BUG #13781: "unrecognized node type" errors
От | zsolt.sandor@gmail.com |
---|---|
Тема | BUG #13781: "unrecognized node type" errors |
Дата | |
Msg-id | 20151123134252.781.61901@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #13781: "unrecognized node type" errors
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 13781 Logged by: Zsolt Sandor Email address: zsolt.sandor@gmail.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@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@entry=20, fmt=fmt@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@entry=0x0, forUpdatePushedDown=forUpdatePushedDown@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@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@entry=0x7f28fa83ece0, query_string=query_string@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@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@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@entry=0x0, src=src@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@entry=0, argtypes=argtypes@entry=0x0, Values=Values@entry=0x0, Nulls=Nulls@entry=0x0, read_only=0 '\000', cursorOptions=cursorOptions@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@entry=0x7fff5f3a02f0, dynquery=<optimized out>, params=0x0, portalname=portalname@entry=0x0, cursorOptions=cursorOptions@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@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@entry=0x7f28f888cea0, fcinfo=fcinfo@entry=0x7f28fa830540, simple_eval_estate=simple_eval_estate@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@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@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@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@entry=0x7f28fa82f8a0, paramLI=paramLI@entry=0x0, snapshot=snapshot@entry=0x0, crosscheck_snapshot=crosscheck_snapshot@entry=0x0, read_only=read_only@entry=0 '\000', fire_triggers=fire_triggers@entry=1 '\001', tcount=tcount@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@entry=0x0, read_only=<optimized out>, tcount=tcount@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@entry=0x7fff5f3a0b40, expr=0x7f28f897a470, maxtuples=maxtuples@entry=0, portalP=portalP@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@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@entry=0x7f28f8840b90, fcinfo=fcinfo@entry=0x7f28f8953120, simple_eval_estate=simple_eval_estate@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@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@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@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@entry=0x7f28f87be020, forward=forward@entry=1 '\001', count=0, count@entry=9223372036854775807, dest=dest@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@entry=0x7f28f87be020, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=1 '\001', dest=dest@entry=0x7f28f89ec980, altdest=altdest@entry=0x7f28f89ec980, completionTag=completionTag@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@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
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Caleb MeredithДата:
Сообщение: Re: BUG #13780: Multiple commands not allowed for creating a policy.
Следующее
От: Caleb MeredithДата:
Сообщение: Re: BUG #13780: Multiple commands not allowed for creating a policy.