[egenix-users] too many connections open

[M.-A. Lemburg]

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 ! ::::