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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content