Bug #39987 main.partition_not_windows fails under debug build

• Submitted: 12 Oct 2008 10:35
• Modified: 29 Oct 2008 12:42
• Reporter: Michael Widenius
• Status: Duplicate
• Category: Server
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: Linux (openSUSE 10.3)
• Assigned to: Mattias Jonsson
• Target Version: 5.1+
• Triage: Triaged: D3 (Medium)

[12 Oct 2008 10:35] Michael Widenius

Description:
Regression from Bug#32167

With a debug build, main.partition_not_windows dies with:

mysqltest: At line 40: query 'ALTER TABLE t1 REORGANIZE PARTITION p0 INTO
(partition p1 VALUES LESS THAN (1) $data_directory $inx_directory
(SUBPARTITION subpart10, SUBPARTITION subpart11),
partition p2 VALUES LESS THAN (2) $data_directory $inx_directory
(SUBPARTITION subpart20, SUBPARTITION subpart21))' failed: 1030: Got error 140 from
storage engine

How to repeat:
BUILD/compile-pentium64-valgrind-max
mysql-test-run main.partition_not_windows

Suggested fix:
mysqld.cc:

@@ -7473,6 +7487,10 @@ static void mysql_init_variables(void)
   /* Things reset to zero */
   opt_skip_slave_start= opt_reckless_slave = 0;
   mysql_home[0]= pidfile_name[0]= log_error_file[0]= 0;
+#if defined(HAVE_REALPATH) && !defined(HAVE_purify) && !defined(HAVE_BROKEN_REALPATH)
+  /*  We can only test for sub paths if my_symlink.c is using realpath */
+  myisam_test_invalid_symlink= test_if_data_home_dir;
+#endif

[14 Oct 2008 12:04] Mattias Jonsson

This is a duplicate of bug#39102.

[26 Oct 2008 23:20] Bugs System

Pushed into 6.0.8-alpha  (revid:[e-mail]-20081012100952-h39szt1kgq6j0tj4) (version
source revid:[e-mail]-20081020191322-i0e65e3k8044kkce) (pib:5)

[29 Oct 2008 12:42] Mattias Jonsson

Duplicate of bug#39102. (pushed into the 51-bugteam)