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

mariabackup --compress --parallel=4 hangs in current 10.5.17 from GitHub

    XMLWordPrintable

Details

    Description

      Recent MariaDB Community Server (10.5.17) built from GitHub code does not allow to use --compress option with mariabackup. For example:

      [openxs@fc35 maria10.5]$ bin/mariabackup --user=openxs --backup --compress --parallel=4 --target-dir=/tmp/backup/
      [00] 2022-07-06 11:38:15 Connecting to MySQL server host: localhost, user: openxs, password: not set, port: not set, socket: not set
      [00] 2022-07-06 11:38:15 Using server version 10.5.17-MariaDB
      [00] 2022-07-06 11:38:15 Warning: option 'datadir' has different values:
        '/var/lib/mysql' in defaults file
        '/home/openxs/dbs/maria10.5/data/' in SHOW VARIABLES
      bin/mariabackup based on MariaDB server 10.5.17-MariaDB Linux (x86_64)
      [00] 2022-07-06 11:38:15 uses posix_fadvise().
      [00] 2022-07-06 11:38:15 cd to /home/openxs/dbs/maria10.5/data/
      [00] 2022-07-06 11:38:15 open files limit requested 0, set to 100000
      [00] 2022-07-06 11:38:15 mariabackup: using the following InnoDB configuration:
      [00] 2022-07-06 11:38:15 innodb_data_home_dir = 
      [00] 2022-07-06 11:38:15 innodb_data_file_path = ibdata1:12M:autoextend
      [00] 2022-07-06 11:38:15 innodb_log_group_home_dir = ./
      [00] 2022-07-06 11:38:15 InnoDB: Using Linux native AIO
      2022-07-06 11:38:15 0 [Note] InnoDB: Number of pools: 1
      

      It hangs this way indefinitely with the following content in the target directory:

      ^C
      [openxs@fc35 maria10.5]$ ls -l /tmp/backup/*
      -rw-r-----. 1 openxs openxs 0 Jul  6 11:38 /tmp/backup/ib_logfile0.qp
      [openxs@fc35 maria10.5]$ 
      

      This build is affected:

      [openxs@fc35 server]$ git log -1
      commit 0fca5068a88e9baee2ba06914885e80ca6c330ad (HEAD -> 10.5, origin/bb-10.5-serg, origin/10.5)
      Author: Sergei Golubchik <serg@mariadb.org>
      Date:   Mon Jul 4 20:20:20 2022 +0200
       
          MDEV-28234 Change maturity of plugins for July 2022 Releases
          
          mysql_json: GAMMA -> STABLE
      

      while this older one worked perfectly:

      [openxs@fc35 server]$ git log -1
      commit ea40c75c2793f15e57482a0b374ab48b81b8e3ac (HEAD -> 10.5, origin/10.5)
      Merge: a0e4853eff0 99c8aed00d8
      Author: Marko Mäkelä <marko.makela@mariadb.com>
      Date:   Wed May 25 14:24:51 2022 +0300
       
          Merge 10.4 into 10.5
      

      So, we have some recent enough regression introduced here. Tested on both Fedora 35 and macOS 10.13.6.

      Attachments

        1. compress_qpress.opt
          0.1 kB
          Marko Mäkelä
        2. compress_qpress.test
          3 kB
          Marko Mäkelä
        3. mariadb_10.3.36_mariabackup_Backtrace
          14 kB
          Pramod Mahto
        4. mariadb_10.3.36_mariabackup_log
          15 kB
          Pramod Mahto

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              valerii Valerii Kravchuk
              Votes:
              0 Vote for this issue
              Watchers:
              10 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.