[metrics-alerts] Cron <exonerator at materculae> cd /srv/exonerator.torproject.org/exonerator/ && ~exonerator/bin/run-exonerator

Cron Daemon root at materculae.torproject.org
Mon May 9 19:56:54 UTC 2022


2022-05-09 11:22:02,456 WARN o.t.m.e.ExoneraTorDatabaseImporter:174 Lock file /srv/exonerator.torproject.org/exonerator/exonerator-lock is at least 6 hours old. Overwriting and continuing with the database import.
2022-05-09 19:56:53,704 ERROR o.t.m.e.ExoneraTorDatabaseImporter:413 Caught an SQL exception while importing status entry with base64-encoded fingerprint UhtkC82UC2sJIB5YyC4aWORVcHU and valid-after time 2022-05-08T07:00. Check the exception for details. Exiting.
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "statusentry_oraddress_validafter_fingerprint_id_oraddress_key"
  Detail: Key (validafter, fingerprint_id, oraddress)=(2022-05-08 07:00:00, 540299, 69.197.151.94) already exists.
  Where: SQL statement "INSERT INTO statusentry_oraddress (validafter, fingerprint_id,
            oraddress, nickname_id, exit)
          VALUES (insert_validafter, insert_fingerprint_id,
            insert_oraddress::INET, insert_nickname_id,
            insert_exit)"
PL/pgSQL function insert_statusentry_oraddress(timestamp without time zone,character,text,character,character varying,boolean) line 14 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.importStatusentry(ExoneraTorDatabaseImporter.java:410)
	at org.torproject.metrics.exonerator.ExoneraTorDatabaseImporter.parseConsensus(ExoneraTorDatabaseImporter.java:338)
	at org.torproject.metrics.exonerator.ExoneraTorDatabaseImporter.parseDescriptors(ExoneraTorDatabaseImporter.java:276)
	at org.torproject.metrics.exonerator.ExoneraTorDatabaseImporter.main(ExoneraTorDatabaseImporter.java:68)


More information about the metrics-alerts mailing list