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

[Johny Kadarisman Kwan]

Hi there,

I'm running Kamilio 3.0.3, at least that is showen on sercmd>core.version.

following are other details:

Server: kamailio (3.0.3 (i386/linux)) a22dc9
Mysql: 5.0.77
CentOS 5.5


On Thu, Nov 18, 2010 at 5:19 PM, Iñaki Baz Castillo <ibc at aliax.net> wrote:
> 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>
>