Skip site navigation (1) Skip section navigation (2)

Re: Curious buildfarm failures (fwd)

From: Sergey Koposov <koposov(at)ast(dot)cam(dot)ac(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org, Andres Freund <andres(at)2ndquadrant(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>
Subject: Re: Curious buildfarm failures (fwd)
Date: 2013-01-15 20:26:49
Message-ID: alpine.LRH.2.03.1301152012220.773@ast.cam.ac.uk (view raw or flat)
Thread:
Lists: 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 process exited 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 exit code
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/


In response to

pgsql-hackers by date

Next:From: Kohei KaiGaiDate: 2013-01-15 20:28:23
Subject: [sepgsql 2/3] Add db_schema:search permission checks
Previous:From: Tom LaneDate: 2013-01-15 20:22:11
Subject: Re: erroneous restore into pg_catalog schema

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group