![]() Switched core_db and all profiles from SQLite MySQL (via ODBC) and start getting the error: "Deadlock found when trying to get lock try restarting transaction".įreeSWITCH (Version 1.10. This opens the opportunity for a deadlock due to MySQL’s gap locking mechanism.two Freeswitch (Version 1.10.9) servers Active and Backup with keepalived to control floating/virtual IPs, that part works fine. ![]() Switched core_db and all profiles from SQLite MySQL (via ODBC) and start getting the error: "Deadlock found when trying to get lock try restarting transaction". 'Deadlock found when trying to get lock try restarting transaction'. 1 Answer Sorted by: 0 The status in your question doesn't contain any deadlock information, so you haven't taken it just after the deadlock. Update sip_registrations set ping_expires = 1682339621 where hostname='fs' and profile_name='external' and ping_expires <= 1682339592 ERROR 1213 (40001): Deadlock found when trying to get lock try restarting transaction At that point, the lock request for the other client can be granted and it deletes the row from the table. 01:33:12.298041 98.90% switch_core_sqldb.c:728 ODBC SQL ERR Deadlock found when trying to get lock try restarting transaction 01:33:12.298041 98.90% switch_odbc.c:529 ERR: ĭeadlock found when trying to get lock try restarting transaction
0 Comments
Leave a Reply. |