I think option 2 should be fixed to ignore deleted files. E.g. # 2 :List where the most recent copies of a file are saved *Enter path with trailing slash: *Enter filename: *Enter Client name: SELECT DISTINCT Job.JobId,StartTime AS JobStartTime,VolumeName,Client.Name AS ClientName FROM Job,File,Path,Filename,Media,JobMedia,Client WHERE File.JobId=Job.JobId AND File.FileIndex > 0 AND Path.Path='%1' AND Filename.Name='%2' AND Client.Name='%3' AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId AND Client.ClientId=Job.ClientId ORDER BY Job.StartTime DESC LIMIT 5;
Queries 1 and 12 also need to be fixed. __Martin >>>>> On Tue, 7 May 2019 14:59:47 +0200, Christoph Litauer said: > > Sorry for the long delay, had holidays ... > > That seems to be the explanation. I use accurate for all my backups. Your > command lists cyrus.header as deleted. As a result "restore" doesn't list the > parent directory. > > But > - should option 2 really find deleted files? > - how do I find the last _not_ deleted version of a file? > > > Am 25.04.2019 um 17:19 schrieb Martin Simmons <mar...@lispworks.com>: > > > > Here's another possible problem: query 2 gives the wrong results if you are > > using "accurate" backups and have deleted files. > > > > Try > > > > echo "list files type=deleted jobid=1100162" | bconsole | grep > > someuser/Transkriptionen > > > > to see if that directory was deleted. > > > > __Martin > > > > > >>>>>> On Thu, 18 Apr 2019 13:13:20 +0100, Martin Simmons said: > >> > >> Yes, I think commands 2 and 3 should be successful because command 1 is > >> successful. > >> > >> Is the path entirely ASCII? Is "someuser" the real name? > >> > >> You could try > >> > >> (echo "restore"; echo 3; echo 1100162; echo "cd /var") | bconsole > >> (echo "restore"; echo 3; echo 1100162; echo "cd /var/spool") | bconsole > >> (echo "restore"; echo 3; echo 1100162; echo "cd /var/spool/imap") | > >> bconsole > >> > >> etc to see which directory is invalid. > >> > >> __Martin > >> > >> > >>>>>> On Thu, 18 Apr 2019 13:43:11 +0200, Christoph Litauer said: > >>> > >>> Dubious ... > >>> > >>> # (echo "query"; echo 12; echo 1100162) | bconsole | grep someuser/ | > >>> grep cyrus.header > >>> | /var/spool/imap/d/user/someuser/Transkriptionen/ > >>> | cyrus.header | > >>> > >>> # echo "list files jobid=1100162" | bconsole | grep > >>> someuser/Transkriptionen > >>> <no result> > >>> > >>> # (echo "restore"; echo 3; echo 1100162; echo "cd > >>> /var/spool/imap/d/user/someuser/Transkriptionen") | bconsole > >>> ... > >>> Invalid path given. > >>> ... > >>> > >>> > >>> In my opinion all 3 commands should be successful? > >>> > >>>> Am 18.04.2019 um 11:39 schrieb Martin Simmons <mar...@lispworks.com>: > >>>> > >>>> You could also check with query 12 (List Files for a selected JobId) to > >>>> see if > >>>> that lists your files. > >>>> > >>>> __Martin > >>>> > >>>>>>>>> On Wed, 17 Apr 2019 17:53:50 +0100, Martin Simmons said: >>>>> >>>>> Ah, it looks like query 2 will list up to 5 lines for jobs that span more >>>>> than >>>>> one volume, so that is not suspicious after all. >>>>> >>>>> Do you have any non-ASCII characters in the path (I assume "someuser" is a >>>>> manual edit)? >>>>> >>>>> __Martin >>>>> >>>>> > >>>>>>>>> On Wed, 17 Apr 2019 16:59:29 +0200, Christoph Litauer said: > >>>>>> > >>>>>> Hi Martin, > >>>>>> > >>>>>> thanks for the suggestions. > >>>>>> The job is about 161GB and spans more than one "File"-volume. "list > >>>>>> jobmedia jobid=1100162" gives all the index numbers for all mentioned > >>>>>> volumes. And a query 7 gives: > >>>>>> > >>>>>> Choose a query (1-20): 7 > >>>>>> Enter JobId: 1100162 > >>>>>> +-----------+------------+ > >>>>>> | jobid | volumename | > >>>>>> +-----------+------------+ > >>>>>> | 1,100,162 | File-2110 | > >>>>>> | 1,100,162 | File-2885 | > >>>>>> | 1,100,162 | File-1828 | > >>>>>> | 1,100,162 | File-2598 | > >>>>>> | 1,100,162 | File-2188 | > >>>>>> | 1,100,162 | File-1157 | > >>>>>> | 1,100,162 | File-1500 | > >>>>>> | 1,100,162 | File-1107 | > >>>>>> | 1,100,162 | File-1995 | > >>>>>> +-----------+------------+ > >>>>>> > >>>>>> My retention time for differentials is about 3 month. I use postgres. > >>>>>> > >>>>>> Everything seems to be ok. Will investigate further. > >>>>>> > >>>>>>> Am 12.04.2019 um 16:21 schrieb Martin Simmons <mar...@lispworks.com>: > >>>>>>> > >>>>>>> Thq query output looks suspicious to me -- do you expect the file to > >>>>>>> be stored > >>>>>>> 5 times in the same job? > >>>>>>> > >>>>>>> It might be interesting to see the output from "list jobmedia > >>>>>>> jobid=1100162" and > >>>>>>> query 7 (List Volumes used by selected JobId) for 1100162. > >>>>>>> > >>>>>>> If you are using mysql, then I suggest running mysqlcheck abd > >>>>>>> myisamchk if > >>>>>>> appropriate. > >>>>>>> > >>>>>>> Also, I assume you mean "list files jobid=1100162" (not job=1100162). > >>>>>>> > >>>>>>> __Martin > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>>>>>>> On Fri, 12 Apr 2019 11:02:52 +0200, Christoph Litauer said: > >>>>>> > >>>>>> Dear bacula users, > >>>>>> > >>>>>> I am using bacula 9.0.4. I wonder about a strange effect: > >>>>>> > >>>>>> Sometimes I get restore requests without a concrete timestamp. The > >>>>>> users can't remember the time of removal. In these cases I use the > >>>>>> bconsole query command, option 2 "List where the most recent copies of > >>>>>> a file are saved". Example: > >>>>>> > >>>>>> Choose a query (1-20): 2 > >>>>>> /var/spool/imap/d/user/someuser/Transkriptionen/ > >>>>>> Enter filename: cyrus.index > >>>>>> Enter Client name: imap1 > >>>>>> +-----------+---------------------+------------+------------+ > >>>>>> | jobid | jobstarttime | volumename | clientname | > >>>>>> +-----------+---------------------+------------+------------+ > >>>>>> | 1,100,162 | 2019-03-27 00:07:01 | File-1107 | imap1 | > >>>>>> | 1,100,162 | 2019-03-27 00:07:01 | File-1157 | imap1 | > >>>>>> | 1,100,162 | 2019-03-27 00:07:01 | File-1500 | imap1 | > >>>>>> | 1,100,162 | 2019-03-27 00:07:01 | File-1828 | imap1 | > >>>>>> | 1,100,162 | 2019-03-27 00:07:01 | File-1995 | imap1 | > >>>>>> +-----------+---------------------+------------+------------+ > >>>>>> > >>>>>> Then I try to find the file with "list files job=1100162", but no > >>>>>> luck. I am not able to restore the file in the queried job. > >>>>>> > >>>>>> Is my index corrupt? But we never had problems restoring files (with > >>>>>> concrete timestamps). Or is the query weird? > >>>>>> > >>>>>> -- > >>>>>> Kind regards > >>>>>> Christoph > >>>>>> _________________________________________ > >>>>>> Uni Koblenz, Computing Centre, Office A 022 > >>>>>> Postfach 201602, 56016 Koblenz > >>>>>> Fon: +49 261 287-1311, Fax: -100 1311 > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> _______________________________________________ > >>>>>> Bacula-users mailing list > >>>>>> Bacula-users@lists.sourceforge.net > >>>>>> https://lists.sourceforge.net/lists/listinfo/bacula-users > >>>>>> > >>>>>> > >>>>>> > >>>>>> -- > >>>>>> Freundliche Grüße > >>>>>> Christoph Litauer > >>>>>> _________________________________________ > >>>>>> Uni Koblenz, Rechenzentrum, Raum A 022 > >>>>>> Postfach 201602, 56016 Koblenz > >>>>>> Fon: +49 261 287-1311, Fax: -100 1311 > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> >>>>> > >>>> > >>>> > >>>> _______________________________________________ > >>>> Bacula-users mailing list > >>>> Bacula-users@lists.sourceforge.net > >>>> https://lists.sourceforge.net/lists/listinfo/bacula-users > >>> > >>> > >>> -- > >>> Freundliche Grüße > >>> Christoph Litauer > >>> _________________________________________ > >>> Uni Koblenz, Rechenzentrum, Raum A 022 > >>> Postfach 201602, 56016 Koblenz > >>> Fon: +49 261 287-1311, Fax: -100 1311 > >>> > >>> > >>> > >>> > >>> > >>> > >> > > > -- > Freundliche Grüße > Christoph Litauer > _________________________________________ > Uni Koblenz, Rechenzentrum, Raum A 022 > Postfach 201602, 56016 Koblenz > Fon: +49 261 287-1311, Fax: -100 1311 > > > > > > _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
