Hi Wei, Thanks for the pointer! i had a duplicate db.cloud.encryption.type value.
Everything is working again. Kr, Bram > On 30 Mar 2023, at 10:54, Wei ZHOU <[email protected]> wrote: > > Hi Bram, > > Can you check the setting of "db.cloud.encryption.type" > in /etc/cloudstack/management/db.properties ? > > -Wei > > On Thu, 30 Mar 2023 at 10:31, Bram Gillemon <[email protected]> wrote: > >> To recap: >> >> First time i upgraded cloudstack, got a lot of errors on missing >> procedures (they just don't exist on my installation, not sure why). >> >> Second upgrade: >> >> - dropped the cloud database, dropped the cloud_usage database >> - reimported the cloud database and the cloud_usage database >> - created the procedures (if i don't, i can't even upgrade cloudstack) >> - restarted cloudstack-management which completed the upgrade without any >> problems? >> >> If i then try to connect to the cloudstack mgmt interface i get an >> >> HTTP ERROR 503 Service Unavailable >> >> URI: /client/ >> STATUS: 503 >> MESSAGE: Service Unavailable >> SERVLET: - >> >> >> Kr, >> Bram >> >> >>> On 30 Mar 2023, at 10:23, Bram Gillemon <[email protected]> wrote: >>> >>> 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 >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>> >>>>> >>> >> >>
