PostgreSQLのバージョンアップ(8.3.3)のための、事前にコンパイルをしてみた。コンパイルは何のエラーもなく終了。しかし、いつもはやっていない make check を行ってみると事態は急変。なんだか、穏やかじゃないメッセージが、、、
============== running regression test queries ==============
parallel group (17 tests): boolean char name varchar text int2 int8 int4 float8 float4 bit numeric txid oid money uuid enum
boolean ... FAILED
char ... FAILED
name ... FAILED
varchar ... FAILED
text ... FAILED
int2 ... FAILED
int4 ... FAILED
int8 ... FAILED
oid ... FAILED
float4 ... FAILED
float8 ... FAILED
bit ... FAILED
numeric ... FAILED
txid ... FAILED
uuid ... FAILED
enum ... FAILED
money ... FAILED
test strings ... FAILED
test numerology ... FAILED
parallel group (18 tests): point lseg box path polygon date timetz timestamptz time timestamp interval tinterval inet tstypes reltime comments circle abstime
point ... FAILED
lseg ... FAILED
box ... FAILED
path ... FAILED
polygon ... FAILED
circle ... FAILED
date ... FAILED
time ... FAILED
timetz ... FAILED
timestamp ... FAILED
timestamptz ... FAILED
interval ... FAILED
abstime ... FAILED
reltime ... FAILED
tinterval ... FAILED
inet ... FAILED
tstypes ... FAILED
comments ... FAILED
parallel group (5 tests): geometry horology oidjoins type_sanity opr_sanity
geometry ... FAILED
horology ... FAILED
oidjoins ... FAILED
type_sanity ... FAILED
opr_sanity ... FAILED
test insert ... FAILED
test create_function_1 ... FAILED
test create_type ... FAILED
test create_table ... FAILED
test create_function_2 ... FAILED
parallel group (2 tests): copy copyselect
copy ... FAILED
copyselect ... FAILED
parallel group (8 tests): constraints triggers create_operator create_misc create_aggregate inherit drop_if_exists vacuum
constraints ... FAILED
triggers ... FAILED
create_misc ... FAILED
create_aggregate ... FAILED
create_operator ... FAILED
inherit ... FAILED
vacuum ... FAILED
drop_if_exists ... FAILED
parallel group (2 tests): create_index create_view
create_index ... FAILED
create_view ... FAILED
test sanity_check ... FAILED
test errors ... FAILED
test select ... FAILED
parallel group (20 tests): select_into select_distinct select_distinct_on subselect join select_implicit aggregates select_having case union portals hash_index btree_index arrays transactions namespace random delete prepared_xacts update
select_into ... FAILED
select_distinct ... FAILED
select_distinct_on ... FAILED
select_implicit ... FAILED
select_having ... FAILED
subselect ... FAILED
union ... FAILED
case ... FAILED
join ... FAILED
aggregates ... FAILED
transactions ... FAILED
random ... failed (ignored)
portals ... FAILED
arrays ... FAILED
btree_index ... FAILED
hash_index ... FAILED
update ... FAILED
namespace ... FAILED
prepared_xacts ... FAILED
delete ... FAILED
test privileges ... FAILED
test misc ... FAILED
parallel group (10 tests): select_views foreign_key portals_p2 rules cluster guc dependency combocid tsearch tsdicts
select_views ... FAILED
portals_p2 ... FAILED
rules ... FAILED
foreign_key ... FAILED
cluster ... FAILED
dependency ... FAILED
guc ... FAILED
combocid ... FAILED
tsearch ... FAILED
tsdicts ... FAILED
parallel group (18 tests): plancache limit copy2 temp without_oid plpgsql truncate rangefuncs conversion alter_table prepare domain polymorphism rowtypes largeobject sequence returning xml
plancache ... FAILED
limit ... FAILED
plpgsql ... FAILED
copy2 ... FAILED
temp ... FAILED
domain ... FAILED
rangefuncs ... FAILED
prepare ... FAILED
without_oid ... FAILED
conversion ... FAILED
truncate ... FAILED
alter_table ... FAILED
sequence ... FAILED
polymorphism ... FAILED
rowtypes ... FAILED
returning ... FAILED
largeobject ... FAILED
xml ... FAILED
test stats ... FAILED
test tablespace ... FAILED
============== shutting down postmaster ==============
server stopped=======================================================
114 of 114 tests failed, 1 of these failures ignored.
=======================================================
どうよ、100%だよ、100%、、、。で、試しに現行のバージョンで make check してみると、
=======================
All 103 tests passed.
=======================
んー、まいったねー。まー、案外フツーにインストールできちゃうもんだけど、やっぱ、落ち着かないなぁ。
で、試しに他のサーバでもやってみました。同じハード構成、同じOSのサーバと、全然違うハードでOSもクローンの奴。で、結果。
同一ハード、OS
=======================
All 114 tests passed.
=======================
別ハード、クローンOS
=======================
All 114 tests passed.
=======================
おーい！ どうなってるのん？ なんだんこれは？ んー、なんか不安になってきたぞ、さらに別の奴で実験。
別ハード、クローンOS
=======================
All 114 tests passed.
=======================
、、、やばいのかなぁ、やっぱ。意地になって、別バージョンでコンパイル、 make check してみる。
8.3.1
=======================================================
114 of 114 tests failed, 1 of these failures ignored.
=======================================================
がーん！
8.2.9
=======================
All 103 tests passed.
=======================
およ？
8.3.0
=======================================================
114 of 114 tests failed, 1 of these failures ignored.
=======================================================
がびょーん。なんか、おれ根本的に間違ってるのかなぁ？ なんか8.3から変わったことがあるのかなぁ？ うーん、謎だー。