[18:34:00.930] src/tools/ci/cores_backtrace.sh linux /tmp/cores [18:34:01.158] dumping /tmp/cores/postgres-6-22943.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [18:34:01.409] [New LWP 22943] [18:34:01.409] [18:34:01.409] This GDB supports auto-downloading debuginfo from the following URLs: [18:34:01.409] [18:34:01.409] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [18:34:01.409] Debuginfod has been disabled. [18:34:01.409] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [18:34:01.664] [Thread debugging using libthread_db enabled] [18:34:01.664] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:34:01.664] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN '. [18:34:01.664] Program terminated with signal SIGABRT, Aborted. [18:34:01.664] #0 0x00007fefb04a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:02.834] [18:34:02.834] Thread 1 (Thread 0x7fefae031f00 (LWP 22943)): [18:34:02.834] #0 0x00007fefb04a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:02.834] No symbol table info available. [18:34:02.834] #1 0x00007fefb045afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:02.834] No symbol table info available. [18:34:02.834] #2 0x00007fefb0445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:02.834] No symbol table info available. [18:34:02.834] #3 0x00007fefb061e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [18:34:02.834] No locals. [18:34:02.834] #4 0x00007fefb062aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [18:34:02.834] No locals. [18:34:02.834] #5 0x00007fefb060dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55a333d4c8a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [18:34:02.834] bp = 140722134223840 [18:34:02.834] pc = [18:34:02.834] Opts = {FromUnrecoverableHandler = true, pc = 94159423681300, bp = 94159459367240} [18:34:02.834] #6 0x000055a333003314 in examine_self_contradictory_rels (root=root@entry=0x55a3351daa78, rel=rel@entry=0x55a3352ca908, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [18:34:02.834] lc__state = [18:34:02.834] rlist = [18:34:02.834] i = 2 [18:34:02.834] br = [18:34:02.834] expression = [18:34:02.834] or_rinfo = 0x55a33520c698 [18:34:02.834] ccxt = [18:34:02.834] delidx = 0x55a33520c531 [18:34:02.834] arglst = [18:34:02.834] lc = [18:34:02.834] arg = [18:34:02.834] n = [18:34:02.834] restrictinfo = [18:34:02.834] ccwapper = {clausecxt = 0x55a33520bec8} [18:34:02.834] sec = {sopcinfo = {n_members = 38, opcies = 0x55a33520b998}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x55a33520eef8, atop_set = 0x55a33520bda8}, ccfree = 0x55a33520c500, vifree = 0x55a33520c038} [18:34:02.834] __func__ = "examine_self_contradictory_rels" [18:34:02.834] #7 0x000055a333003523 in examine_self_contradictory_rels_phase1 (root=root@entry=0x55a3351daa78) at ../src/backend/optimizer/plan/contradictory.c:2608 [18:34:02.834] rel = 0x55a3352ca908 [18:34:02.834] rti = 1 [18:34:02.834] rinfo = [18:34:02.834] #8 0x000055a332fce4c6 in query_planner (root=root@entry=0x55a3351daa78, qp_callback=qp_callback@entry=0x55a332fd37e3 , qp_extra=qp_extra@entry=0x7ffc6cd28de0) at ../src/backend/optimizer/plan/planmain.c:193 [18:34:02.834] parse = 0x55a334faad18 [18:34:02.834] joinlist = 0x55a33520ef68 [18:34:02.834] final_rel = [18:34:02.834] __func__ = "query_planner" [18:34:02.834] #9 0x000055a332fe0f58 in grouping_planner (root=root@entry=0x55a3351daa78, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [18:34:02.834] sort_input_targets = 0x5 [18:34:02.834] sort_input_target_parallel_safe = [18:34:02.834] grouping_target = [18:34:02.834] scanjoin_target = [18:34:02.834] activeWindows = 0x0 [18:34:02.834] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [18:34:02.834] sort_input_targets_contain_srfs = 0x1 [18:34:02.834] have_grouping = [18:34:02.834] wflists = 0x0 [18:34:02.834] gset_data = 0x0 [18:34:02.834] sort_input_target = [18:34:02.834] grouping_targets = 0x1 [18:34:02.834] grouping_target_parallel_safe = [18:34:02.834] scanjoin_targets = 0x0 [18:34:02.834] scanjoin_target_parallel_safe = [18:34:02.834] grouping_targets_contain_srfs = 0x1 [18:34:02.834] scanjoin_targets_contain_srfs = 0x55a333547ef6 [18:34:02.834] scanjoin_target_same_exprs = [18:34:02.834] parse = 0x55a334faad18 [18:34:02.834] offset_est = 0 [18:34:02.834] count_est = 0 [18:34:02.834] limit_tuples = -1 [18:34:02.834] have_postponed_srfs = false [18:34:02.834] final_target = [18:34:02.834] final_targets = 0x55a3350abac8 [18:34:02.834] final_targets_contain_srfs = 0x55a332f3f1a8 [18:34:02.834] final_target_parallel_safe = [18:34:02.834] current_rel = [18:34:02.834] final_rel = [18:34:02.834] extra = {limit_needed = false, limit_tuples = 4.6520936064664865e-310, count_est = 94159459379656, offset_est = 94159459379656} [18:34:02.834] lc = [18:34:02.834] __func__ = "grouping_planner" [18:34:02.834] #10 0x000055a332fe3edc in subquery_planner (glob=glob@entry=0x55a3352ca7f8, parse=parse@entry=0x55a334faad18, 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:1151 [18:34:02.834] root = 0x55a3351daa78 [18:34:02.834] newWithCheckOptions = [18:34:02.834] newHaving = 0x0 [18:34:02.834] hasOuterJoins = [18:34:02.834] hasResultRTEs = false [18:34:02.834] final_rel = [18:34:02.834] l = 0x0 [18:34:02.834] #11 0x000055a332fe4b6d in standard_planner (parse=0x55a334faad18, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [18:34:02.834] result = [18:34:02.834] glob = 0x55a3352ca7f8 [18:34:02.834] tuple_fraction = 0 [18:34:02.834] root = [18:34:02.834] final_rel = [18:34:02.834] best_path = [18:34:02.834] top_plan = [18:34:02.834] lp = [18:34:02.834] lr = [18:34:02.834] #12 0x000055a332fe5bd7 in planner (parse=parse@entry=0x55a334faad18, query_string=query_string@entry=0x55a334fa9a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [18:34:02.834] result = [18:34:02.834] #13 0x000055a333255464 in pg_plan_query (querytree=querytree@entry=0x55a334faad18, query_string=query_string@entry=0x55a334fa9a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [18:34:02.834] plan = [18:34:02.834] #14 0x000055a332d585a6 in standard_ExplainOneQuery (query=0x55a334faad18, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55a334fd5068, queryString=0x55a334fa9a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [18:34:02.834] plan = [18:34:02.834] planstart = [18:34:02.834] planduration = {ticks = 94159422855884} [18:34:02.834] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94159429118956, shared_blks_dirtied = 1825738958, shared_blks_written = 3, local_blks_hit = 4294967299, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94159456873752, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94159429205750}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94159422853265}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94159456873752}} [18:34:02.834] bufusage = {shared_blks_hit = 0, shared_blks_read = 94159425879468, shared_blks_dirtied = 73057393721347, shared_blks_written = 72057594037927936, local_blks_hit = 140667239678480, local_blks_read = 94159456874928, local_blks_dirtied = 94159456873752, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94159428733708, shared_blk_read_time = {ticks = 140667239678480}, shared_blk_write_time = {ticks = 94159428733727}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94159429114539}, temp_blk_read_time = {ticks = 94159457045792}, temp_blk_write_time = {ticks = 64}} [18:34:02.834] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140722134224976, freespace = 10} [18:34:02.834] planner_ctx = 0x0 [18:34:02.834] saved_ctx = 0x0 [18:34:02.834] #15 0x000055a332d5888c in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55a334fd5068, pstate=pstate@entry=0x55a334fd4f58, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [18:34:02.834] No locals. [18:34:02.834] #16 0x000055a332d597e3 in ExplainQuery (pstate=pstate@entry=0x55a334fd4f58, stmt=stmt@entry=0x55a334faab58, params=params@entry=0x0, dest=dest@entry=0x55a334fd4ec8) at ../src/backend/commands/explain.c:357 [18:34:02.834] l__state = [18:34:02.834] l = 0x55a3352ca7c0 [18:34:02.834] es = 0x55a334fd5068 [18:34:02.834] tstate = [18:34:02.834] jstate = [18:34:02.834] query = [18:34:02.834] rewritten = 0x55a3352ca7a8 [18:34:02.834] lc = 0x0 [18:34:02.834] timing_set = false [18:34:02.834] buffers_set = false [18:34:02.834] summary_set = false [18:34:02.834] __func__ = "ExplainQuery" [18:34:02.834] #17 0x000055a33325fe84 in standard_ProcessUtility (pstmt=0x55a334faac08, queryString=0x55a334fa9a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55a334fd4ec8, qc=0x7ffc6cd292d0) at ../src/backend/tcop/utility.c:866 [18:34:02.834] parsetree = 0x55a334faab58 [18:34:02.834] isTopLevel = true [18:34:02.834] isAtomicContext = false [18:34:02.834] pstate = 0x55a334fd4f58 [18:34:02.834] readonly_flags = [18:34:02.834] __func__ = "standard_ProcessUtility" [18:34:02.834] #18 0x000055a3332605ad in ProcessUtility (pstmt=pstmt@entry=0x55a334faac08, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55a334fd4ec8, qc=0x7ffc6cd292d0) at ../src/backend/tcop/utility.c:523 [18:34:02.834] No locals. [18:34:02.834] #19 0x000055a33325bf6b in PortalRunUtility (portal=portal@entry=0x55a33502b7e0, pstmt=0x55a334faac08, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55a334fd4ec8, qc=qc@entry=0x7ffc6cd292d0) at ../src/backend/tcop/pquery.c:1152 [18:34:02.834] No locals. [18:34:02.834] #20 0x000055a33325c7de in FillPortalStore (portal=portal@entry=0x55a33502b7e0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [18:34:02.834] treceiver = 0x55a334fd4ec8 [18:34:02.834] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:34:02.834] __func__ = "FillPortalStore" [18:34:02.834] #21 0x000055a33325ccf9 in PortalRun (portal=portal@entry=0x55a33502b7e0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55a3350abed8, altdest=altdest@entry=0x55a3350abed8, qc=qc@entry=0x7ffc6cd29490) at ../src/backend/tcop/pquery.c:759 [18:34:02.834] _save_exception_stack = 0x7ffc6cd29540 [18:34:02.834] _save_context_stack = 0x0 [18:34:02.834] _local_sigjmp_buf = {{__jmpbuf = {0, -5690790740359137354, 94159457400800, 94159456873424, 94159456873400, 94159456873352, -1893609396563363914, -5690804282838763594}, __mask_was_saved = 0, __saved_mask = {__val = {94159429118956, 1825739807, 4, 94159456873352, 112, 153, 94159457400800, 94159456873424, 94159456873400, 94159456873352, 94159429206159, 1, 2, 153, 94159418473553, 0}}}} [18:34:02.834] _do_rethrow = [18:34:02.834] result = [18:34:02.834] nprocessed = [18:34:02.834] saveTopTransactionResourceOwner = 0x55a334fe8998 [18:34:02.834] saveTopTransactionContext = 0x55a33503fc50 [18:34:02.834] saveActivePortal = 0x0 [18:34:02.834] saveResourceOwner = 0x55a334fe8998 [18:34:02.834] savePortalContext = 0x0 [18:34:02.834] saveMemoryContext = 0x55a33503fc50 [18:34:02.834] __func__ = "PortalRun" [18:34:02.834] #22 0x000055a333255f30 in exec_simple_query (query_string=query_string@entry=0x55a334fa9a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1271 [18:34:02.834] cmdtaglen = 7 [18:34:02.834] snapshot_set = [18:34:02.834] per_parsetree_context = 0x0 [18:34:02.834] plantree_list = 0x55a3350abe88 [18:34:02.834] parsetree = 0x55a334faab88 [18:34:02.834] commandTag = [18:34:02.834] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:34:02.834] querytree_list = [18:34:02.834] portal = 0x55a33502b7e0 [18:34:02.834] receiver = 0x55a3350abed8 [18:34:02.834] format = 0 [18:34:02.834] cmdtagname = [18:34:02.834] parsetree_item__state = [18:34:02.834] dest = DestRemote [18:34:02.834] oldcontext = 0x55a33503fc50 [18:34:02.834] parsetree_list = 0x55a334faabb8 [18:34:02.834] parsetree_item = 0x55a334faabd0 [18:34:02.834] save_log_statement_stats = false [18:34:02.834] was_logged = true [18:34:02.834] use_implicit_block = false [18:34:02.834] msec_str = "\004\000\000\000\000\000\000\0009FQ3\243U\000\000 \225\322l\374\177\000\000n\000\000\000\000\000\000" [18:34:02.834] __func__ = "exec_simple_query" [18:34:02.834] #23 0x000055a333258c89 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [18:34:02.834] query_string = 0x55a334fa9a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [18:34:02.834] firstchar = [18:34:02.834] input_message = {data = 0x55a334fa9a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", len = 110, maxlen = 1024, cursor = 110} [18:34:02.834] local_sigjmp_buf = {{__jmpbuf = {94159441807832, -5690793158862981194, 140722134226588, 4, 16, 140722134226820, -1893609396764690506, -5690804284894365770}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94159456599536, 14336, 94159441801888, 94159457122640, 16, 94159429118504, 0, 9, 2, 94159441807840, 94159456599536, 94159441801888, 4, 16, 140722134226820}}}} [18:34:02.834] send_ready_for_query = false [18:34:02.834] idle_in_transaction_timeout_enabled = false [18:34:02.834] idle_session_timeout_enabled = false [18:34:02.834] __func__ = "PostgresMain" [18:34:02.834] #24 0x000055a33324ecf4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:34:02.834] bsdata = [18:34:02.834] #25 0x000055a3331003e0 in postmaster_child_launch (child_type=B_BACKEND, child_slot=16, startup_data=startup_data@entry=0x7ffc6cd2969c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc6cd296f0) at ../src/backend/postmaster/launch_backend.c:274 [18:34:02.834] pid = [18:34:02.834] #26 0x000055a3331053db in BackendStartup (client_sock=client_sock@entry=0x7ffc6cd296f0) at ../src/backend/postmaster/postmaster.c:3386 [18:34:02.834] bn = 0x55a334fd1588 [18:34:02.834] pid = [18:34:02.834] startup_data = {canAcceptConnections = CAC_OK} [18:34:02.834] cac = [18:34:02.834] __func__ = "BackendStartup" [18:34:02.834] #27 0x000055a3331072b4 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [18:34:02.834] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\272\024)2\243U\000\000\220\367$2\243U\000\000@\230\322l\374\177\000\0008\230\322l\374\177\000\000\225[\362\001\000\000\000\000\240\344ð\357\177\000\000+", '\000' , "\374\177\000\000\000\004\000\000\000\000\000\000h\326ױ\357\177\000\0000\346ð\357\177\000\000\340\322ױ\357\177\000\000\316)fR\000\000\000", __ss_align = 1825740928}, salen = 2}} [18:34:02.834] i = 0 [18:34:02.834] now = [18:34:02.834] last_lockfile_recheck_time = 1734546603 [18:34:02.834] last_touch_time = 1734546603 [18:34:02.834] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1329338832, events = 32751, fd = -1311255840, user_data = 0x7c96e577}, {pos = 1825740992, events = 32764, fd = -1311425976, user_data = 0xf}, {pos = -1329338832, events = 32751, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1311255840, user_data = 0x7ffc6cd29838}, {pos = 1825740864, events = 32764, fd = -1311254936, user_data = 0x0}, {pos = 888838792, events = 21923, fd = -1337230710, user_data = 0x55a334fa9a88}, {pos = 1, events = 21923, fd = 32768, user_data = 0xffffffff}, {pos = -1337794528, events = 32751, fd = -1315483744, user_data = 0x55a334fd5048}, {pos = 889016104, events = 21923, fd = 889013489, user_data = 0x7fefb1d59ebe}, {pos = 1, events = 0, fd = -1311255840, user_data = 0x1aa}, {pos = 866729296, events = 21923, fd = 0, user_data = 0xd8}, {pos = 888838792, events = 21923, fd = -1311400258, user_data = 0x1}, {pos = 0, events = 0, fd = -1337794528, user_data = 0x7fefb04f2e40 }, {pos = 16, events = 0, fd = 1825742000, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fefb1d5c1ba}, {pos = 0, events = 0, fd = -1337266780, user_data = 0x0}, {pos = 873713024, events = 21923, fd = 2, user_data = 0x0}, {pos = 888585872, events = 21923, fd = 857635785, user_data = 0x55a334fdc7f0}, {pos = 857639774, events = 21923, fd = 889047115, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -1337760568, user_data = 0x7fefb049c880 }, {pos = -1375527496, events = 32751, fd = 1825742192, user_data = 0x100007f00000002}, {pos = -1337233657, events = 32751, fd = 2, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -1335944096, events = 32751, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x0}, {pos = 0, events = 21760, 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 = 889020304, events = 21923, fd = -1337230710, user_data = 0xa}, {pos = 861084331, events = 21923, fd = 889028528, user_data = 0x7fefb04b58be}, {pos = -1335961120, events = 32751, fd = -1337323154, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x5024c6fd2d3acf00}, {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 = 0x55a334fd4d20}, {pos = 1, events = 0, fd = 889015784, user_data = 0x3}, {pos = 0, events = 0, fd = 21720, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 888838792, user_data = 0x7fefb04f3053 }, {pos = 889015784, events = 21923, fd = 1024, user_data = 0x7ffc6cd29d78}, {pos = 861167647, events = 21923, fd = 873777552, user_data = 0x55a333534adc }, {pos = 889015584, events = 21923, fd = 888838512, user_data = 0x55a334fd4d20}, {pos = -1337239701, events = 32751, fd = 0, user_data = 0x55a333546746 }, {pos = 889015584, events = 1, fd = 861169807, user_data = 0x55a334fa9970}, {pos = 758828800, events = 1344587517, fd = 0, user_data = 0x7fefb04a2ab1}, {pos = -1337322256, events = 32751, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 888585872, user_data = 0x5024c6fd2d3acf00}, {pos = 0, events = 0, fd = 758828800, user_data = 0xc}, {pos = 758828800, events = 1344587517, fd = 0, user_data = 0x7fefb045b239 }, {pos = 217, events = 0, fd = 856686813, user_data = 0x400000}, {pos = 0, events = 0, fd = 888585872, user_data = 0x55a333534970 }, {pos = 888672416, events = 21923, fd = 888838512, user_data = 0x55a334f810a0}, {pos = 1, events = 0, fd = 0, user_data = 0x55a3334f3131 }, {pos = 12, events = 0, fd = 889011032, user_data = 0x55a334fd3b38}, {pos = 873714432, events = 21923, fd = 296, user_data = 0x55a3331028f7 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 856703284, events = 21923, fd = 870135728, user_data = 0x55a334faa318}} [18:34:02.835] nevents = 1 [18:34:02.835] __func__ = "ServerLoop" [18:34:02.835] #28 0x000055a333108b35 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55a334f67d00) at ../src/backend/postmaster/postmaster.c:1371 [18:34:02.835] opt = [18:34:02.835] status = [18:34:02.835] userDoption = [18:34:02.835] listen_addr_saved = false [18:34:02.835] output_config_variable = [18:34:02.835] __func__ = "PostmasterMain" [18:34:02.835] #29 0x000055a332f35214 in main (argc=4, argv=0x55a334f67d00) at ../src/backend/main/main.c:230 [18:34:02.835] do_check_root = [18:34:02.835] dispatch_option = [18:34:02.873] -e [18:34:02.873] [18:34:02.873] [18:34:02.935] dumping /tmp/cores/postgres-6-23453.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:34:03.179] [New LWP 23453] [18:34:03.179] [18:34:03.179] This GDB supports auto-downloading debuginfo from the following URLs: [18:34:03.179] [18:34:03.179] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [18:34:03.179] Debuginfod has been disabled. [18:34:03.179] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [18:34:03.280] [Thread debugging using libthread_db enabled] [18:34:03.280] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:34:03.280] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [18:34:03.280] Program terminated with signal SIGABRT, Aborted. [18:34:03.280] #0 0x00007fb2d2aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:04.270] [18:34:04.270] Thread 1 (Thread 0x7fb2d29dbf00 (LWP 23453)): [18:34:04.270] #0 0x00007fb2d2aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:04.270] No symbol table info available. [18:34:04.270] #1 0x00007fb2d2a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:04.270] No symbol table info available. [18:34:04.270] #2 0x00007fb2d2a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:04.270] No symbol table info available. [18:34:04.270] #3 0x00007fb2d2c1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [18:34:04.270] No locals. [18:34:04.270] #4 0x00007fb2d2c2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [18:34:04.270] No locals. [18:34:04.270] #5 0x00007fb2d2c0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55560c18c8a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [18:34:04.270] bp = 140721710202240 [18:34:04.270] pc = [18:34:04.270] Opts = {FromUnrecoverableHandler = true, pc = 93828044567316, bp = 93828065386768} [18:34:04.270] #6 0x000055560b443314 in examine_self_contradictory_rels (root=root@entry=0x55560c876e28, rel=rel@entry=0x55560c7fa328, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [18:34:04.270] lc__state = [18:34:04.270] rlist = [18:34:04.270] i = 2 [18:34:04.270] br = [18:34:04.270] expression = [18:34:04.270] or_rinfo = 0x55560c81f2e8 [18:34:04.270] ccxt = [18:34:04.270] delidx = 0x55560c81efe1 [18:34:04.270] arglst = [18:34:04.270] lc = [18:34:04.270] arg = [18:34:04.270] n = [18:34:04.270] restrictinfo = [18:34:04.270] ccwapper = {clausecxt = 0x55560c81e958} [18:34:04.270] sec = {sopcinfo = {n_members = 38, opcies = 0x55560c81e428}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x55560c81ddc0, atop_set = 0x55560c81e838}, ccfree = 0x55560c81ef60, vifree = 0x55560c81e9f8} [18:34:04.270] __func__ = "examine_self_contradictory_rels" [18:34:04.270] #7 0x000055560b443523 in examine_self_contradictory_rels_phase1 (root=root@entry=0x55560c876e28) at ../src/backend/optimizer/plan/contradictory.c:2608 [18:34:04.270] rel = 0x55560c7fa328 [18:34:04.270] rti = 1 [18:34:04.270] rinfo = [18:34:04.270] #8 0x000055560b40e4c6 in query_planner (root=root@entry=0x55560c876e28, qp_callback=qp_callback@entry=0x55560b4137e3 , qp_extra=qp_extra@entry=0x7ffc538c7f80) at ../src/backend/optimizer/plan/planmain.c:193 [18:34:04.270] parse = 0x55560c627f70 [18:34:04.270] joinlist = 0x55560c81de30 [18:34:04.270] final_rel = [18:34:04.270] __func__ = "query_planner" [18:34:04.270] #9 0x000055560b420f58 in grouping_planner (root=root@entry=0x55560c876e28, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [18:34:04.270] sort_input_targets = 0x5 [18:34:04.270] sort_input_target_parallel_safe = [18:34:04.270] grouping_target = [18:34:04.270] scanjoin_target = [18:34:04.270] activeWindows = 0x0 [18:34:04.270] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [18:34:04.270] sort_input_targets_contain_srfs = 0x1 [18:34:04.270] have_grouping = [18:34:04.270] wflists = 0x0 [18:34:04.270] gset_data = 0x0 [18:34:04.270] sort_input_target = [18:34:04.270] grouping_targets = 0x1 [18:34:04.270] grouping_target_parallel_safe = [18:34:04.270] scanjoin_targets = 0x0 [18:34:04.270] scanjoin_target_parallel_safe = [18:34:04.270] grouping_targets_contain_srfs = 0x1 [18:34:04.270] scanjoin_targets_contain_srfs = 0x55560b987ef6 [18:34:04.270] scanjoin_target_same_exprs = [18:34:04.270] parse = 0x55560c627f70 [18:34:04.270] offset_est = 0 [18:34:04.270] count_est = 0 [18:34:04.270] limit_tuples = -1 [18:34:04.270] have_postponed_srfs = false [18:34:04.270] final_target = [18:34:04.270] final_targets = 0x55560c783a58 [18:34:04.270] final_targets_contain_srfs = 0x55560b37f1a8 [18:34:04.270] final_target_parallel_safe = [18:34:04.270] current_rel = [18:34:04.270] final_rel = [18:34:04.270] extra = {limit_needed = false, limit_tuples = 4.635721302869606e-310, count_est = 93828065384184, offset_est = 93828065384184} [18:34:04.270] lc = [18:34:04.270] __func__ = "grouping_planner" [18:34:04.270] #10 0x000055560b423edc in subquery_planner (glob=glob@entry=0x55560c7fa218, parse=parse@entry=0x55560c627f70, 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:1151 [18:34:04.270] root = 0x55560c876e28 [18:34:04.270] newWithCheckOptions = [18:34:04.270] newHaving = 0x0 [18:34:04.270] hasOuterJoins = [18:34:04.270] hasResultRTEs = false [18:34:04.270] final_rel = [18:34:04.270] l = 0x0 [18:34:04.270] #11 0x000055560b424b6d in standard_planner (parse=0x55560c627f70, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [18:34:04.270] result = [18:34:04.270] glob = 0x55560c7fa218 [18:34:04.270] tuple_fraction = 0 [18:34:04.270] root = [18:34:04.270] final_rel = [18:34:04.270] best_path = [18:34:04.270] top_plan = [18:34:04.270] lp = [18:34:04.270] lr = [18:34:04.270] #12 0x000055560b425bd7 in planner (parse=parse@entry=0x55560c627f70, query_string=query_string@entry=0x55560c626af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [18:34:04.270] result = [18:34:04.270] #13 0x000055560b695464 in pg_plan_query (querytree=querytree@entry=0x55560c627f70, query_string=query_string@entry=0x55560c626af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [18:34:04.270] plan = [18:34:04.270] #14 0x000055560b1985a6 in standard_ExplainOneQuery (query=0x55560c627f70, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55560c824f68, queryString=0x55560c626af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [18:34:04.270] plan = [18:34:04.270] planstart = [18:34:04.270] planduration = {ticks = 93828043741900} [18:34:04.270] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 93828050004972, shared_blks_dirtied = 1401717358, shared_blks_written = 3, local_blks_hit = 5696684896, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 93828063330160, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 93828050091766}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93828043739281}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 93828063330160}} [18:34:04.270] bufusage = {shared_blks_hit = 0, shared_blks_read = 93828046765484, shared_blks_dirtied = 131864085938176, shared_blks_written = 72057594037927936, local_blks_hit = 140405818240616, local_blks_read = 93828063331336, local_blks_dirtied = 93828063330160, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 93828049619724, shared_blk_read_time = {ticks = 140405818240616}, shared_blk_write_time = {ticks = 93828049619743}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93828050000555}, temp_blk_read_time = {ticks = 93828065414176}, temp_blk_write_time = {ticks = 64}} [18:34:04.270] mem_counters = {nblocks = 93828065239416, freechunks = 4294967297, totalspace = 140721710203376, freespace = 10} [18:34:04.270] planner_ctx = 0x0 [18:34:04.270] saved_ctx = 0x0 [18:34:04.270] #15 0x000055560b19888c in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55560c824f68, pstate=pstate@entry=0x55560c824e58, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [18:34:04.270] No locals. [18:34:04.270] #16 0x000055560b1997e3 in ExplainQuery (pstate=pstate@entry=0x55560c824e58, stmt=stmt@entry=0x55560c627db0, params=params@entry=0x0, dest=dest@entry=0x55560c824dc8) at ../src/backend/commands/explain.c:357 [18:34:04.270] l__state = [18:34:04.270] l = 0x55560c7fa1e0 [18:34:04.270] es = 0x55560c824f68 [18:34:04.270] tstate = [18:34:04.270] jstate = [18:34:04.270] query = [18:34:04.270] rewritten = 0x55560c7fa1c8 [18:34:04.270] lc = 0x0 [18:34:04.270] timing_set = false [18:34:04.270] buffers_set = false [18:34:04.270] summary_set = false [18:34:04.270] __func__ = "ExplainQuery" [18:34:04.270] #17 0x000055560b69fe84 in standard_ProcessUtility (pstmt=0x55560c627e60, queryString=0x55560c626af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55560c824dc8, qc=0x7ffc538c8470) at ../src/backend/tcop/utility.c:866 [18:34:04.270] parsetree = 0x55560c627db0 [18:34:04.270] isTopLevel = true [18:34:04.270] isAtomicContext = false [18:34:04.270] pstate = 0x55560c824e58 [18:34:04.270] readonly_flags = [18:34:04.270] __func__ = "standard_ProcessUtility" [18:34:04.270] #18 0x000055560b6a05ad in ProcessUtility (pstmt=pstmt@entry=0x55560c627e60, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55560c824dc8, qc=0x7ffc538c8470) at ../src/backend/tcop/utility.c:523 [18:34:04.270] No locals. [18:34:04.270] #19 0x000055560b69bf6b in PortalRunUtility (portal=portal@entry=0x55560c6ab100, pstmt=0x55560c627e60, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55560c824dc8, qc=qc@entry=0x7ffc538c8470) at ../src/backend/tcop/pquery.c:1152 [18:34:04.270] No locals. [18:34:04.270] #20 0x000055560b69c7de in FillPortalStore (portal=portal@entry=0x55560c6ab100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [18:34:04.270] treceiver = 0x55560c824dc8 [18:34:04.270] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:34:04.270] __func__ = "FillPortalStore" [18:34:04.270] #21 0x000055560b69ccf9 in PortalRun (portal=portal@entry=0x55560c6ab100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55560c783d38, altdest=altdest@entry=0x55560c783d38, qc=qc@entry=0x7ffc538c8630) at ../src/backend/tcop/pquery.c:759 [18:34:04.270] _save_exception_stack = 0x7ffc538c86e0 [18:34:04.270] _save_context_stack = 0x0 [18:34:04.270] _local_sigjmp_buf = {{__jmpbuf = {0, -3848730412718457818, 93828063867136, 93828063329832, 93828063329808, 93828063329760, -6934927709527311322, -3848714871797679066}, __mask_was_saved = 0, __saved_mask = {__val = {93828050004972, 1401718207, 4, 93828063329760, 112, 153, 93828063867136, 93828063329832, 93828063329808, 93828063329760, 93828050092175, 1, 2, 153, 93828039359569, 0}}}} [18:34:04.270] _do_rethrow = [18:34:04.270] result = [18:34:04.270] nprocessed = [18:34:04.270] saveTopTransactionResourceOwner = 0x55560c666708 [18:34:04.270] saveTopTransactionContext = 0x55560c6bd530 [18:34:04.270] saveActivePortal = 0x0 [18:34:04.270] saveResourceOwner = 0x55560c666708 [18:34:04.270] savePortalContext = 0x0 [18:34:04.270] saveMemoryContext = 0x55560c6bd530 [18:34:04.270] __func__ = "PortalRun" [18:34:04.270] #22 0x000055560b695f30 in exec_simple_query (query_string=query_string@entry=0x55560c626af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');") at ../src/backend/tcop/postgres.c:1271 [18:34:04.270] cmdtaglen = 7 [18:34:04.270] snapshot_set = [18:34:04.270] per_parsetree_context = 0x0 [18:34:04.270] plantree_list = 0x55560c783ce8 [18:34:04.270] parsetree = 0x55560c627de0 [18:34:04.270] commandTag = [18:34:04.270] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:34:04.270] querytree_list = [18:34:04.270] portal = 0x55560c6ab100 [18:34:04.270] receiver = 0x55560c783d38 [18:34:04.270] format = 0 [18:34:04.270] cmdtagname = [18:34:04.270] parsetree_item__state = [18:34:04.270] dest = DestRemote [18:34:04.270] oldcontext = 0x55560c6bd530 [18:34:04.270] parsetree_list = 0x55560c627e10 [18:34:04.270] parsetree_item = 0x55560c627e28 [18:34:04.270] save_log_statement_stats = false [18:34:04.270] was_logged = false [18:34:04.270] use_implicit_block = false [18:34:04.270] msec_str = "\004\000\000\000\000\000\000\0009F\225\vVU\000\000\300\206\214S\374\177\000\000S\000\000\000\000\000\000" [18:34:04.270] __func__ = "exec_simple_query" [18:34:04.270] #23 0x000055560b698c89 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [18:34:04.270] query_string = 0x55560c626af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');" [18:34:04.270] firstchar = [18:34:04.270] input_message = {data = 0x55560c626af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", len = 83, maxlen = 1024, cursor = 83} [18:34:04.270] local_sigjmp_buf = {{__jmpbuf = {93828062693848, -3848730136121934810, 140721710204988, 4, 16, 140721710205220, -6934927709460202458, -3848714869474165722}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93828063055376, 15616, 93828062687904, 93828063587696, 16, 93828050004520, 0, 9, 2, 93828062693856, 93828063055376, 93828062687904, 4, 16, 140721710205220}}}} [18:34:04.270] send_ready_for_query = false [18:34:04.270] idle_in_transaction_timeout_enabled = false [18:34:04.270] idle_session_timeout_enabled = false [18:34:04.270] __func__ = "PostgresMain" [18:34:04.270] #24 0x000055560b68ecf4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:34:04.270] bsdata = [18:34:04.270] #25 0x000055560b5403e0 in postmaster_child_launch (child_type=B_BACKEND, child_slot=16, startup_data=startup_data@entry=0x7ffc538c883c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc538c8890) at ../src/backend/postmaster/launch_backend.c:274 [18:34:04.270] pid = [18:34:04.270] #26 0x000055560b5453db in BackendStartup (client_sock=client_sock@entry=0x7ffc538c8890) at ../src/backend/postmaster/postmaster.c:3386 [18:34:04.270] bn = 0x55560c64f338 [18:34:04.270] pid = [18:34:04.270] startup_data = {canAcceptConnections = CAC_OK} [18:34:04.270] cac = [18:34:04.270] __func__ = "BackendStartup" [18:34:04.270] #27 0x000055560b5472b4 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [18:34:04.270] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\243Ҳ\177\000\000\240O\372Ӳ\177\000\0008\211\214S\374\177\000\0004\211\214S\374\177", '\000' , "\272\024m\nVU\000\000\220\367h\nVU\000\000\000\212\214S\374\177\000\000\370\211\214S\374\177\000\000\225[\362\001\000\000\000\000\240\264\362Ӳ\177\000\000+", '\000' , "VU\000\000\310\023m\nVU\000", __ss_align = 140406041532008}, salen = 2}} [18:34:04.270] i = 0 [18:34:04.270] now = [18:34:04.270] last_lockfile_recheck_time = 1734546600 [18:34:04.270] last_touch_time = 1734546600 [18:34:04.270] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x55560a6d14ba}, {pos = -734341528, events = 32690, fd = -739068368, user_data = 0x7fb2d43ad2e0}, {pos = 2090263927, events = 0, fd = 1401719424, user_data = 0x7fb2d4383a48}, {pos = 15, events = 0, fd = -739068368, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fb2d43ad2e0}, {pos = 1401719288, events = 32764, fd = 1401719296, user_data = 0x7fb2d43ad668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 207783904, events = 21846, fd = 1, user_data = 0x7ffc538c8f23}, {pos = -1, events = 0, fd = -761077728, user_data = 0x7fb2d3fa4fa0}, {pos = 207954328, events = 21846, fd = 207954040, user_data = 0x55560c654461}, {pos = -734486850, events = 32690, fd = 1, user_data = 0x7fb2d43ad2e0}, {pos = 426, events = 0, fd = 200097104, user_data = 0x0}, {pos = 236, events = 0, fd = 207776688, user_data = 0x7fb2d4389ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fb2d2a2e020}, {pos = -760271296, events = 32690, fd = 16, user_data = 0x7ffc538c8e50}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -734477894, events = 32690, fd = 0, user_data = 0x7fb2d2aaeda4 }, {pos = 0, events = 0, fd = 207080832, user_data = 0x2}, {pos = 0, events = 0, fd = 207523504, user_data = 0x55560b62c797 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 207776688, user_data = 0x7fb2d4389ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fb2d2a364c8}, {pos = -760516857, events = 32690, fd = 207136960, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -759227296, events = 32690, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x342020200a0a3533}, {pos = 822763892, events = 892613431, fd = 808859188, 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 = 207969424, user_data = 0x7fb2d2ab576b}, {pos = -759244320, events = 32690, fd = -760606354, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xe041ca54d5ade500}, {pos = -759241248, events = 32690, fd = -328, user_data = 0x0}, {pos = 207953720, events = 21846, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 21059, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 207776688, user_data = 0x7fb2d2af3053 }, {pos = 207953720, events = 21846, fd = 1024, user_data = 0x7ffc538c8f18}, {pos = 194535455, events = 21846, fd = 207145360, user_data = 0x55560b974adc }, {pos = 207953520, events = 21846, fd = 207776240, user_data = 0x55560c651e70}, {pos = -760522901, events = 32690, fd = 0, user_data = 0x55560b986746 }, {pos = 207953520, events = 1, fd = 194537615, user_data = 0x55560c6269f0}, {pos = -710023936, events = 3762408020, fd = 0, user_data = 0x7fb2d2aa2ab1}, {pos = -760605456, events = 32690, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 207523504, user_data = 0xe041ca54d5ade500}, {pos = 0, events = 0, fd = -710023936, user_data = 0xc}, {pos = -710023936, events = 3762408020, fd = 0, user_data = 0x7fb2d2a5b239 }, {pos = 237, events = 0, fd = 190054621, user_data = 0x400000}, {pos = 0, events = 0, fd = 207523504, user_data = 0x55560b974970 }, {pos = 207610144, events = 21846, fd = 207776240, user_data = 0x55560c5fe120}, {pos = 1, events = 0, fd = 0, user_data = 0x55560b933131 }, {pos = 12, events = 0, fd = 207953096, user_data = 0x55560c651ca8}, {pos = 207082240, events = 21846, fd = 296, user_data = 0x55560b5428f7 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 190071092, events = 21846, fd = 203503536, user_data = 0x55560c6273c8}} [18:34:04.270] nevents = 1 [18:34:04.270] __func__ = "ServerLoop" [18:34:04.270] #28 0x000055560b548b35 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55560c5e4d70) at ../src/backend/postmaster/postmaster.c:1371 [18:34:04.270] opt = [18:34:04.270] status = [18:34:04.270] userDoption = [18:34:04.270] listen_addr_saved = false [18:34:04.270] output_config_variable = [18:34:04.270] __func__ = "PostmasterMain" [18:34:04.270] #29 0x000055560b375214 in main (argc=8, argv=0x55560c5e4d70) at ../src/backend/main/main.c:230 [18:34:04.270] do_check_root = [18:34:04.270] dispatch_option = [18:34:04.307] -e [18:34:04.307] [18:34:04.307] [18:34:04.374] dumping /tmp/cores/postgres-6-39510.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [18:34:04.639] [New LWP 39510] [18:34:04.639] [18:34:04.639] This GDB supports auto-downloading debuginfo from the following URLs: [18:34:04.639] [18:34:04.639] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [18:34:04.639] Debuginfod has been disabled. [18:34:04.639] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [18:34:04.743] [Thread debugging using libthread_db enabled] [18:34:04.743] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:34:04.743] Core was generated by `postgres: test: postgres db1 [local] SELECT '. [18:34:04.743] Program terminated with signal SIGABRT, Aborted. [18:34:04.743] #0 0x00007fc6a36a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:04.799] [18:34:04.799] Thread 1 (Thread 0x7fc6a33e7f00 (LWP 39510)): [18:34:04.799] #0 0x00007fc6a36a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:04.799] No symbol table info available. [18:34:04.799] #1 0x00007fc6a365afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:04.799] No symbol table info available. [18:34:04.799] #2 0x00007fc6a3645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:04.799] No symbol table info available. [18:34:04.799] #3 0x00007fc6a381e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [18:34:04.799] No locals. [18:34:04.799] #4 0x00007fc6a382aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [18:34:04.799] No locals. [18:34:04.799] #5 0x00007fc6a380dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55bf5c67b8a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [18:34:04.799] bp = 140727709146768 [18:34:04.799] pc = [18:34:04.799] Opts = {FromUnrecoverableHandler = true, pc = 94280363483924, bp = 140490925358248} [18:34:04.799] #6 0x000055bf5b932314 in examine_self_contradictory_rels (root=root@entry=0x55bf5ec2bf28, rel=rel@entry=0x55bf5ec35c18, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [18:34:04.799] lc__state = [18:34:04.799] rlist = [18:34:04.799] i = 7 [18:34:04.799] br = [18:34:04.799] expression = [18:34:04.799] or_rinfo = 0x7fc697b34d38 [18:34:04.799] ccxt = [18:34:04.799] delidx = 0x7fc697b37e91 [18:34:04.799] arglst = [18:34:04.799] lc = [18:34:04.799] arg = [18:34:04.799] n = [18:34:04.799] restrictinfo = [18:34:04.799] ccwapper = {clausecxt = 0x7fc697b35b28} [18:34:04.799] sec = {sopcinfo = {n_members = 38, opcies = 0x7fc697b352c8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7fc697b356d8, atop_set = 0x7fc697b33398}, ccfree = 0x7fc697b37e60, vifree = 0x7fc697b36d78} [18:34:04.799] __func__ = "examine_self_contradictory_rels" [18:34:04.799] #7 0x000055bf5b932523 in examine_self_contradictory_rels_phase1 (root=root@entry=0x55bf5ec2bf28) at ../src/backend/optimizer/plan/contradictory.c:2608 [18:34:04.799] rel = 0x55bf5ec35c18 [18:34:04.799] rti = 1 [18:34:04.799] rinfo = [18:34:04.799] #8 0x000055bf5b8fd4c6 in query_planner (root=root@entry=0x55bf5ec2bf28, qp_callback=qp_callback@entry=0x55bf5b9027e3 , qp_extra=qp_extra@entry=0x7ffdb91d2090) at ../src/backend/optimizer/plan/planmain.c:193 [18:34:04.799] parse = 0x55bf5ec22720 [18:34:04.799] joinlist = 0x7fc697b33528 [18:34:04.799] final_rel = [18:34:04.799] __func__ = "query_planner" [18:34:04.799] #9 0x000055bf5b90ff58 in grouping_planner (root=root@entry=0x55bf5ec2bf28, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [18:34:04.799] sort_input_targets = 0x55bf5ec2bf28 [18:34:04.799] sort_input_target_parallel_safe = [18:34:04.799] grouping_target = [18:34:04.799] scanjoin_target = [18:34:04.799] activeWindows = 0x0 [18:34:04.799] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [18:34:04.799] sort_input_targets_contain_srfs = 0x55bf5ec29720 [18:34:04.799] have_grouping = [18:34:04.799] wflists = 0x0 [18:34:04.799] gset_data = 0x0 [18:34:04.799] sort_input_target = [18:34:04.799] grouping_targets = 0x55bf5ec29768 [18:34:04.799] grouping_target_parallel_safe = [18:34:04.799] scanjoin_targets = 0x55bf5ec29750 [18:34:04.799] scanjoin_target_parallel_safe = [18:34:04.799] grouping_targets_contain_srfs = 0x55bf5ec2bf28 [18:34:04.799] scanjoin_targets_contain_srfs = 0x0 [18:34:04.799] scanjoin_target_same_exprs = [18:34:04.799] parse = 0x55bf5ec22720 [18:34:04.799] offset_est = 0 [18:34:04.799] count_est = 0 [18:34:04.799] limit_tuples = -1 [18:34:04.799] have_postponed_srfs = false [18:34:04.799] final_target = [18:34:04.799] final_targets = 0x55bf5ec2bf28 [18:34:04.799] final_targets_contain_srfs = 0x7 [18:34:04.799] final_target_parallel_safe = [18:34:04.799] current_rel = [18:34:04.799] final_rel = [18:34:04.799] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94280416896800} [18:34:04.799] lc = [18:34:04.799] __func__ = "grouping_planner" [18:34:04.799] #10 0x000055bf5b912edc in subquery_planner (glob=, parse=0x55bf5ec22720, parent_root=parent_root@entry=0x55bf5ec1f8e0, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [18:34:04.799] root = 0x55bf5ec2bf28 [18:34:04.799] newWithCheckOptions = [18:34:04.799] newHaving = 0x0 [18:34:04.799] hasOuterJoins = [18:34:04.799] hasResultRTEs = true [18:34:04.799] final_rel = [18:34:04.799] l = 0x0 [18:34:04.799] #11 0x000055bf5b924876 in SS_process_ctes (root=root@entry=0x55bf5ec1f8e0) at ../src/backend/optimizer/plan/subselect.c:966 [18:34:04.799] subquery = [18:34:04.799] cte = 0x55bf5ebe5490 [18:34:04.799] cmdType = [18:34:04.799] subroot = [18:34:04.799] final_rel = [18:34:04.799] best_path = [18:34:04.799] plan = [18:34:04.799] splan = [18:34:04.799] paramid = [18:34:04.799] lc__state = [18:34:04.799] lc = [18:34:04.799] __func__ = "SS_process_ctes" [18:34:04.799] #12 0x000055bf5b911980 in subquery_planner (glob=glob@entry=0x55bf5ebfa6e8, parse=parse@entry=0x55bf5ebfa7f8, 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:704 [18:34:04.799] root = 0x55bf5ec1f8e0 [18:34:04.799] newWithCheckOptions = [18:34:04.799] newHaving = [18:34:04.799] hasOuterJoins = [18:34:04.799] hasResultRTEs = [18:34:04.799] final_rel = [18:34:04.799] l = [18:34:04.799] #13 0x000055bf5b913b6d in standard_planner (parse=0x55bf5ebfa7f8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [18:34:04.799] result = [18:34:04.799] glob = 0x55bf5ebfa6e8 [18:34:04.799] tuple_fraction = 0 [18:34:04.799] root = [18:34:04.799] final_rel = [18:34:04.799] best_path = [18:34:04.799] top_plan = [18:34:04.799] lp = [18:34:04.799] lr = [18:34:04.799] #14 0x000055bf5b914bd7 in planner (parse=parse@entry=0x55bf5ebfa7f8, query_string=query_string@entry=0x55bf5eb0a5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [18:34:04.799] result = [18:34:04.799] #15 0x000055bf5bb84464 in pg_plan_query (querytree=querytree@entry=0x55bf5ebfa7f8, query_string=query_string@entry=0x55bf5eb0a5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [18:34:04.799] plan = [18:34:04.799] #16 0x000055bf5bb84845 in pg_plan_queries (querytrees=0x55bf5ec1f890, query_string=query_string@entry=0x55bf5eb0a5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:993 [18:34:04.799] query = 0x55bf5ebfa7f8 [18:34:04.799] stmt = [18:34:04.799] query_list__state = [18:34:04.799] stmt_list = 0x0 [18:34:04.799] query_list = [18:34:04.799] #17 0x000055bf5bb84df2 in exec_simple_query (query_string=query_string@entry=0x55bf5eb0a5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "...) at ../src/backend/tcop/postgres.c:1190 [18:34:04.799] cmdtaglen = 6 [18:34:04.799] snapshot_set = true [18:34:04.799] per_parsetree_context = 0x0 [18:34:04.799] plantree_list = [18:34:04.799] parsetree = 0x55bf5ebfa668 [18:34:04.799] commandTag = CMDTAG_SELECT [18:34:04.799] qc = {commandTag = 1935, nprocessed = 94280415749536} [18:34:04.799] querytree_list = [18:34:04.799] portal = [18:34:04.799] receiver = [18:34:04.799] format = 0 [18:34:04.799] cmdtagname = [18:34:04.799] parsetree_item__state = [18:34:04.799] dest = DestRemote [18:34:04.799] oldcontext = 0x55bf5eb99f40 [18:34:04.799] parsetree_list = 0x55bf5ebfa698 [18:34:04.799] parsetree_item = 0x55bf5ebfa6b0 [18:34:04.799] save_log_statement_stats = false [18:34:04.799] was_logged = true [18:34:04.799] use_implicit_block = false [18:34:04.799] msec_str = "\004\000\000\000\000\000\000\00096\344[\277U\000\000`$\035\271\375\177\000\000\217\a\000\000\000\000\000" [18:34:04.799] __func__ = "exec_simple_query" [18:34:04.799] #18 0x000055bf5bb87c89 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [18:34:04.799] query_string = 0x55bf5eb0a5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "... [18:34:04.799] firstchar = [18:34:04.799] input_message = {data = 0x55bf5eb0a5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., len = 1935, maxlen = 2048, cursor = 1935} [18:34:04.799] local_sigjmp_buf = {{__jmpbuf = {94280381610456, -9023738872078331252, 140727709148636, 4, 2, 140727709148868, -3008133817742191988, -9023749715178220916}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94280415477200, 14336, 94280381604512, 94280415984720, 2, 94280368921128, 0, 9, 2, 94280381610464, 94280415477200, 94280381604512, 4, 2, 140727709148868}}}} [18:34:04.799] send_ready_for_query = false [18:34:04.799] idle_in_transaction_timeout_enabled = false [18:34:04.799] idle_session_timeout_enabled = false [18:34:04.799] __func__ = "PostgresMain" [18:34:04.799] #19 0x000055bf5bb7dcf4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:34:04.799] bsdata = [18:34:04.799] #20 0x000055bf5ba2f3e0 in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x7ffdb91d25dc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffdb91d2630) at ../src/backend/postmaster/launch_backend.c:274 [18:34:04.799] pid = [18:34:04.799] #21 0x000055bf5ba343db in BackendStartup (client_sock=client_sock@entry=0x7ffdb91d2630) at ../src/backend/postmaster/postmaster.c:3386 [18:34:04.799] bn = 0x55bf5eb315f8 [18:34:04.799] pid = [18:34:04.799] startup_data = {canAcceptConnections = CAC_OK} [18:34:04.799] cac = [18:34:04.799] __func__ = "BackendStartup" [18:34:04.799] #22 0x000055bf5ba362b4 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [18:34:04.799] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\272\004\274Z\277U\000\000\220\347\267Z\277U\000\000\200'\035\271\375\177\000\000x'\035\271\375\177\000\000\225[\362\001\000\000\000\000\240\324\343\243\306\177\000\000+", '\000' , "\375\177\000\000\000\004\000\000\000\000\000\000h\026\352\244\306\177\000\0000\326\343\243\306\177\000\000\340\022\352\244\306\177\000\000\316)fR\000\000\000", __ss_align = 3105695680}, salen = 2}} [18:34:04.799] i = 0 [18:34:04.799] now = [18:34:04.799] last_lockfile_recheck_time = 1734546678 [18:34:04.799] last_touch_time = 1734546678 [18:34:04.799] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1545349584, events = 32710, fd = -1528163616, user_data = 0x7c96e577}, {pos = -1189271552, events = 32765, fd = -1528333752, user_data = 0xf}, {pos = -1545349584, events = 32710, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1528163616, user_data = 0x7ffdb91d2778}, {pos = -1189271680, events = 32765, fd = -1528162712, user_data = 0x0}, {pos = 1588640288, events = 21951, fd = -1553237366, user_data = 0x55bf5eb0ba20}, {pos = 1, events = 21951, fd = 32768, user_data = 0xffffffff}, {pos = -1553801184, events = 32710, fd = -1531773024, user_data = 0x55bf5eb35358}, {pos = 1588810296, events = 21951, fd = 1588807681, user_data = 0x7fc6a4e7debe}, {pos = 1, events = 0, fd = -1528163616, user_data = 0x1aa}, {pos = 1547447632, events = 21951, fd = 0, user_data = 0xd8}, {pos = 1588640288, events = 21951, fd = -1528308034, user_data = 0x1}, {pos = 0, events = 0, fd = -1553801184, user_data = 0x7fc6a36f2e40 }, {pos = 16, events = 0, fd = -1189270544, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fc6a4e801ba}, {pos = 0, events = 0, fd = -1553273436, user_data = 0x0}, {pos = 1554431360, events = 21951, fd = 2, user_data = 0x0}, {pos = 1588379248, events = 21951, fd = 1538354121, user_data = 0x55bf5eb3cb00}, {pos = 1538358110, events = 21951, fd = 1588841307, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -1553767224, user_data = 0x7fc6a369c880 }, {pos = -1556185672, events = 32710, fd = -1189270352, user_data = 0x100007f00000002}, {pos = -1553240313, events = 32710, fd = 2, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -1551950752, events = 32710, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1213561443, events = 1699240015, fd = 168450615, user_data = 0x74616467702f6174}, {pos = 925960801, events = 875902003, fd = 1751342899, user_data = 0x305f742f61746164}, {pos = 1684826485, events = 1769300527, fd = 1949262956, user_data = 0x0}, {pos = 0, events = 21760, 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 = 1588814496, events = 21951, fd = -1553237366, user_data = 0xa}, {pos = 1541802667, events = 21951, fd = 1588822720, user_data = 0x7fc6a36b58be}, {pos = -1551967776, events = 32710, fd = -1553329810, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x6c4e59ae5b427c00}, {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 = 0x55bf5eb35030}, {pos = 1, events = 0, fd = 1588809976, user_data = 0x3}, {pos = 0, events = 0, fd = 39124, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1588640288, user_data = 0x7fc6a36f3053 }, {pos = 1588809976, events = 21951, fd = 1024, user_data = 0x7ffdb91d2cb8}, {pos = 1541885983, events = 21951, fd = 1554495888, user_data = 0x55bf5be63adc }, {pos = 1588809776, events = 21951, fd = 1588632704, user_data = 0x55bf5eb35030}, {pos = -1553246357, events = 32710, fd = 0, user_data = 0x55bf5be75746 }, {pos = 1588809776, events = 1, fd = 1541888143, user_data = 0x55bf5eb09c80}, {pos = 1531083776, events = 1817074094, fd = 0, user_data = 0x7fc6a36a2ab1}, {pos = -1553328912, events = 32710, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1588379248, user_data = 0x6c4e59ae5b427c00}, {pos = 0, events = 0, fd = 1531083776, user_data = 0xc}, {pos = 1531083776, events = 1817074094, fd = 0, user_data = 0x7fc6a365b239 }, {pos = 217, events = 0, fd = 1537405149, user_data = 0x400000}, {pos = 0, events = 0, fd = 1588379248, user_data = 0x55bf5be63970 }, {pos = 1588466608, events = 21951, fd = 1588632704, user_data = 0x55bf5eae13b0}, {pos = 1, events = 0, fd = 0, user_data = 0x55bf5be22131 }, {pos = 12, events = 0, fd = 1588805224, user_data = 0x55bf5eb33e48}, {pos = 1554432768, events = 21951, fd = 296, user_data = 0x55bf5ba318f7 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1537421620, events = 21951, fd = 1550854064, user_data = 0x55bf5eb0a638}} [18:34:04.799] nevents = 1 [18:34:04.799] __func__ = "ServerLoop" [18:34:04.799] #23 0x000055bf5ba37b35 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55bf5eac7ce0) at ../src/backend/postmaster/postmaster.c:1371 [18:34:04.799] opt = [18:34:04.799] status = [18:34:04.799] userDoption = [18:34:04.799] listen_addr_saved = false [18:34:04.799] output_config_variable = [18:34:04.799] __func__ = "PostmasterMain" [18:34:04.799] #24 0x000055bf5b864214 in main (argc=4, argv=0x55bf5eac7ce0) at ../src/backend/main/main.c:230 [18:34:04.799] do_check_root = [18:34:04.799] dispatch_option = [18:34:04.818] -e [18:34:04.818] [18:34:04.818] [18:34:04.884] dumping /tmp/cores/postgres-6-28514.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:34:05.143] [New LWP 28514] [18:34:05.143] [18:34:05.143] This GDB supports auto-downloading debuginfo from the following URLs: [18:34:05.143] [18:34:05.143] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [18:34:05.143] Debuginfod has been disabled. [18:34:05.143] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [18:34:05.244] [Thread debugging using libthread_db enabled] [18:34:05.244] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:34:05.244] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [18:34:05.244] Program terminated with signal SIGABRT, Aborted. [18:34:05.244] #0 0x00007fb2d2aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:06.353] [18:34:06.353] Thread 1 (Thread 0x7fb2d29dbf00 (LWP 28514)): [18:34:06.353] #0 0x00007fb2d2aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:06.353] No symbol table info available. [18:34:06.353] #1 0x00007fb2d2a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:06.353] No symbol table info available. [18:34:06.353] #2 0x00007fb2d2a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:06.353] No symbol table info available. [18:34:06.353] #3 0x00007fb2d2c1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [18:34:06.353] No locals. [18:34:06.353] #4 0x00007fb2d2c2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [18:34:06.353] No locals. [18:34:06.353] #5 0x00007fb2d2c0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55560c18c8a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [18:34:06.353] bp = 140721710202240 [18:34:06.353] pc = [18:34:06.353] Opts = {FromUnrecoverableHandler = true, pc = 93828044567316, bp = 93828064349096} [18:34:06.353] #6 0x000055560b443314 in examine_self_contradictory_rels (root=root@entry=0x55560c685408, rel=rel@entry=0x55560c6851b8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [18:34:06.353] lc__state = [18:34:06.353] rlist = [18:34:06.353] i = 2 [18:34:06.353] br = [18:34:06.353] expression = [18:34:06.353] or_rinfo = 0x55560c721788 [18:34:06.353] ccxt = [18:34:06.353] delidx = 0x55560c721721 [18:34:06.353] arglst = [18:34:06.353] lc = [18:34:06.353] arg = [18:34:06.353] n = [18:34:06.353] restrictinfo = [18:34:06.353] ccwapper = {clausecxt = 0x55560c721088} [18:34:06.353] sec = {sopcinfo = {n_members = 38, opcies = 0x55560c720bf8}, attrsdc = {min_attr = -6, max_attr = 5, len_set = 2, atop_array = 0x55560c720318, atop_set = 0x55560c720498}, ccfree = 0x55560c7216f0, vifree = 0x55560c721290} [18:34:06.353] __func__ = "examine_self_contradictory_rels" [18:34:06.353] #7 0x000055560b443523 in examine_self_contradictory_rels_phase1 (root=root@entry=0x55560c685408) at ../src/backend/optimizer/plan/contradictory.c:2608 [18:34:06.353] rel = 0x55560c6851b8 [18:34:06.353] rti = 1 [18:34:06.353] rinfo = [18:34:06.353] #8 0x000055560b40e4c6 in query_planner (root=root@entry=0x55560c685408, qp_callback=qp_callback@entry=0x55560b4137e3 , qp_extra=qp_extra@entry=0x7ffc538c7f80) at ../src/backend/optimizer/plan/planmain.c:193 [18:34:06.353] parse = 0x55560c6280e0 [18:34:06.353] joinlist = 0x55560c720508 [18:34:06.353] final_rel = [18:34:06.353] __func__ = "query_planner" [18:34:06.353] #9 0x000055560b420f58 in grouping_planner (root=root@entry=0x55560c685408, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [18:34:06.353] sort_input_targets = 0x5 [18:34:06.353] sort_input_target_parallel_safe = [18:34:06.353] grouping_target = [18:34:06.353] scanjoin_target = [18:34:06.353] activeWindows = 0x0 [18:34:06.353] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [18:34:06.353] sort_input_targets_contain_srfs = 0x1 [18:34:06.353] have_grouping = [18:34:06.353] wflists = 0x0 [18:34:06.353] gset_data = 0x0 [18:34:06.353] sort_input_target = [18:34:06.353] grouping_targets = 0x1 [18:34:06.353] grouping_target_parallel_safe = [18:34:06.353] scanjoin_targets = 0x0 [18:34:06.353] scanjoin_target_parallel_safe = [18:34:06.353] grouping_targets_contain_srfs = 0x1 [18:34:06.353] scanjoin_targets_contain_srfs = 0x55560b987ef6 [18:34:06.353] scanjoin_target_same_exprs = [18:34:06.353] parse = 0x55560c6280e0 [18:34:06.353] offset_est = 0 [18:34:06.353] count_est = 0 [18:34:06.353] limit_tuples = -1 [18:34:06.353] have_postponed_srfs = false [18:34:06.353] final_target = [18:34:06.353] final_targets = 0x55560c65d618 [18:34:06.353] final_targets_contain_srfs = 0x55560b37f1a8 [18:34:06.353] final_target_parallel_safe = [18:34:06.353] current_rel = [18:34:06.353] final_rel = [18:34:06.353] extra = {limit_needed = false, limit_tuples = 4.635721302869606e-310, count_est = 93828063716104, offset_est = 93828063716104} [18:34:06.353] lc = [18:34:06.353] __func__ = "grouping_planner" [18:34:06.353] #10 0x000055560b423edc in subquery_planner (glob=glob@entry=0x55560c6850a8, parse=parse@entry=0x55560c6280e0, 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:1151 [18:34:06.353] root = 0x55560c685408 [18:34:06.353] newWithCheckOptions = [18:34:06.353] newHaving = 0x0 [18:34:06.353] hasOuterJoins = [18:34:06.353] hasResultRTEs = false [18:34:06.353] final_rel = [18:34:06.353] l = 0x0 [18:34:06.353] #11 0x000055560b424b6d in standard_planner (parse=0x55560c6280e0, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [18:34:06.353] result = [18:34:06.353] glob = 0x55560c6850a8 [18:34:06.353] tuple_fraction = 0 [18:34:06.353] root = [18:34:06.353] final_rel = [18:34:06.353] best_path = [18:34:06.353] top_plan = [18:34:06.353] lp = [18:34:06.353] lr = [18:34:06.353] #12 0x000055560b425bd7 in planner (parse=parse@entry=0x55560c6280e0, query_string=query_string@entry=0x55560c626af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [18:34:06.353] result = [18:34:06.353] #13 0x000055560b695464 in pg_plan_query (querytree=querytree@entry=0x55560c6280e0, query_string=query_string@entry=0x55560c626af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [18:34:06.353] plan = [18:34:06.353] #14 0x000055560b1985a6 in standard_ExplainOneQuery (query=0x55560c6280e0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55560c6614b8, queryString=0x55560c626af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [18:34:06.353] plan = [18:34:06.353] planstart = [18:34:06.353] planduration = {ticks = 93828043741900} [18:34:06.353] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 93828050004972, shared_blks_dirtied = 1401717358, shared_blks_written = 3, local_blks_hit = 5696684896, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 93828063330528, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 93828050091766}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93828043739281}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 93828063330528}} [18:34:06.353] bufusage = {shared_blks_hit = 0, shared_blks_read = 93828046765484, shared_blks_dirtied = 211308096012288, shared_blks_written = 72057594037927936, local_blks_hit = 140405820801256, local_blks_read = 93828063331920, local_blks_dirtied = 93828063330528, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 93828049619724, shared_blk_read_time = {ticks = 140405820801256}, shared_blk_write_time = {ticks = 93828049619743}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93828050000555}, temp_blk_read_time = {ticks = 93828063564144}, temp_blk_write_time = {ticks = 64}} [18:34:06.353] mem_counters = {nblocks = 93828063711240, freechunks = 4294967297, totalspace = 140721710203376, freespace = 10} [18:34:06.353] planner_ctx = 0x0 [18:34:06.353] saved_ctx = 0x0 [18:34:06.353] #15 0x000055560b19888c in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55560c6614b8, pstate=pstate@entry=0x55560c6613a8, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [18:34:06.353] No locals. [18:34:06.353] #16 0x000055560b1997e3 in ExplainQuery (pstate=pstate@entry=0x55560c6613a8, stmt=stmt@entry=0x55560c627f20, params=params@entry=0x0, dest=dest@entry=0x55560c661318) at ../src/backend/commands/explain.c:357 [18:34:06.353] l__state = [18:34:06.353] l = 0x55560c685070 [18:34:06.353] es = 0x55560c6614b8 [18:34:06.353] tstate = [18:34:06.353] jstate = [18:34:06.353] query = [18:34:06.353] rewritten = 0x55560c685058 [18:34:06.353] lc = 0x0 [18:34:06.353] timing_set = false [18:34:06.353] buffers_set = false [18:34:06.353] summary_set = false [18:34:06.353] __func__ = "ExplainQuery" [18:34:06.353] #17 0x000055560b69fe84 in standard_ProcessUtility (pstmt=0x55560c627fd0, queryString=0x55560c626af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55560c661318, qc=0x7ffc538c8470) at ../src/backend/tcop/utility.c:866 [18:34:06.353] parsetree = 0x55560c627f20 [18:34:06.353] isTopLevel = true [18:34:06.353] isAtomicContext = false [18:34:06.353] pstate = 0x55560c6613a8 [18:34:06.353] readonly_flags = [18:34:06.353] __func__ = "standard_ProcessUtility" [18:34:06.353] #18 0x000055560b6a05ad in ProcessUtility (pstmt=pstmt@entry=0x55560c627fd0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55560c661318, qc=0x7ffc538c8470) at ../src/backend/tcop/utility.c:523 [18:34:06.353] No locals. [18:34:06.353] #19 0x000055560b69bf6b in PortalRunUtility (portal=portal@entry=0x55560c6ab100, pstmt=0x55560c627fd0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55560c661318, qc=qc@entry=0x7ffc538c8470) at ../src/backend/tcop/pquery.c:1152 [18:34:06.353] No locals. [18:34:06.353] #20 0x000055560b69c7de in FillPortalStore (portal=portal@entry=0x55560c6ab100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [18:34:06.353] treceiver = 0x55560c661318 [18:34:06.353] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:34:06.353] __func__ = "FillPortalStore" [18:34:06.353] #21 0x000055560b69ccf9 in PortalRun (portal=portal@entry=0x55560c6ab100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55560c65d8f8, altdest=altdest@entry=0x55560c65d8f8, qc=qc@entry=0x7ffc538c8630) at ../src/backend/tcop/pquery.c:759 [18:34:06.353] _save_exception_stack = 0x7ffc538c86e0 [18:34:06.353] _save_context_stack = 0x0 [18:34:06.353] _local_sigjmp_buf = {{__jmpbuf = {0, -3848730299832959962, 93828063867136, 93828063330200, 93828063330176, 93828063330128, -6934927709527311322, -3848714871797679066}, __mask_was_saved = 0, __saved_mask = {__val = {93828050004972, 1401718207, 4, 93828063330128, 112, 153, 93828063867136, 93828063330200, 93828063330176, 93828063330128, 93828050092175, 1, 2, 153, 93828039359569, 0}}}} [18:34:06.353] _do_rethrow = [18:34:06.353] result = [18:34:06.353] nprocessed = [18:34:06.353] saveTopTransactionResourceOwner = 0x55560c668658 [18:34:06.353] saveTopTransactionContext = 0x55560c6bd530 [18:34:06.353] saveActivePortal = 0x0 [18:34:06.353] saveResourceOwner = 0x55560c668658 [18:34:06.353] savePortalContext = 0x0 [18:34:06.353] saveMemoryContext = 0x55560c6bd530 [18:34:06.353] __func__ = "PortalRun" [18:34:06.353] #22 0x000055560b695f30 in exec_simple_query (query_string=query_string@entry=0x55560c626af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;") at ../src/backend/tcop/postgres.c:1271 [18:34:06.353] cmdtaglen = 7 [18:34:06.353] snapshot_set = [18:34:06.353] per_parsetree_context = 0x0 [18:34:06.353] plantree_list = 0x55560c65d8a8 [18:34:06.353] parsetree = 0x55560c627f50 [18:34:06.353] commandTag = [18:34:06.353] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:34:06.353] querytree_list = [18:34:06.353] portal = 0x55560c6ab100 [18:34:06.353] receiver = 0x55560c65d8f8 [18:34:06.353] format = 0 [18:34:06.353] cmdtagname = [18:34:06.353] parsetree_item__state = [18:34:06.353] dest = DestRemote [18:34:06.353] oldcontext = 0x55560c6bd530 [18:34:06.353] parsetree_list = 0x55560c627f80 [18:34:06.353] parsetree_item = 0x55560c627f98 [18:34:06.353] save_log_statement_stats = false [18:34:06.353] was_logged = false [18:34:06.353] use_implicit_block = false [18:34:06.353] msec_str = "\004\000\000\000\000\000\000\0009F\225\vVU\000\000\300\206\214S\374\177\000\000J\000\000\000\000\000\000" [18:34:06.353] __func__ = "exec_simple_query" [18:34:06.353] #23 0x000055560b698c89 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [18:34:06.353] query_string = 0x55560c626af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;" [18:34:06.353] firstchar = [18:34:06.353] input_message = {data = 0x55560c626af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", len = 74, maxlen = 1024, cursor = 74} [18:34:06.353] local_sigjmp_buf = {{__jmpbuf = {93828062693848, -3848730136121934810, 140721710204988, 4, 20, 140721710205220, -6934927709460202458, -3848714869474165722}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93828063055376, 15616, 93828062687904, 93828063587696, 20, 93828050004520, 0, 9, 2, 93828062693856, 93828063055376, 93828062687904, 4, 20, 140721710205220}}}} [18:34:06.353] send_ready_for_query = false [18:34:06.353] idle_in_transaction_timeout_enabled = false [18:34:06.353] idle_session_timeout_enabled = false [18:34:06.353] __func__ = "PostgresMain" [18:34:06.353] #24 0x000055560b68ecf4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:34:06.353] bsdata = [18:34:06.353] #25 0x000055560b5403e0 in postmaster_child_launch (child_type=B_BACKEND, child_slot=20, startup_data=startup_data@entry=0x7ffc538c883c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc538c8890) at ../src/backend/postmaster/launch_backend.c:274 [18:34:06.353] pid = [18:34:06.353] #26 0x000055560b5453db in BackendStartup (client_sock=client_sock@entry=0x7ffc538c8890) at ../src/backend/postmaster/postmaster.c:3386 [18:34:06.353] bn = 0x55560c64f3f8 [18:34:06.353] pid = [18:34:06.353] startup_data = {canAcceptConnections = CAC_OK} [18:34:06.353] cac = [18:34:06.353] __func__ = "BackendStartup" [18:34:06.353] #27 0x000055560b5472b4 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [18:34:06.353] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\243Ҳ\177\000\000\240O\372Ӳ\177\000\0008\211\214S\374\177\000\0004\211\214S\374\177", '\000' , "\272\024m\nVU\000\000\220\367h\nVU\000\000\000\212\214S\374\177\000\000\370\211\214S\374\177\000\000\225[\362\001\000\000\000\000\240\264\362Ӳ\177\000\000+", '\000' , "VU\000\000\310\023m\nVU\000", __ss_align = 140406041532008}, salen = 2}} [18:34:06.353] i = 0 [18:34:06.353] now = [18:34:06.353] last_lockfile_recheck_time = 1734546600 [18:34:06.353] last_touch_time = 1734546600 [18:34:06.353] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x55560a6d14ba}, {pos = -734341528, events = 32690, fd = -739068368, user_data = 0x7fb2d43ad2e0}, {pos = 2090263927, events = 0, fd = 1401719424, user_data = 0x7fb2d4383a48}, {pos = 15, events = 0, fd = -739068368, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fb2d43ad2e0}, {pos = 1401719288, events = 32764, fd = 1401719296, user_data = 0x7fb2d43ad668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 207783904, events = 21846, fd = 1, user_data = 0x7ffc538c8f23}, {pos = -1, events = 0, fd = -761077728, user_data = 0x7fb2d3fa4fa0}, {pos = 207954328, events = 21846, fd = 207954040, user_data = 0x55560c654461}, {pos = -734486850, events = 32690, fd = 1, user_data = 0x7fb2d43ad2e0}, {pos = 426, events = 0, fd = 200097104, user_data = 0x0}, {pos = 236, events = 0, fd = 207776688, user_data = 0x7fb2d4389ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fb2d2a2e020}, {pos = -760271296, events = 32690, fd = 16, user_data = 0x7ffc538c8e50}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -734477894, events = 32690, fd = 0, user_data = 0x7fb2d2aaeda4 }, {pos = 0, events = 0, fd = 207080832, user_data = 0x2}, {pos = 0, events = 0, fd = 207523504, user_data = 0x55560b62c797 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 207776688, user_data = 0x7fb2d4389ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fb2d2a364c8}, {pos = -760516857, events = 32690, fd = 207136960, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -759227296, events = 32690, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x342020200a0a3533}, {pos = 822763892, events = 892613431, fd = 808859188, 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 = 207969424, user_data = 0x7fb2d2ab576b}, {pos = -759244320, events = 32690, fd = -760606354, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xe041ca54d5ade500}, {pos = -759241248, events = 32690, fd = -328, user_data = 0x0}, {pos = 207953720, events = 21846, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 21059, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 207776688, user_data = 0x7fb2d2af3053 }, {pos = 207953720, events = 21846, fd = 1024, user_data = 0x7ffc538c8f18}, {pos = 194535455, events = 21846, fd = 207145360, user_data = 0x55560b974adc }, {pos = 207953520, events = 21846, fd = 207776240, user_data = 0x55560c651e70}, {pos = -760522901, events = 32690, fd = 0, user_data = 0x55560b986746 }, {pos = 207953520, events = 1, fd = 194537615, user_data = 0x55560c6269f0}, {pos = -710023936, events = 3762408020, fd = 0, user_data = 0x7fb2d2aa2ab1}, {pos = -760605456, events = 32690, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 207523504, user_data = 0xe041ca54d5ade500}, {pos = 0, events = 0, fd = -710023936, user_data = 0xc}, {pos = -710023936, events = 3762408020, fd = 0, user_data = 0x7fb2d2a5b239 }, {pos = 237, events = 0, fd = 190054621, user_data = 0x400000}, {pos = 0, events = 0, fd = 207523504, user_data = 0x55560b974970 }, {pos = 207610144, events = 21846, fd = 207776240, user_data = 0x55560c5fe120}, {pos = 1, events = 0, fd = 0, user_data = 0x55560b933131 }, {pos = 12, events = 0, fd = 207953096, user_data = 0x55560c651ca8}, {pos = 207082240, events = 21846, fd = 296, user_data = 0x55560b5428f7 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 190071092, events = 21846, fd = 203503536, user_data = 0x55560c6273c8}} [18:34:06.353] nevents = 1 [18:34:06.353] __func__ = "ServerLoop" [18:34:06.353] #28 0x000055560b548b35 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55560c5e4d70) at ../src/backend/postmaster/postmaster.c:1371 [18:34:06.353] opt = [18:34:06.353] status = [18:34:06.353] userDoption = [18:34:06.353] listen_addr_saved = false [18:34:06.353] output_config_variable = [18:34:06.353] __func__ = "PostmasterMain" [18:34:06.353] #29 0x000055560b375214 in main (argc=8, argv=0x55560c5e4d70) at ../src/backend/main/main.c:230 [18:34:06.353] do_check_root = [18:34:06.353] dispatch_option = [18:34:06.396] -e [18:34:06.396] [18:34:06.396] [18:34:06.486] dumping /tmp/cores/postgres-6-29161.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [18:34:06.767] [New LWP 29161] [18:34:06.767] [18:34:06.767] This GDB supports auto-downloading debuginfo from the following URLs: [18:34:06.767] [18:34:06.767] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [18:34:06.767] Debuginfod has been disabled. [18:34:06.767] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [18:34:07.026] [Thread debugging using libthread_db enabled] [18:34:07.026] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:34:07.026] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN '. [18:34:07.026] Program terminated with signal SIGABRT, Aborted. [18:34:07.026] #0 0x00007f90d0aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:08.082] [18:34:08.082] Thread 1 (Thread 0x7f90d1237f00 (LWP 29161)): [18:34:08.082] #0 0x00007f90d0aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:08.082] No symbol table info available. [18:34:08.082] #1 0x00007f90d0a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:08.082] No symbol table info available. [18:34:08.082] #2 0x00007f90d0a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:08.082] No symbol table info available. [18:34:08.082] #3 0x00007f90d0c1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [18:34:08.082] No locals. [18:34:08.082] #4 0x00007f90d0c2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [18:34:08.082] No locals. [18:34:08.082] #5 0x00007f90d0c0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5583739b18a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [18:34:08.082] bp = 140723215296288 [18:34:08.082] pc = [18:34:08.082] Opts = {FromUnrecoverableHandler = true, pc = 94023054689044, bp = 94023085269000} [18:34:08.082] #6 0x0000558372c68314 in examine_self_contradictory_rels (root=root@entry=0x5583749e40f8, rel=rel@entry=0x558374a19898, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [18:34:08.082] lc__state = [18:34:08.082] rlist = [18:34:08.082] i = 2 [18:34:08.082] br = [18:34:08.082] expression = [18:34:08.082] or_rinfo = 0x558374992d58 [18:34:08.082] ccxt = [18:34:08.082] delidx = 0x558374992bf1 [18:34:08.082] arglst = [18:34:08.082] lc = [18:34:08.082] arg = [18:34:08.082] n = [18:34:08.082] restrictinfo = [18:34:08.082] ccwapper = {clausecxt = 0x558374992588} [18:34:08.082] sec = {sopcinfo = {n_members = 38, opcies = 0x558374992058}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x5583749916f8, atop_set = 0x558374992468}, ccfree = 0x558374992bc0, vifree = 0x5583749926f8} [18:34:08.082] __func__ = "examine_self_contradictory_rels" [18:34:08.082] #7 0x0000558372c68523 in examine_self_contradictory_rels_phase1 (root=root@entry=0x5583749e40f8) at ../src/backend/optimizer/plan/contradictory.c:2608 [18:34:08.082] rel = 0x558374a19898 [18:34:08.082] rti = 1 [18:34:08.082] rinfo = [18:34:08.082] #8 0x0000558372c334c6 in query_planner (root=root@entry=0x5583749e40f8, qp_callback=qp_callback@entry=0x558372c387e3 , qp_extra=qp_extra@entry=0x7ffcad426920) at ../src/backend/optimizer/plan/planmain.c:193 [18:34:08.082] parse = 0x5583746cfd38 [18:34:08.082] joinlist = 0x558374991768 [18:34:08.082] final_rel = [18:34:08.082] __func__ = "query_planner" [18:34:08.082] #9 0x0000558372c45f58 in grouping_planner (root=root@entry=0x5583749e40f8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [18:34:08.082] sort_input_targets = 0x5 [18:34:08.082] sort_input_target_parallel_safe = [18:34:08.082] grouping_target = [18:34:08.082] scanjoin_target = [18:34:08.082] activeWindows = 0x0 [18:34:08.082] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [18:34:08.082] sort_input_targets_contain_srfs = 0x1 [18:34:08.082] have_grouping = [18:34:08.082] wflists = 0x0 [18:34:08.082] gset_data = 0x0 [18:34:08.082] sort_input_target = [18:34:08.082] grouping_targets = 0x1 [18:34:08.082] grouping_target_parallel_safe = [18:34:08.082] scanjoin_targets = 0x0 [18:34:08.082] scanjoin_target_parallel_safe = [18:34:08.082] grouping_targets_contain_srfs = 0x1 [18:34:08.082] scanjoin_targets_contain_srfs = 0x5583731acef6 [18:34:08.082] scanjoin_target_same_exprs = [18:34:08.082] parse = 0x5583746cfd38 [18:34:08.082] offset_est = 0 [18:34:08.082] count_est = 0 [18:34:08.082] limit_tuples = -1 [18:34:08.082] have_postponed_srfs = false [18:34:08.082] final_target = [18:34:08.082] final_targets = 0x5583747ceae8 [18:34:08.082] final_targets_contain_srfs = 0x558372ba41a8 [18:34:08.082] final_target_parallel_safe = [18:34:08.082] current_rel = [18:34:08.082] final_rel = [18:34:08.082] extra = {limit_needed = false, limit_tuples = 4.6453560830433184e-310, count_est = 94023085608808, offset_est = 94023085608808} [18:34:08.082] lc = [18:34:08.082] __func__ = "grouping_planner" [18:34:08.082] #10 0x0000558372c48edc in subquery_planner (glob=glob@entry=0x558374a19788, parse=parse@entry=0x5583746cfd38, 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:1151 [18:34:08.082] root = 0x5583749e40f8 [18:34:08.082] newWithCheckOptions = [18:34:08.082] newHaving = 0x0 [18:34:08.082] hasOuterJoins = [18:34:08.082] hasResultRTEs = false [18:34:08.082] final_rel = [18:34:08.082] l = 0x0 [18:34:08.082] #11 0x0000558372c49b6d in standard_planner (parse=parse@entry=0x5583746cfd38, query_string=query_string@entry=0x5583746cea90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:425 [18:34:08.082] result = [18:34:08.082] glob = 0x558374a19788 [18:34:08.082] tuple_fraction = 0 [18:34:08.082] root = [18:34:08.082] final_rel = [18:34:08.082] best_path = [18:34:08.082] top_plan = [18:34:08.082] lp = [18:34:08.082] lr = [18:34:08.082] #12 0x00007f90cea5e5a2 in pgss_planner (parse=0x5583746cfd38, query_string=0x5583746cea90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=2048, boundParams=0x0) at ../contrib/pg_stat_statements/pg_stat_statements.c:973 [18:34:08.082] _save_exception_stack = 0x7ffcad4272a0 [18:34:08.082] _save_context_stack = 0x0 [18:34:08.082] _local_sigjmp_buf = {{__jmpbuf = {94023082376504, 8353361903846828363, 0, 2048, 94023082376504, 2048, 2815497683042707787, 2867227218050427211}, __mask_was_saved = 0, __saved_mask = {__val = {94023082870776, 94023082868864, 94023059611239, 94023082375400, 17033, 0, 0, 0, 273489751816, 17033, 0, 140259879954544, 140259879954480, 0, 0, 140723215362476}}}} [18:34:08.082] _do_rethrow = false [18:34:08.082] result = 0x7ffcad426bd8 [18:34:08.082] #13 0x0000558372c4abcd in planner (parse=parse@entry=0x5583746cfd38, query_string=query_string@entry=0x5583746cea90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:290 [18:34:08.082] result = [18:34:08.082] #14 0x0000558372eba464 in pg_plan_query (querytree=querytree@entry=0x5583746cfd38, query_string=query_string@entry=0x5583746cea90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [18:34:08.082] plan = [18:34:08.082] #15 0x00005583729bd5a6 in standard_ExplainOneQuery (query=0x5583746cfd38, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5583746ff6b8, queryString=0x5583746cea90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [18:34:08.082] plan = [18:34:08.082] planstart = [18:34:08.082] planduration = {ticks = 94023053863628} [18:34:08.082] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94023060126700, shared_blks_dirtied = 2906812238, shared_blks_written = 3, local_blks_hit = 6250615480, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94023082376504, shared_blk_read_time = {ticks = -7498083937324726760}, shared_blk_write_time = {ticks = 94023060213494}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94023053861009}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94023082376504}} [18:34:08.082] bufusage = {shared_blks_hit = 0, shared_blks_read = 94023056887212, shared_blks_dirtied = 73156177969152, shared_blks_written = 72057594037927936, local_blks_hit = 140259879944720, local_blks_read = 94023082377680, local_blks_dirtied = 94023082376504, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94023059741452, shared_blk_read_time = {ticks = 140259879944720}, shared_blk_write_time = {ticks = 94023059741471}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94023060122283}, temp_blk_read_time = {ticks = 94023082570608}, temp_blk_write_time = {ticks = 64}} [18:34:08.082] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140723215298256, freespace = 10} [18:34:08.082] planner_ctx = 0x0 [18:34:08.082] saved_ctx = 0x0 [18:34:08.082] #16 0x00005583729bd88c in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5583746ff6b8, pstate=pstate@entry=0x5583746ff5a8, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [18:34:08.082] No locals. [18:34:08.082] #17 0x00005583729be7e3 in ExplainQuery (pstate=pstate@entry=0x5583746ff5a8, stmt=stmt@entry=0x5583746cfb78, params=params@entry=0x0, dest=dest@entry=0x5583746ff518) at ../src/backend/commands/explain.c:357 [18:34:08.082] l__state = [18:34:08.082] l = 0x558374a19750 [18:34:08.082] es = 0x5583746ff6b8 [18:34:08.082] tstate = [18:34:08.082] jstate = [18:34:08.082] query = [18:34:08.082] rewritten = 0x558374a19738 [18:34:08.082] lc = 0x0 [18:34:08.082] timing_set = false [18:34:08.082] buffers_set = false [18:34:08.082] summary_set = false [18:34:08.082] __func__ = "ExplainQuery" [18:34:08.082] #18 0x0000558372ec4e84 in standard_ProcessUtility (pstmt=pstmt@entry=0x5583746cfc28, queryString=queryString@entry=0x5583746cea90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", readOnlyTree=readOnlyTree@entry=false, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x5583746ff518, qc=0x7ffcad4274e0) at ../src/backend/tcop/utility.c:866 [18:34:08.082] parsetree = 0x5583746cfb78 [18:34:08.082] isTopLevel = true [18:34:08.082] isAtomicContext = false [18:34:08.082] pstate = 0x5583746ff5a8 [18:34:08.082] readonly_flags = [18:34:08.082] __func__ = "standard_ProcessUtility" [18:34:08.082] #19 0x00007f90cea5dd8f in pgss_ProcessUtility (pstmt=0x5583746cfc28, queryString=0x5583746cea90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x5583746ff518, qc=0x7ffcad4274e0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [18:34:08.082] _save_exception_stack = 0x7ffcad427580 [18:34:08.082] _save_context_stack = 0x0 [18:34:08.082] _local_sigjmp_buf = {{__jmpbuf = {0, -2815890246645700277, 94023082376232, 94023082571032, 140723215299808, 1, 2815497682172389707, 2867227218680359243}, __mask_was_saved = 0, __saved_mask = {__val = {94023060122283, 94023082371472, 11, 1, 94023060126700, 1954345656, 1, 94023082371472, 10, 94023083422664, 94023083422664, 1, 94023083422664, 94023083422408, 140259952914183, 86}}}} [18:34:08.082] _do_rethrow = false [18:34:08.082] duration = [18:34:08.082] bufusage = {shared_blks_hit = 0, shared_blks_read = 94023060213903, shared_blks_dirtied = 0, shared_blks_written = 94023082378232, local_blks_hit = 94023083420520, local_blks_read = 94023083420520, local_blks_dirtied = 94023083420440, local_blks_written = 140723215299568, temp_blks_read = 140723215299568, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94023055137397}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94023082378376}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94023060122283}} [18:34:08.082] walusage_start = {wal_records = 70, wal_fpi = 18, wal_bytes = 107515} [18:34:08.082] start = [18:34:08.082] rows = [18:34:08.082] bufusage_start = {shared_blks_hit = 1456, shared_blks_read = 348, shared_blks_dirtied = 18, shared_blks_written = 65, 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}} [18:34:08.082] walusage = {wal_records = 140723215299328, wal_fpi = 94023059614671, wal_bytes = 140723215299328} [18:34:08.082] parsetree = [18:34:08.082] saved_queryId = 12487626183684739362 [18:34:08.082] saved_stmt_location = 0 [18:34:08.082] saved_stmt_len = 108 [18:34:08.082] enabled = true [18:34:08.082] #20 0x0000558372ec54f8 in ProcessUtility (pstmt=pstmt@entry=0x5583746cfc28, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5583746ff518, qc=0x7ffcad4274e0) at ../src/backend/tcop/utility.c:519 [18:34:08.082] No locals. [18:34:08.082] #21 0x0000558372ec0f6b in PortalRunUtility (portal=portal@entry=0x558374752000, pstmt=0x5583746cfc28, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5583746ff518, qc=qc@entry=0x7ffcad4274e0) at ../src/backend/tcop/pquery.c:1152 [18:34:08.082] No locals. [18:34:08.082] #22 0x0000558372ec17de in FillPortalStore (portal=portal@entry=0x558374752000, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [18:34:08.082] treceiver = 0x5583746ff518 [18:34:08.082] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:34:08.082] __func__ = "FillPortalStore" [18:34:08.082] #23 0x0000558372ec1cf9 in PortalRun (portal=portal@entry=0x558374752000, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5583747cfc38, altdest=altdest@entry=0x5583747cfc38, qc=qc@entry=0x7ffcad4276a0) at ../src/backend/tcop/pquery.c:759 [18:34:08.082] _save_exception_stack = 0x7ffcad427750 [18:34:08.082] _save_context_stack = 0x0 [18:34:08.082] _local_sigjmp_buf = {{__jmpbuf = {0, 8353361765656045899, 94023082909696, 94023082376176, 94023082376152, 94023082376104, 2815497681975257419, 8353358607899830603}, __mask_was_saved = 0, __saved_mask = {__val = {94023060126700, 2906813999, 4, 94023082376104, 112, 153, 94023082909696, 94023082376176, 94023082376152, 94023082376104, 94023060213903, 1, 2, 153, 94023049481297, 0}}}} [18:34:08.082] _do_rethrow = [18:34:08.082] result = [18:34:08.082] nprocessed = [18:34:08.082] saveTopTransactionResourceOwner = 0x5583747114d8 [18:34:08.082] saveTopTransactionContext = 0x558374764020 [18:34:08.082] saveActivePortal = 0x0 [18:34:08.082] saveResourceOwner = 0x5583747114d8 [18:34:08.082] savePortalContext = 0x0 [18:34:08.082] saveMemoryContext = 0x558374764020 [18:34:08.082] __func__ = "PortalRun" [18:34:08.082] #24 0x0000558372ebaf30 in exec_simple_query (query_string=query_string@entry=0x5583746cea90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1271 [18:34:08.082] cmdtaglen = 7 [18:34:08.082] snapshot_set = [18:34:08.082] per_parsetree_context = 0x0 [18:34:08.082] plantree_list = 0x5583747cfbe8 [18:34:08.082] parsetree = 0x5583746cfba8 [18:34:08.082] commandTag = [18:34:08.082] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:34:08.082] querytree_list = [18:34:08.082] portal = 0x558374752000 [18:34:08.082] receiver = 0x5583747cfc38 [18:34:08.082] format = 0 [18:34:08.082] cmdtagname = [18:34:08.082] parsetree_item__state = [18:34:08.082] dest = DestRemote [18:34:08.082] oldcontext = 0x558374764020 [18:34:08.082] parsetree_list = 0x5583746cfbd8 [18:34:08.082] parsetree_item = 0x5583746cfbf0 [18:34:08.082] save_log_statement_stats = false [18:34:08.082] was_logged = true [18:34:08.082] use_implicit_block = false [18:34:08.082] msec_str = "\004\000\000\000\000\000\000\0009\226\027s\203U\000\0000wB\255\374\177\000\000n\000\000\000\000\000\000" [18:34:08.082] __func__ = "exec_simple_query" [18:34:08.082] #25 0x0000558372ebdc89 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [18:34:08.082] query_string = 0x5583746cea90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [18:34:08.082] firstchar = [18:34:08.082] input_message = {data = 0x5583746cea90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", len = 110, maxlen = 1024, cursor = 110} [18:34:08.082] local_sigjmp_buf = {{__jmpbuf = {94023072815576, 8353356022340004171, 140723215300780, 4, 5, 140723215301012, 2815497682042366283, 8353358631144794443}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94023082629552, 0, 168, 94023060126802, 0, 10, 2, 94023072815584, 94023082102320, 94023072809632, 4, 5, 140723215301012}}}} [18:34:08.082] send_ready_for_query = false [18:34:08.082] idle_in_transaction_timeout_enabled = false [18:34:08.082] idle_session_timeout_enabled = false [18:34:08.082] __func__ = "PostgresMain" [18:34:08.082] #26 0x0000558372eb3cf4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:34:08.082] bsdata = [18:34:08.082] #27 0x0000558372d653e0 in postmaster_child_launch (child_type=B_BACKEND, child_slot=5, startup_data=startup_data@entry=0x7ffcad4278ac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcad427900) at ../src/backend/postmaster/launch_backend.c:274 [18:34:08.082] pid = [18:34:08.082] #28 0x0000558372d6a3db in BackendStartup (client_sock=client_sock@entry=0x7ffcad427900) at ../src/backend/postmaster/postmaster.c:3386 [18:34:08.082] bn = 0x5583746fb1b8 [18:34:08.082] pid = [18:34:08.082] startup_data = {canAcceptConnections = CAC_OK} [18:34:08.082] cac = [18:34:08.082] __func__ = "BackendStartup" [18:34:08.082] #29 0x0000558372d6c2b4 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [18:34:08.082] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "DҐ\177\000\000>\004\000\000\000\000\000\000\260\227\243А\177\000\000\240\317\373ѐ\177\000\000\270yB\255\374\177\000\000\264yB\255\374\177", '\000' , "\272d\357q\203U\000\000\220G\353q\203U\000\000\200zB\255\374\177\000\000xzB\255\374\177\000\000\225[\362\001*\221\213$\260\212ot\203U\000\000,\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [18:34:08.082] i = 0 [18:34:08.082] now = [18:34:08.082] last_lockfile_recheck_time = 1734546630 [18:34:08.082] last_touch_time = 1734546630 [18:34:08.082] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = -1388152128, user_data = 0x0}, {pos = 15, events = 0, fd = 1911514298, user_data = 0x7f90d246e668}, {pos = -779545040, events = 32656, fd = -767106336, user_data = 0x7c96e577}, {pos = -1388152064, events = 32764, fd = -767276472, user_data = 0xf}, {pos = -779545040, events = 32656, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -767106336, user_data = 0x7ffcad427a78}, {pos = -1388152192, events = 32764, fd = -767105432, user_data = 0x0}, {pos = 1953297840, events = 21891, fd = -793842331, user_data = 0x7ffcad427f93}, {pos = 1, events = 0, fd = -1388152192, user_data = 0xffffffff}, {pos = -794632160, events = 32656, fd = -772026464, user_data = 0x5583746ff698}, {pos = 1953494392, events = 21891, fd = 1953517889, user_data = 0x7f90d244aebe}, {pos = 1, events = 0, fd = -767106336, user_data = 0x1aa}, {pos = 1936690512, events = 21891, fd = 0, user_data = 0x56}, {pos = 1953485064, events = 21891, fd = -767250754, user_data = 0x1}, {pos = 0, events = 0, fd = -794632160, user_data = 0x7f90d0af2e40 }, {pos = 16, events = 0, fd = -1388151104, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f90d244d1ba}, {pos = 0, events = 0, fd = -794104412, user_data = 0x0}, {pos = 1943674240, events = 21891, fd = 2, user_data = 0x0}, {pos = 1953042128, events = 21891, fd = 1952410737, user_data = 0x160}, {pos = 1936689920, events = 21891, fd = 4, user_data = 0x2ffff00001fa0}, {pos = 1953485064, events = 21891, fd = -767250754, user_data = 0x1}, {pos = -794071289, events = 32656, fd = -794598200, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -792781728, events = 32656, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x558374690ed0}, {pos = -794068342, events = 32656, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x7f90d1892540}, {pos = -779539840, events = 32656, 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 = -792798752, events = 32656, fd = -794160786, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x248b912aa0e6fc00}, {pos = -792795680, events = 32656, fd = -328, user_data = 0x0}, {pos = 1953494072, events = 21891, fd = 1024, user_data = 0x5583746ff438}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 28284, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1953485064, user_data = 0x7f90d0af3053 }, {pos = 1953494072, events = 21891, fd = 1024, user_data = 0x7ffcad427f88}, {pos = 1931128863, events = 21891, fd = 1943738768, user_data = 0x558373199adc }, {pos = 1953493872, events = 21891, fd = 1953294736, user_data = 0x5583746ff370}, {pos = -794077333, events = 32656, fd = 0, user_data = 0x5583731ab746 }, {pos = 1953493872, events = 1, fd = 1931131023, user_data = 0x5583746ce990}, {pos = -1595474944, events = 613126442, fd = 0, user_data = 0x7f90d0aa2ab1}, {pos = -794159888, events = 32656, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1953042128, user_data = 0x248b912aa0e6fc00}, {pos = 0, events = 0, fd = -1595474944, user_data = 0xc}, {pos = -1595474944, events = 613126442, fd = 0, user_data = 0x7f90d0a5b239 }, {pos = 87, events = 0, fd = 1926648029, user_data = 0x400000}, {pos = 0, events = 0, fd = 1953042128, user_data = 0x558373199970 }, {pos = 1953128640, events = 21891, fd = 1953294736, user_data = 0x5583746a60c0}, {pos = 1, events = 0, fd = 0, user_data = 0x558373158131 }, {pos = 12, events = 0, fd = 1953481016, user_data = 0x5583746fc118}, {pos = 1943675648, events = 21891, fd = 296, user_data = 0x558372d678f7 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1926664500, events = 21891, fd = 1940096944, user_data = 0x5583746cf348}} [18:34:08.083] nevents = 1 [18:34:08.083] __func__ = "ServerLoop" [18:34:08.083] #30 0x0000558372d6db35 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55837468cd30) at ../src/backend/postmaster/postmaster.c:1371 [18:34:08.083] opt = [18:34:08.083] status = [18:34:08.083] userDoption = [18:34:08.083] listen_addr_saved = false [18:34:08.083] output_config_variable = [18:34:08.083] __func__ = "PostmasterMain" [18:34:08.083] #31 0x0000558372b9a214 in main (argc=4, argv=0x55837468cd30) at ../src/backend/main/main.c:230 [18:34:08.083] do_check_root = [18:34:08.083] dispatch_option = [18:34:08.126] -e [18:34:08.126] [18:34:08.126] [18:34:08.217] dumping /tmp/cores/postgres-6-21846.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:34:08.486] [New LWP 21846] [18:34:08.486] [18:34:08.486] This GDB supports auto-downloading debuginfo from the following URLs: [18:34:08.486] [18:34:08.486] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [18:34:08.486] Debuginfod has been disabled. [18:34:08.486] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [18:34:08.744] [Thread debugging using libthread_db enabled] [18:34:08.744] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:34:08.744] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [18:34:08.744] Program terminated with signal SIGABRT, Aborted. [18:34:08.744] #0 0x00007fb2d2aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:10.031] [18:34:10.031] Thread 1 (Thread 0x7fb2d29dbf00 (LWP 21846)): [18:34:10.031] #0 0x00007fb2d2aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:10.031] No symbol table info available. [18:34:10.031] #1 0x00007fb2d2a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:10.031] No symbol table info available. [18:34:10.031] #2 0x00007fb2d2a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:10.031] No symbol table info available. [18:34:10.031] #3 0x00007fb2d2c1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [18:34:10.031] No locals. [18:34:10.031] #4 0x00007fb2d2c2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [18:34:10.031] No locals. [18:34:10.031] #5 0x00007fb2d2c0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55560c18c8a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [18:34:10.031] bp = 140721710202240 [18:34:10.031] pc = [18:34:10.031] Opts = {FromUnrecoverableHandler = true, pc = 93828044567316, bp = 93828065824696} [18:34:10.031] #6 0x000055560b443314 in examine_self_contradictory_rels (root=root@entry=0x55560c86fde8, rel=rel@entry=0x55560c873a28, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [18:34:10.031] lc__state = [18:34:10.031] rlist = [18:34:10.031] i = 2 [18:34:10.031] br = [18:34:10.031] expression = [18:34:10.031] or_rinfo = 0x55560c889d08 [18:34:10.031] ccxt = [18:34:10.031] delidx = 0x55560c889ba1 [18:34:10.031] arglst = [18:34:10.031] lc = [18:34:10.031] arg = [18:34:10.031] n = [18:34:10.031] restrictinfo = [18:34:10.031] ccwapper = {clausecxt = 0x55560c889538} [18:34:10.031] sec = {sopcinfo = {n_members = 38, opcies = 0x55560c889008}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x55560c843588, atop_set = 0x55560c889418}, ccfree = 0x55560c889b70, vifree = 0x55560c8896a8} [18:34:10.031] __func__ = "examine_self_contradictory_rels" [18:34:10.031] #7 0x000055560b443523 in examine_self_contradictory_rels_phase1 (root=root@entry=0x55560c86fde8) at ../src/backend/optimizer/plan/contradictory.c:2608 [18:34:10.031] rel = 0x55560c873a28 [18:34:10.031] rti = 1 [18:34:10.031] rinfo = [18:34:10.031] #8 0x000055560b40e4c6 in query_planner (root=root@entry=0x55560c86fde8, qp_callback=qp_callback@entry=0x55560b4137e3 , qp_extra=qp_extra@entry=0x7ffc538c7f80) at ../src/backend/optimizer/plan/planmain.c:193 [18:34:10.031] parse = 0x55560c627d98 [18:34:10.031] joinlist = 0x55560c8435f8 [18:34:10.031] final_rel = [18:34:10.031] __func__ = "query_planner" [18:34:10.031] #9 0x000055560b420f58 in grouping_planner (root=root@entry=0x55560c86fde8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [18:34:10.031] sort_input_targets = 0x5 [18:34:10.031] sort_input_target_parallel_safe = [18:34:10.031] grouping_target = [18:34:10.031] scanjoin_target = [18:34:10.031] activeWindows = 0x0 [18:34:10.031] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [18:34:10.031] sort_input_targets_contain_srfs = 0x1 [18:34:10.031] have_grouping = [18:34:10.031] wflists = 0x0 [18:34:10.031] gset_data = 0x0 [18:34:10.031] sort_input_target = [18:34:10.031] grouping_targets = 0x1 [18:34:10.031] grouping_target_parallel_safe = [18:34:10.031] scanjoin_targets = 0x0 [18:34:10.031] scanjoin_target_parallel_safe = [18:34:10.031] grouping_targets_contain_srfs = 0x1 [18:34:10.031] scanjoin_targets_contain_srfs = 0x55560b987ef6 [18:34:10.031] scanjoin_target_same_exprs = [18:34:10.031] parse = 0x55560c627d98 [18:34:10.031] offset_est = 0 [18:34:10.031] count_est = 0 [18:34:10.031] limit_tuples = -1 [18:34:10.031] have_postponed_srfs = false [18:34:10.031] final_target = [18:34:10.031] final_targets = 0x55560c83c298 [18:34:10.031] final_targets_contain_srfs = 0x55560b37f1a8 [18:34:10.031] final_target_parallel_safe = [18:34:10.031] current_rel = [18:34:10.031] final_rel = [18:34:10.031] extra = {limit_needed = false, limit_tuples = 4.635721302869606e-310, count_est = 93828065538136, offset_est = 93828065538136} [18:34:10.031] lc = [18:34:10.031] __func__ = "grouping_planner" [18:34:10.031] #10 0x000055560b423edc in subquery_planner (glob=glob@entry=0x55560c873918, parse=parse@entry=0x55560c627d98, 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:1151 [18:34:10.031] root = 0x55560c86fde8 [18:34:10.031] newWithCheckOptions = [18:34:10.031] newHaving = 0x0 [18:34:10.031] hasOuterJoins = [18:34:10.031] hasResultRTEs = false [18:34:10.031] final_rel = [18:34:10.031] l = 0x0 [18:34:10.031] #11 0x000055560b424b6d in standard_planner (parse=0x55560c627d98, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [18:34:10.031] result = [18:34:10.031] glob = 0x55560c873918 [18:34:10.031] tuple_fraction = 0 [18:34:10.031] root = [18:34:10.031] final_rel = [18:34:10.031] best_path = [18:34:10.031] top_plan = [18:34:10.031] lp = [18:34:10.031] lr = [18:34:10.031] #12 0x000055560b425bd7 in planner (parse=parse@entry=0x55560c627d98, query_string=query_string@entry=0x55560c626af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [18:34:10.031] result = [18:34:10.031] #13 0x000055560b695464 in pg_plan_query (querytree=querytree@entry=0x55560c627d98, query_string=query_string@entry=0x55560c626af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [18:34:10.031] plan = [18:34:10.031] #14 0x000055560b1985a6 in standard_ExplainOneQuery (query=0x55560c627d98, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55560c6521b8, queryString=0x55560c626af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [18:34:10.031] plan = [18:34:10.031] planstart = [18:34:10.031] planduration = {ticks = 93828043741900} [18:34:10.031] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 93828050004972, shared_blks_dirtied = 1401717358, shared_blks_written = 3, local_blks_hit = 4294967299, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 93828063329688, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 93828050091766}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93828043739281}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 93828063329688}} [18:34:10.031] bufusage = {shared_blks_hit = 0, shared_blks_read = 93828046765484, shared_blks_dirtied = 73237782347776, shared_blks_written = 72057594037927936, local_blks_hit = 140405820264976, local_blks_read = 93828063330864, local_blks_dirtied = 93828063329688, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 93828049619724, shared_blk_read_time = {ticks = 140405820264976}, shared_blk_write_time = {ticks = 93828049619743}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93828050000555}, temp_blk_read_time = {ticks = 93828063501936}, temp_blk_write_time = {ticks = 64}} [18:34:10.031] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140721710203376, freespace = 10} [18:34:10.031] planner_ctx = 0x0 [18:34:10.031] saved_ctx = 0x0 [18:34:10.031] #15 0x000055560b19888c in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55560c6521b8, pstate=pstate@entry=0x55560c6520a8, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [18:34:10.031] No locals. [18:34:10.031] #16 0x000055560b1997e3 in ExplainQuery (pstate=pstate@entry=0x55560c6520a8, stmt=stmt@entry=0x55560c627bd8, params=params@entry=0x0, dest=dest@entry=0x55560c652018) at ../src/backend/commands/explain.c:357 [18:34:10.031] l__state = [18:34:10.031] l = 0x55560c8738e0 [18:34:10.031] es = 0x55560c6521b8 [18:34:10.031] tstate = [18:34:10.031] jstate = [18:34:10.031] query = [18:34:10.031] rewritten = 0x55560c8738c8 [18:34:10.031] lc = 0x0 [18:34:10.031] timing_set = false [18:34:10.031] buffers_set = false [18:34:10.031] summary_set = false [18:34:10.031] __func__ = "ExplainQuery" [18:34:10.031] #17 0x000055560b69fe84 in standard_ProcessUtility (pstmt=0x55560c627c88, queryString=0x55560c626af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55560c652018, qc=0x7ffc538c8470) at ../src/backend/tcop/utility.c:866 [18:34:10.031] parsetree = 0x55560c627bd8 [18:34:10.031] isTopLevel = true [18:34:10.031] isAtomicContext = false [18:34:10.031] pstate = 0x55560c6520a8 [18:34:10.031] readonly_flags = [18:34:10.031] __func__ = "standard_ProcessUtility" [18:34:10.031] #18 0x000055560b6a05ad in ProcessUtility (pstmt=pstmt@entry=0x55560c627c88, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55560c652018, qc=0x7ffc538c8470) at ../src/backend/tcop/utility.c:523 [18:34:10.031] No locals. [18:34:10.031] #19 0x000055560b69bf6b in PortalRunUtility (portal=portal@entry=0x55560c6ab100, pstmt=0x55560c627c88, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55560c652018, qc=qc@entry=0x7ffc538c8470) at ../src/backend/tcop/pquery.c:1152 [18:34:10.031] No locals. [18:34:10.031] #20 0x000055560b69c7de in FillPortalStore (portal=portal@entry=0x55560c6ab100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [18:34:10.031] treceiver = 0x55560c652018 [18:34:10.031] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:34:10.031] __func__ = "FillPortalStore" [18:34:10.031] #21 0x000055560b69ccf9 in PortalRun (portal=portal@entry=0x55560c6ab100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55560c83c6a8, altdest=altdest@entry=0x55560c83c6a8, qc=qc@entry=0x7ffc538c8630) at ../src/backend/tcop/pquery.c:759 [18:34:10.031] _save_exception_stack = 0x7ffc538c86e0 [18:34:10.031] _save_context_stack = 0x0 [18:34:10.031] _local_sigjmp_buf = {{__jmpbuf = {0, -3848728426482729946, 93828063867136, 93828063329360, 93828063329336, 93828063329288, -6934927709527311322, -3848714871797679066}, __mask_was_saved = 0, __saved_mask = {__val = {93828050004972, 1401718207, 4, 93828063329288, 112, 153, 93828063867136, 93828063329360, 93828063329336, 93828063329288, 93828050092175, 1, 2, 153, 93828039359569, 0}}}} [18:34:10.031] _do_rethrow = [18:34:10.031] result = [18:34:10.031] nprocessed = [18:34:10.031] saveTopTransactionResourceOwner = 0x55560c667db8 [18:34:10.031] saveTopTransactionContext = 0x55560c6bd530 [18:34:10.031] saveActivePortal = 0x0 [18:34:10.031] saveResourceOwner = 0x55560c667db8 [18:34:10.031] savePortalContext = 0x0 [18:34:10.031] saveMemoryContext = 0x55560c6bd530 [18:34:10.031] __func__ = "PortalRun" [18:34:10.031] #22 0x000055560b695f30 in exec_simple_query (query_string=query_string@entry=0x55560c626af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1271 [18:34:10.031] cmdtaglen = 7 [18:34:10.031] snapshot_set = [18:34:10.031] per_parsetree_context = 0x0 [18:34:10.031] plantree_list = 0x55560c83c658 [18:34:10.031] parsetree = 0x55560c627c08 [18:34:10.031] commandTag = [18:34:10.031] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:34:10.031] querytree_list = [18:34:10.031] portal = 0x55560c6ab100 [18:34:10.031] receiver = 0x55560c83c6a8 [18:34:10.031] format = 0 [18:34:10.031] cmdtagname = [18:34:10.031] parsetree_item__state = [18:34:10.031] dest = DestRemote [18:34:10.031] oldcontext = 0x55560c6bd530 [18:34:10.031] parsetree_list = 0x55560c627c38 [18:34:10.031] parsetree_item = 0x55560c627c50 [18:34:10.031] save_log_statement_stats = false [18:34:10.031] was_logged = false [18:34:10.031] use_implicit_block = false [18:34:10.031] msec_str = "\004\000\000\000\000\000\000\0009F\225\vVU\000\000\300\206\214S\374\177\000\000n\000\000\000\000\000\000" [18:34:10.031] __func__ = "exec_simple_query" [18:34:10.031] #23 0x000055560b698c89 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [18:34:10.031] query_string = 0x55560c626af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [18:34:10.031] firstchar = [18:34:10.031] input_message = {data = 0x55560c626af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", len = 110, maxlen = 1024, cursor = 110} [18:34:10.031] local_sigjmp_buf = {{__jmpbuf = {93828062693848, -3848730136121934810, 140721710204988, 4, 5, 140721710205220, -6934927709460202458, -3848714869474165722}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93828063055376, 15616, 93828062687904, 93828063587696, 5, 93828050004520, 0, 9, 2, 93828062693856, 93828063055376, 93828062687904, 4, 5, 140721710205220}}}} [18:34:10.031] send_ready_for_query = false [18:34:10.031] idle_in_transaction_timeout_enabled = false [18:34:10.031] idle_session_timeout_enabled = false [18:34:10.031] __func__ = "PostgresMain" [18:34:10.031] #24 0x000055560b68ecf4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:34:10.031] bsdata = [18:34:10.031] #25 0x000055560b5403e0 in postmaster_child_launch (child_type=B_BACKEND, child_slot=5, startup_data=startup_data@entry=0x7ffc538c883c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc538c8890) at ../src/backend/postmaster/launch_backend.c:274 [18:34:10.031] pid = [18:34:10.031] #26 0x000055560b5453db in BackendStartup (client_sock=client_sock@entry=0x7ffc538c8890) at ../src/backend/postmaster/postmaster.c:3386 [18:34:10.031] bn = 0x55560c64f128 [18:34:10.031] pid = [18:34:10.031] startup_data = {canAcceptConnections = CAC_OK} [18:34:10.031] cac = [18:34:10.031] __func__ = "BackendStartup" [18:34:10.031] #27 0x000055560b5472b4 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [18:34:10.031] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\243Ҳ\177\000\000\240O\372Ӳ\177\000\0008\211\214S\374\177\000\0004\211\214S\374\177", '\000' , "\272\024m\nVU\000\000\220\367h\nVU\000\000\000\212\214S\374\177\000\000\370\211\214S\374\177\000\000\225[\362\001\000\000\000\000\240\264\362Ӳ\177\000\000+", '\000' , "VU\000\000\310\023m\nVU\000", __ss_align = 140406041532008}, salen = 2}} [18:34:10.031] i = 0 [18:34:10.031] now = [18:34:10.031] last_lockfile_recheck_time = 1734546600 [18:34:10.031] last_touch_time = 1734546600 [18:34:10.031] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x55560a6d14ba}, {pos = -734341528, events = 32690, fd = -739068368, user_data = 0x7fb2d43ad2e0}, {pos = 2090263927, events = 0, fd = 1401719424, user_data = 0x7fb2d4383a48}, {pos = 15, events = 0, fd = -739068368, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fb2d43ad2e0}, {pos = 1401719288, events = 32764, fd = 1401719296, user_data = 0x7fb2d43ad668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 207783904, events = 21846, fd = 1, user_data = 0x7ffc538c8f23}, {pos = -1, events = 0, fd = -761077728, user_data = 0x7fb2d3fa4fa0}, {pos = 207954328, events = 21846, fd = 207954040, user_data = 0x55560c654461}, {pos = -734486850, events = 32690, fd = 1, user_data = 0x7fb2d43ad2e0}, {pos = 426, events = 0, fd = 200097104, user_data = 0x0}, {pos = 236, events = 0, fd = 207776688, user_data = 0x7fb2d4389ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fb2d2a2e020}, {pos = -760271296, events = 32690, fd = 16, user_data = 0x7ffc538c8e50}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -734477894, events = 32690, fd = 0, user_data = 0x7fb2d2aaeda4 }, {pos = 0, events = 0, fd = 207080832, user_data = 0x2}, {pos = 0, events = 0, fd = 207523504, user_data = 0x55560b62c797 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 207776688, user_data = 0x7fb2d4389ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fb2d2a364c8}, {pos = -760516857, events = 32690, fd = 207136960, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -759227296, events = 32690, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x342020200a0a3533}, {pos = 822763892, events = 892613431, fd = 808859188, 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 = 207969424, user_data = 0x7fb2d2ab576b}, {pos = -759244320, events = 32690, fd = -760606354, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xe041ca54d5ade500}, {pos = -759241248, events = 32690, fd = -328, user_data = 0x0}, {pos = 207953720, events = 21846, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 21059, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 207776688, user_data = 0x7fb2d2af3053 }, {pos = 207953720, events = 21846, fd = 1024, user_data = 0x7ffc538c8f18}, {pos = 194535455, events = 21846, fd = 207145360, user_data = 0x55560b974adc }, {pos = 207953520, events = 21846, fd = 207776240, user_data = 0x55560c651e70}, {pos = -760522901, events = 32690, fd = 0, user_data = 0x55560b986746 }, {pos = 207953520, events = 1, fd = 194537615, user_data = 0x55560c6269f0}, {pos = -710023936, events = 3762408020, fd = 0, user_data = 0x7fb2d2aa2ab1}, {pos = -760605456, events = 32690, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 207523504, user_data = 0xe041ca54d5ade500}, {pos = 0, events = 0, fd = -710023936, user_data = 0xc}, {pos = -710023936, events = 3762408020, fd = 0, user_data = 0x7fb2d2a5b239 }, {pos = 237, events = 0, fd = 190054621, user_data = 0x400000}, {pos = 0, events = 0, fd = 207523504, user_data = 0x55560b974970 }, {pos = 207610144, events = 21846, fd = 207776240, user_data = 0x55560c5fe120}, {pos = 1, events = 0, fd = 0, user_data = 0x55560b933131 }, {pos = 12, events = 0, fd = 207953096, user_data = 0x55560c651ca8}, {pos = 207082240, events = 21846, fd = 296, user_data = 0x55560b5428f7 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 190071092, events = 21846, fd = 203503536, user_data = 0x55560c6273c8}} [18:34:10.031] nevents = 1 [18:34:10.031] __func__ = "ServerLoop" [18:34:10.031] #28 0x000055560b548b35 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55560c5e4d70) at ../src/backend/postmaster/postmaster.c:1371 [18:34:10.031] opt = [18:34:10.031] status = [18:34:10.031] userDoption = [18:34:10.031] listen_addr_saved = false [18:34:10.031] output_config_variable = [18:34:10.031] __func__ = "PostmasterMain" [18:34:10.031] #29 0x000055560b375214 in main (argc=8, argv=0x55560c5e4d70) at ../src/backend/main/main.c:230 [18:34:10.031] do_check_root = [18:34:10.031] dispatch_option = [18:34:10.076] -e [18:34:10.076] [18:34:10.076] [18:34:10.149] dumping /tmp/cores/postgres-6-25813.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [18:34:10.424] [New LWP 25813] [18:34:10.424] [18:34:10.424] This GDB supports auto-downloading debuginfo from the following URLs: [18:34:10.424] [18:34:10.424] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [18:34:10.424] Debuginfod has been disabled. [18:34:10.424] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [18:34:10.529] [Thread debugging using libthread_db enabled] [18:34:10.529] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:34:10.529] Core was generated by `postgres: postgres regression [local] SELECT '. [18:34:10.529] Program terminated with signal SIGABRT, Aborted. [18:34:10.529] #0 0x00007fb2d2aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:11.650] [18:34:11.650] Thread 1 (Thread 0x7fb2d29dbf00 (LWP 25813)): [18:34:11.650] #0 0x00007fb2d2aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:11.650] No symbol table info available. [18:34:11.650] #1 0x00007fb2d2a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:11.650] No symbol table info available. [18:34:11.650] #2 0x00007fb2d2a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:11.650] No symbol table info available. [18:34:11.650] #3 0x00007fb2d2c1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [18:34:11.650] No locals. [18:34:11.650] #4 0x00007fb2d2c2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [18:34:11.650] No locals. [18:34:11.650] #5 0x00007fb2d2c0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55560c18c8a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [18:34:11.650] bp = 140721710199872 [18:34:11.650] pc = [18:34:11.650] Opts = {FromUnrecoverableHandler = true, pc = 93828044567316, bp = 93828064792136} [18:34:11.650] #6 0x000055560b443314 in examine_self_contradictory_rels (root=root@entry=0x55560c77d808, rel=rel@entry=0x55560c7c9830, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [18:34:11.650] lc__state = [18:34:11.650] rlist = [18:34:11.650] i = 3 [18:34:11.650] br = [18:34:11.650] expression = [18:34:11.650] or_rinfo = 0x55560c78dc20 [18:34:11.650] ccxt = [18:34:11.650] delidx = 0x55560c78e3a1 [18:34:11.650] arglst = [18:34:11.650] lc = [18:34:11.650] arg = [18:34:11.650] n = [18:34:11.650] restrictinfo = [18:34:11.650] ccwapper = {clausecxt = 0x55560c78d960} [18:34:11.650] sec = {sopcinfo = {n_members = 38, opcies = 0x55560c78d008}, attrsdc = {min_attr = -6, max_attr = 7, len_set = 2, atop_array = 0x55560c77f098, atop_set = 0x55560c77f628}, ccfree = 0x55560c78d930, vifree = 0x55560c78df90} [18:34:11.650] __func__ = "examine_self_contradictory_rels" [18:34:11.650] #7 0x000055560b443523 in examine_self_contradictory_rels_phase1 (root=root@entry=0x55560c77d808) at ../src/backend/optimizer/plan/contradictory.c:2608 [18:34:11.650] rel = 0x55560c7c9830 [18:34:11.650] rti = 1 [18:34:11.650] rinfo = [18:34:11.650] #8 0x000055560b40e4c6 in query_planner (root=root@entry=0x55560c77d808, qp_callback=qp_callback@entry=0x55560b4137e3 , qp_extra=qp_extra@entry=0x7ffc538c7640) at ../src/backend/optimizer/plan/planmain.c:193 [18:34:11.650] parse = 0x55560c7868e8 [18:34:11.650] joinlist = 0x55560c77f698 [18:34:11.650] final_rel = [18:34:11.650] __func__ = "query_planner" [18:34:11.650] #9 0x000055560b420f58 in grouping_planner (root=root@entry=0x55560c77d808, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [18:34:11.650] sort_input_targets = 0x55560c77e5f8 [18:34:11.650] sort_input_target_parallel_safe = [18:34:11.650] grouping_target = [18:34:11.650] scanjoin_target = [18:34:11.650] activeWindows = 0x0 [18:34:11.650] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [18:34:11.650] sort_input_targets_contain_srfs = 0x2 [18:34:11.650] have_grouping = [18:34:11.650] wflists = 0x0 [18:34:11.650] gset_data = 0x0 [18:34:11.650] sort_input_target = [18:34:11.650] grouping_targets = 0x0 [18:34:11.650] grouping_target_parallel_safe = [18:34:11.650] scanjoin_targets = 0x55560c77d808 [18:34:11.650] scanjoin_target_parallel_safe = [18:34:11.650] grouping_targets_contain_srfs = 0x55560c77e698 [18:34:11.650] scanjoin_targets_contain_srfs = 0x0 [18:34:11.650] scanjoin_target_same_exprs = [18:34:11.650] parse = 0x55560c7868e8 [18:34:11.650] offset_est = 0 [18:34:11.650] count_est = 0 [18:34:11.650] limit_tuples = -1 [18:34:11.650] have_postponed_srfs = false [18:34:11.650] final_target = [18:34:11.650] final_targets = 0x55560c781a08 [18:34:11.650] final_targets_contain_srfs = 0x55560b4626f5 [18:34:11.650] final_target_parallel_safe = [18:34:11.650] current_rel = [18:34:11.650] final_rel = [18:34:11.650] extra = {limit_needed = 200, limit_tuples = 4.6357223398415101e-310, count_est = 93828064732824, offset_est = 93828064729096} [18:34:11.650] lc = [18:34:11.650] __func__ = "grouping_planner" [18:34:11.650] #10 0x000055560b423edc in subquery_planner (glob=glob@entry=0x55560c7c9720, parse=parse@entry=0x55560c7868e8, 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:1151 [18:34:11.650] root = 0x55560c77d808 [18:34:11.650] newWithCheckOptions = [18:34:11.650] newHaving = 0x0 [18:34:11.650] hasOuterJoins = [18:34:11.650] hasResultRTEs = false [18:34:11.650] final_rel = [18:34:11.650] l = 0x0 [18:34:11.650] #11 0x000055560b424b6d in standard_planner (parse=0x55560c7868e8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [18:34:11.650] result = [18:34:11.650] glob = 0x55560c7c9720 [18:34:11.650] tuple_fraction = 0 [18:34:11.650] root = [18:34:11.650] final_rel = [18:34:11.650] best_path = [18:34:11.650] top_plan = [18:34:11.650] lp = [18:34:11.650] lr = [18:34:11.650] #12 0x000055560b425bd7 in planner (parse=parse@entry=0x55560c7868e8, query_string=query_string@entry=0x55560c7865a0 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [18:34:11.650] result = [18:34:11.650] #13 0x000055560b695464 in pg_plan_query (querytree=querytree@entry=0x55560c7868e8, query_string=query_string@entry=0x55560c7865a0 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [18:34:11.650] plan = [18:34:11.650] #14 0x000055560b1985a6 in standard_ExplainOneQuery (query=0x55560c7868e8, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55560c7c91b0, queryString=0x55560c7865a0 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [18:34:11.650] plan = [18:34:11.650] planstart = [18:34:11.650] planduration = {ticks = 93828043741900} [18:34:11.650] bufusage_start = {shared_blks_hit = 77496, shared_blks_read = 8, shared_blks_dirtied = 228, shared_blks_written = 228, 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}} [18:34:11.650] bufusage = {shared_blks_hit = 0, shared_blks_read = 93828046765484, shared_blks_dirtied = 154799211298816, shared_blks_written = 72057594037927936, local_blks_hit = 140405819668512, local_blks_read = 93828064766032, local_blks_dirtied = 93828064766184, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 93828049619724, shared_blk_read_time = {ticks = 140405819668512}, shared_blk_write_time = {ticks = 93828049619743}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93828050000555}, temp_blk_read_time = {ticks = 93828064765088}, temp_blk_write_time = {ticks = 64}} [18:34:11.650] mem_counters = {nblocks = 93828065040000, freechunks = 4294967297, totalspace = 140721710201008, freespace = 10} [18:34:11.650] planner_ctx = 0x0 [18:34:11.650] saved_ctx = 0x0 [18:34:11.650] #15 0x000055560b19888c in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55560c7c91b0, pstate=pstate@entry=0x55560c7c90a0, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [18:34:11.650] No locals. [18:34:11.650] #16 0x000055560b1997e3 in ExplainQuery (pstate=pstate@entry=0x55560c7c90a0, stmt=stmt@entry=0x55560c786790, params=params@entry=0x0, dest=dest@entry=0x55560c7c9010) at ../src/backend/commands/explain.c:357 [18:34:11.650] l__state = [18:34:11.650] l = 0x55560c7c96e8 [18:34:11.650] es = 0x55560c7c91b0 [18:34:11.650] tstate = [18:34:11.650] jstate = [18:34:11.650] query = [18:34:11.650] rewritten = 0x55560c7c96d0 [18:34:11.650] lc = 0x0 [18:34:11.650] timing_set = false [18:34:11.650] buffers_set = false [18:34:11.650] summary_set = false [18:34:11.650] __func__ = "ExplainQuery" [18:34:11.650] #17 0x000055560b69fe84 in standard_ProcessUtility (pstmt=0x55560c786680, queryString=0x55560c7865a0 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", readOnlyTree=, context=PROCESS_UTILITY_QUERY, params=0x0, queryEnv=0x0, dest=0x55560c7c9010, qc=0x7ffc538c7b30) at ../src/backend/tcop/utility.c:866 [18:34:11.650] parsetree = 0x55560c786790 [18:34:11.650] isTopLevel = false [18:34:11.650] isAtomicContext = true [18:34:11.650] pstate = 0x55560c7c90a0 [18:34:11.650] readonly_flags = [18:34:11.650] __func__ = "standard_ProcessUtility" [18:34:11.650] #18 0x000055560b6a05ad in ProcessUtility (pstmt=pstmt@entry=0x55560c786680, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_QUERY, params=, queryEnv=, dest=0x55560c7c9010, qc=0x7ffc538c7b30) at ../src/backend/tcop/utility.c:523 [18:34:11.650] No locals. [18:34:11.650] #19 0x000055560b69bf6b in PortalRunUtility (portal=portal@entry=0x55560c6ab210, pstmt=0x55560c786680, isTopLevel=isTopLevel@entry=false, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55560c7c9010, qc=qc@entry=0x7ffc538c7b30) at ../src/backend/tcop/pquery.c:1152 [18:34:11.650] No locals. [18:34:11.650] #20 0x000055560b69c7de in FillPortalStore (portal=portal@entry=0x55560c6ab210, isTopLevel=isTopLevel@entry=false) at ../src/backend/tcop/pquery.c:1025 [18:34:11.650] treceiver = 0x55560c7c9010 [18:34:11.650] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:34:11.650] __func__ = "FillPortalStore" [18:34:11.650] #21 0x000055560b69d112 in PortalRunFetch (portal=portal@entry=0x55560c6ab210, fdirection=fdirection@entry=FETCH_FORWARD, count=count@entry=10, dest=dest@entry=0x55560bebf5a0 ) at ../src/backend/tcop/pquery.c:1433 [18:34:11.650] _save_exception_stack = 0x7ffc538c80e0 [18:34:11.650] _save_context_stack = 0x7ffc538c7f50 [18:34:11.650] _local_sigjmp_buf = {{__jmpbuf = {93828055561632, -3848730287655846874, 0, 10, 140721710202736, 93828063703288, -6934927715525166042, -3848714871850370010}, __mask_was_saved = 0, __saved_mask = {__val = {187945178, 93828064765344, 93828050010691, 140721710202704, 93828043492121, 144, 140405820459975, 93828064631056, 8192, 93828064688464, 93828064631056, 93828064631056, 93828064631312, 0, 93828050002798, 0}}}} [18:34:11.650] _do_rethrow = [18:34:11.650] result = [18:34:11.650] saveActivePortal = 0x55560c6ab100 [18:34:11.650] saveResourceOwner = 0x55560c66a538 [18:34:11.650] savePortalContext = 0x55560c785050 [18:34:11.650] oldContext = 0x55560c739260 [18:34:11.650] __func__ = "PortalRunFetch" [18:34:11.650] #22 0x000055560b33d25b in _SPI_cursor_operation (portal=portal@entry=0x55560c6ab210, direction=direction@entry=FETCH_FORWARD, count=count@entry=10, dest=0x55560bebf5a0 ) at ../src/backend/executor/spi.c:3027 [18:34:11.650] nfetched = [18:34:11.650] __func__ = "_SPI_cursor_operation" [18:34:11.650] #23 0x000055560b342b4b in SPI_cursor_fetch (portal=portal@entry=0x55560c6ab210, forward=forward@entry=true, count=10) at ../src/backend/executor/spi.c:1808 [18:34:11.650] No locals. [18:34:11.650] #24 0x00007fb2c70c8ef1 in exec_for_query (estate=estate@entry=0x7ffc538c7f70, stmt=stmt@entry=0x55560c6830f8, portal=portal@entry=0x55560c6ab210, prefetch_ok=, prefetch_ok@entry=true) at ../src/pl/plpgsql/src/pl_exec.c:5887 [18:34:11.650] var = 0x55560c683148 [18:34:11.650] tuptab = [18:34:11.650] found = false [18:34:11.650] rc = 0 [18:34:11.650] previous_id = 1 [18:34:11.650] tupdescs_match = true [18:34:11.650] n = [18:34:11.650] #25 0x00007fb2c70c9afb in exec_stmt_dynfors (estate=estate@entry=0x7ffc538c7f70, stmt=stmt@entry=0x55560c6830f8) at ../src/pl/plpgsql/src/pl_exec.c:4645 [18:34:11.650] portal = 0x55560c6ab210 [18:34:11.650] rc = [18:34:11.650] #26 0x00007fb2c70c543c in exec_stmts (estate=estate@entry=0x7ffc538c7f70, stmts=0x55560c6837f8) at ../src/pl/plpgsql/src/pl_exec.c:2096 [18:34:11.650] stmt = 0x55560c6830f8 [18:34:11.650] rc = [18:34:11.650] s__state = [18:34:11.650] save_estmt = 0x55560c683848 [18:34:11.650] s = [18:34:11.650] __func__ = "exec_stmts" [18:34:11.650] #27 0x00007fb2c70c610a in exec_stmt_block (estate=estate@entry=0x7ffc538c7f70, block=block@entry=0x55560c683848) at ../src/pl/plpgsql/src/pl_exec.c:1939 [18:34:11.650] rc = -1 [18:34:11.650] i = 3 [18:34:11.650] __func__ = "exec_stmt_block" [18:34:11.650] #28 0x00007fb2c70c6251 in exec_toplevel_block (estate=estate@entry=0x7ffc538c7f70, block=0x55560c683848) at ../src/pl/plpgsql/src/pl_exec.c:1630 [18:34:11.650] rc = [18:34:11.650] #29 0x00007fb2c70c6986 in plpgsql_exec_function (func=func@entry=0x55560c66a128, fcinfo=fcinfo@entry=0x55560c683cd0, simple_eval_estate=simple_eval_estate@entry=0x0, simple_eval_resowner=simple_eval_resowner@entry=0x0, procedure_resowner=procedure_resowner@entry=0x0, atomic=) at ../src/pl/plpgsql/src/pl_exec.c:619 [18:34:11.650] estate = {func = 0x55560c66a128, trigdata = 0x0, evtrigdata = 0x0, retval = 0, retisnull = true, rettype = 0, fn_rettype = 2249, retistuple = true, retisset = true, readonly_func = false, atomic = true, exitlabel = 0x0, cur_error = 0x0, tuple_store = 0x0, tuple_store_desc = 0x0, tuple_store_cxt = 0x55560c74ad70, tuple_store_owner = 0x55560c66a538, rsi = 0x7ffc538c8220, found_varno = 4, ndatums = 9, datums = 0x55560c752ec0, datum_context = 0x55560c752d70, paramLI = 0x55560c752e70, simple_eval_estate = 0x55560c756e90, simple_eval_resowner = 0x55560c6685a8, procedure_resowner = 0x0, cast_hash = 0x55560c767a20, stmt_mcontext = 0x55560c765910, stmt_mcontext_parent = 0x55560c752d70, eval_tuptable = 0x0, eval_processed = 0, eval_econtext = 0x55560c7570a0, err_stmt = 0x55560c6830f8, err_var = 0x0, err_text = 0x0, plugin_info = 0x0} [18:34:11.650] plerrcontext = {previous = 0x0, callback = 0x7fb2c70c3625 , arg = 0x7ffc538c7f70} [18:34:11.650] i = 1 [18:34:11.650] rc = [18:34:11.650] __func__ = "plpgsql_exec_function" [18:34:11.650] #30 0x00007fb2c70cfc9b in plpgsql_call_handler (fcinfo=0x55560c683cd0) at ../src/pl/plpgsql/src/pl_handler.c:276 [18:34:11.650] _save_exception_stack = 0x7ffc538c8510 [18:34:11.650] _save_context_stack = 0x0 [18:34:11.650] _local_sigjmp_buf = {{__jmpbuf = {93828063600936, 6934005092276141094, 0, 93828064522920, 1, 93828064525376, -6934927709386802138, -6962838814061069274}, __mask_was_saved = 0, __saved_mask = {__val = {93828063706360, 0, 0, 0, 93828042714667, 93828063706320, 93828064524552, 32, 93828042917369, 93828064524968, 93828064522920, 93828063706064, 93828063706320, 93828063706064, 93828043111364, 93828063706320}}}} [18:34:11.650] _do_rethrow = false [18:34:11.650] nonatomic = false [18:34:11.650] func = 0x55560c66a128 [18:34:11.650] save_cur_estate = 0x0 [18:34:11.650] procedure_resowner = 0x0 [18:34:11.650] retval = 0 [18:34:11.650] rc = [18:34:11.650] __func__ = "plpgsql_call_handler" [18:34:11.650] #31 0x000055560b2b1ce0 in ExecMakeTableFunctionResult (setexpr=0x55560c74b3d8, econtext=0x55560c74b2a8, argContext=, expectedDesc=0x55560c74bc40, randomAccess=false) at ../src/backend/executor/execSRF.c:234 [18:34:11.650] result = 140405820764488 [18:34:11.650] tupstore = 0x0 [18:34:11.650] tupdesc = 0x0 [18:34:11.650] funcrettype = 2249 [18:34:11.650] returnsTuple = [18:34:11.650] returnsSet = true [18:34:11.650] fcinfo = 0x55560c683cd0 [18:34:11.650] fcusage = {fs = 0x0, save_f_total_time = {ticks = 93828049473134}, save_total = {ticks = 140405820764528}, start = {ticks = 140405820764528}} [18:34:11.650] rsinfo = {type = T_ReturnSetInfo, econtext = 0x55560c74b2a8, expectedDesc = 0x55560c74bc40, allowedModes = 11, returnMode = SFRM_ValuePerCall, isDone = ExprSingleResult, setResult = 0x0, setDesc = 0x0} [18:34:11.650] tmptup = {t_len = 208977984, t_self = {ip_blkid = {bi_hi = 21846, bi_lo = 0}, ip_posid = 0}, t_tableOid = 0, t_data = 0x2} [18:34:11.650] callerContext = 0x55560c74ad70 [18:34:11.650] first_time = true [18:34:11.650] __func__ = "ExecMakeTableFunctionResult" [18:34:11.650] #32 0x000055560b2dfeed in FunctionNext (node=0x55560c74b098) at ../src/backend/executor/nodeFunctionscan.c:94 [18:34:11.650] tstore = 0x0 [18:34:11.650] estate = [18:34:11.650] direction = ForwardScanDirection [18:34:11.650] scanslot = 0x55560c74be60 [18:34:11.650] alldone = [18:34:11.650] oldpos = [18:34:11.650] funcno = [18:34:11.650] att = [18:34:11.650] #33 0x000055560b2b3640 in ExecScanFetch (node=node@entry=0x55560c74b098, accessMtd=accessMtd@entry=0x55560b2dfcb8 , recheckMtd=recheckMtd@entry=0x55560b2dfbc4 ) at ../src/backend/executor/execScan.c:131 [18:34:11.650] estate = [18:34:11.650] #34 0x000055560b2b374a in ExecScan (node=0x55560c74b098, accessMtd=accessMtd@entry=0x55560b2dfcb8 , recheckMtd=recheckMtd@entry=0x55560b2dfbc4 ) at ../src/backend/executor/execScan.c:180 [18:34:11.650] econtext = 0x55560c74b2a8 [18:34:11.650] qual = 0x0 [18:34:11.650] projInfo = 0x0 [18:34:11.650] #35 0x000055560b2dfc3c in ExecFunctionScan (pstate=) at ../src/backend/executor/nodeFunctionscan.c:269 [18:34:11.650] node = [18:34:11.650] #36 0x000055560b2ac370 in ExecProcNodeFirst (node=0x55560c74b098) at ../src/backend/executor/execProcnode.c:469 [18:34:11.650] No locals. [18:34:11.650] #37 0x000055560b2977e2 in ExecProcNode (node=node@entry=0x55560c74b098) at ../src/include/executor/executor.h:278 [18:34:11.650] No locals. [18:34:11.650] #38 0x000055560b2986a0 in ExecutePlan (queryDesc=queryDesc@entry=0x55560c785150, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x55560c7bd570) at ../src/backend/executor/execMain.c:1655 [18:34:11.650] estate = 0x55560c74ae70 [18:34:11.650] planstate = 0x55560c74b098 [18:34:11.650] use_parallel_mode = false [18:34:11.650] slot = [18:34:11.650] current_tuple_count = 0 [18:34:11.650] #39 0x000055560b2998ac in standard_ExecutorRun (queryDesc=0x55560c785150, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:363 [18:34:11.650] estate = 0x55560c74ae70 [18:34:11.650] operation = CMD_SELECT [18:34:11.650] dest = 0x55560c7bd570 [18:34:11.650] sendTuples = [18:34:11.650] oldcontext = 0x55560c785050 [18:34:11.650] #40 0x000055560b29990c in ExecutorRun (queryDesc=queryDesc@entry=0x55560c785150, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:300 [18:34:11.650] No locals. [18:34:11.650] #41 0x000055560b699868 in PortalRunSelect (portal=portal@entry=0x55560c6ab100, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55560c7bd570) at ../src/backend/tcop/pquery.c:920 [18:34:11.650] queryDesc = 0x55560c785150 [18:34:11.650] direction = [18:34:11.650] nprocessed = [18:34:11.650] __func__ = "PortalRunSelect" [18:34:11.650] #42 0x000055560b69cc30 in PortalRun (portal=portal@entry=0x55560c6ab100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55560c7bd570, altdest=altdest@entry=0x55560c7bd570, qc=qc@entry=0x7ffc538c8630) at ../src/backend/tcop/pquery.c:764 [18:34:11.650] _save_exception_stack = 0x7ffc538c86e0 [18:34:11.650] _save_context_stack = 0x0 [18:34:11.650] _local_sigjmp_buf = {{__jmpbuf = {0, -3848730419973555162, 93828063867136, 93828063329080, 93828063329056, 93828063329008, -6934927709527311322, -3848714871797679066}, __mask_was_saved = 0, __saved_mask = {__val = {93828050004972, 1401718207, 4, 93828063329008, 112, 179, 93828063867136, 93828063329080, 93828063329056, 93828063329008, 93828050092175, 1, 2, 179, 93828039359569, 0}}}} [18:34:11.650] _do_rethrow = [18:34:11.650] result = [18:34:11.650] nprocessed = [18:34:11.650] saveTopTransactionResourceOwner = 0x55560c667db8 [18:34:11.650] saveTopTransactionContext = 0x55560c6bd530 [18:34:11.650] saveActivePortal = 0x0 [18:34:11.650] saveResourceOwner = 0x55560c667db8 [18:34:11.650] savePortalContext = 0x0 [18:34:11.650] saveMemoryContext = 0x55560c6bd530 [18:34:11.650] __func__ = "PortalRun" [18:34:11.650] #43 0x000055560b695f30 in exec_simple_query (query_string=query_string@entry=0x55560c626af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');") at ../src/backend/tcop/postgres.c:1271 [18:34:11.650] cmdtaglen = 6 [18:34:11.650] snapshot_set = [18:34:11.650] per_parsetree_context = 0x0 [18:34:11.650] plantree_list = 0x55560c7bd520 [18:34:11.650] parsetree = 0x55560c627af0 [18:34:11.650] commandTag = [18:34:11.650] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [18:34:11.650] querytree_list = [18:34:11.650] portal = 0x55560c6ab100 [18:34:11.650] receiver = 0x55560c7bd570 [18:34:11.650] format = 0 [18:34:11.650] cmdtagname = [18:34:11.650] parsetree_item__state = [18:34:11.650] dest = DestRemote [18:34:11.650] oldcontext = 0x55560c6bd530 [18:34:11.650] parsetree_list = 0x55560c627b20 [18:34:11.650] parsetree_item = 0x55560c627b38 [18:34:11.650] save_log_statement_stats = false [18:34:11.650] was_logged = false [18:34:11.650] use_implicit_block = false [18:34:11.650] msec_str = "\004\000\000\000\000\000\000\0009F\225\vVU\000\000\300\206\214S\374\177\000\000x\000\000\000\000\000\000" [18:34:11.650] __func__ = "exec_simple_query" [18:34:11.650] #44 0x000055560b698c89 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [18:34:11.650] query_string = 0x55560c626af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');" [18:34:11.650] firstchar = [18:34:11.650] input_message = {data = 0x55560c626af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');", len = 120, maxlen = 1024, cursor = 120} [18:34:11.650] local_sigjmp_buf = {{__jmpbuf = {93828062693848, -3848730136121934810, 140721710204988, 4, 14, 140721710205220, -6934927709460202458, -3848714869474165722}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93828063055376, 15616, 93828062687904, 93828063587696, 14, 93828050004520, 0, 9, 2, 93828062693856, 93828063055376, 93828062687904, 4, 14, 140721710205220}}}} [18:34:11.650] send_ready_for_query = false [18:34:11.650] idle_in_transaction_timeout_enabled = false [18:34:11.650] idle_session_timeout_enabled = false [18:34:11.650] __func__ = "PostgresMain" [18:34:11.650] #45 0x000055560b68ecf4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:34:11.650] bsdata = [18:34:11.650] #46 0x000055560b5403e0 in postmaster_child_launch (child_type=B_BACKEND, child_slot=14, startup_data=startup_data@entry=0x7ffc538c883c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc538c8890) at ../src/backend/postmaster/launch_backend.c:274 [18:34:11.650] pid = [18:34:11.650] #47 0x000055560b5453db in BackendStartup (client_sock=client_sock@entry=0x7ffc538c8890) at ../src/backend/postmaster/postmaster.c:3386 [18:34:11.650] bn = 0x55560c64f2d8 [18:34:11.650] pid = [18:34:11.650] startup_data = {canAcceptConnections = CAC_OK} [18:34:11.650] cac = [18:34:11.650] __func__ = "BackendStartup" [18:34:11.650] #48 0x000055560b5472b4 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [18:34:11.650] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\243Ҳ\177\000\000\240O\372Ӳ\177\000\0008\211\214S\374\177\000\0004\211\214S\374\177", '\000' , "\272\024m\nVU\000\000\220\367h\nVU\000\000\000\212\214S\374\177\000\000\370\211\214S\374\177\000\000\225[\362\001\000\000\000\000\240\264\362Ӳ\177\000\000+", '\000' , "VU\000\000\310\023m\nVU\000", __ss_align = 140406041532008}, salen = 2}} [18:34:11.650] i = 0 [18:34:11.650] now = [18:34:11.650] last_lockfile_recheck_time = 1734546600 [18:34:11.650] last_touch_time = 1734546600 [18:34:11.650] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x55560a6d14ba}, {pos = -734341528, events = 32690, fd = -739068368, user_data = 0x7fb2d43ad2e0}, {pos = 2090263927, events = 0, fd = 1401719424, user_data = 0x7fb2d4383a48}, {pos = 15, events = 0, fd = -739068368, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fb2d43ad2e0}, {pos = 1401719288, events = 32764, fd = 1401719296, user_data = 0x7fb2d43ad668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 207783904, events = 21846, fd = 1, user_data = 0x7ffc538c8f23}, {pos = -1, events = 0, fd = -761077728, user_data = 0x7fb2d3fa4fa0}, {pos = 207954328, events = 21846, fd = 207954040, user_data = 0x55560c654461}, {pos = -734486850, events = 32690, fd = 1, user_data = 0x7fb2d43ad2e0}, {pos = 426, events = 0, fd = 200097104, user_data = 0x0}, {pos = 236, events = 0, fd = 207776688, user_data = 0x7fb2d4389ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fb2d2a2e020}, {pos = -760271296, events = 32690, fd = 16, user_data = 0x7ffc538c8e50}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -734477894, events = 32690, fd = 0, user_data = 0x7fb2d2aaeda4 }, {pos = 0, events = 0, fd = 207080832, user_data = 0x2}, {pos = 0, events = 0, fd = 207523504, user_data = 0x55560b62c797 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 207776688, user_data = 0x7fb2d4389ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7fb2d2a364c8}, {pos = -760516857, events = 32690, fd = 207136960, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -759227296, events = 32690, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x342020200a0a3533}, {pos = 822763892, events = 892613431, fd = 808859188, 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 = 207969424, user_data = 0x7fb2d2ab576b}, {pos = -759244320, events = 32690, fd = -760606354, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xe041ca54d5ade500}, {pos = -759241248, events = 32690, fd = -328, user_data = 0x0}, {pos = 207953720, events = 21846, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 21059, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 207776688, user_data = 0x7fb2d2af3053 }, {pos = 207953720, events = 21846, fd = 1024, user_data = 0x7ffc538c8f18}, {pos = 194535455, events = 21846, fd = 207145360, user_data = 0x55560b974adc }, {pos = 207953520, events = 21846, fd = 207776240, user_data = 0x55560c651e70}, {pos = -760522901, events = 32690, fd = 0, user_data = 0x55560b986746 }, {pos = 207953520, events = 1, fd = 194537615, user_data = 0x55560c6269f0}, {pos = -710023936, events = 3762408020, fd = 0, user_data = 0x7fb2d2aa2ab1}, {pos = -760605456, events = 32690, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 207523504, user_data = 0xe041ca54d5ade500}, {pos = 0, events = 0, fd = -710023936, user_data = 0xc}, {pos = -710023936, events = 3762408020, fd = 0, user_data = 0x7fb2d2a5b239 }, {pos = 237, events = 0, fd = 190054621, user_data = 0x400000}, {pos = 0, events = 0, fd = 207523504, user_data = 0x55560b974970 }, {pos = 207610144, events = 21846, fd = 207776240, user_data = 0x55560c5fe120}, {pos = 1, events = 0, fd = 0, user_data = 0x55560b933131 }, {pos = 12, events = 0, fd = 207953096, user_data = 0x55560c651ca8}, {pos = 207082240, events = 21846, fd = 296, user_data = 0x55560b5428f7 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 190071092, events = 21846, fd = 203503536, user_data = 0x55560c6273c8}} [18:34:11.650] nevents = 1 [18:34:11.650] __func__ = "ServerLoop" [18:34:11.650] #49 0x000055560b548b35 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55560c5e4d70) at ../src/backend/postmaster/postmaster.c:1371 [18:34:11.650] opt = [18:34:11.650] status = [18:34:11.650] userDoption = [18:34:11.650] listen_addr_saved = false [18:34:11.650] output_config_variable = [18:34:11.650] __func__ = "PostmasterMain" [18:34:11.650] #50 0x000055560b375214 in main (argc=8, argv=0x55560c5e4d70) at ../src/backend/main/main.c:230 [18:34:11.650] do_check_root = [18:34:11.650] dispatch_option = [18:34:11.691] -e [18:34:11.691] [18:34:11.691] [18:34:11.760] dumping /tmp/cores/postgres-6-39683.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [18:34:12.032] [New LWP 39683] [18:34:12.032] [18:34:12.032] This GDB supports auto-downloading debuginfo from the following URLs: [18:34:12.032] [18:34:12.032] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [18:34:12.032] Debuginfod has been disabled. [18:34:12.032] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [18:34:12.135] [Thread debugging using libthread_db enabled] [18:34:12.135] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [18:34:12.135] Core was generated by `postgres: test: postgres db2 [local] SELECT '. [18:34:12.135] Program terminated with signal SIGABRT, Aborted. [18:34:12.135] #0 0x00007fc6a36a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:12.193] [18:34:12.193] Thread 1 (Thread 0x7fc6a33e7f00 (LWP 39683)): [18:34:12.193] #0 0x00007fc6a36a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:12.193] No symbol table info available. [18:34:12.193] #1 0x00007fc6a365afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:12.193] No symbol table info available. [18:34:12.193] #2 0x00007fc6a3645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [18:34:12.193] No symbol table info available. [18:34:12.193] #3 0x00007fc6a381e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [18:34:12.193] No locals. [18:34:12.193] #4 0x00007fc6a382aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [18:34:12.193] No locals. [18:34:12.193] #5 0x00007fc6a380dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55bf5c67b8a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [18:34:12.193] bp = 140727709146768 [18:34:12.193] pc = [18:34:12.193] Opts = {FromUnrecoverableHandler = true, pc = 94280363483924, bp = 140490925358248} [18:34:12.193] #6 0x000055bf5b932314 in examine_self_contradictory_rels (root=root@entry=0x55bf5ec2bf28, rel=rel@entry=0x55bf5ec35c18, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [18:34:12.193] lc__state = [18:34:12.193] rlist = [18:34:12.193] i = 7 [18:34:12.193] br = [18:34:12.193] expression = [18:34:12.193] or_rinfo = 0x7fc697b34d38 [18:34:12.193] ccxt = [18:34:12.193] delidx = 0x7fc697b37e91 [18:34:12.193] arglst = [18:34:12.193] lc = [18:34:12.193] arg = [18:34:12.193] n = [18:34:12.193] restrictinfo = [18:34:12.193] ccwapper = {clausecxt = 0x7fc697b35b28} [18:34:12.193] sec = {sopcinfo = {n_members = 38, opcies = 0x7fc697b352c8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7fc697b356d8, atop_set = 0x7fc697b33398}, ccfree = 0x7fc697b37e60, vifree = 0x7fc697b36d78} [18:34:12.193] __func__ = "examine_self_contradictory_rels" [18:34:12.193] #7 0x000055bf5b932523 in examine_self_contradictory_rels_phase1 (root=root@entry=0x55bf5ec2bf28) at ../src/backend/optimizer/plan/contradictory.c:2608 [18:34:12.193] rel = 0x55bf5ec35c18 [18:34:12.193] rti = 1 [18:34:12.193] rinfo = [18:34:12.193] #8 0x000055bf5b8fd4c6 in query_planner (root=root@entry=0x55bf5ec2bf28, qp_callback=qp_callback@entry=0x55bf5b9027e3 , qp_extra=qp_extra@entry=0x7ffdb91d2090) at ../src/backend/optimizer/plan/planmain.c:193 [18:34:12.193] parse = 0x55bf5ec22720 [18:34:12.193] joinlist = 0x7fc697b33528 [18:34:12.193] final_rel = [18:34:12.193] __func__ = "query_planner" [18:34:12.193] #9 0x000055bf5b90ff58 in grouping_planner (root=root@entry=0x55bf5ec2bf28, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [18:34:12.193] sort_input_targets = 0x55bf5ec2bf28 [18:34:12.193] sort_input_target_parallel_safe = [18:34:12.193] grouping_target = [18:34:12.193] scanjoin_target = [18:34:12.193] activeWindows = 0x0 [18:34:12.193] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [18:34:12.193] sort_input_targets_contain_srfs = 0x55bf5ec29720 [18:34:12.193] have_grouping = [18:34:12.193] wflists = 0x0 [18:34:12.193] gset_data = 0x0 [18:34:12.193] sort_input_target = [18:34:12.193] grouping_targets = 0x55bf5ec29768 [18:34:12.193] grouping_target_parallel_safe = [18:34:12.193] scanjoin_targets = 0x55bf5ec29750 [18:34:12.193] scanjoin_target_parallel_safe = [18:34:12.193] grouping_targets_contain_srfs = 0x55bf5ec2bf28 [18:34:12.193] scanjoin_targets_contain_srfs = 0x0 [18:34:12.193] scanjoin_target_same_exprs = [18:34:12.193] parse = 0x55bf5ec22720 [18:34:12.193] offset_est = 0 [18:34:12.193] count_est = 0 [18:34:12.193] limit_tuples = -1 [18:34:12.193] have_postponed_srfs = false [18:34:12.193] final_target = [18:34:12.193] final_targets = 0x55bf5ec2bf28 [18:34:12.193] final_targets_contain_srfs = 0x7 [18:34:12.193] final_target_parallel_safe = [18:34:12.193] current_rel = [18:34:12.193] final_rel = [18:34:12.193] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94280416896800} [18:34:12.193] lc = [18:34:12.193] __func__ = "grouping_planner" [18:34:12.193] #10 0x000055bf5b912edc in subquery_planner (glob=, parse=0x55bf5ec22720, parent_root=parent_root@entry=0x55bf5ec1f8e0, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [18:34:12.193] root = 0x55bf5ec2bf28 [18:34:12.193] newWithCheckOptions = [18:34:12.193] newHaving = 0x0 [18:34:12.193] hasOuterJoins = [18:34:12.193] hasResultRTEs = true [18:34:12.193] final_rel = [18:34:12.193] l = 0x0 [18:34:12.193] #11 0x000055bf5b924876 in SS_process_ctes (root=root@entry=0x55bf5ec1f8e0) at ../src/backend/optimizer/plan/subselect.c:966 [18:34:12.193] subquery = [18:34:12.193] cte = 0x55bf5ebe5490 [18:34:12.193] cmdType = [18:34:12.193] subroot = [18:34:12.193] final_rel = [18:34:12.193] best_path = [18:34:12.193] plan = [18:34:12.193] splan = [18:34:12.193] paramid = [18:34:12.193] lc__state = [18:34:12.193] lc = [18:34:12.193] __func__ = "SS_process_ctes" [18:34:12.193] #12 0x000055bf5b911980 in subquery_planner (glob=glob@entry=0x55bf5ebfa6e8, parse=parse@entry=0x55bf5ebfa7f8, 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:704 [18:34:12.193] root = 0x55bf5ec1f8e0 [18:34:12.193] newWithCheckOptions = [18:34:12.193] newHaving = [18:34:12.193] hasOuterJoins = [18:34:12.193] hasResultRTEs = [18:34:12.193] final_rel = [18:34:12.193] l = [18:34:12.193] #13 0x000055bf5b913b6d in standard_planner (parse=0x55bf5ebfa7f8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [18:34:12.193] result = [18:34:12.193] glob = 0x55bf5ebfa6e8 [18:34:12.193] tuple_fraction = 0 [18:34:12.193] root = [18:34:12.193] final_rel = [18:34:12.193] best_path = [18:34:12.193] top_plan = [18:34:12.193] lp = [18:34:12.193] lr = [18:34:12.193] #14 0x000055bf5b914bd7 in planner (parse=parse@entry=0x55bf5ebfa7f8, query_string=query_string@entry=0x55bf5eb0a5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [18:34:12.193] result = [18:34:12.193] #15 0x000055bf5bb84464 in pg_plan_query (querytree=querytree@entry=0x55bf5ebfa7f8, query_string=query_string@entry=0x55bf5eb0a5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [18:34:12.193] plan = [18:34:12.193] #16 0x000055bf5bb84845 in pg_plan_queries (querytrees=0x55bf5ec1f890, query_string=query_string@entry=0x55bf5eb0a5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:993 [18:34:12.193] query = 0x55bf5ebfa7f8 [18:34:12.193] stmt = [18:34:12.193] query_list__state = [18:34:12.193] stmt_list = 0x0 [18:34:12.193] query_list = [18:34:12.193] #17 0x000055bf5bb84df2 in exec_simple_query (query_string=query_string@entry=0x55bf5eb0a5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "...) at ../src/backend/tcop/postgres.c:1190 [18:34:12.193] cmdtaglen = 6 [18:34:12.193] snapshot_set = true [18:34:12.193] per_parsetree_context = 0x0 [18:34:12.193] plantree_list = [18:34:12.193] parsetree = 0x55bf5ebfa668 [18:34:12.193] commandTag = CMDTAG_SELECT [18:34:12.193] qc = {commandTag = 1935, nprocessed = 94280415749536} [18:34:12.193] querytree_list = [18:34:12.193] portal = [18:34:12.193] receiver = [18:34:12.193] format = 0 [18:34:12.193] cmdtagname = [18:34:12.193] parsetree_item__state = [18:34:12.193] dest = DestRemote [18:34:12.193] oldcontext = 0x55bf5eb99f40 [18:34:12.193] parsetree_list = 0x55bf5ebfa698 [18:34:12.193] parsetree_item = 0x55bf5ebfa6b0 [18:34:12.193] save_log_statement_stats = false [18:34:12.193] was_logged = true [18:34:12.193] use_implicit_block = false [18:34:12.193] msec_str = "\004\000\000\000\000\000\000\00096\344[\277U\000\000`$\035\271\375\177\000\000\217\a\000\000\000\000\000" [18:34:12.193] __func__ = "exec_simple_query" [18:34:12.193] #18 0x000055bf5bb87c89 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [18:34:12.193] query_string = 0x55bf5eb0a5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "... [18:34:12.193] firstchar = [18:34:12.193] input_message = {data = 0x55bf5eb0a5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., len = 1935, maxlen = 2048, cursor = 1935} [18:34:12.193] local_sigjmp_buf = {{__jmpbuf = {94280381610456, -9023738872078331252, 140727709148636, 4, 1, 140727709148868, -3008133817742191988, -9023749715178220916}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94280415477200, 14336, 94280381604512, 94280415984720, 1, 94280368921128, 0, 9, 2, 94280381610464, 94280415477200, 94280381604512, 4, 1, 140727709148868}}}} [18:34:12.193] send_ready_for_query = false [18:34:12.193] idle_in_transaction_timeout_enabled = false [18:34:12.193] idle_session_timeout_enabled = false [18:34:12.193] __func__ = "PostgresMain" [18:34:12.193] #19 0x000055bf5bb7dcf4 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [18:34:12.193] bsdata = [18:34:12.193] #20 0x000055bf5ba2f3e0 in postmaster_child_launch (child_type=B_BACKEND, child_slot=1, startup_data=startup_data@entry=0x7ffdb91d25dc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffdb91d2630) at ../src/backend/postmaster/launch_backend.c:274 [18:34:12.193] pid = [18:34:12.193] #21 0x000055bf5ba343db in BackendStartup (client_sock=client_sock@entry=0x7ffdb91d2630) at ../src/backend/postmaster/postmaster.c:3386 [18:34:12.193] bn = 0x55bf5eb315c8 [18:34:12.193] pid = [18:34:12.193] startup_data = {canAcceptConnections = CAC_OK} [18:34:12.193] cac = [18:34:12.193] __func__ = "BackendStartup" [18:34:12.193] #22 0x000055bf5ba362b4 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [18:34:12.193] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\272\004\274Z\277U\000\000\220\347\267Z\277U\000\000\200'\035\271\375\177\000\000x'\035\271\375\177\000\000\225[\362\001\000\000\000\000\240\324\343\243\306\177\000\000+", '\000' , "\375\177\000\000\000\004\000\000\000\000\000\000h\026\352\244\306\177\000\0000\326\343\243\306\177\000\000\340\022\352\244\306\177\000\000\316)fR\000\000\000", __ss_align = 3105695680}, salen = 2}} [18:34:12.193] i = 0 [18:34:12.193] now = [18:34:12.193] last_lockfile_recheck_time = 1734546678 [18:34:12.193] last_touch_time = 1734546678 [18:34:12.193] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1545349584, events = 32710, fd = -1528163616, user_data = 0x7c96e577}, {pos = -1189271552, events = 32765, fd = -1528333752, user_data = 0xf}, {pos = -1545349584, events = 32710, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1528163616, user_data = 0x7ffdb91d2778}, {pos = -1189271680, events = 32765, fd = -1528162712, user_data = 0x0}, {pos = 1588640288, events = 21951, fd = -1553237366, user_data = 0x55bf5eb0ba20}, {pos = 1, events = 21951, fd = 32768, user_data = 0xffffffff}, {pos = -1553801184, events = 32710, fd = -1531773024, user_data = 0x55bf5eb35358}, {pos = 1588810296, events = 21951, fd = 1588807681, user_data = 0x7fc6a4e7debe}, {pos = 1, events = 0, fd = -1528163616, user_data = 0x1aa}, {pos = 1547447632, events = 21951, fd = 0, user_data = 0xd8}, {pos = 1588640288, events = 21951, fd = -1528308034, user_data = 0x1}, {pos = 0, events = 0, fd = -1553801184, user_data = 0x7fc6a36f2e40 }, {pos = 16, events = 0, fd = -1189270544, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fc6a4e801ba}, {pos = 0, events = 0, fd = -1553273436, user_data = 0x0}, {pos = 1554431360, events = 21951, fd = 2, user_data = 0x0}, {pos = 1588379248, events = 21951, fd = 1538354121, user_data = 0x55bf5eb3cb00}, {pos = 1538358110, events = 21951, fd = 1588841307, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -1553767224, user_data = 0x7fc6a369c880 }, {pos = -1556185672, events = 32710, fd = -1189270352, user_data = 0x100007f00000002}, {pos = -1553240313, events = 32710, fd = 2, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -1551950752, events = 32710, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1213561443, events = 1699240015, fd = 168450615, user_data = 0x74616467702f6174}, {pos = 925960801, events = 875902003, fd = 1751342899, user_data = 0x305f742f61746164}, {pos = 1684826485, events = 1769300527, fd = 1949262956, user_data = 0x0}, {pos = 0, events = 21760, 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 = 1588814496, events = 21951, fd = -1553237366, user_data = 0xa}, {pos = 1541802667, events = 21951, fd = 1588822720, user_data = 0x7fc6a36b58be}, {pos = -1551967776, events = 32710, fd = -1553329810, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x6c4e59ae5b427c00}, {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 = 0x55bf5eb35030}, {pos = 1, events = 0, fd = 1588809976, user_data = 0x3}, {pos = 0, events = 0, fd = 39124, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1588640288, user_data = 0x7fc6a36f3053 }, {pos = 1588809976, events = 21951, fd = 1024, user_data = 0x7ffdb91d2cb8}, {pos = 1541885983, events = 21951, fd = 1554495888, user_data = 0x55bf5be63adc }, {pos = 1588809776, events = 21951, fd = 1588632704, user_data = 0x55bf5eb35030}, {pos = -1553246357, events = 32710, fd = 0, user_data = 0x55bf5be75746 }, {pos = 1588809776, events = 1, fd = 1541888143, user_data = 0x55bf5eb09c80}, {pos = 1531083776, events = 1817074094, fd = 0, user_data = 0x7fc6a36a2ab1}, {pos = -1553328912, events = 32710, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1588379248, user_data = 0x6c4e59ae5b427c00}, {pos = 0, events = 0, fd = 1531083776, user_data = 0xc}, {pos = 1531083776, events = 1817074094, fd = 0, user_data = 0x7fc6a365b239 }, {pos = 217, events = 0, fd = 1537405149, user_data = 0x400000}, {pos = 0, events = 0, fd = 1588379248, user_data = 0x55bf5be63970 }, {pos = 1588466608, events = 21951, fd = 1588632704, user_data = 0x55bf5eae13b0}, {pos = 1, events = 0, fd = 0, user_data = 0x55bf5be22131 }, {pos = 12, events = 0, fd = 1588805224, user_data = 0x55bf5eb33e48}, {pos = 1554432768, events = 21951, fd = 296, user_data = 0x55bf5ba318f7 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1537421620, events = 21951, fd = 1550854064, user_data = 0x55bf5eb0a638}} [18:34:12.193] nevents = 1 [18:34:12.193] __func__ = "ServerLoop" [18:34:12.193] #23 0x000055bf5ba37b35 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55bf5eac7ce0) at ../src/backend/postmaster/postmaster.c:1371 [18:34:12.193] opt = [18:34:12.193] status = [18:34:12.193] userDoption = [18:34:12.193] listen_addr_saved = false [18:34:12.193] output_config_variable = [18:34:12.193] __func__ = "PostmasterMain" [18:34:12.193] #24 0x000055bf5b864214 in main (argc=4, argv=0x55bf5eac7ce0) at ../src/backend/main/main.c:230 [18:34:12.193] do_check_root = [18:34:12.193] dispatch_option =