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

sst mariabackup broken on rocksdb - cannot GET_LOCK

    XMLWordPrintable

Details

    Description

      GET_LOCK / RELEASE_LOCK now errors on Galera due to non-support. RocksDB uses this for checkpoint locking, an alternative locking mechanism is needed.

      10.5.a6780df49b443b172124e7e881ed0bea54d75907, url=https://buildbot.mariadb.org/#/builders/408/builds/8250 daemon log file

      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -innobackupex-backup: [00] 2023-03-29 03:26:34 Skipping db: ./#rocksdb
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -innobackupex-backup: [00] 2023-03-29 03:26:34 Finished backing up non-InnoDB tables and files
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -innobackupex-backup: [01] 2023-03-29 03:26:34 Streaming ./aria_log_control to <STDOUT>
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -innobackupex-backup: [01] 2023-03-29 03:26:34         ...done
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -innobackupex-backup: [01] 2023-03-29 03:26:34 Streaming ./aria_log.00000001 to <STDOUT>
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -innobackupex-backup: [01] 2023-03-29 03:26:34         ...done
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -innobackupex-backup: [00] 2023-03-29 03:26:34 Obtaining rocksdb checkpoint lock.
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -innobackupex-backup: [00] FATAL ERROR: 2023-03-29 03:26:34 failed to execute query SELECT GET_LOCK('mariabackup_rocksdb_checkpoint',3600): This version of MariaDB doesn't yet support 'GET_LOCK in cluster (WSREP_ON=ON)'
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -wsrep-sst-donor: mariadb-backup finished with error: 1. Check syslog or '/var/lib/node1/mariabackup.backup.log' for details
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -wsrep-sst-donor: Cleanup after exit with status: 22
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -wsrep-sst-donor: Removing /var/lib/node1/xtrabackup_galera_info file due to signal
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -wsrep-sst-donor: Cleaning up temporary directories
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -wsrep-sst-joiner: xtrabackup_checkpoints missing, failed mariadb-backup/SST on donor
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -wsrep-sst-joiner: Cleanup after exit with status: 2
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -wsrep-sst-joiner: Removing /var/lib/node2/.sst/xtrabackup_galera_info file due to signal
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -wsrep-sst-joiner: Removing the sst_in_progress file
      		 
      Mar 29 03:26:34 bb-hz-bbw5-debian-10 -wsrep-sst-joiner: Cleaning up temporary directories
      		 
       

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31325 Can not run db patches using flyway when use the latest 10.6.13 lts MariaDB version with galera 4

          • Major - Major loss of function.
          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30473 Do not allow GET_LOCK() / RELEASE_LOCK() in cluster

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-13122 Backup myrocks with mariabackup

          • Major - Major loss of function.
          • Closed

          Activity

            People

              serg Sergei Golubchik
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.