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