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