[OpenSIPS-Users] db_mysql error, crash

[Jeff Pyle]

Hi Bogdan,

CentOS 5.2 running 2.6.18-92.1.22.el5xen.

Mysql client lib came from Mysql's own RPM named
MySQL-Cluster-gpl-client-6.3.20-0.rhel5.  The file itself is called
libmysqlclient.so.16.0.0 or libmysqlclient_r.so.16.0.0.

Does that answer the version question?  I'm not sure how to tell otherwise.


- Jeff



On 3/25/09 2:22 PM, "Bogdan-Andrei Iancu" <bogdan at voice-system.ro> wrote:

> Hi Jeff,
> 
> What OS are you using? and what version for mysql client lib?
> 
> Thanks and regards,
> Bogdan
> 
> Jeff Pyle wrote:
>> Hello,
>> 
>> I woke up this morning to this on Opensips 1.5.0:
>> 
>> Mar 25 08:50:10 opensips[12439]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute()
>> failed(2): (1210) Incorrect arguments to mysql_stmt_execute
>> Mar 25 08:50:10 opensips[12439]: ERROR:dialog:remove_dialog_from_db:
>> failed to delete database information
>> Mar 25 08:50:18 opensips[12412]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute()
>> failed(2): (1210) Incorrect arguments to mysql_stmt_execute
>> Mar 25 08:50:18 opensips[12412]: ERROR:dialog:remove_dialog_from_db:
>> failed to delete database information
>> Mar 25 08:50:19 opensips[12439]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute()
>> failed(2): (1210) Incorrect arguments to mysql_stmt_execute
>> Mar 25 08:50:19 opensips[12439]: ERROR:dialog:remove_dialog_from_db:
>> failed to delete database information
>> Mar 25 08:50:23 opensips[12412]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute()
>> failed(2): (1210) Incorrect arguments to mysql_stmt_execute
>> Mar 25 08:50:23 opensips[12412]: ERROR:dialog:remove_dialog_from_db:
>> failed to delete database information
>> Mar 25 08:50:27 opensips[12412]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute()
>> failed(2): (1210) Incorrect arguments to mysql_stmt_execute
>> Mar 25 08:50:27 opensips[12412]: ERROR:dialog:remove_dialog_from_db:
>> failed to delete database information
>> Mar 25 08:50:27 opensips[12439]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute()
>> failed(2): (1210) Incorrect arguments to mysql_stmt_execute
>> Mar 25 08:50:27 opensips[12439]: ERROR:dialog:remove_dialog_from_db:
>> failed to delete database information
>> Mar 25 08:50:30 opensips[12439]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute()
>> failed(2): (1210) Incorrect arguments to mysql_stmt_execute
>> Mar 25 08:50:30 opensips[12439]: ERROR:dialog:remove_dialog_from_db:
>> failed to delete database information
>> Mar 25 08:50:54 opensips[12412]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute()
>> failed(2): (1210) Incorrect arguments to mysql_stmt_execute
>> Mar 25 08:50:54 opensips[12412]: ERROR:dialog:remove_dialog_from_db:
>> failed to delete database information
>> Mar 25 08:51:48 opensips[12439]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute()
>> failed(2): (1210) Incorrect arguments to mysql_stmt_execute
>> Mar 25 08:51:48 opensips[12439]: ERROR:dialog:remove_dialog_from_db:
>> failed to delete database information
>> Mar 25 08:51:55 opensips[12412]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute()
>> failed(2): (1210) Incorrect arguments to mysql_stmt_execute
>> Mar 25 08:51:55 opensips[12412]: ERROR:dialog:remove_dialog_from_db:
>> failed to delete database information
>> Mar 25 08:52:16 opensips[12412]:
>> ERROR:db_mysql:db_mysql_do_prepared_query: mysql_stmt_execute()
>> failed(2): (1210) Incorrect arguments to mysql_stmt_execute
>> Mar 25 08:52:16 opensips[12412]: ERROR:dialog:remove_dialog_from_db:
>> failed to delete database information
>> Mar 25 08:52:25 opensips[12400]: INFO:core:handle_sigs: child process
>> 12435 exited normally, status=1
>> Mar 25 08:52:25 opensips[12400]: INFO:core:handle_sigs: terminating
>> due to SIGCHLD
>> Mar 25 08:52:25 opensips[12412]: INFO:core:sig_usr: signal 15 received
>> Mar 25 08:52:25 opensips[12468]: INFO:core:sig_usr: signal 15 received
>> Mar 25 08:52:25 opensips[12437]: INFO:core:sig_usr: signal 15 received
>> 
>> I have all the memory debug output from the crash as well (several
>> hundred lines). Unfortunately no core was generated even with Œulimit
>> ­c 0¹ and a working directory set.
>> 
>> 
>> - Jeff
>> 
>> ------------------------------------------------------------------------
>> 
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>   
>