Postgres printed this

ERROR: deadlock detected

What it meansTwo or more transactions each held a lock the other needed, so Postgres aborted one of them to break the cycle.

The first thing to checkFind the conflicting queries in the server log, then make transactions lock rows in a consistent order and keep them short; retry on this error.