Thread: regression results for AIX 4.2
Hey guys,
after manually patching my float.h compilation on aix continued up to
the end. I run a "make check" and I see quite some failures! I don't
think it is safe to install and use th db this way? Do you want
further details to investigate some of these problems ?
============== creating temporary installation ==============
============== initializing database system ==============
============== starting postmaster ==============
running on port 55432 with pid 13646
============== creating database "regression" ==============
CREATE DATABASE
============== dropping regression test user accounts ==============
============== installing plpgsql ==============
============== running regression test queries ==============
parallel group (13 tests): name int2 float4 char text oid varchar
boolean int4 int8 float8 bit numeric
boolean ... ok
char ... ok
name ... FAILED
varchar ... ok
text ... ok
int2 ... FAILED
int4 ... ok
int8 ... ok
oid ... ok
float4 ... FAILED
float8 ... ok
bit ... ok
numeric ... ok
test strings ... ok
test numerology ... FAILED
parallel group (20 tests): path box point circle lseg polygon time
timetz date timestamp abstime reltime inet comments interval tinterval
timestamptz type_sanity oidjoins opr_sanity
point ... ok
lseg ... ok
box ... ok
path ... ok
polygon ... ok
circle ... ok
date ... ok
time ... ok
timetz ... ok
timestamp ... FAILED
timestamptz ... FAILED
interval ... ok
abstime ... FAILED
reltime ... ok
tinterval ... ok
inet ... FAILED
comments ... ok
oidjoins ... ok
type_sanity ... ok
opr_sanity ... ok
test geometry ... ok
test horology ... FAILED
test insert ... ok
test create_function_1 ... ok
test create_type ... ok
test create_table ... ok
test create_function_2 ... ok
test copy ... FAILED
parallel group (7 tests): constraints triggers create_misc
create_aggregate inherit create_operator vacuum
constraints ... FAILED
triggers ... FAILED
create_misc ... FAILED
create_aggregate ... FAILED
create_operator ... FAILED
inherit ... FAILED
vacuum ... FAILED
parallel group (2 tests): create_index create_view
create_index ... FAILED
create_view ... FAILED
test sanity_check ... FAILED
test errors ... FAILED
test select ... FAILED
parallel group (19 tests): select_into select_distinct
select_implicit select_distinct_on select_having union subselect case
aggregates join transactions random arrays portals btree_index
hash_index namespace update prepared_xacts
select_into ... FAILED
select_distinct ... FAILED
select_distinct_on ... FAILED
select_implicit ... FAILED
select_having ... FAILED
subselect ... FAILED
union ... FAILED
case ... FAILED
join ... FAILED
aggregates ... FAILED
transactions ... FAILED
random ... failed (ignored)
portals ... FAILED
arrays ... FAILED
btree_index ... FAILED
hash_index ... FAILED
update ... FAILED
namespace ... FAILED
prepared_xacts ... FAILED
test privileges ... FAILED
test misc ... FAILED
parallel group (6 tests): select_views portals_p2 rules foreign_key
cluster dependency
select_views ... FAILED
portals_p2 ... FAILED
rules ... FAILED
foreign_key ... FAILED
cluster ... FAILED
dependency ... FAILED
parallel group (14 tests): limit plpgsql copy2 rangefuncs temp domain
prepare without_oid alter_table conversion truncate sequence rowtypes
polymorphism
limit ... FAILED
plpgsql ... FAILED
copy2 ... FAILED
temp ... FAILED
domain ... FAILED
rangefuncs ... FAILED
prepare ... FAILED
without_oid ... FAILED
conversion ... FAILED
truncate ... FAILED
alter_table ... FAILED
sequence ... FAILED
polymorphism ... FAILED
rowtypes ... FAILED
test stats ... FAILED
test tablespace ... FAILED
============== shutting down postmaster ==============
pg_ctl: PID file
"/home/multix/postgresql-8.1.3/src/test/regress/./tmp_check/data/postmaster.pid"
does not exist
Is postmaster running?
=====================================================
65 of 98 tests failed, 1 of these failures ignored.
=====================================================
greetings,
Riccardo
Yes, seems worse. Try doing an install then a make check or make installcheck and see if that improves it. --------------------------------------------------------------------------- Riccardo Mottola wrote: > Hey guys, > > after manually patching my float.h compilation on aix continued up to > the end. I run a "make check" and I see quite some failures! I don't > think it is safe to install and use th db this way? Do you want > further details to investigate some of these problems ? > > ============== creating temporary installation ============== > ============== initializing database system ============== > ============== starting postmaster ============== > running on port 55432 with pid 13646 > ============== creating database "regression" ============== > CREATE DATABASE > ============== dropping regression test user accounts ============== > ============== installing plpgsql ============== > ============== running regression test queries ============== > parallel group (13 tests): name int2 float4 char text oid varchar > boolean int4 int8 float8 bit numeric > boolean ... ok > char ... ok > name ... FAILED > varchar ... ok > text ... ok > int2 ... FAILED > int4 ... ok > int8 ... ok > oid ... ok > float4 ... FAILED > float8 ... ok > bit ... ok > numeric ... ok > test strings ... ok > test numerology ... FAILED > parallel group (20 tests): path box point circle lseg polygon time > timetz date timestamp abstime reltime inet comments interval tinterval > timestamptz type_sanity oidjoins opr_sanity > point ... ok > lseg ... ok > box ... ok > path ... ok > polygon ... ok > circle ... ok > date ... ok > time ... ok > timetz ... ok > timestamp ... FAILED > timestamptz ... FAILED > interval ... ok > abstime ... FAILED > reltime ... ok > tinterval ... ok > inet ... FAILED > comments ... ok > oidjoins ... ok > type_sanity ... ok > opr_sanity ... ok > test geometry ... ok > test horology ... FAILED > test insert ... ok > test create_function_1 ... ok > test create_type ... ok > test create_table ... ok > test create_function_2 ... ok > test copy ... FAILED > parallel group (7 tests): constraints triggers create_misc > create_aggregate inherit create_operator vacuum > constraints ... FAILED > triggers ... FAILED > create_misc ... FAILED > create_aggregate ... FAILED > create_operator ... FAILED > inherit ... FAILED > vacuum ... FAILED > parallel group (2 tests): create_index create_view > create_index ... FAILED > create_view ... FAILED > test sanity_check ... FAILED > test errors ... FAILED > test select ... FAILED > parallel group (19 tests): select_into select_distinct > select_implicit select_distinct_on select_having union subselect case > aggregates join transactions random arrays portals btree_index > hash_index namespace update prepared_xacts > select_into ... FAILED > select_distinct ... FAILED > select_distinct_on ... FAILED > select_implicit ... FAILED > select_having ... FAILED > subselect ... FAILED > union ... FAILED > case ... FAILED > join ... FAILED > aggregates ... FAILED > transactions ... FAILED > random ... failed (ignored) > portals ... FAILED > arrays ... FAILED > btree_index ... FAILED > hash_index ... FAILED > update ... FAILED > namespace ... FAILED > prepared_xacts ... FAILED > test privileges ... FAILED > test misc ... FAILED > parallel group (6 tests): select_views portals_p2 rules foreign_key > cluster dependency > select_views ... FAILED > portals_p2 ... FAILED > rules ... FAILED > foreign_key ... FAILED > cluster ... FAILED > dependency ... FAILED > parallel group (14 tests): limit plpgsql copy2 rangefuncs temp domain > prepare without_oid alter_table conversion truncate sequence rowtypes > polymorphism > limit ... FAILED > plpgsql ... FAILED > copy2 ... FAILED > temp ... FAILED > domain ... FAILED > rangefuncs ... FAILED > prepare ... FAILED > without_oid ... FAILED > conversion ... FAILED > truncate ... FAILED > alter_table ... FAILED > sequence ... FAILED > polymorphism ... FAILED > rowtypes ... FAILED > test stats ... FAILED > test tablespace ... FAILED > ============== shutting down postmaster ============== > pg_ctl: PID file > "/home/multix/postgresql-8.1.3/src/test/regress/./tmp_check/data/postmaster.pid" > does not exist > Is postmaster running? > > ===================================================== > 65 of 98 tests failed, 1 of these failures ignored. > ===================================================== > > greetings, > Riccardo > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. +
Hey,
On 3/20/06, Bruce Momjian <pgman@candle.pha.pa.us> wrote:
>
> Yes, seems worse. Try doing an install then a make check or make
> installcheck and see if that improves it.
>
I installed, reated the user, like in the short version of the INSTALL document.
once installed (and started) I rerun make check.
things appear to improve quite a bit:
============== running regression test queries ==============
parallel group (13 tests): boolean float8 char text name varchar int2
int8 int4 oid float4 bit numeric
boolean ... ok
char ... ok
name ... ok
varchar ... ok
text ... ok
int2 ... ok
int4 ... ok
int8 ... ok
oid ... ok
float4 ... ok
float8 ... ok
bit ... ok
numeric ... ok
test strings ... ok
test numerology ... ok
parallel group (20 tests): point polygon circle time date timetz
interval timestamp lseg box timestamptz path abstime reltime tinterval
comments inet type_sanity oidjoins opr_sanity
point ... ok
lseg ... ok
box ... ok
path ... ok
polygon ... ok
circle ... ok
date ... ok
time ... ok
timetz ... ok
timestamp ... ok
timestamptz ... ok
interval ... ok
abstime ... ok
reltime ... ok
tinterval ... ok
inet ... ok
comments ... ok
oidjoins ... ok
type_sanity ... ok
opr_sanity ... ok
test geometry ... ok
test horology ... ok
test insert ... ok
test create_function_1 ... ok
test create_type ... ok
test create_table ... ok
test create_function_2 ... ok
test copy ... ok
parallel group (7 tests): create_operator create_aggregate vacuum
triggers constraints inherit create_misc
constraints ... ok
triggers ... ok
create_misc ... ok
create_aggregate ... ok
create_operator ... ok
inherit ... ok
vacuum ... ok
parallel group (2 tests): create_view create_index
create_index ... ok
create_view ... ok
test sanity_check ... ok
test errors ... ok
test select ... ok
parallel group (19 tests): select_into select_distinct_on
select_having select_distinct select_implicit union case random
aggregates transactions join portals subselect btree_index update
namespace hash_index arrays prepared_xacts
select_into ... ok
select_distinct ... ok
select_distinct_on ... ok
select_implicit ... ok
select_having ... ok
subselect ... ok
union ... ok
case ... ok
join ... ok
aggregates ... ok
transactions ... ok
random ... ok
portals ... ok
arrays ... ok
btree_index ... ok
hash_index ... ok
update ... ok
namespace ... ok
prepared_xacts ... ok
test privileges ... ok
test misc ... ok
parallel group (6 tests): portals_p2 dependency cluster select_views
rules foreign_key
select_views ... ok
portals_p2 ... ok
rules ... ok
foreign_key ... ok
cluster ... ok
dependency ... ok
parallel group (14 tests): limit temp copy2 prepare domain rangefuncs
conversion without_oid plpgsql rowtypes sequence polymorphism
alter_table truncate
limit ... ok
plpgsql ... ok
copy2 ... ok
temp ... ok
domain ... ok
rangefuncs ... ok
prepare ... ok
without_oid ... ok
conversion ... ok
truncate ... FAILED
alter_table ... FAILED
sequence ... FAILED
polymorphism ... FAILED
rowtypes ... FAILED
test stats ... FAILED
test tablespace ... FAILED
============== shutting down postmaster ==============
pg_ctl: PID file
"/home/multix/postgresql-8.1.3/src/test/regress/./tmp_check/data/postmaster.pid"
does not exist
Is postmaster running?
=======================
7 of 98 tests failed.
further comments?
-Riccardo
My guess is that the server is now crashing. Take a look at regressions.diffs. --------------------------------------------------------------------------- Riccardo Mottola wrote: > Hey, > > On 3/20/06, Bruce Momjian <pgman@candle.pha.pa.us> wrote: > > > > Yes, seems worse. Try doing an install then a make check or make > > installcheck and see if that improves it. > > > > I installed, reated the user, like in the short version of the INSTALL document. > > once installed (and started) I rerun make check. > > things appear to improve quite a bit: > > ============== running regression test queries ============== > parallel group (13 tests): boolean float8 char text name varchar int2 > int8 int4 oid float4 bit numeric > boolean ... ok > char ... ok > name ... ok > varchar ... ok > text ... ok > int2 ... ok > int4 ... ok > int8 ... ok > oid ... ok > float4 ... ok > float8 ... ok > bit ... ok > numeric ... ok > test strings ... ok > test numerology ... ok > parallel group (20 tests): point polygon circle time date timetz > interval timestamp lseg box timestamptz path abstime reltime tinterval > comments inet type_sanity oidjoins opr_sanity > point ... ok > lseg ... ok > box ... ok > path ... ok > polygon ... ok > circle ... ok > date ... ok > time ... ok > timetz ... ok > timestamp ... ok > timestamptz ... ok > interval ... ok > abstime ... ok > reltime ... ok > tinterval ... ok > inet ... ok > comments ... ok > oidjoins ... ok > type_sanity ... ok > > opr_sanity ... ok > test geometry ... ok > test horology ... ok > test insert ... ok > test create_function_1 ... ok > test create_type ... ok > test create_table ... ok > test create_function_2 ... ok > test copy ... ok > parallel group (7 tests): create_operator create_aggregate vacuum > triggers constraints inherit create_misc > constraints ... ok > triggers ... ok > create_misc ... ok > create_aggregate ... ok > create_operator ... ok > inherit ... ok > vacuum ... ok > parallel group (2 tests): create_view create_index > create_index ... ok > create_view ... ok > test sanity_check ... ok > test errors ... ok > test select ... ok > parallel group (19 tests): select_into select_distinct_on > select_having select_distinct select_implicit union case random > aggregates transactions join portals subselect btree_index update > namespace hash_index arrays prepared_xacts > select_into ... ok > select_distinct ... ok > select_distinct_on ... ok > select_implicit ... ok > select_having ... ok > subselect ... ok > union ... ok > case ... ok > join ... ok > aggregates ... ok > transactions ... ok > random ... ok > portals ... ok > arrays ... ok > btree_index ... ok > hash_index ... ok > update ... ok > namespace ... ok > prepared_xacts ... ok > test privileges ... ok > test misc ... ok > parallel group (6 tests): portals_p2 dependency cluster select_views > rules foreign_key > select_views ... ok > portals_p2 ... ok > rules ... ok > foreign_key ... ok > cluster ... ok > dependency ... ok > parallel group (14 tests): limit temp copy2 prepare domain rangefuncs > conversion without_oid plpgsql rowtypes sequence polymorphism > alter_table truncate > limit ... ok > plpgsql ... ok > copy2 ... ok > temp ... ok > domain ... ok > rangefuncs ... ok > prepare ... ok > without_oid ... ok > conversion ... ok > truncate ... FAILED > alter_table ... FAILED > sequence ... FAILED > polymorphism ... FAILED > rowtypes ... FAILED > test stats ... FAILED > test tablespace ... FAILED > ============== shutting down postmaster ============== > pg_ctl: PID file > "/home/multix/postgresql-8.1.3/src/test/regress/./tmp_check/data/postmaster.pid" > does not exist > Is postmaster running? > > ======================= > 7 of 98 tests failed. > > further comments? > -Riccardo > -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. +
Quoth multix@gmail.com ("Riccardo Mottola"):
> Hey guys,
>
> after manually patching my float.h compilation on aix continued up to
> the end. I run a "make check" and I see quite some failures! I don't
> think it is safe to install and use th db this way? Do you want
> further details to investigate some of these problems ?
I'd fully expect there to be some horology problems falling out of the
recent modifications made to when daylight savings time will begin in
2007.
But the sheer volume of "most of the tests failed" wouldn't give me
much confidence.
If you could account for all of the differences representing minor
rounding errors or the like where the results could reasonably be a
*little* different, that would be one thing.
But it looks as though the postmaster fell over at about the point of
the "test copy" test, and that everything failed from then on. That
would cause me a lot of concern.
It's worth observing that AIX 4.2 is Really Rather Old... On 5.1 and
5.3, the only failures we'd expect to see are with horology, where the
results vary by patchlevel based on whether or not AIX has gotten
patched to be aware of timezone policy changes...
--
let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;;
http://linuxdatabases.info/info/slony.html
Rules of the Evil Overlord #89. "After I captures the hero's
superweapon, I will not immediately disband my legions and relax my
guard because I believe whoever holds the weapon is unstoppable. After
all, the hero held the weapon and I took it from him."
<http://www.eviloverlord.com/>