You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Ruilong Huo (JIRA)" <ji...@apache.org> on 2017/01/17 09:28:26 UTC

[jira] [Comment Edited] (HAWQ-1278) Investigate installcheck-good issue on Mac OSX

    [ https://issues.apache.org/jira/browse/HAWQ-1278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15825631#comment-15825631 ] 

Ruilong Huo edited comment on HAWQ-1278 at 1/17/17 9:27 AM:
------------------------------------------------------------

Had a try with 10.10.5 and 10.11.5, it seems ok. While it is on 10.12.x.
{noformat}
rhuo-mbp:incubator-hawq rhuo$ make installcheck-good
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C src/test installcheck-good
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C regress installcheck-good
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C ../../../src/port all
make[3]: Nothing to be done for `all'.
rm -rf ./testtablespace
mkdir ./testtablespace
./checkinc.py
Greenplum INCLUDEDIR:    /Users/rhuo/Workspace/hawq/hawq-2.0/hawq-db-devel/include
Greenplum PKGINCLUDEDIR: /Users/rhuo/Workspace/hawq/hawq-2.0/hawq-db-devel/include/postgresql
Checking includes...
Include files are ok
cd . && ./makeschedule ./known_good_schedule /Users/rhuo/Repository/git/hawq/incubator-hawq/src/test/regress/current_good_schedule
Writing new schedule '/Users/rhuo/Repository/git/hawq/incubator-hawq/src/test/regress/current_good_schedule'.
rm -rf data/upg_catupgrade_12.sql
perl -pi \
		-e 's/(, )?(indexid|relid|reltype_oid|toast_oid|toast_index|toast_relid|toast_reltype|shared|CamelCase)=[0-9a-zA-Z]+//gi;' \
		-e 's/oid=false//g;' \
		-e 's/with \([^a-zA-Z]*\)//g;' \
		-e 's/\(oid=[0-9]+\)//;' \
		-e 's/tablespace pg_global//g;' \
		-e 's/oids=true, /oids=true/;' \
		-e 's/\(,/(/;' \
 		< ./data/upgrade20/upg2_catupgrade_20.sql.in \
		> data/upg_catupgrade_20.sql
-i used with no filenames on the command line, reading from STDIN.
./pg_regress --inputdir=. --multibyte=    --psqldir=/Users/rhuo/Workspace/hawq/hawq-2.0/hawq-db-devel/bin --schedule=./current_good_schedule --srcdir=/Users/rhuo/Repository/git/hawq/incubator-hawq/src/test/regress --expected-statuses-file=expected_statuses
(using postmaster on Unix socket, port 5432)
============== dropping database "regression"         ==============
NOTICE:  database "regression" does not exist, skipping
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
============== checking optimizer status              ==============
Optimizer enabled. Using optimizer answer files whenever possible
============== running regression test queries        ==============
test errortbl             ... ok (3.99 sec)
test goh_create_type_composite ... ok (1.36 sec)
test goh_toast            ... ok (0.60 sec)
test goh_database         ... ok (2.33 sec)
test goh_gp_dist_random   ... ok (0.10 sec)
test create_table_test    ... ok (0.16 sec)
...
{noformat}


was (Author: huor):
Had a try with 10.10.5, it seems ok:
{noformat}
rhuo-mbp:incubator-hawq rhuo$ make installcheck-good
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C src/test installcheck-good
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C regress installcheck-good
/Applications/Xcode.app/Contents/Developer/usr/bin/make -C ../../../src/port all
make[3]: Nothing to be done for `all'.
rm -rf ./testtablespace
mkdir ./testtablespace
./checkinc.py
Greenplum INCLUDEDIR:    /Users/rhuo/Workspace/hawq/hawq-2.0/hawq-db-devel/include
Greenplum PKGINCLUDEDIR: /Users/rhuo/Workspace/hawq/hawq-2.0/hawq-db-devel/include/postgresql
Checking includes...
Include files are ok
cd . && ./makeschedule ./known_good_schedule /Users/rhuo/Repository/git/hawq/incubator-hawq/src/test/regress/current_good_schedule
Writing new schedule '/Users/rhuo/Repository/git/hawq/incubator-hawq/src/test/regress/current_good_schedule'.
rm -rf data/upg_catupgrade_12.sql
perl -pi \
		-e 's/(, )?(indexid|relid|reltype_oid|toast_oid|toast_index|toast_relid|toast_reltype|shared|CamelCase)=[0-9a-zA-Z]+//gi;' \
		-e 's/oid=false//g;' \
		-e 's/with \([^a-zA-Z]*\)//g;' \
		-e 's/\(oid=[0-9]+\)//;' \
		-e 's/tablespace pg_global//g;' \
		-e 's/oids=true, /oids=true/;' \
		-e 's/\(,/(/;' \
 		< ./data/upgrade20/upg2_catupgrade_20.sql.in \
		> data/upg_catupgrade_20.sql
-i used with no filenames on the command line, reading from STDIN.
./pg_regress --inputdir=. --multibyte=    --psqldir=/Users/rhuo/Workspace/hawq/hawq-2.0/hawq-db-devel/bin --schedule=./current_good_schedule --srcdir=/Users/rhuo/Repository/git/hawq/incubator-hawq/src/test/regress --expected-statuses-file=expected_statuses
(using postmaster on Unix socket, port 5432)
============== dropping database "regression"         ==============
NOTICE:  database "regression" does not exist, skipping
DROP DATABASE
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
============== checking optimizer status              ==============
Optimizer enabled. Using optimizer answer files whenever possible
============== running regression test queries        ==============
test errortbl             ... ok (3.99 sec)
test goh_create_type_composite ... ok (1.36 sec)
test goh_toast            ... ok (0.60 sec)
test goh_database         ... ok (2.33 sec)
test goh_gp_dist_random   ... ok (0.10 sec)
test create_table_test    ... ok (0.16 sec)
...
{noformat}

> Investigate installcheck-good issue on Mac OSX
> ----------------------------------------------
>
>                 Key: HAWQ-1278
>                 URL: https://issues.apache.org/jira/browse/HAWQ-1278
>             Project: Apache HAWQ
>          Issue Type: Task
>          Components: Tests
>            Reporter: Ed Espino
>            Assignee: Ruilong Huo
>             Fix For: 2.1.0.0-incubating
>
>
> I am filing this as a place holder for the Mac OSX installcheck-good investigation work.  Ming Li originally reported installcheck-good testing issues with errtable and hcatalog_lookup test suites.
> This issue is not seen on CentOS 6 & 7 environments.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)