[GitHub] incubator-hawq pull request #1290: HAWQ-1529. Fix segment resource manager h...

2017-09-25 Thread kuien
Github user kuien closed the pull request at: https://github.com/apache/incubator-hawq/pull/1290 ---

[GitHub] incubator-hawq pull request #1292: HAWQ-1532. recognize timezone 'CST' corre...

2017-09-29 Thread kuien
GitHub user kuien opened a pull request: https://github.com/apache/incubator-hawq/pull/1292 HAWQ-1532. recognize timezone 'CST' correctly in China On some platforms, CST (China Standard Time) is used as time string suffix of GMT+8, especially for users in China. I tracked

[GitHub] incubator-hawq pull request #1290: HAWQ-1529. Fix segment resource manager h...

2017-09-25 Thread kuien
GitHub user kuien opened a pull request: https://github.com/apache/incubator-hawq/pull/1290 HAWQ-1529. Fix segment resource manager hang when postmaster died If PostmasterIsAlive() is under implicit declaration, %eax (32-bits) will be used for comparison rather than %al (8-bits

[GitHub] incubator-hawq issue #1292: HAWQ-1532. recognize timezone 'CST' correctly in...

2017-10-19 Thread kuien
Github user kuien commented on the issue: https://github.com/apache/incubator-hawq/pull/1292 On my redhat 7 server, it works like following: psql (8.2.15) Type "help" for help. postgres=# show timezone_abbreviations; timezone_abb

[GitHub] incubator-hawq pull request #1315: HAWQ-1556. enable ALTER SCHEMA RENAME/OWN...

2017-11-29 Thread kuien
GitHub user kuien opened a pull request: https://github.com/apache/incubator-hawq/pull/1315 HAWQ-1556. enable ALTER SCHEMA RENAME/OWNER You can merge this pull request into a Git repository by running: $ git pull https://github.com/kuien/incubator-hawq alter Alternatively

[GitHub] incubator-hawq pull request #1316: HAWQ-1550. Constrain max log file storage...

2017-11-29 Thread kuien
GitHub user kuien opened a pull request: https://github.com/apache/incubator-hawq/pull/1316 HAWQ-1550. Constrain max log file storage/duration A) add guc 'log_max_size' to constrain max log storage B) add guc 'log_max_age' to constraint log size You can merge this pull request

[GitHub] incubator-hawq issue #1292: HAWQ-1532. recognize timezone 'CST' correctly in...

2017-11-29 Thread kuien
Github user kuien commented on the issue: https://github.com/apache/incubator-hawq/pull/1292 @radarwave give me more time on it ... It is not easy for an Internet-engineer to prepare sufficent tests, :( ---

[GitHub] incubator-hawq issue #1315: HAWQ-1556. enable ALTER SCHEMA RENAME/OWNER

2017-11-29 Thread kuien
Github user kuien commented on the issue: https://github.com/apache/incubator-hawq/pull/1315 CI failed with strange error, it seems irrelevant to the pr, is it right? > configure: error: Please install apr from http://apr.apache.org/ and add dir of 'apr-1-config' to

[GitHub] incubator-hawq issue #1292: HAWQ-1532. recognize timezone 'CST' correctly in...

2017-11-30 Thread kuien
Github user kuien commented on the issue: https://github.com/apache/incubator-hawq/pull/1292 @xunzhang @radarwave @linwen please have a look, now this PR is not naked with tests on, LOL Besides, I find the ```./feature-test ``` has a small issue and I record it in https

[GitHub] incubator-hawq issue #1292: HAWQ-1532. recognize timezone 'CST' correctly in...

2017-11-30 Thread kuien
Github user kuien commented on the issue: https://github.com/apache/incubator-hawq/pull/1292 I force to update the commit message body, because the commit id from PG upstream is not correct, should be: > > commit 5b89473d870dc2a9fec0926c5afccf53042dbb0a > Au

[GitHub] incubator-hawq pull request #1324: HAWQ-1573. Clear debug_query_string in pr...

2017-12-14 Thread kuien
GitHub user kuien opened a pull request: https://github.com/apache/incubator-hawq/pull/1324 HAWQ-1573. Clear debug_query_string in proc_exit to avoid crash Backport following commit from PostgreSQL: commit e1eb7c81192bec3735eed3228202b400f31c8010 Author: Tom Lane &l

[GitHub] incubator-hawq pull request #1292: HAWQ-1532. recognize timezone 'CST' corre...

