[egenix-users] Exception exceptions.AttributeError - Depending upon the naming of the module ( connector.py / error_connector.py)

[M.-A. Lemburg]

On 2009-02-11 16:58, Senthil Kumaran wrote:
> Thanks for the quick response again. I shall try all your suggestions.
> I was not aware the connection.close() and session.close() should be
> done. I was just doing connection.close()
> 
> On Wed, M.-A. Lemburg wrote:
>> Are you running the requests in a for-loop or starting the script
>> 20 or more times ?
> 
> I am starting and running the script for 6-7 times, one after the
> after and this error message comes up.
> I wonder what is happening, because the python interpretor is shutdown
> each time the script is complete ( successfully for 6-7 times). I go
> restart the server and the same pattern will follow.

That would explain why you are running out of connections.

If you don't call session.close() on the client side and the
implicit call fails due to Python already having shut down
modules which are needed to communicate the end-of-communication
to the server, the server will only notice the closed client
connection after a timeout is reached.

The server will keep the database connections open until it
gets the timeout notice.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Feb 11 2009)
>>> 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 our new mxODBC.Connect Python Database Interface for free ! ::::


   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611
               http://www.egenix.com/company/contact/