[sr-dev] different mysql errors

Iñaki Baz Castillo ibc at aliax.net
Thu Jun 4 12:38:28 CEST 2009


El Jueves, 4 de Junio de 2009, Jan Janak escribió:
> On 04-06 13:03, Juha Heinanen wrote:
> > Jan Janak writes:
> >  > Could you try to figure out which query is generating this error?
> >  > There is a debug statement commented out on line 95 of km_dbase.c in
> >  > db_mysql module, please, uncomment it and try again, it should print
> >  > the query that generates this error in syslog.
> >
> > jan,
> >
> > i uncommented the dbg message and changed it to info.  looks like the
> > problem may have something to do with msilo module.  when ua
> > registers, it is checked from db if there are some pending messages for
> > it.
> >
> > -- juha
> >
> > Jun  4 12:57:45 localhost /usr/sbin/sip-router[20251]: INFO: xlog
> > [xlog.c:186]: INFO: REGISTER <sip:jh at test.fi> by <jh at test.fi> from
> > <192.98.101.10> is authorized Jun  4 12:57:45 localhost
> > /usr/sbin/sip-router[20251]: INFO: db_mysql [km_dbase.c:98]:
> > submit_query(): update location set expires='2009-06-04 13:57:45',q=0.50 
> >    
> > ,cseq=441,flags=0,cflags=0,user_agent='Twinkle/1.4.2',received=NULL,path=
> >NULL,socket='',methods=6111,last_modified='2009-06-04 12:57:45' where
> > username='jh' AND
> > contact='sip:jh_test_fi at 192.98.101.10:5074;transport=udp' AND
> > callid='ysunsysgskxufqy at localhost' AND domain='test.fi' Jun  4 12:57:45
> > localhost /usr/sbin/sip-router[20283]: INFO: xlog [xlog.c:186]: INFO:
> > REGISTER <sip:test at test.fi> by <test at test.fi> from <192.98.101.10> is
> > authorized Jun  4 12:57:45 localhost /usr/sbin/sip-router[20283]: INFO:
> > db_mysql [km_dbase.c:98]: submit_query(): insert into location
> > (username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,
> >path,socket,methods,last_modified,domain ) values
> > ('test','sip:test at 192.98.101.10:5074;transport=tcp','2009-06-04
> > 13:57:45',0.50     
> > ,'xtbkpufsizzylnl at localhost',116,0,0,'Twinkle/1.4.2',NULL,NULL,'',6111,'2
> >009-06-04 12:57:45','test.fi') Jun  4 12:57:45 localhost
> > /usr/sbin/sip-router[20251]: INFO: db_mysql [km_dbase.c:98]:
> > submit_query(): select id,src_addr,dst_addr,body,ctype,inc_time from silo
> > where username='jh' AND domain='test.fi' AND snd_time=0 order by id Jun 
> > 4 12:57:45 localhost /usr/sbin/sip-router[20283]: INFO: db_mysql
> > [km_dbase.c:98]: submit_query(): select
> > id,src_addr,dst_addr,body,ctype,inc_time from silo where username='test'
> > AND domain='test.fi' AND snd_time=0 order by id Jun  4 12:57:45 localhost
> > /usr/sbin/sip-router[20283]: ERROR: db_mysql [km_dbase.c:119]: driver
> > error on query: Commands out of sync; you can't run this command now Jun 
> > 4 12:57:45 localhost /usr/sbin/sip-router[20283]: ERROR: <core>
> > [db_query.c:101]: error while submitting query
>
> Juha,
>
> Is this all the output? The problem occurs in process 20283, this error is
> returned by the mysql library when the caller does not free the result
> returned by a previous command correctly. I am especially interested in
> previous databasa queries submitted within process 20283.
>
> I could also happen that one of the modules does not initialize database
> properly in mod_init or child_init, could you send me the list of modules
> you are using?

If you are using xcal_client, remove it!
In OpenSIPS it caused this error due to a bad DB initialization.


-- 
Iñaki Baz Castillo <ibc at aliax.net>



More information about the sr-dev mailing list