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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users