[asterisk-users] odbc error - server is gone

[Warren Selby]

You're using 1.4.2. Why not try upgrading to a more recent release of 1.4 (I believe 1.4.41 is current) and see if your issue has been resolved. 

Thanks,
--Warren Selby, dCAP

On Apr 29, 2011, at 7:32 AM, Rizwan Hisham <rizwanhasham at gmail.com> wrote:

> Yes I have it there, here the content of the file:
> 
> i think the code is buggy,
> 
> here is a comment from the function which generated the error (ast_odbc_smart_execute in res_odbc.c line 155 )
> 
> /* This is a really bad method of trying to correct a dead connection.  It
>  * only ever really worked with MySQL.  It will not work with any other
>  * database, since most databases prepare their statements on the server,
>  * and if you disconnect, you invalidate the statement handle.  Hence, if
>  * you disconnect, you're going to fail anyway, whether you try to execute
>  * a second time or not.
>  */
> 
> This function is used all over.
> 
> On Fri, Apr 29, 2011 at 12:23 AM, Sherwood McGowan <sherwood.mcgowan at gmail.com> wrote:
> On Thu, Apr 28, 2011 at 11:09 AM, Rizwan Hisham <rizwanhasham at gmail.com> wrote:
> Hi list,
> yesterday I converted my voicemail.conf to realtime voicemail and also configured to store the voicemessages in a database using odbc as described here and here.
> I am using asterisk 1.4.2 with mysql. I also installed the proper odbc driver for mysql on the server. I successfully completed the conversion of a lot of voicemail users into db yesterday. But today on the CLI thsi error was showing;
> 
> [Apr 28 11:40:54] WARNING[24676]: res_odbc.c:147 ast_odbc_smart_execute: SQL Execute returned an error -1: 08S01: [MySQL][ODBC 3.51 Driver][mysqld-5.0.68-log]MySQL server has gone away (70)
> [Apr 28 11:40:54] WARNING[24676]: res_odbc.c:147 ast_odbc_smart_execute: SQL Execute returned an error -1: 08S01: [MySQL][ODBC 3.51 Driver][mysqld-5.0.68-log]MySQL server has gone away (70)
> [Apr 28 11:40:54] WARNING[24676]: app_voicemail.c:2239 inboxcount: SQL Execute error!
> [SELECT COUNT(*) FROM voicemessages WHERE dir = '/var/spool/asterisk/voicemail/default/1757XXXXXXX/INBOX']
> 
> I know that the error is caused due to stale odbc connection with mysql. But i want to find out if there is a cure for it. Why the connection went stale in the first place also.
> 
> Any ideas?
> 
> -- 
> Best Ragards
> Rizwan Qureshi
> VoIP/Asterisk Engineer
> Axvoice Inc.
> 
> V: +92 (0) 3333 6767 26
> E: rizwanhasham at gmail.com
> W: www.axvoice.com
> 
> 
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>               http://www.asterisk.org/hello
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
> 
> 
> do you have "sanitysql => select 1" configured in res_odbc.ini?
> 
> -- 
> Sherwood McGowan
> Telecommunications and VOIP Consultant
> 
> 
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>               http://www.asterisk.org/hello
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
> 
> 
> 
> -- 
> Best Ragards
> Rizwan Qureshi
> VoIP/Asterisk Engineer
> Axvoice Inc.
> 
> V: +92 (0) 3333 6767 26
> E: rizwanhasham at gmail.com
> W: www.axvoice.com
> 
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>               http://www.asterisk.org/hello
> 
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110429/0649344e/attachment.htm>