[09:34:57.068] src/tools/ci/cores_backtrace.sh linux /tmp/cores [09:34:57.268] dumping /tmp/cores/postgres-6-27897.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:34:57.524] [New LWP 27897] [09:34:57.524] [09:34:57.524] This GDB supports auto-downloading debuginfo from the following URLs: [09:34:57.524] [09:34:57.524] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:34:57.524] Debuginfod has been disabled. [09:34:57.524] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:34:57.635] [Thread debugging using libthread_db enabled] [09:34:57.635] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:34:57.635] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [09:34:57.635] Program terminated with signal SIGABRT, Aborted. [09:34:57.635] #0 0x00007f66d72a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:34:58.646] [09:34:58.646] Thread 1 (Thread 0x7f66d521bf00 (LWP 27897)): [09:34:58.646] #0 0x00007f66d72a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:34:58.646] No symbol table info available. [09:34:58.646] #1 0x00007f66d725afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:34:58.646] No symbol table info available. [09:34:58.646] #2 0x00007f66d7245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:34:58.646] No symbol table info available. [09:34:58.646] #3 0x00007f66d741e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [09:34:58.646] No locals. [09:34:58.646] #4 0x00007f66d742aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [09:34:58.646] No locals. [09:34:58.646] #5 0x00007f66d740dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x558a107007a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [09:34:58.646] bp = 140735780042560 [09:34:58.646] pc = [09:34:58.646] Opts = {FromUnrecoverableHandler = true, pc = 94051455728895, bp = 94051626239336} [09:34:58.646] #6 0x0000558a0f9bfcff in examine_self_contradictory_rels (root=root@entry=0x558a19cf9128, rel=rel@entry=0x558a19cfab18, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [09:34:58.646] lc__state = [09:34:58.646] rlist = [09:34:58.646] i = 2 [09:34:58.646] br = [09:34:58.646] expression = [09:34:58.646] or_rinfo = 0x558a19c5d148 [09:34:58.646] ccxt = [09:34:58.646] delidx = 0x558a19c5d0e1 [09:34:58.646] arglst = [09:34:58.646] lc = [09:34:58.646] arg = [09:34:58.646] n = [09:34:58.646] restrictinfo = [09:34:58.646] ccwapper = {clausecxt = 0x558a19c5ca48} [09:34:58.646] sec = {sopcinfo = {n_members = 38, opcies = 0x558a19c5c5b8}, attrsdc = {min_attr = -6, max_attr = 5, len_set = 2, atop_array = 0x558a19c5bcd8, atop_set = 0x558a19c5be58}, ccfree = 0x558a19c5d0b0, vifree = 0x558a19c5cc50} [09:34:58.646] __func__ = "examine_self_contradictory_rels" [09:34:58.646] #7 0x0000558a0f9bff0e in examine_self_contradictory_rels_phase1 (root=root@entry=0x558a19cf9128) at ../src/backend/optimizer/plan/contradictory.c:2608 [09:34:58.646] rel = 0x558a19cfab18 [09:34:58.646] rti = 1 [09:34:58.646] rinfo = [09:34:58.646] #8 0x0000558a0f98a9eb in query_planner (root=root@entry=0x558a19cf9128, qp_callback=qp_callback@entry=0x558a0f98fd08 , qp_extra=qp_extra@entry=0x7fff9a2d3940) at ../src/backend/optimizer/plan/planmain.c:190 [09:34:58.646] parse = 0x558a19c010e0 [09:34:58.646] joinlist = 0x558a19c5bec8 [09:34:58.646] final_rel = [09:34:58.646] __func__ = "query_planner" [09:34:58.646] #9 0x0000558a0f99d943 in grouping_planner (root=root@entry=0x558a19cf9128, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1574 [09:34:58.646] sort_input_targets = 0x5 [09:34:58.646] sort_input_target_parallel_safe = [09:34:58.646] grouping_target = [09:34:58.646] scanjoin_target = [09:34:58.646] activeWindows = 0x0 [09:34:58.646] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [09:34:58.646] sort_input_targets_contain_srfs = 0x1 [09:34:58.646] have_grouping = [09:34:58.646] wflists = 0x0 [09:34:58.646] gset_data = 0x0 [09:34:58.646] sort_input_target = [09:34:58.646] grouping_targets = 0x1 [09:34:58.646] grouping_target_parallel_safe = [09:34:58.646] scanjoin_targets = 0x0 [09:34:58.646] scanjoin_target_parallel_safe = [09:34:58.646] grouping_targets_contain_srfs = 0x1 [09:34:58.646] scanjoin_targets_contain_srfs = 0x558a0feffcd3 [09:34:58.646] scanjoin_target_same_exprs = [09:34:58.646] parse = 0x558a19c010e0 [09:34:58.646] offset_est = 0 [09:34:58.646] count_est = 0 [09:34:58.646] limit_tuples = -1 [09:34:58.646] have_postponed_srfs = false [09:34:58.646] final_target = [09:34:58.646] final_targets = 0x558a19cd9ed8 [09:34:58.646] final_targets_contain_srfs = 0x558a0f8fc688 [09:34:58.646] final_target_parallel_safe = [09:34:58.646] current_rel = [09:34:58.646] final_rel = [09:34:58.646] extra = {limit_needed = false, limit_tuples = 4.6467592809915586e-310, count_est = 94051626915128, offset_est = 94051626915128} [09:34:58.646] lc = [09:34:58.646] __func__ = "grouping_planner" [09:34:58.646] #10 0x0000558a0f9a08c7 in subquery_planner (glob=glob@entry=0x558a19cfaa08, parse=parse@entry=0x558a19c010e0, 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:1143 [09:34:58.646] root = 0x558a19cf9128 [09:34:58.646] newWithCheckOptions = [09:34:58.646] newHaving = 0x0 [09:34:58.646] hasOuterJoins = [09:34:58.646] hasResultRTEs = false [09:34:58.646] final_rel = [09:34:58.646] l = 0x0 [09:34:58.646] #11 0x0000558a0f9a1558 in standard_planner (parse=0x558a19c010e0, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:417 [09:34:58.646] result = [09:34:58.646] glob = 0x558a19cfaa08 [09:34:58.646] tuple_fraction = 0 [09:34:58.646] root = [09:34:58.646] final_rel = [09:34:58.646] best_path = [09:34:58.646] top_plan = [09:34:58.646] lp = [09:34:58.646] lr = [09:34:58.646] #12 0x0000558a0f9a25c2 in planner (parse=parse@entry=0x558a19c010e0, query_string=query_string@entry=0x558a19bffaf0 "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:284 [09:34:58.646] result = [09:34:58.646] #13 0x0000558a0fc10f23 in pg_plan_query (querytree=querytree@entry=0x558a19c010e0, query_string=query_string@entry=0x558a19bffaf0 "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:911 [09:34:58.646] plan = [09:34:58.646] #14 0x0000558a0f718329 in standard_ExplainOneQuery (query=0x558a19c010e0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x558a19c3a4b8, queryString=0x558a19bffaf0 "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:496 [09:34:58.646] plan = [09:34:58.646] planstart = [09:34:58.646] planduration = {ticks = 94051454906284} [09:34:58.646] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94051461147081, shared_blks_dirtied = 2586655790, shared_blks_written = 3, local_blks_hit = 4726984656, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94051625865440, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94051461233875}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94051454903665}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94051625865440}} [09:34:58.646] bufusage = {shared_blks_hit = 0, shared_blks_read = 94051457923051, shared_blks_dirtied = 228140072845312, shared_blks_written = 72057594037927936, local_blks_hit = 140079478485224, local_blks_read = 94051625866832, local_blks_dirtied = 94051625865440, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94051460762757, shared_blk_read_time = {ticks = 140079478485224}, shared_blk_write_time = {ticks = 94051460762776}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94051461142664}, temp_blk_read_time = {ticks = 94051626099056}, temp_blk_write_time = {ticks = 64}} [09:34:58.646] mem_counters = {nblocks = 94051626887528, freechunks = 4294967297, totalspace = 140735780043696, freespace = 10} [09:34:58.646] planner_ctx = 0x0 [09:34:58.646] saved_ctx = 0x0 [09:34:58.646] #15 0x0000558a0f71860f in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x558a19c3a4b8, pstate=pstate@entry=0x558a19c3a3a8, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [09:34:58.646] No locals. [09:34:58.646] #16 0x0000558a0f71950f in ExplainQuery (pstate=pstate@entry=0x558a19c3a3a8, stmt=stmt@entry=0x558a19c00f20, params=params@entry=0x0, dest=dest@entry=0x558a19c3a318) at ../src/backend/commands/explain.c:350 [09:34:58.646] l__state = [09:34:58.646] l = 0x558a19cfa9d0 [09:34:58.646] es = 0x558a19c3a4b8 [09:34:58.646] tstate = [09:34:58.646] jstate = [09:34:58.646] query = [09:34:58.646] rewritten = 0x558a19cfa9b8 [09:34:58.646] lc = 0x0 [09:34:58.646] timing_set = false [09:34:58.646] summary_set = false [09:34:58.646] __func__ = "ExplainQuery" [09:34:58.646] #17 0x0000558a0fc1bb05 in standard_ProcessUtility (pstmt=0x558a19c00fd0, queryString=0x558a19bffaf0 "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=0x558a19c3a318, qc=0x7fff9a2d3e30) at ../src/backend/tcop/utility.c:866 [09:34:58.646] parsetree = 0x558a19c00f20 [09:34:58.646] isTopLevel = true [09:34:58.646] isAtomicContext = false [09:34:58.646] pstate = 0x558a19c3a3a8 [09:34:58.646] readonly_flags = [09:34:58.646] __func__ = "standard_ProcessUtility" [09:34:58.646] #18 0x0000558a0fc1c22e in ProcessUtility (pstmt=pstmt@entry=0x558a19c00fd0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x558a19c3a318, qc=0x7fff9a2d3e30) at ../src/backend/tcop/utility.c:523 [09:34:58.646] No locals. [09:34:58.646] #19 0x0000558a0fc17a9a in PortalRunUtility (portal=portal@entry=0x558a19c82100, pstmt=0x558a19c00fd0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x558a19c3a318, qc=qc@entry=0x7fff9a2d3e30) at ../src/backend/tcop/pquery.c:1158 [09:34:58.646] No locals. [09:34:58.646] #20 0x0000558a0fc1830d in FillPortalStore (portal=portal@entry=0x558a19c82100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [09:34:58.646] treceiver = 0x558a19c3a318 [09:34:58.646] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:34:58.646] __func__ = "FillPortalStore" [09:34:58.646] #21 0x0000558a0fc18901 in PortalRun (portal=portal@entry=0x558a19c82100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x558a19cda1b8, altdest=altdest@entry=0x558a19cda1b8, qc=0x7fff9a2d4010) at ../src/backend/tcop/pquery.c:763 [09:34:58.646] _save_exception_stack = 0x7fff9a2d40c0 [09:34:58.646] _save_context_stack = 0x0 [09:34:58.646] _local_sigjmp_buf = {{__jmpbuf = {0, -8272672822597912945, 94051626393856, 94051625865112, 94051626393856, 94051625865040, -2748734931039029617, -8272650730461464945}, __mask_was_saved = 0, __saved_mask = {__val = {94051461142664, 94051625859568, 112, 4, 94051461147081, 2586656671, 4, 94051625865040, 112, 153, 94051626393856, 94051625865112, 94051625865088, 94051625865040, 94051461234284, 1}}}} [09:34:58.646] _do_rethrow = [09:34:58.646] result = [09:34:58.646] nprocessed = [09:34:58.646] saveTopTransactionResourceOwner = 0x558a19c41898 [09:34:58.646] saveTopTransactionContext = 0x558a19c94530 [09:34:58.646] saveActivePortal = 0x0 [09:34:58.646] saveResourceOwner = 0x558a19c41898 [09:34:58.646] savePortalContext = 0x0 [09:34:58.646] saveMemoryContext = 0x558a19c94530 [09:34:58.646] __func__ = "PortalRun" [09:34:58.646] #22 0x0000558a0fc119f9 in exec_simple_query (query_string=query_string@entry=0x558a19bffaf0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;") at ../src/backend/tcop/postgres.c:1283 [09:34:58.646] cmdtaglen = 7 [09:34:58.646] snapshot_set = [09:34:58.646] per_parsetree_context = 0x0 [09:34:58.646] plantree_list = 0x558a19cda168 [09:34:58.646] parsetree = 0x558a19c00f50 [09:34:58.646] commandTag = [09:34:58.646] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:34:58.646] querytree_list = [09:34:58.646] portal = 0x558a19c82100 [09:34:58.646] receiver = 0x558a19cda1b8 [09:34:58.646] format = 0 [09:34:58.646] cmdtagname = [09:34:58.646] parsetree_item__state = [09:34:58.646] dest = DestRemote [09:34:58.646] oldcontext = 0x558a19c94530 [09:34:58.646] parsetree_list = 0x558a19c00f80 [09:34:58.646] parsetree_item = 0x558a19c00f98 [09:34:58.646] save_log_statement_stats = false [09:34:58.646] was_logged = false [09:34:58.646] use_implicit_block = false [09:34:58.646] msec_str = "\004\000\000\000\000\000\000\000W\306\354\017\212U\000\000\240@-\232\377\177\000\000J\000\000\000\000\000\000" [09:34:58.646] __func__ = "exec_simple_query" [09:34:58.646] #23 0x0000558a0fc1477d in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [09:34:58.646] query_string = 0x558a19bffaf0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;" [09:34:58.646] firstchar = [09:34:58.646] input_message = {data = 0x558a19bffaf0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", len = 74, maxlen = 1024, cursor = 74} [09:34:58.646] local_sigjmp_buf = {{__jmpbuf = {94051473806840, -8272658275083356529, 140735780045340, 4, 18, 140735780045572, -2748734933408811377, -8272650734424820081}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94051625590288, 15616, 94051473800928, 94051626114416, 18, 94051461146629, 0, 9, 2, 94051473806848, 94051625590288, 94051473800928, 4, 18, 140735780045572}}}} [09:34:58.646] send_ready_for_query = false [09:34:58.646] idle_in_transaction_timeout_enabled = false [09:34:58.646] idle_session_timeout_enabled = false [09:34:58.646] __func__ = "PostgresMain" [09:34:58.646] #24 0x0000558a0fc0a5f3 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:34:58.646] bsdata = [09:34:58.646] #25 0x0000558a0fabc345 in postmaster_child_launch (child_type=B_BACKEND, child_slot=18, startup_data=startup_data@entry=0x7fff9a2d421c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff9a2d4270) at ../src/backend/postmaster/launch_backend.c:274 [09:34:58.646] pid = [09:34:58.646] #26 0x0000558a0fac1340 in BackendStartup (client_sock=client_sock@entry=0x7fff9a2d4270) at ../src/backend/postmaster/postmaster.c:3377 [09:34:58.646] bn = 0x558a19c28398 [09:34:58.646] pid = [09:34:58.646] startup_data = {canAcceptConnections = CAC_OK} [09:34:58.646] cac = [09:34:58.646] __func__ = "BackendStartup" [09:34:58.646] #27 0x0000558a0fac3219 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [09:34:58.646] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\022\203\305\016\212U\000\000hg\301\016\212U\000\000\300C-\232\377\177\000\000\270C-\232\377\177\000\000\225[\362\001\000\000\000\000\240t\b\330f\177\000\000+", '\000' , "\377\177\000\000\000\004\000\000\000\000\000\000h\206\265\330f\177\000\0000v\b\330f\177\000\000\340\202\265\330f\177\000\000\316)fR\000\000\000", __ss_align = 2586657792}, salen = 2}} [09:34:58.646] i = 0 [09:34:58.646] now = [09:34:58.646] last_lockfile_recheck_time = 1732527060 [09:34:58.646] last_touch_time = 1732527060 [09:34:58.646] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -670534096, events = 32614, fd = -659193120, user_data = 0x7c96e577}, {pos = -1708309440, events = 32767, fd = -659363256, user_data = 0xf}, {pos = -670534096, events = 32614, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -659193120, user_data = 0x7fff9a2d43b8}, {pos = -1708309568, events = 32767, fd = -659192216, user_data = 0x0}, {pos = 432012208, events = 21898, fd = -685016438, user_data = 0x558a19bffbb0}, {pos = 1, events = 21898, fd = 32768, user_data = 0xffffffff}, {pos = -685580256, events = 32614, fd = -663421024, user_data = 0x558a19c2b198}, {pos = 432189560, events = 21898, fd = 432198753, user_data = 0x7f66d8b34ebe}, {pos = 1, events = 0, fd = -659193120, user_data = 0x1ab}, {pos = 272932184, events = 21898, fd = 0, user_data = 0xec}, {pos = 432012208, events = 21898, fd = -659337538, user_data = 0x1}, {pos = 0, events = 0, fd = -685580256, user_data = 0x7f66d72f2e40 }, {pos = 16, events = 0, fd = -1708308432, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f66d8b371ba}, {pos = 0, events = 0, fd = -685052508, user_data = 0x0}, {pos = 279894432, events = 21898, fd = 2, user_data = 0x0}, {pos = 431759024, events = 21898, fd = 263861672, user_data = 0x558a19c32cc0}, {pos = 263865661, events = 21898, fd = 432221467, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -685546296, user_data = 0x7f66d729c880 }, {pos = -719209032, events = 32614, fd = -1708308240, user_data = 0x100007f00000002}, {pos = -685019385, events = 32614, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -683729824, events = 32614, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 1330015316, fd = 168440164, user_data = 0x35323337310a6174}, {pos = 909129522, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 432192608, events = 21898, fd = -685016438, user_data = 0xa}, {pos = 267294856, events = 21898, fd = 432204944, user_data = 0x7f66d72b576b}, {pos = -683746848, events = 32614, fd = -685108882, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x3c2331672550e900}, {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 = 0x558a19c2ae70}, {pos = 1, events = 0, fd = 432189240, user_data = 0x3}, {pos = 0, events = 0, fd = 20995, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 432012208, user_data = 0x7f66d72f3053 }, {pos = 432189240, events = 21898, fd = 1024, user_data = 0x7fff9a2d48f8}, {pos = 267378172, events = 21898, fd = 279958960, user_data = 0x558a0feec8b9 }, {pos = 432189040, events = 21898, fd = 432011760, user_data = 0x558a19c2ae70}, {pos = -685025429, events = 32614, fd = 0, user_data = 0x558a0fefe523 }, {pos = 432189040, events = 1, fd = 267380332, user_data = 0x558a19bff9f0}, {pos = 626059520, events = 1008939367, fd = 0, user_data = 0x7f66d72a2ab1}, {pos = -685107984, events = 32614, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 431759024, user_data = 0x3c2331672550e900}, {pos = 0, events = 0, fd = 626059520, user_data = 0xc}, {pos = 626059520, events = 1008939367, fd = 0, user_data = 0x7f66d725b239 }, {pos = 237, events = 0, fd = 262914114, user_data = 0x400000}, {pos = 0, events = 0, fd = 431759024, user_data = 0x558a0feec74d }, {pos = 431845664, events = 21898, fd = 432011760, user_data = 0x558a19bd7120}, {pos = 1, events = 0, fd = 0, user_data = 0x558a0feab14a }, {pos = 12, events = 0, fd = 432188616, user_data = 0x558a19c2aca8}, {pos = 279895840, events = 21898, fd = 296, user_data = 0x558a0fabe85c }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 262930585, events = 21898, fd = 276328912, user_data = 0x558a19c003c8}} [09:34:58.646] nevents = 1 [09:34:58.646] __func__ = "ServerLoop" [09:34:58.646] #28 0x0000558a0fac4aaa in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x558a19bbdd70) at ../src/backend/postmaster/postmaster.c:1361 [09:34:58.646] opt = [09:34:58.646] status = [09:34:58.646] userDoption = [09:34:58.646] listen_addr_saved = false [09:34:58.646] output_config_variable = [09:34:58.646] __func__ = "PostmasterMain" [09:34:58.646] #29 0x0000558a0f8f277a in main (argc=8, argv=0x558a19bbdd70) at ../src/backend/main/main.c:196 [09:34:58.646] do_check_root = [09:34:58.684] -e [09:34:58.684] [09:34:58.684] [09:34:58.746] dumping /tmp/cores/postgres-6-39629.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:34:58.988] [New LWP 39629] [09:34:58.988] [09:34:58.988] This GDB supports auto-downloading debuginfo from the following URLs: [09:34:58.988] [09:34:58.988] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:34:58.988] Debuginfod has been disabled. [09:34:58.988] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:34:59.088] [Thread debugging using libthread_db enabled] [09:34:59.088] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:34:59.088] Core was generated by `postgres: test: postgres db2 [local] SELECT '. [09:34:59.088] Program terminated with signal SIGABRT, Aborted. [09:34:59.088] #0 0x00007fa883ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:34:59.150] [09:34:59.150] Thread 1 (Thread 0x7fa883dd3f00 (LWP 39629)): [09:34:59.150] #0 0x00007fa883ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:34:59.150] No symbol table info available. [09:34:59.150] #1 0x00007fa883e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:34:59.150] No symbol table info available. [09:34:59.150] #2 0x00007fa883e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:34:59.150] No symbol table info available. [09:34:59.150] #3 0x00007fa88401e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [09:34:59.150] No locals. [09:34:59.150] #4 0x00007fa88402aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [09:34:59.150] No locals. [09:34:59.150] #5 0x00007fa88400dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x562255e867a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [09:34:59.150] bp = 140728863697088 [09:34:59.150] pc = [09:34:59.150] Opts = {FromUnrecoverableHandler = true, pc = 94705456274687, bp = 140361548511592} [09:34:59.150] #6 0x0000562255145cff in examine_self_contradictory_rels (root=root@entry=0x562276ee65e0, rel=rel@entry=0x7fa8783ca4b8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [09:34:59.150] lc__state = [09:34:59.150] rlist = [09:34:59.150] i = 7 [09:34:59.150] br = [09:34:59.150] expression = [09:34:59.150] or_rinfo = 0x7fa8783d6048 [09:34:59.150] ccxt = [09:34:59.150] delidx = 0x7fa8783d7fe1 [09:34:59.150] arglst = [09:34:59.150] lc = [09:34:59.150] arg = [09:34:59.150] n = [09:34:59.150] restrictinfo = [09:34:59.150] ccwapper = {clausecxt = 0x7fa8783d5958} [09:34:59.150] sec = {sopcinfo = {n_members = 38, opcies = 0x7fa8783d50f8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7fa8783d5508, atop_set = 0x7fa8783d2f48}, ccfree = 0x7fa8783d7fb0, vifree = 0x7fa8783d6ec8} [09:34:59.150] __func__ = "examine_self_contradictory_rels" [09:34:59.150] #7 0x0000562255145f0e in examine_self_contradictory_rels_phase1 (root=root@entry=0x562276ee65e0) at ../src/backend/optimizer/plan/contradictory.c:2608 [09:34:59.150] rel = 0x7fa8783ca4b8 [09:34:59.150] rti = 1 [09:34:59.150] rinfo = [09:34:59.150] #8 0x00005622551109eb in query_planner (root=root@entry=0x562276ee65e0, qp_callback=qp_callback@entry=0x562255115d08 , qp_extra=qp_extra@entry=0x7ffdfdee2ac0) at ../src/backend/optimizer/plan/planmain.c:190 [09:34:59.150] parse = 0x562276edcdd8 [09:34:59.150] joinlist = 0x7fa8783d30d8 [09:34:59.150] final_rel = [09:34:59.150] __func__ = "query_planner" [09:34:59.150] #9 0x0000562255123943 in grouping_planner (root=root@entry=0x562276ee65e0, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1574 [09:34:59.150] sort_input_targets = 0x562276ee65e0 [09:34:59.150] sort_input_target_parallel_safe = [09:34:59.150] grouping_target = [09:34:59.150] scanjoin_target = [09:34:59.150] activeWindows = 0x0 [09:34:59.150] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [09:34:59.150] sort_input_targets_contain_srfs = 0x562276ee3dd8 [09:34:59.150] have_grouping = [09:34:59.150] wflists = 0x0 [09:34:59.150] gset_data = 0x0 [09:34:59.150] sort_input_target = [09:34:59.150] grouping_targets = 0x562276ee3e20 [09:34:59.150] grouping_target_parallel_safe = [09:34:59.150] scanjoin_targets = 0x562276ee3e08 [09:34:59.150] scanjoin_target_parallel_safe = [09:34:59.150] grouping_targets_contain_srfs = 0x562276ee65e0 [09:34:59.150] scanjoin_targets_contain_srfs = 0x0 [09:34:59.150] scanjoin_target_same_exprs = [09:34:59.150] parse = 0x562276edcdd8 [09:34:59.150] offset_est = 0 [09:34:59.150] count_est = 0 [09:34:59.150] limit_tuples = -1 [09:34:59.150] have_postponed_srfs = false [09:34:59.150] final_target = [09:34:59.150] final_targets = 0x562276ee65e0 [09:34:59.150] final_targets_contain_srfs = 0x7 [09:34:59.150] final_target_parallel_safe = [09:34:59.150] current_rel = [09:34:59.150] final_rel = [09:34:59.150] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94706024173016} [09:34:59.150] lc = [09:34:59.150] __func__ = "grouping_planner" [09:34:59.150] #10 0x00005622551268c7 in subquery_planner (glob=, parse=0x562276edcdd8, parent_root=parent_root@entry=0x562276ed9c78, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1143 [09:34:59.150] root = 0x562276ee65e0 [09:34:59.150] newWithCheckOptions = [09:34:59.150] newHaving = 0x0 [09:34:59.150] hasOuterJoins = [09:34:59.150] hasResultRTEs = true [09:34:59.150] final_rel = [09:34:59.150] l = 0x0 [09:34:59.150] #11 0x0000562255138261 in SS_process_ctes (root=root@entry=0x562276ed9c78) at ../src/backend/optimizer/plan/subselect.c:968 [09:34:59.150] subquery = [09:34:59.150] cte = 0x562276e96490 [09:34:59.150] cmdType = [09:34:59.150] subroot = [09:34:59.150] final_rel = [09:34:59.150] best_path = [09:34:59.150] plan = [09:34:59.150] splan = [09:34:59.150] paramid = [09:34:59.150] lc__state = [09:34:59.150] lc = [09:34:59.150] __func__ = "SS_process_ctes" [09:34:59.150] #12 0x000056225512536b in subquery_planner (glob=glob@entry=0x562276ea7388, parse=parse@entry=0x562276ea7498, 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:696 [09:34:59.150] root = 0x562276ed9c78 [09:34:59.150] newWithCheckOptions = [09:34:59.150] newHaving = [09:34:59.150] hasOuterJoins = [09:34:59.150] hasResultRTEs = [09:34:59.150] final_rel = [09:34:59.150] l = [09:34:59.150] #13 0x0000562255127558 in standard_planner (parse=0x562276ea7498, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:417 [09:34:59.150] result = [09:34:59.150] glob = 0x562276ea7388 [09:34:59.150] tuple_fraction = 0 [09:34:59.150] root = [09:34:59.150] final_rel = [09:34:59.150] best_path = [09:34:59.150] top_plan = [09:34:59.150] lp = [09:34:59.150] lr = [09:34:59.150] #14 0x00005622551285c2 in planner (parse=parse@entry=0x562276ea7498, query_string=query_string@entry=0x562276dbb5a0 "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:284 [09:34:59.150] result = [09:34:59.150] #15 0x0000562255396f23 in pg_plan_query (querytree=querytree@entry=0x562276ea7498, query_string=query_string@entry=0x562276dbb5a0 "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:911 [09:34:59.150] plan = [09:34:59.150] #16 0x0000562255397304 in pg_plan_queries (querytrees=0x562276ed9c28, query_string=query_string@entry=0x562276dbb5a0 "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:1005 [09:34:59.150] query = 0x562276ea7498 [09:34:59.150] stmt = [09:34:59.150] query_list__state = [09:34:59.150] stmt_list = 0x0 [09:34:59.150] query_list = [09:34:59.150] #17 0x00005622553978b1 in exec_simple_query (query_string=query_string@entry=0x562276dbb5a0 "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:1202 [09:34:59.150] cmdtaglen = 6 [09:34:59.150] snapshot_set = true [09:34:59.150] per_parsetree_context = 0x0 [09:34:59.150] plantree_list = [09:34:59.150] parsetree = 0x562276ea7308 [09:34:59.150] commandTag = CMDTAG_SELECT [09:34:59.150] qc = {commandTag = 1935, nprocessed = 94706022987168} [09:34:59.150] querytree_list = [09:34:59.150] portal = [09:34:59.150] receiver = [09:34:59.150] format = 0 [09:34:59.150] cmdtagname = [09:34:59.150] parsetree_item__state = [09:34:59.150] dest = DestRemote [09:34:59.150] oldcontext = 0x562276e4af40 [09:34:59.150] parsetree_list = 0x562276ea7338 [09:34:59.150] parsetree_item = 0x562276ea7350 [09:34:59.150] save_log_statement_stats = false [09:34:59.150] was_logged = true [09:34:59.150] use_implicit_block = false [09:34:59.150] msec_str = "\004\000\000\000\000\000\000\000W&eU\"V\000\000\220.\356\375\375\177\000\000\217\a\000\000\000\000\000" [09:34:59.150] __func__ = "exec_simple_query" [09:34:59.150] #18 0x000056225539a77d in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [09:34:59.150] query_string = 0x562276dbb5a0 "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 "... [09:34:59.150] firstchar = [09:34:59.150] input_message = {data = 0x562276dbb5a0 "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} [09:34:59.150] local_sigjmp_buf = {{__jmpbuf = {94705474352632, -3867676738088561383, 140728863698956, 4, 2, 140728863699188, -7355477756528782055, -3867670289953417959}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94706022714832, 14336, 94705474346720, 94706023222352, 2, 94705461692421, 0, 9, 2, 94705474352640, 94706022714832, 94705474346720, 4, 2, 140728863699188}}}} [09:34:59.150] send_ready_for_query = false [09:34:59.150] idle_in_transaction_timeout_enabled = false [09:34:59.150] idle_session_timeout_enabled = false [09:34:59.150] __func__ = "PostgresMain" [09:34:59.150] #19 0x00005622553905f3 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:34:59.150] bsdata = [09:34:59.150] #20 0x0000562255242345 in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x7ffdfdee300c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffdfdee3060) at ../src/backend/postmaster/launch_backend.c:274 [09:34:59.150] pid = [09:34:59.150] #21 0x0000562255247340 in BackendStartup (client_sock=client_sock@entry=0x7ffdfdee3060) at ../src/backend/postmaster/postmaster.c:3377 [09:34:59.150] bn = 0x562276de25f8 [09:34:59.150] pid = [09:34:59.150] startup_data = {canAcceptConnections = CAC_OK} [09:34:59.150] cac = [09:34:59.150] __func__ = "BackendStartup" [09:34:59.150] #22 0x0000562255249219 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [09:34:59.150] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\356\375\375\177\000\000\3640\356\375\375\177", '\000' , "\022\343=T\"V\000\000h\3079T\"V\000\000\3001\356\375\375\177\000\000\2701\356\375\375\177\000\000\225[\362\001\000\000\000\000\240tȄ\250\177\000\000+", '\000' , " \342=T\"V\000\000h\346p\205\250\177\000\0000vȄ\250\177\000", __ss_align = 140361770001120}, salen = 2}} [09:34:59.150] i = 0 [09:34:59.150] now = [09:34:59.150] last_lockfile_recheck_time = 1732527140 [09:34:59.150] last_touch_time = 1732527140 [09:34:59.150] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1413341970, events = 22050, fd = -2056198552, user_data = 0x7fa884c87630}, {pos = -2056199456, events = 32680, fd = 2090263927, user_data = 0x7ffdfdee3240}, {pos = -2056369592, events = 32680, fd = 15, user_data = 0x7fa884c87630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -2056199456, events = 32680, fd = -34721352, user_data = 0x7ffdfdee31c0}, {pos = -2056198552, events = 32680, fd = 0, user_data = 0x562276dbca20}, {pos = 1433134230, events = 22050, fd = 32768, user_data = 0x1}, {pos = 1994115680, events = 22050, fd = -1, user_data = 0x7fa883e2e020}, {pos = -2060271712, events = 32680, fd = 1994285912, user_data = 0x562276de6238}, {pos = 1994283009, events = 22050, fd = -2056343874, user_data = 0x1}, {pos = -2056199456, events = 32680, fd = 427, user_data = 0x562255bcfd58 }, {pos = 0, events = 0, fd = 216, user_data = 0x562276dbca20}, {pos = -2056343874, events = 32680, fd = 1, user_data = 0x0}, {pos = -2082283488, events = 32680, fd = -2081477056, user_data = 0x10}, {pos = -34720224, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2056334918, user_data = 0x0}, {pos = -2081755740, events = 32680, fd = 0, user_data = 0x5622562739a0 }, {pos = 2, events = 0, fd = 0, user_data = 0x562276d7ce70}, {pos = 1429382461, events = 22050, fd = 1994316635, user_data = 0x56225532e176 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x562276dbca20}, {pos = -2056343874, events = 32680, fd = 1, user_data = 0x0}, {pos = -2082249528, events = 32680, fd = -2081830784, user_data = 0x42d}, {pos = -2081722617, events = 32680, fd = 2, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = -2080433056, events = 32680, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4278190080, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1751342899, events = 795566949, fd = 1635017060, user_data = 0x6975622f646c6975}, {pos = 1949262956, events = 1920234341, fd = 0, user_data = 0x7f0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = 1432811656, events = 22050, fd = 1994298048, user_data = 0x7fa883eb58be}, {pos = -2080450080, events = 32680, fd = -2081812114, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x4820c9a5d7f0f00}, {pos = -2080447008, events = 32680, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1994285304, user_data = 0x3}, {pos = 0, events = 0, fd = 39021, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1994115616, user_data = 0x7fa883ef3053 }, {pos = 1994285304, events = 22050, fd = 1024, user_data = 0x7ffdfdee36e8}, {pos = 1432894972, events = 22050, fd = 1445475760, user_data = 0x5622556728b9 }, {pos = 1994285104, events = 22050, fd = 1994108032, user_data = 0x562276de6030}, {pos = -2081728661, events = 32680, fd = 0, user_data = 0x562255684523 }, {pos = 1994285104, events = 1, fd = 1432897132, user_data = 0x562276dbac80}, {pos = 1568608000, events = 75631770, fd = 0, user_data = 0x7fa883ea2ab1}, {pos = -2081811216, events = 32680, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1993854576, user_data = 0x4820c9a5d7f0f00}, {pos = 0, events = 0, fd = 1568608000, user_data = 0xc}, {pos = 1568608000, events = 75631770, fd = 0, user_data = 0x7fa883e5b239 }, {pos = 217, events = 0, fd = 1428430914, user_data = 0x400000}, {pos = 0, events = 0, fd = 1993854576, user_data = 0x56225567274d }, {pos = 1993941936, events = 22050, fd = 1994108032, user_data = 0x562276d923b0}, {pos = 1, events = 0, fd = 0, user_data = 0x56225563114a }, {pos = 12, events = 0, fd = 1994280552, user_data = 0x562276de4e48}, {pos = 1445412640, events = 22050, fd = 296, user_data = 0x56225524485c }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1428447385, events = 22050, fd = 1441845712, user_data = 0x562276dbb638}} [09:34:59.150] nevents = 1 [09:34:59.150] __func__ = "ServerLoop" [09:34:59.150] #23 0x000056225524aaaa in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x562276d78ce0) at ../src/backend/postmaster/postmaster.c:1361 [09:34:59.150] opt = [09:34:59.150] status = [09:34:59.150] userDoption = [09:34:59.150] listen_addr_saved = false [09:34:59.150] output_config_variable = [09:34:59.150] __func__ = "PostmasterMain" [09:34:59.150] #24 0x000056225507877a in main (argc=4, argv=0x562276d78ce0) at ../src/backend/main/main.c:196 [09:34:59.150] do_check_root = [09:34:59.170] -e [09:34:59.170] [09:34:59.170] [09:34:59.269] dumping /tmp/cores/postgres-6-22588.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:34:59.514] [New LWP 22588] [09:34:59.514] [09:34:59.514] This GDB supports auto-downloading debuginfo from the following URLs: [09:34:59.514] [09:34:59.514] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:34:59.514] Debuginfod has been disabled. [09:34:59.514] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:34:59.756] [Thread debugging using libthread_db enabled] [09:34:59.756] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:34:59.756] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN '. [09:34:59.756] Program terminated with signal SIGABRT, Aborted. [09:34:59.756] #0 0x00007f3efb6a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:00.719] [09:35:00.719] Thread 1 (Thread 0x7f3ef9221f00 (LWP 22588)): [09:35:00.719] #0 0x00007f3efb6a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:00.719] No symbol table info available. [09:35:00.719] #1 0x00007f3efb65afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:00.719] No symbol table info available. [09:35:00.719] #2 0x00007f3efb645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:00.719] No symbol table info available. [09:35:00.719] #3 0x00007f3efb81e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [09:35:00.719] No locals. [09:35:00.719] #4 0x00007f3efb82aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [09:35:00.719] No locals. [09:35:00.719] #5 0x00007f3efb80dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55871b8f77a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [09:35:00.719] bp = 140736730994640 [09:35:00.719] pc = [09:35:00.719] Opts = {FromUnrecoverableHandler = true, pc = 94038757436671, bp = 94039735759880} [09:35:00.719] #6 0x000055871abb6cff in examine_self_contradictory_rels (root=root@entry=0x5587553b2798, rel=rel@entry=0x5587552959f8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [09:35:00.719] lc__state = [09:35:00.719] rlist = [09:35:00.719] i = 2 [09:35:00.719] br = [09:35:00.719] expression = [09:35:00.719] or_rinfo = 0x5587550b8158 [09:35:00.719] ccxt = [09:35:00.719] delidx = 0x5587550b7ff1 [09:35:00.719] arglst = [09:35:00.719] lc = [09:35:00.719] arg = [09:35:00.719] n = [09:35:00.719] restrictinfo = [09:35:00.719] ccwapper = {clausecxt = 0x5587550b7988} [09:35:00.719] sec = {sopcinfo = {n_members = 38, opcies = 0x5587550b7458}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x5587552ffba8, atop_set = 0x5587550b7868}, ccfree = 0x5587550b7fc0, vifree = 0x5587550b7af8} [09:35:00.719] __func__ = "examine_self_contradictory_rels" [09:35:00.719] #7 0x000055871abb6f0e in examine_self_contradictory_rels_phase1 (root=root@entry=0x5587553b2798) at ../src/backend/optimizer/plan/contradictory.c:2608 [09:35:00.719] rel = 0x5587552959f8 [09:35:00.719] rti = 1 [09:35:00.719] rinfo = [09:35:00.719] #8 0x000055871ab819eb in query_planner (root=root@entry=0x5587553b2798, qp_callback=qp_callback@entry=0x55871ab86d08 , qp_extra=qp_extra@entry=0x7fffd2db99d0) at ../src/backend/optimizer/plan/planmain.c:190 [09:35:00.719] parse = 0x558755060d18 [09:35:00.719] joinlist = 0x5587552ffc18 [09:35:00.719] final_rel = [09:35:00.719] __func__ = "query_planner" [09:35:00.719] #9 0x000055871ab94943 in grouping_planner (root=root@entry=0x5587553b2798, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1574 [09:35:00.719] sort_input_targets = 0x5 [09:35:00.719] sort_input_target_parallel_safe = [09:35:00.719] grouping_target = [09:35:00.719] scanjoin_target = [09:35:00.719] activeWindows = 0x0 [09:35:00.719] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [09:35:00.719] sort_input_targets_contain_srfs = 0x1 [09:35:00.719] have_grouping = [09:35:00.719] wflists = 0x0 [09:35:00.719] gset_data = 0x0 [09:35:00.719] sort_input_target = [09:35:00.719] grouping_targets = 0x1 [09:35:00.719] grouping_target_parallel_safe = [09:35:00.719] scanjoin_targets = 0x0 [09:35:00.719] scanjoin_target_parallel_safe = [09:35:00.719] grouping_targets_contain_srfs = 0x1 [09:35:00.719] scanjoin_targets_contain_srfs = 0x55871b0f6cd3 [09:35:00.719] scanjoin_target_same_exprs = [09:35:00.719] parse = 0x558755060d18 [09:35:00.719] offset_est = 0 [09:35:00.719] count_est = 0 [09:35:00.719] limit_tuples = -1 [09:35:00.719] have_postponed_srfs = false [09:35:00.719] final_target = [09:35:00.719] final_targets = 0x558755149028 [09:35:00.719] final_targets_contain_srfs = 0x55871aaf3688 [09:35:00.719] final_target_parallel_safe = [09:35:00.719] current_rel = [09:35:00.719] final_rel = [09:35:00.719] extra = {limit_needed = false, limit_tuples = 4.6461319019966854e-310, count_est = 94039738152568, offset_est = 94039738152568} [09:35:00.719] lc = [09:35:00.719] __func__ = "grouping_planner" [09:35:00.719] #10 0x000055871ab978c7 in subquery_planner (glob=glob@entry=0x5587552958e8, parse=parse@entry=0x558755060d18, 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:1143 [09:35:00.719] root = 0x5587553b2798 [09:35:00.719] newWithCheckOptions = [09:35:00.719] newHaving = 0x0 [09:35:00.719] hasOuterJoins = [09:35:00.719] hasResultRTEs = false [09:35:00.719] final_rel = [09:35:00.719] l = 0x0 [09:35:00.719] #11 0x000055871ab98558 in standard_planner (parse=0x558755060d18, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:417 [09:35:00.719] result = [09:35:00.719] glob = 0x5587552958e8 [09:35:00.719] tuple_fraction = 0 [09:35:00.719] root = [09:35:00.719] final_rel = [09:35:00.719] best_path = [09:35:00.719] top_plan = [09:35:00.719] lp = [09:35:00.719] lr = [09:35:00.719] #12 0x000055871ab995c2 in planner (parse=parse@entry=0x558755060d18, query_string=query_string@entry=0x55875505fa70 "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:284 [09:35:00.719] result = [09:35:00.719] #13 0x000055871ae07f23 in pg_plan_query (querytree=querytree@entry=0x558755060d18, query_string=query_string@entry=0x55875505fa70 "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:911 [09:35:00.719] plan = [09:35:00.719] #14 0x000055871a90f329 in standard_ExplainOneQuery (query=0x558755060d18, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55875508b068, queryString=0x55875505fa70 "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:496 [09:35:00.719] plan = [09:35:00.719] planstart = [09:35:00.719] planduration = {ticks = 94038756614060} [09:35:00.719] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94038762854857, shared_blks_dirtied = 3537607870, shared_blks_written = 3, local_blks_hit = 4294967296, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94039735405848, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94038762941651}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94038756611441}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94039735405848}} [09:35:00.719] bufusage = {shared_blks_hit = 0, shared_blks_read = 94038759630827, shared_blks_dirtied = 72980084310019, shared_blks_written = 72057594037927936, local_blks_hit = 139908291306000, local_blks_read = 94039735407024, local_blks_dirtied = 94039735405848, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94038762470533, shared_blk_read_time = {ticks = 139908291306000}, shared_blk_write_time = {ticks = 94038762470552}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94038762850440}, temp_blk_read_time = {ticks = 94039735577888}, temp_blk_write_time = {ticks = 64}} [09:35:00.719] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140736730995776, freespace = 10} [09:35:00.719] planner_ctx = 0x0 [09:35:00.719] saved_ctx = 0x0 [09:35:00.719] #15 0x000055871a90f60f in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55875508b068, pstate=pstate@entry=0x55875508af58, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [09:35:00.719] No locals. [09:35:00.719] #16 0x000055871a91050f in ExplainQuery (pstate=pstate@entry=0x55875508af58, stmt=stmt@entry=0x558755060b58, params=params@entry=0x0, dest=dest@entry=0x55875508aec8) at ../src/backend/commands/explain.c:350 [09:35:00.719] l__state = [09:35:00.719] l = 0x5587552958b0 [09:35:00.719] es = 0x55875508b068 [09:35:00.719] tstate = [09:35:00.719] jstate = [09:35:00.719] query = [09:35:00.719] rewritten = 0x558755295898 [09:35:00.719] lc = 0x0 [09:35:00.719] timing_set = false [09:35:00.719] summary_set = false [09:35:00.719] __func__ = "ExplainQuery" [09:35:00.719] #17 0x000055871ae12b05 in standard_ProcessUtility (pstmt=0x558755060c08, queryString=0x55875505fa70 "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=0x55875508aec8, qc=0x7fffd2db9ec0) at ../src/backend/tcop/utility.c:866 [09:35:00.719] parsetree = 0x558755060b58 [09:35:00.719] isTopLevel = true [09:35:00.719] isAtomicContext = false [09:35:00.719] pstate = 0x55875508af58 [09:35:00.719] readonly_flags = [09:35:00.719] __func__ = "standard_ProcessUtility" [09:35:00.719] #18 0x000055871ae1322e in ProcessUtility (pstmt=pstmt@entry=0x558755060c08, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55875508aec8, qc=0x7fffd2db9ec0) at ../src/backend/tcop/utility.c:523 [09:35:00.719] No locals. [09:35:00.719] #19 0x000055871ae0ea9a in PortalRunUtility (portal=portal@entry=0x5587550e17e0, pstmt=0x558755060c08, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55875508aec8, qc=qc@entry=0x7fffd2db9ec0) at ../src/backend/tcop/pquery.c:1158 [09:35:00.719] No locals. [09:35:00.719] #20 0x000055871ae0f30d in FillPortalStore (portal=portal@entry=0x5587550e17e0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [09:35:00.719] treceiver = 0x55875508aec8 [09:35:00.719] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:35:00.719] __func__ = "FillPortalStore" [09:35:00.719] #21 0x000055871ae0f901 in PortalRun (portal=portal@entry=0x5587550e17e0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x558755149438, altdest=altdest@entry=0x558755149438, qc=0x7fffd2dba0a0) at ../src/backend/tcop/pquery.c:763 [09:35:00.719] _save_exception_stack = 0x7fffd2dba150 [09:35:00.719] _save_context_stack = 0x0 [09:35:00.719] _local_sigjmp_buf = {{__jmpbuf = {0, 3796523199032416705, 94039735932896, 94039735405520, 94039735932896, 94039735405448, 6944262699493317057, 3796369923415562689}, __mask_was_saved = 0, __saved_mask = {__val = {94038762850440, 94039735400816, 112, 4, 94038762854857, 3537608751, 4, 94039735405448, 112, 153, 94039735932896, 94039735405520, 94039735405496, 94039735405448, 94038762942060, 1}}}} [09:35:00.719] _do_rethrow = [09:35:00.719] result = [09:35:00.719] nprocessed = [09:35:00.719] saveTopTransactionResourceOwner = 0x55875509e998 [09:35:00.719] saveTopTransactionContext = 0x5587550f5c50 [09:35:00.719] saveActivePortal = 0x0 [09:35:00.719] saveResourceOwner = 0x55875509e998 [09:35:00.719] savePortalContext = 0x0 [09:35:00.719] saveMemoryContext = 0x5587550f5c50 [09:35:00.719] __func__ = "PortalRun" [09:35:00.719] #22 0x000055871ae089f9 in exec_simple_query (query_string=query_string@entry=0x55875505fa70 "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:1283 [09:35:00.719] cmdtaglen = 7 [09:35:00.719] snapshot_set = [09:35:00.719] per_parsetree_context = 0x0 [09:35:00.719] plantree_list = 0x5587551493e8 [09:35:00.719] parsetree = 0x558755060b88 [09:35:00.719] commandTag = [09:35:00.719] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:35:00.719] querytree_list = [09:35:00.719] portal = 0x5587550e17e0 [09:35:00.719] receiver = 0x558755149438 [09:35:00.719] format = 0 [09:35:00.719] cmdtagname = [09:35:00.719] parsetree_item__state = [09:35:00.719] dest = DestRemote [09:35:00.719] oldcontext = 0x5587550f5c50 [09:35:00.719] parsetree_list = 0x558755060bb8 [09:35:00.719] parsetree_item = 0x558755060bd0 [09:35:00.719] save_log_statement_stats = false [09:35:00.719] was_logged = true [09:35:00.719] use_implicit_block = false [09:35:00.719] msec_str = "\004\000\000\000\000\000\000\000W6\f\033\207U\000\0000\241\333\322\377\177\000\000n\000\000\000\000\000\000" [09:35:00.719] __func__ = "exec_simple_query" [09:35:00.719] #23 0x000055871ae0b77d in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [09:35:00.719] query_string = 0x55875505fa70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [09:35:00.719] firstchar = [09:35:00.719] input_message = {data = 0x55875505fa70 "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} [09:35:00.719] local_sigjmp_buf = {{__jmpbuf = {94038775514616, 3796367410432006593, 140736730997420, 4, 8, 140736730997652, 6944262701426891201, 3796369921607555521}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94039735131632, 14336, 94038775508704, 94039735654736, 8, 94038762854405, 0, 9, 2, 94038775514624, 94039735131632, 94038775508704, 4, 8, 140736730997652}}}} [09:35:00.719] send_ready_for_query = false [09:35:00.719] idle_in_transaction_timeout_enabled = false [09:35:00.719] idle_session_timeout_enabled = false [09:35:00.719] __func__ = "PostgresMain" [09:35:00.719] #24 0x000055871ae015f3 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:35:00.719] bsdata = [09:35:00.719] #25 0x000055871acb3345 in postmaster_child_launch (child_type=B_BACKEND, child_slot=8, startup_data=startup_data@entry=0x7fffd2dba2ac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffd2dba300) at ../src/backend/postmaster/launch_backend.c:274 [09:35:00.719] pid = [09:35:00.719] #26 0x000055871acb8340 in BackendStartup (client_sock=client_sock@entry=0x7fffd2dba300) at ../src/backend/postmaster/postmaster.c:3377 [09:35:00.719] bn = 0x558755087408 [09:35:00.719] pid = [09:35:00.719] startup_data = {canAcceptConnections = CAC_OK} [09:35:00.719] cac = [09:35:00.719] __func__ = "BackendStartup" [09:35:00.719] #27 0x000055871acba219 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [09:35:00.719] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\373\374>\177\000\000>\004\000\000\000\000\000\000\260\227c\373>\177\000\000\240\377\262\374>\177\000\000\270\243\333\322\377\177\000\000\264\243\333\322\377\177", '\000' , "\022\363\344\031\207U\000\000h\327\340\031\207U\000\000\200\244\333\322\377\177\000\000x\244\333\322\377\177\000\000\225[\362\001\272)\325\035\240\204]\373>\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [09:35:00.719] i = 0 [09:35:00.719] now = [09:35:00.719] last_lockfile_recheck_time = 1732527062 [09:35:00.719] last_touch_time = 1732527062 [09:35:00.719] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = -757357376, user_data = 0x0}, {pos = 15, events = 0, fd = 434434834, user_data = 0x7f3efcfe1668}, {pos = -77756880, events = 32574, fd = -50457888, user_data = 0x7c96e577}, {pos = -757357312, events = 32767, fd = -50628024, user_data = 0xf}, {pos = -77756880, events = 32574, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -50457888, user_data = 0x7fffd2dba478}, {pos = -757357440, events = 32767, fd = -50456984, user_data = 0x0}, {pos = 1426462496, events = 21895, fd = -76616347, user_data = 0x7fffd2dba993}, {pos = 1, events = 0, fd = -757357440, user_data = 0xffffffff}, {pos = -77406176, events = 32574, fd = -55378016, user_data = 0x55875508b048}, {pos = 1426632488, events = 21895, fd = 1426629873, user_data = 0x7f3efcfbdebe}, {pos = 1, events = 0, fd = -50457888, user_data = 0x1ab}, {pos = 459541848, events = 21895, fd = 0, user_data = 0xd8}, {pos = 1426455176, events = 21895, fd = -50602306, user_data = 0x1}, {pos = 0, events = 0, fd = -77406176, user_data = 0x7f3efb6f2e40 }, {pos = 16, events = 0, fd = -757356352, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f3efcfc01ba}, {pos = 0, events = 0, fd = -76878428, user_data = 0x0}, {pos = 466504096, events = 21895, fd = 2, user_data = 0x0}, {pos = 1426202256, events = 21895, fd = 1952410737, user_data = 0x161}, {pos = 459541256, events = 21895, fd = 4, user_data = 0x2ffff00001fa0}, {pos = 1426455176, events = 21895, fd = -50602306, user_data = 0x1}, {pos = -76845305, events = 32574, fd = -77372216, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -75555744, events = 32574, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x558755021e90}, {pos = -76842358, events = 32574, 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 = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x0}, {pos = 0, events = 32512, 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 = -75572768, events = 32574, fd = -76934802, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x1dd529ba21081000}, {pos = -75569696, events = 32574, fd = -328, user_data = 0x0}, {pos = 1426632168, events = 21895, fd = 1024, user_data = 0x55875508ade8}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 21509, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1426455176, user_data = 0x7f3efb6f3053 }, {pos = 1426632168, events = 21895, fd = 1024, user_data = 0x7fffd2dba988}, {pos = 453987836, events = 21895, fd = 466568624, user_data = 0x55871b0e38b9 }, {pos = 1426631968, events = 21895, fd = 1426454896, user_data = 0x55875508ad20}, {pos = -76851349, events = 32574, fd = 0, user_data = 0x55871b0f5523 }, {pos = 1426631968, events = 1, fd = 453989996, user_data = 0x55875505f970}, {pos = 554176512, events = 500509114, fd = 0, user_data = 0x7f3efb6a2ab1}, {pos = -76933904, events = 32574, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1426202256, user_data = 0x1dd529ba21081000}, {pos = 0, events = 0, fd = 554176512, user_data = 0xc}, {pos = 554176512, events = 500509114, fd = 0, user_data = 0x7f3efb65b239 }, {pos = 217, events = 0, fd = 449523778, user_data = 0x400000}, {pos = 0, events = 0, fd = 1426202256, user_data = 0x55871b0e374d }, {pos = 1426288800, events = 21895, fd = 1426454896, user_data = 0x5587550370a0}, {pos = 1, events = 0, fd = 0, user_data = 0x55871b0a214a }, {pos = 12, events = 0, fd = 1426627416, user_data = 0x558755089b38}, {pos = 466505504, events = 21895, fd = 296, user_data = 0x55871acb585c }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 449540249, events = 21895, fd = 462938576, user_data = 0x558755060318}} [09:35:00.719] nevents = 1 [09:35:00.719] __func__ = "ServerLoop" [09:35:00.719] #28 0x000055871acbbaaa in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55875501dd00) at ../src/backend/postmaster/postmaster.c:1361 [09:35:00.719] opt = [09:35:00.719] status = [09:35:00.719] userDoption = [09:35:00.719] listen_addr_saved = false [09:35:00.719] output_config_variable = [09:35:00.719] __func__ = "PostmasterMain" [09:35:00.719] #29 0x000055871aae977a in main (argc=4, argv=0x55875501dd00) at ../src/backend/main/main.c:196 [09:35:00.719] do_check_root = [09:35:00.757] -e [09:35:00.757] [09:35:00.757] [09:35:00.820] dumping /tmp/cores/postgres-6-25447.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:35:01.076] [New LWP 25447] [09:35:01.076] [09:35:01.076] This GDB supports auto-downloading debuginfo from the following URLs: [09:35:01.076] [09:35:01.076] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:35:01.076] Debuginfod has been disabled. [09:35:01.076] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:35:01.191] [Thread debugging using libthread_db enabled] [09:35:01.191] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:35:01.191] Core was generated by `postgres: postgres regression [local] SELECT '. [09:35:01.191] Program terminated with signal SIGABRT, Aborted. [09:35:01.191] #0 0x00007f66d72a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:02.289] [09:35:02.289] Thread 1 (Thread 0x7f66d521bf00 (LWP 25447)): [09:35:02.289] #0 0x00007f66d72a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:02.289] No symbol table info available. [09:35:02.289] #1 0x00007f66d725afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:02.289] No symbol table info available. [09:35:02.289] #2 0x00007f66d7245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:02.289] No symbol table info available. [09:35:02.289] #3 0x00007f66d741e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [09:35:02.289] No locals. [09:35:02.289] #4 0x00007f66d742aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [09:35:02.289] No locals. [09:35:02.289] #5 0x00007f66d740dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x558a107007a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [09:35:02.289] bp = 140735780040144 [09:35:02.289] pc = [09:35:02.289] Opts = {FromUnrecoverableHandler = true, pc = 94051455728895, bp = 94051627222232} [09:35:02.289] #6 0x0000558a0f9bfcff in examine_self_contradictory_rels (root=root@entry=0x558a19d81458, rel=rel@entry=0x558a19d7f1f0, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [09:35:02.289] lc__state = [09:35:02.289] rlist = [09:35:02.289] i = 3 [09:35:02.289] br = [09:35:02.289] expression = [09:35:02.289] or_rinfo = 0x558a19d4d2b0 [09:35:02.289] ccxt = [09:35:02.289] delidx = 0x558a19d4da31 [09:35:02.289] arglst = [09:35:02.289] lc = [09:35:02.289] arg = [09:35:02.289] n = [09:35:02.289] restrictinfo = [09:35:02.289] ccwapper = {clausecxt = 0x558a19d4cff0} [09:35:02.289] sec = {sopcinfo = {n_members = 38, opcies = 0x558a19d4c698}, attrsdc = {min_attr = -6, max_attr = 7, len_set = 2, atop_array = 0x558a19d82ce8, atop_set = 0x558a19d83278}, ccfree = 0x558a19d4cfc0, vifree = 0x558a19d4d620} [09:35:02.289] __func__ = "examine_self_contradictory_rels" [09:35:02.289] #7 0x0000558a0f9bff0e in examine_self_contradictory_rels_phase1 (root=root@entry=0x558a19d81458) at ../src/backend/optimizer/plan/contradictory.c:2608 [09:35:02.289] rel = 0x558a19d7f1f0 [09:35:02.289] rti = 1 [09:35:02.289] rinfo = [09:35:02.289] #8 0x0000558a0f98a9eb in query_planner (root=root@entry=0x558a19d81458, qp_callback=qp_callback@entry=0x558a0f98fd08 , qp_extra=qp_extra@entry=0x7fff9a2d2fd0) at ../src/backend/optimizer/plan/planmain.c:190 [09:35:02.289] parse = 0x558a19d1d738 [09:35:02.289] joinlist = 0x558a19d832e8 [09:35:02.289] final_rel = [09:35:02.289] __func__ = "query_planner" [09:35:02.289] #9 0x0000558a0f99d943 in grouping_planner (root=root@entry=0x558a19d81458, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1574 [09:35:02.289] sort_input_targets = 0x558a19d82248 [09:35:02.289] sort_input_target_parallel_safe = [09:35:02.289] grouping_target = [09:35:02.289] scanjoin_target = [09:35:02.289] activeWindows = 0x0 [09:35:02.289] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [09:35:02.289] sort_input_targets_contain_srfs = 0x2 [09:35:02.289] have_grouping = [09:35:02.289] wflists = 0x0 [09:35:02.289] gset_data = 0x0 [09:35:02.289] sort_input_target = [09:35:02.289] grouping_targets = 0x0 [09:35:02.289] grouping_target_parallel_safe = [09:35:02.289] scanjoin_targets = 0x558a19d81458 [09:35:02.289] scanjoin_target_parallel_safe = [09:35:02.289] grouping_targets_contain_srfs = 0x558a19d822e8 [09:35:02.289] scanjoin_targets_contain_srfs = 0x0 [09:35:02.289] scanjoin_target_same_exprs = [09:35:02.289] parse = 0x558a19d1d738 [09:35:02.289] offset_est = 0 [09:35:02.289] count_est = 0 [09:35:02.289] limit_tuples = -1 [09:35:02.289] have_postponed_srfs = false [09:35:02.289] final_target = [09:35:02.289] final_targets = 0x558a19d1ed48 [09:35:02.289] final_targets_contain_srfs = 0x558a0f9de538 [09:35:02.289] final_target_parallel_safe = [09:35:02.289] current_rel = [09:35:02.289] final_rel = [09:35:02.289] extra = {limit_needed = 24, limit_tuples = 4.64676780531647e-310, count_est = 94051627442920, offset_est = 94051627439192} [09:35:02.289] lc = [09:35:02.289] __func__ = "grouping_planner" [09:35:02.289] #10 0x0000558a0f9a08c7 in subquery_planner (glob=glob@entry=0x558a19d7f0e0, parse=parse@entry=0x558a19d1d738, 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:1143 [09:35:02.289] root = 0x558a19d81458 [09:35:02.289] newWithCheckOptions = [09:35:02.289] newHaving = 0x0 [09:35:02.289] hasOuterJoins = [09:35:02.289] hasResultRTEs = false [09:35:02.289] final_rel = [09:35:02.289] l = 0x0 [09:35:02.289] #11 0x0000558a0f9a1558 in standard_planner (parse=0x558a19d1d738, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:417 [09:35:02.289] result = [09:35:02.289] glob = 0x558a19d7f0e0 [09:35:02.289] tuple_fraction = 0 [09:35:02.289] root = [09:35:02.289] final_rel = [09:35:02.289] best_path = [09:35:02.289] top_plan = [09:35:02.289] lp = [09:35:02.289] lr = [09:35:02.289] #12 0x0000558a0f9a25c2 in planner (parse=parse@entry=0x558a19d1d738, query_string=query_string@entry=0x558a19d1d3f0 "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:284 [09:35:02.289] result = [09:35:02.289] #13 0x0000558a0fc10f23 in pg_plan_query (querytree=querytree@entry=0x558a19d1d738, query_string=query_string@entry=0x558a19d1d3f0 "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:911 [09:35:02.289] plan = [09:35:02.289] #14 0x0000558a0f718329 in standard_ExplainOneQuery (query=0x558a19d1d738, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x558a19d7eb70, queryString=0x558a19d1d3f0 "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:496 [09:35:02.289] plan = [09:35:02.289] planstart = [09:35:02.289] planduration = {ticks = 94051454906284} [09:35:02.289] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94051461147081, shared_blks_dirtied = 2586653374, shared_blks_written = 3, local_blks_hit = 4728148720, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94051627030328, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94051461233875}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94051454903665}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94051627030328}} [09:35:02.289] bufusage = {shared_blks_hit = 0, shared_blks_read = 94051457923051, shared_blks_dirtied = 143559281885184, shared_blks_written = 72057594037927936, local_blks_hit = 140079477352176, local_blks_read = 94051627030176, local_blks_dirtied = 94051627030328, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94051460762757, shared_blk_read_time = {ticks = 140079477352176}, shared_blk_write_time = {ticks = 94051460762776}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94051461142664}, temp_blk_read_time = {ticks = 94051627029232}, temp_blk_write_time = {ticks = 64}} [09:35:02.289] mem_counters = {nblocks = 94051627429952, freechunks = 4294967297, totalspace = 140735780041280, freespace = 10} [09:35:02.289] planner_ctx = 0x0 [09:35:02.289] saved_ctx = 0x0 [09:35:02.289] #15 0x0000558a0f71860f in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x558a19d7eb70, pstate=pstate@entry=0x558a19d7ea60, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [09:35:02.289] No locals. [09:35:02.289] #16 0x0000558a0f71950f in ExplainQuery (pstate=pstate@entry=0x558a19d7ea60, stmt=stmt@entry=0x558a19d1d5e0, params=params@entry=0x0, dest=dest@entry=0x558a19d7e9d0) at ../src/backend/commands/explain.c:350 [09:35:02.289] l__state = [09:35:02.289] l = 0x558a19d7f0a8 [09:35:02.289] es = 0x558a19d7eb70 [09:35:02.289] tstate = [09:35:02.289] jstate = [09:35:02.289] query = [09:35:02.289] rewritten = 0x558a19d7f090 [09:35:02.289] lc = 0x0 [09:35:02.289] timing_set = false [09:35:02.289] summary_set = false [09:35:02.289] __func__ = "ExplainQuery" [09:35:02.289] #17 0x0000558a0fc1bb05 in standard_ProcessUtility (pstmt=0x558a19d1d4d0, queryString=0x558a19d1d3f0 "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=0x558a19d7e9d0, qc=0x7fff9a2d34c0) at ../src/backend/tcop/utility.c:866 [09:35:02.289] parsetree = 0x558a19d1d5e0 [09:35:02.289] isTopLevel = false [09:35:02.289] isAtomicContext = true [09:35:02.289] pstate = 0x558a19d7ea60 [09:35:02.289] readonly_flags = [09:35:02.289] __func__ = "standard_ProcessUtility" [09:35:02.289] #18 0x0000558a0fc1c22e in ProcessUtility (pstmt=pstmt@entry=0x558a19d1d4d0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_QUERY, params=, queryEnv=, dest=0x558a19d7e9d0, qc=0x7fff9a2d34c0) at ../src/backend/tcop/utility.c:523 [09:35:02.289] No locals. [09:35:02.289] #19 0x0000558a0fc17a9a in PortalRunUtility (portal=portal@entry=0x558a19c84210, pstmt=0x558a19d1d4d0, isTopLevel=isTopLevel@entry=false, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x558a19d7e9d0, qc=qc@entry=0x7fff9a2d34c0) at ../src/backend/tcop/pquery.c:1158 [09:35:02.289] No locals. [09:35:02.289] #20 0x0000558a0fc1830d in FillPortalStore (portal=portal@entry=0x558a19c84210, isTopLevel=isTopLevel@entry=false) at ../src/backend/tcop/pquery.c:1031 [09:35:02.289] treceiver = 0x558a19d7e9d0 [09:35:02.289] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:35:02.289] __func__ = "FillPortalStore" [09:35:02.289] #21 0x0000558a0fc18d90 in PortalRunFetch (portal=portal@entry=0x558a19c84210, fdirection=fdirection@entry=FETCH_FORWARD, count=count@entry=10, dest=dest@entry=0x558a10435600 ) at ../src/backend/tcop/pquery.c:1442 [09:35:02.289] _save_exception_stack = 0x7fff9a2d3a70 [09:35:02.289] _save_context_stack = 0x7fff9a2d38e0 [09:35:02.289] _local_sigjmp_buf = {{__jmpbuf = {94051626402320, -8272672787108858225, 0, 10, 140735780043008, 94051626234040, -2748734930856577393, -8272650730532243825}, __mask_was_saved = 0, __saved_mask = {__val = {260810686, 94051627029488, 94051461152800, 140735780042976, 94051454657021, 144, 140079478143943, 94051627098816, 8192, 94051627369376, 94051627098816, 94051627098816, 94051627099072, 0, 94051461144907, 0}}}} [09:35:02.289] _do_rethrow = [09:35:02.289] result = [09:35:02.289] saveActivePortal = 0x558a19c84100 [09:35:02.289] saveResourceOwner = 0x558a19c43508 [09:35:02.289] savePortalContext = 0x558a19d1fae0 [09:35:02.289] oldContext = 0x558a19d14270 [09:35:02.289] __func__ = "PortalRunFetch" [09:35:02.289] #22 0x0000558a0f8ba93f in _SPI_cursor_operation (portal=portal@entry=0x558a19c84210, direction=direction@entry=FETCH_FORWARD, count=count@entry=10, dest=0x558a10435600 ) at ../src/backend/executor/spi.c:3027 [09:35:02.289] nfetched = [09:35:02.289] __func__ = "_SPI_cursor_operation" [09:35:02.289] #23 0x0000558a0f8c0234 in SPI_cursor_fetch (portal=portal@entry=0x558a19c84210, forward=forward@entry=true, count=10) at ../src/backend/executor/spi.c:1808 [09:35:02.289] No locals. [09:35:02.289] #24 0x00007f66cb87fef1 in exec_for_query (estate=estate@entry=0x7fff9a2d3900, stmt=stmt@entry=0x558a19c5b0b8, portal=portal@entry=0x558a19c84210, prefetch_ok=, prefetch_ok@entry=true) at ../src/pl/plpgsql/src/pl_exec.c:5887 [09:35:02.289] var = 0x558a19c5b108 [09:35:02.289] tuptab = [09:35:02.289] found = false [09:35:02.289] rc = 0 [09:35:02.289] previous_id = 1 [09:35:02.289] tupdescs_match = true [09:35:02.289] n = [09:35:02.289] #25 0x00007f66cb880afb in exec_stmt_dynfors (estate=estate@entry=0x7fff9a2d3900, stmt=stmt@entry=0x558a19c5b0b8) at ../src/pl/plpgsql/src/pl_exec.c:4645 [09:35:02.289] portal = 0x558a19c84210 [09:35:02.289] rc = [09:35:02.289] #26 0x00007f66cb87c43c in exec_stmts (estate=estate@entry=0x7fff9a2d3900, stmts=0x558a19c5b7b8) at ../src/pl/plpgsql/src/pl_exec.c:2096 [09:35:02.289] stmt = 0x558a19c5b0b8 [09:35:02.289] rc = [09:35:02.289] s__state = [09:35:02.289] save_estmt = 0x558a19c5b808 [09:35:02.289] s = [09:35:02.289] __func__ = "exec_stmts" [09:35:02.289] #27 0x00007f66cb87d10a in exec_stmt_block (estate=estate@entry=0x7fff9a2d3900, block=block@entry=0x558a19c5b808) at ../src/pl/plpgsql/src/pl_exec.c:1939 [09:35:02.289] rc = -1 [09:35:02.289] i = 3 [09:35:02.289] __func__ = "exec_stmt_block" [09:35:02.289] #28 0x00007f66cb87d251 in exec_toplevel_block (estate=estate@entry=0x7fff9a2d3900, block=0x558a19c5b808) at ../src/pl/plpgsql/src/pl_exec.c:1630 [09:35:02.289] rc = [09:35:02.289] #29 0x00007f66cb87d986 in plpgsql_exec_function (func=func@entry=0x558a19c430f8, fcinfo=fcinfo@entry=0x558a19d764c0, 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 [09:35:02.289] estate = {func = 0x558a19c430f8, 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 = 0x558a19d783d0, tuple_store_owner = 0x558a19c43508, rsi = 0x7fff9a2d3bb0, found_varno = 4, ndatums = 9, datums = 0x558a19d0ffa0, datum_context = 0x558a19d0fe50, paramLI = 0x558a19d0ff50, simple_eval_estate = 0x558a19d383e0, simple_eval_resowner = 0x558a19c41578, procedure_resowner = 0x0, cast_hash = 0x558a19d64470, stmt_mcontext = 0x558a19d2e2c0, stmt_mcontext_parent = 0x558a19d0fe50, eval_tuptable = 0x0, eval_processed = 0, eval_econtext = 0x558a19d385f0, err_stmt = 0x558a19c5b0b8, err_var = 0x0, err_text = 0x0, plugin_info = 0x0} [09:35:02.289] plerrcontext = {previous = 0x0, callback = 0x7f66cb87a625 , arg = 0x7fff9a2d3900} [09:35:02.289] i = 1 [09:35:02.289] rc = [09:35:02.289] __func__ = "plpgsql_exec_function" [09:35:02.289] #30 0x00007f66cb886c9b in plpgsql_call_handler (fcinfo=0x558a19d764c0) at ../src/pl/plpgsql/src/pl_handler.c:276 [09:35:02.289] _save_exception_stack = 0x7fff9a2d3ed0 [09:35:02.289] _save_context_stack = 0x0 [09:35:02.289] _local_sigjmp_buf = {{__jmpbuf = {94051626135800, 2748810400043103887, 0, 94051627403528, 1, 94051627405984, -2748734930913200497, -2816953813842266481}, __mask_was_saved = 0, __saved_mask = {__val = {94051627394280, 0, 0, 0, 94051453880297, 94051627394240, 94051627405160, 32, 94051454082278, 433557684, 94051627403528, 94051627393984, 94051627394240, 94051627393984, 94051454276285, 94051627394240}}}} [09:35:02.289] _do_rethrow = false [09:35:02.289] nonatomic = false [09:35:02.289] func = 0x558a19c430f8 [09:35:02.289] save_cur_estate = 0x0 [09:35:02.289] procedure_resowner = 0x0 [09:35:02.289] retval = 0 [09:35:02.289] rc = [09:35:02.289] __func__ = "plpgsql_call_handler" [09:35:02.289] #31 0x0000558a0f82f3cd in ExecMakeTableFunctionResult (setexpr=0x558a19d78a38, econtext=0x558a19d78908, argContext=, expectedDesc=0x558a19d792a0, randomAccess=false) at ../src/backend/executor/execSRF.c:234 [09:35:02.289] result = 94051460632476 [09:35:02.289] tupstore = 0x0 [09:35:02.289] tupdesc = 0x0 [09:35:02.289] funcrettype = 2249 [09:35:02.289] returnsTuple = [09:35:02.289] returnsSet = true [09:35:02.289] fcinfo = 0x558a19d764c0 [09:35:02.289] fcusage = {fs = 0x0, save_f_total_time = {ticks = 94051460625737}, save_total = {ticks = 0}, start = {ticks = 94051460617596}} [09:35:02.289] rsinfo = {type = T_ReturnSetInfo, econtext = 0x558a19d78908, expectedDesc = 0x558a19d792a0, allowedModes = 11, returnMode = SFRM_ValuePerCall, isDone = ExprSingleResult, setResult = 0x0, setDesc = 0x0} [09:35:02.289] tmptup = {t_len = 0, t_self = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 23}, t_tableOid = 0, t_data = 0x0} [09:35:02.289] callerContext = 0x558a19d783d0 [09:35:02.289] first_time = true [09:35:02.289] __func__ = "ExecMakeTableFunctionResult" [09:35:02.289] #32 0x0000558a0f85d5e6 in FunctionNext (node=0x558a19d786f8) at ../src/backend/executor/nodeFunctionscan.c:94 [09:35:02.289] tstore = 0x0 [09:35:02.289] estate = [09:35:02.289] direction = ForwardScanDirection [09:35:02.289] scanslot = 0x558a19d794c0 [09:35:02.289] alldone = [09:35:02.289] oldpos = [09:35:02.289] funcno = [09:35:02.289] att = [09:35:02.289] #33 0x0000558a0f830d2d in ExecScanFetch (node=node@entry=0x558a19d786f8, accessMtd=accessMtd@entry=0x558a0f85d3b1 , recheckMtd=recheckMtd@entry=0x558a0f85d2bd ) at ../src/backend/executor/execScan.c:131 [09:35:02.289] estate = [09:35:02.289] #34 0x0000558a0f830e37 in ExecScan (node=0x558a19d786f8, accessMtd=accessMtd@entry=0x558a0f85d3b1 , recheckMtd=recheckMtd@entry=0x558a0f85d2bd ) at ../src/backend/executor/execScan.c:180 [09:35:02.289] econtext = 0x558a19d78908 [09:35:02.289] qual = 0x0 [09:35:02.289] projInfo = 0x0 [09:35:02.289] #35 0x0000558a0f85d335 in ExecFunctionScan (pstate=) at ../src/backend/executor/nodeFunctionscan.c:269 [09:35:02.289] node = [09:35:02.289] #36 0x0000558a0f829c4a in ExecProcNodeFirst (node=0x558a19d786f8) at ../src/backend/executor/execProcnode.c:469 [09:35:02.289] No locals. [09:35:02.289] #37 0x0000558a0f815081 in ExecProcNode (node=node@entry=0x558a19d786f8) at ../src/include/executor/executor.h:278 [09:35:02.289] No locals. [09:35:02.289] #38 0x0000558a0f815236 in ExecutePlan (estate=estate@entry=0x558a19d784d0, planstate=0x558a19d786f8, use_parallel_mode=, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x558a19d28080, execute_once=true) at ../src/backend/executor/execMain.c:1655 [09:35:02.289] slot = [09:35:02.289] current_tuple_count = 0 [09:35:02.289] #39 0x0000558a0f816fae in standard_ExecutorRun (queryDesc=0x558a19d1fbe0, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:362 [09:35:02.289] estate = 0x558a19d784d0 [09:35:02.289] operation = CMD_SELECT [09:35:02.289] dest = 0x558a19d28080 [09:35:02.289] sendTuples = [09:35:02.289] oldcontext = 0x558a19d1fae0 [09:35:02.289] __func__ = "standard_ExecutorRun" [09:35:02.289] #40 0x0000558a0f8171e1 in ExecutorRun (queryDesc=queryDesc@entry=0x558a19d1fbe0, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:303 [09:35:02.289] No locals. [09:35:02.289] #41 0x0000558a0fc15361 in PortalRunSelect (portal=portal@entry=0x558a19c84100, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x558a19d28080) at ../src/backend/tcop/pquery.c:924 [09:35:02.289] queryDesc = 0x558a19d1fbe0 [09:35:02.289] direction = [09:35:02.289] nprocessed = [09:35:02.289] __func__ = "PortalRunSelect" [09:35:02.289] #42 0x0000558a0fc18819 in PortalRun (portal=portal@entry=0x558a19c84100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x558a19d28080, altdest=altdest@entry=0x558a19d28080, qc=0x7fff9a2d4010) at ../src/backend/tcop/pquery.c:768 [09:35:02.289] _save_exception_stack = 0x7fff9a2d40c0 [09:35:02.289] _save_context_stack = 0x0 [09:35:02.289] _local_sigjmp_buf = {{__jmpbuf = {0, -8272672866647542129, 94051626402048, 94051625863992, 94051626402048, 94051625863920, -2748734931039029617, -8272650730461464945}, __mask_was_saved = 0, __saved_mask = {__val = {94051461142664, 94051625859568, 112, 4, 94051461147081, 2586656671, 4, 94051625863920, 112, 179, 94051626402048, 94051625863992, 94051625863968, 94051625863920, 94051461234284, 1}}}} [09:35:02.289] _do_rethrow = [09:35:02.289] result = [09:35:02.289] nprocessed = [09:35:02.289] saveTopTransactionResourceOwner = 0x558a19c40db8 [09:35:02.289] saveTopTransactionContext = 0x558a19c96530 [09:35:02.289] saveActivePortal = 0x0 [09:35:02.289] saveResourceOwner = 0x558a19c40db8 [09:35:02.289] savePortalContext = 0x0 [09:35:02.289] saveMemoryContext = 0x558a19c96530 [09:35:02.289] __func__ = "PortalRun" [09:35:02.289] #43 0x0000558a0fc119f9 in exec_simple_query (query_string=query_string@entry=0x558a19bffaf0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');") at ../src/backend/tcop/postgres.c:1283 [09:35:02.289] cmdtaglen = 6 [09:35:02.289] snapshot_set = [09:35:02.289] per_parsetree_context = 0x0 [09:35:02.289] plantree_list = 0x558a19d28030 [09:35:02.289] parsetree = 0x558a19c00af0 [09:35:02.289] commandTag = [09:35:02.289] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:35:02.289] querytree_list = [09:35:02.289] portal = 0x558a19c84100 [09:35:02.289] receiver = 0x558a19d28080 [09:35:02.289] format = 0 [09:35:02.289] cmdtagname = [09:35:02.289] parsetree_item__state = [09:35:02.289] dest = DestRemote [09:35:02.289] oldcontext = 0x558a19c96530 [09:35:02.289] parsetree_list = 0x558a19c00b20 [09:35:02.289] parsetree_item = 0x558a19c00b38 [09:35:02.289] save_log_statement_stats = false [09:35:02.289] was_logged = false [09:35:02.289] use_implicit_block = false [09:35:02.289] msec_str = "\004\000\000\000\000\000\000\000W\306\354\017\212U\000\000\240@-\232\377\177\000\000x\000\000\000\000\000\000" [09:35:02.289] __func__ = "exec_simple_query" [09:35:02.289] #44 0x0000558a0fc1477d in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [09:35:02.289] query_string = 0x558a19bffaf0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');" [09:35:02.289] firstchar = [09:35:02.289] input_message = {data = 0x558a19bffaf0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');", len = 120, maxlen = 1024, cursor = 120} [09:35:02.289] local_sigjmp_buf = {{__jmpbuf = {94051473806840, -8272658275083356529, 140735780045340, 4, 20, 140735780045572, -2748734933408811377, -8272650734424820081}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94051625590288, 15616, 94051473800928, 94051626122608, 20, 94051461146629, 0, 9, 2, 94051473806848, 94051625590288, 94051473800928, 4, 20, 140735780045572}}}} [09:35:02.289] send_ready_for_query = false [09:35:02.289] idle_in_transaction_timeout_enabled = false [09:35:02.289] idle_session_timeout_enabled = false [09:35:02.289] __func__ = "PostgresMain" [09:35:02.289] #45 0x0000558a0fc0a5f3 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:35:02.289] bsdata = [09:35:02.289] #46 0x0000558a0fabc345 in postmaster_child_launch (child_type=B_BACKEND, child_slot=20, startup_data=startup_data@entry=0x7fff9a2d421c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff9a2d4270) at ../src/backend/postmaster/launch_backend.c:274 [09:35:02.289] pid = [09:35:02.289] #47 0x0000558a0fac1340 in BackendStartup (client_sock=client_sock@entry=0x7fff9a2d4270) at ../src/backend/postmaster/postmaster.c:3377 [09:35:02.289] bn = 0x558a19c283f8 [09:35:02.289] pid = [09:35:02.289] startup_data = {canAcceptConnections = CAC_OK} [09:35:02.289] cac = [09:35:02.289] __func__ = "BackendStartup" [09:35:02.289] #48 0x0000558a0fac3219 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [09:35:02.289] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\022\203\305\016\212U\000\000hg\301\016\212U\000\000\300C-\232\377\177\000\000\270C-\232\377\177\000\000\225[\362\001\000\000\000\000\240t\b\330f\177\000\000+", '\000' , "\377\177\000\000\000\004\000\000\000\000\000\000h\206\265\330f\177\000\0000v\b\330f\177\000\000\340\202\265\330f\177\000\000\316)fR\000\000\000", __ss_align = 2586657792}, salen = 2}} [09:35:02.289] i = 0 [09:35:02.289] now = [09:35:02.289] last_lockfile_recheck_time = 1732527060 [09:35:02.289] last_touch_time = 1732527060 [09:35:02.289] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -670534096, events = 32614, fd = -659193120, user_data = 0x7c96e577}, {pos = -1708309440, events = 32767, fd = -659363256, user_data = 0xf}, {pos = -670534096, events = 32614, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -659193120, user_data = 0x7fff9a2d43b8}, {pos = -1708309568, events = 32767, fd = -659192216, user_data = 0x0}, {pos = 432012208, events = 21898, fd = -685016438, user_data = 0x558a19bffbb0}, {pos = 1, events = 21898, fd = 32768, user_data = 0xffffffff}, {pos = -685580256, events = 32614, fd = -663421024, user_data = 0x558a19c2b198}, {pos = 432189560, events = 21898, fd = 432198753, user_data = 0x7f66d8b34ebe}, {pos = 1, events = 0, fd = -659193120, user_data = 0x1ab}, {pos = 272932184, events = 21898, fd = 0, user_data = 0xec}, {pos = 432012208, events = 21898, fd = -659337538, user_data = 0x1}, {pos = 0, events = 0, fd = -685580256, user_data = 0x7f66d72f2e40 }, {pos = 16, events = 0, fd = -1708308432, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f66d8b371ba}, {pos = 0, events = 0, fd = -685052508, user_data = 0x0}, {pos = 279894432, events = 21898, fd = 2, user_data = 0x0}, {pos = 431759024, events = 21898, fd = 263861672, user_data = 0x558a19c32cc0}, {pos = 263865661, events = 21898, fd = 432221467, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -685546296, user_data = 0x7f66d729c880 }, {pos = -719209032, events = 32614, fd = -1708308240, user_data = 0x100007f00000002}, {pos = -685019385, events = 32614, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -683729824, events = 32614, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 1330015316, fd = 168440164, user_data = 0x35323337310a6174}, {pos = 909129522, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 432192608, events = 21898, fd = -685016438, user_data = 0xa}, {pos = 267294856, events = 21898, fd = 432204944, user_data = 0x7f66d72b576b}, {pos = -683746848, events = 32614, fd = -685108882, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x3c2331672550e900}, {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 = 0x558a19c2ae70}, {pos = 1, events = 0, fd = 432189240, user_data = 0x3}, {pos = 0, events = 0, fd = 20995, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 432012208, user_data = 0x7f66d72f3053 }, {pos = 432189240, events = 21898, fd = 1024, user_data = 0x7fff9a2d48f8}, {pos = 267378172, events = 21898, fd = 279958960, user_data = 0x558a0feec8b9 }, {pos = 432189040, events = 21898, fd = 432011760, user_data = 0x558a19c2ae70}, {pos = -685025429, events = 32614, fd = 0, user_data = 0x558a0fefe523 }, {pos = 432189040, events = 1, fd = 267380332, user_data = 0x558a19bff9f0}, {pos = 626059520, events = 1008939367, fd = 0, user_data = 0x7f66d72a2ab1}, {pos = -685107984, events = 32614, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 431759024, user_data = 0x3c2331672550e900}, {pos = 0, events = 0, fd = 626059520, user_data = 0xc}, {pos = 626059520, events = 1008939367, fd = 0, user_data = 0x7f66d725b239 }, {pos = 237, events = 0, fd = 262914114, user_data = 0x400000}, {pos = 0, events = 0, fd = 431759024, user_data = 0x558a0feec74d }, {pos = 431845664, events = 21898, fd = 432011760, user_data = 0x558a19bd7120}, {pos = 1, events = 0, fd = 0, user_data = 0x558a0feab14a }, {pos = 12, events = 0, fd = 432188616, user_data = 0x558a19c2aca8}, {pos = 279895840, events = 21898, fd = 296, user_data = 0x558a0fabe85c }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 262930585, events = 21898, fd = 276328912, user_data = 0x558a19c003c8}} [09:35:02.289] nevents = 1 [09:35:02.289] __func__ = "ServerLoop" [09:35:02.289] #49 0x0000558a0fac4aaa in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x558a19bbdd70) at ../src/backend/postmaster/postmaster.c:1361 [09:35:02.289] opt = [09:35:02.289] status = [09:35:02.289] userDoption = [09:35:02.289] listen_addr_saved = false [09:35:02.289] output_config_variable = [09:35:02.289] __func__ = "PostmasterMain" [09:35:02.289] #50 0x0000558a0f8f277a in main (argc=8, argv=0x558a19bbdd70) at ../src/backend/main/main.c:196 [09:35:02.289] do_check_root = [09:35:02.326] -e [09:35:02.326] [09:35:02.326] [09:35:02.413] dumping /tmp/cores/postgres-6-21861.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:35:02.658] [New LWP 21861] [09:35:02.658] [09:35:02.658] This GDB supports auto-downloading debuginfo from the following URLs: [09:35:02.658] [09:35:02.658] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:35:02.658] Debuginfod has been disabled. [09:35:02.658] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:35:02.900] [Thread debugging using libthread_db enabled] [09:35:02.900] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:35:02.900] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [09:35:02.900] Program terminated with signal SIGABRT, Aborted. [09:35:02.900] #0 0x00007f66d72a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:03.856] [09:35:03.856] Thread 1 (Thread 0x7f66d521bf00 (LWP 21861)): [09:35:03.856] #0 0x00007f66d72a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:03.856] No symbol table info available. [09:35:03.856] #1 0x00007f66d725afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:03.856] No symbol table info available. [09:35:03.856] #2 0x00007f66d7245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:03.856] No symbol table info available. [09:35:03.856] #3 0x00007f66d741e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [09:35:03.856] No locals. [09:35:03.856] #4 0x00007f66d742aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [09:35:03.856] No locals. [09:35:03.856] #5 0x00007f66d740dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x558a107007a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [09:35:03.856] bp = 140735780042560 [09:35:03.856] pc = [09:35:03.856] Opts = {FromUnrecoverableHandler = true, pc = 94051455728895, bp = 94051628625128} [09:35:03.856] #6 0x0000558a0f9bfcff in examine_self_contradictory_rels (root=root@entry=0x558a19f4fb88, rel=rel@entry=0x558a19e3f318, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [09:35:03.856] lc__state = [09:35:03.856] rlist = [09:35:03.856] i = 2 [09:35:03.856] br = [09:35:03.856] expression = [09:35:03.856] or_rinfo = 0x558a19ea3a38 [09:35:03.856] ccxt = [09:35:03.856] delidx = 0x558a19ea38d1 [09:35:03.856] arglst = [09:35:03.856] lc = [09:35:03.856] arg = [09:35:03.856] n = [09:35:03.856] restrictinfo = [09:35:03.856] ccwapper = {clausecxt = 0x558a19ea3268} [09:35:03.856] sec = {sopcinfo = {n_members = 38, opcies = 0x558a19ea2d38}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x558a19e25008, atop_set = 0x558a19ea3148}, ccfree = 0x558a19ea38a0, vifree = 0x558a19ea33d8} [09:35:03.856] __func__ = "examine_self_contradictory_rels" [09:35:03.856] #7 0x0000558a0f9bff0e in examine_self_contradictory_rels_phase1 (root=root@entry=0x558a19f4fb88) at ../src/backend/optimizer/plan/contradictory.c:2608 [09:35:03.856] rel = 0x558a19e3f318 [09:35:03.856] rti = 1 [09:35:03.856] rinfo = [09:35:03.856] #8 0x0000558a0f98a9eb in query_planner (root=root@entry=0x558a19f4fb88, qp_callback=qp_callback@entry=0x558a0f98fd08 , qp_extra=qp_extra@entry=0x7fff9a2d3940) at ../src/backend/optimizer/plan/planmain.c:190 [09:35:03.856] parse = 0x558a19c00d98 [09:35:03.856] joinlist = 0x558a19e25078 [09:35:03.856] final_rel = [09:35:03.856] __func__ = "query_planner" [09:35:03.856] #9 0x0000558a0f99d943 in grouping_planner (root=root@entry=0x558a19f4fb88, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1574 [09:35:03.856] sort_input_targets = 0x5 [09:35:03.856] sort_input_target_parallel_safe = [09:35:03.856] grouping_target = [09:35:03.856] scanjoin_target = [09:35:03.856] activeWindows = 0x0 [09:35:03.856] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [09:35:03.856] sort_input_targets_contain_srfs = 0x1 [09:35:03.856] have_grouping = [09:35:03.856] wflists = 0x0 [09:35:03.856] gset_data = 0x0 [09:35:03.856] sort_input_target = [09:35:03.856] grouping_targets = 0x1 [09:35:03.856] grouping_target_parallel_safe = [09:35:03.856] scanjoin_targets = 0x0 [09:35:03.856] scanjoin_target_parallel_safe = [09:35:03.856] grouping_targets_contain_srfs = 0x1 [09:35:03.856] scanjoin_targets_contain_srfs = 0x558a0feffcd3 [09:35:03.856] scanjoin_target_same_exprs = [09:35:03.856] parse = 0x558a19c00d98 [09:35:03.856] offset_est = 0 [09:35:03.856] count_est = 0 [09:35:03.856] limit_tuples = -1 [09:35:03.856] have_postponed_srfs = false [09:35:03.856] final_target = [09:35:03.856] final_targets = 0x558a19ce7d18 [09:35:03.856] final_targets_contain_srfs = 0x558a0f8fc688 [09:35:03.856] final_target_parallel_safe = [09:35:03.856] current_rel = [09:35:03.856] final_rel = [09:35:03.856] extra = {limit_needed = false, limit_tuples = 4.6467592809915586e-310, count_est = 94051628108504, offset_est = 94051628108504} [09:35:03.856] lc = [09:35:03.856] __func__ = "grouping_planner" [09:35:03.856] #10 0x0000558a0f9a08c7 in subquery_planner (glob=glob@entry=0x558a19e3f208, parse=parse@entry=0x558a19c00d98, 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:1143 [09:35:03.856] root = 0x558a19f4fb88 [09:35:03.856] newWithCheckOptions = [09:35:03.856] newHaving = 0x0 [09:35:03.856] hasOuterJoins = [09:35:03.856] hasResultRTEs = false [09:35:03.856] final_rel = [09:35:03.856] l = 0x0 [09:35:03.856] #11 0x0000558a0f9a1558 in standard_planner (parse=0x558a19c00d98, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:417 [09:35:03.856] result = [09:35:03.856] glob = 0x558a19e3f208 [09:35:03.856] tuple_fraction = 0 [09:35:03.856] root = [09:35:03.856] final_rel = [09:35:03.856] best_path = [09:35:03.856] top_plan = [09:35:03.856] lp = [09:35:03.856] lr = [09:35:03.856] #12 0x0000558a0f9a25c2 in planner (parse=parse@entry=0x558a19c00d98, query_string=query_string@entry=0x558a19bffaf0 "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:284 [09:35:03.856] result = [09:35:03.856] #13 0x0000558a0fc10f23 in pg_plan_query (querytree=querytree@entry=0x558a19c00d98, query_string=query_string@entry=0x558a19bffaf0 "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:911 [09:35:03.856] plan = [09:35:03.856] #14 0x0000558a0f718329 in standard_ExplainOneQuery (query=0x558a19c00d98, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x558a19c2b1b8, queryString=0x558a19bffaf0 "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:496 [09:35:03.856] plan = [09:35:03.856] planstart = [09:35:03.856] planduration = {ticks = 94051454906284} [09:35:03.856] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94051461147081, shared_blks_dirtied = 2586655790, shared_blks_written = 3, local_blks_hit = 4294967296, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94051625864600, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94051461233875}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94051454903665}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94051625864600}} [09:35:03.856] bufusage = {shared_blks_hit = 0, shared_blks_read = 94051457923051, shared_blks_dirtied = 73065983655936, shared_blks_written = 72057594037927936, local_blks_hit = 140079477948944, local_blks_read = 94051625865776, local_blks_dirtied = 94051625864600, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94051460762757, shared_blk_read_time = {ticks = 140079477948944}, shared_blk_write_time = {ticks = 94051460762776}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94051461142664}, temp_blk_read_time = {ticks = 94051626036848}, temp_blk_write_time = {ticks = 64}} [09:35:03.856] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140735780043696, freespace = 10} [09:35:03.856] planner_ctx = 0x0 [09:35:03.856] saved_ctx = 0x0 [09:35:03.856] #15 0x0000558a0f71860f in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x558a19c2b1b8, pstate=pstate@entry=0x558a19c2b0a8, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [09:35:03.856] No locals. [09:35:03.856] #16 0x0000558a0f71950f in ExplainQuery (pstate=pstate@entry=0x558a19c2b0a8, stmt=stmt@entry=0x558a19c00bd8, params=params@entry=0x0, dest=dest@entry=0x558a19c2b018) at ../src/backend/commands/explain.c:350 [09:35:03.856] l__state = [09:35:03.856] l = 0x558a19e3f1d0 [09:35:03.856] es = 0x558a19c2b1b8 [09:35:03.856] tstate = [09:35:03.856] jstate = [09:35:03.856] query = [09:35:03.856] rewritten = 0x558a19e3f1b8 [09:35:03.856] lc = 0x0 [09:35:03.856] timing_set = false [09:35:03.856] summary_set = false [09:35:03.856] __func__ = "ExplainQuery" [09:35:03.856] #17 0x0000558a0fc1bb05 in standard_ProcessUtility (pstmt=0x558a19c00c88, queryString=0x558a19bffaf0 "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=0x558a19c2b018, qc=0x7fff9a2d3e30) at ../src/backend/tcop/utility.c:866 [09:35:03.856] parsetree = 0x558a19c00bd8 [09:35:03.856] isTopLevel = true [09:35:03.856] isAtomicContext = false [09:35:03.856] pstate = 0x558a19c2b0a8 [09:35:03.856] readonly_flags = [09:35:03.856] __func__ = "standard_ProcessUtility" [09:35:03.856] #18 0x0000558a0fc1c22e in ProcessUtility (pstmt=pstmt@entry=0x558a19c00c88, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x558a19c2b018, qc=0x7fff9a2d3e30) at ../src/backend/tcop/utility.c:523 [09:35:03.856] No locals. [09:35:03.856] #19 0x0000558a0fc17a9a in PortalRunUtility (portal=portal@entry=0x558a19c84100, pstmt=0x558a19c00c88, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x558a19c2b018, qc=qc@entry=0x7fff9a2d3e30) at ../src/backend/tcop/pquery.c:1158 [09:35:03.856] No locals. [09:35:03.856] #20 0x0000558a0fc1830d in FillPortalStore (portal=portal@entry=0x558a19c84100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [09:35:03.856] treceiver = 0x558a19c2b018 [09:35:03.856] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:35:03.856] __func__ = "FillPortalStore" [09:35:03.856] #21 0x0000558a0fc18901 in PortalRun (portal=portal@entry=0x558a19c84100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x558a19ce8128, altdest=altdest@entry=0x558a19ce8128, qc=0x7fff9a2d4010) at ../src/backend/tcop/pquery.c:763 [09:35:03.856] _save_exception_stack = 0x7fff9a2d40c0 [09:35:03.856] _save_context_stack = 0x0 [09:35:03.856] _local_sigjmp_buf = {{__jmpbuf = {0, -8272672832242714993, 94051626402048, 94051625864272, 94051626402048, 94051625864200, -2748734931039029617, -8272650730461464945}, __mask_was_saved = 0, __saved_mask = {__val = {94051461142664, 94051625859568, 112, 4, 94051461147081, 2586656671, 4, 94051625864200, 112, 153, 94051626402048, 94051625864272, 94051625864248, 94051625864200, 94051461234284, 1}}}} [09:35:03.856] _do_rethrow = [09:35:03.856] result = [09:35:03.856] nprocessed = [09:35:03.856] saveTopTransactionResourceOwner = 0x558a19c40db8 [09:35:03.856] saveTopTransactionContext = 0x558a19c96530 [09:35:03.856] saveActivePortal = 0x0 [09:35:03.856] saveResourceOwner = 0x558a19c40db8 [09:35:03.856] savePortalContext = 0x0 [09:35:03.856] saveMemoryContext = 0x558a19c96530 [09:35:03.856] __func__ = "PortalRun" [09:35:03.856] #22 0x0000558a0fc119f9 in exec_simple_query (query_string=query_string@entry=0x558a19bffaf0 "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:1283 [09:35:03.856] cmdtaglen = 7 [09:35:03.856] snapshot_set = [09:35:03.856] per_parsetree_context = 0x0 [09:35:03.856] plantree_list = 0x558a19ce80d8 [09:35:03.856] parsetree = 0x558a19c00c08 [09:35:03.856] commandTag = [09:35:03.856] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:35:03.856] querytree_list = [09:35:03.856] portal = 0x558a19c84100 [09:35:03.856] receiver = 0x558a19ce8128 [09:35:03.856] format = 0 [09:35:03.856] cmdtagname = [09:35:03.856] parsetree_item__state = [09:35:03.856] dest = DestRemote [09:35:03.856] oldcontext = 0x558a19c96530 [09:35:03.856] parsetree_list = 0x558a19c00c38 [09:35:03.856] parsetree_item = 0x558a19c00c50 [09:35:03.856] save_log_statement_stats = false [09:35:03.856] was_logged = false [09:35:03.856] use_implicit_block = false [09:35:03.856] msec_str = "\004\000\000\000\000\000\000\000W\306\354\017\212U\000\000\240@-\232\377\177\000\000n\000\000\000\000\000\000" [09:35:03.856] __func__ = "exec_simple_query" [09:35:03.856] #23 0x0000558a0fc1477d in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [09:35:03.856] query_string = 0x558a19bffaf0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [09:35:03.856] firstchar = [09:35:03.856] input_message = {data = 0x558a19bffaf0 "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} [09:35:03.856] local_sigjmp_buf = {{__jmpbuf = {94051473806840, -8272658275083356529, 140735780045340, 4, 20, 140735780045572, -2748734933408811377, -8272650734424820081}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94051625590288, 15616, 94051473800928, 94051626122608, 20, 94051461146629, 0, 9, 2, 94051473806848, 94051625590288, 94051473800928, 4, 20, 140735780045572}}}} [09:35:03.856] send_ready_for_query = false [09:35:03.856] idle_in_transaction_timeout_enabled = false [09:35:03.856] idle_session_timeout_enabled = false [09:35:03.856] __func__ = "PostgresMain" [09:35:03.856] #24 0x0000558a0fc0a5f3 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:35:03.856] bsdata = [09:35:03.856] #25 0x0000558a0fabc345 in postmaster_child_launch (child_type=B_BACKEND, child_slot=20, startup_data=startup_data@entry=0x7fff9a2d421c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff9a2d4270) at ../src/backend/postmaster/launch_backend.c:274 [09:35:03.856] pid = [09:35:03.856] #26 0x0000558a0fac1340 in BackendStartup (client_sock=client_sock@entry=0x7fff9a2d4270) at ../src/backend/postmaster/postmaster.c:3377 [09:35:03.856] bn = 0x558a19c283f8 [09:35:03.856] pid = [09:35:03.856] startup_data = {canAcceptConnections = CAC_OK} [09:35:03.856] cac = [09:35:03.856] __func__ = "BackendStartup" [09:35:03.856] #27 0x0000558a0fac3219 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [09:35:03.856] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\022\203\305\016\212U\000\000hg\301\016\212U\000\000\300C-\232\377\177\000\000\270C-\232\377\177\000\000\225[\362\001\000\000\000\000\240t\b\330f\177\000\000+", '\000' , "\377\177\000\000\000\004\000\000\000\000\000\000h\206\265\330f\177\000\0000v\b\330f\177\000\000\340\202\265\330f\177\000\000\316)fR\000\000\000", __ss_align = 2586657792}, salen = 2}} [09:35:03.856] i = 0 [09:35:03.856] now = [09:35:03.856] last_lockfile_recheck_time = 1732527060 [09:35:03.856] last_touch_time = 1732527060 [09:35:03.856] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -670534096, events = 32614, fd = -659193120, user_data = 0x7c96e577}, {pos = -1708309440, events = 32767, fd = -659363256, user_data = 0xf}, {pos = -670534096, events = 32614, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -659193120, user_data = 0x7fff9a2d43b8}, {pos = -1708309568, events = 32767, fd = -659192216, user_data = 0x0}, {pos = 432012208, events = 21898, fd = -685016438, user_data = 0x558a19bffbb0}, {pos = 1, events = 21898, fd = 32768, user_data = 0xffffffff}, {pos = -685580256, events = 32614, fd = -663421024, user_data = 0x558a19c2b198}, {pos = 432189560, events = 21898, fd = 432198753, user_data = 0x7f66d8b34ebe}, {pos = 1, events = 0, fd = -659193120, user_data = 0x1ab}, {pos = 272932184, events = 21898, fd = 0, user_data = 0xec}, {pos = 432012208, events = 21898, fd = -659337538, user_data = 0x1}, {pos = 0, events = 0, fd = -685580256, user_data = 0x7f66d72f2e40 }, {pos = 16, events = 0, fd = -1708308432, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f66d8b371ba}, {pos = 0, events = 0, fd = -685052508, user_data = 0x0}, {pos = 279894432, events = 21898, fd = 2, user_data = 0x0}, {pos = 431759024, events = 21898, fd = 263861672, user_data = 0x558a19c32cc0}, {pos = 263865661, events = 21898, fd = 432221467, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -685546296, user_data = 0x7f66d729c880 }, {pos = -719209032, events = 32614, fd = -1708308240, user_data = 0x100007f00000002}, {pos = -685019385, events = 32614, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -683729824, events = 32614, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 1330015316, fd = 168440164, user_data = 0x35323337310a6174}, {pos = 909129522, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 432192608, events = 21898, fd = -685016438, user_data = 0xa}, {pos = 267294856, events = 21898, fd = 432204944, user_data = 0x7f66d72b576b}, {pos = -683746848, events = 32614, fd = -685108882, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x3c2331672550e900}, {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 = 0x558a19c2ae70}, {pos = 1, events = 0, fd = 432189240, user_data = 0x3}, {pos = 0, events = 0, fd = 20995, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 432012208, user_data = 0x7f66d72f3053 }, {pos = 432189240, events = 21898, fd = 1024, user_data = 0x7fff9a2d48f8}, {pos = 267378172, events = 21898, fd = 279958960, user_data = 0x558a0feec8b9 }, {pos = 432189040, events = 21898, fd = 432011760, user_data = 0x558a19c2ae70}, {pos = -685025429, events = 32614, fd = 0, user_data = 0x558a0fefe523 }, {pos = 432189040, events = 1, fd = 267380332, user_data = 0x558a19bff9f0}, {pos = 626059520, events = 1008939367, fd = 0, user_data = 0x7f66d72a2ab1}, {pos = -685107984, events = 32614, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 431759024, user_data = 0x3c2331672550e900}, {pos = 0, events = 0, fd = 626059520, user_data = 0xc}, {pos = 626059520, events = 1008939367, fd = 0, user_data = 0x7f66d725b239 }, {pos = 237, events = 0, fd = 262914114, user_data = 0x400000}, {pos = 0, events = 0, fd = 431759024, user_data = 0x558a0feec74d }, {pos = 431845664, events = 21898, fd = 432011760, user_data = 0x558a19bd7120}, {pos = 1, events = 0, fd = 0, user_data = 0x558a0feab14a }, {pos = 12, events = 0, fd = 432188616, user_data = 0x558a19c2aca8}, {pos = 279895840, events = 21898, fd = 296, user_data = 0x558a0fabe85c }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 262930585, events = 21898, fd = 276328912, user_data = 0x558a19c003c8}} [09:35:03.857] nevents = 1 [09:35:03.857] __func__ = "ServerLoop" [09:35:03.857] #28 0x0000558a0fac4aaa in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x558a19bbdd70) at ../src/backend/postmaster/postmaster.c:1361 [09:35:03.857] opt = [09:35:03.857] status = [09:35:03.857] userDoption = [09:35:03.857] listen_addr_saved = false [09:35:03.857] output_config_variable = [09:35:03.857] __func__ = "PostmasterMain" [09:35:03.857] #29 0x0000558a0f8f277a in main (argc=8, argv=0x558a19bbdd70) at ../src/backend/main/main.c:196 [09:35:03.857] do_check_root = [09:35:03.893] -e [09:35:03.893] [09:35:03.893] [09:35:03.955] dumping /tmp/cores/postgres-6-23484.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:35:04.196] [New LWP 23484] [09:35:04.196] [09:35:04.196] This GDB supports auto-downloading debuginfo from the following URLs: [09:35:04.196] [09:35:04.196] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:35:04.196] Debuginfod has been disabled. [09:35:04.196] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:35:04.297] [Thread debugging using libthread_db enabled] [09:35:04.297] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:35:04.297] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [09:35:04.297] Program terminated with signal SIGABRT, Aborted. [09:35:04.297] #0 0x00007f66d72a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:05.250] [09:35:05.250] Thread 1 (Thread 0x7f66d521bf00 (LWP 23484)): [09:35:05.250] #0 0x00007f66d72a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:05.250] No symbol table info available. [09:35:05.250] #1 0x00007f66d725afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:05.250] No symbol table info available. [09:35:05.250] #2 0x00007f66d7245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:05.250] No symbol table info available. [09:35:05.250] #3 0x00007f66d741e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [09:35:05.250] No locals. [09:35:05.250] #4 0x00007f66d742aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [09:35:05.250] No locals. [09:35:05.250] #5 0x00007f66d740dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x558a107007a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [09:35:05.250] bp = 140735780042560 [09:35:05.250] pc = [09:35:05.250] Opts = {FromUnrecoverableHandler = true, pc = 94051455728895, bp = 94051628050352} [09:35:05.250] #6 0x0000558a0f9bfcff in examine_self_contradictory_rels (root=root@entry=0x558a19e0ab48, rel=rel@entry=0x558a19db0678, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [09:35:05.250] lc__state = [09:35:05.250] rlist = [09:35:05.250] i = 2 [09:35:05.250] br = [09:35:05.250] expression = [09:35:05.250] or_rinfo = 0x558a19e17988 [09:35:05.250] ccxt = [09:35:05.250] delidx = 0x558a19e17681 [09:35:05.250] arglst = [09:35:05.250] lc = [09:35:05.250] arg = [09:35:05.250] n = [09:35:05.250] restrictinfo = [09:35:05.250] ccwapper = {clausecxt = 0x558a19e16ff8} [09:35:05.250] sec = {sopcinfo = {n_members = 38, opcies = 0x558a19e16ac8}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x558a19e16460, atop_set = 0x558a19e16ed8}, ccfree = 0x558a19e17600, vifree = 0x558a19e17098} [09:35:05.250] __func__ = "examine_self_contradictory_rels" [09:35:05.250] #7 0x0000558a0f9bff0e in examine_self_contradictory_rels_phase1 (root=root@entry=0x558a19e0ab48) at ../src/backend/optimizer/plan/contradictory.c:2608 [09:35:05.250] rel = 0x558a19db0678 [09:35:05.250] rti = 1 [09:35:05.250] rinfo = [09:35:05.250] #8 0x0000558a0f98a9eb in query_planner (root=root@entry=0x558a19e0ab48, qp_callback=qp_callback@entry=0x558a0f98fd08 , qp_extra=qp_extra@entry=0x7fff9a2d3940) at ../src/backend/optimizer/plan/planmain.c:190 [09:35:05.250] parse = 0x558a19c00f70 [09:35:05.250] joinlist = 0x558a19e164d0 [09:35:05.250] final_rel = [09:35:05.250] __func__ = "query_planner" [09:35:05.250] #9 0x0000558a0f99d943 in grouping_planner (root=root@entry=0x558a19e0ab48, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1574 [09:35:05.250] sort_input_targets = 0x5 [09:35:05.250] sort_input_target_parallel_safe = [09:35:05.250] grouping_target = [09:35:05.250] scanjoin_target = [09:35:05.250] activeWindows = 0x0 [09:35:05.250] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [09:35:05.250] sort_input_targets_contain_srfs = 0x1 [09:35:05.250] have_grouping = [09:35:05.250] wflists = 0x0 [09:35:05.250] gset_data = 0x0 [09:35:05.250] sort_input_target = [09:35:05.250] grouping_targets = 0x1 [09:35:05.250] grouping_target_parallel_safe = [09:35:05.250] scanjoin_targets = 0x0 [09:35:05.250] scanjoin_target_parallel_safe = [09:35:05.250] grouping_targets_contain_srfs = 0x1 [09:35:05.250] scanjoin_targets_contain_srfs = 0x558a0feffcd3 [09:35:05.250] scanjoin_target_same_exprs = [09:35:05.250] parse = 0x558a19c00f70 [09:35:05.250] offset_est = 0 [09:35:05.250] count_est = 0 [09:35:05.250] limit_tuples = -1 [09:35:05.250] have_postponed_srfs = false [09:35:05.250] final_target = [09:35:05.250] final_targets = 0x558a19e20068 [09:35:05.250] final_targets_contain_srfs = 0x558a0f8fc688 [09:35:05.250] final_target_parallel_safe = [09:35:05.250] current_rel = [09:35:05.250] final_rel = [09:35:05.250] extra = {limit_needed = false, limit_tuples = 4.6467592809915586e-310, count_est = 94051628047768, offset_est = 94051628047768} [09:35:05.250] lc = [09:35:05.250] __func__ = "grouping_planner" [09:35:05.250] #10 0x0000558a0f9a08c7 in subquery_planner (glob=glob@entry=0x558a19db0568, parse=parse@entry=0x558a19c00f70, 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:1143 [09:35:05.250] root = 0x558a19e0ab48 [09:35:05.250] newWithCheckOptions = [09:35:05.250] newHaving = 0x0 [09:35:05.250] hasOuterJoins = [09:35:05.250] hasResultRTEs = false [09:35:05.250] final_rel = [09:35:05.250] l = 0x0 [09:35:05.250] #11 0x0000558a0f9a1558 in standard_planner (parse=0x558a19c00f70, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:417 [09:35:05.250] result = [09:35:05.250] glob = 0x558a19db0568 [09:35:05.250] tuple_fraction = 0 [09:35:05.250] root = [09:35:05.250] final_rel = [09:35:05.250] best_path = [09:35:05.250] top_plan = [09:35:05.250] lp = [09:35:05.250] lr = [09:35:05.250] #12 0x0000558a0f9a25c2 in planner (parse=parse@entry=0x558a19c00f70, query_string=query_string@entry=0x558a19bffaf0 "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:284 [09:35:05.250] result = [09:35:05.250] #13 0x0000558a0fc10f23 in pg_plan_query (querytree=querytree@entry=0x558a19c00f70, query_string=query_string@entry=0x558a19bffaf0 "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:911 [09:35:05.250] plan = [09:35:05.250] #14 0x0000558a0f718329 in standard_ExplainOneQuery (query=0x558a19c00f70, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x558a19e140f8, queryString=0x558a19bffaf0 "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:496 [09:35:05.250] plan = [09:35:05.250] planstart = [09:35:05.250] planduration = {ticks = 94051454906284} [09:35:05.250] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94051461147081, shared_blks_dirtied = 2586655790, shared_blks_written = 3, local_blks_hit = 4726984288, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94051625865072, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94051461233875}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94051454903665}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94051625865072}} [09:35:05.250] bufusage = {shared_blks_hit = 0, shared_blks_read = 94051457923051, shared_blks_dirtied = 133174050963456, shared_blks_written = 72057594037927936, local_blks_hit = 140079475931624, local_blks_read = 94051625866248, local_blks_dirtied = 94051625865072, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94051460762757, shared_blk_read_time = {ticks = 140079475931624}, shared_blk_write_time = {ticks = 94051460762776}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94051461142664}, temp_blk_read_time = {ticks = 94051628039600}, temp_blk_write_time = {ticks = 64}} [09:35:05.250] mem_counters = {nblocks = 94051627631816, freechunks = 4294967297, totalspace = 140735780043696, freespace = 10} [09:35:05.250] planner_ctx = 0x0 [09:35:05.250] saved_ctx = 0x0 [09:35:05.250] #15 0x0000558a0f71860f in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x558a19e140f8, pstate=pstate@entry=0x558a19e13fe8, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [09:35:05.250] No locals. [09:35:05.250] #16 0x0000558a0f71950f in ExplainQuery (pstate=pstate@entry=0x558a19e13fe8, stmt=stmt@entry=0x558a19c00db0, params=params@entry=0x0, dest=dest@entry=0x558a19e13f58) at ../src/backend/commands/explain.c:350 [09:35:05.250] l__state = [09:35:05.250] l = 0x558a19db0530 [09:35:05.250] es = 0x558a19e140f8 [09:35:05.250] tstate = [09:35:05.250] jstate = [09:35:05.250] query = [09:35:05.250] rewritten = 0x558a19db0518 [09:35:05.250] lc = 0x0 [09:35:05.250] timing_set = false [09:35:05.250] summary_set = false [09:35:05.250] __func__ = "ExplainQuery" [09:35:05.250] #17 0x0000558a0fc1bb05 in standard_ProcessUtility (pstmt=0x558a19c00e60, queryString=0x558a19bffaf0 "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=0x558a19e13f58, qc=0x7fff9a2d3e30) at ../src/backend/tcop/utility.c:866 [09:35:05.250] parsetree = 0x558a19c00db0 [09:35:05.250] isTopLevel = true [09:35:05.250] isAtomicContext = false [09:35:05.250] pstate = 0x558a19e13fe8 [09:35:05.250] readonly_flags = [09:35:05.250] __func__ = "standard_ProcessUtility" [09:35:05.250] #18 0x0000558a0fc1c22e in ProcessUtility (pstmt=pstmt@entry=0x558a19c00e60, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x558a19e13f58, qc=0x7fff9a2d3e30) at ../src/backend/tcop/utility.c:523 [09:35:05.250] No locals. [09:35:05.250] #19 0x0000558a0fc17a9a in PortalRunUtility (portal=portal@entry=0x558a19c84100, pstmt=0x558a19c00e60, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x558a19e13f58, qc=qc@entry=0x7fff9a2d3e30) at ../src/backend/tcop/pquery.c:1158 [09:35:05.250] No locals. [09:35:05.250] #20 0x0000558a0fc1830d in FillPortalStore (portal=portal@entry=0x558a19c84100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [09:35:05.250] treceiver = 0x558a19e13f58 [09:35:05.250] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:35:05.250] __func__ = "FillPortalStore" [09:35:05.250] #21 0x0000558a0fc18901 in PortalRun (portal=portal@entry=0x558a19c84100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x558a19e20348, altdest=altdest@entry=0x558a19e20348, qc=0x7fff9a2d4010) at ../src/backend/tcop/pquery.c:763 [09:35:05.250] _save_exception_stack = 0x7fff9a2d40c0 [09:35:05.250] _save_context_stack = 0x0 [09:35:05.250] _local_sigjmp_buf = {{__jmpbuf = {0, -8272673008256682353, 94051626402048, 94051625864744, 94051626402048, 94051625864672, -2748734931039029617, -8272650730461464945}, __mask_was_saved = 0, __saved_mask = {__val = {94051461142664, 94051625859568, 112, 4, 94051461147081, 2586656671, 4, 94051625864672, 112, 153, 94051626402048, 94051625864744, 94051625864720, 94051625864672, 94051461234284, 1}}}} [09:35:05.250] _do_rethrow = [09:35:05.250] result = [09:35:05.250] nprocessed = [09:35:05.250] saveTopTransactionResourceOwner = 0x558a19c3f708 [09:35:05.250] saveTopTransactionContext = 0x558a19c96530 [09:35:05.250] saveActivePortal = 0x0 [09:35:05.250] saveResourceOwner = 0x558a19c3f708 [09:35:05.250] savePortalContext = 0x0 [09:35:05.250] saveMemoryContext = 0x558a19c96530 [09:35:05.250] __func__ = "PortalRun" [09:35:05.250] #22 0x0000558a0fc119f9 in exec_simple_query (query_string=query_string@entry=0x558a19bffaf0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');") at ../src/backend/tcop/postgres.c:1283 [09:35:05.250] cmdtaglen = 7 [09:35:05.250] snapshot_set = [09:35:05.250] per_parsetree_context = 0x0 [09:35:05.250] plantree_list = 0x558a19e202f8 [09:35:05.250] parsetree = 0x558a19c00de0 [09:35:05.250] commandTag = [09:35:05.250] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:35:05.250] querytree_list = [09:35:05.250] portal = 0x558a19c84100 [09:35:05.250] receiver = 0x558a19e20348 [09:35:05.250] format = 0 [09:35:05.250] cmdtagname = [09:35:05.250] parsetree_item__state = [09:35:05.250] dest = DestRemote [09:35:05.250] oldcontext = 0x558a19c96530 [09:35:05.250] parsetree_list = 0x558a19c00e10 [09:35:05.250] parsetree_item = 0x558a19c00e28 [09:35:05.250] save_log_statement_stats = false [09:35:05.250] was_logged = false [09:35:05.250] use_implicit_block = false [09:35:05.250] msec_str = "\004\000\000\000\000\000\000\000W\306\354\017\212U\000\000\240@-\232\377\177\000\000S\000\000\000\000\000\000" [09:35:05.250] __func__ = "exec_simple_query" [09:35:05.250] #23 0x0000558a0fc1477d in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [09:35:05.250] query_string = 0x558a19bffaf0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');" [09:35:05.250] firstchar = [09:35:05.250] input_message = {data = 0x558a19bffaf0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", len = 83, maxlen = 1024, cursor = 83} [09:35:05.250] local_sigjmp_buf = {{__jmpbuf = {94051473806840, -8272658275083356529, 140735780045340, 4, 13, 140735780045572, -2748734933408811377, -8272650734424820081}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94051625590288, 15616, 94051473800928, 94051626122608, 13, 94051461146629, 0, 9, 2, 94051473806848, 94051625590288, 94051473800928, 4, 13, 140735780045572}}}} [09:35:05.250] send_ready_for_query = false [09:35:05.250] idle_in_transaction_timeout_enabled = false [09:35:05.250] idle_session_timeout_enabled = false [09:35:05.250] __func__ = "PostgresMain" [09:35:05.250] #24 0x0000558a0fc0a5f3 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:35:05.250] bsdata = [09:35:05.250] #25 0x0000558a0fabc345 in postmaster_child_launch (child_type=B_BACKEND, child_slot=13, startup_data=startup_data@entry=0x7fff9a2d421c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff9a2d4270) at ../src/backend/postmaster/launch_backend.c:274 [09:35:05.250] pid = [09:35:05.250] #26 0x0000558a0fac1340 in BackendStartup (client_sock=client_sock@entry=0x7fff9a2d4270) at ../src/backend/postmaster/postmaster.c:3377 [09:35:05.250] bn = 0x558a19c282a8 [09:35:05.250] pid = [09:35:05.250] startup_data = {canAcceptConnections = CAC_OK} [09:35:05.250] cac = [09:35:05.250] __func__ = "BackendStartup" [09:35:05.250] #27 0x0000558a0fac3219 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [09:35:05.250] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\022\203\305\016\212U\000\000hg\301\016\212U\000\000\300C-\232\377\177\000\000\270C-\232\377\177\000\000\225[\362\001\000\000\000\000\240t\b\330f\177\000\000+", '\000' , "\377\177\000\000\000\004\000\000\000\000\000\000h\206\265\330f\177\000\0000v\b\330f\177\000\000\340\202\265\330f\177\000\000\316)fR\000\000\000", __ss_align = 2586657792}, salen = 2}} [09:35:05.250] i = 0 [09:35:05.250] now = [09:35:05.250] last_lockfile_recheck_time = 1732527060 [09:35:05.250] last_touch_time = 1732527060 [09:35:05.250] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -670534096, events = 32614, fd = -659193120, user_data = 0x7c96e577}, {pos = -1708309440, events = 32767, fd = -659363256, user_data = 0xf}, {pos = -670534096, events = 32614, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -659193120, user_data = 0x7fff9a2d43b8}, {pos = -1708309568, events = 32767, fd = -659192216, user_data = 0x0}, {pos = 432012208, events = 21898, fd = -685016438, user_data = 0x558a19bffbb0}, {pos = 1, events = 21898, fd = 32768, user_data = 0xffffffff}, {pos = -685580256, events = 32614, fd = -663421024, user_data = 0x558a19c2b198}, {pos = 432189560, events = 21898, fd = 432198753, user_data = 0x7f66d8b34ebe}, {pos = 1, events = 0, fd = -659193120, user_data = 0x1ab}, {pos = 272932184, events = 21898, fd = 0, user_data = 0xec}, {pos = 432012208, events = 21898, fd = -659337538, user_data = 0x1}, {pos = 0, events = 0, fd = -685580256, user_data = 0x7f66d72f2e40 }, {pos = 16, events = 0, fd = -1708308432, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f66d8b371ba}, {pos = 0, events = 0, fd = -685052508, user_data = 0x0}, {pos = 279894432, events = 21898, fd = 2, user_data = 0x0}, {pos = 431759024, events = 21898, fd = 263861672, user_data = 0x558a19c32cc0}, {pos = 263865661, events = 21898, fd = 432221467, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -685546296, user_data = 0x7f66d729c880 }, {pos = -719209032, events = 32614, fd = -1708308240, user_data = 0x100007f00000002}, {pos = -685019385, events = 32614, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -683729824, events = 32614, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 1330015316, fd = 168440164, user_data = 0x35323337310a6174}, {pos = 909129522, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 432192608, events = 21898, fd = -685016438, user_data = 0xa}, {pos = 267294856, events = 21898, fd = 432204944, user_data = 0x7f66d72b576b}, {pos = -683746848, events = 32614, fd = -685108882, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x3c2331672550e900}, {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 = 0x558a19c2ae70}, {pos = 1, events = 0, fd = 432189240, user_data = 0x3}, {pos = 0, events = 0, fd = 20995, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 432012208, user_data = 0x7f66d72f3053 }, {pos = 432189240, events = 21898, fd = 1024, user_data = 0x7fff9a2d48f8}, {pos = 267378172, events = 21898, fd = 279958960, user_data = 0x558a0feec8b9 }, {pos = 432189040, events = 21898, fd = 432011760, user_data = 0x558a19c2ae70}, {pos = -685025429, events = 32614, fd = 0, user_data = 0x558a0fefe523 }, {pos = 432189040, events = 1, fd = 267380332, user_data = 0x558a19bff9f0}, {pos = 626059520, events = 1008939367, fd = 0, user_data = 0x7f66d72a2ab1}, {pos = -685107984, events = 32614, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 431759024, user_data = 0x3c2331672550e900}, {pos = 0, events = 0, fd = 626059520, user_data = 0xc}, {pos = 626059520, events = 1008939367, fd = 0, user_data = 0x7f66d725b239 }, {pos = 237, events = 0, fd = 262914114, user_data = 0x400000}, {pos = 0, events = 0, fd = 431759024, user_data = 0x558a0feec74d }, {pos = 431845664, events = 21898, fd = 432011760, user_data = 0x558a19bd7120}, {pos = 1, events = 0, fd = 0, user_data = 0x558a0feab14a }, {pos = 12, events = 0, fd = 432188616, user_data = 0x558a19c2aca8}, {pos = 279895840, events = 21898, fd = 296, user_data = 0x558a0fabe85c }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 262930585, events = 21898, fd = 276328912, user_data = 0x558a19c003c8}} [09:35:05.250] nevents = 1 [09:35:05.250] __func__ = "ServerLoop" [09:35:05.250] #28 0x0000558a0fac4aaa in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x558a19bbdd70) at ../src/backend/postmaster/postmaster.c:1361 [09:35:05.250] opt = [09:35:05.250] status = [09:35:05.250] userDoption = [09:35:05.250] listen_addr_saved = false [09:35:05.250] output_config_variable = [09:35:05.250] __func__ = "PostmasterMain" [09:35:05.250] #29 0x0000558a0f8f277a in main (argc=8, argv=0x558a19bbdd70) at ../src/backend/main/main.c:196 [09:35:05.250] do_check_root = [09:35:05.286] -e [09:35:05.286] [09:35:05.286] [09:35:05.369] dumping /tmp/cores/postgres-6-29295.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:35:05.615] [New LWP 29295] [09:35:05.615] [09:35:05.615] This GDB supports auto-downloading debuginfo from the following URLs: [09:35:05.615] [09:35:05.615] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:35:05.615] Debuginfod has been disabled. [09:35:05.615] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:35:05.852] [Thread debugging using libthread_db enabled] [09:35:05.852] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:35:05.852] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN '. [09:35:05.852] Program terminated with signal SIGABRT, Aborted. [09:35:05.852] #0 0x00007f38498a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:06.838] [09:35:06.838] Thread 1 (Thread 0x7f384a687f00 (LWP 29295)): [09:35:06.838] #0 0x00007f38498a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:06.838] No symbol table info available. [09:35:06.838] #1 0x00007f384985afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:06.838] No symbol table info available. [09:35:06.838] #2 0x00007f3849845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:06.838] No symbol table info available. [09:35:06.838] #3 0x00007f3849a1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [09:35:06.838] No locals. [09:35:06.838] #4 0x00007f3849a2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [09:35:06.838] No locals. [09:35:06.838] #5 0x00007f3849a0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5635bc7577a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [09:35:06.838] bp = 140729309546576 [09:35:06.838] pc = [09:35:06.838] Opts = {FromUnrecoverableHandler = true, pc = 94788781174015, bp = 94788881926600} [09:35:06.838] #6 0x00005635bba16cff in examine_self_contradictory_rels (root=root@entry=0x5635c187e368, rel=rel@entry=0x5635c192d1b8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [09:35:06.838] lc__state = [09:35:06.838] rlist = [09:35:06.838] i = 2 [09:35:06.838] br = [09:35:06.838] expression = [09:35:06.838] or_rinfo = 0x5635c1a2d718 [09:35:06.838] ccxt = [09:35:06.838] delidx = 0x5635c1a2d5b1 [09:35:06.838] arglst = [09:35:06.838] lc = [09:35:06.838] arg = [09:35:06.838] n = [09:35:06.838] restrictinfo = [09:35:06.838] ccwapper = {clausecxt = 0x5635c1a2cf48} [09:35:06.838] sec = {sopcinfo = {n_members = 38, opcies = 0x5635c1a2ca18}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x5635c1a2c0b8, atop_set = 0x5635c1a2ce28}, ccfree = 0x5635c1a2d580, vifree = 0x5635c1a2d0b8} [09:35:06.838] __func__ = "examine_self_contradictory_rels" [09:35:06.838] #7 0x00005635bba16f0e in examine_self_contradictory_rels_phase1 (root=root@entry=0x5635c187e368) at ../src/backend/optimizer/plan/contradictory.c:2608 [09:35:06.838] rel = 0x5635c192d1b8 [09:35:06.838] rti = 1 [09:35:06.838] rinfo = [09:35:06.838] #8 0x00005635bb9e19eb in query_planner (root=root@entry=0x5635c187e368, qp_callback=qp_callback@entry=0x5635bb9e6d08 , qp_extra=qp_extra@entry=0x7ffe18814a50) at ../src/backend/optimizer/plan/planmain.c:190 [09:35:06.838] parse = 0x5635c170cd38 [09:35:06.838] joinlist = 0x5635c1a2c128 [09:35:06.838] final_rel = [09:35:06.838] __func__ = "query_planner" [09:35:06.838] #9 0x00005635bb9f4943 in grouping_planner (root=root@entry=0x5635c187e368, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1574 [09:35:06.838] sort_input_targets = 0x5 [09:35:06.838] sort_input_target_parallel_safe = [09:35:06.838] grouping_target = [09:35:06.838] scanjoin_target = [09:35:06.838] activeWindows = 0x0 [09:35:06.838] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [09:35:06.838] sort_input_targets_contain_srfs = 0x1 [09:35:06.838] have_grouping = [09:35:06.838] wflists = 0x0 [09:35:06.838] gset_data = 0x0 [09:35:06.838] sort_input_target = [09:35:06.838] grouping_targets = 0x1 [09:35:06.838] grouping_target_parallel_safe = [09:35:06.838] scanjoin_targets = 0x0 [09:35:06.838] scanjoin_target_parallel_safe = [09:35:06.838] grouping_targets_contain_srfs = 0x1 [09:35:06.838] scanjoin_targets_contain_srfs = 0x5635bbf56cd3 [09:35:06.838] scanjoin_target_same_exprs = [09:35:06.838] parse = 0x5635c170cd38 [09:35:06.838] offset_est = 0 [09:35:06.838] count_est = 0 [09:35:06.838] limit_tuples = -1 [09:35:06.838] have_postponed_srfs = false [09:35:06.838] final_target = [09:35:06.838] final_targets = 0x5635c1802b48 [09:35:06.838] final_targets_contain_srfs = 0x5635bb953688 [09:35:06.838] final_target_parallel_safe = [09:35:06.838] current_rel = [09:35:06.838] final_rel = [09:35:06.838] extra = {limit_needed = false, limit_tuples = 4.6831879982153983e-310, count_est = 94788880167384, offset_est = 94788880167384} [09:35:06.838] lc = [09:35:06.838] __func__ = "grouping_planner" [09:35:06.838] #10 0x00005635bb9f78c7 in subquery_planner (glob=glob@entry=0x5635c192d0a8, parse=parse@entry=0x5635c170cd38, 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:1143 [09:35:06.838] root = 0x5635c187e368 [09:35:06.838] newWithCheckOptions = [09:35:06.838] newHaving = 0x0 [09:35:06.838] hasOuterJoins = [09:35:06.838] hasResultRTEs = false [09:35:06.838] final_rel = [09:35:06.838] l = 0x0 [09:35:06.838] #11 0x00005635bb9f8558 in standard_planner (parse=parse@entry=0x5635c170cd38, query_string=query_string@entry=0x5635c170ba90 "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:417 [09:35:06.838] result = [09:35:06.838] glob = 0x5635c192d0a8 [09:35:06.838] tuple_fraction = 0 [09:35:06.838] root = [09:35:06.838] final_rel = [09:35:06.838] best_path = [09:35:06.838] top_plan = [09:35:06.838] lp = [09:35:06.838] lr = [09:35:06.838] #12 0x00007f38478365b0 in pgss_planner (parse=0x5635c170cd38, query_string=0x5635c170ba90 "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 [09:35:06.838] _save_exception_stack = 0x7ffe188153d0 [09:35:06.838] _save_context_stack = 0x0 [09:35:06.838] _local_sigjmp_buf = {{__jmpbuf = {94788878650680, 9196180245762648812, 0, 2048, 94788878650680, 2048, 3173022152729668332, 3279861681766902508}, __mask_was_saved = 0, __saved_mask = {__val = {94788879145016, 94788879143040, 94788786077596, 0, 17022, 0, 0, 0, 288173936696, 17022, 0, 139879655811184, 139879655811120, 0, 0, 140729311033772}}}} [09:35:06.838] _do_rethrow = false [09:35:06.838] result = 0x5635c1925290 [09:35:06.838] #13 0x00005635bb9f95b8 in planner (parse=parse@entry=0x5635c170cd38, query_string=query_string@entry=0x5635c170ba90 "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:282 [09:35:06.838] result = [09:35:06.838] #14 0x00005635bbc67f23 in pg_plan_query (querytree=querytree@entry=0x5635c170cd38, query_string=query_string@entry=0x5635c170ba90 "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:911 [09:35:06.838] plan = [09:35:06.838] #15 0x00005635bb76f329 in standard_ExplainOneQuery (query=0x5635c170cd38, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5635c173c6b8, queryString=0x5635c170ba90 "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:496 [09:35:06.838] plan = [09:35:06.838] planstart = [09:35:06.838] planduration = {ticks = 94788780351404} [09:35:06.838] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94788786592201, shared_blks_dirtied = 411127934, shared_blks_written = 3, local_blks_hit = 7543237960, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94788878650680, shared_blk_read_time = {ticks = -7625875164108118144}, shared_blk_write_time = {ticks = 94788786678995}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94788780348785}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94788878650680}} [09:35:06.838] bufusage = {shared_blks_hit = 0, shared_blks_read = 94788783368171, shared_blks_dirtied = 73108933328896, shared_blks_written = 72057594037927936, local_blks_hit = 139879655801360, local_blks_read = 94788878651856, local_blks_dirtied = 94788878650680, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94788786207877, shared_blk_read_time = {ticks = 139879655801360}, shared_blk_write_time = {ticks = 94788786207896}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94788786587784}, temp_blk_read_time = {ticks = 94788878844784}, temp_blk_write_time = {ticks = 64}} [09:35:06.838] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140729309548544, freespace = 10} [09:35:06.838] planner_ctx = 0x0 [09:35:06.838] saved_ctx = 0x0 [09:35:06.838] #16 0x00005635bb76f60f in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5635c173c6b8, pstate=pstate@entry=0x5635c173c5a8, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [09:35:06.838] No locals. [09:35:06.838] #17 0x00005635bb77050f in ExplainQuery (pstate=pstate@entry=0x5635c173c5a8, stmt=stmt@entry=0x5635c170cb78, params=params@entry=0x0, dest=dest@entry=0x5635c173c518) at ../src/backend/commands/explain.c:350 [09:35:06.838] l__state = [09:35:06.838] l = 0x5635c192d070 [09:35:06.838] es = 0x5635c173c6b8 [09:35:06.838] tstate = [09:35:06.838] jstate = [09:35:06.838] query = [09:35:06.838] rewritten = 0x5635c192d058 [09:35:06.838] lc = 0x0 [09:35:06.838] timing_set = false [09:35:06.838] summary_set = false [09:35:06.838] __func__ = "ExplainQuery" [09:35:06.838] #18 0x00005635bbc72b05 in standard_ProcessUtility (pstmt=pstmt@entry=0x5635c170cc28, queryString=queryString@entry=0x5635c170ba90 "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=0x5635c173c518, qc=0x7ffe18815610) at ../src/backend/tcop/utility.c:866 [09:35:06.838] parsetree = 0x5635c170cb78 [09:35:06.838] isTopLevel = true [09:35:06.838] isAtomicContext = false [09:35:06.838] pstate = 0x5635c173c5a8 [09:35:06.838] readonly_flags = [09:35:06.838] __func__ = "standard_ProcessUtility" [09:35:06.838] #19 0x00007f3847835d9d in pgss_ProcessUtility (pstmt=0x5635c170cc28, queryString=0x5635c170ba90 "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=0x5635c173c518, qc=0x7ffe18815610) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [09:35:06.838] _save_exception_stack = 0x7ffe188156b0 [09:35:06.838] _save_context_stack = 0x0 [09:35:06.838] _local_sigjmp_buf = {{__jmpbuf = {0, -3173656936683558164, 94788878650408, 94788878845208, 140729309550096, 1, 3173022152467524332, 3279861679920622316}, __mask_was_saved = 0, __saved_mask = {__val = {94788786592201, 3246403256, 0, 94788879660488, 94788786587784, 94788878645648, 11, 1, 94788786592201, 3246404376, 1, 94788878645648, 10, 94788879660072, 139879728771181, 1}}}} [09:35:06.838] _do_rethrow = false [09:35:06.838] duration = [09:35:06.838] bufusage = {shared_blks_hit = 94788878652408, shared_blks_read = 140729309549888, shared_blks_dirtied = 140729309549888, shared_blks_written = 0, local_blks_hit = 0, local_blks_read = 94788786679404, local_blks_dirtied = 0, local_blks_written = 94788878652408, temp_blks_read = 94788879657928, temp_blks_written = 94788879657928, shared_blk_read_time = {ticks = 94788879657848}, shared_blk_write_time = {ticks = 140729309549888}, local_blk_read_time = {ticks = 140729309549888}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94788781619686}} [09:35:06.838] walusage_start = {wal_records = 70, wal_fpi = 16, wal_bytes = 91725} [09:35:06.838] start = [09:35:06.838] rows = [09:35:06.838] bufusage_start = {shared_blks_hit = 1550, shared_blks_read = 256, shared_blks_dirtied = 20, shared_blks_written = 45, 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}} [09:35:06.838] walusage = {wal_records = 1, wal_fpi = 94788786070857, wal_bytes = 1} [09:35:06.838] parsetree = [09:35:06.838] saved_queryId = 12005976174521218929 [09:35:06.838] saved_stmt_location = 0 [09:35:06.838] saved_stmt_len = 108 [09:35:06.838] enabled = true [09:35:06.838] #20 0x00005635bbc73179 in ProcessUtility (pstmt=pstmt@entry=0x5635c170cc28, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5635c173c518, qc=0x7ffe18815610) at ../src/backend/tcop/utility.c:519 [09:35:06.838] No locals. [09:35:06.838] #21 0x00005635bbc6ea9a in PortalRunUtility (portal=portal@entry=0x5635c178f000, pstmt=0x5635c170cc28, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5635c173c518, qc=qc@entry=0x7ffe18815610) at ../src/backend/tcop/pquery.c:1158 [09:35:06.838] No locals. [09:35:06.838] #22 0x00005635bbc6f30d in FillPortalStore (portal=portal@entry=0x5635c178f000, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [09:35:06.838] treceiver = 0x5635c173c518 [09:35:06.838] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:35:06.838] __func__ = "FillPortalStore" [09:35:06.838] #23 0x00005635bbc6f901 in PortalRun (portal=portal@entry=0x5635c178f000, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5635c1803c98, altdest=altdest@entry=0x5635c1803c98, qc=0x7ffe188157f0) at ../src/backend/tcop/pquery.c:763 [09:35:06.838] _save_exception_stack = 0x7ffe188158a0 [09:35:06.838] _save_context_stack = 0x0 [09:35:06.838] _local_sigjmp_buf = {{__jmpbuf = {0, 9196179829218978540, 94788879183872, 94788878650352, 94788879183872, 94788878650280, 3173022152605936364, 9196227677525617388}, __mask_was_saved = 0, __saved_mask = {__val = {94788786587784, 94788878645648, 112, 4, 94788786592201, 411129727, 4, 94788878650280, 112, 153, 94788879183872, 94788878650352, 94788878650328, 94788878650280, 94788786679404, 1}}}} [09:35:06.838] _do_rethrow = [09:35:06.838] result = [09:35:06.838] nprocessed = [09:35:06.838] saveTopTransactionResourceOwner = 0x5635c174e4d8 [09:35:06.838] saveTopTransactionContext = 0x5635c17a1020 [09:35:06.838] saveActivePortal = 0x0 [09:35:06.838] saveResourceOwner = 0x5635c174e4d8 [09:35:06.838] savePortalContext = 0x0 [09:35:06.838] saveMemoryContext = 0x5635c17a1020 [09:35:06.838] __func__ = "PortalRun" [09:35:06.838] #24 0x00005635bbc689f9 in exec_simple_query (query_string=query_string@entry=0x5635c170ba90 "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:1283 [09:35:06.838] cmdtaglen = 7 [09:35:06.838] snapshot_set = [09:35:06.838] per_parsetree_context = 0x0 [09:35:06.838] plantree_list = 0x5635c1803c48 [09:35:06.838] parsetree = 0x5635c170cba8 [09:35:06.838] commandTag = [09:35:06.838] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:35:06.838] querytree_list = [09:35:06.838] portal = 0x5635c178f000 [09:35:06.838] receiver = 0x5635c1803c98 [09:35:06.838] format = 0 [09:35:06.838] cmdtagname = [09:35:06.838] parsetree_item__state = [09:35:06.838] dest = DestRemote [09:35:06.838] oldcontext = 0x5635c17a1020 [09:35:06.838] parsetree_list = 0x5635c170cbd8 [09:35:06.838] parsetree_item = 0x5635c170cbf0 [09:35:06.838] save_log_statement_stats = false [09:35:06.838] was_logged = true [09:35:06.838] use_implicit_block = false [09:35:06.838] msec_str = "\004\000\000\000\000\000\000\000W6\362\2735V\000\000\200X\201\030\376\177\000\000n\000\000\000\000\000\000" [09:35:06.838] __func__ = "exec_simple_query" [09:35:06.838] #25 0x00005635bbc6b77d in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [09:35:06.838] query_string = 0x5635c170ba90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [09:35:06.838] firstchar = [09:35:06.838] input_message = {data = 0x5635c170ba90 "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} [09:35:06.838] local_sigjmp_buf = {{__jmpbuf = {94788799251960, 9196243504035375852, 140729309551100, 4, 7, 140729309551332, 3173022152140368620, 9196227680013101804}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94788878903728, 0, 168, 94788786592303, 0, 10, 2, 94788799251968, 94788878376496, 94788799246048, 4, 7, 140729309551332}}}} [09:35:06.838] send_ready_for_query = false [09:35:06.838] idle_in_transaction_timeout_enabled = false [09:35:06.838] idle_session_timeout_enabled = false [09:35:06.838] __func__ = "PostgresMain" [09:35:06.838] #26 0x00005635bbc615f3 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:35:06.838] bsdata = [09:35:06.838] #27 0x00005635bbb13345 in postmaster_child_launch (child_type=B_BACKEND, child_slot=7, startup_data=startup_data@entry=0x7ffe188159fc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe18815a50) at ../src/backend/postmaster/launch_backend.c:274 [09:35:06.838] pid = [09:35:06.838] #28 0x00005635bbb18340 in BackendStartup (client_sock=client_sock@entry=0x7ffe18815a50) at ../src/backend/postmaster/postmaster.c:3377 [09:35:06.838] bn = 0x5635c1738218 [09:35:06.838] pid = [09:35:06.838] startup_data = {canAcceptConnections = CAC_OK} [09:35:06.838] cac = [09:35:06.838] __func__ = "BackendStartup" [09:35:06.838] #29 0x00005635bbb1a219 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [09:35:06.838] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\203I8\177\000\000\240\317\331J8\177\000\000\370Z\201\030\376\177\000\000\364Z\201\030\376\177", '\000' , "\022\363ʺ5V\000\000h\327ƺ5V\000\000\300[\201\030\376\177\000\000\270[\201\030\376\177\000\000\225[\362\001\000\000\000\000\260Zs\3015V\000\000,", '\000' , "5V\000\000 \362ʺ5V\000", __ss_align = 139879755605608}, salen = 2}} [09:35:06.838] i = 0 [09:35:06.838] now = [09:35:06.838] last_lockfile_recheck_time = 1732527091 [09:35:06.838] last_touch_time = 1732527091 [09:35:06.838] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x5635bacaf312}, {pos = 1260709480, events = 32568, fd = 1248388656, user_data = 0x7f384b24e2e0}, {pos = 2090263927, events = 0, fd = 411130944, user_data = 0x7f384b224a48}, {pos = 15, events = 0, fd = 1248388656, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f384b24e2e0}, {pos = 411130808, events = 32766, fd = 411130816, user_data = 0x7f384b24e668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = -1049573968, events = 22069, fd = 1, user_data = 0x7ffe188160e3}, {pos = -1, events = 0, fd = 1233313824, user_data = 0x7f384ad9cfa0}, {pos = -1049377128, events = 22069, fd = -1049377416, user_data = 0x5635c1742141}, {pos = 1260564158, events = 32568, fd = 1, user_data = 0x7f384b24e2e0}, {pos = 427, events = 0, fd = -1135997608, user_data = 0x0}, {pos = 86, events = 0, fd = -1049386744, user_data = 0x7f384b22aebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f384982e020}, {pos = 1234120256, events = 32568, fd = 16, user_data = 0x7ffe18816010}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1260573114, events = 32568, fd = 0, user_data = 0x7f38498aeda4 }, {pos = 0, events = 0, fd = -1129035360, user_data = 0x2}, {pos = 0, events = 0, fd = -1049829680, user_data = 0x5635bbbff176 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = -1049386744, user_data = 0x7f384b22aebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f38498364c8}, {pos = 1233874695, events = 32568, fd = -1128979200, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1235164256, events = 32568, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x735f3732305f742f}, {pos = 1634038388, events = 1701994349, fd = 1868785010, user_data = 0x7274735f3732302f}, {pos = 1248392512, events = 32568, fd = 1248393856, 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 = -1049347728, user_data = 0x7f38498b576b}, {pos = 1235147232, events = 32568, fd = 1233785198, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xe77e597deb38d600}, {pos = 1235150304, events = 32568, fd = -328, user_data = 0x0}, {pos = -1049377736, events = 22069, 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 = 28300, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1049386744, user_data = 0x7f38498f3053 }, {pos = -1049377736, events = 22069, fd = 1024, user_data = 0x7ffe188160d8}, {pos = -1141551620, events = 22069, fd = -1128970832, user_data = 0x5635bbf438b9 }, {pos = -1049377936, events = 22069, fd = -1049577072, user_data = 0x5635c173c370}, {pos = 1233868651, events = 32568, fd = 0, user_data = 0x5635bbf55523 }, {pos = -1049377936, events = 1, fd = -1141549460, user_data = 0x5635c170b990}, {pos = -348596736, events = 3883817341, fd = 0, user_data = 0x7f38498a2ab1}, {pos = 1233786096, events = 32568, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1049829680, user_data = 0xe77e597deb38d600}, {pos = 0, events = 0, fd = -348596736, user_data = 0xc}, {pos = -348596736, events = 3883817341, fd = 0, user_data = 0x7f384985b239 }, {pos = 87, events = 0, fd = -1146015678, user_data = 0x400000}, {pos = 0, events = 0, fd = -1049829680, user_data = 0x5635bbf4374d }, {pos = -1049743168, events = 22069, fd = -1049577072, user_data = 0x5635c16e30c0}, {pos = 1, events = 0, fd = 0, user_data = 0x5635bbf0214a }, {pos = 12, events = 0, fd = -1049390792, user_data = 0x5635c1739118}, {pos = -1129033952, events = 22069, fd = 296, user_data = 0x5635bbb1585c }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1145999207, events = 22069, fd = -1132600880, user_data = 0x5635c170c348}} [09:35:06.838] nevents = 1 [09:35:06.838] __func__ = "ServerLoop" [09:35:06.838] #30 0x00005635bbb1baaa in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5635c16c9d30) at ../src/backend/postmaster/postmaster.c:1361 [09:35:06.838] opt = [09:35:06.838] status = [09:35:06.838] userDoption = [09:35:06.838] listen_addr_saved = false [09:35:06.838] output_config_variable = [09:35:06.838] __func__ = "PostmasterMain" [09:35:06.838] #31 0x00005635bb94977a in main (argc=4, argv=0x5635c16c9d30) at ../src/backend/main/main.c:196 [09:35:06.838] do_check_root = [09:35:06.875] -e [09:35:06.875] [09:35:06.875] [09:35:06.940] dumping /tmp/cores/postgres-6-25955.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:35:07.192] [New LWP 25955] [09:35:07.192] [09:35:07.192] This GDB supports auto-downloading debuginfo from the following URLs: [09:35:07.192] [09:35:07.192] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:35:07.192] Debuginfod has been disabled. [09:35:07.192] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:35:07.290] [Thread debugging using libthread_db enabled] [09:35:07.290] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:35:07.290] Core was generated by `postgres: postgres regression [local] ALTER TABLE '. [09:35:07.290] Program terminated with signal SIGABRT, Aborted. [09:35:07.290] #0 0x00007f66d72a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:08.289] [09:35:08.289] Thread 1 (Thread 0x7f66d521bf00 (LWP 25955)): [09:35:08.289] #0 0x00007f66d72a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:08.289] No symbol table info available. [09:35:08.289] #1 0x00007f66d725afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:08.289] No symbol table info available. [09:35:08.289] #2 0x00007f66d7245472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:08.289] No symbol table info available. [09:35:08.289] #3 0x00007f66d741e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [09:35:08.289] No locals. [09:35:08.289] #4 0x00007f66d742aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [09:35:08.289] No locals. [09:35:08.289] #5 0x00007f66d740dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x558a107007a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [09:35:08.289] bp = 140735780039392 [09:35:08.289] pc = [09:35:08.289] Opts = {FromUnrecoverableHandler = true, pc = 94051455728895, bp = 94051629370712} [09:35:08.289] #6 0x0000558a0f9bfcff in examine_self_contradictory_rels (root=root@entry=0x558a19dff098, rel=rel@entry=0x558a19f577b8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [09:35:08.289] lc__state = [09:35:08.289] rlist = [09:35:08.289] i = 4 [09:35:08.289] br = [09:35:08.289] expression = [09:35:08.289] or_rinfo = 0x558a19f5ad50 [09:35:08.289] ccxt = [09:35:08.289] delidx = 0x558a19f5ad39 [09:35:08.289] arglst = [09:35:08.289] lc = [09:35:08.289] arg = [09:35:08.289] n = [09:35:08.289] restrictinfo = [09:35:08.289] ccwapper = {clausecxt = 0x558a19f5a858} [09:35:08.289] sec = {sopcinfo = {n_members = 38, opcies = 0x558a19f59f18}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x558a19f59ab8, atop_set = 0x558a19f5a328}, ccfree = 0x558a19f5ad08, vifree = 0x558a19f5a3c8} [09:35:08.289] __func__ = "examine_self_contradictory_rels" [09:35:08.289] #7 0x0000558a0f9bff0e in examine_self_contradictory_rels_phase1 (root=root@entry=0x558a19dff098) at ../src/backend/optimizer/plan/contradictory.c:2608 [09:35:08.289] rel = 0x558a19f577b8 [09:35:08.289] rti = 2 [09:35:08.289] rinfo = [09:35:08.289] #8 0x0000558a0f98a9eb in query_planner (root=root@entry=0x558a19dff098, qp_callback=qp_callback@entry=0x558a0f98fd08 , qp_extra=qp_extra@entry=0x7fff9a2d2ce0) at ../src/backend/optimizer/plan/planmain.c:190 [09:35:08.289] parse = 0x558a19dfd7f0 [09:35:08.289] joinlist = 0x558a19f585e8 [09:35:08.289] final_rel = [09:35:08.289] __func__ = "query_planner" [09:35:08.289] #9 0x0000558a0f99d943 in grouping_planner (root=root@entry=0x558a19dff098, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1574 [09:35:08.289] sort_input_targets = 0x558a19f49508 [09:35:08.289] sort_input_target_parallel_safe = [09:35:08.289] grouping_target = [09:35:08.289] scanjoin_target = [09:35:08.289] activeWindows = 0x0 [09:35:08.289] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [09:35:08.289] sort_input_targets_contain_srfs = 0x5 [09:35:08.289] have_grouping = [09:35:08.289] wflists = 0x0 [09:35:08.289] gset_data = 0x0 [09:35:08.289] sort_input_target = [09:35:08.289] grouping_targets = 0x0 [09:35:08.289] grouping_target_parallel_safe = [09:35:08.289] scanjoin_targets = 0x558a19dff098 [09:35:08.289] scanjoin_target_parallel_safe = [09:35:08.289] grouping_targets_contain_srfs = 0x558a19f49718 [09:35:08.289] scanjoin_targets_contain_srfs = 0x0 [09:35:08.289] scanjoin_target_same_exprs = [09:35:08.289] parse = 0x558a19dfd7f0 [09:35:08.289] offset_est = 0 [09:35:08.289] count_est = 0 [09:35:08.289] limit_tuples = -1 [09:35:08.289] have_postponed_srfs = false [09:35:08.289] final_target = [09:35:08.289] final_targets = 0x558a19dfe380 [09:35:08.289] final_targets_contain_srfs = 0x558a0f9de538 [09:35:08.289] final_target_parallel_safe = [09:35:08.289] current_rel = [09:35:08.289] final_rel = [09:35:08.289] extra = {limit_needed = 216, limit_tuples = 4.6467678307675701e-310, count_est = 94051629307672, offset_est = 94051627954328} [09:35:08.289] lc = [09:35:08.289] __func__ = "grouping_planner" [09:35:08.289] #10 0x0000558a0f9a08c7 in subquery_planner (glob=glob@entry=0x558a19dfef88, parse=parse@entry=0x558a19dfd7f0, 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:1143 [09:35:08.289] root = 0x558a19dff098 [09:35:08.289] newWithCheckOptions = [09:35:08.289] newHaving = 0x0 [09:35:08.289] hasOuterJoins = [09:35:08.289] hasResultRTEs = false [09:35:08.289] final_rel = [09:35:08.289] l = 0x0 [09:35:08.289] #11 0x0000558a0f9a1558 in standard_planner (parse=0x558a19dfd7f0, query_string=, cursorOptions=0, boundParams=) at ../src/backend/optimizer/plan/planner.c:417 [09:35:08.289] result = [09:35:08.289] glob = 0x558a19dfef88 [09:35:08.289] tuple_fraction = 0 [09:35:08.289] root = [09:35:08.289] final_rel = [09:35:08.289] best_path = [09:35:08.289] top_plan = [09:35:08.289] lp = [09:35:08.289] lr = [09:35:08.289] #12 0x0000558a0f9a25c2 in planner (parse=parse@entry=0x558a19dfd7f0, query_string=query_string@entry=0x558a19f24b18 "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:284 [09:35:08.289] result = [09:35:08.289] #13 0x0000558a0fc10f23 in pg_plan_query (querytree=querytree@entry=0x558a19dfd7f0, query_string=query_string@entry=0x558a19f24b18 "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:911 [09:35:08.289] plan = [09:35:08.289] #14 0x0000558a0fc11304 in pg_plan_queries (querytrees=querytrees@entry=0x558a19dfd7a0, query_string=0x558a19f24b18 "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:1005 [09:35:08.289] query = 0x558a19dfd7f0 [09:35:08.289] stmt = [09:35:08.289] query_list__state = [09:35:08.289] stmt_list = 0x0 [09:35:08.289] query_list = [09:35:08.289] #15 0x0000558a0fe81645 in BuildCachedPlan (plansource=plansource@entry=0x558a19f23be0, qlist=0x558a19dfd7a0, qlist@entry=0x0, boundParams=boundParams@entry=0x0, queryEnv=queryEnv@entry=0x0) at ../src/backend/utils/cache/plancache.c:962 [09:35:08.289] plan = [09:35:08.289] plist = [09:35:08.289] snapshot_set = false [09:35:08.289] is_transient = [09:35:08.289] plan_context = [09:35:08.289] oldcxt = 0x558a19dfd6a0 [09:35:08.289] lc = [09:35:08.289] #16 0x0000558a0fe81f64 in GetCachedPlan (plansource=plansource@entry=0x558a19f23be0, boundParams=0x0, owner=owner@entry=0x0, queryEnv=0x0) at ../src/backend/utils/cache/plancache.c:1199 [09:35:08.289] plan = 0x0 [09:35:08.289] qlist = 0x0 [09:35:08.289] customplan = false [09:35:08.289] __func__ = "GetCachedPlan" [09:35:08.289] #17 0x0000558a0f8bf99c in _SPI_execute_plan (plan=plan@entry=0x558a19f4d020, options=options@entry=0x7fff9a2d30b0, snapshot=snapshot@entry=0x558a10afd760 , crosscheck_snapshot=crosscheck_snapshot@entry=0x0, fire_triggers=fire_triggers@entry=false) at ../src/backend/executor/spi.c:2577 [09:35:08.289] plansource = 0x558a19f23be0 [09:35:08.289] stmt_list = [09:35:08.289] lc2 = [09:35:08.289] lc1__state = [09:35:08.289] my_res = 0 [09:35:08.289] my_processed = 0 [09:35:08.289] my_tuptable = 0x0 [09:35:08.289] res = [09:35:08.289] allow_nonatomic = false [09:35:08.289] pushed_active_snap = true [09:35:08.289] plan_owner = 0x0 [09:35:08.289] spicallbackarg = {query = 0x558a19f24b18 "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} [09:35:08.289] spierrcontext = {previous = 0x0, callback = 0x558a0f8ba1fd <_SPI_error_callback>, arg = 0x7fff9a2d3050} [09:35:08.289] cplan = 0x0 [09:35:08.289] lc1 = [09:35:08.289] __func__ = "_SPI_execute_plan" [09:35:08.289] #18 0x0000558a0f8c005c in SPI_execute_snapshot (plan=plan@entry=0x558a19f4d020, Values=Values@entry=0x0, Nulls=Nulls@entry=0x0, snapshot=0x558a10afd760 , crosscheck_snapshot=crosscheck_snapshot@entry=0x0, read_only=read_only@entry=true, fire_triggers=false, tcount=1) at ../src/backend/executor/spi.c:797 [09:35:08.289] options = {params = 0x0, read_only = true, allow_nonatomic = false, must_return_tuples = false, tcount = 1, dest = 0x0, owner = 0x0} [09:35:08.289] res = 0 [09:35:08.289] #19 0x0000558a0fdba51f in RI_PartitionRemove_Check (trigger=trigger@entry=0x7fff9a2d37f0, fk_rel=fk_rel@entry=0x7f66cb6baa38, pk_rel=pk_rel@entry=0x7f66cb6bc718) at ../src/backend/utils/adt/ri_triggers.c:1871 [09:35:08.289] riinfo = 0x558a19f2d478 [09:35:08.289] querybuf = {data = 0x558a19f3ee38 "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} [09:35:08.289] constraintDef = [09:35:08.289] pkrelname = "\"fkpart4\".\"droppk2_d\"\000\000\000\200\344\\\324f\177\000\000\000\034\242\313f\177\000\000\000\002\333\031\212U\000\000\000\002\333\031\212U\000\000\2207-\232\377\177\000\000\005\000\000\000\000\000\000\000\344R\275\017\212U\000\000\000\002\333\031\212U\000\000\370\241\275\017\212U\000\000\2107-\232\377\177\000\000\000\000\000\000qA\270x0\036\304\031\212U\000\000\351\353\353\017\212U\000\000\2547-\232\377\177\000\000\340\0217\327f\177\000\000\\(\347\017", '\000' , "\367\251\000\000\000\000\000\000(\316\310\031\212U\000\000\000\000\000\000\000\000\000\000\260@\306\031\212U\000\000\2547-\232\377\177", '\000' ... [09:35:08.289] fkrelname = "\"fkpart4\".\"dropfk\"\000\313f\177\000\000Pb^\017\212U\000\000\210\325k\313f\177\000\000\265\313\346\017\212U\000\000\360f\311\031\212U\000\000Y\253%R\031\000\000\000\006\252", '\000' , "\001\000\003\000\000\000\000\000\000\000\000\000q\tv=\000\000\000\000\000\362\273\031\212U\000\000\200\352*\324f\177\000\000\003\000\000\000\000\000\000\000\020\000\000\000\000\000\000\000\214\357\353\017\212U\000\000\2206-\232\377\177\000\000\340\0217\327f\177\000\000\200\344\\\324\021\000\000\000\2176-\232\377\177\000\000\260c^\324f\177\000\000"... [09:35:08.289] pkattname = "pk.\"a\"\000\000\037\177+\327f\177\000\000\000@\000\000.\n\000\000\000\000\000\000\000\000\000\001\001\000\000\000f\177\000\000E\257\356\017\212U\000\000\360f\311\031\212U\000\000\001\000\000\000\000\000\000\000\b\277\360\031\212U\000\000\000\272\306\031\212U\000\000\000\000\000\000\000\000\000\000\030\351\213\313f\177\000\000\001\000\000\000\000\000\000\000) \275\017\212U\000\000\000@\000\000.\n\000\000\000\000\000\000\000\000\000\001\001\000\000\000\000" [09:35:08.289] fkattname = "\"a\"\000a\"\000\000\002", '\000' , "\002\333\031\212U\000\000P5-\232\377\177\000\000l\361\353\017\212U", '\000' , "\002\333\031\212U\000\000\377\377\377\377", '\000' , "x\271\333\031\212U\000\000\245[\275\017\212U\000\000x\271\333\031\212U\000\000\001\000\000\000\000\000\000\000x\271\333\031\212U\000\000\234\264\275\017\212U\000\000\230g\365\031\001" [09:35:08.289] sep = 0x558a10105032 " AND " [09:35:08.289] fk_only = [09:35:08.289] save_nestlevel = 2 [09:35:08.289] workmembuf = "65536\000\000\000\350\017\306\031\212U\000\000\267\v\000\000\000\000\000\000\220\000\306\031\212U\000" [09:35:08.289] spi_result = [09:35:08.289] qplan = 0x558a19f4d020 [09:35:08.289] i = [09:35:08.289] __func__ = "RI_PartitionRemove_Check" [09:35:08.289] #20 0x0000558a0f76f610 in ATDetachCheckNoForeignKeyRefs (partition=partition@entry=0x7f66cb6bc718) at ../src/backend/commands/tablecmds.c:20729 [09:35:08.289] constrOid = [09:35:08.289] rel = 0x7f66cb6baa38 [09:35:08.289] trig = {tgoid = 0, tgname = 0x7f66cb6bd614 "dropfk_a_fkey4", tgfoid = 0, tgtype = 0, tgenabled = 79 'O', tgisinternal = true, tgisclone = false, tgconstrrelid = 43505, tgconstrindid = 43508, tgconstraint = 43526, tgdeferrable = false, tginitdeferred = false, tgnargs = 0, tgnattr = 0, tgattr = 0x0, tgargs = 0x0, tgqual = 0x0, tgoldtable = 0x0, tgnewtable = 0x0} [09:35:08.289] tuple = 0x7f66cb6bd5c8 [09:35:08.289] constrForm = [09:35:08.289] cell__state = [09:35:08.289] constraints = 0x558a19f3ede8 [09:35:08.289] cell = [09:35:08.289] __func__ = "ATDetachCheckNoForeignKeyRefs" [09:35:08.289] #21 0x0000558a0f7a6a98 in ATExecDetachPartition (wqueue=wqueue@entry=0x7fff9a2d3a08, tab=tab@entry=0x558a19f0d088, rel=rel@entry=0x7f66cb6b0848, name=, concurrent=) at ../src/backend/commands/tablecmds.c:19712 [09:35:08.289] partRel = 0x7f66cb6bc718 [09:35:08.289] address = {classId = 0, objectId = 0, objectSubId = 8} [09:35:08.289] defaultPartOid = 43505 [09:35:08.289] __func__ = "ATExecDetachPartition" [09:35:08.289] #22 0x0000558a0f7a8202 in ATExecCmd (wqueue=wqueue@entry=0x7fff9a2d3a08, tab=tab@entry=0x558a19f0d088, cmd=, lockmode=lockmode@entry=8, cur_pass=cur_pass@entry=AT_PASS_MISC, context=context@entry=0x7fff9a2d3af0) at ../src/backend/commands/tablecmds.c:5580 [09:35:08.289] address = {classId = 0, objectId = 0, objectSubId = 0} [09:35:08.289] rel = 0x7f66cb6b0848 [09:35:08.289] __func__ = "ATExecCmd" [09:35:08.289] #23 0x0000558a0f7a847d in ATRewriteCatalogs (wqueue=wqueue@entry=0x7fff9a2d3a08, lockmode=lockmode@entry=8, context=context@entry=0x7fff9a2d3af0) at ../src/backend/commands/tablecmds.c:5245 [09:35:08.289] lcmd__state = [09:35:08.289] tab = 0x558a19f0d088 [09:35:08.289] subcmds = 0x558a19f35738 [09:35:08.289] lcmd = [09:35:08.289] ltab__state = [09:35:08.289] pass = AT_PASS_MISC [09:35:08.289] ltab = [09:35:08.289] #24 0x0000558a0f7a89d7 in ATController (parsetree=parsetree@entry=0x558a19c00630, rel=rel@entry=0x7f66cb6b0848, cmds=, recurse=, lockmode=lockmode@entry=8, context=context@entry=0x7fff9a2d3af0) at ../src/backend/commands/tablecmds.c:4802 [09:35:08.289] wqueue = 0x558a19f25d30 [09:35:08.289] lcmd = 0x0 [09:35:08.289] #25 0x0000558a0f7a8a8e in AlterTable (stmt=stmt@entry=0x558a19c00630, lockmode=lockmode@entry=8, context=context@entry=0x7fff9a2d3af0) at ../src/backend/commands/tablecmds.c:4457 [09:35:08.289] rel = 0x7f66cb6b0848 [09:35:08.289] #26 0x0000558a0fc1ca81 in ProcessUtilitySlow (pstate=pstate@entry=0x558a19f25c20, pstmt=pstmt@entry=0x558a19c00730, queryString=queryString@entry=0x558a19bffaf0 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x558a19c00af0, qc=0x7fff9a2d4010) at ../src/backend/tcop/utility.c:1321 [09:35:08.289] atcontext = {pstmt = 0x558a19c00730, queryString = 0x558a19bffaf0 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;", relid = 43493, params = 0x0, queryEnv = 0x0} [09:35:08.289] atstmt = 0x558a19c00630 [09:35:08.289] relid = 43493 [09:35:08.289] lockmode = 8 [09:35:08.289] cell = 0x0 [09:35:08.289] _save_exception_stack = 0x7fff9a2d3ed0 [09:35:08.289] _save_context_stack = 0x0 [09:35:08.289] _local_sigjmp_buf = {{__jmpbuf = {0, -8272672716346755441, 94051625862704, 0, 94051625859824, 0, -2748734930925783409, -8272650732416928113}, __mask_was_saved = 0, __saved_mask = {__val = {0, 0, 94051461460195, 0, 0, 2980, 263787014, 94051627411904, 94051454103118, 94051627872192, 0, 94051627872192, 94051461458964, 140079639150008, 3690196533323098500, 94051463981441}}}} [09:35:08.289] _do_rethrow = false [09:35:08.289] parsetree = 0x558a19c00630 [09:35:08.289] isTopLevel = true [09:35:08.289] isCompleteQuery = true [09:35:08.289] needCleanup = false [09:35:08.289] commandCollected = false [09:35:08.289] address = {classId = 21898, objectId = 432014896, objectSubId = 21898} [09:35:08.289] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [09:35:08.289] __func__ = "ProcessUtilitySlow" [09:35:08.289] #27 0x0000558a0fc1c0d3 in standard_ProcessUtility (pstmt=0x558a19c00730, queryString=0x558a19bffaf0 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x558a19c00af0, qc=0x7fff9a2d4010) at ../src/backend/tcop/utility.c:1070 [09:35:08.289] parsetree = 0x558a19c00630 [09:35:08.289] isTopLevel = true [09:35:08.289] isAtomicContext = false [09:35:08.289] pstate = 0x558a19f25c20 [09:35:08.289] readonly_flags = [09:35:08.289] __func__ = "standard_ProcessUtility" [09:35:08.289] #28 0x0000558a0fc1c22e in ProcessUtility (pstmt=pstmt@entry=0x558a19c00730, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x558a19c00af0, qc=0x7fff9a2d4010) at ../src/backend/tcop/utility.c:523 [09:35:08.289] No locals. [09:35:08.289] #29 0x0000558a0fc17a9a in PortalRunUtility (portal=portal@entry=0x558a19c84100, pstmt=pstmt@entry=0x558a19c00730, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x558a19c00af0, qc=qc@entry=0x7fff9a2d4010) at ../src/backend/tcop/pquery.c:1158 [09:35:08.289] No locals. [09:35:08.289] #30 0x0000558a0fc1803f in PortalRunMulti (portal=portal@entry=0x558a19c84100, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x558a19c00af0, altdest=altdest@entry=0x558a19c00af0, qc=qc@entry=0x7fff9a2d4010) at ../src/backend/tcop/pquery.c:1315 [09:35:08.289] pstmt = 0x558a19c00730 [09:35:08.289] stmtlist_item__state = [09:35:08.289] active_snapshot_set = false [09:35:08.289] stmtlist_item = 0x558a19c00ab8 [09:35:08.289] #31 0x0000558a0fc18612 in PortalRun (portal=portal@entry=0x558a19c84100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x558a19c00af0, altdest=altdest@entry=0x558a19c00af0, qc=0x7fff9a2d4010) at ../src/backend/tcop/pquery.c:791 [09:35:08.289] _save_exception_stack = 0x7fff9a2d40c0 [09:35:08.289] _save_context_stack = 0x0 [09:35:08.289] _local_sigjmp_buf = {{__jmpbuf = {0, -8272672716522916209, 94051626402048, 94051625862904, 94051626402048, 94051625862832, -2748734931039029617, -8272650730461464945}, __mask_was_saved = 0, __saved_mask = {__val = {94051461142664, 94051625859568, 112, 4, 94051461147081, 2586656671, 4, 94051625862832, 112, 34, 94051626402048, 94051625862904, 94051625862880, 94051625862832, 94051461234284, 94051625862832}}}} [09:35:08.289] _do_rethrow = [09:35:08.289] result = [09:35:08.289] nprocessed = [09:35:08.289] saveTopTransactionResourceOwner = 0x558a19c41658 [09:35:08.289] saveTopTransactionContext = 0x558a19c96530 [09:35:08.289] saveActivePortal = 0x0 [09:35:08.289] saveResourceOwner = 0x558a19c41658 [09:35:08.289] savePortalContext = 0x0 [09:35:08.289] saveMemoryContext = 0x558a19c96530 [09:35:08.289] __func__ = "PortalRun" [09:35:08.289] #32 0x0000558a0fc119f9 in exec_simple_query (query_string=query_string@entry=0x558a19bffaf0 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;") at ../src/backend/tcop/postgres.c:1283 [09:35:08.289] cmdtaglen = 11 [09:35:08.289] snapshot_set = [09:35:08.289] per_parsetree_context = 0x0 [09:35:08.289] plantree_list = 0x558a19c00aa0 [09:35:08.289] parsetree = 0x558a19c006b0 [09:35:08.289] commandTag = [09:35:08.289] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:35:08.289] querytree_list = [09:35:08.289] portal = 0x558a19c84100 [09:35:08.289] receiver = 0x558a19c00af0 [09:35:08.289] format = 0 [09:35:08.289] cmdtagname = [09:35:08.289] parsetree_item__state = [09:35:08.289] dest = DestRemote [09:35:08.289] oldcontext = 0x558a19c96530 [09:35:08.289] parsetree_list = 0x558a19c006e0 [09:35:08.289] parsetree_item = 0x558a19c006f8 [09:35:08.289] save_log_statement_stats = false [09:35:08.289] was_logged = false [09:35:08.289] use_implicit_block = false [09:35:08.289] msec_str = "\004\000\000\000\000\000\000\000W\306\354\017\212U\000\000\240@-\232\377\177\000\0000\000\000\000\000\000\000" [09:35:08.289] __func__ = "exec_simple_query" [09:35:08.289] #33 0x0000558a0fc1477d in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [09:35:08.289] query_string = 0x558a19bffaf0 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;" [09:35:08.289] firstchar = [09:35:08.289] input_message = {data = 0x558a19bffaf0 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;", len = 48, maxlen = 1024, cursor = 48} [09:35:08.289] local_sigjmp_buf = {{__jmpbuf = {94051473806840, -8272658275083356529, 140735780045340, 4, 19, 140735780045572, -2748734933408811377, -8272650734424820081}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94051625590288, 15616, 94051473800928, 94051626122608, 19, 94051461146629, 0, 9, 2, 94051473806848, 94051625590288, 94051473800928, 4, 19, 140735780045572}}}} [09:35:08.289] send_ready_for_query = false [09:35:08.289] idle_in_transaction_timeout_enabled = false [09:35:08.289] idle_session_timeout_enabled = false [09:35:08.289] __func__ = "PostgresMain" [09:35:08.289] #34 0x0000558a0fc0a5f3 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:35:08.289] bsdata = [09:35:08.289] #35 0x0000558a0fabc345 in postmaster_child_launch (child_type=B_BACKEND, child_slot=19, startup_data=startup_data@entry=0x7fff9a2d421c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff9a2d4270) at ../src/backend/postmaster/launch_backend.c:274 [09:35:08.289] pid = [09:35:08.289] #36 0x0000558a0fac1340 in BackendStartup (client_sock=client_sock@entry=0x7fff9a2d4270) at ../src/backend/postmaster/postmaster.c:3377 [09:35:08.289] bn = 0x558a19c283c8 [09:35:08.289] pid = [09:35:08.289] startup_data = {canAcceptConnections = CAC_OK} [09:35:08.289] cac = [09:35:08.289] __func__ = "BackendStartup" [09:35:08.289] #37 0x0000558a0fac3219 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [09:35:08.289] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\022\203\305\016\212U\000\000hg\301\016\212U\000\000\300C-\232\377\177\000\000\270C-\232\377\177\000\000\225[\362\001\000\000\000\000\240t\b\330f\177\000\000+", '\000' , "\377\177\000\000\000\004\000\000\000\000\000\000h\206\265\330f\177\000\0000v\b\330f\177\000\000\340\202\265\330f\177\000\000\316)fR\000\000\000", __ss_align = 2586657792}, salen = 2}} [09:35:08.289] i = 0 [09:35:08.289] now = [09:35:08.289] last_lockfile_recheck_time = 1732527060 [09:35:08.289] last_touch_time = 1732527060 [09:35:08.289] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -670534096, events = 32614, fd = -659193120, user_data = 0x7c96e577}, {pos = -1708309440, events = 32767, fd = -659363256, user_data = 0xf}, {pos = -670534096, events = 32614, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -659193120, user_data = 0x7fff9a2d43b8}, {pos = -1708309568, events = 32767, fd = -659192216, user_data = 0x0}, {pos = 432012208, events = 21898, fd = -685016438, user_data = 0x558a19bffbb0}, {pos = 1, events = 21898, fd = 32768, user_data = 0xffffffff}, {pos = -685580256, events = 32614, fd = -663421024, user_data = 0x558a19c2b198}, {pos = 432189560, events = 21898, fd = 432198753, user_data = 0x7f66d8b34ebe}, {pos = 1, events = 0, fd = -659193120, user_data = 0x1ab}, {pos = 272932184, events = 21898, fd = 0, user_data = 0xec}, {pos = 432012208, events = 21898, fd = -659337538, user_data = 0x1}, {pos = 0, events = 0, fd = -685580256, user_data = 0x7f66d72f2e40 }, {pos = 16, events = 0, fd = -1708308432, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f66d8b371ba}, {pos = 0, events = 0, fd = -685052508, user_data = 0x0}, {pos = 279894432, events = 21898, fd = 2, user_data = 0x0}, {pos = 431759024, events = 21898, fd = 263861672, user_data = 0x558a19c32cc0}, {pos = 263865661, events = 21898, fd = 432221467, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -685546296, user_data = 0x7f66d729c880 }, {pos = -719209032, events = 32614, fd = -1708308240, user_data = 0x100007f00000002}, {pos = -685019385, events = 32614, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -683729824, events = 32614, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 1330015316, fd = 168440164, user_data = 0x35323337310a6174}, {pos = 909129522, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 432192608, events = 21898, fd = -685016438, user_data = 0xa}, {pos = 267294856, events = 21898, fd = 432204944, user_data = 0x7f66d72b576b}, {pos = -683746848, events = 32614, fd = -685108882, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x3c2331672550e900}, {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 = 0x558a19c2ae70}, {pos = 1, events = 0, fd = 432189240, user_data = 0x3}, {pos = 0, events = 0, fd = 20995, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 432012208, user_data = 0x7f66d72f3053 }, {pos = 432189240, events = 21898, fd = 1024, user_data = 0x7fff9a2d48f8}, {pos = 267378172, events = 21898, fd = 279958960, user_data = 0x558a0feec8b9 }, {pos = 432189040, events = 21898, fd = 432011760, user_data = 0x558a19c2ae70}, {pos = -685025429, events = 32614, fd = 0, user_data = 0x558a0fefe523 }, {pos = 432189040, events = 1, fd = 267380332, user_data = 0x558a19bff9f0}, {pos = 626059520, events = 1008939367, fd = 0, user_data = 0x7f66d72a2ab1}, {pos = -685107984, events = 32614, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 431759024, user_data = 0x3c2331672550e900}, {pos = 0, events = 0, fd = 626059520, user_data = 0xc}, {pos = 626059520, events = 1008939367, fd = 0, user_data = 0x7f66d725b239 }, {pos = 237, events = 0, fd = 262914114, user_data = 0x400000}, {pos = 0, events = 0, fd = 431759024, user_data = 0x558a0feec74d }, {pos = 431845664, events = 21898, fd = 432011760, user_data = 0x558a19bd7120}, {pos = 1, events = 0, fd = 0, user_data = 0x558a0feab14a }, {pos = 12, events = 0, fd = 432188616, user_data = 0x558a19c2aca8}, {pos = 279895840, events = 21898, fd = 296, user_data = 0x558a0fabe85c }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 262930585, events = 21898, fd = 276328912, user_data = 0x558a19c003c8}} [09:35:08.290] nevents = 1 [09:35:08.290] __func__ = "ServerLoop" [09:35:08.290] #38 0x0000558a0fac4aaa in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x558a19bbdd70) at ../src/backend/postmaster/postmaster.c:1361 [09:35:08.290] opt = [09:35:08.290] status = [09:35:08.290] userDoption = [09:35:08.290] listen_addr_saved = false [09:35:08.290] output_config_variable = [09:35:08.290] __func__ = "PostmasterMain" [09:35:08.290] #39 0x0000558a0f8f277a in main (argc=8, argv=0x558a19bbdd70) at ../src/backend/main/main.c:196 [09:35:08.290] do_check_root = [09:35:08.327] -e [09:35:08.327] [09:35:08.327] [09:35:08.389] dumping /tmp/cores/postgres-6-39465.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:35:08.640] [New LWP 39465] [09:35:08.640] [09:35:08.640] This GDB supports auto-downloading debuginfo from the following URLs: [09:35:08.640] [09:35:08.640] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [09:35:08.640] Debuginfod has been disabled. [09:35:08.640] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [09:35:08.739] [Thread debugging using libthread_db enabled] [09:35:08.739] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [09:35:08.739] Core was generated by `postgres: test: postgres db1 [local] SELECT '. [09:35:08.739] Program terminated with signal SIGABRT, Aborted. [09:35:08.739] #0 0x00007fa883ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:08.800] [09:35:08.800] Thread 1 (Thread 0x7fa883dd3f00 (LWP 39465)): [09:35:08.800] #0 0x00007fa883ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:08.800] No symbol table info available. [09:35:08.800] #1 0x00007fa883e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:08.800] No symbol table info available. [09:35:08.800] #2 0x00007fa883e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [09:35:08.800] No symbol table info available. [09:35:08.800] #3 0x00007fa88401e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [09:35:08.800] No locals. [09:35:08.800] #4 0x00007fa88402aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [09:35:08.800] No locals. [09:35:08.800] #5 0x00007fa88400dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x562255e867a0, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [09:35:08.800] bp = 140728863697088 [09:35:08.800] pc = [09:35:08.800] Opts = {FromUnrecoverableHandler = true, pc = 94705456274687, bp = 140361548511592} [09:35:08.800] #6 0x0000562255145cff in examine_self_contradictory_rels (root=root@entry=0x562276ee65e0, rel=rel@entry=0x7fa8783ca4b8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [09:35:08.800] lc__state = [09:35:08.800] rlist = [09:35:08.800] i = 7 [09:35:08.800] br = [09:35:08.800] expression = [09:35:08.800] or_rinfo = 0x7fa8783d5ed8 [09:35:08.800] ccxt = [09:35:08.800] delidx = 0x7fa8783d7e71 [09:35:08.800] arglst = [09:35:08.800] lc = [09:35:08.800] arg = [09:35:08.800] n = [09:35:08.800] restrictinfo = [09:35:08.800] ccwapper = {clausecxt = 0x7fa8783d57e8} [09:35:08.800] sec = {sopcinfo = {n_members = 38, opcies = 0x7fa8783d4f88}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7fa8783d5398, atop_set = 0x7fa8783d2f48}, ccfree = 0x7fa8783d7e40, vifree = 0x7fa8783d6d58} [09:35:08.800] __func__ = "examine_self_contradictory_rels" [09:35:08.800] #7 0x0000562255145f0e in examine_self_contradictory_rels_phase1 (root=root@entry=0x562276ee65e0) at ../src/backend/optimizer/plan/contradictory.c:2608 [09:35:08.800] rel = 0x7fa8783ca4b8 [09:35:08.800] rti = 1 [09:35:08.800] rinfo = [09:35:08.800] #8 0x00005622551109eb in query_planner (root=root@entry=0x562276ee65e0, qp_callback=qp_callback@entry=0x562255115d08 , qp_extra=qp_extra@entry=0x7ffdfdee2ac0) at ../src/backend/optimizer/plan/planmain.c:190 [09:35:08.800] parse = 0x562276edcdd8 [09:35:08.800] joinlist = 0x7fa8783d30d8 [09:35:08.800] final_rel = [09:35:08.800] __func__ = "query_planner" [09:35:08.800] #9 0x0000562255123943 in grouping_planner (root=root@entry=0x562276ee65e0, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1574 [09:35:08.800] sort_input_targets = 0x562276ee65e0 [09:35:08.800] sort_input_target_parallel_safe = [09:35:08.800] grouping_target = [09:35:08.800] scanjoin_target = [09:35:08.800] activeWindows = 0x0 [09:35:08.800] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [09:35:08.800] sort_input_targets_contain_srfs = 0x562276ee3dd8 [09:35:08.800] have_grouping = [09:35:08.800] wflists = 0x0 [09:35:08.800] gset_data = 0x0 [09:35:08.800] sort_input_target = [09:35:08.800] grouping_targets = 0x562276ee3e20 [09:35:08.800] grouping_target_parallel_safe = [09:35:08.800] scanjoin_targets = 0x562276ee3e08 [09:35:08.800] scanjoin_target_parallel_safe = [09:35:08.800] grouping_targets_contain_srfs = 0x562276ee65e0 [09:35:08.800] scanjoin_targets_contain_srfs = 0x0 [09:35:08.800] scanjoin_target_same_exprs = [09:35:08.800] parse = 0x562276edcdd8 [09:35:08.800] offset_est = 0 [09:35:08.800] count_est = 0 [09:35:08.800] limit_tuples = -1 [09:35:08.800] have_postponed_srfs = false [09:35:08.800] final_target = [09:35:08.800] final_targets = 0x562276ee65e0 [09:35:08.800] final_targets_contain_srfs = 0x7 [09:35:08.800] final_target_parallel_safe = [09:35:08.800] current_rel = [09:35:08.800] final_rel = [09:35:08.800] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94706024173016} [09:35:08.800] lc = [09:35:08.800] __func__ = "grouping_planner" [09:35:08.800] #10 0x00005622551268c7 in subquery_planner (glob=, parse=0x562276edcdd8, parent_root=parent_root@entry=0x562276ed9c78, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1143 [09:35:08.800] root = 0x562276ee65e0 [09:35:08.800] newWithCheckOptions = [09:35:08.800] newHaving = 0x0 [09:35:08.800] hasOuterJoins = [09:35:08.800] hasResultRTEs = true [09:35:08.800] final_rel = [09:35:08.800] l = 0x0 [09:35:08.800] #11 0x0000562255138261 in SS_process_ctes (root=root@entry=0x562276ed9c78) at ../src/backend/optimizer/plan/subselect.c:968 [09:35:08.800] subquery = [09:35:08.800] cte = 0x562276e96490 [09:35:08.800] cmdType = [09:35:08.800] subroot = [09:35:08.800] final_rel = [09:35:08.800] best_path = [09:35:08.800] plan = [09:35:08.800] splan = [09:35:08.800] paramid = [09:35:08.800] lc__state = [09:35:08.800] lc = [09:35:08.800] __func__ = "SS_process_ctes" [09:35:08.800] #12 0x000056225512536b in subquery_planner (glob=glob@entry=0x562276ea7388, parse=parse@entry=0x562276ea7498, 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:696 [09:35:08.800] root = 0x562276ed9c78 [09:35:08.800] newWithCheckOptions = [09:35:08.800] newHaving = [09:35:08.800] hasOuterJoins = [09:35:08.800] hasResultRTEs = [09:35:08.800] final_rel = [09:35:08.800] l = [09:35:08.800] #13 0x0000562255127558 in standard_planner (parse=0x562276ea7498, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:417 [09:35:08.800] result = [09:35:08.800] glob = 0x562276ea7388 [09:35:08.800] tuple_fraction = 0 [09:35:08.800] root = [09:35:08.800] final_rel = [09:35:08.800] best_path = [09:35:08.800] top_plan = [09:35:08.800] lp = [09:35:08.800] lr = [09:35:08.800] #14 0x00005622551285c2 in planner (parse=parse@entry=0x562276ea7498, query_string=query_string@entry=0x562276dbb5a0 "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:284 [09:35:08.800] result = [09:35:08.800] #15 0x0000562255396f23 in pg_plan_query (querytree=querytree@entry=0x562276ea7498, query_string=query_string@entry=0x562276dbb5a0 "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:911 [09:35:08.800] plan = [09:35:08.800] #16 0x0000562255397304 in pg_plan_queries (querytrees=0x562276ed9c28, query_string=query_string@entry=0x562276dbb5a0 "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:1005 [09:35:08.800] query = 0x562276ea7498 [09:35:08.800] stmt = [09:35:08.800] query_list__state = [09:35:08.800] stmt_list = 0x0 [09:35:08.800] query_list = [09:35:08.800] #17 0x00005622553978b1 in exec_simple_query (query_string=query_string@entry=0x562276dbb5a0 "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:1202 [09:35:08.800] cmdtaglen = 6 [09:35:08.800] snapshot_set = true [09:35:08.800] per_parsetree_context = 0x0 [09:35:08.800] plantree_list = [09:35:08.800] parsetree = 0x562276ea7308 [09:35:08.800] commandTag = CMDTAG_SELECT [09:35:08.800] qc = {commandTag = 1935, nprocessed = 94706022987168} [09:35:08.800] querytree_list = [09:35:08.800] portal = [09:35:08.800] receiver = [09:35:08.800] format = 0 [09:35:08.800] cmdtagname = [09:35:08.800] parsetree_item__state = [09:35:08.800] dest = DestRemote [09:35:08.800] oldcontext = 0x562276e4af40 [09:35:08.800] parsetree_list = 0x562276ea7338 [09:35:08.800] parsetree_item = 0x562276ea7350 [09:35:08.800] save_log_statement_stats = false [09:35:08.800] was_logged = true [09:35:08.800] use_implicit_block = false [09:35:08.800] msec_str = "\004\000\000\000\000\000\000\000W&eU\"V\000\000\220.\356\375\375\177\000\000\217\a\000\000\000\000\000" [09:35:08.800] __func__ = "exec_simple_query" [09:35:08.800] #18 0x000056225539a77d in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4798 [09:35:08.800] query_string = 0x562276dbb5a0 "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 "... [09:35:08.800] firstchar = [09:35:08.800] input_message = {data = 0x562276dbb5a0 "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} [09:35:08.800] local_sigjmp_buf = {{__jmpbuf = {94705474352632, -3867676738088561383, 140728863698956, 4, 1, 140728863699188, -7355477756528782055, -3867670289953417959}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94706022714832, 14336, 94705474346720, 94706023222352, 1, 94705461692421, 0, 9, 2, 94705474352640, 94706022714832, 94705474346720, 4, 1, 140728863699188}}}} [09:35:08.800] send_ready_for_query = false [09:35:08.800] idle_in_transaction_timeout_enabled = false [09:35:08.800] idle_session_timeout_enabled = false [09:35:08.800] __func__ = "PostgresMain" [09:35:08.800] #19 0x00005622553905f3 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [09:35:08.800] bsdata = [09:35:08.800] #20 0x0000562255242345 in postmaster_child_launch (child_type=B_BACKEND, child_slot=1, startup_data=startup_data@entry=0x7ffdfdee300c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffdfdee3060) at ../src/backend/postmaster/launch_backend.c:274 [09:35:08.800] pid = [09:35:08.800] #21 0x0000562255247340 in BackendStartup (client_sock=client_sock@entry=0x7ffdfdee3060) at ../src/backend/postmaster/postmaster.c:3377 [09:35:08.800] bn = 0x562276de25c8 [09:35:08.800] pid = [09:35:08.800] startup_data = {canAcceptConnections = CAC_OK} [09:35:08.800] cac = [09:35:08.800] __func__ = "BackendStartup" [09:35:08.800] #22 0x0000562255249219 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [09:35:08.800] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\356\375\375\177\000\000\3640\356\375\375\177", '\000' , "\022\343=T\"V\000\000h\3079T\"V\000\000\3001\356\375\375\177\000\000\2701\356\375\375\177\000\000\225[\362\001\000\000\000\000\240tȄ\250\177\000\000+", '\000' , " \342=T\"V\000\000h\346p\205\250\177\000\0000vȄ\250\177\000", __ss_align = 140361770001120}, salen = 2}} [09:35:08.800] i = 0 [09:35:08.800] now = [09:35:08.800] last_lockfile_recheck_time = 1732527140 [09:35:08.800] last_touch_time = 1732527140 [09:35:08.800] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1413341970, events = 22050, fd = -2056198552, user_data = 0x7fa884c87630}, {pos = -2056199456, events = 32680, fd = 2090263927, user_data = 0x7ffdfdee3240}, {pos = -2056369592, events = 32680, fd = 15, user_data = 0x7fa884c87630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -2056199456, events = 32680, fd = -34721352, user_data = 0x7ffdfdee31c0}, {pos = -2056198552, events = 32680, fd = 0, user_data = 0x562276dbca20}, {pos = 1433134230, events = 22050, fd = 32768, user_data = 0x1}, {pos = 1994115680, events = 22050, fd = -1, user_data = 0x7fa883e2e020}, {pos = -2060271712, events = 32680, fd = 1994285912, user_data = 0x562276de6238}, {pos = 1994283009, events = 22050, fd = -2056343874, user_data = 0x1}, {pos = -2056199456, events = 32680, fd = 427, user_data = 0x562255bcfd58 }, {pos = 0, events = 0, fd = 216, user_data = 0x562276dbca20}, {pos = -2056343874, events = 32680, fd = 1, user_data = 0x0}, {pos = -2082283488, events = 32680, fd = -2081477056, user_data = 0x10}, {pos = -34720224, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -2056334918, user_data = 0x0}, {pos = -2081755740, events = 32680, fd = 0, user_data = 0x5622562739a0 }, {pos = 2, events = 0, fd = 0, user_data = 0x562276d7ce70}, {pos = 1429382461, events = 22050, fd = 1994316635, user_data = 0x56225532e176 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x562276dbca20}, {pos = -2056343874, events = 32680, fd = 1, user_data = 0x0}, {pos = -2082249528, events = 32680, fd = -2081830784, user_data = 0x42d}, {pos = -2081722617, events = 32680, fd = 2, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = -2080433056, events = 32680, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4278190080, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1751342899, events = 795566949, fd = 1635017060, user_data = 0x6975622f646c6975}, {pos = 1949262956, events = 1920234341, fd = 0, user_data = 0x7f0000000000}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = 1432811656, events = 22050, fd = 1994298048, user_data = 0x7fa883eb58be}, {pos = -2080450080, events = 32680, fd = -2081812114, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x4820c9a5d7f0f00}, {pos = -2080447008, events = 32680, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1994285304, user_data = 0x3}, {pos = 0, events = 0, fd = 39021, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1994115616, user_data = 0x7fa883ef3053 }, {pos = 1994285304, events = 22050, fd = 1024, user_data = 0x7ffdfdee36e8}, {pos = 1432894972, events = 22050, fd = 1445475760, user_data = 0x5622556728b9 }, {pos = 1994285104, events = 22050, fd = 1994108032, user_data = 0x562276de6030}, {pos = -2081728661, events = 32680, fd = 0, user_data = 0x562255684523 }, {pos = 1994285104, events = 1, fd = 1432897132, user_data = 0x562276dbac80}, {pos = 1568608000, events = 75631770, fd = 0, user_data = 0x7fa883ea2ab1}, {pos = -2081811216, events = 32680, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1993854576, user_data = 0x4820c9a5d7f0f00}, {pos = 0, events = 0, fd = 1568608000, user_data = 0xc}, {pos = 1568608000, events = 75631770, fd = 0, user_data = 0x7fa883e5b239 }, {pos = 217, events = 0, fd = 1428430914, user_data = 0x400000}, {pos = 0, events = 0, fd = 1993854576, user_data = 0x56225567274d }, {pos = 1993941936, events = 22050, fd = 1994108032, user_data = 0x562276d923b0}, {pos = 1, events = 0, fd = 0, user_data = 0x56225563114a }, {pos = 12, events = 0, fd = 1994280552, user_data = 0x562276de4e48}, {pos = 1445412640, events = 22050, fd = 296, user_data = 0x56225524485c }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1428447385, events = 22050, fd = 1441845712, user_data = 0x562276dbb638}} [09:35:08.800] nevents = 1 [09:35:08.800] __func__ = "ServerLoop" [09:35:08.800] #23 0x000056225524aaaa in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x562276d78ce0) at ../src/backend/postmaster/postmaster.c:1361 [09:35:08.800] opt = [09:35:08.800] status = [09:35:08.800] userDoption = [09:35:08.801] listen_addr_saved = false [09:35:08.801] output_config_variable = [09:35:08.801] __func__ = "PostmasterMain" [09:35:08.801] #24 0x000056225507877a in main (argc=4, argv=0x562276d78ce0) at ../src/backend/main/main.c:196 [09:35:08.801] do_check_root =