Hi Wendy, no, I haven't found anything else out. I went ahead and opened a support ticket <https://help.heroku.com/tickets/69189>.
On Mon, Nov 26, 2012 at 6:54 PM, Wendy Friedlander < [email protected]> wrote: > 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/pos**tgresql_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/pos**tgresql_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 > -- 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
