Bacula-users

Re: [Bacula-users] Fatal error: sql_create.c:894 Fill File table Query failed

2012-02-10 16:39:35
Subject: Re: [Bacula-users] Fatal error: sql_create.c:894 Fill File table Query failed
From: Adrian Reyer <bacula-lists AT lihas DOT de>
To: Maria McKinley <maria AT shadlen DOT org>
Date: Fri, 10 Feb 2012 22:37:16 +0100
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
-- 
LiHAS - Adrian Reyer - Hessenwiesenstraße 10 - D-70565 Stuttgart
Fon: +49 (7 11) 78 28 50 90 - Fax:  +49 (7 11) 78 28 50 91
Mail: lihas AT lihas DOT de - Web: http://lihas.de
Linux, Netzwerke, Consulting & Support - USt-ID: DE 227 816 626 Stuttgart

------------------------------------------------------------------------------
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
<Prev in Thread] Current Thread [Next in Thread>