Re: pika failing since the per-column collation patch

From: Rémi Zara <remi_zara(at)mac(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pika failing since the per-column collation patch
Date: 2011-02-14 18:27:51
Message-ID: 669E50C5-3EF6-48BF-B39A-614EBB206B46@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2011-02-14 18:47:01 Re: pg_terminate_backend and pg_cancel_backend by not administrator user
Previous Message Stephen Frost 2011-02-14 18:12:21 Re: ALTER TYPE 2: skip already-provable no-work rewrites