Truncate = just delete it? Or something more?
-----Original Message-----
From: Graham Keeling [mailto:graham AT equiinet DOT com]
Sent: Wednesday, May 11, 2011 11:13 AM
To: bacula-users AT lists.sourceforge DOT net
Subject: Re: [Bacula-users] Run out of disk space
On Wed, May 11, 2011 at 11:05:47AM -0500, Duncan McQueen wrote:
> The second command gives me this:
>
> Error updating Volume records: ERR=sql_update.c:443 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
Is it because your database files are on the same disk that has filled up?
If so and it were me, I would truncate a volume that I knew that I didn't want,
restart the database and try again.
> -----Original Message-----
> From: John Drescher [mailto:drescherjm AT gmail DOT com]
> Sent: Wednesday, May 11, 2011 10:33 AM
> To: Duncan McQueen
> Cc: Bacula-users AT lists.sourceforge DOT net
> Subject: Re: [Bacula-users] Run out of disk space
>
> > I set my retention periods too long and now have run out of disk space. If
> > I want to start over (after I have edited the conf files for a good
> > retention period) and blow away the old volumes, what do I need to do? Just
> > delete the files or do I need to do something in the database?
> >
>
> You would need to delete each volume in the database. I would just
> change the retention period on the pool and then use bconsole to apply
> that to the existing volumes.
>
> I think the commands are
>
> update "Pool from resource"
>
> then
>
> update " all volumes in pool"
>
> or similar.
>
> John
>
> ------------------------------------------------------------------------------
> Achieve unprecedented app performance and reliability
> What every C/C++ and Fortran developer should know.
> Learn how Intel has extended the reach of its next-generation tools
> to help boost performance applications - inlcuding clusters.
> http://p.sf.net/sfu/intel-dev2devmay
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|