Getting error during the CA API Gateway upgrade

Products

• CA API Gateway

Issue/Introduction

We are upgrading our CA API Gateway from version 9.4 to version 10.0 in containerized form and MYSQL DB from version 5.7 to 8.0 is successfully upgraded.

- We are unable to start our services getting below error at CA API end

- When we are starting the CA API container service, all the connection are going in time wait state after that connection is  getting closed.

- We have validated all the 105 tables is present.

Environment

API Gateway 9.4 ,10.X

Resolution

The password for the SSG_ADMIN_USER had expired. Once it was corrected and also by adding the below settings in the docker-compose.yaml , it was okay .

--character-set-server=utf8mb3

Also the volume mount that were added in the docker-compose.yaml file were having permission issues. Once that was corrected it was okay.