volumes quota_usages in_use properties does not change when delete volume snapshots

[Leo Liang]

When user create one volume's snapshot ，then delete it , the quota_usages tables 'in_use' fileds is not changed.
thus , if tenant defaut quaota is 10, when user create 10 volumes ,then delete it ,user cannot create new volume or snapshot ,
it returns "Volumes quota exceed."

[Vincent Hou (houshengbo)]

Shawn, please elaborate more about how you produce this issue.
I tested both under current code and grizzly. They both worked fine.

The in-use value changes when creating or deleting vol/snapshot.

mysql> select * from quota_usages;
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| created_at | updated_at | deleted_at | deleted | id | project_id | resource | in_use | reserved | until_refresh |
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| 2013-05-16 13:02:30 | 2013-05-16 13:04:50 | NULL | 0 | 1 | c6e1e8fc952943368840d5dd516acb33 | gigabytes | 10 | 0 | NULL |
| 2013-05-16 13:02:30 | 2013-05-16 13:04:50 | NULL | 0 | 2 | c6e1e8fc952943368840d5dd516acb33 | volumes | 10 | 0 | NULL |
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
2 rows in set (0.00 sec)

After I delete one volume.

mysql> select * from quota_usages;
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| created_at | updated_at | deleted_at | deleted | id | project_id | resource | in_use | reserved | until_refresh |
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| 2013-05-16 13:02:30 | 2013-05-16 13:06:14 | NULL | 0 | 1 | c6e1e8fc952943368840d5dd516acb33 | gigabytes | 9 | 0 | NULL |
| 2013-05-16 13:02:30 | 2013-05-16 13:06:14 | NULL | 0 | 2 | c6e1e8fc952943368840d5dd516acb33 | volumes | 9 | 0 | NULL |
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
2 rows in set (0.00 sec)

[Leo Liang (11315889-a)]

Sorry, I made a little mistake in the fields name, i test just now ,

that is snapshot's bug ,please notice the snapshot fields ,after create snapshot and delete it .

mysql> select * from quota_usages where project_id='30387eb46b624012bce5172ac77ab407';
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| created_at | updated_at | deleted_at | deleted | id | project_id | resource | in_use | reserved | until_refresh |
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+

| 2013-05-06 03:12:43 | 2013-05-17 09:06:12 | NULL | 0 | 6 | 30387eb46b624012bce5172ac77ab407 | snapshots | 6 | 0 | NULL |
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
3 rows in set (0.00 sec)

[Cian O'Driscoll (dricco)]

Also tests on master and stable/grizzly head and cannot repo.

output form stable/grizzly head testing

mysql> select * from quota_usages;
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| created_at | updated_at | deleted_at | deleted | id | project_id | resource | in_use | reserved | until_refresh |
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| 2013-05-30 09:27:24 | 2013-05-30 09:29:12 | NULL | 0 | 1 | 51365a6f2fb0462fae664903e982a88b | gigabytes | 2 | 0 | NULL |
| 2013-05-30 09:27:24 | 2013-05-30 09:27:24 | NULL | 0 | 2 | 51365a6f2fb0462fae664903e982a88b | volumes | 1 | 0 | NULL |
| 2013-05-30 09:27:45 | 2013-05-30 09:29:12 | NULL | 0 | 3 | 51365a6f2fb0462fae664903e982a88b | snapshots | 1 | 0 | NULL |
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
3 rows in set (0.00 sec)

mysql>
mysql>
mysql> select * from quota_usages;
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| created_at | updated_at | deleted_at | deleted | id | project_id | resource | in_use | reserved | until_refresh |
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| 2013-05-30 09:27:24 | 2013-05-30 09:42:18 | NULL | 0 | 1 | 51365a6f2fb0462fae664903e982a88b | gigabytes | 3 | 0 | NULL |
| 2013-05-30 09:27:24 | 2013-05-30 09:27:24 | NULL | 0 | 2 | 51365a6f2fb0462fae664903e982a88b | volumes | 1 | 0 | NULL |
| 2013-05-30 09:27:45 | 2013-05-30 09:42:18 | NULL | 0 | 3 | 51365a6f2fb0462fae664903e982a88b | snapshots | 2 | 0 | NULL |
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
3 rows in set (0.00 sec)

mysql>
mysql> select * from quota_usages;
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| created_at | updated_at | deleted_at | deleted | id | project_id | resource | in_use | reserved | until_refresh |
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| 2013-05-30 09:27:24 | 2013-05-30 09:42:54 | NULL | 0 | 1 | 51365a6f2fb0462fae664903e982a88b | gigabytes | 4 | 0 | NULL |
| 2013-05-30 09:27:24 | 2013-05-30 09:27:24 | NULL | 0 | 2 | 51365a6f2f...

[Sean McGinnis (sean-mcginnis)]

Closing stale bug. If this is still an issue please reopen.