Forum: Ruby on Rails Database stops returning results after a period of time.

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Nick T. (Guest)
on 2007-04-13 08:41
(Received via mailing list)
Hello all

I'm seeing strange behaviour from an internal application running with
the following general setup:

  * app is served by a single mongrel instance running on Windows
Server 2003
  * the same server hosts an SQL Server 2000 database that uses
trusted connections
  * sessions use ActiveRecordStore
  * running Rails 1.1.6 and Ruby 1.8.5

The issue is that, after a period of time, valid operations such as
Constant.find_by_value_and_group(@claim.loss_type,'LOSS_TYPES_20')
stop returning results.

Inspection of the production log doesn't give any further insight into
the issue, nor do the Event Viewer logs shed any further light.
Restarting mongrel fixes the issue temporarily.

Has anyone experienced something similar or can you suggest a route to
investigate the problem?

Thanks
Nick
This topic is locked and can not be replied to.