Portal outage observed during API Group Un assignment

Products

• CA API Developer Portal

Issue/Introduction

We observed a 10 min portal outage during performing api group Un assignment. We run the below query to delete applications associated with the api group. The delete query took 3 min and during that time the portal was not accessible. Could you please check and let us know the reason

Command:

delete from APPLICATION_API_API_GROUP_XREF  <value1> where <value1>.API_GROUP_UUID = ‘<grp_uuid> AND <value1>.TENANT_ID = ‘<tenant_name>’;

638594 rows took 3 min 31 seconds 

 

Environment

Portal 5.x

Cause

The LARGE number of deletes caused mysql to run out of space for the redo log 

2025-07-20T01:50:28.880516Z 0 [Warning] [MY-013867] [InnoDB] Redo log is running out of free space, pausing user threads... Consider increasing innodb_redo_log_capacity.

2025-07-20T01:53:52.601763Z 0 [Warning] [MY-013867] [InnoDB] Redo log is running out of free space, pausing user threads... Consider increasing innodb_redo_log_capacity.

2025-07-20T01:53:58.686549Z 0 [ERROR] [MY-013059] [InnoDB] Out of space in the redo log. Checkpoint LSN: 148510969804. Consider increasing innodb_redo_log_capacity.

2025-07-20T01:54:03.686694Z 0 [ERROR] [MY-013059] [InnoDB] Out of space in the redo log. Checkpoint LSN: 148510969804. Consider increasing innodb_redo_log_capacity.

Resolution

The default REDO capacity is 100MB

mysql> show variables like 'innodb_redo_log_capacity';

innodb_redo_log_capacity                 104857600                         

Solution  needs to be done on both Master and Secondary mysql:  Command will be in increase Redo Log capacity to 200MB execute the following SQL statement:

mysql> set global innodb_redo_log_capacity=200*1024*1024;

Check

mysql> show variables like 'innodb_redo_log_capacity';

innodb_redo_log_capacity      209715200