On 2/21/2011 2:36 PM, John Drescher wrote:
> 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.

What datatype is media.endblock on your system?  On mine, PostgreSQL, it 
is: endblock         | bigint                      | not null

I suspect yours is int.  Changing it to bigint should fix the problem.

-- 
Dan Langille - http://langille.org/

------------------------------------------------------------------------------
Index, Search & Analyze Logs and other IT data in Real-Time with Splunk 
Collect, index and harness all the fast moving IT data generated by your 
applications, servers and devices whether physical, virtual or in the cloud.
Deliver compliance at lower cost and gain new business insights. 
Free Software Download: http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users