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

Yehavi Bourvine yehavi.bourvine at gmail.com
Tue Feb 16 10:59:26 PST 2010


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


More information about the FreeSWITCH-users mailing list