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
