Re: [Moosefs-users] (FYI) fail to build postgresql on MFS disk

[Anh K. H. <ky...@vi...>]

Hi,
On Wed, 9 Feb 2011 08:58:17 +0100
"Michal Borychowski" <mic...@ge...> wrote:

> We just tried to install postgresql on the machine:
> MFS: 1.6.20
> Ubuntu 10.10 / 64bit
> 
> with the "dpkg-buildpackage -us -nc -rfakeroot" command and
> everything went smoothly. And we are not sure where to look further
> for any error and how to debug it.

Thank you for your information.

I've tried as you said, and the results are weird:

  #1. dpkg-buildpackage -us                # failed
  #2. dpkg-buildpackage -us     -rfakeroot # passed
  #3. dpkg-buildpackage -us -nc -rfakeroot # failed

That's really strange. It's seem that the problem happened randomly... I will test and give you more results.

Regards,

> 
> Here is a piece of log:
> 
> ./pg_regress --inputdir=. --dlpath=. --multibyte=SQL_ASCII
> --temp-install=./tmp_check --top-builddir=../../..
> --schedule=./parallel_schedule  numeric_big
> ============== creating temporary installation        ==============
> ============== initializing database system           ==============
> ============== starting postmaster                    ==============
> running on port 57235 with pid 32628
> ============== creating database "regression"         ==============
> CREATE DATABASE
> ALTER DATABASE
> ============== running regression test queries        ==============
> test tablespace               ... ok
> parallel group (17 tests):  int2 float4 name oid money text varchar
> char int4 int8 boolean txid float8 bit uuid enum 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
>      txid                     ... ok
>      uuid                     ... ok
>      enum                     ... ok
>      money                    ... ok
> test strings                  ... ok
> test numerology               ... ok
> parallel group (19 tests):  point circle comments tstypes box lseg
> abstime reltime tinterval timetz date polygon macaddr time
> timestamp path interval inet timestamptz
>      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
>      macaddr                  ... ok
>      tstypes                  ... ok
>      comments                 ... ok
> parallel group (5 tests):  geometry horology type_sanity oidjoins
> opr_sanity geometry                 ... ok
>      horology                 ... 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 (10 tests):  create_aggregate create_operator
> create_cast drop_if_exists typed_table create_misc triggers vacuum
> constraints inherit constraints              ... ok
>      triggers                 ... ok
>      create_misc              ... ok
>      create_aggregate         ... ok
>      create_operator          ... ok
>      inherit                  ... ok
>      typed_table              ... ok
>      vacuum                   ... ok
>      drop_if_exists           ... ok
>      create_cast              ... 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 (20 tests):  select_distinct select_distinct_on
> select_into btree_index hash_index random union update
> select_having delete namespace case aggregates select_implicit
> prepared_xacts subselect transactions portals arrays join
>      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
>      delete                   ... ok
> test privileges               ... ok
> test misc                     ... ok
> test rules                    ... ok
> parallel group (13 tests):  combocid select_views portals_p2
> tsdicts window xmlmap foreign_data guc dependency tsearch bitmapops
> cluster foreign_key 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
> parallel group (19 tests):  limit conversion xml prepare
> polymorphism largeobject without_oid with copy2 returning rowtypes
> plancache sequence temp rangefuncs domain plpgsql truncate
> alter_table 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                     ... ok
>      xml                      ... ok
> test stats                    ... ok
> test numeric_big          ... ok
> ============== shutting down postmaster               ==============
> 
> =======================
>  All 123 tests passed. 
> =======================
> 
> 
> 
> 
> Regards
> Michal
> 
> 
> -----Original Message-----
> From: Anh K. Huynh [mailto:ky...@vi...] 
> Sent: Tuesday, February 08, 2011 6:57 AM
> To: moosefs-users
> Subject: [Moosefs-users] (FYI) fail to build postgresql on MFS disk
> 
> Hi,
> 
> I am trying to build `postgresql-9.0.3` on a Lenny system. The
> source is located on a MFS disk. The build process is good
> (binaries are created), but the tests fails (for example, test
> "numeric_big" as below); and many sql statements cannot be
> executed. Please note that during the test, Debian system will run
> a temporary database server to feed SQL statements.
> 
> I move source to a NFS disk, and things go well. So this post may
> help anyone who intends to build `postgresql` on MFS disk. If you
> need any information, just let me know.
> 
> Regards,
> 
> Logs:
> 
> ***
> /home/debian/psql.source/postgresql-9.0-9.0.3/src/test/regress/expected/nume
> ric_big.out     2011-01-27 18:21:31.000000000 -0800
> ---
> /home/debian/psql.source/postgresql-9.0-9.0.3/src/test/regress/results/numer
> ic_big.out      2011-02-07 20:17:12.000000000 -0800
> ***************
> *** 500,505 ****
> --- 500,506 ----