Hi Peter, Like Sebastian already mention it, pg drop the table, and it often happen when postgresql lack free temporary space. Some operation especially virtual full, need lot of space, our best advise would be to kept 50% free space where you db is located.
On Friday 2 August 2024 at 08:28:35 UTC+2 Sebastian Sura wrote: > Hi Peter, > > the batch table is a temporary table used by bareos during the backup > process. If you see this error, then it means that the director somehow > lost connection to the pg database. Can you make sure that your db is not > getting restarted somehow or that the connection does not otherwise drop ? > > Kind Regards, > Sebastian Sura > Am 26.07.24 um 23:09 schrieb Peter Kropf: > > My backups have been running without issue for a while but I'm starting to > see this error: > > > 26-Jul 07:46 bareos-dir JobId 3823: Fatal error: cats/sql_create.cc:817 > Fill File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, > Name, LStat, MD5, DeltaSeq, Fhinfo, Fhnode) SELECT batch.FileIndex, > batch.JobId, Path.PathId, batch.Name, batch.LStat, batch.MD5, > batch.DeltaSeq, batch.Fhinfo, batch.Fhnode FROM batch JOIN Path ON > (batch.Path = Path.Path) : ERR=ERROR: relation "batch" does not exist > LINE 1: ..., batch.DeltaSeq, batch.Fhinfo, batch.Fhnode FROM batch JOIN... > > > Server director and storage are on version 23.0.2, client file daemon is > on 23.0.4~pre113.6ea98eb40. > > Help! > > -- Peter > > -- > 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...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/bareos-users/5f0db329-9e3c-4e19-9171-2c198961d335n%40googlegroups.com > > <https://groups.google.com/d/msgid/bareos-users/5f0db329-9e3c-4e19-9171-2c198961d335n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > -- > Sebastian Sura sebasti...@bareos.com > Bareos GmbH & Co. KG Phone: +49 221 630693-0 > https://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/be6d8ef7-3455-4941-abe0-32a938eda3b4n%40googlegroups.com.
