[
https://issues.apache.org/jira/browse/HAWQ-346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15101377#comment-15101377
]
ASF GitHub Bot commented on HAWQ-346:
-------------------------------------
GitHub user liming01 opened a pull request:
https://github.com/apache/incubator-hawq/pull/272
HAWQ-346. Fixed assertion failure when dispatching EXPLAIN ANALYZE wi…
…th window function in optimizer off mode
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/liming01/incubator-hawq mli/expl_wdw_assert
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hawq/pull/272.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 #272
----
commit b1bbc41256e627817f0abe9bfdd954b41a72f115
Author: Ming LI <[email protected]>
Date: 2016-01-15T07:37:02Z
HAWQ-346. Fixed assertion failure when dispatching EXPLAIN ANALYZE with
window function in optimizer off mode
----
> Windown function explain cause dispatch core
> --------------------------------------------
>
> Key: HAWQ-346
> URL: https://issues.apache.org/jira/browse/HAWQ-346
> Project: Apache HAWQ
> Issue Type: Bug
> Reporter: Ming LI
> Assignee: Ming LI
>
> SET optimizer=off;
> SET gp_workfile_caching=on;
> DROP TABLE IF EXISTS perct_spill;
> CREATE TABLE perct_spill AS SELECT a, a / 10 AS b FROM generate_series(1,
> 1000000) a;
> EXPLAIN ANALYZE SELECT SUM((SELECT SUM(b) OVER () FROM perct_spill LIMIT 1))
> FROM perct_spill t;"
> (gdb) bt
> #0 0x0000003c1e832925 in raise () from /lib64/libc.so.6
> #1 0x0000003c1e834105 in abort () from /lib64/libc.so.6
> #2 0x00000000009d9c24 in ExceptionalCondition (conditionName=0xdd18b0
> "!(sliceIndex < results->sliceCapacity && si->resultBegin >= 0 &&
> si->resultBegin <= si->resultEnd && si->resultEnd <= results->resultCount)",
> errorType=0xdd1544 "FailedAssertion", fileName=0xdd1530
> "cdbdispatchresult.c", lineNumber=999) at assert.c:60
> #3 0x0000000000ac93e0 in cdbdisp_resultBegin (results=0x2d42480,
> sliceIndex=3) at cdbdispatchresult.c:996
> #4 0x0000000000aca73e in cdbexplain_recvExecStats (planstate=0x2cb3038,
> dispatchResults=0x2d42480, sliceIndex=3, showstatctx=0x2ca4908, segmentNum=1)
> at cdbexplain.c:511
> #5 0x0000000000766e64 in ExecSetParamPlan (node=0x2cc2458,
> econtext=0x2cc3800, gbl_queryDesc=0x2ca3f38) at nodeSubplan.c:1290
> #6 0x0000000000b4c947 in preprocess_initplans (queryDesc=0x2ca3f38) at
> cdbsubplan.c:154
> #7 0x00000000007149f7 in ExecutorStart (queryDesc=0x2ca3f38, eflags=0) at
> execMain.c:898
> #8 0x0000000000697a0f in ExplainOnePlan_internal (plannedstmt=0x2ca3bf8,
> stmt=0x2ae5bc8, queryString=0x2ae4168 "EXPLAIN ANALYZE SELECT SUM((SELECT
> SUM(b) OVER () FROM perct_spill LIMIT 1)) FROM perct_spill t;", params=0x0,
> tstate=0x2c86728, es=0x7fffbbd4e6b0, isSequential=0 '\000') at explain.c:510
> #9 0x0000000000697734 in ExplainOnePlan (plannedstmt=0x2ca3bf8,
> stmt=0x2ae5bc8, queryString=0x2ae4168 "EXPLAIN ANALYZE SELECT SUM((SELECT
> SUM(b) OVER () FROM perct_spill LIMIT 1)) FROM perct_spill t;", params=0x0,
> tstate=0x2c86728) at explain.c:418
> #10 0x00000000006974d4 in ExplainOneQuery (query=0x2ad1268, stmt=0x2ae5bc8,
> queryString=0x2ae4168 "EXPLAIN ANALYZE SELECT SUM((SELECT SUM(b) OVER () FROM
> perct_spill LIMIT 1)) FROM perct_spill t;", params=0x0, tstate=0x2c86728) at
> explain.c:333
> #11 0x00000000006970b6 in ExplainQuery (stmt=0x2ae5bc8, queryString=0x2ae4168
> "EXPLAIN ANALYZE SELECT SUM((SELECT SUM(b) OVER () FROM perct_spill LIMIT 1))
> FROM perct_spill t;", params=0x0, dest=0x2ad0bd0) at explain.c:178
> #12 0x00000000009024a2 in ProcessUtility (parsetree=0x2ae5bc8,
> queryString=0x2ad0968 "EXPLAIN ANALYZE SELECT SUM((SELECT SUM(b) OVER () FROM
> perct_spill LIMIT 1)) FROM perct_spill t;", params=0x0, isTopLevel=1 '\001',
> dest=0x2ad0bd0, completionTag=0x7fffbbd4eb20 "") at utility.c:1475
> #13 0x00000000008fe712 in PortalRunUtility (portal=0x2af8ad8,
> utilityStmt=0x2ae5bc8, isTopLevel=1 '\001', dest=0x2ad0bd0,
> completionTag=0x7fffbbd4eb20 "") at pquery.c:1887
> #14 0x00000000008fe424 in FillPortalStore (portal=0x2af8ad8, isTopLevel=1
> '\001') at pquery.c:1759
> #15 0x00000000008fdd37 in PortalRun (portal=0x2af8ad8,
> count=9223372036854775807, isTopLevel=1 '\001', dest=0x2ae6068,
> altdest=0x2ae6068, completionTag=0x7fffbbd4ed30 "") at pquery.c:1493
> #16 0x00000000008f380d in exec_simple_query (query_string=0x2ae4168 "EXPLAIN
> ANALYZE SELECT SUM((SELECT SUM(b) OVER () FROM perct_spill LIMIT 1)) FROM
> perct_spill t;", seqServerHost=0x0, seqServerPort=-1) at postgres.c:1744
> #17 0x00000000008f85fa in PostgresMain (argc=4, argv=0x29ef148,
> username=0x29eef48 "gpadmin") at postgres.c:4706
> #18 0x000000000089bc40 in BackendRun (port=0x29a30c0) at postmaster.c:5863
> #19 0x000000000089b0ca in BackendStartup (port=0x29a30c0) at postmaster.c:5456
> #20 0x00000000008957e3 in ServerLoop () at postmaster.c:2158
> #21 0x0000000000894706 in PostmasterMain (argc=9, argv=0x29a65f0) at
> postmaster.c:1450
> #22 0x00000000007ad91e in main (argc=9, argv=0x29a65f0) at main.c:226
> (gdb) quit
> #0 0x0000003c1e832925 in raise () from /lib64/libc.so.6
> #1 0x0000003c1e834105 in abort () from /lib64/libc.so.6
> #2 0x00000000009d9c24 in ExceptionalCondition (conditionName=0xdce8ff
> "!(nextReadLen >= 0)", errorType=0xdce5d2 "FailedAssertion",
> fileName=0xdce5c0 "cdbbufferedread.c", lineNumber=284) at assert.c:60
> #3 0x0000000000abbe11 in BufferedReadUseBeforeBuffer
> (bufferedRead=0x1d0e030, maxReadAheadLen=32768, nextBufferLen=0x7fff8a6875ac,
> isUseSplitLen=1 '\001') at cdbbufferedread.c:284
> #4 0x0000000000abc92b in BufferedReadGrowBuffer (bufferedRead=0x1d0e030,
> newMaxReadAheadLen=32768, growBufferLen=0x7fff8a6875ac, isUseSplitLen=1
> '\001') at cdbbufferedread.c:647
> #5 0x0000000000ab64d2 in AppendOnlyStorageRead_InternalGetBuffer
> (storageRead=0x1d0dfe0, header=0x7fff8a687618, content=0x7fff8a687610,
> isUseSplitLen=1 '\001') at cdbappendonlystorageread.c:1200
> #6 0x0000000000ab6a97 in AppendOnlyStorageRead_Content
> (storageRead=0x1d0dfe0, contentOut=0x1e00110 "Television:Titles:So You Think
> You Can
> Dance,Television:Titles:Sportscenter,Television:Titles:Stargate,Television:Titles:Supernatural,Television:Titles:Survivor,Television:Titles:The
> Hills,Television:"..., contentOutLen=32760, isUseSplitLen=0 '\000') at
> cdbappendonlystorageread.c:1428
> #7 0x0000000000ab6a63 in AppendOnlyStorageRead_Content
> (storageRead=0x1d0dfe0, contentOut=0x1df8118 "J\023\002\200\177\177\177\177",
> contentOutLen=136008, isUseSplitLen=0 '\000') at
> cdbappendonlystorageread.c:1401
> #8 0x000000000058afea in AppendOnlyExecutorReadBlock_GetContents
> (executorReadBlock=0x1d0df08) at appendonlyam.c:684
> #9 0x000000000058c135 in getNextBlock (scan=0x1d0dec0) at appendonlyam.c:1243
> #10 0x000000000058c1e5 in appendonlygettup (scan=0x1d0dec0,
> dir=ForwardScanDirection, nkeys=0, key=0x0, slot=0x1cb6870) at
> appendonlyam.c:1283
> #11 0x000000000058ccb4 in appendonly_getnext (scan=0x1d0dec0,
> direction=ForwardScanDirection, slot=0x1cb6870) at appendonlyam.c:1673
> #12 0x0000000000738105 in AppendOnlyScanNext (scanState=0x1d3ec10) at
> execAOScan.c:39
> #13 0x000000000072dad3 in ExecScan (node=0x1d3ec10, accessMtd=0x738024
> <AppendOnlyScanNext>) at execScan.c:110
> #14 0x000000000072e330 in ExecTableScanRelation (scanState=0x1d3ec10) at
> execScan.c:441
> #15 0x000000000076a330 in ExecTableScan (node=0x1d3ec10) at nodeTableScan.c:42
> #16 0x0000000000720288 in ExecProcNode (node=0x1d3ec10) at execProcnode.c:904
> #17 0x000000000075af35 in execMotionSender (node=0x1d3e0e8) at
> nodeMotion.c:348
> #18 0x000000000075ae20 in ExecMotion (node=0x1d3e0e8) at nodeMotion.c:315
> #19 0x0000000000720470 in ExecProcNode (node=0x1d3e0e8) at execProcnode.c:999
> #20 0x0000000000719254 in ExecutePlan (estate=0x1cb59d8, planstate=0x1d3e0e8,
> operation=CMD_SELECT, numberTuples=0, direction=ForwardScanDirection,
> dest=0x1deb510) at execMain.c:3180
> #21 0x000000000071531f in ExecutorRun (queryDesc=0x1cbcc20,
> direction=ForwardScanDirection, count=0) at execMain.c:1166
> #22 0x00000000008fb70e in ProcessQuery (portal=0x1cbaa68, stmt=0x1ceca68,
> params=0x0, dest=0x1deb510, completionTag=0x7fff8a6880f0 "") at pquery.c:301
> #23 0x00000000008fe9c4 in PortalRunMulti (portal=0x1cbaa68, isTopLevel=1
> '\001', dest=0x1deb510, altdest=0x1deb510, completionTag=0x7fff8a6880f0 "")
> at pquery.c:1969
> #24 0x00000000008fdde7 in PortalRun (portal=0x1cbaa68,
> count=9223372036854775807, isTopLevel=1 '\001', dest=0x1deb510,
> altdest=0x1deb510, completionTag=0x7fff8a6880f0 "") at pquery.c:1514
> #25 0x00000000008f2d21 in exec_mpp_query (query_string=0x1cebf02 "INSERT INTO
> huge_tuples select * FROM huge_tuples;", serializedQuerytree=0x0,
> serializedQuerytreelen=0, serializedPlantree=0x1cebf35 "P\034",
> serializedPlantreelen=1537, serializedParams=0x0, serializedParamslen=0,
> serializedSliceInfo=0x1cec536 "\351", serializedSliceInfolen=108,
> serializedResource=0x1cec5f0 "0", serializedResourceLen=39,
> seqServerHost=0x1cec617 "10.32.35.174", seqServerPort=64364, localSlice=1) at
> postgres.c:1380
> #26 0x00000000008f8d14 in PostgresMain (argc=266, argv=0x1bed448,
> username=0x1bd0f48 "gpadmin") at postgres.c:4882
> #27 0x000000000089bc40 in BackendRun (port=0x1b850c0) at postmaster.c:5863
> #28 0x000000000089b0ca in BackendStartup (port=0x1b850c0) at postmaster.c:5456
> #29 0x00000000008957e3 in ServerLoop () at postmaster.c:2158
> #30 0x0000000000894706 in PostmasterMain (argc=9, argv=0x1b885f0) at
> postmaster.c:1450
> #31 0x00000000007ad91e in main (argc=9, argv=0x1b885f0) at main.c:226
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
