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

Document ID : KB000004404
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.