*** This bug is a duplicate of bug 1368391 ***
https://bugs.launchpad.net/bugs/1368391
Fixed with this instead: https://review.openstack.org/#/c/121517/
** This bug has been marked a duplicate of bug 1368391
sqlalchemy-migrate 0.9.2 is breaking nova unit tests
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Glance.
https://bugs.launchpad.net/bugs/1404933
Title:
0.9.2 breaks glance migration 006
Status in OpenStack Image Registry and Delivery Service (Glance):
Invalid
Status in Database schema migration for SQLAlchemy:
In Progress
Bug description:
Just tried a Delorean package built against 0.9.2. It looks like
93ae21007d0100332a5751fc58f7616ced775ef9 (SqlScript: execute multiple
statements one by one) breaks a very old glance 006 migration.
2014-12-22 15:56:08.059 11110 ERROR migrate.versioning.script.sql [-] SQL
script
/usr/lib/python2.7/site-packages/glance/db/sqlalchemy/migrate_repo/versions/006_mysql_upgrade.sql
failed: (OperationalError) (1065, 'Query was empty') '\n' ()
2014-12-22 15:56:08.060 11110 CRITICAL glance [-] OperationalError:
(OperationalError) (1065, 'Query was empty') '\n' ()
2014-12-22 15:56:08.060 11110 TRACE glance Traceback (most recent call last):
2014-12-22 15:56:08.060 11110 TRACE glance File "/usr/bin/glance-manage",
line 10, in <module>
2014-12-22 15:56:08.060 11110 TRACE glance sys.exit(main())
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib/python2.7/site-packages/glance/cmd/manage.py", line 281, in main
2014-12-22 15:56:08.060 11110 TRACE glance return CONF.command.action_fn()
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib/python2.7/site-packages/glance/cmd/manage.py", line 157, in sync
2014-12-22 15:56:08.060 11110 TRACE glance CONF.command.current_version)
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib/python2.7/site-packages/glance/cmd/manage.py", line 115, in sync
2014-12-22 15:56:08.060 11110 TRACE glance version)
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/migration.py", line 79, in
db_sync
2014-12-22 15:56:08.060 11110 TRACE glance return
versioning_api.upgrade(engine, repository, version)
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in
upgrade
2014-12-22 15:56:08.060 11110 TRACE glance return _migrate(url,
repository, version, upgrade=True, err=err, **opts)
2014-12-22 15:56:08.060 11110 TRACE glance File "<string>", line 2, in
_migrate
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line
160, in with_engine
2014-12-22 15:56:08.060 11110 TRACE glance return f(*a, **kw)
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in
_migrate
2014-12-22 15:56:08.060 11110 TRACE glance schema.runchange(ver, change,
changeset.step)
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in
runchange
2014-12-22 15:56:08.060 11110 TRACE glance change.run(self.engine, step)
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib/python2.7/site-packages/migrate/versioning/script/sql.py", line 45,
in run
2014-12-22 15:56:08.060 11110 TRACE glance conn.execute(statement)
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 721, in
execute
2014-12-22 15:56:08.060 11110 TRACE glance return
self._execute_text(object, multiparams, params)
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 870, in
_execute_text
2014-12-22 15:56:08.060 11110 TRACE glance statement, parameters
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in
_execute_context
2014-12-22 15:56:08.060 11110 TRACE glance context)
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1156, in
_handle_dbapi_exception
2014-12-22 15:56:08.060 11110 TRACE glance
util.raise_from_cause(newraise, exc_info)
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in
raise_from_cause
2014-12-22 15:56:08.060 11110 TRACE glance reraise(type(exception),
exception, tb=exc_tb)
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in
_execute_context
2014-12-22 15:56:08.060 11110 TRACE glance context)
2014-12-22 15:56:08.060 11110 TRACE glance File
"/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in
do_execute
2014-12-22 15:56:08.060 11110 TRACE glance cursor.execute(statement,
parameters)
To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1404933/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
