[OpenSIPS-Devel] ERROR:db_mysql:db_mysql_submit_query

[Bogdan-Andrei Iancu]

Hi Iñaki,

But, based on the mysql logs, what is the last query performed by proc 
23847  before generating the "out of sync" errors?

The error from 23846 is not related as each process uses a dedicated 
mysql connection to server.

Regards,
Bogdan

Iñaki Baz Castillo wrote:
> 2008/12/10 Iñaki Baz Castillo <ibc at aliax.net>:
>   
>
>
> Also, as you cad see in the following log, the error is related to the
> MySQL driver, regardless of the OpenSIPS module:
>
> ---------
> opensips[23846]: ERROR:db_mysql:db_mysql_submit_query: driver error on
> query: Duplicate entry 'sip:bob at domain.net-bob-oversip.net-presence'
> for key 2
> opensips[23846]: ERROR:core:db_do_insert: error while submitting query
> opensips[23846]: ERROR:presence:update_presentity: inserting new
> record in database
> opensips[23846]: ERROR:presence:handle_publish: when updating presentity
> opensips[23847]: ERROR:db_mysql:db_mysql_submit_query: driver error on
> query: Commands out of sync; you can't run this command now
> opensips[23847]: ERROR:core:db_do_query: error while submitting query
> opensips[23847]: ERROR:presence:get_p_notify_body: failed to query
> presentity table
>