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
