sqlalchemy migrate 0.8.4 unconditionally requires db2

[Sean Dague]

sqlalchemy 0.8.4 was released with broken db2 support, so it always requires db2, even when not using db2. This is very bad.

Logstash query for it - http://logstash.openstack.org/#eyJzZWFyY2giOiJtZXNzYWdlOlwiSW1wb3J0RXJyb3I6IE5vIG1vZHVsZSBuYW1lZCBpYm1fZGJfc2FcIiBBTkQgKGZpbGVuYW1lOmNvbnNvbGUuaHRtbCBPUiBmaWxlbmFtZTpcImxvZ3MvZGV2c3RhY2tsb2cudHh0XCIpIiwiZmllbGRzIjpbXSwib2Zmc2V0IjowLCJ0aW1lZnJhbWUiOiI2MDQ4MDAiLCJncmFwaG1vZGUiOiJjb3VudCIsInRpbWUiOnsidXNlcl9pbnRlcnZhbCI6MH0sInN0YW1wIjoxMzkzODYwODI4OTU4fQ==

[OpenStack Infra (hudson-openstack)]

Related fix proposed to branch: master
Review: https://review.openstack.org/77618

[Anita Kuno (anteaya)]

http://git.openstack.org/cgit/stackforge/sqlalchemy-migrate/commit/?id=21fcdad0f485437d010e5743626c63ab3acdaec5

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/77618
Committed: https://git.openstack.org/cgit/openstack-infra/elastic-recheck/commit/?id=614c1da8956e88ff6a83e5be2ab1cd2397664606
Submitter: Jenkins
Branch: master

commit 614c1da8956e88ff6a83e5be2ab1cd2397664606
Author: Sean Dague <email address hidden>
Date: Mon Mar 3 10:35:42 2014 -0500

    add query for migrate db2 error

    Change-Id: I500cd54ba56b6211768362e78394f97edb0fec79
    Related-Bug: #1287229

[Matt Riedemann (mriedem)]

http://logs.openstack.org/67/40467/77/check/check-tempest-dsvm-postgres-full/97f5031/logs/devstacklog.txt.gz

2014-03-03 15:35:06.599 | + /opt/stack/new/keystone/bin/keystone-manage db_sync
2014-03-03 15:35:06.603 | Traceback (most recent call last):
2014-03-03 15:35:06.608 | File "/opt/stack/new/keystone/bin/keystone-manage", line 36, in <module>
2014-03-03 15:35:06.612 | from keystone import cli
2014-03-03 15:35:06.616 | File "/opt/stack/new/keystone/keystone/cli.py", line 19, in <module>
2014-03-03 15:35:06.620 | from migrate import exceptions
2014-03-03 15:35:06.625 | File "/usr/local/lib/python2.7/dist-packages/migrate/__init__.py", line 11, in <module>
2014-03-03 15:35:06.629 | from migrate.changeset import *
2014-03-03 15:35:06.633 | File "/usr/local/lib/python2.7/dist-packages/migrate/changeset/__init__.py", line 22, in <module>
2014-03-03 15:35:06.638 | from migrate.changeset.schema import *
2014-03-03 15:35:06.642 | File "/usr/local/lib/python2.7/dist-packages/migrate/changeset/schema.py", line 15, in <module>
2014-03-03 15:35:06.646 | from migrate.changeset.databases.visitor import (get_engine_visitor,
2014-03-03 15:35:06.650 | File "/usr/local/lib/python2.7/dist-packages/migrate/changeset/databases/visitor.py", line 7, in <module>
2014-03-03 15:35:06.655 | from migrate.changeset.databases import (sqlite,
2014-03-03 15:35:06.659 | File "/usr/local/lib/python2.7/dist-packages/migrate/changeset/databases/ibmdb2.py", line 7, in <module>
2014-03-03 15:35:06.663 | from ibm_db_sa import base
2014-03-03 15:35:06.668 | ImportError: No module named ibm_db_sa

[Matt Riedemann (mriedem)]

sqlalchemy-migrate patch is here: https://review.openstack.org/#/c/77669/

[OpenStack Infra (hudson-openstack)]

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

[Matt Riedemann (mriedem)]

Infra patch to try and get tempest to run against sqlalchemy-migrate changes: https://review.openstack.org/#/c/77679/

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/77669
Committed: https://git.openstack.org/cgit/stackforge/sqlalchemy-migrate/commit/?id=12a6bcfa8c1ead90f22135ea7ab75352ed06d6b2
Submitter: Jenkins
Branch: master

commit 12a6bcfa8c1ead90f22135ea7ab75352ed06d6b2
Author: Matt Riedemann <email address hidden>
Date: Mon Mar 3 10:31:52 2014 -0800

    Conditionally import ibmdb2/ibm_db_sa

    Since ibm_db_sa is not part of sqlalchemy, we need to handle the
    conditional import of the module in visitor.py so we don't get an
    ImportError if ibm_db_sa is not available.

    Closes-Bug: #1287229

    Change-Id: Ida070b629ce3b9be727ae49973bb6a71543c1dcf