Hi Chris, Thanks for responding. We have done a number of tests and I don't think it has anything to do with the connection pool settings as we have tested a number of different configurations with no difference in the outcome.
The problem is only during startup. After the first request has been processed and erred, we get great performance and no errors whatsoever! In fact, our performance tests has shown that the nginx + uwsgi + pylons stack performs brilliantly under tremendous load. Because our problem is only for the first request it further shifts the blame from the pool unless sqlalchemy is taking too long to establish the initial pool. I think you might be correct in your suspicion of the initialization of the Session. I will have to more closely review the pattern but I am pretty sure we have followed the typical initialization seen in most pylons documentation. Cheers On 22 November 2010 14:30, cd34 <[email protected]> wrote: > Two possibilities. > > sqlalchemy.echo = false > sqlalchemy.echo_pool = false > sqlalchemy.pool_recycle = 10 > > With pyramid, based on a chat in IRC with Ben Bangert, I modified > those to: > > sqlalchemy.echo = false > sqlalchemy.echo_pool = false > sqlalchemy.pool_recycle = 30 > sqlalchemy.pool_size = 20 > sqlalchemy.max_overflow = 10 > sqlalchemy.pool_timeout = 5 > > ------ > > However, the thing that is puzzling is the Gone Away/out of sync on > startup. I think what you might find there is that you have altered > Session somewhere during your startup or not instantiated it > properly. Might want to check your models to make sure that the DB > session isn't overwritten somewhere which is coincidentally mentioned > in a very recent thread: > > > http://groups.google.com/group/pylons-discuss/browse_thread/thread/4994e152af779a38 > > -- > 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]<pylons-discuss%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/pylons-discuss?hl=en. > > -- 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.
