Test db_migrations doesn't work concurrently

Bug #1207750 reported by Joshua Hesketh
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
OpenStack Compute (nova)
Fix Released
Low
Joshua Hesketh

Bug Description

When running with alternative test_migrations.conf odd errors occur.

For example, with just mysql tests often the database/tables disappear pre-maturely:

ProgrammingError: (ProgrammingError) (1146, "Table 'test_migrations.migrate_version' doesn't exist") 'SELECT migrate_version.repository_id, migrate_version.repository_path, migrate_version.version \nFROM migrate_version \nWHERE migrate_version.repository_id = %s' ('nova',)

With both sqlite and mysql it sometimes actually works. Possibly this is due to race conditions.

Tags: db
Changed in nova:
assignee: nobody → Joshua Hesketh (joshua.hesketh)
description: updated
Matt Riedemann (mriedem)
tags: added: db
Michael Still (mikal)
Changed in nova:
status: New → Triaged
importance: Undecided → Low
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to nova (master)

Fix proposed to branch: master
Review: https://review.openstack.org/40137

Changed in nova:
status: Triaged → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to nova (master)

Reviewed: https://review.openstack.org/40137
Committed: http://github.com/openstack/nova/commit/cf99852f51f95bcf60c99df7190841ffff3337cb
Submitter: Jenkins
Branch: master

commit cf99852f51f95bcf60c99df7190841ffff3337cb
Author: Joshua Hesketh <email address hidden>
Date: Sat Aug 3 00:09:08 2013 +1000

    Fix tests to work with mysql+postgres concurrently

    Optimise tests.db.test_migrations and tests.db.test_migration_utils for
    concurrency and make opportunistic tests obey walk_style configurations.

    Closes-Bug: 1207750

    Change-Id: Idb30f144fb67aefc58749897d774103c3c0ec640

Changed in nova:
status: In Progress → Fix Committed
Changed in nova:
milestone: none → icehouse-1
Thierry Carrez (ttx)
Changed in nova:
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in nova:
milestone: icehouse-1 → 2014.1
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

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