mysql: driver_error

List overview All Threads
Download

newer

older

openser db on an external mysql...

Re: [SR-Users] dlg_manage and...

Uri Shacked

5 Feb 2013 5 Feb '13

10:29 a.m.

Hi,

I am doing some testing and i have trouble understanding when does the "mysql:driver_error" counter/statistics increase....

I stopped the mysqld process on the DB server and used sqlops. the driver_error did still is on 0.

I use version 3.3.2.

Thanks,

Uri

Attachments:

attachment.html (text/html — 1.6 KB)

Show replies by date

Daniel-Constantin Mierla

8 Feb 8 Feb

9:34 a.m.

Hello,

did you get any error log message in syslog from mysql module? A quick check in the code shows that the counter is incremented on connection errors or fetching results.

Cheers, Daniel

On 2/5/13 11:29 AM, Uri Shacked wrote:

...

Hi,

I am doing some testing and i have trouble understanding when does the "mysql:driver_error" counter/statistics increase....

I stopped the mysqld process on the DB server and used sqlops. the driver_error did still is on 0.

I use version 3.3.2.

Thanks,

Uri

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- Daniel-Constantin Mierla - http://www.asipto.com http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio World Conference, April 16-17, 2013, Berlin - http://conference.kamailio.com -

Uri Shacked

10 Feb 10 Feb

10:11 a.m.

Hi,

The Mysql server is not on the same machine. On the kamailio log i get the error - "[ km_dbase.c:122]: driver error on query: Can't connect to MySQL server on......" But the statistics couter does not increase.

Thanks, Uri

...

Hello,

did you get any error log message in syslog from mysql module? A quick check in the code shows that the counter is incremented on connection errors or fetching results.

Cheers, Daniel

On Tue, Feb 5, 2013 at 12:29 PM, Uri Shacked ushacked@gmail.com wrote:

...

Hi,

I am doing some testing and i have trouble understanding when does the "mysql:driver_error" counter/statistics increase....

I stopped the mysqld process on the DB server and used sqlops. the driver_error did still is on 0.

I use version 3.3.2.

Thanks,

Uri

Daniel-Constantin Mierla

11 Feb 11 Feb

10:57 p.m.

Hello,

looking in the source, the counter is increased for error codes CR_SERVER_GONE_ERROR and CR_SERVER_LOST.

The message printed in the log is for CR_CONNECTION_ERROR, according to http://dev.mysql.com/doc/refman/5.0/en/error-messages-client.html

Perhaps the cases to increment have to be extended.

Cheers, Daniel

On 2/10/13 11:11 AM, Uri Shacked wrote:

...

Hi, The Mysql server is not on the same machine. On the kamailio log i get the error - "[ km_dbase.c:122]: driver error on query: Can't connect to MySQL server on......" But the statistics couter does not increase. Thanks, Uri

...
Hello,

did you get any error log message in syslog from mysql module? A quick check in the code shows that the counter is incremented on connection errors or fetching results.

Cheers, Daniel

On Tue, Feb 5, 2013 at 12:29 PM, Uri Shacked <ushacked@gmail.com mailto:ushacked@gmail.com> wrote:
Hi,

I am doing some testing and i have trouble understanding when does
the "mysql:driver_error" counter/statistics increase....

I stopped the mysqld process on the DB server and used sqlops. the
driver_error did still is on 0.

I use version 3.3.2.

Thanks,

Uri

4453

Age (days ago)

4459

Last active (days ago)

sr-users@lists.kamailio.org

3 comments

2 participants

tags (0)

participants (2)

Daniel-Constantin Mierla
Uri Shacked