Valter Nogueira <vgnogue...@gmail.com> writes:
> I am receiveing dead locks like this:
> Jul 22, 2014 11:00:29 PM br.com.fastway.fastdialer.FastDialerDB query
> SEVERE: SELECT * FROM ONGOING WHERE STATUS='FILA' ORDER BY TRUNK_ID,
> PRIORIDADE_TRONCO, ID;
> org.postgresql.util.PSQLException: ERROR: deadlock detected
> Detail: Process 508 waits for AccessShareLock on relation 2662 of
> database 16384; blocked by process 8504.
> Process 8504 waits for AccessExclusiveLock on relation 2663 of database
> 16384; blocked by process 508.
> What seems odd is that relations 2662 and 2663 are not user tables but
> postgres objects.
Yeah, they're indexes of pg_class. What PG version is that? Are you
perhaps running maintenance operations that try to VACUUM FULL the system
catalogs? (If so, I'd counsel against it.)
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
