In response to Phil Stracchino <ala...@metrocast.net>: > One of my ten differential backups last night failed with an error I've > never seen before:
<snip> > 25-Jan 03:43 babylon4-dir JobId 978: Fatal error: sql_create.c:825 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 <snip> > This is Bacula-3.0.3 on Solaris 10 x86, locally compiled, running > against the preinstalled Solaris 10 MySQL 4.0.31 package. Jobs both > before and after this one completed without incident. Only this job, of > a batch of ten running concurrently, failed. The CLOSEST to full > filesystem on the server has over 110GB free. > > Is this something we need to be concerned about? (Unfortunately, not > knowing what caused it, I have no idea how to reproduce it.) Looks like MySQL was blocking on some other operation. Is there something else that runs on this database around this time? (i.e. dbcheck?) I'm not as familiar with MySQL as some might be, but there should be a way to get more information from MySQL's logs. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ ------------------------------------------------------------------------------ Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
