[MDEV-26562] galera-sst-mariabackup is failing due to missing xtrabackup_checkpoints. - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.3.35, 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3, 10.9.1, 10.10(EOL)
Fix Version/s: 10.3.36, 10.4.26, 10.5.17, 10.6.9, 10.7.5, 10.8.4, 10.9.2, 10.10.0
Component/s: Galera SST
Labels:
None

Description

galera-sst-mariabackup is failing due to missing xtrabackup_checkpoints.

10.7.0 42ad4fa34644115fd4b8fda72e36359d99f264c9
removed '/dev/shm/var/mysqld.2/data/ib_buffer_pool'
WSREP_SST: [INFO] Waiting for SST streaming to complete! (20210906 15:46:48.633)
2021-09-06 15:46:49 0 [Note] WSREP: (a47d1885-8839, 'tcp://0.0.0.0:16005') turning message relay requesting off
2021/09/06 15:46:59 socat[9043] E SSL_read(): Connection reset by peer
[00] 2021-09-06 15:46:59 xb_stream_read_chunk(): my_read() failed.
2021-09-06 15:46:59 0 [Note] WSREP: 0.0 (ubuntu-groovy-amd64): State transfer to 1.0 (ubuntu-groovy-amd64) complete.
2021-09-06 15:46:59 0 [Note] WSREP: Member 0.0 (ubuntu-groovy-amd64) synced with group.
WSREP_SST: [ERROR] Error while getting data from donor node: exit codes: 1 1 (20210906 15:46:59.948)
WSREP_SST: [ERROR] xtrabackup_checkpoints missing, failed mariabackup/SST on donor (20210906 15:46:59.958)
WSREP_SST: [ERROR] Cleanup after exit with status:2 (20210906 15:46:59.961)
WSREP_SST: [INFO] Removing the sst_in_progress file (20210906 15:46:59.963)
WSREP_SST: [INFO] Cleaning up temporary directories (20210906 15:46:59.968)

node1.err

node2.err

Attachments

Activity

Ascending order - Click to sort in descending order

Ramesh Sivaraman created issue - 2021-09-07 13:39

Ramesh Sivaraman made changes - 2021-09-07 13:39

Field	Original Value	New Value
Link		This issue blocks MDEV-26498 [ MDEV-26498 ]

Ramesh Sivaraman made changes - 2021-09-07 17:04

Description

galera-sst-mariabackup is failing due to missing xtrabackup_checkpoints.

*[stdio.log|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-groovy-amd64/builds/1640/steps/galera-sst-mariabackup/logs/stdio]*
{code:title=10.7.0 42ad4fa34644115fd4b8fda72e36359d99f264c9}
removed '/dev/shm/var/mysqld.2/data/ib_buffer_pool'
WSREP_SST: [INFO] Waiting for SST streaming to complete! (20210906 15:46:48.633)
2021-09-06 15:46:49 0 [Note] WSREP: (a47d1885-8839, 'tcp://0.0.0.0:16005') turning message relay requesting off
2021/09/06 15:46:59 socat[9043] E SSL_read(): Connection reset by peer
[00] 2021-09-06 15:46:59 xb_stream_read_chunk(): my_read() failed.
2021-09-06 15:46:59 0 [Note] WSREP: 0.0 (ubuntu-groovy-amd64): State transfer to 1.0 (ubuntu-groovy-amd64) complete.
2021-09-06 15:46:59 0 [Note] WSREP: Member 0.0 (ubuntu-groovy-amd64) synced with group.
WSREP_SST: [ERROR] Error while getting data from donor node: exit codes: 1 1 (20210906 15:46:59.948)
WSREP_SST: [ERROR] xtrabackup_checkpoints missing, failed mariabackup/SST on donor (20210906 15:46:59.958)
WSREP_SST: [ERROR] Cleanup after exit with status:2 (20210906 15:46:59.961)
WSREP_SST: [INFO] Removing the sst_in_progress file (20210906 15:46:59.963)
WSREP_SST: [INFO] Cleaning up temporary directories (20210906 15:46:59.968)
{code}

*node1.err|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-groovy-amd64/builds/1640/steps/galera-sst-mariabackup/logs/mysqld.1.err]*

*node2.err|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-groovy-amd64/builds/1640/steps/galera-sst-mariabackup/logs/mysqld.2.err]*

galera-sst-mariabackup is failing due to missing xtrabackup_checkpoints.

