The following bug has been CLOSED
======================================================================
http://bugs.bacula.org/bug_view_advanced_page.php?bug_id=0000219
======================================================================
Reported By: ArnoL
Assigned To:
======================================================================
Project: bacula
Bug ID: 219
Category: Director
Reproducibility: have not tried
Severity: minor
Priority: normal
Status: closed
======================================================================
Date Submitted: 01-20-2005 04:20 PST
Last Modified: 02-26-2005 14:09 PST
======================================================================
Summary: wrong pool information in catalog
Description:
After noticing a problem with pools with "Maximum Volumes" set, I checked
the catalog database and found that the NumVols stored in Pool does not
represent the actual number of volumes in the pools.
select Name,NumVols from Pool;
+---------+---------+
| Name | NumVols |
+---------+---------+
| Default | 0 |
| TMPDisk | 0 |
| DDS | 4 |
| QIC | 23 |
| Full | 18 |
| Diff | 18 |
| Incr | 11 |
| Schrott | 0 |
+---------+---------+
select Pool.Name,count(*) from Media,Pool where Pool.PoolId=Media.PoolId
group by Media.PoolId;
+---------+----------+
| Name | count(*) |
+---------+----------+
| TMPDisk | 1 |
| DDS | 2 |
| Full | 43 |
| Diff | 17 |
| Incr | 10 |
| QIC | 22 |
| Schrott | 3 |
+---------+----------+
which seems to indicate that bacula loses track of the volumes and pools
somewhere... not even the total number of volumes is right, so it's
probably not moving volumes from one pool to another that causes these
problems.
======================================================================
----------------------------------------------------------------------
kern - 02-10-2005 02:45 PST
----------------------------------------------------------------------
I noticed this problem some time ago, and have corrected it in version 1.37
(I think). If you know how to produce the inconsistent state, it would be
helpful if you would test version 1.37 (caution, it requires a new or
upgrade to the database and is probably not yet ready for production).
Since the problem has been around so long, I doubt I'll fix it in 1.36.2.
----------------------------------------------------------------------
ArnoL - 02-10-2005 08:39 PST
----------------------------------------------------------------------
Unfortunately, I don't know how to produce that state.
I actually left everything as it was (incorrect), because I don't limit
the volumes in a pool that way.
At the moment, using 1.37 is not possible for me.
I will correct the Pool information and regularly check if it's still ok,
perhaps I can find what causes the irregularities. (I do update volume
params to move tapes between pools and I add tapes).
I'll add my findisngs as Bugnotes.
----------------------------------------------------------------------
ArnoL - 02-12-2005 11:13 PST
----------------------------------------------------------------------
One first result:
Moving a tape from one pool to another - changing it's Pool attribute -
modified the table Pool correctly.
----------------------------------------------------------------------
ArnoL - 02-26-2005 13:29 PST
----------------------------------------------------------------------
After some serious volume adding and moving still no differences between
actual pool contents and the Pools table.
I suggest closing this bug as either unresolvable or not reproducable, and
see if it urns up again in later versions.
----------------------------------------------------------------------
kern - 02-26-2005 14:09 PST
----------------------------------------------------------------------
Thanks for all your testing and for suggesting to close the bug. I suspect
that your pool got out of sync with an older unfixed version of Bacula.
If it happens again, please re-open the bug or open a new one.
Bug History
Date Modified Username Field Change
======================================================================
01-20-05 04:20 ArnoL New Bug
02-10-05 02:45 kern Bugnote Added: 0000644
02-10-05 02:45 kern Status new => feedback
02-10-05 08:39 ArnoL Bugnote Added: 0000647
02-12-05 11:13 ArnoL Bugnote Added: 0000657
02-26-05 13:29 ArnoL Bugnote Added: 0000704
02-26-05 14:09 kern Bugnote Added: 0000705
02-26-05 14:09 kern Resolution open => fixed
02-26-05 14:09 kern Status feedback => closed
======================================================================
|