Menu
▾
▴
Re: [Postgres-xc-general] [patch] patch for pgxc running on FreeBSD
|
From: Jov <am...@am...> - 2014-12-24 03:51:05
|
============== setting connection information ==============
CREATE NODE
CREATE NODE
CREATE NODE
CREATE NODE
CREATE NODE
CREATE NODE
pgxc_pool_reload
------------------
t
(1 row)
pgxc_pool_reload
------------------
t
(1 row)
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries ==============
test tablespace ... ok
parallel group (18 tests): oid name varchar uuid int2 float4 char boolean
txid int4 text money int8 float8 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 ... ok
test strings ... ok
test numerology ... ok
parallel group (19 tests): lseg comments box circle polygon path time
timetz abstime reltime interval tinterval inet point macaddr timestamp
tstypes timestamptz date
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 (6 tests): regex geometry type_sanity horology oidjoins
opr_sanity
geometry ... ok
horology ... ok
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 ... ok
create_view ... ok
test inherit ... ok
parallel group (10 tests): create_cast create_aggregate typed_table
create_function_3 drop_if_exists create_table_like constraints
updatable_views vacuum triggers
create_aggregate ... ok
create_function_3 ... ok
create_cast ... ok
constraints ... ok
triggers ... ok
create_table_like ... ok
typed_table ... ok
vacuum ... ok
drop_if_exists ... ok
updatable_views ... ok
test sanity_check ... ok
test errors ... ok
test select ... ok
parallel group (19 tests): select_distinct_on btree_index select_having
hash_index select_distinct case update delete namespace select_implicit
random transactions select_into union arrays subselect portals join
aggregates
select_into ... ok
select_distinct ... ok
select_distinct_on ... ok
select_implicit ... ok
select_having ... ok
subselect ... ok
union ... ok
case ... ok
join ... FAILED
aggregates ... ok
transactions ... ok
random ... ok
portals ... ok
arrays ... ok
btree_index ... ok
hash_index ... ok
update ... ok
namespace ... ok
delete ... ok
test prepared_xacts ... ok
parallel group (4 tests): security_label collate privileges matview
privileges ... ok
security_label ... ok
collate ... ok
matview ... ok
parallel group (3 tests): psql misc alter_generic
alter_generic ... ok
misc ... ok
psql ... ok
test rules ... ok
test event_trigger ... ok
parallel group (15 tests): combocid xmlmap tsdicts portals_p2 guc
dependency functional_deps cluster json tsearch foreign_data select_views
window 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
json ... FAILED
test advisory_lock ... ok
parallel group (19 tests): largeobject polymorphism prepare limit
returning rowtypes temp plancache conversion copy2 sequence xml truncate
with rangefuncs domain plpgsql alter_table without_oid
plancache ... ok
limit ... ok
plpgsql ... FAILED
copy2 ... ok
temp ... ok
domain ... ok
rangefuncs ... ok
prepare ... ok
without_oid ... ok
conversion ... ok
truncate ... ok
alter_table ... ok
sequence ... ok
polymorphism ... FAILED (test process exited with exit
code 2)
rowtypes ... ok
returning ... ok
largeobject ... FAILED (test process exited with exit
code 2)
with ... ok
xml ... ok
test stats ... ok
test xc_create_function ... ok
test xc_misc ... ok
parallel group (17 tests): xc_params xc_sequence xc_limit xc_constraints
xc_sort xc_having xc_temp xc_copy xc_distkey xc_FQS_join xc_remote xc_FQS
xc_trigship xc_triggers xc_groupby xc_alter_table xc_returning
xc_groupby ... ok
xc_distkey ... ok
xc_having ... ok
xc_temp ... ok
xc_remote ... ok
xc_FQS ... ok
xc_FQS_join ... ok
xc_copy ... ok
xc_alter_table ... ok
xc_sequence ... ok
xc_triggers ... ok
xc_trigship ... ok
xc_constraints ... ok
xc_limit ... ok
xc_sort ... ok
xc_returning ... ok
xc_params ... ok
test xc_node ... ok
test xc_prepared_xacts ... ok
test xc_notrans_block ... ok
============== shutting down postmaster ==============
waiting for server to shut down... done
server stopped
========================
5 of 158 tests failed.
========================
This is regression result on FreeBSD after this patch.
I also run the regression on CentOS6 x86_64，which get 3 of 158 tests failed.
I will check the failed tests later.
Jov
blog: http:amutu.com/blog <http://amutu.com/blog>
2014-12-24 10:39 GMT+08:00 Jov <am...@am...>:
> These changes already exist in PGXL,I port them to PGXC.
>
> the problem this patch solved(common in xl and xc):
> 1.make pgxc_ctl explicit depend bash（report error if there is no bash
> in PATH
> ）
> 2.change '#!/bin/bash' to '#/usr/bin/env bash' for all bash script
> 3.fix build error for missing .h for some type or maroc.
> 4.fix pool send and recv fds which transfer corrupt fds
>
> There also some changes only for PGXC:
> 1.build pgxc_ctl when cd contrib && make
> 2.fix build error for postgresMain which declare as return void but return
> a int.
> 3.fix warning : implicit declaration of function ‘heap_form_tuple’ is
> invalid in C99，which return int for a 64bit pointer，which cause runtime
> error.
>
> ref:
>
> http://sourceforge.net/p/postgres-xl/postgres-xl/ci/9f4da7c3527699ad66ed4af7088faa3ab8fad42c/
>
> http://sourceforge.net/p/postgres-xl/postgres-xl/ci/ccaa2d54927b73ace8efc686ea715daa99a72a76/
>
> http://sourceforge.net/p/postgres-xl/postgres-xl/ci/922f7aba30ee6a15a5cd4dabeeb254614d87d3b6/
>
>
> Jov
> blog: http:amutu.com/blog <http://amutu.com/blog>
>
>
|
