moosefs-users

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

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

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/numeric_big.out     2011-01-27 18:21:31.000000000 -0800
--- /home/debian/psql.source/postgresql-9.0-9.0.3/src/test/regress/results/numeric_big.out      2011-02-07 20:17:12.000000000 -0800
***************
*** 500,505 ****
--- 500,506 ----
  CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id);
  CREATE UNIQUE INDEX num_exp_power_10_ln_idx ON num_exp_power_10_ln (id);
  VACUUM ANALYZE num_exp_add;
+ WARNING:  could not open statistics file "pg_stat_tmp/pgstat.stat": Operation not permitted
  VACUUM ANALYZE num_exp_sub;
  VACUUM ANALYZE num_exp_div;
  VACUUM ANALYZE num_exp_mul;

-- 
Anh Ky Huynh @ UTC+7

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

[Michal B. <mic...@ge...>]

Hi!

This 
> + WARNING:  could not open statistics file "pg_stat_tmp/pgstat.stat":
> Operation not permitted

looks more like a problem with access rights than with the MooseFS itself.
Would you check it?


Regards
Michal


-----Original Message-----
From: Anh K. Huynh [mailto:ky...@vi...] 
Sent: Tuesday, February 08, 2011 6:56 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 ----
  CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id);
  CREATE UNIQUE INDEX num_exp_power_10_ln_idx ON num_exp_power_10_ln (id);
  VACUUM ANALYZE num_exp_add;
+ WARNING:  could not open statistics file "pg_stat_tmp/pgstat.stat":
Operation not permitted
  VACUUM ANALYZE num_exp_sub;
  VACUUM ANALYZE num_exp_div;
  VACUUM ANALYZE num_exp_mul;

-- 
Anh Ky Huynh @ UTC+7

----------------------------------------------------------------------------
--
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
moosefs-users mailing list
moo...@li...
https://lists.sourceforge.net/lists/listinfo/moosefs-users

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

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

On Tue, 8 Feb 2011 07:32:53 +0100
"Michal Borychowski" <mic...@ge...> wrote:

> Hi!
> 
> This 
> > + WARNING:  could not open statistics file
> > "pg_stat_tmp/pgstat.stat": Operation not permitted
> 
> looks more like a problem with access rights than with the MooseFS
> itself. Would you check it?

This file is deleted after the error is captured, so I have no idea what it is :( I asked on #debian, but I didn't receive any reply. Will try on the list debian-users instead. I've also tried to build the package under root account, and the problem is still the same. The full log can be found at
	http://pastebin.com/x6YdPuvE (> 5400 lines)

Regards,


> -----Original Message-----
> From: Anh K. Huynh [mailto:ky...@vi...] 
> Sent: Tuesday, February 08, 2011 6:56 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 ----
>   CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id);
>   CREATE UNIQUE INDEX num_exp_power_10_ln_idx ON
> num_exp_power_10_ln (id); VACUUM ANALYZE num_exp_add;
> + WARNING:  could not open statistics file
> "pg_stat_tmp/pgstat.stat": Operation not permitted
>   VACUUM ANALYZE num_exp_sub;
>   VACUUM ANALYZE num_exp_div;
>   VACUUM ANALYZE num_exp_mul;
> 


-- 
Anh Ky Huynh @ UTC+7

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

[Michal B. <mic...@ge...>]

Hi!

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.


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 ----
  CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id);
  CREATE UNIQUE INDEX num_exp_power_10_ln_idx ON num_exp_power_10_ln (id);
  VACUUM ANALYZE num_exp_add;
+ WARNING:  could not open statistics file "pg_stat_tmp/pgstat.stat":
Operation not permitted
  VACUUM ANALYZE num_exp_sub;
  VACUUM ANALYZE num_exp_div;
  VACUUM ANALYZE num_exp_mul;

-- 
Anh Ky Huynh @ UTC+7

----------------------------------------------------------------------------
--
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
moosefs-users mailing list
moo...@li...
https://lists.sourceforge.net/lists/listinfo/moosefs-users

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