Ooops...
Thanks for that.
I completely ignored the * as I always used it without the *.
Is it a 3.0.* thing? If it it...I might not have read the release notes
properly.
Thank you.
Bruno
John Drescher wrote:
> On Thu, Apr 30, 2009 at 12:31 PM, Bruno Almeida
> <bruno.almeida AT net-a-porter DOT com> wrote:
>> 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.
>>
>>
>
> Prefix the mediaid with a * as in
>
> It purges (deletes) all Files from a Job,
> JobId, Client or Volume; or it purges (deletes)
> all Jobs from a Client or Volume without regard
> for retention periods. Normally you should use the
> PRUNE command, which respects retention periods.
> You have the following choices:
> 1: files
> 2: jobs
> 3: volume
> Choose item to purge (1-3): 3
> Defined Pools:
> 1: Default
> 2: Catalogs
> 3: Users
> 4: Temp
> 5: Scratch
> Select the Pool (1-5): 1
> +---------+---------------+-----------+---------+---------------+----------+--------------+---------+------+-----------+-------------+---------------------+
> | mediaid | volumename | volstatus | enabled | volbytes |
> volfiles | volretention | recycle | slot | inchanger | mediatype |
> lastwritten |
> +---------+---------------+-----------+---------+---------------+----------+--------------+---------+------+-----------+-------------+---------------------+
> | 1 | JMD0-Def-0001 | Full | 1 | 5,368,696,070 |
> 1 | 2,592,000 | 1 | 0 | 0 | File |
> 2009-04-05 02:10:57 |
> | 2 | JMD0-Def-0002 | Full | 1 | 4,947,230,240 |
> 1 | 2,592,000 | 1 | 0 | 0 | File |
> 2009-04-05 02:51:27 |
> | 12 | JMD0-Def-0012 | Append | 1 | 1,056,896,794 |
> 0 | 2,592,000 | 1 | 0 | 0 | File |
> 2009-04-30 02:11:19 |
> | 14 | JMD0-Def-0014 | Full | 1 | 5,368,696,890 |
> 1 | 2,592,000 | 1 | 0 | 0 | File |
> 2009-03-28 02:09:00 |
> | 27 | JMD0-Def-0027 | Full | 1 | 5,368,703,580 |
> 1 | 2,592,000 | 1 | 0 | 0 | File |
> 2009-04-13 02:06:29 |
> | 31 | JMD0-Def-0031 | Full | 1 | 5,368,673,136 |
> 1 | 2,592,000 | 1 | 0 | 0 | File |
> 2009-04-21 02:09:44 |
> | 36 | JMD0-Def-0036 | Full | 1 | 5,368,654,783 |
> 1 | 2,592,000 | 1 | 0 | 0 | File |
> 2009-04-22 02:28:05 |
> | 44 | JMD0-Def-0044 | Full | 1 | 5,368,687,123 |
> 1 | 2,592,000 | 1 | 0 | 0 | File |
> 2009-04-28 02:06:10 |
> | 49 | JMD0-Def-0049 | Full | 1 | 5,368,699,865 |
> 1 | 2,592,000 | 1 | 0 | 0 | File |
> 2009-04-19 02:14:20 |
> | 50 | JMD0-Def-0050 | Error | 1 | 0 |
> 0 | 2,592,000 | 1 | 0 | 0 | File |
> |
> | 51 | JMD0-Def-0051 | Append | 1 | 0 |
> 0 | 2,592,000 | 1 | 0 | 0 | DVD |
> |
> | 52 | JMD0-Def-0052 | Append | 1 | 597,771,314 |
> 0 | 2,592,000 | 1 | 0 | 0 | OfflineFile |
> 2009-03-25 12:32:24 |
> | 53 | JMD0-Def-0053 | Error | 1 | 0 |
> 0 | 2,592,000 | 1 | 0 | 0 | File |
> |
> +---------+---------------+-----------+---------+---------------+----------+--------------+---------+------+-----------+-------------+---------------------+
> Enter *MediaId or Volume name: *50
> 0 Files on Volume "JMD0-Def-0050" purged from catalog.
> There are no more Jobs associated with Volume "JMD0-Def-0050". Marking
> it purged.
> *
>
>
> John
--
Bruno Almeida
Enterprise Systems
NET-A-PORTER
The Dome
Whiteleys Centre
151 Queensway
London
W2 4YN
Tel: 0207 255 4500
www.net-a-porter.com
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
|
