[OpenSIPS-Users] db_mysql error, crash

[Bogdan-Andrei Iancu]

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" <bogdan at voice-system.ro> 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" <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
>>>>>>         
>>>>>>             
>>>   
>>>       
>
>
>