Ticket #39345

Crash from illegal parallel bitmap scan plan in REL10_1_3_3 when index name is incorrect

Open Date: 2019-06-24 23:52 Last Update: 2019-06-24 23:52

Reporter:
(Anonymous)
Owner:
(None)
Type:
Status:
Open
Component:
(None)
MileStone:
(None)
Priority:
7
Severity:
7
Resolution:
None
File:
None

Details

Query crashes with the following stack using pg_hint_plan with REL10_1_3_3 when an incorrect index name is supplied due to an illegal parallel bitmap scan plan being created. Seems to be a problem in the pg_hint_plan_set_rel_pathlist function. If we copy the master version of this function, the crash is avoided. However, we don't if it is safe to pull that fix from master to REL10.

#0 CheckVarSlotCompatibility (attnum=attnum@entry=1, vartype=23, slot=0x0) at execExprInterp.c:1549 #1 0x000000000066724b in ExecJustScanVarFirst (state=0x2ad964354708, econtext=<optimized out>, isnull=0x7ffe8f901f8f "") at execExprInterp.c:1704 #2 0x00000000006824a6 in ExecEvalExpr (isNull=0x7ffe8f901f8f "", econtext=0x2ad964354568, state=<optimized out>) at ../../../src/include/executor/executor.h:289 #3 ExecIndexEvalRuntimeKeys (econtext=econtext@entry=0x2ad964354568, runtimeKeys=<optimized out>, numRuntimeKeys=<optimized out>) at nodeIndexscan.c:655 #4 0x000000000067dd5f in ExecReScanBitmapIndexScan (node=0x2ad964354348) at nodeBitmapIndexscan.c:152 #5 0x0000000000663565 in ExecReScan (node=node@entry=0x2ad964354348) at execAmi.c:189 #6 0x000000000067dc88 in MultiExecBitmapIndexScan (node=0x2ad964354348) at nodeBitmapIndexscan.c:74 #7 0x00000000006715c9 in MultiExecProcNode (node=<optimized out>) at execProcnode.c:490 #8 0x000000000067d097 in BitmapHeapNext (node=node@entry=0x2ad96432bf38) at nodeBitmapHeapscan.c:144 #9 0x0000000000672597 in ExecScanFetch (recheckMtd=0x67c9d0 <BitmapHeapRecheck>, accessMtd=0x67ca30 <BitmapHeapNext>, node=0x2ad96432bf38) at execScan.c:97 #10 ExecScan (node=0x2ad96432bf38, accessMtd=0x67ca30 <BitmapHeapNext>, recheckMtd=0x67c9d0 <BitmapHeapRecheck>) at execScan.c:164 #11 0x0000000000671088 in ExecProcNodeInstr (node=0x2ad96432bf38) at execProcnode.c:446 #12 0x000000000068aa9f in ExecProcNode (node=0x2ad96432bf38) at ../../../src/include/executor/executor.h:250

Ticket History (1/1 Histories)

2019-06-24 23:53 Updated by: None
  • New Ticket "Crash from illegal parallel bitmap scan plan in REL10_1_3_3 when index name is incorrect" created

Attachment File List

No attachments

Edit

You are not logged in. I you are not logged in, your comment will be treated as an anonymous post. » Login