Error on cinder data purge
Issue
- It seems that purge processing runs periodically for the cinder database, and it seems that there is an error due to constraint violation in this database.
-
Would you tell me if there is information on whether there is a corresponding cinder package and whether it is a problem that can be resolved by setting change?
2017-01-31 00:01:03.206 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Purging deleted rows older than age=30 days from table=transfers 2017-01-31 00:01:03.209 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Deleted 0 rows from table=transfers 2017-01-31 00:01:03.215 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Purging deleted rows older than age=30 days from table=reservations 2017-01-31 00:01:03.220 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Deleted 0 rows from table=reservations 2017-01-31 00:01:03.224 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Purging deleted rows older than age=30 days from table=services 2017-01-31 00:01:03.226 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Deleted 0 rows from table=services 2017-01-31 00:01:03.230 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Purging deleted rows older than age=30 days from table=cgsnapshots 2017-01-31 00:01:03.232 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Deleted 0 rows from table=cgsnapshots 2017-01-31 00:01:03.234 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Purging deleted rows older than age=30 days from table=quota_classes 2017-01-31 00:01:03.237 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Deleted 0 rows from table=quota_classes 2017-01-31 00:01:03.240 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Purging deleted rows older than age=30 days from table=volume_admin_metadata 2017-01-31 00:01:03.242 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Deleted 0 rows from table=volume_admin_metadata 2017-01-31 00:01:03.243 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Purging deleted rows older than age=30 days from table=quota_usages 2017-01-31 00:01:03.245 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Deleted 0 rows from table=quota_usages 2017-01-31 00:01:03.249 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Purging deleted rows older than age=30 days from table=volume_metadata 2017-01-31 00:01:03.251 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Deleted 0 rows from table=volume_metadata 2017-01-31 00:01:03.254 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Purging deleted rows older than age=30 days from table=iscsi_targets 2017-01-31 00:01:03.256 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Deleted 0 rows from table=iscsi_targets 2017-01-31 00:01:03.260 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Purging deleted rows older than age=30 days from table=backups 2017-01-31 00:01:03.262 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Deleted 0 rows from table=backups 2017-01-31 00:01:03.266 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Purging deleted rows older than age=30 days from table=quotas 2017-01-31 00:01:03.268 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Deleted 0 rows from table=quotas 2017-01-31 00:01:03.271 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Purging deleted rows older than age=30 days from table=encryption 2017-01-31 00:01:03.273 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Deleted 0 rows from table=encryption 2017-01-31 00:01:03.278 15947 INFO cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] Purging deleted rows older than age=30 days from table=snapshots 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api [req-0b81520f-645e-40b8-b4f9-4c95ab3d62ed - - - - -] DBError detected when purging from table=snapshots 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api Traceback (most recent call last): 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib/python2.7/site-packages/cinder/db/sqlalchemy/api.py", line 4012, in purge_deleted_rows 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api .where(t.c.deleted_at < deleted_age)) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 1023, in execute 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api bind, close_with_result=True).execute(clause, params or {}) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api return meth(self, multiparams, params) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api return connection._execute_clauseelement(self, multiparams, params) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api compiled_sql, distilled_params 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api context) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api util.raise_from_cause(newraise, exc_info) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api reraise(type(exception), exception, tb=exc_tb) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api context) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api cursor.execute(statement, parameters) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 146, in execute 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api result = self._query(query) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 296, in _query 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api conn.query(q) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 781, in query 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api self._affected_rows = self._read_query_result(unbuffered=unbuffered) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 942, in _read_query_result 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api result.read() 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1138, in read 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api first_packet = self.connection._read_packet() 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 906, in _read_packet 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api packet.check_error() 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 367, in check_error 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api err.raise_mysql_exception(self._data) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 120, in raise_mysql_exception 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api _check_mysql_exception(errinfo) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 112, in _check_mysql_exception 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api raise errorclass(errno, errorvalue) 2017-01-31 00:01:03.281 15947 ERROR cinder.db.sqlalchemy.api DBReferenceError: (pymysql.err.IntegrityError) (1451, u'Cannot delete or update a parent row: a foreign key constraint fails (`cinder`.`volume_glance_metadata`, CONSTRAINT `volume_glance_metadata_ibfk_2` FOREIGN KEY (`snapshot_id`) REFERENCES `snapshots` ( `id`))') [SQL: u'DELETE FROM snapshots WHERE snapshots.deleted_at < %s'] [parameters: (datetime.datetime(2016, 12, 31, 15, 1, 3, 279004),)] ...
Environment
Red Hat OpenStack Platform 8.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
