| gillesMo | Hello ! I'm upgrading my LAB from 2023.1 to 2024.1, using openstack-ansible 29.2.3. Problem with nova DB upgrade : | 14:47 |
|---|---|---|
| gillesMo | Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check | 14:48 |
| gillesMo | the manual. You have to change some columns to TEXT or BLOBs')\n[SQL: ALTER TABLE shadow_instances ADD COLUMN compute_id BIGINT | 14:48 |
| gillesMo | And also on : SQL: ALTER TABLE shadow_instances ADD COLUMN compu | 14:48 |
| gillesMo | te_id BIGINT | 14:48 |
| gillesMo | I've tried the Train upgrade-script https://opendev.org/openstack/openstack-ansible/src/tag/train-eol/scripts/upgrade-utilities/galera-row-format-switch.yml but now, I've got : Duplicate column name 'compute_id'\")\n[SQL: ALTER TABLE instances ADD COLUMN compute_id BIGINT | 14:49 |
| gillesMo | Thos happens on Ansible Task : TASK [os_nova : Synchronize the nova DB schema] | 14:51 |
| gillesMo | This happens on Ansible Task : TASK [os_nova : Synchronize the nova DB schema] | 14:51 |
| gillesMo | The first messages are "ERROR: Could not access cell0.\nHas the nova_api database been created?\nHas the nova_cell0 database been created?" I can see the 3 databases nova, nova_api and nova_cell0" | 14:57 |
| mgariepy | how long is that cluster been up for ? was it upgraded from older releases ? | 15:09 |
| gillesMo | Hi mgariepy, This cluster is Old, created as Newton I think, upgraded since | 15:51 |
| noonedeadpunk | mgariepy: btw yes - mysql thing kinda known. eventually all new clusters are expected to use socket for auth of root user, not password | 16:08 |
| noonedeadpunk | but as that could mess up internal stuff - we did not migrate root user auth on our own | 16:09 |
| noonedeadpunk | but stopped placing my.cnf with aut details except utility containers | 16:09 |
| noonedeadpunk | seemed like this was kinda middle ground... | 16:09 |
| gillesMo | Is there known nova DB migration problems between slurp releases 2023.1 and 2024.1 ? I've re-executed the old (Train) galera-row-format-switch.yml playbook to alow bigger Rows, but then, There's problem with a compute_id column, present in nova_cell0 database, but not in nova database... | 16:31 |
| gillesMo | It seems like https://bugs.launchpad.net/nova/+bug/2065403 | 17:00 |
| opendevreview | Amy Marrich proposed openstack/openstack-ansible master: [doc] Add documentation on how to rotate passwords https://review.opendev.org/c/openstack/openstack-ansible/+/951451 | 17:04 |
| mgariepy | i wonder if i should juste change the grants for root user.. | 17:22 |
| jrosser | that causing trouble was the original reason for changing the way we handle the root user iirc | 17:23 |
| mgariepy | otherwise adding back the my.cnf on galera nodes ? | 17:26 |
| mgariepy | are the grants synced accross cluster? | 17:27 |
| mgariepy | waht kind of trouble would i causeS? | 17:40 |
| jrosser | maybe we talk about different things but there was trouble at an upgrade when we had modified the root user | 17:55 |
| jrosser | and that caused startup of the upgraded mariadb to fail iirc | 17:56 |
| jrosser | so the change was to only use the root user to create / set up grants for the `admin` user | 17:56 |
Generated by irclog2html.py 4.0.0 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!