Still Deadlocks when using MariaDB

[adamseeliger]

Issue 2063 is closed, but we still see Deadlocks using MariaDB.

FreeSWITCH Version 1.10.11
bitnami/mariadb-galera:11.2.2

mod_mariadb.c:274 Could not commit transaction: Deadlock found when trying to get lock; try restarting transaction

There are no other erros / exceptions in the freeswitch / mariadb logs.

We use mod_xml_curl for registrations and mod_sofia for client connections.

[wangcc57]

"update sip_registrations set ping_expires" of internal and external will trigger this deadlock, sometime the X lock of mysql will lock,so you can add a mutex in Sofia, before you update this table, lock the mutex, and after unlock.

sofia_reg.c method sofia_reg_check_ping_expire