[Freeswitch-users] SQL ERR: library routine called out of sequence
Yehavi Bourvine
yehavi.bourvine at gmail.com
Tue Feb 16 11:30:33 PST 2010
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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100216/d3a65942/attachment-0002.html
More information about the FreeSWITCH-users
mailing list