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 schrieb am Samstag, 27. Januar 2024 um 11:04:04 UTC+1: > 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 schrieb am Samstag, 27. Januar 2024 um 10:34:59 UTC+1: > >> 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 schrieb am Freitag, 26. Januar 2024 um 19:25:17 UTC+1: >> >>> 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? >>> >>> -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to bareos-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/4515da6f-447f-4963-91d2-7ced7b274290n%40googlegroups.com.
