Skip to content

Instantly share code, notes, and snippets.

@nrb

nrb/expand_error Secret

Created June 15, 2017 21:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nrb/6f3788c333f717e601b0ded35137acee to your computer and use it in GitHub Desktop.
Save nrb/6f3788c333f717e601b0ded35137acee to your computer and use it in GitHub Desktop.
(glance-master) root@aio1-glance-container-b8b56a18:/openstack/venvs/glance-master# glance-manage db expand
/openstack/venvs/glance-master/lib/python2.7/site-packages/glance/cmd/manage.py:437: DeprecationWarning: Using the 'enforce_type' argument is deprecated in version '4.0' and will be removed in version '5.0': The argument enforce_type has changed its default value to True and then will be removed completely.
CONF.set_default(name='use_stderr', default=True, enforce_type=True)
/openstack/venvs/glance-master/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py:1325: OsloDBDeprecationWarning: EngineFacade is deprecated; please use oslo_db.sqlalchemy.enginefacade
expire_on_commit=expire_on_commit, _conf=conf)
INFO [alembic.runtime.migration] Context impl MySQLImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
INFO [alembic.runtime.migration] Running upgrade liberty -> mitaka01, add index on created_at and updated_at columns of 'images' table
CRITI [glance] Unhandled error
Traceback (most recent call last):
File "/openstack/venvs/glance-master/bin/glance-manage", line 11, in <module>
sys.exit(main())
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/glance/cmd/manage.py", line 464, in main
return CONF.command.action_fn(*func_args, **func_kwargs)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/glance/cmd/manage.py", line 144, in expand
self.sync(version=expand_head)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/glance/cmd/manage.py", line 120, in sync
alembic_command.upgrade(a_config, version)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/alembic/command.py", line 254, in upgrade
script.run_env()
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/alembic/script/base.py", line 421, in run_env
util.load_python_file(self.dir, 'env.py')
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file
module = load_module_py(module_id, path)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/alembic/util/compat.py", line 75, in load_module_py
mod = imp.load_source(module_id, path, fp)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/glance/db/sqlalchemy/alembic_migrations/env.py", line 89, in <module>
run_migrations_online()
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/glance/db/sqlalchemy/alembic_migrations/env.py", line 84, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/alembic/runtime/environment.py", line 817, in run_migrations
self.get_context().run_migrations(**kw)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/alembic/runtime/migration.py", line 329, in run_migrations
step.migration_fn(**kw)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/glance/db/sqlalchemy/alembic_migrations/versions/mitaka01_add_image_created_updated_idx.py", line 45, in upgrade
created_index.create(migrate_engine)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/sql/schema.py", line 3398, in create
bind._run_visitor(ddl.SchemaGenerator, self)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1538, in _run_visitor
**kwargs).traverse_single(element)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 791, in visit_index
self.connection.execute(CreateIndex(index))
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute
return meth(self, multiparams, params)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1002, in _execute_ddl
compiled
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
context)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
exc_info
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/connections.py", line 856, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/connections.py", line 1057, in _read_query_result
result.read()
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in read
first_packet = self.connection._read_packet()
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet
packet.check_error()
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error
err.raise_mysql_exception(self._data)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1061, u"Duplicate key name 'created_at_image_idx'") [SQL: u'CREATE INDEX created_at_image_idx ON images (created_at)']
(glance-master) root@aio1-glance-container-b8b56a18:/openstack/venvs/glance-master#
(glance-master) root@aio1-glance-container-b8b56a18:/openstack/venvs/glance-master# glance-manage db sync
/openstack/venvs/glance-master/lib/python2.7/site-packages/glance/cmd/manage.py:437: DeprecationWarning: Using the 'enforce_type' argument is deprecated in version '4.0' and will be removed in version '5.0': The argument enforce_type has changed its default value to True and then will be removed completely.
CONF.set_default(name='use_stderr', default=True, enforce_type=True)
/openstack/venvs/glance-master/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py:1325: OsloDBDeprecationWarning: EngineFacade is deprecated; please use oslo_db.sqlalchemy.enginefacade
expire_on_commit=expire_on_commit, _conf=conf)
INFO [alembic.runtime.migration] Context impl MySQLImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
INFO [alembic.runtime.migration] Running upgrade liberty -> mitaka01, add index on created_at and updated_at columns of 'images' table
CRITI [glance] Unhandled error
Traceback (most recent call last):
File "/openstack/venvs/glance-master/bin/glance-manage", line 11, in <module>
sys.exit(main())
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/glance/cmd/manage.py", line 464, in main
return CONF.command.action_fn(*func_args, **func_kwargs)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/glance/cmd/manage.py", line 120, in sync
alembic_command.upgrade(a_config, version)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/alembic/command.py", line 254, in upgrade
script.run_env()
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/alembic/script/base.py", line 421, in run_env
util.load_python_file(self.dir, 'env.py')
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file
module = load_module_py(module_id, path)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/alembic/util/compat.py", line 75, in load_module_py
mod = imp.load_source(module_id, path, fp)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/glance/db/sqlalchemy/alembic_migrations/env.py", line 89, in <module>
run_migrations_online()
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/glance/db/sqlalchemy/alembic_migrations/env.py", line 84, in run_migrations_online
context.run_migrations()
File "<string>", line 8, in run_migrations
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/alembic/runtime/environment.py", line 817, in run_migrations
self.get_context().run_migrations(**kw)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/alembic/runtime/migration.py", line 329, in run_migrations
step.migration_fn(**kw)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/glance/db/sqlalchemy/alembic_migrations/versions/mitaka01_add_image_created_updated_idx.py", line 45, in upgrade
created_index.create(migrate_engine)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/sql/schema.py", line 3398, in create
bind._run_visitor(ddl.SchemaGenerator, self)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1538, in _run_visitor
**kwargs).traverse_single(element)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 791, in visit_index
self.connection.execute(CreateIndex(index))
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 945, in execute
return meth(self, multiparams, params)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1002, in _execute_ddl
compiled
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1189, in _execute_context
context)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1402, in _handle_dbapi_exception
exc_info
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context
context)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 470, in do_execute
cursor.execute(statement, parameters)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute
result = self._query(query)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query
conn.query(q)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/connections.py", line 856, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/connections.py", line 1057, in _read_query_result
result.read()
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/connections.py", line 1340, in read
first_packet = self.connection._read_packet()
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/connections.py", line 1014, in _read_packet
packet.check_error()
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error
err.raise_mysql_exception(self._data)
File "/openstack/venvs/glance-master/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (pymysql.err.InternalError) (1061, u"Duplicate key name 'created_at_image_idx'") [SQL: u'CREATE INDEX created_at_image_idx ON images (created_at)']
(glance-master) root@aio1-glance-container-b8b56a18:/openstack/venvs/glance-master#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment