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 > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > -- Bogdan-Andrei Iancu www.voice-system.ro _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
