DAve wrote: > Good morning. I have begun getting an error I cannot seem to track down. > It seems that the job runs fine, the volumes fill, but when the job > finishes Bacula is unable to write the completion because the job no > longer exists. It looks to me like Bacula is purging the jobs too soon. > > The error I get in the backup report is as follows, > > 05-Jan 05:57 storage2-sd: Job write elapsed time = 04:56:31, Transfer > rate = 3.761 M bytes/second > 05-Jan 05:57 director-dir: Allied-ex3.2009-01-05_01.00.01 Warning: Error > updating job record. sql_update.c:194 Update problem: affected_rows=0 > 05-Jan 05:57 director-dir: Allied-ex3.2009-01-05_01.00.01 Warning: Error > getting job record for stats: sql_get.c:293 No Job found for JobId 15303 > > This client gets a full backup once a night for DR. Retention is set for > 12 hours. Oddly I have two jobs running for this client and one job > completes fine, the other fails. > > Looking through the archives I found a few bits of information > concerning MySQL and a few bits concerning retention times and auto > pruning. I suspect I have an issues with how I setup auto pruning but > the solution eludes me. That might have something to do with 2000mg of > antibiotics a day and screaming sinuses 8^0 > > As to MySQL, I checked the table status and all looks well. > mysql> SHOW TABLE STATUS FROM bacula like 'File' \G > *************************** 1. row *************************** > Name: File > Engine: MyISAM > Version: 10 > Row_format: Dynamic > Rows: 2749308 > Avg_row_length: 84 > Data_length: 316518320 > Max_data_length: 281474976710655 > Index_length: 160896000 > Data_free: 82983144 > Auto_increment: 108368578 > Create_time: 2008-03-04 16:01:52 > Update_time: 2009-01-05 11:41:24 > Check_time: 2009-01-01 13:35:43 > Collation: latin1_swedish_ci > Checksum: NULL > Create_options: > Comment: > 1 row in set (0.00 sec) > > Checking my director config looks good also, both client's have their > backups configured identically, but only the smaller backup fails. > ### SCHEDULES > Schedule { > Name = "Allied-vm1" > Run = Level=Full FullPool=vm1-allied-Pool mon-sun at 01:00 > } > > Schedule { > Name = "Allied-ex3" > Run = Level=Full FullPool=ex3-allied-Pool mon-sun at 01:00 > } > > > ### CLIENTS > Client { > Name = allied-vm1-fd > Address = REDACTED > FDPort = 49201 > Catalog = DataVault > Password = "REDACTED" # password for FileDaemon > File Retention = 1 week # 30 days > Job Retention = 1 week # six months > AutoPrune = yes # Prune expired Jobs/Files > } > > Client { > Name = allied-ex3-fd > Address = REDACTED > FDPort = 49202 > Catalog = DataVault > Password = "REDACTED" # password for FileDaemon > File Retention = 1 week # 30 days > Job Retention = 1 week # six months > AutoPrune = yes # Prune expired Jobs/Files > } > > ### POOLS > Pool { > Name = vm1-allied-Pool > Pool Type = Backup > LabelFormat = "vm1-allied-" > Recycle = yes > Recycle Oldest Volume = yes > Purge Oldest Volume = yes > AutoPrune = yes > Volume Retention = 12 hours > Maximum Volumes = 240 > Maximum Volume Jobs = 0 > Maximum Volume Bytes = 1G > } > > Pool { > Name = ex3-allied-Pool > Pool Type = Backup > LabelFormat = "ex3-allied-" > Recycle = yes > Recycle Oldest Volume = yes > Purge Oldest Volume = yes > AutoPrune = yes > Volume Retention = 12 hours > Maximum Volumes = 60 > Maximum Volume Jobs = 0 > Maximum Volume Bytes = 1G > } > > Any ideas what I may have done wrong? The backup for ex3 ran fine until > a few days ago. Any assistance is appreciated. > > DAve
Well, as an update I reset my File/Job Retention from 1 week to 1 day, updated my pool, and everything has run a full month without error. I am happy to report all seems well now. DAve -- The whole internet thing is sucking the life out of me, there ain't no pony in there. ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users