2017-12-14 Thread kuien
Github user kuien closed the pull request at: https://github.com/apache/incubator-hawq/pull/1292 ---

[GitHub] incubator-hawq issue #1311: HAWQ-1549 Fix standby resync when using -M smart...

2017-11-13 Thread kuien
Github user kuien commented on the issue: https://github.com/apache/incubator-hawq/pull/1311 +1 ---

[GitHub] incubator-hawq pull request #1308: HAWQ-1530. Illegally killing a JDBC selec...

2017-11-07 Thread kuien
Github user kuien commented on a diff in the pull request: https://github.com/apache/incubator-hawq/pull/1308#discussion_r149592641 --- Diff: src/backend/cdb/dispatcher.c --- @@ -1414,9 +1415,12 @@ dispatch_cleanup(DispatchData *data) if (dispatcher_is_state_error(data

[GitHub] incubator-hawq issue #1318: HAWQ-1560. Changed log level to DEBUG1 for data ...

2017-12-03 Thread kuien
Github user kuien commented on the issue: https://github.com/apache/incubator-hawq/pull/1318 LGTM ---

[GitHub] incubator-hawq issue #1316: HAWQ-1550. Constrain max log file storage/durati...

2018-05-07 Thread kuien
Github user kuien commented on the issue: https://github.com/apache/incubator-hawq/pull/1316 make sense ---

[GitHub] incubator-hawq pull request #1316: HAWQ-1550. Constrain max log file storage...

2018-05-07 Thread kuien
Github user kuien closed the pull request at: https://github.com/apache/incubator-hawq/pull/1316 ---

[GitHub] incubator-hawq issue #1292: HAWQ-1532. recognize timezone 'CST' correctly in...

2017-10-19 Thread kuien
Github user kuien commented on the issue: https://github.com/apache/incubator-hawq/pull/1292 @radarwave good question, I may need to add the tests as well. ---

[GitHub] incubator-hawq pull request #1331: HAWQ-1557. Concurrent drop should not rep...

2018-01-22 Thread kuien
GitHub user kuien opened a pull request: https://github.com/apache/incubator-hawq/pull/1331 HAWQ-1557. Concurrent drop should not report error for drop IF EXISTS. Concurrent drop should not report error for drop IF EXISTS. The reason is: relation can potential be dropped or altered

[GitHub] incubator-hawq pull request #1331: HAWQ-1557. Concurrent drop should not rep...

2018-02-06 Thread kuien
Github user kuien closed the pull request at: https://github.com/apache/incubator-hawq/pull/1331 ---

[GitHub] incubator-hawq pull request #1325: HAWQ-1125. Running pl/python related feat...

2017-12-28 Thread kuien
GitHub user kuien opened a pull request: https://github.com/apache/incubator-hawq/pull/1325 HAWQ-1125. Running pl/python related feature_test cases in parallel Prior commit: dc14ecbafc368a45cda5806ef7680ffe0825aef1 You can merge this pull request into a Git repository by running

[GitHub] incubator-hawq pull request #1324: HAWQ-1573. Clear debug_query_string in pr...

2018-01-23 Thread kuien
Github user kuien closed the pull request at: https://github.com/apache/incubator-hawq/pull/1324 ---

[GitHub] incubator-hawq issue #1325: HAWQ-1125. Running pl/python related feature_tes...

2018-01-23 Thread kuien
Github user kuien commented on the issue: https://github.com/apache/incubator-hawq/pull/1325 Thanks @radarwave ---

[GitHub] incubator-hawq pull request #1325: HAWQ-1125. Running pl/python related feat...

2018-01-23 Thread kuien
Github user kuien closed the pull request at: https://github.com/apache/incubator-hawq/pull/1325 ---

[jira] [Commented] (HAWQ-1528) Support read on writable external table

2017-09-19 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1528?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16171463#comment-16171463 ] Kuien Liu commented on HAWQ-1528: - I guess, then comes with consistency issues, :) > Support r

[jira] [Created] (HAWQ-1529) "segment resource manager" will NOT exit when postmaster died

2017-09-19 Thread Kuien Liu (JIRA)
Kuien Liu created HAWQ-1529: --- Summary: "segment resource manager" will NOT exit when postmaster died Key: HAWQ-1529 URL: https://issues.apache.org/jira/browse/HAWQ-1529 Project: Apache HAWQ

[jira] [Comment Edited] (HAWQ-1529) "segment resource manager" will NOT exit when postmaster died

