Same problem here New installation of Glance Ocata MariaDB: 10.2.7 OS: CentOS 7.3 The workaround was downgrade to MariaDB 10.1.25 Error: [root@controller01 ~]# su -s /bin/sh -c "glance-manage db_sync" glance Option "verbose" from group "DEFAULT" is deprecated for removal. Its value may be silently ignored in the future. /usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py:1241: 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, liberty initial INFO [alembic.runtime.migration] Running upgrade liberty -> mitaka01, add index on created_at and updated_at columns of 'images' table /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py:3000: SAWarning: Unknown schema content: u' CONSTRAINT `CONSTRAINT_1` CHECK (`is_public` in (0,1)),' util.warn("Unknown schema content: %r" % line) /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py:3000: SAWarning: Unknown schema content: u' CONSTRAINT `CONSTRAINT_2` CHECK (`deleted` in (0,1)),' util.warn("Unknown schema content: %r" % line) /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py:3000: SAWarning: Unknown schema content: u' CONSTRAINT `CONSTRAINT_3` CHECK (`protected` in (0,1))' util.warn("Unknown schema content: %r" % line) INFO [alembic.runtime.migration] Running upgrade mitaka01 -> mitaka02, update metadef os_nova_server /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py:3000: SAWarning: Unknown schema content: u' CONSTRAINT `CONSTRAINT_1` CHECK (`protected` in (0,1))' util.warn("Unknown schema content: %r" % line) INFO [alembic.runtime.migration] Running upgrade mitaka02 -> ocata01, add visibility to and remove is_public from images /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py:3000: SAWarning: Unknown schema content: u' CONSTRAINT `CONSTRAINT_1` CHECK (`is_public` in (0,1)),' util.warn("Unknown schema content: %r" % line) /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py:3000: SAWarning: Unknown schema content: u' CONSTRAINT `CONSTRAINT_2` CHECK (`deleted` in (0,1)),' util.warn("Unknown schema content: %r" % line) /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py:3000: SAWarning: Unknown schema content: u' CONSTRAINT `CONSTRAINT_3` CHECK (`protected` in (0,1))' util.warn("Unknown schema content: %r" % line) /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py:3000: SAWarning: Unknown schema content: u' CONSTRAINT `CONSTRAINT_1` CHECK (`can_share` in (0,1)),' util.warn("Unknown schema content: %r" % line) /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/mysql/base.py:3000: SAWarning: Unknown schema content: u' CONSTRAINT `CONSTRAINT_2` CHECK (`deleted` in (0,1))' util.warn("Unknown schema content: %r" % line) CRITI [glance] InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'is_public' in 'CHECK'") [SQL: u'ALTER TABLE images DROP COLUMN is_public'] Traceback (most recent call last): File "/usr/bin/glance-manage", line 10, in sys.exit(main()) File "/usr/lib/python2.7/site-packages/glance/cmd/manage.py", line 447, in main return CONF.command.action_fn() File "/usr/lib/python2.7/site-packages/glance/cmd/manage.py", line 286, in sync self.command_object.sync(CONF.command.version) File "/usr/lib/python2.7/site-packages/glance/cmd/manage.py", line 119, in sync alembic_command.upgrade(a_config, version) File "/usr/lib/python2.7/site-packages/alembic/command.py", line 174, in upgrade script.run_env() File "/usr/lib/python2.7/site-packages/alembic/script/base.py", line 407, in run_env util.load_python_file(self.dir, 'env.py') File "/usr/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file module = load_module_py(module_id, path) File "/usr/lib/python2.7/site-packages/alembic/util/compat.py", line 79, in load_module_py mod = imp.load_source(module_id, path, fp) File "/usr/lib/python2.7/site-packages/glance/db/sqlalchemy/alembic_migrations/env.py", line 92, in run_migrations_online() File "/usr/lib/python2.7/site-packages/glance/db/sqlalchemy/alembic_migrations/env.py", line 87, in run_migrations_online context.run_migrations() File "", line 8, in run_migrations File "/usr/lib/python2.7/site-packages/alembic/runtime/environment.py", line 797, in run_migrations self.get_context().run_migrations(**kw) File "/usr/lib/python2.7/site-packages/alembic/runtime/migration.py", line 312, in run_migrations step.migration_fn(**kw) File "/usr/lib/python2.7/site-packages/glance/db/sqlalchemy/alembic_migrations/versions/ocata01_add_visibility_remove_is_public.py", line 72, in upgrade op.drop_column('images', 'is_public') File "", line 8, in drop_column File "", line 3, in drop_column File "/usr/lib/python2.7/site-packages/alembic/operations/ops.py", line 1637, in drop_column return operations.invoke(op) File "/usr/lib/python2.7/site-packages/alembic/operations/base.py", line 318, in invoke return fn(self, operation) File "/usr/lib/python2.7/site-packages/alembic/operations/toimpl.py", line 81, in drop_column **operation.kw File "/usr/lib/python2.7/site-packages/alembic/ddl/impl.py", line 175, in drop_column self._exec(base.DropColumn(table_name, column, schema=schema)) File "/usr/lib/python2.7/site-packages/alembic/ddl/impl.py", line 118, in _exec return conn.execute(construct, *multiparams, **params) File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute return meth(self, multiparams, params) File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection return connection._execute_ddl(self, multiparams, params) File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl compiled File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context context) File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception exc_info File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause reraise(type(exception), exception, tb=exc_tb) File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute result = self._query(query) File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query conn.query(q) File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 841, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1029, in _read_query_result result.read() File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1312, in read first_packet = self.connection._read_packet() File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 991, in _read_packet packet.check_error() File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error err.raise_mysql_exception(self._data) File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception raise errorclass(errno, errval) InternalError: (pymysql.err.InternalError) (1054, u"Unknown column 'is_public' in 'CHECK'") [SQL: u'ALTER TABLE images DROP COLUMN is_public']