it turned out the hang up problems (now fixed) were separate from mysql "driver error on query: Commands out of sync" problems.
here is one example on that error from process 609 right after sr restart:
Jun 6 18:22:41 localhost /usr/sbin/sip-router[609]: INFO: db_mysql [km_dbase.c:97]: submit_query(): select username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,domain from location Jun 6 18:22:44 localhost /usr/sbin/sip-router[609]: INFO: db_mysql [km_dbase.c:97]: 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=udp','2009-06-06 19:22:44',0.50 ,'ikquzsrapccwsci@localhost',219,0,0,'Twinkle/1.4.2',NULL,NULL,'',6111,'2009-06-06 18:22:44','test.fi') Jun 6 18:22:44 localhost /usr/sbin/sip-router[609]: INFO: db_mysql [km_dbase.c:97]: 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 6 18:22:44 localhost /usr/sbin/sip-router[609]: ERROR: db_mysql [km_dbase.c:118]: driver error on query: Commands out of sync; you can't run this command now Jun 6 18:22:44 localhost /usr/sbin/sip-router[609]: ERROR: <core> [db_query.c:101]: error while submitting query Jun 6 18:22:44 localhost /usr/sbin/sip-router[609]: ERROR: msilo [msilo.c:1007]: failed to query database
as you see, there is first select on location, then insert on location (save) and finally select on msilo (m_dump) that causes the error.
any idea how it is possible that insert (which does not return result) could cause following select to return this kind of error?
i have not experienced these kind of errors in k with the same config and modules. could it be that there is a bug in srdb1 lib?
-- juha