[asterisk-bugs] [JIRA] (ASTERISK-21662) Res_odbc keeps losing connection to MySQL

Tue Apr 23 09:20:38 CDT 2013

    [ https://issues.asterisk.org/jira/browse/ASTERISK-21662?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=205582#comment-205582 ] 

Michael L. Young edited comment on ASTERISK-21662 at 4/23/13 9:18 AM:
----------------------------------------------------------------------

I have uploaded the res_odbc and odbc.ini files.  These asterisk servers are not busy at all.  I have an OpenSIPS proxy server that sits in front of my Asterisk servers and it never loses its connection but maybe that is because OpenSIPS is never really idle when it comes to reading or writing to the database maybe?  I also have an OpenXCAP server that doesn't lose connectivity.  When I do a "show processlist;" within mysql I see that all my connections are good and persistent except for the mysql ones.  If I use the res_config_mysql module I don't lose my connection but I do run into a different issue for which I currently have a different trouble ticket open.  ASTERISK-21387

So if I use res_config_mysql my connectivity to the database is fine until I run into my deadlock issue.  I set my logging to debug and I only got this

[Apr 22 21:46:17] WARNING[24159][C-00000006] res_odbc.c: SetConnectAttr (Txn isolation) returned an error: HY000: [MySQL][ODBC 5.1 Driver]MySQL server has gone away
[Apr 22 21:46:17] WARNING[24159][C-00000006] res_odbc.c: SQL Execute returned an error -1: 08S01: [MySQL][ODBC 5.1 Driver][mysqld-5.1.42]MySQL server has gone away (65)
[Apr 22 21:46:17] WARNING[24159][C-00000006] res_odbc.c: SQL Execute error -1! Verifying connection to asterisk [MySQL-asterisk]...
[Apr 22 21:46:17] WARNING[24159][C-00000006] res_odbc.c: Connection is down attempting to reconnect...
[Apr 22 21:46:22] NOTICE[24159][C-00000006] res_odbc.c: Connecting asterisk
[Apr 22 21:46:22] NOTICE[24159][C-00000006] res_odbc.c: res_odbc: Connected to asterisk [MySQL-asterisk]

      was (Author: osiris123d):
    I have uploaded the res_odbc and odbc.ini files.  These asterisk servers are not busy at all.  I have an OpenSIPS proxy server that sits in front of my Asterisk servers and it never loses its connection but maybe that is because OpenSIPS is never really idle when it comes to reading or writing to the database maybe?  I also have an OpenXCAP server that doesn't lose connectivity.  When I do a "show processlist;" within mysql I see that all my connections are good and persistent except for the mysql ones.  If I use the res_config_mysql module I don't lose my connection but I do run into a different issue for which I currently have a different trouble ticket open.  https://issues.asterisk.org/jira/browse/ASTERISK-21387

So if I use res_config_mysql my connectivity to the database is fine until I run into my deadlock issue.  I set my logging to debug and I only got this

[Apr 22 21:46:17] WARNING[24159][C-00000006] res_odbc.c: SetConnectAttr (Txn isolation) returned an error: HY000: [MySQL][ODBC 5.1 Driver]MySQL server has gone away
[Apr 22 21:46:17] WARNING[24159][C-00000006] res_odbc.c: SQL Execute returned an error -1: 08S01: [MySQL][ODBC 5.1 Driver][mysqld-5.1.42]MySQL server has gone away (65)
[Apr 22 21:46:17] WARNING[24159][C-00000006] res_odbc.c: SQL Execute error -1! Verifying connection to asterisk [MySQL-asterisk]...
[Apr 22 21:46:17] WARNING[24159][C-00000006] res_odbc.c: Connection is down attempting to reconnect...
[Apr 22 21:46:22] NOTICE[24159][C-00000006] res_odbc.c: Connecting asterisk
[Apr 22 21:46:22] NOTICE[24159][C-00000006] res_odbc.c: res_odbc: Connected to asterisk [MySQL-asterisk]

> Res_odbc keeps losing connection to MySQL
> -----------------------------------------
>
>                 Key: ASTERISK-21662
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-21662
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_odbc
>    Affects Versions: 11.3.0
>         Environment: Debian 6.0
>            Reporter: Duane Larson
>            Assignee: Duane Larson
>         Attachments: odbc.ini.txt, res_odbc.txt
>
>
> For some reason my ODBC connection to my MySQL server keeps losing its connection.  Because of this calls might be delayed until Asterisk re-establishes the connection.
> I have posted this before in the forum and never got an answer.
> http://forums.asterisk.org/viewtopic.php?p=170284
> Here are the errors I see
> {noformat}
> [Apr 19 15:05:18] WARNING[7380][C-00000003] res_odbc.c: SetConnectAttr (Txn isolation) returned an error: HY000: [MySQL][ODBC 5.1 Driver]MySQL server has gone away
> [Apr 19 15:05:18] WARNING[7380][C-00000003] res_odbc.c: SQL Execute returned an error -1: 08S01: [MySQL][ODBC 5.1 Driver][mysqld-5.1.42]MySQL server has gone away (65)
> [Apr 19 15:05:18] WARNING[7380][C-00000003] res_odbc.c: SQL Execute error -1! Verifying connection to asterisk [MySQL-asterisk]...
> [Apr 19 15:05:18] WARNING[7380][C-00000003] res_odbc.c: Connection is down attempting to reconnect...
> [Apr 19 15:05:23] NOTICE[7380][C-00000003] res_odbc.c: Connecting asterisk
> [Apr 19 15:05:23] NOTICE[7380][C-00000003] res_odbc.c: res_odbc: Connected to asterisk [MySQL-asterisk]
> [Apr 19 15:05:23] WARNING[7380][C-00000003] res_odbc.c: SQL Execute returned an error -1: 42S22: [MySQL][ODBC 5.1 Driver][mysqld-5.1.42]Unknown column 'callbackextension' in 'where clause' (91)
> [Apr 19 15:05:23] WARNING[7380][C-00000003] res_odbc.c: SQL Execute error -1! Verifying connection to asterisk [MySQL-asterisk]...
> [Apr 19 15:05:23] WARNING[7380][C-00000003] res_odbc.c: Connection is down attempting to reconnect...
> [Apr 19 15:05:28] NOTICE[7380][C-00000003] res_odbc.c: Connecting asterisk
> [Apr 19 15:05:28] NOTICE[7380][C-00000003] res_odbc.c: res_odbc: Connected to asterisk [MySQL-asterisk]
> [Apr 19 15:05:28] WARNING[7380][C-00000003] res_odbc.c: SQL Execute returned an error -1: 42S22: [MySQL][ODBC 5.1 Driver][mysqld-5.1.42]Unknown column 'callbackextension' in 'where clause' (91)
> [Apr 19 15:05:28] WARNING[7380][C-00000003] res_odbc.c: SQL Execute error -1! Verifying connection to asterisk [MySQL-asterisk]...
> [Apr 19 15:05:28] WARNING[7380][C-00000003] res_odbc.c: Connection is down attempting to reconnect...
> [Apr 19 15:05:33] NOTICE[7380][C-00000003] res_odbc.c: Connecting asterisk
> [Apr 19 15:05:33] NOTICE[7380][C-00000003] res_odbc.c: res_odbc: Connected to asterisk [MySQL-asterisk]
> [Apr 20 13:24:25] WARNING[7380][C-00000004] res_odbc.c: SetConnectAttr (Txn isolation) returned an error: HY000: [MySQL][ODBC 5.1 Driver]MySQL server has gone away
> [Apr 20 13:24:25] WARNING[7380][C-00000004] res_odbc.c: SQL Execute returned an error -1: 08S01: [MySQL][ODBC 5.1 Driver][mysqld-5.1.42]MySQL server has gone away (65)
> [Apr 20 13:24:25] WARNING[7380][C-00000004] res_odbc.c: SQL Execute error -1! Verifying connection to asterisk [MySQL-asterisk]...
> [Apr 20 13:24:25] WARNING[7380][C-00000004] res_odbc.c: Connection is down attempting to reconnect...
> [Apr 20 13:24:30] NOTICE[7380][C-00000004] res_odbc.c: Connecting asterisk
> [Apr 20 13:24:30] NOTICE[7380][C-00000004] res_odbc.c: res_odbc: Connected to asterisk [MySQL-asterisk]
> {noformat}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.asterisk.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira