[MDEV-9099] Test encryption.innodb_encryption_discard_import fails on buildbot Created: 2015-11-09  Updated: 2016-10-29  Resolved: 2016-10-29

Status: Closed
Project: MariaDB Server
Component/s: Encryption, Storage Engine - InnoDB, Storage Engine - XtraDB, Tests
Affects Version/s: 10.1.8
Fix Version/s: 10.1.19

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

P8 Rhel 7.1


Sprint: 10.1.9-3, 10.1.10

 Description   

http://buildbot.askmonty.org/buildbot/builders/p8-rhel71-bintar/builds/628/steps/test/logs/stdio



 Comments   
Comment by Jan Lindström (Inactive) [ 2015-11-12 ]

Not visible on latest build.

Comment by Elena Stepanova [ 2015-11-12 ]

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.

Comment by Jan Lindström (Inactive) [ 2015-11-16 ]

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.

Comment by Jan Lindström (Inactive) [ 2015-11-17 ]

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

Comment by Jan Lindström (Inactive) [ 2015-12-16 ]

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.

Comment by Elena Stepanova [ 2016-07-31 ]

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.

Comment by Jan Lindström (Inactive) [ 2016-10-29 ]

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

Generated at Thu Feb 08 07:32:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.