[Rails] Re: Waiting for 1 connection to finish

2009-07-23 Thread Fernando Perez
I reinstalled my web app on a new VM, and merged Nginx and Rails on the same VM, and I still got the conneciton close problem, but now it happens between the Postgresl VM and my rails app one. So there is definitely a problem between Rails and Postgresql. Taken from -- The postgres gem is

[Rails] Re: Waiting for 1 connection to finish

2009-07-22 Thread Conrad Taylor
On Wed, Jul 22, 2009 at 2:04 AM, Fernando Perez rails-mailing-l...@andreas-s.net wrote: This morning all my Thin process are stuck again :-(, something seems to happen during the night or at least during a long period of time so that all processes end up blocked. Have you done any sand-box

[Rails] Re: Waiting for 1 connection to finish

2009-07-22 Thread Fernando Perez
Have you done any sand-box (i.e. staging server) testing prior to migrating your production application from 2.3.2 to 2.3.3? Everything works fine on my dev machine, and everything works fine (for a limited time though) on the production server. This problem appeared prior to upgrading

[Rails] Re: Waiting for 1 connection to finish

2009-07-22 Thread Fernando Perez
Cool my processes are blocking and here is what $ netstat -anp is giving me: Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name [...] tcp 1239 0 10.0.0.2:3100 10.0.0.1:36186 CLOSE_WAIT - tcp1 0 10.0.0.2:3100

[Rails] Re: Waiting for 1 connection to finish

2009-07-21 Thread Fernando Perez
Damn it was a former zombie Thin process that was still causing trouble! With kill -9 and restarting all new Thin instances to take advantage of the updated gem seems to have resolved the problem. I'll still keep an eye on it, and provide feedback. -- Posted via http://www.ruby-forum.com/.