Bug #52987 mysqldump fails if umask=0077
Submitted: 20 Apr 2010 14:25 Modified: 14 Oct 2010 14:46
Reporter: Sven Sandberg Email Updates:
Status: Closed Impact on me:
None 
Category:Tests Severity:S7 (Test Cases)
Version:5.1+ OS:Any
Assigned to: Sven Sandberg CPU Architecture:Any
Tags: mysqldump, test, umask

[20 Apr 2010 14:25] Sven Sandberg
Description:
The test case mysqldump fails if mysql-test/std_data/words.dat is not world-readable. This means that it fails on all machines where the source tree was branched while umask=0077.

How to repeat:
$ umask 0077
$ bzr branch my:5.1 5.1
$ cd 5.1
$ ./BUILD/compile-pentium-debug-max
$ cd mysql-test
$ ./mtr mysqldump

Suggested fix:
=== modified file 'mysql-test/t/mysqldump.test'
--- mysql-test/t/mysqldump.test	2009-07-31 17:14:52 +0000
+++ mysql-test/t/mysqldump.test	2010-04-20 14:19:01 +0000
@@ -1983,6 +1983,7 @@
 create table `load` (a varchar(255));
 
 --copy_file std_data/words.dat $MYSQLTEST_VARDIR/tmp/load.txt
+--chmod 0644 $MYSQLTEST_VARDIR/tmp/load.txt
 
 --exec $MYSQL_IMPORT --ignore test $MYSQLTEST_VARDIR/tmp/load.txt
[21 Apr 2010 6:06] Sveta Smirnova
Thank you for the report.

Verified as described.
[19 May 2010 9:42] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108602

3387 Sven Sandberg	2010-05-19
      BUG#52987: mysqldump fails if umask=0077
      Problem: The test case mysqldump reads a file that must
      be world-readable. The test did not force the file to be
      world-readable, so if the tree was branched with a umask
      of 0077, the test would fail.
      Fix: chmod the file.
     @ mysql-test/t/mysqldump.test
        Added chmod so that the file is guaranteed to be world-readable.
[20 May 2010 15:26] Horst Hunger
ok. ready to push.
[20 May 2010 15:38] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108815

3392 Sven Sandberg	2010-05-20
      BUG#52987: mysqldump fails if umask=0077
      Problem: The test case mysqldump reads a file that must
      be world-readable. The test did not force the file to be
      world-readable, so if the tree was branched with a umask
      of 0077, the test would fail.
      Fix: chmod the file.
     @ mysql-test/t/mysqldump.test
        Added chmod so that the file is guaranteed to be world-readable.
[20 May 2010 20:16] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/108837

4072 Sven Sandberg	2010-05-20 [merge]
      merged bugfix for BUG#52987 from 5.1 to pe
[28 May 2010 6:02] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100524190136-egaq7e8zgkwb9aqi) (version source revid:alik@sun.com-20100524190136-egaq7e8zgkwb9aqi) (pib:16)
[28 May 2010 6:31] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100524190941-nuudpx60if25wsvx) (version source revid:alik@sun.com-20100524190409-5w4l7mje1wk1c90l) (merge vers: 6.0.14-alpha) (pib:16)
[28 May 2010 6:59] Bugs System
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100524185725-c8k5q7v60i5nix3t) (version source revid:alexey.kopytov@sun.com-20100523204118-0tl3goawu658rxh6) (merge vers: 5.5.5-m3) (pib:16)
[2 Jun 2010 8:49] Bugs System
Pushed into 5.1.48 (revid:georgi.kodinov@oracle.com-20100602084411-2yu607bslbmgufl3) (version source revid:sven.sandberg@sun.com-20100520153801-yyhujm1qqa4eyfn0) (merge vers: 5.1.47) (pib:16)
[14 Oct 2010 8:34] Bugs System
Pushed into mysql-5.1-telco-7.0 5.1.51-ndb-7.0.20 (revid:martin.skold@mysql.com-20101014082627-jrmy9xbfbtrebw3c) (version source revid:vasil.dimov@oracle.com-20100513074652-0cvlhgkesgbb2bfh) (merge vers: 5.5.5-m3) (pib:21)
[14 Oct 2010 8:49] Bugs System
Pushed into mysql-5.1-telco-6.3 5.1.51-ndb-6.3.39 (revid:martin.skold@mysql.com-20101014083757-5qo48b86d69zjvzj) (version source revid:vasil.dimov@oracle.com-20100513074652-0cvlhgkesgbb2bfh) (merge vers: 5.5.5-m3) (pib:21)
[14 Oct 2010 9:03] Bugs System
Pushed into mysql-5.1-telco-6.2 5.1.51-ndb-6.2.19 (revid:martin.skold@mysql.com-20101014084420-y54ecj85j5we27oa) (version source revid:vasil.dimov@oracle.com-20100513074652-0cvlhgkesgbb2bfh) (merge vers: 5.5.5-m3) (pib:21)
[14 Oct 2010 14:46] Jon Stephens
Testing only, closed.