Error on cinder data purge

Solution In Progress - Updated -

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.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.