[MDEV-16493] encryption.innodb-remove-encryption failed in buildbot with with timeout in wait condition Created: 2018-06-14  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.1, 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Thirunarayanan Balathandayuthapani
Resolution: Unresolved Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos6-x86/builds/7254

10.1 26be5072429082e634b8fc1026093709

 
encryption.innodb-remove-encryption 'innodb_plugin' w1 [ fail ]
 
        Test ended at 2018-06-12 11:01:11
 
 
 
CURRENT_TEST: encryption.innodb-remove-encryption
 
--- /usr/share/mysql-test/suite/encryption/r/innodb-remove-encryption.result	2018-06-12 09:45:03.000000000 +0300
 
+++ /dev/shm/var/1/log/innodb-remove-encryption.reject	2018-06-12 11:01:11.794981207 +0300
 
@@ -7,23 +7,23 @@
 
 
 # Restart server with encryption
 
 # Wait until encryption threads have encrypted all tablespaces
 
+Timeout in wait_condition.inc for SELECT COUNT(*) = 3 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0 AND ROTATING_OR_FLUSHING = 0;
 
+Id	User	Host	db	Command	Time	State	Info	Progress
 
+2	root	localhost	test	Query	0	init	show full processlist	0.000
 
 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
 
 NAME
 
 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
 
 NAME
 
-mysql/innodb_table_stats
 
-mysql/innodb_index_stats
 
-./ibdata1
 
 # Success!
 
 SELECT * from t1;
 
 a	b
 
 # Now turn off encryption and wait for threads to decrypt all tablespaces
 
 SET GLOBAL innodb_encrypt_tables = off;
 
+Timeout in wait_condition.inc for SELECT COUNT(*) = 3 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0 AND ROTATING_OR_FLUSHING = 0;
 
+Id	User	Host	db	Command	Time	State	Info	Progress
 
+2	root	localhost	test	Query	0	init	show full processlist	0.000
 
 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
 
 NAME
 
-mysql/innodb_table_stats
 
-mysql/innodb_index_stats
 
-./ibdata1
 
 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
 
 NAME
 
 # Success!
 
@@ -31,9 +31,6 @@
 
 # Restart server with no encryption setup, there should be no crashes
 
 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
 
 NAME
 
-mysql/innodb_table_stats
 
-mysql/innodb_index_stats
 
-./ibdata1
 
 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
 
 NAME
 
 SELECT * from t1;
 
 
 
mysqltest: Result length mismatch



 Comments   
Comment by Alice Sherepa [ 2020-09-20 ]

on 10.5 http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-trusty-amd64/builds/19063/steps/mtr/logs/stdio

encryption.innodb-remove-encryption 'innodb' w4 [ fail ]
 
        Test ended at 2020-09-17 15:17:06
 
 
 
CURRENT_TEST: encryption.innodb-remove-encryption
 
--- /usr/local/mariadb-10.5.6-linux-x86_64/mysql-test/suite/encryption/r/innodb-remove-encryption.result	2020-09-17 14:11:09.000000000 +0000
 
+++ /usr/local/mariadb-10.5.6-linux-x86_64/mysql-test/suite/encryption/r/innodb-remove-encryption.reject	2020-09-17 15:17:06.276102488 +0000
 
@@ -8,25 +8,23 @@
 
 # Restart server with encryption
 
 # restart: --plugin-load-add=file_key_management.so --loose-file-key-management --loose-file-key-management-filename=MYSQL_TEST_DIR/std_data/keys.txt --file-key-management-encryption-algorithm=aes_cbc --innodb-encrypt-tables=ON --innodb-encryption-threads=4 --innodb-tablespaces-encryption --innodb-encryption-rotate-key-age=15
 
 # Wait until encryption threads have encrypted all tablespaces
 
+Timeout in wait_condition.inc for SELECT COUNT(*) = 4 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0 AND ROTATING_OR_FLUSHING = 0;
 
+Id	User	Host	db	Command	Time	State	Info	Progress
 
+3	root	localhost	test	Query	0	starting	show full processlist	0.000
 
 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
 
 NAME
 
 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
 
 NAME
 
-innodb_system
 
-mysql/innodb_index_stats
 
-mysql/innodb_table_stats
 
-mysql/transaction_registry
 
 # Success!
 
 SELECT * from t1;
 
 a	b
 
 # Now turn off encryption and wait for threads to decrypt all tablespaces
 
 SET GLOBAL innodb_encrypt_tables = off;
 
+Timeout in wait_condition.inc for SELECT COUNT(*) = 4 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0 AND ROTATING_OR_FLUSHING = 0;
 
+Id	User	Host	db	Command	Time	State	Info	Progress
 
+3	root	localhost	test	Query	0	starting	show full processlist	0.000
 
 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
 
 NAME
 
-innodb_system
 
-mysql/innodb_index_stats
 
-mysql/innodb_table_stats
 
-mysql/transaction_registry
 
 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
 
 NAME
 
 # Success!
 
@@ -35,10 +33,6 @@
 
 # restart: --skip-file-key-management --innodb-encrypt-tables=OFF --innodb-encryption-threads=0 --innodb-tablespaces-encryption
 
 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
 
 NAME
 
-innodb_system
 
-mysql/innodb_index_stats
 
-mysql/innodb_table_stats
 
-mysql/transaction_registry
 
 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
 
 NAME
 
 SELECT * from t1;
 
 
 
mysqltest: Result length mismatch

Last 25 fails

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