Re: [Bacula-users] Corrupted catalog on bad drive - please help!

2013-02-21 Thread Uwe Schuerkamp
On Wed, Feb 20, 2013 at 09:50:14AM -0500, Phil Stracchino wrote: Also make sure you have the innodb_tables_as_files option set, otherwise you db will be one huge unmanageable blob that can't be reduced in size after a while by dumping / importing again. Whoa there, Nellie. Make sure

Re: [Bacula-users] Corrupted catalog on bad drive - please help!

2013-02-21 Thread Phil Stracchino
On 02/21/13 03:44, Uwe Schuerkamp wrote: What strategy would you suggest to shrink an innodb-based DB short of dumping, dropping and re-importing it? I feel more comfortable with the file-base approach probably because it resembles the dearly loved MyISAM behaviour ;) That dearly loved

Re: [Bacula-users] Corrupted catalog on bad drive - please help!

2013-02-20 Thread Uwe Schuerkamp
On Wed, Feb 20, 2013 at 12:17:30AM -0500, Michael Stauffer _g wrote: How do I setup the DB using InnoDB? I'm not seeing that in the docs. (I'm sticking with bacula 3.0 for now, until I can get the catalog back and do another full backup). Hello Michael, I can only answer this question:

Re: [Bacula-users] Corrupted catalog on bad drive - please help!

2013-02-20 Thread Michael Stauffer _g
Message: 14 Date: Wed, 20 Feb 2013 10:17:08 +0100 From: Uwe Schuerkamp uwe.schuerk...@nionex.net Subject: Re: [Bacula-users] Corrupted catalog on bad drive - please help! On Wed, Feb 20, 2013 at 12:17:30AM -0500, Michael Stauffer _g wrote: How do I setup the DB using InnoDB? I'm

Re: [Bacula-users] Corrupted catalog on bad drive - please help!

2013-02-20 Thread Uwe Schuerkamp
On Wed, Feb 20, 2013 at 07:58:53AM -0500, Michael Stauffer _g wrote: snip snip So if I'm making a new empty database using the setup script in bacula, then I'll do this step - right? Yep, you can also alter the create_mysql_tables.sql script directly I believe. All the best, Uwe --

Re: [Bacula-users] Corrupted catalog on bad drive - please help!

2013-02-20 Thread Phil Stracchino
On 02/20/13 04:17, Uwe Schuerkamp wrote: On Wed, Feb 20, 2013 at 12:17:30AM -0500, Michael Stauffer _g wrote: How do I setup the DB using InnoDB? I'm not seeing that in the docs. (I'm sticking with bacula 3.0 for now, until I can get the catalog back and do another full backup). Hello

Re: [Bacula-users] Corrupted catalog on bad drive - please help!

2013-02-19 Thread Michael Stauffer _g
Message: 8 Date: Mon, 11 Feb 2013 17:42:53 -0500 From: Phil Stracchino ala...@metrocast.net Subject: Re: [Bacula-users] Corrupted catalog on bad drive - please help! To: bacula-users@lists.sourceforge.net Message-ID: 511973ed.4080...@metrocast.net Content-Type: text/plain; charset=ISO-8859

Re: [Bacula-users] Corrupted catalog on bad drive - please help!

2013-02-15 Thread Michael Stauffer _g
-Original Message- From: Adrian Reyer [mailto:bacula-li...@lihas.de] Sent: Monday, February 11, 2013 5:14 PM To: Michael Stauffer _g Cc: Bacula_users_list_mgstauff_gmail Subject: Re: [Bacula-users] Corrupted catalog on bad drive - please help! On Mon, Feb 11, 2013 at 04:09:52PM -0500, Michael

[Bacula-users] Corrupted catalog on bad drive - please help!

2013-02-11 Thread Michael Stauffer _g
Hi everyone, I've got a corrupted catalog on a bad disk and could really use some advice on how to proceed. I'm very new to bacula (and pretty new to sysadmin after many years programming), and have inherited a bacula system that's been untended for a year and a half or more. It's running

Re: [Bacula-users] Corrupted catalog on bad drive - please help!

2013-02-11 Thread Adrian Reyer
On Mon, Feb 11, 2013 at 04:09:52PM -0500, Michael Stauffer _g wrote: This seems to be a disk error, but I ran 'xfs_repair' anyway but it didn't fix anything, not surprising. You could try a badblock scan as well. Catalog backups: There's a script running on the machine that backs up the

Re: [Bacula-users] Corrupted catalog on bad drive - please help!

2013-02-11 Thread Phil Stracchino
On 02/11/13 16:09, Michael Stauffer _g wrote: I'm seeing the error in bacula logs: ERR=Duplicate entry '1828889455' for key 1 running dbcheck yields: Query failed: SELECT File.FileId,Job.JobId FROM File LEFT OUTER JOIN Job ON (File.JobId=Job.JobId) WHERE Job.JobId IS NULL LIMIT 30: