Gateway Fails To Start Up Within AWS EKS Environment

Products

• CA API Gateway

Issue/Introduction

We are deploying a new Kubernetes gateway within AWS EKS which is connecting to an external AWS RDS Mysql database.

The gateway does not start up and when viewing the logs of the pod the last entry is the following:

Waiting for one of the databases to come up...

Environment

All supported versions of the CA API Gateway

Cause

After enabling mysql debug on the external RDS database side we could see the following error getting logged when the gateway was trying to start up and create the DATABASECHANGELOG table within the ssg database.

Error Code: 3750. Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting.

Resolution

Execute the following mysql query:

SET GLOBAL sql_require_primary_key = OFF;

 

The gateway was then able to fully start up successfully.