Re: [OpenSIPS-Users] db_mysql error, crash

2009-04-06 Thread Bogdan-Andrei Iancu
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" wrote: > > >> You mean at statup, the old

Re: [OpenSIPS-Users] db_mysql error, crash

2009-04-06 Thread Jeff Pyle
Correct. Exactly. On 4/6/09 8:54 AM, "Bogdan-Andrei Iancu" 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 e

Re: [OpenSIPS-Users] db_mysql error, crash

2009-04-06 Thread 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 f

Re: [OpenSIPS-Users] db_mysql error, crash

2009-04-06 Thread Jeff Pyle
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 conne

Re: [OpenSIPS-Users] db_mysql error, crash

2009-04-06 Thread 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 si

Re: [OpenSIPS-Users] db_mysql error, crash

2009-04-06 Thread Jacek Konieczny
On Fri, Apr 03, 2009 at 05:46:30PM +0300, Bogdan-Andrei Iancu wrote: > So, the fix is available on SVN - update and give it another try - it > should work (at least for me it did). I have applied the fix to our opensips server today and, indeed, the bug seems fixed. Thanks a lot! I love that kin

Re: [OpenSIPS-Users] db_mysql error, crash

2009-04-03 Thread Bogdan-Andrei Iancu
Hi Jacek, First of all, many, many thanks for your help and support in debugging this issue. I have to say mysql really sucks when comes to re-connect :(... Following the logs from you I was able to reproduce the crash and to find the cause...and eventually a fix. So, the fix is available on S

Re: [OpenSIPS-Users] db_mysql error, crash

2009-03-31 Thread Bogdan-Andrei Iancu
Hi Jacek, but are you using the latest SVN trunk or 1.5 ? if yes, and still crashes, could you run in debug=6 and send me the logs (from startup to crash) ? maybe off list if the file is too big. Thanks and regards, Bogdan Jacek Konieczny wrote: > On Fri, Mar 27, 2009 at 11:53:47AM +0100, Iñak

Re: [OpenSIPS-Users] db_mysql error, crash

2009-03-30 Thread Jacek Konieczny
On Fri, Mar 27, 2009 at 11:53:47AM +0100, Iñaki Baz Castillo wrote: > 2009/3/27 Jacek Konieczny : > > Hello, > > > > On Wed, Mar 25, 2009 at 09:36:42AM -0400, Jeff Pyle wrote: > >>  I woke up this morning to this on Opensips 1.5.0: > > > > Core was generated by `opensips'. > > Program terminated wi

Re: [OpenSIPS-Users] db_mysql error, crash

2009-03-27 Thread Iñaki Baz Castillo
2009/3/27 Jacek Konieczny : > Hello, > > On Wed, Mar 25, 2009 at 09:36:42AM -0400, Jeff Pyle wrote: >>  I woke up this morning to this on Opensips 1.5.0: > > Core was generated by `opensips'. > Program terminated with signal 11, Segmentation fault. > #0  0xb7b673bd in mysql_stmt_result_metadata (st

Re: [OpenSIPS-Users] db_mysql error, crash

2009-03-27 Thread Jacek Konieczny
Hello, On Wed, Mar 25, 2009 at 09:36:42AM -0400, Jeff Pyle wrote: > I woke up this morning to this on Opensips 1.5.0: The log: Mar 27 08:22:52 gtw1-ms opensips[14929]: ERROR:core:re_init_statement: failed while mysql_stmt_prepare: Unknown prepared statement handler (3) given to mysql_stmt_clos

Re: [OpenSIPS-Users] db_mysql error, crash

2009-03-26 Thread Jeff Pyle
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

Re: [OpenSIPS-Users] db_mysql error, crash

2009-03-25 Thread Jeff Pyle
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 other

Re: [OpenSIPS-Users] db_mysql error, crash

2009-03-25 Thread Bogdan-Andrei Iancu
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):

[OpenSIPS-Users] db_mysql error, crash

2009-03-25 Thread Jeff Pyle
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 del