MySQL Forums
Forum List  »  NDB clusters

ERROR 1297 (HY000): Got temporary error 20008 'Query aborted due to out of query memory' from NDBCLUSTER
Posted by: david lerner
Date: April 09, 2014 07:12AM

Hello,

After implementing test cluster on 4 Azure Ubuntu large vms,
getting this error :
ERROR 1297 (HY000): Got temporary error 20008 'Query aborted due to out of query memory' from NDBCLUSTER,
When trying to execute large queries.

DB size is 8GB.

Cluster vesion gpl-7.3.4
Each machine has 7GB Ram, 4 core AMD CPU 2Ghz

config.ini:
[NDB_MGMD DEFAULT]
Portnumber=1186

[NDB_MGMD]
NodeId=49
HostName=maincdh-1
DataDir=/data/MySQL_Cluster/49/
Portnumber=1186

[NDB_MGMD]
NodeId=52
HostName=maincdh-2
DataDir=/data/MySQL_Cluster/52/
Portnumber=1186

[TCP DEFAULT]
SendBufferMemory=2M
ReceiveBufferMemory=2M

[NDBD DEFAULT]
BackupMaxWriteSize=1M
BackupDataBufferSize=16M
BackupLogBufferSize=4M
BackupMemory=20M
BackupReportFrequency=10
MemReportFrequency=30
LogLevelStartup=15
LogLevelShutdown=15
LogLevelCheckpoint=8
LogLevelNodeRestart=15
DataMemory=22G
IndexMemory=4G
MaxNoOfTables=4096
MaxNoOfTriggers=3500
NoOfReplicas=2
StringMemory=25
DiskPageBufferMemory=64M
SharedGlobalMemory=20M
LongMessageBuffer=32M
MaxNoOfConcurrentTransactions=16384
BatchSizePerLocalScan=512
FragmentLogFileSize=256M
NoOfFragmentLogFiles=21
RedoBuffer=32M
MaxNoOfExecutionThreads=4
StopOnError=false
LockPagesInMainMemory=1
TimeBetweenEpochsTimeout=32000
TimeBetweenWatchdogCheckInitial=60000
TransactionInactiveTimeout=60000
HeartbeatIntervalDbDb=1500
HeartbeatIntervalDbApi=1500

[NDBD]
NodeId=1
HostName=maincdh-1
DataDir=/data/MySQL_Cluster/1/

[NDBD]
NodeId=2
HostName=maincdh-2
DataDir=/data/MySQL_Cluster/2/

[NDBD]
NodeId=3
HostName=maincdh-3
DataDir=/data/MySQL_Cluster/3/

[NDBD]
NodeId=4
HostName=maincdh-4
DataDir=/data/MySQL_Cluster/4/

[MYSQLD DEFAULT]

[MYSQLD]
NodeId=50
HostName=maincdh-3

[MYSQLD]
NodeId=51
HostName=maincdh-4

[API]
NodeId=53
HostName=maincdh-3

[API]
NodeId=54
HostName=maincdh-4


Please Help

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 1297 (HY000): Got temporary error 20008 'Query aborted due to out of query memory' from NDBCLUSTER
2279
April 09, 2014 07:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.