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

Reply via email to