I've been using Bareos for a short time, moving backups from Bacula to it. 
It's working fine, writing files to an S3 Bucket without issues.

When I added my File Server to be backed up by Bareos, at the end of a long 
run Full Backup Job (about 3 TB in space) it shows this error below. I 
tried lots of changes, but without fixing it.

I also looked for that over the Internet and found the same issue from 
Bacula 14 years ago, but couldn't find a solution.

My Postgres 16 Database server has a lot of free space and does not have 
any restrictions on the pg_temp, so I hope someone here has any idea to 
solve this problem.

```
bareos-dir JobId 1439: Fatal error: cats/sql_create.cc:800 Fill Path table 
Query failed: INSERT INTO Path (Path) SELECT a.Path FROM ( SELECT DISTINCT 
Path FROM batch ) AS a WHERE NOT EXISTS ( SELECT Path FROM Path WHERE Path 
= a.Path ) : ERR=ERROR: relation "batch" does not exist
LINE 1: ...h) SELECT a.Path FROM ( SELECT DISTINCT Path FROM batch ) AS...
```

-- 
You received this message because you are subscribed to the Google Groups 
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bareos-users/0ea2e149-b92a-40e9-932b-97fdcde86335n%40googlegroups.com.

Reply via email to