# Database stops returning results after a period of time

**URL:** <https://www.ruby-forum.com/t/database-stops-returning-results-after-a-period-of-time/91895>\
**Category:** Rails\
**Created:** [April 13, 2007, 6:41am UTC](https://www.ruby-forum.com/t/database-stops-returning-results-after-a-period-of-time/91895 "2007-04-13T06:41:45Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ntran](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/73ab20/32.png) [@ntran](https://www.ruby-forum.com/u/ntran)\
**Post date:** [April 13, 2007, 6:41am UTC](https://www.ruby-forum.com/t/database-stops-returning-results-after-a-period-of-time/91895/1 "2007-04-13T06:41:45Z")

</div>

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