On 01/06/2015 01:31 PM, philhu wrote: > ok, tried to do that, seems to have failed, but list volumes shows retention > is now correct:
> Select parameter to modify (1-18): 14 > Error updating Volume records: ERR=sql_update.c:451 Update failed: > affected_rows=0 for UPDATE Media SET ActionOnPurge=0, > Recycle=1,VolRetention=63072000,VolUseDuration=0,MaxVolJobs=0,MaxVolFiles=0,MaxVolBytes=53687091200,RecyclePoolId=0 > WHERE PoolId=1 > Error updating Volume records: ERR=sql_update.c:451 Update failed: > affected_rows=0 for UPDATE Media SET ActionOnPurge=0, > Recycle=1,VolRetention=63072000,VolUseDuration=0,MaxVolJobs=0,MaxVolFiles=0,MaxVolBytes=53687091200,RecyclePoolId=0 > WHERE PoolId=2 > Error updating Volume records: ERR=sql_update.c:451 Update failed: > affected_rows=0 for UPDATE Media SET ActionOnPurge=0, > Recycle=1,VolRetention=31536000,VolUseDuration=0,MaxVolJobs=0,MaxVolFiles=0,MaxVolBytes=0,RecyclePoolId=0 > WHERE PoolId=3 > All Volume defaults updated from "LTO4Tapes" Pool record. > * Hi Phil... Just a quick note regarding your mention of the command failing. If you notice, the last line says: 'All Volume defaults updated from "LTO4Tapes" Pool record.' Which means that the SQL query that Bacula sent to the DB successfully updated the records for all of the volumes in the "LTO4Tapes" pool. However, the three lines above it are a bit misleading in that they are not really errors in the true sense of an error. What actually happened was that there were no volumes in those pools to update. To verify this, type "List Pools" in bconsole. You should see four pools listed, and the first three; PoolId 1, 2, and 3 will have NumVols = 0. Hope this helps. Bill -- Bill Arlofski Reverse Polarity, LLC http://www.revpol.com/ -- Not responsible for anything below this line -- ------------------------------------------------------------------------------ Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
