Sorry for the long delay, had holidays ... That seems to be the explanation. I use accurate for all my backups. Your command lists cyrus.header as deleted. As a result "restore" doesn't list the parent directory.
But - should option 2 really find deleted files? - how do I find the last _not_ deleted version of a file? > Am 25.04.2019 um 17:19 schrieb Martin Simmons <mar...@lispworks.com>: > > 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 >>> >>> >>> >>> >>> >>> >> -- 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
