Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-33656

MariaDB unresponsive and in error log file --Thread 139894688810752 has waited at srv0srv.cc line 1554

    XMLWordPrintable

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

          Activity

            People

              Unassigned Unassigned
              MurthyRamachandrula R S N Murthy
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.