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
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
