[metrics-alerts] Cron <metrics at meronense> cd /srv/metrics.torproject.org/metrics/bin/website && ./run-web.sh

[Cron Daemon]

2022-10-07 10:54:33,865 WARN o.t.m.s.main.Main:76 Caught an exception when invoking the main method of the org.torproject.metrics.stats.clients.Main module. Moving on to the next module, if available.
java.lang.reflect.InvocationTargetException: null
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.torproject.metrics.stats.main.Main.main(Main.java:72)
Caused by: org.postgresql.util.PSQLException: ERROR: deadlock detected
  Detail: Process 574157 waits for ShareLock on transaction 12907344; blocked by process 434631.
Process 434631 waits for AccessExclusiveLock on relation 323550 of database 17025; blocked by process 574157.
  Hint: See server log for query details.
  Where: while deleting tuple (17738,75) in relation "aggregated"
SQL statement "DELETE FROM aggregated WHERE date IN (SELECT DISTINCT date FROM update)"
PL/pgSQL function aggregate() line 24 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.PgStatement.executeWithFlags(PgStatement.java:307)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
	at org.torproject.metrics.stats.clients.Database.processImported(Database.java:81)
	at org.torproject.metrics.stats.clients.Main.main(Main.java:50)
	... 5 common frames omitted