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