Hi Bram, If the upgrade fails, you need to restore the database from backup. Otherwise, you will face the issue like Caused by: java.sql.SQLSyntaxErrorException: Duplicate column name 'public_mtu'
Please try the following (assume you have backed up the database before upgrade) - stop cloudstack-management - drop old databases cloud and cloud_usage - restore databases - create the missing procedures - start cloudstack-management -Wei On Thu, 30 Mar 2023 at 09:40, Bram Gillemon <[email protected]> wrote: > 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 > >> > >> > >> > >> > >> > >> > >> > >
