Hi, > This is a normal interbackend communication signal. You need to > configure gdb to ignore SIGUSR2 (ie, pass it on and not stop execution). > Probably SIGUSR1 too.
Done. Here's the result: Breakpoint 1, 0x000000000054aec0 in SPI_connect () (gdb) bt #0 0x000000000054aec0 in SPI_connect () #1 0x00002afdffd243c2 in plpgsql_call_handler () from /usr/local/pgsql/lib/plpgsql.so #2 0x00000000005331f7 in ExecMakeFunctionResult () #3 0x0000000000534f1a in ExecEvalExprSwitchContext () #4 0x00000000005919e4 in evaluate_expr () #5 0x0000000000592e69 in simplify_function () #6 0x000000000059354e in eval_const_expressions_mutator () #7 0x0000000000556d70 in expression_tree_mutator () #8 0x0000000000593414 in eval_const_expressions_mutator () #9 0x00000000005934e2 in eval_const_expressions_mutator () #10 0x00000000005566bd in expression_tree_mutator () #11 0x000000000059332d in eval_const_expressions_mutator () #12 0x0000000000556d70 in expression_tree_mutator () #13 0x000000000059332d in eval_const_expressions_mutator () #14 0x000000000059436f in eval_const_expressions () #15 0x00000000005862a1 in preprocess_expression () #16 0x00000000005889cf in subquery_planner () #17 0x0000000000588f63 in standard_planner () #18 0x00000000005cc6b1 in pg_plan_query () #19 0x00000000005cc76e in pg_plan_queries () #20 0x000000000066a522 in RevalidateCachedPlan () #21 0x00002afdffd27e12 in exec_eval_expr () from /usr/local/pgsql/lib/plpgsql.so #22 0x00002afdffd28122 in exec_eval_boolean () from /usr/local/pgsql/lib/plpgsql.so #23 0x00002afdffd2d927 in exec_stmt_if () from /usr/local/pgsql/lib/plpgsql.so #24 0x00002afdffd2c3b8 in exec_stmts () from /usr/local/pgsql/lib/plpgsql.so #25 0x00002afdffd2bb70 in exec_stmt_block () from /usr/local/pgsql/lib/plpgsql.so #26 0x00002afdffd2e26f in plpgsql_exec_function () from /usr/local/pgsql/lib/plpgsql.so #27 0x00002afdffd2447e in plpgsql_call_handler () from /usr/local/pgsql/lib/plpgsql.so #28 0x00000000005331f7 in ExecMakeFunctionResult () #29 0x0000000000530157 in ExecProject () #30 0x0000000000541dd3 in ExecResult () #31 0x000000000052fb86 in ExecProcNode () #32 0x000000000052d99f in standard_ExecutorRun () #33 0x00000000005cfff4 in PortalRunSelect () #34 0x00000000005d11e0 in PortalRun () #35 0x00000000005ccfcb in exec_simple_query () #36 0x00000000005cdce4 in PostgresMain () #37 0x00000000005a50fb in ServerLoop () #38 0x00000000005a5c2a in PostmasterMain () #39 0x000000000055498e in main () Looking forward to your reply ! -- Best, Frank. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
