[Freeswitch-users] SQL ERR: library routine called out of sequence
Yehavi Bourvine
yehavi.bourvine at gmail.com
Sun Feb 28 05:14:44 PST 2010
Hello,
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.
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?
I am willing to test whatever you like, and can do it now as this machine is
not in production yet.
Thanks! __Yehavi:
2010/2/16 Anthony Minessale <anthony.minessale at gmail.com>
> Strange, even on abusive testing we have not seen this problem.
>
> please update to latest trunk.
> There was only one change I can think of that may cause your issue and I
> added a patch for it.
> If it persists try setting the sql-in-transactions profile param to false.
>
>
>
>
>
> On Tue, Feb 16, 2010 at 1:30 PM, Yehavi Bourvine <
> yehavi.bourvine at gmail.com> wrote:
>
>> 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.
>>
>> Might it be thread unsafe function calls? I've found the following while
>> searching the WEB:
>>
>> *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*
>>
>> Although it quotes MSDN, it might be related to Linux as well.
>>
>> Thanks, __Yehavi:
>>
>> 2010/2/16 Anthony Minessale <anthony.minessale at gmail.com>
>>
>>> That sounds about right.
>>>
>>> That error usually has something to do with using db calls on a closed
>>> file or something along those lines.
>>> Maybe you have a permission problem on the directory where the db files
>>> are?
>>>
>>>
>>>
>>> On Tue, Feb 16, 2010 at 12:59 PM, Yehavi Bourvine <
>>> yehavi.bourvine at gmail.com> wrote:
>>>
>>>> The OS is Fedora-10 (soon to be upgraded to 12).
>>>>
>>>> What I do when I want to test a new version:
>>>>
>>>> - Download the latest one into a fresh directory
>>>> - bootstrap.sh, configure and make
>>>> - stop Freeswitch, delete everything in lib, mod, bin ,db
>>>> - make install and run it.
>>>>
>>>>
>>>> Is there additional place to clean?
>>>>
>>>> Thanks! __Yehavi:
>>>>
>>>> 2010/2/16 Anthony Minessale <anthony.minessale at gmail.com>
>>>>
>>>>> you may want to do a clean wipe of all files related to FS then.
>>>>> you clearly have some problem with legacy something or other because we
>>>>> don't see that on dozens of dev boxes.
>>>>>
>>>>> What os is it?
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Feb 16, 2010 at 9:27 AM, Yehavi Bourvine <
>>>>> yehavi.bourvine at gmail.com> wrote:
>>>>>
>>>>>> Tried this, but it didn't help. I delete these DB files before any
>>>>>> upgrade just to be sure.
>>>>>>
>>>>>> Thanks! __Yehavi:
>>>>>>
>>>>>> 2010/2/16 Anthony Minessale <anthony.minessale at gmail.com>
>>>>>>
>>>>>>> try removing all the .db files from /usr/local/freeswitch/db
>>>>>>>
>>>>>>>
>>>>>>> On Tue, Feb 16, 2010 at 8:56 AM, Yehavi Bourvine <
>>>>>>> yehavi.bourvine at gmail.com> wrote:
>>>>>>>
>>>>>>>> Hello,
>>>>>>>>
>>>>>>>> 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.
>>>>>>>> Anyone have seen this?
>>>>>>>>
>>>>>>>> Other details: Fedora 10, SQlite 3.5.9.
>>>>>>>> We also do SQLite quesries during call setup via LUA from CoreDB. Is
>>>>>>>> it an SQLite problem?
>>>>>>>>
>>>>>>>> Thanks! __Yehavi:
>>>>>>>>
>>>>>>>> The samples:
>>>>>>>> 2010-02-16 16:22:13.762679 [ERR] switch_core_sqldb.c:404 SQL ERR
>>>>>>>> [library routin
>>>>>>>> e called out of sequence]
>>>>>>>> delete from sip_dialogs where call_id='
>>>>>>>> 8656841832142-120172129116107 at 10.64.1.2'
>>>>>>>>
>>>>>>>> 2010-02-16 16:42:00.802442 [ERR] switch_core_sqldb.c:722 SQL ERR:
>>>>>>>> [select call_i
>>>>>>>>
>>>>>>>> d,sip_user,sip_host,contact,status,rpid,expires,user_agent,server_user,server_ho
>>>>>>>>
>>>>>>>> st,profile_name,hostname,network_ip,network_port,sip_username,sip_realm,mwi_user
>>>>>>>> ,mwi_host from sip_registrations where profile_name='phones' and
>>>>>>>> contact like '%
>>>>>>>> 80635%'] library routine called out of sequence
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> FreeSWITCH-users mailing list
>>>>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>>>>> UNSUBSCRIBE:
>>>>>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>>>>> http://www.freeswitch.org
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Anthony Minessale II
>>>>>>>
>>>>>>> FreeSWITCH http://www.freeswitch.org/
>>>>>>> ClueCon http://www.cluecon.com/
>>>>>>> Twitter: http://twitter.com/FreeSWITCH_wire
>>>>>>>
>>>>>>> AIM: anthm
>>>>>>> MSN:anthony_minessale at hotmail.com<MSN%3Aanthony_minessale at hotmail.com>
>>>>>>> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
>>>>>>> IRC: irc.freenode.net #freeswitch
>>>>>>>
>>>>>>> FreeSWITCH Developer Conference
>>>>>>> sip:888 at conference.freeswitch.org<sip%3A888 at conference.freeswitch.org>
>>>>>>> iax:guest at conference.freeswitch.org/888
>>>>>>> googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
>>>>>>> pstn:+19193869900
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> FreeSWITCH-users mailing list
>>>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>>>> UNSUBSCRIBE:
>>>>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>>>> http://www.freeswitch.org
>>>>>>>
>>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> FreeSWITCH-users mailing list
>>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>>> UNSUBSCRIBE:
>>>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>>> http://www.freeswitch.org
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Anthony Minessale II
>>>>>
>>>>> FreeSWITCH http://www.freeswitch.org/
>>>>> ClueCon http://www.cluecon.com/
>>>>> Twitter: http://twitter.com/FreeSWITCH_wire
>>>>>
>>>>> AIM: anthm
>>>>> MSN:anthony_minessale at hotmail.com<MSN%3Aanthony_minessale at hotmail.com>
>>>>> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
>>>>> IRC: irc.freenode.net #freeswitch
>>>>>
>>>>> FreeSWITCH Developer Conference
>>>>> sip:888 at conference.freeswitch.org<sip%3A888 at conference.freeswitch.org>
>>>>> iax:guest at conference.freeswitch.org/888
>>>>> googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
>>>>> pstn:+19193869900
>>>>>
>>>>> _______________________________________________
>>>>> FreeSWITCH-users mailing list
>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>> UNSUBSCRIBE:
>>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>> http://www.freeswitch.org
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> FreeSWITCH-users mailing list
>>>> FreeSWITCH-users at lists.freeswitch.org
>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> UNSUBSCRIBE:
>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>> http://www.freeswitch.org
>>>>
>>>>
>>>
>>>
>>> --
>>> Anthony Minessale II
>>>
>>> FreeSWITCH http://www.freeswitch.org/
>>> ClueCon http://www.cluecon.com/
>>> Twitter: http://twitter.com/FreeSWITCH_wire
>>>
>>> AIM: anthm
>>> MSN:anthony_minessale at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
>>> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
>>> IRC: irc.freenode.net #freeswitch
>>>
>>> FreeSWITCH Developer Conference
>>> sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
>>> iax:guest at conference.freeswitch.org/888
>>> googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
>>> pstn:+19193869900
>>>
>>> _______________________________________________
>>> FreeSWITCH-users mailing list
>>> FreeSWITCH-users at lists.freeswitch.org
>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>> http://www.freeswitch.org
>>>
>>>
>>
>> _______________________________________________
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>>
>
>
> --
> Anthony Minessale II
>
> FreeSWITCH http://www.freeswitch.org/
> ClueCon http://www.cluecon.com/
> Twitter: http://twitter.com/FreeSWITCH_wire
>
> AIM: anthm
> MSN:anthony_minessale at hotmail.com <MSN%3Aanthony_minessale at hotmail.com>
> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>
> IRC: irc.freenode.net #freeswitch
>
> FreeSWITCH Developer Conference
> sip:888 at conference.freeswitch.org <sip%3A888 at conference.freeswitch.org>
> iax:guest at conference.freeswitch.org/888
> googletalk:conf+888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>
> pstn:+19193869900
>
> _______________________________________________
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100228/956a418b/attachment-0002.html
More information about the FreeSWITCH-users
mailing list