[Freeswitch-users] SQL ERR: library routine called out of sequence

Anthony Minessale anthony.minessale at gmail.com
Tue Feb 16 12:30:41 PST 2010 

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100216/2fcd1a2f/attachment-0002.html

More information about the FreeSWITCH-users mailing list