Connection failure when SQL server is reset


#1

Hey guys,

I have a rails app using SQL Server. The application server has Win2000,
Apache 2 + scgi. The database server is Win2000 + SQL Server. When the
database server is rebooted, the rails application returns the following
error: Connection failure: connection reset by peer. Now, I have no
control
over when the database gets rebooted, that is in the hands of the db
folks.
It seems to me that rails likes to open a db connection and keep it open
for
the lifetime of the rails app. In the event of a reboot, it throws back
an
error, as it still thinks it has a connection. Is there any way
workaround
for this?

Thanks,

Jin


#2

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Nov 8, 2005, at 9:40 AM, Jin L. wrote:

I have a rails app using SQL Server. The application server has
Win2000, Apache 2 + scgi. The database server is Win2000 + SQL
Server. When the database server is rebooted, the rails application
returns the following error: Connection failure: connection reset
by peer. Now, I have no control over when the database gets
rebooted, that is in the hands of the db folks. It seems to me that
rails likes to open a db connection and keep it open for the
lifetime of the rails app. In the event of a reboot, it throws back
an error, as it still thinks it has a connection. Is there any way
workaround for this?

Please see
http://dev.rubyonrails.org/ticket/428
and
http://dev.rubyonrails.org/ticket/1697

jeremy
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (Darwin)

iD8DBQFDcQB/AQHALep9HFYRAok9AJ9Psgd0roNTslOoBItxdBoFXJYV0gCfdWRf
wYI9lHH5gpJ/nyrXABwIhUY=
=fb0F
-----END PGP SIGNATURE-----