Sorry, logs at /var/log/cloudstack/management/management-server.log ________________________________ From: Harikrishna Patnala <harikrishna.patn...@shapeblue.com> Sent: Monday, September 20, 2021 10:04 AM To: users@cloudstack.apache.org <users@cloudstack.apache.org> Subject: Re: Problem with Templates/ISO
Hi Douglas, Firstly, welcome to CloudStack. This looks to me like DB changes did not apply properly during installation. Did you observe any issues in the logs during the management server installation or start. You can check the logs at /usr/share/cloudstack/management/management-server.log and see the exact reason for DB sql exception when you perform the list templates operation. As mentioned already there is no change in the system VM template from 4.15.1 to 4.15.2 Regards, Harikrishna ________________________________ From: DL <douglasl...@gmail.com> Sent: Monday, September 20, 2021 9:38 AM To: users@cloudstack.apache.org <users@cloudstack.apache.org> Subject: Problem with Templates/ISO Hello there, I am a new CloutStack user and a new user on this mailing list. After following the Quick Installation Guide, I ended up with empty Template/ISOs when I attempted to create a VM instance. If I go to Images/Templates, I got 500 Internal Server Error: Request Failed (530) DB Exception on: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT template_store_ref.id, template_store_ref.store_id, template_store_ref.template_id, template_store_ref.store_role, template_store_ref.created, template_store_ref.last_updated, template_store_ref.download_pct, template_store_ref.size, template_store_ref.physical_size, template_store_ref.download_state, template_store_ref.local_path, template_store_ref.error_str, template_store_ref.job_id, template_store_ref.install_path, template_store_ref.url, template_store_ref.download_url, template_store_ref.download_url_created, template_store_ref.is_copy, template_store_ref.destroyed, template_store_ref.update_count, template_store_ref.updated, template_store_ref.state, template_store_ref.ref_cnt FROM template_store_ref WHERE template_store_ref.template_id = 3 AND template_store_ref.download_state != 'BYPASSED' AND template_store_ref.destroyed = 0 AND template_store_ref.store_id IN ) Could someone help me fix this issue? The quick installation guide I followed says it is for 4.15.2.0 installation. However, in the System Template Setup section, this command: """ /usr/share/cloudstack-common/scripts/storage/secondary/cloud-install-sys-tmplt -m /export/secondary -u https://download.cloudstack.org/systemvm/4.15/systemvmtemplate-4.15.1-kvm.qcow2.bz2 -h kvm -F """ seems to suggest that the process will download template vms for the 4.15.1.0 version? Could this be the reason? Does anyone have an idea about when the Template for the 4.15.2.0 version will be available? Best regards, Douglas
