View Issue Details

IDProjectCategoryView StatusLast Update
0001568bareos-coreGeneralpublic2023-12-12 11:32
ReporterAlexSN Assigned Tobruno-at-bareos  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionsuspended 
PlatformLinuxOSUbuntuOS Version22.04
Product Version22.1.1 
Summary0001568: Incremental mariadb backups fail because of a warning
DescriptionThe 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 InformationI can make full backups of the database without problem.
TagsNo tags attached.

Activities

bruno-at-bareos

bruno-at-bareos

2023-11-09 09:59

manager   ~0005508

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
AlexSN

AlexSN

2023-11-10 10:12

reporter   ~0005511

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
AlexSN

AlexSN

2023-11-10 10:14

reporter   ~0005512

Maybe it is because of MariaDB version?
Server version: 11.0.3-MariaDB-1:11.0.3+maria~ubu2204 mariadb.org binary distribution
bruno-at-bareos

bruno-at-bareos

2023-11-20 16:50

manager   ~0005521

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 ?
AlexSN

AlexSN

2023-11-20 17:10

reporter   ~0005522

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
AlexSN

AlexSN

2023-11-29 22:32

reporter   ~0005554

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
bruno-at-bareos

bruno-at-bareos

2023-11-30 09:54

manager   ~0005558

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.
bruno-at-bareos

bruno-at-bareos

2023-12-12 11:32

manager   ~0005605

Will maybe fixed, if sponsoring occured for mariadb plugin

Issue History

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