# sudo -u barbican barbican-manage db upgrade
/usr/lib/python3/dist-packages/pymysql/cursors.py:170: Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.")
result = self._query(query)
2020-10-13 15:45:16.211 28298 WARNING oslo_db.sqlalchemy.engines [-] MySQL SQL mode is 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION', consider enabling TRADITIONAL or STRICT_ALL_TABLES
2020-10-13 15:45:16.217 28298 INFO alembic.runtime.migration [-] Context impl MySQLImpl.
2020-10-13 15:45:16.217 28298 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.
2020-10-13 15:45:16.232 28298 INFO alembic.runtime.migration [-] Running upgrade 1bc885808c76 -> 161f8aceb687, fill project_id to secrets where missing
2020-10-13 15:45:16.399 28298 WARNING oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped.: pymysql.err.InternalError: (3098, 'The table does not comply with the requirements by an external plugin.')
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1245, in _execute_context
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters self.dialect.do_execute(
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 581, in do_execute
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query)
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q)
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters result.read()
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1075, in read
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error()
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval)
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters pymysql.err.InternalError: (3098, 'The table does not comply with the requirements by an external plugin.')
2020-10-13 15:45:16.399 28298 ERROR oslo_db.sqlalchemy.exc_filters
ERROR: (pymysql.err.InternalError) (3098, 'The table does not comply with the requirements by an external plugin.')
[SQL: UPDATE secrets, project_secret SET secrets.project_id=project_secret.project_id WHERE secrets.id = project_secret.secret_id AND secrets.project_id IS NULL]
(Background on this error at: http://sqlalche.me/e/2j85)
Attempting to validate the package change ran into another failure mode:
# apt-cache policy barbican-common 0-0ubuntu0. 20.04.2~ ubuntu20. 04.1~ppa2020101 31146 0-0ubuntu0. 20.04.2~ ubuntu20. 04.1~ppa2020101 31146 0-0ubuntu0. 20.04.2~ ubuntu20. 04.1~ppa2020101 31146 500 ppa.launchpad. net/chris. macnaughton/ focal-ussuri/ ubuntu focal/main amd64 Packages dpkg/status 10.0.0- 0ubuntu0. 20.04.1 500 nova.clouds. archive. ubuntu. com/ubuntu focal-updates/main amd64 Packages 10.0.0~ b2~git202002050 8.7b14d983- 0ubuntu3 500 nova.clouds. archive. ubuntu. com/ubuntu focal/main amd64 Packages
barbican-common:
Installed: 1:10.0.
Candidate: 1:10.0.
Version table:
*** 1:10.0.
500 http://
100 /var/lib/
1:
500 http://
1:
500 http://
# sudo -u barbican barbican-manage db upgrade python3/ dist-packages/ pymysql/ cursors. py:170: Warning: (3719, "'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.") sqlalchemy. engines [-] MySQL SQL mode is 'ONLY_FULL_ GROUP_BY, STRICT_ TRANS_TABLES, NO_ZERO_ IN_DATE, NO_ZERO_ DATE,ERROR_ FOR_DIVISION_ BY_ZERO, NO_ENGINE_ SUBSTITUTION' , consider enabling TRADITIONAL or STRICT_ALL_TABLES runtime. migration [-] Context impl MySQLImpl. runtime. migration [-] Will assume non-transactional DDL. runtime. migration [-] Running upgrade 1bc885808c76 -> 161f8aceb687, fill project_id to secrets where missing sqlalchemy. exc_filters [-] DBAPIError exception wrapped.: pymysql. err.InternalErr or: (3098, 'The table does not comply with the requirements by an external plugin.') 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: (3098, 'The table does not comply with the requirements by an external plugin.') sqlalchemy. exc_filters err.InternalErr or) (3098, 'The table does not comply with the requirements by an external plugin.') project_ id=project_ secret. project_ id WHERE secrets.id = project_ secret. secret_ id AND secrets.project_id IS NULL] sqlalche. me/e/2j85)
/usr/lib/
result = self._query(query)
2020-10-13 15:45:16.211 28298 WARNING oslo_db.
2020-10-13 15:45:16.217 28298 INFO alembic.
2020-10-13 15:45:16.217 28298 INFO alembic.
2020-10-13 15:45:16.232 28298 INFO alembic.
2020-10-13 15:45:16.399 28298 WARNING oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
2020-10-13 15:45:16.399 28298 ERROR oslo_db.
ERROR: (pymysql.
[SQL: UPDATE secrets, project_secret SET secrets.
(Background on this error at: http://