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
• Status: Can't repeat
• 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

Description:
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'
      INITIAL_SIZE 16M
      UNDO_BUFFER_SIZE = 1M
      ENGINE=NDB;
Query OK, 0 rows affected (5.64 sec)

mysql> DROP LOGFILE GROUP log_group1 ENGINE=NDB;
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.