Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.5.9
-
None
-
None
Description
The MariaDB is very slow and at times it is unresponsive., while working on Database Encryption.
After updated below MariaDB encryption variables , initiated the mariadb service. while few tables are getting auto encrypted there are errors in mariadb error log file
plugin_dir=<MariaDB_Bin>/lib/plugin
plugin_load_add=file_key_management.so
file_key_management_filename=/<PATH>/keyfile.enc
file_key_management_filekey=FILE:/<PATH>/keyfile.passwd
file_key_management_encryption_algorithm=aes_cbc
encrypt_binlog=ON
innodb_encrypt_log=ON
innodb_encryption_threads=7
innodb_encrypt_tables=FORCE
innodb_encrypt_temporary_tables=ON
encrypt_tmp_disk_tables=ON
encrypt_tmp_files=ON
aria_encrypt_tables=ON
innodb_encryption_rotate_key_age=1024
innodb_encryption_rotation_iops=1024
=== MariaDb Error Log ============
2024-03-12 9:57:58 0 [Note] /data/HCL/mariadb/bin/mariadbd: ready for connections.
Version: '10.5.9-MariaDB-log' socket: '/tmp/mysql.sock' port: 3306 MariaDB Server
2024-03-12 10:23:03 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 10:24:55 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 10:26:27 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 10:27:15 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 10:31:06 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 10:31:46 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 2 pending operations
2024-03-12 10:32:22 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 10:33:21 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 10:33:44 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 10:34:16 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 10:35:17 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 2 pending operations
2024-03-12 10:39:15 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 10:50:21 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 10:51:47 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 10:58:09 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 11:11:22 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 11:11:43 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 11:24:04 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 11:31:38 4 [Note] InnoDB: Cannot close file ./platform/usm_opt_lock.ibd because of 1 pending operations
2024-03-12 11:35:43 0 [Warning] InnoDB: A long semaphore wait:
--Thread 139894688810752 has waited at srv0srv.cc line 1554 for 245.00 seconds the semaphore:
X-lock on RW-latch at 0x55d36855e338 created in file dict0dict.cc line 1041
a writer (thread id 139906278823680) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time write locked in file handler0alter.cc line 6255
2024-03-12 11:35:43 0 [Note] InnoDB: A semaphore wait:
Attachments
Issue Links
- relates to
-
MDEV-26055 Adaptive flushing is still not getting invoked in 10.5.11
- Closed
-
MDEV-32977 InnoDB Cannot close file Pending operations and pending fsync
- Open