Bug #38315 "Cluster Failure" in ps_7ndb
Submitted: 23 Jul 2008 16:00 Modified: 6 Jul 2009 9:04
Reporter: Daniel Fischer Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:mysql-5.0 OS:Any (Solaris 10 x86, linux)
Assigned to: CPU Architecture:Any
Tags: 5.0 current
Triage: Triaged: D3 (Medium) / R6 (Needs Assessment) / E6 (Needs Assessment)

[23 Jul 2008 16:00] Daniel Fischer
Description:
The ps__7ndb test randomly and rarely fails with a "Cluster Failure" error:

ps_7ndb [ fail ]

mysqltest: In included file "./include/ps_create.inc": At line 25: query 'create table t1
(
a int, b varchar(30),
primary key(a)
) engine = $type ' failed: 157: Could not connect to storage engine

The result from queries just before the failure was:
use test;
drop table if exists t1, t9 ;
create table t1
(
a int, b varchar(30),
primary key(a)
) engine = 'NDB'  ;

More results from queries before failure can be found in /export/home/pb2/test/sourcebuilder-build-1000-1216815843.9/mysql-5.0.68-solaris10-i386-test/mysql-test/var/log/ps_7ndb.log

Warnings from just before the error:
Error 1296 Got error 4009 'Cluster Failure' from NDB

How to repeat:
No idea, it's a random failure.
[23 Jul 2008 17:16] Hartmut Holzgraefe
Is it possible to retrieve the cluster logs and trace files when this happens?
[23 Jul 2008 17:24] Daniel Fischer
They were overwritten by a different test running later.
[23 Aug 2008 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[6 Jul 2009 8:58] Georgi Kodinov
Still failing in 5.0-bugteam and 5.0-main
[6 Jul 2009 9:03] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/77988

2793 Georgi Kodinov	2009-07-06
      Bug#38315 and Bug#35148: disabled sporadically failing NDB tests
[6 Jul 2009 9:04] Georgi Kodinov
moving back to verified. Just a test case disablement
[7 Jul 2009 7:52] Bugs System
Pushed into 5.0.84 (revid:joro@sun.com-20090707074938-ksah1ibn0vs92cem) (version source revid:joro@sun.com-20090706090156-8ueejauuku7xm9yn) (merge vers: 5.0.84) (pib:11)
[8 Jul 2009 13:30] Bugs System
Pushed into 5.1.37 (revid:joro@sun.com-20090708131116-kyz8iotbum8w9yic) (version source revid:joro@sun.com-20090706090729-iso31mxw10fxqqhr) (merge vers: 5.1.37) (pib:11)
[9 Jul 2009 7:35] Bugs System
Pushed into 5.0.84 (revid:joro@sun.com-20090707074938-ksah1ibn0vs92cem) (version source revid:joro@sun.com-20090706090156-8ueejauuku7xm9yn) (merge vers: 5.0.84) (pib:11)
[9 Jul 2009 7:36] Bugs System
Pushed into 5.1.37 (revid:joro@sun.com-20090708131116-kyz8iotbum8w9yic) (version source revid:joro@sun.com-20090706090729-iso31mxw10fxqqhr) (merge vers: 5.1.37) (pib:11)
[10 Jul 2009 11:21] Bugs System
Pushed into 5.4.4-alpha (revid:anozdrin@bk-internal.mysql.com-20090710111017-bnh2cau84ug1hvei) (version source revid:joro@sun.com-20090706095557-11y1wz36gwyjyrd4) (merge vers: 5.4.4-alpha) (pib:11)
[26 Aug 2009 13:46] Bugs System
Pushed into 5.1.37-ndb-7.0.8 (revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)
[26 Aug 2009 13:46] Bugs System
Pushed into 5.1.37-ndb-6.3.27 (revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (version source revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (merge vers: 5.1.37-ndb-6.3.27) (pib:11)
[26 Aug 2009 13:48] Bugs System
Pushed into 5.1.37-ndb-6.2.19 (revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (version source revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (merge vers: 5.1.37-ndb-6.2.19) (pib:11)
[27 Aug 2009 16:33] Bugs System
Pushed into 5.1.35-ndb-7.1.0 (revid:magnus.blaudd@sun.com-20090827163030-6o3kk6r2oua159hr) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)