[02:07:58.631] src/tools/ci/cores_backtrace.sh linux /tmp/cores [02:07:58.844] dumping /tmp/cores/postgres-6-22179.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [02:07:59.084] [New LWP 22179] [02:07:59.084] [02:07:59.084] This GDB supports auto-downloading debuginfo from the following URLs: [02:07:59.084] [02:07:59.084] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [02:07:59.084] Debuginfod has been disabled. [02:07:59.084] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [02:07:59.326] [Thread debugging using libthread_db enabled] [02:07:59.326] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [02:07:59.326] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN '. [02:07:59.326] Program terminated with signal SIGABRT, Aborted. [02:07:59.326] #0 0x00007f9f476a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:00.205] [02:08:00.205] Thread 1 (Thread 0x7f9f45623f00 (LWP 22179)): [02:08:00.205] #0 0x00007f9f476a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:00.205] No symbol table info available. [02:08:00.205] #1 0x00007f9f4765afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:00.205] No symbol table info available. [02:08:00.205] #2 0x00007f9f47645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:00.205] No symbol table info available. [02:08:00.205] #3 0x00007f9f4781e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [02:08:00.205] No locals. [02:08:00.205] #4 0x00007f9f4782aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [02:08:00.205] No locals. [02:08:00.205] #5 0x00007f9f4780dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x561ad8b96200, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [02:08:00.205] bp = 140721857662336 [02:08:00.205] pc = [02:08:00.205] Opts = {FromUnrecoverableHandler = true, pc = 94673291195224, bp = 94673340503736} [02:08:00.205] #6 0x0000561ad7e43358 in examine_self_contradictory_rels (root=root@entry=0x561adadf2958, rel=rel@entry=0x561adad540a8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [02:08:00.205] lc__state = [02:08:00.205] rlist = [02:08:00.205] i = 2 [02:08:00.205] br = [02:08:00.205] expression = [02:08:00.205] or_rinfo = 0x561adad4a408 [02:08:00.205] ccxt = [02:08:00.205] delidx = 0x561adad4a2a1 [02:08:00.205] arglst = [02:08:00.205] lc = [02:08:00.205] arg = [02:08:00.205] n = [02:08:00.205] restrictinfo = [02:08:00.205] ccwapper = {clausecxt = 0x561adad49c38} [02:08:00.205] sec = {sopcinfo = {n_members = 38, opcies = 0x561adad49708}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x561adad48eb8, atop_set = 0x561adad49b18}, ccfree = 0x561adad4a270, vifree = 0x561adad49da8} [02:08:00.205] __func__ = "examine_self_contradictory_rels" [02:08:00.205] #7 0x0000561ad7e43567 in examine_self_contradictory_rels_phase1 (root=root@entry=0x561adadf2958) at ../src/backend/optimizer/plan/contradictory.c:2608 [02:08:00.205] rel = 0x561adad540a8 [02:08:00.205] rti = 1 [02:08:00.205] rinfo = [02:08:00.205] #8 0x0000561ad7e0e520 in query_planner (root=root@entry=0x561adadf2958, qp_callback=qp_callback@entry=0x561ad7e1383d , qp_extra=qp_extra@entry=0x7ffc5c568f80) at ../src/backend/optimizer/plan/planmain.c:193 [02:08:00.205] parse = 0x561adaaf4d18 [02:08:00.205] joinlist = 0x561adad48f28 [02:08:00.205] final_rel = [02:08:00.205] __func__ = "query_planner" [02:08:00.205] #9 0x0000561ad7e20f9c in grouping_planner (root=root@entry=0x561adadf2958, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [02:08:00.205] sort_input_targets = 0x5 [02:08:00.205] sort_input_target_parallel_safe = [02:08:00.205] grouping_target = [02:08:00.205] scanjoin_target = [02:08:00.205] activeWindows = 0x0 [02:08:00.205] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [02:08:00.205] sort_input_targets_contain_srfs = 0x1 [02:08:00.205] have_grouping = [02:08:00.205] wflists = 0x0 [02:08:00.205] gset_data = 0x0 [02:08:00.205] sort_input_target = [02:08:00.205] grouping_targets = 0x1 [02:08:00.205] grouping_target_parallel_safe = [02:08:00.205] scanjoin_targets = 0x0 [02:08:00.205] scanjoin_target_parallel_safe = [02:08:00.205] grouping_targets_contain_srfs = 0x1 [02:08:00.205] scanjoin_targets_contain_srfs = 0x561ad8388f3e [02:08:00.205] scanjoin_target_same_exprs = [02:08:00.205] parse = 0x561adaaf4d18 [02:08:00.205] offset_est = 0 [02:08:00.205] count_est = 0 [02:08:00.205] limit_tuples = -1 [02:08:00.205] have_postponed_srfs = false [02:08:00.205] final_target = [02:08:00.205] final_targets = 0x561adad8c798 [02:08:00.205] final_targets_contain_srfs = 0x561ad7d7ef9a [02:08:00.205] final_target_parallel_safe = [02:08:00.205] current_rel = [02:08:00.205] final_rel = [02:08:00.205] extra = {limit_needed = false, limit_tuples = 4.6774820349515087e-310, count_est = 94673341200376, offset_est = 94673341200376} [02:08:00.205] lc = [02:08:00.205] __func__ = "grouping_planner" [02:08:00.205] #10 0x0000561ad7e23f20 in subquery_planner (glob=glob@entry=0x561adad4f748, parse=parse@entry=0x561adaaf4d18, 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 [02:08:00.205] root = 0x561adadf2958 [02:08:00.205] newWithCheckOptions = [02:08:00.205] newHaving = 0x0 [02:08:00.205] hasOuterJoins = [02:08:00.205] hasResultRTEs = false [02:08:00.205] final_rel = [02:08:00.205] l = 0x0 [02:08:00.205] #11 0x0000561ad7e24bb1 in standard_planner (parse=0x561adaaf4d18, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [02:08:00.205] result = [02:08:00.205] glob = 0x561adad4f748 [02:08:00.205] tuple_fraction = 0 [02:08:00.205] root = [02:08:00.205] final_rel = [02:08:00.205] best_path = [02:08:00.205] top_plan = [02:08:00.205] lp = [02:08:00.205] lr = [02:08:00.205] #12 0x0000561ad7e25c1b in planner (parse=parse@entry=0x561adaaf4d18, query_string=query_string@entry=0x561adaaf3a70 "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 [02:08:00.205] result = [02:08:00.205] #13 0x0000561ad8095251 in pg_plan_query (querytree=querytree@entry=0x561adaaf4d18, query_string=query_string@entry=0x561adaaf3a70 "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 [02:08:00.205] plan = [02:08:00.205] #14 0x0000561ad7b951d3 in standard_ExplainOneQuery (query=0x561adaaf4d18, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x561adad4f4a8, queryString=0x561adaaf3a70 "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 [02:08:00.205] plan = [02:08:00.205] planstart = [02:08:00.205] planduration = {ticks = 94673290369214} [02:08:00.205] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94673296636980, shared_blks_dirtied = 1549177454, shared_blks_written = 3, local_blks_hit = 4294967392, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94673338060056, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94673296723774}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94673290366595}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94673338060056}} [02:08:00.205] bufusage = {shared_blks_hit = 0, shared_blks_read = 94673293392647, shared_blks_dirtied = 73160472936451, shared_blks_written = 72057594037927936, local_blks_hit = 140321882592928, local_blks_read = 94673338061232, local_blks_dirtied = 94673338060056, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94673296251499, shared_blk_read_time = {ticks = 140321882592928}, shared_blk_write_time = {ticks = 94673296251518}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94673296632563}, temp_blk_read_time = {ticks = 94673338239456}, temp_blk_write_time = {ticks = 64}} [02:08:00.205] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140721857663472, freespace = 10} [02:08:00.205] planner_ctx = 0x0 [02:08:00.205] saved_ctx = 0x0 [02:08:00.205] #15 0x0000561ad7b954b9 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x561adad4f4a8, pstate=pstate@entry=0x561adab20c98, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [02:08:00.205] No locals. [02:08:00.205] #16 0x0000561ad7b96410 in ExplainQuery (pstate=pstate@entry=0x561adab20c98, stmt=stmt@entry=0x561adaaf4b58, params=params@entry=0x0, dest=dest@entry=0x561adab20c08) at ../src/backend/commands/explain.c:357 [02:08:00.205] l__state = [02:08:00.205] l = 0x561adad54070 [02:08:00.205] es = 0x561adad4f4a8 [02:08:00.205] tstate = [02:08:00.205] jstate = [02:08:00.205] query = [02:08:00.205] rewritten = 0x561adad54058 [02:08:00.205] lc = 0x0 [02:08:00.205] timing_set = false [02:08:00.205] buffers_set = false [02:08:00.205] summary_set = false [02:08:00.205] __func__ = "ExplainQuery" [02:08:00.205] #17 0x0000561ad809fc71 in standard_ProcessUtility (pstmt=0x561adaaf4c08, queryString=0x561adaaf3a70 "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=0x561adab20c08, qc=0x7ffc5c569470) at ../src/backend/tcop/utility.c:866 [02:08:00.205] parsetree = 0x561adaaf4b58 [02:08:00.205] isTopLevel = true [02:08:00.205] isAtomicContext = false [02:08:00.205] pstate = 0x561adab20c98 [02:08:00.205] readonly_flags = [02:08:00.205] __func__ = "standard_ProcessUtility" [02:08:00.205] #18 0x0000561ad80a039a in ProcessUtility (pstmt=pstmt@entry=0x561adaaf4c08, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x561adab20c08, qc=0x7ffc5c569470) at ../src/backend/tcop/utility.c:523 [02:08:00.205] No locals. [02:08:00.205] #19 0x0000561ad809bd58 in PortalRunUtility (portal=portal@entry=0x561adab78380, pstmt=0x561adaaf4c08, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x561adab20c08, qc=qc@entry=0x7ffc5c569470) at ../src/backend/tcop/pquery.c:1152 [02:08:00.205] No locals. [02:08:00.205] #20 0x0000561ad809c5cb in FillPortalStore (portal=portal@entry=0x561adab78380, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [02:08:00.205] treceiver = 0x561adab20c08 [02:08:00.205] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:08:00.205] __func__ = "FillPortalStore" [02:08:00.205] #21 0x0000561ad809cae6 in PortalRun (portal=portal@entry=0x561adab78380, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x561adad8cba8, altdest=altdest@entry=0x561adad8cba8, qc=qc@entry=0x7ffc5c569630) at ../src/backend/tcop/pquery.c:759 [02:08:00.205] _save_exception_stack = 0x7ffc5c5696e0 [02:08:00.205] _save_context_stack = 0x0 [02:08:00.205] _local_sigjmp_buf = {{__jmpbuf = {0, 7075061891932774109, 94673338598272, 94673338059728, 94673338059704, 94673338059656, 3594618326105349853, 7075065868943908573}, __mask_was_saved = 0, __saved_mask = {__val = {94673296636980, 1549178303, 4, 94673338059656, 112, 153, 94673338598272, 94673338059728, 94673338059704, 94673338059656, 94673296724183, 1, 2, 153, 94673285970335, 0}}}} [02:08:00.205] _do_rethrow = [02:08:00.205] result = [02:08:00.205] nprocessed = [02:08:00.205] saveTopTransactionResourceOwner = 0x561adab354b8 [02:08:00.205] saveTopTransactionContext = 0x561adab8a3a0 [02:08:00.205] saveActivePortal = 0x0 [02:08:00.205] saveResourceOwner = 0x561adab354b8 [02:08:00.205] savePortalContext = 0x0 [02:08:00.205] saveMemoryContext = 0x561adab8a3a0 [02:08:00.205] __func__ = "PortalRun" [02:08:00.205] #22 0x0000561ad8095d1d in exec_simple_query (query_string=query_string@entry=0x561adaaf3a70 "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 [02:08:00.205] cmdtaglen = 7 [02:08:00.205] snapshot_set = [02:08:00.205] per_parsetree_context = 0x0 [02:08:00.205] plantree_list = 0x561adad8cb58 [02:08:00.205] parsetree = 0x561adaaf4b88 [02:08:00.205] commandTag = [02:08:00.205] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:08:00.205] querytree_list = [02:08:00.205] portal = 0x561adab78380 [02:08:00.205] receiver = 0x561adad8cba8 [02:08:00.205] format = 0 [02:08:00.205] cmdtagname = [02:08:00.205] parsetree_item__state = [02:08:00.205] dest = DestRemote [02:08:00.205] oldcontext = 0x561adab8a3a0 [02:08:00.205] parsetree_list = 0x561adaaf4bb8 [02:08:00.205] parsetree_item = 0x561adaaf4bd0 [02:08:00.205] save_log_statement_stats = false [02:08:00.205] was_logged = true [02:08:00.205] use_implicit_block = false [02:08:00.205] msec_str = "\004\000\000\000\000\000\000\000\201V5\330\032V\000\000\300\226V\\\374\177\000\000n\000\000\000\000\000\000" [02:08:00.205] __func__ = "exec_simple_query" [02:08:00.205] #23 0x0000561ad8098a76 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [02:08:00.205] query_string = 0x561adaaf3a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [02:08:00.205] firstchar = [02:08:00.205] input_message = {data = 0x561adaaf3a70 "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} [02:08:00.205] local_sigjmp_buf = {{__jmpbuf = {94673309386328, 7075066006420217565, 140721857665084, 4, 5, 140721857665316, 3594618326038240989, 7075065870994530013}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94673337785840, 14464, 94673309380384, 94673338319984, 5, 94673296636528, 0, 9, 2, 94673309386336, 94673337785840, 94673309380384, 4, 5, 140721857665316}}}} [02:08:00.205] send_ready_for_query = false [02:08:00.205] idle_in_transaction_timeout_enabled = false [02:08:00.205] idle_session_timeout_enabled = false [02:08:00.205] __func__ = "PostgresMain" [02:08:00.205] #24 0x0000561ad808eae1 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [02:08:00.205] bsdata = [02:08:00.205] #25 0x0000561ad7f4020f in postmaster_child_launch (child_type=B_BACKEND, child_slot=5, startup_data=startup_data@entry=0x7ffc5c56983c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc5c569890) at ../src/backend/postmaster/launch_backend.c:274 [02:08:00.205] pid = [02:08:00.205] #26 0x0000561ad7f4520a in BackendStartup (client_sock=client_sock@entry=0x7ffc5c569890) at ../src/backend/postmaster/postmaster.c:3386 [02:08:00.205] bn = 0x561adab1c028 [02:08:00.205] pid = [02:08:00.205] startup_data = {canAcceptConnections = CAC_OK} [02:08:00.205] cac = [02:08:00.205] __func__ = "BackendStartup" [02:08:00.205] #27 0x0000561ad7f470e3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [02:08:00.205] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "cG\237\177\000\000\240\177\265H\237\177\000\0008\231V\\\374\177\000\0004\231V\\\374\177", '\000' , "B\006\f\327\032V\000\000\310\347\a\327\032V\000\000\000\232V\\\374\177\000\000\370\231V\\\374\177\000\000\225[\362\001\000\000\000\000\240\204HH\237\177\000\000+", '\000' , "\032V\000\000P\005\f\327\032V\000", __ss_align = 140322100610664}, salen = 2}} [02:08:00.205] i = 0 [02:08:00.205] now = [02:08:00.205] last_lockfile_recheck_time = 1736128969 [02:08:00.205] last_touch_time = 1736128969 [02:08:00.205] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x561ad70c0642}, {pos = 1224083048, events = 32671, fd = 1212712496, user_data = 0x7f9f48f602e0}, {pos = 2090263927, events = 0, fd = 1549179520, user_data = 0x7f9f48f36a48}, {pos = 15, events = 0, fd = 1212712496, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f9f48f602e0}, {pos = 1549179384, events = 32764, fd = 1549179392, user_data = 0x7f9f48f60668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = -626043104, events = 22042, fd = 1, user_data = 0x7ffc5c569f23}, {pos = -1, events = 0, fd = 1197662240, user_data = 0x7f9f48b57fa0}, {pos = -625865464, events = 22042, fd = -625865752, user_data = 0x561adab209c1}, {pos = 1223937726, events = 32671, fd = 1, user_data = 0x7f9f48f602e0}, {pos = 426, events = 0, fd = -661807792, user_data = 0x0}, {pos = 216, events = 0, fd = -626050424, user_data = 0x7f9f48f3cebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f9f4762e020}, {pos = 1198468672, events = 32671, fd = 16, user_data = 0x7ffc5c569e50}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1223946682, events = 32671, fd = 0, user_data = 0x7f9f476aeda4 }, {pos = 0, events = 0, fd = -654784000, user_data = 0x2}, {pos = 0, events = 0, fd = -626303344, user_data = 0x561ad802c4f2 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = -626050424, user_data = 0x7f9f48f3cebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f9f476364c8}, {pos = 1198223469, events = 32671, fd = -654727872, user_data = 0x561adab26410}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 1199512672, events = 32671, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, 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 = 4294967040, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x30305f742f617461}, {pos = 1735417650, events = 1735423327, fd = 1853190772, user_data = 0x2f65646172677075}, {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 = -625860592, user_data = 0x7f9f476b58be}, {pos = 1199495648, events = 32671, fd = 1198133614, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xd8d57c3c321a8900}, {pos = 1199498720, events = 32671, fd = -328, user_data = 0x0}, {pos = -625866072, events = 22042, 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 = 20984, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -626050424, user_data = 0x7f9f476f3053 }, {pos = -625866072, events = 22042, fd = 1024, user_data = 0x7ffc5c569f18}, {pos = -667389849, events = 22042, fd = -654719472, user_data = 0x561ad8375b24 }, {pos = -625866272, events = 22042, fd = -626050704, user_data = 0x561adab209e0}, {pos = 1198217406, events = 32671, fd = 0, user_data = 0x561ad838778e }, {pos = -625866272, events = 1, fd = -667387689, user_data = 0x561adaaf3970}, {pos = 840599808, events = 3637869628, fd = 0, user_data = 0x7f9f476a2ab1}, {pos = 1198134512, events = 32671, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -626303344, user_data = 0xd8d57c3c321a8900}, {pos = 0, events = 0, fd = 840599808, user_data = 0xc}, {pos = 840599808, events = 3637869628, fd = 0, user_data = 0x7f9f4765b239 }, {pos = 217, events = 0, fd = -671875316, user_data = 0x400000}, {pos = 0, events = 0, fd = -626303344, user_data = 0x561ad83759b8 }, {pos = -626216800, events = 22042, fd = -626050704, user_data = 0x561adaacb0a0}, {pos = 1, events = 0, fd = 0, user_data = 0x561ad83341bd }, {pos = 12, events = 0, fd = -625874936, user_data = 0x561adab1e7e8}, {pos = -654782592, events = 22042, fd = 296, user_data = 0x561ad7f42726 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -671858845, events = 22042, fd = -658386000, user_data = 0x561adaaf4318}} [02:08:00.205] nevents = 1 [02:08:00.205] __func__ = "ServerLoop" [02:08:00.205] #28 0x0000561ad7f48964 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x561adaab1d00) at ../src/backend/postmaster/postmaster.c:1371 [02:08:00.205] opt = [02:08:00.205] status = [02:08:00.205] userDoption = [02:08:00.205] listen_addr_saved = false [02:08:00.205] output_config_variable = [02:08:00.205] __func__ = "PostmasterMain" [02:08:00.205] #29 0x0000561ad7d75006 in main (argc=4, argv=0x561adaab1d00) at ../src/backend/main/main.c:230 [02:08:00.205] do_check_root = [02:08:00.205] dispatch_option = [02:08:00.240] -e [02:08:00.240] [02:08:00.240] [02:08:00.322] dumping /tmp/cores/postgres-6-21306.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:08:00.564] [New LWP 21306] [02:08:00.564] [02:08:00.564] This GDB supports auto-downloading debuginfo from the following URLs: [02:08:00.564] [02:08:00.564] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [02:08:00.564] Debuginfod has been disabled. [02:08:00.564] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [02:08:00.802] [Thread debugging using libthread_db enabled] [02:08:00.802] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [02:08:00.802] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [02:08:00.802] Program terminated with signal SIGABRT, Aborted. [02:08:00.802] #0 0x00007fb1246a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:01.654] [02:08:01.654] Thread 1 (Thread 0x7fb1243d2f00 (LWP 21306)): [02:08:01.654] #0 0x00007fb1246a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:01.654] No symbol table info available. [02:08:01.654] #1 0x00007fb12465afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:01.654] No symbol table info available. [02:08:01.654] #2 0x00007fb124645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:01.654] No symbol table info available. [02:08:01.654] #3 0x00007fb12481e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [02:08:01.654] No locals. [02:08:01.654] #4 0x00007fb12482aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [02:08:01.654] No locals. [02:08:01.654] #5 0x00007fb12480dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x564961270200, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [02:08:01.654] bp = 140734841171280 [02:08:01.654] pc = [02:08:01.654] Opts = {FromUnrecoverableHandler = true, pc = 94873148576600, bp = 94873173187128} [02:08:01.654] #6 0x000056496051d358 in examine_self_contradictory_rels (root=root@entry=0x564961bba698, rel=rel@entry=0x564961c09828, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [02:08:01.654] lc__state = [02:08:01.654] rlist = [02:08:01.654] i = 2 [02:08:01.654] br = [02:08:01.654] expression = [02:08:01.654] or_rinfo = 0x564961c96788 [02:08:01.654] ccxt = [02:08:01.654] delidx = 0x564961c96621 [02:08:01.654] arglst = [02:08:01.654] lc = [02:08:01.654] arg = [02:08:01.654] n = [02:08:01.654] restrictinfo = [02:08:01.654] ccwapper = {clausecxt = 0x564961c95fb8} [02:08:01.654] sec = {sopcinfo = {n_members = 38, opcies = 0x564961c95a88}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x564961c95238, atop_set = 0x564961c95e98}, ccfree = 0x564961c965f0, vifree = 0x564961c96128} [02:08:01.654] __func__ = "examine_self_contradictory_rels" [02:08:01.654] #7 0x000056496051d567 in examine_self_contradictory_rels_phase1 (root=root@entry=0x564961bba698) at ../src/backend/optimizer/plan/contradictory.c:2608 [02:08:01.654] rel = 0x564961c09828 [02:08:01.654] rti = 1 [02:08:01.654] rinfo = [02:08:01.654] #8 0x00005649604e8520 in query_planner (root=root@entry=0x564961bba698, qp_callback=qp_callback@entry=0x5649604ed83d , qp_extra=qp_extra@entry=0x7fff62372f50) at ../src/backend/optimizer/plan/planmain.c:193 [02:08:01.654] parse = 0x564961966d98 [02:08:01.654] joinlist = 0x564961c952a8 [02:08:01.654] final_rel = [02:08:01.654] __func__ = "query_planner" [02:08:01.654] #9 0x00005649604faf9c in grouping_planner (root=root@entry=0x564961bba698, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [02:08:01.654] sort_input_targets = 0x5 [02:08:01.654] sort_input_target_parallel_safe = [02:08:01.654] grouping_target = [02:08:01.654] scanjoin_target = [02:08:01.654] activeWindows = 0x0 [02:08:01.654] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [02:08:01.654] sort_input_targets_contain_srfs = 0x1 [02:08:01.654] have_grouping = [02:08:01.654] wflists = 0x0 [02:08:01.654] gset_data = 0x0 [02:08:01.654] sort_input_target = [02:08:01.654] grouping_targets = 0x1 [02:08:01.654] grouping_target_parallel_safe = [02:08:01.654] scanjoin_targets = 0x0 [02:08:01.654] scanjoin_target_parallel_safe = [02:08:01.654] grouping_targets_contain_srfs = 0x1 [02:08:01.654] scanjoin_targets_contain_srfs = 0x564960a62f3e [02:08:01.654] scanjoin_target_same_exprs = [02:08:01.654] parse = 0x564961966d98 [02:08:01.654] offset_est = 0 [02:08:01.654] count_est = 0 [02:08:01.654] limit_tuples = -1 [02:08:01.654] have_postponed_srfs = false [02:08:01.654] final_target = [02:08:01.654] final_targets = 0x564961a67348 [02:08:01.654] final_targets_contain_srfs = 0x564960458f9a [02:08:01.654] final_target_parallel_safe = [02:08:01.654] current_rel = [02:08:01.654] final_rel = [02:08:01.654] extra = {limit_needed = false, limit_tuples = 4.6873563015720761e-310, count_est = 94873172292920, offset_est = 94873172292920} [02:08:01.654] lc = [02:08:01.654] __func__ = "grouping_planner" [02:08:01.654] #10 0x00005649604fdf20 in subquery_planner (glob=glob@entry=0x564961c3fd68, parse=parse@entry=0x564961966d98, 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 [02:08:01.654] root = 0x564961bba698 [02:08:01.654] newWithCheckOptions = [02:08:01.654] newHaving = 0x0 [02:08:01.654] hasOuterJoins = [02:08:01.654] hasResultRTEs = false [02:08:01.654] final_rel = [02:08:01.654] l = 0x0 [02:08:01.654] #11 0x00005649604febb1 in standard_planner (parse=0x564961966d98, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [02:08:01.654] result = [02:08:01.654] glob = 0x564961c3fd68 [02:08:01.654] tuple_fraction = 0 [02:08:01.654] root = [02:08:01.654] final_rel = [02:08:01.654] best_path = [02:08:01.654] top_plan = [02:08:01.654] lp = [02:08:01.654] lr = [02:08:01.654] #12 0x00005649604ffc1b in planner (parse=parse@entry=0x564961966d98, query_string=query_string@entry=0x564961965af0 "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 [02:08:01.654] result = [02:08:01.654] #13 0x000056496076f251 in pg_plan_query (querytree=querytree@entry=0x564961966d98, query_string=query_string@entry=0x564961965af0 "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 [02:08:01.654] plan = [02:08:01.654] #14 0x000056496026f1d3 in standard_ExplainOneQuery (query=0x564961966d98, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x564961c3fac8, queryString=0x564961965af0 "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 [02:08:01.654] plan = [02:08:01.654] planstart = [02:08:01.654] planduration = {ticks = 94873147750590} [02:08:01.654] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94873154018356, shared_blks_dirtied = 1647784510, shared_blks_written = 3, local_blks_hit = 4294967392, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94873169849752, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94873154105150}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94873147747971}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94873169849752}} [02:08:01.654] bufusage = {shared_blks_hit = 0, shared_blks_read = 94873150774023, shared_blks_dirtied = 73242077315072, shared_blks_written = 72057594037927936, local_blks_hit = 140398600636064, local_blks_read = 94873169850928, local_blks_dirtied = 94873169849752, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94873153632875, shared_blk_read_time = {ticks = 140398600636064}, shared_blk_write_time = {ticks = 94873153632894}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94873154013939}, temp_blk_read_time = {ticks = 94873170030240}, temp_blk_write_time = {ticks = 64}} [02:08:01.654] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140734841172416, freespace = 10} [02:08:01.654] planner_ctx = 0x0 [02:08:01.654] saved_ctx = 0x0 [02:08:01.654] #15 0x000056496026f4b9 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x564961c3fac8, pstate=pstate@entry=0x564961993158, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [02:08:01.654] No locals. [02:08:01.654] #16 0x0000564960270410 in ExplainQuery (pstate=pstate@entry=0x564961993158, stmt=stmt@entry=0x564961966bd8, params=params@entry=0x0, dest=dest@entry=0x5649619930c8) at ../src/backend/commands/explain.c:357 [02:08:01.654] l__state = [02:08:01.654] l = 0x564961c097f0 [02:08:01.654] es = 0x564961c3fac8 [02:08:01.654] tstate = [02:08:01.654] jstate = [02:08:01.654] query = [02:08:01.654] rewritten = 0x564961c097d8 [02:08:01.654] lc = 0x0 [02:08:01.654] timing_set = false [02:08:01.654] buffers_set = false [02:08:01.654] summary_set = false [02:08:01.654] __func__ = "ExplainQuery" [02:08:01.654] #17 0x0000564960779c71 in standard_ProcessUtility (pstmt=0x564961966c88, queryString=0x564961965af0 "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=0x5649619930c8, qc=0x7fff62373440) at ../src/backend/tcop/utility.c:866 [02:08:01.654] parsetree = 0x564961966bd8 [02:08:01.654] isTopLevel = true [02:08:01.654] isAtomicContext = false [02:08:01.654] pstate = 0x564961993158 [02:08:01.654] readonly_flags = [02:08:01.654] __func__ = "standard_ProcessUtility" [02:08:01.654] #18 0x000056496077a39a in ProcessUtility (pstmt=pstmt@entry=0x564961966c88, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5649619930c8, qc=0x7fff62373440) at ../src/backend/tcop/utility.c:523 [02:08:01.654] No locals. [02:08:01.654] #19 0x0000564960775d58 in PortalRunUtility (portal=portal@entry=0x5649619ea980, pstmt=0x564961966c88, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5649619930c8, qc=qc@entry=0x7fff62373440) at ../src/backend/tcop/pquery.c:1152 [02:08:01.654] No locals. [02:08:01.654] #20 0x00005649607765cb in FillPortalStore (portal=portal@entry=0x5649619ea980, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [02:08:01.654] treceiver = 0x5649619930c8 [02:08:01.654] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:08:01.654] __func__ = "FillPortalStore" [02:08:01.654] #21 0x0000564960776ae6 in PortalRun (portal=portal@entry=0x5649619ea980, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x564961a67758, altdest=altdest@entry=0x564961a67758, qc=qc@entry=0x7fff62373600) at ../src/backend/tcop/pquery.c:759 [02:08:01.654] _save_exception_stack = 0x7fff623736b0 [02:08:01.654] _save_context_stack = 0x0 [02:08:01.654] _local_sigjmp_buf = {{__jmpbuf = {0, 3272947398149828840, 94873170389376, 94873169849424, 94873169849400, 94873169849352, 9081472862339100904, 3272951392998289640}, __mask_was_saved = 0, __saved_mask = {__val = {94873154018356, 1647785359, 4, 94873169849352, 112, 153, 94873170389376, 94873169849424, 94873169849400, 94873169849352, 94873154105559, 1, 2, 153, 94873143351711, 0}}}} [02:08:01.654] _do_rethrow = [02:08:01.654] result = [02:08:01.654] nprocessed = [02:08:01.654] saveTopTransactionResourceOwner = 0x5649619a75b8 [02:08:01.654] saveTopTransactionContext = 0x5649619fc9a0 [02:08:01.654] saveActivePortal = 0x0 [02:08:01.654] saveResourceOwner = 0x5649619a75b8 [02:08:01.654] savePortalContext = 0x0 [02:08:01.654] saveMemoryContext = 0x5649619fc9a0 [02:08:01.654] __func__ = "PortalRun" [02:08:01.654] #22 0x000056496076fd1d in exec_simple_query (query_string=query_string@entry=0x564961965af0 "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 [02:08:01.654] cmdtaglen = 7 [02:08:01.654] snapshot_set = [02:08:01.654] per_parsetree_context = 0x0 [02:08:01.654] plantree_list = 0x564961a67708 [02:08:01.654] parsetree = 0x564961966c08 [02:08:01.654] commandTag = [02:08:01.654] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:08:01.654] querytree_list = [02:08:01.654] portal = 0x5649619ea980 [02:08:01.654] receiver = 0x564961a67758 [02:08:01.654] format = 0 [02:08:01.654] cmdtagname = [02:08:01.654] parsetree_item__state = [02:08:01.654] dest = DestRemote [02:08:01.654] oldcontext = 0x5649619fc9a0 [02:08:01.654] parsetree_list = 0x564961966c38 [02:08:01.654] parsetree_item = 0x564961966c50 [02:08:01.654] save_log_statement_stats = false [02:08:01.654] was_logged = false [02:08:01.654] use_implicit_block = false [02:08:01.654] msec_str = "\004\000\000\000\000\000\000\000\201\366\242`IV\000\000\22067b\377\177\000\000n\000\000\000\000\000\000" [02:08:01.654] __func__ = "exec_simple_query" [02:08:01.654] #23 0x0000564960772a76 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [02:08:01.654] query_string = 0x564961965af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [02:08:01.654] firstchar = [02:08:01.654] input_message = {data = 0x564961965af0 "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} [02:08:01.654] local_sigjmp_buf = {{__jmpbuf = {94873166767704, 3272949056509473000, 140734841174028, 4, 16, 140734841174260, 9081472862271992040, 3272951394984947944}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94873169575440, 15744, 94873166761760, 94873170109808, 16, 94873154017904, 0, 9, 2, 94873166767712, 94873169575440, 94873166761760, 4, 16, 140734841174260}}}} [02:08:01.654] send_ready_for_query = false [02:08:01.654] idle_in_transaction_timeout_enabled = false [02:08:01.654] idle_session_timeout_enabled = false [02:08:01.654] __func__ = "PostgresMain" [02:08:01.654] #24 0x0000564960768ae1 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [02:08:01.654] bsdata = [02:08:01.654] #25 0x000056496061a20f in postmaster_child_launch (child_type=B_BACKEND, child_slot=16, startup_data=startup_data@entry=0x7fff6237380c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff62373860) at ../src/backend/postmaster/launch_backend.c:274 [02:08:01.654] pid = [02:08:01.654] #26 0x000056496061f20a in BackendStartup (client_sock=client_sock@entry=0x7fff62373860) at ../src/backend/postmaster/postmaster.c:3386 [02:08:01.654] bn = 0x56496198e338 [02:08:01.654] pid = [02:08:01.654] startup_data = {canAcceptConnections = CAC_OK} [02:08:01.654] cac = [02:08:01.654] __func__ = "BackendStartup" [02:08:01.654] #27 0x00005649606210e3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [02:08:01.654] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "7b\377\177\000\000\36487b\377\177", '\000' , "B\246y_IV\000\000ȇu_IV\000\000\30097b\377\177\000\000\27097b\377\177\000\000\225[\362\001\000\000\000\000\240tH%\261\177\000\000+", '\000' , "P\245y_IV\000\000hF\353%\261\177\000\0000vH%\261\177\000", __ss_align = 140398822114016}, salen = 2}} [02:08:01.654] i = 0 [02:08:01.654] now = [02:08:01.654] last_lockfile_recheck_time = 1736128967 [02:08:01.654] last_touch_time = 1736128967 [02:08:01.654] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1601807938, events = 22089, fd = 636175976, user_data = 0x7fb125487630}, {pos = 636175072, events = 32689, fd = 2090263927, user_data = 0x7fff62373a40}, {pos = 636004936, events = 32689, fd = 15, user_data = 0x7fb125487630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 636175072, events = 32689, fd = 1647786424, user_data = 0x7fff623739c0}, {pos = 636175976, events = 32689, fd = 0, user_data = 0x564961965bb0}, {pos = 1621734699, events = 22089, fd = 32768, user_data = 0x1}, {pos = 1637251040, events = 22089, fd = -1, user_data = 0x7fb12462e020}, {pos = 632491936, events = 32689, fd = 1637429704, user_data = 0x5649619930a8}, {pos = 1637428865, events = 22089, fd = 636030654, user_data = 0x1}, {pos = 636175072, events = 32689, fd = 426, user_data = 0x564960fb3d50 }, {pos = 0, events = 0, fd = 236, user_data = 0x564961965bb0}, {pos = 636030654, events = 32689, fd = 1, user_data = 0x0}, {pos = 610459680, events = 32689, fd = 611266112, user_data = 0x10}, {pos = 1647787552, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 636039610, user_data = 0x0}, {pos = 610987428, events = 32689, fd = 0, user_data = 0x564961666a00 }, {pos = 2, events = 0, fd = 0, user_data = 0x564961927eb0}, {pos = 1617963193, events = 22089, fd = 1637451115, user_data = 0x5649607064f2 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x564961965bb0}, {pos = 636030654, events = 32689, fd = 1, user_data = 0x0}, {pos = 610493640, events = 32689, fd = 610912384, user_data = 0x437}, {pos = 611020909, events = 32689, fd = 2, user_data = 0x564961998510}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = 612310112, events = 32689, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x754942732d737365}, {pos = 168454726, events = 857743392, fd = 822763892, user_data = 0x30340a3736393832}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = 1621412595, events = 22089, fd = 1637434496, user_data = 0x7fb1246b58be}, {pos = 612293088, events = 32689, fd = 610931054, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x88dd25d4b537d800}, {pos = 612296160, events = 32689, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1637429096, user_data = 0x3}, {pos = 0, events = 0, fd = 20462, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1637243824, user_data = 0x7fb1246f3053 }, {pos = 1637429096, events = 22089, fd = 1024, user_data = 0x7fff62373ee8}, {pos = 1621495911, events = 22089, fd = 1634166288, user_data = 0x564960a4fb24 }, {pos = 1637428896, events = 22089, fd = 1637243376, user_data = 0x564961992ea0}, {pos = 611014846, events = 32689, fd = 0, user_data = 0x564960a6178e }, {pos = 1637428896, events = 1, fd = 1621498071, user_data = 0x5649619659f0}, {pos = -1254631424, events = 2296194516, fd = 0, user_data = 0x7fb1246a2ab1}, {pos = 610931952, events = 32689, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1636990640, user_data = 0x88dd25d4b537d800}, {pos = 0, events = 0, fd = -1254631424, user_data = 0xc}, {pos = -1254631424, events = 2296194516, fd = 0, user_data = 0x7fb12465b239 }, {pos = 237, events = 0, fd = 1617010444, user_data = 0x400000}, {pos = 0, events = 0, fd = 1636990640, user_data = 0x564960a4f9b8 }, {pos = 1637077280, events = 22089, fd = 1637243376, user_data = 0x56496193d120}, {pos = 1, events = 0, fd = 0, user_data = 0x564960a0e1bd }, {pos = 12, events = 0, fd = 1637420232, user_data = 0x564961990ca8}, {pos = 1634103168, events = 22089, fd = 296, user_data = 0x56496061c726 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1617026915, events = 22089, fd = 1630499760, user_data = 0x5649619663c8}} [02:08:01.655] nevents = 1 [02:08:01.655] __func__ = "ServerLoop" [02:08:01.655] #28 0x0000564960622964 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x564961923d70) at ../src/backend/postmaster/postmaster.c:1371 [02:08:01.655] opt = [02:08:01.655] status = [02:08:01.655] userDoption = [02:08:01.655] listen_addr_saved = false [02:08:01.655] output_config_variable = [02:08:01.655] __func__ = "PostmasterMain" [02:08:01.655] #29 0x000056496044f006 in main (argc=8, argv=0x564961923d70) at ../src/backend/main/main.c:230 [02:08:01.655] do_check_root = [02:08:01.655] dispatch_option = [02:08:01.689] -e [02:08:01.689] [02:08:01.689] [02:08:01.749] dumping /tmp/cores/postgres-6-27467.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:08:01.986] [New LWP 27467] [02:08:01.986] [02:08:01.986] This GDB supports auto-downloading debuginfo from the following URLs: [02:08:01.986] [02:08:01.986] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [02:08:01.986] Debuginfod has been disabled. [02:08:01.986] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [02:08:02.087] [Thread debugging using libthread_db enabled] [02:08:02.087] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [02:08:02.087] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [02:08:02.087] Program terminated with signal SIGABRT, Aborted. [02:08:02.087] #0 0x00007fb1246a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:02.943] [02:08:02.943] Thread 1 (Thread 0x7fb1243d2f00 (LWP 27467)): [02:08:02.943] #0 0x00007fb1246a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:02.943] No symbol table info available. [02:08:02.943] #1 0x00007fb12465afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:02.943] No symbol table info available. [02:08:02.943] #2 0x00007fb124645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:02.943] No symbol table info available. [02:08:02.943] #3 0x00007fb12481e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [02:08:02.943] No locals. [02:08:02.943] #4 0x00007fb12482aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [02:08:02.943] No locals. [02:08:02.943] #5 0x00007fb12480dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x564961270200, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [02:08:02.943] bp = 140734841171280 [02:08:02.943] pc = [02:08:02.943] Opts = {FromUnrecoverableHandler = true, pc = 94873148576600, bp = 94873170236520} [02:08:02.943] #6 0x000056496051d358 in examine_self_contradictory_rels (root=root@entry=0x564961a5f5c8, rel=rel@entry=0x564961a61e88, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [02:08:02.943] lc__state = [02:08:02.943] rlist = [02:08:02.943] i = 2 [02:08:02.943] br = [02:08:02.943] expression = [02:08:02.943] or_rinfo = 0x5649619c6048 [02:08:02.943] ccxt = [02:08:02.943] delidx = 0x5649619c5fe1 [02:08:02.943] arglst = [02:08:02.943] lc = [02:08:02.943] arg = [02:08:02.943] n = [02:08:02.943] restrictinfo = [02:08:02.943] ccwapper = {clausecxt = 0x5649619c5948} [02:08:02.943] sec = {sopcinfo = {n_members = 38, opcies = 0x5649619c54b8}, attrsdc = {min_attr = -6, max_attr = 5, len_set = 2, atop_array = 0x5649619c4ba8, atop_set = 0x5649619c4d28}, ccfree = 0x5649619c5fb0, vifree = 0x5649619c5b50} [02:08:02.943] __func__ = "examine_self_contradictory_rels" [02:08:02.943] #7 0x000056496051d567 in examine_self_contradictory_rels_phase1 (root=root@entry=0x564961a5f5c8) at ../src/backend/optimizer/plan/contradictory.c:2608 [02:08:02.943] rel = 0x564961a61e88 [02:08:02.943] rti = 1 [02:08:02.943] rinfo = [02:08:02.943] #8 0x00005649604e8520 in query_planner (root=root@entry=0x564961a5f5c8, qp_callback=qp_callback@entry=0x5649604ed83d , qp_extra=qp_extra@entry=0x7fff62372f50) at ../src/backend/optimizer/plan/planmain.c:193 [02:08:02.943] parse = 0x5649619670e0 [02:08:02.943] joinlist = 0x5649619c4d98 [02:08:02.943] final_rel = [02:08:02.943] __func__ = "query_planner" [02:08:02.943] #9 0x00005649604faf9c in grouping_planner (root=root@entry=0x564961a5f5c8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [02:08:02.943] sort_input_targets = 0x5 [02:08:02.943] sort_input_target_parallel_safe = [02:08:02.943] grouping_target = [02:08:02.943] scanjoin_target = [02:08:02.943] activeWindows = 0x0 [02:08:02.943] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [02:08:02.943] sort_input_targets_contain_srfs = 0x1 [02:08:02.943] have_grouping = [02:08:02.943] wflists = 0x0 [02:08:02.943] gset_data = 0x0 [02:08:02.943] sort_input_target = [02:08:02.943] grouping_targets = 0x1 [02:08:02.943] grouping_target_parallel_safe = [02:08:02.943] scanjoin_targets = 0x0 [02:08:02.943] scanjoin_target_parallel_safe = [02:08:02.943] grouping_targets_contain_srfs = 0x1 [02:08:02.943] scanjoin_targets_contain_srfs = 0x564960a62f3e [02:08:02.943] scanjoin_target_same_exprs = [02:08:02.943] parse = 0x5649619670e0 [02:08:02.943] offset_est = 0 [02:08:02.943] count_est = 0 [02:08:02.943] limit_tuples = -1 [02:08:02.943] have_postponed_srfs = false [02:08:02.943] final_target = [02:08:02.943] final_targets = 0x564961a48678 [02:08:02.943] final_targets_contain_srfs = 0x564960458f9a [02:08:02.943] final_target_parallel_safe = [02:08:02.943] current_rel = [02:08:02.943] final_rel = [02:08:02.943] extra = {limit_needed = false, limit_tuples = 4.6873563015720761e-310, count_est = 94873170871400, offset_est = 94873170871400} [02:08:02.943] lc = [02:08:02.943] __func__ = "grouping_planner" [02:08:02.943] #10 0x00005649604fdf20 in subquery_planner (glob=glob@entry=0x564961a61868, parse=parse@entry=0x5649619670e0, 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 [02:08:02.943] root = 0x564961a5f5c8 [02:08:02.943] newWithCheckOptions = [02:08:02.943] newHaving = 0x0 [02:08:02.943] hasOuterJoins = [02:08:02.943] hasResultRTEs = false [02:08:02.943] final_rel = [02:08:02.943] l = 0x0 [02:08:02.943] #11 0x00005649604febb1 in standard_planner (parse=0x5649619670e0, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [02:08:02.943] result = [02:08:02.943] glob = 0x564961a61868 [02:08:02.943] tuple_fraction = 0 [02:08:02.943] root = [02:08:02.943] final_rel = [02:08:02.943] best_path = [02:08:02.943] top_plan = [02:08:02.943] lp = [02:08:02.943] lr = [02:08:02.943] #12 0x00005649604ffc1b in planner (parse=parse@entry=0x5649619670e0, query_string=query_string@entry=0x564961965af0 "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 [02:08:02.943] result = [02:08:02.943] #13 0x000056496076f251 in pg_plan_query (querytree=querytree@entry=0x5649619670e0, query_string=query_string@entry=0x564961965af0 "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 [02:08:02.943] plan = [02:08:02.943] #14 0x000056496026f1d3 in standard_ExplainOneQuery (query=0x5649619670e0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x564961a615c8, queryString=0x564961965af0 "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 [02:08:02.943] plan = [02:08:02.943] planstart = [02:08:02.943] planduration = {ticks = 94873147750590} [02:08:02.943] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94873154018356, shared_blks_dirtied = 1647784510, shared_blks_written = 3, local_blks_hit = 4294967392, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94873169850592, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94873154105150}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94873147747971}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94873169850592}} [02:08:02.943] bufusage = {shared_blks_hit = 0, shared_blks_read = 94873150774023, shared_blks_dirtied = 211290916143104, shared_blks_written = 72057594037927936, local_blks_hit = 140398601168488, local_blks_read = 94873169851984, local_blks_dirtied = 94873169850592, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94873153632875, shared_blk_read_time = {ticks = 140398601168488}, shared_blk_write_time = {ticks = 94873153632894}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94873154013939}, temp_blk_read_time = {ticks = 94873170705872}, temp_blk_write_time = {ticks = 64}} [02:08:02.943] mem_counters = {nblocks = 94873170877928, freechunks = 4294967297, totalspace = 140734841172416, freespace = 10} [02:08:02.943] planner_ctx = 0x0 [02:08:02.943] saved_ctx = 0x0 [02:08:02.943] #15 0x000056496026f4b9 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x564961a615c8, pstate=pstate@entry=0x564961a38088, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [02:08:02.943] No locals. [02:08:02.943] #16 0x0000564960270410 in ExplainQuery (pstate=pstate@entry=0x564961a38088, stmt=stmt@entry=0x564961966f20, params=params@entry=0x0, dest=dest@entry=0x564961a37ff8) at ../src/backend/commands/explain.c:357 [02:08:02.943] l__state = [02:08:02.943] l = 0x564961a61e50 [02:08:02.943] es = 0x564961a615c8 [02:08:02.943] tstate = [02:08:02.943] jstate = [02:08:02.943] query = [02:08:02.943] rewritten = 0x564961a61e38 [02:08:02.943] lc = 0x0 [02:08:02.943] timing_set = false [02:08:02.943] buffers_set = false [02:08:02.943] summary_set = false [02:08:02.943] __func__ = "ExplainQuery" [02:08:02.943] #17 0x0000564960779c71 in standard_ProcessUtility (pstmt=0x564961966fd0, queryString=0x564961965af0 "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=0x564961a37ff8, qc=0x7fff62373440) at ../src/backend/tcop/utility.c:866 [02:08:02.943] parsetree = 0x564961966f20 [02:08:02.943] isTopLevel = true [02:08:02.943] isAtomicContext = false [02:08:02.943] pstate = 0x564961a38088 [02:08:02.943] readonly_flags = [02:08:02.943] __func__ = "standard_ProcessUtility" [02:08:02.943] #18 0x000056496077a39a in ProcessUtility (pstmt=pstmt@entry=0x564961966fd0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x564961a37ff8, qc=0x7fff62373440) at ../src/backend/tcop/utility.c:523 [02:08:02.943] No locals. [02:08:02.943] #19 0x0000564960775d58 in PortalRunUtility (portal=portal@entry=0x5649619ea980, pstmt=0x564961966fd0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x564961a37ff8, qc=qc@entry=0x7fff62373440) at ../src/backend/tcop/pquery.c:1152 [02:08:02.943] No locals. [02:08:02.943] #20 0x00005649607765cb in FillPortalStore (portal=portal@entry=0x5649619ea980, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [02:08:02.943] treceiver = 0x564961a37ff8 [02:08:02.943] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:08:02.943] __func__ = "FillPortalStore" [02:08:02.943] #21 0x0000564960776ae6 in PortalRun (portal=portal@entry=0x5649619ea980, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x564961a48958, altdest=altdest@entry=0x564961a48958, qc=qc@entry=0x7fff62373600) at ../src/backend/tcop/pquery.c:759 [02:08:02.943] _save_exception_stack = 0x7fff623736b0 [02:08:02.943] _save_context_stack = 0x0 [02:08:02.943] _local_sigjmp_buf = {{__jmpbuf = {0, 3272947412309799144, 94873170389376, 94873169850264, 94873169850240, 94873169850192, 9081472862339100904, 3272951392998289640}, __mask_was_saved = 0, __saved_mask = {__val = {94873154018356, 1647785359, 4, 94873169850192, 112, 153, 94873170389376, 94873169850264, 94873169850240, 94873169850192, 94873154105559, 1, 2, 153, 94873143351711, 0}}}} [02:08:02.943] _do_rethrow = [02:08:02.943] result = [02:08:02.943] nprocessed = [02:08:02.943] saveTopTransactionResourceOwner = 0x5649619a7e58 [02:08:02.943] saveTopTransactionContext = 0x5649619fc9a0 [02:08:02.943] saveActivePortal = 0x0 [02:08:02.943] saveResourceOwner = 0x5649619a7e58 [02:08:02.943] savePortalContext = 0x0 [02:08:02.943] saveMemoryContext = 0x5649619fc9a0 [02:08:02.943] __func__ = "PortalRun" [02:08:02.943] #22 0x000056496076fd1d in exec_simple_query (query_string=query_string@entry=0x564961965af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;") at ../src/backend/tcop/postgres.c:1271 [02:08:02.943] cmdtaglen = 7 [02:08:02.943] snapshot_set = [02:08:02.943] per_parsetree_context = 0x0 [02:08:02.943] plantree_list = 0x564961a48908 [02:08:02.943] parsetree = 0x564961966f50 [02:08:02.943] commandTag = [02:08:02.943] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:08:02.943] querytree_list = [02:08:02.943] portal = 0x5649619ea980 [02:08:02.943] receiver = 0x564961a48958 [02:08:02.943] format = 0 [02:08:02.943] cmdtagname = [02:08:02.943] parsetree_item__state = [02:08:02.943] dest = DestRemote [02:08:02.943] oldcontext = 0x5649619fc9a0 [02:08:02.943] parsetree_list = 0x564961966f80 [02:08:02.943] parsetree_item = 0x564961966f98 [02:08:02.943] save_log_statement_stats = false [02:08:02.943] was_logged = false [02:08:02.943] use_implicit_block = false [02:08:02.943] msec_str = "\004\000\000\000\000\000\000\000\201\366\242`IV\000\000\22067b\377\177\000\000J\000\000\000\000\000\000" [02:08:02.943] __func__ = "exec_simple_query" [02:08:02.943] #23 0x0000564960772a76 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [02:08:02.943] query_string = 0x564961965af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;" [02:08:02.943] firstchar = [02:08:02.943] input_message = {data = 0x564961965af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", len = 74, maxlen = 1024, cursor = 74} [02:08:02.943] local_sigjmp_buf = {{__jmpbuf = {94873166767704, 3272949056509473000, 140734841174028, 4, 7, 140734841174260, 9081472862271992040, 3272951394984947944}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94873169575440, 15744, 94873166761760, 94873170109808, 7, 94873154017904, 0, 9, 2, 94873166767712, 94873169575440, 94873166761760, 4, 7, 140734841174260}}}} [02:08:02.943] send_ready_for_query = false [02:08:02.943] idle_in_transaction_timeout_enabled = false [02:08:02.943] idle_session_timeout_enabled = false [02:08:02.943] __func__ = "PostgresMain" [02:08:02.943] #24 0x0000564960768ae1 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [02:08:02.943] bsdata = [02:08:02.943] #25 0x000056496061a20f in postmaster_child_launch (child_type=B_BACKEND, child_slot=7, startup_data=startup_data@entry=0x7fff6237380c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff62373860) at ../src/backend/postmaster/launch_backend.c:274 [02:08:02.943] pid = [02:08:02.943] #26 0x000056496061f20a in BackendStartup (client_sock=client_sock@entry=0x7fff62373860) at ../src/backend/postmaster/postmaster.c:3386 [02:08:02.943] bn = 0x56496198e188 [02:08:02.943] pid = [02:08:02.943] startup_data = {canAcceptConnections = CAC_OK} [02:08:02.943] cac = [02:08:02.943] __func__ = "BackendStartup" [02:08:02.943] #27 0x00005649606210e3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [02:08:02.943] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "7b\377\177\000\000\36487b\377\177", '\000' , "B\246y_IV\000\000ȇu_IV\000\000\30097b\377\177\000\000\27097b\377\177\000\000\225[\362\001\000\000\000\000\240tH%\261\177\000\000+", '\000' , "P\245y_IV\000\000hF\353%\261\177\000\0000vH%\261\177\000", __ss_align = 140398822114016}, salen = 2}} [02:08:02.943] i = 0 [02:08:02.943] now = [02:08:02.943] last_lockfile_recheck_time = 1736128967 [02:08:02.943] last_touch_time = 1736128967 [02:08:02.943] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1601807938, events = 22089, fd = 636175976, user_data = 0x7fb125487630}, {pos = 636175072, events = 32689, fd = 2090263927, user_data = 0x7fff62373a40}, {pos = 636004936, events = 32689, fd = 15, user_data = 0x7fb125487630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 636175072, events = 32689, fd = 1647786424, user_data = 0x7fff623739c0}, {pos = 636175976, events = 32689, fd = 0, user_data = 0x564961965bb0}, {pos = 1621734699, events = 22089, fd = 32768, user_data = 0x1}, {pos = 1637251040, events = 22089, fd = -1, user_data = 0x7fb12462e020}, {pos = 632491936, events = 32689, fd = 1637429704, user_data = 0x5649619930a8}, {pos = 1637428865, events = 22089, fd = 636030654, user_data = 0x1}, {pos = 636175072, events = 32689, fd = 426, user_data = 0x564960fb3d50 }, {pos = 0, events = 0, fd = 236, user_data = 0x564961965bb0}, {pos = 636030654, events = 32689, fd = 1, user_data = 0x0}, {pos = 610459680, events = 32689, fd = 611266112, user_data = 0x10}, {pos = 1647787552, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 636039610, user_data = 0x0}, {pos = 610987428, events = 32689, fd = 0, user_data = 0x564961666a00 }, {pos = 2, events = 0, fd = 0, user_data = 0x564961927eb0}, {pos = 1617963193, events = 22089, fd = 1637451115, user_data = 0x5649607064f2 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x564961965bb0}, {pos = 636030654, events = 32689, fd = 1, user_data = 0x0}, {pos = 610493640, events = 32689, fd = 610912384, user_data = 0x437}, {pos = 611020909, events = 32689, fd = 2, user_data = 0x564961998510}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = 612310112, events = 32689, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x754942732d737365}, {pos = 168454726, events = 857743392, fd = 822763892, user_data = 0x30340a3736393832}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = 1621412595, events = 22089, fd = 1637434496, user_data = 0x7fb1246b58be}, {pos = 612293088, events = 32689, fd = 610931054, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x88dd25d4b537d800}, {pos = 612296160, events = 32689, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1637429096, user_data = 0x3}, {pos = 0, events = 0, fd = 20462, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1637243824, user_data = 0x7fb1246f3053 }, {pos = 1637429096, events = 22089, fd = 1024, user_data = 0x7fff62373ee8}, {pos = 1621495911, events = 22089, fd = 1634166288, user_data = 0x564960a4fb24 }, {pos = 1637428896, events = 22089, fd = 1637243376, user_data = 0x564961992ea0}, {pos = 611014846, events = 32689, fd = 0, user_data = 0x564960a6178e }, {pos = 1637428896, events = 1, fd = 1621498071, user_data = 0x5649619659f0}, {pos = -1254631424, events = 2296194516, fd = 0, user_data = 0x7fb1246a2ab1}, {pos = 610931952, events = 32689, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1636990640, user_data = 0x88dd25d4b537d800}, {pos = 0, events = 0, fd = -1254631424, user_data = 0xc}, {pos = -1254631424, events = 2296194516, fd = 0, user_data = 0x7fb12465b239 }, {pos = 237, events = 0, fd = 1617010444, user_data = 0x400000}, {pos = 0, events = 0, fd = 1636990640, user_data = 0x564960a4f9b8 }, {pos = 1637077280, events = 22089, fd = 1637243376, user_data = 0x56496193d120}, {pos = 1, events = 0, fd = 0, user_data = 0x564960a0e1bd }, {pos = 12, events = 0, fd = 1637420232, user_data = 0x564961990ca8}, {pos = 1634103168, events = 22089, fd = 296, user_data = 0x56496061c726 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1617026915, events = 22089, fd = 1630499760, user_data = 0x5649619663c8}} [02:08:02.943] nevents = 1 [02:08:02.943] __func__ = "ServerLoop" [02:08:02.943] #28 0x0000564960622964 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x564961923d70) at ../src/backend/postmaster/postmaster.c:1371 [02:08:02.943] opt = [02:08:02.943] status = [02:08:02.943] userDoption = [02:08:02.943] listen_addr_saved = false [02:08:02.943] output_config_variable = [02:08:02.943] __func__ = "PostmasterMain" [02:08:02.943] #29 0x000056496044f006 in main (argc=8, argv=0x564961923d70) at ../src/backend/main/main.c:230 [02:08:02.943] do_check_root = [02:08:02.943] dispatch_option = [02:08:02.975] -e [02:08:02.975] [02:08:02.975] [02:08:03.037] dumping /tmp/cores/postgres-6-24976.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:08:03.278] [New LWP 24976] [02:08:03.278] [02:08:03.278] This GDB supports auto-downloading debuginfo from the following URLs: [02:08:03.278] [02:08:03.278] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [02:08:03.278] Debuginfod has been disabled. [02:08:03.278] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [02:08:03.381] [Thread debugging using libthread_db enabled] [02:08:03.381] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [02:08:03.381] Core was generated by `postgres: postgres regression [local] SELECT '. [02:08:03.381] Program terminated with signal SIGABRT, Aborted. [02:08:03.381] #0 0x00007fb1246a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:04.304] [02:08:04.304] Thread 1 (Thread 0x7fb1243d2f00 (LWP 24976)): [02:08:04.304] #0 0x00007fb1246a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:04.304] No symbol table info available. [02:08:04.304] #1 0x00007fb12465afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:04.304] No symbol table info available. [02:08:04.304] #2 0x00007fb124645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:04.304] No symbol table info available. [02:08:04.304] #3 0x00007fb12481e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [02:08:04.304] No locals. [02:08:04.304] #4 0x00007fb12482aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [02:08:04.304] No locals. [02:08:04.304] #5 0x00007fb12480dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x564961270200, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [02:08:04.304] bp = 140734841168912 [02:08:04.304] pc = [02:08:04.304] Opts = {FromUnrecoverableHandler = true, pc = 94873148576600, bp = 94873171294728} [02:08:04.304] #6 0x000056496051d358 in examine_self_contradictory_rels (root=root@entry=0x564961ac58a8, rel=rel@entry=0x564961ac6718, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [02:08:04.304] lc__state = [02:08:04.304] rlist = [02:08:04.304] i = 3 [02:08:04.304] br = [02:08:04.304] expression = [02:08:04.304] or_rinfo = 0x564961ac8798 [02:08:04.304] ccxt = [02:08:04.304] delidx = 0x564961ac8f19 [02:08:04.304] arglst = [02:08:04.304] lc = [02:08:04.304] arg = [02:08:04.304] n = [02:08:04.304] restrictinfo = [02:08:04.304] ccwapper = {clausecxt = 0x564961ac84d8} [02:08:04.304] sec = {sopcinfo = {n_members = 38, opcies = 0x564961ac7bc8}, attrsdc = {min_attr = -6, max_attr = 7, len_set = 2, atop_array = 0x564961ac71a8, atop_set = 0x564961ac7738}, ccfree = 0x564961ac7838, vifree = 0x564961ac8b08} [02:08:04.304] __func__ = "examine_self_contradictory_rels" [02:08:04.304] #7 0x000056496051d567 in examine_self_contradictory_rels_phase1 (root=root@entry=0x564961ac58a8) at ../src/backend/optimizer/plan/contradictory.c:2608 [02:08:04.304] rel = 0x564961ac6718 [02:08:04.304] rti = 1 [02:08:04.304] rinfo = [02:08:04.304] #8 0x00005649604e8520 in query_planner (root=root@entry=0x564961ac58a8, qp_callback=qp_callback@entry=0x5649604ed83d , qp_extra=qp_extra@entry=0x7fff62372610) at ../src/backend/optimizer/plan/planmain.c:193 [02:08:04.304] parse = 0x564961afc528 [02:08:04.304] joinlist = 0x564961ac77a8 [02:08:04.304] final_rel = [02:08:04.304] __func__ = "query_planner" [02:08:04.304] #9 0x00005649604faf9c in grouping_planner (root=root@entry=0x564961ac58a8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [02:08:04.304] sort_input_targets = 0x564961ac6608 [02:08:04.304] sort_input_target_parallel_safe = [02:08:04.304] grouping_target = [02:08:04.304] scanjoin_target = [02:08:04.304] activeWindows = 0x0 [02:08:04.304] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [02:08:04.304] sort_input_targets_contain_srfs = 0x2 [02:08:04.304] have_grouping = [02:08:04.304] wflists = 0x0 [02:08:04.304] gset_data = 0x0 [02:08:04.304] sort_input_target = [02:08:04.304] grouping_targets = 0x0 [02:08:04.304] grouping_target_parallel_safe = [02:08:04.304] scanjoin_targets = 0x564961ac58a8 [02:08:04.304] scanjoin_target_parallel_safe = [02:08:04.304] grouping_targets_contain_srfs = 0x564961ac66a8 [02:08:04.304] scanjoin_targets_contain_srfs = 0x0 [02:08:04.304] scanjoin_target_same_exprs = [02:08:04.304] parse = 0x564961afc528 [02:08:04.304] offset_est = 0 [02:08:04.304] count_est = 0 [02:08:04.304] limit_tuples = -1 [02:08:04.304] have_postponed_srfs = false [02:08:04.304] final_target = [02:08:04.304] final_targets = 0x564961ac4278 [02:08:04.304] final_targets_contain_srfs = 0x56496053c240 [02:08:04.304] final_target_parallel_safe = [02:08:04.304] current_rel = [02:08:04.304] final_rel = [02:08:04.304] extra = {limit_needed = 216, limit_tuples = 4.6873574644515705e-310, count_est = 94873171289768, offset_est = 94873171286184} [02:08:04.304] lc = [02:08:04.304] __func__ = "grouping_planner" [02:08:04.304] #10 0x00005649604fdf20 in subquery_planner (glob=glob@entry=0x564961ac55c0, parse=parse@entry=0x564961afc528, 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 [02:08:04.304] root = 0x564961ac58a8 [02:08:04.304] newWithCheckOptions = [02:08:04.304] newHaving = 0x0 [02:08:04.304] hasOuterJoins = [02:08:04.304] hasResultRTEs = false [02:08:04.304] final_rel = [02:08:04.304] l = 0x0 [02:08:04.304] #11 0x00005649604febb1 in standard_planner (parse=0x564961afc528, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [02:08:04.304] result = [02:08:04.304] glob = 0x564961ac55c0 [02:08:04.304] tuple_fraction = 0 [02:08:04.304] root = [02:08:04.304] final_rel = [02:08:04.304] best_path = [02:08:04.304] top_plan = [02:08:04.304] lp = [02:08:04.304] lr = [02:08:04.304] #12 0x00005649604ffc1b in planner (parse=parse@entry=0x564961afc528, query_string=query_string@entry=0x564961afc1e0 "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 [02:08:04.304] result = [02:08:04.304] #13 0x000056496076f251 in pg_plan_query (querytree=querytree@entry=0x564961afc528, query_string=query_string@entry=0x564961afc1e0 "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 [02:08:04.304] plan = [02:08:04.304] #14 0x000056496026f1d3 in standard_ExplainOneQuery (query=0x564961afc528, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x564961ac5050, queryString=0x564961afc1e0 "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 [02:08:04.304] plan = [02:08:04.304] planstart = [02:08:04.304] planduration = {ticks = 94873147750590} [02:08:04.304] bufusage_start = {shared_blks_hit = 77543, shared_blks_read = 8, shared_blks_dirtied = 227, shared_blks_written = 227, 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}} [02:08:04.304] bufusage = {shared_blks_hit = 0, shared_blks_read = 94873150774023, shared_blks_dirtied = 154485678686208, shared_blks_written = 72057594037927936, local_blks_hit = 140398600042800, local_blks_read = 94873171510416, local_blks_dirtied = 94873171510568, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94873153632875, shared_blk_read_time = {ticks = 140398600042800}, shared_blk_write_time = {ticks = 94873153632894}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94873154013939}, temp_blk_read_time = {ticks = 94873171509472}, temp_blk_write_time = {ticks = 64}} [02:08:04.304] mem_counters = {nblocks = 94873171285280, freechunks = 4294967297, totalspace = 140734841170048, freespace = 10} [02:08:04.304] planner_ctx = 0x0 [02:08:04.304] saved_ctx = 0x0 [02:08:04.304] #15 0x000056496026f4b9 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x564961ac5050, pstate=pstate@entry=0x564961ac4f40, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [02:08:04.304] No locals. [02:08:04.304] #16 0x0000564960270410 in ExplainQuery (pstate=pstate@entry=0x564961ac4f40, stmt=stmt@entry=0x564961afc3d0, params=params@entry=0x0, dest=dest@entry=0x564961ac4eb0) at ../src/backend/commands/explain.c:357 [02:08:04.304] l__state = [02:08:04.304] l = 0x564961ac5588 [02:08:04.304] es = 0x564961ac5050 [02:08:04.304] tstate = [02:08:04.304] jstate = [02:08:04.304] query = [02:08:04.304] rewritten = 0x564961ac5570 [02:08:04.304] lc = 0x0 [02:08:04.304] timing_set = false [02:08:04.304] buffers_set = false [02:08:04.304] summary_set = false [02:08:04.304] __func__ = "ExplainQuery" [02:08:04.304] #17 0x0000564960779c71 in standard_ProcessUtility (pstmt=0x564961afc2c0, queryString=0x564961afc1e0 "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=0x564961ac4eb0, qc=0x7fff62372b00) at ../src/backend/tcop/utility.c:866 [02:08:04.304] parsetree = 0x564961afc3d0 [02:08:04.304] isTopLevel = false [02:08:04.304] isAtomicContext = true [02:08:04.304] pstate = 0x564961ac4f40 [02:08:04.304] readonly_flags = [02:08:04.304] __func__ = "standard_ProcessUtility" [02:08:04.304] #18 0x000056496077a39a in ProcessUtility (pstmt=pstmt@entry=0x564961afc2c0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_QUERY, params=, queryEnv=, dest=0x564961ac4eb0, qc=0x7fff62372b00) at ../src/backend/tcop/utility.c:523 [02:08:04.304] No locals. [02:08:04.304] #19 0x0000564960775d58 in PortalRunUtility (portal=portal@entry=0x5649619eaa90, pstmt=0x564961afc2c0, isTopLevel=isTopLevel@entry=false, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x564961ac4eb0, qc=qc@entry=0x7fff62372b00) at ../src/backend/tcop/pquery.c:1152 [02:08:04.304] No locals. [02:08:04.304] #20 0x00005649607765cb in FillPortalStore (portal=portal@entry=0x5649619eaa90, isTopLevel=isTopLevel@entry=false) at ../src/backend/tcop/pquery.c:1025 [02:08:04.304] treceiver = 0x564961ac4eb0 [02:08:04.304] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:08:04.304] __func__ = "FillPortalStore" [02:08:04.304] #21 0x0000564960776eff in PortalRunFetch (portal=portal@entry=0x5649619eaa90, fdirection=fdirection@entry=FETCH_FORWARD, count=count@entry=10, dest=dest@entry=0x564960f9f500 ) at ../src/backend/tcop/pquery.c:1433 [02:08:04.304] _save_exception_stack = 0x7fff623730b0 [02:08:04.304] _save_context_stack = 0x7fff62372f20 [02:08:04.304] _local_sigjmp_buf = {{__jmpbuf = {94873159595264, 3272947189937238248, 0, 10, 140734841171776, 94873171064968, 9081472862448152808, 3272951392816099560}, __mask_was_saved = 0, __saved_mask = {__val = {1614900495, 94873171509728, 94873154024075, 140734841171744, 94873147500366, 144, 140398600809447, 94873171156976, 8192, 94873171139504, 94873171156976, 94873171156976, 94873171157232, 0, 94873154016182, 0}}}} [02:08:04.304] _do_rethrow = [02:08:04.304] result = [02:08:04.304] saveActivePortal = 0x5649619ea980 [02:08:04.304] saveResourceOwner = 0x5649619a9d38 [02:08:04.304] savePortalContext = 0x564961aff910 [02:08:04.304] oldContext = 0x564961a77f00 [02:08:04.304] __func__ = "PortalRunFetch" [02:08:04.304] #22 0x0000564960416e90 in _SPI_cursor_operation (portal=portal@entry=0x5649619eaa90, direction=direction@entry=FETCH_FORWARD, count=count@entry=10, dest=0x564960f9f500 ) at ../src/backend/executor/spi.c:3027 [02:08:04.304] nfetched = [02:08:04.304] __func__ = "_SPI_cursor_operation" [02:08:04.304] #23 0x000056496041c8b8 in SPI_cursor_fetch (portal=portal@entry=0x5649619eaa90, forward=forward@entry=true, count=10) at ../src/backend/executor/spi.c:1808 [02:08:04.304] No locals. [02:08:04.304] #24 0x00007fb118b96236 in exec_for_query (estate=estate@entry=0x7fff62372f40, stmt=stmt@entry=0x564961a8f888, portal=portal@entry=0x5649619eaa90, prefetch_ok=, prefetch_ok@entry=true) at ../src/pl/plpgsql/src/pl_exec.c:5887 [02:08:04.304] var = 0x564961a8f8d8 [02:08:04.304] tuptab = [02:08:04.304] found = false [02:08:04.304] rc = 0 [02:08:04.304] previous_id = 1 [02:08:04.304] tupdescs_match = true [02:08:04.304] n = [02:08:04.304] #25 0x00007fb118b96e40 in exec_stmt_dynfors (estate=estate@entry=0x7fff62372f40, stmt=stmt@entry=0x564961a8f888) at ../src/pl/plpgsql/src/pl_exec.c:4645 [02:08:04.304] portal = 0x5649619eaa90 [02:08:04.304] rc = [02:08:04.304] #26 0x00007fb118b92738 in exec_stmts (estate=estate@entry=0x7fff62372f40, stmts=0x564961a8ff88) at ../src/pl/plpgsql/src/pl_exec.c:2096 [02:08:04.304] stmt = 0x564961a8f888 [02:08:04.304] rc = [02:08:04.304] s__state = [02:08:04.304] save_estmt = 0x564961a8ffd8 [02:08:04.304] s = [02:08:04.304] __func__ = "exec_stmts" [02:08:04.304] #27 0x00007fb118b93406 in exec_stmt_block (estate=estate@entry=0x7fff62372f40, block=block@entry=0x564961a8ffd8) at ../src/pl/plpgsql/src/pl_exec.c:1939 [02:08:04.304] rc = -1 [02:08:04.304] i = 3 [02:08:04.304] __func__ = "exec_stmt_block" [02:08:04.304] #28 0x00007fb118b9354d in exec_toplevel_block (estate=estate@entry=0x7fff62372f40, block=0x564961a8ffd8) at ../src/pl/plpgsql/src/pl_exec.c:1630 [02:08:04.304] rc = [02:08:04.304] #29 0x00007fb118b93c82 in plpgsql_exec_function (func=func@entry=0x5649619a9928, fcinfo=fcinfo@entry=0x564961a92460, 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 [02:08:04.304] estate = {func = 0x5649619a9928, 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 = 0x564961a87f50, tuple_store_owner = 0x5649619a9d38, rsi = 0x7fff623731f0, found_varno = 4, ndatums = 9, datums = 0x564961aa8150, datum_context = 0x564961aa8000, paramLI = 0x564961aa8100, simple_eval_estate = 0x564961a96050, simple_eval_resowner = 0x5649619a7da8, procedure_resowner = 0x0, cast_hash = 0x564961ab2120, stmt_mcontext = 0x564961aa5ff0, stmt_mcontext_parent = 0x564961aa8000, eval_tuptable = 0x0, eval_processed = 0, eval_econtext = 0x564961a96260, err_stmt = 0x564961a8f888, err_var = 0x0, err_text = 0x0, plugin_info = 0x0} [02:08:04.304] plerrcontext = {previous = 0x0, callback = 0x7fb118b90917 , arg = 0x7fff62372f40} [02:08:04.304] i = 1 [02:08:04.304] rc = [02:08:04.304] __func__ = "plpgsql_exec_function" [02:08:04.304] #30 0x00007fb118b9cfe0 in plpgsql_call_handler (fcinfo=0x564961a92460) at ../src/pl/plpgsql/src/pl_handler.c:276 [02:08:04.304] _save_exception_stack = 0x7fff623734e0 [02:08:04.304] _save_context_stack = 0x0 [02:08:04.304] _local_sigjmp_buf = {{__jmpbuf = {94873170123048, -9081197359195459352, 0, 94873171035272, 1, 94873171037728, 9081472862206980328, 9122932122827780328}, __mask_was_saved = 0, __saved_mask = {__val = {94873171076232, 0, 0, 0, 94873146712063, 94873171076192, 94873171036904, 32, 94873146914685, 94873171037320, 94873171035272, 94873171075936, 94873171076192, 94873171075936, 94873147117363, 94873171076192}}}} [02:08:04.304] _do_rethrow = false [02:08:04.304] nonatomic = false [02:08:04.304] func = 0x5649619a9928 [02:08:04.304] save_cur_estate = 0x0 [02:08:04.304] procedure_resowner = 0x0 [02:08:04.304] retval = 0 [02:08:04.304] rc = [02:08:04.304] __func__ = "plpgsql_call_handler" [02:08:04.304] #31 0x0000564960388e38 in ExecMakeTableFunctionResult (setexpr=0x564961a885b8, econtext=0x564961a88488, argContext=, expectedDesc=0x564961a88e20, randomAccess=false) at ../src/backend/executor/execSRF.c:234 [02:08:04.304] result = 140398601131592 [02:08:04.304] tupstore = 0x0 [02:08:04.304] tupdesc = 0x0 [02:08:04.304] funcrettype = 2249 [02:08:04.304] returnsTuple = [02:08:04.304] returnsSet = true [02:08:04.304] fcinfo = 0x564961a92460 [02:08:04.304] fcusage = {fs = 0x0, save_f_total_time = {ticks = 94873153486276}, save_total = {ticks = 140398601131632}, start = {ticks = 140398601131632}} [02:08:04.304] rsinfo = {type = T_ReturnSetInfo, econtext = 0x564961a88488, expectedDesc = 0x564961a88e20, allowedModes = 11, returnMode = SFRM_ValuePerCall, isDone = ExprSingleResult, setResult = 0x0, setDesc = 0x0} [02:08:04.304] tmptup = {t_len = 415192712, t_self = {ip_blkid = {bi_hi = 32689, bi_lo = 0}, ip_posid = 2}, t_tableOid = 0, t_data = 0x1} [02:08:04.304] callerContext = 0x564961a87f50 [02:08:04.304] first_time = true [02:08:04.304] __func__ = "ExecMakeTableFunctionResult" [02:08:04.304] #32 0x00005649603b925c in FunctionNext (node=0x564961a88278) at ../src/backend/executor/nodeFunctionscan.c:94 [02:08:04.304] tstore = 0x0 [02:08:04.304] estate = [02:08:04.304] direction = ForwardScanDirection [02:08:04.304] scanslot = 0x564961a89040 [02:08:04.304] alldone = [02:08:04.304] oldpos = [02:08:04.304] funcno = [02:08:04.304] att = [02:08:04.304] #33 0x000056496038a798 in ExecScanFetch (node=node@entry=0x564961a88278, accessMtd=accessMtd@entry=0x5649603b9027 , recheckMtd=recheckMtd@entry=0x5649603b8f33 ) at ../src/backend/executor/execScan.c:131 [02:08:04.304] estate = [02:08:04.304] #34 0x000056496038a8a2 in ExecScan (node=0x564961a88278, accessMtd=accessMtd@entry=0x5649603b9027 , recheckMtd=recheckMtd@entry=0x5649603b8f33 ) at ../src/backend/executor/execScan.c:180 [02:08:04.304] econtext = 0x564961a88488 [02:08:04.304] qual = 0x0 [02:08:04.304] projInfo = 0x0 [02:08:04.304] #35 0x00005649603b8fab in ExecFunctionScan (pstate=) at ../src/backend/executor/nodeFunctionscan.c:269 [02:08:04.304] node = [02:08:04.304] #36 0x000056496038351f in ExecProcNodeFirst (node=0x564961a88278) at ../src/backend/executor/execProcnode.c:469 [02:08:04.304] No locals. [02:08:04.304] #37 0x000056496036ea01 in ExecProcNode (node=node@entry=0x564961a88278) at ../src/include/executor/executor.h:272 [02:08:04.304] No locals. [02:08:04.304] #38 0x000056496036f8bf in ExecutePlan (queryDesc=queryDesc@entry=0x564961affa10, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x5649619c2790) at ../src/backend/executor/execMain.c:1655 [02:08:04.304] estate = 0x564961a88050 [02:08:04.304] planstate = 0x564961a88278 [02:08:04.304] use_parallel_mode = false [02:08:04.304] slot = [02:08:04.304] current_tuple_count = 0 [02:08:04.304] #39 0x0000564960370acb in standard_ExecutorRun (queryDesc=0x564961affa10, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:363 [02:08:04.304] estate = 0x564961a88050 [02:08:04.304] operation = CMD_SELECT [02:08:04.304] dest = 0x5649619c2790 [02:08:04.304] sendTuples = [02:08:04.304] oldcontext = 0x564961aff910 [02:08:04.304] #40 0x0000564960370b2b in ExecutorRun (queryDesc=queryDesc@entry=0x564961affa10, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:300 [02:08:04.304] No locals. [02:08:04.304] #41 0x0000564960773655 in PortalRunSelect (portal=portal@entry=0x5649619ea980, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x5649619c2790) at ../src/backend/tcop/pquery.c:920 [02:08:04.304] queryDesc = 0x564961affa10 [02:08:04.304] direction = [02:08:04.304] nprocessed = [02:08:04.304] __func__ = "PortalRunSelect" [02:08:04.304] #42 0x0000564960776a1d in PortalRun (portal=portal@entry=0x5649619ea980, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5649619c2790, altdest=altdest@entry=0x5649619c2790, qc=qc@entry=0x7fff62373600) at ../src/backend/tcop/pquery.c:764 [02:08:04.304] _save_exception_stack = 0x7fff623736b0 [02:08:04.304] _save_context_stack = 0x0 [02:08:04.304] _local_sigjmp_buf = {{__jmpbuf = {0, 3272947211848282344, 94873170389376, 94873169849144, 94873169849120, 94873169849072, 9081472862339100904, 3272951392998289640}, __mask_was_saved = 0, __saved_mask = {__val = {94873154018356, 1647785359, 4, 94873169849072, 112, 179, 94873170389376, 94873169849144, 94873169849120, 94873169849072, 94873154105559, 1, 2, 179, 94873143351711, 0}}}} [02:08:04.304] _do_rethrow = [02:08:04.304] result = [02:08:04.304] nprocessed = [02:08:04.304] saveTopTransactionResourceOwner = 0x5649619a75b8 [02:08:04.304] saveTopTransactionContext = 0x5649619fc9a0 [02:08:04.304] saveActivePortal = 0x0 [02:08:04.304] saveResourceOwner = 0x5649619a75b8 [02:08:04.304] savePortalContext = 0x0 [02:08:04.304] saveMemoryContext = 0x5649619fc9a0 [02:08:04.304] __func__ = "PortalRun" [02:08:04.304] #43 0x000056496076fd1d in exec_simple_query (query_string=query_string@entry=0x564961965af0 "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 [02:08:04.304] cmdtaglen = 6 [02:08:04.304] snapshot_set = [02:08:04.304] per_parsetree_context = 0x0 [02:08:04.304] plantree_list = 0x5649619c2740 [02:08:04.304] parsetree = 0x564961966af0 [02:08:04.304] commandTag = [02:08:04.304] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:08:04.304] querytree_list = [02:08:04.304] portal = 0x5649619ea980 [02:08:04.304] receiver = 0x5649619c2790 [02:08:04.304] format = 0 [02:08:04.304] cmdtagname = [02:08:04.304] parsetree_item__state = [02:08:04.304] dest = DestRemote [02:08:04.304] oldcontext = 0x5649619fc9a0 [02:08:04.304] parsetree_list = 0x564961966b20 [02:08:04.304] parsetree_item = 0x564961966b38 [02:08:04.304] save_log_statement_stats = false [02:08:04.304] was_logged = false [02:08:04.304] use_implicit_block = false [02:08:04.304] msec_str = "\004\000\000\000\000\000\000\000\201\366\242`IV\000\000\22067b\377\177\000\000x\000\000\000\000\000\000" [02:08:04.304] __func__ = "exec_simple_query" [02:08:04.304] #44 0x0000564960772a76 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [02:08:04.304] query_string = 0x564961965af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');" [02:08:04.304] firstchar = [02:08:04.304] input_message = {data = 0x564961965af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');", len = 120, maxlen = 1024, cursor = 120} [02:08:04.304] local_sigjmp_buf = {{__jmpbuf = {94873166767704, 3272949056509473000, 140734841174028, 4, 6, 140734841174260, 9081472862271992040, 3272951394984947944}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94873169575440, 15744, 94873166761760, 94873170109808, 6, 94873154017904, 0, 9, 2, 94873166767712, 94873169575440, 94873166761760, 4, 6, 140734841174260}}}} [02:08:04.304] send_ready_for_query = false [02:08:04.304] idle_in_transaction_timeout_enabled = false [02:08:04.304] idle_session_timeout_enabled = false [02:08:04.304] __func__ = "PostgresMain" [02:08:04.304] #45 0x0000564960768ae1 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [02:08:04.304] bsdata = [02:08:04.304] #46 0x000056496061a20f in postmaster_child_launch (child_type=B_BACKEND, child_slot=6, startup_data=startup_data@entry=0x7fff6237380c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff62373860) at ../src/backend/postmaster/launch_backend.c:274 [02:08:04.304] pid = [02:08:04.304] #47 0x000056496061f20a in BackendStartup (client_sock=client_sock@entry=0x7fff62373860) at ../src/backend/postmaster/postmaster.c:3386 [02:08:04.304] bn = 0x56496198e158 [02:08:04.304] pid = [02:08:04.304] startup_data = {canAcceptConnections = CAC_OK} [02:08:04.304] cac = [02:08:04.304] __func__ = "BackendStartup" [02:08:04.304] #48 0x00005649606210e3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [02:08:04.304] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "7b\377\177\000\000\36487b\377\177", '\000' , "B\246y_IV\000\000ȇu_IV\000\000\30097b\377\177\000\000\27097b\377\177\000\000\225[\362\001\000\000\000\000\240tH%\261\177\000\000+", '\000' , "P\245y_IV\000\000hF\353%\261\177\000\0000vH%\261\177\000", __ss_align = 140398822114016}, salen = 2}} [02:08:04.304] i = 0 [02:08:04.304] now = [02:08:04.304] last_lockfile_recheck_time = 1736128967 [02:08:04.304] last_touch_time = 1736128967 [02:08:04.304] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1601807938, events = 22089, fd = 636175976, user_data = 0x7fb125487630}, {pos = 636175072, events = 32689, fd = 2090263927, user_data = 0x7fff62373a40}, {pos = 636004936, events = 32689, fd = 15, user_data = 0x7fb125487630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 636175072, events = 32689, fd = 1647786424, user_data = 0x7fff623739c0}, {pos = 636175976, events = 32689, fd = 0, user_data = 0x564961965bb0}, {pos = 1621734699, events = 22089, fd = 32768, user_data = 0x1}, {pos = 1637251040, events = 22089, fd = -1, user_data = 0x7fb12462e020}, {pos = 632491936, events = 32689, fd = 1637429704, user_data = 0x5649619930a8}, {pos = 1637428865, events = 22089, fd = 636030654, user_data = 0x1}, {pos = 636175072, events = 32689, fd = 426, user_data = 0x564960fb3d50 }, {pos = 0, events = 0, fd = 236, user_data = 0x564961965bb0}, {pos = 636030654, events = 32689, fd = 1, user_data = 0x0}, {pos = 610459680, events = 32689, fd = 611266112, user_data = 0x10}, {pos = 1647787552, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 636039610, user_data = 0x0}, {pos = 610987428, events = 32689, fd = 0, user_data = 0x564961666a00 }, {pos = 2, events = 0, fd = 0, user_data = 0x564961927eb0}, {pos = 1617963193, events = 22089, fd = 1637451115, user_data = 0x5649607064f2 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x564961965bb0}, {pos = 636030654, events = 32689, fd = 1, user_data = 0x0}, {pos = 610493640, events = 32689, fd = 610912384, user_data = 0x437}, {pos = 611020909, events = 32689, fd = 2, user_data = 0x564961998510}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = 612310112, events = 32689, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x754942732d737365}, {pos = 168454726, events = 857743392, fd = 822763892, user_data = 0x30340a3736393832}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = 1621412595, events = 22089, fd = 1637434496, user_data = 0x7fb1246b58be}, {pos = 612293088, events = 32689, fd = 610931054, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x88dd25d4b537d800}, {pos = 612296160, events = 32689, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1637429096, user_data = 0x3}, {pos = 0, events = 0, fd = 20462, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1637243824, user_data = 0x7fb1246f3053 }, {pos = 1637429096, events = 22089, fd = 1024, user_data = 0x7fff62373ee8}, {pos = 1621495911, events = 22089, fd = 1634166288, user_data = 0x564960a4fb24 }, {pos = 1637428896, events = 22089, fd = 1637243376, user_data = 0x564961992ea0}, {pos = 611014846, events = 32689, fd = 0, user_data = 0x564960a6178e }, {pos = 1637428896, events = 1, fd = 1621498071, user_data = 0x5649619659f0}, {pos = -1254631424, events = 2296194516, fd = 0, user_data = 0x7fb1246a2ab1}, {pos = 610931952, events = 32689, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1636990640, user_data = 0x88dd25d4b537d800}, {pos = 0, events = 0, fd = -1254631424, user_data = 0xc}, {pos = -1254631424, events = 2296194516, fd = 0, user_data = 0x7fb12465b239 }, {pos = 237, events = 0, fd = 1617010444, user_data = 0x400000}, {pos = 0, events = 0, fd = 1636990640, user_data = 0x564960a4f9b8 }, {pos = 1637077280, events = 22089, fd = 1637243376, user_data = 0x56496193d120}, {pos = 1, events = 0, fd = 0, user_data = 0x564960a0e1bd }, {pos = 12, events = 0, fd = 1637420232, user_data = 0x564961990ca8}, {pos = 1634103168, events = 22089, fd = 296, user_data = 0x56496061c726 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1617026915, events = 22089, fd = 1630499760, user_data = 0x5649619663c8}} [02:08:04.304] nevents = 1 [02:08:04.304] __func__ = "ServerLoop" [02:08:04.304] #49 0x0000564960622964 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x564961923d70) at ../src/backend/postmaster/postmaster.c:1371 [02:08:04.304] opt = [02:08:04.304] status = [02:08:04.304] userDoption = [02:08:04.304] listen_addr_saved = false [02:08:04.304] output_config_variable = [02:08:04.304] __func__ = "PostmasterMain" [02:08:04.304] #50 0x000056496044f006 in main (argc=8, argv=0x564961923d70) at ../src/backend/main/main.c:230 [02:08:04.304] do_check_root = [02:08:04.304] dispatch_option = [02:08:04.339] -e [02:08:04.339] [02:08:04.339] [02:08:04.400] dumping /tmp/cores/postgres-6-22981.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [02:08:04.642] [New LWP 22981] [02:08:04.642] [02:08:04.642] This GDB supports auto-downloading debuginfo from the following URLs: [02:08:04.642] [02:08:04.642] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [02:08:04.642] Debuginfod has been disabled. [02:08:04.642] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [02:08:04.744] [Thread debugging using libthread_db enabled] [02:08:04.744] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [02:08:04.744] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [02:08:04.744] Program terminated with signal SIGABRT, Aborted. [02:08:04.744] #0 0x00007fb1246a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:05.596] [02:08:05.596] Thread 1 (Thread 0x7fb1243d2f00 (LWP 22981)): [02:08:05.596] #0 0x00007fb1246a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:05.596] No symbol table info available. [02:08:05.596] #1 0x00007fb12465afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:05.596] No symbol table info available. [02:08:05.596] #2 0x00007fb124645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:05.596] No symbol table info available. [02:08:05.596] #3 0x00007fb12481e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [02:08:05.596] No locals. [02:08:05.596] #4 0x00007fb12482aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [02:08:05.596] No locals. [02:08:05.596] #5 0x00007fb12480dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x564961270200, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [02:08:05.596] bp = 140734841171280 [02:08:05.596] pc = [02:08:05.596] Opts = {FromUnrecoverableHandler = true, pc = 94873148576600, bp = 94873171743312} [02:08:05.596] #6 0x000056496051d358 in examine_self_contradictory_rels (root=root@entry=0x564961b0dcb8, rel=rel@entry=0x564961b23738, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [02:08:05.596] lc__state = [02:08:05.596] rlist = [02:08:05.596] i = 2 [02:08:05.596] br = [02:08:05.596] expression = [02:08:05.596] or_rinfo = 0x564961b36160 [02:08:05.596] ccxt = [02:08:05.596] delidx = 0x564961b35e59 [02:08:05.596] arglst = [02:08:05.596] lc = [02:08:05.596] arg = [02:08:05.596] n = [02:08:05.596] restrictinfo = [02:08:05.596] ccwapper = {clausecxt = 0x564961b357d0} [02:08:05.596] sec = {sopcinfo = {n_members = 38, opcies = 0x564961b352a0}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x564961b34e40, atop_set = 0x564961b356b0}, ccfree = 0x564961b35dd8, vifree = 0x564961b35870} [02:08:05.596] __func__ = "examine_self_contradictory_rels" [02:08:05.596] #7 0x000056496051d567 in examine_self_contradictory_rels_phase1 (root=root@entry=0x564961b0dcb8) at ../src/backend/optimizer/plan/contradictory.c:2608 [02:08:05.596] rel = 0x564961b23738 [02:08:05.596] rti = 1 [02:08:05.596] rinfo = [02:08:05.596] #8 0x00005649604e8520 in query_planner (root=root@entry=0x564961b0dcb8, qp_callback=qp_callback@entry=0x5649604ed83d , qp_extra=qp_extra@entry=0x7fff62372f50) at ../src/backend/optimizer/plan/planmain.c:193 [02:08:05.596] parse = 0x564961966f70 [02:08:05.596] joinlist = 0x564961b34eb0 [02:08:05.596] final_rel = [02:08:05.596] __func__ = "query_planner" [02:08:05.596] #9 0x00005649604faf9c in grouping_planner (root=root@entry=0x564961b0dcb8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [02:08:05.596] sort_input_targets = 0x5 [02:08:05.596] sort_input_target_parallel_safe = [02:08:05.596] grouping_target = [02:08:05.596] scanjoin_target = [02:08:05.596] activeWindows = 0x0 [02:08:05.596] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [02:08:05.596] sort_input_targets_contain_srfs = 0x1 [02:08:05.596] have_grouping = [02:08:05.596] wflists = 0x0 [02:08:05.596] gset_data = 0x0 [02:08:05.596] sort_input_target = [02:08:05.596] grouping_targets = 0x1 [02:08:05.596] grouping_target_parallel_safe = [02:08:05.596] scanjoin_targets = 0x0 [02:08:05.596] scanjoin_target_parallel_safe = [02:08:05.596] grouping_targets_contain_srfs = 0x1 [02:08:05.596] scanjoin_targets_contain_srfs = 0x564960a62f3e [02:08:05.596] scanjoin_target_same_exprs = [02:08:05.596] parse = 0x564961966f70 [02:08:05.596] offset_est = 0 [02:08:05.596] count_est = 0 [02:08:05.596] limit_tuples = -1 [02:08:05.596] have_postponed_srfs = false [02:08:05.596] final_target = [02:08:05.596] final_targets = 0x564961b22908 [02:08:05.596] final_targets_contain_srfs = 0x564960458f9a [02:08:05.596] final_target_parallel_safe = [02:08:05.596] current_rel = [02:08:05.596] final_rel = [02:08:05.596] extra = {limit_needed = false, limit_tuples = 4.6873563015720761e-310, count_est = 94873171585464, offset_est = 94873171585464} [02:08:05.596] lc = [02:08:05.596] __func__ = "grouping_planner" [02:08:05.596] #10 0x00005649604fdf20 in subquery_planner (glob=glob@entry=0x564961b0ef68, parse=parse@entry=0x564961966f70, 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 [02:08:05.596] root = 0x564961b0dcb8 [02:08:05.596] newWithCheckOptions = [02:08:05.596] newHaving = 0x0 [02:08:05.596] hasOuterJoins = [02:08:05.596] hasResultRTEs = false [02:08:05.596] final_rel = [02:08:05.596] l = 0x0 [02:08:05.596] #11 0x00005649604febb1 in standard_planner (parse=0x564961966f70, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [02:08:05.596] result = [02:08:05.596] glob = 0x564961b0ef68 [02:08:05.596] tuple_fraction = 0 [02:08:05.596] root = [02:08:05.596] final_rel = [02:08:05.596] best_path = [02:08:05.596] top_plan = [02:08:05.596] lp = [02:08:05.596] lr = [02:08:05.596] #12 0x00005649604ffc1b in planner (parse=parse@entry=0x564961966f70, query_string=query_string@entry=0x564961965af0 "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 [02:08:05.596] result = [02:08:05.596] #13 0x000056496076f251 in pg_plan_query (querytree=querytree@entry=0x564961966f70, query_string=query_string@entry=0x564961965af0 "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 [02:08:05.596] plan = [02:08:05.596] #14 0x000056496026f1d3 in standard_ExplainOneQuery (query=0x564961966f70, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x564961b0ecc8, queryString=0x564961965af0 "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 [02:08:05.596] plan = [02:08:05.596] planstart = [02:08:05.596] planduration = {ticks = 94873147750590} [02:08:05.596] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94873154018356, shared_blks_dirtied = 1647784510, shared_blks_written = 3, local_blks_hit = 4294967392, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94873169850224, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94873154105150}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94873147747971}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94873169850224}} [02:08:05.596] bufusage = {shared_blks_hit = 0, shared_blks_read = 94873150774023, shared_blks_dirtied = 133199820767232, shared_blks_written = 72057594037927936, local_blks_hit = 140398598749512, local_blks_read = 94873169851400, local_blks_dirtied = 94873169850224, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94873153632875, shared_blk_read_time = {ticks = 140398598749512}, shared_blk_write_time = {ticks = 94873153632894}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94873154013939}, temp_blk_read_time = {ticks = 94873171931984}, temp_blk_write_time = {ticks = 64}} [02:08:05.596] mem_counters = {nblocks = 94873171670680, freechunks = 4294967297, totalspace = 140734841172416, freespace = 10} [02:08:05.596] planner_ctx = 0x0 [02:08:05.596] saved_ctx = 0x0 [02:08:05.596] #15 0x000056496026f4b9 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x564961b0ecc8, pstate=pstate@entry=0x564961b63608, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [02:08:05.596] No locals. [02:08:05.596] #16 0x0000564960270410 in ExplainQuery (pstate=pstate@entry=0x564961b63608, stmt=stmt@entry=0x564961966db0, params=params@entry=0x0, dest=dest@entry=0x564961b63578) at ../src/backend/commands/explain.c:357 [02:08:05.596] l__state = [02:08:05.596] l = 0x564961b23700 [02:08:05.596] es = 0x564961b0ecc8 [02:08:05.596] tstate = [02:08:05.596] jstate = [02:08:05.596] query = [02:08:05.596] rewritten = 0x564961b236e8 [02:08:05.596] lc = 0x0 [02:08:05.596] timing_set = false [02:08:05.596] buffers_set = false [02:08:05.596] summary_set = false [02:08:05.596] __func__ = "ExplainQuery" [02:08:05.596] #17 0x0000564960779c71 in standard_ProcessUtility (pstmt=0x564961966e60, queryString=0x564961965af0 "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=0x564961b63578, qc=0x7fff62373440) at ../src/backend/tcop/utility.c:866 [02:08:05.596] parsetree = 0x564961966db0 [02:08:05.596] isTopLevel = true [02:08:05.596] isAtomicContext = false [02:08:05.596] pstate = 0x564961b63608 [02:08:05.596] readonly_flags = [02:08:05.596] __func__ = "standard_ProcessUtility" [02:08:05.596] #18 0x000056496077a39a in ProcessUtility (pstmt=pstmt@entry=0x564961966e60, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x564961b63578, qc=0x7fff62373440) at ../src/backend/tcop/utility.c:523 [02:08:05.596] No locals. [02:08:05.596] #19 0x0000564960775d58 in PortalRunUtility (portal=portal@entry=0x5649619ea980, pstmt=0x564961966e60, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x564961b63578, qc=qc@entry=0x7fff62373440) at ../src/backend/tcop/pquery.c:1152 [02:08:05.596] No locals. [02:08:05.596] #20 0x00005649607765cb in FillPortalStore (portal=portal@entry=0x5649619ea980, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [02:08:05.596] treceiver = 0x564961b63578 [02:08:05.596] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:08:05.596] __func__ = "FillPortalStore" [02:08:05.596] #21 0x0000564960776ae6 in PortalRun (portal=portal@entry=0x5649619ea980, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x564961b22be8, altdest=altdest@entry=0x564961b22be8, qc=qc@entry=0x7fff62373600) at ../src/backend/tcop/pquery.c:759 [02:08:05.596] _save_exception_stack = 0x7fff623736b0 [02:08:05.596] _save_context_stack = 0x0 [02:08:05.596] _local_sigjmp_buf = {{__jmpbuf = {0, 3272947572211347688, 94873170389376, 94873169849896, 94873169849872, 94873169849824, 9081472862339100904, 3272951392998289640}, __mask_was_saved = 0, __saved_mask = {__val = {94873154018356, 1647785359, 4, 94873169849824, 112, 153, 94873170389376, 94873169849896, 94873169849872, 94873169849824, 94873154105559, 1, 2, 153, 94873143351711, 0}}}} [02:08:05.596] _do_rethrow = [02:08:05.596] result = [02:08:05.596] nprocessed = [02:08:05.596] saveTopTransactionResourceOwner = 0x5649619a5f08 [02:08:05.596] saveTopTransactionContext = 0x5649619fc9a0 [02:08:05.596] saveActivePortal = 0x0 [02:08:05.596] saveResourceOwner = 0x5649619a5f08 [02:08:05.596] savePortalContext = 0x0 [02:08:05.596] saveMemoryContext = 0x5649619fc9a0 [02:08:05.596] __func__ = "PortalRun" [02:08:05.596] #22 0x000056496076fd1d in exec_simple_query (query_string=query_string@entry=0x564961965af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');") at ../src/backend/tcop/postgres.c:1271 [02:08:05.596] cmdtaglen = 7 [02:08:05.596] snapshot_set = [02:08:05.596] per_parsetree_context = 0x0 [02:08:05.596] plantree_list = 0x564961b22b98 [02:08:05.596] parsetree = 0x564961966de0 [02:08:05.596] commandTag = [02:08:05.596] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:08:05.596] querytree_list = [02:08:05.596] portal = 0x5649619ea980 [02:08:05.596] receiver = 0x564961b22be8 [02:08:05.596] format = 0 [02:08:05.596] cmdtagname = [02:08:05.596] parsetree_item__state = [02:08:05.596] dest = DestRemote [02:08:05.596] oldcontext = 0x5649619fc9a0 [02:08:05.596] parsetree_list = 0x564961966e10 [02:08:05.596] parsetree_item = 0x564961966e28 [02:08:05.596] save_log_statement_stats = false [02:08:05.596] was_logged = false [02:08:05.596] use_implicit_block = false [02:08:05.596] msec_str = "\004\000\000\000\000\000\000\000\201\366\242`IV\000\000\22067b\377\177\000\000S\000\000\000\000\000\000" [02:08:05.596] __func__ = "exec_simple_query" [02:08:05.596] #23 0x0000564960772a76 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [02:08:05.596] query_string = 0x564961965af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');" [02:08:05.596] firstchar = [02:08:05.596] input_message = {data = 0x564961965af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", len = 83, maxlen = 1024, cursor = 83} [02:08:05.596] local_sigjmp_buf = {{__jmpbuf = {94873166767704, 3272949056509473000, 140734841174028, 4, 13, 140734841174260, 9081472862271992040, 3272951394984947944}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94873169575440, 15744, 94873166761760, 94873170109808, 13, 94873154017904, 0, 9, 2, 94873166767712, 94873169575440, 94873166761760, 4, 13, 140734841174260}}}} [02:08:05.596] send_ready_for_query = false [02:08:05.596] idle_in_transaction_timeout_enabled = false [02:08:05.596] idle_session_timeout_enabled = false [02:08:05.596] __func__ = "PostgresMain" [02:08:05.596] #24 0x0000564960768ae1 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [02:08:05.596] bsdata = [02:08:05.596] #25 0x000056496061a20f in postmaster_child_launch (child_type=B_BACKEND, child_slot=13, startup_data=startup_data@entry=0x7fff6237380c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff62373860) at ../src/backend/postmaster/launch_backend.c:274 [02:08:05.596] pid = [02:08:05.596] #26 0x000056496061f20a in BackendStartup (client_sock=client_sock@entry=0x7fff62373860) at ../src/backend/postmaster/postmaster.c:3386 [02:08:05.596] bn = 0x56496198e2a8 [02:08:05.596] pid = [02:08:05.596] startup_data = {canAcceptConnections = CAC_OK} [02:08:05.596] cac = [02:08:05.596] __func__ = "BackendStartup" [02:08:05.596] #27 0x00005649606210e3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [02:08:05.596] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "7b\377\177\000\000\36487b\377\177", '\000' , "B\246y_IV\000\000ȇu_IV\000\000\30097b\377\177\000\000\27097b\377\177\000\000\225[\362\001\000\000\000\000\240tH%\261\177\000\000+", '\000' , "P\245y_IV\000\000hF\353%\261\177\000\0000vH%\261\177\000", __ss_align = 140398822114016}, salen = 2}} [02:08:05.596] i = 0 [02:08:05.596] now = [02:08:05.596] last_lockfile_recheck_time = 1736128967 [02:08:05.596] last_touch_time = 1736128967 [02:08:05.596] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1601807938, events = 22089, fd = 636175976, user_data = 0x7fb125487630}, {pos = 636175072, events = 32689, fd = 2090263927, user_data = 0x7fff62373a40}, {pos = 636004936, events = 32689, fd = 15, user_data = 0x7fb125487630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 636175072, events = 32689, fd = 1647786424, user_data = 0x7fff623739c0}, {pos = 636175976, events = 32689, fd = 0, user_data = 0x564961965bb0}, {pos = 1621734699, events = 22089, fd = 32768, user_data = 0x1}, {pos = 1637251040, events = 22089, fd = -1, user_data = 0x7fb12462e020}, {pos = 632491936, events = 32689, fd = 1637429704, user_data = 0x5649619930a8}, {pos = 1637428865, events = 22089, fd = 636030654, user_data = 0x1}, {pos = 636175072, events = 32689, fd = 426, user_data = 0x564960fb3d50 }, {pos = 0, events = 0, fd = 236, user_data = 0x564961965bb0}, {pos = 636030654, events = 32689, fd = 1, user_data = 0x0}, {pos = 610459680, events = 32689, fd = 611266112, user_data = 0x10}, {pos = 1647787552, events = 32767, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 636039610, user_data = 0x0}, {pos = 610987428, events = 32689, fd = 0, user_data = 0x564961666a00 }, {pos = 2, events = 0, fd = 0, user_data = 0x564961927eb0}, {pos = 1617963193, events = 22089, fd = 1637451115, user_data = 0x5649607064f2 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x564961965bb0}, {pos = 636030654, events = 32689, fd = 1, user_data = 0x0}, {pos = 610493640, events = 32689, fd = 610912384, user_data = 0x437}, {pos = 611020909, events = 32689, fd = 2, user_data = 0x564961998510}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = 612310112, events = 32689, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x754942732d737365}, {pos = 168454726, events = 857743392, fd = 822763892, user_data = 0x30340a3736393832}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = 1621412595, events = 22089, fd = 1637434496, user_data = 0x7fb1246b58be}, {pos = 612293088, events = 32689, fd = 610931054, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x88dd25d4b537d800}, {pos = 612296160, events = 32689, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1637429096, user_data = 0x3}, {pos = 0, events = 0, fd = 20462, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1637243824, user_data = 0x7fb1246f3053 }, {pos = 1637429096, events = 22089, fd = 1024, user_data = 0x7fff62373ee8}, {pos = 1621495911, events = 22089, fd = 1634166288, user_data = 0x564960a4fb24 }, {pos = 1637428896, events = 22089, fd = 1637243376, user_data = 0x564961992ea0}, {pos = 611014846, events = 32689, fd = 0, user_data = 0x564960a6178e }, {pos = 1637428896, events = 1, fd = 1621498071, user_data = 0x5649619659f0}, {pos = -1254631424, events = 2296194516, fd = 0, user_data = 0x7fb1246a2ab1}, {pos = 610931952, events = 32689, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1636990640, user_data = 0x88dd25d4b537d800}, {pos = 0, events = 0, fd = -1254631424, user_data = 0xc}, {pos = -1254631424, events = 2296194516, fd = 0, user_data = 0x7fb12465b239 }, {pos = 237, events = 0, fd = 1617010444, user_data = 0x400000}, {pos = 0, events = 0, fd = 1636990640, user_data = 0x564960a4f9b8 }, {pos = 1637077280, events = 22089, fd = 1637243376, user_data = 0x56496193d120}, {pos = 1, events = 0, fd = 0, user_data = 0x564960a0e1bd }, {pos = 12, events = 0, fd = 1637420232, user_data = 0x564961990ca8}, {pos = 1634103168, events = 22089, fd = 296, user_data = 0x56496061c726 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1617026915, events = 22089, fd = 1630499760, user_data = 0x5649619663c8}} [02:08:05.596] nevents = 1 [02:08:05.596] __func__ = "ServerLoop" [02:08:05.596] #28 0x0000564960622964 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x564961923d70) at ../src/backend/postmaster/postmaster.c:1371 [02:08:05.596] opt = [02:08:05.596] status = [02:08:05.596] userDoption = [02:08:05.596] listen_addr_saved = false [02:08:05.596] output_config_variable = [02:08:05.596] __func__ = "PostmasterMain" [02:08:05.596] #29 0x000056496044f006 in main (argc=8, argv=0x564961923d70) at ../src/backend/main/main.c:230 [02:08:05.596] do_check_root = [02:08:05.596] dispatch_option = [02:08:05.627] -e [02:08:05.627] [02:08:05.627] [02:08:05.688] dumping /tmp/cores/postgres-6-39034.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [02:08:05.942] [New LWP 39034] [02:08:05.942] [02:08:05.942] This GDB supports auto-downloading debuginfo from the following URLs: [02:08:05.942] [02:08:05.942] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [02:08:05.942] Debuginfod has been disabled. [02:08:05.942] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [02:08:06.040] [Thread debugging using libthread_db enabled] [02:08:06.040] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [02:08:06.040] Core was generated by `postgres: test: postgres db2 [local] SELECT '. [02:08:06.040] Program terminated with signal SIGABRT, Aborted. [02:08:06.040] #0 0x00007f16da2a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:06.096] [02:08:06.096] Thread 1 (Thread 0x7f16da1d5f00 (LWP 39034)): [02:08:06.096] #0 0x00007f16da2a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:06.096] No symbol table info available. [02:08:06.096] #1 0x00007f16da25afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:06.096] No symbol table info available. [02:08:06.096] #2 0x00007f16da245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:06.096] No symbol table info available. [02:08:06.096] #3 0x00007f16da41e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [02:08:06.096] No locals. [02:08:06.096] #4 0x00007f16da42aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [02:08:06.096] No locals. [02:08:06.096] #5 0x00007f16da40dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x563d473ba200, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [02:08:06.096] bp = 140730041866000 [02:08:06.096] pc = [02:08:06.096] Opts = {FromUnrecoverableHandler = true, pc = 94821174113112, bp = 139735931153576} [02:08:06.096] #6 0x0000563d46667358 in examine_self_contradictory_rels (root=root@entry=0x563d48561478, rel=rel@entry=0x563d4856b168, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [02:08:06.096] lc__state = [02:08:06.096] rlist = [02:08:06.096] i = 7 [02:08:06.096] br = [02:08:06.096] expression = [02:08:06.096] or_rinfo = 0x7f16ce89fd38 [02:08:06.096] ccxt = [02:08:06.096] delidx = 0x7f16ce8a2e91 [02:08:06.096] arglst = [02:08:06.096] lc = [02:08:06.096] arg = [02:08:06.096] n = [02:08:06.096] restrictinfo = [02:08:06.096] ccwapper = {clausecxt = 0x7f16ce8a0b28} [02:08:06.096] sec = {sopcinfo = {n_members = 38, opcies = 0x7f16ce8a02c8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7f16ce8a06d8, atop_set = 0x7f16ce89e398}, ccfree = 0x7f16ce8a2e60, vifree = 0x7f16ce8a1d78} [02:08:06.096] __func__ = "examine_self_contradictory_rels" [02:08:06.096] #7 0x0000563d46667567 in examine_self_contradictory_rels_phase1 (root=root@entry=0x563d48561478) at ../src/backend/optimizer/plan/contradictory.c:2608 [02:08:06.096] rel = 0x563d4856b168 [02:08:06.096] rti = 1 [02:08:06.096] rinfo = [02:08:06.096] #8 0x0000563d46632520 in query_planner (root=root@entry=0x563d48561478, qp_callback=qp_callback@entry=0x563d4663783d , qp_extra=qp_extra@entry=0x7ffe44279910) at ../src/backend/optimizer/plan/planmain.c:193 [02:08:06.096] parse = 0x563d48557c70 [02:08:06.096] joinlist = 0x7f16ce89e528 [02:08:06.096] final_rel = [02:08:06.096] __func__ = "query_planner" [02:08:06.096] #9 0x0000563d46644f9c in grouping_planner (root=root@entry=0x563d48561478, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [02:08:06.096] sort_input_targets = 0x563d48561478 [02:08:06.096] sort_input_target_parallel_safe = [02:08:06.096] grouping_target = [02:08:06.096] scanjoin_target = [02:08:06.096] activeWindows = 0x0 [02:08:06.096] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [02:08:06.096] sort_input_targets_contain_srfs = 0x563d4855ec70 [02:08:06.096] have_grouping = [02:08:06.096] wflists = 0x0 [02:08:06.096] gset_data = 0x0 [02:08:06.096] sort_input_target = [02:08:06.096] grouping_targets = 0x563d4855ecb8 [02:08:06.096] grouping_target_parallel_safe = [02:08:06.096] scanjoin_targets = 0x563d4855eca0 [02:08:06.096] scanjoin_target_parallel_safe = [02:08:06.096] grouping_targets_contain_srfs = 0x563d48561478 [02:08:06.096] scanjoin_targets_contain_srfs = 0x0 [02:08:06.096] scanjoin_target_same_exprs = [02:08:06.096] parse = 0x563d48557c70 [02:08:06.096] offset_est = 0 [02:08:06.096] count_est = 0 [02:08:06.096] limit_tuples = -1 [02:08:06.096] have_postponed_srfs = false [02:08:06.096] final_target = [02:08:06.096] final_targets = 0x563d48561478 [02:08:06.096] final_targets_contain_srfs = 0x7 [02:08:06.096] final_target_parallel_safe = [02:08:06.096] current_rel = [02:08:06.096] final_rel = [02:08:06.096] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94821206555760} [02:08:06.096] lc = [02:08:06.096] __func__ = "grouping_planner" [02:08:06.096] #10 0x0000563d46647f20 in subquery_planner (glob=, parse=0x563d48557c70, parent_root=parent_root@entry=0x563d48554e30, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [02:08:06.096] root = 0x563d48561478 [02:08:06.096] newWithCheckOptions = [02:08:06.096] newHaving = 0x0 [02:08:06.096] hasOuterJoins = [02:08:06.096] hasResultRTEs = true [02:08:06.096] final_rel = [02:08:06.096] l = 0x0 [02:08:06.096] #11 0x0000563d466598ba in SS_process_ctes (root=root@entry=0x563d48554e30) at ../src/backend/optimizer/plan/subselect.c:966 [02:08:06.096] subquery = [02:08:06.096] cte = 0x563d4851a200 [02:08:06.096] cmdType = [02:08:06.096] subroot = [02:08:06.096] final_rel = [02:08:06.096] best_path = [02:08:06.096] plan = [02:08:06.096] splan = [02:08:06.096] paramid = [02:08:06.096] lc__state = [02:08:06.096] lc = [02:08:06.096] __func__ = "SS_process_ctes" [02:08:06.096] #12 0x0000563d466469c4 in subquery_planner (glob=glob@entry=0x563d4852ec38, parse=parse@entry=0x563d4852ed48, 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 [02:08:06.096] root = 0x563d48554e30 [02:08:06.096] newWithCheckOptions = [02:08:06.096] newHaving = [02:08:06.096] hasOuterJoins = [02:08:06.096] hasResultRTEs = [02:08:06.096] final_rel = [02:08:06.096] l = [02:08:06.096] #13 0x0000563d46648bb1 in standard_planner (parse=0x563d4852ed48, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [02:08:06.096] result = [02:08:06.096] glob = 0x563d4852ec38 [02:08:06.096] tuple_fraction = 0 [02:08:06.096] root = [02:08:06.096] final_rel = [02:08:06.096] best_path = [02:08:06.096] top_plan = [02:08:06.096] lp = [02:08:06.096] lr = [02:08:06.096] #14 0x0000563d46649c1b in planner (parse=parse@entry=0x563d4852ed48, query_string=query_string@entry=0x563d4843e5a0 "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 [02:08:06.096] result = [02:08:06.096] #15 0x0000563d468b9251 in pg_plan_query (querytree=querytree@entry=0x563d4852ed48, query_string=query_string@entry=0x563d4843e5a0 "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 [02:08:06.096] plan = [02:08:06.096] #16 0x0000563d468b9632 in pg_plan_queries (querytrees=0x563d48554de0, query_string=query_string@entry=0x563d4843e5a0 "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 [02:08:06.096] query = 0x563d4852ed48 [02:08:06.096] stmt = [02:08:06.096] query_list__state = [02:08:06.096] stmt_list = 0x0 [02:08:06.096] query_list = [02:08:06.096] #17 0x0000563d468b9bdf in exec_simple_query (query_string=query_string@entry=0x563d4843e5a0 "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 [02:08:06.096] cmdtaglen = 6 [02:08:06.096] snapshot_set = true [02:08:06.096] per_parsetree_context = 0x0 [02:08:06.096] plantree_list = [02:08:06.096] parsetree = 0x563d4852ebb8 [02:08:06.096] commandTag = CMDTAG_SELECT [02:08:06.096] qc = {commandTag = 1935, nprocessed = 94821205403040} [02:08:06.096] querytree_list = [02:08:06.096] portal = [02:08:06.096] receiver = [02:08:06.096] format = 0 [02:08:06.096] cmdtagname = [02:08:06.096] parsetree_item__state = [02:08:06.096] dest = DestRemote [02:08:06.096] oldcontext = 0x563d484ce690 [02:08:06.096] parsetree_list = 0x563d4852ebe8 [02:08:06.096] parsetree_item = 0x563d4852ec00 [02:08:06.096] save_log_statement_stats = false [02:08:06.096] was_logged = true [02:08:06.096] use_implicit_block = false [02:08:06.096] msec_str = "\004\000\000\000\000\000\000\000\201\226\267F=V\000\000\340\234'D\376\177\000\000\217\a\000\000\000\000\000" [02:08:06.096] __func__ = "exec_simple_query" [02:08:06.096] #18 0x0000563d468bca76 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [02:08:06.096] query_string = 0x563d4843e5a0 "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 "... [02:08:06.096] firstchar = [02:08:06.096] input_message = {data = 0x563d4843e5a0 "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} [02:08:06.096] local_sigjmp_buf = {{__jmpbuf = {94821192304216, 2022520449823020820, 140730041867868, 4, 1, 140730041868100, 5735168189796062996, 2022516788497618708}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94821205130704, 14464, 94821192298272, 94821205641056, 1, 94821179554416, 0, 9, 2, 94821192304224, 94821205130704, 94821192298272, 4, 1, 140730041868100}}}} [02:08:06.096] send_ready_for_query = false [02:08:06.096] idle_in_transaction_timeout_enabled = false [02:08:06.096] idle_session_timeout_enabled = false [02:08:06.096] __func__ = "PostgresMain" [02:08:06.096] #19 0x0000563d468b2ae1 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [02:08:06.096] bsdata = [02:08:06.096] #20 0x0000563d4676420f in postmaster_child_launch (child_type=B_BACKEND, child_slot=1, startup_data=startup_data@entry=0x7ffe44279e5c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe44279eb0) at ../src/backend/postmaster/launch_backend.c:274 [02:08:06.096] pid = [02:08:06.096] #21 0x0000563d4676920a in BackendStartup (client_sock=client_sock@entry=0x7ffe44279eb0) at ../src/backend/postmaster/postmaster.c:3386 [02:08:06.096] bn = 0x563d48466278 [02:08:06.096] pid = [02:08:06.096] startup_data = {canAcceptConnections = CAC_OK} [02:08:06.096] cac = [02:08:06.096] __func__ = "BackendStartup" [02:08:06.096] #22 0x0000563d4676b0e3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [02:08:06.096] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "BF\216E=V\000\000\310'\212E=V\000\000\000\240'D\376\177\000\000\370\237'D\376\177\000\000\225[\362\001\000\000\000\000\240T\243\332\026\177\000\000+", '\000' , "\376\177\000\000\000\004\000\000\000\000\000\000hF\276\333\026\177\000\0000V\243\332\026\177\000\000\340B\276\333\026\177\000\000\316)fR\000\000\000", __ss_align = 1143447616}, salen = 2}} [02:08:06.096] i = 0 [02:08:06.096] now = [02:08:06.096] last_lockfile_recheck_time = 1736129043 [02:08:06.096] last_touch_time = 1736129043 [02:08:06.096] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -626829776, events = 32534, fd = -608288032, user_data = 0x7c96e577}, {pos = 1143447680, events = 32766, fd = -608458168, user_data = 0xf}, {pos = -626829776, events = 32534, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -608288032, user_data = 0x7ffe44279ff8}, {pos = 1143447552, events = 32766, fd = -608287128, user_data = 0x0}, {pos = 1212414496, events = 22077, fd = -634684790, user_data = 0x563d4843fa20}, {pos = 1, events = 22077, fd = 32768, user_data = 0xffffffff}, {pos = -635248608, events = 32534, fd = -613208160, user_data = 0x563d4846b018}, {pos = 1212591864, events = 22077, fd = 1212591313, user_data = 0x7f16dbbc0ebe}, {pos = 1, events = 0, fd = -608288032, user_data = 0x1aa}, {pos = 1192222032, events = 22077, fd = 0, user_data = 0xd8}, {pos = 1212414496, events = 22077, fd = -608432450, user_data = 0x1}, {pos = 0, events = 0, fd = -635248608, user_data = 0x7f16da2f2e40 }, {pos = 16, events = 0, fd = 1143448688, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f16dbbc31ba}, {pos = 0, events = 0, fd = -634720860, user_data = 0x0}, {pos = 1199245824, events = 22077, fd = 2, user_data = 0x0}, {pos = 1212153456, events = 22077, fd = 1183103268, user_data = 0x563d48470720}, {pos = 1183107257, events = 22077, fd = 1212614523, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -635214648, user_data = 0x7f16da29c880 }, {pos = -635609672, events = 32534, fd = 1143448880, user_data = 0x100007f00000002}, {pos = -634687379, events = 32534, fd = 2, user_data = 0x563d48470720}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = -633398176, events = 32534, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1969453677, events = 1111060578, fd = 168440396, user_data = 0x74616467702f6174}, {pos = 925960801, events = 842085939, fd = 1751342899, user_data = 0x305f742f61746164}, {pos = 1684826485, events = 1769300527, fd = 1949262956, user_data = 0x0}, {pos = 0, events = 22016, 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 = 1212592384, events = 22077, fd = -634684790, user_data = 0xa}, {pos = 1186556659, events = 22077, fd = 1212597024, user_data = 0x7f16da2b58be}, {pos = -633415200, events = 32534, fd = -634777234, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xa00db5c312138900}, {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 = 0x563d4846acf0}, {pos = 1, events = 0, fd = 1212591544, user_data = 0x3}, {pos = 0, events = 0, fd = 38505, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1212414496, user_data = 0x7f16da2f3053 }, {pos = 1212591544, events = 22077, fd = 1024, user_data = 0x7ffe4427a538}, {pos = 1186639975, events = 22077, fd = 1199310352, user_data = 0x563d46b99b24 }, {pos = 1212591344, events = 22077, fd = 1212406912, user_data = 0x563d4846acf0}, {pos = -634693442, events = 32534, fd = 0, user_data = 0x563d46bab78e }, {pos = 1212591344, events = 1, fd = 1186642135, user_data = 0x563d4843dc80}, {pos = 303270144, events = 2685253059, fd = 0, user_data = 0x7f16da2a2ab1}, {pos = -634776336, events = 32534, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1212153456, user_data = 0xa00db5c312138900}, {pos = 0, events = 0, fd = 303270144, user_data = 0xc}, {pos = 303270144, events = 2685253059, fd = 0, user_data = 0x7f16da25b239 }, {pos = 217, events = 0, fd = 1182154508, user_data = 0x400000}, {pos = 0, events = 0, fd = 1212153456, user_data = 0x563d46b999b8 }, {pos = 1212240816, events = 22077, fd = 1212406912, user_data = 0x563d484153b0}, {pos = 1, events = 0, fd = 0, user_data = 0x563d46b581bd }, {pos = 12, events = 0, fd = 1212582680, user_data = 0x563d48468af8}, {pos = 1199247232, events = 22077, fd = 296, user_data = 0x563d46766726 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1182170979, events = 22077, fd = 1195643824, user_data = 0x563d4843e638}} [02:08:06.096] nevents = 1 [02:08:06.096] __func__ = "ServerLoop" [02:08:06.096] #23 0x0000563d4676c964 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x563d483fbce0) at ../src/backend/postmaster/postmaster.c:1371 [02:08:06.096] opt = [02:08:06.096] status = [02:08:06.096] userDoption = [02:08:06.096] listen_addr_saved = false [02:08:06.096] output_config_variable = [02:08:06.096] __func__ = "PostmasterMain" [02:08:06.096] #24 0x0000563d46599006 in main (argc=4, argv=0x563d483fbce0) at ../src/backend/main/main.c:230 [02:08:06.096] do_check_root = [02:08:06.096] dispatch_option = [02:08:06.113] -e [02:08:06.113] [02:08:06.113] [02:08:06.174] dumping /tmp/cores/postgres-6-38917.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [02:08:06.414] [New LWP 38917] [02:08:06.414] [02:08:06.414] This GDB supports auto-downloading debuginfo from the following URLs: [02:08:06.414] [02:08:06.414] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [02:08:06.414] Debuginfod has been disabled. [02:08:06.414] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [02:08:06.510] [Thread debugging using libthread_db enabled] [02:08:06.510] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [02:08:06.510] Core was generated by `postgres: test: postgres db1 [local] SELECT '. [02:08:06.510] Program terminated with signal SIGABRT, Aborted. [02:08:06.510] #0 0x00007f16da2a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:06.565] [02:08:06.565] Thread 1 (Thread 0x7f16da1d5f00 (LWP 38917)): [02:08:06.565] #0 0x00007f16da2a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:06.565] No symbol table info available. [02:08:06.565] #1 0x00007f16da25afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:06.565] No symbol table info available. [02:08:06.565] #2 0x00007f16da245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:06.565] No symbol table info available. [02:08:06.565] #3 0x00007f16da41e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [02:08:06.565] No locals. [02:08:06.565] #4 0x00007f16da42aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [02:08:06.565] No locals. [02:08:06.565] #5 0x00007f16da40dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x563d473ba200, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [02:08:06.565] bp = 140730041866000 [02:08:06.565] pc = [02:08:06.565] Opts = {FromUnrecoverableHandler = true, pc = 94821174113112, bp = 139735931153576} [02:08:06.565] #6 0x0000563d46667358 in examine_self_contradictory_rels (root=root@entry=0x563d48561478, rel=rel@entry=0x563d4856b168, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [02:08:06.565] lc__state = [02:08:06.565] rlist = [02:08:06.565] i = 7 [02:08:06.565] br = [02:08:06.565] expression = [02:08:06.565] or_rinfo = 0x7f16ce89fd38 [02:08:06.565] ccxt = [02:08:06.565] delidx = 0x7f16ce8a2e91 [02:08:06.565] arglst = [02:08:06.565] lc = [02:08:06.565] arg = [02:08:06.565] n = [02:08:06.565] restrictinfo = [02:08:06.565] ccwapper = {clausecxt = 0x7f16ce8a0b28} [02:08:06.565] sec = {sopcinfo = {n_members = 38, opcies = 0x7f16ce8a02c8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7f16ce8a06d8, atop_set = 0x7f16ce89e398}, ccfree = 0x7f16ce8a2e60, vifree = 0x7f16ce8a1d78} [02:08:06.565] __func__ = "examine_self_contradictory_rels" [02:08:06.565] #7 0x0000563d46667567 in examine_self_contradictory_rels_phase1 (root=root@entry=0x563d48561478) at ../src/backend/optimizer/plan/contradictory.c:2608 [02:08:06.565] rel = 0x563d4856b168 [02:08:06.565] rti = 1 [02:08:06.565] rinfo = [02:08:06.565] #8 0x0000563d46632520 in query_planner (root=root@entry=0x563d48561478, qp_callback=qp_callback@entry=0x563d4663783d , qp_extra=qp_extra@entry=0x7ffe44279910) at ../src/backend/optimizer/plan/planmain.c:193 [02:08:06.565] parse = 0x563d48557c70 [02:08:06.565] joinlist = 0x7f16ce89e528 [02:08:06.565] final_rel = [02:08:06.565] __func__ = "query_planner" [02:08:06.565] #9 0x0000563d46644f9c in grouping_planner (root=root@entry=0x563d48561478, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [02:08:06.565] sort_input_targets = 0x563d48561478 [02:08:06.565] sort_input_target_parallel_safe = [02:08:06.565] grouping_target = [02:08:06.565] scanjoin_target = [02:08:06.565] activeWindows = 0x0 [02:08:06.565] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [02:08:06.565] sort_input_targets_contain_srfs = 0x563d4855ec70 [02:08:06.565] have_grouping = [02:08:06.565] wflists = 0x0 [02:08:06.565] gset_data = 0x0 [02:08:06.565] sort_input_target = [02:08:06.565] grouping_targets = 0x563d4855ecb8 [02:08:06.565] grouping_target_parallel_safe = [02:08:06.565] scanjoin_targets = 0x563d4855eca0 [02:08:06.565] scanjoin_target_parallel_safe = [02:08:06.565] grouping_targets_contain_srfs = 0x563d48561478 [02:08:06.565] scanjoin_targets_contain_srfs = 0x0 [02:08:06.565] scanjoin_target_same_exprs = [02:08:06.565] parse = 0x563d48557c70 [02:08:06.565] offset_est = 0 [02:08:06.565] count_est = 0 [02:08:06.565] limit_tuples = -1 [02:08:06.565] have_postponed_srfs = false [02:08:06.565] final_target = [02:08:06.565] final_targets = 0x563d48561478 [02:08:06.565] final_targets_contain_srfs = 0x7 [02:08:06.565] final_target_parallel_safe = [02:08:06.565] current_rel = [02:08:06.565] final_rel = [02:08:06.565] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94821206555760} [02:08:06.565] lc = [02:08:06.565] __func__ = "grouping_planner" [02:08:06.565] #10 0x0000563d46647f20 in subquery_planner (glob=, parse=0x563d48557c70, parent_root=parent_root@entry=0x563d48554e30, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [02:08:06.565] root = 0x563d48561478 [02:08:06.565] newWithCheckOptions = [02:08:06.565] newHaving = 0x0 [02:08:06.565] hasOuterJoins = [02:08:06.565] hasResultRTEs = true [02:08:06.565] final_rel = [02:08:06.565] l = 0x0 [02:08:06.565] #11 0x0000563d466598ba in SS_process_ctes (root=root@entry=0x563d48554e30) at ../src/backend/optimizer/plan/subselect.c:966 [02:08:06.565] subquery = [02:08:06.565] cte = 0x563d4851a200 [02:08:06.565] cmdType = [02:08:06.565] subroot = [02:08:06.565] final_rel = [02:08:06.565] best_path = [02:08:06.565] plan = [02:08:06.565] splan = [02:08:06.565] paramid = [02:08:06.565] lc__state = [02:08:06.565] lc = [02:08:06.565] __func__ = "SS_process_ctes" [02:08:06.565] #12 0x0000563d466469c4 in subquery_planner (glob=glob@entry=0x563d4852ec38, parse=parse@entry=0x563d4852ed48, 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 [02:08:06.565] root = 0x563d48554e30 [02:08:06.565] newWithCheckOptions = [02:08:06.565] newHaving = [02:08:06.565] hasOuterJoins = [02:08:06.565] hasResultRTEs = [02:08:06.565] final_rel = [02:08:06.565] l = [02:08:06.565] #13 0x0000563d46648bb1 in standard_planner (parse=0x563d4852ed48, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [02:08:06.565] result = [02:08:06.565] glob = 0x563d4852ec38 [02:08:06.565] tuple_fraction = 0 [02:08:06.565] root = [02:08:06.565] final_rel = [02:08:06.565] best_path = [02:08:06.565] top_plan = [02:08:06.565] lp = [02:08:06.565] lr = [02:08:06.565] #14 0x0000563d46649c1b in planner (parse=parse@entry=0x563d4852ed48, query_string=query_string@entry=0x563d4843e5a0 "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 [02:08:06.565] result = [02:08:06.565] #15 0x0000563d468b9251 in pg_plan_query (querytree=querytree@entry=0x563d4852ed48, query_string=query_string@entry=0x563d4843e5a0 "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 [02:08:06.565] plan = [02:08:06.565] #16 0x0000563d468b9632 in pg_plan_queries (querytrees=0x563d48554de0, query_string=query_string@entry=0x563d4843e5a0 "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 [02:08:06.565] query = 0x563d4852ed48 [02:08:06.565] stmt = [02:08:06.565] query_list__state = [02:08:06.565] stmt_list = 0x0 [02:08:06.565] query_list = [02:08:06.565] #17 0x0000563d468b9bdf in exec_simple_query (query_string=query_string@entry=0x563d4843e5a0 "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 [02:08:06.565] cmdtaglen = 6 [02:08:06.565] snapshot_set = true [02:08:06.565] per_parsetree_context = 0x0 [02:08:06.565] plantree_list = [02:08:06.565] parsetree = 0x563d4852ebb8 [02:08:06.565] commandTag = CMDTAG_SELECT [02:08:06.565] qc = {commandTag = 1935, nprocessed = 94821205403040} [02:08:06.565] querytree_list = [02:08:06.565] portal = [02:08:06.565] receiver = [02:08:06.565] format = 0 [02:08:06.565] cmdtagname = [02:08:06.565] parsetree_item__state = [02:08:06.565] dest = DestRemote [02:08:06.565] oldcontext = 0x563d484ce690 [02:08:06.565] parsetree_list = 0x563d4852ebe8 [02:08:06.565] parsetree_item = 0x563d4852ec00 [02:08:06.565] save_log_statement_stats = false [02:08:06.565] was_logged = true [02:08:06.565] use_implicit_block = false [02:08:06.565] msec_str = "\004\000\000\000\000\000\000\000\201\226\267F=V\000\000\340\234'D\376\177\000\000\217\a\000\000\000\000\000" [02:08:06.565] __func__ = "exec_simple_query" [02:08:06.565] #18 0x0000563d468bca76 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [02:08:06.565] query_string = 0x563d4843e5a0 "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 "... [02:08:06.565] firstchar = [02:08:06.565] input_message = {data = 0x563d4843e5a0 "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} [02:08:06.565] local_sigjmp_buf = {{__jmpbuf = {94821192304216, 2022520449823020820, 140730041867868, 4, 2, 140730041868100, 5735168189796062996, 2022516788497618708}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94821205130704, 14464, 94821192298272, 94821205641056, 2, 94821179554416, 0, 9, 2, 94821192304224, 94821205130704, 94821192298272, 4, 2, 140730041868100}}}} [02:08:06.565] send_ready_for_query = false [02:08:06.565] idle_in_transaction_timeout_enabled = false [02:08:06.565] idle_session_timeout_enabled = false [02:08:06.565] __func__ = "PostgresMain" [02:08:06.565] #19 0x0000563d468b2ae1 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [02:08:06.565] bsdata = [02:08:06.565] #20 0x0000563d4676420f in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x7ffe44279e5c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe44279eb0) at ../src/backend/postmaster/launch_backend.c:274 [02:08:06.565] pid = [02:08:06.565] #21 0x0000563d4676920a in BackendStartup (client_sock=client_sock@entry=0x7ffe44279eb0) at ../src/backend/postmaster/postmaster.c:3386 [02:08:06.565] bn = 0x563d484662a8 [02:08:06.565] pid = [02:08:06.565] startup_data = {canAcceptConnections = CAC_OK} [02:08:06.565] cac = [02:08:06.565] __func__ = "BackendStartup" [02:08:06.565] #22 0x0000563d4676b0e3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [02:08:06.565] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "BF\216E=V\000\000\310'\212E=V\000\000\000\240'D\376\177\000\000\370\237'D\376\177\000\000\225[\362\001\000\000\000\000\240T\243\332\026\177\000\000+", '\000' , "\376\177\000\000\000\004\000\000\000\000\000\000hF\276\333\026\177\000\0000V\243\332\026\177\000\000\340B\276\333\026\177\000\000\316)fR\000\000\000", __ss_align = 1143447616}, salen = 2}} [02:08:06.565] i = 0 [02:08:06.565] now = [02:08:06.565] last_lockfile_recheck_time = 1736129043 [02:08:06.565] last_touch_time = 1736129043 [02:08:06.565] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -626829776, events = 32534, fd = -608288032, user_data = 0x7c96e577}, {pos = 1143447680, events = 32766, fd = -608458168, user_data = 0xf}, {pos = -626829776, events = 32534, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -608288032, user_data = 0x7ffe44279ff8}, {pos = 1143447552, events = 32766, fd = -608287128, user_data = 0x0}, {pos = 1212414496, events = 22077, fd = -634684790, user_data = 0x563d4843fa20}, {pos = 1, events = 22077, fd = 32768, user_data = 0xffffffff}, {pos = -635248608, events = 32534, fd = -613208160, user_data = 0x563d4846b018}, {pos = 1212591864, events = 22077, fd = 1212591313, user_data = 0x7f16dbbc0ebe}, {pos = 1, events = 0, fd = -608288032, user_data = 0x1aa}, {pos = 1192222032, events = 22077, fd = 0, user_data = 0xd8}, {pos = 1212414496, events = 22077, fd = -608432450, user_data = 0x1}, {pos = 0, events = 0, fd = -635248608, user_data = 0x7f16da2f2e40 }, {pos = 16, events = 0, fd = 1143448688, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f16dbbc31ba}, {pos = 0, events = 0, fd = -634720860, user_data = 0x0}, {pos = 1199245824, events = 22077, fd = 2, user_data = 0x0}, {pos = 1212153456, events = 22077, fd = 1183103268, user_data = 0x563d48470720}, {pos = 1183107257, events = 22077, fd = 1212614523, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -635214648, user_data = 0x7f16da29c880 }, {pos = -635609672, events = 32534, fd = 1143448880, user_data = 0x100007f00000002}, {pos = -634687379, events = 32534, fd = 2, user_data = 0x563d48470720}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = -633398176, events = 32534, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1969453677, events = 1111060578, fd = 168440396, user_data = 0x74616467702f6174}, {pos = 925960801, events = 842085939, fd = 1751342899, user_data = 0x305f742f61746164}, {pos = 1684826485, events = 1769300527, fd = 1949262956, user_data = 0x0}, {pos = 0, events = 22016, 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 = 1212592384, events = 22077, fd = -634684790, user_data = 0xa}, {pos = 1186556659, events = 22077, fd = 1212597024, user_data = 0x7f16da2b58be}, {pos = -633415200, events = 32534, fd = -634777234, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xa00db5c312138900}, {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 = 0x563d4846acf0}, {pos = 1, events = 0, fd = 1212591544, user_data = 0x3}, {pos = 0, events = 0, fd = 38505, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1212414496, user_data = 0x7f16da2f3053 }, {pos = 1212591544, events = 22077, fd = 1024, user_data = 0x7ffe4427a538}, {pos = 1186639975, events = 22077, fd = 1199310352, user_data = 0x563d46b99b24 }, {pos = 1212591344, events = 22077, fd = 1212406912, user_data = 0x563d4846acf0}, {pos = -634693442, events = 32534, fd = 0, user_data = 0x563d46bab78e }, {pos = 1212591344, events = 1, fd = 1186642135, user_data = 0x563d4843dc80}, {pos = 303270144, events = 2685253059, fd = 0, user_data = 0x7f16da2a2ab1}, {pos = -634776336, events = 32534, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1212153456, user_data = 0xa00db5c312138900}, {pos = 0, events = 0, fd = 303270144, user_data = 0xc}, {pos = 303270144, events = 2685253059, fd = 0, user_data = 0x7f16da25b239 }, {pos = 217, events = 0, fd = 1182154508, user_data = 0x400000}, {pos = 0, events = 0, fd = 1212153456, user_data = 0x563d46b999b8 }, {pos = 1212240816, events = 22077, fd = 1212406912, user_data = 0x563d484153b0}, {pos = 1, events = 0, fd = 0, user_data = 0x563d46b581bd }, {pos = 12, events = 0, fd = 1212582680, user_data = 0x563d48468af8}, {pos = 1199247232, events = 22077, fd = 296, user_data = 0x563d46766726 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1182170979, events = 22077, fd = 1195643824, user_data = 0x563d4843e638}} [02:08:06.565] nevents = 1 [02:08:06.565] __func__ = "ServerLoop" [02:08:06.565] #23 0x0000563d4676c964 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x563d483fbce0) at ../src/backend/postmaster/postmaster.c:1371 [02:08:06.565] opt = [02:08:06.565] status = [02:08:06.566] userDoption = [02:08:06.566] listen_addr_saved = false [02:08:06.566] output_config_variable = [02:08:06.566] __func__ = "PostmasterMain" [02:08:06.566] #24 0x0000563d46599006 in main (argc=4, argv=0x563d483fbce0) at ../src/backend/main/main.c:230 [02:08:06.566] do_check_root = [02:08:06.566] dispatch_option = [02:08:06.583] -e [02:08:06.583] [02:08:06.583] [02:08:06.662] dumping /tmp/cores/postgres-6-28786.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [02:08:06.906] [New LWP 28786] [02:08:06.906] [02:08:06.906] This GDB supports auto-downloading debuginfo from the following URLs: [02:08:06.906] [02:08:06.906] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [02:08:06.906] Debuginfod has been disabled. [02:08:06.906] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [02:08:07.142] [Thread debugging using libthread_db enabled] [02:08:07.142] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [02:08:07.142] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN '. [02:08:07.142] Program terminated with signal SIGABRT, Aborted. [02:08:07.142] #0 0x00007f2ae88a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:07.994] [02:08:07.994] Thread 1 (Thread 0x7f2ae9037f00 (LWP 28786)): [02:08:07.994] #0 0x00007f2ae88a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:07.994] No symbol table info available. [02:08:07.994] #1 0x00007f2ae885afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:07.994] No symbol table info available. [02:08:07.994] #2 0x00007f2ae8845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [02:08:07.994] No symbol table info available. [02:08:07.994] #3 0x00007f2ae8a1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [02:08:07.994] No locals. [02:08:07.994] #4 0x00007f2ae8a2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [02:08:07.994] No locals. [02:08:07.994] #5 0x00007f2ae8a0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x563ddc84d200, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [02:08:07.994] bp = 140729653026112 [02:08:07.994] pc = [02:08:07.994] Opts = {FromUnrecoverableHandler = true, pc = 94823678714712, bp = 94823707392200} [02:08:07.994] #6 0x0000563ddbafa358 in examine_self_contradictory_rels (root=root@entry=0x563ddd5a6878, rel=rel@entry=0x563ddd628898, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [02:08:07.994] lc__state = [02:08:07.994] rlist = [02:08:07.994] i = 2 [02:08:07.994] br = [02:08:07.994] expression = [02:08:07.994] or_rinfo = 0x563ddd654600 [02:08:07.994] ccxt = [02:08:07.994] delidx = 0x563ddd654499 [02:08:07.994] arglst = [02:08:07.994] lc = [02:08:07.994] arg = [02:08:07.994] n = [02:08:07.994] restrictinfo = [02:08:07.994] ccwapper = {clausecxt = 0x563ddd653e48} [02:08:07.994] sec = {sopcinfo = {n_members = 38, opcies = 0x563ddd653918}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x563ddd652fb8, atop_set = 0x563ddd653d28}, ccfree = 0x563ddd654468, vifree = 0x563ddd653fb8} [02:08:07.994] __func__ = "examine_self_contradictory_rels" [02:08:07.994] #7 0x0000563ddbafa567 in examine_self_contradictory_rels_phase1 (root=root@entry=0x563ddd5a6878) at ../src/backend/optimizer/plan/contradictory.c:2608 [02:08:07.994] rel = 0x563ddd628898 [02:08:07.994] rti = 1 [02:08:07.994] rinfo = [02:08:07.994] #8 0x0000563ddbac5520 in query_planner (root=root@entry=0x563ddd5a6878, qp_callback=qp_callback@entry=0x563ddbaca83d , qp_extra=qp_extra@entry=0x7ffe2cfa5f40) at ../src/backend/optimizer/plan/planmain.c:193 [02:08:07.994] parse = 0x563ddd2f6d38 [02:08:07.994] joinlist = 0x563ddd653028 [02:08:07.994] final_rel = [02:08:07.994] __func__ = "query_planner" [02:08:07.994] #9 0x0000563ddbad7f9c in grouping_planner (root=root@entry=0x563ddd5a6878, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [02:08:07.994] sort_input_targets = 0x5 [02:08:07.994] sort_input_target_parallel_safe = [02:08:07.994] grouping_target = [02:08:07.994] scanjoin_target = [02:08:07.994] activeWindows = 0x0 [02:08:07.994] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [02:08:07.994] sort_input_targets_contain_srfs = 0x1 [02:08:07.994] have_grouping = [02:08:07.994] wflists = 0x0 [02:08:07.994] gset_data = 0x0 [02:08:07.994] sort_input_target = [02:08:07.994] grouping_targets = 0x1 [02:08:07.994] grouping_target_parallel_safe = [02:08:07.994] scanjoin_targets = 0x0 [02:08:07.994] scanjoin_target_parallel_safe = [02:08:07.994] grouping_targets_contain_srfs = 0x1 [02:08:07.994] scanjoin_targets_contain_srfs = 0x563ddc03ff3e [02:08:07.994] scanjoin_target_same_exprs = [02:08:07.994] parse = 0x563ddd2f6d38 [02:08:07.994] offset_est = 0 [02:08:07.994] count_est = 0 [02:08:07.994] limit_tuples = -1 [02:08:07.994] have_postponed_srfs = false [02:08:07.994] final_target = [02:08:07.994] final_targets = 0x563ddd3faa08 [02:08:07.994] final_targets_contain_srfs = 0x563ddba35f9a [02:08:07.994] final_target_parallel_safe = [02:08:07.994] current_rel = [02:08:07.994] final_rel = [02:08:07.994] extra = {limit_needed = false, limit_tuples = 4.6849121656457389e-310, count_est = 94823707388552, offset_est = 94823707388552} [02:08:07.994] lc = [02:08:07.994] __func__ = "grouping_planner" [02:08:07.994] #10 0x0000563ddbadaf20 in subquery_planner (glob=glob@entry=0x563ddd462878, parse=parse@entry=0x563ddd2f6d38, 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 [02:08:07.994] root = 0x563ddd5a6878 [02:08:07.994] newWithCheckOptions = [02:08:07.994] newHaving = 0x0 [02:08:07.994] hasOuterJoins = [02:08:07.994] hasResultRTEs = false [02:08:07.994] final_rel = [02:08:07.994] l = 0x0 [02:08:07.994] #11 0x0000563ddbadbbb1 in standard_planner (parse=parse@entry=0x563ddd2f6d38, query_string=query_string@entry=0x563ddd2f5a90 "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 [02:08:07.994] result = [02:08:07.994] glob = 0x563ddd462878 [02:08:07.994] tuple_fraction = 0 [02:08:07.994] root = [02:08:07.994] final_rel = [02:08:07.994] best_path = [02:08:07.994] top_plan = [02:08:07.994] lp = [02:08:07.994] lr = [02:08:07.994] #12 0x00007f2ae68525a2 in pgss_planner (parse=0x563ddd2f6d38, query_string=0x563ddd2f5a90 "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 [02:08:07.994] _save_exception_stack = 0x7ffe2cfa68c0 [02:08:07.994] _save_context_stack = 0x0 [02:08:07.994] _local_sigjmp_buf = {{__jmpbuf = {94823703866680, -5277039432082373594, 0, 2048, 94823703866680, 2048, -1926464003784031194, -1951668544862665690}, __mask_was_saved = 0, __saved_mask = {__val = {94823704359720, 94823704357376, 94823683640767, 94823703865576, 17004, 0, 0, 0, 387301664040, 17004, 0, 139822193819008, 139822193818944, 0, 0, 140729653381548}}}} [02:08:07.994] _do_rethrow = false [02:08:07.994] result = 0x7ffe2cfa61f8 [02:08:07.994] #13 0x0000563ddbadcc11 in planner (parse=parse@entry=0x563ddd2f6d38, query_string=query_string@entry=0x563ddd2f5a90 "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 [02:08:07.994] result = [02:08:07.994] #14 0x0000563ddbd4c251 in pg_plan_query (querytree=querytree@entry=0x563ddd2f6d38, query_string=query_string@entry=0x563ddd2f5a90 "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 [02:08:07.994] plan = [02:08:07.994] #15 0x0000563ddb84c1d3 in standard_ExplainOneQuery (query=0x563ddd2f6d38, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x563ddd4625d8, queryString=0x563ddd2f5a90 "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 [02:08:07.994] plan = [02:08:07.994] planstart = [02:08:07.994] planduration = {ticks = 94823677888702} [02:08:07.994] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94823684156468, shared_blks_dirtied = 754607470, shared_blks_written = 3, local_blks_hit = 8009189448, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94823703866680, shared_blk_read_time = {ticks = 4572608289643898656}, shared_blk_write_time = {ticks = 94823684243262}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94823677886083}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94823703866680}} [02:08:07.994] bufusage = {shared_blks_hit = 0, shared_blks_read = 94823680912135, shared_blks_dirtied = 73031623917568, shared_blks_written = 72057594037927936, local_blks_hit = 139822193809056, local_blks_read = 94823703867856, local_blks_dirtied = 94823703866680, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94823683770987, shared_blk_read_time = {ticks = 139822193809056}, shared_blk_write_time = {ticks = 94823683771006}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94823684152051}, temp_blk_read_time = {ticks = 94823704081760}, temp_blk_write_time = {ticks = 64}} [02:08:07.994] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140729653028080, freespace = 10} [02:08:07.994] planner_ctx = 0x0 [02:08:07.994] saved_ctx = 0x0 [02:08:07.994] #16 0x0000563ddb84c4b9 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x563ddd4625d8, pstate=pstate@entry=0x563ddd32b818, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [02:08:07.994] No locals. [02:08:07.994] #17 0x0000563ddb84d410 in ExplainQuery (pstate=pstate@entry=0x563ddd32b818, stmt=stmt@entry=0x563ddd2f6b78, params=params@entry=0x0, dest=dest@entry=0x563ddd32b788) at ../src/backend/commands/explain.c:357 [02:08:07.994] l__state = [02:08:07.994] l = 0x563ddd5a6840 [02:08:07.994] es = 0x563ddd4625d8 [02:08:07.994] tstate = [02:08:07.994] jstate = [02:08:07.994] query = [02:08:07.994] rewritten = 0x563ddd5a6828 [02:08:07.994] lc = 0x0 [02:08:07.994] timing_set = false [02:08:07.994] buffers_set = false [02:08:07.994] summary_set = false [02:08:07.994] __func__ = "ExplainQuery" [02:08:07.994] #18 0x0000563ddbd56c71 in standard_ProcessUtility (pstmt=pstmt@entry=0x563ddd2f6c28, queryString=queryString@entry=0x563ddd2f5a90 "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=0x563ddd32b788, qc=0x7ffe2cfa6b00) at ../src/backend/tcop/utility.c:866 [02:08:07.994] parsetree = 0x563ddd2f6b78 [02:08:07.994] isTopLevel = true [02:08:07.994] isAtomicContext = false [02:08:07.994] pstate = 0x563ddd32b818 [02:08:07.994] readonly_flags = [02:08:07.994] __func__ = "standard_ProcessUtility" [02:08:07.994] #19 0x00007f2ae6851d8f in pgss_ProcessUtility (pstmt=0x563ddd2f6c28, queryString=0x563ddd2f5a90 "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=0x563ddd32b788, qc=0x7ffe2cfa6b00) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [02:08:07.994] _save_exception_stack = 0x7ffe2cfa6ba0 [02:08:07.994] _save_context_stack = 0x0 [02:08:07.994] _local_sigjmp_buf = {{__jmpbuf = {0, 1927411751836468262, 94823703866408, 94823704082312, 140729653029632, 1, -1926464003714825178, -1951668542754241498}, __mask_was_saved = 0, __saved_mask = {__val = {94823684152051, 94823703861648, 11, 1, 94823684156468, 3711939032, 1, 94823703861648, 10, 94823704933096, 94823704933096, 1, 94823704933096, 94823704932840, 139822266806381, 86}}}} [02:08:07.994] _do_rethrow = false [02:08:07.994] duration = [02:08:07.994] bufusage = {shared_blks_hit = 0, shared_blks_read = 94823684243671, shared_blks_dirtied = 0, shared_blks_written = 94823703868408, local_blks_hit = 94823704930952, local_blks_read = 94823704930952, local_blks_dirtied = 94823704930872, local_blks_written = 140729653029392, temp_blks_read = 140729653029392, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94823679162536}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94823703868552}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94823684152051}} [02:08:07.994] walusage_start = {wal_records = 72, wal_fpi = 4, wal_bytes = 31275} [02:08:07.994] start = [02:08:07.994] rows = [02:08:07.994] bufusage_start = {shared_blks_hit = 1508, shared_blks_read = 302, shared_blks_dirtied = 18, shared_blks_written = 55, 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}} [02:08:07.994] walusage = {wal_records = 140729653029152, wal_fpi = 94823683644199, wal_bytes = 140729653029152} [02:08:07.994] parsetree = [02:08:07.994] saved_queryId = 15398652884051699192 [02:08:07.994] saved_stmt_location = 0 [02:08:07.994] saved_stmt_len = 108 [02:08:07.994] enabled = true [02:08:07.994] #20 0x0000563ddbd572e5 in ProcessUtility (pstmt=pstmt@entry=0x563ddd2f6c28, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x563ddd32b788, qc=0x7ffe2cfa6b00) at ../src/backend/tcop/utility.c:519 [02:08:07.994] No locals. [02:08:07.994] #21 0x0000563ddbd52d58 in PortalRunUtility (portal=portal@entry=0x563ddd378980, pstmt=0x563ddd2f6c28, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x563ddd32b788, qc=qc@entry=0x7ffe2cfa6b00) at ../src/backend/tcop/pquery.c:1152 [02:08:07.994] No locals. [02:08:07.994] #22 0x0000563ddbd535cb in FillPortalStore (portal=portal@entry=0x563ddd378980, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [02:08:07.994] treceiver = 0x563ddd32b788 [02:08:07.994] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:08:07.994] __func__ = "FillPortalStore" [02:08:07.994] #23 0x0000563ddbd53ae6 in PortalRun (portal=portal@entry=0x563ddd378980, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x563ddd3fbb58, altdest=altdest@entry=0x563ddd3fbb58, qc=qc@entry=0x7ffe2cfa6cc0) at ../src/backend/tcop/pquery.c:759 [02:08:07.994] _save_exception_stack = 0x7ffe2cfa6d70 [02:08:07.994] _save_context_stack = 0x0 [02:08:07.994] _local_sigjmp_buf = {{__jmpbuf = {0, -5277039289248496602, 94823704398208, 94823703866352, 94823703866328, 94823703866280, -1926464003576413146, -5277025326434991066}, __mask_was_saved = 0, __saved_mask = {__val = {94823684156468, 754609231, 4, 94823703866280, 112, 153, 94823704398208, 94823703866352, 94823703866328, 94823703866280, 94823684243671, 1, 2, 153, 94823673489823, 0}}}} [02:08:07.994] _do_rethrow = [02:08:07.994] result = [02:08:07.994] nprocessed = [02:08:07.994] saveTopTransactionResourceOwner = 0x563ddd337e58 [02:08:07.994] saveTopTransactionContext = 0x563ddd38b1c0 [02:08:07.994] saveActivePortal = 0x0 [02:08:07.994] saveResourceOwner = 0x563ddd337e58 [02:08:07.994] savePortalContext = 0x0 [02:08:07.994] saveMemoryContext = 0x563ddd38b1c0 [02:08:07.994] __func__ = "PortalRun" [02:08:07.994] #24 0x0000563ddbd4cd1d in exec_simple_query (query_string=query_string@entry=0x563ddd2f5a90 "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 [02:08:07.994] cmdtaglen = 7 [02:08:07.994] snapshot_set = [02:08:07.994] per_parsetree_context = 0x0 [02:08:07.994] plantree_list = 0x563ddd3fbb08 [02:08:07.994] parsetree = 0x563ddd2f6ba8 [02:08:07.994] commandTag = [02:08:07.994] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [02:08:07.994] querytree_list = [02:08:07.994] portal = 0x563ddd378980 [02:08:07.994] receiver = 0x563ddd3fbb58 [02:08:07.994] format = 0 [02:08:07.994] cmdtagname = [02:08:07.994] parsetree_item__state = [02:08:07.994] dest = DestRemote [02:08:07.994] oldcontext = 0x563ddd38b1c0 [02:08:07.994] parsetree_list = 0x563ddd2f6bd8 [02:08:07.994] parsetree_item = 0x563ddd2f6bf0 [02:08:07.994] save_log_statement_stats = false [02:08:07.994] was_logged = true [02:08:07.994] use_implicit_block = false [02:08:07.994] msec_str = "\004\000\000\000\000\000\000\000\201\306\000\334=V\000\000Pm\372,\376\177\000\000n\000\000\000\000\000\000" [02:08:07.994] __func__ = "exec_simple_query" [02:08:07.994] #25 0x0000563ddbd4fa76 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [02:08:07.994] query_string = 0x563ddd2f5a90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [02:08:07.994] firstchar = [02:08:07.994] input_message = {data = 0x563ddd2f5a90 "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} [02:08:07.994] local_sigjmp_buf = {{__jmpbuf = {94823696905816, -5277036459027577818, 140729653030604, 4, 19, 140729653030836, -1926464003375086554, -5277025315869146074}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94823704118064, 0, 168, 94823684156570, 0, 10, 2, 94823696905824, 94823703592496, 94823696899872, 4, 19, 140729653030836}}}} [02:08:07.994] send_ready_for_query = false [02:08:07.994] idle_in_transaction_timeout_enabled = false [02:08:07.994] idle_session_timeout_enabled = false [02:08:07.994] __func__ = "PostgresMain" [02:08:07.994] #26 0x0000563ddbd45ae1 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [02:08:07.994] bsdata = [02:08:07.994] #27 0x0000563ddbbf720f in postmaster_child_launch (child_type=B_BACKEND, child_slot=19, startup_data=startup_data@entry=0x7ffe2cfa6ecc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe2cfa6f20) at ../src/backend/postmaster/launch_backend.c:274 [02:08:07.994] pid = [02:08:07.994] #28 0x0000563ddbbfc20a in BackendStartup (client_sock=client_sock@entry=0x7ffe2cfa6f20) at ../src/backend/postmaster/postmaster.c:3386 [02:08:07.994] bn = 0x563ddd321548 [02:08:07.994] pid = [02:08:07.994] startup_data = {canAcceptConnections = CAC_OK} [02:08:07.994] cac = [02:08:07.994] __func__ = "BackendStartup" [02:08:07.994] #29 0x0000563ddbbfe0e3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [02:08:07.994] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\372,\376\177\000\000\264o\372,\376\177", '\000' , "Bv\327\332=V\000\000\310W\323\332=V\000\000\200p\372,\376\177\000\000xp\372,\376\177\000\000\225[\362\001\000\000\000\000\360\0062\335=V\000\000,", '\000' , "Pu\327\332=V\000\000h6&\352*\177\000\0000\346\006\351*\177\000", __ss_align = 139822293725920}, salen = 2}} [02:08:07.994] i = 0 [02:08:07.994] now = [02:08:07.994] last_lockfile_recheck_time = 1736128996 [02:08:07.994] last_touch_time = 1736128996 [02:08:07.994] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -623413694, events = 22077, fd = -366594456, user_data = 0x7f2ae906e630}, {pos = -366595360, events = 32554, fd = 2090263927, user_data = 0x7ffe2cfa7100}, {pos = -366765496, events = 32554, fd = 15, user_data = 0x7f2ae906e630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -366595360, events = 32554, fd = 754610296, user_data = 0x7ffe2cfa7080}, {pos = -366594456, events = 32554, fd = 0, user_data = 0x563ddd3231f8}, {pos = -603486933, events = 22077, fd = 32768, user_data = 0x1}, {pos = -584096336, events = 22077, fd = -1, user_data = 0x7f2ae882e020}, {pos = -371515488, events = 32554, fd = -583878520, user_data = 0x563ddd32b768}, {pos = -583902127, events = 22077, fd = -366739778, user_data = 0x1}, {pos = -366595360, events = 32554, fd = 426, user_data = 0x563ddc590d50 }, {pos = 0, events = 0, fd = 86, user_data = 0x563ddd3231f8}, {pos = -366739778, events = 32554, fd = 1, user_data = 0x0}, {pos = -394076128, events = 32554, fd = -393269696, user_data = 0x10}, {pos = 754611424, events = 32766, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -366730822, user_data = 0x0}, {pos = -393548380, events = 32554, fd = 0, user_data = 0x563ddcc43a00 }, {pos = 2, events = 0, fd = 0, user_data = 0x563ddd2b7ed0}, {pos = -607258439, events = 22077, fd = -583883349, user_data = 0x563ddbce34f2 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x563ddd3231f8}, {pos = -366739778, events = 32554, fd = 1, user_data = 0x0}, {pos = -394042168, events = 32554, fd = -393623424, user_data = 0x437}, {pos = -393515257, events = 32554, fd = 2, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = -392225696, events = 32554, fd = 255, user_data = 0xfffffffffffffef0}, {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 = 0xa67}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = -379034304, user_data = 0x7f2ae9686a80}, {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 = 0xa}, {pos = -603809037, events = 22077, fd = -583872128, user_data = 0x7f2ae88b576b}, {pos = -392242720, events = 32554, fd = -393604754, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x9381f24abd9e100}, {pos = -392239648, events = 32554, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -583879128, user_data = 0x3}, {pos = 0, events = 0, fd = 27807, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -583912968, user_data = 0x7f2ae88f3053 }, {pos = -583879128, events = 22077, fd = 1024, user_data = 0x7ffe2cfa75a8}, {pos = -603725721, events = 22077, fd = -591055344, user_data = 0x563ddc02cb24 }, {pos = -583879328, events = 22077, fd = -584099440, user_data = 0x563ddd32b560}, {pos = -393521301, events = 32554, fd = 0, user_data = 0x563ddc03e78e }, {pos = -583879328, events = 1, fd = -603723561, user_data = 0x563ddd2f5990}, {pos = -1411784448, events = 154672932, fd = 0, user_data = 0x7f2ae88a2ab1}, {pos = -393603856, events = 32554, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -584352048, user_data = 0x9381f24abd9e100}, {pos = 0, events = 0, fd = -1411784448, user_data = 0xc}, {pos = -1411784448, events = 154672932, fd = 0, user_data = 0x7f2ae885b239 }, {pos = 87, events = 0, fd = -608211188, user_data = 0x400000}, {pos = 0, events = 0, fd = -584352048, user_data = 0x563ddc02c9b8 }, {pos = -584265536, events = 22077, fd = -584099440, user_data = 0x563ddd2cd0c0}, {pos = 1, events = 0, fd = 0, user_data = 0x563ddbfeb1bd }, {pos = 12, events = 0, fd = -583917016, user_data = 0x563ddd322208}, {pos = -591118464, events = 22077, fd = 296, user_data = 0x563ddbbf9726 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -608194717, events = 22077, fd = -594721872, user_data = 0x563ddd2f6348}} [02:08:07.994] nevents = 1 [02:08:07.994] __func__ = "ServerLoop" [02:08:07.994] #30 0x0000563ddbbff964 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x563ddd2b3d30) at ../src/backend/postmaster/postmaster.c:1371 [02:08:07.994] opt = [02:08:07.994] status = [02:08:07.994] userDoption = [02:08:07.994] listen_addr_saved = false [02:08:07.994] output_config_variable = [02:08:07.994] __func__ = "PostmasterMain" [02:08:07.994] #31 0x0000563ddba2c006 in main (argc=4, argv=0x563ddd2b3d30) at ../src/backend/main/main.c:230 [02:08:07.994] do_check_root = [02:08:07.994] dispatch_option =