gnocchi-upgrade failed
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Gnocchi |
Incomplete
|
Undecided
|
Unassigned |
Bug Description
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/
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/
2017-03-07 19:18:00.920 17477 ERROR gnocchi create_
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/opt/stack/
2017-03-07 19:18:00.920 17477 ERROR gnocchi Base.metadata.
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
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/
2017-03-07 19:18:00.920 17477 ERROR gnocchi **kwargs)
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
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/
2017-03-07 19:18:00.920 17477 ERROR gnocchi _is_metadata_
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
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/
2017-03-07 19:18:00.920 17477 ERROR gnocchi include_
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
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/
2017-03-07 19:18:00.920 17477 ERROR gnocchi return connection.
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
2017-03-07 19:18:00.920 17477 ERROR gnocchi compiled
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
2017-03-07 19:18:00.920 17477 ERROR gnocchi context)
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
2017-03-07 19:18:00.920 17477 ERROR gnocchi util.raise_
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
2017-03-07 19:18:00.920 17477 ERROR gnocchi reraise(
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
2017-03-07 19:18:00.920 17477 ERROR gnocchi context)
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
2017-03-07 19:18:00.920 17477 ERROR gnocchi cursor.
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
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/
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/
2017-03-07 19:18:00.920 17477 ERROR gnocchi self._affected_rows = self._read_
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
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/
2017-03-07 19:18:00.920 17477 ERROR gnocchi first_packet = self.connection
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
2017-03-07 19:18:00.920 17477 ERROR gnocchi packet.
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
2017-03-07 19:18:00.920 17477 ERROR gnocchi err.raise_
2017-03-07 19:18:00.920 17477 ERROR gnocchi File "/usr/local/
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.
Execute gnocchi-upgrade still failed.
Let me guess: you are using an ancient MySQL version.
Resolution: use PostgreSQL or upgrade to MySQL least 5.6. We're in 2017. ;-)