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
> 


_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to