View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001568 | bareos-core | General | public | 2023-11-08 14:17 | 2023-12-12 11:32 |
Reporter | AlexSN | Assigned To | bruno-at-bareos | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | suspended | ||
Platform | Linux | OS | Ubuntu | OS Version | 22.04 |
Product Version | 22.1.1 | ||||
Summary | 0001568: Incremental mariadb backups fail because of a warning | ||||
Description | The message below appears when you try to make an incremental mariadb backup. I think the backup work fails because of the warning. Fatal error: python3-fd-mod: Could not get LSN with command "echo 'SHOW ENGINE INNODB STATUS' | mysql --defaults-extra-file=/root/.my.cnf -r | grep 'Log sequence number' | awk '{ print $4 }'", Error: b"mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead\n" | ||||
Additional Information | I can make full backups of the database without problem. | ||||
Tags | No tags attached. | ||||
Thanks for the report, but would you mind to give us the exact version of the OS used and the mariadb package version. With a stock ubuntun 22.04 I can't reproduce this |
|
OS: Linux m01 5.15.0-88-generic 0000098-Ubuntu SMP Mon Oct 2 15:18:56 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux bareos-filedaemon-mariabackup-python-plugin: Installed: 22.1.2~pre4.c37b33136-104 Candidate: 22.1.2~pre4.c37b33136-104 Thanks for your help |
|
Maybe it is because of MariaDB version? Server version: 11.0.3-MariaDB-1:11.0.3+maria~ubu2204 mariadb.org binary distribution |
|
Yes it is related to the new warnings MariaDB has the good idea to set with newer version 11x While it would be possible to change the default plugin option in the file set to something similar to dumpbinary=/usr/bin/mariadb-backup --defaults-file=mysqldefaults mysqlcmd=mariadb --defaults-file=mysqldefaults --raw I'm 100% it will failed afterwards as they also change the name of the temp checkpoint control file to mariadb_backup_checkpoint The plugin need a more intense review and rework. Would you like to propose a PR for or can offer sponsoring to realize this ? |
|
I'm afraid I can't do any. We solved our side by using mariadb-dump instead, and everything is working for us. Just thought you should know about the problem Thanks anyway |
|
For your information, changing mysql for mariadb in the line below in bareos-fd-mariabackup.py --> ours was located in /usr/lib/bareos/plugins solves the problem. Original: self.mysqlcmd = "mysql %s -r" % self.mycnf Change to: self.mysqlcmd = "mariadb %s -r" % self.mycnf I suppose the change will be overwritten at next update, but it is a simple change if you need the functionality. We are no longer using bareos but one of our client that does, requested our help and we found that 'patch' for him. Basically... it is what the warning requests to do Hope it is useful for somebody |
|
Well my investigation didn't confirm it as only this simple changes. That will maybe work for full, but it is also highly recommend to move to new mariadb-backup executable name, and of course xbstream has been also renamed. That's why either it will need a PR from community, or sponsors to implement the changes. But again thanks to have reported the issue. |
|
Will maybe fixed, if sponsoring occured for mariadb plugin | |
Date Modified | Username | Field | Change |
---|---|---|---|
2023-11-08 14:17 | AlexSN | New Issue | |
2023-11-09 09:59 | bruno-at-bareos | Assigned To | => bruno-at-bareos |
2023-11-09 09:59 | bruno-at-bareos | Status | new => feedback |
2023-11-09 09:59 | bruno-at-bareos | Note Added: 0005508 | |
2023-11-10 10:12 | AlexSN | Note Added: 0005511 | |
2023-11-10 10:12 | AlexSN | Status | feedback => assigned |
2023-11-10 10:14 | AlexSN | Note Added: 0005512 | |
2023-11-20 16:50 | bruno-at-bareos | Note Added: 0005521 | |
2023-11-20 17:10 | AlexSN | Note Added: 0005522 | |
2023-11-29 22:32 | AlexSN | Note Added: 0005554 | |
2023-11-30 09:54 | bruno-at-bareos | Note Added: 0005558 | |
2023-12-12 11:32 | bruno-at-bareos | Status | assigned => closed |
2023-12-12 11:32 | bruno-at-bareos | Resolution | open => suspended |
2023-12-12 11:32 | bruno-at-bareos | Note Added: 0005605 |