----- Ursprüngliche Mail -----
Von: "Thomas Stegbauer" <mailinglis...@stegbauer.info>
An: bacula-users@lists.sourceforge.net
Gesendet: Freitag, 20. Mai 2011 13:57:45
Betreff: Re: [Bacula-users] howto to recover postgres catalog after delete from
file
----- Ursprüngliche Mail -----
Von: "Martin Simmons" <mar...@lispworks.com>
An: bacula-users@lists.sourceforge.net
Gesendet: Freitag, 20. Mai 2011 12:06:59
Betreff: Re: [Bacula-users] howto to recover postgres catalog after delete from
file
>>>>> 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
------------------------------------------------------------------------------
\d file
Table "public.file"
Column | Type | Modifiers
------------+---------+--------------------
fileid | bigint | not null
fileindex | integer | not null default 0
jobid | integer | not null
pathid | integer | not null
filenameid | integer | not null
markid | integer | not null default 0
lstat | text | not null
md5 | text | not null
hi Martin,
that was the appropriate tip. i recreated the indexes, the foreign_key and the
sequence, now i was able to make two Backup.
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
