Hi, iam trying to use one mysql db beetwen Freeswitches but have some issues on each one fs: For example fs1dev: [ERR] switch_odbc.c:514 ERR: [delete from sip_registrations where expires > 0 and expires <= 1409289251 and hostname='fs1dev'] [ERR] switch_odbc.c:514 ERR: [delete from registrations where expires > 0 and expires <= 1409288616 and hostname='fs1dev'] fs3dev: [ERR] switch_odbc.c:514 ERR: [delete from sip_registrations where expires > 0 and expires <= 1409284836 and hostname='fs3 dev'] Opensips on front as sip load balancer only (forwarding sip registration to fs machines) on each node there is FreeSWITCH Version 1.2.12 Linux fs3dev 3.2.0-4-amd64 #1 SMP Debian 3.2.51-1 x86_64 GNU/Linux cat /etc/odbcinst.ini [MySQL] Description = MySQL driver Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so UsageCount = 1 FileUsage = 1 Threading = 0 issue exist on Mysql 5.6 or Percona Galera 5.6.15-63.0 using same mysql version (InnoDB) we tried to setup indexing, but this not help : ALTER TABLE registrations ADD KEY r_host_expires (hostname,expires); ALTER TABLE sip_registrations ADD KEY host_expires (hostname,expires); there is no load at all on FS machines (up to 5 sip users registering). Freeswitch configuration: add to /usr/local/freeswitch/conf/autoload_configs/spidermonkey.conf.xml <load module="mod_spidermonkey_odbc"/> add to /usr/local/freeswitch/conf/autoload_configs/voicemail.conf.xml |<param name="odbc-dsn" value="odbc://freeswitch:root:password"/>| add to /usr/local/freeswitch/conf/autoload_configs/switch.conf.xml <param name="core-db-dsn" value="freeswitch:fs:password" /> <param name="core-recovery-db-dsn" value="odbc://freeswitch:fs:password"/> <param name="odbc-dsn" value="odbc://freeswitch:fs:password"/> <param name="track-calls" value="true"/> <!--for recovery --> <param name="switchname" value="fs1dev"/> or <param name="switchname" value="$${hostname}"/> Sofia.conf.xml Added odbc-dsn param setting under global_settings and under <settings></settings> in each sip profile: sip_profiles/external.xml sip_profiles/internal.xml sip_profiles/internal-ipv6.xml <param name="odbc-dsn" value="freeswitch:fs:password"/> ----------- Main question is if FS 1.2.12 is designed for such configuration ? Maybe someone resolve that issue ? Maybe it is fixed in some newest version of Freeswitch ? Mysql tuning ? Maybe someone have enviroment that works without Deadlock issue ? which mysql and fs version ? thanks for any help Marcin