Bug #16552 CREATE TEMPORARY TABLE fails when using NDBCLUSTER

• Submitted: 16 Jan 2006 23:48
• Modified: 25 Feb 2006 20:09
• Reporter: Jonathan Miller
• Status: Closed
• Category: Server: Cluster
• Severity: S3 (Non-critical)
• Version: 5.1.6-alpha
• OS: Linux (Linux)
• Assigned to: Tomas Ulin

[16 Jan 2006 23:48] Jonathan Miller

Description:
rpl_row_flsh_tbls              [ fail ]

Errors are (from
/home/ndbdev/jmiller/clones/mysql-5.1-new/mysql-test/var/log/mysqltest-time) :
mysqltest: In included file "./extra/rpl_tests/rpl_flsh_tbls.test": At line 14: query
'insert into t4 select * from t3' failed: 1017: Can't find file: 't3' (errno: 2)

rpl_row_drop                   [ fail ]

Errors are (from
/home/ndbdev/jmiller/clones/mysql-5.1-new/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 9: query 'CREATE TEMPORARY TABLE t2 (a int, b int)' failed: 1: Can't
create/write to file './tmp/@0023sql4f1c_8_0.ndb' (Errcode: 2)

rpl_row_create_table           [ fail ]

Errors are (from
/home/ndbdev/jmiller/clones/mysql-5.1-new/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 43: query 'CREATE TEMPORARY TABLE tt3 (a INT, b INT)' failed: 1: Can't
create/write to file './tmp/@0023sql4d2b_3_0.ndb' (Errcode: 2)

How to repeat:
./mysql-test-run  --mysqld=--binlog-format=row --do-test=rpl --with-ndbcluster-all
--mysqld=--default-storage-engine=ndb

[26 Jan 2006 12:40] Jonathan Miller

Again, notes needed if you want to lower priority.

[17 Feb 2006 16:57] Tomas Ulin

fixed with bugfix of 17210

[23 Feb 2006 11:33] Jon Stephens

Duplicate of Bug #17210.

[25 Feb 2006 20:09] Jonathan Miller

Might have been fixes with the same patch, but was not them same bug Behavior as this one
produced failures where the other produced a core.