[OpenSIPS-Users] db_mysql error, crash

Mon Apr 6 15:02:30 CEST 2009

If a remote server, try to run an tcpdump on 3306 (mysql port) when you 
start, just to see what is going one between the mysql client and server...

Regards,
Bogdan

Jeff Pyle wrote:
> Correct.  Exactly. 
>
>
> On 4/6/09 8:54 AM, "Bogdan-Andrei Iancu" <bogdan at voice-system.ro> 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" <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
>>>>>>>>         
>>>>>>>>            
>>>>>>>>                 
>>>>>   
>>>>>       
>>>>>           
>>>   
>>>       
>
>
>   