| opendevreview | likui proposed openstack/designate-dashboard master: Remove extra spaces in tox.ini https://review.opendev.org/c/openstack/designate-dashboard/+/894863 | 02:45 |
|---|---|---|
| *** ozzzo1 is now known as ozzzo | 07:02 | |
| gboutry | Hi, I have an issue with alembic revision [1], all tables created before this revision is applied have the tuple (charset, collation) = (utf8mb4, utf8mb4_0900_ai_ci) | 09:21 |
| gboutry | But the revision [1] sets service_statuses to (utf8mb3, utf8mb3_general_ci), and it is also applied as the new default of the database. | 09:21 |
| gboutry | Then, this revision [2] (applied after the fix charset revision) is trying to create the shared_zones table with (utf8mb3, utf8mb3_general_ci), which fails due to table zone being (utf8mb4, utf8mb4_0900_ai_ci) | 09:21 |
| gboutry | I've tested to apply every migration while skipping [1] fix charset, and the db sync commands completes correctly, with all tables being my database default charset/collation: (utf8mb4, utf8mb4_0900_ai_ci) | 09:21 |
| gboutry | I'm currently using a workaround, when building my oci image to just skip the revision. | 09:21 |
| gboutry | I'm not sure how to move forward not to break any existing installation. | 09:21 |
| gboutry | Take note that my scenario is a new designate installation and not an upgrade. | 09:22 |
| gboutry | [1] (fix charset): https://opendev.org/openstack/designate/src/branch/stable/2023.1/designate/storage/impl_sqlalchemy/alembic/versions/15b34ff3ecb8_fix_service_charset.py | 09:22 |
| gboutry | [2] (shared_zones): https://opendev.org/openstack/designate/src/branch/stable/2023.1/designate/storage/impl_sqlalchemy/alembic/versions/b20189fd288e_shared_zone.py | 09:22 |
| johnsom | gboutry How are you creating your designate database? I am wondering if there is an issue with how the base database is being created. | 20:49 |
| johnsom | It should be "CREATE DATABASE designate CHARACTER SET utf9;" | 20:49 |
| johnsom | sorry, utf8, not utf9. typo | 20:50 |
| johnsom | The utf8 is an alias for utf8mb3, so everything should be utf8mb3. | 20:53 |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!