On Aug 19, 2009, at 10:33 PM, Craig Ringer wrote:
> On Wed, 2009-08-19 at 08:58 -0400, Arturo Pérez wrote:
>
>> 19-Aug 02:24 bacula-dir JobId 1951: Fatal error: sql_create.c:789
>> Fill Path table Query failed: INSERT INTO Path (Path) SELECT a.Path
>> FROM (SELECT DISTINCT Path FROM batch) AS a WHERE NOT EXISTS (SELECT
>> Path FROM Path WHERE Path = a.Path) : ERR=ERROR: array size exceeds
>> the maximum allowed (268435455)
>
> That's odd. Where's the array? Subqueries shouldn't result in
> arrays in
> any way, no?
>
Looks like a bad build so far. I was upgrading to 3.0/8.4 and tried
to build
everything universal (on Mac) to future-proof the upgrade. I built
just a native
binary and it seems to work better.
-arturo