How to fix quota entries from Cinder database (MariaDB)

Solution In Progress - Updated -

Issue

cinder quota-usage is out of sync with the actually used resources.

$ cinder quota-usage 042b54c1f35f425d84a13529ec52f243
+----------------------+--------+----------+-------+
|         Type         | In_use | Reserved | Limit |
+----------------------+--------+----------+-------+
|   backup_gigabytes   |   0    |    0     |  1000 |
|       backups        |   0    |    0     |   10  |
|      gigabytes       |   1    |    0     |  1000 |
| gigabytes_backup.sbm |   0    |    0     |   -1  |
|    gigabytes_ceph    |   0    |    0     |   -1  |
|  gigabytes_ceph.ssd  |   1    |    0     |   -1  |
| per_volume_gigabytes |   0    |    0     |   -1  |
|      snapshots       |   0    |    0     |   10  |
| snapshots_backup.sbm |   0    |    0     |   -1  |
|    snapshots_ceph    |   0    |    0     |   -1  |
|  snapshots_ceph.ssd  |   0    |    0     |   -1  |
|       volumes        |   1    |    0     |   10  |
|  volumes_backup.sbm  |   0    |    0     |   -1  |
|     volumes_ceph     |   0    |    0     |   -1  |
|   volumes_ceph.ssd   |   1    |    0     |   -1  |
+----------------------+--------+----------+-------+

$ export OS_PROJECT_ID=042b54c1f35f425d84a13529ec52f243
$ cinder list
+----+--------+------+------+-------------+----------+-------------+
| ID | Status | Name | Size | Volume Type | Bootable | Attached to |
+----+--------+------+------+-------------+----------+-------------+
+----+--------+------+------+-------------+----------+-------------+
$ cinder snapshot-list
+----+-----------+--------+------+------+
| ID | Volume ID | Status | Name | Size |
+----+-----------+--------+------+------+
+----+-----------+--------+------+------+

Environment

  • Red Hat OpenStack Platform 10.0 (RHOSP)
  • Red Hat OpenStack Platform 9.0 (RHOSP)

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In