Valter Nogueira <vgnogueira@xxxxxxxxx> 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
