Am 12.06.24 um 00:57 schrieb Marcio Feldmann:
```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 existLINE 1: ...h) SELECT a.Path FROM ( SELECT DISTINCT Path FROM batch ) AS... ```
The table "batch" is a temporary per-job table. When Bareos loses the connection to the database, it will automatically re-establish the connection. However, all temporary tables will be gone and you will then eventually run into the issue you're seeing. Did you - by any chance - restart the database server during the backup job or was there another reason why the connection would have been broken?
Best Regards, Andreas -- Andreas Rogge andreas.ro...@bareos.com Bareos GmbH & Co. KG Phone: +49 221-630693-86 http://www.bareos.com Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 Komplementär: Bareos Verwaltungs-GmbH Geschäftsführer: Stephan Dühr, Jörg Steffens, Philipp Storz -- 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 bareos-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/6ee79f0d-58a9-4eae-ac69-fcaddf8f0a1e%40bareos.com.
OpenPGP_0x00314758866BD59E.asc
Description: OpenPGP public key
OpenPGP_signature.asc
Description: OpenPGP digital signature