Hey folks, it's me again! (I will wait for the groans to subside....good.)
I've got two issues, both related to (I think) connection pooling. I'm using Elixir with Pylons. The first issue is that I'm still seeing "old" data show up on my web pages. I have some background tasks that are updating the database, and if I keep hitting "refresh" in my web browser, the data on the web page seems to go backwards in time. The second issue is that if the database (Postgres) has a problem with one of my SQL statements (foreign key violation, duplicate key problem), the connection is left in a state where you have to execute a "rollback" before anything else can happen. Which causes all future requests that happen to get that DB connection to fail. The only way I've found to fix the problem is to restart my app server. So...does anyone have a recipe for what I should be doing at the start of each request to make sure i have a clean DB connection? (Or something that should be done at the end of each request to clean up after myself?) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
