[MDEV-4214] Building 5.5.29 sources one test fails: main.partition_rename_longfilename Created: 2013-02-27  Updated: 2013-03-14  Resolved: 2013-03-14

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.29
Fix Version/s: 10.0.2, 5.5.31

Type: Bug Priority: Major
Reporter: Otto Kekäläinen Assignee: Elena Stepanova
Resolution: Fixed Votes: 0
Labels: None
Environment:

Ubuntu 12.04


Attachments: File main.partition_rename_longfilename.tar.gz    

 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



 Comments   
Comment by Otto Kekäläinen [ 2013-02-27 ]

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.

Comment by Elena Stepanova [ 2013-02-28 ]

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

Comment by Elena Stepanova [ 2013-03-07 ]

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.

Comment by Sergei Golubchik [ 2013-03-14 ]

ok to push

Regards,
Sergei

Comment by Elena Stepanova [ 2013-03-14 ]

Thanks!

Comment by Elena Stepanova [ 2013-03-14 ]

Pushed into maria/5.5 as revno 3697

Generated at Thu Feb 08 06:54:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.