Hi Andrew, Have you had any luck with this? I've had the same problem as well -- first error is connection time out and the next is eof detected. The site is then down for a while... happened twice today, took 16 min to resolve. At least now I know I can do 'heroku restart' I hadn't thought of that. It has only happened since the db update as well.
Please let me know what you've learned. Thanks! -Wendy On Wednesday, November 21, 2012 11:20:07 AM UTC-5, Andrew Lorente wrote: > > I've been having intermittent pg connection problems since my app was > migrated to the new database setup. I'll get a pair of exceptions (see > below). Sometimes the problem fixes itself in a couple of minutes; other > times I have to do a `heroku restart`. > > The first exception that comes through is a "connection timeout:" > > A ActiveRecord::StatementInvalid occurred in posts#index: > > PG::Error: SSL SYSCALL error: Connection timed out > : SELECT "posts".* FROM "posts" WHERE (published_at < '2012-11-21 > 15:43:06.226910') ORDER BY posts.published_at DESC LIMIT 15 > vendor/bundle/ruby/1.9.1/gems/ > activerecord-3.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:1106:in > > `async_exec' > > The second exception is an "EOF Detected:" > > A ActiveRecord::StatementInvalid occurred in posts#index: > > PG::Error: SSL SYSCALL error: EOF detected > : SELECT "posts".* FROM "posts" WHERE (published_at < '2012-11-21 > 15:58:42.070747') ORDER BY posts.published_at DESC LIMIT 15 > vendor/bundle/ruby/1.9.1/gems/ > activerecord-3.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:1106:in > > `async_exec' > > They always come in pairs like that (on subsequent requests). > > I'm not sure what else to look up to help figure this out. Any ideas? > > Thanks, > Andrew > -- You received this message because you are subscribed to the Google Groups "Heroku" group. 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_US?hl=en
