On 05/19/11 12:54, Thomas Stegbauer wrote:
> 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?


You have a backup copy of your DB.   ...Right?

Worse case:  Stop Bacula, drop the Bacula DB, recreate it, restart
Bacula, bscan in the volume containing your last Catalog backup, restore
the Catalog.

However, if the device your Catalog is stored on is throwing block
errors, and you do this WITHOUT first replacing that device, you're
playing Russian roulette.  Replace the drive first.


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

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