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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
