Hi there,
######################
# Summary of problem #
######################
I get the following output from the bconsole 'restore' command:
"No Full backup before 2007-03-07 12:26:11 found."
This is after choosing option 5: "Select the most recent backup for a
client".
This only started happening after using the 'bscan' utility to rebuild
my catalog.
I was able to run this restore command before I used the bscan utility
but I could only see ~25,000 out of the ~250,000 files in the backup.
####################
# Detailed history #
####################
This backup job has been running for a couple of months, so far it is
comprised of 1 full backup and ~35 incremental backups.
Recently I wanted to test the restore process to make sure everything
worked. I tried to run the 'restore' command using option 5: Select the
most recent backup for a client.
At this point bacula provided me with a Directory Tree Structure however
only 10% of my files were available.
After troubleshooting this issue in the #bacula channel on freenode we
discovered that the client definition in the director configuration file
was setup to automatically prune all files over 60 days old.
Even though I had specifically set 'AutoPrune = No' and 'Volume
Retention = 99y' in my pool definition, the client definition seems to
have over written this.
After fixing this configuration problem I then set out to attempt to
rebuild the database using the 'bscan' utility.
bscan -s -m -c bacula-sd.conf -v -V Archive-1\|Archive-2\|Archive-3\|
Archive-4\|Archive-5\|Archive-6\|Archive-7\|Archive-8 /dev/nst0
One thing I need to mention, this backup spans across 9 tapes, I only
ran bscan on the first 8 because I assumed that the files on the last
tape did not need to be scanned as they were less than 60 days old
(Could this be a problem?).
When bscan finished it told me that it had entered ~255,000 files into
my database, unfortunately I did not save the final output from bscan.
Before running bscan I also backed up my database:
-rw-r----- 1 bacula bacula 1851354112 2007-03-07 12:15 bacula.db
-rw-r----- 1 root root 1851354112 2007-03-05 14:06
bacula.db.backup-05-03-07
(I don't know why the database files are the same size?)
Now when I try to run the restore command it tells me:
No Full backup before 2007-03-07 12:26:11 found
####################################
# An example of my bacula-dir.conf #
####################################
Job {
Name = "Daily_Archive_Job"
Client = pandora-fd
Type = Backup
Level = Incremental
FileSet = "Archive"
Storage = Tape
Messages = Standard
Pool = "Daily_Archive_Pool"
Schedule = "Daily_Cycle"
Priority = 5
Write Bootstrap = "/var/lib/bacula/Daily_Archive_Job.bsr"
}
FileSet {
Name = "Archive"
Include {
Options {
signature = MD5
}
File = /mnt/raid-1/servers/archive
File = /mnt/raid-1/traffic_accounting
}
}
Pool {
Name = Daily_Archive_Pool
Pool Type = Backup
AutoPrune = no
Volume Retention = 99y
Recycle = no
}
#########################
# Output from list jobs #
#########################
*list jobs
Using default Catalog name=MyCatalog DB=bacula
+-------+-----------------------+---------------------+------+-------+----------+--------------+-----------+
| JobId | Name | StartTime | Type | Level |
JobFiles | JobBytes | JobStatus |
+-------+-----------------------+---------------------+------+-------+----------+--------------+-----------+
| 157 | BackupCatalog | 0 | B | F | 0
| 0 | C |
| 282 | Daily_Live_Job | 0 | B | F | 0
| 0 | C |
| 283 | BackupCatalog | 0 | B | F | 0
| 0 | C |
| 1 | Client1 | 2006-12-06 23:05:02 | B | F | 0
| 0 | f |
| 2 | BackupCatalog | 2006-12-06 23:10:02 | B | F | 0
| 0 | f |
| 5 | BackupCatalog | 2006-12-07 10:40:22 | B | F | 0
| 0 | f |
| 6 | Client1 | 2006-12-07 10:43:14 | B | F | 0
| 0 | f |
| 7 | BackupCatalog | 2006-12-07 10:46:38 | B | F | 0
| 0 | f |
| 8 | BackupCatalog | 2006-12-07 10:48:50 | B | F | 0
| 0 | f |
| 14 | RestoreFiles | 2006-12-08 11:03:19 | R | F | 1
| 14047 | T |
| 39 | Daily_Live_Job | 2006-12-14 11:28:53 | B | F | 0
| 0 | A |
| 40 | Daily_Live_Job | 2006-12-14 11:28:55 | B | F | 0
| 0 | A |
| 41 | Daily_Live_Job | 2006-12-14 11:28:58 | B | F | 0
| 0 | A |
| 42 | Daily_Live_Job | 2006-12-14 11:29:00 | B | F | 0
| 0 | A |
| 43 | Daily_Live_Job | 2006-12-14 11:29:02 | B | F | 0
| 0 | A |
| 44 | Daily_Live_Job | 2006-12-14 11:29:04 | B | F | 0
| 0 | A |
| 45 | Daily_Live_Job | 2006-12-14 11:29:06 | B | F | 0
| 0 | A |
| 46 | Daily_Live_Job | 2006-12-14 11:29:08 | B | F | 0
| 0 | A |
| 47 | Daily_Live_Job | 2006-12-14 11:29:10 | B | F | 0
| 0 | A |
| 48 | Daily_Live_Job | 2006-12-14 11:29:12 | B | F | 0
| 0 | A |
| 49 | Daily_Live_Job | 2006-12-14 11:29:14 | B | F | 0
| 0 | A |
| 50 | Daily_Live_Job | 2006-12-14 11:29:16 | B | F | 0
| 0 | A |
| 51 | Daily_Live_Job | 2006-12-14 11:29:18 | B | F | 0
| 0 | A |
| 52 | Daily_Live_Job | 2006-12-14 11:29:20 | B | F | 0
| 0 | A |
| 53 | Daily_Live_Job | 2006-12-14 11:29:22 | B | F | 0
| 0 | A |
| 54 | Daily_Live_Job | 2006-12-14 11:29:25 | B | F | 0
| 0 | A |
| 55 | Daily_Live_Job | 2006-12-14 11:29:27 | B | F | 0
| 0 | A |
| 56 | Daily_Live_Job | 2006-12-14 11:29:29 | B | F | 0
| 0 | A |
| 57 | Daily_Live_Job | 2006-12-14 11:29:31 | B | F | 0
| 0 | A |
| 58 | Daily_Live_Job | 2006-12-14 11:29:33 | B | F | 0
| 0 | A |
| 59 | Daily_Live_Job | 2006-12-14 11:29:35 | B | F | 0
| 0 | A |
| 60 | Daily_Live_Job | 2006-12-14 11:29:37 | B | F | 0
| 0 | A |
| 61 | Daily_Live_Job | 2006-12-14 11:29:39 | B | F | 0
| 0 | A |
| 62 | Daily_Live_Job | 2006-12-14 11:29:41 | B | F | 0
| 0 | A |
| 64 | Daily_Live_Job | 2006-12-14 11:29:43 | B | F | 0
| 0 | A |
| 65 | Daily_Live_Job | 2006-12-14 11:29:45 | B | F | 0
| 0 | A |
| 66 | Daily_Live_Job | 2006-12-14 11:29:47 | B | F | 0
| 0 | A |
| 67 | Daily_Live_Job | 2006-12-14 11:29:49 | B | F | 0
| 0 | A |
| 68 | Daily_Live_Job | 2006-12-14 11:29:52 | B | F | 0
| 0 | A |
| 69 | Daily_Live_Job | 2006-12-14 11:29:54 | B | F | 0
| 0 | A |
| 70 | Daily_Live_Job | 2006-12-14 11:29:56 | B | F | 0
| 0 | A |
| 71 | Daily_Live_Job | 2006-12-14 11:29:58 | B | F | 0
| 0 | A |
| 72 | Daily_Live_Job | 2006-12-14 11:30:00 | B | F | 0
| 0 | A |
| 73 | Daily_Live_Job | 2006-12-14 11:30:02 | B | F | 0
| 0 | A |
| 74 | Daily_Live_Job | 2006-12-14 11:30:04 | B | F | 0
| 0 | A |
| 75 | Daily_Live_Job | 2006-12-14 11:30:06 | B | F | 0
| 0 | A |
| 76 | Daily_Live_Job | 2006-12-14 11:30:08 | B | F | 0
| 0 | A |
| 77 | Daily_Live_Job | 2006-12-14 11:30:10 | B | F | 0
| 0 | A |
| 78 | Daily_Live_Job | 2006-12-14 11:30:12 | B | F | 0
| 0 | A |
| 79 | Daily_Live_Job | 2006-12-14 11:30:14 | B | F | 0
| 0 | A |
| 80 | Daily_Live_Job | 2006-12-14 11:30:16 | B | F | 0
| 0 | A |
| 81 | Daily_Live_Job | 2006-12-14 11:30:19 | B | F | 0
| 0 | A |
| 82 | Daily_Live_Job | 2006-12-14 11:30:21 | B | F | 0
| 0 | A |
| 83 | Daily_Live_Job | 2006-12-14 11:30:23 | B | F | 0
| 0 | A |
| 84 | Daily_Live_Job | 2006-12-14 11:30:25 | B | F | 0
| 0 | A |
| 85 | Daily_Live_Job | 2006-12-14 11:30:27 | B | F | 0
| 0 | A |
| 86 | Daily_Live_Job | 2006-12-14 11:30:29 | B | F | 0
| 0 | A |
| 87 | Daily_Live_Job | 2006-12-14 11:30:31 | B | F | 0
| 0 | A |
| 89 | Daily_Live_Job | 2006-12-14 11:30:33 | B | F | 0
| 0 | A |
| 90 | Daily_Live_Job | 2006-12-14 11:30:35 | B | F | 0
| 0 | A |
| 91 | Daily_Live_Job | 2006-12-14 11:30:37 | B | F | 0
| 0 | A |
| 92 | Daily_Live_Job | 2006-12-14 11:30:39 | B | F | 0
| 0 | A |
| 93 | Daily_Live_Job | 2006-12-14 11:30:41 | B | F | 0
| 0 | A |
| 94 | Daily_Live_Job | 2006-12-14 11:30:43 | B | F | 0
| 0 | A |
| 63 | BackupCatalog | 2006-12-14 11:37:48 | B | F | 0
| 0 | A |
| 88 | BackupCatalog | 2006-12-14 11:37:50 | B | F | 0
| 0 | A |
| 149 | Daily_Live_Job | 2007-01-10 15:09:44 | B | F | 0
| 0 | A |
| 150 | Monthly_Live_Job | 2007-01-10 15:40:20 | B | F | 0
| 0 | A |
| 151 | Monthly_Live_Job | 2007-01-10 16:12:41 | B | F | 0
| 0 | f |
| 152 | Monthly_Live_Job | 2007-01-10 16:21:29 | B | F |
11604 | 180513327 | A |
| 153 | Monthly_Live_Job | 2007-01-10 16:29:24 | B | F |
276105 | 7770753916 | T |
| 179 | Daily_Archive_Job | 2007-01-23 17:11:27 | B | F | 0
| 0 | A |
| 197 | Daily_Archive_Job | 2007-01-31 14:28:30 | B | F |
255450 | 730923188523 | T |
| 198 | Daily_Archive_Job | 2007-02-01 20:18:44 | B | I |
994 | 3962503581 | T |
| 199 | Daily_Live_Job | 2007-02-01 20:27:17 | B | F | 0
| 0 | A |
| 200 | Monthly_Live_Job | 2007-02-01 20:27:19 | B | F | 0
| 0 | A |
| 201 | BackupCatalog | 2007-02-01 20:27:21 | B | F | 0
| 0 | A |
| 202 | BackupCatalog | 2007-02-01 20:27:23 | B | F | 0
| 0 | A |
| 203 | Daily_Archive_Job | 2007-02-02 01:30:04 | B | I |
686 | 776728387 | T |
| 206 | Daily_Archive_Job | 2007-02-03 01:30:03 | B | I |
168 | 1478613484 | E |
| 209 | Daily_Archive_Job | 2007-02-05 09:36:39 | B | I |
2794 | 8718990882 | T |
| 212 | Daily_Archive_Job | 2007-02-05 09:54:57 | B | I | 0
| 0 | T |
| 215 | Daily_Archive_Job | 2007-02-06 01:30:03 | B | I |
96 | 630085699 | T |
| 218 | Daily_Archive_Job | 2007-02-07 01:30:04 | B | I |
978 | 3173777420 | T |
| 221 | Daily_Archive_Job | 2007-02-08 01:30:03 | B | I |
979 | 4127762498 | T |
| 224 | Daily_Archive_Job | 2007-02-09 01:30:04 | B | I |
989 | 3120320233 | T |
| 227 | Daily_Archive_Job | 2007-02-10 01:30:04 | B | I |
980 | 3124987525 | T |
| 230 | Daily_Archive_Job | 2007-02-11 01:30:03 | B | I |
980 | 3231148044 | T |
| 233 | Daily_Archive_Job | 2007-02-12 01:30:03 | B | I |
974 | 3161288917 | T |
| 236 | Daily_Archive_Job | 2007-02-13 01:30:04 | B | I |
983 | 3121671301 | T |
| 239 | Daily_Archive_Job | 2007-02-14 01:30:03 | B | I |
972 | 3058925870 | T |
| 242 | Daily_Archive_Job | 2007-02-15 01:30:04 | B | I |
1001 | 3130006475 | T |
| 245 | Daily_Archive_Job | 2007-02-16 01:30:04 | B | I |
973 | 3180835109 | T |
| 248 | Daily_Archive_Job | 2007-02-17 01:30:03 | B | I |
975 | 3223494662 | T |
| 251 | Daily_Archive_Job | 2007-02-18 01:30:04 | B | I |
973 | 3113706952 | T |
| 254 | Daily_Archive_Job | 2007-02-19 01:30:04 | B | I |
996 | 3082105825 | T |
| 257 | Daily_Archive_Job | 2007-02-20 01:30:03 | B | I |
977 | 3010903571 | T |
| 260 | Daily_Archive_Job | 2007-02-21 01:30:03 | B | I |
989 | 3270699587 | T |
| 263 | Daily_Archive_Job | 2007-02-22 01:30:04 | B | I |
995 | 3288556655 | T |
| 266 | Daily_Archive_Job | 2007-02-23 01:30:03 | B | I |
995 | 3154138343 | T |
| 269 | Daily_Archive_Job | 2007-02-24 01:30:04 | B | I |
1000 | 3174689601 | T |
| 270 | Daily_Live_Job | 2007-02-24 02:18:24 | B | F |
304562 | 13072085432 | T |
| 271 | BackupCatalog | 2007-02-24 04:15:49 | B | F | 1
| 1843714169 | T |
| 272 | Daily_Archive_Job | 2007-02-25 01:30:04 | B | I |
975 | 3125912232 | T |
| 273 | Daily_Live_Job | 2007-02-25 02:14:48 | B | F |
304798 | 13091423740 | T |
| 274 | BackupCatalog | 2007-02-25 04:17:27 | B | F | 1
| 1843714169 | T |
| 275 | Daily_Archive_Job | 2007-02-26 01:30:03 | B | I |
969 | 3138290178 | T |
| 276 | Daily_Live_Job | 2007-02-26 02:16:43 | B | F |
305034 | 13099587929 | T |
| 277 | BackupCatalog | 2007-02-26 04:26:52 | B | F | 1
| 1843714169 | T |
| 278 | Daily_Archive_Job | 2007-02-27 01:30:04 | B | I |
1004 | 3237467977 | T |
| 279 | Daily_Live_Job | 2007-02-27 02:18:25 | B | F |
305624 | 13111091416 | T |
| 280 | BackupCatalog | 2007-02-27 04:16:01 | B | F | 1
| 1843714169 | T |
| 281 | Daily_Archive_Job | 2007-02-28 01:30:04 | B | I |
1232 | 3314168495 | T |
| 284 | Daily_Archive_Job | 2007-02-28 09:47:58 | B | I |
877 | 2853526783 | T |
| 285 | Daily_Archive_Job | 2007-03-01 03:00:04 | B | I |
103 | 631587016 | T |
| 286 | Daily_Live_Job | 2007-03-01 03:05:16 | B | F |
307368 | 16665285712 | T |
| 287 | Monthly_Live_Job | 2007-03-01 04:29:42 | B | F |
307368 | 16665285712 | T |
| 288 | BackupCatalog | 2007-03-01 06:03:45 | B | F | 1
| 1843714169 | T |
| 289 | Daily_Archive_Job | 2007-03-02 08:40:49 | B | I |
1858 | 6609945559 | T |
| 290 | Daily_Live_Job | 2007-03-02 09:00:34 | B | F |
309226 | 18695739450 | T |
| 291 | BackupCatalog | 2007-03-02 11:01:22 | B | F | 1
| 1843714169 | T |
| 292 | Daily_Archive_Job | 2007-03-03 03:00:04 | B | I |
123 | 632224756 | T |
| 293 | Daily_Live_Job | 2007-03-03 03:16:44 | B | F |
308307 | 22326270112 | T |
| 294 | BackupCatalog | 2007-03-03 05:38:16 | B | F | 1
| 1843714169 | T |
| 295 | Daily_Archive_Job | 2007-03-04 03:00:04 | B | I |
441 | 1619898707 | T |
| 296 | Daily_Live_Job | 2007-03-04 03:44:04 | B | F |
308466 | 23525336253 | T |
| 297 | BackupCatalog | 2007-03-04 05:59:42 | B | F | 1
| 1843714169 | T |
| 298 | Daily_Archive_Job | 2007-03-05 03:00:04 | B | I |
109 | 633713911 | T |
| 299 | Daily_Live_Job | 2007-03-05 03:19:01 | B | F |
308602 | 24693712531 | T |
| 300 | BackupCatalog | 2007-03-05 08:47:43 | B | F | 1
| 1843714169 | T |
| 301 | Restore_Daily_Archive | 2007-03-05 11:34:37 | R | F | 1
| 0 | T |
| 302 | Restore_Daily_Archive | 2007-03-05 11:43:59 | R | F | 1
| 5028272 | T |
| 303 | Restore_Daily_Archive | 2007-03-05 12:04:41 | R | F | 1
| 0 | T |
| 304 | Restore_Daily_Archive | 2007-03-05 13:31:34 | R | F |
3640 | 13600780278 | A |
| 305 | Daily_Archive_Job | 2007-03-07 03:00:02 | B | F | 0
| 0 | f |
| 306 | Daily_Live_Job | 2007-03-07 03:30:06 | B | F | 0
| 0 | f |
| 307 | BackupCatalog | 2007-03-07 05:08:02 | B | F | 0
| 0 | f |
| 308 | Restore_Daily_Archive | 2007-03-07 12:15:59 | R | F | 0
| 0 | f |
+-------+-----------------------+---------------------+------+-------+----------+--------------+-----------+
###########
# Summary #
###########
At this point I'm very stuck =)
Any ideas would be greatly appreciated!
Thank you,
Paul England
Auckland, New Zealand
