hi,
I'm running bacula version 5.2.6 on debian 7.9 with pgsql database. I've several jobs with spooling data enabled. Today each I get the following error within each job after starting despooling:
31-Mar 16:27 lx17-bacula-sd-sd JobId 30213: Committing spooled data to Volume "MITA02L5".
Despooling 23,360,515,172 bytes ...
31-Mar 16:28 lx11-afk-dir JobId 30213: Error: sql_update.c:411 sql_update.c:411 update
UPDATE Media SET
VolJobs=1,VolFiles=1,VolBlocks=133151,VolBytes=8589901824,VolMounts=179,VolErrors=0,VolWrites=214761
5974,MaxVolBytes=0,VolStatus='Append',Slot=5,InChanger=1,VolReadTime=441167991,VolWriteTime=580703597
240,VolParts=0,LabelType=0,StorageId=2,PoolId=6,VolRetention=518400,VolUseDuration=259200,MaxVolJobs=
0,MaxVolFiles=0,Enabled=1,LocationId=0,ScratchPoolId=0,RecyclePoolId=0,RecycleCount=101,Recycle=1,Act
ionOnPurge=0
WHERE VolumeName='MITA02L5' failed:
FEHLER: integer is out of range
31-Mar 16:28 lx11-afk-dir JobId 30213: Fatal error: Catalog error updating Media record.
sql_update.c:501 Update failed: affected_rows=0 for UPDATE Media SET InChanger=0, Slot=0
WHERE Slot=5 AND StorageId=2 AND MediaId!=56
31-Mar 16:28 lx17-bacula-sd-sd JobId 30213: Fatal error: Error getting Volume info: 1993
Update Media error
I've already purged the volume and tried to re-run the jobs, and I've made "update slots" already, but I guess it's an database issue?
Maybe anyone can help me
best regards
martin