Bacula-users

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

2017-04-09 12:53:31
Subject: Re: [Bacula-users] Fatal error sql_create.c
From: Petar Kozić <petar.kozic AT mint DOT rs>
To: Josip Deanovic <djosip+news AT linuxpages DOT net>
Date: Sun, 9 Apr 2017 18:52:42 +0200
Yes, I am using spooling, but I don't have define spooling directory. Director and mysql is on same server. Storage is on same but on different mount point LVM.

On Apr 9, 2017 6:23 PM, "Josip Deanovic" <djosip+news AT linuxpages DOT net> wrote:
On Sunday 2017-04-09 05:50:31 Petar Kozić wrote:
> This happend only on Sunday when Bacula run scheduled full backup on
> about 12 instances. Ofcorse, I have different run time in schedule, but
> because some instances have lot data, in some time 2-3 instances works
> in same time.
>
> I have over 70GB free space on mysql server and thats not problem. I’m
> also increase innodb_timeout from 50 to 100 last week when I have same
> problem.
>
> I have enabled batch insert, maybe thats problem or I must to increase
> inndob_timeout more.

Are you using spooling?
If yes, is your spool directory on the same file system as your database
data?

--
Josip Deanovic

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users