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

2010/11/18 Johny Kadarisman Kwan jkr888@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?