Dead Locks

From: Valter Nogueira <vgnogueira(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Dead Locks
Date: 2014-07-23 19:38:19
Message-ID: CALbXVc-xMHKQ_4FG8DiUhCpqtWGLEbguAcRQ6VxYDhHMeXcJOQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-07-23 19:45:08 Re: Dead Locks
Previous Message klo uo 2014-07-23 19:33:21 Re: question about memory usage