Hello, I've found by a verify job that some files looks like not correctly backup.
So my filled /home/pierre/.screenrc is in the bconsole restore menu shown as empty file with root:root owner instead pierre:pierre and have a 0 unix epoche timestamp (1.1.70 1:00 am). I found also a warning message found: Warning: sql_get.c:186 More than one Filename!: 2 for file: .screenrc So i checked the filename table and found two filenameid for the same filename. I checked also the file table and found two sets of files, one related to the one filenameid and the other to the other filenameid but pathid, jobid, fileindex and all other columns without fileid are the same. fileid differs also. It looks like each backup for one file there will be created two new lines in the file table. By a test I removed the older filenameid entry, than I checked the file table that there exists minimum two rows in the file table where jobid, pathid and fileindex, one to the removed filenameid and one to the newer one. For all of them I removed the rows related to the removed filenameid. The rest of rows i update the filenameid to the newer one (only one row was found). After a checking the catalog and a restore test no error related to this file is shown any more. The stats like permissions and timestamps are now also fixed. I have a bunch of other filenames which are duplicated in filename table found. I found also some duplicate names in path table. Did I have forgotten any thing? I fixed it by python script one step by next but this should not be the best solution. Is there a tool which can fix such issue? Cheers, Pierre _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
