Re: [HACKERS] mysql_fdw + PG10: unrecognized node type: 217

Re: Tom Lane 2017-09-10 <13662.1505077015@sss.pgh.pa.us>
> Christoph Berg <myon@debian.org> writes:
> > I'm not sure if this is a bug in mysql_fdw, or in PG10:
> 
> > ! ERROR:  unrecognized node type: 217
> 
> Hm, nodetag 217 is T_List according to gdb.  Wouldn't expect that
> failure in very many places.  If you could get a stack trace from
> the errfinish call, it might help narrow things down.
> 
> Offhand my bet is on mysql_fdw needing an update for some PG10
> change, but that's just a guess.

postgres=# select test_param_where();
FEHLER:  XX000: unrecognized node type: 217
KONTEXT:  SQL-Anweisung »select b        from numbers where a=x«
PL/pgSQL-Funktion test_param_where() Zeile 6 bei SQL-Anweisung
ORT:  ExecInitExprRec, execExpr.c:2031

(gdb) b execExpr.c:2031
Breakpoint 2 at 0x55d5a728e530: file ./build/../src/backend/executor/execExpr.c, line 2031.
(gdb) c
Continuing.

Breakpoint 2, ExecInitExprRec (node=<optimized out>, parent=parent@entry=0x55d5a8766368,
state=state@entry=0x55d5a87667d0,resv=resv@entry=0x55d5a87667d8, resnull=resnull@entry=0x55d5a87667d5 "")   at
./build/../src/backend/executor/execExpr.c:2034
2034    ./build/../src/backend/executor/execExpr.c: Datei oder Verzeichnis nicht gefunden.
(gdb) bt f
#0  ExecInitExprRec (node=<optimized out>, parent=parent@entry=0x55d5a8766368, state=state@entry=0x55d5a87667d0,
resv=resv@entry=0x55d5a87667d8,resnull=resnull@entry=0x55d5a87667d5 "")   at
./build/../src/backend/executor/execExpr.c:2034      scratch = {opcode = 20, resvalue = 0x55d5a87667d8, resnull =
0x55d5a87667d5"", d = {fetch = {             last_var = -1468635040}, var = {attnum = -1468635040, vartype = 21973},
wholerow= {             var = 0x55d5a8766860, first = -72 '\270', slow = 104 'h',              tupdesc = 0x7f9e21220140
<plpgsql_call_handler>,junkFilter = 0x55d500000000}, assign_var = {             resultnum = -1468635040, attnum =
21973},assign_tmp = {resultnum = -1468635040}, constval = {             value = 94376142727264, isnull = -72 '\270'},
func= {finfo = 0x55d5a8766860,              fcinfo_data = 0x55d5a87668b8, fn_addr = 0x7f9e21220140
<plpgsql_call_handler>,nargs = 0}, boolexpr = {             anynull = 0x55d5a8766860 "@\001\"!\236\177", jumpdone =
-1468634952},qualexpr = {             jumpdone = -1468635040}, jump = {jumpdone = -1468635040}, nulltest_row = {argdesc
=0x55d5a8766860},            param = {paramid = -1468635040, paramtype = 21973}, casetest = {value = 0x55d5a8766860,
         isnull = 0x55d5a87668b8 "`hv\250\325U"}, make_readonly = {value = 0x55d5a8766860,              isnull =
0x55d5a87668b8"`hv\250\325U"}, iocoerce = {finfo_out = 0x55d5a8766860,              fcinfo_data_out = 0x55d5a87668b8,
finfo_in= 0x7f9e21220140 <plpgsql_call_handler>,              fcinfo_data_in = 0x55d500000000}, sqlvaluefunction = {svf
=0x55d5a8766860}, nextvalueexpr = {             seqid = 2826332256, seqtypid = 21973}, arrayexpr = {elemvalues =
0x55d5a8766860,             elemnulls = 0x55d5a87668b8 "`hv\250\325U", nelems = 555876672, elemtype = 32670, elemlength
=0,              elembyval = 0 '\000', elemalign = 0 '\000', multidims = -43 '\325'}, arraycoerce = {
coerceexpr= 0x55d5a8766860, resultelemtype = 2826332344,              elemfunc = 0x7f9e21220140 <plpgsql_call_handler>,
amstate= 0x55d500000000}, row = {             tupdesc = 0x55d5a8766860, elemvalues = 0x55d5a87668b8,
elemnulls= 0x7f9e21220140 <plpgsql_call_handler> "UH\211\345ATSH\201", <incomplete sequence \354>},
rowcompare_step= {finfo = 0x55d5a8766860, fcinfo_data = 0x55d5a87668b8,              fn_addr = 0x7f9e21220140
<plpgsql_call_handler>,jumpnull = 0, jumpdone = 21973}, rowcompare_final = {             rctype = 2826332256}, minmax =
{values= 0x55d5a8766860, nulls = 0x55d5a87668b8 "`hv\250\325U",              nelems = 555876672, op = (unknown: 32670),
finfo= 0x55d500000000, fcinfo_data = 0x55d5a86d5df8},            fieldselect = {fieldnum = 26720, resulttype = 21973,
argdesc= 0x55d5a87668b8}, fieldstore = {             fstore = 0x55d5a8766860, argdesc = 0x55d5a87668b8, values =
0x7f9e21220140<plpgsql_call_handler>,              nulls = 0x55d500000000 <error: Cannot access memory at address
0x55d500000000>,             ncolumns = -1469227528}, arrayref_subscript = {state = 0x55d5a8766860, off = -1468634952,
           isupper = -43 '\325', jumpdone = 555876672}, arrayref = {state = 0x55d5a8766860}, domaincheck = {
constraintname = 0x55d5a8766860 "@\001\"!\236\177", checkvalue = 0x55d5a87668b8,              checknull =
0x7f9e21220140<plpgsql_call_handler> "UH\211\345ATSH\201", <incomplete sequence \354>,              resulttype = 0},
convert_rowtype= {convert = 0x55d5a8766860, indesc = 0x55d5a87668b8,              outdesc = 0x7f9e21220140
<plpgsql_call_handler>,map = 0x55d500000000, initialized = -8 '\370'},            scalararrayop = {element_type =
2826332256,useOr = -43 '\325', typlen = 0, typbyval = -72 '\270',              typalign = 104 'h', finfo =
0x7f9e21220140<plpgsql_call_handler>, fcinfo_data = 0x55d500000000,              fn_addr = 0x55d5a86d5df8}, xmlexpr =
{xexpr= 0x55d5a8766860, named_argvalue = 0x55d5a87668b8,              named_argnull = 0x7f9e21220140
<plpgsql_call_handler>"UH\211\345ATSH\201", <incomplete sequence \354>, argvalue = 0x55d500000000, argnull =
0x55d5a86d5df8"\300]m\250\325U"}, aggref = {astate = 0x55d5a8766860},            grouping_func = {parent =
0x55d5a8766860,clauses = 0x55d5a87668b8}, window_func = {             wfstate = 0x55d5a8766860}, subplan = {sstate =
0x55d5a8766860},alternative_subplan = {             asstate = 0x55d5a8766860}}}       __func__ = "ExecInitExprRec"
 
