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

mariabackup hangs at FLUSH TABLES WITH READ LOCK when Node is wsrep_desync

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Not a Bug
    • 10.3.6
    • N/A
    • Backup, Galera
    • None
    • CentOS 7.4

    Description

      mariabackup hangs at FLUSH TABLES WITH READ LOCK when Node is wsrep_desync

      on Galera Node set wsrep_desync and FTWRL
      get mariabackup . mariabackup hangs.

      attached full mariabackup log file and sql processlist ;

      MariaDB [(none)]> set global wsrep_desync=1;
      Query OK, 0 rows affected (0.001 sec)
      MariaDB [(none)]> flush tables with read lock;
      Query OK, 0 rows affected (0.000 sec)
      

      2. Perform mariabackup from other session

      mariabackup --backup -u root -p1 --target-dir=/var/mariadb/backup/B1
      180418 14:01:52 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
      Using server version 10.3.6-MariaDB
      mariabackup based on MariaDB server 10.3.6-MariaDB Linux (x86_64)
      mariabackup: uses posix_fadvise().
      mariabackup: cd to /var/lib/mysql/
      mariabackup: open files limit requested 0, set to 1024
      mariabackup: using the following InnoDB configuration:
      mariabackup:   innodb_data_home_dir = .
      mariabackup:   innodb_data_file_path = ibdata1:12M:autoextend
      mariabackup:   innodb_log_group_home_dir = ./
      2018-04-18 14:01:52 0 [Note] InnoDB: Number of pools: 1
      mariabackup: Generating a list of tablespaces
      2018-04-18 14:01:52 0 [Warning] InnoDB: Allocated tablespace ID 154 for fi/people, old maximum was 0
      2018-04-18 14:01:52 0 [Warning] InnoDB: Open files 60 exceeds the limit 18446744073709551615
      180418 14:01:52 >> log scanned up to (48213433987)
      180418 14:01:52 [01] Copying ./ibdata1 to /var/mariadb/backup/B1/ibdata1
      2018-04-18 14:01:53 0 [Warning] InnoDB: Open files 61 exceeds the limit 18446744073709551615
      180418 14:01:53 >> log scanned up to (48213433987)
      180418 14:01:54 [01]        ...done
      180418 14:01:54 [01] Copying ./fi/people.ibd to /var/mariadb/backup/B1/fi/people.ibd
      180418 14:01:54 [01]        ...done
       
      ~~~~~
      180418 14:44:08 [01] Copying ./tpcc/ORDER_LINE.ibd to /var/mariadb/backup/B1/tpcc/ORDER_LINE.ibd
      180418 14:44:09 [01]        ...done
      180418 14:44:09 [01] Copying ./tpcc/STOCK.ibd to /var/mariadb/backup/B1/tpcc/STOCK.ibd
      180418 14:44:11 [01]        ...done
      180418 14:44:11 [01] Copying ./tpcc/WAREHOUSE.ibd to /var/mariadb/backup/B1/tpcc/WAREHOUSE.ibd
      180418 14:44:11 [01]        ...done
      180418 14:44:11 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
      180418 14:44:11 Executing FLUSH TABLES WITH READ LOCK...
      
      

      mariabackup hangs

      MariaDB [(none)]> show processlist ;
       
      |  88 | root        | localhost | NULL | Query   |     0 | Init                     | show processlist            |                                              0.000 |
      | 120 | root        | localhost | NULL | Sleep   |  2386 |                          | NULL                        |                                              0.000 |
      | 125 | root        | localhost | NULL | Query   |  1345 | Init                     | FLUSH TABLES WITH READ LOCK |                                              0.000 |
      +-----+-------------+-----------+------+---------+-------+--------------------------+-----------------------------+                                          ----------+
      73 rows in set (0.000 sec)
      
      

      Attachments

        1. mariabackup_log.txt
          9 kB
          Zdravelina Sokolovska
        2. processlist.txt
          13 kB
          Zdravelina Sokolovska

        Issue Links

          Activity

            People

              wlad Vladislav Vaintroub
              winstone Zdravelina Sokolovska (Inactive)
              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.