[Freeswitch-users] Strange errors from sqlite DB

[Peter Olsson]

Brian,

This is the log when it first occured. I'm not sure if I'll ever recreate the issue, so do you think I should open a jira anyway? This log is more or less all I have.

2010-05-03 20:25:32.673126 [DEBUG] switch_core_state_machine.c:119 (sofia/internal/50711 at 10.10.1.35) State Change CS_ROUTING -> CS_EXECUTE
2010-05-03 20:25:32.673126 [DEBUG] switch_core_session.c:1021 Send signal sofia/internal/50711 at 10.10.1.35 [BREAK]
2010-05-03 20:25:32.673126 [DEBUG] switch_core_state_machine.c:341 (sofia/internal/50711 at 10.10.1.35) State ROUTING going to sleep
2010-05-03 20:25:32.673126 [DEBUG] switch_core_state_machine.c:314 (sofia/internal/50711 at 10.10.1.35) Running State Change CS_EXECUTE
2010-05-03 20:25:32.673126 [DEBUG] switch_core_state_machine.c:348 (sofia/internal/50711 at 10.10.1.35) State EXECUTE
2010-05-03 20:25:32.673126 [DEBUG] mod_sofia.c:226 sofia/internal/50711 at 10.10.1.35 SOFIA EXECUTE
2010-05-03 20:25:32.673126 [DEBUG] switch_core_state_machine.c:157 sofia/internal/50711 at 10.10.1.35 Standard EXECUTE
EXECUTE sofia/internal/50711 at 10.10.1.35 set(hangup_after_bridge=true)
2010-05-03 20:25:32.673126 [DEBUG] mod_dptools.c:816 sofia/internal/50711 at 10.10.1.35 SET [hangup_after_bridge]=[true]
EXECUTE sofia/internal/50711 at 10.10.1.35 bridge(sofia/gateway/vip2000-trunk/00709275071)
2010-05-03 20:25:32.673126 [NOTICE] switch_channel.c:669 New Channel sofia/internal/00709275071 [41b995f9-df54-4053-a521-ae804c6c1c6b]
2010-05-03 20:25:32.673126 [DEBUG] mod_sofia.c:3386 (sofia/internal/00709275071) State Change CS_NEW -> CS_INIT
2010-05-03 20:25:32.673126 [DEBUG] switch_core_session.c:1021 Send signal sofia/internal/00709275071 [BREAK]
2010-05-03 20:25:32.673126 [DEBUG] switch_core_state_machine.c:314 (sofia/internal/00709275071) Running State Change CS_INIT
2010-05-03 20:25:32.673126 [DEBUG] switch_core_state_machine.c:338 (sofia/internal/00709275071) State INIT
2010-05-03 20:25:32.673126 [DEBUG] mod_sofia.c:83 sofia/internal/00709275071 SOFIA INIT
2010-05-03 20:25:32.673126 [DEBUG] mod_sofia.c:117 (sofia/internal/00709275071) State Change CS_INIT -> CS_ROUTING
2010-05-03 20:25:32.673126 [DEBUG] switch_core_session.c:1021 Send signal sofia/internal/00709275071 [BREAK]
2010-05-03 20:25:32.673126 [DEBUG] switch_core_state_machine.c:338 (sofia/internal/00709275071) State INIT going to sleep
2010-05-03 20:25:32.673126 [DEBUG] switch_core_state_machine.c:314 (sofia/internal/00709275071) Running State Change CS_ROUTING
2010-05-03 20:25:32.673126 [DEBUG] sofia.c:4153 Channel sofia/internal/00709275071 entering state [calling][0]
2010-05-03 20:25:32.673126 [DEBUG] switch_core_state_machine.c:341 (sofia/internal/00709275071) State ROUTING
2010-05-03 20:25:32.673126 [DEBUG] mod_sofia.c:140 sofia/internal/00709275071 SOFIA ROUTING
2010-05-03 20:25:32.673126 [DEBUG] switch_ivr_originate.c:66 (sofia/internal/00709275071) State Change CS_ROUTING -> CS_CONSUME_MEDIA
2010-05-03 20:25:32.673126 [DEBUG] switch_core_session.c:1021 Send signal sofia/internal/00709275071 [BREAK]
2010-05-03 20:25:32.673126 [DEBUG] switch_core_state_machine.c:341 (sofia/internal/00709275071) State ROUTING going to sleep
2010-05-03 20:25:32.673126 [DEBUG] switch_core_state_machine.c:314 (sofia/internal/00709275071) Running State Change CS_CONSUME_MEDIA
2010-05-03 20:25:32.673126 [DEBUG] switch_core_state_machine.c:360 (sofia/internal/00709275071) State CONSUME_MEDIA
2010-05-03 20:25:32.673126 [DEBUG] switch_core_state_machine.c:360 (sofia/internal/00709275071) State CONSUME_MEDIA going to sleep
2010-05-03 20:25:32.688751 [INFO] sofia.c:662 Update Callee ID to "00709275071" <00709275071>
2010-05-03 20:25:32.751251 [ERR] switch_core_sqldb.c:722 SQL ERR: [select sip_subscriptions.proto,sip_subscriptions.sip_user,sip_subscriptions.sip_host,sip_subscriptions.sub_to_user,sip_subscriptions.sub_to_host,sip_subscriptions.event,sip_subscriptions.contact,sip_subscriptions.call_id,sip_subscriptions.full_from,sip_subscriptions.full_via,sip_subscriptions.expires,sip_subscriptions.user_agent,sip_subscriptions.accept,sip_subscriptions.profile_name,'CS_ROUTING','unknown','10.10.1.35',sip_presence.status,sip_presence.rpid from sip_subscriptions left join sip_presence on (sip_subscriptions.sub_to_user=sip_presence.sip_user and sip_subscriptions.sub_to_host=sip_presence.sip_host and sip_subscriptions.profile_name=sip_presence.profile_name) where sip_subscriptions.expires > -1 and (event='presence' or event='dialog') and sub_to_user='50711' and (sub_to_host='10.10.1.35' or presence_hosts like '%10.10.1.35%') and (sip_subscriptions.profile_name = 'internal' or sip_subscriptions.presence_hosts != sip_subscriptions.sub_to_host)] library routine called out of sequence
2010-05-03 20:25:32.782501 [DEBUG] sofia.c:4153 Channel sofia/internal/00709275071 entering state [proceeding][180]
2010-05-03 20:25:32.782501 [NOTICE] sofia.c:4223 Ring-Ready sofia/internal/00709275071!
2010-05-03 20:25:32.782501 [NOTICE] mod_sofia.c:1837 Ring-Ready sofia/internal/50711 at 10.10.1.35!
2010-05-03 20:25:32.782501 [ERR] switch_core_sqldb.c:525 Statement Error [select 'appearance-index=1' from sip_subscriptions where expires > -1 and hostname='teller' and event='call-info' and sub_to_user='00709275071' and sub_to_host='192.168.1.55']!
2010-05-03 20:25:32.782501 [DEBUG] switch_core_session.c:641 Send signal sofia/internal/50711 at 10.10.1.35 [BREAK]
2010-05-03 20:25:32.782501 [NOTICE] switch_ivr_originate.c:437 Ring Ready sofia/internal/50711 at 10.10.1.35!
2010-05-03 20:25:32.782501 [DEBUG] sofia.c:4153 Channel sofia/internal/00709275071 entering state [proceeding][183]
2010-05-03 20:25:32.782501 [DEBUG] sofia.c:4164 Remote SDP:

________________________________________
Från: freeswitch-users-bounces at lists.freeswitch.org [freeswitch-users-bounces at lists.freeswitch.org] f&#246;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!