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

Reply via email to