Hey guys, what's up? Could someone try to help me to identify why some of my jobs have this error below? This happen only sometimes.
Fatal error: sql_create.c:841 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 I found this "solution" in a place. Do you think that will it resolve? ---------------------------------------------------------------------------- "If you run into this problem, there is a fairly simple fix in most cases. The default innodb lock wait timeout is 50 seconds. To change it, edit the MySQL config file (normally /etc/my.cnf) and change the line: # innodb_lock_wait_timeout=50 to: innodb_lock_wait_timeout=100 Then restart MySQL and Bacula." ---------------------------------------------------------------------------- Thanks!!
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
