Ruby on Rails: How to set a database timeout in application configuration?

Question

I'd like to set my database to timeout requests that do not complete within a set amount of time, in order to prevent outlier requests from monopolizing the entire application.

Is there anything I can add to my Rails configuration files in order to set this?

I tried to add a line I saw often online of timeout: 5000 to my database.yml, but that didn't seem to have any effect.

I tried to make calls to ActiveRecord::Base.connection.execute('set statement_timeout to 5000') in the environment.rb but that causes Rails to error out.

I'm running a Postgres database on Heroku, where I do not have direct database access, hence I cannot do this with database configuration directly. Even if I remotely execute that command from the Heroku console, they can restart my application at any time, and if this isn't re-executed as the application starts, my change gets lost.

Bill Lipa · Accepted Answer · 2015-02-24 04:53:11Z

9

database.yml:

defaults: &default
  adapter: postgresql
  encoding: unicode
  pool: 5
  min_messages: warning
  variables:
    statement_timeout: 5000

answered Feb 24, 2015 at 4:53

Bill Lipa

2,0891 gold badge19 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jwan622 Over a year ago

is that for 5 seconds or 5000 seconds?

Bill Lipa Over a year ago

5000 means 5 seconds.

William Jones · Accepted Answer · 2010-08-22 04:29:24Z

5

Got this working, just needed to include the line in environment.rb at the very end, rather than in the beginning or in the block.

answered Aug 22, 2010 at 4:29

William Jones

18.3k18 gold badges66 silver badges101 bronze badges

Comments

Matthew Wood · Accepted Answer · 2010-08-18 01:23:28Z

2

Try this syntax:

SET statement_timeout = 5000;

answered Aug 18, 2010 at 1:23

Matthew Wood

16.5k6 gold badges49 silver badges35 bronze badges

1 Comment

William Jones Over a year ago

No, the problem isn't the SQL, the error I get when I stick the ActiveRecord::Base.connection.execute into my environment.rb is uninitialized constant ActiveRecord.

Collectives™ on Stack Overflow

Ruby on Rails: How to set a database timeout in application configuration?

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related