oslo_db.tests.sqlalchemy.test_utils.MySQLTestMigrations.test_insert_from_select_with_specified_columns_negative fails in the gate
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
oslo.db |
Fix Released
|
High
|
Roman Podoliaka |
Bug Description
A couple of gate jobs failed recently with:
2015-04-08 17:23:43.605 | =======
2015-04-08 17:23:43.605 | Failed 1 tests - output below:
2015-04-08 17:23:43.605 | =======
2015-04-08 17:23:43.605 |
2015-04-08 17:23:43.605 | oslo_db.
2015-04-08 17:23:43.605 | -------
2015-04-08 17:23:43.605 |
2015-04-08 17:23:43.605 | Captured traceback:
2015-04-08 17:23:43.605 | ~~~~~~~~~~~~~~~~~~~
2015-04-08 17:23:43.606 | Traceback (most recent call last):
2015-04-08 17:23:43.606 | File "/home/
2015-04-08 17:23:43.606 | insert_statement)
2015-04-08 17:23:43.606 | File "/home/
2015-04-08 17:23:43.606 | self.assertThat
2015-04-08 17:23:43.606 | File "/home/
2015-04-08 17:23:43.606 | mismatch_error = self._matchHelp
2015-04-08 17:23:43.606 | File "/home/
2015-04-08 17:23:43.606 | mismatch = matcher.
2015-04-08 17:23:43.606 | File "/home/
2015-04-08 17:23:43.606 | mismatch = self.exception_
2015-04-08 17:23:43.607 | File "/home/
2015-04-08 17:23:43.607 | mismatch = matcher.
2015-04-08 17:23:43.607 | File "/home/
2015-04-08 17:23:43.607 | reraise(*matchee)
2015-04-08 17:23:43.607 | File "/home/
2015-04-08 17:23:43.607 | result = matchee()
2015-04-08 17:23:43.607 | File "/home/
2015-04-08 17:23:43.607 | return self._callable_
2015-04-08 17:23:43.607 | File "/home/
2015-04-08 17:23:43.607 | return meth(self, multiparams, params)
2015-04-08 17:23:43.608 | File "/home/
2015-04-08 17:23:43.608 | return connection.
2015-04-08 17:23:43.608 | File "/home/
2015-04-08 17:23:43.608 | compiled_sql, distilled_params
2015-04-08 17:23:43.608 | File "/home/
2015-04-08 17:23:43.608 | context)
2015-04-08 17:23:43.608 | File "/home/
2015-04-08 17:23:43.608 | e, statement, parameters, cursor, context)
2015-04-08 17:23:43.608 | File "/home/
2015-04-08 17:23:43.609 | util.raise_
2015-04-08 17:23:43.609 | File "/home/
2015-04-08 17:23:43.609 | reraise(
2015-04-08 17:23:43.609 | File "/home/
2015-04-08 17:23:43.609 | context)
2015-04-08 17:23:43.609 | File "/home/
2015-04-08 17:23:43.609 | cursor.
2015-04-08 17:23:43.609 | File "/home/
2015-04-08 17:23:43.617 | self.errorhandl
2015-04-08 17:23:43.617 | File "/home/
2015-04-08 17:23:43.617 | raise errorclass, errorvalue
2015-04-08 17:23:43.617 | sqlalchemy.
The problem is that the negative test case inserts randomly generated UUID values into an integer column and MySQL throws two different errors, depending on whether a particular UUID starts with a decimal digit or not.
We should handle both errors and wrap them with a high level DataError exception.
Changed in oslo.db: | |
milestone: | 1.8.0 → next-liberty |
This has actually been closed for a while now - https:/ /review. openstack. org/#/c/ 172099/