[ https://issues.apache.org/jira/browse/HAWQ-358?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15212132#comment-15212132 ]
xin zhang edited comment on HAWQ-358 at 3/25/16 6:12 PM: --------------------------------------------------------- At this moment, only two tests failed on OSX (not on Linux) {code} test exttab1 ... FAILED (11.18 sec) test hcatalog_lookup ... FAILED (0.71 sec) (test process exited with unexpected exit code 2, but was expected exit code 0) {code} {code} ======================= 2 of 56 tests failed. ======================= {code} The regression.diffs is: {code} *** ./expected/exttab1_optimizer.out 2016-03-25 10:23:17.000000000 -0700 --- ./results/exttab1.out 2016-03-25 10:23:17.000000000 -0700 *************** *** 610,617 **** --drop foreign table ext; -- should fail (wrong object) --drop external table ext; ---------------------------------------------------------------------- ! r_name ! MIDDLE EAST -- -- -- --- 599,606 ---- --drop foreign table ext; -- should fail (wrong object) --drop external table ext; ---------------------------------------------------------------------- ! x ! Okay, gpfdist version "2.0.0.0_beta build dev" is running on localhost:7070. -- -- -- *************** *** 673,680 **** -- in between runs, so we don't check for count(*), and instead check for distinct. -- negative -- positive ! --------------------------- ---------------------------------------------------------------------- ERROR: location uri "gpfdist://localhost:7070/wet.out" appears more than once ERROR: the ON segment syntax for writable external tables is deprecated ERROR: the file protocol for external tables is deprecated --- 662,670 ---- -- in between runs, so we don't check for count(*), and instead check for distinct. -- negative -- positive ! -- start_ignore ---------------------------------------------------------------------- + ------------------------------------------------------------------------------ ERROR: location uri "gpfdist://localhost:7070/wet.out" appears more than once ERROR: the ON segment syntax for writable external tables is deprecated ERROR: the file protocol for external tables is deprecated *************** *** 690,720 **** create writable external table wet_pos3(like wet_pos2) location('gpfdist://localhost:7070/wet.out') format 'text' distributed by(a,b); create writable external table wet_region(like reg_region) location('gpfdist://localhost:7070/wet_region.out') format 'text'; create writable external web table wet_pos5(a text, b text) execute 'some command' on segment 0 format 'text'; select * from wet_pos1; (1 row) ! GP_IGNORE:-- start_ignore ! GP_IGNORE:select * from gpfdist_status; ! GP_IGNORE: x ! GP_IGNORE:-------------------------------------------------------------------------- ! GP_IGNORE: Okay, gpfdist version "1.3.0.0 build dev" is running on localhost:7070. ! GP_IGNORE:(1 row) ! GP_IGNORE: ! GP_IGNORE:select * from gpfdist_stop; ! GP_IGNORE: x ! GP_IGNORE:------------- ! GP_IGNORE: stopping... ! GP_IGNORE:(1 row) ! GP_IGNORE: ! GP_IGNORE:select * from gpfdist_status; ! GP_IGNORE: x ! GP_IGNORE:------------------------------------------------------ ! GP_IGNORE: Error: gpfdist is not running (reason: socket error) ! GP_IGNORE: Exit: 1 ! GP_IGNORE: ! GP_IGNORE:(3 rows) ! GP_IGNORE: ! GP_IGNORE:-- end_ignore -- -- get an error for missing gpfdist -- --- 680,704 ---- create writable external table wet_pos3(like wet_pos2) location('gpfdist://localhost:7070/wet.out') format 'text' distributed by(a,b); create writable external table wet_region(like reg_region) location('gpfdist://localhost:7070/wet_region.out') format 'text'; create writable external web table wet_pos5(a text, b text) execute 'some command' on segment 0 format 'text'; + select * from gpfdist_status; select * from wet_pos1; (1 row) ! select * from gpfdist_stop; ! x ! ------------- ! stopping... ! (1 row) ! ! select * from gpfdist_status; ! x ! ------------------------------------------------------ ! ! Error: gpfdist is not running (reason: socket error) ! Exit: 1 ! (3 rows) ! ! -- end_ignore -- -- get an error for missing gpfdist -- ====================================================================== *** ./expected/hcatalog_lookup.out 2016-03-25 10:23:55.000000000 -0700 --- ./results/hcatalog_lookup.out 2016-03-25 10:23:55.000000000 -0700 *************** *** 13,22 **** -- enable GUC SET hcatalog_enable = true; SELECT * FROM pxf_get_item_fields('Hive', '*abc*abc*'); ! path | itemname | fieldname | fieldtype ! ------+----------+-----------+----------- ! (0 rows) ! -- Create function to insert and scan in-memory data to pg_class CREATE OR REPLACE FUNCTION convert_to_hcatalog_schema(schemaName text) RETURNS text AS '/Users/xzhang/workspace/incubator-hawq/src/test/regress/regress.so', 'convert_to_hcatalog_schema' --- 13,19 ---- -- enable GUC SET hcatalog_enable = true; SELECT * FROM pxf_get_item_fields('Hive', '*abc*abc*'); ! ERROR: remote component error (0): (SOMEFILE:SOMEFUNC) -- Create function to insert and scan in-memory data to pg_class CREATE OR REPLACE FUNCTION convert_to_hcatalog_schema(schemaName text) RETURNS text AS '/Users/xzhang/workspace/incubator-hawq/src/test/regress/regress.so', 'convert_to_hcatalog_schema' ====================================================================== {code} was (Author: xzhang.pivotal): At this moment, only two tests failed: {code} test exttab1 ... FAILED (11.18 sec) test hcatalog_lookup ... FAILED (0.71 sec) (test process exited with unexpected exit code 2, but was expected exit code 0) {code} {code} ======================= 2 of 56 tests failed. ======================= {code} The regression.diffs is: {code} *** ./expected/exttab1_optimizer.out 2016-03-25 10:23:17.000000000 -0700 --- ./results/exttab1.out 2016-03-25 10:23:17.000000000 -0700 *************** *** 610,617 **** --drop foreign table ext; -- should fail (wrong object) --drop external table ext; ---------------------------------------------------------------------- ! r_name ! MIDDLE EAST -- -- -- --- 599,606 ---- --drop foreign table ext; -- should fail (wrong object) --drop external table ext; ---------------------------------------------------------------------- ! x ! Okay, gpfdist version "2.0.0.0_beta build dev" is running on localhost:7070. -- -- -- *************** *** 673,680 **** -- in between runs, so we don't check for count(*), and instead check for distinct. -- negative -- positive ! --------------------------- ---------------------------------------------------------------------- ERROR: location uri "gpfdist://localhost:7070/wet.out" appears more than once ERROR: the ON segment syntax for writable external tables is deprecated ERROR: the file protocol for external tables is deprecated --- 662,670 ---- -- in between runs, so we don't check for count(*), and instead check for distinct. -- negative -- positive ! -- start_ignore ---------------------------------------------------------------------- + ------------------------------------------------------------------------------ ERROR: location uri "gpfdist://localhost:7070/wet.out" appears more than once ERROR: the ON segment syntax for writable external tables is deprecated ERROR: the file protocol for external tables is deprecated *************** *** 690,720 **** create writable external table wet_pos3(like wet_pos2) location('gpfdist://localhost:7070/wet.out') format 'text' distributed by(a,b); create writable external table wet_region(like reg_region) location('gpfdist://localhost:7070/wet_region.out') format 'text'; create writable external web table wet_pos5(a text, b text) execute 'some command' on segment 0 format 'text'; select * from wet_pos1; (1 row) ! GP_IGNORE:-- start_ignore ! GP_IGNORE:select * from gpfdist_status; ! GP_IGNORE: x ! GP_IGNORE:-------------------------------------------------------------------------- ! GP_IGNORE: Okay, gpfdist version "1.3.0.0 build dev" is running on localhost:7070. ! GP_IGNORE:(1 row) ! GP_IGNORE: ! GP_IGNORE:select * from gpfdist_stop; ! GP_IGNORE: x ! GP_IGNORE:------------- ! GP_IGNORE: stopping... ! GP_IGNORE:(1 row) ! GP_IGNORE: ! GP_IGNORE:select * from gpfdist_status; ! GP_IGNORE: x ! GP_IGNORE:------------------------------------------------------ ! GP_IGNORE: Error: gpfdist is not running (reason: socket error) ! GP_IGNORE: Exit: 1 ! GP_IGNORE: ! GP_IGNORE:(3 rows) ! GP_IGNORE: ! GP_IGNORE:-- end_ignore -- -- get an error for missing gpfdist -- --- 680,704 ---- create writable external table wet_pos3(like wet_pos2) location('gpfdist://localhost:7070/wet.out') format 'text' distributed by(a,b); create writable external table wet_region(like reg_region) location('gpfdist://localhost:7070/wet_region.out') format 'text'; create writable external web table wet_pos5(a text, b text) execute 'some command' on segment 0 format 'text'; + select * from gpfdist_status; select * from wet_pos1; (1 row) ! select * from gpfdist_stop; ! x ! ------------- ! stopping... ! (1 row) ! ! select * from gpfdist_status; ! x ! ------------------------------------------------------ ! ! Error: gpfdist is not running (reason: socket error) ! Exit: 1 ! (3 rows) ! ! -- end_ignore -- -- get an error for missing gpfdist -- ====================================================================== *** ./expected/hcatalog_lookup.out 2016-03-25 10:23:55.000000000 -0700 --- ./results/hcatalog_lookup.out 2016-03-25 10:23:55.000000000 -0700 *************** *** 13,22 **** -- enable GUC SET hcatalog_enable = true; SELECT * FROM pxf_get_item_fields('Hive', '*abc*abc*'); ! path | itemname | fieldname | fieldtype ! ------+----------+-----------+----------- ! (0 rows) ! -- Create function to insert and scan in-memory data to pg_class CREATE OR REPLACE FUNCTION convert_to_hcatalog_schema(schemaName text) RETURNS text AS '/Users/xzhang/workspace/incubator-hawq/src/test/regress/regress.so', 'convert_to_hcatalog_schema' --- 13,19 ---- -- enable GUC SET hcatalog_enable = true; SELECT * FROM pxf_get_item_fields('Hive', '*abc*abc*'); ! ERROR: remote component error (0): (SOMEFILE:SOMEFUNC) -- Create function to insert and scan in-memory data to pg_class CREATE OR REPLACE FUNCTION convert_to_hcatalog_schema(schemaName text) RETURNS text AS '/Users/xzhang/workspace/incubator-hawq/src/test/regress/regress.so', 'convert_to_hcatalog_schema' ====================================================================== {code} > Installcheck good failures in hawq-dev environment > -------------------------------------------------- > > Key: HAWQ-358 > URL: https://issues.apache.org/jira/browse/HAWQ-358 > Project: Apache HAWQ > Issue Type: Bug > Components: Tests > Reporter: Caleb Welton > Assignee: Ruilong Huo > Fix For: backlog > > > Build and test within a hawq dev environment setup via the instructions > outlined in the hawq-devel docker enviroment: > https://hub.docker.com/r/mayjojo/hawq-devel/ > Results in the following errors > {noformat} > ... > test errortbl ... FAILED (6.83 sec) > ... > test subplan ... FAILED (8.15 sec) > ... > test create_table_distribution ... FAILED (3.47 sec) > test copy ... FAILED (34.76 sec) > ... > test set_functions ... FAILED (4.90 sec) > ... > test exttab1 ... FAILED (17.66 sec) > ... > {noformat} > Summary of issues: > * *errortbl* - every connection to gpfdist results in "connection with > gpfdist failed for gpfdist://localhost:7070/nation.tbl" > * *subplan* - trying to create plpython resulted in "could not access file > "$libdir/plpython": No such file or directory", lack of plpython causes many > other statements to fail > * *create_table_distribution* - test likely needs some refactoring to reflect > calculating correct bucketnum based on current system configuration > * *copy* - seems to be failing because rows aren't coming out in the expected > order, test needs fixing to be able to handle this > * *set_functions* - same plpythonu issue described above > * *exttab1* - same issue reading from gpfdist described above -- This message was sent by Atlassian JIRA (v6.3.4#6332)