ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 4404


Updated On:


CA API Developer Portal CA API Gateway


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 



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



API Portal 3.5MySQL 5.5.45MySQL Cluster NDB 7.2


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.