Re: Tom Lane 2017-09-10 <[email protected]>
> Christoph Berg <[email protected]> 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=<optimized out>, 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 address 0x10>},
make_readonly = {value = 0x55d5a8766150,
isnull = 0x10 <error: Cannot access memory at address 0x10>},
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: Cannot access 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 "select test_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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
