"empty" full backup

Markus Dubois

unread,

Jan 26, 2024, 1:25:17 PM1/26/24

to bareos-users

i've using latest bareos v23

i've switched from an always inceremental to an fairly easy 2 weekly full and incremental in between

Now just for accident i discovered that the second full, which was sucessfull acording to the logs seems to be "empty".

When i want to restore and select the second full as the source for restore, then then db gets browsed and instead delivering the folder tree, just comes back with an empty screen. No errors, nothing to select.

What happen here?

Markus Dubois

unread,

Jan 27, 2024, 4:34:59 AM1/27/24

to bareos-users

hmm, odd situation

did:

.bvfs_clear_cache yes

bareos-dbcheck

check came back with:

Checking for orphaned Path entries. This may take some time!
Query failed: SELECT DISTINCT Path.PathId, File.PathId, Path.Path FROM Path LEFT JOIN File USIN
G (PathId) LEFT JOIN PathHierarchy ON (Path.Pathid = PathHierarchy.PPathId) WHERE File.PathId I
S NULL AND PathHierarchy.PPathId IS NULL LIMIT 300000 : ERR=ERROR: could not resize shared mem
ory segment "/PostgreSQL.447978704" to 16777216 bytes: No space left on device
CONTEXT: parallel worker

but my shm_size is already 64 MB, so 16 MB as needed above should be no problem

Filesystem Size Used Available Use% Mounted on shm 64.0M 1.0M 63.0M 2% /dev/shm

what can i do now?

using postgres 15.5 by the way

Markus Dubois

unread,

Jan 27, 2024, 5:04:04 AM1/27/24

to bareos-users

nevermind postgres performance optimizaions performed set the values to 2 back to 0

max_parallel_workers_per_gather = 0

max_parallel_maintenance_workers = 0

check runs through now, fixing db issues atm

Markus Dubois

unread,

Jan 27, 2024, 9:16:17 AM1/27/24

to bareos-users

so actually bareos-dbcheck said only "found 3000000 orphaned Path records"....

other references in the group here told to execute .bvfs_lsdirs jobid
with the job id of the latest full backup. did this and get ERROR back. Duh! Of course this full backup is not working.....

so what next? are those orphaned paths to fix?

Markus Dubois

unread,

Jan 27, 2024, 9:35:45 AM1/27/24

to bareos-users

interesting.... selecting and browsing the ful backup id via bconsole is possible....