FAQ
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

Search Discussions

  • Bruce Momjian at Mar 20, 2006 at 1:59 pm
    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. +
  • Riccardo Mottola at Mar 20, 2006 at 3:15 pm
    Hey,
    On 3/20/06, Bruce Momjian 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 at Mar 20, 2006 at 3:19 pm
    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 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. +
  • Chris Browne at Mar 20, 2006 at 2:03 pm

    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/>

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedMar 20, '06 at 9:52a
activeMar 20, '06 at 3:19p
posts5
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase