[Freeswitch-users] Lock wait timeout exceeded; try restarting transaction

Lloyd Aloysius lloyd.aloysius at gmail.com
Tue Jul 16 06:21:34 MSD 2013


Hi,

I got the following error

2013-07-15 21:47:41.061450 [ERR] switch_odbc.c:514 ERR: [delete from
sip_dialogs where (expires = -1 or (expires > 0 and expires <= 1373939087))
and hostname='mydomain.com']
[STATE: HY000 CODE 1205 ERROR: [unixODBC][MySQL][ODBC 5.1
Driver][mysqld-5.5.32]Lock wait timeout exceeded; try restarting
transaction]

and the odbcinst.ini

[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib/libmyodbc5.so
Setup           = /usr/lib/libodbcmyS.so
Driver64        = /usr/lib64/libmyodbc5.so
Setup64         = /usr/lib64/libodbcmyS.so
FileUsage       = 1
Threading       = 0
UsageCount      = 1

This is a mysql memory leak? How can fix this error?

DB Server running with 24 GB memory and 2 Quad Core Xeon


Thanks
Lloyd
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130715/0d3d347e/attachment.html 


Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list