[jira] [Resolved] (HAWQ-346) Windown function explain cause dispatch core

["Ming LI (JIRA)" <ji...@apache.org>]

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

Ming LI resolved HAWQ-346.
--------------------------
    Resolution: Fixed

> 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)