yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1434440] Re: glance db sync failed when using DB2

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>
Date: Fri, 04 Sep 2015 06:45:42 -0000
Reply-to: Bug 1434440 <1434440@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
** Changed in: glance
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Glance.
https://bugs.launchpad.net/bugs/1434440

Title:
  glance db sync failed when using DB2

Status in Glance:
  Fix Released

Bug description:
  The DB2 CI on nova project was blocked by glance db sync.

  Software versions:

  SQLAlchemy (0.9.8)
  sqlalchemy-migrate (0.9.5)
  ibm-db (2.0.4.1)
  ibm-db-alembic (0.1.0) with patch https://code.google.com/p/ibm-db/source/detail?r=74221d0d47a9aad3b1a28c9a5a5de41880136560&repo=ibm-db-alembic
  ibm-db-sa (0.3.2) with patch https://code.google.com/p/ibm-db/source/detail?r=f560ba1e0d8210c1498c3db35489eb471001749a&repo=ibm-db-sa


  2015-03-19 09:06:19.182 | 2015-03-19 17:06:19.182 13546 INFO migrate.versioning.api [-] 38 -> 39...
  2015-03-19 09:06:19.335 | 2015-03-19 17:06:19.332 13546 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (ProgrammingError) ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0669N  A system required index cannot be dropped explicitly.  SQLSTATE=42917 SQLCODE=-669 '\nDROP INDEX ix_namespaces_namespace' ()
  2015-03-19 09:06:19.335 | 2015-03-19 17:06:19.332 13546 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
  2015-03-19 09:06:19.335 | 2015-03-19 17:06:19.332 13546 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
  2015-03-19 09:06:19.335 | 2015-03-19 17:06:19.332 13546 TRACE oslo_db.sqlalchemy.exc_filters     context)
  2015-03-19 09:06:19.335 | 2015-03-19 17:06:19.332 13546 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/local/lib/python2.7/dist-packages/ibm_db_sa-0.3.2-py2.7.egg/ibm_db_sa/ibm_db.py", line 106, in do_execute
  2015-03-19 09:06:19.335 | 2015-03-19 17:06:19.332 13546 TRACE oslo_db.sqlalchemy.exc_filters     cursor.execute(statement, parameters)
  2015-03-19 09:06:19.335 | 2015-03-19 17:06:19.332 13546 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/local/lib/python2.7/dist-packages/ibm_db_dbi.py", line 1332, in execute
  2015-03-19 09:06:19.336 | 2015-03-19 17:06:19.332 13546 TRACE oslo_db.sqlalchemy.exc_filters     self._execute_helper(parameters)
  2015-03-19 09:06:19.336 | 2015-03-19 17:06:19.332 13546 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/local/lib/python2.7/dist-packages/ibm_db_dbi.py", line 1244, in _execute_helper
  2015-03-19 09:06:19.336 | 2015-03-19 17:06:19.332 13546 TRACE oslo_db.sqlalchemy.exc_filters     raise self.messages[len(self.messages) - 1]
  2015-03-19 09:06:19.336 | 2015-03-19 17:06:19.332 13546 TRACE oslo_db.sqlalchemy.exc_filters ProgrammingError: ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0669N  A system required index cannot be dropped explicitly.  SQLSTATE=42917 SQLCODE=-669
  2015-03-19 09:06:19.336 | 2015-03-19 17:06:19.332 13546 TRACE oslo_db.sqlalchemy.exc_filters
  2015-03-19 09:06:19.458 | 2015-03-19 17:06:19.342 13546 CRITICAL glance [-] DBError: (ProgrammingError) ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0669N  A system required index cannot be dropped explicitly.  SQLSTATE=42917 SQLCODE=-669 '\nDROP INDEX ix_namespaces_namespace' ()
  2015-03-19 09:06:19.459 | 2015-03-19 17:06:19.342 13546 TRACE glance Traceback (most recent call last):
  2015-03-19 09:06:19.459 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/bin/glance-manage", line 10, in <module>
  2015-03-19 09:06:19.460 | 2015-03-19 17:06:19.342 13546 TRACE glance     sys.exit(main())
  2015-03-19 09:06:19.460 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/opt/stack/new/glance/glance/cmd/manage.py", line 303, in main
  2015-03-19 09:06:19.460 | 2015-03-19 17:06:19.342 13546 TRACE glance     return CONF.command.action_fn()
  2015-03-19 09:06:19.460 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/opt/stack/new/glance/glance/cmd/manage.py", line 171, in sync
  2015-03-19 09:06:19.460 | 2015-03-19 17:06:19.342 13546 TRACE glance     CONF.command.current_version)
  2015-03-19 09:06:19.461 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/opt/stack/new/glance/glance/cmd/manage.py", line 116, in sync
  2015-03-19 09:06:19.461 | 2015-03-19 17:06:19.342 13546 TRACE glance     version)
  2015-03-19 09:06:19.461 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 79, in db_sync
  2015-03-19 09:06:19.461 | 2015-03-19 17:06:19.342 13546 TRACE glance     return versioning_api.upgrade(engine, repository, version)
  2015-03-19 09:06:19.461 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade
  2015-03-19 09:06:19.462 | 2015-03-19 17:06:19.342 13546 TRACE glance     return _migrate(url, repository, version, upgrade=True, err=err, **opts)
  2015-03-19 09:06:19.462 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "<string>", line 2, in _migrate
  2015-03-19 09:06:19.462 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 160, in with_engine
  2015-03-19 09:06:19.462 | 2015-03-19 17:06:19.342 13546 TRACE glance     return f(*a, **kw)
  2015-03-19 09:06:19.462 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate
  2015-03-19 09:06:19.462 | 2015-03-19 17:06:19.342 13546 TRACE glance     schema.runchange(ver, change, changeset.step)
  2015-03-19 09:06:19.462 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93, in runchange
  2015-03-19 09:06:19.462 | 2015-03-19 17:06:19.342 13546 TRACE glance     change.run(self.engine, step)
  2015-03-19 09:06:19.462 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 148, in run
  2015-03-19 09:06:19.462 | 2015-03-19 17:06:19.342 13546 TRACE glance     script_func(engine)
  2015-03-19 09:06:19.463 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/opt/stack/new/glance/glance/db/sqlalchemy/migrate_repo/versions/039_add_changes_to_satisfy_models_metadef.py", line 34, in upgrade
  2015-03-19 09:06:19.463 | 2015-03-19 17:06:19.342 13546 TRACE glance     Index('ix_namespaces_namespace', metadef_namespaces.c.namespace).drop()
  2015-03-19 09:06:19.463 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 2975, in drop
  2015-03-19 09:06:19.463 | 2015-03-19 17:06:19.342 13546 TRACE glance     bind._run_visitor(ddl.SchemaDropper, self)
  2015-03-19 09:06:19.463 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1616, in _run_visitor
  2015-03-19 09:06:19.463 | 2015-03-19 17:06:19.342 13546 TRACE glance     conn._run_visitor(visitorcallable, element, **kwargs)
  2015-03-19 09:06:19.463 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1245, in _run_visitor
  2015-03-19 09:06:19.463 | 2015-03-19 17:06:19.342 13546 TRACE glance     **kwargs).traverse_single(element)
  2015-03-19 09:06:19.463 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 120, in traverse_single
  2015-03-19 09:06:19.463 | 2015-03-19 17:06:19.342 13546 TRACE glance     return meth(obj, **kw)
  2015-03-19 09:06:19.464 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 813, in visit_index
  2015-03-19 09:06:19.464 | 2015-03-19 17:06:19.342 13546 TRACE glance     self.connection.execute(DropIndex(index))
  2015-03-19 09:06:19.464 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 729, in execute
  2015-03-19 09:06:19.464 | 2015-03-19 17:06:19.342 13546 TRACE glance     return meth(self, multiparams, params)
  2015-03-19 09:06:19.464 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 69, in _execute_on_connection
  2015-03-19 09:06:19.464 | 2015-03-19 17:06:19.342 13546 TRACE glance     return connection._execute_ddl(self, multiparams, params)
  2015-03-19 09:06:19.464 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 783, in _execute_ddl
  2015-03-19 09:06:19.464 | 2015-03-19 17:06:19.342 13546 TRACE glance     compiled
  2015-03-19 09:06:19.464 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
  2015-03-19 09:06:19.464 | 2015-03-19 17:06:19.342 13546 TRACE glance     context)
  2015-03-19 09:06:19.465 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/compat/handle_error.py", line 261, in _handle_dbapi_exception
  2015-03-19 09:06:19.465 | 2015-03-19 17:06:19.342 13546 TRACE glance     e, statement, parameters, cursor, context)
  2015-03-19 09:06:19.465 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1155, in _handle_dbapi_exception
  2015-03-19 09:06:19.465 | 2015-03-19 17:06:19.342 13546 TRACE glance     util.raise_from_cause(newraise, exc_info)
  2015-03-19 09:06:19.465 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
  2015-03-19 09:06:19.465 | 2015-03-19 17:06:19.342 13546 TRACE glance     reraise(type(exception), exception, tb=exc_tb)
  2015-03-19 09:06:19.465 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
  2015-03-19 09:06:19.465 | 2015-03-19 17:06:19.342 13546 TRACE glance     context)
  2015-03-19 09:06:19.465 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/ibm_db_sa-0.3.2-py2.7.egg/ibm_db_sa/ibm_db.py", line 106, in do_execute
  2015-03-19 09:06:19.465 | 2015-03-19 17:06:19.342 13546 TRACE glance     cursor.execute(statement, parameters)
  2015-03-19 09:06:19.466 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/ibm_db_dbi.py", line 1332, in execute
  2015-03-19 09:06:19.466 | 2015-03-19 17:06:19.342 13546 TRACE glance     self._execute_helper(parameters)
  2015-03-19 09:06:19.466 | 2015-03-19 17:06:19.342 13546 TRACE glance   File "/usr/local/lib/python2.7/dist-packages/ibm_db_dbi.py", line 1244, in _execute_helper
  2015-03-19 09:06:19.466 | 2015-03-19 17:06:19.342 13546 TRACE glance     raise self.messages[len(self.messages) - 1]
  2015-03-19 09:06:19.466 | 2015-03-19 17:06:19.342 13546 TRACE glance DBError: (ProgrammingError) ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0669N  A system required index cannot be dropped explicitly.  SQLSTATE=42917 SQLCODE=-669 '\nDROP INDEX ix_namespaces_namespace' ()
  2015-03-19 09:06:19.466 | 2015-03-19 17:06:19.342 13546 TRACE glance

To manage notifications about this bug go to:
https://bugs.launchpad.net/glance/+bug/1434440/+subscriptions
References

[Bug 1434440] [NEW] glance db sync failed when using DB2
From: Jun Hong Li, 2015-03-20