I added a query to my query.sql that does the job.
Thanks a lot.
> Am 07.05.2019 um 18:30 schrieb Martin Simmons :
>
> I think option 2 should be fixed to ignore deleted files. E.g.
>
> # 2
> :List where the most recent copies of a file are saved
> *Enter path with trailing slash:
> *Enter file
I think option 2 should be fixed to ignore deleted files. E.g.
# 2
:List where the most recent copies of a file are saved
*Enter path with trailing slash:
*Enter filename:
*Enter Client name:
SELECT DISTINCT Job.JobId,StartTime AS JobStartTime,VolumeName,Client.Name AS
ClientName
FROM Job,File,
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_ d
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
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
(e
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/T
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
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 | v
Hello Christoph
Or maybe your File Retention is to small and Bacula are deleting from
catalog.
Best regards
*Wanderlei Hüttel*
http://www.bacula.com.br
Em sex, 12 de abr de 2019 às 11:27, Martin Simmons
escreveu:
> Thq query output looks suspicious to me -- do you expect the file to be
> st
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 mysqlc
11 matches
Mail list logo
