Re: [Bacula-users] damaged database (was Re: possible bug found)

2007-03-17 Thread Mike Seda
Hi Kern, Thanks for these tips... I didn't see them until just now... I actually fixed the database already based on documented changes that I had stored in my Wiki and bacula emails (containing JobId and VolumeName)... I verified the changes by doing a few restores and the aforementioned doubl

Re: [Bacula-users] damaged database (was Re: possible bug found)

2007-03-15 Thread Kern Sibbald
On Thursday 15 March 2007 16:17, Mike Seda wrote: > Ok.. I have found all references to MediaId... The following sql > statements were executed: > select MediaId, JobId from JobMedia; > select MediaId from Media; > select MediaId from CDImages; > select MediaId from LocationLog; > > Since I also ch

Re: [Bacula-users] damaged database (was Re: possible bug found)

2007-03-15 Thread Mike Seda
Ok.. I have found all references to MediaId... The following sql statements were executed: select MediaId, JobId from JobMedia; select MediaId from Media; select MediaId from CDImages; select MediaId from LocationLog; Since I also changed PoolId, I did: select PoolId from Pool; select PoolId from

[Bacula-users] damaged database (was Re: possible bug found)

2007-03-15 Thread Mike Seda
Hi All, Kern is right... I should have never changed those MediaIds... I actually remember changing a few other things such as renaming the Default pool to Weekly and resetting the auto_increment value on Media and Pool tables. I also remember changing something about PoolId. In hind-sight, I d