Hi guys !!

Two weeks ago, my system began working abnormal..
first, the database have a "corruption" in table public.file
http://www.mail-archive.com/pgsql-admin@postgresql.org/msg36393.html

I sent this error to the pgsql-admin, because I thought that the
problem was only in the database.

In this opportunity I checked the RAM, disk and change the data base
to other server, but without solution.
After a couple of day, I decide to restore a backup of my catalog and
began work fine until yesterday.


But, yesterday I receive this message:

=================
10-Jan 06:11 bacula-dir JobId 31162: Fatal error: sql_create.c:875
Fill Filename table Query failed: INSERT INTO Filename (Name) SELECT
a.Name FROM (SELECT DISTINCT Name FROM batch) as a WHERE NOT EXISTS
(SELECT Name FROM Filename WHERE Name = a.Name): ERR=ERROR:  could not
open relation with OID 2247622656
=================

well, this occurred with one of my jobs (96 in total)... but, today
"this same" error was occurred in other job/client

=================
11-Jan 00:24 bacula-dir JobId 31173: Fatal error: sql_create.c:875
Fill Filename table Query failed: INSERT INTO Filename (Name) SELECT
a.Name FROM (SELECT DISTINCT Name FROM batch) as a WHERE NOT EXISTS
(SELECT Name FROM Filename WHERE Name = a.Name): ERR=ERROR:  could not
open relation with OID 2247622656
=================

Note: All others backup finished OK.

More info:
    bacula-dir: 5.0.1
    bacula-fd (cliente1): 2.4.2
    bacula-fd (cliente2): 5.0.1
    postgresql: 8.4.6-0ubuntu10.04


That is a bacula bug ??
How I can debug this error ???
and more important, how I can check the integrity of my catalog from
bacula (vaccumdb don't show problems)??

thanks and attentive to any commentary.

-- 
--
Victor Hugo dos Santos
Linux Counter #224399

------------------------------------------------------------------------------
Gaining the trust of online customers is vital for the success of any company
that requires sensitive data to be transmitted over the Web.   Learn how to 
best implement a security strategy that keeps consumers' information secure 
and instills the confidence they need to proceed with transactions.
http://p.sf.net/sfu/oracle-sfdevnl 
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel

Reply via email to