Ming LI created HAWQ-346:
----------------------------
Summary: 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: Lei Chang
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)
