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,
production.ini:
sqlalchemy.url = mysql://root@localhost/db?use_unicode=True&charset=utf8
sqlalchemy.pool_recycle = 30 (I try difrent value: 3600, 1800, 300)
sqlalchemy.echo_pool = True
sqlalchemy.pool_size = 10
sqlalchemy.max_overflow = 15
uwsgi:
[uwsgi]
socket = /tmp/site.wsgi
master = true
workers = 4
harakiri = 60
post-buffering = 8192
Could sombody help me ? Sorry for my english....
--
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.
