Thanks Mr. Harper for the reply. Me too found that this happenes sometimes when the mysql file tbl_name MAX_ROWS value reaches its limits. We shall increase this limit and see if the error persists. One point you mentioned about spooling to the same volume. The details of the spool are ,
Maximum Spool Size = 8G Maximum Job Spool Size = 8G SpoolDirectory = /var/backup; But currently /var partition has 13 GB free space. Isnt it enough for our backup? What if we disable the spooling. Will it help? I would like to know how you pointed out "You are spooling to the same volume as your database" ?? Thanks in adv. Regards, Sac -----Original Message----- From: James Harper [mailto:james.har...@bendigoit.com.au] Sent: Montag, 8. Juni 2009 08:49 To: Holikar, Sachin (ext); bacula-users@lists.sourceforge.net Subject: RE: [Bacula-users] Bacula Fatal Error > > Hello, > > We have been using Bacula Version: 2.2.7 for our backup needs. Today morning > we have received a fatal error and the backup could not be completed. Strange > enough the backup termination status is saying OK. If you have any kind of > hint to resolution of this error then kindly suggest the same. Thanks in > advance. > > ... > > 06-Jun 15:20 remote-dir JobId 2014: 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=The table > 'File' is full > That last message 'The table 'File' is full' is probably the reason. One or more of the following is probably true: 1. You are out of space on the volume where your database is stored 2. You are spooling to the same volume as your database, causing #1, but it will appear to have plenty of space once the backup stops as the spool file will be deleted (ask me how I know about this :) 3. You have reached some internal limit in your database. I doubt that will happen with mysql or postgresql but could be possible with sqlite. How many rows in File? (select count(*) from file) James ------------------------------------------------------------------------------ OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
