yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1404933] Re: 0.9.2 breaks glance migration 006

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Dan Prince <dprince@xxxxxxxxxx>
Date: Mon, 22 Dec 2014 16:56:46 -0000
Reply-to: Bug 1404933 <1404933@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
** Also affects: glance
   Importance: Undecided
       Status: New

-- 
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):
  New
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