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/[email protected]/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
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
