Hello ,

We're using glance 2012.1+stable~20120608-5462295-0ubuntu2.2. We got a info as 'Lost connect to MySQL server during query' and glance spend 17 minutes to wait the response. is there any solution for shortened time? The following section is error message. Thanks.

-- Error Message:

2013-04-08 10:52:19 24193 DEBUG [routes.middleware] Match dict: {'action': u'show', 'controller': <glance.common.wsgi.resource object="" at="" 0x2f5dd10="">, 'id': u'test'}

2013-04-08 11:09:57 24193 WARNING [glance.registry.db.api] Got mysql server has gone away: (2013, 'Lost connection to MySQL server during query')

2013-04-08 11:09:57 24193 DEBUG [eventlet.wsgi.server] Traceback (most recent call last): File "/usr/lib/python2.7/dist-packages/eventlet/wsgi.py", line 382, in handleoneresponse result = self.application(self.environ, start_response)

File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 147, in call resp = self.call_func(req, args, *self.kwargs)

File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 210, in call_func return self.func(req, args, *kwargs)

File "/usr/lib/python2.7/dist-packages/glance/common/wsgi.py", line 279, in call response = req.get_response(self.application)

File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1086, in getresponse application, catchexc_info=False)

File "/usr/lib/python2.7/dist-packages/webob/request.py", line 1055, in callapplication appiter = application(self.environ, start_response)

File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in call return resp(environ, start_response)

File "/usr/lib/pymodules/python2.7/routes/middleware.py", line 131, in call response = self.app(environ, start_response)

File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 159, in call return resp(environ, start_response)

File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 147, in call resp = self.call_func(req, args, *self.kwargs)

File "/usr/lib/python2.7/dist-packages/webob/dec.py", line 210, in call_func return self.func(req, args, *kwargs)

File "/usr/lib/python2.7/dist-packages/glance/common/wsgi.py", line 477, in call request, **action_args)

File "/usr/lib/python2.7/dist-packages/glance/common/wsgi.py", line 494, in dispatch return method(args, *kwargs)

File "/usr/lib/python2.7/dist-packages/glance/registry/api/v1/images.py", line 274, in show image = dbapi.imageget(req.context, id)

File "/usr/lib/python2.7/dist-packages/glance/registry/db/api.py", line 287, in image_get image = query.one()

File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2184, in one ret = list(self)

File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in iter return self.executeand_instances(context)

File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2240, in executeandinstances closewith_result=True)

File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2231, in connectionfrom_session **kw)

File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 730, in connection closewithresult=closewithresult)

File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 736, in connectionforbind ... (more)