[jira] [Closed] (HAWQ-475) Add build_type gcov for code coverage.

[Xiang Sheng (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HAWQ-475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Xiang Sheng closed HAWQ-475.


> Add build_type gcov for code coverage.
> --
>
> Key: HAWQ-475
> URL: https://issues.apache.org/jira/browse/HAWQ-475
> Project: Apache HAWQ
>  Issue Type: Improvement
>  Components: Build
>Reporter: Xiang Sheng
>Assignee: Lei Chang
>




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

[jira] [Commented] (HAWQ-475) Add build_type gcov for code coverage.

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-475:
-

Github user stanlyxiang closed the pull request at:

https://github.com/apache/incubator-hawq/pull/398


> Add build_type gcov for code coverage.
> --
>
> Key: HAWQ-475
> URL: https://issues.apache.org/jira/browse/HAWQ-475
> Project: Apache HAWQ
>  Issue Type: Improvement
>  Components: Build
>Reporter: Xiang Sheng
>Assignee: Lei Chang
>




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

[jira] [Commented] (HAWQ-477) Copy table to file do not real execute for lineitem.

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-477:
-

Github user asfgit closed the pull request at:

https://github.com/apache/incubator-hawq/pull/400


> Copy table to file do not real execute for lineitem.
> 
>
> Key: HAWQ-477
> URL: https://issues.apache.org/jira/browse/HAWQ-477
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Reporter: Hubert Zhang
>Assignee: Hubert Zhang
>
> Copy table to file do not real execute for lineitem for partition table



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

[jira] [Commented] (HAWQ-477) Copy table to file do not real execute for lineitem.

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-477:
-

Github user wengyanqing commented on the pull request:

https://github.com/apache/incubator-hawq/pull/400#issuecomment-191023075
  
+1


> Copy table to file do not real execute for lineitem.
> 
>
> Key: HAWQ-477
> URL: https://issues.apache.org/jira/browse/HAWQ-477
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Reporter: Hubert Zhang
>Assignee: Hubert Zhang
>
> Copy table to file do not real execute for lineitem for partition table



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

[jira] [Commented] (HAWQ-475) Add build_type gcov for code coverage.

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-475:
-

Github user yaoj2 commented on the pull request:

https://github.com/apache/incubator-hawq/pull/398#issuecomment-191022396
  
+1


> Add build_type gcov for code coverage.
> --
>
> Key: HAWQ-475
> URL: https://issues.apache.org/jira/browse/HAWQ-475
> Project: Apache HAWQ
>  Issue Type: Improvement
>  Components: Build
>Reporter: Xiang Sheng
>Assignee: Lei Chang
>




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

[jira] [Commented] (HAWQ-476) Unexpected internal error in execHHashagg.

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-476:
-

Github user wengyanqing commented on the pull request:

https://github.com/apache/incubator-hawq/pull/399#issuecomment-191022405
  
+1


> Unexpected internal error in execHHashagg.
> --
>
> Key: HAWQ-476
> URL: https://issues.apache.org/jira/browse/HAWQ-476
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Reporter: Hubert Zhang
>Assignee: Hubert Zhang
>
> when we run query on big cluster, we encounter Unexpected Internal Error in 
> execHHashagg. with errormessage too many passes or hash entries in pg_logs



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

[jira] [Commented] (HAWQ-475) Add build_type gcov for code coverage.

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-475:
-

Github user radarwave commented on the pull request:

https://github.com/apache/incubator-hawq/pull/398#issuecomment-191021984
  
Looks good to me. +1


> Add build_type gcov for code coverage.
> --
>
> Key: HAWQ-475
> URL: https://issues.apache.org/jira/browse/HAWQ-475
> Project: Apache HAWQ
>  Issue Type: Improvement
>  Components: Build
>Reporter: Xiang Sheng
>Assignee: Lei Chang
>




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

[jira] [Commented] (HAWQ-455) Disable creating partition tables with non uniform bucket schema

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-455:
-

Github user hsyuan commented on a diff in the pull request:

https://github.com/apache/incubator-hawq/pull/387#discussion_r54669862
  
--- Diff: src/backend/commands/tablecmds.c ---
@@ -13758,6 +13758,24 @@ ATPExecPartAdd(AlteredTableInfo *tab,
 errhint("use a named partition"),
   
errOmitLocation(true)));
 
+   PartitionElem *pElem = (PartitionElem *) pc2->arg1;
+   Node *pStoreAttr = pElem->storeAttr;
+   if (pStoreAttr && ((AlterPartitionCmd *)pStoreAttr)->arg1)
+   {
+   List *pWithList = (List *)(((AlterPartitionCmd 
*)pStoreAttr)->arg1);
+   GpPolicy *parentPolicy = GpPolicyFetch(CurrentMemoryContext, 
RelationGetRelid(rel));
+   int bucketnum = parentPolicy->bucketnum;
--- End diff --

make sense


> Disable creating partition tables with non uniform bucket schema 
> -
>
> Key: HAWQ-455
> URL: https://issues.apache.org/jira/browse/HAWQ-455
> Project: Apache HAWQ
>  Issue Type: Improvement
>  Components: DDL
>Reporter: Haisheng Yuan
>Assignee: Lei Chang
>
> HAWQ user should not be able to create partition tables with non uniform 
> bucket schema so that don't make orca trip up when it queries across a single 
> partition. Or else the user should see an error message.



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

[jira] [Commented] (HAWQ-455) Disable creating partition tables with non uniform bucket schema

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-455:
-

Github user hsyuan commented on a diff in the pull request:

https://github.com/apache/incubator-hawq/pull/387#discussion_r54669793
  
--- Diff: src/backend/commands/tablecmds.c ---
@@ -13758,6 +13758,24 @@ ATPExecPartAdd(AlteredTableInfo *tab,
 errhint("use a named partition"),
   
errOmitLocation(true)));
 
+   PartitionElem *pElem = (PartitionElem *) pc2->arg1;
+   Node *pStoreAttr = pElem->storeAttr;
+   if (pStoreAttr && ((AlterPartitionCmd *)pStoreAttr)->arg1)
+   {
+   List *pWithList = (List *)(((AlterPartitionCmd 
*)pStoreAttr)->arg1);
+   GpPolicy *parentPolicy = GpPolicyFetch(CurrentMemoryContext, 
RelationGetRelid(rel));
+   int bucketnum = parentPolicy->bucketnum;
+   int child_bucketnum = 
GetRelOpt_bucket_num_fromOptions(pWithList, bucketnum);
+
+   if (child_bucketnum != bucketnum)
+   ereport(ERROR,
+   
(errcode(ERRCODE_GP_FEATURE_NOT_SUPPORTED),
+   errmsg("distribution 
policy for partition%s "
--- End diff --

The other parts of this file use the same format. %s here in fact contains 
"", so no need to add quotes here. 


> Disable creating partition tables with non uniform bucket schema 
> -
>
> Key: HAWQ-455
> URL: https://issues.apache.org/jira/browse/HAWQ-455
> Project: Apache HAWQ
>  Issue Type: Improvement
>  Components: DDL
>Reporter: Haisheng Yuan
>Assignee: Lei Chang
>
> HAWQ user should not be able to create partition tables with non uniform 
> bucket schema so that don't make orca trip up when it queries across a single 
> partition. Or else the user should see an error message.



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

[jira] [Created] (HAWQ-480) HAWQ RM does not calculate correct yarn cluster volume

[Yi Jin (JIRA)]

Yi Jin created HAWQ-480:
---

 Summary: HAWQ RM does not calculate correct yarn cluster volume
 Key: HAWQ-480
 URL: https://issues.apache.org/jira/browse/HAWQ-480
 Project: Apache HAWQ
  Issue Type: Bug
  Components: Resource Manager
Reporter: Yi Jin
Assignee: Lei Chang


PST,,,p52869,th11406317440,con4,,seg-1,"LOG","0","Removed 
pending GRM request from root resource queue by (2048 MB, 1.00 CORE) to (0 
MB, 0.00 CORE)",,,0,,"resqueuemanager.c",4343,
2016-02-29 22:34:17.481384 
PST,,,p52869,th11406317440,con4,,seg-1,"FATAL","XX000","HAWQ RM 
Validation. Allocated too much resource in resource pool. (8192 MB, 4.00 
CORE) (resourcepool.c:3835)",,,0,,"resourcepool.c",3835,"Stack trace:
10x87152f postgres  + 0x87152f
20x871c09 postgres elog_finish + 0xa9
30x8ddd41 postgres validateResourcePoolStatus + 0x501
40x8fd517 postgres MainHandlerLoop + 0x1a7
50x8fda20 postgres ResManagerMainServer2ndPhase + 0x1e0
60x8fde54 postgres ResManagerMain + 0x394
70x8fe1e1 postgres ResManagerProcessStartup + 0x181
80x75e0c8 postgres  + 0x75e0c8
90x75ef82 postgres  + 0x75ef82
10   0x76432d postgres  + 0x76432d
11   0x765e8e postgres PostmasterMain + 0xc7e
12   0x6c029a postgres main + 0x48a
13   0x3c1e81ed1d libc.so.6 __libc_start_main + 0xfd
14   0x4a1c39 postgres  + 0x4a1c39
"



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

[jira] [Assigned] (HAWQ-480) HAWQ RM does not calculate correct yarn cluster volume

[Yi Jin (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HAWQ-480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yi Jin reassigned HAWQ-480:
---

Assignee: Yi Jin  (was: Lei Chang)

> HAWQ RM does not calculate correct yarn cluster volume
> --
>
> Key: HAWQ-480
> URL: https://issues.apache.org/jira/browse/HAWQ-480
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Resource Manager
>Reporter: Yi Jin
>Assignee: Yi Jin
>
> PST,,,p52869,th11406317440,con4,,seg-1,"LOG","0","Removed 
> pending GRM request from root resource queue by (2048 MB, 1.00 CORE) to 
> (0 MB, 0.00 CORE)",,,0,,"resqueuemanager.c",4343,
> 2016-02-29 22:34:17.481384 
> PST,,,p52869,th11406317440,con4,,seg-1,"FATAL","XX000","HAWQ RM 
> Validation. Allocated too much resource in resource pool. (8192 MB, 4.00 
> CORE) (resourcepool.c:3835)",,,0,,"resourcepool.c",3835,"Stack trace:
> 10x87152f postgres  + 0x87152f
> 20x871c09 postgres elog_finish + 0xa9
> 30x8ddd41 postgres validateResourcePoolStatus + 0x501
> 40x8fd517 postgres MainHandlerLoop + 0x1a7
> 50x8fda20 postgres ResManagerMainServer2ndPhase + 0x1e0
> 60x8fde54 postgres ResManagerMain + 0x394
> 70x8fe1e1 postgres ResManagerProcessStartup + 0x181
> 80x75e0c8 postgres  + 0x75e0c8
> 90x75ef82 postgres  + 0x75ef82
> 10   0x76432d postgres  + 0x76432d
> 11   0x765e8e postgres PostmasterMain + 0xc7e
> 12   0x6c029a postgres main + 0x48a
> 13   0x3c1e81ed1d libc.so.6 __libc_start_main + 0xfd
> 14   0x4a1c39 postgres  + 0x4a1c39
> "



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

[jira] [Commented] (HAWQ-479) Upgrade JSON-C dependency from 0.6 to 0.12

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-479:
-

Github user xinzweb commented on the pull request:

https://github.com/apache/incubator-hawq/pull/401#issuecomment-191004069
  
+1


> Upgrade JSON-C dependency from 0.6 to 0.12
> --
>
> Key: HAWQ-479
> URL: https://issues.apache.org/jira/browse/HAWQ-479
> Project: Apache HAWQ
>  Issue Type: Improvement
>  Components: Build
>Reporter: xin zhang
>Assignee: Lei Chang
>
> In order to support building HAWQ with GPORCA, we have to bump the JSON-C 
> version from 0.6 to 0.12.
> This requires changing the path of JSON from *json/json.h* to *json-c/json.h*.



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

[jira] [Commented] (HAWQ-479) Upgrade JSON-C dependency from 0.6 to 0.12

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-479:
-

Github user GodenYao commented on the pull request:

https://github.com/apache/incubator-hawq/pull/401#issuecomment-191005116
  
+1


> Upgrade JSON-C dependency from 0.6 to 0.12
> --
>
> Key: HAWQ-479
> URL: https://issues.apache.org/jira/browse/HAWQ-479
> Project: Apache HAWQ
>  Issue Type: Improvement
>  Components: Build
>Reporter: xin zhang
>Assignee: Lei Chang
>
> In order to support building HAWQ with GPORCA, we have to bump the JSON-C 
> version from 0.6 to 0.12.
> This requires changing the path of JSON from *json/json.h* to *json-c/json.h*.



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

[jira] [Created] (HAWQ-479) Upgrade JSON-C dependency from 0.6 to 0.12

[xin zhang (JIRA)]

xin zhang created HAWQ-479:
--

 Summary: Upgrade JSON-C dependency from 0.6 to 0.12
 Key: HAWQ-479
 URL: https://issues.apache.org/jira/browse/HAWQ-479
 Project: Apache HAWQ
  Issue Type: Improvement
  Components: Build
Reporter: xin zhang
Assignee: Lei Chang


In order to support building HAWQ with GPORCA, we have to bump the JSON-C 
version from 0.6 to 0.12.

This requires changing the path of JSON from *json/json.h* to *json-c/json.h*.



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

[jira] [Commented] (HAWQ-404) Add sort during INSERT of append only row oriented partition tables

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-404:
-

Github user hsyuan commented on a diff in the pull request:

https://github.com/apache/incubator-hawq/pull/392#discussion_r54654661
  
--- Diff: src/include/nodes/plannodes.h ---
@@ -1149,6 +1149,7 @@ typedef struct DML
AttrNumber  actionColIdx;   /* index of action column into the 
target list */
AttrNumber  ctidColIdx; /* index of ctid column into 
the target list */
AttrNumber  tupleoidColIdx; /* index of tuple oid column into the 
target list */
+   boolneedsSort;  /* needs the data to be sorted 
*/
 
--- End diff --

Changed.


> Add sort during INSERT of append only row oriented partition tables
> ---
>
> Key: HAWQ-404
> URL: https://issues.apache.org/jira/browse/HAWQ-404
> Project: Apache HAWQ
>  Issue Type: Improvement
>Reporter: Haisheng Yuan
>Assignee: Lei Chang
>




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

[jira] [Commented] (HAWQ-404) Add sort during INSERT of append only row oriented partition tables

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-404:
-

Github user hsyuan commented on the pull request:

https://github.com/apache/incubator-hawq/pull/392#issuecomment-190862743
  
Currently, only the first 2 cases will set the flag to true. no other case 
at this moment.

@vraghavan78 


> Add sort during INSERT of append only row oriented partition tables
> ---
>
> Key: HAWQ-404
> URL: https://issues.apache.org/jira/browse/HAWQ-404
> Project: Apache HAWQ
>  Issue Type: Improvement
>Reporter: Haisheng Yuan
>Assignee: Lei Chang
>




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

[jira] [Commented] (HAWQ-404) Add sort during INSERT of append only row oriented partition tables

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-404:
-

Github user gcaragea commented on the pull request:

https://github.com/apache/incubator-hawq/pull/392#issuecomment-190855167
  
Just to confirm: this new flag in the DML node is set in all cases when the 
input is sorted on partition id. By "all cases" I mean: 
- destination is AO table, and number of parts is > 
optimizer_parts_to_force_sort_on_insert
- destination is Parquet table and gp_parquet_insert_sort is true
- any other case when ORCA inserts a sort on partition id before the DML 
node

Correct?


> Add sort during INSERT of append only row oriented partition tables
> ---
>
> Key: HAWQ-404
> URL: https://issues.apache.org/jira/browse/HAWQ-404
> Project: Apache HAWQ
>  Issue Type: Improvement
>Reporter: Haisheng Yuan
>Assignee: Lei Chang
>




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

[jira] [Commented] (HAWQ-471) Reindex bug

[Dong Li (JIRA)]

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

Dong Li commented on HAWQ-471:
--

This situation is cause by HAWQ-478.

> Reindex bug
> ---
>
> Key: HAWQ-471
> URL: https://issues.apache.org/jira/browse/HAWQ-471
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Catalog
>Reporter: Dong Li
>Assignee: Lei Chang
>
> cr_workload=#   reindex  index pg_class_relname_nsp_index;
> ERROR:  index "pg_class_relname_nsp_index" contains unexpected zero page at 
> block 20
> HINT:  Please REINDEX it.
> The index of pg_class_relname_nsp has problem and error out "index 
> "pg_class_relname_nsp_index" contains unexpected zero page at block 20". 
> But if we reindex it, it errors it out again.
> So it is a recurse bug and the index can never be fixed.



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

[jira] [Created] (HAWQ-478) Bug when shut down cluster during recovery pass3

[Dong Li (JIRA)]

Dong Li created HAWQ-478:


 Summary: Bug when shut down cluster during recovery pass3   
 Key: HAWQ-478
 URL: https://issues.apache.org/jira/browse/HAWQ-478
 Project: Apache HAWQ
  Issue Type: Bug
  Components: Transaction
Reporter: Dong Li
Assignee: Lei Chang


 Shutting down cluster when master  recovering in  pass3   cause inconsistency 
between pg_class and gp_persistent table.
And it cause data loss.
{code}
2016-03-01 01:56:33.032318 
PST,,,p119941,th7312979840,,,seg-1,"LOG","0","checkpoint record 
is at 0/302AD30",,,0,,"xlog.c",6304,
2016-03-01 01:56:33.032337 
PST,,,p119941,th7312979840,,,seg-1,"LOG","0","redo record is at 
0/302AD30; undo record is at 0/0; shutdown FALSE",,,0,,"xlog.c",6338,
2016-03-01 01:56:33.032353 
PST,,,p119941,th7312979840,,,seg-1,"LOG","0","next transaction 
ID: 0/1045; next OID: 24726",,,0,,"xlog.c",6342,
2016-03-01 01:56:33.032367 
PST,,,p119941,th7312979840,,,seg-1,"LOG","0","next MultiXactId: 
1; next MultiXactOffset: 0",,,0,,"xlog.c",6345,
2016-03-01 01:56:33.032382 
PST,,,p119941,th7312979840,,,seg-1,"LOG","0","database system 
was not properly shut down; automatic recovery in 
progress",,,0,,"xlog.c",6434,
2016-03-01 01:56:33.033329 
PST,,,p119941,th7312979840,,,seg-1,"LOG","0","redo starts at 
0/302AD80",,,0,,"xlog.c",6523,
2016-03-01 01:56:33.089749 
PST,,,p119941,th7312979840,,,seg-1,"LOG","0","record with zero 
length at 0/77A7708",,,0,,"xlog.c",4110,
2016-03-01 01:56:33.089792 
PST,,,p119941,th7312979840,,,seg-1,"LOG","0","redo done at 
0/77A76D8",,,0,,"xlog.c",6560,
2016-03-01 01:56:33.089893 
PST,,,p119941,th7312979840,,,seg-1,"LOG","0","end of 
transaction log location is 0/77A7708",,,0,,"xlog.c",6582,
2016-03-01 01:56:33.738889 
PST,,,p119941,th7312979840,,,seg-1,"LOG","0","Finished startup 
pass 1.  Proceeding to startup crash recovery passes 2 and 
3.",,,0,,"xlog.c",6816,
2016-03-01 01:56:34.525387 
PST,,,p118947,th7312979840,,,seg-1,"LOG","0","received smart 
shutdown request",,,0,,"postmaster.c",3447,
2016-03-01 01:56:35.042857 
PST,,,p119958,th7312979840,,,seg-1,"WARNING","XX000","could not 
remove relation directory 16385/16536/20219: Success 
(smgr.c:1049)","Dropping file-system object -- Relation Directory: 
'16385/16536/20219'",,0,,"smgr.c",1049,
2016-03-01 01:56:35.131058 
PST,,,p119958,th7312979840,,,seg-1,"WARNING","XX000","could not 
remove relation directory 16385/16536/16894: Success 
(smgr.c:1049)","Dropping file-system object -- Relation Directory: 
'16385/16536/16894'",,0,,"smgr.c",1049,
2016-03-01 01:56:35.584893 
PST,,,p119958,th7312979840,,,seg-1,"LOG","0","Finished startup 
crash recovery pass 2",,,0,,"xlog.c",6987,
2016-03-01 01:56:35.590423 
PST,,,p120017,th7312979840,,,seg-1,"LOG","0","shutting 
down",,,0,,"xlog.c",7853,
2016-03-01 01:56:35.592973 
PST,,,p120017,th7312979840,,,seg-1,"LOG","0","database system 
is shut down",,,0,,"xlog.c",7874,
{code}


{code}
cr_workload=# select *  from pg_class where relname like 'create_insert%' and 
relname not like '%prt%';
relname | relnamespace | reltype | relowner | relam | relfilenode | 
reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid | 
relaosegrelid | relaosegidxid | relhasindex | relisshared | relkind | 
relstorage | relnatts | relchecks | reltriggers | relukeys | relfkeys | relrefs 
| relhasoids | relh
aspkey | relhasrules | relhassubclass | relfrozenxid | relacl |reloptions
+--+-+--+---+-+---+--+---+---+---+---+---+-+-+-++--+---+-+--+--+-++-
---+-++--++---
 create_insert1 | 2200 |  696503 |   10 | 0 |  702761 | 
0 |0 | 0 | 0 | 0 | 
0 | 0 | f   | f   | r   | a  |3 
| 0 |   0 |0 |0 |   0 | f  | f
   | f   | t  |11609 || 
{appendonly=true}
(1 row)

cr_workload=# \d
No relations found.
cr_workload=# select * from create_insert1;
ERROR:  relation "create_insert1" does not exist
LINE 1: select * from create_insert1;
  ^
cr_workload=# select * from gp_persistent_relation_node where relfilenode_oid = 
702761;
 tablespace_oid | database_oid | relfilenode_oid | persistent_state | reserved 
| 

[jira] [Commented] (HAWQ-477) Copy table to file do not real execute for lineitem.

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-477:
-

GitHub user zhangh43 opened a pull request:

https://github.com/apache/incubator-hawq/pull/400

HAWQ-477. Copy table to file do not real execute for lineitem.



You can merge this pull request into a Git repository by running:

$ git pull https://github.com/zhangh43/incubator-hawq hawq4772

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-hawq/pull/400.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 #400


commit fa3ad0b2e02e705029cc56834944aacd9b14c7a4
Author: hubertzhang 
Date:   2016-03-01T09:35:28Z

HAWQ-477. Copy table to file do not real execute for lineitem.




> Copy table to file do not real execute for lineitem.
> 
>
> Key: HAWQ-477
> URL: https://issues.apache.org/jira/browse/HAWQ-477
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Reporter: Hubert Zhang
>Assignee: Hubert Zhang
>
> Copy table to file do not real execute for lineitem for partition table



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

[jira] [Assigned] (HAWQ-477) Copy table to file do not real execute for lineitem.

[Hubert Zhang (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HAWQ-477?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Hubert Zhang reassigned HAWQ-477:
-

Assignee: Hubert Zhang  (was: Lei Chang)

> Copy table to file do not real execute for lineitem.
> 
>
> Key: HAWQ-477
> URL: https://issues.apache.org/jira/browse/HAWQ-477
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Reporter: Hubert Zhang
>Assignee: Hubert Zhang
>
> Copy table to file do not real execute for lineitem for partition table



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

[jira] [Created] (HAWQ-477) Copy table to file do not real execute for lineitem.

[Hubert Zhang (JIRA)]

Hubert Zhang created HAWQ-477:
-

 Summary: Copy table to file do not real execute for lineitem.
 Key: HAWQ-477
 URL: https://issues.apache.org/jira/browse/HAWQ-477
 Project: Apache HAWQ
  Issue Type: Bug
  Components: Core
Reporter: Hubert Zhang
Assignee: Lei Chang


Copy table to file do not real execute for lineitem for partition table



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

[jira] [Commented] (HAWQ-476) Unexpected internal error in execHHashagg.

[ASF GitHub Bot (JIRA)]

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

ASF GitHub Bot commented on HAWQ-476:
-

GitHub user zhangh43 opened a pull request:

https://github.com/apache/incubator-hawq/pull/399

HAWQ-476. Unexpected internal error in execHHashagg.

bucketnum will exceed INT_MAX

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/zhangh43/incubator-hawq hawq476

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/incubator-hawq/pull/399.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 #399


commit c479fc6811601e7a47ccae92dca0f157b28fa4cd
Author: hubertzhang 
Date:   2016-03-01T09:00:59Z

HAWQ-476. Unexpected internal error in execHHashagg.




> Unexpected internal error in execHHashagg.
> --
>
> Key: HAWQ-476
> URL: https://issues.apache.org/jira/browse/HAWQ-476
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Reporter: Hubert Zhang
>Assignee: Hubert Zhang
>
> when we run query on big cluster, we encounter Unexpected Internal Error in 
> execHHashagg. with errormessage too many passes or hash entries in pg_logs



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

[jira] [Assigned] (HAWQ-476) Unexpected internal error in execHHashagg.

[Hubert Zhang (JIRA)]

 [ 
https://issues.apache.org/jira/browse/HAWQ-476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Hubert Zhang reassigned HAWQ-476:
-

Assignee: Hubert Zhang  (was: Lei Chang)

> Unexpected internal error in execHHashagg.
> --
>
> Key: HAWQ-476
> URL: https://issues.apache.org/jira/browse/HAWQ-476
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Reporter: Hubert Zhang
>Assignee: Hubert Zhang
>
> when we run query on big cluster, we encounter Unexpected Internal Error in 
> execHHashagg. with errormessage too many passes or hash entries in pg_logs



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

[jira] [Created] (HAWQ-476) Unexpected internal error in execHHashagg.

[Hubert Zhang (JIRA)]

Hubert Zhang created HAWQ-476:
-

 Summary: Unexpected internal error in execHHashagg.
 Key: HAWQ-476
 URL: https://issues.apache.org/jira/browse/HAWQ-476
 Project: Apache HAWQ
  Issue Type: Bug
  Components: Core
Reporter: Hubert Zhang
Assignee: Lei Chang


when we run query on big cluster, we encounter Unexpected Internal Error in 
execHHashagg. with errormessage too many passes or hash entries in pg_logs



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