[Bacula-users] prune/purge/delete not working when using volume id

Hi All,


I upgrade to bacula 3.0.0 and then to 3.0.1 and am having a small
problem with pruning/purge/delete volume.

It looks like to query sent to mysql is a bit mixed up. It works if I
use the volume name though.

It's doing a FROM Media WHERE VolumeName='ID' instead WHERE MediaId='ID'

Se the steps done and the query logged on mysql.


*prune
You have the following choices:
     1: Files
     2: Jobs
     3: Volume
     4: Stats
Choose item to prune (1-4): 3
Defined Pools:
     1: NIX-DME-MONTHLY
     2: NIX-DME-WKLY-A
     3: NIX-DME-WKLY-B
     4: NIX-DME-WKLY-C
     5: NIX-DME-WKLY-D
     6: NIX-DME-MONDAY
     7: NIX-DME-TUESDAY
     8: NIX-DME-WEDNESDAY
     9: NIX-DME-THURSDAY
    10: NIX-DME-DAILY
    11: NIX-DME-WKLY
Select the Pool (1-11): 9
+---------+---------------+-----------+---------+----------------+----------+--------------+---------+------+-----------+-----------+---------------------+
| MediaId | VolumeName    | VolStatus | Enabled | VolBytes       |
VolFiles | VolRetention | Recycle | Slot | InChanger | MediaType |
LastWritten         |
+---------+---------------+-----------+---------+----------------+----------+--------------+---------+------+-----------+-----------+---------------------+
|       4 | NIX-DME-THU-A | Used      |       1 | 56,244,916,224 |
 61 |    1,123,200 |       1 |    0 |         0 | LTO       | 2009-04-24
02:40:47 |
|      12 | NIX-DME-THU-B | Used      |       1 | 46,400,062,464 |
 52 |    1,123,200 |       1 |    4 |         1 | LTO       | 2009-04-03
02:03:18 |
+---------+---------------+-----------+---------+----------------+----------+--------------+---------+------+-----------+-----------+---------------------+
Enter *MediaId or Volume name: 12
sql_get.c:1029 Media record for Volume "12" not found.



And this is the SQL query:

SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolParts,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime
FROM Media WHERE VolumeName='12'


Thanks


Bruno


Coming soon! Stella McCartney exclusive summer collection,
Register interest at www.net-a-porter.com/stella
______________________________________________________________________

CONFIDENTIALITY NOTICE
The information in this email is confidential and is intended solely for the 
addressee. Access to this email by anyone else is unauthorised. If you are not 
the intended recipient, you must not read, use or disseminate the information. 
Any views expressed in this message are those of the individual sender, except 
where the sender specifically states them to be the views of Net a Porter Ltd. 

Net A Porter Ltd is a company registered in England & Wales Number: 3820604 
Registered Office: The Dome, Whiteleys Centre, 151 Queensway, London, W2 4YN.
_____________________________________________________________________

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations 
Conference from O'Reilly Media. Velocity features a full day of 
expert-led, hands-on workshops and two days of sessions from industry 
leaders in dedicated Performance & Operations tracks. Use code vel09scf 
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users