[MDEV-28314] The Galera cluster primary node goes into hang mode when innodb_encryption_threads is enabled Created: 2022-04-14  Updated: 2022-04-21  Resolved: 2022-04-20

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8
Fix Version/s: 10.3.35, 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3

Type: Bug Priority: Critical
Reporter: Ramesh Sivaraman Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Attachments: File gdb_stack.log     File n1.cnf     File n2.cnf    

 Description   

Test case

10.9.0 abe971219456b1f41923c06ff715fd4efeb02850 (Optimized)

/test/mtest/mariadb-10.9.0-linux-x86_64/scripts/mariadb-install-db --no-defaults --force --auth-root-authentication-method=normal  --basedir=/test/mtest/mariadb-10.9.0-linux-x86_64 --datadir=/test/mtest/mariadb-10.9.0-linux-x86_64/node1  > /test/mtest/mariadb-10.9.0-linux-x86_64/logs/startup_node1.err 2>&1
 
 
/test/mtest/mariadb-10.9.0-linux-x86_64/scripts/mariadb-install-db --no-defaults --force --auth-root-authentication-method=normal  --basedir=/test/mtest/mariadb-10.9.0-linux-x86_64 --datadir=/test/mtest/mariadb-10.9.0-linux-x86_64/node2  > /test/mtest/mariadb-10.9.0-linux-x86_64/logs/startup_node2.err 2>&1
 
/test/mtest/mariadb-10.9.0-linux-x86_64/bin/mysqld --defaults-file=/test/mtest/mariadb-10.9.0-linux-x86_64/n1.cnf --plugin-load-add=file_key_management.so --loose-file-key-management --loose-file-key-management-filename=/home/ramesh/mariadb-qa/galera-sst-qa/conf/keys.txt --file-key-management-encryption-algorithm=aes_cbc  --wsrep-new-cluster > /test/mtest/mariadb-10.9.0-linux-x86_64/logs/node1.err 2>&1 &
 
sleep 2
 
/test/mtest/mariadb-10.9.0-linux-x86_64/bin/mysql -uroot -S/test/mtest/mariadb-10.9.0-linux-x86_64/node1/node1_socket.sock -e 'create database if not exists test' > /dev/null 2>&1
 
sysbench /usr/share/sysbench/oltp_insert.lua --table-size=1000 --tables=10 --threads=10 --mysql-db=test --mysql-user=root --db-driver=mysql --mysql-socket=/test/mtest/mariadb-10.9.0-linux-x86_64/node1/node1_socket.sock prepare > /test/mtest/mariadb-10.9.0-linux-x86_64/logs/sysbench_load.log 2>&1
 
/test/mtest/mariadb-10.9.0-linux-x86_64/bin/mysqld --defaults-file=/test/mtest/mariadb-10.9.0-linux-x86_64/n2.cnf --plugin-load-add=file_key_management.so --loose-file-key-management --loose-file-key-management-filename=/home/ramesh/mariadb-qa/galera-sst-qa/conf/keys.txt --file-key-management-encryption-algorithm=aes_cbc  > /test/mtest/mariadb-10.9.0-linux-x86_64/logs/node2.err 2>&1 &
 
sleep 5
 
/test/mtest/mariadb-10.9.0-linux-x86_64/bin/mysql -uroot -S/test/mtest/mariadb-10.9.0-linux-x86_64/node1/node1_socket.sock -e"FLUSH LOGS" ; # "FLUSH LOGS" goes to hang state

Attached gdb stack gdb_stack.log from primary node



 Comments   
Comment by Jan Lindström (Inactive) [ 2022-04-19 ]
  • 10.4 version (test result set) : bb-10.4-MDEV-28314
Generated at Thu Feb 08 09:59:45 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.