4 Jun
2009
4 Jun
'09
6:38 a.m.
El Jueves, 4 de Junio de 2009, Jan Janak escribió:
On 04-06 13:03, Juha Heinanen wrote:
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(a)aliax.net>
Jan Janak writes:
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? 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@test.fi> by <jh(a)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@192.98.101.10:5074;transport=udp' AND
callid='ysunsysgskxufqy@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@test.fi> by <test(a)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@192.98.101.10:5074;transport=tcp','2009-06-04
13:57:45',0.50
,'xtbkpufsizzylnl(a)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