Thank you very much, I also think it is innodb_timeout is relevant for this
problem, because I was get this error last week and when I increase timeout
from 50 to 100 this problem was disappear. After few days I was restart
mysql, but I still to add this statement in my.cnf and timeout was revert
to 50.
Last night I was increase timeout to 150 and set in my.cnf
I will inform is the problem solved.
Thank you.
*—*
*Petar Kozić*
System Administrator
On April 9, 2017 at 7:55:19 PM, Heitor Faria (hei...@bacula.com.br) wrote:
> On Sunday 2017-04-09 02:49:41 Petar Kozić wrote:
>> Hi,
>> Can someone tell me why I get this error:
>>
>> Fatal error: sql_create.c:833 Fill File table Query failed: INSERT INTO
>> File (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT
>> batch.FileIndex, batch.JobId, Path.PathId,
>> Filename.FilenameId,batch.LStat, batch.MD5, batch.DeltaSeq FROM batch
>> JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name =
>> Filename.Name): ERR=Lock wait timeout exceeded; try restarting
>> transaction
Hello, Peter: I suspect this error was here before on this list. There is a
workaround which is increasing database lock wait timeout value, and
probably deploy some configuration tuning for Bacula workload in order to
prevent transactions taking that long.
>> This error appear only when I doing Full backup at Sunday on my about
>> 10-12 linux instances.
>> *—*
>>
>> *Petar Kozić*
>> System Administrator
Regards,
--
===========================================================================
Heitor Medrado de Faria | Bacula do Brasil
• Não seja tarifado pelo tamanho dos seus backups, conheça o Bacula
Enterprise: http://www.bacula.com.br/enterprise/
• Ministro treinamento e implementação in-company do Bacula Community:
http://www.bacula.com.br/in-company/
(61) 98268-4220 | www.bacula.com.br
============================================================================
Indicamos também as capacitações complementares:
• Shell básico e Programação em Shell com Julio Neves.
• Zabbix com Adail Host.
============================================================================
------------------------------------------------------------------------------
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
