Details
Major
Description
I downloaded there official MariaDB release as tar.gz from mariadb.org and while trying to build it, one of the mysql-test failed: main.partition_rename_longfilename
Running the individual test gives the following output:
$ ./mysql-test-run main.partition_rename_longfilename
Logging: ./mysql-test-run main.partition_rename_longfilename
vardir: /home/otto/MariaDB/mariadb-5.5-5.5.29/builddir/mysql-test/var
Checking leftover processes...
- found old pid 24625 in 'mysqld.3.pid', killing it...
process did not exist!
mysql-test-run: WARNING: Found non pid file 'mysqld.err' in '/home/otto/MariaDB/mariadb-5.5-5.5.29/builddir/mysql-test/var/run'
mysql-test-run: WARNING: Found non pid file 'mytest.log' in '/home/otto/MariaDB/mariadb-5.5-5.5.29/builddir/mysql-test/var/run'
Removing old var directory...
Creating var directory '/home/otto/MariaDB/mariadb-5.5-5.5.29/builddir/mysql-test/var'...
Checking supported features...
MariaDB Version 5.5.29-MariaDB-mariadb1~precise
Installing system database...
- skipping ndbcluster
- SSL connections supported
Collecting tests...
Using server port 59245
==============================================================================
TEST RESULT TIME (ms) or COMMENT
--------------------------------------------------------------------------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
main.partition_rename_longfilename [ fail ]
Test ended at 2013-02-27 23:24:42
CURRENT_TEST: main.partition_rename_longfilename
mysqltest: At line 28: query 'RENAME TABLE t1 TO `t2_............................end`' failed: 7: Error on rename of './test/t1#P#p0.MYI' to './test/t2_@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p0.MYI' (Errcode: 36)
The result from queries just before the failure was:
< snip >
PARTITION p2 VALUES LESS THAN MAXVALUE);
# List of files in database `test`, all original t1-files here
t1#P#p0.MYD
t1#P#p0.MYI
t1#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYD
t1#P#p1@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e.MYI
t1#P#p2.MYD
t1#P#p2.MYI
t1.frm
t1.par
INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
# Renaming to a file name where the first partition is 155 chars
# and the second partition is 255 chars
RENAME TABLE t1 TO `t2_............................end`;
More results from queries before failure can be found in /home/otto/MariaDB/mariadb-5.5-5.5.29/builddir/mysql-test/var/log/partition_rename_longfilename.log
- saving '/home/otto/MariaDB/mariadb-5.5-5.5.29/builddir/mysql-test/var/log/main.partition_rename_longfilename/' to '/home/otto/MariaDB/mariadb-5.5-5.5.29/builddir/mysql-test/var/log/main.partition_rename_longfilename/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 4 seconds executing testcases
Failure: Failed 1/1 tests, 0.00% were successful.
Failing test(s): main.partition_rename_longfilename
var/log/main.partition_rename_longfilename/ attached
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
From IRC:
<montywi> otto_: ok; We should test that when MariaDB starts and disable this test if it can't create files with 255 characters.
...
<montywi> better to use perl
...
<montywi> so for the test, it's enough to check if we can create a 255 file name in datadir
The change is currently in 5.5-elenst:
http://bazaar.launchpad.net/~elenst/maria/5.5-elenst/revision/3686
It will be pushed into maria/5.5 after release 5.5.30, since it's not urgent, to avoid disturbing the ongoing release process.
ok to push
Regards,
Sergei
Thanks!
Pushed into maria/5.5 as revno 3697
The filename 't2_@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002eend#P#p0.MYI' is 155 characters long, and as I have my home folder encrypted using eCryptFS, filenames above 140 characters might be too long (as the encrypted version can't fit 255 characters).
So this issues is indeed restricted to my setup. Normal users are very unlikely to run a MariaDB server on a eCryptFS partition and certainly binaries can be built on unenctypted partitions, so we can ignore this test error.