yahoo-eng-team team mailing list archive

[Cyril Roelandt <1939936@xxxxxxxxxxxxxxxxxx>]

Sorry we haven't gotten to this earlier. This looks like an isolated
issue with your MySQL database. I don't think this is still an issue,
feel free to reopen if needed.

** Changed in: glance
       Status: New => Invalid

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Glance.
https://bugs.launchpad.net/bugs/1939936

Title:
  The glance-api service runs but does not respond to requests

Status in Glance:
  Invalid

Bug description:
  openstack version :V

  phenomenon：
  The query images is not returned.

  telnet ip 9292 ,is ok

  curl ip:9292 ,no response.

  glance-api:logs

  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines   File "/var/lib/openstack/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines     self.dialect.do_execute(
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines   File "/var/lib/openstack/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines     cursor.execute(statement, parameters)
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines   File "/var/lib/openstack/lib/python3.8/site-packages/pymysql/cursors.py", line 163, in execute
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines     result = self._query(query)
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines   File "/var/lib/openstack/lib/python3.8/site-packages/pymysql/cursors.py", line 321, in _query
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines     conn.query(q)
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines   File "/var/lib/openstack/lib/python3.8/site-packages/pymysql/connections.py", line 505, in query
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines   File "/var/lib/openstack/lib/python3.8/site-packages/pymysql/connections.py", line 724, in _read_query_result
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines     result.read()
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines   File "/var/lib/openstack/lib/python3.8/site-packages/pymysql/connections.py", line 1069, in read
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines     first_packet = self.connection._read_packet()
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines   File "/var/lib/openstack/lib/python3.8/site-packages/pymysql/connections.py", line 646, in _read_packet
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines     packet_header = self._read_bytes(4)
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines   File "/var/lib/openstack/lib/python3.8/site-packages/pymysql/connections.py", line 698, in _read_bytes
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines     raise err.OperationalError(
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines oslo_db.exception.DBConnectionError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query')
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines [SQL: SELECT 1]
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines (Background on this error at: http://sqlalche.me/e/13/e3q8)
  2021-08-11 07:38:11.764 47 ERROR oslo_db.sqlalchemy.engines
  2021-08-12 07:22:34.084 47 INFO glance.domain [-] Task [0e45d62c-3670-42b8-9fd3-bfd064c35a78] status changing from pendingto processing
  2021-08-12 07:22:37.837 47 INFO glance.common.scripts.image_import.main [-] Task 0e45d62c-3670-42b8-9fd3-bfd064c35a78: Gotimage data uri file:///tmp/staging/3decd27d-b895-4471-9634-03ee1378bab2 to be imported
  2021-08-12 07:22:38.081 47 WARNING glance_store._drivers.rbd [-] Since image size is zero we will be doing resize-before-write which will be slower than normal
  2021-08-12 07:22:45.863 47 INFO glance.location [-] Image format matched and virtual size computed: 42949672960
  2021-08-12 07:22:46.861 47 INFO glance.domain [-] Task [0e45d62c-3670-42b8-9fd3-bfd064c35a78] status changing from processing to success
  2021-08-12 07:22:47.011 47 INFO glance.async_.flows.api_image_import [-] 0e45d62c-3670-42b8-9fd3-bfd064c35a78 of api_image_import completed
  2021-08-12 07:55:30.629 47 INFO glance.domain [-] Task [08636c18-8dea-4268-9301-bd899328b484] status changing from pendingto processing
  2021-08-12 07:55:31.682 47 INFO glance.common.scripts.image_import.main [-] Task 08636c18-8dea-4268-9301-bd899328b484: Gotimage data uri file:///tmp/staging/ee85cc10-6ac6-4645-9404-c70ab56559ca to be imported
  2021-08-12 07:55:32.066 47 WARNING glance_store._drivers.rbd [-] Since image size is zero we will be doing resize-before-write which will be slower than normal
  2021-08-12 07:55:33.393 47 INFO glance.location [-] Image format matched and virtual size computed: 22
  2021-08-12 07:55:35.629 47 INFO glance.domain [-] Task [08636c18-8dea-4268-9301-bd899328b484] status changing from processing to success
  2021-08-12 07:55:37.074 47 INFO glance.async_.flows.api_image_import [-] 08636c18-8dea-4268-9301-bd899328b484 of api_image_import completed

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1939936/+subscriptions