Hello
I am running an application with cherrypy, sqlalchemy and mysql. All is
working fine but sometimes after inserting many data i get the following
messages.
I am using an scoped_session and remove the session if i don't need it. I
only see 3 databases processe in the mysql database.
br
Jürgen Hauptmann
> >> >
> >> >
> >> > 500 Internal Server Error
> >> >
> >> > The server encountered an unexpected condition which prevented
> it
> >> from
> >> > fulfilling the request.
> >> >
> >> > Traceback (most recent call last):
> >> > File
> "/usr/lib/python2.4/site-packages/cherrypy/_cprequest.py",
> >> line
> >> > 551, in respond
> >> > cherrypy.response.body = self.handler()
> >> > File
> "/usr/lib/python2.4/site-packages/cherrypy/_cpdispatch.py",
> >> line
> >> > 24, in __call__
> >> > return self.callable(*self.args, **self.kwargs)
> >> > File "server.py", line 60, in view
> >> > fall = session.query(Fall).filter_by(id=id).one()
> >> > File
> >> >
> >>
> "/usr/lib/python2.4/site-packages/SQLAlchemy-0.4.7p1-py2.4.egg/sqlal
> >> chemy/orm/query.py",
> >> > line 924, in one
> >> > ret = list(self[0:2])
> >> > File
> >> >
> >>
> "/usr/lib/python2.4/site-packages/SQLAlchemy-0.4.7p1-py2.4.egg/sqlal
> >> chemy/orm/query.py",
> >> > line 938, in __iter__
> >> > return self._execute_and_instances(context)
> >> > File
> >> >
> >>
> "/usr/lib/python2.4/site-packages/SQLAlchemy-0.4.7p1-py2.4.egg/sqlal
> >> chemy/orm/query.py",
> >> > line 941, in _execute_and_instances
> >> > result = self.session.execute(querycontext.statement,
> >> > params=self._params, mapper=self.mapper,
> >> > instance=self._refresh_instance)
> >> > File
> >> >
> >>
> "/usr/lib/python2.4/site-packages/SQLAlchemy-0.4.7p1-py2.4.egg/sqlal
> >> chemy/orm/session.py",
> >> > line 628, in execute
> >> > return self.__connection(engine,
> >> > close_with_result=True).execute(clause, params or {})
> >> > File
> >> >
> >>
> "/usr/lib/python2.4/site-packages/SQLAlchemy-0.4.7p1-py2.4.egg/sqlal
> >> chemy/orm/session.py",
> >> > line 600, in __connection
> >> > return self.transaction.get_or_add(engine)
> >> > File
> >> >
> >>
> "/usr/lib/python2.4/site-packages/SQLAlchemy-0.4.7p1-py2.4.egg/sqlal
> >> chemy/orm/session.py",
> >> > line 217, in get_or_add
> >> > conn = bind.contextual_connect()
> >> > File
> >> >
> >>
> "/usr/lib/python2.4/site-packages/SQLAlchemy-0.4.7p1-py2.4.egg/sqlal
> >> chemy/engine/base.py",
> >> > line 1239, in contextual_connect
> >> > return Connection(self, self.pool.connect(),
> >> > close_with_result=close_with_result, **kwargs)
> >> > File
> >> >
> >>
> "/usr/lib/python2.4/site-packages/SQLAlchemy-0.4.7p1-py2.4.egg/sqlal
> >> chemy/pool.py",
> >> > line 170, in connect
> >> > agent = _ConnectionFairy(self)
> >> > File
> >> >
> >>
> "/usr/lib/python2.4/site-packages/SQLAlchemy-0.4.7p1-py2.4.egg/sqlal
> >> chemy/pool.py",
> >> > line 323, in __init__
> >> > rec = self._connection_record = pool.get()
> >> > File
> >> >
> >>
> "/usr/lib/python2.4/site-packages/SQLAlchemy-0.4.7p1-py2.4.egg/sqlal
> >> chemy/pool.py",
> >> > line 180, in get
> >> > return self.do_get()
> >> > File
> >> >
> >>
> "/usr/lib/python2.4/site-packages/SQLAlchemy-0.4.7p1-py2.4.egg/sqlal
> >> chemy/pool.py",
> >> > line 604, in do_get
> >> > raise exceptions.TimeoutError("QueuePool limit of size %d
> >> overflow %d
> >> > reached, connection timed out, timeout %d" % (self.size(),
> >> > self.overflow(), self._timeout))
> >> > TimeoutError: QueuePool limit of size 30 overflow 10 reached,
> >> connection
> >> > timed out, timeout 30
> >> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
