[jira] [Resolved] (HAWQ-811) Redefine execute interface in sql_util.h of feature test library to support returning error message.
[ https://issues.apache.org/jira/browse/HAWQ-811?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongwu resolved HAWQ-811. - Resolution: Done > Redefine execute interface in sql_util.h of feature test library to support > returning error message. > > > Key: HAWQ-811 > URL: https://issues.apache.org/jira/browse/HAWQ-811 > Project: Apache HAWQ > Issue Type: Improvement >Reporter: hongwu >Assignee: hongwu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-810) Add string format for feature test library
[ https://issues.apache.org/jira/browse/HAWQ-810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongwu resolved HAWQ-810. - Resolution: Done > Add string format for feature test library > -- > > Key: HAWQ-810 > URL: https://issues.apache.org/jira/browse/HAWQ-810 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: hongwu >Assignee: hongwu > > For example, define a string: > {noformat} > std::string s = stringFormat("hello %s %s world", "xunzhang", "wuhong"); > {noformat} > instead of: > {noformat} > std::string s = "hello" + "xunzhang" + "wuhong" + "world"; > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq pull request #:
Github user xunzhang commented on the pull request: https://github.com/apache/incubator-hawq/commit/0d754a43709160410f5d1d40d0f0f5535c2b1c84#commitcomment-17855074 https://github.com/apache/incubator-hawq/pull/708 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Commented] (HAWQ-811) Redefine execute interface in sql_util.h of feature test library to support returning error message.
[ https://issues.apache.org/jira/browse/HAWQ-811?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15328956#comment-15328956 ] ASF GitHub Bot commented on HAWQ-811: - Github user xunzhang closed the pull request at: https://github.com/apache/incubator-hawq/pull/708 > Redefine execute interface in sql_util.h of feature test library to support > returning error message. > > > Key: HAWQ-811 > URL: https://issues.apache.org/jira/browse/HAWQ-811 > Project: Apache HAWQ > Issue Type: Improvement >Reporter: hongwu >Assignee: hongwu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-811) Redefine execute interface in sql_util.h of feature test library to support returning error message.
[ https://issues.apache.org/jira/browse/HAWQ-811?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15328955#comment-15328955 ] ASF GitHub Bot commented on HAWQ-811: - Github user xunzhang commented on the issue: https://github.com/apache/incubator-hawq/pull/708 Merged into master. > Redefine execute interface in sql_util.h of feature test library to support > returning error message. > > > Key: HAWQ-811 > URL: https://issues.apache.org/jira/browse/HAWQ-811 > Project: Apache HAWQ > Issue Type: Improvement >Reporter: hongwu >Assignee: hongwu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq pull request #:
Github user xunzhang commented on the pull request: https://github.com/apache/incubator-hawq/commit/9f7a3a427ab8b4f0eb85cb88f1c64a6ec973fe2b#commitcomment-17855071 https://github.com/apache/incubator-hawq/pull/707 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Commented] (HAWQ-810) Add string format for feature test library
[ https://issues.apache.org/jira/browse/HAWQ-810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15328953#comment-15328953 ] ASF GitHub Bot commented on HAWQ-810: - Github user xunzhang commented on the issue: https://github.com/apache/incubator-hawq/pull/707 Merged into master. > Add string format for feature test library > -- > > Key: HAWQ-810 > URL: https://issues.apache.org/jira/browse/HAWQ-810 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: hongwu >Assignee: hongwu > > For example, define a string: > {noformat} > std::string s = stringFormat("hello %s %s world", "xunzhang", "wuhong"); > {noformat} > instead of: > {noformat} > std::string s = "hello" + "xunzhang" + "wuhong" + "world"; > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-810) Add string format for feature test library
[ https://issues.apache.org/jira/browse/HAWQ-810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15328954#comment-15328954 ] ASF GitHub Bot commented on HAWQ-810: - Github user xunzhang closed the pull request at: https://github.com/apache/incubator-hawq/pull/707 > Add string format for feature test library > -- > > Key: HAWQ-810 > URL: https://issues.apache.org/jira/browse/HAWQ-810 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: hongwu >Assignee: hongwu > > For example, define a string: > {noformat} > std::string s = stringFormat("hello %s %s world", "xunzhang", "wuhong"); > {noformat} > instead of: > {noformat} > std::string s = "hello" + "xunzhang" + "wuhong" + "world"; > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq pull request #708: HAWQ-811. Refactor execute interface in sq...
Github user xunzhang closed the pull request at: https://github.com/apache/incubator-hawq/pull/708 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-hawq issue #708: HAWQ-811. Refactor execute interface in sql_util ...
Github user xunzhang commented on the issue: https://github.com/apache/incubator-hawq/pull/708 Merged into master. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-hawq pull request #707: HAWQ-810. Add stringFormat for feature tes...
Github user xunzhang closed the pull request at: https://github.com/apache/incubator-hawq/pull/707 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-hawq issue #707: HAWQ-810. Add stringFormat for feature test libra...
Github user xunzhang commented on the issue: https://github.com/apache/incubator-hawq/pull/707 Merged into master. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Updated] (HAWQ-812) Activate standby master failed after create a new database
[ https://issues.apache.org/jira/browse/HAWQ-812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunling Wang updated HAWQ-812: --- Description: Activate standby master failed after create a new database. However, it will success if we do not create a new database even we create a new table and insert data. 1. Create a new database 'gptest' {code} [gpadmin@test1 ~]$ psql -l List of databases Name| Owner | Encoding | Access privileges ---+-+--+--- postgres | gpadmin | UTF8 | template0 | gpadmin | UTF8 | template1 | gpadmin | UTF8 | (3 rows) [gpadmin@test1 ~]$ createdb gptest [gpadmin@test1 ~]$ psql -l List of databases Name| Owner | Encoding | Access privileges ---+-+--+--- gptest| gpadmin | UTF8 | postgres | gpadmin | UTF8 | template0 | gpadmin | UTF8 | template1 | gpadmin | UTF8 | (4 rows) {code} 2. Stop HAWQ master {code} [gpadmin@test1 ~]$ hawq stop master -a 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Prepare to do 'hawq stop' 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-You can find log in: 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20160613.log 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-GPHOME is set to: 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/. 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq with args: ['stop', 'master'] 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-There are 0 connections to the database 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart' 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Master host=test1 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq master 20160613:20:13:46:068559 hawq_stop:test1:gpadmin-[INFO]:-Master stopped successfully {code} 3. Activate standby master {code} [gpadmin@test1 ~]$ ssh test5 'source /data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/./greenplum_path.sh; hawq activate standby -a' 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Prepare to do 'hawq activate' 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-You can find log in: 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_activate_20160613.log 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-GPHOME is set to: 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/. 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Activate hawq with args: ['activate', 'standby'] 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Starting to activate standby master 'test5' 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-HAWQ master is not running, skip 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping all the running segments 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:- 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping running standby 20160613:20:14:23:126841 hawq_activate:test5:gpadmin-[INFO]:-Update master host name in hawq-site.xml 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-GUC hawq_master_address_host already exist in hawq-site.xml Update it with value: test5 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-Remove current standby from hawq-site.xml 20160613:20:14:39:126841 hawq_activate:test5:gpadmin-[INFO]:-Start master in master only mode {code} It hangs and can not start master. And the master log is following: {code} 2016-06-13 20:14:40.268022 PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","database system was shut down at 2016-06-13 20:02:50 PDT",,,0,,"xlog.c",6205, 2016-06-13 20:14:40.268112 PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","found recovery.conf file indicating standby takeover recovery needed",,,0,,"xlog.c",5485, 2016-06-13 20:14:40.268131 PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","checkpoint record is at 0/1C75EF0",,,0,,"xlog.c",6304, 2016-06-13 20:14:40.268143 PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","redo record is at 0/1C75EF0; undo record is at 0/0; shutdown TRUE",,,0,,"xlog.c",6338, 2016-06-13 20:14:40.268155 PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","next transaction ID: 0/1003; next OID: 16508&q
[jira] [Closed] (HAWQ-813) Activate standby master failed after create a new database
[ https://issues.apache.org/jira/browse/HAWQ-813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunling Wang closed HAWQ-813. -- Resolution: Invalid > Activate standby master failed after create a new database > -- > > Key: HAWQ-813 > URL: https://issues.apache.org/jira/browse/HAWQ-813 > Project: Apache HAWQ > Issue Type: Bug > Components: Backup & restore >Reporter: Chunling Wang >Assignee: Lei Chang > > Activate standby master failed after create a new database. However, it will > success if we do not create a new database even we create a new table and > insert data. > 1. Create a new database 'gptest' > {code} > [gpadmin@test1 ~]$ psql -l > List of databases >Name| Owner | Encoding | Access privileges > ---+-+--+--- > postgres | gpadmin | UTF8 | > template0 | gpadmin | UTF8 | > template1 | gpadmin | UTF8 | > (3 rows) > [gpadmin@test1 ~]$ createdb gptest > [gpadmin@test1 ~]$ psql -l > List of databases >Name| Owner | Encoding | Access privileges > ---+-+--+--- > gptest| gpadmin | UTF8 | > postgres | gpadmin | UTF8 | > template0 | gpadmin | UTF8 | > template1 | gpadmin | UTF8 | > (4 rows) > {code} > 2. Stop HAWQ master > {code} > [gpadmin@test1 ~]$ hawq stop master -a > 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Prepare to do 'hawq > stop' > 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-You can find log in: > 20160613:20:13:44:068559 > hawq_stop:test1:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20160613.log > 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-GPHOME is set to: > 20160613:20:13:44:068559 > hawq_stop:test1:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/. > 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq with args: > ['stop', 'master'] > 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-There are 0 > connections to the database > 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Commencing Master > instance shutdown with mode='smart' > 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Master host=test1 > 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq master > 20160613:20:13:46:068559 hawq_stop:test1:gpadmin-[INFO]:-Master stopped > successfully > {code} > 3. Activate standby master > {code} > [gpadmin@test1 ~]$ ssh test5 'source > /data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/./greenplum_path.sh; > hawq activate standby -a' > 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Prepare to do > 'hawq activate' > 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-You can find log > in: > 20160613:20:14:14:126841 > hawq_activate:test5:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_activate_20160613.log > 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-GPHOME is set to: > 20160613:20:14:14:126841 > hawq_activate:test5:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/. > 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Activate hawq > with args: ['activate', 'standby'] > 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Starting to > activate standby master 'test5' > 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-HAWQ master is > not running, skip > 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping all the > running segments > 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:- > 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping running > standby > 20160613:20:14:23:126841 hawq_activate:test5:gpadmin-[INFO]:-Update master > host name in hawq-site.xml > 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-GUC > hawq_master_address_host already exist in hawq-site.xml > Update it with value: test5 > 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-Remove current > standby from hawq-site.xml > 20160613:20:14:39:126841 hawq_activate:test5:gpadmin-[INFO]:-Start master in > master only mode > {code} > It hangs and can not start master. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-812) Activate standby master failed after create a new database
[ https://issues.apache.org/jira/browse/HAWQ-812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunling Wang updated HAWQ-812: --- Description: Activate standby master failed after create a new database. However, it will success if we do not create a new database even we create a new table and insert data. 1. Create a new database 'gptest' {code} [gpadmin@test1 ~]$ psql -l List of databases Name| Owner | Encoding | Access privileges ---+-+--+--- postgres | gpadmin | UTF8 | template0 | gpadmin | UTF8 | template1 | gpadmin | UTF8 | (3 rows) [gpadmin@test1 ~]$ createdb gptest [gpadmin@test1 ~]$ psql -l List of databases Name| Owner | Encoding | Access privileges ---+-+--+--- gptest| gpadmin | UTF8 | postgres | gpadmin | UTF8 | template0 | gpadmin | UTF8 | template1 | gpadmin | UTF8 | (4 rows) {code} 2. Stop HAWQ master {code} [gpadmin@test1 ~]$ hawq stop master -a 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Prepare to do 'hawq stop' 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-You can find log in: 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20160613.log 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-GPHOME is set to: 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/. 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq with args: ['stop', 'master'] 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-There are 0 connections to the database 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart' 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Master host=test1 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq master 20160613:20:13:46:068559 hawq_stop:test1:gpadmin-[INFO]:-Master stopped successfully {code} 3. Activate standby master {code} [gpadmin@test1 ~]$ ssh test5 'source /data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/./greenplum_path.sh; hawq activate standby -a' 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Prepare to do 'hawq activate' 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-You can find log in: 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_activate_20160613.log 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-GPHOME is set to: 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/. 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Activate hawq with args: ['activate', 'standby'] 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Starting to activate standby master 'test5' 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-HAWQ master is not running, skip 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping all the running segments 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:- 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping running standby 20160613:20:14:23:126841 hawq_activate:test5:gpadmin-[INFO]:-Update master host name in hawq-site.xml 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-GUC hawq_master_address_host already exist in hawq-site.xml Update it with value: test5 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-Remove current standby from hawq-site.xml 20160613:20:14:39:126841 hawq_activate:test5:gpadmin-[INFO]:-Start master in master only mode {code} It hangs and can not start master. And the master log is following: {code} 48,1 底端 2016-06-13 20:14:40.268022 PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","database system was shut down at 2016-06-13 20:02:50 PDT",,,0,,"xlog.c",6205, 2016-06-13 20:14:40.268112 PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","found recovery.conf file indicating standby takeover recovery needed",,,0,,"xlog.c",5485, 2016-06-13 20:14:40.268131 PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","checkpoint record is at 0/1C75EF0",,,0,,"xlog.c",6304, 2016-06-13 20:14:40.268143 PDT,,,p127518,th-12124628160,,,seg-1,"LOG","0","redo record is at 0/1C75EF0; undo record is at 0/0; shutdown TRUE",,,0,,"xlog.c",6338, 2016-06-13 20:14:40.268155 PDT,,,p127518,th-12
[jira] [Created] (HAWQ-813) Activate standby master failed after create a new database
Chunling Wang created HAWQ-813: -- Summary: Activate standby master failed after create a new database Key: HAWQ-813 URL: https://issues.apache.org/jira/browse/HAWQ-813 Project: Apache HAWQ Issue Type: Bug Components: Backup & restore Reporter: Chunling Wang Assignee: Lei Chang Activate standby master failed after create a new database. However, it will success if we do not create a new database even we create a new table and insert data. 1. Create a new database 'gptest' {code} [gpadmin@test1 ~]$ psql -l List of databases Name| Owner | Encoding | Access privileges ---+-+--+--- postgres | gpadmin | UTF8 | template0 | gpadmin | UTF8 | template1 | gpadmin | UTF8 | (3 rows) [gpadmin@test1 ~]$ createdb gptest [gpadmin@test1 ~]$ psql -l List of databases Name| Owner | Encoding | Access privileges ---+-+--+--- gptest| gpadmin | UTF8 | postgres | gpadmin | UTF8 | template0 | gpadmin | UTF8 | template1 | gpadmin | UTF8 | (4 rows) {code} 2. Stop HAWQ master {code} [gpadmin@test1 ~]$ hawq stop master -a 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Prepare to do 'hawq stop' 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-You can find log in: 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20160613.log 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-GPHOME is set to: 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/. 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq with args: ['stop', 'master'] 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-There are 0 connections to the database 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart' 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Master host=test1 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq master 20160613:20:13:46:068559 hawq_stop:test1:gpadmin-[INFO]:-Master stopped successfully {code} 3. Activate standby master {code} [gpadmin@test1 ~]$ ssh test5 'source /data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/./greenplum_path.sh; hawq activate standby -a' 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Prepare to do 'hawq activate' 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-You can find log in: 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_activate_20160613.log 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-GPHOME is set to: 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/. 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Activate hawq with args: ['activate', 'standby'] 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Starting to activate standby master 'test5' 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-HAWQ master is not running, skip 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping all the running segments 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:- 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping running standby 20160613:20:14:23:126841 hawq_activate:test5:gpadmin-[INFO]:-Update master host name in hawq-site.xml 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-GUC hawq_master_address_host already exist in hawq-site.xml Update it with value: test5 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-Remove current standby from hawq-site.xml 20160613:20:14:39:126841 hawq_activate:test5:gpadmin-[INFO]:-Start master in master only mode {code} It hangs and can not start master. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HAWQ-812) Activate standby master failed after create a new database
Chunling Wang created HAWQ-812: -- Summary: Activate standby master failed after create a new database Key: HAWQ-812 URL: https://issues.apache.org/jira/browse/HAWQ-812 Project: Apache HAWQ Issue Type: Bug Components: Backup & restore Reporter: Chunling Wang Assignee: Lei Chang Activate standby master failed after create a new database. However, it will success if we do not create a new database even we create a new table and insert data. 1. Create a new database 'gptest' {code} [gpadmin@test1 ~]$ psql -l List of databases Name| Owner | Encoding | Access privileges ---+-+--+--- postgres | gpadmin | UTF8 | template0 | gpadmin | UTF8 | template1 | gpadmin | UTF8 | (3 rows) [gpadmin@test1 ~]$ createdb gptest [gpadmin@test1 ~]$ psql -l List of databases Name| Owner | Encoding | Access privileges ---+-+--+--- gptest| gpadmin | UTF8 | postgres | gpadmin | UTF8 | template0 | gpadmin | UTF8 | template1 | gpadmin | UTF8 | (4 rows) {code} 2. Stop HAWQ master {code} [gpadmin@test1 ~]$ hawq stop master -a 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Prepare to do 'hawq stop' 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-You can find log in: 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20160613.log 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-GPHOME is set to: 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/. 20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq with args: ['stop', 'master'] 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-There are 0 connections to the database 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='smart' 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Master host=test1 20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq master 20160613:20:13:46:068559 hawq_stop:test1:gpadmin-[INFO]:-Master stopped successfully {code} 3. Activate standby master {code} [gpadmin@test1 ~]$ ssh test5 'source /data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/./greenplum_path.sh; hawq activate standby -a' 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Prepare to do 'hawq activate' 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-You can find log in: 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_activate_20160613.log 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-GPHOME is set to: 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/. 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Activate hawq with args: ['activate', 'standby'] 20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Starting to activate standby master 'test5' 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-HAWQ master is not running, skip 20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping all the running segments 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:- 20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping running standby 20160613:20:14:23:126841 hawq_activate:test5:gpadmin-[INFO]:-Update master host name in hawq-site.xml 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-GUC hawq_master_address_host already exist in hawq-site.xml Update it with value: test5 20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-Remove current standby from hawq-site.xml 20160613:20:14:39:126841 hawq_activate:test5:gpadmin-[INFO]:-Start master in master only mode {code} It hangs and can not start master. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-809) Change libhdfs3 function test port to hadoop default port
[ https://issues.apache.org/jira/browse/HAWQ-809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15328854#comment-15328854 ] ASF GitHub Bot commented on HAWQ-809: - Github user radarwave commented on the issue: https://github.com/apache/incubator-hawq/pull/705 LGTM. +1 > Change libhdfs3 function test port to hadoop default port > - > > Key: HAWQ-809 > URL: https://issues.apache.org/jira/browse/HAWQ-809 > Project: Apache HAWQ > Issue Type: Test > Components: libhdfs >Reporter: Jiali Yao >Assignee: Jiali Yao > > In libhdfs3 function test, now it use hdfs port 9000 we need to change it to > default hdfs port -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-809) Change libhdfs3 function test port to hadoop default port
[ https://issues.apache.org/jira/browse/HAWQ-809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15328853#comment-15328853 ] ASF GitHub Bot commented on HAWQ-809: - Github user huor commented on the issue: https://github.com/apache/incubator-hawq/pull/705 +1 > Change libhdfs3 function test port to hadoop default port > - > > Key: HAWQ-809 > URL: https://issues.apache.org/jira/browse/HAWQ-809 > Project: Apache HAWQ > Issue Type: Test > Components: libhdfs >Reporter: Jiali Yao >Assignee: Jiali Yao > > In libhdfs3 function test, now it use hdfs port 9000 we need to change it to > default hdfs port -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq issue #705: HAWQ-809: Change libhdfs function test default hd...
Github user radarwave commented on the issue: https://github.com/apache/incubator-hawq/pull/705 LGTM. +1 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-hawq issue #705: HAWQ-809: Change libhdfs function test default hd...
Github user huor commented on the issue: https://github.com/apache/incubator-hawq/pull/705 +1 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Commented] (HAWQ-811) Redefine execute interface in sql_util.h of feature test library to support returning error message.
[ https://issues.apache.org/jira/browse/HAWQ-811?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15328838#comment-15328838 ] ASF GitHub Bot commented on HAWQ-811: - Github user radarwave commented on the issue: https://github.com/apache/incubator-hawq/pull/708 +1 > Redefine execute interface in sql_util.h of feature test library to support > returning error message. > > > Key: HAWQ-811 > URL: https://issues.apache.org/jira/browse/HAWQ-811 > Project: Apache HAWQ > Issue Type: Improvement >Reporter: hongwu >Assignee: hongwu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq issue #708: HAWQ-811. Refactor execute interface in sql_util ...
Github user radarwave commented on the issue: https://github.com/apache/incubator-hawq/pull/708 +1 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Resolved] (HAWQ-759) Query cannot be terminated by pg_cancel_backend or pg_terminate_backend
[ https://issues.apache.org/jira/browse/HAWQ-759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lin Wen resolved HAWQ-759. -- Resolution: Fixed > Query cannot be terminated by pg_cancel_backend or pg_terminate_backend > --- > > Key: HAWQ-759 > URL: https://issues.apache.org/jira/browse/HAWQ-759 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Lin Wen >Assignee: Lin Wen > > Query cannot be terminated by pg_cancel_backend or pg_terminate_backend. > Reproduce procedure > 1. create a pipe > [gpadmin@mdw tmp]$ mkfifo /tmp/test.dat > 2.create test table and run copy command. > gpadmin=# create table public.test(id int) distributed randomly; > CREATE TABLE > Time: 306.431 ms > gpadmin=# copy public.test to '/tmp/test.dat'; > 3. open a new psql session. try to terminate this session but fails. > Time: 2.327 ms > gpadmin=# select pg_cancel_backend(19210); > pg_cancel_backend > --- > t > (1 row) > Time: 0.452 ms > gpadmin=# select pg_terminate_backend(19210); > pg_terminate_backend > -- > t > (1 row) > Time: 0.368 ms > gpadmin=# select * from pg_stat_activity ; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq pull request #706: HAWQ-759. Fix query cannot be terminated b...
Github user linwen closed the pull request at: https://github.com/apache/incubator-hawq/pull/706 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Commented] (HAWQ-811) Redefine execute interface in sql_util.h of feature test library to support returning error message.
[ https://issues.apache.org/jira/browse/HAWQ-811?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15328776#comment-15328776 ] ASF GitHub Bot commented on HAWQ-811: - Github user huor commented on the issue: https://github.com/apache/incubator-hawq/pull/708 +1 > Redefine execute interface in sql_util.h of feature test library to support > returning error message. > > > Key: HAWQ-811 > URL: https://issues.apache.org/jira/browse/HAWQ-811 > Project: Apache HAWQ > Issue Type: Improvement >Reporter: hongwu >Assignee: hongwu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq pull request #707: HAWQ-810. Add stringFormat for feature tes...
Github user xunzhang commented on a diff in the pull request: https://github.com/apache/incubator-hawq/pull/707#discussion_r66898792 --- Diff: src/test/feature/testlib/test_lib.cpp --- @@ -73,6 +74,11 @@ TEST_F(TestCommonLib, TestSqlUtil) { util.execSQLFile("testlib/sql/sample.sql", "testlib/ans/sample.ans"); } +TEST_F(TestCommonLib, TestStringFormat) { + auto s1 = hawq::test::stringFormat("welcome %s to apache %s project", "you", "HAWQ"); + EXPECT_EQ(s1, "welcome you to apache HAWQ project"); --- End diff -- Here welcome is used as transitive verb. Refer webster: http://www.merriam-webster.com/dictionary/welcome --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Commented] (HAWQ-810) Add string format for feature test library
[ https://issues.apache.org/jira/browse/HAWQ-810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15328779#comment-15328779 ] ASF GitHub Bot commented on HAWQ-810: - Github user xunzhang commented on a diff in the pull request: https://github.com/apache/incubator-hawq/pull/707#discussion_r66898792 --- Diff: src/test/feature/testlib/test_lib.cpp --- @@ -73,6 +74,11 @@ TEST_F(TestCommonLib, TestSqlUtil) { util.execSQLFile("testlib/sql/sample.sql", "testlib/ans/sample.ans"); } +TEST_F(TestCommonLib, TestStringFormat) { + auto s1 = hawq::test::stringFormat("welcome %s to apache %s project", "you", "HAWQ"); + EXPECT_EQ(s1, "welcome you to apache HAWQ project"); --- End diff -- Here welcome is used as transitive verb. Refer webster: http://www.merriam-webster.com/dictionary/welcome > Add string format for feature test library > -- > > Key: HAWQ-810 > URL: https://issues.apache.org/jira/browse/HAWQ-810 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: hongwu >Assignee: hongwu > > For example, define a string: > {noformat} > std::string s = stringFormat("hello %s %s world", "xunzhang", "wuhong"); > {noformat} > instead of: > {noformat} > std::string s = "hello" + "xunzhang" + "wuhong" + "world"; > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq issue #708: HAWQ-811. Refactor execute interface in sql_util ...
Github user huor commented on the issue: https://github.com/apache/incubator-hawq/pull/708 +1 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Updated] (HAWQ-786) HAWQ supports ORC as a native storage format
[ https://issues.apache.org/jira/browse/HAWQ-786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang updated HAWQ-786: --- Description: In current HAWQ, two native formats are supported: AO and parquet. Now we want to support ORC. A framework to support naive c/c++ pluggable format is needed to support ORC more easily. And it can also be potentially used for fast external data access. (was: In current HAWQ, two native formats are supported: AO and parquet. Now we want to support ORC. A framework to support naive c/c++ pluggable format is needed. And it can also be potentially used for fast external data access.) > HAWQ supports ORC as a native storage format > > > Key: HAWQ-786 > URL: https://issues.apache.org/jira/browse/HAWQ-786 > Project: Apache HAWQ > Issue Type: New Feature > Components: Storage >Reporter: Lei Chang >Assignee: hongwu > > In current HAWQ, two native formats are supported: AO and parquet. Now we > want to support ORC. A framework to support naive c/c++ pluggable format is > needed to support ORC more easily. And it can also be potentially used for > fast external data access. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Deleted] (HAWQ-639) HAWQ support ORC as a native storage format
[ https://issues.apache.org/jira/browse/HAWQ-639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang deleted HAWQ-639: --- > HAWQ support ORC as a native storage format > --- > > Key: HAWQ-639 > URL: https://issues.apache.org/jira/browse/HAWQ-639 > Project: Apache HAWQ > Issue Type: Sub-task >Reporter: Goden Yao >Assignee: hongwu > > As a user, I want to be able to store my table as ORC format in HAWQ -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Comment Edited] (HAWQ-639) HAWQ support ORC as a native storage format
[ https://issues.apache.org/jira/browse/HAWQ-639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15328762#comment-15328762 ] Lei Chang edited comment on HAWQ-639 at 6/14/16 1:52 AM: - consolidate this with HAWQ-786 was (Author: lei_chang): consolidate this with HAWQ-796 > HAWQ support ORC as a native storage format > --- > > Key: HAWQ-639 > URL: https://issues.apache.org/jira/browse/HAWQ-639 > Project: Apache HAWQ > Issue Type: Sub-task >Reporter: Goden Yao >Assignee: hongwu > > As a user, I want to be able to store my table as ORC format in HAWQ -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq issue #707: HAWQ-810. Add stringFormat for feature test libra...
Github user huor commented on the issue: https://github.com/apache/incubator-hawq/pull/707 +1 except for the test case for string format. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Commented] (HAWQ-810) Add string format for feature test library
[ https://issues.apache.org/jira/browse/HAWQ-810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15328773#comment-15328773 ] ASF GitHub Bot commented on HAWQ-810: - Github user huor commented on the issue: https://github.com/apache/incubator-hawq/pull/707 +1 except for the test case for string format. > Add string format for feature test library > -- > > Key: HAWQ-810 > URL: https://issues.apache.org/jira/browse/HAWQ-810 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: hongwu >Assignee: hongwu > > For example, define a string: > {noformat} > std::string s = stringFormat("hello %s %s world", "xunzhang", "wuhong"); > {noformat} > instead of: > {noformat} > std::string s = "hello" + "xunzhang" + "wuhong" + "world"; > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-810) Add string format for feature test library
[ https://issues.apache.org/jira/browse/HAWQ-810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15328772#comment-15328772 ] ASF GitHub Bot commented on HAWQ-810: - Github user huor commented on a diff in the pull request: https://github.com/apache/incubator-hawq/pull/707#discussion_r66898131 --- Diff: src/test/feature/testlib/test_lib.cpp --- @@ -73,6 +74,11 @@ TEST_F(TestCommonLib, TestSqlUtil) { util.execSQLFile("testlib/sql/sample.sql", "testlib/ans/sample.ans"); } +TEST_F(TestCommonLib, TestStringFormat) { + auto s1 = hawq::test::stringFormat("welcome %s to apache %s project", "you", "HAWQ"); + EXPECT_EQ(s1, "welcome you to apache HAWQ project"); --- End diff -- ``` auto s1 = hawq::test::stringFormat("Welcome to apache %s project", "HAWQ"); + EXPECT_EQ(s1, "Welcome to apache HAWQ project"); ``` or ``` auto s1 = hawq::test::stringFormat("%s are welcome to apache %s project", "You", "HAWQ"); + EXPECT_EQ(s1, "You are welcome to apache HAWQ project"); ``` > Add string format for feature test library > -- > > Key: HAWQ-810 > URL: https://issues.apache.org/jira/browse/HAWQ-810 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: hongwu >Assignee: hongwu > > For example, define a string: > {noformat} > std::string s = stringFormat("hello %s %s world", "xunzhang", "wuhong"); > {noformat} > instead of: > {noformat} > std::string s = "hello" + "xunzhang" + "wuhong" + "world"; > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq pull request #707: HAWQ-810. Add stringFormat for feature tes...
Github user huor commented on a diff in the pull request: https://github.com/apache/incubator-hawq/pull/707#discussion_r66898131 --- Diff: src/test/feature/testlib/test_lib.cpp --- @@ -73,6 +74,11 @@ TEST_F(TestCommonLib, TestSqlUtil) { util.execSQLFile("testlib/sql/sample.sql", "testlib/ans/sample.ans"); } +TEST_F(TestCommonLib, TestStringFormat) { + auto s1 = hawq::test::stringFormat("welcome %s to apache %s project", "you", "HAWQ"); + EXPECT_EQ(s1, "welcome you to apache HAWQ project"); --- End diff -- ``` auto s1 = hawq::test::stringFormat("Welcome to apache %s project", "HAWQ"); + EXPECT_EQ(s1, "Welcome to apache HAWQ project"); ``` or ``` auto s1 = hawq::test::stringFormat("%s are welcome to apache %s project", "You", "HAWQ"); + EXPECT_EQ(s1, "You are welcome to apache HAWQ project"); ``` --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Commented] (HAWQ-639) HAWQ support ORC as a native storage format
[ https://issues.apache.org/jira/browse/HAWQ-639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15328762#comment-15328762 ] Lei Chang commented on HAWQ-639: consolidate this with HAWQ-796 > HAWQ support ORC as a native storage format > --- > > Key: HAWQ-639 > URL: https://issues.apache.org/jira/browse/HAWQ-639 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Storage >Reporter: Goden Yao >Assignee: hongwu > > As a user, I want to be able to store my table as ORC format in HAWQ -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-786) HAWQ supports ORC as a native storage format
[ https://issues.apache.org/jira/browse/HAWQ-786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang updated HAWQ-786: --- Summary: HAWQ supports ORC as a native storage format (was: Framework to support native C/C++ pluggable formats (ORC et al)) > HAWQ supports ORC as a native storage format > > > Key: HAWQ-786 > URL: https://issues.apache.org/jira/browse/HAWQ-786 > Project: Apache HAWQ > Issue Type: New Feature > Components: Storage >Reporter: Lei Chang >Assignee: hongwu > > In current HAWQ, two native formats are supported: AO and parquet. Now we > want to support ORC. A framework to support naive c/c++ pluggable format is > needed. And it can also be potentially used for fast external data access. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-786) Framework to support native C/C++ pluggable formats (ORC et al)
[ https://issues.apache.org/jira/browse/HAWQ-786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang updated HAWQ-786: --- Summary: Framework to support native C/C++ pluggable formats (ORC et al) (was: Framework to support native C/C++ pluggable format (ORC et al)) > Framework to support native C/C++ pluggable formats (ORC et al) > --- > > Key: HAWQ-786 > URL: https://issues.apache.org/jira/browse/HAWQ-786 > Project: Apache HAWQ > Issue Type: New Feature > Components: Storage >Reporter: Lei Chang >Assignee: hongwu > > In current HAWQ, two native formats are supported: AO and parquet. Now we > want to support ORC. A framework to support naive c/c++ pluggable format is > needed. And it can also be potentially used for fast external data access. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-786) Framework to support native C/C++ pluggable format (ORC et al)
[ https://issues.apache.org/jira/browse/HAWQ-786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang updated HAWQ-786: --- Description: In current HAWQ, two native formats are supported: AO and parquet. Now we want to support ORC. A framework to support naive c/c++ pluggable format is needed. And it can also be potentially used for fast external data access. (was: In current HAWQ, two native formats are supported: AO and parquet. Now we want to support ORC. A framework to support pluggable format with C/C++ scanner is needed. And it can also be potentially used for fast external data access.) > Framework to support native C/C++ pluggable format (ORC et al) > -- > > Key: HAWQ-786 > URL: https://issues.apache.org/jira/browse/HAWQ-786 > Project: Apache HAWQ > Issue Type: New Feature > Components: Storage >Reporter: Lei Chang >Assignee: hongwu > > In current HAWQ, two native formats are supported: AO and parquet. Now we > want to support ORC. A framework to support naive c/c++ pluggable format is > needed. And it can also be potentially used for fast external data access. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-786) Framework to support native C/C++ pluggable format
[ https://issues.apache.org/jira/browse/HAWQ-786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang updated HAWQ-786: --- Summary: Framework to support native C/C++ pluggable format (was: Framework to support pluggable format with C/C++ scanner) > Framework to support native C/C++ pluggable format > -- > > Key: HAWQ-786 > URL: https://issues.apache.org/jira/browse/HAWQ-786 > Project: Apache HAWQ > Issue Type: New Feature > Components: Storage >Reporter: Lei Chang >Assignee: hongwu > > In current HAWQ, two native formats are supported: AO and parquet. Now we > want to support ORC. A framework to support pluggable format with C/C++ > scanner is needed. And it can also be potentially used for fast external data > access. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-786) Framework to support native C/C++ pluggable format (ORC et al)
[ https://issues.apache.org/jira/browse/HAWQ-786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang updated HAWQ-786: --- Summary: Framework to support native C/C++ pluggable format (ORC et al) (was: Framework to support native C/C++ pluggable format) > Framework to support native C/C++ pluggable format (ORC et al) > -- > > Key: HAWQ-786 > URL: https://issues.apache.org/jira/browse/HAWQ-786 > Project: Apache HAWQ > Issue Type: New Feature > Components: Storage >Reporter: Lei Chang >Assignee: hongwu > > In current HAWQ, two native formats are supported: AO and parquet. Now we > want to support ORC. A framework to support pluggable format with C/C++ > scanner is needed. And it can also be potentially used for fast external data > access. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-639) HAWQ support ORC as a native storage format
[ https://issues.apache.org/jira/browse/HAWQ-639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lei Chang updated HAWQ-639: --- Issue Type: Sub-task (was: New Feature) Parent: HAWQ-786 > HAWQ support ORC as a native storage format > --- > > Key: HAWQ-639 > URL: https://issues.apache.org/jira/browse/HAWQ-639 > Project: Apache HAWQ > Issue Type: Sub-task > Components: Storage >Reporter: Goden Yao >Assignee: hongwu > > As a user, I want to be able to store my table as ORC format in HAWQ -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-811) Redefine execute interface in sql_util.h of feature test library to support returning error message.
[ https://issues.apache.org/jira/browse/HAWQ-811?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15327623#comment-15327623 ] ASF GitHub Bot commented on HAWQ-811: - Github user xunzhang commented on the issue: https://github.com/apache/incubator-hawq/pull/708 cc @ztao1987 > Redefine execute interface in sql_util.h of feature test library to support > returning error message. > > > Key: HAWQ-811 > URL: https://issues.apache.org/jira/browse/HAWQ-811 > Project: Apache HAWQ > Issue Type: Improvement >Reporter: hongwu >Assignee: hongwu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq issue #708: HAWQ-811. Refactor execute interface in sql_util ...
Github user xunzhang commented on the issue: https://github.com/apache/incubator-hawq/pull/708 cc @ztao1987 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Commented] (HAWQ-811) Redefine execute interface in sql_util.h of feature test library to support returning error message.
[ https://issues.apache.org/jira/browse/HAWQ-811?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15327611#comment-15327611 ] ASF GitHub Bot commented on HAWQ-811: - GitHub user xunzhang opened a pull request: https://github.com/apache/incubator-hawq/pull/708 HAWQ-811. Refactor execute interface in sql_util of feature test library to support returning error message. You can merge this pull request into a Git repository by running: $ git pull https://github.com/xunzhang/incubator-hawq HAWQ-811 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-hawq/pull/708.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #708 commit 56caef6ed9d97bfcf6332b5d9135daa2c8e8bccc Author: xunzhangDate: 2016-06-13T15:26:25Z HAWQ-811. Refactor execute interface in sql_util of feature test library to support returning error message. > Redefine execute interface in sql_util.h of feature test library to support > returning error message. > > > Key: HAWQ-811 > URL: https://issues.apache.org/jira/browse/HAWQ-811 > Project: Apache HAWQ > Issue Type: Improvement >Reporter: hongwu >Assignee: hongwu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HAWQ-811) Redefine execute interface in sql_util.h of feature test library to support returning error message.
hongwu created HAWQ-811: --- Summary: Redefine execute interface in sql_util.h of feature test library to support returning error message. Key: HAWQ-811 URL: https://issues.apache.org/jira/browse/HAWQ-811 Project: Apache HAWQ Issue Type: Improvement Reporter: hongwu Assignee: Lei Chang -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HAWQ-811) Redefine execute interface in sql_util.h of feature test library to support returning error message.
[ https://issues.apache.org/jira/browse/HAWQ-811?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongwu reassigned HAWQ-811: --- Assignee: hongwu (was: Lei Chang) > Redefine execute interface in sql_util.h of feature test library to support > returning error message. > > > Key: HAWQ-811 > URL: https://issues.apache.org/jira/browse/HAWQ-811 > Project: Apache HAWQ > Issue Type: Improvement >Reporter: hongwu >Assignee: hongwu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq issue #707: HAWQ-810. Add stringFormat for feature test libra...
Github user jiny2 commented on the issue: https://github.com/apache/incubator-hawq/pull/707 +1 LGTM --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Commented] (HAWQ-759) Query cannot be terminated by pg_cancel_backend or pg_terminate_backend
[ https://issues.apache.org/jira/browse/HAWQ-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15327176#comment-15327176 ] ASF GitHub Bot commented on HAWQ-759: - Github user jiny2 commented on the issue: https://github.com/apache/incubator-hawq/pull/706 +1 > Query cannot be terminated by pg_cancel_backend or pg_terminate_backend > --- > > Key: HAWQ-759 > URL: https://issues.apache.org/jira/browse/HAWQ-759 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Lin Wen >Assignee: Lin Wen > > Query cannot be terminated by pg_cancel_backend or pg_terminate_backend. > Reproduce procedure > 1. create a pipe > [gpadmin@mdw tmp]$ mkfifo /tmp/test.dat > 2.create test table and run copy command. > gpadmin=# create table public.test(id int) distributed randomly; > CREATE TABLE > Time: 306.431 ms > gpadmin=# copy public.test to '/tmp/test.dat'; > 3. open a new psql session. try to terminate this session but fails. > Time: 2.327 ms > gpadmin=# select pg_cancel_backend(19210); > pg_cancel_backend > --- > t > (1 row) > Time: 0.452 ms > gpadmin=# select pg_terminate_backend(19210); > pg_terminate_backend > -- > t > (1 row) > Time: 0.368 ms > gpadmin=# select * from pg_stat_activity ; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq issue #706: HAWQ-759. Fix query cannot be terminated by pg_ca...
Github user jiny2 commented on the issue: https://github.com/apache/incubator-hawq/pull/706 +1 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-hawq issue #707: HAWQ-810. Add stringFormat for feature test libra...
Github user xunzhang commented on the issue: https://github.com/apache/incubator-hawq/pull/707 also cc @jiny2 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Commented] (HAWQ-810) Add string format for feature test library
[ https://issues.apache.org/jira/browse/HAWQ-810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15327168#comment-15327168 ] ASF GitHub Bot commented on HAWQ-810: - Github user xunzhang commented on the issue: https://github.com/apache/incubator-hawq/pull/707 also cc @jiny2 > Add string format for feature test library > -- > > Key: HAWQ-810 > URL: https://issues.apache.org/jira/browse/HAWQ-810 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: hongwu >Assignee: hongwu > > For example, define a string: > {noformat} > std::string s = stringFormat("hello %s %s world", "xunzhang", "wuhong"); > {noformat} > instead of: > {noformat} > std::string s = "hello" + "xunzhang" + "wuhong" + "world"; > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-810) Add string format for feature test library
[ https://issues.apache.org/jira/browse/HAWQ-810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15327165#comment-15327165 ] ASF GitHub Bot commented on HAWQ-810: - Github user xunzhang commented on the issue: https://github.com/apache/incubator-hawq/pull/707 cc @zhangh43 @huor > Add string format for feature test library > -- > > Key: HAWQ-810 > URL: https://issues.apache.org/jira/browse/HAWQ-810 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: hongwu >Assignee: hongwu > > For example, define a string: > {noformat} > std::string s = stringFormat("hello %s %s world", "xunzhang", "wuhong"); > {noformat} > instead of: > {noformat} > std::string s = "hello" + "xunzhang" + "wuhong" + "world"; > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq issue #707: HAWQ-810. Add stringFormat for feature test libra...
Github user xunzhang commented on the issue: https://github.com/apache/incubator-hawq/pull/707 cc @zhangh43 @huor --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-hawq pull request #707: HAWQ-810. Add stringFormat for feature tes...
GitHub user xunzhang opened a pull request: https://github.com/apache/incubator-hawq/pull/707 HAWQ-810. Add stringFormat for feature test library You can merge this pull request into a Git repository by running: $ git pull https://github.com/xunzhang/incubator-hawq HAWQ-810 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-hawq/pull/707.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #707 commit a4a2aeae4ff8f9addfb5d862ea502d46e2e685f8 Author: xunzhangDate: 2016-06-13T11:08:01Z HAWQ-810. Add stringFormat for feature test library --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Commented] (HAWQ-810) Add string format for feature test library
[ https://issues.apache.org/jira/browse/HAWQ-810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15327163#comment-15327163 ] ASF GitHub Bot commented on HAWQ-810: - GitHub user xunzhang opened a pull request: https://github.com/apache/incubator-hawq/pull/707 HAWQ-810. Add stringFormat for feature test library You can merge this pull request into a Git repository by running: $ git pull https://github.com/xunzhang/incubator-hawq HAWQ-810 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-hawq/pull/707.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #707 commit a4a2aeae4ff8f9addfb5d862ea502d46e2e685f8 Author: xunzhangDate: 2016-06-13T11:08:01Z HAWQ-810. Add stringFormat for feature test library > Add string format for feature test library > -- > > Key: HAWQ-810 > URL: https://issues.apache.org/jira/browse/HAWQ-810 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: hongwu >Assignee: hongwu > > For example, define a string: > {noformat} > std::string s = stringFormat("hello %s %s world", "xunzhang", "wuhong"); > {noformat} > instead of: > {noformat} > std::string s = "hello" + "xunzhang" + "wuhong" + "world"; > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HAWQ-810) Add string format for feature test library
[ https://issues.apache.org/jira/browse/HAWQ-810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongwu reassigned HAWQ-810: --- Assignee: hongwu (was: Jiali Yao) > Add string format for feature test library > -- > > Key: HAWQ-810 > URL: https://issues.apache.org/jira/browse/HAWQ-810 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: hongwu >Assignee: hongwu > > For example, define a string: > {noformat} > std::string s = stringFormat("hello %s %s world", "xunzhang", "wuhong"); > {noformat} > instead of: > {noformat} > std::string s = "hello" + "xunzhang" + "wuhong" + "world"; > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HAWQ-810) Add string format for feature test library
hongwu created HAWQ-810: --- Summary: Add string format for feature test library Key: HAWQ-810 URL: https://issues.apache.org/jira/browse/HAWQ-810 Project: Apache HAWQ Issue Type: New Feature Components: Tests Reporter: hongwu Assignee: Jiali Yao For example, define a string: {noformat} std::string s = stringFormat("hello %s %s world", "xunzhang", "wuhong"); {noformat} instead of: {noformat} std::string s = "hello" + "xunzhang" + "wuhong" + "world"; {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-759) Query cannot be terminated by pg_cancel_backend or pg_terminate_backend
[ https://issues.apache.org/jira/browse/HAWQ-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15327004#comment-15327004 ] ASF GitHub Bot commented on HAWQ-759: - Github user huor commented on the issue: https://github.com/apache/incubator-hawq/pull/706 +1 > Query cannot be terminated by pg_cancel_backend or pg_terminate_backend > --- > > Key: HAWQ-759 > URL: https://issues.apache.org/jira/browse/HAWQ-759 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Lin Wen >Assignee: Lin Wen > > Query cannot be terminated by pg_cancel_backend or pg_terminate_backend. > Reproduce procedure > 1. create a pipe > [gpadmin@mdw tmp]$ mkfifo /tmp/test.dat > 2.create test table and run copy command. > gpadmin=# create table public.test(id int) distributed randomly; > CREATE TABLE > Time: 306.431 ms > gpadmin=# copy public.test to '/tmp/test.dat'; > 3. open a new psql session. try to terminate this session but fails. > Time: 2.327 ms > gpadmin=# select pg_cancel_backend(19210); > pg_cancel_backend > --- > t > (1 row) > Time: 0.452 ms > gpadmin=# select pg_terminate_backend(19210); > pg_terminate_backend > -- > t > (1 row) > Time: 0.368 ms > gpadmin=# select * from pg_stat_activity ; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq issue #706: HAWQ-759. Fix query cannot be terminated by pg_ca...
Github user huor commented on the issue: https://github.com/apache/incubator-hawq/pull/706 +1 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Commented] (HAWQ-759) Query cannot be terminated by pg_cancel_backend or pg_terminate_backend
[ https://issues.apache.org/jira/browse/HAWQ-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15326986#comment-15326986 ] ASF GitHub Bot commented on HAWQ-759: - Github user liming01 commented on the issue: https://github.com/apache/incubator-hawq/pull/706 LGTM. +1. > Query cannot be terminated by pg_cancel_backend or pg_terminate_backend > --- > > Key: HAWQ-759 > URL: https://issues.apache.org/jira/browse/HAWQ-759 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Lin Wen >Assignee: Lin Wen > > Query cannot be terminated by pg_cancel_backend or pg_terminate_backend. > Reproduce procedure > 1. create a pipe > [gpadmin@mdw tmp]$ mkfifo /tmp/test.dat > 2.create test table and run copy command. > gpadmin=# create table public.test(id int) distributed randomly; > CREATE TABLE > Time: 306.431 ms > gpadmin=# copy public.test to '/tmp/test.dat'; > 3. open a new psql session. try to terminate this session but fails. > Time: 2.327 ms > gpadmin=# select pg_cancel_backend(19210); > pg_cancel_backend > --- > t > (1 row) > Time: 0.452 ms > gpadmin=# select pg_terminate_backend(19210); > pg_terminate_backend > -- > t > (1 row) > Time: 0.368 ms > gpadmin=# select * from pg_stat_activity ; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq issue #706: HAWQ-759. Fix query cannot be terminated by pg_ca...
Github user liming01 commented on the issue: https://github.com/apache/incubator-hawq/pull/706 LGTM. +1. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[GitHub] incubator-hawq pull request #706: HAWQ-759. Fix query cannot be terminated b...
GitHub user linwen opened a pull request: https://github.com/apache/incubator-hawq/pull/706 HAWQ-759. Fix query cannot be terminated by pg_cancel_backend or pg_t⦠Please review, Thanks! You can merge this pull request into a Git repository by running: $ git pull https://github.com/linwen/incubator-hawq hawq-759 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-hawq/pull/706.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #706 commit 8b6d9b9efed1aa7a8ca29748a650bd97a13b69d2 Author: Wen LinDate: 2016-06-13T08:07:51Z HAWQ-759. Fix query cannot be terminated by pg_cancel_backend or pg_terminate_backend --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Commented] (HAWQ-759) Query cannot be terminated by pg_cancel_backend or pg_terminate_backend
[ https://issues.apache.org/jira/browse/HAWQ-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15326972#comment-15326972 ] ASF GitHub Bot commented on HAWQ-759: - GitHub user linwen opened a pull request: https://github.com/apache/incubator-hawq/pull/706 HAWQ-759. Fix query cannot be terminated by pg_cancel_backend or pg_t… Please review, Thanks! You can merge this pull request into a Git repository by running: $ git pull https://github.com/linwen/incubator-hawq hawq-759 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-hawq/pull/706.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #706 commit 8b6d9b9efed1aa7a8ca29748a650bd97a13b69d2 Author: Wen LinDate: 2016-06-13T08:07:51Z HAWQ-759. Fix query cannot be terminated by pg_cancel_backend or pg_terminate_backend > Query cannot be terminated by pg_cancel_backend or pg_terminate_backend > --- > > Key: HAWQ-759 > URL: https://issues.apache.org/jira/browse/HAWQ-759 > Project: Apache HAWQ > Issue Type: Bug >Reporter: Lin Wen >Assignee: Lin Wen > > Query cannot be terminated by pg_cancel_backend or pg_terminate_backend. > Reproduce procedure > 1. create a pipe > [gpadmin@mdw tmp]$ mkfifo /tmp/test.dat > 2.create test table and run copy command. > gpadmin=# create table public.test(id int) distributed randomly; > CREATE TABLE > Time: 306.431 ms > gpadmin=# copy public.test to '/tmp/test.dat'; > 3. open a new psql session. try to terminate this session but fails. > Time: 2.327 ms > gpadmin=# select pg_cancel_backend(19210); > pg_cancel_backend > --- > t > (1 row) > Time: 0.452 ms > gpadmin=# select pg_terminate_backend(19210); > pg_terminate_backend > -- > t > (1 row) > Time: 0.368 ms > gpadmin=# select * from pg_stat_activity ; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[GitHub] incubator-hawq pull request #705: HAWQ-809: Change libhdfs function test def...
GitHub user yaoj2 opened a pull request: https://github.com/apache/incubator-hawq/pull/705 HAWQ-809: Change libhdfs function test default hdfs port from 9000 to ⦠Change libhdfs3 function test default port from 9000 to 8020 You can merge this pull request into a Git repository by running: $ git pull https://github.com/yaoj2/incubator-hawq hawq-809 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-hawq/pull/705.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #705 commit 5aed70021591e098c08928f59f0c295bcf5f548c Author: yaoj2Date: 2016-06-13T08:00:07Z HAWQ-809:change libhdfs function test default hdfs port from 9000 to 8020 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastruct...@apache.org or file a JIRA ticket with INFRA. ---
[jira] [Commented] (HAWQ-809) Change libhdfs3 function test port to hadoop default port
[ https://issues.apache.org/jira/browse/HAWQ-809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15326959#comment-15326959 ] ASF GitHub Bot commented on HAWQ-809: - GitHub user yaoj2 opened a pull request: https://github.com/apache/incubator-hawq/pull/705 HAWQ-809: Change libhdfs function test default hdfs port from 9000 to … Change libhdfs3 function test default port from 9000 to 8020 You can merge this pull request into a Git repository by running: $ git pull https://github.com/yaoj2/incubator-hawq hawq-809 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-hawq/pull/705.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #705 commit 5aed70021591e098c08928f59f0c295bcf5f548c Author: yaoj2Date: 2016-06-13T08:00:07Z HAWQ-809:change libhdfs function test default hdfs port from 9000 to 8020 > Change libhdfs3 function test port to hadoop default port > - > > Key: HAWQ-809 > URL: https://issues.apache.org/jira/browse/HAWQ-809 > Project: Apache HAWQ > Issue Type: Test > Components: libhdfs >Reporter: Jiali Yao >Assignee: Jiali Yao > > In libhdfs3 function test, now it use hdfs port 9000 we need to change it to > default hdfs port -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-809) Change libhdfs3 function test port to hadoop default port
[ https://issues.apache.org/jira/browse/HAWQ-809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiali Yao updated HAWQ-809: --- Assignee: Jiali Yao (was: Lei Chang) > Change libhdfs3 function test port to hadoop default port > - > > Key: HAWQ-809 > URL: https://issues.apache.org/jira/browse/HAWQ-809 > Project: Apache HAWQ > Issue Type: Test > Components: libhdfs >Reporter: Jiali Yao >Assignee: Jiali Yao > > In libhdfs3 function test, now it use hdfs port 9000 we need to change it to > default hdfs port -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HAWQ-809) Change libhdfs3 function test port to hadoop default port
Jiali Yao created HAWQ-809: -- Summary: Change libhdfs3 function test port to hadoop default port Key: HAWQ-809 URL: https://issues.apache.org/jira/browse/HAWQ-809 Project: Apache HAWQ Issue Type: Test Components: libhdfs Reporter: Jiali Yao Assignee: Lei Chang In libhdfs3 function test, now it use hdfs port 9000 we need to change it to default hdfs port -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-731) Implement Data Generator
[ https://issues.apache.org/jira/browse/HAWQ-731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiali Yao resolved HAWQ-731. Resolution: Fixed > Implement Data Generator > - > > Key: HAWQ-731 > URL: https://issues.apache.org/jira/browse/HAWQ-731 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: Lili Ma >Assignee: Lili Ma > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-709) Include googletest for unittest/featuretest for HAWQ
[ https://issues.apache.org/jira/browse/HAWQ-709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongwu resolved HAWQ-709. - Resolution: Fixed > Include googletest for unittest/featuretest for HAWQ > > > Key: HAWQ-709 > URL: https://issues.apache.org/jira/browse/HAWQ-709 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: hongwu >Assignee: hongwu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-731) Implement Data Generator
[ https://issues.apache.org/jira/browse/HAWQ-731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiali Yao updated HAWQ-731: --- Assignee: Lili Ma (was: Jiali Yao) > Implement Data Generator > - > > Key: HAWQ-731 > URL: https://issues.apache.org/jira/browse/HAWQ-731 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: Lili Ma >Assignee: Lili Ma > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Resolved] (HAWQ-619) Change 'gpextract' to 'hawqextract' for InputFormat unit test
[ https://issues.apache.org/jira/browse/HAWQ-619?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiali Yao resolved HAWQ-619. Resolution: Fixed Fix Version/s: 2.0.0 > Change 'gpextract' to 'hawqextract' for InputFormat unit test > - > > Key: HAWQ-619 > URL: https://issues.apache.org/jira/browse/HAWQ-619 > Project: Apache HAWQ > Issue Type: Task > Components: Tests >Reporter: Chunling Wang >Assignee: Jiali Yao > Fix For: 2.0.0 > > > Change 'gpextract' to 'hawqextract' in SimpleTableLocalTester.java for > InputFormat unit test. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-709) Include googletest for unittest/featuretest for HAWQ
[ https://issues.apache.org/jira/browse/HAWQ-709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jiali Yao updated HAWQ-709: --- Assignee: hongwu (was: Jiali Yao) > Include googletest for unittest/featuretest for HAWQ > > > Key: HAWQ-709 > URL: https://issues.apache.org/jira/browse/HAWQ-709 > Project: Apache HAWQ > Issue Type: New Feature > Components: Tests >Reporter: hongwu >Assignee: hongwu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HAWQ-762) Hive aggregation queries through PXF sometimes hang
[ https://issues.apache.org/jira/browse/HAWQ-762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15326912#comment-15326912 ] Michael Andre Pearce (IG) commented on HAWQ-762: Sorry forgot to mention one crucial bit, the cluster is kerberised. We have noticed a side issue but worth mentioning incase it's related that we get gss exceptions every 24hours (length of token in our organisation) on the pxf components as such we now schedule restart these via cron. > Hive aggregation queries through PXF sometimes hang > --- > > Key: HAWQ-762 > URL: https://issues.apache.org/jira/browse/HAWQ-762 > Project: Apache HAWQ > Issue Type: Bug > Components: Hcatalog, PXF >Reporter: Oleksandr Diachenko >Assignee: Goden Yao > Labels: performance > > Reproduce Steps: > {code} > select count(*) from hcatalog.default.hivetable; > {code} > sometimes, this query will hang and we see from pxf logs that Hive thrift > server cannot be connected from PXF agent. > While users can still visit hive metastore (through HUE) and execute the same > query. > After a restart of PXF agent, this query goes through without issues. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HAWQ-808) Add feature test for external_oid with new framework
hongwu created HAWQ-808: --- Summary: Add feature test for external_oid with new framework Key: HAWQ-808 URL: https://issues.apache.org/jira/browse/HAWQ-808 Project: Apache HAWQ Issue Type: Test Components: Tests Reporter: hongwu Assignee: Jiali Yao -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HAWQ-807) Add feature test for gpcopy with new framework
[ https://issues.apache.org/jira/browse/HAWQ-807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongwu reassigned HAWQ-807: --- Assignee: hongwu (was: Jiali Yao) > Add feature test for gpcopy with new framework > -- > > Key: HAWQ-807 > URL: https://issues.apache.org/jira/browse/HAWQ-807 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Reporter: hongwu >Assignee: hongwu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HAWQ-805) Add feature test for exttab1 with new framework
[ https://issues.apache.org/jira/browse/HAWQ-805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongwu reassigned HAWQ-805: --- Assignee: hongwu (was: Jiali Yao) > Add feature test for exttab1 with new framework > --- > > Key: HAWQ-805 > URL: https://issues.apache.org/jira/browse/HAWQ-805 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Reporter: hongwu >Assignee: hongwu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HAWQ-808) Add feature test for external_oid with new framework
[ https://issues.apache.org/jira/browse/HAWQ-808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongwu reassigned HAWQ-808: --- Assignee: hongwu (was: Jiali Yao) > Add feature test for external_oid with new framework > > > Key: HAWQ-808 > URL: https://issues.apache.org/jira/browse/HAWQ-808 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Reporter: hongwu >Assignee: hongwu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Assigned] (HAWQ-806) Add feature test for subplan with new framework
[ https://issues.apache.org/jira/browse/HAWQ-806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongwu reassigned HAWQ-806: --- Assignee: hongwu (was: Jiali Yao) > Add feature test for subplan with new framework > --- > > Key: HAWQ-806 > URL: https://issues.apache.org/jira/browse/HAWQ-806 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Reporter: hongwu >Assignee: hongwu > -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HAWQ-807) Add feature test for gpcopy with new framework
hongwu created HAWQ-807: --- Summary: Add feature test for gpcopy with new framework Key: HAWQ-807 URL: https://issues.apache.org/jira/browse/HAWQ-807 Project: Apache HAWQ Issue Type: Test Components: Tests Reporter: hongwu Assignee: Jiali Yao -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HAWQ-806) Add feature test for subplan with new framework
hongwu created HAWQ-806: --- Summary: Add feature test for subplan with new framework Key: HAWQ-806 URL: https://issues.apache.org/jira/browse/HAWQ-806 Project: Apache HAWQ Issue Type: Test Components: Tests Reporter: hongwu Assignee: Jiali Yao -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HAWQ-805) Add feature test for exttab1 with new framework
hongwu created HAWQ-805: --- Summary: Add feature test for exttab1 with new framework Key: HAWQ-805 URL: https://issues.apache.org/jira/browse/HAWQ-805 Project: Apache HAWQ Issue Type: Test Components: Tests Reporter: hongwu Assignee: Jiali Yao -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HAWQ-804) Add feature test for error table with new framework
hongwu created HAWQ-804: --- Summary: Add feature test for error table with new framework Key: HAWQ-804 URL: https://issues.apache.org/jira/browse/HAWQ-804 Project: Apache HAWQ Issue Type: Test Components: Tests Reporter: hongwu Assignee: Jiali Yao -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HAWQ-804) Add feature test for error table with new framework
[ https://issues.apache.org/jira/browse/HAWQ-804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hongwu updated HAWQ-804: Fix Version/s: 2.1.0 > Add feature test for error table with new framework > --- > > Key: HAWQ-804 > URL: https://issues.apache.org/jira/browse/HAWQ-804 > Project: Apache HAWQ > Issue Type: Test > Components: Tests >Reporter: hongwu >Assignee: Jiali Yao > Fix For: 2.1.0 > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)