I've been getting this error on some of my backups (not all).   The full 
error is:

26-Dec 01:00 Arwen-dir JobId 11: Fatal error: Can't fill Path table 
Query failed: INSERT INTO Path (Path) SELECT a.Path FROM (SELECT 
DISTINCT Path FROM batch) AS a WHERE NOT EXISTS (SELECT Path FROM Path 
AS p WHERE p.Path = a.Path): ERR=Table 'batch' is marked as crashed and 
should be repaired

26-Dec 01:00 Arwen-dir JobId 11: Error: Bacula Arwen-dir 2.4.2 
(26Jul08): 26-Dec-2009 01:00:34
  Build OS:               x86_64-pc-linux-gnu debian lenny/sid
  JobId:                  11
  Job:                    Arwen_XP64_Backup_Set_2.2009-12-25_20.33.10
  Backup Level:           Full
  Client:                 "Arwen_XP64" 2.4.2 (26Jul08) 
x86_64-pc-linux-gnu,debian,lenny/sid
  FileSet:                "Arwen_XP64" 2009-12-25 20:33:35
  Pool:                   "Backup_Set_2" (From Job resource)
  Storage:                "Backup_Set_2" (From Pool resource)
  Scheduled time:         25-Dec-2009 20:33:26
  Start time:             26-Dec-2009 00:14:57
  End time:               26-Dec-2009 01:00:34
  Elapsed time:           45 mins 37 secs
  Priority:               16
  FD Files Written:       139,974
  SD Files Written:       139,974
  FD Bytes Written:       18,201,877,756 (18.20 GB)
  SD Bytes Written:       18,228,549,111 (18.22 GB)
  Rate:                   6650.3 KB/s
  Software Compression:   39.6 %
  VSS:                    no
  Storage Encryption:     no
  Volume name(s):         Backup_Set_2_0003
  Volume Session Id:      6
  Volume Session Time:    1261630416
  Last Volume Bytes:      185,551,543,549 (185.5 GB)
  Non-fatal FD errors:    0
  SD Errors:              0
  FD termination status:  OK
  SD termination status:  OK
  Termination:            *** Backup Error ***

I'm running a rotating set of 3 pools on a monthly cycle.   This happens 
ONLY with the 2nd pool and only with 2 of the jobs.   I thought at first 
this might be a MySQL timeout, but this job was only 45 minutes in 
length while another job that takes 28 hours doesn't hit this problem.   
And this job with one of the other pools doesn't hit this error.

I've tried running bscan to correct the catalog, I've tried dumping the 
entire catalog and redoing the backups.   Still get the error.   Result 
is that I can't do any incremental backups of this job since the job is 
never marked as having a full backup.

This problem was introduced, I think, by running out of space in root.   
This problem has since been resolved - root is now running at 46% 
utilization.

Any thoughts on a repair strategy?

Thanx,

Paul Howard







------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev 
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users