On 2/10/12 1:37 PM, Adrian Reyer wrote: > Hi Maria, > > On Wed, Feb 08, 2012 at 11:46:24AM -0800, Maria McKinley wrote: >> 05-Feb 22:25 billie-dir JobId 3931: Fatal error: sql_create.c:894 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=Table './bacula/File' is marked as crashed and last (automatic?) >> repair failed > > Have you tried 'mysqlrepair bacula File' or 'mysqlrepair -A'? > > Regards, > Adrian
Thanks so much, not sure why I didn't find that command. I am cautiously optimistic that worked. Was able to check status, and start a new job without errors. cheers, maria ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
