Re: [Bacula-users] Fatal error sql

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 (heitor AT bacula.com DOT 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 AT lists.sourceforge DOT 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

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