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

2017-02-14 Thread Paul Guo (JIRA) 

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

Paul Guo commented on HAWQ-1278:


To my knowledge, this issue has been resolved. Maybe we could close this one 
now?

> 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.2.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.15#6346)

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

2017-02-03 Thread Ed Espino (JIRA) 

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

Ed Espino commented on HAWQ-1278:
-

[~huor] David now has access to the project's wiki.

> 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.2.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.15#6346)

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

2017-01-18 Thread Ruilong Huo (JIRA) 

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

Ruilong Huo commented on HAWQ-1278:
---

[~espino], did you get a chance to grant access of hawq wiki to David?

> 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.2.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)

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

2017-01-18 Thread David Yozie (JIRA) 

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

David Yozie commented on HAWQ-1278:
---

[~espino][~huor] - It looks like we're still using the wiki 
(https://cwiki.apache.org/confluence/display/HAWQ/HAWQ+Release+2.1.0.0-incubating+Release?show-miniview)
 for publishing release notes.  I'm still trying to edit permissions on the 
wiki.  Nobody on the docs team can edit the wiki content :(

> 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.2.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)

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

2017-01-18 Thread Ruilong Huo (JIRA) 

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

Ruilong Huo commented on HAWQ-1278:
---

[~espino] and [~dyozie], per investigation with [~abai] and [~liming01], the 
root cause is that: 1) error table suite failure is due to gpfidst issue; 2) 
gpfdist failure is due to the client receive no response from gpfdist service 
after the http request is sent. To be specific, there is a bug in curl-7.51.0 
on osx 10.12 while curl-7.43.0 is good on that.

As for doc, we need to add below information:
{noformat}
Know issue: HAWQ-1278: curl 7.51.0 bug on osx 10.12 introduce gpfdist client 
fail to get response from gpfdist service after http request is sent.
The solution: use curl 7.43
{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.2.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)

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

2017-01-18 Thread Ming LI (JIRA) 

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

Ming LI commented on HAWQ-1278:
---

On macOS 10.12.2, after changed curl version from 7.51.0 to 7.43.0, the test 
errortbl ran clean.
So it should be a curl bug on this version of platform. Thanks.

> 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.2.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)

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

2017-01-17 Thread Ed Espino (JIRA) 

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

Ed Espino commented on HAWQ-1278:
-

[~huor] Thanks for the review.  I have updated the Fix Version to 
2.2.0.0-incubating.  We will need to add a note for this issue in the release 
notes for the Apache HAWQ 2.1.0.0-incubating release. Please provide 
information so [~dyozie] can add it.

> 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.2.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)

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

2017-01-17 Thread Ruilong Huo (JIRA) 

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

Ruilong Huo commented on HAWQ-1278:
---

[~espino] and [~dyozie], given the RCA above, it is a known limitation of poll 
and curl on osx 10.12 that make gpfdist malfunction. It is not a blocker as it 
is ok with osx 10.10 and 11.

> 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)

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

2017-01-17 Thread Ruilong Huo (JIRA) 

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

Ruilong Huo commented on HAWQ-1278:
---

Seems poll on 10.12.1 is broken and is fixed in 10.12.2.
https://github.com/curl/curl/issues/1057
https://daniel.haxx.se/blog/2016/10/11/poll-on-mac-10-12-is-broken/

Here is code snippet from the comment that can check if poll is ok.
{noformat}
rhuo-mbp:tmp rhuo$ cat test.c
#include 
#include 
#include 

int main(void)
{
  struct timeval before, after;
  int rc;
  size_t us;

  gettimeofday(&before, NULL);
  rc = poll(NULL, 0, 500);
  gettimeofday(&after, NULL);

  us = (after.tv_sec - before.tv_sec) * 100 +
(after.tv_usec - before.tv_usec);

  if(us < 40) {
puts("poll() is broken");
return 1;
  }
  else {
puts("poll() works");
  }
  return 0;
}

rhuo-mbp:tmp rhuo$ gcc -g -Wall test.c -o test

rhuo-mbp:tmp rhuo$ ./test
poll() works
{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)

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

2017-01-17 Thread Ruilong Huo (JIRA) 

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

Ruilong Huo commented on HAWQ-1278:
---

Potential a curl issue on osx 10.12 with curl 7.51.0. While it is ok on osx 
10.10 ~ 11 with curl 7.43. To be specific, client does not receive response 
after sent http request to server.
{noformat}
 255 static int
 256 check_response(URL_FILE *file, int *rc, const char **response_string)
 257 {
..
 262
 263 /* get the response code from curl */
 264 if (curl_easy_getinfo(curl, CURLINFO_RESPONSE_CODE, &response_code) != 
CURLE_OK)
 265 {
 266 *rc = 500;
 267 *response_string = "curl_easy_getinfo failed";
 268 return -1;
 269 }
..
 277 if (! (200 <= response_code && response_code < 300))
 278 {
 279 if (response_code == 0)
 280 {
 281 longoserrno = 0;
 282 static char connmsg[64];
 283
 284 /* get the os level errno, and string representation of it */
 285 if (curl_easy_getinfo(curl, CURLINFO_OS_ERRNO, &oserrno) == 
CURLE_OK)
 286 {
 287 if (oserrno != 0)
 288 snprintf(connmsg, sizeof connmsg, "error code = %d 
(%s)",
 289  (int) oserrno, strerror((int)oserrno));
 290 }
 291
 292 ereport(ERROR, (errcode(ERRCODE_CONNECTION_FAILURE),
 293 errmsg("connection with gpfdist failed for %s. 
"
 294 "effective url: %s. %s", file->url, 
effective_url,
 295 (oserrno != 0 ? connmsg : "")),
 296 errOmitLocation(true)));
 297 }
{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)

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

2017-01-17 Thread Ruilong Huo (JIRA) 

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

Ruilong Huo commented on HAWQ-1278:
---

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)

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

2017-01-16 Thread Ed Espino (JIRA) 

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

Ed Espino commented on HAWQ-1278:
-

FYI: The hcatalog_lookup test suite requires "hive" and "pxf" services running. 
 The following SQL will cause a core dump on my MacBook Pro (Mac OS Sierra 
10.12.2 and Xcode 8.2.1):

{code}
SELECT * FROM pxf_get_item_fields('Hive', '*');
{code}

> 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)