[sr-dev] driver error on query: Commands out of sync

[Juha Heinanen]

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 at 192.98.101.10:5074;transport=udp','2009-06-06 19:22:44',0.50      ,'ikquzsrapccwsci at 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