#1  0x000055d5a7291957 in ExecBuildProjectionInfo (targetList=<optimized out>, econtext=<optimized out>,
slot=<optimizedout>, parent=parent@entry=0x55d5a8766368, inputDesc=inputDesc@entry=0x0)   at
./build/../src/backend/executor/execExpr.c:401      variable = <optimized out>       attnum = <optimized out>
isSafeVar= 0 '\000'       projInfo = 0x55d5a87667c8       state = 0x55d5a87667d0       scratch = {opcode =
140729302326160,resvalue = 0x1, resnull = 0x55d5a8766670 "\001", d = {fetch = {             last_var = -1468636848},
var= {attnum = -1468636848, vartype = 21973}, wholerow = {             var = 0x55d5a8766150, first = 16 '\020', slow =
0'\000', tupdesc = 0x55d5a86d5df8,              junkFilter = 0x7ffe18131bc0}, assign_var = {resultnum = -1468636848,
attnum= 21973}, assign_tmp = {             resultnum = -1468636848}, constval = {value = 94376142725456, isnull = 16
'\020'},func = {             finfo = 0x55d5a8766150, fcinfo_data = 0x10, fn_addr = 0x55d5a86d5df8, nargs = 403905472},
boolexpr= {             anynull = 0x55d5a8766150 "\006", jumpdone = 16}, qualexpr = {jumpdone = -1468636848}, jump = {
          jumpdone = -1468636848}, nulltest_row = {argdesc = 0x55d5a8766150}, param = {paramid = -1468636848,
  paramtype = 21973}, casetest = {value = 0x55d5a8766150,              isnull = 0x10 <error: Cannot access memory at
address0x10>}, make_readonly = {value = 0x55d5a8766150,              isnull = 0x10 <error: Cannot access memory at
address0x10>}, iocoerce = {finfo_out = 0x55d5a8766150,              fcinfo_data_out = 0x10, finfo_in = 0x55d5a86d5df8,
fcinfo_data_in= 0x7ffe18131bc0},            sqlvaluefunction = {svf = 0x55d5a8766150}, nextvalueexpr = {seqid =
2826330448,seqtypid = 21973},            arrayexpr = {elemvalues = 0x55d5a8766150,              elemnulls = 0x10
<error:Cannot access memory at address 0x10>, nelems = -1469227528,              elemtype = 21973, elemlength = 7104,
elembyval= 19 '\023', elemalign = 24 '\030', 
 
---Type <return> to continue, or q <return> to quit---             multidims = -2 '\376'}, arraycoerce = {coerceexpr =
0x55d5a8766150,resultelemtype = 16,              elemfunc = 0x55d5a86d5df8, amstate = 0x7ffe18131bc0}, row = {tupdesc =
0x55d5a8766150,             elemvalues = 0x10, elemnulls = 0x55d5a86d5df8 "\300]m\250\325U"}, rowcompare_step = {
     finfo = 0x55d5a8766150, fcinfo_data = 0x10, fn_addr = 0x55d5a86d5df8, jumpnull = 403905472,              jumpdone
=32766}, rowcompare_final = {rctype = 2826330448}, minmax = {values = 0x55d5a8766150,              nulls = 0x10 <error:
Cannotaccess memory at address 0x10>, nelems = -1469227528,              op = (IS_LEAST | unknown: 21972), finfo =
0x7ffe18131bc0,             fcinfo_data = 0x55d5a753928f <MemoryContextAlloc+63>}, fieldselect = {fieldnum = 24912,
        resulttype = 21973, argdesc = 0x10}, fieldstore = {fstore = 0x55d5a8766150, argdesc = 0x10,              values
=0x55d5a86d5df8, nulls = 0x7ffe18131bc0 "\340\033\023\030\376\177", ncolumns = -1487695217},
arrayref_subscript= {state = 0x55d5a8766150, off = 16, isupper = 0 '\000', jumpdone = -1469227528},            arrayref
={state = 0x55d5a8766150}, domaincheck = {constraintname = 0x55d5a8766150 "\006",              checkvalue = 0x10,
checknull= 0x55d5a86d5df8 "\300]m\250\325U", resulttype = 403905472},            convert_rowtype = {convert =
0x55d5a8766150,indesc = 0x10, outdesc = 0x55d5a86d5df8,              map = 0x7ffe18131bc0, initialized = -113 '\217'},
scalararrayop= {element_type = 2826330448,              useOr = -43 '\325', typlen = 0, typbyval = 16 '\020', typalign
=0 '\000', finfo = 0x55d5a86d5df8,              fcinfo_data = 0x7ffe18131bc0, fn_addr = 0x55d5a753928f
<MemoryContextAlloc+63>},xmlexpr = {             xexpr = 0x55d5a8766150, named_argvalue = 0x10, named_argnull =
0x55d5a86d5df8"\300]m\250\325U",              argvalue = 0x7ffe18131bc0,              argnull = 0x55d5a753928f
<MemoryContextAlloc+63>"H\205\300tP[A\\]\303\017\037\200"}, aggref = {             astate = 0x55d5a8766150},
grouping_func= {parent = 0x55d5a8766150, clauses = 0x10}, window_func = {             wfstate = 0x55d5a8766150},
subplan= {sstate = 0x55d5a8766150}, alternative_subplan = {             asstate = 0x55d5a8766150}}}       lc =
0x55d5a86d6f90
#2  0x000055d5a72a27e7 in ExecAssignProjectionInfo (planstate=planstate@entry=0x55d5a8766368,
inputDesc=inputDesc@entry=0x0)at ./build/../src/backend/executor/execUtils.c:496
 
