[ https://issues.apache.org/jira/browse/HAWQ-346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15101388#comment-15101388 ]
ASF GitHub Bot commented on HAWQ-346: ------------------------------------- Github user jianlirong commented on the pull request: https://github.com/apache/incubator-hawq/pull/272#issuecomment-171894866 +1, LGTM. > 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)