Portal upgrade fails from 5.0.2 to 5.1.2 release.
Error found in the db-upgrade container log.
Jun 19 10:50:29 hostname eab22d62199e[3779]: Unexpected error running Liquibase: Migration failed for change set doesntmatter::portaldb-28.2-DML-Adding-EmailTemplate-AppDeleteApprovalNotification-To-EMAIL_TEMPLATE-Table.xml::mr654504:
Jun 19 10:50:29 hostname eab22d62199e[3779]: Reason: liquibase.exception.DatabaseException: FUNCTION portal.generate_uuid does not exist
Release : 5.0.2
The db-upgrade Liquibase scripts removed the FUNCTIONS during upgrade but failed to create new ones.
mysql> SHOW FUNCTION STATUS WHERE db = 'portal';
Empty set (0.02 sec)
Manually created the below FUNCTIONS.
CREATE DEFINER=`msqladmin`@`%` FUNCTION `generate_uuid`() RETURNS varchar(36) CHARSET utf8mb4 DETERMINISTIC RETURN UUID();
CREATE DEFINER=`msqladmin`@`%` FUNCTION `AES_DECRYPT_PORTAL`() RETURNS varchar(36) CHARSET utf8mb4 DETERMINISTIC RETURN UUID();
CREATE DEFINER=`msqladmin`@`%` FUNCTION `AES_ENCRYPT_PORTAL`() RETURNS varchar(36) CHARSET utf8mb4 DETERMINISTIC RETURN UUID();
CREATE DEFINER=`msqladmin`@`%` FUNCTION `current_ms`() RETURNS varchar(36) CHARSET utf8mb4 DETERMINISTIC RETURN UUID();
-----------------------
Run portal.sh script to start portal upgrade.