Bug #22020 ndb_dd_<various> tests fail, amd64 Linux
Submitted: 5 Sep 2006 13:50 Modified: 5 Sep 2006 20:38
Reporter: Patrick Galbraith Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Cluster: Disk Data Severity:S1 (Critical)
Version:5.1 OS:Linux (Linux)
Assigned to: Assigned Account CPU Architecture:Any

[5 Sep 2006 13:50] Patrick Galbraith
Description:
I am trying to merge 5.1 main to 5.1 engines, and keep getting failures 
with various ndb tests. I tried a stock 5.1 tree on dserv-b, and it fails 
during make test at:

ndb_dd_advance                 [ fail ]

Errors are (from /users/pgalbraith/mysql-build/mysql-5.1-clone/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 203: query 'DROP LOGFILE GROUP log_group1
ENGINE =NDB' failed: 1516: Failed to drop LOGFILE GROUP
(the last lines may be the most important ones)

Result from queries before failure can be found in r/ndb_dd_advance.log

or:

./mysql-test-run.pl --start-from=ndb_dd_advance --force

=======================================================
Starting Tests in the 'main' suite

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

ndb_dd_advance                 [ fail ]

Errors are (from /users/pgalbraith/mysql-build/mysql-5.1-clone/mysql-test/var/log/mysqltest-time) :

mysqltest: At line 203: query 'DROP LOGFILE GROUP log_group1
ENGINE =NDB' failed: 1516: Failed to drop LOGFILE GROUP
(the last lines may be the most important ones)
Result from queries before failure can be found in r/ndb_dd_advance.log

Stopping All Servers
Shutting-down Instance Manager
Restoring snapshot of databases
Resuming Tests

ndb_dd_advance2                [ fail ]

Errors are (from /users/pgalbraith/mysql-build/mysql-5.1-clone/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 144: query 'DROP LOGFILE GROUP lg
ENGINE=NDB' failed: 1516: Failed to drop LOGFILE GROUP
(the last lines may be the most important ones)
Result from queries before failure can be found in r/ndb_dd_advance2.log

Stopping All Servers
Shutting-down Instance Manager
Restoring snapshot of databases
Resuming Tests

ndb_dd_backuprestore           [ fail ]

Errors are (from /users/pgalbraith/mysql-build/mysql-5.1-clone/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 65: query 'DROP LOGFILE GROUP log_group1
ENGINE =NDB' failed: 1516: Failed to drop LOGFILE GROUP
(the last lines may be the most important ones)
Result from queries before failure can be found in r/ndb_dd_backuprestore.log

Stopping All Servers
Shutting-down Instance Manager
Restoring snapshot of databases
Resuming Tests

ndb_dd_basic                   [ fail ]

Errors are (from /users/pgalbraith/mysql-build/mysql-5.1-clone/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 363: query 'DROP LOGFILE GROUP lg1 
ENGINE =NDB' failed: 1516: Failed to drop LOGFILE GROUP
(the last lines may be the most important ones)
Result from queries before failure can be found in r/ndb_dd_basic.log

Stopping All Servers
Shutting-down Instance Manager
Restoring snapshot of databases
Resuming Tests

ndb_dd_ddl                     [ fail ]

Errors are (from /users/pgalbraith/mysql-build/mysql-5.1-clone/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 141: query 'DROP LOGFILE GROUP lg1 
ENGINE=NDB' failed: 1516: Failed to drop LOGFILE GROUP
(the last lines may be the most important ones)
Result from queries before failure can be found in r/ndb_dd_ddl.log

Stopping All Servers
Shutting-down Instance Manager
Restoring snapshot of databases
Resuming Tests

ndb_dd_disk2memory             [ fail ]

Errors are (from /users/pgalbraith/mysql-build/mysql-5.1-clone/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 182: query 'DROP LOGFILE GROUP log_group1
ENGINE =NDB' failed: 1516: Failed to drop LOGFILE GROUP
(the last lines may be the most important ones)
Result from queries before failure can be found in r/ndb_dd_disk2memory.log

Stopping All Servers
Shutting-down Instance Manager
Restoring snapshot of databases
Resuming Tests

ndb_dd_dump                    [ fail ]

Errors are (from /users/pgalbraith/mysql-build/mysql-5.1-clone/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 195: query 'DROP LOGFILE GROUP lg1 ENGINE = NDB' failed: 1516: Failed to drop LOGFILE GROUP
(the last lines may be the most important ones)
Result from queries before failure can be found in r/ndb_dd_dump.log

Stopping All Servers
Shutting-down Instance Manager
Restoring snapshot of databases
Resuming Tests

How to repeat:
'make test' or 'cd mysql-test; ./mysql-test-run.pl ndb_dd_advance'

or better yet './mysql-test-run.pl --start-from=ndb_dd_advance --force'
[5 Sep 2006 13:56] Jonas Oreland
Which gcc version are you using ?
(cause I just fixed some gcc4 problems)
[5 Sep 2006 15:08] Patrick Galbraith
MySQL's own server, devsrv-b:

pgalbraith@devsrv-b:~/mysql-build/mysql-5.1-clone/mysql-test> gcc -v
Using built-in specs.
Target: x86_64-suse-linux
Configured with: ../configure --enable-threads=posix --prefix=/usr --with-local-prefix=/usr/local --infodir=/usr/share/info --mandir=/usr/share/man --libdir=/usr/lib64 --libexecdir=/usr/lib64 --enable-languages=c,c++,objc,f95,java,ada --disable-checking --with-gxx-include-dir=/usr/include/c++/4.0.2 --enable-java-awt=gtk --disable-libjava-multilib --with-slibdir=/lib64 --with-system-zlib --enable-shared --enable-__cxa_atexit --without-system-libunwind --host=x86_64-suse-linux
Thread model: posix
gcc version 4.0.2 20050901 (prerelease) (SUSE Linux)
[5 Sep 2006 20:38] Jonas Oreland
Hi,

I tested 5.1 and 5.1-new-ndb,
  it failed in 5.1 and worked in 5.1-new-ndb

Making it a perfect duplicate of http://bugs.mysql.com/bug.php?id=21981

/Jonas