[04:32:21.274] src/tools/ci/cores_backtrace.sh linux /tmp/cores [04:32:21.489] dumping /tmp/cores/postgres-6-22909.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [04:32:21.732] [New LWP 22909] [04:32:21.732] [04:32:21.732] This GDB supports auto-downloading debuginfo from the following URLs: [04:32:21.732] [04:32:21.732] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [04:32:21.732] Debuginfod has been disabled. [04:32:21.732] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [04:32:21.975] [Thread debugging using libthread_db enabled] [04:32:21.975] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [04:32:21.975] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [04:32:21.975] Program terminated with signal SIGABRT, Aborted. [04:32:21.975] #0 0x00007f97deea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:22.970] [04:32:22.970] Thread 1 (Thread 0x7f97dedd5f00 (LWP 22909)): [04:32:22.970] #0 0x00007f97deea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:22.970] No symbol table info available. [04:32:22.970] #1 0x00007f97dee5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:22.970] No symbol table info available. [04:32:22.970] #2 0x00007f97dee45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:22.970] No symbol table info available. [04:32:22.970] #3 0x00007f97df01e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [04:32:22.970] No locals. [04:32:22.970] #4 0x00007f97df02aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [04:32:22.970] No locals. [04:32:22.970] #5 0x00007f97df00dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5624423398a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [04:32:22.970] bp = 140723196498624 [04:32:22.970] pc = [04:32:22.970] Opts = {FromUnrecoverableHandler = true, pc = 94713715510686, bp = 94714627424328} [04:32:22.970] #6 0x00005624415e4d9e in examine_self_contradictory_rels (root=root@entry=0x562477ad6068, rel=rel@entry=0x562477ae03f8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [04:32:22.970] lc__state = [04:32:22.970] rlist = [04:32:22.970] i = 2 [04:32:22.970] br = [04:32:22.970] expression = [04:32:22.970] or_rinfo = 0x562477b90d98 [04:32:22.970] ccxt = [04:32:22.970] delidx = 0x562477b90c31 [04:32:22.970] arglst = [04:32:22.970] lc = [04:32:22.970] arg = [04:32:22.970] n = [04:32:22.970] restrictinfo = [04:32:22.970] ccwapper = {clausecxt = 0x562477b905c8} [04:32:22.970] sec = {sopcinfo = {n_members = 38, opcies = 0x562477b90098}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x562477b8f848, atop_set = 0x562477b904a8}, ccfree = 0x562477b90c00, vifree = 0x562477b90738} [04:32:22.970] __func__ = "examine_self_contradictory_rels" [04:32:22.970] #7 0x00005624415e4fad in examine_self_contradictory_rels_phase1 (root=root@entry=0x562477ad6068) at ../src/backend/optimizer/plan/contradictory.c:2608 [04:32:22.970] rel = 0x562477ae03f8 [04:32:22.970] rti = 1 [04:32:22.970] rinfo = [04:32:22.970] #8 0x00005624415afe3d in query_planner (root=root@entry=0x562477ad6068, qp_callback=qp_callback@entry=0x5624415b5283 , qp_extra=qp_extra@entry=0x7ffcac2394c0) at ../src/backend/optimizer/plan/planmain.c:193 [04:32:22.970] parse = 0x562477880db8 [04:32:22.970] joinlist = 0x562477b8f8b8 [04:32:22.970] final_rel = [04:32:22.970] __func__ = "query_planner" [04:32:22.970] #9 0x00005624415c29e2 in grouping_planner (root=root@entry=0x562477ad6068, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [04:32:22.970] sort_input_targets = 0x5 [04:32:22.970] sort_input_target_parallel_safe = [04:32:22.970] grouping_target = [04:32:22.970] scanjoin_target = [04:32:22.970] activeWindows = 0x0 [04:32:22.970] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [04:32:22.970] sort_input_targets_contain_srfs = 0x1 [04:32:22.970] have_grouping = [04:32:22.970] wflists = 0x0 [04:32:22.970] gset_data = 0x0 [04:32:22.970] sort_input_target = [04:32:22.970] grouping_targets = 0x1 [04:32:22.970] grouping_target_parallel_safe = [04:32:22.970] scanjoin_targets = 0x0 [04:32:22.970] scanjoin_target_parallel_safe = [04:32:22.970] grouping_targets_contain_srfs = 0x1 [04:32:22.970] scanjoin_targets_contain_srfs = 0x562441b2b2ec [04:32:22.970] scanjoin_target_same_exprs = [04:32:22.970] parse = 0x562477880db8 [04:32:22.970] offset_est = 0 [04:32:22.970] count_est = 0 [04:32:22.970] limit_tuples = -1 [04:32:22.970] have_postponed_srfs = false [04:32:22.970] final_target = [04:32:22.970] final_targets = 0x562477982b28 [04:32:22.970] final_targets_contain_srfs = 0x5624415208b7 [04:32:22.970] final_target_parallel_safe = [04:32:22.970] current_rel = [04:32:22.970] final_rel = [04:32:22.970] extra = {limit_needed = false, limit_tuples = 4.6794792614892796e-310, count_est = 94714626666248, offset_est = 94714626666248} [04:32:22.970] lc = [04:32:22.970] __func__ = "grouping_planner" [04:32:22.970] #10 0x00005624415c5966 in subquery_planner (glob=glob@entry=0x562477ac1ef8, parse=parse@entry=0x562477880db8, 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 [04:32:22.970] root = 0x562477ad6068 [04:32:22.970] newWithCheckOptions = [04:32:22.970] newHaving = 0x0 [04:32:22.970] hasOuterJoins = [04:32:22.970] hasResultRTEs = false [04:32:22.970] final_rel = [04:32:22.970] l = 0x0 [04:32:22.970] #11 0x00005624415c65f7 in standard_planner (parse=0x562477880db8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [04:32:22.970] result = [04:32:22.970] glob = 0x562477ac1ef8 [04:32:22.970] tuple_fraction = 0 [04:32:22.970] root = [04:32:22.970] final_rel = [04:32:22.970] best_path = [04:32:22.970] top_plan = [04:32:22.970] lp = [04:32:22.970] lr = [04:32:22.970] #12 0x00005624415c7661 in planner (parse=parse@entry=0x562477880db8, query_string=query_string@entry=0x56247787fb10 "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 [04:32:22.970] result = [04:32:22.970] #13 0x00005624418373b5 in pg_plan_query (querytree=querytree@entry=0x562477880db8, query_string=query_string@entry=0x56247787fb10 "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 [04:32:22.970] plan = [04:32:22.970] #14 0x0000562441336843 in standard_ExplainOneQuery (query=0x562477880db8, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x562477ac1c58, queryString=0x56247787fb10 "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 [04:32:22.970] plan = [04:32:22.970] planstart = [04:32:22.970] planduration = {ticks = 94713714684375} [04:32:22.970] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94713720954850, shared_blks_dirtied = 2888013742, shared_blks_written = 3, local_blks_hit = 4294967440, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94714624216504, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94713721041644}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94713714681756}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94714624216504}} [04:32:22.970] bufusage = {shared_blks_hit = 0, shared_blks_read = 94713717710174, shared_blks_dirtied = 73164767903744, shared_blks_written = 72057594037927936, local_blks_hit = 140290060498592, local_blks_read = 94714624217680, local_blks_dirtied = 94714624216504, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94713720569369, shared_blk_read_time = {ticks = 140290060498592}, shared_blk_write_time = {ticks = 94713720569388}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94713720950433}, temp_blk_read_time = {ticks = 94714624397616}, temp_blk_write_time = {ticks = 64}} [04:32:22.970] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140723196499760, freespace = 10} [04:32:22.970] planner_ctx = 0x0 [04:32:22.970] saved_ctx = 0x0 [04:32:22.970] #15 0x0000562441336b29 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x562477ac1c58, pstate=pstate@entry=0x5624778ad3e8, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [04:32:22.970] No locals. [04:32:22.970] #16 0x0000562441337a80 in ExplainQuery (pstate=pstate@entry=0x5624778ad3e8, stmt=stmt@entry=0x562477880bf8, params=params@entry=0x0, dest=dest@entry=0x5624778ad358) at ../src/backend/commands/explain.c:357 [04:32:22.970] l__state = [04:32:22.970] l = 0x562477ae03c0 [04:32:22.970] es = 0x562477ac1c58 [04:32:22.970] tstate = [04:32:22.970] jstate = [04:32:22.970] query = [04:32:22.970] rewritten = 0x562477ae03a8 [04:32:22.970] lc = 0x0 [04:32:22.970] timing_set = false [04:32:22.970] buffers_set = false [04:32:22.970] summary_set = false [04:32:22.970] __func__ = "ExplainQuery" [04:32:22.970] #17 0x0000562441841dd5 in standard_ProcessUtility (pstmt=0x562477880ca8, queryString=0x56247787fb10 "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=0x5624778ad358, qc=0x7ffcac2399b0) at ../src/backend/tcop/utility.c:866 [04:32:22.970] parsetree = 0x562477880bf8 [04:32:22.970] isTopLevel = true [04:32:22.970] isAtomicContext = false [04:32:22.970] pstate = 0x5624778ad3e8 [04:32:22.970] readonly_flags = [04:32:22.970] __func__ = "standard_ProcessUtility" [04:32:22.970] #18 0x00005624418424fe in ProcessUtility (pstmt=pstmt@entry=0x562477880ca8, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5624778ad358, qc=0x7ffcac2399b0) at ../src/backend/tcop/utility.c:523 [04:32:22.970] No locals. [04:32:22.970] #19 0x000056244183debc in PortalRunUtility (portal=portal@entry=0x562477905020, pstmt=0x562477880ca8, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5624778ad358, qc=qc@entry=0x7ffcac2399b0) at ../src/backend/tcop/pquery.c:1152 [04:32:22.970] No locals. [04:32:22.970] #20 0x000056244183e72f in FillPortalStore (portal=portal@entry=0x562477905020, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [04:32:22.970] treceiver = 0x5624778ad358 [04:32:22.970] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:32:22.970] __func__ = "FillPortalStore" [04:32:22.970] #21 0x000056244183ec4a in PortalRun (portal=portal@entry=0x562477905020, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x562477982f38, altdest=altdest@entry=0x562477982f38, qc=qc@entry=0x7ffcac239b70) at ../src/backend/tcop/pquery.c:759 [04:32:22.970] _save_exception_stack = 0x7ffcac239c20 [04:32:22.970] _save_context_stack = 0x0 [04:32:22.970] _local_sigjmp_buf = {{__jmpbuf = {0, 6057641625061747373, 94714624757792, 94714624216176, 94714624216152, 94714624216104, 549623331257379501, 6057760142598793901}, __mask_was_saved = 0, __saved_mask = {__val = {94713720954850, 2888014591, 4, 94714624216104, 112, 153, 94714624757792, 94714624216176, 94714624216152, 94714624216104, 94713721042053, 1, 2, 153, 94713710287263, 0}}}} [04:32:22.970] _do_rethrow = [04:32:22.970] result = [04:32:22.970] nprocessed = [04:32:22.970] saveTopTransactionResourceOwner = 0x5624778bfd98 [04:32:22.970] saveTopTransactionContext = 0x562477917450 [04:32:22.970] saveActivePortal = 0x0 [04:32:22.970] saveResourceOwner = 0x5624778bfd98 [04:32:22.970] savePortalContext = 0x0 [04:32:22.970] saveMemoryContext = 0x562477917450 [04:32:22.970] __func__ = "PortalRun" [04:32:22.970] #22 0x0000562441837e81 in exec_simple_query (query_string=query_string@entry=0x56247787fb10 "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 [04:32:22.970] cmdtaglen = 7 [04:32:22.970] snapshot_set = [04:32:22.970] per_parsetree_context = 0x0 [04:32:22.970] plantree_list = 0x562477982ee8 [04:32:22.970] parsetree = 0x562477880c28 [04:32:22.970] commandTag = [04:32:22.970] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:32:22.970] querytree_list = [04:32:22.970] portal = 0x562477905020 [04:32:22.970] receiver = 0x562477982f38 [04:32:22.970] format = 0 [04:32:22.970] cmdtagname = [04:32:22.970] parsetree_item__state = [04:32:22.970] dest = DestRemote [04:32:22.970] oldcontext = 0x562477917450 [04:32:22.970] parsetree_list = 0x562477880c58 [04:32:22.970] parsetree_item = 0x562477880c70 [04:32:22.970] save_log_statement_stats = false [04:32:22.970] was_logged = false [04:32:22.970] use_implicit_block = false [04:32:22.970] msec_str = "\004\000\000\000\000\000\000\000/z\257A$V\000\000\000\234#\254\374\177\000\000n\000\000\000\000\000\000" [04:32:22.970] __func__ = "exec_simple_query" [04:32:22.970] #23 0x000056244183abda in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [04:32:22.970] query_string = 0x56247787fb10 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [04:32:22.970] firstchar = [04:32:22.970] input_message = {data = 0x56247787fb10 "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} [04:32:22.970] local_sigjmp_buf = {{__jmpbuf = {94713733711576, 6057758414608329389, 140723196501372, 4, 9, 140723196501604, 549623331324488365, 6057760144569461421}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94714623942192, 17408, 94713733705632, 94714624476560, 9, 94713720954398, 0, 10, 2, 94713733711584, 94714623942192, 94713733705632, 4, 9, 140723196501604}}}} [04:32:22.970] send_ready_for_query = false [04:32:22.970] idle_in_transaction_timeout_enabled = false [04:32:22.970] idle_session_timeout_enabled = false [04:32:22.970] __func__ = "PostgresMain" [04:32:22.970] #24 0x0000562441830c45 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:32:22.970] bsdata = [04:32:22.970] #25 0x00005624416e211c in postmaster_child_launch (child_type=B_BACKEND, child_slot=9, startup_data=startup_data@entry=0x7ffcac239d7c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcac239dd0) at ../src/backend/postmaster/launch_backend.c:274 [04:32:22.970] pid = [04:32:22.970] #26 0x00005624416e7328 in BackendStartup (client_sock=client_sock@entry=0x7ffcac239dd0) at ../src/backend/postmaster/postmaster.c:3466 [04:32:22.970] bn = 0x5624778a8208 [04:32:22.970] pid = [04:32:22.970] startup_data = {canAcceptConnections = CAC_OK} [04:32:22.970] cac = [04:32:22.970] __func__ = "BackendStartup" [04:32:22.970] #27 0x00005624416e934c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [04:32:22.970] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\343ޗ\177\000\000\240\0378\340\227\177\000\000x\236#\254\374\177\000\000t\236#\254\374\177", '\000' , "\222&\206@$V\000\000\320\a\202@$V\000\000@\237#\254\374\177\000\0008\237#\254\374\177\000\000\225[\362\001\000\000\000\000\240\264cߗ\177\000\000+", '\000' , "$V\000\000\240%\206@$V\000", __ss_align = 140290282792552}, salen = 2}} [04:32:22.970] i = 0 [04:32:22.970] now = [04:32:22.970] last_lockfile_recheck_time = 1736656041 [04:32:22.970] last_touch_time = 1736656041 [04:32:22.970] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x562440862692}, {pos = -528963992, events = 32663, fd = -547113424, user_data = 0x7f97e078a2e0}, {pos = 2090263927, events = 0, fd = -1406951488, user_data = 0x7f97e0760a48}, {pos = 15, events = 0, fd = -547113424, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f97e078a2e0}, {pos = -1406951624, events = 32764, fd = -1406951616, user_data = 0x7f97e078a668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 2005407744, events = 22052, fd = 1, user_data = 0x7ffcac23a463}, {pos = -1, events = 0, fd = -555556832, user_data = 0x7f97e0381fa0}, {pos = 2005587032, events = 22052, fd = 2005586744, user_data = 0x5624778ad111}, {pos = -529109314, events = 32663, fd = 1, user_data = 0x7f97e078a2e0}, {pos = 426, events = 0, fd = 1107811664, user_data = 0x0}, {pos = 249, events = 0, fd = 2005400528, user_data = 0x7f97e0766ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f97dee2e020}, {pos = -554750400, events = 32663, fd = 16, user_data = 0x7ffcac23a390}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -529100358, events = 32663, fd = 0, user_data = 0x7f97deeaeda4 }, {pos = 0, events = 0, fd = 1114835584, user_data = 0x2}, {pos = 0, events = 0, fd = 2005147344, user_data = 0x5624417ce749 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 2005400528, user_data = 0x7f97e0766ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f97dee364c8}, {pos = -554995603, events = 32663, fd = 1114891712, user_data = 0x5624778b2530}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = -553706400, events = 32663, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x352020200a0a3249}, {pos = 822763892, events = 909521719, fd = 875574837, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1024, user_data = 0x7f97deeb58be}, {pos = -553723424, events = 32663, fd = -555085458, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2005587264, user_data = 0xa4af8daaf90cfe00}, {pos = -553720352, events = 32663, fd = -328, user_data = 0x0}, {pos = 2005586424, events = 22052, 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 = 22087, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 2005400528, user_data = 0x7f97deef3053 }, {pos = 2005586424, events = 22052, fd = 1024, user_data = 0x7ffcac23a458}, {pos = 1102222357, events = 22052, fd = 1114900112, user_data = 0x562441b17ed2 }, {pos = 2005586224, events = 22052, fd = 2005400080, user_data = 0x5624778ad130}, {pos = -555001666, events = 32663, fd = 0, user_data = 0x562441b29b3c }, {pos = 2005586224, events = 1, fd = 1102224517, user_data = 0x56247787fa10}, {pos = -116589056, events = 2762968490, fd = 0, user_data = 0x7f97deea2ab1}, {pos = -555084560, events = 32663, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2005147344, user_data = 0xa4af8daaf90cfe00}, {pos = 0, events = 0, fd = -116589056, user_data = 0xc}, {pos = -116589056, events = 2762968490, fd = 0, user_data = 0x7f97dee5b239 }, {pos = 250, events = 0, fd = 1097735705, user_data = 0x400000}, {pos = 0, events = 0, fd = 2005147344, user_data = 0x562441b17d66 }, {pos = 2005233984, events = 22052, fd = 2005400080, user_data = 0x562477857140}, {pos = 1, events = 0, fd = 0, user_data = 0x562441ad656b }, {pos = 12, events = 0, fd = 2005577560, user_data = 0x5624778aaf38}, {pos = 1114836992, events = 22052, fd = 296, user_data = 0x5624416e4633 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1097752062, events = 22052, fd = 1111231600, user_data = 0x5624778803e8}} [04:32:22.971] nevents = 1 [04:32:22.971] __func__ = "ServerLoop" [04:32:22.971] #28 0x00005624416eabab in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x56247783dd90) at ../src/backend/postmaster/postmaster.c:1377 [04:32:22.971] opt = [04:32:22.971] status = [04:32:22.971] userDoption = [04:32:22.971] listen_addr_saved = false [04:32:22.971] output_config_variable = [04:32:22.971] __func__ = "PostmasterMain" [04:32:22.971] #29 0x000056244151691f in main (argc=8, argv=0x56247783dd90) at ../src/backend/main/main.c:230 [04:32:22.971] do_check_root = [04:32:22.971] dispatch_option = [04:32:23.007] -e [04:32:23.007] [04:32:23.007] [04:32:23.090] dumping /tmp/cores/postgres-6-30111.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [04:32:23.322] [New LWP 30111] [04:32:23.322] [04:32:23.322] This GDB supports auto-downloading debuginfo from the following URLs: [04:32:23.322] [04:32:23.322] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [04:32:23.322] Debuginfod has been disabled. [04:32:23.322] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [04:32:23.559] [Thread debugging using libthread_db enabled] [04:32:23.559] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [04:32:23.559] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN '. [04:32:23.559] Program terminated with signal SIGABRT, Aborted. [04:32:23.559] #0 0x00007f1a4baa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:24.534] [04:32:24.534] Thread 1 (Thread 0x7f1a4c233f00 (LWP 30111)): [04:32:24.534] #0 0x00007f1a4baa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:24.534] No symbol table info available. [04:32:24.534] #1 0x00007f1a4ba5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:24.534] No symbol table info available. [04:32:24.534] #2 0x00007f1a4ba45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:24.534] No symbol table info available. [04:32:24.534] #3 0x00007f1a4bc1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [04:32:24.534] No locals. [04:32:24.534] #4 0x00007f1a4bc2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [04:32:24.534] No locals. [04:32:24.534] #5 0x00007f1a4bc0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55ddc1ac48a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [04:32:24.534] bp = 140735179561056 [04:32:24.534] pc = [04:32:24.534] Opts = {FromUnrecoverableHandler = true, pc = 94410911448478, bp = 94411807243032} [04:32:24.534] #6 0x000055ddc0d6fd9e in examine_self_contradictory_rels (root=root@entry=0x55ddf644cc58, rel=rel@entry=0x55ddf6291a98, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [04:32:24.534] lc__state = [04:32:24.534] rlist = [04:32:24.534] i = 2 [04:32:24.534] br = [04:32:24.534] expression = [04:32:24.534] or_rinfo = 0x55ddf63bc850 [04:32:24.534] ccxt = [04:32:24.534] delidx = 0x55ddf63bc6e9 [04:32:24.534] arglst = [04:32:24.534] lc = [04:32:24.534] arg = [04:32:24.534] n = [04:32:24.534] restrictinfo = [04:32:24.534] ccwapper = {clausecxt = 0x55ddf63bc098} [04:32:24.534] sec = {sopcinfo = {n_members = 38, opcies = 0x55ddf63bbb68}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x55ddf63bb208, atop_set = 0x55ddf63bbf78}, ccfree = 0x55ddf63bc6b8, vifree = 0x55ddf63bc208} [04:32:24.534] __func__ = "examine_self_contradictory_rels" [04:32:24.534] #7 0x000055ddc0d6ffad in examine_self_contradictory_rels_phase1 (root=root@entry=0x55ddf644cc58) at ../src/backend/optimizer/plan/contradictory.c:2608 [04:32:24.534] rel = 0x55ddf6291a98 [04:32:24.534] rti = 1 [04:32:24.534] rinfo = [04:32:24.534] #8 0x000055ddc0d3ae3d in query_planner (root=root@entry=0x55ddf644cc58, qp_callback=qp_callback@entry=0x55ddc0d40283 , qp_extra=qp_extra@entry=0x7fff76629a60) at ../src/backend/optimizer/plan/planmain.c:193 [04:32:24.534] parse = 0x55ddf619bd58 [04:32:24.534] joinlist = 0x55ddf63bb278 [04:32:24.534] final_rel = [04:32:24.534] __func__ = "query_planner" [04:32:24.534] #9 0x000055ddc0d4d9e2 in grouping_planner (root=root@entry=0x55ddf644cc58, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [04:32:24.534] sort_input_targets = 0x5 [04:32:24.534] sort_input_target_parallel_safe = [04:32:24.534] grouping_target = [04:32:24.534] scanjoin_target = [04:32:24.534] activeWindows = 0x0 [04:32:24.534] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [04:32:24.534] sort_input_targets_contain_srfs = 0x1 [04:32:24.534] have_grouping = [04:32:24.534] wflists = 0x0 [04:32:24.534] gset_data = 0x0 [04:32:24.534] sort_input_target = [04:32:24.534] grouping_targets = 0x1 [04:32:24.534] grouping_target_parallel_safe = [04:32:24.534] scanjoin_targets = 0x0 [04:32:24.534] scanjoin_target_parallel_safe = [04:32:24.534] grouping_targets_contain_srfs = 0x1 [04:32:24.534] scanjoin_targets_contain_srfs = 0x55ddc12b62ec [04:32:24.534] scanjoin_target_same_exprs = [04:32:24.534] parse = 0x55ddf619bd58 [04:32:24.534] offset_est = 0 [04:32:24.534] count_est = 0 [04:32:24.534] limit_tuples = -1 [04:32:24.534] have_postponed_srfs = false [04:32:24.534] final_target = [04:32:24.534] final_targets = 0x55ddf629d7d8 [04:32:24.534] final_targets_contain_srfs = 0x55ddc0cab8b7 [04:32:24.534] final_target_parallel_safe = [04:32:24.534] current_rel = [04:32:24.534] final_rel = [04:32:24.534] extra = {limit_needed = false, limit_tuples = 4.6645187530334648e-310, count_est = 94411807239384, offset_est = 94411807239384} [04:32:24.534] lc = [04:32:24.534] __func__ = "grouping_planner" [04:32:24.534] #10 0x000055ddc0d50966 in subquery_planner (glob=glob@entry=0x55ddf63dda18, parse=parse@entry=0x55ddf619bd58, 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 [04:32:24.534] root = 0x55ddf644cc58 [04:32:24.534] newWithCheckOptions = [04:32:24.534] newHaving = 0x0 [04:32:24.534] hasOuterJoins = [04:32:24.534] hasResultRTEs = false [04:32:24.534] final_rel = [04:32:24.534] l = 0x0 [04:32:24.534] #11 0x000055ddc0d515f7 in standard_planner (parse=parse@entry=0x55ddf619bd58, query_string=query_string@entry=0x55ddf619aab0 "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 [04:32:24.534] result = [04:32:24.534] glob = 0x55ddf63dda18 [04:32:24.534] tuple_fraction = 0 [04:32:24.534] root = [04:32:24.534] final_rel = [04:32:24.534] best_path = [04:32:24.534] top_plan = [04:32:24.534] lp = [04:32:24.534] lr = [04:32:24.534] #12 0x00007f1a4913d5a2 in pgss_planner (parse=0x55ddf619bd58, query_string=0x55ddf619aab0 "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 [04:32:24.534] _save_exception_stack = 0x7fff7662a3e0 [04:32:24.534] _save_context_stack = 0x0 [04:32:24.534] _local_sigjmp_buf = {{__jmpbuf = {94411805015384, 5244972484113817372, 0, 2048, 94411805015384, 2048, 2057268001701191452, 2109545805078945564}, __mask_was_saved = 0, __saved_mask = {__val = {94411805507496, 94411805506048, 94410916376855, 94411805014280, 17042, 0, 0, 0, 139425128520, 17042, 0, 139750841478528, 139750841478464, 0, 0, 140735179884972}}}} [04:32:24.534] _do_rethrow = false [04:32:24.534] result = 0x7fff76629d18 [04:32:24.534] #13 0x000055ddc0d52657 in planner (parse=parse@entry=0x55ddf619bd58, query_string=query_string@entry=0x55ddf619aab0 "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 [04:32:24.534] result = [04:32:24.534] #14 0x000055ddc0fc23b5 in pg_plan_query (querytree=querytree@entry=0x55ddf619bd58, query_string=query_string@entry=0x55ddf619aab0 "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 [04:32:24.534] plan = [04:32:24.534] #15 0x000055ddc0ac1843 in standard_ExplainOneQuery (query=0x55ddf619bd58, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55ddf63dd778, queryString=0x55ddf619aab0 "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 [04:32:24.534] plan = [04:32:24.534] planstart = [04:32:24.534] planduration = {ticks = 94410910622167} [04:32:24.534] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94410916892642, shared_blks_dirtied = 1986175118, shared_blks_written = 3, local_blks_hit = 8424856136, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94411805015384, shared_blk_read_time = {ticks = -722166841469404031}, shared_blk_write_time = {ticks = 94410916979436}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94410910619548}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94411805015384}} [04:32:24.534] bufusage = {shared_blks_hit = 0, shared_blks_read = 94410913647966, shared_blks_dirtied = 73194832674816, shared_blks_written = 72057594037927936, local_blks_hit = 139750841468576, local_blks_read = 94411805016560, local_blks_dirtied = 94411805015384, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94410916507161, shared_blk_read_time = {ticks = 139750841468576}, shared_blk_write_time = {ticks = 94410916507180}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94410916888225}, temp_blk_read_time = {ticks = 94411805230464}, temp_blk_write_time = {ticks = 64}} [04:32:24.534] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140735179563024, freespace = 10} [04:32:24.534] planner_ctx = 0x0 [04:32:24.534] saved_ctx = 0x0 [04:32:24.534] #16 0x000055ddc0ac1b29 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55ddf63dd778, pstate=pstate@entry=0x55ddf61d0838, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [04:32:24.534] No locals. [04:32:24.534] #17 0x000055ddc0ac2a80 in ExplainQuery (pstate=pstate@entry=0x55ddf61d0838, stmt=stmt@entry=0x55ddf619bb98, params=params@entry=0x0, dest=dest@entry=0x55ddf61d07a8) at ../src/backend/commands/explain.c:357 [04:32:24.534] l__state = [04:32:24.534] l = 0x55ddf644cc20 [04:32:24.534] es = 0x55ddf63dd778 [04:32:24.534] tstate = [04:32:24.534] jstate = [04:32:24.534] query = [04:32:24.534] rewritten = 0x55ddf644cc08 [04:32:24.534] lc = 0x0 [04:32:24.534] timing_set = false [04:32:24.534] buffers_set = false [04:32:24.534] summary_set = false [04:32:24.534] __func__ = "ExplainQuery" [04:32:24.534] #18 0x000055ddc0fccdd5 in standard_ProcessUtility (pstmt=pstmt@entry=0x55ddf619bc48, queryString=queryString@entry=0x55ddf619aab0 "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=0x55ddf61d07a8, qc=0x7fff7662a620) at ../src/backend/tcop/utility.c:866 [04:32:24.534] parsetree = 0x55ddf619bb98 [04:32:24.534] isTopLevel = true [04:32:24.534] isAtomicContext = false [04:32:24.534] pstate = 0x55ddf61d0838 [04:32:24.534] readonly_flags = [04:32:24.534] __func__ = "standard_ProcessUtility" [04:32:24.534] #19 0x00007f1a4913cd8f in pgss_ProcessUtility (pstmt=0x55ddf619bc48, queryString=0x55ddf619aab0 "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=0x55ddf61d07a8, qc=0x7fff7662a620) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [04:32:24.534] _save_exception_stack = 0x7fff7662a6c0 [04:32:24.534] _save_context_stack = 0x0 [04:32:24.534] _local_sigjmp_buf = {{__jmpbuf = {0, -2057566015617933540, 94411805015112, 94411805231016, 140735179564576, 1, 2057268003783663388, 2109545805141073692}, __mask_was_saved = 0, __saved_mask = {__val = {94410916888225, 94411805010352, 11, 1, 94410916892642, 4129939368, 1, 94411805010352, 10, 94411806073016, 94411806073016, 1, 94411806073016, 94411806072760, 139750915403885, 86}}}} [04:32:24.534] _do_rethrow = false [04:32:24.534] duration = [04:32:24.534] bufusage = {shared_blks_hit = 0, shared_blks_read = 94410916979845, shared_blks_dirtied = 0, shared_blks_written = 94411805017112, local_blks_hit = 94411806070872, local_blks_read = 94411806070872, local_blks_dirtied = 94411806070792, local_blks_written = 140735179564336, temp_blks_read = 140735179564336, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94410911896389}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94411805017256}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94410916888225}} [04:32:24.534] walusage_start = {wal_records = 72, wal_fpi = 0, wal_bytes = 6572} [04:32:24.534] start = [04:32:24.534] rows = [04:32:24.534] bufusage_start = {shared_blks_hit = 1492, shared_blks_read = 320, shared_blks_dirtied = 26, shared_blks_written = 58, 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}} [04:32:24.534] walusage = {wal_records = 140735179564096, wal_fpi = 94410916380287, wal_bytes = 140735179564096} [04:32:24.534] parsetree = [04:32:24.534] saved_queryId = 12348319437508817197 [04:32:24.534] saved_stmt_location = 0 [04:32:24.534] saved_stmt_len = 108 [04:32:24.534] enabled = true [04:32:24.534] #20 0x000055ddc0fcd449 in ProcessUtility (pstmt=pstmt@entry=0x55ddf619bc48, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55ddf61d07a8, qc=0x7fff7662a620) at ../src/backend/tcop/utility.c:519 [04:32:24.534] No locals. [04:32:24.534] #21 0x000055ddc0fc8ebc in PortalRunUtility (portal=portal@entry=0x55ddf621d9a0, pstmt=0x55ddf619bc48, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55ddf61d07a8, qc=qc@entry=0x7fff7662a620) at ../src/backend/tcop/pquery.c:1152 [04:32:24.534] No locals. [04:32:24.534] #22 0x000055ddc0fc972f in FillPortalStore (portal=portal@entry=0x55ddf621d9a0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [04:32:24.534] treceiver = 0x55ddf61d07a8 [04:32:24.534] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:32:24.534] __func__ = "FillPortalStore" [04:32:24.534] #23 0x000055ddc0fc9c4a in PortalRun (portal=portal@entry=0x55ddf621d9a0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55ddf629e928, altdest=altdest@entry=0x55ddf629e928, qc=qc@entry=0x7fff7662a7e0) at ../src/backend/tcop/pquery.c:759 [04:32:24.534] _save_exception_stack = 0x7fff7662a890 [04:32:24.534] _save_context_stack = 0x0 [04:32:24.534] _local_sigjmp_buf = {{__jmpbuf = {0, 5244972623686623004, 94411805546912, 94411805015056, 94411805015032, 94411805014984, 2057268003653639964, 5244880905191776028}, __mask_was_saved = 0, __saved_mask = {__val = {94410916892642, 1986176879, 4, 94411805014984, 112, 153, 94411805546912, 94411805015056, 94411805015032, 94411805014984, 94410916979845, 1, 2, 153, 94410906225055, 0}}}} [04:32:24.534] _do_rethrow = [04:32:24.534] result = [04:32:24.534] nprocessed = [04:32:24.534] saveTopTransactionResourceOwner = 0x55ddf61dce78 [04:32:24.534] saveTopTransactionContext = 0x55ddf62301e0 [04:32:24.534] saveActivePortal = 0x0 [04:32:24.534] saveResourceOwner = 0x55ddf61dce78 [04:32:24.534] savePortalContext = 0x0 [04:32:24.534] saveMemoryContext = 0x55ddf62301e0 [04:32:24.534] __func__ = "PortalRun" [04:32:24.534] #24 0x000055ddc0fc2e81 in exec_simple_query (query_string=query_string@entry=0x55ddf619aab0 "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 [04:32:24.534] cmdtaglen = 7 [04:32:24.534] snapshot_set = [04:32:24.534] per_parsetree_context = 0x0 [04:32:24.534] plantree_list = 0x55ddf629e8d8 [04:32:24.534] parsetree = 0x55ddf619bbc8 [04:32:24.534] commandTag = [04:32:24.534] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:32:24.534] querytree_list = [04:32:24.534] portal = 0x55ddf621d9a0 [04:32:24.534] receiver = 0x55ddf629e928 [04:32:24.534] format = 0 [04:32:24.534] cmdtagname = [04:32:24.534] parsetree_item__state = [04:32:24.534] dest = DestRemote [04:32:24.534] oldcontext = 0x55ddf62301e0 [04:32:24.534] parsetree_list = 0x55ddf619bbf8 [04:32:24.534] parsetree_item = 0x55ddf619bc10 [04:32:24.534] save_log_statement_stats = false [04:32:24.534] was_logged = true [04:32:24.534] use_implicit_block = false [04:32:24.534] msec_str = "\004\000\000\000\000\000\000\000/*(\301\335U\000\000p\250bv\377\177\000\000n\000\000\000\000\000\000" [04:32:24.534] __func__ = "exec_simple_query" [04:32:24.534] #25 0x000055ddc0fc5bda in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [04:32:24.534] query_string = 0x55ddf619aab0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [04:32:24.534] firstchar = [04:32:24.534] input_message = {data = 0x55ddf619aab0 "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} [04:32:24.534] local_sigjmp_buf = {{__jmpbuf = {94410929649368, 5244878569966755612, 140735179565548, 4, 2, 140735179565780, 2057268003452313372, 5244880903370792732}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6144, 10, 94411805266768, 0, 168, 94410916892744, 0, 10, 2, 94410929649376, 94411804741200, 94410929643424, 4, 2, 140735179565780}}}} [04:32:24.534] send_ready_for_query = false [04:32:24.534] idle_in_transaction_timeout_enabled = false [04:32:24.534] idle_session_timeout_enabled = false [04:32:24.534] __func__ = "PostgresMain" [04:32:24.534] #26 0x000055ddc0fbbc45 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:32:24.534] bsdata = [04:32:24.534] #27 0x000055ddc0e6d11c in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x7fff7662a9ec "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff7662aa40) at ../src/backend/postmaster/launch_backend.c:274 [04:32:24.534] pid = [04:32:24.534] #28 0x000055ddc0e72328 in BackendStartup (client_sock=client_sock@entry=0x7fff7662aa40) at ../src/backend/postmaster/postmaster.c:3466 [04:32:24.534] bn = 0x55ddf61c6238 [04:32:24.534] pid = [04:32:24.534] startup_data = {canAcceptConnections = CAC_OK} [04:32:24.534] cac = [04:32:24.534] __func__ = "BackendStartup" [04:32:24.534] #29 0x000055ddc0e7434c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [04:32:24.534] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "3M\032\177\000\000>\004\000\000\000\000\000\000\260\227\243K\032\177\000\000\240/\365L\032\177\000\000\370\252bv\377\177\000\000\364\252bv\377\177", '\000' , "\222\326\376\277\335U\000\000з\372\277\335U\000\000\300\253bv\377\177\000\000\270\253bv\377\177\000\000\225[\362\001\214\205\245\277\020W\034\366\335U\000\000,\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [04:32:24.534] i = 0 [04:32:24.534] now = [04:32:24.534] last_lockfile_recheck_time = 1736656070 [04:32:24.534] last_touch_time = 1736656070 [04:32:24.534] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 1986178048, user_data = 0x0}, {pos = 15, events = 0, fd = -1073817966, user_data = 0x7f1a4d35b668}, {pos = 1284019760, events = 32538, fd = 1295364832, user_data = 0x7c96e577}, {pos = 1986178112, events = 32767, fd = 1295194696, user_data = 0xf}, {pos = 1284019760, events = 32538, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1295364832, user_data = 0x7fff7662abb8}, {pos = 1986177984, events = 32767, fd = 1295365736, user_data = 0x0}, {pos = -166087216, events = 21981, fd = 1269755237, user_data = 0x7fff7662b0d3}, {pos = 1, events = 0, fd = 1986177984, user_data = 0xffffffff}, {pos = 1268965408, events = 32538, fd = 1291136928, user_data = 0x55ddf61d08a8}, {pos = -165869688, events = 21981, fd = -165893007, user_data = 0x7f1a4d337ebe}, {pos = 1, events = 0, fd = 1295364832, user_data = 0x1aa}, {pos = -1048539824, events = 21981, fd = 0, user_data = 0x56}, {pos = -165903848, events = 21981, fd = 1295220414, user_data = 0x1}, {pos = 0, events = 0, fd = 1268965408, user_data = 0x7f1a4baf2e40 }, {pos = 16, events = 0, fd = 1986179072, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f1a4d33a1ba}, {pos = 0, events = 0, fd = 1269493156, user_data = 0x0}, {pos = -1041515904, events = 21981, fd = 2, user_data = 0x0}, {pos = -166342928, events = 21981, fd = 1952410737, user_data = 0x160}, {pos = -1048540416, events = 21981, fd = 4, user_data = 0x2ffff00001fa0}, {pos = -165903848, events = 21981, fd = 1295220414, user_data = 0x1}, {pos = 1269526279, events = 32538, fd = 1268999368, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1270815840, events = 32538, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55ddf615cef0}, {pos = 1269529226, events = 32538, fd = 0, user_data = 0x0}, {pos = -65536, events = 4294967295, fd = -1, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 811562031, user_data = 0x65725f6d61657274}, {pos = 1868785010, events = 2037540214, fd = 926036015, user_data = 0x7f1a4c88a540}, {pos = 1284024960, events = 32538, 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 = 1270798816, events = 32538, fd = 1269436782, user_data = 0x100000400}, {pos = 7, events = 0, fd = -165874320, user_data = 0xbfa5858cc431ba00}, {pos = 1270801888, events = 32538, fd = -328, user_data = 0x0}, {pos = -165870008, events = 21981, fd = 1024, user_data = 0x55ddf61d0648}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 29339, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -165903848, user_data = 0x7f1a4baf3053 }, {pos = -165870008, events = 21981, fd = 1024, user_data = 0x7fff7662b0c8}, {pos = -1054129131, events = 21981, fd = -1041451376, user_data = 0x55ddc12a2ed2 }, {pos = -165870208, events = 21981, fd = -166090320, user_data = 0x55ddf61d0580}, {pos = 1269520235, events = 32538, fd = 0, user_data = 0x55ddc12b4b3c }, {pos = -165870208, events = 1, fd = -1054126971, user_data = 0x55ddf619a9b0}, {pos = -1003374080, events = 3215295884, fd = 0, user_data = 0x7f1a4baa2ab1}, {pos = 1269437680, events = 32538, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -166342928, user_data = 0xbfa5858cc431ba00}, {pos = 0, events = 0, fd = -1003374080, user_data = 0xc}, {pos = -1003374080, events = 3215295884, fd = 0, user_data = 0x7f1a4ba5b239 }, {pos = 87, events = 0, fd = -1058615783, user_data = 0x400000}, {pos = 0, events = 0, fd = -166342928, user_data = 0x55ddc12a2d66 }, {pos = -166256416, events = 21981, fd = -166090320, user_data = 0x55ddf61720e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55ddc126156b }, {pos = 12, events = 0, fd = -165907896, user_data = 0x55ddf61c7228}, {pos = -1041514496, events = 21981, fd = 296, user_data = 0x55ddc0e6f633 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1058599426, events = 21981, fd = -1045119888, user_data = 0x55ddf619b368}} [04:32:24.535] nevents = 1 [04:32:24.535] __func__ = "ServerLoop" [04:32:24.535] #30 0x000055ddc0e75bab in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55ddf6158d50) at ../src/backend/postmaster/postmaster.c:1377 [04:32:24.535] opt = [04:32:24.535] status = [04:32:24.535] userDoption = [04:32:24.535] listen_addr_saved = false [04:32:24.535] output_config_variable = [04:32:24.535] __func__ = "PostmasterMain" [04:32:24.535] #31 0x000055ddc0ca191f in main (argc=4, argv=0x55ddf6158d50) at ../src/backend/main/main.c:230 [04:32:24.535] do_check_root = [04:32:24.535] dispatch_option = [04:32:24.571] -e [04:32:24.571] [04:32:24.571] [04:32:24.631] dumping /tmp/cores/postgres-6-26933.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [04:32:24.878] [New LWP 26933] [04:32:24.878] [04:32:24.878] This GDB supports auto-downloading debuginfo from the following URLs: [04:32:24.878] [04:32:24.878] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [04:32:24.878] Debuginfod has been disabled. [04:32:24.878] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [04:32:24.980] [Thread debugging using libthread_db enabled] [04:32:24.980] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [04:32:24.980] Core was generated by `postgres: postgres regression [local] ALTER TABLE '. [04:32:24.980] Program terminated with signal SIGABRT, Aborted. [04:32:24.980] #0 0x00007f97deea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:25.977] [04:32:25.977] Thread 1 (Thread 0x7f97dedd5f00 (LWP 26933)): [04:32:25.977] #0 0x00007f97deea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:25.977] No symbol table info available. [04:32:25.977] #1 0x00007f97dee5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:25.977] No symbol table info available. [04:32:25.977] #2 0x00007f97dee45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:25.977] No symbol table info available. [04:32:25.977] #3 0x00007f97df01e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [04:32:25.977] No locals. [04:32:25.977] #4 0x00007f97df02aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [04:32:25.977] No locals. [04:32:25.977] #5 0x00007f97df00dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5624423398a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [04:32:25.977] bp = 140723196495456 [04:32:25.977] pc = [04:32:25.977] Opts = {FromUnrecoverableHandler = true, pc = 94713715510686, bp = 94714627713176} [04:32:25.977] #6 0x00005624415e4d9e in examine_self_contradictory_rels (root=root@entry=0x562477985408, rel=rel@entry=0x562477bd5388, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [04:32:25.977] lc__state = [04:32:25.977] rlist = [04:32:25.977] i = 4 [04:32:25.977] br = [04:32:25.977] expression = [04:32:25.977] or_rinfo = 0x562477bd8890 [04:32:25.977] ccxt = [04:32:25.977] delidx = 0x562477bd8879 [04:32:25.977] arglst = [04:32:25.977] lc = [04:32:25.977] arg = [04:32:25.977] n = [04:32:25.977] restrictinfo = [04:32:25.977] ccwapper = {clausecxt = 0x562477bd8398} [04:32:25.977] sec = {sopcinfo = {n_members = 38, opcies = 0x562477bd7a58}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x562477bd75f8, atop_set = 0x562477bd7e68}, ccfree = 0x562477bd8848, vifree = 0x562477bd7f08} [04:32:25.977] __func__ = "examine_self_contradictory_rels" [04:32:25.977] #7 0x00005624415e4fad in examine_self_contradictory_rels_phase1 (root=root@entry=0x562477985408) at ../src/backend/optimizer/plan/contradictory.c:2608 [04:32:25.977] rel = 0x562477bd5388 [04:32:25.977] rti = 2 [04:32:25.977] rinfo = [04:32:25.977] #8 0x00005624415afe3d in query_planner (root=root@entry=0x562477985408, qp_callback=qp_callback@entry=0x5624415b5283 , qp_extra=qp_extra@entry=0x7ffcac238860) at ../src/backend/optimizer/plan/planmain.c:193 [04:32:25.977] parse = 0x562477983b60 [04:32:25.977] joinlist = 0x562477bd6128 [04:32:25.977] final_rel = [04:32:25.977] __func__ = "query_planner" [04:32:25.977] #9 0x00005624415c29e2 in grouping_planner (root=root@entry=0x562477985408, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [04:32:25.977] sort_input_targets = 0x562477bf0ab8 [04:32:25.977] sort_input_target_parallel_safe = [04:32:25.977] grouping_target = [04:32:25.977] scanjoin_target = [04:32:25.977] activeWindows = 0x0 [04:32:25.977] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [04:32:25.977] sort_input_targets_contain_srfs = 0x5 [04:32:25.977] have_grouping = [04:32:25.977] wflists = 0x0 [04:32:25.977] gset_data = 0x0 [04:32:25.977] sort_input_target = [04:32:25.977] grouping_targets = 0x0 [04:32:25.977] grouping_target_parallel_safe = [04:32:25.977] scanjoin_targets = 0x562477985408 [04:32:25.977] scanjoin_target_parallel_safe = [04:32:25.977] grouping_targets_contain_srfs = 0x562477bf0cc8 [04:32:25.977] scanjoin_targets_contain_srfs = 0x0 [04:32:25.977] scanjoin_target_same_exprs = [04:32:25.977] parse = 0x562477983b60 [04:32:25.977] offset_est = 0 [04:32:25.977] count_est = 0 [04:32:25.977] limit_tuples = -1 [04:32:25.977] have_postponed_srfs = false [04:32:25.977] final_target = [04:32:25.977] final_targets = 0x5624779846f0 [04:32:25.977] final_targets_contain_srfs = 0x562441603c86 [04:32:25.977] final_target_parallel_safe = [04:32:25.977] current_rel = [04:32:25.977] final_rel = [04:32:25.977] extra = {limit_needed = 136, limit_tuples = 4.6795242511096579e-310, count_est = 94714627820744, offset_est = 94714625283080} [04:32:25.977] lc = [04:32:25.977] __func__ = "grouping_planner" [04:32:25.977] #10 0x00005624415c5966 in subquery_planner (glob=glob@entry=0x5624779852f8, parse=parse@entry=0x562477983b60, 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 [04:32:25.977] root = 0x562477985408 [04:32:25.977] newWithCheckOptions = [04:32:25.977] newHaving = 0x0 [04:32:25.977] hasOuterJoins = [04:32:25.977] hasResultRTEs = false [04:32:25.977] final_rel = [04:32:25.977] l = 0x0 [04:32:25.977] #11 0x00005624415c65f7 in standard_planner (parse=0x562477983b60, query_string=, cursorOptions=0, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [04:32:25.977] result = [04:32:25.977] glob = 0x5624779852f8 [04:32:25.977] tuple_fraction = 0 [04:32:25.977] root = [04:32:25.977] final_rel = [04:32:25.977] best_path = [04:32:25.977] top_plan = [04:32:25.977] lp = [04:32:25.977] lr = [04:32:25.977] #12 0x00005624415c7661 in planner (parse=parse@entry=0x562477983b60, query_string=query_string@entry=0x562477accc98 "SELECT fk.\"a\" FROM ONLY \"fkpart4\".\"dropfk\" fk JOIN \"fkpart4\".\"droppk2_d\" pk ON ( pk.\"a\" OPERATOR(pg_catalog.=) fk.\"a\") WHERE ((pk.a IS NOT NULL) AND (pk.a >= 1000) AND (pk.a < 2000) AND (NOT ((pk.a IS"..., cursorOptions=cursorOptions@entry=0, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [04:32:25.977] result = [04:32:25.977] #13 0x00005624418373b5 in pg_plan_query (querytree=querytree@entry=0x562477983b60, query_string=query_string@entry=0x562477accc98 "SELECT fk.\"a\" FROM ONLY \"fkpart4\".\"dropfk\" fk JOIN \"fkpart4\".\"droppk2_d\" pk ON ( pk.\"a\" OPERATOR(pg_catalog.=) fk.\"a\") WHERE ((pk.a IS NOT NULL) AND (pk.a >= 1000) AND (pk.a < 2000) AND (NOT ((pk.a IS"..., cursorOptions=cursorOptions@entry=0, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [04:32:25.977] plan = [04:32:25.977] #14 0x0000562441837796 in pg_plan_queries (querytrees=querytrees@entry=0x562477983b10, query_string=0x562477accc98 "SELECT fk.\"a\" FROM ONLY \"fkpart4\".\"dropfk\" fk JOIN \"fkpart4\".\"droppk2_d\" pk ON ( pk.\"a\" OPERATOR(pg_catalog.=) fk.\"a\") WHERE ((pk.a IS NOT NULL) AND (pk.a >= 1000) AND (pk.a < 2000) AND (NOT ((pk.a IS"..., cursorOptions=0, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:993 [04:32:25.977] query = 0x562477983b60 [04:32:25.977] stmt = [04:32:25.977] query_list__state = [04:32:25.977] stmt_list = 0x0 [04:32:25.977] query_list = [04:32:25.977] #15 0x0000562441aac7cf in BuildCachedPlan (plansource=plansource@entry=0x562477baf790, qlist=0x562477983b10, qlist@entry=0x0, boundParams=boundParams@entry=0x0, queryEnv=queryEnv@entry=0x0) at ../src/backend/utils/cache/plancache.c:962 [04:32:25.977] plan = [04:32:25.977] plist = [04:32:25.977] snapshot_set = false [04:32:25.977] is_transient = [04:32:25.977] plan_context = [04:32:25.977] oldcxt = 0x562477983a10 [04:32:25.977] lc = [04:32:25.977] #16 0x0000562441aad0ee in GetCachedPlan (plansource=plansource@entry=0x562477baf790, boundParams=0x0, owner=owner@entry=0x0, queryEnv=0x0) at ../src/backend/utils/cache/plancache.c:1199 [04:32:25.977] plan = 0x0 [04:32:25.977] qlist = 0x0 [04:32:25.977] customplan = false [04:32:25.977] __func__ = "GetCachedPlan" [04:32:25.977] #17 0x00005624414e3939 in _SPI_execute_plan (plan=plan@entry=0x562477bf3640, options=options@entry=0x7ffcac238c30, snapshot=snapshot@entry=0x562442740840 , crosscheck_snapshot=crosscheck_snapshot@entry=0x0, fire_triggers=fire_triggers@entry=false) at ../src/backend/executor/spi.c:2577 [04:32:25.977] plansource = 0x562477baf790 [04:32:25.977] stmt_list = [04:32:25.977] lc2 = [04:32:25.977] lc1__state = [04:32:25.977] my_res = 0 [04:32:25.977] my_processed = 0 [04:32:25.977] my_tuptable = 0x0 [04:32:25.977] res = [04:32:25.977] allow_nonatomic = false [04:32:25.977] pushed_active_snap = true [04:32:25.977] plan_owner = 0x0 [04:32:25.977] spicallbackarg = {query = 0x562477accc98 "SELECT fk.\"a\" FROM ONLY \"fkpart4\".\"dropfk\" fk JOIN \"fkpart4\".\"droppk2_d\" pk ON ( pk.\"a\" OPERATOR(pg_catalog.=) fk.\"a\") WHERE ((pk.a IS NOT NULL) AND (pk.a >= 1000) AND (pk.a < 2000) AND (NOT ((pk.a IS"..., mode = RAW_PARSE_DEFAULT} [04:32:25.977] spierrcontext = {previous = 0x0, callback = 0x5624414de067 <_SPI_error_callback>, arg = 0x7ffcac238bd0} [04:32:25.977] cplan = 0x0 [04:32:25.977] lc1 = [04:32:25.977] __func__ = "_SPI_execute_plan" [04:32:25.977] #18 0x00005624414e3ff9 in SPI_execute_snapshot (plan=plan@entry=0x562477bf3640, Values=Values@entry=0x0, Nulls=Nulls@entry=0x0, snapshot=0x562442740840 , crosscheck_snapshot=crosscheck_snapshot@entry=0x0, read_only=read_only@entry=true, fire_triggers=false, tcount=1) at ../src/backend/executor/spi.c:797 [04:32:25.977] options = {params = 0x0, read_only = true, allow_nonatomic = false, must_return_tuples = false, tcount = 1, dest = 0x0, owner = 0x0} [04:32:25.977] res = 0 [04:32:25.977] #19 0x00005624419e464a in RI_PartitionRemove_Check (trigger=trigger@entry=0x7ffcac239370, fk_rel=fk_rel@entry=0x7f97d31e7998, pk_rel=pk_rel@entry=0x7f97d31e9678) at ../src/backend/utils/adt/ri_triggers.c:1878 [04:32:25.977] riinfo = 0x562477bc80c8 [04:32:25.977] querybuf = {data = 0x562477bd2c68 "SELECT fk.\"a\" FROM ONLY \"fkpart4\".\"dropfk\" fk JOIN \"fkpart4\".\"droppk2_d\" pk ON ( pk.\"a\" OPERATOR(pg_catalog.=) fk.\"a\") WHERE ((pk.a IS NOT NULL) AND (pk.a >= 1000) AND (pk.a < 2000) AND (NOT ((pk.a IS"..., len = 277, maxlen = 1024, cursor = 0} [04:32:25.977] constraintDef = [04:32:25.977] pkrelname = "\"fkpart4\".\"droppk2_d\"\000\000\000\200\320\031ܗ\177\000\000\000\205Tӗ\177\000\000\300\263\245w$V\000\000\300\263\245w$V\000\000\020\223#\254\374\177\000\000\005\000\000\000\000\000\000\000W\270\177A$V\000\000\300\263\245w$V\000\000k\a\200A$V\000\000\b\223#\254\374\177\000\000\000\000\000\000E\032\300J\2301\213w$V\000\0006\240\256A$V\000\000,\223#\254\374\177\000\000\340\021\367ޗ\177\000\000\376٩A", '\000' , "\357\251\000\000\000\000\000\000h\360\220w$V\000\000\000\000\000\000\000\000\000\000\320O\216w$V\000\000,\223#\254\374\177", '\000' ... [04:32:25.977] fkrelname = "\"fkpart4\".\"dropfk\"\000ӗ\177\000\000\tK A$V\000\000\350\244\036ӗ\177\000\0000}\251A$V\000\000\001\000\000\000\000\000\000\000\365\tP\032\025\000\000\000\376\251", '\000' , "\001\000\003\000\000\000\000\000\000\000\000\000E\022]\213\000\000\000\000 \362\203w$V\000\000\000\002\337ۗ\177\000\000\003\000\000\000\000\000\000\000\020\000\000\000\000\000\000\000٣\256A$V\000\000\020\222#\254\374\177\000\000\340\021\367ޗ\177\000\000\200\320\031\334\005\000\000\000\017\222#\254\374\177\000\000\260i\033ܗ\177\000\000\250\237\337ۗ\177\000\000"... [04:32:25.977] pkattname = "pk.\"a\"\000\000\037\177\353ޗ\177\000\000\000@\000\000.\n\000\000\000\000\000\000\000\000\000\001\001\000\000\000\227\177\000\000^e\261A$V\000\000\020v\221w$V\000\000\001\000\000\000\000\000\000\000\b\004\273w$V\000\000\000Ɏw$V\000\000\000\000\000\000\000\000\000\000Hz>ӗ\177\000\000\001\000\000\000\000\000\000\000\234\205\177A$V\000\000\000@\000\000.\n\000\000\000\000\000\000\000\000\000\001\001\000\000\000\000" [04:32:25.977] fkattname = "\"a\"\000a\"\000\000\002", '\000' , "\300\263\245w$V\000\000А#\254\374\177\000\000\271\245\256A$V\000\000\000\000\000\000\000\000\000\000\300\263\245w$V\000\000\377\377\377\377", '\000' , "x\210\213w$V\000\000\030\301\177A$V\000\000x\210\213w$V\000\000\001\000\000\000\000\000\000\000x\210\213w$V\000\000\017\032\200A$V\000\000xS\275w\001" [04:32:25.977] sep = 0x562441d353d2 " AND " [04:32:25.977] fk_only = [04:32:25.977] save_nestlevel = 2 [04:32:25.977] workmembuf = "65536\000\000\000\b\037\216w$V\000\000\367\000\000\000\000\000\000\000\260\017\216w$V\000" [04:32:25.977] spi_result = [04:32:25.977] qplan = 0x562477bf3640 [04:32:25.977] i = [04:32:25.977] __func__ = "RI_PartitionRemove_Check" [04:32:25.977] #20 0x000056244138e3c7 in ATDetachCheckNoForeignKeyRefs (partition=partition@entry=0x7f97d31e9678) at ../src/backend/commands/tablecmds.c:20782 [04:32:25.977] constrOid = [04:32:25.977] rel = 0x7f97d31e7998 [04:32:25.977] trig = {tgoid = 0, tgname = 0x7f97d31ea574 "dropfk_a_fkey4", tgfoid = 0, tgtype = 0, tgenabled = 79 'O', tgisinternal = true, tgisclone = false, tgconstrrelid = 43497, tgconstrindid = 43500, tgconstraint = 43518, tgdeferrable = false, tginitdeferred = false, tgnargs = 0, tgnattr = 0, tgattr = 0x0, tgargs = 0x0, tgqual = 0x0, tgoldtable = 0x0, tgnewtable = 0x0} [04:32:25.977] tuple = 0x7f97d31ea528 [04:32:25.977] constrForm = [04:32:25.977] cell__state = [04:32:25.977] constraints = 0x562477bd35e8 [04:32:25.977] cell = [04:32:25.977] __func__ = "ATDetachCheckNoForeignKeyRefs" [04:32:25.977] #21 0x00005624413c5b81 in ATExecDetachPartition (wqueue=wqueue@entry=0x7ffcac239588, tab=tab@entry=0x562477bf1f98, rel=rel@entry=0x7f97d31dd4b8, name=, concurrent=) at ../src/backend/commands/tablecmds.c:19764 [04:32:25.977] partRel = 0x7f97d31e9678 [04:32:25.977] address = {classId = 0, objectId = 0, objectSubId = 8} [04:32:25.977] defaultPartOid = 43497 [04:32:25.977] __func__ = "ATExecDetachPartition" [04:32:25.977] #22 0x00005624413c72eb in ATExecCmd (wqueue=wqueue@entry=0x7ffcac239588, tab=tab@entry=0x562477bf1f98, cmd=, lockmode=lockmode@entry=8, cur_pass=cur_pass@entry=AT_PASS_MISC, context=context@entry=0x7ffcac239670) at ../src/backend/commands/tablecmds.c:5600 [04:32:25.977] address = {classId = 0, objectId = 0, objectSubId = 0} [04:32:25.977] rel = 0x7f97d31dd4b8 [04:32:25.977] __func__ = "ATExecCmd" [04:32:25.977] #23 0x00005624413c7566 in ATRewriteCatalogs (wqueue=wqueue@entry=0x7ffcac239588, lockmode=lockmode@entry=8, context=context@entry=0x7ffcac239670) at ../src/backend/commands/tablecmds.c:5265 [04:32:25.977] lcmd__state = [04:32:25.977] tab = 0x562477bf1f98 [04:32:25.977] subcmds = 0x562477bf2568 [04:32:25.977] lcmd = [04:32:25.977] ltab__state = [04:32:25.977] pass = AT_PASS_MISC [04:32:25.977] ltab = [04:32:25.977] #24 0x00005624413c7ac0 in ATController (parsetree=parsetree@entry=0x562477880650, rel=rel@entry=0x7f97d31dd4b8, cmds=, recurse=, lockmode=lockmode@entry=8, context=context@entry=0x7ffcac239670) at ../src/backend/commands/tablecmds.c:4822 [04:32:25.977] wqueue = 0x562477bb18e0 [04:32:25.977] lcmd = 0x0 [04:32:25.977] #25 0x00005624413c7b77 in AlterTable (stmt=stmt@entry=0x562477880650, lockmode=lockmode@entry=8, context=context@entry=0x7ffcac239670) at ../src/backend/commands/tablecmds.c:4477 [04:32:25.977] rel = 0x7f97d31dd4b8 [04:32:25.977] #26 0x0000562441842d51 in ProcessUtilitySlow (pstate=pstate@entry=0x562477bb17d0, pstmt=pstmt@entry=0x562477880750, queryString=queryString@entry=0x56247787fb10 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x562477880b10, qc=0x7ffcac239b70) at ../src/backend/tcop/utility.c:1321 [04:32:25.977] atcontext = {pstmt = 0x562477880750, queryString = 0x56247787fb10 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;", relid = 43485, params = 0x0, queryEnv = 0x0} [04:32:25.977] atstmt = 0x562477880650 [04:32:25.977] relid = 43485 [04:32:25.977] lockmode = 8 [04:32:25.977] cell = 0x0 [04:32:25.977] _save_exception_stack = 0x7ffcac239a50 [04:32:25.977] _save_context_stack = 0x0 [04:32:25.977] _local_sigjmp_buf = {{__jmpbuf = {0, 6057641488433343149, 94714624214608, 0, 94714624211728, 0, 549623330858920621, 6057760200203496109}, __mask_was_saved = 0, __saved_mask = {__val = {0, 3255, 2006448948, 94714625269648, 94713717421916, 3255, 94713717422006, 94714625272800, 94713721266263, 140290255838648, 3546362821058819429, 94713723811170, 2888014440, 94713723811168, 140290255838648, 0}}}} [04:32:25.977] _do_rethrow = false [04:32:25.977] parsetree = 0x562477880650 [04:32:25.977] isTopLevel = true [04:32:25.977] isCompleteQuery = true [04:32:25.977] needCleanup = false [04:32:25.977] commandCollected = false [04:32:25.977] address = {classId = 22052, objectId = 2005403216, objectSubId = 22052} [04:32:25.977] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [04:32:25.977] __func__ = "ProcessUtilitySlow" [04:32:25.977] #27 0x00005624418423a3 in standard_ProcessUtility (pstmt=0x562477880750, queryString=0x56247787fb10 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x562477880b10, qc=0x7ffcac239b70) at ../src/backend/tcop/utility.c:1070 [04:32:25.977] parsetree = 0x562477880650 [04:32:25.977] isTopLevel = true [04:32:25.977] isAtomicContext = false [04:32:25.977] pstate = 0x562477bb17d0 [04:32:25.977] readonly_flags = [04:32:25.977] __func__ = "standard_ProcessUtility" [04:32:25.977] #28 0x00005624418424fe in ProcessUtility (pstmt=pstmt@entry=0x562477880750, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x562477880b10, qc=0x7ffcac239b70) at ../src/backend/tcop/utility.c:523 [04:32:25.977] No locals. [04:32:25.977] #29 0x000056244183debc in PortalRunUtility (portal=portal@entry=0x562477905020, pstmt=pstmt@entry=0x562477880750, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x562477880b10, qc=qc@entry=0x7ffcac239b70) at ../src/backend/tcop/pquery.c:1152 [04:32:25.977] No locals. [04:32:25.977] #30 0x000056244183e461 in PortalRunMulti (portal=portal@entry=0x562477905020, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x562477880b10, altdest=altdest@entry=0x562477880b10, qc=qc@entry=0x7ffcac239b70) at ../src/backend/tcop/pquery.c:1309 [04:32:25.977] pstmt = 0x562477880750 [04:32:25.977] stmtlist_item__state = [04:32:25.977] active_snapshot_set = false [04:32:25.977] stmtlist_item = 0x562477880ad8 [04:32:25.977] #31 0x000056244183e9c9 in PortalRun (portal=portal@entry=0x562477905020, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x562477880b10, altdest=altdest@entry=0x562477880b10, qc=qc@entry=0x7ffcac239b70) at ../src/backend/tcop/pquery.c:787 [04:32:25.977] _save_exception_stack = 0x7ffcac239c20 [04:32:25.977] _save_context_stack = 0x0 [04:32:25.977] _local_sigjmp_buf = {{__jmpbuf = {0, 6057641488827607725, 94714624757792, 94714624214808, 94714624214784, 94714624214736, 549623331257379501, 6057760142598793901}, __mask_was_saved = 0, __saved_mask = {__val = {94713720954850, 2888014591, 4, 94714624214736, 112, 34, 94714624757792, 94714624214808, 94714624214784, 94714624214736, 94713721042053, 94714624214736, 2, 34, 94713710287263, 0}}}} [04:32:25.977] _do_rethrow = [04:32:25.977] result = [04:32:25.977] nprocessed = [04:32:25.977] saveTopTransactionResourceOwner = 0x5624778c3a98 [04:32:25.977] saveTopTransactionContext = 0x562477917450 [04:32:25.977] saveActivePortal = 0x0 [04:32:25.977] saveResourceOwner = 0x5624778c3a98 [04:32:25.977] savePortalContext = 0x0 [04:32:25.977] saveMemoryContext = 0x562477917450 [04:32:25.977] __func__ = "PortalRun" [04:32:25.977] #32 0x0000562441837e81 in exec_simple_query (query_string=query_string@entry=0x56247787fb10 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;") at ../src/backend/tcop/postgres.c:1271 [04:32:25.977] cmdtaglen = 11 [04:32:25.977] snapshot_set = [04:32:25.977] per_parsetree_context = 0x0 [04:32:25.977] plantree_list = 0x562477880ac0 [04:32:25.977] parsetree = 0x5624778806d0 [04:32:25.977] commandTag = [04:32:25.977] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:32:25.977] querytree_list = [04:32:25.977] portal = 0x562477905020 [04:32:25.977] receiver = 0x562477880b10 [04:32:25.977] format = 0 [04:32:25.977] cmdtagname = [04:32:25.977] parsetree_item__state = [04:32:25.977] dest = DestRemote [04:32:25.977] oldcontext = 0x562477917450 [04:32:25.977] parsetree_list = 0x562477880700 [04:32:25.977] parsetree_item = 0x562477880718 [04:32:25.977] save_log_statement_stats = false [04:32:25.977] was_logged = false [04:32:25.977] use_implicit_block = false [04:32:25.977] msec_str = "\004\000\000\000\000\000\000\000/z\257A$V\000\000\000\234#\254\374\177\000\0000\000\000\000\000\000\000" [04:32:25.977] __func__ = "exec_simple_query" [04:32:25.977] #33 0x000056244183abda in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [04:32:25.977] query_string = 0x56247787fb10 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;" [04:32:25.977] firstchar = [04:32:25.977] input_message = {data = 0x56247787fb10 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;", len = 48, maxlen = 1024, cursor = 48} [04:32:25.977] local_sigjmp_buf = {{__jmpbuf = {94713733711576, 6057758414608329389, 140723196501372, 4, 9, 140723196501604, 549623331324488365, 6057760144569461421}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94714623942192, 17408, 94713733705632, 94714624476560, 9, 94713720954398, 0, 10, 2, 94713733711584, 94714623942192, 94713733705632, 4, 9, 140723196501604}}}} [04:32:25.977] send_ready_for_query = false [04:32:25.977] idle_in_transaction_timeout_enabled = false [04:32:25.977] idle_session_timeout_enabled = false [04:32:25.977] __func__ = "PostgresMain" [04:32:25.977] #34 0x0000562441830c45 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:32:25.977] bsdata = [04:32:25.977] #35 0x00005624416e211c in postmaster_child_launch (child_type=B_BACKEND, child_slot=9, startup_data=startup_data@entry=0x7ffcac239d7c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcac239dd0) at ../src/backend/postmaster/launch_backend.c:274 [04:32:25.977] pid = [04:32:25.977] #36 0x00005624416e7328 in BackendStartup (client_sock=client_sock@entry=0x7ffcac239dd0) at ../src/backend/postmaster/postmaster.c:3466 [04:32:25.977] bn = 0x5624778a8208 [04:32:25.977] pid = [04:32:25.977] startup_data = {canAcceptConnections = CAC_OK} [04:32:25.977] cac = [04:32:25.977] __func__ = "BackendStartup" [04:32:25.977] #37 0x00005624416e934c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [04:32:25.977] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\343ޗ\177\000\000\240\0378\340\227\177\000\000x\236#\254\374\177\000\000t\236#\254\374\177", '\000' , "\222&\206@$V\000\000\320\a\202@$V\000\000@\237#\254\374\177\000\0008\237#\254\374\177\000\000\225[\362\001\000\000\000\000\240\264cߗ\177\000\000+", '\000' , "$V\000\000\240%\206@$V\000", __ss_align = 140290282792552}, salen = 2}} [04:32:25.977] i = 0 [04:32:25.977] now = [04:32:25.977] last_lockfile_recheck_time = 1736656041 [04:32:25.977] last_touch_time = 1736656041 [04:32:25.977] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x562440862692}, {pos = -528963992, events = 32663, fd = -547113424, user_data = 0x7f97e078a2e0}, {pos = 2090263927, events = 0, fd = -1406951488, user_data = 0x7f97e0760a48}, {pos = 15, events = 0, fd = -547113424, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f97e078a2e0}, {pos = -1406951624, events = 32764, fd = -1406951616, user_data = 0x7f97e078a668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 2005407744, events = 22052, fd = 1, user_data = 0x7ffcac23a463}, {pos = -1, events = 0, fd = -555556832, user_data = 0x7f97e0381fa0}, {pos = 2005587032, events = 22052, fd = 2005586744, user_data = 0x5624778ad111}, {pos = -529109314, events = 32663, fd = 1, user_data = 0x7f97e078a2e0}, {pos = 426, events = 0, fd = 1107811664, user_data = 0x0}, {pos = 249, events = 0, fd = 2005400528, user_data = 0x7f97e0766ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f97dee2e020}, {pos = -554750400, events = 32663, fd = 16, user_data = 0x7ffcac23a390}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -529100358, events = 32663, fd = 0, user_data = 0x7f97deeaeda4 }, {pos = 0, events = 0, fd = 1114835584, user_data = 0x2}, {pos = 0, events = 0, fd = 2005147344, user_data = 0x5624417ce749 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 2005400528, user_data = 0x7f97e0766ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f97dee364c8}, {pos = -554995603, events = 32663, fd = 1114891712, user_data = 0x5624778b2530}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = -553706400, events = 32663, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x352020200a0a3249}, {pos = 822763892, events = 909521719, fd = 875574837, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1024, user_data = 0x7f97deeb58be}, {pos = -553723424, events = 32663, fd = -555085458, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2005587264, user_data = 0xa4af8daaf90cfe00}, {pos = -553720352, events = 32663, fd = -328, user_data = 0x0}, {pos = 2005586424, events = 22052, 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 = 22087, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 2005400528, user_data = 0x7f97deef3053 }, {pos = 2005586424, events = 22052, fd = 1024, user_data = 0x7ffcac23a458}, {pos = 1102222357, events = 22052, fd = 1114900112, user_data = 0x562441b17ed2 }, {pos = 2005586224, events = 22052, fd = 2005400080, user_data = 0x5624778ad130}, {pos = -555001666, events = 32663, fd = 0, user_data = 0x562441b29b3c }, {pos = 2005586224, events = 1, fd = 1102224517, user_data = 0x56247787fa10}, {pos = -116589056, events = 2762968490, fd = 0, user_data = 0x7f97deea2ab1}, {pos = -555084560, events = 32663, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2005147344, user_data = 0xa4af8daaf90cfe00}, {pos = 0, events = 0, fd = -116589056, user_data = 0xc}, {pos = -116589056, events = 2762968490, fd = 0, user_data = 0x7f97dee5b239 }, {pos = 250, events = 0, fd = 1097735705, user_data = 0x400000}, {pos = 0, events = 0, fd = 2005147344, user_data = 0x562441b17d66 }, {pos = 2005233984, events = 22052, fd = 2005400080, user_data = 0x562477857140}, {pos = 1, events = 0, fd = 0, user_data = 0x562441ad656b }, {pos = 12, events = 0, fd = 2005577560, user_data = 0x5624778aaf38}, {pos = 1114836992, events = 22052, fd = 296, user_data = 0x5624416e4633 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1097752062, events = 22052, fd = 1111231600, user_data = 0x5624778803e8}} [04:32:25.977] nevents = 1 [04:32:25.977] __func__ = "ServerLoop" [04:32:25.977] #38 0x00005624416eabab in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x56247783dd90) at ../src/backend/postmaster/postmaster.c:1377 [04:32:25.977] opt = [04:32:25.977] status = [04:32:25.977] userDoption = [04:32:25.977] listen_addr_saved = false [04:32:25.977] output_config_variable = [04:32:25.977] __func__ = "PostmasterMain" [04:32:25.977] #39 0x000056244151691f in main (argc=8, argv=0x56247783dd90) at ../src/backend/main/main.c:230 [04:32:25.977] do_check_root = [04:32:25.977] dispatch_option = [04:32:26.013] -e [04:32:26.013] [04:32:26.013] [04:32:26.075] dumping /tmp/cores/postgres-6-40602.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [04:32:26.322] [New LWP 40602] [04:32:26.322] [04:32:26.322] This GDB supports auto-downloading debuginfo from the following URLs: [04:32:26.322] [04:32:26.322] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [04:32:26.322] Debuginfod has been disabled. [04:32:26.322] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [04:32:26.425] [Thread debugging using libthread_db enabled] [04:32:26.425] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [04:32:26.425] Core was generated by `postgres: test: postgres db1 [local] SELECT '. [04:32:26.425] Program terminated with signal SIGABRT, Aborted. [04:32:26.425] #0 0x00007f051f8a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:26.487] [04:32:26.487] Thread 1 (Thread 0x7f0520032f00 (LWP 40602)): [04:32:26.487] #0 0x00007f051f8a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:26.487] No symbol table info available. [04:32:26.487] #1 0x00007f051f85afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:26.487] No symbol table info available. [04:32:26.487] #2 0x00007f051f845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:26.487] No symbol table info available. [04:32:26.487] #3 0x00007f051fa1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [04:32:26.487] No locals. [04:32:26.487] #4 0x00007f051fa2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [04:32:26.487] No locals. [04:32:26.487] #5 0x00007f051fa0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5605ff0cd8a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [04:32:26.487] bp = 140729980666288 [04:32:26.487] pc = [04:32:26.487] Opts = {FromUnrecoverableHandler = true, pc = 94583739878814, bp = 139659784195240} [04:32:26.487] #6 0x00005605fe378d9e in examine_self_contradictory_rels (root=root@entry=0x560600129578, rel=rel@entry=0x560600133268, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [04:32:26.487] lc__state = [04:32:26.487] rlist = [04:32:26.487] i = 7 [04:32:26.487] br = [04:32:26.487] expression = [04:32:26.487] or_rinfo = 0x7f0513d39e48 [04:32:26.487] ccxt = [04:32:26.487] delidx = 0x7f0513d3cee1 [04:32:26.487] arglst = [04:32:26.487] lc = [04:32:26.487] arg = [04:32:26.487] n = [04:32:26.487] restrictinfo = [04:32:26.487] ccwapper = {clausecxt = 0x7f0513d3ab78} [04:32:26.487] sec = {sopcinfo = {n_members = 38, opcies = 0x7f0513d3a318}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7f0513d3a728, atop_set = 0x7f0513d38398}, ccfree = 0x7f0513d3ceb0, vifree = 0x7f0513d3bdc8} [04:32:26.487] __func__ = "examine_self_contradictory_rels" [04:32:26.487] #7 0x00005605fe378fad in examine_self_contradictory_rels_phase1 (root=root@entry=0x560600129578) at ../src/backend/optimizer/plan/contradictory.c:2608 [04:32:26.487] rel = 0x560600133268 [04:32:26.487] rti = 1 [04:32:26.487] rinfo = [04:32:26.487] #8 0x00005605fe343e3d in query_planner (root=root@entry=0x560600129578, qp_callback=qp_callback@entry=0x5605fe349283 , qp_extra=qp_extra@entry=0x7ffe4081c3b0) at ../src/backend/optimizer/plan/planmain.c:193 [04:32:26.487] parse = 0x56060011fd70 [04:32:26.487] joinlist = 0x7f0513d38528 [04:32:26.487] final_rel = [04:32:26.487] __func__ = "query_planner" [04:32:26.487] #9 0x00005605fe3569e2 in grouping_planner (root=root@entry=0x560600129578, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [04:32:26.487] sort_input_targets = 0x560600129578 [04:32:26.487] sort_input_target_parallel_safe = [04:32:26.487] grouping_target = [04:32:26.487] scanjoin_target = [04:32:26.487] activeWindows = 0x0 [04:32:26.487] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [04:32:26.487] sort_input_targets_contain_srfs = 0x560600126d70 [04:32:26.487] have_grouping = [04:32:26.487] wflists = 0x0 [04:32:26.487] gset_data = 0x0 [04:32:26.487] sort_input_target = [04:32:26.487] grouping_targets = 0x560600126db8 [04:32:26.487] grouping_target_parallel_safe = [04:32:26.487] scanjoin_targets = 0x560600126da0 [04:32:26.487] scanjoin_target_parallel_safe = [04:32:26.487] grouping_targets_contain_srfs = 0x560600129578 [04:32:26.487] scanjoin_targets_contain_srfs = 0x0 [04:32:26.487] scanjoin_target_same_exprs = [04:32:26.487] parse = 0x56060011fd70 [04:32:26.487] offset_est = 0 [04:32:26.487] count_est = 0 [04:32:26.487] limit_tuples = -1 [04:32:26.487] have_postponed_srfs = false [04:32:26.487] final_target = [04:32:26.487] final_targets = 0x560600129578 [04:32:26.487] final_targets_contain_srfs = 0x7 [04:32:26.487] final_target_parallel_safe = [04:32:26.487] current_rel = [04:32:26.487] final_rel = [04:32:26.487] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94583770971504} [04:32:26.487] lc = [04:32:26.487] __func__ = "grouping_planner" [04:32:26.487] #10 0x00005605fe359966 in subquery_planner (glob=, parse=0x56060011fd70, parent_root=parent_root@entry=0x56060011cf30, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [04:32:26.487] root = 0x560600129578 [04:32:26.487] newWithCheckOptions = [04:32:26.487] newHaving = 0x0 [04:32:26.487] hasOuterJoins = [04:32:26.487] hasResultRTEs = true [04:32:26.487] final_rel = [04:32:26.487] l = 0x0 [04:32:26.487] #11 0x00005605fe36b300 in SS_process_ctes (root=root@entry=0x56060011cf30) at ../src/backend/optimizer/plan/subselect.c:966 [04:32:26.487] subquery = [04:32:26.487] cte = 0x5606000e2300 [04:32:26.487] cmdType = [04:32:26.487] subroot = [04:32:26.487] final_rel = [04:32:26.487] best_path = [04:32:26.487] plan = [04:32:26.487] splan = [04:32:26.487] paramid = [04:32:26.487] lc__state = [04:32:26.487] lc = [04:32:26.487] __func__ = "SS_process_ctes" [04:32:26.487] #12 0x00005605fe35840a in subquery_planner (glob=glob@entry=0x5606000f6d38, parse=parse@entry=0x5606000f6e48, 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 [04:32:26.487] root = 0x56060011cf30 [04:32:26.487] newWithCheckOptions = [04:32:26.487] newHaving = [04:32:26.487] hasOuterJoins = [04:32:26.487] hasResultRTEs = [04:32:26.487] final_rel = [04:32:26.487] l = [04:32:26.487] #13 0x00005605fe35a5f7 in standard_planner (parse=0x5606000f6e48, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [04:32:26.487] result = [04:32:26.487] glob = 0x5606000f6d38 [04:32:26.487] tuple_fraction = 0 [04:32:26.487] root = [04:32:26.487] final_rel = [04:32:26.487] best_path = [04:32:26.487] top_plan = [04:32:26.487] lp = [04:32:26.487] lr = [04:32:26.487] #14 0x00005605fe35b661 in planner (parse=parse@entry=0x5606000f6e48, query_string=query_string@entry=0x5606000045c0 "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 [04:32:26.487] result = [04:32:26.487] #15 0x00005605fe5cb3b5 in pg_plan_query (querytree=querytree@entry=0x5606000f6e48, query_string=query_string@entry=0x5606000045c0 "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 [04:32:26.487] plan = [04:32:26.487] #16 0x00005605fe5cb796 in pg_plan_queries (querytrees=0x56060011cee0, query_string=query_string@entry=0x5606000045c0 "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 [04:32:26.487] query = 0x5606000f6e48 [04:32:26.487] stmt = [04:32:26.487] query_list__state = [04:32:26.487] stmt_list = 0x0 [04:32:26.487] query_list = [04:32:26.487] #17 0x00005605fe5cbd43 in exec_simple_query (query_string=query_string@entry=0x5606000045c0 "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 [04:32:26.487] cmdtaglen = 6 [04:32:26.487] snapshot_set = true [04:32:26.487] per_parsetree_context = 0x0 [04:32:26.487] plantree_list = [04:32:26.487] parsetree = 0x5606000f6cb8 [04:32:26.487] commandTag = CMDTAG_SELECT [04:32:26.487] qc = {commandTag = 1935, nprocessed = 94583769810368} [04:32:26.487] querytree_list = [04:32:26.487] portal = [04:32:26.487] receiver = [04:32:26.487] format = 0 [04:32:26.487] cmdtagname = [04:32:26.487] parsetree_item__state = [04:32:26.487] dest = DestRemote [04:32:26.487] oldcontext = 0x560600094d30 [04:32:26.487] parsetree_list = 0x5606000f6ce8 [04:32:26.487] parsetree_item = 0x5606000f6d00 [04:32:26.487] save_log_statement_stats = false [04:32:26.487] was_logged = true [04:32:26.487] use_implicit_block = false [04:32:26.487] msec_str = "\004\000\000\000\000\000\000\000/\272\210\376\005V\000\000\200ǁ@\376\177\000\000\217\a\000\000\000\000\000" [04:32:26.487] __func__ = "exec_simple_query" [04:32:26.487] #18 0x00005605fe5cebda in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [04:32:26.487] query_string = 0x5606000045c0 "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 "... [04:32:26.487] firstchar = [04:32:26.487] input_message = {data = 0x5606000045c0 "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} [04:32:26.487] local_sigjmp_buf = {{__jmpbuf = {94583758079704, 4076850648576884211, 140729980668156, 4, 2, 140729980668388, 7738483273977757171, 4076848601055559155}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94583769538032, 16128, 94583758073760, 94583770048384, 2, 94583745322526, 0, 9, 2, 94583758079712, 94583769538032, 94583758073760, 4, 2, 140729980668388}}}} [04:32:26.487] send_ready_for_query = false [04:32:26.487] idle_in_transaction_timeout_enabled = false [04:32:26.487] idle_session_timeout_enabled = false [04:32:26.487] __func__ = "PostgresMain" [04:32:26.487] #19 0x00005605fe5c4c45 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:32:26.487] bsdata = [04:32:26.487] #20 0x00005605fe47611c in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x7ffe4081c8fc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe4081c950) at ../src/backend/postmaster/launch_backend.c:274 [04:32:26.487] pid = [04:32:26.487] #21 0x00005605fe47b328 in BackendStartup (client_sock=client_sock@entry=0x7ffe4081c950) at ../src/backend/postmaster/postmaster.c:3466 [04:32:26.487] bn = 0x56060002c2c8 [04:32:26.487] pid = [04:32:26.487] startup_data = {canAcceptConnections = CAC_OK} [04:32:26.487] cac = [04:32:26.487] __func__ = "BackendStartup" [04:32:26.487] #22 0x00005605fe47d34c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [04:32:26.487] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\203\037\005\177\000\000\240\357\327 \005\177\000\000\370Ɂ@\376\177\000\000\364Ɂ@\376\177", '\000' , "\222f_\375\005V\000\000\320G[\375\005V\000\000\300ʁ@\376\177\000\000\270ʁ@\376\177\000\000\225[\362\001\000\000\000\000\240\224\003 \005\177\000\000+", '\000' , "\005V\000\000\240e_\375\005V\000", __ss_align = 139660006815336}, salen = 2}} [04:32:26.487] i = 0 [04:32:26.487] now = [04:32:26.487] last_lockfile_recheck_time = 1736656117 [04:32:26.487] last_touch_time = 1736656117 [04:32:26.487] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x5605fd5f6692}, {pos = 555251304, events = 32517, fd = 537105968, user_data = 0x7f05211872e0}, {pos = 2090263927, events = 0, fd = 1082248000, user_data = 0x7f052115da48}, {pos = 15, events = 0, fd = 537105968, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f05211872e0}, {pos = 1082247864, events = 32766, fd = 1082247872, user_data = 0x7f0521187668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = 23168, events = 22022, fd = 1, user_data = 0x7ffe4081cfe3}, {pos = -1, events = 0, fd = 528670752, user_data = 0x7f0520d7efa0}, {pos = 201384, events = 22022, fd = 201096, user_data = 0x560600030f61}, {pos = 555105982, events = 32517, fd = 1, user_data = 0x7f05211872e0}, {pos = 426, events = 0, fd = -18801328, user_data = 0x0}, {pos = 229, events = 0, fd = 23104, user_data = 0x7f0521163ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f051f82e020}, {pos = 529477184, events = 32517, fd = 16, user_data = 0x7ffe4081cf10}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 555114938, events = 32517, fd = 0, user_data = 0x7f051f8aeda4 }, {pos = 0, events = 0, fd = -11777408, user_data = 0x2}, {pos = 0, events = 0, fd = -237936, user_data = 0x5605fe562749 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = 23104, user_data = 0x7f0521163ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f051f8364c8}, {pos = 529231981, events = 32517, fd = -11721280, user_data = 0x560600036740}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 530521184, events = 32517, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 909273419, user_data = 0x362020200a0a6749}, {pos = 1882153332, events = 1952539751, fd = 925960801, user_data = 0x2f6b636568635f33}, {pos = 1635017060, events = 811562031, fd = 1684826485, user_data = 0x72747365742f646c}, {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 = 1024, user_data = 0x7f051f8b58be}, {pos = 530504160, events = 32517, fd = 529142126, user_data = 0x100000400}, {pos = 7, events = 0, fd = 201616, user_data = 0x6a0fb7de62e0bf00}, {pos = 530507232, events = 32517, fd = -328, user_data = 0x0}, {pos = 200776, events = 22022, 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 = 40142, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 23104, user_data = 0x7f051f8f3053 }, {pos = 200776, events = 22022, fd = 1024, user_data = 0x7ffe4081cfd8}, {pos = -24390635, events = 22021, fd = -11712880, user_data = 0x5605fe8abed2 }, {pos = 200576, events = 22022, fd = 15520, user_data = 0x560600030f80}, {pos = 529225918, events = 32517, fd = 0, user_data = 0x5605fe8bdb3c }, {pos = 200576, events = 1, fd = -24388475, user_data = 0x560600003ca0}, {pos = 1658896128, events = 1779415006, fd = 0, user_data = 0x7f051f8a2ab1}, {pos = 529143024, events = 32517, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -237936, user_data = 0x6a0fb7de62e0bf00}, {pos = 0, events = 0, fd = 1658896128, user_data = 0xc}, {pos = 1658896128, events = 1779415006, fd = 0, user_data = 0x7f051f85b239 }, {pos = 230, events = 0, fd = -28877287, user_data = 0x400000}, {pos = 0, events = 0, fd = -237936, user_data = 0x5605fe8abd66 }, {pos = -150576, events = 22021, fd = 15520, user_data = 0x5605fffdb3d0}, {pos = 1, events = 0, fd = 0, user_data = 0x5605fe86a56b }, {pos = 12, events = 0, fd = 191912, user_data = 0x56060002ed88}, {pos = -11776000, events = 22021, fd = 296, user_data = 0x5605fe478633 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -28860930, events = 22021, fd = -15381392, user_data = 0x560600004658}} [04:32:26.487] nevents = 1 [04:32:26.487] __func__ = "ServerLoop" [04:32:26.487] #23 0x00005605fe47ebab in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5605fffc1d00) at ../src/backend/postmaster/postmaster.c:1377 [04:32:26.487] opt = [04:32:26.487] status = [04:32:26.487] userDoption = [04:32:26.487] listen_addr_saved = false [04:32:26.487] output_config_variable = [04:32:26.487] __func__ = "PostmasterMain" [04:32:26.487] #24 0x00005605fe2aa91f in main (argc=4, argv=0x5605fffc1d00) at ../src/backend/main/main.c:230 [04:32:26.487] do_check_root = [04:32:26.487] dispatch_option = [04:32:26.507] -e [04:32:26.507] [04:32:26.507] [04:32:26.572] dumping /tmp/cores/postgres-6-26462.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [04:32:26.822] [New LWP 26462] [04:32:26.822] [04:32:26.822] This GDB supports auto-downloading debuginfo from the following URLs: [04:32:26.822] [04:32:26.822] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [04:32:26.822] Debuginfod has been disabled. [04:32:26.822] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [04:32:26.928] [Thread debugging using libthread_db enabled] [04:32:26.928] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [04:32:26.928] Core was generated by `postgres: postgres regression [local] SELECT '. [04:32:26.928] Program terminated with signal SIGABRT, Aborted. [04:32:26.928] #0 0x00007f97deea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:28.010] [04:32:28.010] Thread 1 (Thread 0x7f97dedd5f00 (LWP 26462)): [04:32:28.010] #0 0x00007f97deea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:28.010] No symbol table info available. [04:32:28.010] #1 0x00007f97dee5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:28.010] No symbol table info available. [04:32:28.010] #2 0x00007f97dee45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:28.010] No symbol table info available. [04:32:28.010] #3 0x00007f97df01e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [04:32:28.010] No locals. [04:32:28.010] #4 0x00007f97df02aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [04:32:28.010] No locals. [04:32:28.010] #5 0x00007f97df00dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5624423398a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [04:32:28.010] bp = 140723196496256 [04:32:28.010] pc = [04:32:28.010] Opts = {FromUnrecoverableHandler = true, pc = 94713715510686, bp = 94714625706216} [04:32:28.010] #6 0x00005624415e4d9e in examine_self_contradictory_rels (root=root@entry=0x5624779ea788, rel=rel@entry=0x5624779eb5f8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [04:32:28.010] lc__state = [04:32:28.010] rlist = [04:32:28.010] i = 3 [04:32:28.010] br = [04:32:28.010] expression = [04:32:28.010] or_rinfo = 0x5624779ed678 [04:32:28.010] ccxt = [04:32:28.010] delidx = 0x5624779eddf9 [04:32:28.010] arglst = [04:32:28.010] lc = [04:32:28.010] arg = [04:32:28.010] n = [04:32:28.010] restrictinfo = [04:32:28.010] ccwapper = {clausecxt = 0x5624779ed3b8} [04:32:28.010] sec = {sopcinfo = {n_members = 38, opcies = 0x5624779ecaa8}, attrsdc = {min_attr = -6, max_attr = 7, len_set = 2, atop_array = 0x5624779ec088, atop_set = 0x5624779ec618}, ccfree = 0x5624779ec718, vifree = 0x5624779ed9e8} [04:32:28.010] __func__ = "examine_self_contradictory_rels" [04:32:28.010] #7 0x00005624415e4fad in examine_self_contradictory_rels_phase1 (root=root@entry=0x5624779ea788) at ../src/backend/optimizer/plan/contradictory.c:2608 [04:32:28.010] rel = 0x5624779eb5f8 [04:32:28.010] rti = 1 [04:32:28.010] rinfo = [04:32:28.010] #8 0x00005624415afe3d in query_planner (root=root@entry=0x5624779ea788, qp_callback=qp_callback@entry=0x5624415b5283 , qp_extra=qp_extra@entry=0x7ffcac238b80) at ../src/backend/optimizer/plan/planmain.c:193 [04:32:28.010] parse = 0x5624779df768 [04:32:28.010] joinlist = 0x5624779ec688 [04:32:28.010] final_rel = [04:32:28.010] __func__ = "query_planner" [04:32:28.010] #9 0x00005624415c29e2 in grouping_planner (root=root@entry=0x5624779ea788, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [04:32:28.010] sort_input_targets = 0x5624779eb4e8 [04:32:28.010] sort_input_target_parallel_safe = [04:32:28.010] grouping_target = [04:32:28.010] scanjoin_target = [04:32:28.010] activeWindows = 0x0 [04:32:28.010] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [04:32:28.010] sort_input_targets_contain_srfs = 0x2 [04:32:28.010] have_grouping = [04:32:28.010] wflists = 0x0 [04:32:28.010] gset_data = 0x0 [04:32:28.010] sort_input_target = [04:32:28.010] grouping_targets = 0x0 [04:32:28.010] grouping_target_parallel_safe = [04:32:28.010] scanjoin_targets = 0x5624779ea788 [04:32:28.010] scanjoin_target_parallel_safe = [04:32:28.010] grouping_targets_contain_srfs = 0x5624779eb588 [04:32:28.010] scanjoin_targets_contain_srfs = 0x0 [04:32:28.010] scanjoin_target_same_exprs = [04:32:28.010] parse = 0x5624779df768 [04:32:28.010] offset_est = 0 [04:32:28.010] count_est = 0 [04:32:28.010] limit_tuples = -1 [04:32:28.010] have_postponed_srfs = false [04:32:28.010] final_target = [04:32:28.010] final_targets = 0x5624779e9158 [04:32:28.010] final_targets_contain_srfs = 0x562441603c86 [04:32:28.010] final_target_parallel_safe = [04:32:28.010] current_rel = [04:32:28.010] final_rel = [04:32:28.010] extra = {limit_needed = 184, limit_tuples = 4.6795242715932243e-310, count_est = 94714625701256, offset_est = 94714625697672} [04:32:28.010] lc = [04:32:28.010] __func__ = "grouping_planner" [04:32:28.010] #10 0x00005624415c5966 in subquery_planner (glob=glob@entry=0x5624779ea4a0, parse=parse@entry=0x5624779df768, 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 [04:32:28.010] root = 0x5624779ea788 [04:32:28.010] newWithCheckOptions = [04:32:28.010] newHaving = 0x0 [04:32:28.010] hasOuterJoins = [04:32:28.010] hasResultRTEs = false [04:32:28.010] final_rel = [04:32:28.010] l = 0x0 [04:32:28.010] #11 0x00005624415c65f7 in standard_planner (parse=0x5624779df768, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [04:32:28.010] result = [04:32:28.010] glob = 0x5624779ea4a0 [04:32:28.010] tuple_fraction = 0 [04:32:28.010] root = [04:32:28.010] final_rel = [04:32:28.010] best_path = [04:32:28.010] top_plan = [04:32:28.010] lp = [04:32:28.010] lr = [04:32:28.010] #12 0x00005624415c7661 in planner (parse=parse@entry=0x5624779df768, query_string=query_string@entry=0x5624779df420 "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 [04:32:28.010] result = [04:32:28.010] #13 0x00005624418373b5 in pg_plan_query (querytree=querytree@entry=0x5624779df768, query_string=query_string@entry=0x5624779df420 "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 [04:32:28.010] plan = [04:32:28.010] #14 0x0000562441336843 in standard_ExplainOneQuery (query=0x5624779df768, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5624779e9f30, queryString=0x5624779df420 "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 [04:32:28.010] plan = [04:32:28.010] planstart = [04:32:28.010] planduration = {ticks = 94713714684375} [04:32:28.010] bufusage_start = {shared_blks_hit = 77427, shared_blks_read = 84, shared_blks_dirtied = 303, shared_blks_written = 233, 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}} [04:32:28.010] bufusage = {shared_blks_hit = 0, shared_blks_read = 94713717710174, shared_blks_dirtied = 143361713389568, shared_blks_written = 72057594037927936, local_blks_hit = 140290059889504, local_blks_read = 94714625652432, local_blks_dirtied = 94714625652584, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94713720569369, shared_blk_read_time = {ticks = 140290059889504}, shared_blk_write_time = {ticks = 94713720569388}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94713720950433}, temp_blk_read_time = {ticks = 94714625651488}, temp_blk_write_time = {ticks = 64}} [04:32:28.010] mem_counters = {nblocks = 94714625696768, freechunks = 4294967297, totalspace = 140723196497392, freespace = 10} [04:32:28.010] planner_ctx = 0x0 [04:32:28.010] saved_ctx = 0x0 [04:32:28.010] #15 0x0000562441336b29 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5624779e9f30, pstate=pstate@entry=0x5624779e9e20, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [04:32:28.010] No locals. [04:32:28.010] #16 0x0000562441337a80 in ExplainQuery (pstate=pstate@entry=0x5624779e9e20, stmt=stmt@entry=0x5624779df610, params=params@entry=0x0, dest=dest@entry=0x5624779e9d90) at ../src/backend/commands/explain.c:357 [04:32:28.010] l__state = [04:32:28.010] l = 0x5624779ea468 [04:32:28.010] es = 0x5624779e9f30 [04:32:28.010] tstate = [04:32:28.010] jstate = [04:32:28.010] query = [04:32:28.010] rewritten = 0x5624779ea450 [04:32:28.010] lc = 0x0 [04:32:28.010] timing_set = false [04:32:28.010] buffers_set = false [04:32:28.010] summary_set = false [04:32:28.010] __func__ = "ExplainQuery" [04:32:28.010] #17 0x0000562441841dd5 in standard_ProcessUtility (pstmt=0x5624779df500, queryString=0x5624779df420 "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=0x5624779e9d90, qc=0x7ffcac239070) at ../src/backend/tcop/utility.c:866 [04:32:28.010] parsetree = 0x5624779df610 [04:32:28.010] isTopLevel = false [04:32:28.010] isAtomicContext = true [04:32:28.010] pstate = 0x5624779e9e20 [04:32:28.010] readonly_flags = [04:32:28.010] __func__ = "standard_ProcessUtility" [04:32:28.010] #18 0x00005624418424fe in ProcessUtility (pstmt=pstmt@entry=0x5624779df500, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_QUERY, params=, queryEnv=, dest=0x5624779e9d90, qc=0x7ffcac239070) at ../src/backend/tcop/utility.c:523 [04:32:28.010] No locals. [04:32:28.010] #19 0x000056244183debc in PortalRunUtility (portal=portal@entry=0x562477905130, pstmt=0x5624779df500, isTopLevel=isTopLevel@entry=false, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5624779e9d90, qc=qc@entry=0x7ffcac239070) at ../src/backend/tcop/pquery.c:1152 [04:32:28.010] No locals. [04:32:28.010] #20 0x000056244183e72f in FillPortalStore (portal=portal@entry=0x562477905130, isTopLevel=isTopLevel@entry=false) at ../src/backend/tcop/pquery.c:1025 [04:32:28.010] treceiver = 0x5624779e9d90 [04:32:28.010] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:32:28.010] __func__ = "FillPortalStore" [04:32:28.010] #21 0x000056244183f063 in PortalRunFetch (portal=portal@entry=0x562477905130, fdirection=fdirection@entry=FETCH_FORWARD, count=count@entry=10, dest=dest@entry=0x562442069500 ) at ../src/backend/tcop/pquery.c:1433 [04:32:28.010] _save_exception_stack = 0x7ffcac239620 [04:32:28.010] _save_context_stack = 0x7ffcac239490 [04:32:28.010] _local_sigjmp_buf = {{__jmpbuf = {94713726539008, 6057641555605121709, 0, 10, 140723196499120, 94714625541816, 549623330947001005, 6057760142512548525}, __mask_was_saved = 0, __saved_mask = {__val = {1095624232, 94714625651744, 94713720960569, 140723196499088, 94713714434151, 144, 140290060667879, 94714625569248, 8192, 94714625626656, 94714625569248, 94714625569248, 94714625569504, 0, 94713720952676, 0}}}} [04:32:28.010] _do_rethrow = [04:32:28.010] result = [04:32:28.010] saveActivePortal = 0x562477905020 [04:32:28.010] saveResourceOwner = 0x562477972708 [04:32:28.010] savePortalContext = 0x562477a27f20 [04:32:28.010] oldContext = 0x56247799d0f0 [04:32:28.010] __func__ = "PortalRunFetch" [04:32:28.010] #22 0x00005624414de7a9 in _SPI_cursor_operation (portal=portal@entry=0x562477905130, direction=direction@entry=FETCH_FORWARD, count=count@entry=10, dest=0x562442069500 ) at ../src/backend/executor/spi.c:3027 [04:32:28.010] nfetched = [04:32:28.010] __func__ = "_SPI_cursor_operation" [04:32:28.010] #23 0x00005624414e41d1 in SPI_cursor_fetch (portal=portal@entry=0x562477905130, forward=forward@entry=true, count=10) at ../src/backend/executor/spi.c:1808 [04:32:28.010] No locals. [04:32:28.010] #24 0x00007f97d33a3b6d in exec_for_query (estate=estate@entry=0x7ffcac2394b0, stmt=stmt@entry=0x5624779c46b8, portal=portal@entry=0x562477905130, prefetch_ok=, prefetch_ok@entry=true) at ../src/pl/plpgsql/src/pl_exec.c:5887 [04:32:28.010] var = 0x5624779c4708 [04:32:28.010] tuptab = [04:32:28.010] found = false [04:32:28.010] rc = 0 [04:32:28.010] previous_id = 1 [04:32:28.010] tupdescs_match = true [04:32:28.010] n = [04:32:28.010] #25 0x00007f97d33a4777 in exec_stmt_dynfors (estate=estate@entry=0x7ffcac2394b0, stmt=stmt@entry=0x5624779c46b8) at ../src/pl/plpgsql/src/pl_exec.c:4645 [04:32:28.010] portal = 0x562477905130 [04:32:28.010] rc = [04:32:28.010] #26 0x00007f97d33a006f in exec_stmts (estate=estate@entry=0x7ffcac2394b0, stmts=0x5624779c4db8) at ../src/pl/plpgsql/src/pl_exec.c:2096 [04:32:28.010] stmt = 0x5624779c46b8 [04:32:28.010] rc = [04:32:28.010] s__state = [04:32:28.010] save_estmt = 0x5624779c4e08 [04:32:28.010] s = [04:32:28.010] __func__ = "exec_stmts" [04:32:28.010] #27 0x00007f97d33a0d3d in exec_stmt_block (estate=estate@entry=0x7ffcac2394b0, block=block@entry=0x5624779c4e08) at ../src/pl/plpgsql/src/pl_exec.c:1939 [04:32:28.010] rc = -1 [04:32:28.010] i = 3 [04:32:28.010] __func__ = "exec_stmt_block" [04:32:28.010] #28 0x00007f97d33a0e84 in exec_toplevel_block (estate=estate@entry=0x7ffcac2394b0, block=0x5624779c4e08) at ../src/pl/plpgsql/src/pl_exec.c:1630 [04:32:28.010] rc = [04:32:28.010] #29 0x00007f97d33a15b9 in plpgsql_exec_function (func=func@entry=0x5624779722f8, fcinfo=fcinfo@entry=0x5624779b1250, 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 [04:32:28.010] estate = {func = 0x5624779722f8, 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 = 0x5624779b3160, tuple_store_owner = 0x562477972708, rsi = 0x7ffcac239760, found_varno = 4, ndatums = 9, datums = 0x5624779bb290, datum_context = 0x5624779bb140, paramLI = 0x5624779bb240, simple_eval_estate = 0x5624779bf260, simple_eval_resowner = 0x5624778c3de8, procedure_resowner = 0x0, cast_hash = 0x5624779cd2f0, stmt_mcontext = 0x5624779cb1e0, stmt_mcontext_parent = 0x5624779bb140, eval_tuptable = 0x0, eval_processed = 0, eval_econtext = 0x5624779bf470, err_stmt = 0x5624779c46b8, err_var = 0x0, err_text = 0x0, plugin_info = 0x0} [04:32:28.010] plerrcontext = {previous = 0x0, callback = 0x7f97d339e24e , arg = 0x7ffcac2394b0} [04:32:28.010] i = 1 [04:32:28.010] rc = [04:32:28.010] __func__ = "plpgsql_exec_function" [04:32:28.010] #30 0x00007f97d33aa917 in plpgsql_call_handler (fcinfo=0x5624779b1250) at ../src/pl/plpgsql/src/pl_handler.c:276 [04:32:28.010] _save_exception_stack = 0x7ffcac239a50 [04:32:28.010] _save_context_stack = 0x0 [04:32:28.010] _local_sigjmp_buf = {{__jmpbuf = {94714625204984, -551128250150098259, 0, 94714625472152, 1, 94714625474608, 549623330852629165, 537715833424505517}, __mask_was_saved = 0, __saved_mask = {__val = {94714625462904, 0, 0, 0, 94713713646045, 94714625462864, 94714625473784, 32, 94713713848906, 94714625474200, 94714625472152, 94714625462608, 94714625462864, 94714625462608, 94713714051399, 94714625462864}}}} [04:32:28.010] _do_rethrow = false [04:32:28.010] nonatomic = false [04:32:28.010] func = 0x5624779722f8 [04:32:28.010] save_cur_estate = 0x0 [04:32:28.010] procedure_resowner = 0x0 [04:32:28.010] retval = 0 [04:32:28.010] rc = [04:32:28.010] __func__ = "plpgsql_call_handler" [04:32:28.010] #31 0x0000562441450905 in ExecMakeTableFunctionResult (setexpr=0x5624779b37c8, econtext=0x5624779b3698, argContext=, expectedDesc=0x5624779b4030, randomAccess=false) at ../src/backend/executor/execSRF.c:234 [04:32:28.010] result = 140290060993864 [04:32:28.010] tupstore = 0x0 [04:32:28.010] tupdesc = 0x0 [04:32:28.010] funcrettype = 2249 [04:32:28.010] returnsTuple = [04:32:28.010] returnsSet = true [04:32:28.010] fcinfo = 0x5624779b1250 [04:32:28.010] fcusage = {fs = 0x0, save_f_total_time = {ticks = 94713720422684}, save_total = {ticks = 140290060993904}, start = {ticks = 140290060993904}} [04:32:28.010] rsinfo = {type = T_ReturnSetInfo, econtext = 0x5624779b3698, expectedDesc = 0x5624779b4030, allowedModes = 11, returnMode = SFRM_ValuePerCall, isDone = ExprSingleResult, setResult = 0x0, setDesc = 0x0} [04:32:28.010] tmptup = {t_len = 3544204680, t_self = {ip_blkid = {bi_hi = 32663, bi_lo = 0}, ip_posid = 2}, t_tableOid = 0, t_data = 0x1} [04:32:28.010] callerContext = 0x5624779b3160 [04:32:28.010] first_time = true [04:32:28.010] __func__ = "ExecMakeTableFunctionResult" [04:32:28.010] #32 0x0000562441480c70 in FunctionNext (node=0x5624779b3488) at ../src/backend/executor/nodeFunctionscan.c:94 [04:32:28.010] tstore = 0x0 [04:32:28.010] estate = [04:32:28.010] direction = ForwardScanDirection [04:32:28.010] scanslot = 0x5624779b4250 [04:32:28.010] alldone = [04:32:28.010] oldpos = [04:32:28.010] funcno = [04:32:28.010] att = [04:32:28.010] #33 0x0000562441452265 in ExecScanFetch (node=node@entry=0x5624779b3488, accessMtd=accessMtd@entry=0x562441480a3b , recheckMtd=recheckMtd@entry=0x562441480947 ) at ../src/backend/executor/execScan.c:131 [04:32:28.010] estate = [04:32:28.010] #34 0x000056244145236f in ExecScan (node=0x5624779b3488, accessMtd=accessMtd@entry=0x562441480a3b , recheckMtd=recheckMtd@entry=0x562441480947 ) at ../src/backend/executor/execScan.c:180 [04:32:28.010] econtext = 0x5624779b3698 [04:32:28.010] qual = 0x0 [04:32:28.010] projInfo = 0x0 [04:32:28.010] #35 0x00005624414809bf in ExecFunctionScan (pstate=) at ../src/backend/executor/nodeFunctionscan.c:269 [04:32:28.010] node = [04:32:28.010] #36 0x000056244144afec in ExecProcNodeFirst (node=0x5624779b3488) at ../src/backend/executor/execProcnode.c:469 [04:32:28.010] No locals. [04:32:28.010] #37 0x0000562441436490 in ExecProcNode (node=node@entry=0x5624779b3488) at ../src/include/executor/executor.h:275 [04:32:28.010] No locals. [04:32:28.010] #38 0x0000562441436e4a in ExecutePlan (queryDesc=queryDesc@entry=0x562477a28020, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x562477a2f910) at ../src/backend/executor/execMain.c:1655 [04:32:28.010] estate = 0x5624779b3260 [04:32:28.010] planstate = 0x5624779b3488 [04:32:28.010] use_parallel_mode = false [04:32:28.010] slot = [04:32:28.010] current_tuple_count = 0 [04:32:28.010] #39 0x0000562441438598 in standard_ExecutorRun (queryDesc=0x562477a28020, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:363 [04:32:28.010] estate = 0x5624779b3260 [04:32:28.010] operation = CMD_SELECT [04:32:28.010] dest = 0x562477a2f910 [04:32:28.010] sendTuples = [04:32:28.010] oldcontext = 0x562477a27f20 [04:32:28.010] #40 0x00005624414385f8 in ExecutorRun (queryDesc=queryDesc@entry=0x562477a28020, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:300 [04:32:28.010] No locals. [04:32:28.010] #41 0x000056244183b7b9 in PortalRunSelect (portal=portal@entry=0x562477905020, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x562477a2f910) at ../src/backend/tcop/pquery.c:920 [04:32:28.010] queryDesc = 0x562477a28020 [04:32:28.010] direction = [04:32:28.010] nprocessed = [04:32:28.010] __func__ = "PortalRunSelect" [04:32:28.010] #42 0x000056244183eb81 in PortalRun (portal=portal@entry=0x562477905020, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x562477a2f910, altdest=altdest@entry=0x562477a2f910, qc=qc@entry=0x7ffcac239b70) at ../src/backend/tcop/pquery.c:764 [04:32:28.010] _save_exception_stack = 0x7ffcac239c20 [04:32:28.010] _save_context_stack = 0x0 [04:32:28.010] _local_sigjmp_buf = {{__jmpbuf = {0, 6057641129593858733, 94714624757792, 94714624215896, 94714624215872, 94714624215824, 549623331257379501, 6057760142598793901}, __mask_was_saved = 0, __saved_mask = {__val = {94713720954850, 2888014591, 4, 94714624215824, 112, 179, 94714624757792, 94714624215896, 94714624215872, 94714624215824, 94713721042053, 1, 2, 179, 94713710287263, 0}}}} [04:32:28.010] _do_rethrow = [04:32:28.010] result = [04:32:28.010] nprocessed = [04:32:28.010] saveTopTransactionResourceOwner = 0x5624778c35f8 [04:32:28.010] saveTopTransactionContext = 0x562477917450 [04:32:28.010] saveActivePortal = 0x0 [04:32:28.010] saveResourceOwner = 0x5624778c35f8 [04:32:28.010] savePortalContext = 0x0 [04:32:28.010] saveMemoryContext = 0x562477917450 [04:32:28.010] __func__ = "PortalRun" [04:32:28.010] #43 0x0000562441837e81 in exec_simple_query (query_string=query_string@entry=0x56247787fb10 "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 [04:32:28.010] cmdtaglen = 6 [04:32:28.010] snapshot_set = [04:32:28.010] per_parsetree_context = 0x0 [04:32:28.010] plantree_list = 0x562477a2f8c0 [04:32:28.010] parsetree = 0x562477880b10 [04:32:28.010] commandTag = [04:32:28.010] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:32:28.010] querytree_list = [04:32:28.010] portal = 0x562477905020 [04:32:28.010] receiver = 0x562477a2f910 [04:32:28.010] format = 0 [04:32:28.010] cmdtagname = [04:32:28.010] parsetree_item__state = [04:32:28.010] dest = DestRemote [04:32:28.010] oldcontext = 0x562477917450 [04:32:28.010] parsetree_list = 0x562477880b40 [04:32:28.010] parsetree_item = 0x562477880b58 [04:32:28.010] save_log_statement_stats = false [04:32:28.010] was_logged = false [04:32:28.010] use_implicit_block = false [04:32:28.010] msec_str = "\004\000\000\000\000\000\000\000/z\257A$V\000\000\000\234#\254\374\177\000\000x\000\000\000\000\000\000" [04:32:28.010] __func__ = "exec_simple_query" [04:32:28.010] #44 0x000056244183abda in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [04:32:28.010] query_string = 0x56247787fb10 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');" [04:32:28.010] firstchar = [04:32:28.010] input_message = {data = 0x56247787fb10 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');", len = 120, maxlen = 1024, cursor = 120} [04:32:28.010] local_sigjmp_buf = {{__jmpbuf = {94713733711576, 6057758414608329389, 140723196501372, 4, 2, 140723196501604, 549623331324488365, 6057760144569461421}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94714623942192, 17408, 94713733705632, 94714624476560, 2, 94713720954398, 0, 10, 2, 94713733711584, 94714623942192, 94713733705632, 4, 2, 140723196501604}}}} [04:32:28.010] send_ready_for_query = false [04:32:28.010] idle_in_transaction_timeout_enabled = false [04:32:28.010] idle_session_timeout_enabled = false [04:32:28.010] __func__ = "PostgresMain" [04:32:28.010] #45 0x0000562441830c45 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:32:28.010] bsdata = [04:32:28.010] #46 0x00005624416e211c in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x7ffcac239d7c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcac239dd0) at ../src/backend/postmaster/launch_backend.c:274 [04:32:28.010] pid = [04:32:28.010] #47 0x00005624416e7328 in BackendStartup (client_sock=client_sock@entry=0x7ffcac239dd0) at ../src/backend/postmaster/postmaster.c:3466 [04:32:28.010] bn = 0x5624778a80b8 [04:32:28.010] pid = [04:32:28.010] startup_data = {canAcceptConnections = CAC_OK} [04:32:28.010] cac = [04:32:28.010] __func__ = "BackendStartup" [04:32:28.010] #48 0x00005624416e934c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [04:32:28.010] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\343ޗ\177\000\000\240\0378\340\227\177\000\000x\236#\254\374\177\000\000t\236#\254\374\177", '\000' , "\222&\206@$V\000\000\320\a\202@$V\000\000@\237#\254\374\177\000\0008\237#\254\374\177\000\000\225[\362\001\000\000\000\000\240\264cߗ\177\000\000+", '\000' , "$V\000\000\240%\206@$V\000", __ss_align = 140290282792552}, salen = 2}} [04:32:28.010] i = 0 [04:32:28.010] now = [04:32:28.010] last_lockfile_recheck_time = 1736656041 [04:32:28.010] last_touch_time = 1736656041 [04:32:28.010] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x562440862692}, {pos = -528963992, events = 32663, fd = -547113424, user_data = 0x7f97e078a2e0}, {pos = 2090263927, events = 0, fd = -1406951488, user_data = 0x7f97e0760a48}, {pos = 15, events = 0, fd = -547113424, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f97e078a2e0}, {pos = -1406951624, events = 32764, fd = -1406951616, user_data = 0x7f97e078a668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 2005407744, events = 22052, fd = 1, user_data = 0x7ffcac23a463}, {pos = -1, events = 0, fd = -555556832, user_data = 0x7f97e0381fa0}, {pos = 2005587032, events = 22052, fd = 2005586744, user_data = 0x5624778ad111}, {pos = -529109314, events = 32663, fd = 1, user_data = 0x7f97e078a2e0}, {pos = 426, events = 0, fd = 1107811664, user_data = 0x0}, {pos = 249, events = 0, fd = 2005400528, user_data = 0x7f97e0766ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f97dee2e020}, {pos = -554750400, events = 32663, fd = 16, user_data = 0x7ffcac23a390}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -529100358, events = 32663, fd = 0, user_data = 0x7f97deeaeda4 }, {pos = 0, events = 0, fd = 1114835584, user_data = 0x2}, {pos = 0, events = 0, fd = 2005147344, user_data = 0x5624417ce749 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 2005400528, user_data = 0x7f97e0766ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f97dee364c8}, {pos = -554995603, events = 32663, fd = 1114891712, user_data = 0x5624778b2530}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = -553706400, events = 32663, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x352020200a0a3249}, {pos = 822763892, events = 909521719, fd = 875574837, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1024, user_data = 0x7f97deeb58be}, {pos = -553723424, events = 32663, fd = -555085458, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2005587264, user_data = 0xa4af8daaf90cfe00}, {pos = -553720352, events = 32663, fd = -328, user_data = 0x0}, {pos = 2005586424, events = 22052, 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 = 22087, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 2005400528, user_data = 0x7f97deef3053 }, {pos = 2005586424, events = 22052, fd = 1024, user_data = 0x7ffcac23a458}, {pos = 1102222357, events = 22052, fd = 1114900112, user_data = 0x562441b17ed2 }, {pos = 2005586224, events = 22052, fd = 2005400080, user_data = 0x5624778ad130}, {pos = -555001666, events = 32663, fd = 0, user_data = 0x562441b29b3c }, {pos = 2005586224, events = 1, fd = 1102224517, user_data = 0x56247787fa10}, {pos = -116589056, events = 2762968490, fd = 0, user_data = 0x7f97deea2ab1}, {pos = -555084560, events = 32663, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2005147344, user_data = 0xa4af8daaf90cfe00}, {pos = 0, events = 0, fd = -116589056, user_data = 0xc}, {pos = -116589056, events = 2762968490, fd = 0, user_data = 0x7f97dee5b239 }, {pos = 250, events = 0, fd = 1097735705, user_data = 0x400000}, {pos = 0, events = 0, fd = 2005147344, user_data = 0x562441b17d66 }, {pos = 2005233984, events = 22052, fd = 2005400080, user_data = 0x562477857140}, {pos = 1, events = 0, fd = 0, user_data = 0x562441ad656b }, {pos = 12, events = 0, fd = 2005577560, user_data = 0x5624778aaf38}, {pos = 1114836992, events = 22052, fd = 296, user_data = 0x5624416e4633 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1097752062, events = 22052, fd = 1111231600, user_data = 0x5624778803e8}} [04:32:28.010] nevents = 1 [04:32:28.010] __func__ = "ServerLoop" [04:32:28.010] #49 0x00005624416eabab in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x56247783dd90) at ../src/backend/postmaster/postmaster.c:1377 [04:32:28.010] opt = [04:32:28.010] status = [04:32:28.010] userDoption = [04:32:28.010] listen_addr_saved = false [04:32:28.010] output_config_variable = [04:32:28.010] __func__ = "PostmasterMain" [04:32:28.010] #50 0x000056244151691f in main (argc=8, argv=0x56247783dd90) at ../src/backend/main/main.c:230 [04:32:28.010] do_check_root = [04:32:28.010] dispatch_option = [04:32:28.048] -e [04:32:28.048] [04:32:28.048] [04:32:28.139] dumping /tmp/cores/postgres-6-23701.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [04:32:28.405] [New LWP 23701] [04:32:28.405] [04:32:28.405] This GDB supports auto-downloading debuginfo from the following URLs: [04:32:28.405] [04:32:28.405] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [04:32:28.405] Debuginfod has been disabled. [04:32:28.405] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [04:32:28.656] [Thread debugging using libthread_db enabled] [04:32:28.656] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [04:32:28.656] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN '. [04:32:28.656] Program terminated with signal SIGABRT, Aborted. [04:32:28.656] #0 0x00007f76bb4a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:29.647] [04:32:29.647] Thread 1 (Thread 0x7f76bbc33f00 (LWP 23701)): [04:32:29.647] #0 0x00007f76bb4a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:29.647] No symbol table info available. [04:32:29.647] #1 0x00007f76bb45afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:29.647] No symbol table info available. [04:32:29.647] #2 0x00007f76bb445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:29.647] No symbol table info available. [04:32:29.647] #3 0x00007f76bb61e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [04:32:29.647] No locals. [04:32:29.647] #4 0x00007f76bb62aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [04:32:29.647] No locals. [04:32:29.647] #5 0x00007f76bb60dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5628d5c518a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [04:32:29.647] bp = 140722782435232 [04:32:29.647] pc = [04:32:29.647] Opts = {FromUnrecoverableHandler = true, pc = 94733371166110, bp = 94734051832552} [04:32:29.647] #6 0x00005628d4efcd9e in examine_self_contradictory_rels (root=root@entry=0x5628fd6da8e8, rel=rel@entry=0x5628fd7ff9d8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [04:32:29.647] lc__state = [04:32:29.647] rlist = [04:32:29.647] i = 2 [04:32:29.647] br = [04:32:29.647] expression = [04:32:29.647] or_rinfo = 0x5628fd820038 [04:32:29.647] ccxt = [04:32:29.647] delidx = 0x5628fd81fed1 [04:32:29.647] arglst = [04:32:29.647] lc = [04:32:29.647] arg = [04:32:29.647] n = [04:32:29.647] restrictinfo = [04:32:29.647] ccwapper = {clausecxt = 0x5628fd81f868} [04:32:29.647] sec = {sopcinfo = {n_members = 38, opcies = 0x5628fd81f338}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x5628fd81eae8, atop_set = 0x5628fd81f748}, ccfree = 0x5628fd81fea0, vifree = 0x5628fd81f9d8} [04:32:29.647] __func__ = "examine_self_contradictory_rels" [04:32:29.647] #7 0x00005628d4efcfad in examine_self_contradictory_rels_phase1 (root=root@entry=0x5628fd6da8e8) at ../src/backend/optimizer/plan/contradictory.c:2608 [04:32:29.647] rel = 0x5628fd7ff9d8 [04:32:29.647] rti = 1 [04:32:29.647] rinfo = [04:32:29.647] #8 0x00005628d4ec7e3d in query_planner (root=root@entry=0x5628fd6da8e8, qp_callback=qp_callback@entry=0x5628d4ecd283 , qp_extra=qp_extra@entry=0x7ffc937579a0) at ../src/backend/optimizer/plan/planmain.c:193 [04:32:29.647] parse = 0x5628fd56dd38 [04:32:29.647] joinlist = 0x5628fd81eb58 [04:32:29.647] final_rel = [04:32:29.647] __func__ = "query_planner" [04:32:29.647] #9 0x00005628d4eda9e2 in grouping_planner (root=root@entry=0x5628fd6da8e8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [04:32:29.647] sort_input_targets = 0x5 [04:32:29.647] sort_input_target_parallel_safe = [04:32:29.647] grouping_target = [04:32:29.647] scanjoin_target = [04:32:29.647] activeWindows = 0x0 [04:32:29.647] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [04:32:29.647] sort_input_targets_contain_srfs = 0x1 [04:32:29.647] have_grouping = [04:32:29.647] wflists = 0x0 [04:32:29.647] gset_data = 0x0 [04:32:29.647] sort_input_target = [04:32:29.647] grouping_targets = 0x1 [04:32:29.647] grouping_target_parallel_safe = [04:32:29.647] scanjoin_targets = 0x0 [04:32:29.647] scanjoin_target_parallel_safe = [04:32:29.647] grouping_targets_contain_srfs = 0x1 [04:32:29.647] scanjoin_targets_contain_srfs = 0x5628d54432ec [04:32:29.647] scanjoin_target_same_exprs = [04:32:29.647] parse = 0x5628fd56dd38 [04:32:29.647] offset_est = 0 [04:32:29.647] count_est = 0 [04:32:29.647] limit_tuples = -1 [04:32:29.647] have_postponed_srfs = false [04:32:29.647] final_target = [04:32:29.647] final_targets = 0x5628fd66ef18 [04:32:29.647] final_targets_contain_srfs = 0x5628d4e388b7 [04:32:29.647] final_target_parallel_safe = [04:32:29.647] current_rel = [04:32:29.647] final_rel = [04:32:29.647] extra = {limit_needed = false, limit_tuples = 4.6804503798984288e-310, count_est = 94734050506632, offset_est = 94734050506632} [04:32:29.647] lc = [04:32:29.647] __func__ = "grouping_planner" [04:32:29.647] #10 0x00005628d4edd966 in subquery_planner (glob=glob@entry=0x5628fd840ae8, parse=parse@entry=0x5628fd56dd38, 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 [04:32:29.647] root = 0x5628fd6da8e8 [04:32:29.647] newWithCheckOptions = [04:32:29.647] newHaving = 0x0 [04:32:29.647] hasOuterJoins = [04:32:29.647] hasResultRTEs = false [04:32:29.647] final_rel = [04:32:29.647] l = 0x0 [04:32:29.647] #11 0x00005628d4ede5f7 in standard_planner (parse=0x5628fd56dd38, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [04:32:29.647] result = [04:32:29.647] glob = 0x5628fd840ae8 [04:32:29.647] tuple_fraction = 0 [04:32:29.647] root = [04:32:29.647] final_rel = [04:32:29.647] best_path = [04:32:29.647] top_plan = [04:32:29.647] lp = [04:32:29.647] lr = [04:32:29.647] #12 0x00005628d4edf661 in planner (parse=parse@entry=0x5628fd56dd38, query_string=query_string@entry=0x5628fd56ca90 "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 [04:32:29.647] result = [04:32:29.647] #13 0x00005628d514f3b5 in pg_plan_query (querytree=querytree@entry=0x5628fd56dd38, query_string=query_string@entry=0x5628fd56ca90 "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 [04:32:29.647] plan = [04:32:29.647] #14 0x00005628d4c4e843 in standard_ExplainOneQuery (query=0x5628fd56dd38, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5628fd840848, queryString=0x5628fd56ca90 "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 [04:32:29.647] plan = [04:32:29.647] planstart = [04:32:29.647] planduration = {ticks = 94733370339799} [04:32:29.647] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94733376610274, shared_blks_dirtied = 2473950350, shared_blks_written = 3, local_blks_hit = 4294967440, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94734049008952, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94733376697068}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94733370337180}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94734049008952}} [04:32:29.647] bufusage = {shared_blks_hit = 0, shared_blks_read = 94733373365598, shared_blks_dirtied = 73091753459715, shared_blks_written = 72057594037927936, local_blks_hit = 140147732276896, local_blks_read = 94734049010128, local_blks_dirtied = 94734049008952, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94733376224793, shared_blk_read_time = {ticks = 140147732276896}, shared_blk_write_time = {ticks = 94733376224812}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94733376605857}, temp_blk_read_time = {ticks = 94734049188976}, temp_blk_write_time = {ticks = 64}} [04:32:29.647] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140722782436368, freespace = 10} [04:32:29.647] planner_ctx = 0x0 [04:32:29.647] saved_ctx = 0x0 [04:32:29.647] #15 0x00005628d4c4eb29 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5628fd840848, pstate=pstate@entry=0x5628fd599f28, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [04:32:29.647] No locals. [04:32:29.647] #16 0x00005628d4c4fa80 in ExplainQuery (pstate=pstate@entry=0x5628fd599f28, stmt=stmt@entry=0x5628fd56db78, params=params@entry=0x0, dest=dest@entry=0x5628fd599e98) at ../src/backend/commands/explain.c:357 [04:32:29.647] l__state = [04:32:29.647] l = 0x5628fd7ff9a0 [04:32:29.647] es = 0x5628fd840848 [04:32:29.647] tstate = [04:32:29.647] jstate = [04:32:29.647] query = [04:32:29.647] rewritten = 0x5628fd7ff988 [04:32:29.647] lc = 0x0 [04:32:29.647] timing_set = false [04:32:29.647] buffers_set = false [04:32:29.647] summary_set = false [04:32:29.647] __func__ = "ExplainQuery" [04:32:29.647] #17 0x00005628d5159dd5 in standard_ProcessUtility (pstmt=0x5628fd56dc28, queryString=0x5628fd56ca90 "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=0x5628fd599e98, qc=0x7ffc93757e90) at ../src/backend/tcop/utility.c:866 [04:32:29.647] parsetree = 0x5628fd56db78 [04:32:29.647] isTopLevel = true [04:32:29.647] isAtomicContext = false [04:32:29.647] pstate = 0x5628fd599f28 [04:32:29.647] readonly_flags = [04:32:29.647] __func__ = "standard_ProcessUtility" [04:32:29.647] #18 0x00005628d515a4fe in ProcessUtility (pstmt=pstmt@entry=0x5628fd56dc28, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5628fd599e98, qc=0x7ffc93757e90) at ../src/backend/tcop/utility.c:523 [04:32:29.647] No locals. [04:32:29.647] #19 0x00005628d5155ebc in PortalRunUtility (portal=portal@entry=0x5628fd5f1a20, pstmt=0x5628fd56dc28, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5628fd599e98, qc=qc@entry=0x7ffc93757e90) at ../src/backend/tcop/pquery.c:1152 [04:32:29.647] No locals. [04:32:29.647] #20 0x00005628d515672f in FillPortalStore (portal=portal@entry=0x5628fd5f1a20, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [04:32:29.647] treceiver = 0x5628fd599e98 [04:32:29.647] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:32:29.647] __func__ = "FillPortalStore" [04:32:29.647] #21 0x00005628d5156c4a in PortalRun (portal=portal@entry=0x5628fd5f1a20, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5628fd66f328, altdest=altdest@entry=0x5628fd66f328, qc=qc@entry=0x7ffc93758050) at ../src/backend/tcop/pquery.c:759 [04:32:29.647] _save_exception_stack = 0x7ffc93758100 [04:32:29.647] _save_context_stack = 0x0 [04:32:29.647] _local_sigjmp_buf = {{__jmpbuf = {0, 8269215246547211512, 94734049548832, 94734049008624, 94734049008600, 94734049008552, 2408013285864559864, 8269303340826023160}, __mask_was_saved = 0, __saved_mask = {__val = {94733376610274, 2473951199, 4, 94734049008552, 112, 153, 94734049548832, 94734049008624, 94734049008600, 94734049008552, 94733376697477, 1, 2, 153, 94733365942687, 0}}}} [04:32:29.647] _do_rethrow = [04:32:29.647] result = [04:32:29.647] nprocessed = [04:32:29.647] saveTopTransactionResourceOwner = 0x5628fd5ae4d8 [04:32:29.647] saveTopTransactionContext = 0x5628fd603a40 [04:32:29.647] saveActivePortal = 0x0 [04:32:29.647] saveResourceOwner = 0x5628fd5ae4d8 [04:32:29.647] savePortalContext = 0x0 [04:32:29.647] saveMemoryContext = 0x5628fd603a40 [04:32:29.647] __func__ = "PortalRun" [04:32:29.647] #22 0x00005628d514fe81 in exec_simple_query (query_string=query_string@entry=0x5628fd56ca90 "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 [04:32:29.647] cmdtaglen = 7 [04:32:29.647] snapshot_set = [04:32:29.647] per_parsetree_context = 0x0 [04:32:29.647] plantree_list = 0x5628fd66f2d8 [04:32:29.647] parsetree = 0x5628fd56dba8 [04:32:29.647] commandTag = [04:32:29.647] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:32:29.647] querytree_list = [04:32:29.647] portal = 0x5628fd5f1a20 [04:32:29.647] receiver = 0x5628fd66f328 [04:32:29.647] format = 0 [04:32:29.647] cmdtagname = [04:32:29.647] parsetree_item__state = [04:32:29.647] dest = DestRemote [04:32:29.647] oldcontext = 0x5628fd603a40 [04:32:29.647] parsetree_list = 0x5628fd56dbd8 [04:32:29.647] parsetree_item = 0x5628fd56dbf0 [04:32:29.647] save_log_statement_stats = false [04:32:29.647] was_logged = true [04:32:29.647] use_implicit_block = false [04:32:29.647] msec_str = "\004\000\000\000\000\000\000\000/\372@\325(V\000\000\340\200u\223\374\177\000\000n\000\000\000\000\000\000" [04:32:29.647] __func__ = "exec_simple_query" [04:32:29.647] #23 0x00005628d5152bda in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [04:32:29.647] query_string = 0x5628fd56ca90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [04:32:29.647] firstchar = [04:32:29.647] input_message = {data = 0x5628fd56ca90 "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} [04:32:29.647] local_sigjmp_buf = {{__jmpbuf = {94733389367000, 8269296878179374328, 140722782437980, 4, 17, 140722782438212, 2408013283515749624, 8269303343284278520}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94734048734736, 16128, 94733389361056, 94734049268880, 17, 94733376609822, 0, 9, 2, 94733389367008, 94734048734736, 94733389361056, 4, 17, 140722782438212}}}} [04:32:29.647] send_ready_for_query = false [04:32:29.647] idle_in_transaction_timeout_enabled = false [04:32:29.647] idle_session_timeout_enabled = false [04:32:29.647] __func__ = "PostgresMain" [04:32:29.647] #24 0x00005628d5148c45 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:32:29.647] bsdata = [04:32:29.647] #25 0x00005628d4ffa11c in postmaster_child_launch (child_type=B_BACKEND, child_slot=17, startup_data=startup_data@entry=0x7ffc9375825c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc937582b0) at ../src/backend/postmaster/launch_backend.c:274 [04:32:29.647] pid = [04:32:29.647] #26 0x00005628d4fff328 in BackendStartup (client_sock=client_sock@entry=0x7ffc937582b0) at ../src/backend/postmaster/postmaster.c:3466 [04:32:29.647] bn = 0x5628fd595288 [04:32:29.647] pid = [04:32:29.647] startup_data = {canAcceptConnections = CAC_OK} [04:32:29.647] cac = [04:32:29.647] __func__ = "BackendStartup" [04:32:29.647] #27 0x00005628d500134c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [04:32:29.647] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\222\246\027\324(V\000\000Ї\023\324(V\000\000\000\204u\223\374\177\000\000\370\203u\223\374\177\000\000\225[\362\001\000\000\000\000\240t(\274v\177\000\000+", '\000' , "\374\177\000\000\000\004\000\000\000\000\000\000h\266ܼv\177\000\0000v(\274v\177\000\000\340\262ܼv\177\000\000\316)fR\000\000\000", __ss_align = 2473952320}, salen = 2}} [04:32:29.647] i = 0 [04:32:29.647] now = [04:32:29.647] last_lockfile_recheck_time = 1736656043 [04:32:29.647] last_touch_time = 1736656043 [04:32:29.647] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1138198992, events = 32630, fd = -1126386976, user_data = 0x7c96e577}, {pos = -1821014912, events = 32764, fd = -1126557112, user_data = 0xf}, {pos = -1138198992, events = 32630, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1126386976, user_data = 0x7ffc937583f8}, {pos = -1821015040, events = 32764, fd = -1126386072, user_data = 0x0}, {pos = -44643672, events = 22056, fd = -1152681334, user_data = 0x5628fd56caa8}, {pos = 1, events = 22056, fd = 32768, user_data = 0xffffffff}, {pos = -1153245152, events = 32630, fd = -1130614880, user_data = 0x5628fd599f98}, {pos = -44458376, events = 22056, fd = -44458927, user_data = 0x7f76bcda7ebe}, {pos = 1, events = 0, fd = -1126386976, user_data = 0x1aa}, {pos = -711369392, events = 22056, fd = 0, user_data = 0xe5}, {pos = -44643672, events = 22056, fd = -1126531394, user_data = 0x1}, {pos = 0, events = 0, fd = -1153245152, user_data = 0x7f76bb4f2e40 }, {pos = 16, events = 0, fd = -1821013904, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f76bcdaa1ba}, {pos = 0, events = 0, fd = -1152717404, user_data = 0x0}, {pos = -704345472, events = 22056, fd = 2, user_data = 0x0}, {pos = -44896592, events = 22056, fd = -720495749, user_data = 0x5628fd59f430}, {pos = -720491760, events = 22056, fd = -44436341, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -1153211192, user_data = 0x7f76bb49c880 }, {pos = -1144832584, events = 32630, fd = -1821013712, user_data = 0x100007f00000002}, {pos = -1152683923, events = 32630, fd = 2, user_data = 0x5628fd59f430}, {pos = 255, events = 0, fd = 0, user_data = 0x2}, {pos = -1151394720, events = 32630, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 170996256, events = 1415662692, fd = 1735275343, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, 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 = -44453216, events = 22056, fd = 1080, user_data = 0x5628fd599c70}, {pos = -717039839, events = 22056, fd = 1024, user_data = 0x7f76bb4b58be}, {pos = -1151411744, events = 32630, fd = -1152773778, user_data = 0x100000400}, {pos = 7, events = 0, fd = -44457856, user_data = 0xc89cd660bd73ee00}, {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 = 0x5628fd599c70}, {pos = 1, events = 0, fd = -44458696, user_data = 0x3}, {pos = 0, events = 0, fd = 22692, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -44643672, user_data = 0x7f76bb4f3053 }, {pos = -44458696, events = 22056, fd = 1024, user_data = 0x7ffc93758938}, {pos = -716958699, events = 22056, fd = -704280944, user_data = 0x5628d542fed2 }, {pos = -44458896, events = 22056, fd = -44643952, user_data = 0x5628fd599c70}, {pos = -1152689986, events = 32630, fd = 0, user_data = 0x5628d5441b3c }, {pos = -44458896, events = 1, fd = -716956539, user_data = 0x5628fd56c990}, {pos = -1116475904, events = 3365721696, fd = 0, user_data = 0x7f76bb4a2ab1}, {pos = -1152772880, events = 32630, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -44896592, user_data = 0xc89cd660bd73ee00}, {pos = 0, events = 0, fd = -1116475904, user_data = 0xc}, {pos = -1116475904, events = 3365721696, fd = 0, user_data = 0x7f76bb45b239 }, {pos = 230, events = 0, fd = -721445351, user_data = 0x400000}, {pos = 0, events = 0, fd = -44896592, user_data = 0x5628d542fd66 }, {pos = -44810048, events = 22056, fd = -44643952, user_data = 0x5628fd5440c0}, {pos = 1, events = 0, fd = 0, user_data = 0x5628d53ee56b }, {pos = 12, events = 0, fd = -44467560, user_data = 0x5628fd597a78}, {pos = -704344064, events = 22056, fd = 296, user_data = 0x5628d4ffc633 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -721428994, events = 22056, fd = -707949456, user_data = 0x5628fd56d338}} [04:32:29.648] nevents = 1 [04:32:29.648] __func__ = "ServerLoop" [04:32:29.648] #28 0x00005628d5002bab in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5628fd52ad20) at ../src/backend/postmaster/postmaster.c:1377 [04:32:29.648] opt = [04:32:29.648] status = [04:32:29.648] userDoption = [04:32:29.648] listen_addr_saved = false [04:32:29.648] output_config_variable = [04:32:29.648] __func__ = "PostmasterMain" [04:32:29.648] #29 0x00005628d4e2e91f in main (argc=4, argv=0x5628fd52ad20) at ../src/backend/main/main.c:230 [04:32:29.648] do_check_root = [04:32:29.648] dispatch_option = [04:32:29.685] -e [04:32:29.685] [04:32:29.685] [04:32:29.748] dumping /tmp/cores/postgres-6-40772.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [04:32:29.998] [New LWP 40772] [04:32:29.998] [04:32:29.998] This GDB supports auto-downloading debuginfo from the following URLs: [04:32:29.998] [04:32:29.998] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [04:32:29.998] Debuginfod has been disabled. [04:32:29.998] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [04:32:30.102] [Thread debugging using libthread_db enabled] [04:32:30.102] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [04:32:30.102] Core was generated by `postgres: test: postgres db2 [local] SELECT '. [04:32:30.102] Program terminated with signal SIGABRT, Aborted. [04:32:30.102] #0 0x00007f051f8a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:30.162] [04:32:30.162] Thread 1 (Thread 0x7f0520032f00 (LWP 40772)): [04:32:30.162] #0 0x00007f051f8a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:30.162] No symbol table info available. [04:32:30.162] #1 0x00007f051f85afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:30.162] No symbol table info available. [04:32:30.162] #2 0x00007f051f845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:30.162] No symbol table info available. [04:32:30.162] #3 0x00007f051fa1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [04:32:30.162] No locals. [04:32:30.162] #4 0x00007f051fa2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [04:32:30.162] No locals. [04:32:30.162] #5 0x00007f051fa0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5605ff0cd8a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [04:32:30.162] bp = 140729980666288 [04:32:30.162] pc = [04:32:30.162] Opts = {FromUnrecoverableHandler = true, pc = 94583739878814, bp = 139659784195240} [04:32:30.162] #6 0x00005605fe378d9e in examine_self_contradictory_rels (root=root@entry=0x560600129578, rel=rel@entry=0x560600133268, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [04:32:30.162] lc__state = [04:32:30.162] rlist = [04:32:30.162] i = 7 [04:32:30.162] br = [04:32:30.162] expression = [04:32:30.162] or_rinfo = 0x7f0513d39d38 [04:32:30.162] ccxt = [04:32:30.162] delidx = 0x7f0513d3ce91 [04:32:30.162] arglst = [04:32:30.162] lc = [04:32:30.162] arg = [04:32:30.162] n = [04:32:30.162] restrictinfo = [04:32:30.162] ccwapper = {clausecxt = 0x7f0513d3ab28} [04:32:30.162] sec = {sopcinfo = {n_members = 38, opcies = 0x7f0513d3a2c8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7f0513d3a6d8, atop_set = 0x7f0513d38398}, ccfree = 0x7f0513d3ce60, vifree = 0x7f0513d3bd78} [04:32:30.162] __func__ = "examine_self_contradictory_rels" [04:32:30.162] #7 0x00005605fe378fad in examine_self_contradictory_rels_phase1 (root=root@entry=0x560600129578) at ../src/backend/optimizer/plan/contradictory.c:2608 [04:32:30.162] rel = 0x560600133268 [04:32:30.162] rti = 1 [04:32:30.162] rinfo = [04:32:30.162] #8 0x00005605fe343e3d in query_planner (root=root@entry=0x560600129578, qp_callback=qp_callback@entry=0x5605fe349283 , qp_extra=qp_extra@entry=0x7ffe4081c3b0) at ../src/backend/optimizer/plan/planmain.c:193 [04:32:30.162] parse = 0x56060011fd70 [04:32:30.162] joinlist = 0x7f0513d38528 [04:32:30.162] final_rel = [04:32:30.162] __func__ = "query_planner" [04:32:30.162] #9 0x00005605fe3569e2 in grouping_planner (root=root@entry=0x560600129578, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [04:32:30.162] sort_input_targets = 0x560600129578 [04:32:30.162] sort_input_target_parallel_safe = [04:32:30.162] grouping_target = [04:32:30.162] scanjoin_target = [04:32:30.162] activeWindows = 0x0 [04:32:30.162] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [04:32:30.162] sort_input_targets_contain_srfs = 0x560600126d70 [04:32:30.162] have_grouping = [04:32:30.162] wflists = 0x0 [04:32:30.162] gset_data = 0x0 [04:32:30.162] sort_input_target = [04:32:30.162] grouping_targets = 0x560600126db8 [04:32:30.162] grouping_target_parallel_safe = [04:32:30.162] scanjoin_targets = 0x560600126da0 [04:32:30.162] scanjoin_target_parallel_safe = [04:32:30.162] grouping_targets_contain_srfs = 0x560600129578 [04:32:30.162] scanjoin_targets_contain_srfs = 0x0 [04:32:30.162] scanjoin_target_same_exprs = [04:32:30.162] parse = 0x56060011fd70 [04:32:30.162] offset_est = 0 [04:32:30.162] count_est = 0 [04:32:30.162] limit_tuples = -1 [04:32:30.162] have_postponed_srfs = false [04:32:30.162] final_target = [04:32:30.162] final_targets = 0x560600129578 [04:32:30.162] final_targets_contain_srfs = 0x7 [04:32:30.162] final_target_parallel_safe = [04:32:30.162] current_rel = [04:32:30.162] final_rel = [04:32:30.162] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94583770971504} [04:32:30.162] lc = [04:32:30.162] __func__ = "grouping_planner" [04:32:30.162] #10 0x00005605fe359966 in subquery_planner (glob=, parse=0x56060011fd70, parent_root=parent_root@entry=0x56060011cf30, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [04:32:30.162] root = 0x560600129578 [04:32:30.162] newWithCheckOptions = [04:32:30.162] newHaving = 0x0 [04:32:30.162] hasOuterJoins = [04:32:30.162] hasResultRTEs = true [04:32:30.162] final_rel = [04:32:30.162] l = 0x0 [04:32:30.162] #11 0x00005605fe36b300 in SS_process_ctes (root=root@entry=0x56060011cf30) at ../src/backend/optimizer/plan/subselect.c:966 [04:32:30.162] subquery = [04:32:30.162] cte = 0x5606000e2300 [04:32:30.162] cmdType = [04:32:30.162] subroot = [04:32:30.162] final_rel = [04:32:30.162] best_path = [04:32:30.162] plan = [04:32:30.162] splan = [04:32:30.162] paramid = [04:32:30.162] lc__state = [04:32:30.162] lc = [04:32:30.162] __func__ = "SS_process_ctes" [04:32:30.162] #12 0x00005605fe35840a in subquery_planner (glob=glob@entry=0x5606000f6d38, parse=parse@entry=0x5606000f6e48, 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 [04:32:30.162] root = 0x56060011cf30 [04:32:30.162] newWithCheckOptions = [04:32:30.162] newHaving = [04:32:30.162] hasOuterJoins = [04:32:30.162] hasResultRTEs = [04:32:30.162] final_rel = [04:32:30.162] l = [04:32:30.162] #13 0x00005605fe35a5f7 in standard_planner (parse=0x5606000f6e48, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [04:32:30.162] result = [04:32:30.162] glob = 0x5606000f6d38 [04:32:30.162] tuple_fraction = 0 [04:32:30.162] root = [04:32:30.162] final_rel = [04:32:30.162] best_path = [04:32:30.162] top_plan = [04:32:30.162] lp = [04:32:30.162] lr = [04:32:30.162] #14 0x00005605fe35b661 in planner (parse=parse@entry=0x5606000f6e48, query_string=query_string@entry=0x5606000045c0 "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 [04:32:30.162] result = [04:32:30.162] #15 0x00005605fe5cb3b5 in pg_plan_query (querytree=querytree@entry=0x5606000f6e48, query_string=query_string@entry=0x5606000045c0 "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 [04:32:30.162] plan = [04:32:30.162] #16 0x00005605fe5cb796 in pg_plan_queries (querytrees=0x56060011cee0, query_string=query_string@entry=0x5606000045c0 "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 [04:32:30.162] query = 0x5606000f6e48 [04:32:30.162] stmt = [04:32:30.162] query_list__state = [04:32:30.162] stmt_list = 0x0 [04:32:30.162] query_list = [04:32:30.162] #17 0x00005605fe5cbd43 in exec_simple_query (query_string=query_string@entry=0x5606000045c0 "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 [04:32:30.162] cmdtaglen = 6 [04:32:30.162] snapshot_set = true [04:32:30.162] per_parsetree_context = 0x0 [04:32:30.162] plantree_list = [04:32:30.162] parsetree = 0x5606000f6cb8 [04:32:30.162] commandTag = CMDTAG_SELECT [04:32:30.162] qc = {commandTag = 1935, nprocessed = 94583769810368} [04:32:30.162] querytree_list = [04:32:30.162] portal = [04:32:30.162] receiver = [04:32:30.162] format = 0 [04:32:30.162] cmdtagname = [04:32:30.162] parsetree_item__state = [04:32:30.162] dest = DestRemote [04:32:30.162] oldcontext = 0x560600094d30 [04:32:30.162] parsetree_list = 0x5606000f6ce8 [04:32:30.162] parsetree_item = 0x5606000f6d00 [04:32:30.162] save_log_statement_stats = false [04:32:30.162] was_logged = true [04:32:30.162] use_implicit_block = false [04:32:30.162] msec_str = "\004\000\000\000\000\000\000\000/\272\210\376\005V\000\000\200ǁ@\376\177\000\000\217\a\000\000\000\000\000" [04:32:30.162] __func__ = "exec_simple_query" [04:32:30.162] #18 0x00005605fe5cebda in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [04:32:30.162] query_string = 0x5606000045c0 "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 "... [04:32:30.162] firstchar = [04:32:30.162] input_message = {data = 0x5606000045c0 "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} [04:32:30.162] local_sigjmp_buf = {{__jmpbuf = {94583758079704, 4076850648576884211, 140729980668156, 4, 1, 140729980668388, 7738483273977757171, 4076848601055559155}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94583769538032, 16128, 94583758073760, 94583770048384, 1, 94583745322526, 0, 9, 2, 94583758079712, 94583769538032, 94583758073760, 4, 1, 140729980668388}}}} [04:32:30.162] send_ready_for_query = false [04:32:30.162] idle_in_transaction_timeout_enabled = false [04:32:30.162] idle_session_timeout_enabled = false [04:32:30.162] __func__ = "PostgresMain" [04:32:30.162] #19 0x00005605fe5c4c45 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:32:30.162] bsdata = [04:32:30.162] #20 0x00005605fe47611c in postmaster_child_launch (child_type=B_BACKEND, child_slot=1, startup_data=startup_data@entry=0x7ffe4081c8fc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe4081c950) at ../src/backend/postmaster/launch_backend.c:274 [04:32:30.162] pid = [04:32:30.162] #21 0x00005605fe47b328 in BackendStartup (client_sock=client_sock@entry=0x7ffe4081c950) at ../src/backend/postmaster/postmaster.c:3466 [04:32:30.162] bn = 0x56060002c298 [04:32:30.162] pid = [04:32:30.162] startup_data = {canAcceptConnections = CAC_OK} [04:32:30.162] cac = [04:32:30.162] __func__ = "BackendStartup" [04:32:30.162] #22 0x00005605fe47d34c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [04:32:30.162] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\203\037\005\177\000\000\240\357\327 \005\177\000\000\370Ɂ@\376\177\000\000\364Ɂ@\376\177", '\000' , "\222f_\375\005V\000\000\320G[\375\005V\000\000\300ʁ@\376\177\000\000\270ʁ@\376\177\000\000\225[\362\001\000\000\000\000\240\224\003 \005\177\000\000+", '\000' , "\005V\000\000\240e_\375\005V\000", __ss_align = 139660006815336}, salen = 2}} [04:32:30.162] i = 0 [04:32:30.162] now = [04:32:30.162] last_lockfile_recheck_time = 1736656117 [04:32:30.162] last_touch_time = 1736656117 [04:32:30.162] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x5605fd5f6692}, {pos = 555251304, events = 32517, fd = 537105968, user_data = 0x7f05211872e0}, {pos = 2090263927, events = 0, fd = 1082248000, user_data = 0x7f052115da48}, {pos = 15, events = 0, fd = 537105968, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f05211872e0}, {pos = 1082247864, events = 32766, fd = 1082247872, user_data = 0x7f0521187668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = 23168, events = 22022, fd = 1, user_data = 0x7ffe4081cfe3}, {pos = -1, events = 0, fd = 528670752, user_data = 0x7f0520d7efa0}, {pos = 201384, events = 22022, fd = 201096, user_data = 0x560600030f61}, {pos = 555105982, events = 32517, fd = 1, user_data = 0x7f05211872e0}, {pos = 426, events = 0, fd = -18801328, user_data = 0x0}, {pos = 229, events = 0, fd = 23104, user_data = 0x7f0521163ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f051f82e020}, {pos = 529477184, events = 32517, fd = 16, user_data = 0x7ffe4081cf10}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 555114938, events = 32517, fd = 0, user_data = 0x7f051f8aeda4 }, {pos = 0, events = 0, fd = -11777408, user_data = 0x2}, {pos = 0, events = 0, fd = -237936, user_data = 0x5605fe562749 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = 23104, user_data = 0x7f0521163ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f051f8364c8}, {pos = 529231981, events = 32517, fd = -11721280, user_data = 0x560600036740}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 530521184, events = 32517, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 909273419, user_data = 0x362020200a0a6749}, {pos = 1882153332, events = 1952539751, fd = 925960801, user_data = 0x2f6b636568635f33}, {pos = 1635017060, events = 811562031, fd = 1684826485, user_data = 0x72747365742f646c}, {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 = 1024, user_data = 0x7f051f8b58be}, {pos = 530504160, events = 32517, fd = 529142126, user_data = 0x100000400}, {pos = 7, events = 0, fd = 201616, user_data = 0x6a0fb7de62e0bf00}, {pos = 530507232, events = 32517, fd = -328, user_data = 0x0}, {pos = 200776, events = 22022, 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 = 40142, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 23104, user_data = 0x7f051f8f3053 }, {pos = 200776, events = 22022, fd = 1024, user_data = 0x7ffe4081cfd8}, {pos = -24390635, events = 22021, fd = -11712880, user_data = 0x5605fe8abed2 }, {pos = 200576, events = 22022, fd = 15520, user_data = 0x560600030f80}, {pos = 529225918, events = 32517, fd = 0, user_data = 0x5605fe8bdb3c }, {pos = 200576, events = 1, fd = -24388475, user_data = 0x560600003ca0}, {pos = 1658896128, events = 1779415006, fd = 0, user_data = 0x7f051f8a2ab1}, {pos = 529143024, events = 32517, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -237936, user_data = 0x6a0fb7de62e0bf00}, {pos = 0, events = 0, fd = 1658896128, user_data = 0xc}, {pos = 1658896128, events = 1779415006, fd = 0, user_data = 0x7f051f85b239 }, {pos = 230, events = 0, fd = -28877287, user_data = 0x400000}, {pos = 0, events = 0, fd = -237936, user_data = 0x5605fe8abd66 }, {pos = -150576, events = 22021, fd = 15520, user_data = 0x5605fffdb3d0}, {pos = 1, events = 0, fd = 0, user_data = 0x5605fe86a56b }, {pos = 12, events = 0, fd = 191912, user_data = 0x56060002ed88}, {pos = -11776000, events = 22021, fd = 296, user_data = 0x5605fe478633 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -28860930, events = 22021, fd = -15381392, user_data = 0x560600004658}} [04:32:30.162] nevents = 1 [04:32:30.162] __func__ = "ServerLoop" [04:32:30.162] #23 0x00005605fe47ebab in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5605fffc1d00) at ../src/backend/postmaster/postmaster.c:1377 [04:32:30.162] opt = [04:32:30.162] status = [04:32:30.162] userDoption = [04:32:30.162] listen_addr_saved = false [04:32:30.162] output_config_variable = [04:32:30.162] __func__ = "PostmasterMain" [04:32:30.162] #24 0x00005605fe2aa91f in main (argc=4, argv=0x5605fffc1d00) at ../src/backend/main/main.c:230 [04:32:30.162] do_check_root = [04:32:30.162] dispatch_option = [04:32:30.181] -e [04:32:30.181] [04:32:30.181] [04:32:30.245] dumping /tmp/cores/postgres-6-24648.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [04:32:30.499] [New LWP 24648] [04:32:30.499] [04:32:30.499] This GDB supports auto-downloading debuginfo from the following URLs: [04:32:30.499] [04:32:30.499] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [04:32:30.499] Debuginfod has been disabled. [04:32:30.499] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [04:32:30.611] [Thread debugging using libthread_db enabled] [04:32:30.611] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [04:32:30.611] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [04:32:30.611] Program terminated with signal SIGABRT, Aborted. [04:32:30.611] #0 0x00007f97deea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:31.611] [04:32:31.611] Thread 1 (Thread 0x7f97dedd5f00 (LWP 24648)): [04:32:31.611] #0 0x00007f97deea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:31.611] No symbol table info available. [04:32:31.611] #1 0x00007f97dee5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:31.611] No symbol table info available. [04:32:31.611] #2 0x00007f97dee45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:31.611] No symbol table info available. [04:32:31.611] #3 0x00007f97df01e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [04:32:31.611] No locals. [04:32:31.611] #4 0x00007f97df02aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [04:32:31.611] No locals. [04:32:31.611] #5 0x00007f97df00dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5624423398a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [04:32:31.611] bp = 140723196498624 [04:32:31.611] pc = [04:32:31.611] Opts = {FromUnrecoverableHandler = true, pc = 94713715510686, bp = 94714626667104} [04:32:31.611] #6 0x00005624415e4d9e in examine_self_contradictory_rels (root=root@entry=0x562477ad47d8, rel=rel@entry=0x562477ac15f8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [04:32:31.611] lc__state = [04:32:31.611] rlist = [04:32:31.611] i = 2 [04:32:31.611] br = [04:32:31.611] expression = [04:32:31.611] or_rinfo = 0x562477ad8170 [04:32:31.611] ccxt = [04:32:31.611] delidx = 0x562477ad7e69 [04:32:31.611] arglst = [04:32:31.611] lc = [04:32:31.611] arg = [04:32:31.611] n = [04:32:31.611] restrictinfo = [04:32:31.611] ccwapper = {clausecxt = 0x562477ad77e0} [04:32:31.611] sec = {sopcinfo = {n_members = 38, opcies = 0x562477ad72b0}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x562477ad6e50, atop_set = 0x562477ad76c0}, ccfree = 0x562477ad7de8, vifree = 0x562477ad7880} [04:32:31.611] __func__ = "examine_self_contradictory_rels" [04:32:31.611] #7 0x00005624415e4fad in examine_self_contradictory_rels_phase1 (root=root@entry=0x562477ad47d8) at ../src/backend/optimizer/plan/contradictory.c:2608 [04:32:31.611] rel = 0x562477ac15f8 [04:32:31.611] rti = 1 [04:32:31.611] rinfo = [04:32:31.611] #8 0x00005624415afe3d in query_planner (root=root@entry=0x562477ad47d8, qp_callback=qp_callback@entry=0x5624415b5283 , qp_extra=qp_extra@entry=0x7ffcac2394c0) at ../src/backend/optimizer/plan/planmain.c:193 [04:32:31.611] parse = 0x562477880f90 [04:32:31.611] joinlist = 0x562477ad6ec0 [04:32:31.611] final_rel = [04:32:31.611] __func__ = "query_planner" [04:32:31.611] #9 0x00005624415c29e2 in grouping_planner (root=root@entry=0x562477ad47d8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [04:32:31.611] sort_input_targets = 0x5 [04:32:31.611] sort_input_target_parallel_safe = [04:32:31.611] grouping_target = [04:32:31.611] scanjoin_target = [04:32:31.611] activeWindows = 0x0 [04:32:31.611] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [04:32:31.611] sort_input_targets_contain_srfs = 0x1 [04:32:31.611] have_grouping = [04:32:31.611] wflists = 0x0 [04:32:31.611] gset_data = 0x0 [04:32:31.611] sort_input_target = [04:32:31.611] grouping_targets = 0x1 [04:32:31.611] grouping_target_parallel_safe = [04:32:31.611] scanjoin_targets = 0x0 [04:32:31.611] scanjoin_target_parallel_safe = [04:32:31.611] grouping_targets_contain_srfs = 0x1 [04:32:31.611] scanjoin_targets_contain_srfs = 0x562441b2b2ec [04:32:31.611] scanjoin_target_same_exprs = [04:32:31.611] parse = 0x562477880f90 [04:32:31.611] offset_est = 0 [04:32:31.611] count_est = 0 [04:32:31.611] limit_tuples = -1 [04:32:31.611] have_postponed_srfs = false [04:32:31.611] final_target = [04:32:31.611] final_targets = 0x562477abf3a8 [04:32:31.611] final_targets_contain_srfs = 0x5624415208b7 [04:32:31.611] final_target_parallel_safe = [04:32:31.611] current_rel = [04:32:31.611] final_rel = [04:32:31.611] extra = {limit_needed = false, limit_tuples = 4.6794792614892796e-310, count_est = 94714626659544, offset_est = 94714626659544} [04:32:31.611] lc = [04:32:31.611] __func__ = "grouping_planner" [04:32:31.611] #10 0x00005624415c5966 in subquery_planner (glob=glob@entry=0x562477abffc8, parse=parse@entry=0x562477880f90, 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 [04:32:31.611] root = 0x562477ad47d8 [04:32:31.611] newWithCheckOptions = [04:32:31.611] newHaving = 0x0 [04:32:31.611] hasOuterJoins = [04:32:31.611] hasResultRTEs = false [04:32:31.611] final_rel = [04:32:31.611] l = 0x0 [04:32:31.611] #11 0x00005624415c65f7 in standard_planner (parse=0x562477880f90, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [04:32:31.611] result = [04:32:31.611] glob = 0x562477abffc8 [04:32:31.611] tuple_fraction = 0 [04:32:31.611] root = [04:32:31.611] final_rel = [04:32:31.611] best_path = [04:32:31.611] top_plan = [04:32:31.611] lp = [04:32:31.611] lr = [04:32:31.611] #12 0x00005624415c7661 in planner (parse=parse@entry=0x562477880f90, query_string=query_string@entry=0x56247787fb10 "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 [04:32:31.611] result = [04:32:31.611] #13 0x00005624418373b5 in pg_plan_query (querytree=querytree@entry=0x562477880f90, query_string=query_string@entry=0x56247787fb10 "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 [04:32:31.611] plan = [04:32:31.611] #14 0x0000562441336843 in standard_ExplainOneQuery (query=0x562477880f90, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x562477abfd28, queryString=0x56247787fb10 "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 [04:32:31.611] plan = [04:32:31.611] planstart = [04:32:31.611] planduration = {ticks = 94713714684375} [04:32:31.611] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94713720954850, shared_blks_dirtied = 2888013742, shared_blks_written = 3, local_blks_hit = 4294967440, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94714624216976, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94713721041644}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94713714681756}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94714624216976}} [04:32:31.611] bufusage = {shared_blks_hit = 0, shared_blks_read = 94713717710174, shared_blks_dirtied = 133341554688000, shared_blks_written = 72057594037927936, local_blks_hit = 140290058482680, local_blks_read = 94714624218152, local_blks_dirtied = 94714624216976, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94713720569369, shared_blk_read_time = {ticks = 140290058482680}, shared_blk_write_time = {ticks = 94713720569388}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94713720950433}, temp_blk_read_time = {ticks = 94714626295488}, temp_blk_write_time = {ticks = 64}} [04:32:31.611] mem_counters = {nblocks = 94714626577752, freechunks = 4294967297, totalspace = 140723196499760, freespace = 10} [04:32:31.611] planner_ctx = 0x0 [04:32:31.611] saved_ctx = 0x0 [04:32:31.611] #15 0x0000562441336b29 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x562477abfd28, pstate=pstate@entry=0x562477a7c978, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [04:32:31.611] No locals. [04:32:31.611] #16 0x0000562441337a80 in ExplainQuery (pstate=pstate@entry=0x562477a7c978, stmt=stmt@entry=0x562477880dd0, params=params@entry=0x0, dest=dest@entry=0x562477a7c8e8) at ../src/backend/commands/explain.c:357 [04:32:31.611] l__state = [04:32:31.611] l = 0x562477ac15c0 [04:32:31.611] es = 0x562477abfd28 [04:32:31.611] tstate = [04:32:31.611] jstate = [04:32:31.611] query = [04:32:31.611] rewritten = 0x562477ac15a8 [04:32:31.611] lc = 0x0 [04:32:31.611] timing_set = false [04:32:31.611] buffers_set = false [04:32:31.611] summary_set = false [04:32:31.611] __func__ = "ExplainQuery" [04:32:31.611] #17 0x0000562441841dd5 in standard_ProcessUtility (pstmt=0x562477880e80, queryString=0x56247787fb10 "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=0x562477a7c8e8, qc=0x7ffcac2399b0) at ../src/backend/tcop/utility.c:866 [04:32:31.611] parsetree = 0x562477880dd0 [04:32:31.611] isTopLevel = true [04:32:31.611] isAtomicContext = false [04:32:31.611] pstate = 0x562477a7c978 [04:32:31.611] readonly_flags = [04:32:31.611] __func__ = "standard_ProcessUtility" [04:32:31.611] #18 0x00005624418424fe in ProcessUtility (pstmt=pstmt@entry=0x562477880e80, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x562477a7c8e8, qc=0x7ffcac2399b0) at ../src/backend/tcop/utility.c:523 [04:32:31.611] No locals. [04:32:31.611] #19 0x000056244183debc in PortalRunUtility (portal=portal@entry=0x562477905020, pstmt=0x562477880e80, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x562477a7c8e8, qc=qc@entry=0x7ffcac2399b0) at ../src/backend/tcop/pquery.c:1152 [04:32:31.611] No locals. [04:32:31.611] #20 0x000056244183e72f in FillPortalStore (portal=portal@entry=0x562477905020, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [04:32:31.611] treceiver = 0x562477a7c8e8 [04:32:31.611] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:32:31.611] __func__ = "FillPortalStore" [04:32:31.611] #21 0x000056244183ec4a in PortalRun (portal=portal@entry=0x562477905020, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x562477abf688, altdest=altdest@entry=0x562477abf688, qc=qc@entry=0x7ffcac239b70) at ../src/backend/tcop/pquery.c:759 [04:32:31.611] _save_exception_stack = 0x7ffcac239c20 [04:32:31.611] _save_context_stack = 0x0 [04:32:31.611] _local_sigjmp_buf = {{__jmpbuf = {0, 6057641189367933613, 94714624757792, 94714624216648, 94714624216624, 94714624216576, 549623331257379501, 6057760142598793901}, __mask_was_saved = 0, __saved_mask = {__val = {94713720954850, 2888014591, 4, 94714624216576, 112, 153, 94714624757792, 94714624216648, 94714624216624, 94714624216576, 94713721042053, 1, 2, 153, 94713710287263, 0}}}} [04:32:31.611] _do_rethrow = [04:32:31.611] result = [04:32:31.611] nprocessed = [04:32:31.611] saveTopTransactionResourceOwner = 0x5624778c2e78 [04:32:31.611] saveTopTransactionContext = 0x562477917450 [04:32:31.611] saveActivePortal = 0x0 [04:32:31.611] saveResourceOwner = 0x5624778c2e78 [04:32:31.611] savePortalContext = 0x0 [04:32:31.611] saveMemoryContext = 0x562477917450 [04:32:31.611] __func__ = "PortalRun" [04:32:31.611] #22 0x0000562441837e81 in exec_simple_query (query_string=query_string@entry=0x56247787fb10 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');") at ../src/backend/tcop/postgres.c:1271 [04:32:31.611] cmdtaglen = 7 [04:32:31.611] snapshot_set = [04:32:31.611] per_parsetree_context = 0x0 [04:32:31.611] plantree_list = 0x562477abf638 [04:32:31.611] parsetree = 0x562477880e00 [04:32:31.611] commandTag = [04:32:31.611] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:32:31.611] querytree_list = [04:32:31.611] portal = 0x562477905020 [04:32:31.611] receiver = 0x562477abf688 [04:32:31.611] format = 0 [04:32:31.611] cmdtagname = [04:32:31.611] parsetree_item__state = [04:32:31.611] dest = DestRemote [04:32:31.611] oldcontext = 0x562477917450 [04:32:31.611] parsetree_list = 0x562477880e30 [04:32:31.611] parsetree_item = 0x562477880e48 [04:32:31.611] save_log_statement_stats = false [04:32:31.611] was_logged = false [04:32:31.611] use_implicit_block = false [04:32:31.611] msec_str = "\004\000\000\000\000\000\000\000/z\257A$V\000\000\000\234#\254\374\177\000\000S\000\000\000\000\000\000" [04:32:31.611] __func__ = "exec_simple_query" [04:32:31.611] #23 0x000056244183abda in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [04:32:31.611] query_string = 0x56247787fb10 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');" [04:32:31.611] firstchar = [04:32:31.611] input_message = {data = 0x56247787fb10 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", len = 83, maxlen = 1024, cursor = 83} [04:32:31.611] local_sigjmp_buf = {{__jmpbuf = {94713733711576, 6057758414608329389, 140723196501372, 4, 14, 140723196501604, 549623331324488365, 6057760144569461421}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94714623942192, 17408, 94713733705632, 94714624476560, 14, 94713720954398, 0, 10, 2, 94713733711584, 94714623942192, 94713733705632, 4, 14, 140723196501604}}}} [04:32:31.611] send_ready_for_query = false [04:32:31.611] idle_in_transaction_timeout_enabled = false [04:32:31.611] idle_session_timeout_enabled = false [04:32:31.611] __func__ = "PostgresMain" [04:32:31.611] #24 0x0000562441830c45 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:32:31.611] bsdata = [04:32:31.611] #25 0x00005624416e211c in postmaster_child_launch (child_type=B_BACKEND, child_slot=14, startup_data=startup_data@entry=0x7ffcac239d7c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcac239dd0) at ../src/backend/postmaster/launch_backend.c:274 [04:32:31.611] pid = [04:32:31.611] #26 0x00005624416e7328 in BackendStartup (client_sock=client_sock@entry=0x7ffcac239dd0) at ../src/backend/postmaster/postmaster.c:3466 [04:32:31.611] bn = 0x5624778a82f8 [04:32:31.611] pid = [04:32:31.611] startup_data = {canAcceptConnections = CAC_OK} [04:32:31.611] cac = [04:32:31.611] __func__ = "BackendStartup" [04:32:31.611] #27 0x00005624416e934c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [04:32:31.611] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\343ޗ\177\000\000\240\0378\340\227\177\000\000x\236#\254\374\177\000\000t\236#\254\374\177", '\000' , "\222&\206@$V\000\000\320\a\202@$V\000\000@\237#\254\374\177\000\0008\237#\254\374\177\000\000\225[\362\001\000\000\000\000\240\264cߗ\177\000\000+", '\000' , "$V\000\000\240%\206@$V\000", __ss_align = 140290282792552}, salen = 2}} [04:32:31.611] i = 0 [04:32:31.611] now = [04:32:31.611] last_lockfile_recheck_time = 1736656041 [04:32:31.611] last_touch_time = 1736656041 [04:32:31.611] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x562440862692}, {pos = -528963992, events = 32663, fd = -547113424, user_data = 0x7f97e078a2e0}, {pos = 2090263927, events = 0, fd = -1406951488, user_data = 0x7f97e0760a48}, {pos = 15, events = 0, fd = -547113424, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f97e078a2e0}, {pos = -1406951624, events = 32764, fd = -1406951616, user_data = 0x7f97e078a668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 2005407744, events = 22052, fd = 1, user_data = 0x7ffcac23a463}, {pos = -1, events = 0, fd = -555556832, user_data = 0x7f97e0381fa0}, {pos = 2005587032, events = 22052, fd = 2005586744, user_data = 0x5624778ad111}, {pos = -529109314, events = 32663, fd = 1, user_data = 0x7f97e078a2e0}, {pos = 426, events = 0, fd = 1107811664, user_data = 0x0}, {pos = 249, events = 0, fd = 2005400528, user_data = 0x7f97e0766ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f97dee2e020}, {pos = -554750400, events = 32663, fd = 16, user_data = 0x7ffcac23a390}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -529100358, events = 32663, fd = 0, user_data = 0x7f97deeaeda4 }, {pos = 0, events = 0, fd = 1114835584, user_data = 0x2}, {pos = 0, events = 0, fd = 2005147344, user_data = 0x5624417ce749 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 2005400528, user_data = 0x7f97e0766ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f97dee364c8}, {pos = -554995603, events = 32663, fd = 1114891712, user_data = 0x5624778b2530}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = -553706400, events = 32663, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x352020200a0a3249}, {pos = 822763892, events = 909521719, fd = 875574837, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1024, user_data = 0x7f97deeb58be}, {pos = -553723424, events = 32663, fd = -555085458, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2005587264, user_data = 0xa4af8daaf90cfe00}, {pos = -553720352, events = 32663, fd = -328, user_data = 0x0}, {pos = 2005586424, events = 22052, 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 = 22087, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 2005400528, user_data = 0x7f97deef3053 }, {pos = 2005586424, events = 22052, fd = 1024, user_data = 0x7ffcac23a458}, {pos = 1102222357, events = 22052, fd = 1114900112, user_data = 0x562441b17ed2 }, {pos = 2005586224, events = 22052, fd = 2005400080, user_data = 0x5624778ad130}, {pos = -555001666, events = 32663, fd = 0, user_data = 0x562441b29b3c }, {pos = 2005586224, events = 1, fd = 1102224517, user_data = 0x56247787fa10}, {pos = -116589056, events = 2762968490, fd = 0, user_data = 0x7f97deea2ab1}, {pos = -555084560, events = 32663, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2005147344, user_data = 0xa4af8daaf90cfe00}, {pos = 0, events = 0, fd = -116589056, user_data = 0xc}, {pos = -116589056, events = 2762968490, fd = 0, user_data = 0x7f97dee5b239 }, {pos = 250, events = 0, fd = 1097735705, user_data = 0x400000}, {pos = 0, events = 0, fd = 2005147344, user_data = 0x562441b17d66 }, {pos = 2005233984, events = 22052, fd = 2005400080, user_data = 0x562477857140}, {pos = 1, events = 0, fd = 0, user_data = 0x562441ad656b }, {pos = 12, events = 0, fd = 2005577560, user_data = 0x5624778aaf38}, {pos = 1114836992, events = 22052, fd = 296, user_data = 0x5624416e4633 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1097752062, events = 22052, fd = 1111231600, user_data = 0x5624778803e8}} [04:32:31.611] nevents = 1 [04:32:31.611] __func__ = "ServerLoop" [04:32:31.611] #28 0x00005624416eabab in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x56247783dd90) at ../src/backend/postmaster/postmaster.c:1377 [04:32:31.611] opt = [04:32:31.611] status = [04:32:31.611] userDoption = [04:32:31.611] listen_addr_saved = false [04:32:31.611] output_config_variable = [04:32:31.611] __func__ = "PostmasterMain" [04:32:31.611] #29 0x000056244151691f in main (argc=8, argv=0x56247783dd90) at ../src/backend/main/main.c:230 [04:32:31.611] do_check_root = [04:32:31.611] dispatch_option = [04:32:31.647] -e [04:32:31.647] [04:32:31.647] [04:32:31.709] dumping /tmp/cores/postgres-6-28640.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [04:32:31.958] [New LWP 28640] [04:32:31.958] [04:32:31.958] This GDB supports auto-downloading debuginfo from the following URLs: [04:32:31.958] [04:32:31.958] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [04:32:31.958] Debuginfod has been disabled. [04:32:31.958] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [04:32:32.061] [Thread debugging using libthread_db enabled] [04:32:32.061] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [04:32:32.061] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [04:32:32.061] Program terminated with signal SIGABRT, Aborted. [04:32:32.061] #0 0x00007f97deea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:33.040] [04:32:33.040] Thread 1 (Thread 0x7f97dedd5f00 (LWP 28640)): [04:32:33.040] #0 0x00007f97deea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:33.040] No symbol table info available. [04:32:33.040] #1 0x00007f97dee5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:33.040] No symbol table info available. [04:32:33.040] #2 0x00007f97dee45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [04:32:33.040] No symbol table info available. [04:32:33.040] #3 0x00007f97df01e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [04:32:33.040] No locals. [04:32:33.040] #4 0x00007f97df02aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [04:32:33.040] No locals. [04:32:33.040] #5 0x00007f97df00dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5624423398a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [04:32:33.040] bp = 140723196498624 [04:32:33.040] pc = [04:32:33.040] Opts = {FromUnrecoverableHandler = true, pc = 94713715510686, bp = 94714624629528} [04:32:33.040] #6 0x00005624415e4d9e in examine_self_contradictory_rels (root=root@entry=0x562477981de8, rel=rel@entry=0x5624779846a8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [04:32:33.040] lc__state = [04:32:33.040] rlist = [04:32:33.040] i = 2 [04:32:33.040] br = [04:32:33.040] expression = [04:32:33.040] or_rinfo = 0x5624778e66f8 [04:32:33.040] ccxt = [04:32:33.040] delidx = 0x5624778e6691 [04:32:33.040] arglst = [04:32:33.040] lc = [04:32:33.040] arg = [04:32:33.040] n = [04:32:33.040] restrictinfo = [04:32:33.040] ccwapper = {clausecxt = 0x5624778e5ff8} [04:32:33.040] sec = {sopcinfo = {n_members = 38, opcies = 0x5624778e5b68}, attrsdc = {min_attr = -6, max_attr = 5, len_set = 2, atop_array = 0x5624778e5258, atop_set = 0x5624778e53d8}, ccfree = 0x5624778e6660, vifree = 0x5624778e6200} [04:32:33.040] __func__ = "examine_self_contradictory_rels" [04:32:33.040] #7 0x00005624415e4fad in examine_self_contradictory_rels_phase1 (root=root@entry=0x562477981de8) at ../src/backend/optimizer/plan/contradictory.c:2608 [04:32:33.040] rel = 0x5624779846a8 [04:32:33.040] rti = 1 [04:32:33.040] rinfo = [04:32:33.040] #8 0x00005624415afe3d in query_planner (root=root@entry=0x562477981de8, qp_callback=qp_callback@entry=0x5624415b5283 , qp_extra=qp_extra@entry=0x7ffcac2394c0) at ../src/backend/optimizer/plan/planmain.c:193 [04:32:33.040] parse = 0x562477881100 [04:32:33.040] joinlist = 0x5624778e5448 [04:32:33.040] final_rel = [04:32:33.040] __func__ = "query_planner" [04:32:33.040] #9 0x00005624415c29e2 in grouping_planner (root=root@entry=0x562477981de8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [04:32:33.040] sort_input_targets = 0x5 [04:32:33.040] sort_input_target_parallel_safe = [04:32:33.040] grouping_target = [04:32:33.040] scanjoin_target = [04:32:33.040] activeWindows = 0x0 [04:32:33.040] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [04:32:33.040] sort_input_targets_contain_srfs = 0x1 [04:32:33.040] have_grouping = [04:32:33.040] wflists = 0x0 [04:32:33.040] gset_data = 0x0 [04:32:33.040] sort_input_target = [04:32:33.040] grouping_targets = 0x1 [04:32:33.040] grouping_target_parallel_safe = [04:32:33.040] scanjoin_targets = 0x0 [04:32:33.040] scanjoin_target_parallel_safe = [04:32:33.040] grouping_targets_contain_srfs = 0x1 [04:32:33.040] scanjoin_targets_contain_srfs = 0x562441b2b2ec [04:32:33.040] scanjoin_target_same_exprs = [04:32:33.040] parse = 0x562477881100 [04:32:33.040] offset_est = 0 [04:32:33.040] count_est = 0 [04:32:33.040] limit_tuples = -1 [04:32:33.040] have_postponed_srfs = false [04:32:33.040] final_target = [04:32:33.040] final_targets = 0x562477969e68 [04:32:33.040] final_targets_contain_srfs = 0x5624415208b7 [04:32:33.040] final_target_parallel_safe = [04:32:33.040] current_rel = [04:32:33.040] final_rel = [04:32:33.040] extra = {limit_needed = false, limit_tuples = 4.6794792614892796e-310, count_est = 94714625272968, offset_est = 94714625272968} [04:32:33.040] lc = [04:32:33.040] __func__ = "grouping_planner" [04:32:33.040] #10 0x00005624415c5966 in subquery_planner (glob=glob@entry=0x562477984088, parse=parse@entry=0x562477881100, 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 [04:32:33.040] root = 0x562477981de8 [04:32:33.040] newWithCheckOptions = [04:32:33.040] newHaving = 0x0 [04:32:33.040] hasOuterJoins = [04:32:33.040] hasResultRTEs = false [04:32:33.040] final_rel = [04:32:33.040] l = 0x0 [04:32:33.040] #11 0x00005624415c65f7 in standard_planner (parse=0x562477881100, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [04:32:33.040] result = [04:32:33.040] glob = 0x562477984088 [04:32:33.040] tuple_fraction = 0 [04:32:33.040] root = [04:32:33.040] final_rel = [04:32:33.040] best_path = [04:32:33.040] top_plan = [04:32:33.040] lp = [04:32:33.040] lr = [04:32:33.040] #12 0x00005624415c7661 in planner (parse=parse@entry=0x562477881100, query_string=query_string@entry=0x56247787fb10 "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 [04:32:33.040] result = [04:32:33.040] #13 0x00005624418373b5 in pg_plan_query (querytree=querytree@entry=0x562477881100, query_string=query_string@entry=0x56247787fb10 "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 [04:32:33.040] plan = [04:32:33.040] #14 0x0000562441336843 in standard_ExplainOneQuery (query=0x562477881100, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x562477983de8, queryString=0x56247787fb10 "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 [04:32:33.040] plan = [04:32:33.040] planstart = [04:32:33.040] planduration = {ticks = 94713714684375} [04:32:33.040] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94713720954850, shared_blks_dirtied = 2888013742, shared_blks_written = 3, local_blks_hit = 4294967440, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94714624217344, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94713721041644}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94713714681756}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94714624217344}} [04:32:33.040] bufusage = {shared_blks_hit = 0, shared_blks_read = 94713717710174, shared_blks_dirtied = 228161547681792, shared_blks_written = 72057594037927936, local_blks_hit = 140290061031016, local_blks_read = 94714624218736, local_blks_dirtied = 94714624217344, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94713720569369, shared_blk_read_time = {ticks = 140290061031016}, shared_blk_write_time = {ticks = 94713720569388}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94713720950433}, temp_blk_read_time = {ticks = 94714625186240}, temp_blk_write_time = {ticks = 64}} [04:32:33.040] mem_counters = {nblocks = 94714625279496, freechunks = 4294967297, totalspace = 140723196499760, freespace = 10} [04:32:33.040] planner_ctx = 0x0 [04:32:33.040] saved_ctx = 0x0 [04:32:33.040] #15 0x0000562441336b29 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x562477983de8, pstate=pstate@entry=0x56247796dc78, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [04:32:33.040] No locals. [04:32:33.040] #16 0x0000562441337a80 in ExplainQuery (pstate=pstate@entry=0x56247796dc78, stmt=stmt@entry=0x562477880f40, params=params@entry=0x0, dest=dest@entry=0x56247796dbe8) at ../src/backend/commands/explain.c:357 [04:32:33.040] l__state = [04:32:33.040] l = 0x562477984670 [04:32:33.040] es = 0x562477983de8 [04:32:33.040] tstate = [04:32:33.040] jstate = [04:32:33.040] query = [04:32:33.040] rewritten = 0x562477984658 [04:32:33.040] lc = 0x0 [04:32:33.040] timing_set = false [04:32:33.040] buffers_set = false [04:32:33.040] summary_set = false [04:32:33.040] __func__ = "ExplainQuery" [04:32:33.040] #17 0x0000562441841dd5 in standard_ProcessUtility (pstmt=0x562477880ff0, queryString=0x56247787fb10 "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=0x56247796dbe8, qc=0x7ffcac2399b0) at ../src/backend/tcop/utility.c:866 [04:32:33.040] parsetree = 0x562477880f40 [04:32:33.040] isTopLevel = true [04:32:33.040] isAtomicContext = false [04:32:33.040] pstate = 0x56247796dc78 [04:32:33.040] readonly_flags = [04:32:33.040] __func__ = "standard_ProcessUtility" [04:32:33.040] #18 0x00005624418424fe in ProcessUtility (pstmt=pstmt@entry=0x562477880ff0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x56247796dbe8, qc=0x7ffcac2399b0) at ../src/backend/tcop/utility.c:523 [04:32:33.040] No locals. [04:32:33.040] #19 0x000056244183debc in PortalRunUtility (portal=portal@entry=0x56247790b030, pstmt=0x562477880ff0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x56247796dbe8, qc=qc@entry=0x7ffcac2399b0) at ../src/backend/tcop/pquery.c:1152 [04:32:33.040] No locals. [04:32:33.040] #20 0x000056244183e72f in FillPortalStore (portal=portal@entry=0x56247790b030, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [04:32:33.040] treceiver = 0x56247796dbe8 [04:32:33.040] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:32:33.040] __func__ = "FillPortalStore" [04:32:33.040] #21 0x000056244183ec4a in PortalRun (portal=portal@entry=0x56247790b030, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x56247796a148, altdest=altdest@entry=0x56247796a148, qc=qc@entry=0x7ffcac239b70) at ../src/backend/tcop/pquery.c:759 [04:32:33.040] _save_exception_stack = 0x7ffcac239c20 [04:32:33.040] _save_context_stack = 0x0 [04:32:33.040] _local_sigjmp_buf = {{__jmpbuf = {0, 6057641577617877677, 94714624782384, 94714624217016, 94714624216992, 94714624216944, 549623331257379501, 6057760142598793901}, __mask_was_saved = 0, __saved_mask = {__val = {94713720954850, 2888014591, 4, 94714624216944, 112, 153, 94714624782384, 94714624217016, 94714624216992, 94714624216944, 94713721042053, 1, 2, 153, 94713710287263, 0}}}} [04:32:33.040] _do_rethrow = [04:32:33.040] result = [04:32:33.040] nprocessed = [04:32:33.040] saveTopTransactionResourceOwner = 0x5624778c4678 [04:32:33.040] saveTopTransactionContext = 0x56247791d460 [04:32:33.040] saveActivePortal = 0x0 [04:32:33.040] saveResourceOwner = 0x5624778c4678 [04:32:33.040] savePortalContext = 0x0 [04:32:33.040] saveMemoryContext = 0x56247791d460 [04:32:33.040] __func__ = "PortalRun" [04:32:33.040] #22 0x0000562441837e81 in exec_simple_query (query_string=query_string@entry=0x56247787fb10 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;") at ../src/backend/tcop/postgres.c:1271 [04:32:33.040] cmdtaglen = 7 [04:32:33.040] snapshot_set = [04:32:33.040] per_parsetree_context = 0x0 [04:32:33.040] plantree_list = 0x56247796a0f8 [04:32:33.040] parsetree = 0x562477880f70 [04:32:33.040] commandTag = [04:32:33.040] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [04:32:33.040] querytree_list = [04:32:33.040] portal = 0x56247790b030 [04:32:33.040] receiver = 0x56247796a148 [04:32:33.040] format = 0 [04:32:33.040] cmdtagname = [04:32:33.040] parsetree_item__state = [04:32:33.040] dest = DestRemote [04:32:33.040] oldcontext = 0x56247791d460 [04:32:33.040] parsetree_list = 0x562477880fa0 [04:32:33.040] parsetree_item = 0x562477880fb8 [04:32:33.040] save_log_statement_stats = false [04:32:33.040] was_logged = false [04:32:33.040] use_implicit_block = false [04:32:33.040] msec_str = "\004\000\000\000\000\000\000\000/z\257A$V\000\000\000\234#\254\374\177\000\000J\000\000\000\000\000\000" [04:32:33.040] __func__ = "exec_simple_query" [04:32:33.040] #23 0x000056244183abda in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [04:32:33.040] query_string = 0x56247787fb10 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;" [04:32:33.040] firstchar = [04:32:33.040] input_message = {data = 0x56247787fb10 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", len = 74, maxlen = 1024, cursor = 74} [04:32:33.040] local_sigjmp_buf = {{__jmpbuf = {94713733711576, 6057758414608329389, 140723196501372, 4, 6, 140723196501604, 549623331324488365, 6057760144569461421}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94714623942192, 17408, 94713733705632, 94714624484768, 6, 94713720954398, 0, 10, 2, 94713733711584, 94714623942192, 94713733705632, 4, 6, 140723196501604}}}} [04:32:33.040] send_ready_for_query = false [04:32:33.040] idle_in_transaction_timeout_enabled = false [04:32:33.040] idle_session_timeout_enabled = false [04:32:33.040] __func__ = "PostgresMain" [04:32:33.040] #24 0x0000562441830c45 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [04:32:33.040] bsdata = [04:32:33.040] #25 0x00005624416e211c in postmaster_child_launch (child_type=B_BACKEND, child_slot=6, startup_data=startup_data@entry=0x7ffcac239d7c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcac239dd0) at ../src/backend/postmaster/launch_backend.c:274 [04:32:33.040] pid = [04:32:33.040] #26 0x00005624416e7328 in BackendStartup (client_sock=client_sock@entry=0x7ffcac239dd0) at ../src/backend/postmaster/postmaster.c:3466 [04:32:33.040] bn = 0x5624778a8178 [04:32:33.040] pid = [04:32:33.040] startup_data = {canAcceptConnections = CAC_OK} [04:32:33.040] cac = [04:32:33.040] __func__ = "BackendStartup" [04:32:33.040] #27 0x00005624416e934c in ServerLoop () at ../src/backend/postmaster/postmaster.c:1679 [04:32:33.040] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\343ޗ\177\000\000\240\0378\340\227\177\000\000x\236#\254\374\177\000\000t\236#\254\374\177", '\000' , "\222&\206@$V\000\000\320\a\202@$V\000\000@\237#\254\374\177\000\0008\237#\254\374\177\000\000\225[\362\001\000\000\000\000\240\264cߗ\177\000\000+", '\000' , "$V\000\000\240%\206@$V\000", __ss_align = 140290282792552}, salen = 2}} [04:32:33.040] i = 0 [04:32:33.040] now = [04:32:33.040] last_lockfile_recheck_time = 1736656041 [04:32:33.040] last_touch_time = 1736656041 [04:32:33.040] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x562440862692}, {pos = -528963992, events = 32663, fd = -547113424, user_data = 0x7f97e078a2e0}, {pos = 2090263927, events = 0, fd = -1406951488, user_data = 0x7f97e0760a48}, {pos = 15, events = 0, fd = -547113424, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f97e078a2e0}, {pos = -1406951624, events = 32764, fd = -1406951616, user_data = 0x7f97e078a668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 2005407744, events = 22052, fd = 1, user_data = 0x7ffcac23a463}, {pos = -1, events = 0, fd = -555556832, user_data = 0x7f97e0381fa0}, {pos = 2005587032, events = 22052, fd = 2005586744, user_data = 0x5624778ad111}, {pos = -529109314, events = 32663, fd = 1, user_data = 0x7f97e078a2e0}, {pos = 426, events = 0, fd = 1107811664, user_data = 0x0}, {pos = 249, events = 0, fd = 2005400528, user_data = 0x7f97e0766ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f97dee2e020}, {pos = -554750400, events = 32663, fd = 16, user_data = 0x7ffcac23a390}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -529100358, events = 32663, fd = 0, user_data = 0x7f97deeaeda4 }, {pos = 0, events = 0, fd = 1114835584, user_data = 0x2}, {pos = 0, events = 0, fd = 2005147344, user_data = 0x5624417ce749 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 2005400528, user_data = 0x7f97e0766ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f97dee364c8}, {pos = -554995603, events = 32663, fd = 1114891712, user_data = 0x5624778b2530}, {pos = 255, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = -553706400, events = 32663, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x352020200a0a3249}, {pos = 822763892, events = 909521719, fd = 875574837, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1024, user_data = 0x7f97deeb58be}, {pos = -553723424, events = 32663, fd = -555085458, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2005587264, user_data = 0xa4af8daaf90cfe00}, {pos = -553720352, events = 32663, fd = -328, user_data = 0x0}, {pos = 2005586424, events = 22052, 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 = 22087, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 2005400528, user_data = 0x7f97deef3053 }, {pos = 2005586424, events = 22052, fd = 1024, user_data = 0x7ffcac23a458}, {pos = 1102222357, events = 22052, fd = 1114900112, user_data = 0x562441b17ed2 }, {pos = 2005586224, events = 22052, fd = 2005400080, user_data = 0x5624778ad130}, {pos = -555001666, events = 32663, fd = 0, user_data = 0x562441b29b3c }, {pos = 2005586224, events = 1, fd = 1102224517, user_data = 0x56247787fa10}, {pos = -116589056, events = 2762968490, fd = 0, user_data = 0x7f97deea2ab1}, {pos = -555084560, events = 32663, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2005147344, user_data = 0xa4af8daaf90cfe00}, {pos = 0, events = 0, fd = -116589056, user_data = 0xc}, {pos = -116589056, events = 2762968490, fd = 0, user_data = 0x7f97dee5b239 }, {pos = 250, events = 0, fd = 1097735705, user_data = 0x400000}, {pos = 0, events = 0, fd = 2005147344, user_data = 0x562441b17d66 }, {pos = 2005233984, events = 22052, fd = 2005400080, user_data = 0x562477857140}, {pos = 1, events = 0, fd = 0, user_data = 0x562441ad656b }, {pos = 12, events = 0, fd = 2005577560, user_data = 0x5624778aaf38}, {pos = 1114836992, events = 22052, fd = 296, user_data = 0x5624416e4633 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1097752062, events = 22052, fd = 1111231600, user_data = 0x5624778803e8}} [04:32:33.040] nevents = 1 [04:32:33.040] __func__ = "ServerLoop" [04:32:33.040] #28 0x00005624416eabab in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x56247783dd90) at ../src/backend/postmaster/postmaster.c:1377 [04:32:33.040] opt = [04:32:33.040] status = [04:32:33.040] userDoption = [04:32:33.040] listen_addr_saved = false [04:32:33.040] output_config_variable = [04:32:33.040] __func__ = "PostmasterMain" [04:32:33.040] #29 0x000056244151691f in main (argc=8, argv=0x56247783dd90) at ../src/backend/main/main.c:230 [04:32:33.040] do_check_root = [04:32:33.040] dispatch_option =