At work I periodically have append failures for my disk based volumes.
The following is an example of the error:

21-Feb 14:20 fileserver-dir JobId 24345: Error: sql_create.c:152
sql_create.c:152 update UPDATE Media SET EndFile=0,
EndBlock=3294226434 WHERE MediaId=275 failed:
ERROR:  integer out of range

21-Feb 14:20 fileserver-dir JobId 24345: Fatal error: Catalog error
creating JobMedia record. sql_create.c:154 Update Media record UPDATE
Media SET EndFile=0, EndBlock=3294226434 WHERE MediaId=275 failed:
ERR=ERROR:  integer out of range

21-Feb 14:20 fileserver-sd JobId 24345: Fatal error: Error creating
JobMedia record: 1992 Create JobMedia error


It appears the problem is with the catalog. I am using 64 bit gentoo
linux and bacula-5.0.3 although the problem has persisted for years. I
only use disk volumes for my catalog so I have not spent much effort
investigating the cause.

-- 
John M. Drescher

------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users