2017-09-25 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16178608#comment-16178608 ] Kuien Liu edited comment on HAWQ-1529 at 9/25/17 8:31 AM: -- A possible patch looks

[jira] [Commented] (HAWQ-1529) "segment resource manager" will NOT exit when postmaster died

2017-09-25 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16178730#comment-16178730 ] Kuien Liu commented on HAWQ-1529: - Without include pmsignal.h, 32 bits of return (PostmasterIsAlive

[jira] [Created] (HAWQ-1532) Recognize CST incorrectly when quey timestamp with time zone in China

2017-09-29 Thread Kuien Liu (JIRA)
Kuien Liu created HAWQ-1532: --- Summary: Recognize CST incorrectly when quey timestamp with time zone in China Key: HAWQ-1532 URL: https://issues.apache.org/jira/browse/HAWQ-1532 Project: Apache HAWQ

[jira] [Closed] (HAWQ-1529) "segment resource manager" will NOT exit when postmaster died

2017-09-25 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1529?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kuien Liu closed HAWQ-1529. --- Resolution: Fixed Fix Version/s: backlog https://github.com/apache/incubator-hawq/pull/1290 > "

[jira] [Commented] (HAWQ-1529) "segment resource manager" will NOT exit when postmaster died

2017-09-25 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16180172#comment-16180172 ] Kuien Liu commented on HAWQ-1529: - https://github.com/apache/incubator-hawq/pull/1290 has been marged

[jira] [Comment Edited] (HAWQ-1529) "segment resource manager" will NOT exit when postmaster died

2017-09-25 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16178608#comment-16178608 ] Kuien Liu edited comment on HAWQ-1529 at 9/25/17 6:52 AM: -- A possible patch looks

[jira] [Commented] (HAWQ-1529) "segment resource manager" will NOT exit when postmaster died

2017-09-24 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16178535#comment-16178535 ] Kuien Liu commented on HAWQ-1529: - After I kill -9 postmaster @ sgement, the segment log prints following

[jira] [Commented] (HAWQ-1529) "segment resource manager" will NOT exit when postmaster died

2017-09-25 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16178608#comment-16178608 ] Kuien Liu commented on HAWQ-1529: - A possible patch looks strange but does work. {code:c} --- a/src

[jira] [Created] (HAWQ-1551) issue on DROP TABLE when the table is altering by other session

2017-11-14 Thread Kuien Liu (JIRA)
Kuien Liu created HAWQ-1551: --- Summary: issue on DROP TABLE when the table is altering by other session Key: HAWQ-1551 URL: https://issues.apache.org/jira/browse/HAWQ-1551 Project: Apache HAWQ

[jira] [Created] (HAWQ-1556) Support more statements with ALTER OWNER

2017-11-28 Thread Kuien Liu (JIRA)
Kuien Liu created HAWQ-1556: --- Summary: Support more statements with ALTER OWNER Key: HAWQ-1556 URL: https://issues.apache.org/jira/browse/HAWQ-1556 Project: Apache HAWQ Issue Type: New Feature

[jira] [Commented] (HAWQ-1556) Support more statements with ALTER OWNER

2017-11-28 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16268664#comment-16268664 ] Kuien Liu commented on HAWQ-1556: - I have done a quick-test, proved these feature (e.g., ALTER SCHEMA OWNER

[jira] [Commented] (HAWQ-1556) Support more statements with ALTER OWNER

2017-11-28 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16270256#comment-16270256 ] Kuien Liu commented on HAWQ-1556: - A coarse way to bypass it is to use REASSIGN: REASSIGN OWNED

[jira] [Created] (HAWQ-1557) DROP TABLE IF EXISTS issues ERROR report

2017-11-28 Thread Kuien Liu (JIRA)
Kuien Liu created HAWQ-1557: --- Summary: DROP TABLE IF EXISTS issues ERROR report Key: HAWQ-1557 URL: https://issues.apache.org/jira/browse/HAWQ-1557 Project: Apache HAWQ Issue Type: Bug

[jira] [Created] (HAWQ-1558) feature-test result is not environment independent

2017-11-30 Thread Kuien Liu (JIRA)
Kuien Liu created HAWQ-1558: --- Summary: feature-test result is not environment independent Key: HAWQ-1558 URL: https://issues.apache.org/jira/browse/HAWQ-1558 Project: Apache HAWQ Issue Type: Bug

[jira] [Updated] (HAWQ-1558) feature-test result is not environment independent

