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 > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>> > >>> > > > >
