After Upgrading API Gateway from 10.0 to 10.1 CR 2 gateway take a long to to start

Products

• CA API Gateway

Issue/Introduction

After Upgrading API Gateway from 10.0 to 10.1 CR 2

It takes 18 minutes to start up 

 

Environment

Release : 10.1

Cause

SSG Logs show the auto archiver where the time is spent. This may have been a one time run after the upgrade that took the time (before and after 8 minutes each).  

NOTE: There are over 8 Million records in audit main table are these records required to keep of off box them 

2022-12-09T11:06:29.454-0500 INFO    1901 com.l7tech.server.service.ServiceCache: Created/Updated/Deleted: [c6b320f0ca043527d40d48eb6ea16954]

2022-12-09T11:15:29.290-0500 INFO    72 com.l7tech.server.audit.AuditArchiver: Starting Audit Archiver check.

2022-12-09T11:15:29.324-0500 INFO    72 com.l7tech.server.audit.AuditArchiver: Below start_archive threshold, not starting archiver thread.

2022-12-09T11:22:04.003-0500 SEVERE  1 com.networknt.schema.JsonSchemaFactory: Failed to load json schema!

java.io.FileNotFoundException: http://example.com/example.json

Resolution

Clear out audit data

If records are not need suggest access mysql and clean up audit tables 

Mysql 8 run the query to cleanup and analyze tables 

# mysql

mysql>

SET FOREIGN_KEY_CHECKS = 0;

truncate table audit_admin;

truncate table audit_detail;

truncate table audit_detail_params;

truncate table audit_main;

truncate table audit_message;

truncate table audit_system;

SET FOREIGN_KEY_CHECKS = 1;

analyze table audit_admin;

analyze table audit_detail;

analyze table audit_detail_params;

analyze table audit_main;

analyze table audit_message;

analyze table audit_system;