Has anybody else experianced this error with bacula:
20-Jun 23:07 bacula-dir JobId 30430: Fatal error: sql_create.c:822 Fill
File table Query failed: INSERT INTO File (FileIndex, JobId, PathId,
FilenameId, LStat, MD5)SELECT batch.FileIndex, batch.JobId, Path.PathId,
Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON
(batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name):
ERR=Lock wait timeout exceeded; try restarting transaction
If you did what was your fix? I am getting about one of these a night.
If I rerun the job it runs fine.
Thanks -Jason
--
----------------------------------------------------------------------------
Jason A. Kates (jason AT kates DOT org)
Fax: 208-975-1514
Phone: 212-400-1670 x2
============================================================================
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|