DBReferenceError: (pymysql.err.IntegrityError) (1452, u'Cannot add or update a child row:

Bug #1742799 reported by Mehdi Abaakouk
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
oslo.db
Invalid
Critical
Unassigned

Bug Description

Hi,

an exc_filters doesn't seem to work anymore:

Jan 11 20:24:06.004781 ubuntu-xenial-rax-ord-0001826484 <email address hidden>[13411]: File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1349, in read
Jan 11 20:24:06.004933 ubuntu-xenial-rax-ord-0001826484 <email address hidden>[13411]: first_packet = self.connection._read_packet()
Jan 11 20:24:06.005062 ubuntu-xenial-rax-ord-0001826484 <email address hidden>[13411]: File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1018, in _read_packet
Jan 11 20:24:06.005207 ubuntu-xenial-rax-ord-0001826484 <email address hidden>[13411]: packet.check_error()
Jan 11 20:24:06.005367 ubuntu-xenial-rax-ord-0001826484 <email address hidden>[13411]: File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 384, in check_error
Jan 11 20:24:06.005492 ubuntu-xenial-rax-ord-0001826484 <email address hidden>[13411]: err.raise_mysql_exception(self._data)
Jan 11 20:24:06.005629 ubuntu-xenial-rax-ord-0001826484 <email address hidden>[13411]: File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
Jan 11 20:24:06.005778 ubuntu-xenial-rax-ord-0001826484 <email address hidden>[13411]: raise errorclass(errno, errval)
Jan 11 20:24:06.005929 ubuntu-xenial-rax-ord-0001826484 <email address hidden>[13411]: DBReferenceError: (pymysql.err.IntegrityError) (1452, u'Cannot add or update a child row: a foreign key constraint fails (`gnocchi`.`archive_policy_rule`, CONSTRAINT `fk_apr_ap_name_ap_name` FOREIGN KEY (`archive_policy_name`) REFERENCES `archive_policy` (`name`))') [SQL: u'INSERT INTO archive_policy_rule (name, archive_policy_name, metric_pattern) VALUES (%(name)s, %(archive_policy_name)s, %(metric_pattern)s)'] [parameters: {'metric_pattern': u'cpu', 'archive_policy_name': u'ceilometer-rate-low', 'name': u'ceilometer-rate@cpu'}]

Mehdi Abaakouk (sileht)
Changed in oslo.db:
importance: Undecided → Critical
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.