On Nov 16, 5:45 pm, Gustavo Narea <[email protected]> wrote: > Thanks for the information. > > I couldn't find the message "Can't reconnect until invalid transaction > is rolled back" in the output you pasted and I think the link to the > FAQ refers to another type of issue.
Sorry. There are actually two exceptions; the first I already posted, and here's the second, with the "Can't reconnect until invalid transaction is rolled back" error. http://pastie.org/1304673 I don't know why I got two exceptions on a single request? I assumed the Pylons / repoze stack would have aborted after the first. (Unless the second exception was while trying to render the error page? If that is what's happening, is there a way to keep repoze.who from breaking rendering the error page?) > I've been reading about that error on the MySQL documentation and it > seems like all the possible causes are external to the > application:http://dev.mysql.com/doc/refman/5.0/en/gone-away.html > > You can try and tweak the Session if you want; it may or may not help. > I don't think handling the exception in repoze.who.plugins.sa is an > appropriate solution because we'd silencing a problem that should be > fixed. I understand that the causes of the "MySQL server has gone away" are external to the app and will work on that later; my concern right now is that (as far as I can tell) repoze.who.plugins.sa isn't cleaning up when this happens, which causes the app to get stuck in the "Can't reconnect until invalid transaction is rolled back" state (and I have to restart the app to get anything working again). The FAQ I linked to does appear to be a different specific issue, but its solution of using a try/except block to properly handle rollbacks seems to apply here too. -- Josh Kelley -- You received this message because you are subscribed to the Google Groups "pylons-discuss" 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/pylons-discuss?hl=en.
