Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.8
-
None
-
P8 Rhel 7.1
-
10.1.9-3, 10.1.10
Description
Attachments
Activity
It is visible on the last build:
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-wily-x86/builds/52/steps/test_4/logs/stdio
encryption.innodb_encryption_discard_import 'xtradb' w1 [ fail ]
|
Test ended at 2015-11-10 19:07:54
|
|
|
CURRENT_TEST: encryption.innodb_encryption_discard_import
|
�/usr/bin/mysqltest: Error on delete of '/dev/shm/var/tmp/1/mysqld.1/t1.cfg' (Errcode: 2 "No such file or directory")
|
�/usr/bin/mysqltest: Error on delete of '/dev/shm/var/tmp/1/mysqld.1/t1.ibd' (Errcode: 2 "No such file or directory")
|
�/usr/bin/mysqltest: Error on delete of '/dev/shm/var/tmp/1/mysqld.1/t2.cfg' (Errcode: 2 "No such file or directory")
|
�/usr/bin/mysqltest: Error on delete of '/dev/shm/var/tmp/1/mysqld.1/t2.ibd' (Errcode: 2 "No such file or directory")
|
�/usr/bin/mysqltest: Error on delete of '/dev/shm/var/tmp/1/mysqld.1/t3.cfg' (Errcode: 2 "No such file or directory")
|
�/usr/bin/mysqltest: Error on delete of '/dev/shm/var/tmp/1/mysqld.1/t3.ibd' (Errcode: 2 "No such file or directory")
|
mysqltest: At line 148: query 'ALTER TABLE t1 IMPORT TABLESPACE' failed: 2013: Lost connection to MySQL server during query
|
|
|
The result from queries just before the failure was:
|
< snip >
|
ALTER TABLE t3 DISCARD TABLESPACE;
|
# Discarded tablespaces should be encrypted
|
# t1 yes on expecting NOT FOUND
|
NOT FOUND /foobar/ in t1.ibd
|
# t2 ... on expecting NOT FOUND
|
NOT FOUND /temp/ in t2.ibd
|
# t3 ... on expecting NOT FOUND
|
NOT FOUND /barfoo/ in t3.ibd
|
# List after t1 DISCARD
|
t1.frm
|
t2.frm
|
t3.frm
|
# Tablespaces should be still encrypted
|
# t1 yes on expecting NOT FOUND
|
NOT FOUND /foobar/ in t1.ibd
|
# t2 ... on expecting NOT FOUND
|
NOT FOUND /temp/ in t2.ibd
|
# t3 ... on expecting NOT FOUND
|
NOT FOUND /barfoo/ in t3.ibd
|
ALTER TABLE t1 IMPORT TABLESPACE;
|
|
|
More results from queries before failure can be found in /dev/shm/var/1/log/innodb_encryption_discard_import.log
|
And we can't close sporadic failures as "not reproducible" just because they didn't happen in a few builds, that's why they are sporadic. If they haven't happened for a couple months, then maybe.
I see, not repeatable if you run test e.g. 20 times but repeatable if you run full mysql-tes-run all suites, something before this test messes things up, not yet sure what.
commit c0216f1d02e63686f986fa8f352fdf6de61249a7
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Tue Nov 17 09:45:55 2015 +0200
MDEV-9099: Test encryption.innodb_encryption_discard_import fails on buildbot
Latest failure on http://buildbot.askmonty.org/buildbot/builders/kvm-deb-trusty-x86/builds/1729/steps/test_4/logs/stdio not assertion but test failure.
Another variation of a failure in the same test:
http://buildbot.askmonty.org/buildbot/builders/p8-rhel6-bintar/builds/65/steps/test/logs/stdio
encryption.innodb_encryption_discard_import 'innodb_plugin' w3 [ fail ] Found warnings/errors in server log file!
|
Test ended at 2016-07-31 01:25:39
|
line
|
InnoDB: Error: trying to do an operation on a dropped tablespace 9
|
^ Found warnings in /home/buildbot/maria-slave/p8-rhel6-bintar/build/mysql-test/var/3/log/mysqld.1.err
|
ok
|
Happened several times on 10.1 and 10.2.
commit bb4b8c74702b8e8c6eea14da9a913f6d7cc61302
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Fri Oct 28 13:59:35 2016 +0300
MDEV-9099: Test encryption.innodb_encryption_discard_import fails on buildbot
Not visible on latest build.