API Gateway: Platform Patch 07-13-2020 APIGWv10 breaks Database

book

Article ID: 195170

calendar_today

Updated On:

Products

CA API Gateway API SECURITY CA Microgateway

Issue/Introduction

Platform Patch ftp://ftp.ca.com/pub/API_Management/Gateway/Platform_Patch/v10.x/Layer7_API_PlatformUpdate_64bit_v10.X-CentOS-2020-07-13.L7P was released for APIGW vApp Centos v10. 

However, this Patch breaks MySQL and it will not restart afterwards. The new script added skip partition to /etc/my.cnf, but this is not supported in MySQL 8.0 causing MySQL not to work.

Environment

Release : 10.0

Component : API GATEWAY

Resolution

Platform patch Layer7_API_PlatformUpdate_64bit_v10.X-CentOS-2020-07-13.L7P including MySQL 8.0.20.to resolve an issue with MySQL randomly restarting.


Unfortunately, this fix did introduce a new issue: the update script inserts the setting "skip-partition" into the [mysqld] setting of /etc/my.cnf, which is not compatible with MySQL 8.0. We are recommending you revert to a snapshot, or if no snapshot or back up is available manually commenting it out should resolve the issue.

Please note if you are not able to revert your snapshot you may run into partitioning issues as well, as MySQL 8.0.20 has increased in size.

Additional Information

This patch has been pulled.  Engineering is looking into these matters.