Menu
▾
▴
Re: [Moosefs-users] (FYI) fail to build postgresql on MFS disk
|
From: Michal B. <mic...@ge...> - 2011-02-09 07:58:33
|
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
|
