[MDEV-14104] innodb_zip.wl6501_scale_1 failed in buildbot(sporadic), error 192 Created: 2017-10-23  Updated: 2021-10-25  Resolved: 2021-10-25

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.2
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Alice Sherepa Assignee: Jan Lindström (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-13254 innodb_zip.wl6501_scale_1 fails in bu... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2-big/builds/1333/steps/test_1/logs/stdio

innodb_zip.wl6501_scale_1 'innodb'       w1 [ fail ]
        Test ended at 2017-10-21 02:29:46
 
CURRENT_TEST: innodb_zip.wl6501_scale_1
mysqltest: In included file "./suite/innodb_zip/include/innodb_wl6501_scale.inc": 
included from /mnt/buildbot/build/mariadb-10.2.10/mysql-test/suite/innodb_zip/t/wl6501_scale_1.test at line 26:
At line 82: query 'select count(*) from t2' failed: 1296: Got error 192 'Table encrypted but decryption failed. This could be because correct encryption management plugin is not loaded, used encryption key is not available or encryption method does not match.' from InnoDB
 
The result from queries just before the failure was:
< snip >
count(*)
5000
select count(*) from t3;
count(*)
5000
truncate table t1;
select count(*) from t1;
count(*)
0
select count(*) from t2;
count(*)
5000
select count(*) from t3;
count(*)
5000
call populate_small();
select count(*) from t1;
count(*)
2000
select count(*) from t2;



 Comments   
Comment by Marko Mäkelä [ 2021-10-25 ]

The latest failure that I could find in the cross-reference was more than 2 years ago, apparently due to a stuck buf_block_t::lock:

10.2 4e02e502f6f9622a84942fd3329241e7

innodb_zip.wl6501_scale_1 'innodb'       w2 [ fail ]
        Test ended at 2019-07-17 22:42:23
 
CURRENT_TEST: innodb_zip.wl6501_scale_1
mysqltest: In included file "./suite/innodb_zip/include/innodb_wl6501_scale.inc": 
included from /mnt/buildbot/build/mariadb-10.2.26/mysql-test/suite/innodb_zip/t/wl6501_scale_1.test at line 26:
At line 85: query 'truncate table t2' failed: 2013: Lost connection to MySQL server during query

Since then, we lost the big-test builder for a couple of years, and this test has not failed on the recently introduced big-test-only builder yet. But, I do not remember seeing this failure locally either. Possibly this was fixed by MDEV-13564.

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