sureshanaparti commented on PR #11214:
URL: https://github.com/apache/cloudstack/pull/11214#issuecomment-3096068144

   Verified the response with ready and non-ready ISOes, it's not returning 
size, physical size when templates are not ready.
   
   CMK =>
   ```
   (localcloud) 🐱 > list isos filter=id,name,format,size,physicalsize,isready 
isofilter=self
   {
     "count": 5,
     "iso": [
       {
         "format": "ISO",
         "id": "a320da7c-5638-464b-b38b-1a4540a6c6e0",
         "isready": true,
         "name": "macchinina-kvm",
         "physicalsize": 9369600,
         "size": 9369600
       },
       {
         "format": "ISO",
         "id": "2e28e46a-7b56-4b77-a618-2edc410db32d",
         "isready": true,
         "name": "proxmox",
         "physicalsize": 672958464,
         "size": 672958464
       },
       {
         "format": "ISO",
         "id": "cd0558d8-e11a-4bcf-b999-bf0627525186",
         "isready": true,
         "name": "CentOS-Stream-9",
         "physicalsize": 1381629952,
         "size": 1381629952
       },
       {
         "format": "ISO",
         "id": "8ad1993e-5797-4dc3-afa5-8b949de62acc",
         "isready": false,
         "name": "test1"
       },
       {
         "format": "ISO",
         "id": "9754aa88-179a-4516-8028-b6e337d7c208",
         "isready": false,
         "name": "test2-upload"
       }
     ]
   }
   (localcloud) 🐱 >
   ```
   
   DB =>
   ```
   mysql> SELECT uuid, name, tmpl.size as template_size, store.size as 
store_size, physical_size, tmpl.state as template_state, store.state as 
store_state, download_state FROM vm_template tmpl, template_store_ref store 
WHERE tmpl.id = store.template_id AND tmpl.format = 'ISO' AND tmpl.removed IS 
NULL;
   
+--------------------------------------+-----------------+---------------+------------+---------------+----------------+-------------+----------------+
   | uuid                                 | name            | template_size | 
store_size | physical_size | template_state | store_state | download_state |
   
+--------------------------------------+-----------------+---------------+------------+---------------+----------------+-------------+----------------+
   | a320da7c-5638-464b-b38b-1a4540a6c6e0 | macchinina-kvm  |       9369600 |   
 9369600 |       9369600 | Active         | Ready       | DOWNLOADED     |
   | 2e28e46a-7b56-4b77-a618-2edc410db32d | proxmox         |     672958464 |  
672958464 |     672958464 | Active         | Ready       | DOWNLOADED     |
   | cd0558d8-e11a-4bcf-b999-bf0627525186 | CentOS-Stream-9 |    1381629952 | 
1381629952 |    1381629952 | Active         | Ready       | DOWNLOADED     |
   | 8ad1993e-5797-4dc3-afa5-8b949de62acc | test1           |             0 |   
       0 |             0 | Active         | Allocated   | DOWNLOAD_ERROR |
   | 9754aa88-179a-4516-8028-b6e337d7c208 | test2-upload    |          NULL |   
    NULL |             0 | NotUploaded    | Allocated   | NULL           |
   
+--------------------------------------+-----------------+---------------+------------+---------------+----------------+-------------+----------------+
   5 rows in set (0.01 sec)
   
    mysql> SELECT uuid, name, format, size, physical_size, state, 
template_state FROM template_view WHERE format = 'ISO' AND account_name != 
'system' AND removed IS NULL;                                          
   
+--------------------------------------+-----------------+--------+------------+---------------+-----------+----------------+
   | uuid                                 | name            | format | size     
  | physical_size | state     | template_state |
   
+--------------------------------------+-----------------+--------+------------+---------------+-----------+----------------+
   | a320da7c-5638-464b-b38b-1a4540a6c6e0 | macchinina-kvm  | ISO    |    
9369600 |       9369600 | Ready     | Active         |
   | 2e28e46a-7b56-4b77-a618-2edc410db32d | proxmox         | ISO    |  
672958464 |     672958464 | Ready     | Active         |
   | cd0558d8-e11a-4bcf-b999-bf0627525186 | CentOS-Stream-9 | ISO    | 
1381629952 |    1381629952 | Ready     | Active         |
   | 8ad1993e-5797-4dc3-afa5-8b949de62acc | test1           | ISO    |          
0 |             0 | Allocated | Active         |
   | 9754aa88-179a-4516-8028-b6e337d7c208 | test2-upload    | ISO    |       
NULL |             0 | Allocated | NotUploaded    |
   
+--------------------------------------+-----------------+--------+------------+---------------+-----------+----------------+
   5 rows in set (0.00 sec)
   
   mysql>
   ``` 
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to