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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users