I'm also facing the same issue. It seems a bug in gnocchi related to compatibility with MySQL 8. In my environment, MySQL version is "5.7.31-0ubuntu0.18.04.1" in Ubuntu1804 and "8.0.21-0ubuntu0.20.04.4" in Ubuntu2004.
The duplicated name of check constraint causes the error in the following code. * https://github.com/gnocchixyz/gnocchi/blob/master/gnocchi/indexer/alembic/versions/40c6aae14c3f_ck_started_before_ended.py In the MySQL 8 document, it's clearly noted that CHECK constraint names must be unique per schema; no two tables in the same schema can share a CHECK constraint name. * https://dev.mysql.com/doc/refman/8.0/en/create-table-check- constraints.html To fix this issue, I believe we need to change the name of check constraint to be unique as the following change. It also tries to fix this issue but it's not merged in the github repository (not sure why). * https://launchpad.net/ubuntu/+source/gnocchi/+changelog * http://launchpadlibrarian.net/444917380/gnocchi_4.3.4-0ubuntu2_4.3.4-0ubuntu3.diff.gz -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1889752 Title: devstack fails for duplicated check constraint name in gnocchi To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/ceilometer/+bug/1889752/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
