I deployed a fresh openstack jammy-caracal
* Created 20 volumes with 5G
* Total usage was given as 100G usage
* Then amended the DB
mysql> update cinder.quota_usages set in_use=70 where
project_id='6a325d7127964b378a3e07ac7639fb4b' and
(resource="gigabytes___DEFAULT__" or resource="gigabytes");
* then we check and try the sync, and then check again, and we see that
it was not changed
root@juju-8dc019-jammy-caracal-5:~# sudo cinder-manage quota check --project-id
6a325d7127964b378a3e07ac7639fb4b
2026-06-04 16:39:29.566 77566 DEBUG oslo_db.sqlalchemy.engines [None
req-df7e98cf-ee40-4a41-b178-d9b272b92753 - - - - - -] MySQL server mode set to
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_Z
ERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
_check_effective_sql_mode
/usr/lib/python3/dist-packages/oslo_db/sqlalchemy/engines.py:342
Processing quota usage for project 6a325d7127964b378a3e07ac7639fb4b
gigabytes: invalid usage saved=70 actual=100
gigabytes___DEFAULT__: invalid usage saved=70 actual=100
Action successfully completed
root@juju-8dc019-jammy-caracal-5:~# sudo cinder-manage quota sync --project-id
6a325d7127964b378a3e07ac7639fb4b
2026-06-04 16:41:04.034 77624 DEBUG oslo_db.sqlalchemy.engines [None
req-85465a39-6291-4dd9-b09e-2246bfefad4d - - - - - -] MySQL server mode set to
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_Z
ERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
_check_effective_sql_mode
/usr/lib/python3/dist-packages/oslo_db/sqlalchemy/engines.py:342
Processing quota usage for project 6a325d7127964b378a3e07ac7639fb4b
gigabytes: invalid usage saved=70 actual=100 - fixed
gigabytes___DEFAULT__: invalid usage saved=70 actual=100 - fixed
Action successfully completed
root@juju-8dc019-jammy-caracal-5:~# sudo cinder-manage quota check --project-id
6a325d7127964b378a3e07ac7639fb4b
2026-06-04 16:41:08.971 77628 DEBUG oslo_db.sqlalchemy.engines [None
req-27ce0fc7-c589-4914-ab2b-6ade3a85300a - - - - - -] MySQL server mode set to
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_Z
ERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
_check_effective_sql_mode
/usr/lib/python3/dist-packages/oslo_db/sqlalchemy/engines.py:342
Processing quota usage for project 6a325d7127964b378a3e07ac7639fb4b
gigabytes: invalid usage saved=70 actual=100
gigabytes___DEFAULT__: invalid usage saved=70 actual=100
Action successfully completed
* Now enabled the PPA, and update the cinder package
root@juju-8dc019-jammy-caracal-5:~# sudo cinder-manage quota check --project-id
6a325d7127964b378a3e07ac7639fb4b
2026-06-04 16:46:21.801 87518 DEBUG oslo_db.sqlalchemy.engines [None
req-1c2a609c-3881-47b9-adb3-30b6d4699ea3 - - - - - -] MySQL server mode set to
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_Z
ERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
_check_effective_sql_mode
/usr/lib/python3/dist-packages/oslo_db/sqlalchemy/engines.py:342
Processing quota usage for project 6a325d7127964b378a3e07ac7639fb4b
gigabytes: invalid usage saved=70 actual=100
gigabytes___DEFAULT__: invalid usage saved=70 actual=100
Action successfully completed
root@juju-8dc019-jammy-caracal-5:~# sudo cinder-manage quota sync --project-id
6a325d7127964b378a3e07ac7639fb4b
2026-06-04 16:46:33.451 87522 DEBUG oslo_db.sqlalchemy.engines [None
req-fc4b5ad5-9504-43f6-afda-f1f6cc9d4d2c - - - - - -] MySQL server mode set to
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_Z
ERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
_check_effective_sql_mode
/usr/lib/python3/dist-packages/oslo_db/sqlalchemy/engines.py:342
Processing quota usage for project 6a325d7127964b378a3e07ac7639fb4b
gigabytes: invalid usage saved=70 actual=100 - fixed
gigabytes___DEFAULT__: invalid usage saved=70 actual=100 - fixed
Action successfully completed
root@juju-8dc019-jammy-caracal-5:~# sudo cinder-manage quota check --project-id
6a325d7127964b378a3e07ac7639fb4b
2026-06-04 16:46:38.537 87526 DEBUG oslo_db.sqlalchemy.engines [None
req-bb95f171-7845-4107-a3b4-70c91d938de0 - - - - - -] MySQL server mode set to
STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_Z
ERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION
_check_effective_sql_mode
/usr/lib/python3/dist-packages/oslo_db/sqlalchemy/engines.py:342
Processing quota usage for project 6a325d7127964b378a3e07ac7639fb4b
Action successfully completed
** Tags removed: verification-caracal-needed
** Tags added: verification-caracal-done
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/2104322
Title:
cinder-manager quota sync is not working
To manage notifications about this bug go to:
https://bugs.launchpad.net/cinder/+bug/2104322/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
