Re: [Sqlrelay-discussion] Auto reconnect not working with freetds and sybase, am I missing something?

[Alexandre F. <lex...@gm...>]

The bug is still there with sqlrelay-0.41 and fresh from cvs


On Wed, Apr 29, 2009 at 11:47 AM, David Muse <dav...@fi...> wrote:
> I have a vague memory of fixing a bug like that with sybase a few
> versions ago.  I can't find it in the changelog though.  You might want
> to try a newer version of SQL Relay, it may just be fixed.
>
> If the problem still exists in the current version, let me know and I'll
> fix it.
>
> Dave
> dav...@fi...
>
> On Fri, 2009-04-03 at 11:19 -0400, Alexandre Forget wrote:
>> Hi,
>>
>> My problem is with the connection between sqlrelay and sybase, it is
>> not automatically reconnected.
>> To test this case I kill the connection in sybase with a command in sqlrsh:
>>
>> > select * from master..sysprocesses;
>> > kill spid
>>
>> After this command I can no longer ping the database
>> > ping;
>>  database is down
>>
>> This is the debug info I get from the sqlr-connection
>> =====================
>> done getting command
>> ping
>> unlinking /var/cache/sqlrelay/tmp/ipc/example-sybase1
>> relogging in...
>> closing cursors...
>> 0
>> 1
>> 2
>> 3
>> 4
>> done closing cursors...
>> trying...
>> initializing cursors...
>> 0
>> 1
>> 2
>> 3
>> 4
>> done initializing cursors
>> done relogging in
>> creating /var/cache/sqlrelay/tmp/ipc/example-sybase1
>> getting command...
>> =======================
>>
>> If I restart sqlrsh the database stay down if I am connected to the
>> same sqlr-connection process. To me, it seem sqlrelay try to reconnect
>> to the db but fail to get a working connexion
>>
>>
>> If I restart sqlrelay width "sqlr-stop ;sqlr-start -id example" then
>> all the connections are working.
>>
>> versions:
>>
>> sqlrelay: 0.39
>> freetds: 0.82
>> sybase: 11.0.3
>>
>> thanks
>>
>
>
> __________________________________________________
> D O T E A S Y - "Join the web hosting revolution!"
>             http://www.doteasy.com
>
> ------------------------------------------------------------------------------
> Register Now & Save for Velocity, the Web Performance & Operations
> Conference from O'Reilly Media. Velocity features a full day of
> expert-led, hands-on workshops and two days of sessions from industry
> leaders in dedicated Performance & Operations tracks. Use code vel09scf
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>



-- 
Alexandre Forget