>>>>> 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users