[CLOUDSTACK-5303] "snapshot" count and "secondary_storage" count are not correct in resource_count table

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.2.0, 4.3.0
• Fix Version/s: 4.2.1, 4.3.0
• Security Level: Public (Anyone can view this level - this is the default.)
• Assignee: Wei Zhou
• Reporter: Wei Zhou
• Created: 28/Nov/13 10:41
• Updated: 08/Jan/14 15:03
• Resolved: 08/Jan/14 15:03

Description

After I had some testing on snapshot (take,delete,create template), the values in resource_count looks wrong.

mysql> select * from resource_count where type="snapshot";
-------------------------------------

id

account_id

domain_id

type

count

-------------------------------------

8	NULL	1	snapshot	2
40	NULL	2	snapshot	0
52	NULL	3	snapshot	0
100	NULL	4	snapshot	0
184	NULL	5	snapshot	0
220	NULL	6	snapshot	1
280	NULL	7	snapshot	1
412	NULL	8	snapshot	0
16	1	NULL	snapshot	0
28	2	NULL	snapshot	0
64	3	NULL	snapshot	0
76	4	NULL	snapshot	0
172	11	NULL	snapshot	0
196	12	NULL	snapshot	0
208	13	NULL	snapshot	0
232	14	NULL	snapshot	1
244	15	NULL	snapshot	0
292	18	NULL	snapshot	1
304	19	NULL	snapshot	0
316	20	NULL	snapshot	0
328	21	NULL	snapshot	0
340	22	NULL	snapshot	0
352	23	NULL	snapshot	0
376	25	NULL	snapshot	0
388	26	NULL	snapshot	0
400	27	NULL	snapshot	0
424	28	NULL	snapshot	1
436	29	NULL	snapshot	-1
448	30	NULL	snapshot	0
460	31	NULL	snapshot	0
472	32	NULL	snapshot	0

-------------------------------------
31 rows in set (0.00 sec)

mysql> select * from resource_count where type="secondary_storage";
-----------------------------------------------------

id

account_id

domain_id

type

count

-----------------------------------------------------

4	NULL	1	secondary_storage	567941002752
48	NULL	2	secondary_storage	0
60	NULL	3	secondary_storage	0
108	NULL	4	secondary_storage	0
192	NULL	5	secondary_storage	0
228	NULL	6	secondary_storage	300647710720
288	NULL	7	secondary_storage	128849018880
420	NULL	8	secondary_storage	0
24	1	NULL	secondary_storage	8866096640
36	2	NULL	secondary_storage	172527849472
72	3	NULL	secondary_storage	0
84	4	NULL	secondary_storage	0
180	11	NULL	secondary_storage	0
204	12	NULL	secondary_storage	0
216	13	NULL	secondary_storage	0
240	14	NULL	secondary_storage	257698037760
252	15	NULL	secondary_storage	0
300	18	NULL	secondary_storage	128849018880
312	19	NULL	secondary_storage	0
324	20	NULL	secondary_storage	0
336	21	NULL	secondary_storage	0
348	22	NULL	secondary_storage	0
360	23	NULL	secondary_storage	0
384	25	NULL	secondary_storage	0
396	26	NULL	secondary_storage	0
408	27	NULL	secondary_storage	0
432	28	NULL	secondary_storage	42949672960
444	29	NULL	secondary_storage	-42949672960
456	30	NULL	secondary_storage	0
468	31	NULL	secondary_storage	0
480	32	NULL	secondary_storage	0

-----------------------------------------------------
31 rows in set (0.01 sec)