Attempting to validate the package change ran into another failure mode:
# apt-cache policy barbican-common
barbican-common:
Installed: 1:10.0.0-0ubuntu0.20.04.2~ubuntu20.04.1~ppa202010131146
Candidate: 1:10.0.0-0ubuntu0.20.04.2~ubuntu20.04.1~ppa202010131146
Version table:
*** 1:10.0.0-0ubuntu0.20.04.2~ubuntu20.04.1~ppa202010131146 500
500 http://ppa.launchpad.net/chris.macnaughton/focal-ussuri/ubuntu
focal/main amd64 Packages
100 /var/lib/dpkg/status
1:10.0.0-0ubuntu0.20.04.1 500
500 http://nova.clouds.archive.ubuntu.com/ubuntu focal-updates/main
amd64 Packages
1:10.0.0~b2~git2020020508.7b14d983-0ubuntu3 500
500 http://nova.clouds.archive.ubuntu.com/ubuntu focal/main amd64
Packages
# 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)
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1899104
Title:
[SRU] barbican-manage db upgrade fails with MySQL8
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/barbican/+bug/1899104/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
