Correction: It happens also on my test system (Fedora 12, Kernel 2.6.32.8, Pentium-III, 1GHz). Thanks, __Yehavi: 2010/2/19 Yehavi Bourvine <yehavi.bourvine@gmail.com>
Unfortunately it did not help. I still get these error messages.
Just for the record, I have two systems:
- Production one which is running Fedora-10 and exibits this problem. - Test system which is running Fedora-12 and does not exibit this phenomenon; however, there is almost zero traffic on this system.
I plan in upgrading the production system to Fedora-12, but it is not that trivial...
Thanks, __Yehavi:
2010/2/16 Anthony Minessale <anthony.minessale@gmail.com>
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@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@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@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@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@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@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@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@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@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@hotmail.com<MSN%3Aanthony_minessale@hotmail.com> >> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> >> IRC: irc.freenode.net #freeswitch >> >> FreeSWITCH Developer Conference >> sip:888@conference.freeswitch.org<sip%3A888@conference.freeswitch.org> >> iax:guest@conference.freeswitch.org/888 >> googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> >> pstn:+19193869900 >> >> _______________________________________________ >> FreeSWITCH-users mailing list >> FreeSWITCH-users@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@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@hotmail.com<MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org<sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@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@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@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@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@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@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org