API Gateway: Platform Patch 07-13-2020 APIGWv10 breaks Database
Article ID: 195170
Updated On:
Products
Issue/Introduction
Platform Patch https://ftp.broadcom.com/user/downloads/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.
Feedback
