Duplicate entries in cinder quota_usages table
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.