Re: [bareos-users] Database error message after a long run backup job - ERROR: relation "batch" does not exist

[Andreas Rogge]

Am 12.06.24 um 00:57 schrieb Marcio Feldmann:

```

LINE 1: ...h) SELECT a.Path FROM ( SELECT DISTINCT Path FROM batch ) AS...
```

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

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.

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?

OpenPGP_0x00314758866BD59E.asc
Description: OpenPGP public key

OpenPGP_signature.asc
Description: OpenPGP digital signature