Backup Central

Hi there,

I had a backup go horribly bad the other day. I believe it was because
of a lost connection during the backup. Since then, I have not been able
to do backup. I have tried using both dbcheck and myisamchk to repair
the databases, but this has not helped. I am afraid my knowledge of
mysql is extremely limited, and I am not sure what to do. The errors
just keep piling up. Here is an example:

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

Judging from other, plentiful error messages, it appears most of the
tables are marked as crashed. How do I repair these problems?

thanks,
maria

------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

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

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