Bacula-users

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

2017-04-09 09:13:11
Subject: Re: [Bacula-users] Fatal error sql_create.c
From: "Gary R. Schmidt" <grs AT mcleod-schmidt.id DOT au>
To: bacula-users AT lists.sourceforge DOT net
Date: Sun, 9 Apr 2017 23:12:01 +1000
On 09/04/2017 22:50, 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.
> 

How much free *temporary* filespace is there?

MySQL needs lots of /tmp, or however you have configured it.

You might want to run one of the various MySQL tuning tools out there, I 
likr http://mysqltuner.pl.

        Cheers,
                Gary    B-)

------------------------------------------------------------------------------
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