[CLOUDSTACK-8312] The storage usage of "Primary Storage Allocated" is incorrect.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.5.0
• Fix Version/s: 4.6.0
• Security Level: Public (Anyone can view this level - this is the default.)
• Environment: Master branch code; XS 6.5
• Assignee: Sanjay Tripathi
• Reporter: Sanjay Tripathi
• Created: 10/Mar/15 11:17
• Updated: 20/Mar/15 11:57
• Resolved: 10/Mar/15 11:21

Description

CS only count volume size into "Resources:Primary Storage Allocated", but missed count in template copied to primary storage.
Infrastructure -> Zones -> Advanced-Zone -> Resources:Primary Storage Allocated
SELECT SUM(volumes.size),COUNT FROM volumes WHERE volumes.pool_id = ? AND volumes.removed IS NULL AND volumes.state != 'Destroy'

REPRO STEPS
==================
1. Get CS prepared.
2. query volume size in database, which is exactly size show in UI:
Infrastructure -> Zones -> Advanced-Zone -> Resources:Primary Storage Allocated
3.it does not count in template size in template_spool_ref

EXPECTED BEHAVIOR
==================
"Primary Storage Allocated" should count both volume and template in primary storage.

ACTUAL BEHAVIOR
==================
"Primary Storage Allocated" only count volume size.