Hello, 28.11.2009 13:27, Carlo Filippetto wrote: > Hi.. I'm new for this newslwetter,
Welcome! I hope you find all the help you need, and stay around and help others, too! > I had this error and I don't > know how to fix it > > Con you halp me? > > --------------- 27-nov 21:41 megabot-bck-dir JobId 3991: Fatal > error: Can't 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=Incorrect key file for table > './bacula/File.MYI'; try to repair it The MySQL table is damaged. The usual cure is to stop Bacula and use mysqlcheck to fix the broken tables. Something like 'mysqlcheck bacula File' would be the starting point, and you'd add options as needed. --auto-repair would probably be useful :-) Afterwards, you should use Bacula's dbcheck tool to verify the integrity of the catalog database. dbcheck can run very long! Cheers, Arno > --------------- > > > I have received this error just onces. After this message I've > received more errors for all the other backups I've done.. > > -------------- 28-nov 12:30 megabot-bck-dir JobId 4004: Fatal > error: Can't 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=Duplicate entry '54718349' for key 1 > > -------------- > > > Sorry for my English! > > Thanks > > > ------------------------------------------------------------------------ > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports > 2008 30-Day trial. Simplify your report design, integration and > deployment - and focus on what you do best, core application > coding. Discover what's new with Crystal Reports now. > http://p.sf.net/sfu/bobj-july > > > ------------------------------------------------------------------------ > > > _______________________________________________ Bacula-users > mailing list Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Arno Lehmann IT-Service Lehmann Sandstr. 6, 49080 Osnabrück www.its-lehmann.de ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
