hi all,

i am running bacula 5.0.1 with postgresql catalog on Ubuntu.
As there was an error in the file relation. it was an blockerror.
i was unable to do a select on the file table, nor a pg_dump of the catalog.

so i deleted everything from
file
filepath
path - table, but left the table there.

running dbcheck brings out 1 o orphaned file  (from a job i tried)

no i whant to make an backup with bacula to fill the file table again.

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?

best regards
thomas

------------------------------------------------------------------------------
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