Re: FATAL: sorry, too many clients already

I'm not sure how you configured your flup, but probably you didn't ask for more than 100 persistent connections?

I ran into the same problem with DBUtils and MySQLdb, even when there should have been only 10 persistent connections. 

If I didn't overlook something, DBUtils doesn't close connections when the
 Python process exits. So, I suspect that when the application server gets restarted frequently (i.e. during development), all those abandoned connections will pile up inside the database server and at some point exhaust its connection pool. 

I use a homegrown scheme for connection persistence now - it explicitly closes all persistent connections when Python exits.  No problems since then. You could add that to DBUtils, too, I guess. Alternatively, I could also send you my code if you're interested. Michael.

 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

_______________________________________________
Webware-discuss mailing list
Webware-discuss-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/webware-discuss