Comment 9 for bug 1899104

Revision history for this message
David Ames (thedac) wrote : Re: [Bug 1899104] Re: [SRU] barbican-manage db upgrade fails with MySQL8

On Tue, Feb 16, 2021 at 12:00 PM Brian Murray
<email address hidden> wrote:
>
> Hello David, or anyone else affected,
>
> Accepted barbican into focal-proposed. The package will build now and be
> available at
> https://launchpad.net/ubuntu/+source/barbican/1:10.0.0-0ubuntu0.20.04.2
> in a few hours, and then in the -proposed repository.
>
> Please help us by testing this new package. See
> https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how
> to enable and use -proposed. Your feedback will aid us getting this
> update out to other Ubuntu users.
>
> If this package fixes the bug for you, please add a comment to this bug,
> mentioning the version of the package you tested, what testing has been
> performed on the package and change the tag from verification-needed-
> focal to verification-done-focal. If it does not fix the bug for you,
> please add a comment stating that, and change the tag to verification-
> failed-focal. In either case, without details of your testing we will
> not be able to proceed.

Unfortunately, we seem to still have a problem.

apt-cache policy python3-barbican
python3-barbican:
  Installed: 1:10.0.0-0ubuntu0.20.04.2
  Candidate: 1:10.0.0-0ubuntu0.20.04.2
  Version table:
 *** 1:10.0.0-0ubuntu0.20.04.2 500
        500 http://archive.ubuntu.com/ubuntu focal-proposed/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)
2021-02-17 17:12:26.700 232723 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
2021-02-17 17:12:26.728 232723 INFO alembic.runtime.migration [-]
Context impl MySQLImpl.
2021-02-17 17:12:26.729 232723 INFO alembic.runtime.migration [-] Will
assume non-transactional DDL.
/usr/lib/python3/dist-packages/alembic/script/revision.py:152:
UserWarning: Revision 39cf2e645cba referenced from 39cf2e645cba ->
0f8c192a061f (head), Add Secret Consumers table is not present
  util.warn(
ERROR: '39cf2e645cba'

--
David Ames