Rif: [Bacula-users] File table - inconsistency

2006-05-22 Thread Ferdinando Pasqualetti 

Ciao Fabrizio,
I'll answer in English, to be understood
by the list.
There are no direct indexes pointing
to files from Jobs or Volumes, so deletion of them at each pruning would
be very expensive in terms of resources.
Anyway you can delete unuseful items
using dbcheck. I have in a daily crontab this command:

/usr/sbin/dbcheck -f -b -c /etc/bacula/bacula-dir.conf
 /tmp/dbcheck.log 21

This should free some space for reuse.
If you want to shrink the database you must save it with:

/etc/bacula/make_catalog_backup bacula
bacula

Then you must drop and rebuld the DB
(or drop all its tables) and restore it with:

mysql bacula  /var/bacula/bacula.sql

I hope this will be useful for you or
someone else.


--
Ferdinando Pasqualetti
G.T.Dati srl
Tel. 0557310862 - 3356172731 - Fax 055720143








.:faber:. [EMAIL PROTECTED]

Inviato da: [EMAIL PROTECTED]
22/05/2006 09.39



Per favore, rispondere
a
[EMAIL PROTECTED]





Per
bacula-users@lists.sourceforge.net


CC



Oggetto
[Bacula-users] File table - inconsistency








Hi to all.

I am a bacula-newbie, and I am trying to use it in a production
environment.
I have notice a weird thing about the File table in bacula database: in
this table, the lines of the files belonging to expired job aren't
deleted so this table will always grow... 
Is this correct? And if it is, could you please tell me why is this
done?

I have experienced such things both on PostgreSQL and MySQL, so I think
that this thing is not an error depending on the database engine...

Thanks in advance to anyone who will help me to understand this thing.


-- 
Fabrizio `faber` Vecchi
---
Il cervello e' un organo meraviglioso: comincia
a lavorare fin dal mattino quando ti svegli, e
non smette finche' non vai in ufficio.

-- Paul Frost --





---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job
easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users





---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk=120709=263057=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: Rif: [Bacula-users] File table - inconsistency

2006-05-22 Thread .:faber:. 
Thanks Ferdinando and Rudolf for your answers.

On Mon, 2006-05-22 at 10:28 +0200, Ferdinando Pasqualetti wrote:
 
 There are no direct indexes pointing to files from Jobs or Volumes, so
 deletion of them at each pruning would be very expensive in terms of
 resources. 
That's just what I used to do at the end of every backup using a php
script, but I think that it's just a temporary solution... just to wait
the #613-bug-fixed release of bacula.
BTW can anyone tell me when will this release come out? 

Cheers :)
-- 
Fabrizio `faber` Vecchi
---
Il cervello e' un organo meraviglioso: comincia
a lavorare fin dal mattino quando ti svegli, e
non smette finche' non vai in ufficio.

-- Paul Frost --




---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: Rif: [Bacula-users] File table - inconsistency

2006-05-22 Thread Rudolf Cejka 
Ferdinando Pasqualetti wrote (2006/05/22):
 ...

I could not read and reply to html mails well, but if you have MySQL and
MyISAM, you do not need to drop the tables - it is sufficient to perform
  optimize table File;
and all other tables (File, Path, Filename, ...) you want to shrink.
Hopefully it would work for InnoDB too, or I believe there should be
some other way to shrink tables without dropping them and rebuilding
the db again. Similarly there is a command vacuumdb in PgSQL.

-- 
Rudolf Cejka cejkar at fit.vutbr.cz http://www.fit.vutbr.cz/~cejkar
Brno University of Technology, Faculty of Information Technology
Bozetechova 2, 612 66  Brno, Czech Republic


---
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users