Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.3.35, 10.4.25, 10.5.16, 10.6.8
-
None
-
RHEL
Description
Hi,
I have log_bin specified to the data directory:
/etc/my.cnf.d/common.cnf:12:log_bin="/var/lib/mysql/mariadb"
In the mariabackup output, I see that mariabackup copies the binary logs to the backup directory:
[00] 2022-06-06 19:22:58 Compressing /var/lib/mysql/mariadb.000270 to /backupdisk/diff-2022-06-06_19-07-01/mariadb.000270.qp
This is needless consumption of space on the backup disk.
I did not find a command-line switch to disable copying the binary logs, I think this is a bug in mariabackup to just copy all the files that are in the data directory.
Specifying a custom binlog directory is NOT a work-around for this issue. It does not seam that the general log is stored with the backup, so why can the binary logs not be excepted?
Earlier bakup runs (with a different mariabackup version) did not show this issue, it seams some thing changed in mariabackup.
My current version:
mariabackup based on MariaDB server 10.3.35-MariaDB Linux (x86_64)
[00] 2022-06-06 10:26:07 Using server version 10.3.31-MariaDB-log
/usr/bin/mariabackup based on MariaDB server 10.3.35-MariaDB Linux (x86_64)
The older runs were slightly different versions:
[00] 2022-03-23 00:07:01 Using server version 10.3.31-MariaDB-log
/usr/bin/mariabackup based on MariaDB server 10.3.34-MariaDB Linux (x86_64)
Thank you,
Michaƫl
Attachments
Issue Links
- is caused by
-
MDEV-27524 Incorrect binlogs after Galera SST using rsync and mariabackup
-
- Closed
-
- relates to
-
MDEV-28772 Mariabackup locks database for minutes since 10.8.3
-
- Closed
-
-
MDEV-29109 mariabackup --rsync option broken since 10.3
-
- Closed
-
-
MDEV-28015 Mariabackup | GTID value is missing, Galera Cluster , adding async slave to it
-
- Closed
-
-
MDEV-28781 mariabackup rsync fails to copy /var/lib/mysql/var/lib/mysql/ib_buffer_pool
-
- Closed
-
- split to
-
MDEV-28968 mariabackup SST doesn't properly handle --innodb-buffer-pool-filename
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Description |
Hi,
I have log_bin specified to the data directory: /etc/my.cnf.d/common.cnf:12:log_bin="/var/lib/mysql/mariadb" In the mariabackup output, I see that mariabackup copies the binary logs to the backup directory: [00] 2022-06-06 19:22:58 Compressing /var/lib/mysql/mariadb.000270 to /backupdisk/diff-2022-06-06_19-07-01/mariadb.000270.qp This is needless consumption of space on the backup disk. I did not find a command-line switch to disable copying the binary logs, I think this is a bug in mariabackup to just copy all the files that are in the data directory. As a work-around I will have a customer directory for binary logs, but I do think it is worth to fix this bug. What if the same bug applies to slow logs, or the general log after it was running for a few days? If those other logs are excepted, then why can the binary logs not be excepted? Thank you, Michaƫl |
Hi,
I have log_bin specified to the data directory: /etc/my.cnf.d/common.cnf:12:log_bin="/var/lib/mysql/mariadb" In the mariabackup output, I see that mariabackup copies the binary logs to the backup directory: [00] 2022-06-06 19:22:58 Compressing /var/lib/mysql/mariadb.000270 to /backupdisk/diff-2022-06-06_19-07-01/mariadb.000270.qp This is needless consumption of space on the backup disk. I did not find a command-line switch to disable copying the binary logs, I think this is a bug in mariabackup to just copy all the files that are in the data directory. As a work-around I will have a customer directory for binary logs, but I do think it is worth to fix this bug. What if the same bug applies to slow logs, or the general log after it was running for a few days? If those other logs are excepted, then why can the binary logs not be excepted? Earlier bakup runs (with a different mariabackup version) did not show this issue, it seams some thing changed in mariabackup. In the My current version: mariabackup based on MariaDB server 10.3.35-MariaDB Linux (x86_64) [00] 2022-06-06 10:26:07 Using server version 10.3.31-MariaDB-log /usr/bin/mariabackup based on MariaDB server 10.3.35-MariaDB Linux (x86_64) The older runs were slightly different versions: [00] 2022-03-23 00:07:01 Using server version 10.3.31-MariaDB-log /usr/bin/mariabackup based on MariaDB server 10.3.34-MariaDB Linux (x86_64) Thank you, Michaƫl |
Priority | Minor [ 4 ] | Major [ 3 ] |
Affects Version/s | 10.3.35 [ 27512 ] | |
Environment | RHEL |
Fix Version/s | 10.3 [ 22126 ] |
Assignee | Alexander Barkov [ bar ] |
Affects Version/s | 10.6.8 [ 27506 ] | |
Affects Version/s | 10.5.16 [ 27508 ] |
Description |
Hi,
I have log_bin specified to the data directory: /etc/my.cnf.d/common.cnf:12:log_bin="/var/lib/mysql/mariadb" In the mariabackup output, I see that mariabackup copies the binary logs to the backup directory: [00] 2022-06-06 19:22:58 Compressing /var/lib/mysql/mariadb.000270 to /backupdisk/diff-2022-06-06_19-07-01/mariadb.000270.qp This is needless consumption of space on the backup disk. I did not find a command-line switch to disable copying the binary logs, I think this is a bug in mariabackup to just copy all the files that are in the data directory. As a work-around I will have a customer directory for binary logs, but I do think it is worth to fix this bug. What if the same bug applies to slow logs, or the general log after it was running for a few days? If those other logs are excepted, then why can the binary logs not be excepted? Earlier bakup runs (with a different mariabackup version) did not show this issue, it seams some thing changed in mariabackup. In the My current version: mariabackup based on MariaDB server 10.3.35-MariaDB Linux (x86_64) [00] 2022-06-06 10:26:07 Using server version 10.3.31-MariaDB-log /usr/bin/mariabackup based on MariaDB server 10.3.35-MariaDB Linux (x86_64) The older runs were slightly different versions: [00] 2022-03-23 00:07:01 Using server version 10.3.31-MariaDB-log /usr/bin/mariabackup based on MariaDB server 10.3.34-MariaDB Linux (x86_64) Thank you, Michaƫl |
Hi,
I have log_bin specified to the data directory: /etc/my.cnf.d/common.cnf:12:log_bin="/var/lib/mysql/mariadb" In the mariabackup output, I see that mariabackup copies the binary logs to the backup directory: [00] 2022-06-06 19:22:58 Compressing /var/lib/mysql/mariadb.000270 to /backupdisk/diff-2022-06-06_19-07-01/mariadb.000270.qp This is needless consumption of space on the backup disk. I did not find a command-line switch to disable copying the binary logs, I think this is a bug in mariabackup to just copy all the files that are in the data directory. As a work-around I will have a custom directory for binary logs, but I do think it is worth to fix this bug. What if the same bug applies to slow logs, or the general log after it was running for a few days? If those other logs are excepted, then why can the binary logs not be excepted? Earlier bakup runs (with a different mariabackup version) did not show this issue, it seams some thing changed in mariabackup. In the My current version: mariabackup based on MariaDB server 10.3.35-MariaDB Linux (x86_64) [00] 2022-06-06 10:26:07 Using server version 10.3.31-MariaDB-log /usr/bin/mariabackup based on MariaDB server 10.3.35-MariaDB Linux (x86_64) The older runs were slightly different versions: [00] 2022-03-23 00:07:01 Using server version 10.3.31-MariaDB-log /usr/bin/mariabackup based on MariaDB server 10.3.34-MariaDB Linux (x86_64) Thank you, Michaƫl |
Description |
Hi,
I have log_bin specified to the data directory: /etc/my.cnf.d/common.cnf:12:log_bin="/var/lib/mysql/mariadb" In the mariabackup output, I see that mariabackup copies the binary logs to the backup directory: [00] 2022-06-06 19:22:58 Compressing /var/lib/mysql/mariadb.000270 to /backupdisk/diff-2022-06-06_19-07-01/mariadb.000270.qp This is needless consumption of space on the backup disk. I did not find a command-line switch to disable copying the binary logs, I think this is a bug in mariabackup to just copy all the files that are in the data directory. As a work-around I will have a custom directory for binary logs, but I do think it is worth to fix this bug. What if the same bug applies to slow logs, or the general log after it was running for a few days? If those other logs are excepted, then why can the binary logs not be excepted? Earlier bakup runs (with a different mariabackup version) did not show this issue, it seams some thing changed in mariabackup. In the My current version: mariabackup based on MariaDB server 10.3.35-MariaDB Linux (x86_64) [00] 2022-06-06 10:26:07 Using server version 10.3.31-MariaDB-log /usr/bin/mariabackup based on MariaDB server 10.3.35-MariaDB Linux (x86_64) The older runs were slightly different versions: [00] 2022-03-23 00:07:01 Using server version 10.3.31-MariaDB-log /usr/bin/mariabackup based on MariaDB server 10.3.34-MariaDB Linux (x86_64) Thank you, Michaƫl |
Hi,
I have log_bin specified to the data directory: /etc/my.cnf.d/common.cnf:12:log_bin="/var/lib/mysql/mariadb" In the mariabackup output, I see that mariabackup copies the binary logs to the backup directory: [00] 2022-06-06 19:22:58 Compressing /var/lib/mysql/mariadb.000270 to /backupdisk/diff-2022-06-06_19-07-01/mariadb.000270.qp This is needless consumption of space on the backup disk. I did not find a command-line switch to disable copying the binary logs, I think this is a bug in mariabackup to just copy all the files that are in the data directory. Specifying a custom binlog directory is NOT a work-around for this issue. It does not seam that the general log is stored with the backup, so why can the binary logs not be excepted? Earlier bakup runs (with a different mariabackup version) did not show this issue, it seams some thing changed in mariabackup. My current version: mariabackup based on MariaDB server 10.3.35-MariaDB Linux (x86_64) [00] 2022-06-06 10:26:07 Using server version 10.3.31-MariaDB-log /usr/bin/mariabackup based on MariaDB server 10.3.35-MariaDB Linux (x86_64) The older runs were slightly different versions: [00] 2022-03-23 00:07:01 Using server version 10.3.31-MariaDB-log /usr/bin/mariabackup based on MariaDB server 10.3.34-MariaDB Linux (x86_64) Thank you, Michaƫl |
Priority | Major [ 3 ] | Critical [ 2 ] |
Link |
This issue is caused by |
Priority | Critical [ 2 ] | Blocker [ 1 ] |
Link |
This issue relates to |
Assignee | Alexander Barkov [ bar ] | Julius Goryavsky [ sysprg ] |
Assignee | Julius Goryavsky [ sysprg ] | Sergei Golubchik [ serg ] |
Link | This issue split to TODO-3498 [ TODO-3498 ] |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
Fix Version/s | 10.4 [ 22408 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Fix Version/s | 10.6 [ 24028 ] | |
Fix Version/s | 10.7 [ 24805 ] | |
Fix Version/s | 10.8 [ 26121 ] |
Affects Version/s | 10.4.25 [ 27510 ] |
Assignee | Sergei Golubchik [ serg ] | Julius Goryavsky [ sysprg ] |
Link |
This issue relates to |
Assignee | Julius Goryavsky [ sysprg ] | Jan Lindstrƶm [ jplindst ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Link |
This issue split to |
Assignee | Jan Lindstrƶm [ jplindst ] | Sergei Golubchik [ serg ] |
Assignee | Sergei Golubchik [ serg ] | Jan Lindstrƶm [ jplindst ] |
Assignee | Jan Lindstrƶm [ jplindst ] | Julius Goryavsky [ sysprg ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Status | Stalled [ 10000 ] | In Progress [ 3 ] |
issue.field.resolutiondate | 2022-08-01 16:57:01.0 | 2022-08-01 16:57:01.433 |
Component/s | Galera SST [ 10121 ] | |
Component/s | mariabackup [ 14500 ] | |
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.3 [ 22126 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Fix Version/s | 10.6 [ 24028 ] | |
Fix Version/s | 10.7 [ 24805 ] | |
Fix Version/s | 10.8 [ 26121 ] | |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Closed [ 6 ] |
Link |
This issue relates to |
Link |
This issue relates to |
Zendesk Related Tickets | 116776 172346 126233 |
Is this not covered with --binlog-info=off?