MySQL Forums
Forum List  »  NDB clusters

Got temporary error 20016 'Query aborted due to node failure' from NDBCLUSTER
Posted by: ketan patel
Date: November 14, 2012 09:30AM

Strange issue on NDBCLUSTER.

same query runs on all clusters, with same configuration, it is just one cluster having this error

JFI ::
Version :: 5.5.19-ndb-7.2.4-gpl-log
all cluster has same OS / same package / same image / same versions
all data nodes and managmenet node is up, while it has produced this error.

error i have received is

Statement :: select count(*) from dim_time t inner join fact_message m on t.timeId = m.timeId inner join dim_country sc on m.senderCountryId=sc.countryId where t.date between '2012-11-01' and '2012-11-05';
ERROR 1296 (HY000): Got error -1 'Unknown error code' from NDBCLUSTER

Statement :: select count(*) from dim_time t LEFT join fact_message m on t.timeId = m.timeId LEFT join dim_country sc on m.senderCountryId=sc.countryId where t.date between '2012-11-01' and '2012-11-05';
ERROR 1297 (HY000): Got temporary error 20016 'Query aborted due to node failure' from NDBCLUSTER

if i do == select count(*) from fact_message; and select count(*) from dim_time; works fine.

have following error in API log - [ERROR] Got error 20016 when reading table './fact_message'

Starting thread because "http://forums.mysql.com/read.php?25,515068,515818#msg-515818"; is closed for response.

in order to fix issue i have to execute "SET ndb_join_pushdown = 0;" before query and error is gone.

It could be bug, not sure.

Thank you



Edited 1 time(s). Last edit at 11/14/2012 09:32AM by ketan patel.

Options: ReplyQuote


Subject
Views
Written By
Posted
Got temporary error 20016 'Query aborted due to node failure' from NDBCLUSTER
8568
November 14, 2012 09:30AM


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.