Hi,
The bacula backup doesn't run and it shows the below error: I'm using
bacula 9.4.3 server and the client is older version 5.0.0.
==============================================================================================
10-Jun 01:49 bacula-dir JobId 208: Start Backup JobId 208,
Job=BackupCorp.client.in.2019-06-10_01.49.34_04
10-Jun 01:49 bacula-dir JobId 208: Fatal error: bdb.h:142 bdb.h:142
query SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolType,VolParts,VolCloudParts,LastPartBytes,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,CacheRetention
FROM Media WHERE PoolId=4 AND MediaType='File' AND Enabled=1 AND
VolStatus='Append' AND VolType IN (0,1) ORDER BY LastWritten IS
NULL,LastWritten DESC,MediaId LIMIT 1 failed:
Unknown column 'VolType' in 'field list'
10-Jun 01:49 bacula-dir JobId 208: Fatal error: bdb.h:142 bdb.h:142
query SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolType,VolParts,VolCloudParts,LastPartBytes,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,CacheRetention
FROM Media WHERE PoolId=4 AND MediaType='File' AND Enabled=1 AND
VolStatus='Recycle' AND VolType IN (0,1) AND Recycle=1 ORDER BY
LastWritten ASC,MediaId LIMIT 1 failed:
Unknown column 'VolType' in 'field list'
10-Jun 01:49 bacula-dir JobId 208: Fatal error: bdb.h:142 bdb.h:142
query SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolType,VolParts,VolCloudParts,LastPartBytes,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,CacheRetention
FROM Media WHERE PoolId=4 AND MediaType='File' AND Enabled=1 AND
VolStatus='Purged' AND VolType IN (0,1) AND Recycle=1 ORDER BY
LastWritten ASC,MediaId LIMIT 1 failed:
Unknown column 'VolType' in 'field list'
10-Jun 01:49 bacula-dir JobId 208: Fatal error: bdb.h:142 bdb.h:142
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,VolType,VolParts,VolCloudParts,LastPartBytes,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,CacheRetention
FROM Media WHERE MediaId=3 failed:
Unknown column 'VolABytes' in 'field list'
10-Jun 01:49 bacula-dir JobId 208: Error: Media record for MediaId=3
not found in Catalog.
10-Jun 01:49 bacula-dir JobId 208: Fatal error: bdb.h:142 bdb.h:142
query SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolType,VolParts,VolCloudParts,LastPartBytes,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,CacheRetention
FROM Media WHERE PoolId=4 AND MediaType='File' AND Enabled=1 AND
VolStatus='Purged' AND VolType IN (0,1) AND Recycle=1 ORDER BY
LastWritten ASC,MediaId LIMIT 1 failed:
Unknown column 'VolType' in 'field list'
10-Jun 01:49 bacula-dir JobId 208: Fatal error: bdb.h:142 bdb.h:142
query SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolType,VolParts,VolCloudParts,LastPartBytes,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,CacheRetention
FROM Media WHERE PoolId=3 AND MediaType='File' AND Enabled=1 AND
VolStatus='Append' ORDER BY LastWritten IS NULL,LastWritten
DESC,MediaId LIMIT 1 failed:
Unknown column 'VolType' in 'field list'
10-Jun 01:49 bacula-dir JobId 208: Fatal error: bdb.h:142 bdb.h:142
query SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolType,VolParts,VolCloudParts,LastPartBytes,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,CacheRetention
FROM Media WHERE PoolId=3 AND MediaType='File' AND Enabled=1 AND
VolStatus='Recycle' AND Recycle=1 ORDER BY LastWritten ASC,MediaId
LIMIT 1 failed:
Unknown column 'VolType' in 'field list'
10-Jun 01:49 bacula-dir JobId 208: Fatal error: bdb.h:142 bdb.h:142
query SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolType,VolParts,VolCloudParts,LastPartBytes,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,CacheRetention
FROM Media WHERE PoolId=3 AND MediaType='File' AND Enabled=1 AND
VolStatus='Purged' AND Recycle=1 ORDER BY LastWritten ASC,MediaId
LIMIT 1 failed:
Unknown column 'VolType' in 'field list'
10-Jun 01:49 bacula-dir JobId 208: Fatal error: bdb.h:142 bdb.h:142
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,VolType,VolParts,VolCloudParts,LastPartBytes,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,CacheRetention
FROM Media WHERE VolumeName='Remote-0004' failed:
Unknown column 'VolABytes' in 'field list'
10-Jun 01:49 bacula-dir JobId 208: Error: sql_create.c:439 Create DB
Media record INSERT INTO Media
(VolumeName,MediaType,MediaTypeId,PoolId,MaxVolBytes,VolCapacityBytes,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,VolStatus,Slot,VolBytes,InChanger,VolReadTime,VolWriteTime,VolType,VolParts,VolCloudParts,LastPartBytes,EndFile,EndBlock,LabelType,StorageId,DeviceId,LocationId,ScratchPoolId,RecyclePoolId,Enabled,ActionOnPurge,CacheRetention)VALUES
('Remote-0004','File',0,4,53687091200,0,1,31536000,0,0,0,'Append',0,0,0,0,0,0,0,0,'0',0,0,0,1,0,0,0,0,1,0,0)
failed. ERR=Unknown column 'VolType' in 'field list'
10-Jun 01:49 bacula-dir JobId 208: Using Device "FileStorage" to write.
10-Jun 01:49 bacula-dir JobId 208: Fatal error: No Job status returned from FD.
10-Jun 01:49 bacula-dir JobId 208: Error: Bacula bacula-dir 9.4.3 (03May19):
Build OS: x86_64-redhat-linux-gnu-bacula redhat
Enterprise release
JobId: 208
Job: BackupCorp.client.in.2019-06-10_01.49.34_04
Backup Level: Incremental, since=2019-05-30 23:06:23
Client: "corp.client.in-fd" 5.0.0 (26Jan10)
x86_64-redhat-linux-gnu,redhat,
FileSet: "Home" 2019-04-22 23:05:00
Pool: "RemoteFile" (From Job resource)
Catalog: "MyCatalog" (From Client resource)
Storage: "File" (From Job resource)
Scheduled time: 10-Jun-2019 01:49:33
Start time: 10-Jun-2019 01:49:36
End time: 10-Jun-2019 01:49:57
Elapsed time: 21 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
Comm Line Compression: None
Snapshot/VSS: no
Encryption: no
Accurate: no
Volume name(s):
Volume Session Id: 10
Volume Session Time: 1559904785
Last Volume Bytes: 0 (0 B)
Non-fatal FD errors: 3
SD Errors: 0
FD termination status: Error
SD termination status:
Termination: *** Backup Error ***
==============================================================================================
While checking the baculs-sd status it shows the below error:
==============================================================================================
# service bacula-sd status
Redirecting to /bin/systemctl status bacula-sd.service
● bacula-sd.service - Bacula Storage Daemon service
Loaded: loaded (/usr/lib/systemd/system/bacula-sd.service; enabled;
vendor preset: disabled)
Active: failed (Result: exit-code) since Mon 2019-06-10 01:49:08 EDT; 4s
ago
Process: 10655 ExecStart=/opt/bacula/bin/bacula-sd -fP -c
/opt/bacula/etc/bacula-sd.conf (code=exited, status=1/FAILURE)
Main PID: 10655 (code=exited, status=1/FAILURE)
Jun 10 01:49:08 bacula.server.in systemd[1]: Started Bacula Storage Daemon
service.
Jun 10 01:49:08 bacula.server.in bacula-sd[10655]: bacula-sd: ERROR
TERMINATION at parse_conf.c:1021
Jun 10 01:49:08 bacula.server.in systemd[1]: bacula-sd.service: main
process exited, code=exited, status=1/FAILURE
Jun 10 01:49:08 bacula.server.in systemd[1]: Unit bacula-sd.service entered
failed state.
Jun 10 01:49:08 bacula.server.in systemd[1]: bacula-sd.service failed.
==============================================================================================
Although bacula-dir service started it shows the below errors:
==============================================================================================
service bacula-dir status
Redirecting to /bin/systemctl status bacula-dir.service
● bacula-dir.service - Bacula Director Daemon service
Loaded: loaded (/usr/lib/systemd/system/bacula-dir.service; enabled;
vendor preset: disabled)
Active: active (running) since Wed 2019-06-05 03:51:29 EDT; 4 days ago
Main PID: 8561 (bacula-dir)
Tasks: 3
CGroup: /system.slice/bacula-dir.service
└─8561 /opt/bacula/bin/bacula-dir -fP -c
/opt/bacula/etc/bacula-dir.conf
Jun 09 23:06:06 bacula.server.in bacula-dir[8561]: 09-Jun 23:06 Message
delivery ERROR: Mail program terminated in error.
Jun 09 23:06:06 bacula.server.in bacula-dir[8561]: CMD=/usr/sbin/bsmtp -h
localhost -f "(Bacula) <root@localhost>" -s "Bacula: Backup Fatal Error of
cor...localhost
Jun 09 23:06:06 bacula.server.in bacula-dir[8561]: ERR=Child exited with
code 1
Jun 09 23:06:06 bacula.server.in bacula-dir[8561]: 09-Jun 23:06 Message
delivery ERROR: Mail program terminated in error.
CMD=/usr/sbin/bsmtp
-h localhost -f "(Bacula) <root@localhost>" -s "Bacula: Backup Fatal Error
of cor...localhost
ERR=Child exited
with code 1...
Jun 09 23:10:03 bacula.server.in bacula-dir[8561]: 09-Jun 23:10 Message
delivery ERROR: Mail prog: bsmtp: bsmtp.c:488-0 Failed to connect to
mailhost localhost
Jun 09 23:10:03 bacula.server.in bacula-dir[8561]: 09-Jun 23:10 Message
delivery ERROR: Mail prog: bsmtp: bsmtp.c:488-0 Failed to connect to
mailhost localhost
Jun 09 23:10:03 bacula.server.in bacula-dir[8561]: 09-Jun 23:10 Message
delivery ERROR: Mail program terminated in error.
Jun 09 23:10:03 bacula.server.in bacula-dir[8561]: CMD=/usr/sbin/bsmtp -h
localhost -f "(Bacula) <root@localhost>" -s "Bacula: Backup Error of
bacula-fd...localhost
Jun 09 23:10:03 bacula.server.in bacula-dir[8561]: ERR=Child exited with
code 1
Jun 09 23:10:03 bacula.server.in bacula-dir[8561]: 09-Jun 23:10 Message
delivery ERROR: Mail program terminated in error.
CMD=/usr/sbin/bsmtp
-h localhost -f "(Bacula) <root@localhost>" -s "Bacula: Backup Error of
bacula-fd...localhost
ERR=Child exited
with code 1...
Hint: Some lines were ellipsized, use -l to show in full.
==============================================================================================
On Sun, Jun 9, 2019 at 3:50 PM Tilman Schmidt <til...@imap.cc> wrote:
> Given that the debug log you shared shows a normal successful start and
> no error, please share your evidence that it stopped and doesn't get
> started again.
> Did you get any error message?
> If so, please share its exact wording and where it appeared.
> Did you check with the ps command whether there is a bacula-sd process
> running?
>
> Be aware that CentOS 7 uses systemd which adds a layer of complexity to
> service management and is notorious for misreporting service status.
> To make sure you're not actually having a systemd problem, try starting
> bacula-sd directly from the command line and check whether it works then.
>
> HTH
> Tilman
>
> Am 09.06.2019 um 10:21 schrieb preash raj:
> > Hi,
> >
> > It is centos 7 and bacula- sd started and enabled before but it got
> > stopped once I test run a remote backup, then it doesn't get started
> > again. Please shed some light on this.
> >
> >
> > On Fri, Jun 7, 2019, 7:01 PM Martin Simmons <mar...@lispworks.com
> > <mailto:mar...@lispworks.com> wrote:
> >
> > That looks like a normal start to me.
> >
> > Which OS is this? How is the service started? Is the service
> > enabled? Check
> > the syslog (or service-specific logs) for error messages.
> >
> > Does it run bacula-sd as a non-root user? If so, you need to test
> > it like
> > that.
> >
> > __Martin
> >
> >
> > >>>>> On Fri, 7 Jun 2019 15:33:15 +0530, preash raj said:
> > >
> > > Hi,
> > > I've installed Bacula 9.4.3 and the bacula-sd service is not
> getting
> > > started. the same configuration works fine with Bacula 5.2.13,
> > please check
> > > the below debug error and shed some light on this.
> > >
> > > =======================================
> > > # bacula-sd -f -d 200
> > > bacula-sd: address_conf.c:274-0 Initaddr 0.0.0.0:9103
> > <http://0.0.0.0:9103>
> > > bacula-sd: jcr.c:131-0 read_last_jobs seek to 192
> > > bacula-sd: jcr.c:138-0 Read num_items=10
> > > bacula-sd: stored.c:608-0 calling init_dev FileStorage
> > > bacula-sd: init_dev.c:116-0 init_dev dev_type=0
> > > bacula-sd: init_dev.c:152-0 Num drivers=15
> > > bacula-sd: bnet_server.c:86-0 Addresses 109.73.166.242:9103
> > <http://109.73.166.242:9103>
> > > bacula-sd: init_dev.c:165-0 loadable=0 type=1 loaded=1 name=file
> > handle=0
> > > bacula-sd: init_dev.c:391-0 init_dev: tape=0
> dev_name=/bacula/backup
> > > bacula-sd: stored.c:610-0 SD init done FileStorage
> > > bacula-sd: block_util.c:170-0 New block adata=0 len=64512
> > block=7f54f0002560
> > > bacula-sd: acquire.c:663-0 Attach 0xf0001f48 to dev "FileStorage"
> > > (/bacula/backup)
> > > =======================================
> > >
>
>
>
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
