Re: Curious buildfarm failures (fwd) - Mailing list pgsql-hackers

On Tue, 15 Jan 2013, Tom Lane wrote:

> BTW, I just finished trying to reproduce this on an IA64 machine
> belonging to Red Hat, without success.  So that seems to eliminate
> any possibility of the machine architecture being the trigger issue.
> The compiler's still a likely cause though.
> Anybody have a similar ICC version (dugong's says it is 10.0 20070809)
> to try?  Also, Sergey, can you find a non-dot-zero release to try?

I think it is indeed the main issue.
I've tried 10.1 ( 10.1.011 ) and it doesn't fail.

When I tried 11.1 (icc (ICC) 11.1 20100401 ) it failed in a quite strange 
way (I don't quite remember it happenning before)

test tablespace               ... ok
parallel group (18 tests):  txid int2 text name oid varchar int4 char money
float8 uuid float4 int8 boolean bit enum numeric rangetypes     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     txid                     ... ok     uuid                     ... ok
enum                    ... ok     money                    ... ok     rangetypes               ... FAILED (test
processexited with exit code     2)
 
test strings                  ... FAILED (test process exited with exit code
2)
test numerology               ... FAILED (test process exited with exit code
2)
parallel group (19 tests):  path interval time inet circle macaddr comments
timestamp timestamptz reltime date tstypes tinterval abstime timetz lseg box
polygon point     point                    ... FAILED (test process exited with exit code
2)     lseg                     ... FAILED (test process exited with exit code
2)     box                      ... FAILED (test process exited with exit code
2)     path                     ... FAILED (test process exited with exit code
2)     polygon                  ... FAILED (test process exited with exit code
2)     circle                   ... FAILED (test process exited with exit code
2)     date                     ... FAILED (test process exited with exit code
2)     time                     ... FAILED (test process exited with exit code
2)     timetz                   ... FAILED (test process exited with exit code
2)     timestamp                ... FAILED (test process exited with exit code
2)     timestamptz              ... FAILED (test process exited with exit code
2)     interval                 ... FAILED (test process exited with exit code
2)     abstime                  ... FAILED (test process exited with exit code
2)     reltime                  ... FAILED (test process exited with exit code
2)     tinterval                ... FAILED (test process exited with exit code
2)     inet                     ... FAILED (test process exited with exit code
2)     macaddr                  ... FAILED (test process exited with exit code
2)     tstypes                  ... FAILED (test process exited with exit code
2)     comments                 ... FAILED (test process exited with exit code
2)
parallel group (6 tests):  geometry regex horology type_sanity oidjoins
opr_sanity     geometry                 ... FAILED     horology                 ... FAILED     regex
...ok     oidjoins                 ... ok     type_sanity              ... ok     opr_sanity               ... ok
 
test insert                   ... ok
test create_function_1        ... ok
test create_type              ... ok
test create_table             ... ok
test create_function_2        ... ok
parallel group (2 tests):  copyselect copy     copy                     ... ok     copyselect               ... ok
parallel group (2 tests):  create_operator create_misc     create_misc              ... ok     create_operator
...ok
 
parallel group (2 tests):  create_view create_index     create_index             ... FAILED (test process exited with
exitcode
 
2)     create_view              ... ok
parallel group (11 tests):  constraints triggers create_cast
create_function_3 updatable_views inherit drop_if_exists create_aggregate
create_table_like typed_table vacuum     create_aggregate         ... FAILED (test process exited with exit code
2)     create_function_3        ... FAILED (test process exited with exit code
2)     create_cast              ... FAILED (test process exited with exit code
2)     constraints              ... FAILED (test process exited with exit code
2)     triggers                 ... FAILED (test process exited with exit code
2)     inherit                  ... FAILED (test process exited with exit code
2)     create_table_like        ... FAILED (test process exited with exit code
2)     typed_table              ... FAILED (test process exited with exit code
2)     vacuum                   ... FAILED (test process exited with exit code
2)     drop_if_exists           ... FAILED (test process exited with exit code
2)     updatable_views          ... FAILED (test process exited with exit code
2)
test sanity_check             ... FAILED (test process exited with exit code
2)
test errors                   ... FAILED (test process exited with exit code
2)
test select                   ... FAILED (test process exited with exit code
2)
parallel group (20 tests):  join transactions subselect portals
select_having case select_distinct btree_index union hash_index namespace
random delete select_implicit select_into arrays update prepared_xacts
aggregates select_distinct_on     select_into              ... FAILED (test process exited with exit code
2)     select_distinct          ... FAILED (test process exited with exit code
2)     select_distinct_on       ... FAILED (test process exited with exit code
2)     select_implicit          ... FAILED (test process exited with exit code
2)     select_having            ... FAILED (test process exited with exit code
2)     subselect                ... FAILED (test process exited with exit code
2)     union                    ... FAILED (test process exited with exit code
2)     case                     ... FAILED (test process exited with exit code
2)     join                     ... FAILED (test process exited with exit code
2)     aggregates               ... FAILED (test process exited with exit code
2)     transactions             ... FAILED (test process exited with exit code
2)     random                   ... failed (ignored) (test process exited with
exit code 2)     portals                  ... FAILED (test process exited with exit code
2)     arrays                   ... FAILED (test process exited with exit code
2)     btree_index              ... FAILED (test process exited with exit code
2)     hash_index               ... FAILED (test process exited with exit code
2)     update                   ... FAILED (test process exited with exit code
2)     namespace                ... FAILED (test process exited with exit code
2)     prepared_xacts           ... FAILED (test process exited with exit code
2)     delete                   ... FAILED (test process exited with exit code
2)
parallel group (3 tests):  security_label collate privileges     privileges               ... ok     security_label
     ... ok     collate                  ... ok
 
parallel group (2 tests):  alter_generic misc     misc                     ... FAILED     alter_generic            ...
ok
test rules                    ... ok
test event_trigger            ... ok
parallel group (16 tests):  combocid portals_p2 advisory_lock xmlmap json
tsdicts guc functional_deps dependency tsearch cluster select_views window
foreign_data foreign_key bitmapops     select_views             ... ok     portals_p2               ... ok
foreign_key             ... ok     cluster                  ... ok     dependency               ... ok     guc
           ... ok     bitmapops                ... ok     combocid                 ... ok     tsearch
...ok     tsdicts                  ... ok     foreign_data             ... ok     window                   ... ok
xmlmap                  ... ok     functional_deps          ... ok     advisory_lock            ... ok     json
           ... ok
 
parallel group (19 tests):  limit conversion prepare temp returning copy2
plancache sequence xml largeobject rowtypes polymorphism without_oid domain
rangefuncs with truncate alter_table plpgsql     plancache                ... ok     limit                    ... ok
plpgsql                  ... ok     copy2                    ... ok     temp                     ... ok     domain
            ... ok     rangefuncs               ... ok     prepare                  ... ok     without_oid
...ok     conversion               ... ok     truncate                 ... ok     alter_table              ... ok
sequence                ... ok     polymorphism             ... ok     rowtypes                 ... ok     returning
           ... ok     largeobject              ... ok     with                     ... FAILED     xml
  ... ok
 
test stats                    ... ok
#########

Digging into the log showed the following trap:

TRAP: FailedAssertion("!(( ((void) ((bool) ((! assert_enabled) || ! (!(((bool) (((const void*)(&nodes[n
]->t_tid) != ((void *)0)) && ((&nodes[n]->t_tid)->ip_posid != 0))))) || (ExceptionalCondition("!(((bool
) (((const void*)(&nodes[n]->t_tid) != ((void *)0)) && ((&nodes[n]->t_tid)->ip_posid != 0))))", ("Faile
dAssertion"), "spgdoinsert.c", 1222), 0)))), ( ((void) ((bool) ((! assert_enabled) || ! (!(((bool) ((co
nst void*)(&(&nodes[n]->t_tid)->ip_blkid) != ((void *)0))))) || (ExceptionalCondition("!(((bool) ((cons
t void*)(&(&nodes[n]->t_tid)->ip_blkid) != ((void *)0))))", ("FailedAssertion"), "spgdoinsert.c", 1222)
, 0)))), (BlockNumber) (((&(&nodes[n]->t_tid)->ip_blkid)->bi_hi << 16) | ((uint16) (&(&nodes[n]->t_tid)
->ip_blkid)->bi_lo)) ) ) == leafBlock)", File: "spgdoinsert.c", Line: 1222)
2013-01-16 00:23:39 MSK [50f5bac9.3d6e:48] DEBUG:  server process (PID 15774) was terminated by signal
6: Aborted
2013-01-16 00:23:39 MSK [50f5bac9.3d6e:49] DETAIL:  Failed process was running: insert into test_range_
spgist select 'empty'::int4range from generate_series(1,500) g;
2013-01-16 00:23:39 MSK [50f5bac9.3d6e:50] LOG:  server process (PID 15774) was terminated by signal 6: Aborted


Cheers,    S
*****************************************************
Sergey E. Koposov, PhD, Research Associate
Institute of Astronomy, University of Cambridge
Madingley road, CB3 0HA, Cambridge, UK
Tel: +44-1223-337-551 Web: http://www.ast.cam.ac.uk/~koposov/