Running
barbican-manage db upgrade fails with the following traceback when the DB is mysql8:
2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last): 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1245, in _execute_context 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters self.dialect.do_execute( 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 581, in do_execute 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters) 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query) 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q) 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered) 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters result.read() 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1075, in read 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet() 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error() 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data) 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval) 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters pymysql.err.InternalError: (3959, "Check constraint 'secret_acls_chk_2' uses column 'creator_only', hence column cannot be dropped or renamed.") 2020-10-08 22:31:32.028 28131 ERROR oslo_db.sqlalchemy.exc_filters ERROR: (pymysql.err.InternalError) (3959, "Check constraint 'secret_acls_chk_2' uses column 'creator_only', hence column cannot be dropped or renamed.") [SQL: ALTER TABLE secret_acls CHANGE creator_only project_access BOOL NULL]
Seems this is a known issue with alembic [0]
[1] https://github.com/sqlalchemy/alembic/issues/699
Running
barbican-manage db upgrade fails with the following traceback when the DB is mysql8:
2020-10-08 22:31:32.028 28131 ERROR oslo_db. sqlalchemy. exc_filters Traceback (most recent call last): sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ sqlalchemy/ engine/ base.py" , line 1245, in _execute_context sqlalchemy. exc_filters self.dialect. do_execute( sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ sqlalchemy/ engine/ default. py", line 581, in do_execute sqlalchemy. exc_filters cursor. execute( statement, parameters) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ cursors. py", line 170, in execute sqlalchemy. exc_filters result = self._query(query) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ cursors. py", line 328, in _query sqlalchemy. exc_filters conn.query(q) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ connections. py", line 517, in query sqlalchemy. exc_filters self._affected_rows = self._read_ query_result( unbuffered= unbuffered) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ connections. py", line 732, in _read_query_result sqlalchemy. exc_filters result.read() sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ connections. py", line 1075, in read sqlalchemy. exc_filters first_packet = self.connection ._read_ packet( ) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ connections. py", line 684, in _read_packet sqlalchemy. exc_filters packet. check_error( ) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ protocol. py", line 220, in check_error sqlalchemy. exc_filters err.raise_ mysql_exception (self._ data) sqlalchemy. exc_filters File "/usr/lib/ python3/ dist-packages/ pymysql/ err.py" , line 109, in raise_mysql_ exception sqlalchemy. exc_filters raise errorclass(errno, errval) sqlalchemy. exc_filters pymysql. err.InternalErr or: (3959, "Check constraint 'secret_acls_chk_2' uses column 'creator_only', hence column cannot be dropped or renamed.") sqlalchemy. exc_filters err.InternalErr or) (3959, "Check constraint 'secret_acls_chk_2' uses column 'creator_only', hence column cannot be dropped or renamed.")
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
2020-10-08 22:31:32.028 28131 ERROR oslo_db.
ERROR: (pymysql.
[SQL: ALTER TABLE secret_acls CHANGE creator_only project_access BOOL NULL]
Seems this is a known issue with alembic [0]
[1] https:/ /github. com/sqlalchemy/ alembic/ issues/ 699