> 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