Bacula-users

[Bacula-users] "column "volabytes" does not exist"

2015-10-15 10:35:02
Subject: [Bacula-users] "column "volabytes" does not exist"
From: Doug Sampson <dougs AT dawnsign DOT com>
To: "'bacula-users AT lists.sourceforge DOT net'" <bacula-users AT lists.sourceforge DOT net>
Date: Thu, 15 Oct 2015 14:13:56 +0000
Hello-

Yesterday I upgraded Bacula from 7.0.5 to 7.2 running on a FreeBSD 10.1 system. 
It appears that the upgrade didn't go well. All of my jobs failed overnight. 
This is a sample of a failed job:

*mes
15-Oct 06:58 pisces-dir JobId 16576: Start Backup JobId 16576, 
Job=mailfilter.2015-10-15_06.58.06_17
15-Oct 06:58 pisces-dir JobId 16576: Fatal error: bdb.h:103 bdb.h:103 query 
SELECT 
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolABytes,VolHoleBytes,VolHoles,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolParts,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge
 FROM Media WHERE MediaId=8001 failed:
ERROR:  column "volabytes" does not exist
LINE 1: ...Id,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolABytes,...
                                                             ^

15-Oct 06:58 pisces-dir JobId 16576: bdb.h:103 SELECT 
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolABytes,VolHoleBytes,VolHoles,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolParts,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge
 FROM Media WHERE MediaId=8001
15-Oct 06:58 pisces-dir JobId 16576: Error: Media record for MediaId=8001 not 
found in Catalog.
15-Oct 06:58 pisces-dir JobId 16576: Fatal error: bdb.h:103 bdb.h:103 query 
SELECT 
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolABytes,VolHoleBytes,VolHoles,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolParts,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge
 FROM Media WHERE MediaId=8083 failed:
ERROR:  column "volabytes" does not exist
LINE 1: ...Id,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolABytes,...
                                                             ^

15-Oct 06:58 pisces-dir JobId 16576: bdb.h:103 SELECT 
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolABytes,VolHoleBytes,VolHoles,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolParts,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge
 FROM Media WHERE MediaId=8083
15-Oct 06:58 pisces-dir JobId 16576: Error: Media record for MediaId=8083 not 
found in Catalog.
15-Oct 06:58 pisces-dir JobId 16576: Created new 
Volume="Backup_mailfilter-fd_2015-10-15_06.58.08", Pool="mailfilter", 
MediaType="File" in catalog.
15-Oct 06:58 pisces-dir JobId 16576: Using Device "FileStoragemailfilter" to 
write.
15-Oct 06:58 pisces-dir JobId 16576: Fatal error: No Job status returned from 
FD.
15-Oct 06:58 pisces-dir JobId 16576: Fatal error: bdb.h:103 bdb.h:103 query 
SELECT 
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolABytes,VolHoleBytes,VolHoles,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolParts,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge
 FROM Media WHERE VolumeName='Backup_mailfilter-fd_2015-10-15_06.58.08' failed:
ERROR:  column "volabytes" does not exist
LINE 1: ...Id,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolABytes,...
                                                             ^

15-Oct 06:58 pisces-dir JobId 16576: bdb.h:103 SELECT 
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolABytes,VolHoleBytes,VolHoles,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolParts,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge
 FROM Media WHERE VolumeName='Backup_mailfilter-fd_2015-10-15_06.58.08'
15-Oct 06:58 pisces-dir JobId 16576: Warning: Error getting Media record for 
Volume "Backup_mailfilter-fd_2015-10-15_06.58.08": ERR=Media record for Volume 
Name "Backup_mailfilter-fd_2015-10-15_06.58.08" not found in Catalog.
15-Oct 06:58 pisces-dir JobId 16576: Error: Bacula pisces-dir 7.2.0 (14Aug15):
  Build OS:               i386-portbld-freebsd9.3 freebsd 9.3-RELEASE-p21
  JobId:                  16576
  Job:                    mailfilter.2015-10-15_06.58.06_17
  Backup Level:           Incremental, since=2015-10-03 00:09:50
  Client:                 "mailfilter-fd" 7.0.5 (28Jul14) 
amd64-portbld-freebsd10.1,freebsd,10.1-RELEASE-p5
  FileSet:                "Mailfilter Set" 2013-06-01 00:05:00
  Pool:                   "mailfilter" (From Job resource)
  Catalog:                "MyCatalog" (From Client resource)
  Storage:                "FileStoragemailfilter" (From Job resource)
  Scheduled time:         15-Oct-2015 06:57:54
  Start time:             15-Oct-2015 06:58:08
  End time:               15-Oct-2015 06:58:08
  Elapsed time:           0 secs
  Priority:               10
  FD Files Written:       0
  SD Files Written:       0
  FD Bytes Written:       0 (0 B)
  SD Bytes Written:       0 (0 B)
  Rate:                   0.0 KB/s
  Software Compression:   None
  Snapshot/VSS:           no
  Encryption:             no
  Accurate:               no
  Volume name(s):         
  Volume Session Id:      1
  Volume Session Time:    1444917165
  Last Volume Bytes:      0 (0 B)
  Non-fatal FD errors:    3
  SD Errors:              0
  FD termination status:  Error
  SD termination status:  
  Termination:            *** Backup Error ***

*

I remember seeing a few errors while executing 
/usr/local/share/bacula/update_bacula_tables but I don't have the output. When 
I tried to rerun it, it stated that the table have been updated to version 15 
so it didn't run.

What are my options at this point?

~Doug

------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users