ERROR 1297 (HY000): Got temporary error 20016 'Query aborted due to node failure' from NDBCLUSTER

[Philippe Havard]

Hi,

Here the config of my cluster:

[ndbd(NDB)] 4 node(s)
id=1 @172.16.1.101 (mysql-5.6.21 ndb-7.3.7, Nodegroup: 0)
id=2 @172.16.1.102 (mysql-5.6.21 ndb-7.3.7, Nodegroup: 0, *)
id=3 @172.16.1.103 (mysql-5.6.21 ndb-7.3.7, Nodegroup: 1)
id=4 @172.16.1.104 (mysql-5.6.21 ndb-7.3.7, Nodegroup: 1)

[ndb_mgmd(MGM)] 2 node(s)
id=49 @172.16.1.107 (mysql-5.6.21 ndb-7.3.7)
id=52 @172.16.1.108 (mysql-5.6.21 ndb-7.3.7)

[mysqld(API)] 2 node(s)
id=61 @172.16.1.105 (mysql-5.6.21 ndb-7.3.7)
id=63 @172.16.1.106 (mysql-5.6.21 ndb-7.3.7)

When running a simple query like the one above, I get: ERROR 1297 (HY000): Got temporary error 20016 'Query aborted due to node failure' from NDBCLUSTER

SELECT `profiles`.*
FROM `profiles`, `customers`, `account_customer_accesses`, `accounts`, `billing_cycles`
WHERE `billing_cycles`.`day` = 2
AND `billing_cycles`.`latest_month` = 11
AND `billing_cycles`.`account_id` = `accounts`.`id`
AND `accounts`.`id` = `account_customer_accesses`.`account_id`
AND `account_customer_accesses`.`customer_id` = `customers`.`id`
AND `customers`.`id` = `profiles`.`customer_id`

Thnaks for your help