Bug #76250 unzip required to run mysql-test-run.pl but not checked for by Cmake
Submitted: 10 Mar 2015 22:33 Modified: 8 Apr 2015 13:14
Reporter: Stewart Smith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.7.6 OS:Any
Assigned to: CPU Architecture:Any

[10 Mar 2015 22:33] Stewart Smith
Description:
innodb.innodb-wl5980-linux               w13 [ fail ]
        Test ended at 2015-03-11 09:30:32

CURRENT_TEST: innodb.innodb-wl5980-linux
sh: 1: unzip: not found
mysqltest: At line 52: command "unzip -qo $MYSQL_TMP_DIR/portability_wl5980_linux.zip -d $MYSQL_TMP_DIR" failed

CMake didn't check for the presence of unzip during configure stage of build

How to repeat:
run mysql-test-run.pl on minimal Ubuntu system.

Suggested fix:
CMake detect unzip
[11 Mar 2015 8:43] MySQL Verification Team
Hello Stewart,

Thank you for the report.

Thanks,
Umesh
[11 Mar 2015 8:43] MySQL Verification Team
// srs dir and os details(unzip was removed)

ushastry@ushastry:~/Downloads$ md5sum mysql-5.7.6-m16.tar.gz 
4f30560e6abf96e7828604bb205d3556  mysql-5.7.6-m16.tar.gz
ushastry@ushastry:~/Downloads$ cat /etc/*release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=14.10
DISTRIB_CODENAME=utopic
DISTRIB_DESCRIPTION="Ubuntu 14.10"
NAME="Ubuntu"
VERSION="14.10 (Utopic Unicorn)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 14.10"
VERSION_ID="14.10"
HOME_URL="http://www.ubuntu.com/"
SUPPORT_URL="http://help.ubuntu.com/"
BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/"

ushastry@ushastry:~/Downloads$cd mysql-5.7.6-m16/
ushastry@ushastry:~/Downloads/mysql-5.7.6-m16$ mkdir build ; cd build/
ushastry@ushastry:~/Downloads/mysql-5.7.6-m16/build$ cmake ../ -DDOWNLOAD_BOOST=1 -DWITH_BOOST=boost/
ushastry@ushastry:~/Downloads/mysql-5.7.6-m16/build$ make
ushastry@ushastry:~/Downloads/mysql-5.7.6-m16/build$ cd mysql-test/

ushastry@ushastry:~/Downloads/mysql-5.7.6-m16/build/mysql-test$ ./mysql-test-run.pl innodb.innodb-wl5980-linux
Logging: /home/ushastry/Downloads/mysql-5.7.6-m16/mysql-test/mysql-test-run.pl  innodb.innodb-wl5980-linux
MySQL Version 5.7.6
Checking supported features...
 - SSL connections supported
Collecting tests...
Removing old var directory...
Creating var directory '/home/ushastry/Downloads/mysql-5.7.6-m16/build/mysql-test/var'...
Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
innodb.innodb-wl5980-linux               [ fail ]
        Test ended at 2015-03-11 14:00:03

CURRENT_TEST: innodb.innodb-wl5980-linux
sh: 1: unzip: not found
mysqltest: At line 52: command "unzip -qo $MYSQL_TMP_DIR/portability_wl5980_linux.zip -d $MYSQL_TMP_DIR" failed

Output from before failure:
exec of 'unzip -qo /home/ushastry/Downloads/mysql-5.7.6-m16/build/mysql-test/var/tmp/portability_wl5980_linux.zip -d /home/ushastry/Downloads/mysql-5.7.6-m16/build/mysql-test/var/tmp' failed, error: 32512, status: 127, errno: 0

The result from queries just before the failure was:
# Skip this test other platfoms and run only on Linux.
# Set the environmental variables
# Stop server
# Copy the remote tablespace & DB zip files from suite location to working location.
# Check that the file exists in the working folder.
# Unzip the zip file.

 - the logfile can be found in '/home/ushastry/Downloads/mysql-5.7.6-m16/build/mysql-test/var/log/innodb.innodb-wl5980-linux/innodb-wl5980-linux.log'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 30 seconds executing testcases

Completed: Failed 1/1 tests, 0.00% were successful.

Failing test(s): innodb.innodb-wl5980-linux

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html

mysql-test-run: *** ERROR: there were failing test cases
[8 Apr 2015 13:14] Paul DuBois
Noted in 5.6.25, 5.7.8, 5.8.0 changelogs.

unzip is required to run some test cases but was not tested for by
CMake.
[24 Apr 2015 12:48] Paul DuBois
Correction: It's the tests themselves that need to check for unzip. So this is a test suite change, no changelog entry needed.