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