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 > > > > > > > > > > > > > _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
