Re: [Bacula-users] s3fs access issue

2017-04-13 Thread Ana Emília M . Arruda
Hello, bacula-sd daemon usually run as bacula user. The directory defined in "Archive Device" should have bacula:disk or bacula:tape ownership. Please have a look at permissions/ownership of "/mnt/s3/consi-it-backup/" to allow bacula user access. Best regards, Ana > I fixed the earlier client

Re: [Bacula-users] Fatal error sql_create.c

2017-04-13 Thread Ana Emília M . Arruda
Hello Petar, I'm sorry I didn't give you details about the best value for ' innodb_autoinc_lock_mode' to use with bacula catalog. Having "innodb_autoinc_lock_mode=2" is the best option for performance of bulk INSERTs (you can see some INSERT...SELECT statements in the logs you sent here). I am

Re: [Bacula-users] Fatal error sql_create.c

2017-04-13 Thread Ana Emília M . Arruda
Hello Petar, Please have a look here: http://bacula.10910.n7.nabble.com/innodb-autoinc-lock-mode-td82493.html Maybe the script for MySQL tunning can help with MariaDB too: https://github.com/major/MySQLTuner-perl Best regards, Ana On Thu, Apr 13, 2017 at 10:09 PM, Petar Kozić wrote: > I usin

[Bacula-users] Restore OK -- warning file count mismatch

2017-04-13 Thread Parthibarajan
Hi, Can anyone explain me why i receive the error and unable to perform restore locally and remotely ?bacula dir version is 7.0.5 file size to restore is 23 GB  ThanksParthi-- Check out the vibrant tech community on one o

Re: [Bacula-users] Fatal error sql_create.c

2017-04-13 Thread Petar Kozić
I using MariaDB 10.1. Which value of innodb_autoinc_lock_mode is best for Bacula, do you know ? *—* *Petar Kozić* System Administrator On April 13, 2017 at 10:04:23 PM, Ana Emília M. Arruda ( emiliaarr...@gmail.com) wrote: Hello Petar, Could you please let us know which Bacula/MySQL Databa

Re: [Bacula-users] Fatal error sql_create.c

2017-04-13 Thread Ana Emília M . Arruda
Hello Petar, Could you please let us know which Bacula/MySQL Database version are you using? Maybe it would be a good idea to have a look at "innodb_autoinc_lock_mode " configuration.​ ​Best regards,

Re: [Bacula-users] Fatal error sql_create.c

2017-04-13 Thread Petar Kozić
Thank you on your answer. Yes I have about 80GB free in drive where is SD working directory. *—* *Petar Kozić* System Administrator On April 13, 2017 at 9:18:39 PM, Ana Emília M. Arruda ( emiliaarr...@gmail.com) wrote: Hi Petar, If you are using spool attributes, you need enough space in th

Re: [Bacula-users] Fatal error sql_create.c

2017-04-13 Thread Ana Emília M . Arruda
Hi Petar, If you are using spool attributes, you need enough space in the SD working directory to store them before SD send attributes to Director. Could you please check if you have enough space in the SD working directory? Best regards, Ana On Wed, Apr 12, 2017 at 6:40 AM, Petar Kozić wrote:

Re: [Bacula-users] Restores very slow while selecting files

2017-04-13 Thread Kern Sibbald
Hello, Bacula was designed to handle a maximum of 10M files (Bacula 5.0.x). Since then file systems have grown a lot and so has Bacula. We have redesigned Bacula a number of times to be able to cope with 50M or more files. From what I see, your problems are in the following areas: 1. You ar

Re: [Bacula-users] No Job status returned from FD. Backup fails

2017-04-13 Thread Matthias Koch-Schirrmeister
And another error: Fatal error: append.c:183 Error reading data header from FD. n=-2 msglen=0 ERR=Connection reset by peer Don't know how to read it, though. This time a CentOS client running FD 5.2.13 is affected. I have no reasons to believe that we actually lost physical connection to the re

Re: [Bacula-users] Restores very slow while selecting files

2017-04-13 Thread Tom Yates
On Wed, 12 Apr 2017, Martin Simmons wrote: > Does that file tree have a lot of hard links (I think the add command only > makes those queries for hard links)? If so, then using Bacula 7 might help > (see "restore optimizespeed" in > http://www.bacula.org/downloads/Bacula-7.4.0/ReleaseNotes). Tha