Bug #71112 Various test suite files have execute bit set but aren't executable
Submitted: 9 Dec 2013 5:05 Modified: 25 Jun 2014 16:15
Reporter: Stewart Smith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Packaging Severity:S3 (Non-critical)
Version:5.5 (all), 5.6 (all) OS:Any
Assigned to: CPU Architecture:Any
Tags: Debian, packaging

[9 Dec 2013 5:05] Stewart Smith
Description:
Found by lintian (lint for debian packages):

 W executable-not-elf-or-script

    usr/lib/mysql-testsuite/collections/default.weekly
    usr/lib/mysql-testsuite/collections/default.weekly
    usr/lib/mysql-testsuite/r/lowercase_table4.result
    usr/lib/mysql-testsuite/r/lowercase_table4.result
    usr/lib/mysql-testsuite/suite/innodb/r/innodb_bug57904.result
    usr/lib/mysql-testsuite/suite/innodb/r/innodb_bug57904.result
    usr/lib/mysql-testsuite/suite/innodb/r/innodb_bug60196.result
    usr/lib/mysql-testsuite/suite/innodb/r/innodb_bug60196.result
    usr/lib/mysql-testsuite/suite/innodb/t/innodb_bug57904.test
    usr/lib/mysql-testsuite/suite/innodb/t/innodb_bug57904.test
    usr/lib/mysql-testsuite/suite/innodb/t/innodb_bug60196-master.opt
    usr/lib/mysql-testsuite/suite/innodb/t/innodb_bug60196-master.opt
    usr/lib/mysql-testsuite/suite/innodb/t/innodb_bug60196.test
    usr/lib/mysql-testsuite/suite/innodb/t/innodb_bug60196.test
    usr/lib/mysql-testsuite/t/lowercase_table4-master.opt
    usr/lib/mysql-testsuite/t/lowercase_table4-master.opt
    usr/lib/mysql-testsuite/t/lowercase_table4.test
    usr/lib/mysql-testsuite/t/lowercase_table4.test

All of the above files are not executable, but have the execute bit set.

How to repeat:
build debian packages, run lintian on them

Suggested fix:
chmod -x the above files, then bzr commit.

I've done this in the Percona Server repositories and the warning goes away.
[9 Dec 2013 7:45] MySQL Verification Team
Hello Stewart,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh
[9 Dec 2013 7:51] MySQL Verification Team
How to repeat:

umshastr@pan10:~/setup$lintian mysql-5.6.15-debian6.0-i686.deb > /tmp/bug.log
umshastr@pan10:~/setup$ cat /tmp/bug.log|grep -i W:
E: mysql: embedded-library opt/mysql/server-5.6/bin/mysqlshow: zlib
E: mysql: embedded-library opt/mysql/server-5.6/bin/mysqlshow: libmysqlclient
W: mysql: missing-depends-line
W: mysql: extra-license-file opt/mysql/server-5.6/COPYING
W: mysql: script-not-executable opt/mysql/server-5.6/mysql-test/std_data/checkDBI_DBD-mysql.pl
W: mysql: script-not-executable opt/mysql/server-5.6/mysql-test/suite/opt_trace/validate_json.py
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_qa_3.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_innodb.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_qa_7_innodb.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_myisam.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_qa_8_myisam.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/t/portability_wl5980_windows.zip
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/r/innodb-wl5980-debug.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_qa_4_myisam.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/t/innodb-wl5980-discard.test
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_qa_8_innodb.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/include/check_ipv4_mapped.inc
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/t/lowercase_table4-master.opt
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_qa_4_innodb.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/include/start_mysqld.inc
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_qa_11.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/bin/mysqlaccess.conf
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/share/innodb_memcached_config.sql
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/t/innodb_bug57904.test
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/r/innodb_bug57904.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/t/innodb-wl5980-debug.test
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/include/have_QC_Disabled.inc
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/r/innodb_bug14169459.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_qa_5_myisam.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/support-files/mysql-log-rotate
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/t/innodb-wl5980-linux.test
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_qa_7_myisam.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_qa.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/t/lowercase_table4.test
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_myisam_innodb.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/t/innodb-wl5980-alter.test
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/t/innodb_bug60196.test
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_qa_6.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/r/innodb_bug60196.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/t/portability_wl5980_linux.zip
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/t/innodb-wl5980-windows.test
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/ndb/t/ndb_show_tables_result.inc
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/r/named_pipe.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/include/shutdown_mysqld.inc
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_qa_14.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_qa_10.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/t/innodb_bug60196-master.opt
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/r/innodb-wl5980-linux.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/r/shm.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/parts/r/partition_exch_qa_5_innodb.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/t/innodb_bug14169459.test
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/t/innodb-multiple-tablespaces.test
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/sys_vars/r/sort_buffer_size_basic_32.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/sql-bench/graph-compare-results
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/suite/innodb/r/innodb-wl5980-windows.result
W: mysql: executable-not-elf-or-script opt/mysql/server-5.6/mysql-test/r/lowercase_table4.result
[5 Feb 2014 8:30] Laurynas Biveinis
In 5.6, mysql-test/include/have_QC_Disabled.inc is affected too.

All of the above applies to 5.7 too.
[25 Jun 2014 16:15] Paul DuBois
Noted in 5.5.39, 5.6.20, 5.7.5 changelogs.

File permissions and line endings of several test files were made
more consistent to avoid warnings from package checkers.