I added a query to my query.sql that does the job. Thanks a lot. > Am 07.05.2019 um 18:30 schrieb Martin Simmons <mar...@lispworks.com>: > > 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 >> >> >> >> >> >>
-- 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
