diff options
| author | Michal Arbet <michal.arbet@ultimum.io> | 2025-06-03 00:25:34 +0200 |
|---|---|---|
| committer | Michal Arbet <michal.arbet@ultimum.io> | 2025-06-05 04:28:18 +0000 |
| commit | aecefb1b8714c9e2b3fee6996f3e2f2276389d56 (patch) | |
| tree | 7ff6f020b54481bb3a2d18197d282a4c4e1a5be2 /zuul.d/base.yaml | |
| parent | e5adff15df98d4905be193931edfeb45d8f9fe89 (diff) | |
| download | kolla-ansible-aecefb1b8714c9e2b3fee6996f3e2f2276389d56.tar.gz kolla-ansible-aecefb1b8714c9e2b3fee6996f3e2f2276389d56.zip | |
Fix routing of queries without schema to service's DB shard
Some queries (e.g. SET AUTOCOMMIT, ROLLBACK) may be executed before
schema is selected, causing them to be routed to hostgroup 0, which
does not exist if user using different `mariadb_default_shard_id`.
This change sets default_hostgroup (shard_id) for users to ensure
correct routing even when schema is not specified.
Also adjusts nova-cell user generation logic to include shard assignment,
so queries from nova_<cell> users are properly routed, even if schema is
not used directly.
This avoids silent misrouting and improves reliability in multi-shard
deployments.
Note: These errors are not visible in CI because
mariadb_default_shard_group_id = 0 and ProxySQL routes to hostgroup 0
by default when no routing rule matches.
Depends-On: https://review.opendev.org/c/openstack/kolla/+/951741
Closes-Bug: #2112339
Change-Id: I4f3380a83fa992c3413e82a4692c26a07b25d57f
Diffstat (limited to 'zuul.d/base.yaml')
| -rw-r--r-- | zuul.d/base.yaml | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/zuul.d/base.yaml b/zuul.d/base.yaml index 5cad12e14..1b771b621 100644 --- a/zuul.d/base.yaml +++ b/zuul.d/base.yaml @@ -210,6 +210,7 @@ voting: false files: !inherit - ^ansible/roles/nova/ + - ^ansible/roles/nova-cell/ - ^ansible/roles/loadbalancer/ - ^tests/test-core-openstack.sh - ^tests/test-proxysql.sh |