Bug #20672 NDB regression fails if mysql-5.1 compiled with gcc4
Submitted: 23 Jun 2006 22:51 Modified: 16 Aug 2006 8:40
Reporter: Nikolay Grishakin Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:5.1 OS:Linux (Linux)
Assigned to: Stewart Smith CPU Architecture:Any

[23 Jun 2006 22:51] Nikolay Grishakin
Opening this bug per Calvin's request.

Here is the regression problem I'm having with mysql-5.1 and gcc4:

NDB regression fails with latest mysql-5.1 build compiled with compile-pentium-max.  "'DROP LOGFILE GROUP" is failing again.
TEST                           RESULT         TIME (ms)
ndb_dd_ddl                 [ fail ]
Errors are (from
/home/ndbdev/ngrishakin/mysql-5.1/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

To make it work I need to use compile-pentium-debug-max. 

How to repeat:
To reproduce, compile latest mysql-5.1 build using compile-pentium-max and run ndb test case, for example, ndb_dd_dll.test
[23 Jun 2006 22:53] Nikolay Grishakin
test case is "ndb_dd_ddl.test" not "_dll"
[24 Jun 2006 4:57] Nikolay Grishakin
To reproduce:
Clone mysql-5.1 tree. Build it with compile-pentium-max.
from mysql-test directory run the following commands:

[ndbdev@ndb15 mysql-test]$ perl mysql-test-run.pl --start-and-exit ndb_basic
[ndbdev@ndb15 mysql-test]$ mysql -uroot -h127.0.0.1 -P9306
mysql>CREATE LOGFILE GROUP log_group1
      ADD UNDOFILE 'undofile.dat'
Query OK, 0 rows affected (5.64 sec)

ERROR 1516 (HY000): Failed to drop LOGFILE GROUP
[24 Jun 2006 5:06] Nikolay Grishakin
mysql> show warnings;
| Level | Code | Message                                                                    |
| Error | 1297 | Got temporary error 701 'System busy with other schema operation' from NDB |
| Error | 1516 | Failed to drop LOGFILE GROUP                                               |
2 rows in set (0.00 sec)
[16 Aug 2006 8:40] Stewart Smith
can't repeat with 5.1.12 based 5.1-ndb tree with gcc4 on debug or non-debug build.

gcc (GCC) 4.0.3 (Ubuntu 4.0.3-1ubuntu5)

perhaps your 4.0.2 is buggy.