On Tuesday 11 January 2011 14:29:45 Victor Hugo dos Santos wrote: > 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 ??
Very unlikely. It looks like the Postgres database has been corrupted. You will need to research the problem and solution on the Postgres web site. > How I can debug this error ??? Probably your best bet is to use postgres tools to completely check and repair the database. Otherwise, you may need to revert to an older copy of your database. > and more important, how I can check the integrity of my catalog from > bacula (vaccumdb don't show problems)?? As John mentioned, perhaps dbcheck might turn up something. Kern > > thanks and attentive to any commentary. ------------------------------------------------------------------------------ Protect Your Site and Customers from Malware Attacks Learn about various malware tactics and how to avoid them. Understand malware threats, the impact they can have on your business, and how you can protect your company and customers by using code signing. http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
