> 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
