In heroku console, any statement that takes more than 6 seconds will
get canceled.
>> ActiveRecord::Base.connection.select_all('show statement_timeout')
=> [{"statement_timeout"=>"6s"}]
Bump it up like this:
ActiveRecord::Base.connection.select_all('set statement_timeout to
60000')
Now you've got a minute.
On Jan 5, 7:53 am, knodi <[email protected]> wrote:
> Workers can't work because the queue is so large that looking for the
> next job times out.
>
> PGError: ERROR: cancelingstatementdue tostatementtimeout
> : SELECT * FROM "delayed_jobs" WHERE ((run_at <= '2010-01-05
> 04:40:26.189062' AND (locked_at IS NULL OR locked_at < '2010-01-05
> 04:40:16.189062') OR (locked_by = E'host:railgun64.16524 pid:13447'))
> AND failed_at IS NULL) ORDER BY priority DESC, run_at ASC LIMIT 5
>
> I'm on Ronin right now do I need more resources? or is there anything
> else I can do to avoid this problem?
--
You received this message because you are subscribed to the Google Groups
"Heroku" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/heroku?hl=en.
