Correct. Exactly.
On 4/6/09 8:54 AM, "Bogdan-Andrei Iancu" <[email protected]> wrote: > 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
