On Tue, Jan 11, 2011 at 1:39 PM, Kern Sibbald <k...@sibbald.com> wrote: > On Tuesday 11 January 2011 14:29:45 Victor Hugo dos Santos wrote:
Hello Kern, [...] >> 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. mmmm.. but after the last problem (last week) I install the postgresql in others server and restore my last catalog backup in this "new" server. For this, I can't believe that the problem is with the server/hardware/postgresql OK... this is a different error/problem, but 2 servers with hardware problems ?? If it is correct (two bad servers), we don't need a sysadmin, we will need a "witch voodoo" here. >> 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. the vaccumdb don't show any type of problems. ============= $ sudo su - postgres -c "vacuumdb -a -f -z" vacuumdb: vacuuming database "bacula" vacuumdb: vacuuming database "postgres" vacuumdb: vacuuming database "roundcubemail" vacuumdb: vacuuming database "template1" vacuumdb: vacuuming database "wikidb" ============= and reindexdb too. >> 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. This the output from dbcheck ========================== Select function number: 16 Checking for Filenames with a trailing slash Found 0 bad Filename records. Checking for Paths without a trailing slash Found 1 bad Path records. Reparing 1 bad Filename records. Checking for duplicate Filename entries. Found 171 duplicate Filename records. Checking for duplicate Path entries. Found 1 duplicate Path records. Checking for orphaned JobMedia entries. Checking for orphaned File entries. This may take some time! Checking for orphaned Path entries. This may take some time! Found 9845 orphaned Path records. Deleting 9845 orphaned Path records. Checking for orphaned Filename entries. This may take some time! Found 215920 orphaned Filename records. Deleting 215920 orphaned Filename records. Checking for orphaned FileSet entries. This takes some time! Found 3 orphaned FileSet records. Deleting 3 orphaned FileSet records. Checking for orphaned Client entries. Found 1 orphaned Client records. Deleting 1 orphaned Client records. Checking for orphaned Job entries. Found 0 orphaned Job records. Checking for Admin Job entries. Found 0 Admin Job records. Checking for Restore Job entries. Found 57 Restore Job records. Deleting 57 Restore Job records. ========================== bad ?? very bad ?? thanks -- -- Victor Hugo dos Santos Linux Counter #224399 ------------------------------------------------------------------------------ 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
