Re: pika failing since the per-column collation patch - Mailing list pgsql-hackers

From Rémi Zara
Subject Re: pika failing since the per-column collation patch
Date
Msg-id 669E50C5-3EF6-48BF-B39A-614EBB206B46@mac.com
Whole thread Raw
In response to Re: pika failing since the per-column collation patch  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: pika failing since the per-column collation patch
Re: pika failing since the per-column collation patch
Re: pika failing since the per-column collation patch
List pgsql-hackers
Le 12 févr. 2011 à 18:51, Peter Eisentraut a écrit :

> On lör, 2011-02-12 at 13:34 +0100, Rémi Zara wrote:
>> Since the per-column collation patch went in, pika (NetBSD 5.1/mips) started failing consistently with this diff:
>>
>> *** /home/pgbuildfarm/workdir/HEAD/pgsql.15101/src/test/regress/expected/polymorphism.out    Sat Feb 12 02:16:07
2011
>> --- /home/pgbuildfarm/workdir/HEAD/pgsql.15101/src/test/regress/results/polymorphism.out    Sat Feb 12 09:10:21 2011
>> ***************
>> *** 624,630 ****
>>
>>  -- such functions must protect themselves if varying element type isn't OK
>>  select max(histogram_bounds) from pg_stats;
>> ! ERROR:  cannot compare arrays of different element types
>>  -- test variadic polymorphic functions
>>  create function myleast(variadic anyarray) returns anyelement as $$
>>    select min($1[i]) from generate_subscripts($1,1) g(i)
>> --- 624,630 ----
>>
>>  -- such functions must protect themselves if varying element type isn't OK
>>  select max(histogram_bounds) from pg_stats;
>> ! ERROR:  locale operation to be invoked, but no collation was derived
>>  -- test variadic polymorphic functions
>>  create function myleast(variadic anyarray) returns anyelement as $$
>>    select min($1[i]) from generate_subscripts($1,1) g(i)
>>
>> Is there something I can do to help investigate this ?
>
> It's only failing on this one machine, but there isn't anything
> platform-specific in this code, so I'd look for memory management faults
> on the code or a compiler problem.  Try with lower optimization for a
> start.
>


Same failure with -O0 (and more shared memory).

Regards,

Rémi Zara

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: ALTER TYPE 2: skip already-provable no-work rewrites
Next
From: "Kevin Grittner"
Date:
Subject: Re: pg_terminate_backend and pg_cancel_backend by not administrator user