[OpenSIPS-Users] db_mysql error, crash

[Jeff Pyle]

Hi Bogdan,

Is this information helpful for you?  Am I looking at the correct item?

I've had several more crashes since this one, but absolutely no hint as to
why.  No mysql errors on these.  Nor core dumps.  It seems to happen only
after the proxy is up for a while.  I'm attempting to run it with debug=4
but it's hard to keep track of that much data.  Hopefully I'll catch a crash
at debug=4 to know at least which module is causing it.


Thanks,
Jeff



On 3/25/09 2:28 PM, "Jeff Pyle" <jpyle at fidelityvoice.com> wrote:

> 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