[OpenSIPS-Users] presence prepared query errors

Bogdan-Andrei Iancu bogdan at voice-system.ro
Tue Dec 8 22:57:08 CET 2009


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 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.

Regards,
Bogdan

Juha Heinanen wrote:
> 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]: ERROR:presence:delete_db_subs: sql delete failed 
>
> is that "normal" with prepared queries?
>
> -- juha
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro




More information about the Users mailing list