Bug #38315 "Cluster Failure" in ps_7ndb

• Submitted: 23 Jul 2008 16:00
• Modified: 6 Jul 2009 9:04
• Reporter: Daniel Fischer
• Status: Verified
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: mysql-5.0
• OS: Any (Solaris 10 x86, linux)
• CPU Architecture: Any
• Tags: 5.0 current

[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:[e-mail]-20090707074938-ksah1ibn0vs92cem) (version source revid:[e-mail]-20090706090156-8ueejauuku7xm9yn) (merge vers: 5.0.84) (pib:11)

[8 Jul 2009 13:30] Bugs System

Pushed into 5.1.37 (revid:[e-mail]-20090708131116-kyz8iotbum8w9yic) (version source revid:[e-mail]-20090706090729-iso31mxw10fxqqhr) (merge vers: 5.1.37) (pib:11)

[9 Jul 2009 7:35] Bugs System

Pushed into 5.0.84 (revid:[e-mail]-20090707074938-ksah1ibn0vs92cem) (version source revid:[e-mail]-20090706090156-8ueejauuku7xm9yn) (merge vers: 5.0.84) (pib:11)

[9 Jul 2009 7:36] Bugs System

Pushed into 5.1.37 (revid:[e-mail]-20090708131116-kyz8iotbum8w9yic) (version source revid:[e-mail]-20090706090729-iso31mxw10fxqqhr) (merge vers: 5.1.37) (pib:11)

[10 Jul 2009 11:21] Bugs System

Pushed into 5.4.4-alpha (revid:[e-mail]-20090710111017-bnh2cau84ug1hvei) (version source revid:[e-mail]-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:[e-mail]-20090826132541-yablppc59e3yb54l) (version source revid:[e-mail]-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:[e-mail]-20090826105955-bkj027t47gfbamnc) (version source revid:[e-mail]-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:[e-mail]-20090825194404-37rtosk049t9koc4) (version source revid:[e-mail]-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:[e-mail]-20090827163030-6o3kk6r2oua159hr) (version source revid:[e-mail]-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)