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