On 12/13/2021 8:29 am, Wolfgang Denk wrote:
Hello,
I'm running on a fedora host using latest Fedora packages:
bacula is version 11.0.5-1.fc34.x86_64; DB is
postgresql-13.4-1.fc34.x86_64
The system has been installed _many_ years ago.
I thought I had succesfully run all DB upgrades during that time,
but apparently something is missing:
When trying to run query # 2 "List where the most recent copies of a
file are saved", I get the following error message:
...
Choose a query (1-17): 2
Enter path with trailing slash: XXXXXX
Enter filename: YYYYYY
Enter Client name: ZZZZZZ
Query failed: ERROR: relation "filename" does not exist
LINE 1: ...ame,Client.Name AS ClientName FROM
Job,File,Path,Filename,M...
^
SELECT DISTINCT Job.JobId,StartTime AS
JobStartTime,VolumeName,Client.Name AS ClientName FROM
Job,File,Path,Filename,Media,JobMedia,Client WHERE
File.JobId=Job.JobId AND Path.Path='XXXXXX' AND
Filename.Name='YYYYYY' AND Client.Name='ZZZZZZ' AND
Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId AND
JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId AND
Client.ClientId=Job.ClientId ORDER BY Job.StartTime DESC LIMIT 20;
Does this ring a bell to somebody? Any ideas how to fix that?
Thanks in advance.
Best regards,
Wolfgang Denk
Did you run the bacula database upgrade??
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
