{"action":"created","issue":{"url":"https://api.github.com/repos/kidchang/openstack-ansible/issues/3","labels_url":"https://api.github.com/repos/kidchang/openstack-ansible/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/kidchang/openstack-ansible/issues/3/comments","events_url":"https://api.github.com/repos/kidchang/openstack-ansible/issues/3/events","html_url":"https://github.com/kidchang/openstack-ansible/issues/3","id":59640068,"number":3,"title":"glance image create failed, stuck in queued status","user":{"login":"jerryz1982","id":1919098,"avatar_url":"https://avatars.githubusercontent.com/u/1919098?v=3","gravatar_id":"","url":"https://api.github.com/users/jerryz1982","html_url":"https://github.com/jerryz1982","followers_url":"https://api.github.com/users/jerryz1982/followers","following_url":"https://api.github.com/users/jerryz1982/following{/other_user}","gists_url":"https://api.github.com/users/jerryz1982/gists{/gist_id}","starred_url":"https://api.github.com/users/jerryz1982/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jerryz1982/subscriptions","organizations_url":"https://api.github.com/users/jerryz1982/orgs","repos_url":"https://api.github.com/users/jerryz1982/repos","events_url":"https://api.github.com/users/jerryz1982/events{/privacy}","received_events_url":"https://api.github.com/users/jerryz1982/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-03-03T13:18:24Z","updated_at":"2015-03-03T13:26:38Z","closed_at":null,"body":"| 6c000758-1580-4ebc-ba6d-5dc40fad700f | cirros-0.3.3-x86_64-disk.img | qcow2       | bare             | 13200896 | queued |\r\n\r\n2015-03-03 12:25:44.708 17006 ERROR glance.registry.api.v1.images [f398b6f3-fb41-452c-b122-b6e6f371c2b1 06fbf2aaf5ed4609ba57df47f53cd965 30af8b5eb252403ea54acb586ddaacc7 - - -] Unable to update image 6c000758-1580-4ebc-ba6d-5dc40fad700f\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images Traceback (most recent call last):\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/glance/registry/api/v1/images.py\", line 478, in update\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     from_state=from_state)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/glance/db/sqlalchemy/api.py\", line 135, in image_update\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     from_state=from_state)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/retrying.py\", line 68, in wrapped_f\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     return Retrying(*dargs, **dkw).call(f, *args, **kw)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/retrying.py\", line 223, in call\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     return attempt.get(self._wrap_exception)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/retrying.py\", line 261, in get\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     six.reraise(self.value[0], self.value[1], self.value[2])\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/retrying.py\", line 217, in call\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     attempt = Attempt(fn(*args, **kwargs), attempt_number, False)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/glance/db/sqlalchemy/api.py\", line 694, in _image_update\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     image_ref = _image_get(context, image_id, session=session)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/glance/db/sqlalchemy/api.py\", line 226, in _image_get\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     image = query.one()\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py\", line 2369, in one\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     ret = list(self)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py\", line 2412, in __iter__\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     return self._execute_and_instances(context)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py\", line 2427, in _execute_and_instances\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     result = conn.execute(querycontext.statement, self._params)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 729, in execute\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     return meth(self, multiparams, params)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py\", line 321, in _execute_on_connection\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     return connection._execute_clauseelement(self, multiparams, params)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 826, in _execute_clauseelement\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     compiled_sql, distilled_params\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 958, in _execute_context\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     context)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 1156, in _handle_dbapi_exception\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     util.raise_from_cause(newraise, exc_info)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py\", line 199, in raise_from_cause\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     reraise(type(exception), exception, tb=exc_tb)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\", line 951, in _execute_context\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     context)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py\", line 436, in do_execute\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     cursor.execute(statement, parameters)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py\", line 174, in execute\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     self.errorhandler(self, exc, value)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images   File \"/usr/lib/python2.7/dist-packages/MySQLdb/connections.py\", line 36, in defaulterrorhandler\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images     raise errorclass, errorvalue\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images DBConnectionError: (OperationalError) (2006, 'MySQL server has gone away') 'SELECT images.created_at AS images_created_at, images.updated_at AS images_updated_at, images.deleted_at AS images_deleted_at, images.deleted AS images_deleted, images.id AS images_id, images.name AS images_name, images.disk_format AS images_disk_format, images.container_format AS images_container_format, images.size AS images_size, images.virtual_size AS images_virtual_size, images.status AS images_status, images.is_public AS images_is_public, images.checksum AS images_checksum, images.min_disk AS images_min_disk, images.min_ram AS images_min_ram, images.owner AS images_owner, images.protected AS images_protected, image_locations_1.created_at AS image_locations_1_created_at, image_locations_1.updated_at AS image_locations_1_updated_at, image_locations_1.deleted_at AS image_locations_1_deleted_at, image_locations_1.deleted AS image_locations_1_deleted, image_locations_1.id AS image_locations_1_id, image_locations_1.image_id AS image_locations_1_image_id, image_locations_1.value AS image_locations_1_value, image_locations_1.meta_data AS image_locations_1_meta_data, image_locations_1.status AS image_locations_1_status, image_properties_1.created_at AS image_properties_1_created_at, image_properties_1.updated_at AS image_properties_1_updated_at, image_properties_1.deleted_at AS image_properties_1_deleted_at, image_properties_1.deleted AS image_properties_1_deleted, image_properties_1.id AS image_properties_1_id, image_properties_1.image_id AS image_properties_1_image_id, image_properties_1.name AS image_properties_1_name, image_properties_1.value AS image_properties_1_value \\nFROM images LEFT OUTER JOIN image_locations AS image_locations_1 ON images.id = image_locations_1.image_id LEFT OUTER JOIN image_properties AS image_properties_1 ON images.id = image_properties_1.image_id \\nWHERE images.id = %s' ('6c000758-1580-4ebc-ba6d-5dc40fad700f',)\r\n2015-03-03 12:25:44.708 17006 TRACE glance.registry.api.v1.images \r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/kidchang/openstack-ansible/issues/comments/76944453","html_url":"https://github.com/kidchang/openstack-ansible/issues/3#issuecomment-76944453","issue_url":"https://api.github.com/repos/kidchang/openstack-ansible/issues/3","id":76944453,"user":{"login":"jerryz1982","id":1919098,"avatar_url":"https://avatars.githubusercontent.com/u/1919098?v=3","gravatar_id":"","url":"https://api.github.com/users/jerryz1982","html_url":"https://github.com/jerryz1982","followers_url":"https://api.github.com/users/jerryz1982/followers","following_url":"https://api.github.com/users/jerryz1982/following{/other_user}","gists_url":"https://api.github.com/users/jerryz1982/gists{/gist_id}","starred_url":"https://api.github.com/users/jerryz1982/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jerryz1982/subscriptions","organizations_url":"https://api.github.com/users/jerryz1982/orgs","repos_url":"https://api.github.com/users/jerryz1982/repos","events_url":"https://api.github.com/users/jerryz1982/events{/privacy}","received_events_url":"https://api.github.com/users/jerryz1982/received_events","type":"User","site_admin":false},"created_at":"2015-03-03T13:26:38Z","updated_at":"2015-03-03T13:26:38Z","body":"Mar  3 12:25:38 vagrant-ubuntu-trusty-64 ansible-command: Invoked with executable=None shell=True args=/opt/image_upload.sh && touch image_upload_completed removes=None creates=image_upload_completed chdir=None\r\nMar  3 12:25:44 vagrant-ubuntu-trusty-64 ansible-service: Invoked with name=mysql pattern=None enabled=None state=restarted sleep=None arguments= runlevel=default"}}