2022-10-07 16:22:02,417 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-10-07 23:59:12,570 WARN o.t.d.i.DescriptorReaderImpl:251 Unable to read descriptor file exonerator-import/recent/relay-descriptors/consensuses/2022-10-04-18-00-00-consensus. java.io.FileNotFoundException: exonerator-import/recent/relay-descriptors/consensuses/2022-10-04-18-00-00-consensus (No such file or directory) at java.base/java.io.FileInputStream.open0(Native Method) at java.base/java.io.FileInputStream.open(FileInputStream.java:219) at java.base/java.io.FileInputStream.<init>(FileInputStream.java:157) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.readDescriptorFile(DescriptorReaderImpl.java:329) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.readDescriptorFiles(DescriptorReaderImpl.java:247) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.run(DescriptorReaderImpl.java:158) at java.base/java.lang.Thread.run(Thread.java:829) 2022-10-07 23:59:15,578 WARN o.t.d.i.DescriptorReaderImpl:251 Unable to read descriptor file exonerator-import/recent/relay-descriptors/consensuses/2022-10-04-17-00-00-consensus. java.io.FileNotFoundException: exonerator-import/recent/relay-descriptors/consensuses/2022-10-04-17-00-00-consensus (No such file or directory) at java.base/java.io.FileInputStream.open0(Native Method) at java.base/java.io.FileInputStream.open(FileInputStream.java:219) at java.base/java.io.FileInputStream.<init>(FileInputStream.java:157) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.readDescriptorFile(DescriptorReaderImpl.java:329) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.readDescriptorFiles(DescriptorReaderImpl.java:247) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.run(DescriptorReaderImpl.java:158) at java.base/java.lang.Thread.run(Thread.java:829) 2022-10-07 23:59:18,472 WARN o.t.d.i.DescriptorReaderImpl:251 Unable to read descriptor file exonerator-import/recent/relay-descriptors/consensuses/2022-10-04-23-00-00-consensus. java.io.FileNotFoundException: exonerator-import/recent/relay-descriptors/consensuses/2022-10-04-23-00-00-consensus (No such file or directory) at java.base/java.io.FileInputStream.open0(Native Method) at java.base/java.io.FileInputStream.open(FileInputStream.java:219) at java.base/java.io.FileInputStream.<init>(FileInputStream.java:157) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.readDescriptorFile(DescriptorReaderImpl.java:329) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.readDescriptorFiles(DescriptorReaderImpl.java:247) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.run(DescriptorReaderImpl.java:158) at java.base/java.lang.Thread.run(Thread.java:829) 2022-10-07 23:59:18,472 WARN o.t.d.i.DescriptorReaderImpl:251 Unable to read descriptor file exonerator-import/recent/relay-descriptors/consensuses/2022-10-04-19-00-00-consensus. java.io.FileNotFoundException: exonerator-import/recent/relay-descriptors/consensuses/2022-10-04-19-00-00-consensus (No such file or directory) at java.base/java.io.FileInputStream.open0(Native Method) at java.base/java.io.FileInputStream.open(FileInputStream.java:219) at java.base/java.io.FileInputStream.<init>(FileInputStream.java:157) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.readDescriptorFile(DescriptorReaderImpl.java:329) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.readDescriptorFiles(DescriptorReaderImpl.java:247) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.run(DescriptorReaderImpl.java:158) at java.base/java.lang.Thread.run(Thread.java:829) 2022-10-07 23:59:19,422 WARN o.t.d.i.DescriptorReaderImpl:251 Unable to read descriptor file exonerator-import/recent/relay-descriptors/consensuses/2022-10-04-22-00-00-consensus. java.io.FileNotFoundException: exonerator-import/recent/relay-descriptors/consensuses/2022-10-04-22-00-00-consensus (No such file or directory) at java.base/java.io.FileInputStream.open0(Native Method) at java.base/java.io.FileInputStream.open(FileInputStream.java:219) at java.base/java.io.FileInputStream.<init>(FileInputStream.java:157) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.readDescriptorFile(DescriptorReaderImpl.java:329) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.readDescriptorFiles(DescriptorReaderImpl.java:247) at org.torproject.descriptor.impl.DescriptorReaderImpl$DescriptorReaderRunnable.run(DescriptorReaderImpl.java:158) at java.base/java.lang.Thread.run(Thread.java:829) 2022-10-08 04:14:05,502 ERROR o.t.m.e.ExoneraTorDatabaseImporter:413 Caught an SQL exception while importing status entry with base64-encoded fingerprint 8Io3RMplaO0oVFwrfBvn2Lony94 and valid-after time 2022-10-07T04: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-10-07 04:00:00, 522330, 95.217.248.169) 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)
metrics-alerts@lists.torproject.org