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

Anthony Minessale anthony.minessale at gmail.com
Tue Feb 16 11:10:12 PST 2010


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


More information about the FreeSWITCH-users mailing list