BUG #13781: "unrecognized node type" errors

The following bug has been logged on the website:

Bug reference: 13781
Logged by: Zsolt Sandor
Email address: zsolt(dot)sandor(at)gmail(dot)com
PostgreSQL version: 9.4.5
Operating system: Linux x86_64
Description:

(I'm reporting this bug on behalf of Zsolt Sandor. He has kindly provided
us a backtrace of the problem, but narrowing it down to a small,
reproducible test case would have been really difficult in this case.)

The problem didn't occur in 9.4.4, but does consistently on 9.4.5. The "bt
full" output is as follows:

#0 errfinish (dummy=dummy(at)entry=0) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/utils/error/elog.c:471
edata = 0x7f28f79ac4e0 <errordata>
elevel = 20
save_ImmediateInterruptOK = 0 '\000'
oldcontext = 0x7f28fa1a95b0
econtext = 0x0
__func__ = "errfinish"
#1 0x00007f28f755f0a7 in elog_finish (elevel=elevel(at)entry=20,
fmt=fmt(at)entry=0x7f28f765032a "unrecognized node type: %d")
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/utils/error/elog.c:1376
edata = 0x7f28f79ac4e0 <errordata>
oldcontext = 0x7f28fa1a95b0
__func__ = "elog_finish"
#2 0x00007f28f73c145c in copyObject (from=0x7f28fa836ac8) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:4637
retval = <optimized out>
__func__ = "copyObject"
#3 0x00007f28f73c50a9 in _copyRangeTblEntry (from=0x7f28f9420c30) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:1981
newnode = 0x7f28fa877f68
#4 0x00007f28f73bf262 in copyObject (from=<optimized out>) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:4600
retval = <optimized out>
__func__ = "copyObject"
#5 0x00007f28f73c03ea in _copyList (from=<optimized out>, from=<optimized
out>)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:3855
new = 0x7f28fa877700
curr_old = 0x7f28f9421678
prev_new = 0x7f28fa877c38
#6 copyObject (from=<optimized out>) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:4217
retval = <optimized out>
__func__ = "copyObject"
#7 0x00007f28f73c2cd5 in _copyQuery (from=0x7f28f941d510) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:2479
newnode = 0x7f28fa8775f0
#8 0x00007f28f73c0362 in copyObject (from=<optimized out>) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:4233
retval = <optimized out>
__func__ = "copyObject"
#9 0x00007f28f73c1fc5 in _copySubLink (from=0x7f28f941d4c0) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:1332
newnode = 0x7f28fa8775a0
#10 0x00007f28f73c0789 in copyObject (from=<optimized out>) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:4090
retval = <optimized out>
__func__ = "copyObject"
#11 0x00007f28f73c03ea in _copyList (from=<optimized out>, from=<optimized
out>)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:3855
new = 0x7f28fa8774e0
curr_old = 0x7f28f9421ca8
prev_new = 0x7f28fa877510
#12 copyObject (from=<optimized out>) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:4217
retval = <optimized out>
__func__ = "copyObject"
#13 0x00007f28f73c1f59 in _copyBoolExpr (from=0x7f28f941d3f0) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:1315
newnode = 0x7f28fa8774b0
#14 0x00007f28f73c0799 in copyObject (from=<optimized out>) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:4087
retval = <optimized out>
__func__ = "copyObject"
#15 0x00007f28f73bf1a3 in _copyAccessPriv (from=<optimized out>,
from=<optimized out>)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:2671
newnode = <optimized out>
#16 copyObject (from=0x7f28f941d358) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:4630
retval = <optimized out>
__func__ = "copyObject"
#17 0x00007f28f73c2ce3 in _copyQuery (from=0x7f28f8d211f0) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:2480
newnode = 0x7f28fa876138
#18 0x00007f28f73c0362 in copyObject (from=<optimized out>) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/nodes/copyfuncs.c:4233
retval = <optimized out>
__func__ = "copyObject"
#19 0x00007f28f744a0d5 in ApplyRetrieveRule (rule=0x7f28f8d211c0,
rule=0x7f28f8d211c0, relation=0x7f28f8f8df78, forUpdatePushedDown=0 '\000',
activeRIRs=0x7f28fa876108,
rt_index=6, parsetree=0x7f28fa83ef50) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/rewrite/rewriteHandler.c:1437
rule_action = <optimized out>
rte = <optimized out>
subrte = <optimized out>
rc = 0x0
#20 fireRIRrules (parsetree=0x7f28fa83ef50, activeRIRs=0x7f28fa876108,
activeRIRs(at)entry=0x0, forUpdatePushedDown=forUpdatePushedDown(at)entry=0
'\000')
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/rewrite/rewriteHandler.c:1706
l = 0x7f28fa875168
rte = <optimized out>
rel = 0x7f28f8f8df78
rules = <optimized out>
rule = 0x7f28f8d211c0
i = <optimized out>
locks = <optimized out>
origResultRelation = 0
rt_index = 6
lc = <optimized out>
__func__ = "fireRIRrules"
#21 0x00007f28f744c874 in QueryRewrite
(parsetree=parsetree(at)entry=0x7f28fa83ef50)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/rewrite/rewriteHandler.c:3313
query = <optimized out>
input_query_id = 0
querylist = <optimized out>
results = 0x0
l = 0x7f28fa8750c8
origCmdType = <optimized out>
foundOriginalQuery = <optimized out>
lastInstead = <optimized out>
#22 0x00007f28f747736a in pg_rewrite_query (query=0x7f28fa83ef50) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/tcop/postgres.c:727
querytree_list = <optimized out>
#23 0x00007f28f7477460 in pg_analyze_and_rewrite
(parsetree=parsetree(at)entry=0x7f28fa83ece0,
query_string=query_string(at)entry=0x7f28fa8365f0 " SELECT cs.tid AS
subject, w.tid As windfarm, ct.tid AS certtype, ct.displayname AS ctDispName
\n", ' ' <repeats 23 times>, "FROM certsubjects AS cs\n", ' ' <repeats 23
times>, "JOIN certtypes as ct ON ct.certsub"..., paramTypes=<optimized out>,
numParams=<optimized out>)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/tcop/postgres.c:645
query = <optimized out>
#24 0x00007f28f73a56aa in _SPI_prepare_plan (
src=src(at)entry=0x7f28fa8365f0 " SELECT cs.tid AS subject, w.tid As
windfarm, ct.tid AS certtype, ct.displayname AS ctDispName \n", ' ' <repeats
23 times>, "FROM certsubjects AS cs\n", ' ' <repeats 23 times>, "JOIN
certtypes as ct ON ct.certsub"..., plan=plan(at)entry=0x7fff5f39ff60)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/spi.c:1857
parsetree = 0x7f28fa83ece0
stmt_list = <optimized out>
plansource = 0x7f28fa840130
raw_parsetree_list = <optimized out>
plancache_list = 0x0
list_item = 0x7f28fa83edf0
spierrcontext = {previous = 0x7fff5f3a02d0, callback =
0x7f28f73a5b00 <_SPI_error_callback>, arg = 0x7f28fa8365f0}
#25 0x00007f28f73a8635 in SPI_cursor_open_with_args (name=name(at)entry=0x0,
src=src(at)entry=0x7f28fa8365f0 " SELECT cs.tid AS subject, w.tid As
windfarm, ct.tid AS certtype, ct.displayname AS ctDispName \n", ' ' <repeats
23 times>, "FROM certsubjects AS cs\n", ' ' <repeats 23 times>, "JOIN
certtypes as ct ON ct.certsub"..., nargs=nargs(at)entry=0,
argtypes=argtypes(at)entry=0x0, Values=Values(at)entry=0x0,
Nulls=Nulls(at)entry=0x0, read_only=0 '\000',
cursorOptions=cursorOptions(at)entry=0)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/spi.c:1148
result = <optimized out>
plan = {magic = 569278163, saved = 0 '\000', oneshot = 0 '\000',
plancache_list = 0x0, plancxt = 0x0, cursor_options = 0, nargs = 0, argtypes
= 0x0,
parserSetup = 0x0, parserSetupArg = 0x0}
paramLI = 0x0
__func__ = "SPI_cursor_open_with_args"
#26 0x00007f28e8245c89 in exec_dynquery_with_params
(estate=estate(at)entry=0x7fff5f3a02f0, dynquery=<optimized out>, params=0x0,
portalname=portalname(at)entry=0x0,
cursorOptions=cursorOptions(at)entry=0) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/pl/plpgsql/src/pl_exec.c:6504
portal = <optimized out>
query = <optimized out>
isnull = 0 '\000'
restype = 705
querystr = 0x7f28fa8365f0 " SELECT cs.tid AS subject, w.tid As
windfarm, ct.tid AS certtype, ct.displayname AS ctDispName \n", ' ' <repeats
23 times>, "FROM certs
ubjects AS cs\n", ' ' <repeats 23 times>, "JOIN certtypes as ct ON
ct.certsub"...
__func__ = "exec_dynquery_with_params"
#27 0x00007f28e8247fe4 in exec_stmt_dynfors (stmt=0x7f28f9701840,
estate=0x7fff5f3a02f0)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/pl/plpgsql/src/pl_exec.c:3682
portal = <optimized out>
rc = <optimized out>
#28 exec_stmt (stmt=0x7f28f9701840, estate=0x7fff5f3a02f0) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/pl/plpgsql/src/pl_exec.c:1471
save_estmt = 0x7f28f97049e0
rc = -1
#29 exec_stmts (estate=0x7fff5f3a02f0, stmts=<optimized out>) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/pl/plpgsql/src/pl_exec.c:1362
stmt = 0x7f28f9701840
rc = 1597637008
s = 0x7f28f9704990
#30 0x00007f28e8249dcd in exec_stmt_block
(estate=estate(at)entry=0x7fff5f3a02f0, block=0x7f28f97049e0)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/pl/plpgsql/src/pl_exec.c:1300
rc = -1
i = <optimized out>
n = <optimized out>
__func__ = "exec_stmt_block"
#31 0x00007f28e824a003 in plpgsql_exec_function
(func=func(at)entry=0x7f28f888cea0, fcinfo=fcinfo(at)entry=0x7f28fa830540,
simple_eval_estate=simple_eval_estate(at)entry=0x0)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/pl/plpgsql/src/pl_exec.c:344
estate = {func = 0x7f28f888cea0, retval = 0, retisnull = 1 '\001',
rettype = 0, fn_rettype = 2278, retistuple = 0 '\000', retisset = 0 '\000',
readonly_func = 0 '\000', rettupdesc = 0x0, exitlabel = 0x0,
cur_error = 0x0, tuple_store = 0x0, tuple_store_cxt = 0x0, tuple_store_owner
= 0x0, rsi = 0x0,
found_varno = 0, ndatums = 19, datums = 0x7f28fa8360f0,
simple_eval_estate = 0x7f28f8813660, eval_tuptable = 0x0, eval_processed =
0, eval_lastoid = 0,
eval_econtext = 0x7f28f8813850, cur_expr = 0x0, err_stmt =
0x7f28f9701840, err_text = 0x0, plugin_info = 0x0}
plerrcontext = {previous = 0x7fff5f3a0760, callback = 0x7f28e82433e0
<plpgsql_exec_error_callback>, arg = 0x7fff5f3a02f0}
i = <optimized out>
rc = <optimized out>
__func__ = "plpgsql_exec_function"
#32 0x00007f28e823f443 in plpgsql_call_handler (fcinfo=0x7f28fa830540) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/pl/plpgsql/src/pl_handler.c:243
save_exception_stack = 0x7fff5f3a0c60
save_context_stack = 0x7fff5f3a0760
local_sigjmp_buf = {{__jmpbuf = {140734791025936,
-2882117546266818963, 139813978309952, 139813978309344, 139813978309840,
139813978312256,
-2882117546432493971, -2760768765055302035}, __mask_was_saved
= 0, __saved_mask = {__val = {0, 139813971472720, 0, 140734791025872,
139813922355675,
139813952535212, 139813978325216, 0, 0, 0, 139813978309840,
72897, 139813978309840, 72897, 139813971469728, 140734791025904}}}}
func = 0x7f28f888cea0
save_cur_estate = 0x0
retval = <optimized out>
rc = <optimized out>
__func__ = "plpgsql_call_handler"
#33 0x00007f28f7385c43 in ExecMakeFunctionResultNoSets
(fcache=0x7f28fa8304d0, econtext=0x7f28fa8302e0, isNull=0x7f28fa830e58
"t1\037vesse\240\245\032\372(\177",
isDone=<optimized out>) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/execQual.c:2026
arg = <optimized out>
result = <optimized out>
fcinfo = 0x7f28fa830540
fcusage = {fs = 0x0, save_f_total_time = {tv_sec = 139813978309840,
tv_usec = 139813978308288}, save_total = {tv_sec = 139813978309344,
tv_usec = 139813978312280}, f_start = {tv_sec = 139813978312560,
tv_usec = 140734791026048}}
i = <optimized out>
#34 0x00007f28f738b85c in ExecTargetList (isDone=0x7fff5f3a061c,
itemIsDone=0x7f28fa830f70, isnull=<optimized out>, values=0x7f28fa830e40,
econtext=0x7f28fa8302e0,
targetlist=0x7f28fa830f40) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/execQual.c:5307
gstate = <optimized out>
tle = <optimized out>
resind = <optimized out>
tl = 0x7f28fa830f20
haveDoneSets = 0 '\000'
#35 ExecProject (projInfo=<optimized out>,
isDone=isDone(at)entry=0x7fff5f3a061c)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/execQual.c:5522
slot = 0x7f28fa8303c0
econtext = 0x7f28fa8302e0
numSimpleVars = <optimized out>
#36 0x00007f28f739d9e0 in ExecResult (node=node(at)entry=0x7f28fa8301d0) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/nodeResult.c:155
outerTupleSlot = <optimized out>
resultSlot = <optimized out>
outerPlan = <optimized out>
econtext = 0x7f28fa8302e0
isDone = ExprSingleResult
#37 0x00007f28f7384b18 in ExecProcNode (node=node(at)entry=0x7f28fa8301d0)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/execProcnode.c:373
result = <optimized out>
__func__ = "ExecProcNode"
#38 0x00007f28f7381d12 in ExecutePlan (dest=0x7f28f795bf80 <spi_printtupDR>,
direction=<optimized out>, numberTuples=0, sendTuples=1 '\001',
operation=CMD_SELECT,
planstate=0x7f28fa8301d0, estate=0x7f28fa8300c0) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/execMain.c:1490
slot = <optimized out>
current_tuple_count = 0
#39 standard_ExecutorRun (queryDesc=0x7f28f88277a0, direction=<optimized
out>, count=0)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/execMain.c:319
estate = 0x7f28fa8300c0
operation = CMD_SELECT
dest = 0x7f28f795bf80 <spi_printtupDR>
sendTuples = <optimized out>
#40 0x00007f28f73a7966 in _SPI_pquery (tcount=0, fire_triggers=1 '\001',
queryDesc=<optimized out>)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/spi.c:2373
eflags = 0
res = 5
#41 _SPI_execute_plan (plan=plan(at)entry=0x7f28fa82f8a0,
paramLI=paramLI(at)entry=0x0, snapshot=snapshot(at)entry=0x0,
crosscheck_snapshot=crosscheck_snapshot(at)entry=0x0,
read_only=read_only(at)entry=0 '\000', fire_triggers=fire_triggers(at)entry=1
'\001', tcount=tcount(at)entry=0)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/spi.c:2161
qdesc = 0x7f28f88277a0
snap = <optimized out>
stmt = <optimized out>
canSetTag = 1 '\001'
dest = <optimized out>
plansource = 0x7f28fa8c1200
stmt_list = 0x7f28fa82fcb0
lc2 = 0x7f28fa82fce0
my_res = 0
my_processed = 0
my_lastoid = 0
my_tuptable = 0x0
res = <optimized out>
pushed_active_snap = 1 '\001'
spierrcontext = {previous = 0x7fff5f3a0b20, callback =
0x7f28f73a5b00 <_SPI_error_callback>, arg = 0x7f28fa8c1640}
cplan = 0x7f28fa82ffb0
lc1 = 0x7f28fa82f8f0
__func__ = "_SPI_execute_plan"
#42 0x00007f28f73a7c7d in SPI_execute_plan_with_paramlist
(plan=0x7f28fa82f8a0, params=params(at)entry=0x0, read_only=<optimized out>,
tcount=tcount(at)entry=0)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/spi.c:449
res = <optimized out>
#43 0x00007f28e8243c64 in exec_run_select
(estate=estate(at)entry=0x7fff5f3a0b40, expr=0x7f28f897a470,
maxtuples=maxtuples(at)entry=0, portalP=portalP(at)entry=0x0)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/pl/plpgsql/src/pl_exec.c:4886
paramLI = 0x0
rc = <optimized out>
__func__ = "exec_run_select"
#44 0x00007f28e8247bb3 in exec_stmt_perform (stmt=<optimized out>,
estate=0x7fff5f3a0b40)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/pl/plpgsql/src/pl_exec.c:1527
expr = <optimized out>
#45 exec_stmt (stmt=0x7f28f897a550, estate=0x7fff5f3a0b40) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/pl/plpgsql/src/pl_exec.c:1403
save_estmt = 0x7f28f8a14b40
rc = -1
#46 exec_stmts (estate=0x7fff5f3a0b40, stmts=<optimized out>) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/pl/plpgsql/src/pl_exec.c:1362
stmt = 0x7f28f897a550
rc = 0
s = 0x7f28f897a570
#47 0x00007f28e8249dcd in exec_stmt_block
(estate=estate(at)entry=0x7fff5f3a0b40, block=0x7f28f8a14b40)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/pl/plpgsql/src/pl_exec.c:1300
rc = -1
i = <optimized out>
n = <optimized out>
__func__ = "exec_stmt_block"
#48 0x00007f28e824a003 in plpgsql_exec_function
(func=func(at)entry=0x7f28f8840b90, fcinfo=fcinfo(at)entry=0x7f28f8953120,
simple_eval_estate=simple_eval_estate(at)entry=0x0)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/pl/plpgsql/src/pl_exec.c:344
estate = {func = 0x7f28f8840b90, retval = 0, retisnull = 1 '\001',
rettype = 0, fn_rettype = 2278, retistuple = 0 '\000', retisset = 0 '\000',
readonly_func = 0 '\000', rettupdesc = 0x0, exitlabel = 0x0,
cur_error = 0x0, tuple_store = 0x0, tuple_store_cxt = 0x0, tuple_store_owner
= 0x0, rsi = 0x0,
found_varno = 0, ndatums = 1, datums = 0x7f28f8888a50,
simple_eval_estate = 0x7f28f8813660, eval_tuptable = 0x0, eval_processed =
1, eval_lastoid = 0,
eval_econtext = 0x7f28f8813770, cur_expr = 0x0, err_stmt =
0x7f28f897a550, err_text = 0x0, plugin_info = 0x0}
plerrcontext = {previous = 0x0, callback = 0x7f28e82433e0
<plpgsql_exec_error_callback>, arg = 0x7fff5f3a0b40}
i = <optimized out>
rc = <optimized out>
__func__ = "plpgsql_exec_function"
#49 0x00007f28e823f443 in plpgsql_call_handler (fcinfo=0x7f28f8953120) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/pl/plpgsql/src/pl_handler.c:243
save_exception_stack = 0x7fff5f3a0fd0
save_context_stack = 0x0
local_sigjmp_buf = {{__jmpbuf = {140734791028064,
-2882117546520574355, 139813945946400, 139813945945792, 139813945946288,
139813945948704,
-2882117546560420243, -2760768765055302035}, __mask_was_saved
= 0, __saved_mask = {__val = {0, 139813957028352, 0, 140734791028000,
139813922355675, 0,
139813945006032, 139813943435920, 72057594037927936, 2278,
139813945946288, 75255, 139813945946288, 75255, 139813951549168,
140734791028032}}}}
func = 0x7f28f8840b90
save_cur_estate = 0x0
retval = <optimized out>
rc = <optimized out>
__func__ = "plpgsql_call_handler"
#50 0x00007f28f7385c43 in ExecMakeFunctionResultNoSets
(fcache=0x7f28f89530b0, econtext=0x7f28f8952ec0, isNull=0x7f28f8953a38
<incomplete sequence \302>,
isDone=<optimized out>) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/execQual.c:2026
arg = <optimized out>
result = <optimized out>
fcinfo = 0x7f28f8953120
fcusage = {fs = 0x0, save_f_total_time = {tv_sec = 139813945946288,
tv_usec = 139813956951392}, save_total = {tv_sec = 139813945945792,
tv_usec = 139813945948728}, f_start = {tv_sec = 139813945949008,
tv_usec = 140734791028176}}
i = <optimized out>
#51 0x00007f28f738b85c in ExecTargetList (isDone=0x7fff5f3a0e6c,
itemIsDone=0x7f28f8953b50, isnull=<optimized out>, values=0x7f28f8953a20,
econtext=0x7f28f8952ec0,
targetlist=0x7f28f8953b20) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/execQual.c:5307
gstate = <optimized out>
tle = <optimized out>
resind = <optimized out>
tl = 0x7f28f8953b00
haveDoneSets = 0 '\000'
#52 ExecProject (projInfo=<optimized out>,
isDone=isDone(at)entry=0x7fff5f3a0e6c)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/execQual.c:5522
slot = 0x7f28f8952fa0
econtext = 0x7f28f8952ec0
numSimpleVars = <optimized out>
#53 0x00007f28f739d9e0 in ExecResult (node=node(at)entry=0x7f28f8952db0) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/nodeResult.c:155
outerTupleSlot = <optimized out>
resultSlot = <optimized out>
outerPlan = <optimized out>
econtext = 0x7f28f8952ec0
isDone = ExprSingleResult
#54 0x00007f28f7384b18 in ExecProcNode (node=node(at)entry=0x7f28f8952db0)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/execProcnode.c:373
result = <optimized out>
__func__ = "ExecProcNode"
#55 0x00007f28f7381d12 in ExecutePlan (dest=0x7f28f89ec980,
direction=<optimized out>, numberTuples=0, sendTuples=1 '\001',
operation=CMD_SELECT,
planstate=0x7f28f8952db0, estate=0x7f28f8952ca0) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/execMain.c:1490
slot = <optimized out>
current_tuple_count = 0
#56 standard_ExecutorRun (queryDesc=0x7f28f872ef10, direction=<optimized
out>, count=0)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/executor/execMain.c:319
estate = 0x7f28f8952ca0
operation = CMD_SELECT
dest = 0x7f28f89ec980
sendTuples = <optimized out>
#57 0x00007f28f747a7ff in PortalRunSelect
(portal=portal(at)entry=0x7f28f87be020, forward=forward(at)entry=1 '\001',
count=0, count(at)entry=9223372036854775807,
dest=dest(at)entry=0x7f28f89ec980) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/tcop/pquery.c:942
queryDesc = 0x7f28f872ef10
direction = <optimized out>
nprocessed = <optimized out>
__func__ = "PortalRunSelect"
#58 0x00007f28f747bdca in PortalRun (portal=portal(at)entry=0x7f28f87be020,
count=count(at)entry=9223372036854775807, isTopLevel=isTopLevel(at)entry=1
'\001',
dest=dest(at)entry=0x7f28f89ec980, altdest=altdest(at)entry=0x7f28f89ec980,
completionTag=completionTag(at)entry=0x7fff5f3a1360 "")
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/tcop/pquery.c:786
save_exception_stack = 0x7fff5f3a1270
save_context_stack = 0x0
local_sigjmp_buf = {{__jmpbuf = {139813943537816,
-2882117545872554387, 139813944287264, 139813946575232, 139813943538088, 2,
-2882117546583488915,
-2760713547078269331}, __mask_was_saved = 0, __saved_mask =
{__val = {140734791028879, 5892608064, 139813925052048, 139813926434718, 64,
140734791028848,
88, 139813944287264, 139813926164044, 139813943538088, 2,
140734791028880, 139813925143050, 2, 139813944287264, 140734791028912}}}}
result = <optimized out>
nprocessed = <optimized out>
saveTopTransactionResourceOwner = 0x7f28f87abe28
saveTopTransactionContext = 0x7f28f86ec4d0
saveActivePortal = 0x0
saveResourceOwner = 0x7f28f87abe28
savePortalContext = 0x0
saveMemoryContext = 0x7f28f86ec4d0
__func__ = "PortalRun"
#59 0x00007f28f7479785 in exec_simple_query (query_string=0x7f28f8706500
"SELECT testVesselCertificateNotifGeneration();")
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/tcop/postgres.c:1072
parsetree = 0x7f28f8707098
portal = 0x7f28f87be020
snapshot_set = <optimized out>
commandTag = <optimized out>
completionTag = "\000ELECT
1\000NCTION\000\340\023:_\377\177\000\000$\022B\367(\177\000\000\000\000\000\000\000\000\000\000\340\016s\370(\177\000\000\340\023:_\377\177\000\000&\240W\367(\177\000"
querytree_list = <optimized out>
plantree_list = 0x7f28f93d1fd0
receiver = 0x7f28f89ec980
format = 0
dest = DestRemote
parsetree_list = 0x7f28f87071c8
save_log_statement_stats = 0 '\000'
was_logged = 0 '\000'
msec_str = "\000ELECT
1\000NCTION\000\340\023:_\377\177\000\000$\022B\367(\177\000"
parsetree_item = 0x7f28f87071a8
isTopLevel = 1 '\001'
#60 PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x7f28f86ee060,
dbname=0x7f28f86edf90 "pvts", username=<optimized out>)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/tcop/postgres.c:4079
query_string = 0x7f28f8706500 "SELECT
testVesselCertificateNotifGeneration();"
firstchar = -126099424
input_message = {data = 0x7f28f8706500 "SELECT
testVesselCertificateNotifGeneration();", len = 47, maxlen = 1024, cursor =
47}
local_sigjmp_buf = {{__jmpbuf = {140734791029360,
-2882117545895623059, 139813943435120, 1, 0, 139813943709408,
-2882117545866262931, -2760713553476811155},
__mask_was_saved = 1, __saved_mask = {__val = {0,
140734791030112, 0, 139813943709408, 139813891592600, 140734791029504,
206158430256, 140734791029712,
140734791029504, 140734791029616, 139813923722336, 0,
139813929538976, 139813943428304, 139813943435120, 139813926125856}}}}
send_ready_for_query = 0 '\000'
__func__ = "PostgresMain"
#61 0x00007f28f724a133 in BackendRun (port=0x7f28f8730ee0) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/postmaster/postmaster.c:4252
ac = 1
secs = 501599535
usecs = 812905
i = 1
av = 0x7f28f86ee060
maxac = <optimized out>
#62 BackendStartup (port=0x7f28f8730ee0) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/postmaster/postmaster.c:3917
bn = <optimized out>
pid = <optimized out>
#63 ServerLoop () at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/postmaster/postmaster.c:1678
rmask = {fds_bits = {8, 0 <repeats 15 times>}}
selres = <optimized out>
readmask = {fds_bits = {72, 0 <repeats 15 times>}}
now = <optimized out>
last_touch_time = 1448281724
__func__ = "ServerLoop"
#64 0x00007f28f742475b in PostmasterMain (argc=5, argv=<optimized out>)
at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/postmaster/postmaster.c:1287
opt = <optimized out>
status = <optimized out>
userDoption = <optimized out>
listen_addr_saved = 1 '\001'
i = <optimized out>
output_config_variable = <optimized out>
__func__ = "PostmasterMain"
#65 0x00007f28f724ae5d in main (argc=5, argv=0x7f28f86ec190) at
/build/postgresql-9.4-cOfbf1/postgresql-9.4-9.4.5/build/../src/backend/main/main.c:228