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

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

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

-- 
Alexandre Forget