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

mariabackup stuck when running apply-log-only with export

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.12
    • 10.3
    • Backup
    • None
    • ubuntu 18.04

    Description

      when we update to mariadb 10.2.21 we where forced to upgrade to mariabackup 10.3.12 to get backups working. since then sometimes the backup process get stuck when we tried to export the cfg files.

      First we prepare the backup

      root@backupmysql:/Respaldo/base_sitio_nuevo# mariabackup --prepare --apply-log-only --verbose --target-dir=/Respaldo/base_sitio_nuevo/20190505
      mariabackup: cd to /Respaldo/base_sitio_nuevo/20190505/
      mariabackup: This target seems to be not prepared yet.
      mariabackup: using the following InnoDB configuration for recovery:
      mariabackup: innodb_data_home_dir = .
      mariabackup: innodb_data_file_path = ibdata1:5000M;ibdata2:100M:autoextend
      mariabackup: innodb_log_group_home_dir = .
      2019-05-05 05:39:09 0x7f71bb26b7c0 InnoDB: Using Linux native AIO
      mariabackup: Starting InnoDB instance for recovery.
      mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
      2019-05-05 5:39:09 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2019-05-05 5:39:09 0 [Note] InnoDB: Uses event mutexes
      2019-05-05 5:39:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2019-05-05 5:39:09 0 [Note] InnoDB: Number of pools: 1
      2019-05-05 5:39:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
      2019-05-05 5:39:09 0 [Note] InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M
      2019-05-05 5:39:09 0 [Note] InnoDB: Completed initialization of buffer pool
      2019-05-05 5:39:09 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      2019-05-05 5:39:09 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7194495242963
      MLOG_CHECKPOINT(7194495242963) read at 7194495242972
      ......
      ......
      apply 7194516842523: 38 len 16 page 26515:2241208
      Applying log to page 13958:166287
      Applying log to page 13958:399878
      2019-05-05 5:39:22 0 [Note] InnoDB: Last binlog file '/DATA/mysql_binlog/mariadb-bin.000192', position 312402516
      Last binlog file /DATA/mysql_binlog/mariadb-bin.000192, position 312402516

      Then we export the cfg files

      root@backupmysql:/Respaldo/base_sitio_nuevo# mariabackup --prepare --apply-log-only --export --target-dir=/Respaldo/base_sitio_nuevo/20190505
      mariabackup based on MariaDB server 10.3.12-MariaDB debian-linux-gnu (x86_64)
      mariabackup: auto-enabling --innodb-file-per-table due to the --export option
      mariabackup: cd to /Respaldo/base_sitio_nuevo/20190505/
      mariabackup: This target seems to be already prepared.
      mariabackup: using the following InnoDB configuration for recovery:
      mariabackup: innodb_data_home_dir = .
      mariabackup: innodb_data_file_path = ibdata1:5000M;ibdata2:100M:autoextend
      mariabackup: innodb_log_group_home_dir = .
      2019-05-06 14:00:04 0x7f46eadb77c0 InnoDB: Using Linux native AIO
      mariabackup: Starting InnoDB instance for recovery.
      mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
      2019-05-06 14:00:04 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2019-05-06 14:00:04 0 [Note] InnoDB: Uses event mutexes
      2019-05-06 14:00:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2019-05-06 14:00:04 0 [Note] InnoDB: Number of pools: 1
      2019-05-06 14:00:04 0 [Note] InnoDB: Using SSE2 crc32 instructions
      2019-05-06 14:00:04 0 [Note] InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M
      2019-05-06 14:00:04 0 [Note] InnoDB: Completed initialization of buffer pool
      2019-05-06 14:00:04 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      2019-05-06 14:00:04 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7194517173825
      2019-05-06 14:00:04 0 [Note] InnoDB: Last binlog file '/DATA/mysql_binlog/mariadb-bin.000192', position 312402516
      Last binlog file /DATA/mysql_binlog/mariadb-bin.000192, position 312402516
      Prepare export : executing "/usr/bin/mariabackup" --mysqld --defaults-file=./backup-my.cnf --defaults-group-suffix= --datadir=. --innodb --innodb-fast-shutdown=0 --loose-partition --innodb_purge_rseg_truncate_frequency=1 --innodb-buffer-pool-size=104857600 --console --log-error= --bootstrap < mariabackup_prepare_for_export.sql
      2019-05-06 14:00:05 0 [Note] mysqld (mysqld 10.3.12-MariaDB-1:10.3.12+maria~bionic) starting as process 29 ...

      And the process get stuck here forever, also using high cpu with 4 cores running wild

      Attachments

        Activity

          People

            vlad.lesin Vladislav Lesin
            crubioim Carlos Rubio
            Votes:
            1 Vote for this issue
            Watchers:
            5 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.