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

book

Article ID: 4404

calendar_today

Updated On:

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 

 

Cause

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

 

Environment

API Portal 3.5MySQL 5.5.45MySQL Cluster NDB 7.2

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.