Error while creating a snapshot!!

[Prakash Rao Banuka <pr...@simplifydc.com>]

Hi,

While creating a snapshot through cloudstack with a user (Role:user) I receive the following error message:

Maximum number of resources of type 'secondary_storage' for account name=demo in domain id=4 has been exceeded.


Secondary Storage limit is 400 GB which is 100% empty, but still it does displays the above error and does not allow me to create a snapshot or template.

I tried the following steps


1.       Initially I checked with resource_limit table and found no records. In CloudStack UI,  I clicked on Accounts tab-account-->edit and apply  then the records got created in the resource_limit table

2.       Now I checked with resource_count table, it had the maximum value of type SNAPSHOT.CREATE (400 GB) for this user.

3.       Then removed unwanted records from usage_event of type SNAPSHOT.CREATE table for this user

4.       Still resource_count shows the same maximum value of (400 GB)

5.       I removed all the projects, instances, snapshots and templates for this account, still some records are there in resource_count table

Can I make all the values in the resource_count table to zero for this account? Or
Is there any other best method to reflect the actual usage in resource_count table.

Thank you
Prakash