<div dir="ltr"><div>After a few more tests I *think* it is related to SLA. Since it cannot be reproduced consistenty I say "think".</div>
<div> </div>
<div>What I have is:</div>
<div>- 80635 which is an SLA extension between two Polycoms.</div>
<div>- 80636 which is a private extension on Polycom</div>
<div>- 80632 which is a Cisco extension.</div>
<div>- 86111 which is connected behind a Cisco SIP<->PSTN gateway. Since this gateway doesn't hav any login information it is not defined as a gateway but accepted via ACL.</div>
<div> </div>
<div>The tests that passed ok:</div>
<div>- From/to 80636/80632 to 80635 (i.e. - all internal).</div>
<div>- From/to 80635 to 80636/80632 (i.e. - all internal)</div>
<div>- From/to 80636/80632 to 86111 and vice versa (i.e. via the gateway, single extensions).</div>
<div> </div>
<div>The one that fails after a few attempts:</div>
<div>- From 86111 to 80635 (i.e. from the gateway to a shared extension).</div>
<div> </div>
<div>I hope that this gives some more clues.</div>
<div> </div>
<div> Thanks, __Yehavi:<br><br></div>
<div class="gmail_quote">2010/2/28 Yehavi Bourvine <span dir="ltr"><<a href="mailto:yehavi.bourvine@gmail.com">yehavi.bourvine@gmail.com</a>></span><br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0.8ex; PADDING-LEFT: 1ex; PADDING-RIGHT: 1ex; BORDER-RIGHT: #ccc 1px solid" class="gmail_quote">
<div dir="rtl">
<div dir="ltr">Hello,</div>
<div dir="ltr"> </div>
<div dir="ltr"> I've installed a machine with CentOS-5.4 and the latest FreeSwitch (16841M). The problem still happens, even if I set sql-in-transactions to false. It happens also on a very light load.</div>
<div dir="ltr"> </div>
<div dir="ltr">I would like to remind that we query the SQLite core DB from a LUA script which is called from the dial plan; might this be the cause of it?</div>
<div dir="ltr"> </div>
<div dir="ltr">I am willing to test whatever you like, and can do it now as this machine is not in production yet.</div>
<div>
<div></div>
<div class="h5">
<div dir="ltr"> </div>
<div dir="ltr"> Thanks! __Yehavi:<br><br></div>
<div dir="ltr" class="gmail_quote">
<div>2010/2/16 Anthony Minessale <span dir="ltr"><<a href="mailto:anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>></span></div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>Strange, even on abusive testing we have not seen this problem.<br><br>please update to latest trunk.<br>There was only one change I can think of that may cause your issue and I added a patch for it.<br>If it persists try setting the sql-in-transactions profile param to false.
<div>
<div></div>
<div><br><br><br><br><br>
<div class="gmail_quote">On Tue, Feb 16, 2010 at 1:30 PM, Yehavi Bourvine <span dir="ltr"><<a href="mailto:yehavi.bourvine@gmail.com" target="_blank">yehavi.bourvine@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>
<div>Most of the queries are ok, only some fail, thus it doesn't look like permission problem. Furthermore, under 1.0.5pre10 it works for months.</div>
<div> </div>
<div>Might it be thread unsafe function calls? I've found the following while searching the WEB:</div>
<div> </div>
<div><i>According to the MSDN docs, System.Timers.Timer operates in a thread pool. If that's the case, your code is breaking the "connections cannot be shared across threads" rule for SQLit</i></div>
<div> </div>
<div>Although it quotes MSDN, it might be related to Linux as well.</div>
<div>
<div></div>
<div>
<div> </div>
<div> Thanks, __Yehavi:<br><br></div>
<div class="gmail_quote">
<div>2010/2/16 Anthony Minessale <span dir="ltr"><<a href="mailto:anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>></span></div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>That sounds about right.<br><br>That error usually has something to do with using db calls on a closed file or something along those lines.<br>Maybe you have a permission problem on the directory where the db files are?
<div>
<div></div>
<div><br><br><br>
<div class="gmail_quote">On Tue, Feb 16, 2010 at 12:59 PM, Yehavi Bourvine <span dir="ltr"><<a href="mailto:yehavi.bourvine@gmail.com" target="_blank">yehavi.bourvine@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>
<div>The OS is Fedora-10 (soon to be upgraded to 12).</div>
<div> </div>
<div>What I do when I want to test a new version:</div>
<div>
<ul>
<li>Download the latest one into a fresh directory</li>
<li>bootstrap.sh, configure and make</li>
<li>stop Freeswitch, delete everything in lib, mod, bin ,db</li>
<li>
<div>make install and run it.</div></li></ul></div>
<div> </div>
<div>Is there additional place to clean?</div>
<div>
<div></div>
<div>
<div> </div>
<div> Thanks! __Yehavi: </div>
<div> </div>
<div class="gmail_quote">
<div>2010/2/16 Anthony Minessale <span dir="ltr"><<a href="mailto:anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>></span></div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>you may want to do a clean wipe of all files related to FS then.<br>you clearly have some problem with legacy something or other because we don't see that on dozens of dev boxes.<br><br>What os is it?
<div>
<div></div>
<div><br><br><br>
<div class="gmail_quote">On Tue, Feb 16, 2010 at 9:27 AM, Yehavi Bourvine <span dir="ltr"><<a href="mailto:yehavi.bourvine@gmail.com" target="_blank">yehavi.bourvine@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>
<div>Tried this, but it didn't help. I delete these DB files before any upgrade just to be sure.</div>
<div> </div>
<div> Thanks! __Yehavi:<br><br></div>
<div class="gmail_quote">
<div>2010/2/16 Anthony Minessale <span dir="ltr"><<a href="mailto:anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>></span></div>
<div>
<div></div>
<div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>try removing all the .db files from /usr/local/freeswitch/db<br><br><br>
<div class="gmail_quote">
<div>
<div></div>
<div>On Tue, Feb 16, 2010 at 8:56 AM, Yehavi Bourvine <span dir="ltr"><<a href="mailto:yehavi.bourvine@gmail.com" target="_blank">yehavi.bourvine@gmail.com</a>></span> wrote:<br></div></div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>
<div></div>
<div>
<div>
<div style="TEXT-ALIGN: left">Hello,</div>
<div style="TEXT-ALIGN: left"> </div>
<div style="TEXT-ALIGN: left"> After upgrading from 1.0.5pre10 to 1.0.5-20100216-0400 we started getting the above errors (I append bellow two samples). It seems Freeswitch fails to read a database using Sqlite.</div>
<div style="TEXT-ALIGN: left">Anyone have seen this?</div>
<div style="TEXT-ALIGN: left"> </div>
<div style="TEXT-ALIGN: left">Other details: Fedora 10, SQlite 3.5.9.</div>
<div style="TEXT-ALIGN: left">We also do SQLite quesries during call setup via LUA from CoreDB. Is it an SQLite problem?</div>
<div style="TEXT-ALIGN: left"> </div>
<div style="TEXT-ALIGN: left"> Thanks! __Yehavi:</div>
<div style="TEXT-ALIGN: left"> </div>
<div style="TEXT-ALIGN: left">The samples:<br></div>
<div style="TEXT-ALIGN: left">2010-02-16 16:22:13.762679 [ERR] switch_core_sqldb.c:404 SQL ERR [library routin<br>e called out of sequence]<br>delete from sip_dialogs where call_id='<a href="mailto:8656841832142-120172129116107@10.64.1.2" target="_blank">8656841832142-120172129116107@10.64.1.2</a>'<br>
<br></div>
<div class="gmail_quote">2010-02-16 16:42:00.802442 [ERR] switch_core_sqldb.c:722 SQL ERR: [select call_i<br>d,sip_user,sip_host,contact,status,rpid,expires,user_agent,server_user,server_ho<br>st,profile_name,hostname,network_ip,network_port,sip_username,sip_realm,mwi_user<br>
,mwi_host from sip_registrations where profile_name='phones' and contact like '%<br>80635%'] library routine called out of sequence<br></div></div><br></div></div>_______________________________________________<br>
FreeSWITCH-users mailing list<br><a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br><a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>
Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br><br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com" target="_blank">MSN:anthony_minessale@hotmail.com</a><br>
GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">PAYPAL:anthony.minessale@gmail.com</a><br>IRC: <a href="http://irc.freenode.net/" target="_blank">irc.freenode.net</a> #freeswitch<br><br>
FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org" target="_blank">sip:888@conference.freeswitch.org</a><br><a href="http://iax:guest@conference.freeswitch.org/888" target="_blank">iax:guest@conference.freeswitch.org/888</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">googletalk:conf+888@conference.freeswitch.org</a><br>pstn:+19193869900<br></div><br>_______________________________________________<br>FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br><a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div></div></div>
<div><br></div></div><br>_______________________________________________<br>FreeSWITCH-users mailing list<br><a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a><br><br></blockquote></div><br><br clear="all"><br>-- <br>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>
ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br><br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com" target="_blank">MSN:anthony_minessale@hotmail.com</a><br>
GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">PAYPAL:anthony.minessale@gmail.com</a><br>IRC: <a href="http://irc.freenode.net/" target="_blank">irc.freenode.net</a> #freeswitch<br><br>
FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org" target="_blank">sip:888@conference.freeswitch.org</a><br><a href="http://iax:guest@conference.freeswitch.org/888" target="_blank">iax:guest@conference.freeswitch.org/888</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">googletalk:conf+888@conference.freeswitch.org</a><br>pstn:+19193869900<br></div></div></div><br>_______________________________________________<br>
FreeSWITCH-users mailing list<br><a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br><a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div>
<div><br></div></div></div></div><br>_______________________________________________<br>FreeSWITCH-users mailing list<br><a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a><br><br></blockquote></div><br><br clear="all"><br>-- <br>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>
ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br><br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com" target="_blank">MSN:anthony_minessale@hotmail.com</a><br>
GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">PAYPAL:anthony.minessale@gmail.com</a><br>IRC: <a href="http://irc.freenode.net/" target="_blank">irc.freenode.net</a> #freeswitch<br><br>
FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org" target="_blank">sip:888@conference.freeswitch.org</a><br><a href="http://iax:guest@conference.freeswitch.org/888" target="_blank">iax:guest@conference.freeswitch.org/888</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">googletalk:conf+888@conference.freeswitch.org</a><br>pstn:+19193869900<br></div></div></div><br>_______________________________________________<br>
FreeSWITCH-users mailing list<br><a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br><a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div>
<div><br></div></div></div></div><br>_______________________________________________<br>FreeSWITCH-users mailing list<br><a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a><br><br></blockquote></div><br><br clear="all"><br>-- <br>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>
ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br><br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com" target="_blank">MSN:anthony_minessale@hotmail.com</a><br>
GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">PAYPAL:anthony.minessale@gmail.com</a><br>IRC: <a href="http://irc.freenode.net/" target="_blank">irc.freenode.net</a> #freeswitch<br><br>
FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org" target="_blank">sip:888@conference.freeswitch.org</a><br><a href="http://iax:guest@conference.freeswitch.org/888" target="_blank">iax:guest@conference.freeswitch.org/888</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">googletalk:conf+888@conference.freeswitch.org</a><br>pstn:+19193869900<br></div></div></div><br>_______________________________________________<br>
FreeSWITCH-users mailing list<br><a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br><a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div>
<div dir="ltr"><br></div></div></div></div></blockquote></div></div>