I think that I found this from another thread.  I had read the thread
but I thought it didn't apply since I can create temp tables:
http://www.mail-archive.com/bacula-devel AT lists.sourceforge DOT 
net/msg01145.html

It seems that I am using more than my 8GB of /tmp for temporary tables
when the I get the insert error.

I have mysql using /tmp for temp tables:
none                  8.0G  1.3G  6.8G  17% /tmp

This is a mysql error that I will fix.
                        Thanks -Jason

On Sat, 2008-06-21 at 08:51 -0400, Jason A. Kates wrote:
> 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