Hi, that was my second attempt, you'll see that the second upgrade ran without any issues. I dropped the database, reimported them and than restarted cloudstack-management and cloudstack-usage. The second upgrade ran without any problems.
Met vriendelijke groeten, Bram Gillemon Voor technische vragen kan je terecht op [email protected] -- [email protected] https://www.x-plose.be t. +32 (0)50 89 26 10 BTW BE0675.723.477 X-plose BV Lieven Bauwensstraat 16 8200 Brugge België Dit emailbericht is strikt vertrouwelijk. Indien het een verkeerde bestemmeling zou bereiken, verzoeken wij u ons daarvan onmiddellijk te verwittigen door ons het bericht terug te sturen via reply. Gelieve het bericht daarna te wissen en dit niet te lezen of kenbaar te maken aan derden. Klik hier om het privacybeleid van de onderneming te vinden. > On 30 Mar 2023, at 10:21, Wei ZHOU <[email protected]> wrote: > > 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 >>>> >>>> >>>> >>>> >>>> >>>> >>>> >> >>
