The value of VolWrites has overflowed its type, which is a pgsql integer (signed 32-bit). The latest version of Bacula uses bigint to prevent this problem.
As a workaround, you could reset VolWrites to 0 for the affected volumes using SQL such as (untested): UPDATE Media SET VolWrites=0 WHERE VolumeName='MITA02L5'; __Martin >>>>> On Thu, 31 Mar 2016 17:25:41 +0200 (CEST), Martin Feldbacher said: > > 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
