[OpenSIPS-Users] presence prepared query errors

Juha Heinanen jh at tutpro.com
Wed Dec 9 09:04:35 CET 2009


Bogdan-Andrei Iancu writes:

 > This does mean you encountered a deadlock. By the sounds of it, you're 
 > likely to be using InnoDB.

bogdan,

yes, because myisam is not good for drbd.  that reminds me, why were all
vachars changed to chars?

 > So, you should issue "SHOW INNODB STATUS" from the mysql command line.
 > 
 > In that output, look for the "LATEST DETECTED DEADLOCK". There you will 
 > see 2 transactions, (1) and (2). You can see the exact queries that 
 > caused it and the table locks that each hold/trying to acquire.
 > 
 > Just post it here to see what are the queries blocking one each
 > other.

i'll post that privately, because there are real uris in the data.

-- juha



More information about the Users mailing list