Hi Bram, Good to know it is fixed.
Regarding the issue with missing procedures in 4.17.0.0, can you share the "version" table in your database ? Kind regards, Wei On Thu, 30 Mar 2023 at 11:29, Bram Gillemon <[email protected]> wrote: > 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 > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>> > >>>>> > >>> > >> > >> > >
