View Issue Details

IDProjectCategoryView StatusLast Update
0001556bareos-corefile daemonpublic2023-10-10 14:25
ReporterAxelBrice Assigned Tobruno-at-bareos  
PriorityurgentSeveritymajorReproducibilityrandom
Status closedResolutionwon't fix 
PlatformLinuxOSCentOSOS Version7
Product Version22.1.0 
Summary0001556: Bpipe close stream error
DescriptionHello,

Sometimes I have an error on my incremental MySQL backup, operated via Bpipe.

It runs :
bpipe:file=/MYSQL/dump.sql:reader=mysqldump --opt --single-transaction --quick --all-databases:writer=/usr/lib/bareos/scripts/bpipe-restore.sh

Sometimes it works, and sometimes it failed after 1 hour with that error :

JobId 9166: Fatal error: bpipe-fd: Error closing stream for pseudo file /MYSQL/dump.sql: 268435459

I dont understand the behavior.
Could you help ?
Steps To Reproducebpipe:file=/MYSQL/dump.sql:reader=mysqldump --opt --single-transaction --quick --all-databases:writer=/usr/lib/bareos/scripts/bpipe-restore.sh
TagsNo tags attached.

Activities

bruno-at-bareos

bruno-at-bareos

2023-10-10 14:25

manager   ~0005453

Hello, I'm not sure you've seen or understood the limitation bpipe has.
It didn't check any errors happening in the piped program, so you have to check that by yourself in scripting or by other means.

Look like here mysqldump drop the pipe after a certain amount of time.

Maybe you want to have a look at the dedicated MariadDB/Mysql db https://docs.bareos.org/master/TasksAndConcepts/Plugins.html#mariadb-mariabackup-plugin or percona xtrabackup https://docs.bareos.org/master/TasksAndConcepts/Plugins.html#percona-xtrabackup-plugin

Issue History

Date Modified Username Field Change
2023-10-04 13:23 AxelBrice New Issue
2023-10-10 14:25 bruno-at-bareos Assigned To => bruno-at-bareos
2023-10-10 14:25 bruno-at-bareos Status new => closed
2023-10-10 14:25 bruno-at-bareos Resolution open => won't fix
2023-10-10 14:25 bruno-at-bareos Note Added: 0005453