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

Slave hangs after snapshot backup

    XMLWordPrintable

Details

    Description

      Our slaves run in docker on a vm and this vm is backuped by veeam.
      Five different slaves, each in its own container.
      Four slaves have 10.6.12.
      One slave has 10.6.17.
      The slave with version 10.6.17 was updated last weekend.
      After we updated that slave, it always hangs after the veeam backup is done.
      The other slaves(10.6.12) on the same vm dont have this problem, neither had the updated slave this problem before.

      It hangs means one process tries to write something and the seconds for this operation increase, until we restart the container.
      Example:

      Write_rows_log_event::write_row(-1) on table `XY`
      

      INSERT INTO XY(eventdate, etc) values('2024-07-03 20:02:31.549' etc)
      

      Do you have an idea why this happens in the newer version or how to fix it?

      Attachments

        1. 1 SHOW PROCESSLIST 080724.txt
          7 kB
          Bruno Bear
        2. 2 SELECT star FROM information_schema.metadata_lock_info 080724.txt
          0.1 kB
          Bruno Bear
        3. 4 SHOW ALL SLAVES STATUS 080724.txt
          6 kB
          Bruno Bear
        4. 5 crash log 08.07.24.txt
          4 kB
          Bruno Bear
        5. logs after restart.txt
          3 kB
          Bruno Bear

        Issue Links

          Activity

            People

              bnestere Brandon Nesterenko
              brunobear Bruno Bear
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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