Re: [openstack-dev] [nova] unit test migration failure specific to MySQL/MariaDB - 'uuid': used in a foreign key constraint 'block_device_mapping_instance_uuid_fkey'

OK so it’s looking like sql_mode=‘TRADITIONAL’ that allows it to work. So that is most of it. My MariaDB has no default sql_mode but oslo.db should be setting this, but in any case this seems more like a local oslo.db connection type of thing that I can track down myself, so most of the

Re: [openstack-dev] [nova] unit test migration failure specific to MySQL/MariaDB - 'uuid': used in a foreign key constraint 'block_device_mapping_instance_uuid_fkey'

working with sdague on IRC, the first thing I’m seeing is that my MariaDB server is disallowing a change in column that is UNIQUE and has an FK pointing to it, and this is distinctly different from a straight up MySQL server (see below). http://paste.openstack.org/raw/155896/ old school

Re: [openstack-dev] [nova] unit test migration failure specific to MySQL/MariaDB - 'uuid': used in a foreign key constraint 'block_device_mapping_instance_uuid_fkey'

On 1/6/2015 5:40 PM, Mike Bayer wrote: Hello - Victor Sergeyev and I are both observing the following test failure which occurs with all the tests underneath nova.tests.unit.db.test_migrations.TestNovaMigrationsMySQL.This is against master with a brand new tox environment and

[openstack-dev] [nova] unit test migration failure specific to MySQL/MariaDB - 'uuid': used in a foreign key constraint 'block_device_mapping_instance_uuid_fkey'

Hello - Victor Sergeyev and I are both observing the following test failure which occurs with all the tests underneath nova.tests.unit.db.test_migrations.TestNovaMigrationsMySQL.This is against master with a brand new tox environment and everything at the default. It does not seem to be