Bug #74987 mtr failure on Ubuntu Utopic, mysqlhotcopy fails with wrong error(255)
| Submitted: | 24 Nov 2014 18:15 | Modified: | 25 Nov 2014 9:46 |
|---|---|---|---|
| Reporter: | George Lorch | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 5.6.21 | OS: | Linux (Ubuntu Utopic (14.10)) |
| Assigned to: | CPU Architecture: | Any |
[25 Nov 2014 9:46]
MySQL Verification Team
Hello George Lorch, Thank you for the report and contribution. Thanks, Umesh
[25 Nov 2014 9:49]
MySQL Verification Team
// ushastry@ushastry:~/Downloads$ md5sum mysql-5.6.21.tar.gz e47c3a70b8d89db3199a349204b2ae4e mysql-5.6.21.tar.gz ushastry@ushastry:~/Downloads/mysql-5.6.21/mysql-test$ 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/mysql-5.6.21$ cmake . -DCMAKE_INSTALL_PREFIX=/home/ushastry/Downloads/mysql-5.6.21 ushastry@ushastry:~/Downloads/mysql-5.6.21$ make ushastry@ushastry:~/Downloads/mysql-5.6.21$ make install ushastry@ushastry:~/Downloads/mysql-5.6.21$ cd mysql-test/ ushastry@ushastry:~/Downloads/mysql-5.6.21/mysql-test$ ./mtr mysqlhotcopy_archive Logging: ./mtr mysqlhotcopy_archive 2014-11-25 15:10:36 25338 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2014-11-25 15:10:36 25338 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000) 2014-11-25 15:10:36 25338 [Note] Plugin 'FEDERATED' is disabled. 2014-11-25 15:10:36 25338 [Note] Binlog end 2014-11-25 15:10:36 25338 [Note] Shutting down plugin 'MyISAM' 2014-11-25 15:10:36 25338 [Note] Shutting down plugin 'CSV' MySQL Version 5.6.21 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/home/ushastry/Downloads/mysql-5.6.21/mysql-test/var'... Installing system database... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.mysqlhotcopy_archive [ fail ] Test ended at 2014-11-25 15:10:41 CURRENT_TEST: main.mysqlhotcopy_archive Warning: /home/ushastry/Downloads/mysql-5.6.21/scripts/mysqlhotcopy is deprecated and will be removed in a future version. Warning: /home/ushastry/Downloads/mysql-5.6.21/scripts/mysqlhotcopy is deprecated and will be removed in a future version. Warning: /home/ushastry/Downloads/mysql-5.6.21/scripts/mysqlhotcopy is deprecated and will be removed in a future version. Warning: /home/ushastry/Downloads/mysql-5.6.21/scripts/mysqlhotcopy is deprecated and will be removed in a future version. Warning: /home/ushastry/Downloads/mysql-5.6.21/scripts/mysqlhotcopy is deprecated and will be removed in a future version. Warning: /home/ushastry/Downloads/mysql-5.6.21/scripts/mysqlhotcopy is deprecated and will be removed in a future version. Can't hotcopy to '/home/ushastry/Downloads/mysql-5.6.21/mysql-test/var/mysqld.1/data/hotcopy_save' because directory already exist and the --allowold or --addtodest options were not given. mysqltest: In included file "./include/mysqlhotcopy.inc": included from ./include/mysqlhotcopy.inc at line 112: At line 111: command "$MYSQLHOTCOPY --quiet -S $MASTER_MYSOCK -u root hotcopy_test hotcopy_save" failed with wrong error: 255 The result from queries just before the failure was: < snip > t2.ARZ t2.frm t3.ARZ t3.frm DROP DATABASE hotcopy_save; db.opt t1.ARZ t1.frm t2.ARZ t2.frm t3.ARZ t3.frm DROP DATABASE hotcopy_save; db.opt t1.ARZ t1.frm t2.ARZ t2.frm t3.ARZ t3.frm More results from queries before failure can be found in /home/ushastry/Downloads/mysql-5.6.21/mysql-test/var/log/mysqlhotcopy_archive.log - saving '/home/ushastry/Downloads/mysql-5.6.21/mysql-test/var/log/main.mysqlhotcopy_archive/' to '/home/ushastry/Downloads/mysql-5.6.21/mysql-test/var/log/main.mysqlhotcopy_archive/' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 5 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.mysqlhotcopy_archive 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
[3 May 2016 12:18]
Yura Sorokin
Also reproducible on Ubuntu 15.10 (Wily) 64-bit with MySQL Server 5.5.49
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: tests mysqlhotcopy_archive and mysqlhotcopy_myisam fail on Ubuntu Utopic: george@ubuntu1410pkg:~/packaging/mysql-5.6.21/mysql-test$ ./mtr mysqlhotcopy_archive Logging: ./mtr mysqlhotcopy_archive 2014-11-24 10:51:14 31013 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2014-11-24 10:51:14 31013 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000) 2014-11-24 10:51:14 31013 [Note] Plugin 'FEDERATED' is disabled. 2014-11-24 10:51:14 31013 [Note] Binlog end 2014-11-24 10:51:14 31013 [Note] Shutting down plugin 'MyISAM' 2014-11-24 10:51:14 31013 [Note] Shutting down plugin 'CSV' MySQL Version 5.6.21 Checking supported features... - SSL connections supported Collecting tests... Removing old var directory... Creating var directory '/home/george/packaging/mysql-5.6.21/mysql-test/var'... Installing system database... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 main.mysqlhotcopy_archive [ fail ] Test ended at 2014-11-24 10:51:22 CURRENT_TEST: main.mysqlhotcopy_archive Warning: /home/george/packaging/mysql-5.6.21/scripts/mysqlhotcopy is deprecated and will be removed in a future version. Warning: /home/george/packaging/mysql-5.6.21/scripts/mysqlhotcopy is deprecated and will be removed in a future version. Warning: /home/george/packaging/mysql-5.6.21/scripts/mysqlhotcopy is deprecated and will be removed in a future version. Warning: /home/george/packaging/mysql-5.6.21/scripts/mysqlhotcopy is deprecated and will be removed in a future version. Warning: /home/george/packaging/mysql-5.6.21/scripts/mysqlhotcopy is deprecated and will be removed in a future version. Warning: /home/george/packaging/mysql-5.6.21/scripts/mysqlhotcopy is deprecated and will be removed in a future version. Can't hotcopy to '/home/george/packaging/mysql-5.6.21/mysql-test/var/mysqld.1/data/hotcopy_save' because directory already exist and the --allowold or --addtodest options were not given. mysqltest: In included file "./include/mysqlhotcopy.inc": included from ./include/mysqlhotcopy.inc at line 112: At line 111: command "$MYSQLHOTCOPY --quiet -S $MASTER_MYSOCK -u root hotcopy_test hotcopy_save" failed with wrong error: 255 The result from queries just before the failure was: < snip > t2.ARZ t2.frm t3.ARZ t3.frm DROP DATABASE hotcopy_save; db.opt t1.ARZ t1.frm t2.ARZ t2.frm t3.ARZ t3.frm DROP DATABASE hotcopy_save; db.opt t1.ARZ t1.frm t2.ARZ t2.frm t3.ARZ t3.frm More results from queries before failure can be found in /home/george/packaging/mysql-5.6.21/mysql-test/var/log/mysqlhotcopy_archiv e.log - saving '/home/george/packaging/mysql-5.6.21/mysql-test/var/log/main.mysqlhotcopy_archive/' to '/home/george/packaging/mysql-5.6. 21/mysql-test/var/log/main.mysqlhotcopy_archive/' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 10 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.mysqlhotcopy_archive 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 How to repeat: Build/install mysql 5.6.21 on Ubuntu Utopic (14.10), then run mtr mysqlhotcopy_archive mysqlhotcopy_myisam Suggested fix: mysql-test/include/mysqlhotcopy.inc @@ -110,7 +110,7 @@ --exec $MYSQLHOTCOPY --quiet -S $MASTER_MYSOCK -u root hotcopy_test hotcopy_save --list_files $MYSQLD_DATADIR/hotcopy_save --replace_result $MASTER_MYSOCK MASTER_MYSOCK - --error 9,11,110,2304 + --error 9,11,110,255,2304 --exec $MYSQLHOTCOPY --quiet -S $MASTER_MYSOCK -u root hotcopy_test hotcopy_save --replace_result $MASTER_MYSOCK MASTER_MYSOCK --exec $MYSQLHOTCOPY --quiet --allowold -S $MASTER_MYSOCK -u root hotcopy_test hotcopy_save