You mean at statup, the old problem, right? Regards, Bogdan
Jeff Pyle wrote: > 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
