2024-12-05 14:22:04,844 ERROR o.t.m.e.ExoneraTorDatabaseImporter:478 Caught an SQL exception while importing exit list entry with base64-encoded fingerprint 4cXkhXzY6Rj6A7HhXxB20KI1sHU, exit address 107.189.7.141, and scan time 2024-12-05T13:01:44. Check the exception for details. Exiting. org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "exitlistentry_exitaddress_scanned_fingerprint_id_exitaddres_key" Detail: Key (scanned, fingerprint_id, exitaddress)=(2024-12-05 13:01:44, 576401, 107.189.7.141) already exists. Where: SQL statement "INSERT INTO exitlistentry_exitaddress (fingerprint_id, exitaddress, scanned) VALUES (insert_fingerprint_id, insert_exitaddress::INET, insert_scanned)" PL/pgSQL function insert_exitlistentry_exitaddress(character,text,character,timestamp without time zone) line 11 at SQL statement at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143) at org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:77) at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:132) at org.torproject.metrics.exonerator.ExoneraTorDatabaseImporter.importExitlistentry(ExoneraTorDatabaseImporter.java:476) at org.torproject.metrics.exonerator.ExoneraTorDatabaseImporter.parseExitList(ExoneraTorDatabaseImporter.java:456) at org.torproject.metrics.exonerator.ExoneraTorDatabaseImporter.parseDescriptors(ExoneraTorDatabaseImporter.java:279) at org.torproject.metrics.exonerator.ExoneraTorDatabaseImporter.main(ExoneraTorDatabaseImporter.java:68)
metrics-alerts@lists.torproject.org