Hi,
so i restarted the upgrade procedure from the previous database.
the only 2 things missing in the database to upgrade without any issues where
these procedures:
CREATE PROCEDURE `cloud`.`ADD_GUEST_OS_AND_HYPERVISOR_MAPPING` (
IN guest_os_category_id bigint(20) unsigned,
IN guest_os_display_name VARCHAR(255),
IN guest_os_hypervisor_hypervisor_type VARCHAR(32),
IN guest_os_hypervisor_hypervisor_version VARCHAR(32),
IN guest_os_hypervisor_guest_os_name VARCHAR(255)
)
BEGIN
INSERT INTO cloud.guest_os (uuid, category_id, display_name, created)
SELECT UUID(), guest_os_category_id, guest_os_display_name, now()
FROM DUAL
WHERE not exists( SELECT 1
FROM cloud.guest_os
WHERE cloud.guest_os.category_id = guest_os_category_id
AND cloud.guest_os.display_name =
guest_os_display_name)
; INSERT INTO cloud.guest_os_hypervisor (uuid, hypervisor_type,
hypervisor_version, guest_os_name, guest_os_id, created)
SELECT UUID(), guest_os_hypervisor_hypervisor_type,
guest_os_hypervisor_hypervisor_version, guest_os_hypervisor_guest_os_name,
guest_os.id, now()
FROM cloud.guest_os
WHERE guest_os.category_id = guest_os_category_id
AND guest_os.display_name = guest_os_display_name
AND NOT EXISTS (SELECT 1
FROM cloud.guest_os_hypervisor as hypervisor
WHERE hypervisor_type =
guest_os_hypervisor_hypervisor_type
AND hypervisor_version =
guest_os_hypervisor_hypervisor_version
AND hypervisor.guest_os_id = guest_os.id
AND hypervisor.guest_os_name =
guest_os_hypervisor_guest_os_name)
;END;
CREATE PROCEDURE `cloud`.`IDEMPOTENT_ADD_COLUMN` (
IN in_table_name VARCHAR(200)
, IN in_column_name VARCHAR(200)
, IN in_column_definition VARCHAR(1000)
)
BEGIN
DECLARE CONTINUE HANDLER FOR 1060 BEGIN END; SET @ddl = CONCAT('ALTER TABLE
', in_table_name); SET @ddl = CONCAT(@ddl, ' ', 'ADD COLUMN') ; SET @ddl =
CONCAT(@ddl, ' ', in_column_name); SET @ddl = CONCAT(@ddl, ' ',
in_column_definition); PREPARE stmt FROM @ddl; EXECUTE stmt; DEALLOCATE PREPARE
stmt; END;
After i ran these manually the upgrade went smooth, but i still can't reach the
mgmt platform.
I uploaded the log files, this is the first attempt of the update.
https://upload.bugoff.be//first-attempt-management-server.log
this is the second attempt where i only added the stored procedures and ran the
upgrade.
https://upload.bugoff.be//second-attempt-management-server.log
Kind Regards,
Bram Gillemon
> On 30 Mar 2023, at 09:15, Wei ZHOU <[email protected]> wrote:
>
> There might be something wrong during the upgrade, for example SQL errors.
>
> Could you upload the full log ?
>
> -Wei
>
> On Wed, 29 Mar 2023 at 23:06, Bram Gillemon <[email protected]> wrote:
>
>> Hi,
>>
>> i'm having some problems updating met cloudstack setup, after the update
>> of the cloudstack-management i tried to start it and got some errors on
>> missing procedures,
>>
>> After creating the necessary procedures by hand, and removing some mtu
>> fields, cloudstack started, at least i thought.
>>
>> It's not listening on port 8250, and i can't seem to figure out why.
>>
>> the logs mention it's listening, but ss -tpln doesn't show anything
>> listening on the port.
>>
>> Attached is the management-server.log, the only "error" i see is the
>> commands.properties is missing.
>>
>> I couldn't find any troubleshooting tips on to debug this, so i hope
>> somebody has some tips.
>>
>>
>>
>>
>> Kind Regards,
>> Bram
>>
>>
>>
>>
>>
>>
>>
