Hello Kern,
pt., 25 sty 2019 o 17:06 Kern Sibbald <[email protected]> napisał(a):
> Hello,
>
> I find the error message very cryptic, and I really don't like just giving
> up, so I have asked the author
> of that particular code to supply a fix.
>
>From what I understand here bvfs is using a special cache tables
(pathvisibility, pathhierarchy) for fast job files browsing. These cache
tables have a references to 'path' and job tables but these references
aren't guarded by a database constraints, so I call it a soft references (I
assume it is for faster update and search).
bacula=# \d pathvisibility
Table "public.pathvisibility"
Column | Type | Modifiers
--------+---------+-----------
pathid | integer | not null
jobid | integer | not null
size | bigint | default 0
files | integer | default 0
Indexes:
"pathvisibility_pkey" PRIMARY KEY, btree (jobid, pathid)
"pathvisibility_jobid" btree (jobid)
bacula=# \d pathhierarchy
Table "public.pathhierarchy"
Column | Type | Modifiers
---------+---------+-----------
pathid | integer | not null
ppathid | integer | not null
Indexes:
"pathhierarchy_pkey" PRIMARY KEY, btree (pathid)
"pathhierarchy_ppathid" btree (ppathid)
The dbcheck utility has no code to deal with bvfs cache tables, so when it
finds these soft references it actually raise an error. I can imagine that
this is a temporary solution.
best regards
>
> Best regards,
> Kern
>
> On 1/23/19 11:03 AM, Radosław Korzeniewski wrote:
>
> Hello,
>
> wt., 22 sty 2019 o 14:39 Stefan Muenkner <[email protected]>
> napisał(a):
>
>> (...)
>> Searching for hascache in the rest of the source I found that hascache in
>> the job table seems to be only reset in ".bvfs_clear_cache".
>>
>
> Great!
>
>
>> >> ....
>> >> 9) Check for orphaned Path records
>> >> ....
>> >> Select function number: 9
>> >> Pruning orphaned Path entries isn't possible when using BVFS.
>> >> ....
>>
>
> So, it seems the message above should be more descriptive and user
> friendly and points to bvfs_clear_cache command.
>
> best regards
> --
> Radosław Korzeniewski
> [email protected]
>
>
>
--
Radosław Korzeniewski
[email protected]
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
