Bug #18019 SELECT query returns wrong result after killing/restarting data node
Submitted: 7 Mar 2006 11:34 Modified: 23 Apr 2006 6:40
Reporter: Serge Kozlov Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version: OS:Linux (Linux FC4)
Assigned to: CPU Architecture:Any

[7 Mar 2006 11:34] Serge Kozlov 
Description:
There is 'ndb' suite in extra test tree and testcase 'ha_ndbd_kill_node.test' failed. 

After restarting killed node correct behaviour:
COUNT(a)        SUM(b)  MAX(b)  MIN(b)
1000    2000    2       2

Current (wrong) behaviour: 
COUNT(a)        SUM(b)  MAX(b)  MIN(b)
-1    2000    2       2

How to repeat:
1. Log into ndb16
2. Go to ~/skozlov/builds/mysql-test/suite/ndb directory
3. Run ./ndbtest.sh ndbtest.ini --do-test=ha_ndbd_kill_node
[7 Mar 2006 11:35] Serge Kozlov 
See trace files into ndb16:/space/bug18019
[4 Apr 2006 20:18] Serge Kozlov 
Currently the behaviour of bug changed (5.1.9 beta). At least the query returns correct results.
[23 Apr 2006 6:40] Jonas Oreland 
this is duplicate of bug#19202

FYI behavior did not change, just slightly different timing.