On April 9, 2017 at 12:13:28 PM, Josip Deanovic (djosip+news AT linuxpages DOT net) 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
>
> This error appear only when I doing Full backup at Sunday on my about
> 10-12 linux instances.
> *—*
>
> *Petar Kozić*
> System Administrator


Check the logs of your database server, check if the database
has enough space on the file system.

Run full backup manually and observe what is going on the backup
and the database server.

--
Josip Deanovic

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