Search Postgresql Archives

Dead Locks

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

select oid, relname from pg_class where oid in (2662,2663)

2662;"pg_class_oid_index"
2663;"pg_class_relname_nsp_index"

Futhermore, this system don't use transactions (I mean it is autocommit) and we don't use triggers, rules or even foreign keys contraints.

Thanks for any help.

Valter

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux