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

[David M. <dav...@fi...>]

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