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
