Thank you Wei, that was the problem. After loading the procedures, the upgrade went smoothly. However, the systemvm-kvm-4.19.0 template has the status not ready (download error), is there any way to fix it? Secondary storage works properly, I can register new templates, and no errors occurred during the upgrade process.
Regards, Piotr -----Original Message----- From: Wei ZHOU <ustcweiz...@gmail.com> Sent: Thursday, February 8, 2024 4:25 PM To: users@cloudstack.apache.org Subject: Re: db upgrade issue Hi, It seems you dumped the database and reimported it. When you dumped the database, you need to use "mysqldump -R" which stores the procedures. Related issue and workaround: https://github.com/apache/cloudstack/issues/8546 -Wei On 08/02/2024, Piotr Pisz <pi...@piszki.pl> wrote: > Hi, > > > > Unfortunately, the db upgrade from 4.18.1 to 4.19 is not performed, it > stops > here: > > > > 2024-02-08 14:19:19,631 DEBUG [c.c.u.d.ScriptRunner] (main:null) > (logid:) > -- > Add remover account ID to quarantined IPs table. > > 2024-02-08 14:19:19,631 DEBUG [c.c.u.d.ScriptRunner] (main:null) > (logid:) CALL `cloud`.`IDEMPOTENT_ADD_COLUMN`('cloud.quarantined_ips', > 'remover_account_id', 'bigint(20) unsigned DEFAULT NULL COMMENT "ID of > the account that removed the IP from quarantine, foreign key to > `account` > table"') > > 2024-02-08 14:19:19,647 ERROR [c.c.u.d.ScriptRunner] (main:null) > (logid:) Error executing: CALL > `cloud`.`IDEMPOTENT_ADD_COLUMN`('cloud.quarantined_ips', > 'remover_account_id', 'bigint(20) unsigned DEFAULT NULL COMMENT "ID of > the account that removed the IP from quarantine, foreign key to > `account` > table"') > > 2024-02-08 14:19:19,647 ERROR [c.c.u.d.ScriptRunner] (main:null) > (logid:) > java.sql.SQLSyntaxErrorException: PROCEDURE > cloud.IDEMPOTENT_ADD_COLUMN does not exist > > 2024-02-08 14:19:19,648 ERROR [c.c.u.DatabaseUpgradeChecker] > (main:null) > (logid:) Unable to execute upgrade script > > java.sql.SQLSyntaxErrorException: PROCEDURE > cloud.IDEMPOTENT_ADD_COLUMN does not exist > > > > The database has not been modified in any way, the environment is > Ubuntu 22 and mysql 8 > > > > Regards, > > Piotr > >
