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
