[MDEV-29591] nesting innodb subdirectories in datadir causes SST to fail - Jira

XML

Word

Printable

Details

Type: Bug
Status: Stalled (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
Fix Version/s: 10.4, 10.5, 10.6
Component/s: Galera SST
Labels:
None

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

relates to

MDEV-28968 mariabackup SST doesn't properly handle --innodb-buffer-pool-filename

Closed

split from

MDEV-28669 Cannot join second node to new cluster WSREP: Application received wrong state

Closed

Activity

People

Assignee:: Julius Goryavsky

Reporter:: Julius Goryavsky

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2022-09-21 12:37

Updated:: 2023-12-07 10:26

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.