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
|