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

nesting innodb subdirectories in datadir causes SST to fail

    XMLWordPrintable

    Details

      Description

      Nesting innodb subdirectories in datadir causes SST to fail. This applies to the variables innodb_data_home_dir, innodb_group_home_dir and innodb_undo_directory - if the directory pointed to by one of these variables is nested in datadir as a subdirectory, then we have problems:

      2022-09-21 14:21:51 0 [Note] WSREP: Deleted page /home/panda/mariadb-10.3/build/mysql-test/var/mysqld.1/data/gcache.page.000000
      WSREP_SST: [INFO] rsync SST started on donor (20220921 14:21:51.766)
      WSREP_SST: [INFO] Using stunnel for SSL encryption: CA: '/home/panda/mariadb-10.3/mysql-test/std_data/cacert.pem', CAPATH='', ssl-mode='VERIFY_CA' (20220921 14:21:51.878)
      2022-09-21 14:21:51 0 [Note] WSREP: Flushing tables for SST...
      2022-09-21 14:21:51 0 [Note] WSREP: Provider paused at f54ccf5e-39a7-11ed-84b9-bff4510d1197:0 (5)
      2022-09-21 14:21:51 0 [Note] InnoDB: Stopping purge
      2022-09-21 14:21:51 0 [Note] WSREP: Tables flushed.
      2022-09-21 14:21:51 0 [Note] WSREP: Donor state reached
      WSREP_SST: [INFO] Tables flushed (20220921 14:21:52.756)
      2022.09.21 14:21:52 LOG3[0]: transfer: s_poll_wait: TIMEOUTclose exceeded: closing
      WSREP_SST: [INFO] Transfer of normal directories done (20220921 14:21:52.794)
      2022.09.21 14:21:52 LOG3[0]: transfer: s_poll_wait: TIMEOUTclose exceeded: closing
      @ERROR: chdir failed
      rsync error: error starting client-server protocol (code 5) at main.c(1675) [sender=3.1.3]
      WSREP_SST: [ERROR] rsync innodb_data_home_dir returned code 5: (20220921 14:21:52.823)
      WSREP_SST: [ERROR] Cleanup after exit with status: 255 (20220921 14:21:52.826)
      2022-09-21 14:21:52 0 [ERROR] WSREP: Failed to read from: wsrep_sst_rsync --role 'donor' --address '127.0.0.1:16007/rsync_sst' --local-port 16000 --socket '/home/panda/mariadb-10.3/build/mysql-test/var/tmp/mysqld.1.sock' --progress 0 --datadir '/home/panda/mariadb-10.3/build/mysql-test/var/mysqld.1/data/' --defaults-file '/home/panda/mariadb-10.3/build/mysql-test/var/my.cnf' --defaults-group-suffix '.1' --gtid 'f54ccf5e-39a7-11ed-84b9-bff4510d1197:0' --gtid-domain-id 0 --binlog-index 'mysqld-bin.index' --mysqld-args --defaults-group-suffix=.1 --defaults-file=/home/panda/mariadb-10.3/build/mysql-test/var/my.cnf --log-output=file --enable-gdb --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --innodb_undo_tablespaces=2 --innodb_data_home_dir=/home/panda/maria
      2022-09-21 14:21:52 0 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'donor' --address '127.0.0.1:16007/rsync_sst' --local-port 16000 --socket '/home/panda/mariadb-10.3/build/mysql-test/var/tmp/mysqld.1.sock' --progress 0 --datadir '/home/panda/mariadb-10.3/build/mysql-test/var/mysqld.1/data/' --defaults-file '/home/panda/mariadb-10.3/build/mysql-test/var/my.cnf' --defaults-group-suffix '.1' --gtid 'f54ccf5e-39a7-11ed-84b9-bff4510d1197:0' --gtid-domain-id 0 --binlog-index 'mysqld-bin.index' --mysqld-args --defaults-group-suffix=.1 --defaults-file=/home/panda/mariadb-10.3/build/mysql-test/var/my.cnf --log-output=file --enable-gdb --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --innodb_undo_tablespaces=2 --innodb_data_home_dir=/home/pa
      2022-09-21 14:21:52 0 [Note] InnoDB: Resuming purge
      2022-09-21 14:21:52 0 [Note] WSREP: resuming provider at 5
      2022-09-21 14:21:52 0 [Note] WSREP: Provider resumed.
      2022-09-21 14:21:52 0 [ERROR] WSREP: Command did not run: wsrep_sst_rsync --role 'donor' --address '127.0.0.1:16007/rsync_sst' --local-port 16000 --socket '/home/panda/mariadb-10.3/build/mysql-test/var/tmp/mysqld.1.sock' --progress 0 --datadir '/home/panda/mariadb-10.3/build/mysql-test/var/mysqld.1/data/' --defaults-file '/home/panda/mariadb-10.3/build/mysql-test/var/my.cnf' --defaults-group-suffix '.1' --gtid 'f54ccf5e-39a7-11ed-84b9-bff4510d1197:0' --gtid-domain-id 0 --binlog-index 'mysqld-bin.index' --mysqld-args --defaults-group-suffix=.1 --defaults-file=/home/panda/mariadb-10.3/build/mysql-test/var/my.cnf --log-output=file --enable-gdb --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --innodb-lock-waits --innodb-metrics --innodb-buffer-pool-stats --innodb-buffer-page --innodb-buffer-page-lru --innodb-sys-columns --innodb-sys-fields --innodb-sys-foreign --innodb-sys-foreign-cols --innodb-sys-indexes --innodb-sys-tables --innodb-sys-virtual --innodb_undo_tablespaces=2 --innodb_data_home_dir=/home/panda/maria
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sysprg Julius Goryavsky
              Reporter:
              sysprg Julius Goryavsky
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.