Truncate = just delete it? Or something more? -----Original Message----- From: Graham Keeling [mailto:gra...@equiinet.com] Sent: Wednesday, May 11, 2011 11:13 AM To: bacula-users@lists.sourceforge.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:dresche...@gmail.com] > Sent: Wednesday, May 11, 2011 10:33 AM > To: Duncan McQueen > Cc: Bacula-users@lists.sourceforge.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@lists.sourceforge.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@lists.sourceforge.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
