Hi
I attached the log file.
If you need detailed log/higher log level, then please let me know.
Can you try to reproduce with attached patch and mail
the line with the
mysql error as well as the last couple of loglines with submit_query and
store_result having the same con: as the failing query.
You can anonymize the queries as long as it is still deducable which module
submitted the query.
Also send list of modules using the database please.
Modules what i am using
loadmodule "db_mysql.so"
loadmodule "mi_fifo.so"
loadmodule "kex.so"
loadmodule "tm.so"
loadmodule "tmx.so"
loadmodule "sl.so"
loadmodule "rr.so"
loadmodule "pv.so"
loadmodule "maxfwd.so"
loadmodule "usrloc.so"
loadmodule "registrar.so"
loadmodule "textops.so"
loadmodule "siputils.so"
loadmodule "xlog.so"
loadmodule "sanity.so"
loadmodule "ctl.so"
loadmodule "mi_rpc.so"
loadmodule "acc.so"
loadmodule "auth.so"
loadmodule "auth_db.so"
loadmodule "alias_db.so"
loadmodule "presence.so"
loadmodule "presence_xml.so"
loadmodule "tls.so"
loadmodule "htable.so"
loadmodule "pike.so"
loadmodule "siptrace.so"
loadmodule "lcr.so"
loadmodule "enum.so"
loadmodule "cfg_rpc.so"
modparam("usrloc", "db_mode", 3)
Only one assumption:
Could it related to this change:
http://git.sip-router.org/cgi-bin/gitweb.cgi?p=sip-router;a=commitdiff;h=
dfc2834223b7c6b2e799da5a0876b8096cfdae5e
That one can be safely reverted if you
don't use the PV $sqlrows. But please
do above test without reverting this.
OK I applied your patch to the git version of km_dbase.c
Thanks,
Misi