[asterisk-users] odbc error - server is gone

[Rizwan Hisham]

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 <http://www.voip-info.org/wiki/view/Asterisk+RealTime+Voicemail> and
>> here <http://www.voip-info.org/wiki/view/Asterisk+Voicemail+ODBC+storage>
>> .
>> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110429/61e8ad72/attachment.htm>