No locals.
#3  0x000055d5a72bd29e in ExecInitResult (node=node@entry=0x55d5a86d6ff0, estate=estate@entry=0x55d5a8766150,
eflags=eflags@entry=16)at ./build/../src/backend/executor/nodeResult.c:234       resstate = 0x55d5a8766368
 
#4  0x000055d5a729e124 in ExecInitNode (node=node@entry=0x55d5a86d6ff0, estate=estate@entry=0x55d5a8766150,
eflags=eflags@entry=16)at ./build/../src/backend/executor/execProcnode.c:164       result = <optimized out>       subps
=<optimized out>       l = <optimized out>       __func__ = "ExecInitNode"
 
#5  0x000055d5a729a0c6 in InitPlan (eflags=16, queryDesc=<optimized out>)   at
./build/../src/backend/executor/execMain.c:1045      operation = CMD_SELECT       estate = 0x55d5a8766150       tupType
=<optimized out>       i = <optimized out>       plannedstmt = <optimized out>       plan = 0x55d5a86d6ff0
rangeTable= <optimized out>       planstate = <optimized out>       l = <optimized out>
 
#6  standard_ExecutorStart (queryDesc=<optimized out>, eflags=16) at ./build/../src/backend/executor/execMain.c:257
 estate = <optimized out>       __func__ = "standard_ExecutorStart"
 
