Bug #34070 ndb_restore_print.test: 'alter table t1 engine ndb' fails with errno: 157

• Submitted: 25 Jan 2008 20:44
• Modified: 2 Jul 2009 11:20
• Reporter: Timothy Smith
• Status: Can't repeat
• Category: Tests: Cluster
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: Any
• Assigned to: Bernt Marius Johnsen
• CPU Architecture: Any
• Tags: pbfail

[25 Jan 2008 20:44] Timothy Smith

Description:
Pushbuild shows this several times in 5.1-bk builds since Jan 10, 2008:

mysqltest: At line 79: query 'alter table t1 engine ndb' failed: 1005: Can't create table 'test.#sql-36de_3' (errno: 157)

Before that, a similar failure happened in Sept. and Oct. 2007:

Errors are (from /dev/shm/var-n_mix-100/log/mysqltest-time) :
mysqltest: At line 108: query 'create table t1
(pk int key
,f1 CHAR(1) BINARY, f2 CHAR(32) BINARY, f3 CHAR(255) BINARY
,g1 VARCHAR(32) BINARY, g2 VARCHAR(255) BINARY, g3 VARCHAR(1000) BINARY
,h1 BINARY(1), h2 BINARY(9), h3 BINARY(255)
,i1 VARBINARY(32), i2 VARBINARY(255), i3 VARBINARY(1000)
) engine ndb' failed: 1005: Can't create table 'test.t1' (errno: 157)

How to repeat:
Examine test failues for "errno: 157":

https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...

It happens on numerous platforms, Linux and Solaris, on x86, ia64, sparc & x86_64.

[2 Jul 2009 10:55] Bernt Marius Johnsen

This test failed like this

34 times in 2007
16 times in 2008, the last time in May.
2 times in 2009, both in January on bzr_mysql-5.1-telco-6.3

The problem seems to have vansihed, and I propose it is set to "Can't repeat".