2017-11-30 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kuien Liu updated HAWQ-1558: Description: When I run ./feature-test with seperate test, for example, 1. {{ ./feature-test --gtest_filter

[jira] [Updated] (HAWQ-1558) feature-test result is not environment independent

2017-11-30 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kuien Liu updated HAWQ-1558: Description: When I run ./feature-test with seperate test, for example, 1. {{./feature-test --gtest_filter

[jira] [Commented] (HAWQ-127) Create CI projects for HAWQ releases

2017-11-30 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16272462#comment-16272462 ] Kuien Liu commented on HAWQ-127: Looking for much more abundant tests, CI/UT is not enough, we'd better

[jira] [Created] (HAWQ-1573) crash during proc_exit when write message to server log

2017-12-14 Thread Kuien Liu (JIRA)
Kuien Liu created HAWQ-1573: --- Summary: crash during proc_exit when write message to server log Key: HAWQ-1573 URL: https://issues.apache.org/jira/browse/HAWQ-1573 Project: Apache HAWQ Issue Type

[jira] [Created] (HAWQ-1550) Query on hawq_toolkit.hawq_log_master_concise is slower as time going

2017-11-13 Thread Kuien Liu (JIRA)
Kuien Liu created HAWQ-1550: --- Summary: Query on hawq_toolkit.hawq_log_master_concise is slower as time going Key: HAWQ-1550 URL: https://issues.apache.org/jira/browse/HAWQ-1550 Project: Apache HAWQ

[jira] [Commented] (HAWQ-1530) Illegally killing a JDBC select query causes locking problems

2017-11-06 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16241605#comment-16241605 ] Kuien Liu commented on HAWQ-1530: - My partner, Zhiyong Dai, has prepared a case to reproduce this issue: 1

[jira] [Commented] (HAWQ-1530) Illegally killing a JDBC select query causes locking problems

2017-11-02 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16235451#comment-16235451 ] Kuien Liu commented on HAWQ-1530: - any progress on this issue? plz prioritize it if possible, thanks

[jira] [Commented] (HAWQ-1558) feature-test result is not environment independent

2017-12-01 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16274275#comment-16274275 ] Kuien Liu commented on HAWQ-1558: - Yes, but it is not a good behavior that we split one utility tool

[jira] [Comment Edited] (HAWQ-1558) feature-test result is not environment independent

2017-12-01 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16274275#comment-16274275 ] Kuien Liu edited comment on HAWQ-1558 at 12/1/17 12:05 PM: --- Yes

[jira] [Created] (HAWQ-1567) Unknown process holds the lock causes DROP TABLE hangs forever

2017-12-05 Thread Kuien Liu (JIRA)
Kuien Liu created HAWQ-1567: --- Summary: Unknown process holds the lock causes DROP TABLE hangs forever Key: HAWQ-1567 URL: https://issues.apache.org/jira/browse/HAWQ-1567 Project: Apache HAWQ

[jira] [Commented] (HAWQ-1567) Unknown process holds the lock causes DROP TABLE hangs forever

2017-12-05 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16279759#comment-16279759 ] Kuien Liu commented on HAWQ-1567: - Thanks to [~yjin] and [~wlin], I will keep an eye on it, once it hangs

[jira] [Commented] (HAWQ-1450) New HAWQ executor with vectorization & possible code generation

2018-01-22 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1450?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16335442#comment-16335442 ] Kuien Liu commented on HAWQ-1450: - Great! Looking forward to this amazing feature. It is a goog opportunity

[jira] [Closed] (HAWQ-1557) DROP TABLE IF EXISTS issues ERROR report

2018-02-06 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kuien Liu closed HAWQ-1557. --- Resolution: Fixed Fix Version/s: backlog > DROP TABLE IF EXISTS issues ERROR rep

[jira] [Commented] (HAWQ-1450) New HAWQ executor with vectorization & possible code generation

2018-02-25 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1450?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16376440#comment-16376440 ] Kuien Liu commented on HAWQ-1450: - Nice doc, clear design. It is a good start. > New HAWQ execu

[jira] [Commented] (HAWQ-1125) Running pl/python related feature_test cases in parallel failed with error "cache lookup failed for language"

2017-12-28 Thread Kuien Liu (JIRA)
[ https://issues.apache.org/jira/browse/HAWQ-1125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16305247#comment-16305247 ] Kuien Liu commented on HAWQ-1125: - On our pipeline (I build it with Jenkins 3.x), I meet two kinds