#7  0x000055d5a73eff9f in PortalStart (portal=portal@entry=0x55d5a863c290, params=params@entry=0x0,
eflags=eflags@entry=0,snapshot=snapshot@entry=0x0) at ./build/../src/backend/tcop/pquery.c:520
save_exception_stack= 0x7ffe181320d0       save_context_stack = 0x0       local_sigjmp_buf = {{__jmpbuf = {0,
-7454889355314867966,94376141505168, 94376125009217, 94376142599232,              94376142134776, -7454889355222593278,
-3684621816750812926},__mask_was_saved = 0, __saved_mask = {             __val = {94373316395008, 1, 0,
140731715569261,94376142016544, 94373316395009, 94376125615781,                140729302326784, 94376141505168,
94376125615781,1, 1, 94376142134776, 140729302326848,                94376123674346, 94376142131424}}}}
saveActivePortal= 0x0       saveResourceOwner = 0x55d5a86864e0       savePortalContext = 0x0       oldContext =
0x55d5a861d0a8      queryDesc = 0x55d5a8715580       myeflags = <optimized out>
 
#8  0x000055d5a73ebef8 in exec_simple_query (query_string=0x55d5a86d50e0 "select test_param_where();")   at
./build/../src/backend/tcop/postgres.c:1060      portal = 0x55d5a863c290       snapshot_set = <optimized out>
commandTag= 0x55d5a7680d41 "SELECT"
 
---Type <return> to continue, or q <return> to quit---       completionTag =
"\000\000\000\000\002\000\000\000\340\036\023\030\376\177\000\000Vm\027\030\376\177\000\000\000\000\000\000\000\000\000\000\360\036\023\030\001\000\000\000\340Pm\250\325U\000\000\001\000\000\000\000\000\000\000@\357a\250\325U\000"
     querytree_list = <optimized out>       plantree_list = 0x55d5a8747440       receiver = <optimized out>
format= 0       dest = DestRemote       parsetree_list = 0x55d5a86d5e20       parsetree_item = 0x55d5a86d5df8
save_log_statement_stats= 0 '\000'       was_logged = 0 '\000'       isTopLevel = 1 '\001'       msec_str =
"\000\000\000\000\002\000\000\000\340\036\023\030\376\177\000\000Vm\027\030\376\177\000\000\000\000\000\000\000\000\000"
     __func__ = "exec_simple_query"
 
#9  0x000055d5a73edcdf in PostgresMain (argc=<optimized out>, argv=argv@entry=0x55d5a866b458,    dbname=<optimized
out>,username=<optimized out>) at ./build/../src/backend/tcop/postgres.c:4090       query_string = 0x55d5a86d50e0
"selecttest_param_where();"       input_message = {data = 0x55d5a86d50e0 "select test_param_where();", len = 27, maxlen
=1024, cursor = 27}       local_sigjmp_buf = {{__jmpbuf = {140729302327408, -7454889353561648894, 1, 94376141385536, 1,
            94376128650368, -7454889355283410686, -3684621816926842622}, __mask_was_saved = 1, __saved_mask = {
   __val = {0, 0, 14133314746797201152, 94376141510584, 94376125255358, 140729302327936, 140729302328336,
140729302329376, 0, 0, 140317402085896, 80, 206158430256, 140729302327912, 140729302327696,
94376141697856}}}}      send_ready_for_query = 0 '\000'       disable_idle_in_transaction_timeout = 0 '\000'
__func__= "PostgresMain"
 
#10 0x000055d5a70d8a59 in BackendRun (port=0x55d5a8669030) at ./build/../src/backend/postmaster/postmaster.c:4357
ac= 1       secs = 558433314       usecs = 93052       i = 1       av = 0x55d5a866b458       maxac = <optimized out>
 
#11 BackendStartup (port=0x55d5a8669030) at ./build/../src/backend/postmaster/postmaster.c:4029       bn = <optimized
out>      pid = <optimized out>
 
#12 ServerLoop () at ./build/../src/backend/postmaster/postmaster.c:1753       i = <optimized out>       rmask =
{fds_bits= {8, 0 <repeats 15 times>}}       selres = <optimized out>       now = <optimized out>       readmask =
{fds_bits= {72, 0 <repeats 15 times>}}       last_lockfile_recheck_time = 1505118107       last_touch_time = 1505118107
     __func__ = "ServerLoop"
 
#13 0x000055d5a736eb18 in PostmasterMain (argc=5, argv=0x55d5a861cd80)   at
./build/../src/backend/postmaster/postmaster.c:1361      opt = <optimized out>       status = <optimized out>
userDoption= <optimized out>       listen_addr_saved = <optimized out>       i = <optimized out>
output_config_variable= <optimized out>       __func__ = "PostmasterMain"
 
#14 0x000055d5a70da934 in main (argc=5, argv=0x55d5a861cd80) at ./build/../src/backend/main/main.c:228
No locals.


Christoph


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers