Bacula-users

[Bacula-users] Error: sql_update.c:411 sql_update.c:411 update UPDATE Media SET

2016-03-31 11:47:24
Subject: [Bacula-users] Error: sql_update.c:411 sql_update.c:411 update UPDATE Media SET
From: Martin Feldbacher <martin.feldbacher AT stegbauer DOT info>
To: bacula-users <bacula-users AT lists.sourceforge DOT net>
Date: Thu, 31 Mar 2016 17:25:41 +0200 (CEST)
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

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
<Prev in Thread] Current Thread [Next in Thread>
  • [Bacula-users] Error: sql_update.c:411 sql_update.c:411 update UPDATE Media SET, Martin Feldbacher <=