[Freeswitch-users] Strange errors from sqlite DB

Peter Olsson peter.olsson at visionutveckling.se
Mon May 3 12:46:52 PDT 2010


Nope, no scripts, or no other external applications accessing the db's.

I don't have the exact git revision right now, but it was pulled/rebuilt on april 14. I've upgraded to latest git now, but I saved the old binaries and db-files, I will play with it tomorrow and see if it's possible to recreated the error - but as I said, I've never seen this before.

I should also add - the time it hapened FS had just been restarted, one call was running, and two Polycom's trying to register (I guess the sip_authentication table is related to register), so really no load at all.

/Peter
________________________________________
Från: freeswitch-users-bounces at lists.freeswitch.org [freeswitch-users-bounces at lists.freeswitch.org] för Brian West [brian at freeswitch.org]
Skickat: den 3 maj 2010 21:33
Till: freeswitch-users at lists.freeswitch.org
Ämne: Re: [Freeswitch-users] Strange errors from sqlite DB

Happen to be touching core.db from outside of FreeSWITCH?  Also what SVN/GIT are you on?

/b

On May 3, 2010, at 2:27 PM, Peter Olsson wrote:

> ----
>
> 2010-05-03 20:29:21.032501 [ERR] switch_core_sqldb.c:404 SQL ERR [library routine called out of sequence]
> insert into sip_authentication (nonce,expires,profile_name,hostname, last_nc) values('6e5df620-d388-4f93-b0b0-8da4cf880ef1', 1272911421, '(NULL)', 'internal', 0)
> 2010-05-03 20:29:21.048126 [ERR] switch_core_sqldb.c:722 SQL ERR: [select nonce,last_nc from sip_authentication where nonce='6e5df620-d388-4f93-b0b0-8da4cf880ef1' and last_nc < 1] library routine called out of sequence
> 2010-05-03 20:29:21.048126 [ERR] switch_core_sqldb.c:404 SQL ERR [library routine called out of sequence]
> update sip_authentication set expires='1272911421',last_nc=1 where nonce='6e5df620-d388-4f93-b0b0-8da4cf880ef1'
> 2010-05-03 20:29:21.048126 [ERR] switch_core_sqldb.c:404 SQL ERR [library routine called out of sequence]
>
> Regards,
>
> Peter


_______________________________________________
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

!DSPAM:4bdf268d32931789114366!




More information about the FreeSWITCH-users mailing list