[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

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 


API Portal 3.5MySQL 5.5.45MySQL Cluster NDB 7.2

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



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.