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:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.6.21 OS:Linux (Ubuntu Utopic (14.10))
Assigned to: CPU Architecture:Any

[24 Nov 2014 18:15] George Lorch
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
[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