Gnocchi

  1. Bug #1670645
  2. Activity log

Activity log for bug #1670645

Date Who What changed Old value New value Message
2017-03-07 11:22:21 Aaron DH bug added bug
2017-03-07 12:17:47 Aaron DH description 2017-03-07 19:18:00.920 17477 ERROR gnocchi Traceback (most recent call last): 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/bin/gnocchi-upgrade", line 10, in <module> 2017-03-07 19:18:00.920 17477 ERROR gnocchi sys.exit(upgrade()) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/opt/stack/gnocchi/gnocchi/cli.py", line 68, in upgrade 2017-03-07 19:18:00.920 17477 ERROR gnocchi create_legacy_resource_types=conf.create_legacy_resource_types) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/opt/stack/gnocchi/gnocchi/indexer/sqlalchemy.py", line 314, in upgrade 2017-03-07 19:18:00.920 17477 ERROR gnocchi Base.metadata.create_all(connection) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 3762, in create_all 2017-03-07 19:18:00.920 17477 ERROR gnocchi tables=tables) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1481, in _run_visitor 2017-03-07 19:18:00.920 17477 ERROR gnocchi **kwargs).traverse_single(element) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single 2017-03-07 19:18:00.920 17477 ERROR gnocchi return meth(obj, **kw) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 730, in visit_metadata 2017-03-07 19:18:00.920 17477 ERROR gnocchi _is_metadata_operation=True) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single 2017-03-07 19:18:00.920 17477 ERROR gnocchi return meth(obj, **kw) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 764, in visit_table 2017-03-07 19:18:00.920 17477 ERROR gnocchi include_foreign_key_constraints=include_foreign_key_constraints 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute 2017-03-07 19:18:00.920 17477 ERROR gnocchi return meth(self, multiparams, params) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection 2017-03-07 19:18:00.920 17477 ERROR gnocchi return connection._execute_ddl(self, multiparams, params) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl 2017-03-07 19:18:00.920 17477 ERROR gnocchi compiled 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context 2017-03-07 19:18:00.920 17477 ERROR gnocchi context) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception 2017-03-07 19:18:00.920 17477 ERROR gnocchi util.raise_from_cause(newraise, exc_info) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause 2017-03-07 19:18:00.920 17477 ERROR gnocchi reraise(type(exception), exception, tb=exc_tb, cause=cause) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context 2017-03-07 19:18:00.920 17477 ERROR gnocchi context) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute 2017-03-07 19:18:00.920 17477 ERROR gnocchi cursor.execute(statement, parameters) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute 2017-03-07 19:18:00.920 17477 ERROR gnocchi result = self._query(query) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query 2017-03-07 19:18:00.920 17477 ERROR gnocchi conn.query(q) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 852, in query 2017-03-07 19:18:00.920 17477 ERROR gnocchi self._affected_rows = self._read_query_result(unbuffered=unbuffered) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1053, in _read_query_result 2017-03-07 19:18:00.920 17477 ERROR gnocchi result.read() 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1336, in read 2017-03-07 19:18:00.920 17477 ERROR gnocchi first_packet = self.connection._read_packet() 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1010, in _read_packet 2017-03-07 19:18:00.920 17477 ERROR gnocchi packet.check_error() 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error 2017-03-07 19:18:00.920 17477 ERROR gnocchi err.raise_mysql_exception(self._data) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception 2017-03-07 19:18:00.920 17477 ERROR gnocchi raise errorclass(errno, errval) 2017-03-07 19:18:00.920 17477 ERROR gnocchi DBError: (pymysql.err.ProgrammingError) (1064, u"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, \n\tPRIMARY KEY (name), \n\tCONSTRAINT uniq_resource_type0tablename UN' at line 6") [SQL: u"\nCREATE TABLE resource_type (\n\tname VARCHAR(255) NOT NULL, \n\ttablename VARCHAR(35) NOT NULL, \n\tattributes TEXT, \n\tstate ENUM('active','creating','creation_error','deleting','deletion_error','updating','updating_error') NOT NULL DEFAULT 'creating', \n\tupdated_at DATETIME(6) NOT NULL, \n\tPRIMARY KEY (name), \n\tCONSTRAINT uniq_resource_type0tablename UNIQUE (tablename)\n)ENGINE=InnoDB CHARSET=utf8\n\n"] Execute gnocchi-upgrade still failed. it's bad in master and stable/3.1, ok in stable/3.0 2017-03-07 19:18:00.920 17477 ERROR gnocchi Traceback (most recent call last): 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/bin/gnocchi-upgrade", line 10, in <module> 2017-03-07 19:18:00.920 17477 ERROR gnocchi sys.exit(upgrade()) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/opt/stack/gnocchi/gnocchi/cli.py", line 68, in upgrade 2017-03-07 19:18:00.920 17477 ERROR gnocchi create_legacy_resource_types=conf.create_legacy_resource_types) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/opt/stack/gnocchi/gnocchi/indexer/sqlalchemy.py", line 314, in upgrade 2017-03-07 19:18:00.920 17477 ERROR gnocchi Base.metadata.create_all(connection) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 3762, in create_all 2017-03-07 19:18:00.920 17477 ERROR gnocchi tables=tables) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1481, in _run_visitor 2017-03-07 19:18:00.920 17477 ERROR gnocchi **kwargs).traverse_single(element) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single 2017-03-07 19:18:00.920 17477 ERROR gnocchi return meth(obj, **kw) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 730, in visit_metadata 2017-03-07 19:18:00.920 17477 ERROR gnocchi _is_metadata_operation=True) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single 2017-03-07 19:18:00.920 17477 ERROR gnocchi return meth(obj, **kw) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 764, in visit_table 2017-03-07 19:18:00.920 17477 ERROR gnocchi include_foreign_key_constraints=include_foreign_key_constraints 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute 2017-03-07 19:18:00.920 17477 ERROR gnocchi return meth(self, multiparams, params) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection 2017-03-07 19:18:00.920 17477 ERROR gnocchi return connection._execute_ddl(self, multiparams, params) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl 2017-03-07 19:18:00.920 17477 ERROR gnocchi compiled 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context 2017-03-07 19:18:00.920 17477 ERROR gnocchi context) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception 2017-03-07 19:18:00.920 17477 ERROR gnocchi util.raise_from_cause(newraise, exc_info) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause 2017-03-07 19:18:00.920 17477 ERROR gnocchi reraise(type(exception), exception, tb=exc_tb, cause=cause) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context 2017-03-07 19:18:00.920 17477 ERROR gnocchi context) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute 2017-03-07 19:18:00.920 17477 ERROR gnocchi cursor.execute(statement, parameters) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute 2017-03-07 19:18:00.920 17477 ERROR gnocchi result = self._query(query) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query 2017-03-07 19:18:00.920 17477 ERROR gnocchi conn.query(q) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 852, in query 2017-03-07 19:18:00.920 17477 ERROR gnocchi self._affected_rows = self._read_query_result(unbuffered=unbuffered) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1053, in _read_query_result 2017-03-07 19:18:00.920 17477 ERROR gnocchi result.read() 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1336, in read 2017-03-07 19:18:00.920 17477 ERROR gnocchi first_packet = self.connection._read_packet() 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1010, in _read_packet 2017-03-07 19:18:00.920 17477 ERROR gnocchi packet.check_error() 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error 2017-03-07 19:18:00.920 17477 ERROR gnocchi err.raise_mysql_exception(self._data) 2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception 2017-03-07 19:18:00.920 17477 ERROR gnocchi raise errorclass(errno, errval) 2017-03-07 19:18:00.920 17477 ERROR gnocchi DBError: (pymysql.err.ProgrammingError) (1064, u"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL, \n\tPRIMARY KEY (name), \n\tCONSTRAINT uniq_resource_type0tablename UN' at line 6") [SQL: u"\nCREATE TABLE resource_type (\n\tname VARCHAR(255) NOT NULL, \n\ttablename VARCHAR(35) NOT NULL, \n\tattributes TEXT, \n\tstate ENUM('active','creating','creation_error','deleting','deletion_error','updating','updating_error') NOT NULL DEFAULT 'creating', \n\tupdated_at DATETIME(6) NOT NULL, \n\tPRIMARY KEY (name), \n\tCONSTRAINT uniq_resource_type0tablename UNIQUE (tablename)\n)ENGINE=InnoDB CHARSET=utf8\n\n"] Execute gnocchi-upgrade still failed.
2017-03-07 13:10:24 Julien Danjou gnocchi: status New Incomplete