Action performed: - tree updated from e48fbd8 to 9b77e13 - $ manila-manage db sync Got: $ manila-manage db sync No handlers could be found for logger "oslo_config.cfg" 2015-08-27 18:25:22.154 DEBUG manila.utils [-] backend from (pid=12711) __get_backend /opt/stack/manila/manila/utils.py:173 2015-08-27 18:25:22.217 DEBUG oslo_db.sqlalchemy.engines [-] MySQL server mode set to STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION from (pid=12711) _check_effective_sql_mode /usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py:256 2015-08-27 18:25:22.223 INFO alembic.runtime.migration [-] Context impl MySQLImpl. 2015-08-27 18:25:22.224 INFO alembic.runtime.migration [-] Will assume non-transactional DDL. 2015-08-27 18:25:22.248 INFO alembic.runtime.migration [-] Running upgrade 5077ffcc5f1c -> 579c267fbb4d, add_share_instances_access_map 2015-08-27 18:25:22.739 DEBUG alembic.runtime.migration [-] update 5077ffcc5f1c to 579c267fbb4d from (pid=12711) update_to_step /usr/lib/python2.7/site-packages/alembic/runtime/migration.py:499 2015-08-27 18:25:22.753 INFO alembic.runtime.migration [-] Running upgrade 579c267fbb4d -> 1f0bd302c1a6, add_availability_zones_table 2015-08-27 18:25:24.45 CRITICAL manila [-] DBDuplicateEntry: (pymysql.err.IntegrityError) (1062, u"Duplicate entry 'nova-False' for key 'az_name_uc'") [SQL: u'INSERT INTO availability_zones (created_at, deleted, id, name) VALUES (%s, %s, %s, %s)'] [parameters: ((datetime.datetime(2015, 8, 27, 18, 25, 23, 978815), 'False', 'b6b489bf-4ac8-4c3b-abb0-42f4eb5f4373', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 978912), 'False', '01fbbe32-c9b0-4f96-a845-1af3ecfc3527', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979013), 'False', '2f321348-bdee-45bd-bc70-a07a037d494e', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979098), 'False', '36c805f3-f0ae-4083-a77d-a9db0d49600c', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979202), 'False', '691ee1b1-25d4-4664-b298-494229dc975c', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979297), 'False', '8cb3a720-ca3f-47f7-83bb-8c6cb9e377e9', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979389), 'False', '6fc85a21-5d32-40eb-992c-24c48a56ab4e', u'nova'))] 2015-08-27 18:25:24.45 TRACE manila Traceback (most recent call last): 2015-08-27 18:25:24.45 TRACE manila File "/usr/bin/manila-manage", line 10, in 2015-08-27 18:25:24.45 TRACE manila sys.exit(main()) 2015-08-27 18:25:24.45 TRACE manila File "/opt/stack/manila/manila/cmd/manage.py", line 448, in main 2015-08-27 18:25:24.45 TRACE manila fn(*fn_args) 2015-08-27 18:25:24.45 TRACE manila File "/opt/stack/manila/manila/cmd/manage.py", line 212, in sync 2015-08-27 18:25:24.45 TRACE manila return migration.upgrade(version) 2015-08-27 18:25:24.45 TRACE manila File "/opt/stack/manila/manila/db/migration.py", line 28, in upgrade 2015-08-27 18:25:24.45 TRACE manila return IMPL.upgrade(version) 2015-08-27 18:25:24.45 TRACE manila File "/opt/stack/manila/manila/db/migrations/alembic/migration.py", line 51, in upgrade 2015-08-27 18:25:24.45 TRACE manila return alembic.command.upgrade(_alembic_config(), revision or 'head') 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/alembic/command.py", line 174, in upgrade 2015-08-27 18:25:24.45 TRACE manila script.run_env() 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/alembic/script/base.py", line 397, in run_env 2015-08-27 18:25:24.45 TRACE manila util.load_python_file(self.dir, 'env.py') 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 81, in load_python_file 2015-08-27 18:25:24.45 TRACE manila module = load_module_py(module_id, path) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/alembic/util/compat.py", line 79, in load_module_py 2015-08-27 18:25:24.45 TRACE manila mod = imp.load_source(module_id, path, fp) 2015-08-27 18:25:24.45 TRACE manila File "/opt/stack/manila/manila/db/migrations/alembic/env.py", line 41, in 2015-08-27 18:25:24.45 TRACE manila run_migrations_online() 2015-08-27 18:25:24.45 TRACE manila File "/opt/stack/manila/manila/db/migrations/alembic/env.py", line 36, in run_migrations_online 2015-08-27 18:25:24.45 TRACE manila context.run_migrations() # pylint: disable=E1101 2015-08-27 18:25:24.45 TRACE manila File "", line 8, in run_migrations 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/alembic/runtime/environment.py", line 788, in run_migrations 2015-08-27 18:25:24.45 TRACE manila self.get_context().run_migrations(**kw) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/alembic/runtime/migration.py", line 312, in run_migrations 2015-08-27 18:25:24.45 TRACE manila step.migration_fn(**kw) 2015-08-27 18:25:24.45 TRACE manila File "/opt/stack/manila/manila/db/migrations/alembic/versions/1f0bd302c1a6_add_availability_zones_table.py", line 78, in upgrade 2015-08-27 18:25:24.45 TRACE manila connection, services_table, availability_zones_table) 2015-08-27 18:25:24.45 TRACE manila File "/opt/stack/manila/manila/db/migrations/alembic/versions/1f0bd302c1a6_add_availability_zones_table.py", line 46, in collect_existing_az_from_services_table 2015-08-27 18:25:24.45 TRACE manila op.bulk_insert(az_table, existing_services) 2015-08-27 18:25:24.45 TRACE manila File "", line 8, in bulk_insert 2015-08-27 18:25:24.45 TRACE manila File "", line 3, in bulk_insert 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/alembic/operations/ops.py", line 1748, in bulk_insert 2015-08-27 18:25:24.45 TRACE manila operations.invoke(op) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/alembic/operations/base.py", line 318, in invoke 2015-08-27 18:25:24.45 TRACE manila return fn(self, operation) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/alembic/operations/toimpl.py", line 154, in bulk_insert 2015-08-27 18:25:24.45 TRACE manila operation.table, operation.rows, multiinsert=operation.multiinsert) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/alembic/ddl/impl.py", line 232, in bulk_insert 2015-08-27 18:25:24.45 TRACE manila self._exec(table.insert(inline=True), multiparams=rows) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/alembic/ddl/impl.py", line 118, in _exec 2015-08-27 18:25:24.45 TRACE manila return conn.execute(construct, *multiparams, **params) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute 2015-08-27 18:25:24.45 TRACE manila return meth(self, multiparams, params) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection 2015-08-27 18:25:24.45 TRACE manila return connection._execute_clauseelement(self, multiparams, params) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement 2015-08-27 18:25:24.45 TRACE manila compiled_sql, distilled_params 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context 2015-08-27 18:25:24.45 TRACE manila context) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception 2015-08-27 18:25:24.45 TRACE manila util.raise_from_cause(newraise, exc_info) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause 2015-08-27 18:25:24.45 TRACE manila reraise(type(exception), exception, tb=exc_tb) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1116, in _execute_context 2015-08-27 18:25:24.45 TRACE manila context) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 95, in do_executemany 2015-08-27 18:25:24.45 TRACE manila rowcount = cursor.executemany(statement, parameters) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 155, in executemany 2015-08-27 18:25:24.45 TRACE manila self._get_db().encoding) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 190, in _do_execute_many 2015-08-27 18:25:24.45 TRACE manila rows += self.execute(sql + postfix) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 134, in execute 2015-08-27 18:25:24.45 TRACE manila result = self._query(query) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 282, in _query 2015-08-27 18:25:24.45 TRACE manila conn.query(q) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 768, in query 2015-08-27 18:25:24.45 TRACE manila self._affected_rows = self._read_query_result(unbuffered=unbuffered) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 929, in _read_query_result 2015-08-27 18:25:24.45 TRACE manila result.read() 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1125, in read 2015-08-27 18:25:24.45 TRACE manila first_packet = self.connection._read_packet() 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 893, in _read_packet 2015-08-27 18:25:24.45 TRACE manila packet.check_error() 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 369, in check_error 2015-08-27 18:25:24.45 TRACE manila err.raise_mysql_exception(self._data) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 120, in raise_mysql_exception 2015-08-27 18:25:24.45 TRACE manila _check_mysql_exception(errinfo) 2015-08-27 18:25:24.45 TRACE manila File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 112, in _check_mysql_exception 2015-08-27 18:25:24.45 TRACE manila raise errorclass(errno, errorvalue) 2015-08-27 18:25:24.45 TRACE manila DBDuplicateEntry: (pymysql.err.IntegrityError) (1062, u"Duplicate entry 'nova-False' for key 'az_name_uc'") [SQL: u'INSERT INTO availability_zones (created_at, deleted, id, name) VALUES (%s, %s, %s, %s)'] [parameters: ((datetime.datetime(2015, 8, 27, 18, 25, 23, 978815), 'False', 'b6b489bf-4ac8-4c3b-abb0-42f4eb5f4373', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 978912), 'False', '01fbbe32-c9b0-4f96-a845-1af3ecfc3527', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979013), 'False', '2f321348-bdee-45bd-bc70-a07a037d494e', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979098), 'False', '36c805f3-f0ae-4083-a77d-a9db0d49600c', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979202), 'False', '691ee1b1-25d4-4664-b298-494229dc975c', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979297), 'False', '8cb3a720-ca3f-47f7-83bb-8c6cb9e377e9', u'nova'), (datetime.datetime(2015, 8, 27, 18, 25, 23, 979389), 'False', '6fc85a21-5d32-40eb-992c-24c48a56ab4e', u'nova'))] 2015-08-27 18:25:24.45 TRACE manila