RE:PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mode

From: "REIX, Tony" <tony(dot)reix(at)atos(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, "APEKE, SENA (ext)" <sena(dot)apeke(dot)external(at)atos(dot)net>, Peter Eisentraut <peter_e(at)gmx(dot)net>, "Anthony Bykov" <a(dot)bykov(at)postgrespro(dot)ru>
Subject: RE:PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mode
Date: 2018-06-01 08:13:38
Message-ID: B37989F2852398498001550C29155BE5301846E9@FRCRPVV9EX3MSX.ww931.my-it-solutions.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Tom,

Here are information about the Perl version we are using on our AIX 7.2 machine.

However, as I said already, all PostgreSQL tests of v10.4 and 9.6.9 are OK, both 32 and 64bit.

# rpm -qa | grep perl
perl-5.24.0-3

This version 5.24.0 release 3 of Perl has been built on a AIX 6.1 machine (everything built on AIX 6.1 is compatible with AIX 7).

Looking at the log of the build/tests, I see:
32bit: Failed 1 test out of 2308, 99.96% okay. t/porting/podcheck ............................................ FAILED at test 1
64bit: All tests successful.

We still build perl with XLC (v13.1.3) since we still have issues with GCC. Now trying to build 5.26.2 with GCC.

Running the following recommended command in 32 bit:
setenv LIBPATH `pwd`:$LIBPATH; cd t; ./perl harness
I have:
Test Summary Report
-------------------
porting/checkcase.t (Wstat: 0 Tests: 19966 Failed: 1)
Failed test: 34
porting/podcheck.t (Wstat: 0 Tests: 2741 Failed: 39)
Failed tests: 1-2, 49, 64, 74, 170, 245, 247, 259-263
321, 324, 412, 537, 539, 600, 744, 1095
1104, 1139, 1151, 1178, 1180, 1187, 1196-1197
1226, 1237, 1239, 1253-1254, 1263, 1265
1289, 1483, 2741
../cpan/ExtUtils-Constant/t/Constant.t (Wstat: 0 Tests: 302 Failed: 3)
Failed tests: 253, 255-256
Files=2410, Tests=835508, 1049 wallclock secs (42.12 usr 10.15 sys + 344.73 cusr 45.63 csys = 442.63 CPU)
Result: FAIL

About the libperl, I have:
# ar tv /opt/freeware/lib/perl5/5.24.0/ppc-aix-thread-multi/CORE/libperl.a
rwxr-xr-x 0/0 2245620 Nov 14 07:37 2017 libperl.o

About Perl header files, they are provided in 2 different directories:
64bit: /opt/freeware/lib/perl5/5.24.0/ppc-aix-thread-multi-64all/CORE/
32bit: /opt/freeware/lib/perl5/5.24.0/ppc-aix-thread-multi/CORE/

One file appears once: /opt/freeware/lib/perl5/5.24.0/Encode/encode.h , but is not used by PostgreSQL.

# diff /opt/freeware/lib/perl5/5.24.0/ppc-aix-thread-multi/CORE/perl.h /opt/freeware/lib/perl5/5.24.0/ppc-aix-thread-multi-64all/CORE/perl.h
# identical

The Perl header files are coherent with libperl.a I think.

Cordialement,

Tony Reix

ATOS / Bull SAS
ATOS Expert
IBM Coop Architect & Technical Leader
Office : +33 (0) 4 76 29 72 67
1 rue de Provence - 38432 Échirolles - France
www.atos.net

________________________________________
De : Tom Lane [tgl(at)sss(dot)pgh(dot)pa(dot)us]
Envoyé : mercredi 30 mai 2018 21:36
À : Alvaro Herrera
Cc : REIX, Tony; PostgreSQL-development; APEKE, SENA (ext); Peter Eisentraut; Anthony Bykov
Objet : Re: PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mode

Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> It's pretty obvious that the transform is broken on your platform.

Seems so, but why? The code involved doesn't look very machine-dependent.

I'm wondering about some sort of version skew or misinstallation on
the Perl side --- say, header files that we're using to compile
that don't match the libperl.so used at runtime.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message REIX, Tony 2018-06-01 09:23:19 RE:PostgreSQL 11 beta1 on AIX 7.2 : 2 failures in 32bit mode
Previous Message Pavel Stehule 2018-06-01 05:19:01 why partition pruning doesn't work?