Bacula-users

Re: [Bacula-users] Integer out of range on disk based volumes.

2011-02-21 17:43:58
Subject: Re: [Bacula-users] Integer out of range on disk based volumes.
From: John Drescher <drescherjm AT gmail DOT com>
To: Dan Langille <dan AT langille DOT org>
Date: Mon, 21 Feb 2011 17:41:36 -0500
>> 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.
>

It was an int.

I executed the following command in psql:
ALTER table media ALTER column endblock TYPE bigint;

I will restart the catalog job and see if that fixes the problem..
Thanks,

John

-- 
John M. Drescher

------------------------------------------------------------------------------
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

<Prev in Thread] Current Thread [Next in Thread>