Hi Bogdan, I've been following the conversation. I updated on Friday. I haven't seen any more of the prepared statement errors, but I still have the occasional problem connecting to a remote mysqld instance for sip_trace. As before, all network captures and mysqld logs show a successful a connection. Odd.
- Jeff On 4/6/09 8:06 AM, "Bogdan-Andrei Iancu" <[email protected]> wrote: > 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" <[email protected]> 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" <[email protected]> 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 [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
