>>>>> On Thu, 19 May 2011 18:54:58 +0200 (CEST), Thomas Stegbauer said: > > but after the backup job i get: > 9-Mai 05:23 pa-server-dir JobId 2268: Fatal error: sql_create.c:894 Fill File > table Query failed: INSERT INTO File (FileIndex, JobId, PathId, FilenameId, > LStat, MD5)SELECT batch.FileIndex, batch.JobId, Path.PathId, > Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON > (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name): > ERR=ERROR: null value in column "fileid" violates not-null constraint > > how to i get the catalog up and running?
It looks like the schema for the file table was damaged. What is the output of \d \d file in psql? __Martin ------------------------------------------------------------------------------ What Every C/C++ and Fortran developer Should Know! Read this article and learn how Intel has extended the reach of its next-generation tools to help Windows* and Linux* C/C++ and Fortran developers boost performance applications - including clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
