Public bug reported: 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 ** Affects: glance Importance: Undecided Status: New ** Description changed: openstack version :V phenomenon： The query images is not returned. telnet ip 9292 ,is ok - curl ip:9291 ,no response. - + 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 -- 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: New 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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
