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.
API Gateway 9.4 ,10.X
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.