*[stdio.log|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-groovy-amd64/builds/1640/steps/galera-sst-mariabackup/logs/stdio]*
{code:title=10.7.0 42ad4fa34644115fd4b8fda72e36359d99f264c9}
removed '/dev/shm/var/mysqld.2/data/ib_buffer_pool'
WSREP_SST: [INFO] Waiting for SST streaming to complete! (20210906 15:46:48.633)
2021-09-06 15:46:49 0 [Note] WSREP: (a47d1885-8839, 'tcp://0.0.0.0:16005') turning message relay requesting off
2021/09/06 15:46:59 socat[9043] E SSL_read(): Connection reset by peer
[00] 2021-09-06 15:46:59 xb_stream_read_chunk(): my_read() failed.
2021-09-06 15:46:59 0 [Note] WSREP: 0.0 (ubuntu-groovy-amd64): State transfer to 1.0 (ubuntu-groovy-amd64) complete.
2021-09-06 15:46:59 0 [Note] WSREP: Member 0.0 (ubuntu-groovy-amd64) synced with group.
WSREP_SST: [ERROR] Error while getting data from donor node: exit codes: 1 1 (20210906 15:46:59.948)
WSREP_SST: [ERROR] xtrabackup_checkpoints missing, failed mariabackup/SST on donor (20210906 15:46:59.958)
WSREP_SST: [ERROR] Cleanup after exit with status:2 (20210906 15:46:59.961)
WSREP_SST: [INFO] Removing the sst_in_progress file (20210906 15:46:59.963)
WSREP_SST: [INFO] Cleaning up temporary directories (20210906 15:46:59.968)
{code}

*[node1.err|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-groovy-amd64/builds/1640/steps/galera-sst-mariabackup/logs/mysqld.1.err]*

*[node2.err|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-groovy-amd64/builds/1640/steps/galera-sst-mariabackup/logs/mysqld.2.err]*

Ramesh Sivaraman made changes - 2021-09-15 06:37

Affects Version/s		10.4 [ 22408 ]
Affects Version/s		10.5 [ 23123 ]
Affects Version/s		10.6 [ 24028 ]

Ramesh Sivaraman made changes - 2021-09-15 06:37

Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]

Sergei Golubchik made changes - 2021-12-06 21:35

Workflow

MariaDB v3 [ 124873 ]

MariaDB v4 [ 143149 ]

Julius Goryavsky made changes - 2022-06-21 03:30

Status

Open [ 1 ]

Confirmed [ 10101 ]

Julius Goryavsky made changes - 2022-06-21 03:30

Assignee

Jan Lindström [ jplindst ]

Julius Goryavsky [ sysprg ]

Julius Goryavsky made changes - 2022-06-21 03:30

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Julius Goryavsky made changes - 2022-06-21 03:30

Priority

Major [ 3 ]

Critical [ 2 ]

Julius Goryavsky made changes - 2022-06-21 03:32

Affects Version/s		10.9.1 [ 27114 ]
Affects Version/s		10.8.3 [ 27502 ]
Affects Version/s		10.7.4 [ 27504 ]
Affects Version/s		10.6.8 [ 27506 ]
Affects Version/s		10.5.16 [ 27508 ]
Affects Version/s		10.4.25 [ 27510 ]
Affects Version/s		10.3.35 [ 27512 ]
Affects Version/s		10.10 [ 27530 ]
Affects Version/s	10.4 [ 22408 ]
Affects Version/s	10.5 [ 23123 ]
Affects Version/s	10.6 [ 24028 ]
Affects Version/s	10.7 [ 24805 ]

Julius Goryavsky made changes - 2022-06-21 03:33

Fix Version/s		10.3.36 [ 27513 ]
Fix Version/s		10.4.26 [ 27511 ]
Fix Version/s		10.5.17 [ 27509 ]
Fix Version/s		10.6.9 [ 27507 ]
Fix Version/s		10.7.5 [ 27505 ]
Fix Version/s		10.8.4 [ 27503 ]
Fix Version/s		10.9.2 [ 27115 ]
Fix Version/s		10.10.0 [ 27912 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.7 [ 24805 ]

Julius Goryavsky made changes - 2022-06-21 11:52

Assignee	Julius Goryavsky [ sysprg ]	Jan Lindström [ jplindst ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Jan Lindström (Inactive) made changes - 2022-06-21 13:42

Assignee	Jan Lindström [ jplindst ]	Julius Goryavsky [ sysprg ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Julius Goryavsky made changes - 2022-06-22 03:21

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Julius Goryavsky made changes - 2022-06-22 03:21

issue.field.resolutiondate

2022-06-22 03:21:58.0

2022-06-22 03:21:58.178

Julius Goryavsky made changes - 2022-06-22 03:21

Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Julien Fritsch made changes - 2022-06-22 13:23

Link

This issue blocks MDEV-26498 [ MDEV-26498 ]

People

Assignee:: Julius Goryavsky

Reporter:: Ramesh Sivaraman

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2021-09-07 13:39

Updated:: 2022-06-29 23:47

Resolved:: 2022-06-22 03:21

Git Integration

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

MariaDB Server

Details

Description

Attachments

Activity

People

Dates

Git Integration