[egenix-users] too many connections open

[Tim Morgan]

Worked like a charm. Thanks. 

> -----Original Message-----
> From: M.-A. Lemburg [mailto:mal at egenix.com] 
> Sent: Tuesday, March 29, 2005 1:51 PM
> To: Tim Morgan
> Cc: egenix-users at lists.egenix.com
> Subject: Re: [egenix-users] too many connections open
> 
> Tim Morgan wrote:
> > Yes, we have just more than 20 connection objects at this time and 
> > this number will probably be increasing shortly.
> 
> I see.
> 
> To adjust the limits, you will have to tweak the Zope DA 
> globals using the following trick:
> 
> Create a file ZopeDASettings.py in the same directory where 
> you find ZopeDA.pyc (Products/mxODBCZopeDA) with the 
> following content:
> 
> """
> # Schema cache
> #MAX_SCHEMA_CACHE_SIZE = 10
> 
> # Maximum number of Zope data sources to pool 
> #MAX_ZOPE_CONNECTION_POOL_SIZE = 20
> 
> # Maximum number of Zope connections to pool per data source 
> #MAX_ZOPE_POOL_SIZE = 50 """
> 
> and uncomment and adjust the limits to your needs.
> You may also want to increase the schema cache size with that 
> many connections open.
> 
> A restart of Zope should then have the Zope DA pick up these 
> new setting automatically.
> 
> >>-----Original Message-----
> >>From: M.-A. Lemburg [mailto:mal at egenix.com]
> >>Sent: Tuesday, March 29, 2005 1:30 PM
> >>To: Tim Morgan
> >>Cc: egenix-users at lists.egenix.com
> >>Subject: Re: [egenix-users] too many connections open
> >>
> >>Tim Morgan wrote:
> >>
> >>>I'm getting the following error on one or more of my
> >>
> >>connection objects:
> >>
> >>> 
> >>> too many connection pools open, try closing a few connections
> >>> 
> >>>If I restart Zope, I can get the connection to open, but I
> >>
> >>end up with
> >>
> >>>a different connection object being closed somewhere else. 
> >>
> >>Is there a
> >>
> >>>hard limit to the number of Database Connections we can
> >>
> >>have at a time?
> >>
> >>There are two limits: You can have up to 20 connection 
> pools with up 
> >>to 50 connections each. Both values can be adjusted, though, if 
> >>needed.
> >>
> >>Do you have more than 20 connection object open at the same time ?
> >>
> >>--
> >>
> >>Marc-Andre Lemburg
> >>eGenix.com
> >>
> >>Professional Python Services directly from the Source  (#1, Mar 29 
> >>2005)
> >> >>> Python/Zope Consulting and Support ...        
> >>http://www.egenix.com/
> >> >>> mxODBC.Zope.Database.Adapter ...             
> >>http://zope.egenix.com/
> >> >>> mxODBC, mxDateTime, mxTextTools ...        
> >>http://python.egenix.com/
> >>______________________________________________________________
> >>__________
> >>
> >>::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! 
> >>::::
> >>
> >>
> > 
> > 
> > 
> > 
> > To view Family & Children's Services Employment 
> Opportunities, visit our website at 
> http://www.fcsok.org/who_we_are/employment.asp.
> > 
> > CONFIDENTIALITY NOTICE:  This email, including any 
> attachments, is intended only for the individual or entity to 
> which it is addressed and may contain information that is 
> privileged, confidential and exempt from disclosure under 
> applicable laws.  If the reader of this message is not the 
> intended recipient, you are hereby informed that any review, 
> use, disclosure, distribution or copying of this 
> communication is strictly prohibited.  If you have received 
> this communication in error, please contact the sender by 
> reply email and delete all forms of the original message from 
> your system.  Thank you.
> > 
> > This e-mail and all other electronic (including voice) 
> communications from the sender's agency are for informational 
> purposes only.  No such communication is intended by the 
> sender to constitute either an electronic record or an 
> electronic signature, or to constitute any agreement by the 
> sender to conduct a transaction by electronic means.  Any 
> such intention or agreement is hereby expressly disclaimed 
> unless otherwise specifically indicated.  To learn more about 
> our agency, please visit our website at http://www.fcsok.org.
> > 
> 
> -- 
> 
> Marc-Andre Lemburg
> eGenix.com
> 
> Professional Python Services directly from the Source  (#1, 
> Mar 29 2005)
> >>> Python/Zope Consulting and Support ...        
> http://www.egenix.com/
> >>> mxODBC.Zope.Database.Adapter ...             
> http://zope.egenix.com/
> >>> mxODBC, mxDateTime, mxTextTools ...        
> http://python.egenix.com/
> ______________________________________________________________
> __________
> 
> ::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for 
> free ! ::::
> 
>