Details
Description
galera_3nodes.galera_ipv6_mysqldump failed on bb 10.2 and bb 10.3: "WSREP_SST: [ERROR] rsync daemon port '16008' has been taken".
10.2.34 0be70a1b773ce66ef1803fcce19522fd9c60c07d |
galera_3nodes.galera_ipv6_mysqldump 'innodb' w1 [ fail ]
|
Test ended at 2020-08-25 13:32:03
|
|
CURRENT_TEST: galera_3nodes.galera_ipv6_mariabackup
|
CURRENT_TEST: galera_3nodes.galera_ipv6_mariabackup_section
|
CURRENT_TEST: galera_3nodes.galera_ipv6_mariabackup
|
CURRENT_TEST: galera_3nodes.galera_ipv6_mysqldump
|
|
|
Failed to start mysqld.2
|
|
|
- skipping '/dev/shm/var/1/log/galera_3nodes.galera_ipv6_mysqldump-innodb/'
|
|
Retrying test galera_3nodes.galera_ipv6_mysqldump, attempt(2/3)...
|
|
***Warnings generated in error logs during shutdown after running tests: galera_3nodes.galera_ipv6_mysqldump
|
|
WSREP_SST: [ERROR] rsync daemon port '16008' has been taken (20200825 13:31:53.933)
|
2020-08-25 13:31:53 140068462999296 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_rsync --role 'joiner' --address '[::1]:16008' --datadir '/dev/shm/var/1/mysqld.2/data/' --defaults-file '/dev/shm/var/1/my.cnf' --defaults-group-suffix '.2' --parent '27002' --binlog-index 'mysqld-bin.index' --mysqld-args --defaults-group-suffix=.2 --defaults-file=/dev/shm/var/1/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --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 --bind-address=:: --core-file --loose-debug-sync-timeout=300
|
2020-08-25 13:31:53 140068462999296 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'joiner' --address '[::1]:16008' --datadir '/dev/shm/var/1/mysqld.2/data/' --defaults-file '/dev/shm/var/1/my.cnf' --defaults-group-suffix '.2' --parent '27002' --binlog-index 'mysqld-bin.index' --mysqld-args --defaults-group-suffix=.2 --defaults-file=/dev/shm/var/1/my.cnf --log-output=file --innodb --innodb-cmpmem --innodb-cmp-per-index --innodb-trx --innodb-locks --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 --bind-address=:: --core-file --loose-debug-sync-timeout=300: 16 (Device or resource busy)
|
2020-08-25 13:31:53 140068463302400 [ERROR] WSREP: Failed to prepare for 'rsync' SST. Unrecoverable.
|
2020-08-25 13:31:53 140068463302400 [ERROR] Aborting
|
Warning: Memory not freed: 1427624
|
On bb 10.4 and bb 10.5 it failed with another output: "mysql_shutdown failed".
10.4.15 88e70f4caea34e0d7677b1fa646151b8b87dd3ab |
galera_3nodes.galera_ipv6_mysqldump 'innodb' w1 [ fail ]
|
Test ended at 2020-08-25 06:58:54
|
|
CURRENT_TEST: galera_3nodes.galera_ipv6_mysqldump
|
mysqltest: In included file "./include/shutdown_mysqld.inc":
|
included from ./include/restart_mysqld.inc at line 10:
|
included from /usr/share/mysql-test/suite/galera_3nodes/t/galera_ipv6_mysqldump.test at line 83:
|
At line 40: mysql_shutdown failed
|
|
The result from queries just before the failure was:
|
< snip >
|
connection node_1;
|
CREATE USER 'sst';
|
GRANT ALL PRIVILEGES ON *.* TO 'sst';
|
SET GLOBAL wsrep_sst_auth = 'sst:';
|
connection node_2;
|
SET GLOBAL wsrep_sst_method = 'mysqldump';
|
Shutting down server ...
|
connection node_1;
|
Cleaning var directory ...
|
CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES (1);
|
connection node_2;
|
Starting server ...
|
SELECT COUNT(*) = 1 FROM t1;
|
COUNT(*) = 1
|
1
|
DROP TABLE t1;
|
SELECT VARIABLE_VALUE LIKE '%[::1]%' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_incoming_addresses';
|
VARIABLE_VALUE LIKE '%[::1]%'
|
Attachments
Issue Links
- duplicates
-
MDEV-21770 `galera_3nodes.galera_ipv6_mariabackup` fails
- Closed
- split to
-
MDEV-24036 galera_3nodes.galera_ipv6_mysqldump: rare random crashes during shutdown
- Closed