Hi,
I think it is not BEAKER problem, this is another trackback:
2011-12-17 18:54:05,371 INFO sqlalchemy.pool.QueuePool Invalidate
connection <_mysql.connection open to 'localhost' at 2502c20> (reason:
OperationalError:(2006, 'MySQL server has gone away'))
2011-12-17 18:54:05,372 INFO sqlalchemy.pool.QueuePool Pool disposed.
Pool size: 10 Connections in pool: 0 Current Overflow: -10 Current
Checked out connections: 0
2011-12-17 18:54:05,372 INFO sqlalchemy.pool.QueuePool Pool recreating
Traceback (most recent call last):
File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
packages/pyramid-1.3a2-py2.7.egg/pyramid/router.py", line 187, in
__call__
response = self.handle_request(request)
File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
packages/pyramid-1.3a2-py2.7.egg/pyramid/tweens.py", line 20, in
excview_tween
response = handler(request)
File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
packages/pyramid-1.3a2-py2.7.egg/pyramid/router.py", line 164, in
handle_request
response = view_callable(context, request)
File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
packages/pyramid-1.3a2-py2.7.egg/pyramid/config/views.py", line 550,
in __call__
return view(context, request)
File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
packages/pyramid-1.3a2-py2.7.egg/pyramid/config/views.py", line 290,
in attr_view
return view(context, request)
File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
packages/pyramid-1.3a2-py2.7.egg/pyramid/config/views.py", line 263,
in predicate_wrapper
return view(context, request)
File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
packages/pyramid-1.3a2-py2.7.egg/pyramid/config/views.py", line 316,
in rendered_view
result = view(context, request)
File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
packages/pyramid-1.3a2-py2.7.egg/pyramid/config/views.py", line 402,
in _class_requestonly_view
response = getattr(inst, attr)()
File "<string>", line 2, in manage
File "/home/users/sharpek/sites/mysite.net/v8/v8/core/decorators/
__init__.py", line 15, in wrapper
return func(self, *args, **kwargs)
File "/home/users/sharpek/sites/mysite.net/v8/v8/modules/album/page/
views.py", line 258, in manage
TeamAssign.STATUS_ACTIVE)),
File "/home/users/sharpek/sites/mysite.net/v8/v8/modules/team/
models.py", line 107, in member_teams
return sql.all()
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line
1947, in all
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line
2057, in __iter__
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line
2072, in _execute_and_instances
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line
1405, in execute
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line
1538, in _execute_clauseelement
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line
1646, in _execute_context
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line
1639, in _execute_context
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/default.py",
line 330, in do_execute
File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 174, in
execute
File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 36,
in defaulterrorhandler
sqlalchemy.exc.OperationalError: (OperationalError) (2006, 'MySQL
server has gone away') 'SELECT
On Dec 17, 6:26 pm, Michael Bayer <mike...@zzzcomputing.com> wrote:
> On Dec 17, 2011, at 8:16 AM, Sharpek wrote:
>
>
>
>
>
>
>
>
>
> > Hi,
>
> > I have fallowing error, with SQLAlchemy 0.7.4.
>
> > This is my trackback:
>
> > 2011-12-17 14:08:55,730 INFO sqlalchemy.pool.QueuePool Invalidate
> > connection <_mysql.connection open to 'sql.wmasg.pl' at 3a79730>
> > (reason: OperationalError:(2006, 'MySQL server has gone away'))
> > 2011-12-17 14:08:55,731 INFO sqlalchemy.pool.QueuePool Pool disposed.
> > Pool size: 10 Connections in pool: 0 Current Overflow: -10 Current
> > Checked out connections: 0
> > 2011-12-17 14:08:55,731 INFO sqlalchemy.pool.QueuePool Pool recreating
> > Traceback (most recent call last):
> > File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
> > packages/pyramid-1.3a2-py2.7.egg/pyramid/router.py", line 187, in
> > __call__
> > response = self.handle_request(request)
> > File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
> > packages/pyramid-1.3a2-py2.7.egg/pyramid/tweens.py", line 20, in
> > excview_tween
> > response = handler(request)
> > File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
> > packages/pyramid-1.3a2-py2.7.egg/pyramid/router.py", line 164, in
> > handle_request
> > response = view_callable(context, request)
> > File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
> > packages/pyramid-1.3a2-py2.7.egg/pyramid/config/views.py", line 316,
> > in rendered_view
> > result = view(context, request)
> > File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
> > packages/pyramid-1.3a2-py2.7.egg/pyramid/config/views.py", line 402,
> > in _class_requestonly_view
> > response = getattr(inst, attr)()
> > File "/home/users/sharpek/sites/mysite.net/v8/v8/modules/index/page/
> > views.py", line 41, in index
> > 'reportage_list': self.get_reportage_list(),
> > File "/home/users/sharpek/sites/mysite.net/v8/v8/modules/index/page/
> > views.py", line 19, in get_reportage_list
> > return generate_html(self, 'mainpage_reportages')
> > File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
> > packages/Beaker-1.6.2-py2.7.egg/beaker/cache.py", line 567, in cached
> > return cache[0].get_value(cache_key, createfunc=go)
> > File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
> > packages/Beaker-1.6.2-py2.7.egg/beaker/cache.py", line 303, in get
> > return self._get_value(key, **kw).get_value()
> > File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
> > packages/Beaker-1.6.2-py2.7.egg/beaker/container.py", line 382, in
> > get_value
> > v = self.createfunc()
> > File "/home/users/sharpek/sites/mysite.net/env/lib64/python2.7/site-
> > packages/Beaker-1.6.2-py2.7.egg/beaker/cache.py", line 565, in go
> > return func(*args)
> > File "<string>", line 2, in generate_html
> > File "/home/users/sharpek/sites/mysite.net/v8/v8/core/handlers.py",
> > line 86, in wrapper
> > rendered = render(tpl, func(self, *args, **kwargs), getattr(self,
> > 'request', None))
> > File "/home/users/sharpek/sites/mysite.net/v8/v8/modules/index/page/
> > views.py", line 16, in generate_html
> > 'reportages': Album.get_reportage_list(Album.REPORTAGE_MAINPAGE,
> > 5)
> > File "/home/users/sharpek/sites/mysite.net/v8/v8/modules/album/
> > models.py", line 76, in get_reportage_list
> > return sql.all()
> > File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line
> > 1947, in all
> > File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line
> > 2057, in __iter__
> > File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/query.py", line
> > 2072, in _execute_and_instances
> > File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line
> > 1405, in execute
> > File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line
> > 1538, in _execute_clauseelement
> > File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line
> > 1646, in _execute_context
> > File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line
> > 1639, in _execute_context
> > File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/default.py",
> > line 330, in do_execute
> > File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 174, in
> > execute
> > File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 36,
> > in defaulterrorhandler
> > sqlalchemy.exc.OperationalError: (OperationalError) (2006, 'MySQL
> > server has gone away') 'SELEC
>
> > My enviroment:
>
> > Pyramid, SQLAlchemy, Python 2.7,
>
> It looks like you have a complex system of using Beaker caching in
> conjunction with Pyramid views going on , I'm not sure how a Beaker->get()
> operation is leading down into a Pyramid view config and all. Basically you
> need to illustrate your architecture to the folks on the Pyramid list -
> unfortunately this is not just an engine config issue. The MySQL error
> is likely from multithreaded access to a single connection, which can be from
> multithreaded access on a single object. Basically if turning off threads
> solves the issue you'd know that thread-unsafe access is the problem.
--
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
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
