Read point 2 as follows:
2. I checked with resource_count table, it had the maximum value of type Secondary_storage (400 GB) for this user. From: Prakash Rao Banuka Sent: Friday, May 16, 2014 6:32 AM To: dev@cloudstack.apache.org Cc: Venkata Suneel Babu Mallela Subject: Error while creating a snapshot!! 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