On 2022-01-12 12:06 PM, mark.berg...@pennmedicine.upenn.edu wrote:
bacula: 9.6.5 Postgres 8.4.20After some large (12TB, 7TB) backup jobs finished and were in the process of despooling attributes to the database, I got the followingg errors: 12-Jan 12:43 vbacula JobId 131494: Fatal error: sql_create.c:841 Fill File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5, batch.DeltaSeq FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name): ERR=ERROR: could not close file "base/pgsql_tmp/pgsql_tmp25672.4702": Input/output error ERROR: could not close file "base/pgsql_tmp/pgsql_tmp25672.5134": Input/output error ERROR: could not close file "base/pgsql_tmp/pgsql_tmp25672.5134": Bad file descriptor ERROR: could not close file "base/pgsql_tmp/pgsql_tmp25672.5134": Bad file descriptor ERROR: could not close file "base/pgsql_tmp/pgsql_tmp25672.5134": Bad file descriptor PANIC: ERRORDATA_STACK_SIZE exceeded ERROR: could not close file "base/pgsql_tmp/pgsql_tmp25672.4702": Input/output error ERROR: could not close file "base/pgsql_tmp/pgsql_tmp25672.5134": Input/output error ERROR: could not close file "base/pgsql_tmp/pgsql_tmp25672.5134": Bad file descriptor ERROR: could not close file "base/pgsql_tmp/pgsql_tmp25672.5134": Bad file descriptor ERROR: could not close file "base/pgsql_tmp/pgsql_tmp25672.5134": Bad file descriptor PANIC: ERRORDATA_STACK_SIZE exceeded
Are you sure your database server is not dead/dying? RAM and/or disks aren't failing? Filesystems have room in them?
Dima _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
