[OpenSIPS-Users] db_mysql error, crash

[Bogdan-Andrei Iancu]

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
>>>>         
>
>
>