[sr-dev] MySQL - driver error on query: Commands out of sync; you can't run this command now

[Iñaki Baz Castillo]

2010/11/18 Johny Kadarisman Kwan <jkr888 at gmail.com>:
> /usr/local/sbin/kamailio[11693]: ERROR: db_mysql [km_dbase.c:117]:
> driver error on query: Commands out of sync; you can't run this
> command now

This error occurs when two MySQL requests sharing the same TCP
connection are sent one after the other, without waiting for the
response of the first one. This problem can arise when two threads or
two processes share the same MySQL connection and there is no a pool
mechanism or a lock mechanism.
This shouldn't occur in Kamailio as each process is supposed to
mantain its own MySQL connections, so it seems a bug. Which version
are you using?

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