Re: [Bacula-users] Fatal error: sql_create.c:894 Fill File table Query failed

2012-02-10 Thread Maria McKinley
On 2/10/12 1:37 PM, Adrian Reyer wrote: > Hi Maria, > > On Wed, Feb 08, 2012 at 11:46:24AM -0800, Maria McKinley wrote: >> 05-Feb 22:25 billie-dir JobId 3931: Fatal error: sql_create.c:894 Fill >> File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, >> FilenameId, LStat, MD5)SELECT

Re: [Bacula-users] Fatal error: sql_create.c:894 Fill File table Query failed

2012-02-10 Thread Adrian Reyer
Hi Maria, On Wed, Feb 08, 2012 at 11:46:24AM -0800, Maria McKinley wrote: > 05-Feb 22:25 billie-dir JobId 3931: Fatal error: sql_create.c:894 Fill > File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, > FilenameId, LStat, MD5)SELECT batch.FileIndex, batch.JobId, Path.PathId, >

Re: [Bacula-users] jbd2 at 99.99% usage with very low speed

2012-02-10 Thread Josh Fisher
On 2/10/2012 9:11 AM, Cristóbal Sabroe Yde wrote: > El 09/02/12 13:46, Cristóbal Sabroe Yde escribió: >> Hi, I've just installed a new backup system consisting of An IBM >> TS3100 ( LTO5) with bacula 5.2.5 running on an openSUSE 12.1 x86_64 >> server. >> >> I'm having VERY low backup speed with

Re: [Bacula-users] BackupCatalog failes

2012-02-10 Thread John Drescher
> Thanks for your help. What I can't understand is why all four backup jobs > running well without an error then? if I understand you correctly, you're > saying if the BackupCatalog fails, the backup jobs should all fail? No. I am saying if the catalog gets corrupted and you do not make regular ba

Re: [Bacula-users] jbd2 at 99.99% usage with very low speed

2012-02-10 Thread Cristóbal Sabroe Yde
El 09/02/12 13:46, Cristóbal Sabroe Yde escribió: Hi, I've just installed a new backup system consisting of An IBM TS3100 ( LTO5) with bacula 5.2.5 running on an openSUSE 12.1 x86_64 server. I'm having VERY low backup speed with 99.99% io

Re: [Bacula-users] FreeBSD 9 and ZFS with compression - should be fine?

2012-02-10 Thread Gary R. Schmidt
On 02/10/12 06:58, Paul Mather wrote: > On Feb 9, 2012, at 2:21 PM, Steven Schlansker wrote: > >> >> On Feb 9, 2012, at 11:05 AM, Mark wrote: >>> Steven, out of curiosity, do you see any benefit with dedup (assuming that >>> bacula volumes are the only thing on a given zfs volume). I did some >>

Re: [Bacula-users] FreeBSD 9 and ZFS with compression - should be fine?

2012-02-10 Thread Paul Mather
On Feb 10, 2012, at 1:53 AM, Silver Salonen wrote: > On Thu, 9 Feb 2012 14:58:33 -0500, Paul Mather wrote: >> On Feb 9, 2012, at 2:21 PM, Steven Schlansker wrote: >>> On the flip side, compression seems to be a very big win. I'm >>> seeing ratios from 1.7 to 2.5x savings and the CPU usage is cla

Re: [Bacula-users] FreeBSD 9 and ZFS with compression - should be fine?

2012-02-10 Thread mayak-cq
On Thu, 2012-02-09 at 23:48 -0800, Steven Schlansker wrote: > > I'll ask just in case - you don't have Bacula FD's compression enabled > > for these filesets which give these compression ratios, do you? > > I do not. I assume doubly compressing would suck up CPU with little to no > gain, alt

Re: [Bacula-users] FreeBSD 9 and ZFS with compression - should be fine?

2012-02-10 Thread Steven Schlansker
On Feb 9, 2012, at 10:53 PM, Silver Salonen wrote: > On Thu, 9 Feb 2012 14:58:33 -0500, Paul Mather wrote: >> On Feb 9, 2012, at 2:21 PM, Steven Schlansker wrote: >>> On the flip side, compression seems to be a very big win. I'm >>> seeing ratios from 1.7 to 2.5x savings and the CPU usage is cl