Re: [OpenSIPS-Users] presence prepared query errors

2009-12-09 Thread Juha Heinanen
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 m

Re: [OpenSIPS-Users] presence prepared query errors

2009-12-08 Thread Bogdan-Andrei Iancu
Hi Juha, This does mean you encountered a deadlock. By the sounds of it, you're likely to be using InnoDB. 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

[OpenSIPS-Users] presence prepared query errors

2009-12-07 Thread Juha Heinanen
i tried opensips 1.6 presence and once in a while i get to syslog these: Dec 7 11:48:14 lohi /usr/sbin/pres-serv[24449]: ERROR:db_mysql:db_mysql_do_prepared_query: driver error: Deadlock found when trying to get lock; try restarting transaction Dec 7 11:48:14 lohi /usr/sbin/pres-serv[24449]: