Hey, I haven't seen the errors personally and have quite a few apps running on Heroku. I have been really happy with the service.
However, does the failure actually stop the rendering of your page and raise an error? I think what heroku are suggesting is that when the connection is lost the client library should reconnect and try again without raising an error, I take it this is not the case? Steve -- http://cloudmailin.com @cloudmailin Incoming email for your web app On 9 Aug 2010, at 14:56, Eric Anderson wrote: > Has anybody else gotten random errors from Heroku's database? I have > been having problems for a while now and am out of ideas so I am > hoping someone can help me. Here is the info I have: > > * Randomly various SQL queries will fail to execute. I get back the > following error: > > PGError: server closed the connection unexpectedly > > The query won't be anything special and will work most of the time. > But occasionally the app > just seems to loose it's connection to the database. > > * I have not see much reported by others but there is some reports of > it. See: > > > http://groups.google.com/group/heroku/browse_thread/thread/efc8c6d9eafc5e93/7c9499b452cbea43 > > * I get this same error on more than one application that I run so I > don't think it is something > the app is doing. > > * At least one of my apps is a paying app (i.e. has 2 persistent > dynos) so I don't think it has anything > to do with spinning up or down. > > * I have reported the issue to Heroku and they have confirmed that > this is a known issue but they gave > the following flippant response: > > This is a known issue. We're looking into it. It should be harmless > - your client should reopen the connection > > When I queried further as to how I should go about doing this and > should I resubmit queries, etc I get no > response from them. > > * These apps do not get much usage so I know it is not a case of over- > utilization. > > * I first reported this issue to them on May 12, 2010 and as of today > (Aug 9, 2010) I still have no resolution. > Each time I get the error I append the full debug info to the ticket > (I am using the Exception Notifier gem > so I just send them what my apps sends me). The following are the > dates I got errors to give you an > idea of how often I am getting them on an app that gets maybe a > dozen or two requests a day: > > - May-13 2010 > - May-14 2010 > - May-26 2010 > - Jun-03 2010 > - Jun-07 2010 > - Jun-14 2010 > - Jun-18 2010 > - Jun-24 2010 > - Jul-14 2010 > - Jul-19 2010 : 2 this day > - Jul-22 2010 : 4 this day > - Jul-27 2010 : 4 this day > - Jul-28 2010 > - Jul-29 2010 : 4 this day > - Aug-03 2010 > - Aug-06 2010 > - Aug-09 2010 : 4 this day > > Does anybody have any suggestions. Is there anything else I could post > that might be helpful. Since Heroku support has been non-responsive > this is really my last hope. If I can't find a resolution I am just > going to have to give up on Heroku and take my money elsewhere. Does > anybody have any suggestions for a good alternative to Heroku? > > -- > You received this message because you are subscribed to the Google Groups > "Heroku" group. > To post to this group, send email to her...@googlegroups.com. > To unsubscribe from this group, send email to > heroku+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en. > -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.