[01:35:04.267] src/tools/ci/cores_backtrace.sh linux /tmp/cores [01:35:04.458] dumping /tmp/cores/sh-3-37159.core for /bin/sh [01:35:04.505] [01:35:04.505] This GDB supports auto-downloading debuginfo from the following URLs: [01:35:04.505] [01:35:04.505] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:35:04.505] Debuginfod has been disabled. [01:35:04.505] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:35:04.509] [New LWP 37159] [01:35:04.511] [New LWP 37158] [01:35:04.511] [Thread debugging using libthread_db enabled] [01:35:04.511] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:35:04.511] Core was generated by `sh -c cp "/tmp/cirrus-ci-build/build/testrun/recovery/042_low_level_backup/data'. [01:35:04.511] Program terminated with signal SIGQUIT, Quit. [01:35:04.511] #0 0x00007f766c5b6dd4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:04.518] [Current thread is 1 (LWP 37159)] [01:35:04.518] [01:35:04.518] Thread 2 (Thread 0x7f766c524740 (LWP 37158)): [01:35:04.518] warning: Couldn't find general-purpose registers in core file. [01:35:04.518] #0 in ?? () [01:35:04.518] PC unavailable, cannot determine locals. [01:35:04.518] Backtrace stopped: not enough registers or memory available to unwind further [01:35:04.518] [01:35:04.518] Thread 1 (LWP 37159): [01:35:04.518] #0 0x00007f766c5b6dd4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:04.518] No symbol table info available. [01:35:04.518] #1 0x00007f766c563239 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:04.518] No symbol table info available. [01:35:04.518] #2 0x00007f766c563497 in sigsetmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:04.518] No symbol table info available. [01:35:04.518] #3 0x000055b1ce2605f3 in ?? () [01:35:04.518] No symbol table info available. [01:35:04.518] #4 0x000055b1ce25a369 in ?? () [01:35:04.518] No symbol table info available. [01:35:04.518] #5 0x000055b1ce25920f in ?? () [01:35:04.518] No symbol table info available. [01:35:04.518] #6 0x000055b1ce259c3b in ?? () [01:35:04.518] No symbol table info available. [01:35:04.518] #7 0x000055b1ce25766f in ?? () [01:35:04.518] No symbol table info available. [01:35:04.518] #8 0x00007f766c54e24a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:04.518] No symbol table info available. [01:35:04.518] #9 0x00007f766c54e305 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:04.518] No symbol table info available. [01:35:04.518] #10 0x000055b1ce257781 in ?? () [01:35:04.518] No symbol table info available. [01:35:04.524] -e [01:35:04.524] [01:35:04.524] [01:35:04.584] dumping /tmp/cores/sh-3-49697.core for /bin/sh [01:35:04.629] [01:35:04.629] This GDB supports auto-downloading debuginfo from the following URLs: [01:35:04.629] [01:35:04.629] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:35:04.629] Debuginfod has been disabled. [01:35:04.629] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:35:04.634] [New LWP 49697] [01:35:04.635] [Thread debugging using libthread_db enabled] [01:35:04.635] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:35:04.635] Core was generated by `sh -c cp "pg_wal/000000010000000000000003.00000028.backup" "/tmp/cirrus-ci-buil'. [01:35:04.635] Program terminated with signal SIGQUIT, Quit. [01:35:04.635] #0 0x00007f32b333add4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:04.636] [01:35:04.636] Thread 1 (Thread 0x7f32b32a8740 (LWP 49697)): [01:35:04.636] #0 0x00007f32b333add4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:04.636] No symbol table info available. [01:35:04.636] #1 0x00007f32b32e7239 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:04.636] No symbol table info available. [01:35:04.636] #2 0x00007f32b32e7497 in sigsetmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:04.636] No symbol table info available. [01:35:04.636] #3 0x0000560339dbc5c1 in ?? () [01:35:04.636] No symbol table info available. [01:35:04.636] #4 0x0000560339db6369 in ?? () [01:35:04.636] No symbol table info available. [01:35:04.636] #5 0x0000560339db520f in ?? () [01:35:04.636] No symbol table info available. [01:35:04.636] #6 0x0000560339db5c3b in ?? () [01:35:04.636] No symbol table info available. [01:35:04.636] #7 0x0000560339db366f in ?? () [01:35:04.636] No symbol table info available. [01:35:04.636] #8 0x00007f32b32d224a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:04.636] No symbol table info available. [01:35:04.636] #9 0x00007f32b32d2305 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:04.636] No symbol table info available. [01:35:04.636] #10 0x0000560339db3781 in ?? () [01:35:04.636] No symbol table info available. [01:35:04.642] -e [01:35:04.642] [01:35:04.642] [01:35:04.735] dumping /tmp/cores/postgres-6-43238.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:35:05.001] [New LWP 43238] [01:35:05.001] [01:35:05.001] This GDB supports auto-downloading debuginfo from the following URLs: [01:35:05.001] [01:35:05.001] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:35:05.001] Debuginfod has been disabled. [01:35:05.001] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:35:05.260] [Thread debugging using libthread_db enabled] [01:35:05.260] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:35:05.260] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN '. [01:35:05.260] Program terminated with signal SIGABRT, Aborted. [01:35:05.260] #0 0x00007f30a40a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:06.307] [01:35:06.307] Thread 1 (Thread 0x7f30a3fd3a80 (LWP 43238)): [01:35:06.307] #0 0x00007f30a40a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:06.307] No symbol table info available. [01:35:06.307] #1 0x00007f30a405afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:06.307] No symbol table info available. [01:35:06.307] #2 0x00007f30a4045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:06.307] No symbol table info available. [01:35:06.307] #3 0x00005624890bee36 in ExceptionalCondition (conditionName=conditionName@entry=0x5624892f2e49 "n >= 0 && n < list->length", fileName=fileName@entry=0x5624892edd60 "../src/include/nodes/pg_list.h", lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [01:35:06.307] No locals. [01:35:06.307] #4 0x0000562488bd08ca in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [01:35:06.307] No locals. [01:35:06.307] #5 0x0000562488bd08ff in list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [01:35:06.307] No locals. [01:35:06.307] #6 0x0000562488bd6031 in var_is_nonnullable (root=0x56249ce42a48, var=var@entry=0x56249cf04db8, use_rel_info=use_rel_info@entry=false) at ../src/backend/optimizer/util/clauses.c:4235 [01:35:06.307] rte = [01:35:06.307] notnullattnums = 0x0 [01:35:06.307] #7 0x0000562488bd9efe in eval_const_expressions_mutator (node=node@entry=0x56249cf04d38, context=context@entry=0x7fff3ba8bd90) at ../src/backend/optimizer/util/clauses.c:3556 [01:35:06.307] varg = 0x56249cf04db8 [01:35:06.307] result = [01:35:06.307] ntest = 0x56249cf04d38 [01:35:06.307] newntest = [01:35:06.307] arg = 0x56249cf04db8 [01:35:06.307] __func__ = "eval_const_expressions_mutator" [01:35:06.307] #8 0x0000562488bdaf8c in simplify_and_arguments (args=, context=context@entry=0x7fff3ba8bd90, haveNull=haveNull@entry=0x7fff3ba8bd3c, forceFalse=forceFalse@entry=0x7fff3ba8bd40) at ../src/backend/optimizer/util/clauses.c:3964 [01:35:06.307] arg = 0x56249cf04d38 [01:35:06.307] newargs = 0x56249cf04f48 [01:35:06.307] unprocessed_args = 0x0 [01:35:06.307] #9 0x0000562488bd7f86 in eval_const_expressions_mutator (node=0x56249cf04b78, context=context@entry=0x7fff3ba8bd90) at ../src/backend/optimizer/util/clauses.c:2877 [01:35:06.307] newargs = [01:35:06.307] haveNull = false [01:35:06.307] forceFalse = false [01:35:06.307] expr = 0x56249cf04b78 [01:35:06.307] __func__ = "eval_const_expressions_mutator" [01:35:06.307] #10 0x0000562488bdaac2 in eval_const_expressions (root=root@entry=0x56249ce42a48, node=node@entry=0x56249cf04b78) at ../src/backend/optimizer/util/clauses.c:2272 [01:35:06.307] context = {boundParams = 0x0, root = 0x56249ce42a48, active_fns = 0x0, case_val = 0x0, estimate = false} [01:35:06.307] #11 0x0000562488bb3f65 in convert_EXISTS_sublink_to_join (root=0x56249ce42a48, sublink=sublink@entry=0x56249ce0ce90, under_not=under_not@entry=false, available_rels=available_rels@entry=0x56249ce42f78) at ../src/backend/optimizer/plan/subselect.c:1541 [01:35:06.307] je = [01:35:06.307] lc__state = [01:35:06.307] result = [01:35:06.307] parse = 0x56249ce0d2b0 [01:35:06.307] subselect = 0x56249cea8018 [01:35:06.307] whereClause = 0x56249cf04b78 [01:35:06.307] subroot = {type = 2294096832, parse = 0x7fff3ba8c2c0, glob = 0x1, query_level = 2293222446, parent_root = 0x56249d06d828, plan_params = 0x562488afbb9b , outer_params = 0x5624893c2e5f, simple_rel_array = 0x56249ce0ccb0, simple_rel_array_size = 0, simple_rte_array = 0x7fff3ba8c2c0, append_rel_array = 0x1, all_baserels = 0x1, outer_join_rels = 0x800, all_query_rels = 0x562488bd24da , join_rel_list = 0x7fff3ba8c340, join_rel_hash = 0x56249d06d878, join_rel_level = 0x562488bd23c0 , join_cur_level = 1000915648, init_plans = 0x1, cte_plan_ids = 0x562488afd28c , multiexpr_params = 0x0, join_domains = 0x0, eq_classes = 0x800, ec_merging_done = 72, canon_pathkeys = 0x562488bd23c0 , left_join_clauses = 0x7fff3ba8c2c0, right_join_clauses = 0x7fff3ba8c2c0, full_join_clauses = 0x0, join_info_list = 0x800, last_rinfo_serial = -2001747345, all_result_relids = 0x5624893c2e5f, leaf_result_relids = 0x56249d06c9b0, append_rel_list = 0x562488bd23c0 , row_identity_vars = 0x56249cf11348, rowMarks = 0x0, placeholder_list = 0x7fff3ba8c2c0, placeholder_array = 0x7fff3ba8c2c0, placeholder_array_size = 0, fkey_list = 0x800, query_pathkeys = 0x562488bd24da , group_pathkeys = 0x562488bd23c0 , num_groupby_pathkeys = -1661922440, window_pathkeys = 0x562488bd23c0 , distinct_pathkeys = 0x56249d06d220, sort_pathkeys = 0x562488bd23c0 , setop_pathkeys = 0x7fff3ba8c2c0, part_schemes = 0x0, initial_rels = 0x562488afdc7b , upper_rels = {0x56249cde0130, 0x56249d06c818, 0x3, 0x3, 0x0, 0x562489102a46 , 0x56249cf089d0, 0x400}, upper_targets = {0x7, 0x562489103b87 , 0x23ba8c2c0, 0x7, 0x0, 0x400, 0x56249cf08b60, 0x2}, processed_groupClause = 0x20, processed_distinctClause = 0x0, processed_tlist = 0x0, update_colnos = 0x562489118da3 , grouping_map = 0x20, minmax_aggs = 0x56249cf08b60, planner_cxt = 0x0, total_table_pages = 4.6795387305088351e-310, tuple_fraction = 4.6795551461858629e-310, limit_tuples = 7.9050503334599447e-323, qual_security_level = 1, hasJoinRTEs = false, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 135, placeholdersFrozen = 59, hasRecursion = 16, group_rtindex = 22052, agginfos = 0x9cf08ad0, aggtransinfos = 0x1, numOrderedAggs = 0, hasNonPartialAggs = false, hasNonSerialAggs = false, wt_param_id = 16, non_recursive_path = 0x2, curOuterRels = 0x2, curOuterParams = 0x1, isAltSubplan = 0x56249ce42ee0, isUsedSubplan = 0x0, join_search_private = 0x56248911927f , partColsUpdated = 164, partPruneInfos = 0x0} [01:35:06.307] rtoffset = [01:35:06.307] varno = [01:35:06.307] clause_varnos = [01:35:06.307] upper_varnos = [01:35:06.307] lc = [01:35:06.307] newWhere = 0x0 [01:35:06.307] all_clauses = 0x56249cf04b28 [01:35:06.307] upper_reference_exists = false [01:35:06.307] #12 0x0000562488bbed85 in pull_up_sublinks_qual_recurse (root=root@entry=0x56249ce42a48, node=0x56249ce0ce90, jtlink1=jtlink1@entry=0x56249ce42ee0, available_rels1=0x56249ce42f78, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [01:35:06.307] sublink = 0x56249ce0ce90 [01:35:06.307] j = [01:35:06.307] child_rels = 0x56249ce0cee0 [01:35:06.307] #13 0x0000562488bbe859 in pull_up_sublinks_jointree_recurse (root=root@entry=0x56249ce42a48, jtnode=, relids=relids@entry=0x7fff3ba8c208) at ../src/backend/optimizer/prep/prepjointree.c:776 [01:35:06.307] j = 0x56249ce42ec8 [01:35:06.307] leftrelids = 0x56249ce42f58 [01:35:06.307] rightrelids = 0x56249ce42f78 [01:35:06.307] jtlink = 0x56249ce42ec8 [01:35:06.307] __func__ = "pull_up_sublinks_jointree_recurse" [01:35:06.307] #14 0x0000562488bbe98d in pull_up_sublinks_jointree_recurse (root=root@entry=0x56249ce42a48, jtnode=0x56249cf12368, relids=relids@entry=0x7fff3ba8c258) at ../src/backend/optimizer/prep/prepjointree.c:706 [01:35:06.307] newchild = [01:35:06.307] childrelids = 0x40000000a97e [01:35:06.307] l__state = [01:35:06.307] frelids = 0x0 [01:35:06.307] newf = [01:35:06.307] jtlink = 0x40000000a97e [01:35:06.307] f = 0x56249cf12368 [01:35:06.307] newfromlist = 0x0 [01:35:06.307] l = [01:35:06.307] __func__ = "pull_up_sublinks_jointree_recurse" [01:35:06.307] #15 0x0000562488bc0973 in pull_up_sublinks (root=root@entry=0x56249ce42a48) at ../src/backend/optimizer/prep/prepjointree.c:653 [01:35:06.307] jtnode = [01:35:06.307] relids = 0x56249ce0d2b0 [01:35:06.307] #16 0x0000562488b9fa4d in subquery_planner (glob=glob@entry=0x56249ce3b4e8, parse=parse@entry=0x56249ce0d2b0, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:751 [01:35:06.307] root = 0x56249ce42a48 [01:35:06.307] newWithCheckOptions = [01:35:06.307] newHaving = [01:35:06.307] hasOuterJoins = [01:35:06.307] hasResultRTEs = [01:35:06.307] final_rel = [01:35:06.307] l = [01:35:06.307] #17 0x0000562488ba1c37 in standard_planner (parse=parse@entry=0x56249ce0d2b0, query_string=query_string@entry=0x56249ce0b6e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:436 [01:35:06.307] result = [01:35:06.307] glob = 0x56249ce3b4e8 [01:35:06.307] tuple_fraction = 0 [01:35:06.307] root = [01:35:06.307] final_rel = [01:35:06.307] best_path = [01:35:06.307] top_plan = [01:35:06.307] lp = [01:35:06.307] lr = [01:35:06.307] #18 0x00007f30a1c3e82d in pgss_planner (parse=0x56249ce0d2b0, query_string=0x56249ce0b6e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=2048, boundParams=0x0) at ../contrib/pg_stat_statements/pg_stat_statements.c:983 [01:35:06.307] _save_exception_stack = 0x7fff3ba8cb30 [01:35:06.307] _save_context_stack = 0x0 [01:35:06.307] _local_sigjmp_buf = {{__jmpbuf = {94715250791088, -6068816588303670659, 0, 2048, 94715250791088, 2048, -544805918099283331, -437058959542623619}, __mask_was_saved = 0, __saved_mask = {__val = {139846813058288, 94715251271240, 94715251269504, 2375403309, 94714917825136, 43390, 0, 0, 194274445312, 43390, 0, 139846813058352, 139846813058288, 0, 0, 140734194682284}}}} [01:35:06.307] _do_rethrow = false [01:35:06.307] result = 0x13ba8c3c8 [01:35:06.307] #19 0x0000562488ba2d1b in planner (parse=parse@entry=0x56249ce0d2b0, query_string=query_string@entry=0x56249ce0b6e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:293 [01:35:06.307] result = [01:35:06.307] #20 0x0000562488e21ffa in pg_plan_query (querytree=querytree@entry=0x56249ce0d2b0, query_string=query_string@entry=0x56249ce0b6e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:900 [01:35:06.307] plan = [01:35:06.307] #21 0x00005624888f6bdf in standard_ExplainOneQuery (query=0x56249ce0d2b0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x56249cea7f88, queryString=0x56249ce0b6e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:353 [01:35:06.307] plan = [01:35:06.307] planstart = [01:35:06.307] planduration = {ticks = 94714911978327} [01:35:06.307] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94714918353799, shared_blks_dirtied = 1000916974, shared_blks_written = 3, local_blks_hit = 6927135368, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94715250791088, shared_blk_read_time = {ticks = -5159148872915149421}, shared_blk_write_time = {ticks = 94714918441190}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94714911975708}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94715250791088}} [01:35:06.307] bufusage = {shared_blks_hit = 1, shared_blks_read = 94714915089476, shared_blks_dirtied = 186358630989824, shared_blks_written = 72057594037927936, local_blks_hit = 139846813021280, local_blks_read = 94715253275432, local_blks_dirtied = 94715250791088, local_blks_written = 1, temp_blks_read = 1, temp_blks_written = 94714917965510, shared_blk_read_time = {ticks = 139846813021280}, shared_blk_write_time = {ticks = 94714917965529}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94714918349382}, temp_blk_read_time = {ticks = 94715250606384}, temp_blk_write_time = {ticks = 64}} [01:35:06.307] mem_counters = {nblocks = 94715250980344, freechunks = 8589934593, totalspace = 140734194304880, freespace = 10} [01:35:06.307] planner_ctx = 0x0 [01:35:06.307] saved_ctx = 0x0 [01:35:06.307] #22 0x00005624888f6ec5 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x56249cea7f88, pstate=pstate@entry=0x56249cde03e8, params=params@entry=0x0) at ../src/backend/commands/explain.c:309 [01:35:06.307] No locals. [01:35:06.307] #23 0x00005624888f716d in ExplainQuery (pstate=pstate@entry=0x56249cde03e8, stmt=stmt@entry=0x56249ce0d0f0, params=params@entry=0x0, dest=dest@entry=0x56249cde0358) at ../src/backend/commands/explain.c:223 [01:35:06.307] l__state = [01:35:06.307] l = 0x56249ce42a10 [01:35:06.307] es = 0x56249cea7f88 [01:35:06.307] tstate = [01:35:06.307] jstate = [01:35:06.307] query = [01:35:06.307] rewritten = 0x56249ce429f8 [01:35:06.307] #24 0x0000562488e2cf4d in standard_ProcessUtility (pstmt=pstmt@entry=0x56249ce0d1a0, queryString=queryString@entry=0x56249ce0b6e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=readOnlyTree@entry=false, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x56249cde0358, qc=0x7fff3ba8cd70) at ../src/backend/tcop/utility.c:866 [01:35:06.307] parsetree = 0x56249ce0d0f0 [01:35:06.307] isTopLevel = true [01:35:06.307] isAtomicContext = false [01:35:06.307] pstate = 0x56249cde03e8 [01:35:06.307] readonly_flags = [01:35:06.307] __func__ = "standard_ProcessUtility" [01:35:06.307] #25 0x00007f30a1c3dfa9 in pgss_ProcessUtility (pstmt=0x56249ce0d1a0, queryString=0x56249ce0b6e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x56249cde0358, qc=0x7fff3ba8cd70) at ../contrib/pg_stat_statements/pg_stat_statements.c:1181 [01:35:06.307] _save_exception_stack = 0x7fff3ba8ce10 [01:35:06.307] _save_context_stack = 0x0 [01:35:06.307] _local_sigjmp_buf = {{__jmpbuf = {0, 544375589606875773, 94715250790816, 94715250606936, 140734194306416, 1, -544805917868596611, -437058958700486019}, __mask_was_saved = 0, __saved_mask = {__val = {94714918225290, 94715250783712, 94714913665708, 2, 140734194306168, 94715251862922, 94715251862922, 94715251862024, 94714919792687, 447, 0, 94715251864376, 0, 94715251860904, 139846887370909, 1}}}} [01:35:06.307] _do_rethrow = false [01:35:06.307] duration = [01:35:06.307] bufusage = {shared_blks_hit = 0, shared_blks_read = 94714919244895, shared_blks_dirtied = 1, shared_blks_written = 94715250789552, local_blks_hit = 94715251860904, local_blks_read = 490, local_blks_dirtied = 1, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94714918349382, shared_blk_read_time = {ticks = 94715250783712}, shared_blk_write_time = {ticks = 94714918349382}, local_blk_read_time = {ticks = 94715250783712}, local_blk_write_time = {ticks = 3}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94714918353799}} [01:35:06.307] walusage_start = {wal_records = 61, wal_fpi = 0, wal_bytes = 6399, wal_buffers_full = 0} [01:35:06.307] start = [01:35:06.307] rows = [01:35:06.307] bufusage_start = {shared_blks_hit = 492, shared_blks_read = 65, shared_blks_dirtied = 9, shared_blks_written = 12, local_blks_hit = 0, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [01:35:06.307] walusage = {wal_records = 140734194305856, wal_fpi = 94714917828750, wal_bytes = 140734194305856, wal_buffers_full = 94714918024172} [01:35:06.307] parsetree = [01:35:06.307] saved_queryId = 2174664879250974619 [01:35:06.307] saved_stmt_location = 0 [01:35:06.307] saved_stmt_len = 204 [01:35:06.307] enabled = true [01:35:06.307] #26 0x0000562488e2d533 in ProcessUtility (pstmt=pstmt@entry=0x56249ce0d1a0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x56249cde0358, qc=0x7fff3ba8cd70) at ../src/backend/tcop/utility.c:519 [01:35:06.307] No locals. [01:35:06.307] #27 0x0000562488e2903a in PortalRunUtility (portal=portal@entry=0x56249ce8bf70, pstmt=0x56249ce0d1a0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x56249cde0358, qc=qc@entry=0x7fff3ba8cd70) at ../src/backend/tcop/pquery.c:1153 [01:35:06.307] No locals. [01:35:06.307] #28 0x0000562488e29895 in FillPortalStore (portal=portal@entry=0x56249ce8bf70, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [01:35:06.307] treceiver = 0x56249cde0358 [01:35:06.307] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:35:06.307] __func__ = "FillPortalStore" [01:35:06.307] #29 0x0000562488e29db0 in PortalRun (portal=portal@entry=0x56249ce8bf70, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x56249cf134e8, altdest=altdest@entry=0x56249cf134e8, qc=qc@entry=0x7fff3ba8cf30) at ../src/backend/tcop/pquery.c:760 [01:35:06.307] _save_exception_stack = 0x7fff3ba8cfe0 [01:35:06.307] _save_context_stack = 0x0 [01:35:06.307] _local_sigjmp_buf = {{__jmpbuf = {0, -6068816738693586307, 94715251310448, 94715250790760, 94715250790736, 94715250790688, -544805918007008643, -6068860584489164163}, __mask_was_saved = 0, __saved_mask = {__val = {94714918353799, 1000918719, 4, 94715250790688, 112, 153, 94715251310448, 94715250790760, 94715250790736, 94715250790688, 94714918441599, 1, 2, 153, 94714907455045, 0}}}} [01:35:06.307] _do_rethrow = [01:35:06.307] result = [01:35:06.307] nprocessed = [01:35:06.307] saveTopTransactionResourceOwner = 0x56249ce4f988 [01:35:06.307] saveTopTransactionContext = 0x56249cea2450 [01:35:06.307] saveActivePortal = 0x0 [01:35:06.307] saveResourceOwner = 0x56249ce4f988 [01:35:06.307] savePortalContext = 0x0 [01:35:06.307] saveMemoryContext = 0x56249cea2450 [01:35:06.307] __func__ = "PortalRun" [01:35:06.307] #30 0x0000562488e22ae8 in exec_simple_query (query_string=query_string@entry=0x56249ce0b6e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"...) at ../src/backend/tcop/postgres.c:1274 [01:35:06.307] cmdtaglen = 7 [01:35:06.307] snapshot_set = [01:35:06.307] per_parsetree_context = 0x0 [01:35:06.307] plantree_list = 0x56249cf13498 [01:35:06.307] parsetree = 0x56249ce0d120 [01:35:06.307] commandTag = [01:35:06.307] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:35:06.307] querytree_list = [01:35:06.307] portal = 0x56249ce8bf70 [01:35:06.307] receiver = 0x56249cf134e8 [01:35:06.307] format = 0 [01:35:06.307] cmdtagname = [01:35:06.307] parsetree_item__state = [01:35:06.307] dest = DestRemote [01:35:06.307] oldcontext = 0x56249cea2450 [01:35:06.307] parsetree_list = 0x56249ce0d150 [01:35:06.307] parsetree_item = 0x56249ce0d168 [01:35:06.307] save_log_statement_stats = false [01:35:06.307] was_logged = true [01:35:06.307] use_implicit_block = false [01:35:06.307] msec_str = "\2406\251\211$V\000\000SR\016\211$V\000\000\300Ϩ;\377\177\000\000\316\000\000\000\000\000\000" [01:35:06.307] __func__ = "exec_simple_query" [01:35:06.307] #31 0x0000562488e25d31 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4767 [01:35:06.307] query_string = 0x56249ce0b6e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"... [01:35:06.307] firstchar = [01:35:06.307] input_message = {data = 0x56249ce0b6e0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., len = 206, maxlen = 1024, cursor = 206} [01:35:06.307] local_sigjmp_buf = {{__jmpbuf = {94714931439832, -6068863172794031491, 4, 94714928379552, 24, 8, -544805917939899779, -6068860591177768323}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94715251038512, 0, 168, 94714918353901, 0, 10, 2, 94714931439840, 94715250514144, 94714931433856, 94714928379552, 24, 8}}}} [01:35:06.307] send_ready_for_query = false [01:35:06.307] idle_in_transaction_timeout_enabled = false [01:35:06.307] idle_session_timeout_enabled = false [01:35:06.307] __func__ = "PostgresMain" [01:35:06.307] #32 0x0000562488e1b63b in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [01:35:06.307] bsdata = [01:35:06.307] #33 0x0000562488cb7864 in postmaster_child_launch (child_type=B_BACKEND, child_slot=8, startup_data=startup_data@entry=0x7fff3ba8d140, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7fff3ba8d1b0) at ../src/backend/postmaster/launch_backend.c:290 [01:35:06.307] pid = [01:35:06.307] #34 0x0000562488cbce28 in BackendStartup (client_sock=client_sock@entry=0x7fff3ba8d1b0) at ../src/backend/postmaster/postmaster.c:3587 [01:35:06.307] bn = 0x56249ce36d18 [01:35:06.307] pid = [01:35:06.307] startup_data = {canAcceptConnections = CAC_OK, socket_created = 808536558774206, fork_started = 808536558774209} [01:35:06.307] cac = [01:35:06.307] __func__ = "BackendStartup" [01:35:06.307] #35 0x0000562488cbf354 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [01:35:06.307] s = {sock = 62, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\250\206އ$V\000\000\030Mڇ$V\000\000\000Ө;\377\177\000\000\370Ҩ;\377\177\000\000\225[\362\001\000\000\000\000\300`\343\234$V\000\000.", '\000' , "\377\177\000\000\000\004\000\000\000\000\000\000hf\244\2450\177\000\000\020\254\203\2440\177\000\000\340b\244\2450\177\000\000\316)fR\000\000\000", __ss_align = 1000919872}, salen = 2}} [01:35:06.307] i = 0 [01:35:06.307] now = [01:35:06.307] last_lockfile_recheck_time = 1755221348 [01:35:06.307] last_touch_time = 1755221288 [01:35:06.307] events = {{pos = 1, events = 2, fd = 60, user_data = 0x0}, {pos = 0, events = 0, fd = 60, user_data = 0x0}, {pos = 1000919936, events = 32767, fd = -1516127672, user_data = 0x11}, {pos = -1534874608, events = 32560, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1515953440, user_data = 0x7fff3ba8d2f8}, {pos = 1000919808, events = 32767, fd = -1515952536, user_data = 0x0}, {pos = -1662809128, events = 22052, fd = -1542751558, user_data = 0x56249ce38bd8}, {pos = 1, events = 22052, fd = 32768, user_data = 0xffffffff}, {pos = -1543315424, events = 32560, fd = -1520961008, user_data = 0x56249cdce778}, {pos = -1663244712, events = 22052, fd = -1662798287, user_data = 0x7f30a5a21ebe}, {pos = 1, events = 0, fd = -1515953440, user_data = 0x1b4}, {pos = -1989628512, events = 22052, fd = 0, user_data = 0x0}, {pos = 86, events = 0, fd = -1516101954, user_data = 0x1}, {pos = 0, events = 0, fd = -1543315424, user_data = 0x7f30a40f2e80 }, {pos = 16, events = 0, fd = 1000920928, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f30a5a242ba}, {pos = 0, events = 0, fd = -1542787628, user_data = 0x0}, {pos = -1982442624, events = 22052, fd = 2, user_data = 0x0}, {pos = -1663276944, events = 22052, fd = -1998908548, user_data = 0x56249ce3ffb0}, {pos = -1998904748, events = 22052, fd = -1662779381, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -1543281464, user_data = 0x7f30a409c880 }, {pos = -1543685840, events = 32560, fd = 1000921136, user_data = 0x100007f00000002}, {pos = -1542754505, events = 32560, fd = 2, user_data = 0x1010}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -1541464992, events = 32560, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 171057184, events = 892875567, fd = 1634420490, user_data = 0x0}, {pos = 0, events = 0, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x7f30a4881a80}, {pos = -1534582848, events = 32560, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1662771248, events = 22052, fd = 1080, user_data = 0x56249cdce450}, {pos = -1995427130, events = 22052, fd = 1024, user_data = 0x7f30a40b58ee}, {pos = -1541482016, events = 32560, fd = -1542844050, user_data = 0x100000400}, {pos = 7, events = 0, fd = -1662779472, user_data = 0xf1529ab061e6be00}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x56249cdce450}, {pos = 3, events = 0, fd = 0, user_data = 0x820a}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x77}, {pos = -1542508397, events = 32560, fd = -1663245232, user_data = 0x1}, {pos = -1663245032, events = 22052, fd = 1024, user_data = 0x7fff3ba8d838}, {pos = -1995345961, events = 22052, fd = -1982338928, user_data = 0x562489105a77 }, {pos = -1663245232, events = 22052, fd = -1662994976, user_data = 0x56249cdce450}, {pos = -1542760549, events = 32560, fd = 0, user_data = 0x5624891178a5 }, {pos = -1663245232, events = 1, fd = -1995343378, user_data = 0x56249ce0b5e0}, {pos = -1542837583, events = 32560, fd = -1542843152, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1642511872, events = 4048722608, fd = -1663276944, user_data = 0xf1529ab061e6be00}, {pos = 13, events = 0, fd = 1642511872, user_data = 0x0}, {pos = -1543130567, events = 32560, fd = 0, user_data = 0x562488cb754a }, {pos = 4194304, events = 0, fd = -1663161280, user_data = 0x1}, {pos = 0, events = 0, fd = -1663276944, user_data = 0x56248910590b }, {pos = -1663161280, events = 22052, fd = -1662994976, user_data = 0x56249cde2c40}, {pos = 1, events = 0, fd = 0, user_data = 0x5624890c38de }, {pos = 13, events = 0, fd = -1662811640, user_data = 0x56249ce381e8}, {pos = -1982441192, events = 22052, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = -1999931644, user_data = 0x56249ce0b5e0}, {pos = -1999914736, events = 22052, fd = -1986140368, user_data = 0x56249ce0bf98}} [01:35:06.307] nevents = 1 [01:35:06.307] __func__ = "ServerLoop" [01:35:06.307] #36 0x0000562488cc0bb8 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x56249cdc97e0) at ../src/backend/postmaster/postmaster.c:1400 [01:35:06.307] opt = [01:35:06.307] status = [01:35:06.307] userDoption = [01:35:06.307] listen_addr_saved = false [01:35:06.307] output_config_variable = [01:35:06.307] __func__ = "PostmasterMain" [01:35:06.307] #37 0x0000562488aeaa9f in main (argc=4, argv=0x56249cdc97e0) at ../src/backend/main/main.c:231 [01:35:06.307] do_check_root = [01:35:06.307] dispatch_option = [01:35:06.346] -e [01:35:06.346] [01:35:06.346] [01:35:06.404] dumping /tmp/cores/sh-3-37158.core for /bin/sh [01:35:06.449] [01:35:06.449] This GDB supports auto-downloading debuginfo from the following URLs: [01:35:06.449] [01:35:06.449] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:35:06.449] Debuginfod has been disabled. [01:35:06.449] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:35:06.453] [New LWP 37158] [01:35:06.455] [Thread debugging using libthread_db enabled] [01:35:06.455] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:35:06.455] Core was generated by `sh -c cp "/tmp/cirrus-ci-build/build/testrun/recovery/042_low_level_backup/data'. [01:35:06.455] Program terminated with signal SIGQUIT, Quit. [01:35:06.455] #0 0x00007f766c5b6dd4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:06.456] [01:35:06.456] Thread 1 (Thread 0x7f766c524740 (LWP 37158)): [01:35:06.456] #0 0x00007f766c5b6dd4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:06.456] No symbol table info available. [01:35:06.456] #1 0x00007f766c563239 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:06.456] No symbol table info available. [01:35:06.456] #2 0x00007f766c563497 in sigsetmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:06.456] No symbol table info available. [01:35:06.456] #3 0x000055b1ce2605c1 in ?? () [01:35:06.456] No symbol table info available. [01:35:06.456] #4 0x000055b1ce25a369 in ?? () [01:35:06.456] No symbol table info available. [01:35:06.456] #5 0x000055b1ce25920f in ?? () [01:35:06.456] No symbol table info available. [01:35:06.456] #6 0x000055b1ce259c3b in ?? () [01:35:06.456] No symbol table info available. [01:35:06.456] #7 0x000055b1ce25766f in ?? () [01:35:06.456] No symbol table info available. [01:35:06.456] #8 0x00007f766c54e24a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:06.456] No symbol table info available. [01:35:06.456] #9 0x00007f766c54e305 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:06.456] No symbol table info available. [01:35:06.456] #10 0x000055b1ce257781 in ?? () [01:35:06.456] No symbol table info available. [01:35:06.464] -e [01:35:06.464] [01:35:06.464] [01:35:06.553] dumping /tmp/cores/postgres-6-32353.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [01:35:06.805] [New LWP 32353] [01:35:06.805] [01:35:06.805] This GDB supports auto-downloading debuginfo from the following URLs: [01:35:06.805] [01:35:06.805] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:35:06.805] Debuginfod has been disabled. [01:35:06.805] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:35:07.046] [Thread debugging using libthread_db enabled] [01:35:07.046] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:35:07.046] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN '. [01:35:07.046] Program terminated with signal SIGABRT, Aborted. [01:35:07.046] #0 0x00007ff0934a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:08.053] [01:35:08.053] Thread 1 (Thread 0x7ff0933d4a80 (LWP 32353)): [01:35:08.053] #0 0x00007ff0934a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:08.053] No symbol table info available. [01:35:08.053] #1 0x00007ff09345afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:08.053] No symbol table info available. [01:35:08.053] #2 0x00007ff093445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:08.053] No symbol table info available. [01:35:08.053] #3 0x000055eb800e5e36 in ExceptionalCondition (conditionName=conditionName@entry=0x55eb80319e49 "n >= 0 && n < list->length", fileName=fileName@entry=0x55eb80314d60 "../src/include/nodes/pg_list.h", lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [01:35:08.053] No locals. [01:35:08.053] #4 0x000055eb7fbf78ca in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [01:35:08.053] No locals. [01:35:08.053] #5 0x000055eb7fbf78ff in list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [01:35:08.053] No locals. [01:35:08.053] #6 0x000055eb7fbfd031 in var_is_nonnullable (root=0x55eb89fe8968, var=var@entry=0x55eb8a0c32d8, use_rel_info=use_rel_info@entry=false) at ../src/backend/optimizer/util/clauses.c:4235 [01:35:08.053] rte = [01:35:08.053] notnullattnums = 0x0 [01:35:08.053] #7 0x000055eb7fc00efe in eval_const_expressions_mutator (node=node@entry=0x55eb8a0c3258, context=context@entry=0x7ffdd8f79550) at ../src/backend/optimizer/util/clauses.c:3556 [01:35:08.053] varg = 0x55eb8a0c32d8 [01:35:08.053] result = [01:35:08.053] ntest = 0x55eb8a0c3258 [01:35:08.053] newntest = [01:35:08.053] arg = 0x55eb8a0c32d8 [01:35:08.053] __func__ = "eval_const_expressions_mutator" [01:35:08.053] #8 0x000055eb7fc01f8c in simplify_and_arguments (args=, context=context@entry=0x7ffdd8f79550, haveNull=haveNull@entry=0x7ffdd8f794fc, forceFalse=forceFalse@entry=0x7ffdd8f79500) at ../src/backend/optimizer/util/clauses.c:3964 [01:35:08.053] arg = 0x55eb8a0c3258 [01:35:08.053] newargs = 0x55eb8a0c3468 [01:35:08.053] unprocessed_args = 0x0 [01:35:08.053] #9 0x000055eb7fbfef86 in eval_const_expressions_mutator (node=0x55eb8a0c3098, context=context@entry=0x7ffdd8f79550) at ../src/backend/optimizer/util/clauses.c:2877 [01:35:08.053] newargs = [01:35:08.053] haveNull = false [01:35:08.053] forceFalse = false [01:35:08.053] expr = 0x55eb8a0c3098 [01:35:08.053] __func__ = "eval_const_expressions_mutator" [01:35:08.053] #10 0x000055eb7fc01ac2 in eval_const_expressions (root=root@entry=0x55eb89fe8968, node=node@entry=0x55eb8a0c3098) at ../src/backend/optimizer/util/clauses.c:2272 [01:35:08.053] context = {boundParams = 0x0, root = 0x55eb89fe8968, active_fns = 0x0, case_val = 0x0, estimate = false} [01:35:08.053] #11 0x000055eb7fbdaf65 in convert_EXISTS_sublink_to_join (root=0x55eb89fe8968, sublink=sublink@entry=0x55eb89fbfe70, under_not=under_not@entry=false, available_rels=available_rels@entry=0x55eb89fe8e98) at ../src/backend/optimizer/plan/subselect.c:1541 [01:35:08.053] je = [01:35:08.053] lc__state = [01:35:08.053] result = [01:35:08.053] parse = 0x55eb89fc0290 [01:35:08.053] subselect = 0x55eb8a1f62d8 [01:35:08.053] whereClause = 0x55eb8a0c3098 [01:35:08.053] subroot = {type = 2143261632, parse = 0x7ffdd8f79a80, glob = 0x1, query_level = 2142387246, parent_root = 0x55eb8a0b4948, plan_params = 0x55eb7fb22b9b , outer_params = 0x55eb89ffa498, simple_rel_array = 0x55eb89fbfc90, simple_rel_array_size = 0, simple_rte_array = 0x7ffdd8f79a80, append_rel_array = 0x1, all_baserels = 0x1, outer_join_rels = 0x800, all_query_rels = 0x55eb7fbf94da , join_rel_list = 0x74a6, join_rel_hash = 0x55eb8a0b4998, join_rel_level = 0x55eb7fbf93c0 , join_cur_level = -654861696, init_plans = 0x1, cte_plan_ids = 0x55eb7fb2428c , multiexpr_params = 0x0, join_domains = 0x0, eq_classes = 0x800, ec_merging_done = 216, canon_pathkeys = 0x55eb7fbf93c0 , left_join_clauses = 0x7ffdd8f79a80, right_join_clauses = 0x7ffdd8f79a80, full_join_clauses = 0x0, join_info_list = 0x800, last_rinfo_serial = 2142384751, all_result_relids = 0x7ffdd8f797f0, leaf_result_relids = 0x55eb8a0b3ad0, append_rel_list = 0x55eb7fbf93c0 , row_identity_vars = 0x55eb8a0bcad8, rowMarks = 0x0, placeholder_list = 0x7ffdd8f79a80, placeholder_array = 0x7ffdd8f79a80, placeholder_array_size = 0, fkey_list = 0x800, query_pathkeys = 0x55eb7fbf94da , group_pathkeys = 0x55eb7fbf93c0 , num_groupby_pathkeys = -1978938616, window_pathkeys = 0x55eb7fbf93c0 , distinct_pathkeys = 0x55eb8a0b4340, sort_pathkeys = 0x55eb7fbf93c0 , setop_pathkeys = 0x7ffdd8f79a80, part_schemes = 0x0, initial_rels = 0x55eb7fb24c7b , upper_rels = {0x55eb8a020b68, 0x55eb8a0b3938, 0x3, 0x3, 0x0, 0x55eb80129a46 , 0x55eb8a0b6a70, 0x400}, upper_targets = {0x7, 0x55eb8012ab87 , 0x2d8f79a80, 0x7, 0x0, 0x400, 0x55eb8a0b6c00, 0x2}, processed_groupClause = 0x20, processed_distinctClause = 0x0, processed_tlist = 0x0, update_colnos = 0x55eb8013fda3 , grouping_map = 0x20, minmax_aggs = 0x55eb8a0b6c00, planner_cxt = 0x0, total_table_pages = 4.6674359022512827e-310, tuple_fraction = 4.6674441090189093e-310, limit_tuples = 7.9050503334599447e-323, qual_security_level = 1, hasJoinRTEs = false, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 135, placeholdersFrozen = 171, hasRecursion = 18, group_rtindex = 21995, agginfos = 0x8a0b6b70, aggtransinfos = 0x1, numOrderedAggs = 0, hasNonPartialAggs = false, hasNonSerialAggs = false, wt_param_id = 16, non_recursive_path = 0x2, curOuterRels = 0x2, curOuterParams = 0x1, isAltSubplan = 0x55eb89fe8e00, isUsedSubplan = 0x0, join_search_private = 0x55eb8014027f , partColsUpdated = 149, partPruneInfos = 0x0} [01:35:08.053] rtoffset = [01:35:08.053] varno = [01:35:08.053] clause_varnos = [01:35:08.053] upper_varnos = [01:35:08.053] lc = [01:35:08.053] newWhere = 0x0 [01:35:08.053] all_clauses = 0x55eb8a0c3048 [01:35:08.053] upper_reference_exists = false [01:35:08.053] #12 0x000055eb7fbe5d85 in pull_up_sublinks_qual_recurse (root=root@entry=0x55eb89fe8968, node=0x55eb89fbfe70, jtlink1=jtlink1@entry=0x55eb89fe8e00, available_rels1=0x55eb89fe8e98, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [01:35:08.053] sublink = 0x55eb89fbfe70 [01:35:08.053] j = [01:35:08.053] child_rels = 0x55eb89fbfec0 [01:35:08.053] #13 0x000055eb7fbe5859 in pull_up_sublinks_jointree_recurse (root=root@entry=0x55eb89fe8968, jtnode=, relids=relids@entry=0x7ffdd8f799c8) at ../src/backend/optimizer/prep/prepjointree.c:776 [01:35:08.053] j = 0x55eb89fe8de8 [01:35:08.053] leftrelids = 0x55eb89fe8e78 [01:35:08.053] rightrelids = 0x55eb89fe8e98 [01:35:08.053] jtlink = 0x55eb89fe8de8 [01:35:08.053] __func__ = "pull_up_sublinks_jointree_recurse" [01:35:08.053] #14 0x000055eb7fbe598d in pull_up_sublinks_jointree_recurse (root=root@entry=0x55eb89fe8968, jtnode=0x55eb8a0bdaf8, relids=relids@entry=0x7ffdd8f79a18) at ../src/backend/optimizer/prep/prepjointree.c:706 [01:35:08.053] newchild = [01:35:08.053] childrelids = 0x40030000a9d3 [01:35:08.053] l__state = [01:35:08.053] frelids = 0x0 [01:35:08.053] newf = [01:35:08.053] jtlink = 0x40030000a9d3 [01:35:08.053] f = 0x55eb8a0bdaf8 [01:35:08.053] newfromlist = 0x0 [01:35:08.053] l = [01:35:08.053] __func__ = "pull_up_sublinks_jointree_recurse" [01:35:08.053] #15 0x000055eb7fbe7973 in pull_up_sublinks (root=root@entry=0x55eb89fe8968) at ../src/backend/optimizer/prep/prepjointree.c:653 [01:35:08.053] jtnode = [01:35:08.053] relids = 0x55eb89fc0290 [01:35:08.053] #16 0x000055eb7fbc6a4d in subquery_planner (glob=glob@entry=0x55eb89ffa738, parse=parse@entry=0x55eb89fc0290, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:751 [01:35:08.053] root = 0x55eb89fe8968 [01:35:08.053] newWithCheckOptions = [01:35:08.053] newHaving = [01:35:08.053] hasOuterJoins = [01:35:08.053] hasResultRTEs = [01:35:08.053] final_rel = [01:35:08.053] l = [01:35:08.053] #17 0x000055eb7fbc8c37 in standard_planner (parse=0x55eb89fc0290, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:436 [01:35:08.053] result = [01:35:08.053] glob = 0x55eb89ffa738 [01:35:08.053] tuple_fraction = 0 [01:35:08.053] root = [01:35:08.053] final_rel = [01:35:08.053] best_path = [01:35:08.053] top_plan = [01:35:08.053] lp = [01:35:08.053] lr = [01:35:08.053] #18 0x000055eb7fbc9d4d in planner (parse=parse@entry=0x55eb89fc0290, query_string=query_string@entry=0x55eb89fbe6c0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:295 [01:35:08.053] result = [01:35:08.053] #19 0x000055eb7fe48ffa in pg_plan_query (querytree=querytree@entry=0x55eb89fc0290, query_string=query_string@entry=0x55eb89fbe6c0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:900 [01:35:08.053] plan = [01:35:08.053] #20 0x000055eb7f91dbdf in standard_ExplainOneQuery (query=0x55eb89fc0290, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55eb89ffa498, queryString=0x55eb89fbe6c0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:353 [01:35:08.053] plan = [01:35:08.053] planstart = [01:35:08.053] planduration = {ticks = 94469948007255} [01:35:08.053] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94469954382727, shared_blks_dirtied = 3640106094, shared_blks_written = 3, local_blks_hit = 4294967440, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94470120669840, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94469954470118}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94469948004636}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94470120669840}} [01:35:08.053] bufusage = {shared_blks_hit = 1, shared_blks_read = 94469951118404, shared_blks_dirtied = 186723703209987, shared_blks_written = 72057594037927936, local_blks_hit = 140671041074272, local_blks_read = 94470121663560, local_blks_dirtied = 94470120669840, local_blks_written = 1, temp_blks_read = 1, temp_blks_written = 94469953994438, shared_blk_read_time = {ticks = 140671041074272}, shared_blk_write_time = {ticks = 94469953994457}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94469954378310}, temp_blk_read_time = {ticks = 94470120485136}, temp_blk_write_time = {ticks = 64}} [01:35:08.053] mem_counters = {nblocks = 94470122988088, freechunks = 8589934593, totalspace = 140728243559408, freespace = 10} [01:35:08.053] planner_ctx = 0x0 [01:35:08.053] saved_ctx = 0x0 [01:35:08.053] #21 0x000055eb7f91dec5 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55eb89ffa498, pstate=pstate@entry=0x55eb89f933c8, params=params@entry=0x0) at ../src/backend/commands/explain.c:309 [01:35:08.053] No locals. [01:35:08.053] #22 0x000055eb7f91e16d in ExplainQuery (pstate=pstate@entry=0x55eb89f933c8, stmt=stmt@entry=0x55eb89fc00d0, params=params@entry=0x0, dest=dest@entry=0x55eb89f93338) at ../src/backend/commands/explain.c:223 [01:35:08.053] l__state = [01:35:08.053] l = 0x55eb8a1f62a0 [01:35:08.053] es = 0x55eb89ffa498 [01:35:08.053] tstate = [01:35:08.053] jstate = [01:35:08.053] query = [01:35:08.053] rewritten = 0x55eb8a1f6288 [01:35:08.053] #23 0x000055eb7fe53f4d in standard_ProcessUtility (pstmt=0x55eb89fc0180, queryString=0x55eb89fbe6c0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55eb89f93338, qc=0x7ffdd8f79e60) at ../src/backend/tcop/utility.c:866 [01:35:08.053] parsetree = 0x55eb89fc00d0 [01:35:08.053] isTopLevel = true [01:35:08.053] isAtomicContext = false [01:35:08.053] pstate = 0x55eb89f933c8 [01:35:08.053] readonly_flags = [01:35:08.053] __func__ = "standard_ProcessUtility" [01:35:08.053] #24 0x000055eb7fe545e8 in ProcessUtility (pstmt=pstmt@entry=0x55eb89fc0180, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55eb89f93338, qc=0x7ffdd8f79e60) at ../src/backend/tcop/utility.c:523 [01:35:08.053] No locals. [01:35:08.053] #25 0x000055eb7fe5003a in PortalRunUtility (portal=portal@entry=0x55eb8a0433f0, pstmt=0x55eb89fc0180, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55eb89f93338, qc=qc@entry=0x7ffdd8f79e60) at ../src/backend/tcop/pquery.c:1153 [01:35:08.053] No locals. [01:35:08.053] #26 0x000055eb7fe50895 in FillPortalStore (portal=portal@entry=0x55eb8a0433f0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [01:35:08.053] treceiver = 0x55eb89f93338 [01:35:08.053] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:35:08.053] __func__ = "FillPortalStore" [01:35:08.053] #27 0x000055eb7fe50db0 in PortalRun (portal=portal@entry=0x55eb8a0433f0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55eb8a0bddd8, altdest=altdest@entry=0x55eb8a0bddd8, qc=qc@entry=0x7ffdd8f7a020) at ../src/backend/tcop/pquery.c:760 [01:35:08.053] _save_exception_stack = 0x7ffdd8f7a0d0 [01:35:08.053] _save_context_stack = 0x0 [01:35:08.053] _local_sigjmp_buf = {{__jmpbuf = {0, -1249839738455874103, 94470121206768, 94470120669512, 94470120669488, 94470120669440, -5004897104485964343, -1250234070792297015}, __mask_was_saved = 0, __saved_mask = {__val = {94469954382727, 3640106927, 4, 94470120669440, 112, 153, 94470121206768, 94470120669512, 94470120669488, 94470120669440, 94469954470527, 1, 2, 153, 94469943483973, 0}}}} [01:35:08.053] _do_rethrow = [01:35:08.053] result = [01:35:08.053] nprocessed = [01:35:08.053] saveTopTransactionResourceOwner = 0x55eb89fffea8 [01:35:08.053] saveTopTransactionContext = 0x55eb8a057890 [01:35:08.053] saveActivePortal = 0x0 [01:35:08.053] saveResourceOwner = 0x55eb89fffea8 [01:35:08.053] savePortalContext = 0x0 [01:35:08.053] saveMemoryContext = 0x55eb8a057890 [01:35:08.053] __func__ = "PortalRun" [01:35:08.053] #28 0x000055eb7fe49ae8 in exec_simple_query (query_string=query_string@entry=0x55eb89fbe6c0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"...) at ../src/backend/tcop/postgres.c:1274 [01:35:08.053] cmdtaglen = 7 [01:35:08.053] snapshot_set = [01:35:08.053] per_parsetree_context = 0x0 [01:35:08.053] plantree_list = 0x55eb8a0bdd88 [01:35:08.053] parsetree = 0x55eb89fc0100 [01:35:08.053] commandTag = [01:35:08.053] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:35:08.053] querytree_list = [01:35:08.053] portal = 0x55eb8a0433f0 [01:35:08.053] receiver = 0x55eb8a0bddd8 [01:35:08.053] format = 0 [01:35:08.053] cmdtagname = [01:35:08.053] parsetree_item__state = [01:35:08.053] dest = DestRemote [01:35:08.053] oldcontext = 0x55eb8a057890 [01:35:08.053] parsetree_list = 0x55eb89fc0130 [01:35:08.053] parsetree_item = 0x55eb89fc0148 [01:35:08.053] save_log_statement_stats = false [01:35:08.053] was_logged = false [01:35:08.053] use_implicit_block = false [01:35:08.053] msec_str = "\240\246\253\200\353U\000\000S\302\020\200\353U\000\000\260\240\367\330\375\177\000\000\316\000\000\000\000\000\000" [01:35:08.053] __func__ = "exec_simple_query" [01:35:08.053] #29 0x000055eb7fe4cd31 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4767 [01:35:08.053] query_string = 0x55eb89fbe6c0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"... [01:35:08.053] firstchar = [01:35:08.053] input_message = {data = 0x55eb89fbe6c0 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., len = 206, maxlen = 1024, cursor = 206} [01:35:08.053] local_sigjmp_buf = {{__jmpbuf = {94469967468760, -1249827227380767287, 4, 94469964408480, 24, 7, -5004897104418855479, -1250234060311517751}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94470120392864, 16128, 94469967462784, 94470120926816, 24, 94469954382275, 0, 9, 2, 94469967468768, 94470120392864, 94469967462784, 94469964408480, 24, 7}}}} [01:35:08.053] send_ready_for_query = false [01:35:08.053] idle_in_transaction_timeout_enabled = false [01:35:08.053] idle_session_timeout_enabled = false [01:35:08.053] __func__ = "PostgresMain" [01:35:08.053] #30 0x000055eb7fe4263b in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [01:35:08.053] bsdata = [01:35:08.053] #31 0x000055eb7fcde864 in postmaster_child_launch (child_type=B_BACKEND, child_slot=7, startup_data=startup_data@entry=0x7ffdd8f7a230, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffdd8f7a2a0) at ../src/backend/postmaster/launch_backend.c:290 [01:35:08.053] pid = [01:35:08.053] #32 0x000055eb7fce3e28 in BackendStartup (client_sock=client_sock@entry=0x7ffdd8f7a2a0) at ../src/backend/postmaster/postmaster.c:3587 [01:35:08.053] bn = 0x55eb89fe6a78 [01:35:08.053] pid = [01:35:08.053] startup_data = {canAcceptConnections = CAC_OK, socket_created = 808536482860284, fork_started = 808536482860286} [01:35:08.053] cac = [01:35:08.053] __func__ = "BackendStartup" [01:35:08.053] #33 0x000055eb7fce6354 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [01:35:08.053] s = {sock = 140, raddr = {addr = {ss_family = 1, __ss_padding = "\367\330\375\177\000\0004\243\367\330\375\177", '\000' , "\250\366\340~\353U\000\000\030\275\334~\353U\000\000\000\244\367\330\375\177\000\000\370\243\367\330\375\177\000\000\225[\362\001\000\000\000\000p\212Ó\360\177\000\000-", '\000' , "\266\365\340~\353U\000\000h\026ޔ\360\177\000\000\020\214Ó\360\177\000", __ss_align = 140671266460384}, salen = 2}} [01:35:08.053] i = 0 [01:35:08.053] now = [01:35:08.053] last_lockfile_recheck_time = 1755221274 [01:35:08.053] last_touch_time = 1755221214 [01:35:08.053] events = {{pos = 1, events = 2, fd = 138, user_data = 0x0}, {pos = 0, events = 0, fd = -1797384600, user_data = 0x0}, {pos = -1797385504, events = 32752, fd = 2090263927, user_data = 0x7ffdd8f7a480}, {pos = -1797559736, events = 32752, fd = 17, user_data = 0x7ff093c38c10}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1797385504, events = 32752, fd = -654859272, user_data = 0x7ffdd8f7a400}, {pos = -1797384600, events = 32752, fd = 0, user_data = 0x55eb89fbe6d8}, {pos = -2145934329, events = 21995, fd = 32768, user_data = 0x1}, {pos = -1979972752, events = 21995, fd = -1, user_data = 0x7ff09342e020}, {pos = -1801700848, events = 32752, fd = -1980229832, user_data = 0x55eb89f81618}, {pos = -1979794399, events = 21995, fd = -1797534018, user_data = 0x1}, {pos = -1797385504, events = 32752, fd = 436, user_data = 0x55eb806b1da0 }, {pos = 0, events = 0, fd = 0, user_data = 0xe5}, {pos = -1797534018, events = 32752, fd = 1, user_data = 0x0}, {pos = -1824333792, events = 32752, fd = -1823527296, user_data = 0x10}, {pos = -654858160, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1797524806, user_data = 0x0}, {pos = -1823805996, events = 32752, fd = 0, user_data = 0x55eb80d8c380 }, {pos = 2, events = 0, fd = 0, user_data = 0x55eb89f79870}, {pos = 2145227348, events = 21995, fd = -1979773349, user_data = 0x55eb7fddd074 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55eb89fbe6d8}, {pos = -1797534018, events = 32752, fd = 1, user_data = 0x0}, {pos = -1824299832, events = 32752, fd = -1823881088, user_data = 0x44e}, {pos = -1823772515, events = 32752, fd = 2, user_data = 0x55eb89ff0e00}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = -1822483360, events = 32752, fd = 255, user_data = 0xfffffffffffffee8}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55eb89f81410}, {pos = -2146262330, events = 21995, fd = 1024, user_data = 0x7ff0934b58ee}, {pos = -1822500384, events = 32752, fd = -1823862418, user_data = 0x100000400}, {pos = 7, events = 0, fd = -1979794368, user_data = 0x4de46f0e9803c500}, {pos = -1822497312, events = 32752, fd = -336, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 3, events = 0, fd = 0, user_data = 0x5875}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x106}, {pos = -1823526765, events = 32752, fd = -1980230640, user_data = 0x1}, {pos = -1980230440, events = 21995, fd = 1024, user_data = 0x7ffdd8f7a928}, {pos = -2146181161, events = 21995, fd = -2133174128, user_data = 0x55eb8012ca77 }, {pos = -1980230640, events = 21995, fd = -1979980352, user_data = 0x55eb89f81410}, {pos = -1823778578, events = 32752, fd = 0, user_data = 0x55eb8013e8a5 }, {pos = -1980230640, events = 1, fd = -2146178578, user_data = 0x55eb89fbe5c0}, {pos = -1823855951, events = 32752, fd = -1823861520, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1744583424, events = 1306816270, fd = -1980262288, user_data = 0x4de46f0e9803c500}, {pos = 13, events = 0, fd = -1744583424, user_data = 0x0}, {pos = -1824148935, events = 32752, fd = 0, user_data = 0x55eb7fcde54a }, {pos = 4194304, events = 0, fd = -1980146656, user_data = 0x1}, {pos = 0, events = 0, fd = -1980262288, user_data = 0x55eb8012c90b }, {pos = -1980146656, events = 21995, fd = -1979980352, user_data = 0x55eb89f95c20}, {pos = 1, events = 0, fd = 0, user_data = 0x55eb800ea8de }, {pos = 13, events = 0, fd = -1979803032, user_data = 0x55eb89fe9a48}, {pos = -2133276392, events = 21995, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = 2144200452, user_data = 0x55eb89fbe5c0}, {pos = 2144217360, events = 21995, fd = -2136975568, user_data = 0x55eb89fbef68}} [01:35:08.053] nevents = 1 [01:35:08.053] __func__ = "ServerLoop" [01:35:08.053] #34 0x000055eb7fce7bb8 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55eb89f7c7b0) at ../src/backend/postmaster/postmaster.c:1400 [01:35:08.053] opt = [01:35:08.053] status = [01:35:08.053] userDoption = [01:35:08.053] listen_addr_saved = false [01:35:08.053] output_config_variable = [01:35:08.053] __func__ = "PostmasterMain" [01:35:08.053] #35 0x000055eb7fb11a9f in main (argc=4, argv=0x55eb89f7c7b0) at ../src/backend/main/main.c:231 [01:35:08.053] do_check_root = [01:35:08.053] dispatch_option = [01:35:08.092] -e [01:35:08.092] [01:35:08.092] [01:35:08.186] dumping /tmp/cores/postgres-6-32066.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [01:35:08.457] [New LWP 32066] [01:35:08.457] [01:35:08.457] This GDB supports auto-downloading debuginfo from the following URLs: [01:35:08.457] [01:35:08.457] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:35:08.457] Debuginfod has been disabled. [01:35:08.457] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:35:08.699] [Thread debugging using libthread_db enabled] [01:35:08.699] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:35:08.699] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [01:35:08.699] Program terminated with signal SIGABRT, Aborted. [01:35:08.699] #0 0x00007f8ce50a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:09.711] [01:35:09.711] Thread 1 (Thread 0x7f8ce2c1da80 (LWP 32066)): [01:35:09.711] #0 0x00007f8ce50a9eec in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:09.711] No symbol table info available. [01:35:09.711] #1 0x00007f8ce505afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:09.711] No symbol table info available. [01:35:09.711] #2 0x00007f8ce5045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:09.711] No symbol table info available. [01:35:09.711] #3 0x0000561bf8e1ae36 in ExceptionalCondition (conditionName=conditionName@entry=0x561bf904ee49 "n >= 0 && n < list->length", fileName=fileName@entry=0x561bf9049d60 "../src/include/nodes/pg_list.h", lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [01:35:09.711] No locals. [01:35:09.711] #4 0x0000561bf892c8ca in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [01:35:09.711] No locals. [01:35:09.711] #5 0x0000561bf892c8ff in list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [01:35:09.711] No locals. [01:35:09.711] #6 0x0000561bf8932031 in var_is_nonnullable (root=0x561c09c62c98, var=var@entry=0x561c09d48498, use_rel_info=use_rel_info@entry=false) at ../src/backend/optimizer/util/clauses.c:4235 [01:35:09.711] rte = [01:35:09.711] notnullattnums = 0x0 [01:35:09.711] #7 0x0000561bf8935efe in eval_const_expressions_mutator (node=node@entry=0x561c09d48418, context=context@entry=0x7ffd8c6f3df0) at ../src/backend/optimizer/util/clauses.c:3556 [01:35:09.711] varg = 0x561c09d48498 [01:35:09.711] result = [01:35:09.711] ntest = 0x561c09d48418 [01:35:09.711] newntest = [01:35:09.711] arg = 0x561c09d48498 [01:35:09.711] __func__ = "eval_const_expressions_mutator" [01:35:09.711] #8 0x0000561bf8936f8c in simplify_and_arguments (args=, context=context@entry=0x7ffd8c6f3df0, haveNull=haveNull@entry=0x7ffd8c6f3d9c, forceFalse=forceFalse@entry=0x7ffd8c6f3da0) at ../src/backend/optimizer/util/clauses.c:3964 [01:35:09.711] arg = 0x561c09d48418 [01:35:09.711] newargs = 0x561c09d48628 [01:35:09.711] unprocessed_args = 0x0 [01:35:09.711] #9 0x0000561bf8933f86 in eval_const_expressions_mutator (node=0x561c09d48258, context=context@entry=0x7ffd8c6f3df0) at ../src/backend/optimizer/util/clauses.c:2877 [01:35:09.711] newargs = [01:35:09.711] haveNull = false [01:35:09.711] forceFalse = false [01:35:09.711] expr = 0x561c09d48258 [01:35:09.711] __func__ = "eval_const_expressions_mutator" [01:35:09.711] #10 0x0000561bf8936ac2 in eval_const_expressions (root=root@entry=0x561c09c62c98, node=node@entry=0x561c09d48258) at ../src/backend/optimizer/util/clauses.c:2272 [01:35:09.711] context = {boundParams = 0x0, root = 0x561c09c62c98, active_fns = 0x0, case_val = 0x0, estimate = false} [01:35:09.711] #11 0x0000561bf890ff65 in convert_EXISTS_sublink_to_join (root=0x561c09c62c98, sublink=sublink@entry=0x561c09c39ec0, under_not=under_not@entry=false, available_rels=available_rels@entry=0x561c09c631c8) at ../src/backend/optimizer/plan/subselect.c:1541 [01:35:09.711] je = [01:35:09.711] lc__state = [01:35:09.711] result = [01:35:09.711] parse = 0x561c09c3a2e0 [01:35:09.711] subselect = 0x561c09c65c28 [01:35:09.711] whereClause = 0x561c09d48258 [01:35:09.711] subroot = {type = 4170376128, parse = 0x7ffd8c6f4320, glob = 0x1, query_level = 4169501742, parent_root = 0x561c09d38008, plan_params = 0x561bf8857b9b , outer_params = 0x561c09d40198, simple_rel_array = 0x561c09c39ce0, simple_rel_array_size = 0, simple_rte_array = 0x7ffd8c6f4320, append_rel_array = 0x1, all_baserels = 0x1, outer_join_rels = 0x800, all_query_rels = 0x561bf892e4da , join_rel_list = 0x74a6, join_rel_hash = 0x561c09d38058, join_rel_level = 0x561bf892e3c0 , join_cur_level = -1938865376, init_plans = 0x1, cte_plan_ids = 0x561bf885928c , multiexpr_params = 0x0, join_domains = 0x0, eq_classes = 0x800, ec_merging_done = 152, canon_pathkeys = 0x561bf892e3c0 , left_join_clauses = 0x7ffd8c6f4320, right_join_clauses = 0x7ffd8c6f4320, full_join_clauses = 0x0, join_info_list = 0x800, last_rinfo_serial = -125468049, all_result_relids = 0x7ffd8c6f4090, leaf_result_relids = 0x561c09d37190, append_rel_list = 0x561bf892e3c0 , row_identity_vars = 0x561c09d41c98, rowMarks = 0x0, placeholder_list = 0x7ffd8c6f4320, placeholder_array = 0x7ffd8c6f4320, placeholder_array_size = 0, fkey_list = 0x800, query_pathkeys = 0x561bf892e4da , group_pathkeys = 0x561bf892e3c0 , num_groupby_pathkeys = 164895944, window_pathkeys = 0x561bf892e3c0 , distinct_pathkeys = 0x561c09d37a00, sort_pathkeys = 0x561bf892e3c0 , setop_pathkeys = 0x7ffd8c6f4320, part_schemes = 0x0, initial_rels = 0x561bf8859c7b , upper_rels = {0x561c09c9b4a0, 0x561c09d36ff8, 0x3, 0x3, 0x0, 0x561bf8e5ea46 , 0x561c09d3a130, 0x400}, upper_targets = {0x7, 0x561bf8e5fb87 , 0x28c6f4320, 0x7, 0x0, 0x400, 0x561c09d3a2c0, 0x2}, processed_groupClause = 0x20, processed_distinctClause = 0x0, processed_tlist = 0x0, update_colnos = 0x561bf8e74da3 , grouping_map = 0x20, minmax_aggs = 0x561c09d3a2c0, planner_cxt = 0x0, total_table_pages = 4.677721634811182e-310, tuple_fraction = 4.6777356060719451e-310, limit_tuples = 7.9050503334599447e-323, qual_security_level = 1, hasJoinRTEs = false, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 135, placeholdersFrozen = 251, hasRecursion = 229, group_rtindex = 22043, agginfos = 0x9d3a230, aggtransinfos = 0x1, numOrderedAggs = 0, hasNonPartialAggs = false, hasNonSerialAggs = false, wt_param_id = 16, non_recursive_path = 0x2, curOuterRels = 0x2, curOuterParams = 0x1, isAltSubplan = 0x561c09c63130, isUsedSubplan = 0x0, join_search_private = 0x561bf8e7527f , partColsUpdated = 163, partPruneInfos = 0x0} [01:35:09.711] rtoffset = [01:35:09.711] varno = [01:35:09.711] clause_varnos = [01:35:09.711] upper_varnos = [01:35:09.711] lc = [01:35:09.711] newWhere = 0x0 [01:35:09.711] all_clauses = 0x561c09d48208 [01:35:09.711] upper_reference_exists = false [01:35:09.711] #12 0x0000561bf891ad85 in pull_up_sublinks_qual_recurse (root=root@entry=0x561c09c62c98, node=0x561c09c39ec0, jtlink1=jtlink1@entry=0x561c09c63130, available_rels1=0x561c09c631c8, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [01:35:09.711] sublink = 0x561c09c39ec0 [01:35:09.711] j = [01:35:09.711] child_rels = 0x561c09c39f10 [01:35:09.711] #13 0x0000561bf891a859 in pull_up_sublinks_jointree_recurse (root=root@entry=0x561c09c62c98, jtnode=, relids=relids@entry=0x7ffd8c6f4268) at ../src/backend/optimizer/prep/prepjointree.c:776 [01:35:09.711] j = 0x561c09c63118 [01:35:09.711] leftrelids = 0x561c09c631a8 [01:35:09.711] rightrelids = 0x561c09c631c8 [01:35:09.711] jtlink = 0x561c09c63118 [01:35:09.711] __func__ = "pull_up_sublinks_jointree_recurse" [01:35:09.711] #14 0x0000561bf891a98d in pull_up_sublinks_jointree_recurse (root=root@entry=0x561c09c62c98, jtnode=0x561c09d42cb8, relids=relids@entry=0x7ffd8c6f42b8) at ../src/backend/optimizer/prep/prepjointree.c:706 [01:35:09.711] newchild = [01:35:09.711] childrelids = 0x40000000a98e [01:35:09.711] l__state = [01:35:09.711] frelids = 0x0 [01:35:09.711] newf = [01:35:09.711] jtlink = 0x40000000a98e [01:35:09.711] f = 0x561c09d42cb8 [01:35:09.711] newfromlist = 0x0 [01:35:09.711] l = [01:35:09.711] __func__ = "pull_up_sublinks_jointree_recurse" [01:35:09.711] #15 0x0000561bf891c973 in pull_up_sublinks (root=root@entry=0x561c09c62c98) at ../src/backend/optimizer/prep/prepjointree.c:653 [01:35:09.711] jtnode = [01:35:09.711] relids = 0x561c09c3a2e0 [01:35:09.711] #16 0x0000561bf88fba4d in subquery_planner (glob=glob@entry=0x561c09d40438, parse=parse@entry=0x561c09c3a2e0, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:751 [01:35:09.711] root = 0x561c09c62c98 [01:35:09.711] newWithCheckOptions = [01:35:09.711] newHaving = [01:35:09.711] hasOuterJoins = [01:35:09.711] hasResultRTEs = [01:35:09.711] final_rel = [01:35:09.711] l = [01:35:09.711] #17 0x0000561bf88fdc37 in standard_planner (parse=0x561c09c3a2e0, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:436 [01:35:09.711] result = [01:35:09.711] glob = 0x561c09d40438 [01:35:09.711] tuple_fraction = 0 [01:35:09.711] root = [01:35:09.711] final_rel = [01:35:09.711] best_path = [01:35:09.711] top_plan = [01:35:09.711] lp = [01:35:09.711] lr = [01:35:09.711] #18 0x0000561bf88fed4d in planner (parse=parse@entry=0x561c09c3a2e0, query_string=query_string@entry=0x561c09c38710 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:295 [01:35:09.711] result = [01:35:09.711] #19 0x0000561bf8b7dffa in pg_plan_query (querytree=querytree@entry=0x561c09c3a2e0, query_string=query_string@entry=0x561c09c38710 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:900 [01:35:09.711] plan = [01:35:09.711] #20 0x0000561bf8652bdf in standard_ExplainOneQuery (query=0x561c09c3a2e0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x561c09d40198, queryString=0x561c09c38710 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:353 [01:35:09.711] plan = [01:35:09.711] planstart = [01:35:09.711] planduration = {ticks = 94678133551959} [01:35:09.711] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94678139927431, shared_blks_dirtied = 2356102414, shared_blks_written = 3, local_blks_hit = 4294967440, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94678422889184, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94678140014822}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94678133549340}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94678422889184}} [01:35:09.711] bufusage = {shared_blks_hit = 1, shared_blks_read = 94678136663108, shared_blks_dirtied = 186427350466560, shared_blks_written = 72057594037927936, local_blks_hit = 140242911335520, local_blks_read = 94678423921416, local_blks_dirtied = 94678422889184, local_blks_written = 1, temp_blks_read = 1, temp_blks_written = 94678139539142, shared_blk_read_time = {ticks = 140242911335520}, shared_blk_write_time = {ticks = 94678139539161}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94678139923014}, temp_blk_read_time = {ticks = 94678422704480}, temp_blk_write_time = {ticks = 64}} [01:35:09.711] mem_counters = {nblocks = 94678423067528, freechunks = 8589934593, totalspace = 140726959555728, freespace = 10} [01:35:09.711] planner_ctx = 0x0 [01:35:09.711] saved_ctx = 0x0 [01:35:09.711] #21 0x0000561bf8652ec5 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x561c09d40198, pstate=pstate@entry=0x561c09c0d418, params=params@entry=0x0) at ../src/backend/commands/explain.c:309 [01:35:09.711] No locals. [01:35:09.711] #22 0x0000561bf865316d in ExplainQuery (pstate=pstate@entry=0x561c09c0d418, stmt=stmt@entry=0x561c09c3a120, params=params@entry=0x0, dest=dest@entry=0x561c09c0d388) at ../src/backend/commands/explain.c:223 [01:35:09.711] l__state = [01:35:09.711] l = 0x561c09c65bf0 [01:35:09.711] es = 0x561c09d40198 [01:35:09.711] tstate = [01:35:09.711] jstate = [01:35:09.711] query = [01:35:09.711] rewritten = 0x561c09c65bd8 [01:35:09.711] #23 0x0000561bf8b88f4d in standard_ProcessUtility (pstmt=0x561c09c3a1d0, queryString=0x561c09c38710 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x561c09c0d388, qc=0x7ffd8c6f4700) at ../src/backend/tcop/utility.c:866 [01:35:09.711] parsetree = 0x561c09c3a120 [01:35:09.711] isTopLevel = true [01:35:09.711] isAtomicContext = false [01:35:09.711] pstate = 0x561c09c0d418 [01:35:09.711] readonly_flags = [01:35:09.711] __func__ = "standard_ProcessUtility" [01:35:09.711] #24 0x0000561bf8b895e8 in ProcessUtility (pstmt=pstmt@entry=0x561c09c3a1d0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x561c09c0d388, qc=0x7ffd8c6f4700) at ../src/backend/tcop/utility.c:523 [01:35:09.711] No locals. [01:35:09.711] #25 0x0000561bf8b8503a in PortalRunUtility (portal=portal@entry=0x561c09cbdc20, pstmt=0x561c09c3a1d0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x561c09c0d388, qc=qc@entry=0x7ffd8c6f4700) at ../src/backend/tcop/pquery.c:1153 [01:35:09.711] No locals. [01:35:09.711] #26 0x0000561bf8b85895 in FillPortalStore (portal=portal@entry=0x561c09cbdc20, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [01:35:09.711] treceiver = 0x561c09c0d388 [01:35:09.711] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:35:09.711] __func__ = "FillPortalStore" [01:35:09.711] #27 0x0000561bf8b85db0 in PortalRun (portal=portal@entry=0x561c09cbdc20, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x561c09d42f98, altdest=altdest@entry=0x561c09d42f98, qc=qc@entry=0x7ffd8c6f48c0) at ../src/backend/tcop/pquery.c:760 [01:35:09.711] _save_exception_stack = 0x7ffd8c6f4970 [01:35:09.711] _save_context_stack = 0x0 [01:35:09.711] _local_sigjmp_buf = {{__jmpbuf = {0, 5704647890079400860, 94678423428128, 94678422888856, 94678422888832, 94678422888784, 2083460729839371164, 5702992888491885468}, __mask_was_saved = 0, __saved_mask = {__val = {94678139927431, 2356103247, 4, 94678422888784, 112, 153, 94678423428128, 94678422888856, 94678422888832, 94678422888784, 94678140015231, 1, 2, 153, 94678129028677, 0}}}} [01:35:09.711] _do_rethrow = [01:35:09.711] result = [01:35:09.711] nprocessed = [01:35:09.711] saveTopTransactionResourceOwner = 0x561c09c7b9e8 [01:35:09.711] saveTopTransactionContext = 0x561c09cd24c0 [01:35:09.711] saveActivePortal = 0x0 [01:35:09.711] saveResourceOwner = 0x561c09c7b9e8 [01:35:09.711] savePortalContext = 0x0 [01:35:09.711] saveMemoryContext = 0x561c09cd24c0 [01:35:09.711] __func__ = "PortalRun" [01:35:09.711] #28 0x0000561bf8b7eae8 in exec_simple_query (query_string=query_string@entry=0x561c09c38710 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"...) at ../src/backend/tcop/postgres.c:1274 [01:35:09.711] cmdtaglen = 7 [01:35:09.711] snapshot_set = [01:35:09.711] per_parsetree_context = 0x0 [01:35:09.711] plantree_list = 0x561c09d42f48 [01:35:09.711] parsetree = 0x561c09c3a150 [01:35:09.711] commandTag = [01:35:09.711] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [01:35:09.711] querytree_list = [01:35:09.711] portal = 0x561c09cbdc20 [01:35:09.711] receiver = 0x561c09d42f98 [01:35:09.711] format = 0 [01:35:09.711] cmdtagname = [01:35:09.711] parsetree_item__state = [01:35:09.711] dest = DestRemote [01:35:09.711] oldcontext = 0x561c09cd24c0 [01:35:09.711] parsetree_list = 0x561c09c3a180 [01:35:09.711] parsetree_item = 0x561c09c3a198 [01:35:09.711] save_log_statement_stats = false [01:35:09.711] was_logged = false [01:35:09.711] use_implicit_block = false [01:35:09.711] msec_str = "\240\366~\371\033V\000\000S\022\344\370\033V\000\000PIo\214\375\177\000\000\316\000\000\000\000\000\000" [01:35:09.711] __func__ = "exec_simple_query" [01:35:09.711] #29 0x0000561bf8b81d31 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4767 [01:35:09.711] query_string = 0x561c09c38710 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"... [01:35:09.711] firstchar = [01:35:09.711] input_message = {data = 0x561c09c38710 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., len = 206, maxlen = 1024, cursor = 206} [01:35:09.711] local_sigjmp_buf = {{__jmpbuf = {94678153013464, 5702995268491625372, 4, 94678149953184, 24, 14, 2083460730309133212, 5702992886065218460}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94678422612176, 17408, 94678153007488, 94678423146896, 24, 94678139926979, 0, 10, 2, 94678153013472, 94678422612176, 94678153007488, 94678149953184, 24, 14}}}} [01:35:09.711] send_ready_for_query = false [01:35:09.711] idle_in_transaction_timeout_enabled = false [01:35:09.711] idle_session_timeout_enabled = false [01:35:09.711] __func__ = "PostgresMain" [01:35:09.711] #30 0x0000561bf8b7763b in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [01:35:09.711] bsdata = [01:35:09.711] #31 0x0000561bf8a13864 in postmaster_child_launch (child_type=B_BACKEND, child_slot=14, startup_data=startup_data@entry=0x7ffd8c6f4ad0, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x7ffd8c6f4b40) at ../src/backend/postmaster/launch_backend.c:290 [01:35:09.711] pid = [01:35:09.711] #32 0x0000561bf8a18e28 in BackendStartup (client_sock=client_sock@entry=0x7ffd8c6f4b40) at ../src/backend/postmaster/postmaster.c:3587 [01:35:09.711] bn = 0x561c09c60ef8 [01:35:09.711] pid = [01:35:09.711] startup_data = {canAcceptConnections = CAC_OK, socket_created = 808536480772273, fork_started = 808536480772277} [01:35:09.711] cac = [01:35:09.711] __func__ = "BackendStartup" [01:35:09.711] #33 0x0000561bf8a1b354 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [01:35:09.711] s = {sock = 151, raddr = {addr = {ss_family = 1, __ss_padding = "\264\367\033V\000\000\030\r\260\367\033V\000\000\200Lo\214\375\177\000\000xLo\214\375\177\000\000\225[\362\001\000\000\000\000p\352\001\343\214\177\000\000-", '\000' , "\240Ko\214\375\177\000\000\000\004\000\000\000\000\000\000\270Lo\214\375\177\000\000\000_, __ss_align = 67}, salen = 2}} [01:35:09.711] i = 0 [01:35:09.711] now = [01:35:09.711] last_lockfile_recheck_time = 1755221273 [01:35:09.711] last_touch_time = 1755221213 [01:35:09.711] events = {{pos = 1, events = 2, fd = 149, user_data = 0x0}, {pos = 0, events = 0, fd = 149, user_data = 0x0}, {pos = 0, events = 0, fd = -486413296, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x7f8ce690f2e0}, {pos = -1938862984, events = 32765, fd = -1938862976, user_data = 0x7f8ce690f668}, {pos = 0, events = 0, fd = 1, user_data = 0x1}, {pos = 163809232, events = 22044, fd = 1, user_data = 0x561c09c387d0}, {pos = -1, events = 0, fd = -452796384, user_data = 0x7f8ce5f72a10}, {pos = 163816448, events = 22044, fd = -452006491, user_data = 0x7ffd8c6f51d3}, {pos = 150, events = 0, fd = -1938862912, user_data = 0x7f8ce690f2e0}, {pos = 436, events = 0, fd = -113349216, user_data = 0x0}, {pos = 0, events = 0, fd = 249, user_data = 0x7f8ce68eaebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f8ce502e020}, {pos = -451989888, events = 32652, fd = 514012664, user_data = 0x7ffd8c6f50f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -426847558, events = 32652, fd = 0, user_data = 0x7f8ce50aedd4 }, {pos = 0, events = 0, fd = -106163328, user_data = 0x2}, {pos = 0, events = 0, fd = 163526768, user_data = 0x7f8ce50eeedd }, {pos = 163816992, events = 22044, fd = -122629252, user_data = 0x561c09c6b130}, {pos = 8096, events = 196607, fd = 164016523, user_data = 0x561bf8b12074 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x169}, {pos = -113349816, events = 22043, fd = 8, user_data = 0x1}, {pos = 163809232, events = 22044, fd = -426856770, user_data = 0x1}, {pos = -452235107, events = 32652, fd = -452762424, user_data = 0x561c09c6b130}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x342020200a0a7941}, {pos = 822763892, events = 842347831, fd = 825372978, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 164020528, user_data = 0x561bf8e5ea46 }, {pos = 163992336, events = 22044, fd = 1080, user_data = 0x561c09bfb440}, {pos = -119147834, events = 22043, fd = 1024, user_data = 0x7f8ce50b58ee}, {pos = -450962976, events = 32652, fd = -452325010, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1938861624, events = 32765, fd = -452231345, user_data = 0x561c09bfb440}, {pos = 3, events = 0, fd = 0, user_data = 0x5829}, {pos = -336, events = 4294967295, fd = 0, user_data = 0x11a}, {pos = -451989357, events = 32652, fd = 163558464, user_data = 0x1}, {pos = 163558664, events = 22044, fd = 1024, user_data = 0x7ffd8c6f51c8}, {pos = -119066665, events = 22043, fd = -106059632, user_data = 0x561bf8e61a77 }, {pos = 163558464, events = 22044, fd = 163808784, user_data = 0x561c09bfb440}, {pos = -452241170, events = 32652, fd = 0, user_data = 0x561bf8e738a5 }, {pos = 163558464, events = 1, fd = -119064082, user_data = 0x561c09c38610}, {pos = -452318543, events = 32652, fd = -452324112, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 792485632, events = 2001304443, fd = 163526768, user_data = 0x77497b7b2f3c5f00}, {pos = 13, events = 0, fd = 792485632, user_data = 0x0}, {pos = -452611527, events = 32652, fd = 0, user_data = 0x561bf8a1354a }, {pos = 4194304, events = 0, fd = 163642480, user_data = 0x1}, {pos = 0, events = 0, fd = 163526768, user_data = 0x561bf8e6190b }, {pos = 163642480, events = 22044, fd = 163808784, user_data = 0x561c09c0fc70}, {pos = 1, events = 0, fd = 0, user_data = 0x561bf8e1f8de }, {pos = 13, events = 0, fd = 163987800, user_data = 0x561c09c64138}, {pos = -106161896, events = 22043, fd = 13, user_data = 0x0}, {pos = 0, events = 0, fd = -123652348, user_data = 0x561c09c38610}, {pos = -123635440, events = 22043, fd = -109861072, user_data = 0x561c09c38fe8}} [01:35:09.711] nevents = 1 [01:35:09.711] __func__ = "ServerLoop" [01:35:09.711] #34 0x0000561bf8a1cbb8 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x561c09bf6830) at ../src/backend/postmaster/postmaster.c:1400 [01:35:09.711] opt = [01:35:09.711] status = [01:35:09.711] userDoption = [01:35:09.711] listen_addr_saved = false [01:35:09.711] output_config_variable = [01:35:09.711] __func__ = "PostmasterMain" [01:35:09.711] #35 0x0000561bf8846a9f in main (argc=8, argv=0x561c09bf6830) at ../src/backend/main/main.c:231 [01:35:09.711] do_check_root = [01:35:09.711] dispatch_option = [01:35:09.749] -e [01:35:09.749] [01:35:09.749] [01:35:09.806] dumping /tmp/cores/sh-3-49702.core for /bin/sh [01:35:09.852] [01:35:09.852] This GDB supports auto-downloading debuginfo from the following URLs: [01:35:09.852] [01:35:09.852] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [01:35:09.852] Debuginfod has been disabled. [01:35:09.852] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [01:35:09.856] [New LWP 49702] [01:35:09.857] [New LWP 49697] [01:35:09.857] [Thread debugging using libthread_db enabled] [01:35:09.857] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [01:35:09.857] Core was generated by `sh -c cp "pg_wal/000000010000000000000003.00000028.backup" "/tmp/cirrus-ci-buil'. [01:35:09.857] Program terminated with signal SIGQUIT, Quit. [01:35:09.857] #0 0x00007f32b333add4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:09.858] [Current thread is 1 (LWP 49702)] [01:35:09.858] [01:35:09.858] Thread 2 (Thread 0x7f32b32a8740 (LWP 49697)): [01:35:09.858] warning: Couldn't find general-purpose registers in core file. [01:35:09.858] #0 in ?? () [01:35:09.858] PC unavailable, cannot determine locals. [01:35:09.858] Backtrace stopped: not enough registers or memory available to unwind further [01:35:09.858] [01:35:09.858] Thread 1 (LWP 49702): [01:35:09.858] #0 0x00007f32b333add4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:09.858] No symbol table info available. [01:35:09.858] #1 0x00007f32b32e7239 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:09.858] No symbol table info available. [01:35:09.858] #2 0x00007f32b32e7497 in sigsetmask () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:09.858] No symbol table info available. [01:35:09.858] #3 0x0000560339dbc5f3 in ?? () [01:35:09.858] No symbol table info available. [01:35:09.858] #4 0x0000560339db6369 in ?? () [01:35:09.858] No symbol table info available. [01:35:09.858] #5 0x0000560339db520f in ?? () [01:35:09.858] No symbol table info available. [01:35:09.858] #6 0x0000560339db5c3b in ?? () [01:35:09.858] No symbol table info available. [01:35:09.858] #7 0x0000560339db366f in ?? () [01:35:09.858] No symbol table info available. [01:35:09.858] #8 0x00007f32b32d224a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:09.858] No symbol table info available. [01:35:09.858] #9 0x00007f32b32d2305 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6 [01:35:09.858] No symbol table info available. [01:35:09.858] #10 0x0000560339db3781 in ?? () [01:35:09.858] No symbol table info available.