Hi Jeff, There were several fixes in this area (mysql) and I think your case should be covered. Please update and test again.
Thanks and regards, Bogdan Jeff Pyle wrote: > 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" <jp...@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" <bog...@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@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users