Frequent error -- ActiveRecord::LostConnection: TinyTds::Error: DBPROCESS is dead or not enabled

[Marc Chambers]

Seeing this error pretty regularly running Passenger and Apache on an Azure Ubuntu VM talking with SQL Azure... could this be a configuration issue? Possibly with timeouts? It happens after the instance idles following a successful request.

Caused ActiveRecord::LostConnection: TinyTds::Error: DBPROCESS is dead or not enabled: EXEC sp_executesql N'SELECT TOP (1) [customers].* FROM [customers] WHERE [customers].[id] = 1'

[Ken Collins]

There is a discussion/ticket here.

https://github.com/rails-sqlserver/tiny_tds/issues/79

In that thread, I talk a little bit about keep alive too, but not a primary point. Have you read these?

https://github.com/rails-sqlserver/tiny_tds/issues/79#issuecomment-5226738

Either way, that discussion and topic is there.


- Ken