Duplicate entries in cinder quota_usages table

Solution In Progress - Updated -

Issue

  • We're unable to create new volumes and while inspecting the database content, we noticed some quota_usages entries were duplicated:
MariaDB [cinder]> select * from quota_usages where reserved > 0 and project_id ='3dfb0a7338bc481a8a7317109de77714' ;
+---------------------+---------------------+------------+---------+------+----------------------------------+---------------+--------+----------+---------------+
| created_at          | updated_at          | deleted_at | deleted | id   | project_id                       | resource      | in_use | reserved | until_refresh |
+---------------------+---------------------+------------+---------+------+----------------------------------+---------------+--------+----------+---------------+
| 2019-08-05 13:27:39 | 2019-08-05 13:27:39 | NULL       |       0 | 2326 | 3dfb0a7338bc481a8a7317109de77714 | gigabytes     |      0 |      200 |          NULL |
| 2019-08-05 13:27:39 | 2019-08-05 13:27:39 | NULL       |       0 | 2329 | 3dfb0a7338bc481a8a7317109de77714 | gigabytes     |      0 |      450 |          NULL |
| 2019-08-05 13:27:39 | 2019-08-22 07:22:43 | NULL       |       0 | 2332 | 3dfb0a7338bc481a8a7317109de77714 | gigabytes     |  11200 |     8100 |          NULL |
| 2019-08-05 13:27:39 | 2019-08-05 13:27:39 | NULL       |       0 | 2335 | 3dfb0a7338bc481a8a7317109de77714 | gigabytes_CBS |      0 |      200 |          NULL |
| 2019-08-05 13:27:39 | 2019-08-05 13:27:39 | NULL       |       0 | 2338 | 3dfb0a7338bc481a8a7317109de77714 | gigabytes_CBS |      0 |      450 |          NULL |
| 2019-08-05 13:27:39 | 2019-08-22 07:22:43 | NULL       |       0 | 2341 | 3dfb0a7338bc481a8a7317109de77714 | gigabytes_CBS |   1600 |     8100 |          NULL |
| 2019-08-05 13:27:39 | 2019-08-05 13:27:39 | NULL       |       0 | 2344 | 3dfb0a7338bc481a8a7317109de77714 | volumes_CBS   |      0 |        1 |          NULL |
| 2019-08-05 13:27:39 | 2019-08-05 13:27:39 | NULL       |       0 | 2347 | 3dfb0a7338bc481a8a7317109de77714 | volumes_CBS   |      0 |        1 |          NULL |
| 2019-08-05 13:27:39 | 2019-08-22 07:22:43 | NULL       |       0 | 2350 | 3dfb0a7338bc481a8a7317109de77714 | volumes_CBS   |      6 |        1 |          NULL |
| 2019-08-05 13:27:39 | 2019-08-05 13:27:39 | NULL       |       0 | 2353 | 3dfb0a7338bc481a8a7317109de77714 | volumes       |      0 |        1 |          NULL |
| 2019-08-05 13:27:39 | 2019-08-05 13:27:39 | NULL       |       0 | 2356 | 3dfb0a7338bc481a8a7317109de77714 | volumes       |      0 |        1 |          NULL |
| 2019-08-05 13:27:39 | 2019-08-22 07:22:43 | NULL       |       0 | 2359 | 3dfb0a7338bc481a8a7317109de77714 | volumes       |     12 |        1 |          NULL |
+---------------------+---------------------+------------+---------+------+----------------------------------+---------------+--------+----------+---------------+
  • What is the best way to solve this issue ?

Environment

  • Red Hat OpenStack Platform 10.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