[CA APIM] MySQL Cluster (Portal DB) After setting, the Portal login failures

Products

• CA API Developer Portal
• CA API Gateway

Issue/Introduction

After "Configure Portal Database Clustering",

Can not log-in to API Portal. 

The following error appeared. 

It appears your session has timed out.

 

Also, the following error occurs frequently. 

(ReplicationActionThread:) - Got temporary error 20008 'Query aborted due to out of query memory' from NDBCLUSTER 

(ReplicationActionThread:) - [ReplicationManager general] -- org.hibernate.exception.GenericJDBCException: could not extract ResultSet 

 

Environment

API Portal 3.5MySQL 5.5.45MySQL Cluster NDB 7.2

Cause

The configuration of MySQLCluster isn't proper for the environment.

 

Resolution

Change config.ini of MySQLCluster.

01. Add  "MaxAllocate" set value 128MB (or more)

    example: MaxAllocate=128M

02. Remove it if "SharedGlobalMemory=0" exists  in the config.ini.