Bug #55094 Test 'partition' crashes in "embedded" run on FreeBSD

• Submitted: 8 Jul 2010 18:09
• Modified: 16 May 2013 4:49
• Reporter: Joerg Bruehe
• Status: Can't repeat
• Category: MySQL Server: Embedded Library ( libmysqld )
• Severity: S3 (Non-critical)
• Version: 5.1.46+
• OS: FreeBSD
• CPU Architecture: Any

[8 Jul 2010 18:09] Joerg Bruehe

Description:
This bug occurred (at least) in 5.1.46, 5.1.47, 5.1.48, 5.1.46sp1,
and in Cluster-7.1.5 which is based on the 5.1.47 server.

The embedded test program crashes when running test "partition" on FreeBSD.
The symptom slightly differs between FreeBSD 6.3 and 7.0, see below:

===== FreeBSD 7.0, both x86 and x86_64 =====
main.partition                           [ retry-fail ]
        Test ended at YYYY-MM-DD HH:MM:SS

CURRENT_TEST: main.partition
mysqltest got signal 11
Backtrace not available.
Writing a core file...

 - saving '/PATH/mysql-test/var/log/main.partition/' to '/PATH/mysql-test/var/log/main.partition/'
=====

===== FreeBSD 6.3, both x86 and x86_64 =====
main.partition                           [ retry-fail ]
        Test ended at YYYY-MM-DD HH:MM:SS

CURRENT_TEST: main.partition

mysqltest failed but provided no output
The result from queries just before the failure was:
< snip >
INSERT INTO t1 VALUES (6,8,10);
SELECT  1 FROM t1 JOIN t1 AS t2 USING (a) FOR UPDATE;
1
1
1
1
1
DROP TABLE t1;
#
# BUG#51868 - crash with myisam_use_mmap and partitioned myisam tables
#
SET GLOBAL myisam_use_mmap=1;
CREATE TABLE t1(a INT) PARTITION BY HASH(a) PARTITIONS 1;
INSERT INTO t1 VALUES(0);
FLUSH TABLE t1;
TRUNCATE TABLE t1;
INSERT INTO t1 VALUES(0);
DROP TABLE t1;
SET GLOBAL myisam_use_mmap=default;
End of 5.1 tests

 - saving '/PATH/mysql-test/var/log/main.partition/' to '/PATH/mysql-test/var/log/main.partition/'
=====

How to repeat:
Run the test suite, embedded.