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

[Anthony Minessale]

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