The upgrade of octavia from antelope -> bobcat fails as there was a new user added for octavia_persistence. The bootstrap_service.yml doesn't create this user and the upgrade fails because of this:
ERROR octavia-db-manage packet.raise_for_error()", "2024-05-13 13:03:58.847 18 ERROR octavia-db-manage File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/protocol.py\", line 221, in raise_for_error", "2024-05-13 13:03:58.847 18 ERROR octavia-db-manage err.raise_mysql_exception(self._data)", "2024-05-13 13:03:58.847 18 ERROR octavia-db-manage File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/err.py\", line 143, in raise_mysql_exception", "2024-05-13 13:03:58.847 18 ERROR octavia-db-manage raise errorclass(errno, errval)", "2024-05-13 13:03:58.847 18 ERROR octavia-db-manage sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, \"Access denied for user 'octavia_persistence'@'man2-li-osnetwork-207-001' (using password: YES)\")", "2024-05-13 13:03:58.847 18 ERROR octavia-db-manage (Background on this error at: https://sqlalche.me/e/14/e3q8)", "2024-05-13 13:03:58.847 18 ERROR octavia-db-manage \u001b[00m"]}
We fixed it by simply changing upgrade.yml to:
- import_tasks: bootstrap.yml
instead of:
- import_tasks: bootstrap_service.yml