[13:17:59.072] src/tools/ci/cores_backtrace.sh linux /tmp/cores [13:17:59.262] dumping /tmp/cores/postgres-6-40030.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:17:59.499] [New LWP 40030] [13:17:59.499] [13:17:59.499] This GDB supports auto-downloading debuginfo from the following URLs: [13:17:59.499] [13:17:59.499] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:17:59.499] Debuginfod has been disabled. [13:17:59.499] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:17:59.606] [Thread debugging using libthread_db enabled] [13:17:59.606] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:17:59.606] Core was generated by `postgres: test: postgres db2 [local] SELECT '. [13:17:59.606] Program terminated with signal SIGABRT, Aborted. [13:17:59.606] #0 0x00007f7045ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:17:59.692] [13:17:59.692] Thread 1 (Thread 0x7f7045bd4f00 (LWP 40030)): [13:17:59.692] #0 0x00007f7045ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:17:59.692] No symbol table info available. [13:17:59.692] #1 0x00007f7045e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:17:59.692] No symbol table info available. [13:17:59.692] #2 0x00007f7045e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:17:59.692] No symbol table info available. [13:17:59.692] #3 0x00007f704601e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [13:17:59.692] No locals. [13:17:59.692] #4 0x00007f704602aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [13:17:59.692] No locals. [13:17:59.692] #5 0x00007f704600dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x559f67764480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [13:17:59.692] bp = 140723352150608 [13:17:59.692] pc = [13:17:59.692] Opts = {FromUnrecoverableHandler = true, pc = 94143110016656, bp = 140119989927080} [13:17:59.692] #6 0x0000559f66a16e90 in examine_self_contradictory_rels (root=root@entry=0x559f685f2328, rel=rel@entry=0x559f685fc018, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [13:17:59.692] lc__state = [13:17:59.692] rlist = [13:17:59.692] i = 7 [13:17:59.692] br = [13:17:59.692] expression = [13:17:59.692] or_rinfo = 0x7f703a39cd38 [13:17:59.692] ccxt = [13:17:59.692] delidx = 0x7f703a39fe91 [13:17:59.692] arglst = [13:17:59.692] lc = [13:17:59.692] arg = [13:17:59.692] n = [13:17:59.692] restrictinfo = [13:17:59.692] ccwapper = {clausecxt = 0x7f703a39db28} [13:17:59.692] sec = {sopcinfo = {n_members = 38, opcies = 0x7f703a39d2c8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7f703a39d6d8, atop_set = 0x7f703a39b398}, ccfree = 0x7f703a39fe60, vifree = 0x7f703a39ed78} [13:17:59.692] __func__ = "examine_self_contradictory_rels" [13:17:59.692] #7 0x0000559f66a1709f in examine_self_contradictory_rels_phase1 (root=root@entry=0x559f685f2328) at ../src/backend/optimizer/plan/contradictory.c:2608 [13:17:59.692] rel = 0x559f685fc018 [13:17:59.692] rti = 1 [13:17:59.692] rinfo = [13:17:59.692] #8 0x0000559f669e2058 in query_planner (root=root@entry=0x559f685f2328, qp_callback=qp_callback@entry=0x559f669e7375 , qp_extra=qp_extra@entry=0x7ffcb56aa450) at ../src/backend/optimizer/plan/planmain.c:193 [13:17:59.692] parse = 0x559f685e8b20 [13:17:59.692] joinlist = 0x7f703a39b528 [13:17:59.692] final_rel = [13:17:59.692] __func__ = "query_planner" [13:17:59.692] #9 0x0000559f669f4ad4 in grouping_planner (root=root@entry=0x559f685f2328, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [13:17:59.692] sort_input_targets = 0x559f685f2328 [13:17:59.692] sort_input_target_parallel_safe = [13:17:59.692] grouping_target = [13:17:59.692] scanjoin_target = [13:17:59.692] activeWindows = 0x0 [13:17:59.692] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [13:17:59.692] sort_input_targets_contain_srfs = 0x559f685efb20 [13:17:59.692] have_grouping = [13:17:59.692] wflists = 0x0 [13:17:59.692] gset_data = 0x0 [13:17:59.692] sort_input_target = [13:17:59.692] grouping_targets = 0x559f685efb68 [13:17:59.692] grouping_target_parallel_safe = [13:17:59.692] scanjoin_targets = 0x559f685efb50 [13:17:59.692] scanjoin_target_parallel_safe = [13:17:59.692] grouping_targets_contain_srfs = 0x559f685f2328 [13:17:59.692] scanjoin_targets_contain_srfs = 0x0 [13:17:59.692] scanjoin_target_same_exprs = [13:17:59.692] parse = 0x559f685e8b20 [13:17:59.692] offset_est = 0 [13:17:59.692] count_est = 0 [13:17:59.692] limit_tuples = -1 [13:17:59.692] have_postponed_srfs = false [13:17:59.692] final_target = [13:17:59.692] final_targets = 0x559f685f2328 [13:17:59.692] final_targets_contain_srfs = 0x7 [13:17:59.692] final_target_parallel_safe = [13:17:59.692] current_rel = [13:17:59.692] final_rel = [13:17:59.692] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94143139187488} [13:17:59.692] lc = [13:17:59.692] __func__ = "grouping_planner" [13:17:59.692] #10 0x0000559f669f7a58 in subquery_planner (glob=, parse=0x559f685e8b20, parent_root=parent_root@entry=0x559f685e5ce0, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [13:17:59.692] root = 0x559f685f2328 [13:17:59.692] newWithCheckOptions = [13:17:59.692] newHaving = 0x0 [13:17:59.692] hasOuterJoins = [13:17:59.692] hasResultRTEs = true [13:17:59.692] final_rel = [13:17:59.692] l = 0x0 [13:17:59.692] #11 0x0000559f66a093f2 in SS_process_ctes (root=root@entry=0x559f685e5ce0) at ../src/backend/optimizer/plan/subselect.c:966 [13:17:59.692] subquery = [13:17:59.692] cte = 0x559f685aa890 [13:17:59.692] cmdType = [13:17:59.692] subroot = [13:17:59.692] final_rel = [13:17:59.692] best_path = [13:17:59.692] plan = [13:17:59.692] splan = [13:17:59.692] paramid = [13:17:59.692] lc__state = [13:17:59.692] lc = [13:17:59.692] __func__ = "SS_process_ctes" [13:17:59.692] #12 0x0000559f669f64fc in subquery_planner (glob=glob@entry=0x559f685bfae8, parse=parse@entry=0x559f685bfbf8, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:704 [13:17:59.692] root = 0x559f685e5ce0 [13:17:59.692] newWithCheckOptions = [13:17:59.692] newHaving = [13:17:59.692] hasOuterJoins = [13:17:59.692] hasResultRTEs = [13:17:59.692] final_rel = [13:17:59.692] l = [13:17:59.692] #13 0x0000559f669f86e9 in standard_planner (parse=0x559f685bfbf8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [13:17:59.692] result = [13:17:59.692] glob = 0x559f685bfae8 [13:17:59.692] tuple_fraction = 0 [13:17:59.692] root = [13:17:59.692] final_rel = [13:17:59.692] best_path = [13:17:59.692] top_plan = [13:17:59.692] lp = [13:17:59.692] lr = [13:17:59.692] #14 0x0000559f669f9753 in planner (parse=parse@entry=0x559f685bfbf8, query_string=query_string@entry=0x559f684cf5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [13:17:59.692] result = [13:17:59.692] #15 0x0000559f66c68d7d in pg_plan_query (querytree=querytree@entry=0x559f685bfbf8, query_string=query_string@entry=0x559f684cf5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [13:17:59.692] plan = [13:17:59.692] #16 0x0000559f66c6915e in pg_plan_queries (querytrees=0x559f685e5c90, query_string=query_string@entry=0x559f684cf5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:993 [13:17:59.692] query = 0x559f685bfbf8 [13:17:59.692] stmt = [13:17:59.692] query_list__state = [13:17:59.692] stmt_list = 0x0 [13:17:59.692] query_list = [13:17:59.692] #17 0x0000559f66c6970b in exec_simple_query (query_string=query_string@entry=0x559f684cf5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "...) at ../src/backend/tcop/postgres.c:1190 [13:17:59.692] cmdtaglen = 6 [13:17:59.692] snapshot_set = true [13:17:59.692] per_parsetree_context = 0x0 [13:17:59.692] plantree_list = [13:17:59.692] parsetree = 0x559f685bfa68 [13:17:59.692] commandTag = CMDTAG_SELECT [13:17:59.692] qc = {commandTag = 1935, nprocessed = 94143138035104} [13:17:59.692] querytree_list = [13:17:59.692] portal = [13:17:59.692] receiver = [13:17:59.692] format = 0 [13:17:59.692] cmdtagname = [13:17:59.692] parsetree_item__state = [13:17:59.692] dest = DestRemote [13:17:59.692] oldcontext = 0x559f6855ef40 [13:17:59.692] parsetree_list = 0x559f685bfa98 [13:17:59.692] parsetree_item = 0x559f685bfab0 [13:17:59.692] save_log_statement_stats = false [13:17:59.692] was_logged = true [13:17:59.692] use_implicit_block = false [13:17:59.692] msec_str = "\004\000\000\000\000\000\000\000\240\220\362f\237U\000\000 \250j\265\374\177\000\000\217\a\000\000\000\000\000" [13:17:59.692] __func__ = "exec_simple_query" [13:17:59.692] #18 0x0000559f66c6c5a2 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [13:17:59.692] query_string = 0x559f684cf5a0 "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 "... [13:17:59.692] firstchar = [13:17:59.692] input_message = {data = 0x559f684cf5a0 "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} [13:17:59.692] local_sigjmp_buf = {{__jmpbuf = {94143128170552, -5216745284741630852, 140723352152476, 4, 1, 140723352152708, -2063281449216772996, -5216743779530181508}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94143137762768, 14336, 94143128164608, 94143138270288, 1, 94143115457679, 0, 9, 2, 94143128170560, 94143137762768, 94143128164608, 4, 1, 140723352152708}}}} [13:17:59.692] send_ready_for_query = false [13:17:59.692] idle_in_transaction_timeout_enabled = false [13:17:59.692] idle_session_timeout_enabled = false [13:17:59.692] __func__ = "PostgresMain" [13:17:59.692] #19 0x0000559f66c6260d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:17:59.692] bsdata = [13:17:59.692] #20 0x0000559f66b13d47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=1, startup_data=startup_data@entry=0x7ffcb56aa99c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcb56aa9f0) at ../src/backend/postmaster/launch_backend.c:274 [13:17:59.692] pid = [13:17:59.692] #21 0x0000559f66b18d42 in BackendStartup (client_sock=client_sock@entry=0x7ffcb56aa9f0) at ../src/backend/postmaster/postmaster.c:3386 [13:17:59.692] bn = 0x559f684f65c8 [13:17:59.692] pid = [13:17:59.692] startup_data = {canAcceptConnections = CAC_OK} [13:17:59.692] cac = [13:17:59.692] __func__ = "BackendStartup" [13:17:59.692] #22 0x0000559f66b1ac1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [13:17:59.692] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\"\306\311e\237U\000\000\300\247\305e\237U\000\000@\253j\265\374\177\000\0008\253j\265\374\177\000\000\225[\362\001\000\000\000\000\240t\310Fp\177\000\000+", '\000' , "\374\177\000\000\000\004\000\000\000\000\000\000h\226mGp\177\000\0000v\310Fp\177\000\000\340\222mGp\177\000\000\316)fR\000\000\000", __ss_align = 3043666816}, salen = 2}} [13:17:59.692] i = 0 [13:17:59.692] now = [13:17:59.692] last_lockfile_recheck_time = 1735046051 [13:17:59.692] last_touch_time = 1735046051 [13:17:59.692] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1187542576, events = 32624, fd = 1198363360, user_data = 0x7c96e577}, {pos = -1251300416, events = 32764, fd = 1198193224, user_data = 0xf}, {pos = 1187542576, events = 32624, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1198363360, user_data = 0x7ffcb56aab38}, {pos = -1251300544, events = 32764, fd = 1198364264, user_data = 0x0}, {pos = 1749879328, events = 21919, fd = 1173060234, user_data = 0x559f684d0a20}, {pos = 1, events = 21919, fd = 32768, user_data = 0xffffffff}, {pos = 1172496416, events = 32624, fd = 1194524576, user_data = 0x559f684fa358}, {pos = 1750049336, events = 21919, fd = 1750046721, user_data = 0x7f70476b5ebe}, {pos = 1, events = 0, fd = 1198363360, user_data = 0x1aa}, {pos = 1732939088, events = 21919, fd = 0, user_data = 0xd8}, {pos = 1749879328, events = 21919, fd = 1198218942, user_data = 0x1}, {pos = 0, events = 0, fd = 1172496416, user_data = 0x7f7045ef2e40 }, {pos = 16, events = 0, fd = -1251299408, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f70476b81ba}, {pos = 0, events = 0, fd = 1173024164, user_data = 0x0}, {pos = 1739944928, events = 21919, fd = 2, user_data = 0x0}, {pos = 1749618288, events = 21919, fd = 1723839553, user_data = 0x559f68501b00}, {pos = 1723843542, events = 21919, fd = 1750080347, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = 1172530376, user_data = 0x7f7045e9c880 }, {pos = 1170034104, events = 32624, fd = -1251299216, user_data = 0x100007f00000002}, {pos = 1173057287, events = 32624, fd = 2, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = 1174346848, events = 32624, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1415727466, events = 1983342968, fd = 168445769, user_data = 0x74616467702f6174}, {pos = 925960801, events = 875574579, fd = 1751342899, user_data = 0x305f742f61746164}, {pos = 1684826485, events = 1769300527, fd = 1949262956, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1750053536, events = 21919, fd = 1173060234, user_data = 0xa}, {pos = 1727292690, events = 21919, fd = 1750061760, user_data = 0x7f7045eb58be}, {pos = 1174329824, events = 32624, fd = 1172967790, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xbc9d1cd4d9d3500}, {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 = 0x559f684fa030}, {pos = 1, events = 0, fd = 1750049016, user_data = 0x3}, {pos = 0, events = 0, fd = 39497, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1749879328, user_data = 0x7f7045ef3053 }, {pos = 1750049016, events = 21919, fd = 1024, user_data = 0x7ffcb56ab078}, {pos = 1727376006, events = 21919, fd = 1740009456, user_data = 0x559f66f49543 }, {pos = 1750048816, events = 21919, fd = 1749871744, user_data = 0x559f684fa030}, {pos = 1173051243, events = 32624, fd = 0, user_data = 0x559f66f5b1ad }, {pos = 1750048816, events = 1, fd = 1727378166, user_data = 0x559f684cec80}, {pos = 1302148352, events = 197775821, fd = 0, user_data = 0x7f7045ea2ab1}, {pos = 1172968688, events = 32624, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1749618288, user_data = 0xbc9d1cd4d9d3500}, {pos = 0, events = 0, fd = 1302148352, user_data = 0xc}, {pos = 1302148352, events = 197775821, fd = 0, user_data = 0x7f7045e5b239 }, {pos = 217, events = 0, fd = 1722890820, user_data = 0x400000}, {pos = 0, events = 0, fd = 1749618288, user_data = 0x559f66f493d7 }, {pos = 1749705648, events = 21919, fd = 1749871744, user_data = 0x559f684a63b0}, {pos = 1, events = 0, fd = 0, user_data = 0x559f66f07b71 }, {pos = 12, events = 0, fd = 1750044264, user_data = 0x559f684f8e48}, {pos = 1739946336, events = 21919, fd = 296, user_data = 0x559f66b1625e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1722907291, events = 21919, fd = 1736357424, user_data = 0x559f684cf638}} [13:17:59.692] nevents = 1 [13:17:59.692] __func__ = "ServerLoop" [13:17:59.692] #23 0x0000559f66b1c49c in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x559f6848cce0) at ../src/backend/postmaster/postmaster.c:1371 [13:17:59.692] opt = [13:17:59.692] status = [13:17:59.693] userDoption = [13:17:59.693] listen_addr_saved = false [13:17:59.693] output_config_variable = [13:17:59.693] __func__ = "PostmasterMain" [13:17:59.693] #24 0x0000559f66948b3e in main (argc=4, argv=0x559f6848cce0) at ../src/backend/main/main.c:230 [13:17:59.693] do_check_root = [13:17:59.693] dispatch_option = [13:17:59.711] -e [13:17:59.711] [13:17:59.711] [13:17:59.798] dumping /tmp/cores/postgres-6-23275.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:18:00.037] [New LWP 23275] [13:18:00.037] [13:18:00.037] This GDB supports auto-downloading debuginfo from the following URLs: [13:18:00.037] [13:18:00.037] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:18:00.037] Debuginfod has been disabled. [13:18:00.037] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:18:00.270] [Thread debugging using libthread_db enabled] [13:18:00.270] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:18:00.270] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN '. [13:18:00.270] Program terminated with signal SIGABRT, Aborted. [13:18:00.270] #0 0x00007f612a8a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:01.146] [13:18:01.146] Thread 1 (Thread 0x7f612841ff00 (LWP 23275)): [13:18:01.146] #0 0x00007f612a8a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:01.146] No symbol table info available. [13:18:01.146] #1 0x00007f612a85afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:01.146] No symbol table info available. [13:18:01.146] #2 0x00007f612a845472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:01.146] No symbol table info available. [13:18:01.146] #3 0x00007f612aa1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [13:18:01.146] No locals. [13:18:01.146] #4 0x00007f612aa2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [13:18:01.146] No locals. [13:18:01.146] #5 0x00007f612aa0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55db78328480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [13:18:01.146] bp = 140723063462880 [13:18:01.146] pc = [13:18:01.146] Opts = {FromUnrecoverableHandler = true, pc = 94401088827024, bp = 94401116638280} [13:18:01.146] #6 0x000055db775dae90 in examine_self_contradictory_rels (root=root@entry=0x55db7913c1f8, rel=rel@entry=0x55db790d6cc8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [13:18:01.146] lc__state = [13:18:01.146] rlist = [13:18:01.146] i = 2 [13:18:01.146] br = [13:18:01.146] expression = [13:18:01.146] or_rinfo = 0x55db79061998 [13:18:01.146] ccxt = [13:18:01.146] delidx = 0x55db79061831 [13:18:01.146] arglst = [13:18:01.146] lc = [13:18:01.146] arg = [13:18:01.146] n = [13:18:01.146] restrictinfo = [13:18:01.146] ccwapper = {clausecxt = 0x55db790611c8} [13:18:01.146] sec = {sopcinfo = {n_members = 38, opcies = 0x55db79060c98}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x55db79060448, atop_set = 0x55db790610a8}, ccfree = 0x55db79061800, vifree = 0x55db79061338} [13:18:01.146] __func__ = "examine_self_contradictory_rels" [13:18:01.146] #7 0x000055db775db09f in examine_self_contradictory_rels_phase1 (root=root@entry=0x55db7913c1f8) at ../src/backend/optimizer/plan/contradictory.c:2608 [13:18:01.146] rel = 0x55db790d6cc8 [13:18:01.146] rti = 1 [13:18:01.146] rinfo = [13:18:01.146] #8 0x000055db775a6058 in query_planner (root=root@entry=0x55db7913c1f8, qp_callback=qp_callback@entry=0x55db775ab375 , qp_extra=qp_extra@entry=0x7ffca4359de0) at ../src/backend/optimizer/plan/planmain.c:193 [13:18:01.146] parse = 0x55db78e30d18 [13:18:01.146] joinlist = 0x55db790604b8 [13:18:01.146] final_rel = [13:18:01.146] __func__ = "query_planner" [13:18:01.146] #9 0x000055db775b8ad4 in grouping_planner (root=root@entry=0x55db7913c1f8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [13:18:01.146] sort_input_targets = 0x5 [13:18:01.146] sort_input_target_parallel_safe = [13:18:01.146] grouping_target = [13:18:01.146] scanjoin_target = [13:18:01.146] activeWindows = 0x0 [13:18:01.146] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [13:18:01.146] sort_input_targets_contain_srfs = 0x1 [13:18:01.146] have_grouping = [13:18:01.146] wflists = 0x0 [13:18:01.146] gset_data = 0x0 [13:18:01.146] sort_input_target = [13:18:01.146] grouping_targets = 0x1 [13:18:01.146] grouping_target_parallel_safe = [13:18:01.146] scanjoin_targets = 0x0 [13:18:01.146] scanjoin_target_parallel_safe = [13:18:01.146] grouping_targets_contain_srfs = 0x1 [13:18:01.146] scanjoin_targets_contain_srfs = 0x55db77b2095d [13:18:01.146] scanjoin_target_same_exprs = [13:18:01.146] parse = 0x55db78e30d18 [13:18:01.146] offset_est = 0 [13:18:01.146] count_est = 0 [13:18:01.146] limit_tuples = -1 [13:18:01.146] have_postponed_srfs = false [13:18:01.146] final_target = [13:18:01.146] final_targets = 0x55db78f31ec8 [13:18:01.146] final_targets_contain_srfs = 0x55db77516ad2 [13:18:01.146] final_target_parallel_safe = [13:18:01.146] current_rel = [13:18:01.146] final_rel = [13:18:01.146] extra = {limit_needed = false, limit_tuples = 4.6640334510670837e-310, count_est = 94401117540504, offset_est = 94401117540504} [13:18:01.146] lc = [13:18:01.146] __func__ = "grouping_planner" [13:18:01.146] #10 0x000055db775bba58 in subquery_planner (glob=glob@entry=0x55db7904a838, parse=parse@entry=0x55db78e30d18, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [13:18:01.146] root = 0x55db7913c1f8 [13:18:01.146] newWithCheckOptions = [13:18:01.146] newHaving = 0x0 [13:18:01.146] hasOuterJoins = [13:18:01.146] hasResultRTEs = false [13:18:01.146] final_rel = [13:18:01.146] l = 0x0 [13:18:01.146] #11 0x000055db775bc6e9 in standard_planner (parse=0x55db78e30d18, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [13:18:01.146] result = [13:18:01.146] glob = 0x55db7904a838 [13:18:01.146] tuple_fraction = 0 [13:18:01.146] root = [13:18:01.146] final_rel = [13:18:01.146] best_path = [13:18:01.146] top_plan = [13:18:01.146] lp = [13:18:01.146] lr = [13:18:01.146] #12 0x000055db775bd753 in planner (parse=parse@entry=0x55db78e30d18, query_string=query_string@entry=0x55db78e2fa70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [13:18:01.146] result = [13:18:01.146] #13 0x000055db7782cd7d in pg_plan_query (querytree=querytree@entry=0x55db78e30d18, query_string=query_string@entry=0x55db78e2fa70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [13:18:01.146] plan = [13:18:01.146] #14 0x000055db7732f0a2 in standard_ExplainOneQuery (query=0x55db78e30d18, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55db7904a598, queryString=0x55db78e2fa70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [13:18:01.146] plan = [13:18:01.146] planstart = [13:18:01.146] planduration = {ticks = 94401088001014} [13:18:01.146] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94401094268499, shared_blks_dirtied = 2754977998, shared_blks_written = 3, local_blks_hit = 4294967392, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94401114344728, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94401094355293}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94401087998395}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94401114344728}} [13:18:01.146] bufusage = {shared_blks_hit = 0, shared_blks_read = 94401091024420, shared_blks_dirtied = 73181947772931, shared_blks_written = 72057594037927936, local_blks_hit = 140055110063776, local_blks_read = 94401114345904, local_blks_dirtied = 94401114344728, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94401093882911, shared_blk_read_time = {ticks = 140055110063776}, shared_blk_write_time = {ticks = 94401093882930}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94401094264082}, temp_blk_read_time = {ticks = 94401114516768}, temp_blk_write_time = {ticks = 64}} [13:18:01.146] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140723063464016, freespace = 10} [13:18:01.146] planner_ctx = 0x0 [13:18:01.146] saved_ctx = 0x0 [13:18:01.146] #15 0x000055db7732f388 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55db7904a598, pstate=pstate@entry=0x55db78e5afd8, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [13:18:01.146] No locals. [13:18:01.146] #16 0x000055db773302df in ExplainQuery (pstate=pstate@entry=0x55db78e5afd8, stmt=stmt@entry=0x55db78e30b58, params=params@entry=0x0, dest=dest@entry=0x55db78e5af48) at ../src/backend/commands/explain.c:357 [13:18:01.146] l__state = [13:18:01.146] l = 0x55db790d6c90 [13:18:01.146] es = 0x55db7904a598 [13:18:01.146] tstate = [13:18:01.146] jstate = [13:18:01.146] query = [13:18:01.146] rewritten = 0x55db790d6c78 [13:18:01.146] lc = 0x0 [13:18:01.146] timing_set = false [13:18:01.146] buffers_set = false [13:18:01.146] summary_set = false [13:18:01.146] __func__ = "ExplainQuery" [13:18:01.146] #17 0x000055db7783779d in standard_ProcessUtility (pstmt=0x55db78e30c08, queryString=0x55db78e2fa70 "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=0x55db78e5af48, qc=0x7ffca435a2d0) at ../src/backend/tcop/utility.c:866 [13:18:01.146] parsetree = 0x55db78e30b58 [13:18:01.146] isTopLevel = true [13:18:01.146] isAtomicContext = false [13:18:01.146] pstate = 0x55db78e5afd8 [13:18:01.146] readonly_flags = [13:18:01.146] __func__ = "standard_ProcessUtility" [13:18:01.146] #18 0x000055db77837ec6 in ProcessUtility (pstmt=pstmt@entry=0x55db78e30c08, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55db78e5af48, qc=0x7ffca435a2d0) at ../src/backend/tcop/utility.c:523 [13:18:01.146] No locals. [13:18:01.146] #19 0x000055db77833884 in PortalRunUtility (portal=portal@entry=0x55db78eb17e0, pstmt=0x55db78e30c08, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55db78e5af48, qc=qc@entry=0x7ffca435a2d0) at ../src/backend/tcop/pquery.c:1152 [13:18:01.146] No locals. [13:18:01.146] #20 0x000055db778340f7 in FillPortalStore (portal=portal@entry=0x55db78eb17e0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [13:18:01.146] treceiver = 0x55db78e5af48 [13:18:01.146] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:18:01.146] __func__ = "FillPortalStore" [13:18:01.146] #21 0x000055db77834612 in PortalRun (portal=portal@entry=0x55db78eb17e0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55db78f322d8, altdest=altdest@entry=0x55db78f322d8, qc=qc@entry=0x7ffca435a490) at ../src/backend/tcop/pquery.c:759 [13:18:01.146] _save_exception_stack = 0x7ffca435a540 [13:18:01.146] _save_context_stack = 0x0 [13:18:01.146] _local_sigjmp_buf = {{__jmpbuf = {0, -7717918128279638812, 94401114871776, 94401114344400, 94401114344376, 94401114344328, -4563329670884872988, -7717924314104058652}, __mask_was_saved = 0, __saved_mask = {__val = {94401094268499, 2754978847, 4, 94401114344328, 112, 153, 94401114871776, 94401114344400, 94401114344376, 94401114344328, 94401094355702, 1, 2, 153, 94401083611551, 0}}}} [13:18:01.146] _do_rethrow = [13:18:01.146] result = [13:18:01.146] nprocessed = [13:18:01.146] saveTopTransactionResourceOwner = 0x55db78e6e998 [13:18:01.146] saveTopTransactionContext = 0x55db78ec5c50 [13:18:01.146] saveActivePortal = 0x0 [13:18:01.146] saveResourceOwner = 0x55db78e6e998 [13:18:01.146] savePortalContext = 0x0 [13:18:01.146] saveMemoryContext = 0x55db78ec5c50 [13:18:01.146] __func__ = "PortalRun" [13:18:01.146] #22 0x000055db7782d849 in exec_simple_query (query_string=query_string@entry=0x55db78e2fa70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1271 [13:18:01.146] cmdtaglen = 7 [13:18:01.146] snapshot_set = [13:18:01.146] per_parsetree_context = 0x0 [13:18:01.146] plantree_list = 0x55db78f32288 [13:18:01.146] parsetree = 0x55db78e30b88 [13:18:01.146] commandTag = [13:18:01.146] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:18:01.146] querytree_list = [13:18:01.146] portal = 0x55db78eb17e0 [13:18:01.146] receiver = 0x55db78f322d8 [13:18:01.146] format = 0 [13:18:01.146] cmdtagname = [13:18:01.146] parsetree_item__state = [13:18:01.146] dest = DestRemote [13:18:01.146] oldcontext = 0x55db78ec5c50 [13:18:01.146] parsetree_list = 0x55db78e30bb8 [13:18:01.146] parsetree_item = 0x55db78e30bd0 [13:18:01.146] save_log_statement_stats = false [13:18:01.146] was_logged = true [13:18:01.146] use_implicit_block = false [13:18:01.146] msec_str = "\004\000\000\000\000\000\000\000\240Юw\333U\000\000 \2455\244\374\177\000\000n\000\000\000\000\000\000" [13:18:01.146] __func__ = "exec_simple_query" [13:18:01.146] #23 0x000055db778305a2 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [13:18:01.146] query_string = 0x55db78e2fa70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [13:18:01.146] firstchar = [13:18:01.146] input_message = {data = 0x55db78e2fa70 "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} [13:18:01.146] local_sigjmp_buf = {{__jmpbuf = {94401106980920, -7717917032575390492, 140723063465628, 4, 13, 140723063465860, -4563329670817764124, -7717924318626173724}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94401114070512, 14336, 94401106974976, 94401114593616, 13, 94401094268047, 0, 9, 2, 94401106980928, 94401114070512, 94401106974976, 4, 13, 140723063465860}}}} [13:18:01.146] send_ready_for_query = false [13:18:01.146] idle_in_transaction_timeout_enabled = false [13:18:01.146] idle_session_timeout_enabled = false [13:18:01.146] __func__ = "PostgresMain" [13:18:01.146] #24 0x000055db7782660d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:18:01.146] bsdata = [13:18:01.146] #25 0x000055db776d7d47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=13, startup_data=startup_data@entry=0x7ffca435a69c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffca435a6f0) at ../src/backend/postmaster/launch_backend.c:274 [13:18:01.146] pid = [13:18:01.146] #26 0x000055db776dcd42 in BackendStartup (client_sock=client_sock@entry=0x7ffca435a6f0) at ../src/backend/postmaster/postmaster.c:3386 [13:18:01.146] bn = 0x55db78e574f8 [13:18:01.146] pid = [13:18:01.146] startup_data = {canAcceptConnections = CAC_OK} [13:18:01.146] cac = [13:18:01.146] __func__ = "BackendStartup" [13:18:01.146] #27 0x000055db776dec1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [13:18:01.146] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\"\006\206v\333U\000\000\300\347\201v\333U\000\000@\2505\244\374\177\000\0008\2505\244\374\177\000\000\225[\362\001\000\000\000\000\240\304\003+a\177\000\000+", '\000' , "\374\177\000\000\000\004\000\000\000\000\000\000h&\022,a\177\000\0000\306\003+a\177\000\000\340\"\022,a\177\000\000\316)fR\000\000\000", __ss_align = 2754979968}, salen = 2}} [13:18:01.146] i = 0 [13:18:01.146] now = [13:18:01.146] last_lockfile_recheck_time = 1735045978 [13:18:01.146] last_touch_time = 1735045978 [13:18:01.146] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 721667632, events = 32609, fd = 739386080, user_data = 0x7c96e577}, {pos = -1539987264, events = 32764, fd = 739215944, user_data = 0xf}, {pos = 721667632, events = 32609, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 739386080, user_data = 0x7ffca435a838}, {pos = -1539987392, events = 32764, fd = 739386984, user_data = 0x0}, {pos = 2028141192, events = 21979, fd = 713783946, user_data = 0x55db78e2fa88}, {pos = 1, events = 21979, fd = 32768, user_data = 0xffffffff}, {pos = 713220128, events = 32609, fd = 735231904, user_data = 0x55db78e5b048}, {pos = 2028318504, events = 21979, fd = 2028315889, user_data = 0x7f612c0feebe}, {pos = 1, events = 0, fd = 739386080, user_data = 0x1aa}, {pos = 2013711696, events = 21979, fd = 0, user_data = 0xd8}, {pos = 2028141192, events = 21979, fd = 739241662, user_data = 0x1}, {pos = 0, events = 0, fd = 713220128, user_data = 0x7f612a8f2e40 }, {pos = 16, events = 0, fd = -1539986256, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f612c1011ba}, {pos = 0, events = 0, fd = 713747876, user_data = 0x0}, {pos = 2020717536, events = 21979, fd = 2, user_data = 0x0}, {pos = 2027888272, events = 21979, fd = 2004612161, user_data = 0x55db78e627f0}, {pos = 2004616150, events = 21979, fd = 2028349515, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = 713254088, user_data = 0x7f612a89c880 }, {pos = 675413432, events = 32609, fd = -1539986064, user_data = 0x100007f00000002}, {pos = 713780999, events = 32609, fd = 2, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = 715070560, events = 32609, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 2028322704, events = 21979, fd = 713783946, user_data = 0xa}, {pos = 2008065298, events = 21979, fd = 2028330928, user_data = 0x7f612a8b58be}, {pos = 715053536, events = 32609, fd = 713691502, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x56350bfdc4744c00}, {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 = 0x55db78e5ad20}, {pos = 1, events = 0, fd = 2028318184, user_data = 0x3}, {pos = 0, events = 0, fd = 22248, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 2028141192, user_data = 0x7f612a8f3053 }, {pos = 2028318184, events = 21979, fd = 1024, user_data = 0x7ffca435ad78}, {pos = 2008148614, events = 21979, fd = 2020782064, user_data = 0x55db77b0d543 }, {pos = 2028317984, events = 21979, fd = 2028140912, user_data = 0x55db78e5ad20}, {pos = 713774955, events = 32609, fd = 0, user_data = 0x55db77b1f1ad }, {pos = 2028317984, events = 1, fd = 2008150774, user_data = 0x55db78e2f970}, {pos = -999011328, events = 1446317053, fd = 0, user_data = 0x7f612a8a2ab1}, {pos = 713692400, events = 32609, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2027888272, user_data = 0x56350bfdc4744c00}, {pos = 0, events = 0, fd = -999011328, user_data = 0xc}, {pos = -999011328, events = 1446317053, fd = 0, user_data = 0x7f612a85b239 }, {pos = 217, events = 0, fd = 2003663428, user_data = 0x400000}, {pos = 0, events = 0, fd = 2027888272, user_data = 0x55db77b0d3d7 }, {pos = 2027974816, events = 21979, fd = 2028140912, user_data = 0x55db78e070a0}, {pos = 1, events = 0, fd = 0, user_data = 0x55db77acbb71 }, {pos = 12, events = 0, fd = 2028313432, user_data = 0x55db78e59b38}, {pos = 2020718944, events = 21979, fd = 296, user_data = 0x55db776da25e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 2003679899, events = 21979, fd = 2017130032, user_data = 0x55db78e30318}} [13:18:01.147] nevents = 1 [13:18:01.147] __func__ = "ServerLoop" [13:18:01.147] #28 0x000055db776e049c in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55db78dedd00) at ../src/backend/postmaster/postmaster.c:1371 [13:18:01.147] opt = [13:18:01.147] status = [13:18:01.147] userDoption = [13:18:01.147] listen_addr_saved = false [13:18:01.147] output_config_variable = [13:18:01.147] __func__ = "PostmasterMain" [13:18:01.147] #29 0x000055db7750cb3e in main (argc=4, argv=0x55db78dedd00) at ../src/backend/main/main.c:230 [13:18:01.147] do_check_root = [13:18:01.147] dispatch_option = [13:18:01.181] -e [13:18:01.181] [13:18:01.181] [13:18:01.270] dumping /tmp/cores/postgres-6-22294.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [13:18:01.509] [New LWP 22294] [13:18:01.509] [13:18:01.509] This GDB supports auto-downloading debuginfo from the following URLs: [13:18:01.509] [13:18:01.509] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:18:01.509] Debuginfod has been disabled. [13:18:01.509] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:18:01.745] [Thread debugging using libthread_db enabled] [13:18:01.745] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:18:01.745] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [13:18:01.745] Program terminated with signal SIGABRT, Aborted. [13:18:01.745] #0 0x00007f9b666a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:02.621] [13:18:02.621] Thread 1 (Thread 0x7f9b663ddf00 (LWP 22294)): [13:18:02.621] #0 0x00007f9b666a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:02.621] No symbol table info available. [13:18:02.621] #1 0x00007f9b6665afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:02.621] No symbol table info available. [13:18:02.621] #2 0x00007f9b66645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:02.621] No symbol table info available. [13:18:02.621] #3 0x00007f9b6681e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [13:18:02.621] No locals. [13:18:02.621] #4 0x00007f9b6682aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [13:18:02.621] No locals. [13:18:02.621] #5 0x00007f9b6680dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x559978980480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [13:18:02.621] bp = 140735132048832 [13:18:02.621] pc = [13:18:02.621] Opts = {FromUnrecoverableHandler = true, pc = 94117627637392, bp = 94117653503816} [13:18:02.621] #6 0x0000559977c32e90 in examine_self_contradictory_rels (root=root@entry=0x559979505868, rel=rel@entry=0x5599793fe0a8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [13:18:02.621] lc__state = [13:18:02.621] rlist = [13:18:02.621] i = 2 [13:18:02.621] br = [13:18:02.621] expression = [13:18:02.621] or_rinfo = 0x5599794dec98 [13:18:02.621] ccxt = [13:18:02.621] delidx = 0x5599794deb31 [13:18:02.621] arglst = [13:18:02.621] lc = [13:18:02.621] arg = [13:18:02.621] n = [13:18:02.621] restrictinfo = [13:18:02.621] ccwapper = {clausecxt = 0x5599794de4c8} [13:18:02.621] sec = {sopcinfo = {n_members = 38, opcies = 0x5599794ddf98}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x5599794dd748, atop_set = 0x5599794de3a8}, ccfree = 0x5599794deb00, vifree = 0x5599794de638} [13:18:02.621] __func__ = "examine_self_contradictory_rels" [13:18:02.621] #7 0x0000559977c3309f in examine_self_contradictory_rels_phase1 (root=root@entry=0x559979505868) at ../src/backend/optimizer/plan/contradictory.c:2608 [13:18:02.621] rel = 0x5599793fe0a8 [13:18:02.621] rti = 1 [13:18:02.621] rinfo = [13:18:02.621] #8 0x0000559977bfe058 in query_planner (root=root@entry=0x559979505868, qp_callback=qp_callback@entry=0x559977c03375 , qp_extra=qp_extra@entry=0x7fff738d9fc0) at ../src/backend/optimizer/plan/planmain.c:193 [13:18:02.621] parse = 0x5599791dad98 [13:18:02.621] joinlist = 0x5599794dd7b8 [13:18:02.621] final_rel = [13:18:02.621] __func__ = "query_planner" [13:18:02.621] #9 0x0000559977c10ad4 in grouping_planner (root=root@entry=0x559979505868, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [13:18:02.621] sort_input_targets = 0x5 [13:18:02.621] sort_input_target_parallel_safe = [13:18:02.621] grouping_target = [13:18:02.621] scanjoin_target = [13:18:02.621] activeWindows = 0x0 [13:18:02.621] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [13:18:02.621] sort_input_targets_contain_srfs = 0x1 [13:18:02.621] have_grouping = [13:18:02.621] wflists = 0x0 [13:18:02.621] gset_data = 0x0 [13:18:02.621] sort_input_target = [13:18:02.621] grouping_targets = 0x1 [13:18:02.621] grouping_target_parallel_safe = [13:18:02.621] scanjoin_targets = 0x0 [13:18:02.621] scanjoin_target_parallel_safe = [13:18:02.621] grouping_targets_contain_srfs = 0x1 [13:18:02.621] scanjoin_targets_contain_srfs = 0x55997817895d [13:18:02.621] scanjoin_target_same_exprs = [13:18:02.621] parse = 0x5599791dad98 [13:18:02.621] offset_est = 0 [13:18:02.621] count_est = 0 [13:18:02.621] limit_tuples = -1 [13:18:02.621] have_postponed_srfs = false [13:18:02.621] final_target = [13:18:02.621] final_targets = 0x5599792dadd8 [13:18:02.621] final_targets_contain_srfs = 0x559977b6ead2 [13:18:02.621] final_target_parallel_safe = [13:18:02.621] current_rel = [13:18:02.621] final_rel = [13:18:02.621] extra = {limit_needed = false, limit_tuples = 4.6500286074944375e-310, count_est = 94117653669640, offset_est = 94117653669640} [13:18:02.621] lc = [13:18:02.621] __func__ = "grouping_planner" [13:18:02.621] #10 0x0000559977c13a58 in subquery_planner (glob=glob@entry=0x55997942c6c8, parse=parse@entry=0x5599791dad98, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [13:18:02.621] root = 0x559979505868 [13:18:02.621] newWithCheckOptions = [13:18:02.621] newHaving = 0x0 [13:18:02.621] hasOuterJoins = [13:18:02.621] hasResultRTEs = false [13:18:02.621] final_rel = [13:18:02.621] l = 0x0 [13:18:02.621] #11 0x0000559977c146e9 in standard_planner (parse=0x5599791dad98, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [13:18:02.621] result = [13:18:02.621] glob = 0x55997942c6c8 [13:18:02.621] tuple_fraction = 0 [13:18:02.621] root = [13:18:02.621] final_rel = [13:18:02.621] best_path = [13:18:02.621] top_plan = [13:18:02.621] lp = [13:18:02.621] lr = [13:18:02.621] #12 0x0000559977c15753 in planner (parse=parse@entry=0x5599791dad98, query_string=query_string@entry=0x5599791d9af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [13:18:02.621] result = [13:18:02.621] #13 0x0000559977e84d7d in pg_plan_query (querytree=querytree@entry=0x5599791dad98, query_string=query_string@entry=0x5599791d9af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [13:18:02.621] plan = [13:18:02.621] #14 0x00005599779870a2 in standard_ExplainOneQuery (query=0x5599791dad98, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55997942c428, queryString=0x5599791d9af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [13:18:02.621] plan = [13:18:02.621] planstart = [13:18:02.621] planduration = {ticks = 94117626811382} [13:18:02.621] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94117633078867, shared_blks_dirtied = 1938662062, shared_blks_written = 3, local_blks_hit = 4294967392, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94117650345368, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94117633165661}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94117626808763}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94117650345368}} [13:18:02.621] bufusage = {shared_blks_hit = 0, shared_blks_read = 94117629834788, shared_blks_dirtied = 73053098754048, shared_blks_written = 72057594037927936, local_blks_hit = 140305218692768, local_blks_read = 94117650346544, local_blks_dirtied = 94117650345368, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94117632693279, shared_blk_read_time = {ticks = 140305218692768}, shared_blk_write_time = {ticks = 94117632693298}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94117633074450}, temp_blk_read_time = {ticks = 94117650517616}, temp_blk_write_time = {ticks = 64}} [13:18:02.621] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140735132049968, freespace = 10} [13:18:02.621] planner_ctx = 0x0 [13:18:02.621] saved_ctx = 0x0 [13:18:02.621] #15 0x0000559977987388 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55997942c428, pstate=pstate@entry=0x559979205128, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [13:18:02.621] No locals. [13:18:02.621] #16 0x00005599779882df in ExplainQuery (pstate=pstate@entry=0x559979205128, stmt=stmt@entry=0x5599791dabd8, params=params@entry=0x0, dest=dest@entry=0x559979205098) at ../src/backend/commands/explain.c:357 [13:18:02.621] l__state = [13:18:02.621] l = 0x5599793fe070 [13:18:02.621] es = 0x55997942c428 [13:18:02.621] tstate = [13:18:02.621] jstate = [13:18:02.621] query = [13:18:02.621] rewritten = 0x5599793fe058 [13:18:02.621] lc = 0x0 [13:18:02.621] timing_set = false [13:18:02.621] buffers_set = false [13:18:02.621] summary_set = false [13:18:02.621] __func__ = "ExplainQuery" [13:18:02.621] #17 0x0000559977e8f79d in standard_ProcessUtility (pstmt=0x5599791dac88, queryString=0x5599791d9af0 "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=0x559979205098, qc=0x7fff738da4b0) at ../src/backend/tcop/utility.c:866 [13:18:02.621] parsetree = 0x5599791dabd8 [13:18:02.621] isTopLevel = true [13:18:02.621] isAtomicContext = false [13:18:02.621] pstate = 0x559979205128 [13:18:02.621] readonly_flags = [13:18:02.621] __func__ = "standard_ProcessUtility" [13:18:02.621] #18 0x0000559977e8fec6 in ProcessUtility (pstmt=pstmt@entry=0x5599791dac88, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x559979205098, qc=0x7fff738da4b0) at ../src/backend/tcop/utility.c:523 [13:18:02.621] No locals. [13:18:02.621] #19 0x0000559977e8b884 in PortalRunUtility (portal=portal@entry=0x55997925e100, pstmt=0x5599791dac88, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x559979205098, qc=qc@entry=0x7fff738da4b0) at ../src/backend/tcop/pquery.c:1152 [13:18:02.621] No locals. [13:18:02.621] #20 0x0000559977e8c0f7 in FillPortalStore (portal=portal@entry=0x55997925e100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [13:18:02.621] treceiver = 0x559979205098 [13:18:02.621] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:18:02.621] __func__ = "FillPortalStore" [13:18:02.621] #21 0x0000559977e8c612 in PortalRun (portal=portal@entry=0x55997925e100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5599792db1e8, altdest=altdest@entry=0x5599792db1e8, qc=qc@entry=0x7fff738da670) at ../src/backend/tcop/pquery.c:759 [13:18:02.621] _save_exception_stack = 0x7fff738da720 [13:18:02.621] _save_context_stack = 0x0 [13:18:02.621] _local_sigjmp_buf = {{__jmpbuf = {0, 6202506833107903170, 94117650882816, 94117650345040, 94117650345016, 94117650344968, 207075809759093442, 6202484252950815426}, __mask_was_saved = 0, __saved_mask = {__val = {94117633078867, 1938662911, 4, 94117650344968, 112, 153, 94117650882816, 94117650345040, 94117650345016, 94117650344968, 94117633166070, 1, 2, 153, 94117622421919, 0}}}} [13:18:02.621] _do_rethrow = [13:18:02.621] result = [13:18:02.621] nprocessed = [13:18:02.621] saveTopTransactionResourceOwner = 0x55997921adb8 [13:18:02.621] saveTopTransactionContext = 0x559979270530 [13:18:02.621] saveActivePortal = 0x0 [13:18:02.621] saveResourceOwner = 0x55997921adb8 [13:18:02.621] savePortalContext = 0x0 [13:18:02.621] saveMemoryContext = 0x559979270530 [13:18:02.621] __func__ = "PortalRun" [13:18:02.621] #22 0x0000559977e85849 in exec_simple_query (query_string=query_string@entry=0x5599791d9af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1271 [13:18:02.621] cmdtaglen = 7 [13:18:02.621] snapshot_set = [13:18:02.621] per_parsetree_context = 0x0 [13:18:02.621] plantree_list = 0x5599792db198 [13:18:02.621] parsetree = 0x5599791dac08 [13:18:02.621] commandTag = [13:18:02.621] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:18:02.621] querytree_list = [13:18:02.621] portal = 0x55997925e100 [13:18:02.621] receiver = 0x5599792db1e8 [13:18:02.621] format = 0 [13:18:02.621] cmdtagname = [13:18:02.621] parsetree_item__state = [13:18:02.621] dest = DestRemote [13:18:02.621] oldcontext = 0x559979270530 [13:18:02.621] parsetree_list = 0x5599791dac38 [13:18:02.621] parsetree_item = 0x5599791dac50 [13:18:02.621] save_log_statement_stats = false [13:18:02.621] was_logged = false [13:18:02.621] use_implicit_block = false [13:18:02.621] msec_str = "\004\000\000\000\000\000\000\000\240P\024x\231U\000\000\000\247\215s\377\177\000\000n\000\000\000\000\000\000" [13:18:02.621] __func__ = "exec_simple_query" [13:18:02.621] #23 0x0000559977e885a2 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [13:18:02.621] query_string = 0x5599791d9af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [13:18:02.621] firstchar = [13:18:02.621] input_message = {data = 0x5599791d9af0 "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} [13:18:02.621] local_sigjmp_buf = {{__jmpbuf = {94117645791288, 6202504458036077250, 140735132051580, 4, 11, 140735132051812, 207075809826202306, 6202484256214377154}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94117650071056, 15616, 94117645785344, 94117650603376, 11, 94117633078415, 0, 9, 2, 94117645791296, 94117650071056, 94117645785344, 4, 11, 140735132051812}}}} [13:18:02.621] send_ready_for_query = false [13:18:02.621] idle_in_transaction_timeout_enabled = false [13:18:02.621] idle_session_timeout_enabled = false [13:18:02.621] __func__ = "PostgresMain" [13:18:02.621] #24 0x0000559977e7e60d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:18:02.621] bsdata = [13:18:02.621] #25 0x0000559977d2fd47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=11, startup_data=startup_data@entry=0x7fff738da87c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff738da8d0) at ../src/backend/postmaster/launch_backend.c:274 [13:18:02.621] pid = [13:18:02.621] #26 0x0000559977d34d42 in BackendStartup (client_sock=client_sock@entry=0x7fff738da8d0) at ../src/backend/postmaster/postmaster.c:3386 [13:18:02.621] bn = 0x559979202248 [13:18:02.621] pid = [13:18:02.621] startup_data = {canAcceptConnections = CAC_OK} [13:18:02.621] cac = [13:18:02.621] __func__ = "BackendStartup" [13:18:02.621] #27 0x0000559977d36c1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [13:18:02.621] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "cf\233\177\000\000\240\217Sg\233\177\000\000x\251\215s\377\177\000\000t\251\215s\377\177", '\000' , "\"\206\353v\231U\000\000\300g\347v\231U\000\000@\252\215s\377\177\000\0008\252\215s\377\177\000\000\225[\362\001\000\000\000\000\240D\343f\233\177\000\000+", '\000' , "\231U\000\0000\205\353v\231U\000", __ss_align = 140305440183912}, salen = 2}} [13:18:02.621] i = 0 [13:18:02.621] now = [13:18:02.621] last_lockfile_recheck_time = 1735045975 [13:18:02.621] last_touch_time = 1735045975 [13:18:02.621] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x559976eb8622}, {pos = 1743525480, events = 32667, fd = 1726170672, user_data = 0x7f9b67ec12e0}, {pos = 2090263927, events = 0, fd = 1938664128, user_data = 0x7f9b67e97a48}, {pos = 15, events = 0, fd = 1726170672, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f9b67ec12e0}, {pos = 1938663992, events = 32767, fd = 1938664000, user_data = 0x7f9b67ec1668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 2031990752, events = 21913, fd = 1, user_data = 0x7fff738daf63}, {pos = -1, events = 0, fd = 1717755936, user_data = 0x7f9b67538fa0}, {pos = 2032161176, events = 21913, fd = 2032160888, user_data = 0x559979207461}, {pos = 1743380158, events = 32667, fd = 1, user_data = 0x7f9b67ec12e0}, {pos = 426, events = 0, fd = 2020363600, user_data = 0x0}, {pos = 236, events = 0, fd = 2031983536, user_data = 0x7f9b67e9debe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f9b6662e020}, {pos = 1718562368, events = 32667, fd = 16, user_data = 0x7fff738dae90}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1743389114, events = 32667, fd = 0, user_data = 0x7f9b666aeda4 }, {pos = 0, events = 0, fd = 2027369440, user_data = 0x2}, {pos = 0, events = 0, fd = 2031730352, user_data = 0x559977e1c00f }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 2031983536, user_data = 0x7f9b67e9debe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f9b666364c8}, {pos = 1718316807, events = 32667, fd = 2027425568, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1719606368, events = 32667, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = 0, events = 4294967040, fd = -1, user_data = 0xffffffff00000000}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x332020200a0a386f}, {pos = 822763892, events = 808792887, fd = 926496052, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2032176272, user_data = 0x7f9b666b576b}, {pos = 1719589344, events = 32667, fd = 1718227310, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x3da7a50057a97900}, {pos = 1719592416, events = 32667, fd = -328, user_data = 0x0}, {pos = 2032160568, events = 21913, 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 = 21526, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 2031983536, user_data = 0x7f9b666f3053 }, {pos = 2032160568, events = 21913, fd = 1024, user_data = 0x7fff738daf58}, {pos = 2014800518, events = 21913, fd = 2027433968, user_data = 0x559978165543 }, {pos = 2032160368, events = 21913, fd = 2031983088, user_data = 0x559979204e70}, {pos = 1718310763, events = 32667, fd = 0, user_data = 0x5599781771ad }, {pos = 2032160368, events = 1, fd = 2014802678, user_data = 0x5599791d99f0}, {pos = 1470724352, events = 1034396928, fd = 0, user_data = 0x7f9b666a2ab1}, {pos = 1718228208, events = 32667, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2031730352, user_data = 0x3da7a50057a97900}, {pos = 0, events = 0, fd = 1470724352, user_data = 0xc}, {pos = 1470724352, events = 1034396928, fd = 0, user_data = 0x7f9b6665b239 }, {pos = 237, events = 0, fd = 2010315332, user_data = 0x400000}, {pos = 0, events = 0, fd = 2031730352, user_data = 0x5599781653d7 }, {pos = 2031816992, events = 21913, fd = 2031983088, user_data = 0x5599791b1120}, {pos = 1, events = 0, fd = 0, user_data = 0x559978123b71 }, {pos = 12, events = 0, fd = 2032159944, user_data = 0x559979204ca8}, {pos = 2027370848, events = 21913, fd = 296, user_data = 0x559977d3225e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 2010331803, events = 21913, fd = 2023781936, user_data = 0x5599791da3c8}} [13:18:02.622] nevents = 1 [13:18:02.622] __func__ = "ServerLoop" [13:18:02.622] #28 0x0000559977d3849c in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x559979197d70) at ../src/backend/postmaster/postmaster.c:1371 [13:18:02.622] opt = [13:18:02.622] status = [13:18:02.622] userDoption = [13:18:02.622] listen_addr_saved = false [13:18:02.622] output_config_variable = [13:18:02.622] __func__ = "PostmasterMain" [13:18:02.622] #29 0x0000559977b64b3e in main (argc=8, argv=0x559979197d70) at ../src/backend/main/main.c:230 [13:18:02.622] do_check_root = [13:18:02.622] dispatch_option = [13:18:02.656] -e [13:18:02.656] [13:18:02.656] [13:18:02.715] dumping /tmp/cores/postgres-6-28588.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [13:18:02.959] [New LWP 28588] [13:18:02.959] [13:18:02.959] This GDB supports auto-downloading debuginfo from the following URLs: [13:18:02.959] [13:18:02.959] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:18:02.959] Debuginfod has been disabled. [13:18:02.959] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:18:03.056] [Thread debugging using libthread_db enabled] [13:18:03.056] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:18:03.056] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [13:18:03.056] Program terminated with signal SIGABRT, Aborted. [13:18:03.056] #0 0x00007f9b666a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:03.944] [13:18:03.944] Thread 1 (Thread 0x7f9b663ddf00 (LWP 28588)): [13:18:03.944] #0 0x00007f9b666a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:03.944] No symbol table info available. [13:18:03.944] #1 0x00007f9b6665afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:03.944] No symbol table info available. [13:18:03.944] #2 0x00007f9b66645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:03.944] No symbol table info available. [13:18:03.944] #3 0x00007f9b6681e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [13:18:03.944] No locals. [13:18:03.944] #4 0x00007f9b6682aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [13:18:03.944] No locals. [13:18:03.944] #5 0x00007f9b6680dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x559978980480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [13:18:03.944] bp = 140735132048832 [13:18:03.944] pc = [13:18:03.944] Opts = {FromUnrecoverableHandler = true, pc = 94117627637392, bp = 94117650729960} [13:18:03.944] #6 0x0000559977c32e90 in examine_self_contradictory_rels (root=root@entry=0x5599792d3458, rel=rel@entry=0x5599792d5d18, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [13:18:03.944] lc__state = [13:18:03.944] rlist = [13:18:03.944] i = 2 [13:18:03.944] br = [13:18:03.944] expression = [13:18:03.944] or_rinfo = 0x5599792397c8 [13:18:03.944] ccxt = [13:18:03.944] delidx = 0x559979239761 [13:18:03.944] arglst = [13:18:03.944] lc = [13:18:03.944] arg = [13:18:03.944] n = [13:18:03.944] restrictinfo = [13:18:03.944] ccwapper = {clausecxt = 0x5599792390c8} [13:18:03.944] sec = {sopcinfo = {n_members = 38, opcies = 0x559979238c38}, attrsdc = {min_attr = -6, max_attr = 5, len_set = 2, atop_array = 0x559979238328, atop_set = 0x5599792384a8}, ccfree = 0x559979239730, vifree = 0x5599792392d0} [13:18:03.944] __func__ = "examine_self_contradictory_rels" [13:18:03.944] #7 0x0000559977c3309f in examine_self_contradictory_rels_phase1 (root=root@entry=0x5599792d3458) at ../src/backend/optimizer/plan/contradictory.c:2608 [13:18:03.944] rel = 0x5599792d5d18 [13:18:03.944] rti = 1 [13:18:03.944] rinfo = [13:18:03.944] #8 0x0000559977bfe058 in query_planner (root=root@entry=0x5599792d3458, qp_callback=qp_callback@entry=0x559977c03375 , qp_extra=qp_extra@entry=0x7fff738d9fc0) at ../src/backend/optimizer/plan/planmain.c:193 [13:18:03.944] parse = 0x5599791db0e0 [13:18:03.944] joinlist = 0x559979238518 [13:18:03.944] final_rel = [13:18:03.944] __func__ = "query_planner" [13:18:03.944] #9 0x0000559977c10ad4 in grouping_planner (root=root@entry=0x5599792d3458, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [13:18:03.944] sort_input_targets = 0x5 [13:18:03.944] sort_input_target_parallel_safe = [13:18:03.944] grouping_target = [13:18:03.944] scanjoin_target = [13:18:03.944] activeWindows = 0x0 [13:18:03.944] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [13:18:03.944] sort_input_targets_contain_srfs = 0x1 [13:18:03.944] have_grouping = [13:18:03.944] wflists = 0x0 [13:18:03.944] gset_data = 0x0 [13:18:03.944] sort_input_target = [13:18:03.944] grouping_targets = 0x1 [13:18:03.944] grouping_target_parallel_safe = [13:18:03.944] scanjoin_targets = 0x0 [13:18:03.944] scanjoin_target_parallel_safe = [13:18:03.944] grouping_targets_contain_srfs = 0x1 [13:18:03.944] scanjoin_targets_contain_srfs = 0x55997817895d [13:18:03.944] scanjoin_target_same_exprs = [13:18:03.944] parse = 0x5599791db0e0 [13:18:03.944] offset_est = 0 [13:18:03.944] count_est = 0 [13:18:03.944] limit_tuples = -1 [13:18:03.944] have_postponed_srfs = false [13:18:03.944] final_target = [13:18:03.944] final_targets = 0x5599792bc108 [13:18:03.944] final_targets_contain_srfs = 0x559977b6ead2 [13:18:03.944] final_target_parallel_safe = [13:18:03.944] current_rel = [13:18:03.944] final_rel = [13:18:03.944] extra = {limit_needed = false, limit_tuples = 4.6500286074944375e-310, count_est = 94117651366648, offset_est = 94117651366648} [13:18:03.944] lc = [13:18:03.944] __func__ = "grouping_planner" [13:18:03.944] #10 0x0000559977c13a58 in subquery_planner (glob=glob@entry=0x5599792d56f8, parse=parse@entry=0x5599791db0e0, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [13:18:03.944] root = 0x5599792d3458 [13:18:03.944] newWithCheckOptions = [13:18:03.944] newHaving = 0x0 [13:18:03.944] hasOuterJoins = [13:18:03.944] hasResultRTEs = false [13:18:03.944] final_rel = [13:18:03.944] l = 0x0 [13:18:03.944] #11 0x0000559977c146e9 in standard_planner (parse=0x5599791db0e0, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [13:18:03.944] result = [13:18:03.944] glob = 0x5599792d56f8 [13:18:03.944] tuple_fraction = 0 [13:18:03.944] root = [13:18:03.944] final_rel = [13:18:03.944] best_path = [13:18:03.944] top_plan = [13:18:03.944] lp = [13:18:03.944] lr = [13:18:03.944] #12 0x0000559977c15753 in planner (parse=parse@entry=0x5599791db0e0, query_string=query_string@entry=0x5599791d9af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [13:18:03.944] result = [13:18:03.944] #13 0x0000559977e84d7d in pg_plan_query (querytree=querytree@entry=0x5599791db0e0, query_string=query_string@entry=0x5599791d9af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [13:18:03.944] plan = [13:18:03.944] #14 0x00005599779870a2 in standard_ExplainOneQuery (query=0x5599791db0e0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5599792d5458, queryString=0x5599791d9af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [13:18:03.944] plan = [13:18:03.944] planstart = [13:18:03.944] planduration = {ticks = 94117626811382} [13:18:03.944] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94117633078867, shared_blks_dirtied = 1938662062, shared_blks_written = 3, local_blks_hit = 4294967392, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94117650346208, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94117633165661}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94117626808763}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94117650346208}} [13:18:03.944] bufusage = {shared_blks_hit = 0, shared_blks_read = 94117629834788, shared_blks_dirtied = 211819197120512, shared_blks_written = 72057594037927936, local_blks_hit = 140305219225192, local_blks_read = 94117650347600, local_blks_dirtied = 94117650346208, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94117632693279, shared_blk_read_time = {ticks = 140305219225192}, shared_blk_write_time = {ticks = 94117632693298}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94117633074450}, temp_blk_read_time = {ticks = 94117651201136}, temp_blk_write_time = {ticks = 64}} [13:18:03.944] mem_counters = {nblocks = 94117651373176, freechunks = 4294967297, totalspace = 140735132049968, freespace = 10} [13:18:03.944] planner_ctx = 0x0 [13:18:03.944] saved_ctx = 0x0 [13:18:03.944] #15 0x0000559977987388 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5599792d5458, pstate=pstate@entry=0x5599792abf28, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [13:18:03.944] No locals. [13:18:03.944] #16 0x00005599779882df in ExplainQuery (pstate=pstate@entry=0x5599792abf28, stmt=stmt@entry=0x5599791daf20, params=params@entry=0x0, dest=dest@entry=0x5599792abe98) at ../src/backend/commands/explain.c:357 [13:18:03.944] l__state = [13:18:03.944] l = 0x5599792d5ce0 [13:18:03.944] es = 0x5599792d5458 [13:18:03.944] tstate = [13:18:03.944] jstate = [13:18:03.944] query = [13:18:03.944] rewritten = 0x5599792d5cc8 [13:18:03.944] lc = 0x0 [13:18:03.944] timing_set = false [13:18:03.944] buffers_set = false [13:18:03.944] summary_set = false [13:18:03.944] __func__ = "ExplainQuery" [13:18:03.944] #17 0x0000559977e8f79d in standard_ProcessUtility (pstmt=0x5599791dafd0, queryString=0x5599791d9af0 "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=0x5599792abe98, qc=0x7fff738da4b0) at ../src/backend/tcop/utility.c:866 [13:18:03.944] parsetree = 0x5599791daf20 [13:18:03.944] isTopLevel = true [13:18:03.944] isAtomicContext = false [13:18:03.944] pstate = 0x5599792abf28 [13:18:03.944] readonly_flags = [13:18:03.944] __func__ = "standard_ProcessUtility" [13:18:03.944] #18 0x0000559977e8fec6 in ProcessUtility (pstmt=pstmt@entry=0x5599791dafd0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5599792abe98, qc=0x7fff738da4b0) at ../src/backend/tcop/utility.c:523 [13:18:03.944] No locals. [13:18:03.944] #19 0x0000559977e8b884 in PortalRunUtility (portal=portal@entry=0x55997925e100, pstmt=0x5599791dafd0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5599792abe98, qc=qc@entry=0x7fff738da4b0) at ../src/backend/tcop/pquery.c:1152 [13:18:03.944] No locals. [13:18:03.944] #20 0x0000559977e8c0f7 in FillPortalStore (portal=portal@entry=0x55997925e100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [13:18:03.944] treceiver = 0x5599792abe98 [13:18:03.944] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:18:03.944] __func__ = "FillPortalStore" [13:18:03.944] #21 0x0000559977e8c612 in PortalRun (portal=portal@entry=0x55997925e100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5599792bc3e8, altdest=altdest@entry=0x5599792bc3e8, qc=qc@entry=0x7fff738da670) at ../src/backend/tcop/pquery.c:759 [13:18:03.944] _save_exception_stack = 0x7fff738da720 [13:18:03.944] _save_context_stack = 0x0 [13:18:03.944] _local_sigjmp_buf = {{__jmpbuf = {0, 6202506818679497410, 94117650882816, 94117650345880, 94117650345856, 94117650345808, 207075809759093442, 6202484252950815426}, __mask_was_saved = 0, __saved_mask = {__val = {94117633078867, 1938662911, 4, 94117650345808, 112, 153, 94117650882816, 94117650345880, 94117650345856, 94117650345808, 94117633166070, 1, 2, 153, 94117622421919, 0}}}} [13:18:03.944] _do_rethrow = [13:18:03.944] result = [13:18:03.944] nprocessed = [13:18:03.944] saveTopTransactionResourceOwner = 0x55997921b658 [13:18:03.944] saveTopTransactionContext = 0x559979270530 [13:18:03.944] saveActivePortal = 0x0 [13:18:03.944] saveResourceOwner = 0x55997921b658 [13:18:03.944] savePortalContext = 0x0 [13:18:03.944] saveMemoryContext = 0x559979270530 [13:18:03.944] __func__ = "PortalRun" [13:18:03.944] #22 0x0000559977e85849 in exec_simple_query (query_string=query_string@entry=0x5599791d9af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;") at ../src/backend/tcop/postgres.c:1271 [13:18:03.944] cmdtaglen = 7 [13:18:03.944] snapshot_set = [13:18:03.944] per_parsetree_context = 0x0 [13:18:03.944] plantree_list = 0x5599792bc398 [13:18:03.944] parsetree = 0x5599791daf50 [13:18:03.944] commandTag = [13:18:03.944] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:18:03.944] querytree_list = [13:18:03.944] portal = 0x55997925e100 [13:18:03.944] receiver = 0x5599792bc3e8 [13:18:03.944] format = 0 [13:18:03.944] cmdtagname = [13:18:03.944] parsetree_item__state = [13:18:03.944] dest = DestRemote [13:18:03.944] oldcontext = 0x559979270530 [13:18:03.944] parsetree_list = 0x5599791daf80 [13:18:03.944] parsetree_item = 0x5599791daf98 [13:18:03.944] save_log_statement_stats = false [13:18:03.944] was_logged = false [13:18:03.944] use_implicit_block = false [13:18:03.944] msec_str = "\004\000\000\000\000\000\000\000\240P\024x\231U\000\000\000\247\215s\377\177\000\000J\000\000\000\000\000\000" [13:18:03.944] __func__ = "exec_simple_query" [13:18:03.944] #23 0x0000559977e885a2 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [13:18:03.944] query_string = 0x5599791d9af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;" [13:18:03.944] firstchar = [13:18:03.944] input_message = {data = 0x5599791d9af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", len = 74, maxlen = 1024, cursor = 74} [13:18:03.944] local_sigjmp_buf = {{__jmpbuf = {94117645791288, 6202504458036077250, 140735132051580, 4, 7, 140735132051812, 207075809826202306, 6202484256214377154}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94117650071056, 15616, 94117645785344, 94117650603376, 7, 94117633078415, 0, 9, 2, 94117645791296, 94117650071056, 94117645785344, 4, 7, 140735132051812}}}} [13:18:03.944] send_ready_for_query = false [13:18:03.944] idle_in_transaction_timeout_enabled = false [13:18:03.944] idle_session_timeout_enabled = false [13:18:03.944] __func__ = "PostgresMain" [13:18:03.944] #24 0x0000559977e7e60d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:18:03.944] bsdata = [13:18:03.944] #25 0x0000559977d2fd47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=7, startup_data=startup_data@entry=0x7fff738da87c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff738da8d0) at ../src/backend/postmaster/launch_backend.c:274 [13:18:03.944] pid = [13:18:03.944] #26 0x0000559977d34d42 in BackendStartup (client_sock=client_sock@entry=0x7fff738da8d0) at ../src/backend/postmaster/postmaster.c:3386 [13:18:03.944] bn = 0x559979202188 [13:18:03.944] pid = [13:18:03.944] startup_data = {canAcceptConnections = CAC_OK} [13:18:03.944] cac = [13:18:03.944] __func__ = "BackendStartup" [13:18:03.944] #27 0x0000559977d36c1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [13:18:03.944] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "cf\233\177\000\000\240\217Sg\233\177\000\000x\251\215s\377\177\000\000t\251\215s\377\177", '\000' , "\"\206\353v\231U\000\000\300g\347v\231U\000\000@\252\215s\377\177\000\0008\252\215s\377\177\000\000\225[\362\001\000\000\000\000\240D\343f\233\177\000\000+", '\000' , "\231U\000\0000\205\353v\231U\000", __ss_align = 140305440183912}, salen = 2}} [13:18:03.944] i = 0 [13:18:03.944] now = [13:18:03.944] last_lockfile_recheck_time = 1735045975 [13:18:03.944] last_touch_time = 1735045975 [13:18:03.944] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x559976eb8622}, {pos = 1743525480, events = 32667, fd = 1726170672, user_data = 0x7f9b67ec12e0}, {pos = 2090263927, events = 0, fd = 1938664128, user_data = 0x7f9b67e97a48}, {pos = 15, events = 0, fd = 1726170672, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f9b67ec12e0}, {pos = 1938663992, events = 32767, fd = 1938664000, user_data = 0x7f9b67ec1668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 2031990752, events = 21913, fd = 1, user_data = 0x7fff738daf63}, {pos = -1, events = 0, fd = 1717755936, user_data = 0x7f9b67538fa0}, {pos = 2032161176, events = 21913, fd = 2032160888, user_data = 0x559979207461}, {pos = 1743380158, events = 32667, fd = 1, user_data = 0x7f9b67ec12e0}, {pos = 426, events = 0, fd = 2020363600, user_data = 0x0}, {pos = 236, events = 0, fd = 2031983536, user_data = 0x7f9b67e9debe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f9b6662e020}, {pos = 1718562368, events = 32667, fd = 16, user_data = 0x7fff738dae90}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1743389114, events = 32667, fd = 0, user_data = 0x7f9b666aeda4 }, {pos = 0, events = 0, fd = 2027369440, user_data = 0x2}, {pos = 0, events = 0, fd = 2031730352, user_data = 0x559977e1c00f }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 2031983536, user_data = 0x7f9b67e9debe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f9b666364c8}, {pos = 1718316807, events = 32667, fd = 2027425568, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1719606368, events = 32667, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = 0, events = 4294967040, fd = -1, user_data = 0xffffffff00000000}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x332020200a0a386f}, {pos = 822763892, events = 808792887, fd = 926496052, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2032176272, user_data = 0x7f9b666b576b}, {pos = 1719589344, events = 32667, fd = 1718227310, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x3da7a50057a97900}, {pos = 1719592416, events = 32667, fd = -328, user_data = 0x0}, {pos = 2032160568, events = 21913, 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 = 21526, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 2031983536, user_data = 0x7f9b666f3053 }, {pos = 2032160568, events = 21913, fd = 1024, user_data = 0x7fff738daf58}, {pos = 2014800518, events = 21913, fd = 2027433968, user_data = 0x559978165543 }, {pos = 2032160368, events = 21913, fd = 2031983088, user_data = 0x559979204e70}, {pos = 1718310763, events = 32667, fd = 0, user_data = 0x5599781771ad }, {pos = 2032160368, events = 1, fd = 2014802678, user_data = 0x5599791d99f0}, {pos = 1470724352, events = 1034396928, fd = 0, user_data = 0x7f9b666a2ab1}, {pos = 1718228208, events = 32667, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2031730352, user_data = 0x3da7a50057a97900}, {pos = 0, events = 0, fd = 1470724352, user_data = 0xc}, {pos = 1470724352, events = 1034396928, fd = 0, user_data = 0x7f9b6665b239 }, {pos = 237, events = 0, fd = 2010315332, user_data = 0x400000}, {pos = 0, events = 0, fd = 2031730352, user_data = 0x5599781653d7 }, {pos = 2031816992, events = 21913, fd = 2031983088, user_data = 0x5599791b1120}, {pos = 1, events = 0, fd = 0, user_data = 0x559978123b71 }, {pos = 12, events = 0, fd = 2032159944, user_data = 0x559979204ca8}, {pos = 2027370848, events = 21913, fd = 296, user_data = 0x559977d3225e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 2010331803, events = 21913, fd = 2023781936, user_data = 0x5599791da3c8}} [13:18:03.944] nevents = 1 [13:18:03.944] __func__ = "ServerLoop" [13:18:03.944] #28 0x0000559977d3849c in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x559979197d70) at ../src/backend/postmaster/postmaster.c:1371 [13:18:03.944] opt = [13:18:03.944] status = [13:18:03.944] userDoption = [13:18:03.944] listen_addr_saved = false [13:18:03.944] output_config_variable = [13:18:03.944] __func__ = "PostmasterMain" [13:18:03.944] #29 0x0000559977b64b3e in main (argc=8, argv=0x559979197d70) at ../src/backend/main/main.c:230 [13:18:03.944] do_check_root = [13:18:03.944] dispatch_option = [13:18:03.976] -e [13:18:03.976] [13:18:03.976] [13:18:04.035] dumping /tmp/cores/postgres-6-39946.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:18:04.268] [New LWP 39946] [13:18:04.268] [13:18:04.268] This GDB supports auto-downloading debuginfo from the following URLs: [13:18:04.268] [13:18:04.268] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:18:04.268] Debuginfod has been disabled. [13:18:04.268] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:18:04.365] [Thread debugging using libthread_db enabled] [13:18:04.365] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:18:04.365] Core was generated by `postgres: test: postgres db1 [local] SELECT '. [13:18:04.365] Program terminated with signal SIGABRT, Aborted. [13:18:04.365] #0 0x00007f7045ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:04.421] [13:18:04.421] Thread 1 (Thread 0x7f7045bd4f00 (LWP 39946)): [13:18:04.421] #0 0x00007f7045ea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:04.421] No symbol table info available. [13:18:04.421] #1 0x00007f7045e5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:04.421] No symbol table info available. [13:18:04.421] #2 0x00007f7045e45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:04.421] No symbol table info available. [13:18:04.421] #3 0x00007f704601e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [13:18:04.421] No locals. [13:18:04.421] #4 0x00007f704602aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [13:18:04.421] No locals. [13:18:04.421] #5 0x00007f704600dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x559f67764480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [13:18:04.421] bp = 140723352150608 [13:18:04.421] pc = [13:18:04.421] Opts = {FromUnrecoverableHandler = true, pc = 94143110016656, bp = 140119989927080} [13:18:04.421] #6 0x0000559f66a16e90 in examine_self_contradictory_rels (root=root@entry=0x559f685f2328, rel=rel@entry=0x559f685fc018, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [13:18:04.421] lc__state = [13:18:04.421] rlist = [13:18:04.421] i = 7 [13:18:04.421] br = [13:18:04.421] expression = [13:18:04.421] or_rinfo = 0x7f703a39cd38 [13:18:04.421] ccxt = [13:18:04.421] delidx = 0x7f703a39fe91 [13:18:04.421] arglst = [13:18:04.421] lc = [13:18:04.421] arg = [13:18:04.421] n = [13:18:04.421] restrictinfo = [13:18:04.421] ccwapper = {clausecxt = 0x7f703a39db28} [13:18:04.421] sec = {sopcinfo = {n_members = 38, opcies = 0x7f703a39d2c8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7f703a39d6d8, atop_set = 0x7f703a39b398}, ccfree = 0x7f703a39fe60, vifree = 0x7f703a39ed78} [13:18:04.421] __func__ = "examine_self_contradictory_rels" [13:18:04.421] #7 0x0000559f66a1709f in examine_self_contradictory_rels_phase1 (root=root@entry=0x559f685f2328) at ../src/backend/optimizer/plan/contradictory.c:2608 [13:18:04.421] rel = 0x559f685fc018 [13:18:04.421] rti = 1 [13:18:04.421] rinfo = [13:18:04.421] #8 0x0000559f669e2058 in query_planner (root=root@entry=0x559f685f2328, qp_callback=qp_callback@entry=0x559f669e7375 , qp_extra=qp_extra@entry=0x7ffcb56aa450) at ../src/backend/optimizer/plan/planmain.c:193 [13:18:04.421] parse = 0x559f685e8b20 [13:18:04.421] joinlist = 0x7f703a39b528 [13:18:04.421] final_rel = [13:18:04.421] __func__ = "query_planner" [13:18:04.421] #9 0x0000559f669f4ad4 in grouping_planner (root=root@entry=0x559f685f2328, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [13:18:04.421] sort_input_targets = 0x559f685f2328 [13:18:04.421] sort_input_target_parallel_safe = [13:18:04.421] grouping_target = [13:18:04.421] scanjoin_target = [13:18:04.421] activeWindows = 0x0 [13:18:04.421] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [13:18:04.421] sort_input_targets_contain_srfs = 0x559f685efb20 [13:18:04.421] have_grouping = [13:18:04.421] wflists = 0x0 [13:18:04.421] gset_data = 0x0 [13:18:04.421] sort_input_target = [13:18:04.421] grouping_targets = 0x559f685efb68 [13:18:04.421] grouping_target_parallel_safe = [13:18:04.421] scanjoin_targets = 0x559f685efb50 [13:18:04.421] scanjoin_target_parallel_safe = [13:18:04.421] grouping_targets_contain_srfs = 0x559f685f2328 [13:18:04.421] scanjoin_targets_contain_srfs = 0x0 [13:18:04.421] scanjoin_target_same_exprs = [13:18:04.421] parse = 0x559f685e8b20 [13:18:04.421] offset_est = 0 [13:18:04.421] count_est = 0 [13:18:04.421] limit_tuples = -1 [13:18:04.421] have_postponed_srfs = false [13:18:04.421] final_target = [13:18:04.421] final_targets = 0x559f685f2328 [13:18:04.421] final_targets_contain_srfs = 0x7 [13:18:04.421] final_target_parallel_safe = [13:18:04.421] current_rel = [13:18:04.421] final_rel = [13:18:04.421] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94143139187488} [13:18:04.421] lc = [13:18:04.421] __func__ = "grouping_planner" [13:18:04.421] #10 0x0000559f669f7a58 in subquery_planner (glob=, parse=0x559f685e8b20, parent_root=parent_root@entry=0x559f685e5ce0, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [13:18:04.421] root = 0x559f685f2328 [13:18:04.421] newWithCheckOptions = [13:18:04.421] newHaving = 0x0 [13:18:04.421] hasOuterJoins = [13:18:04.421] hasResultRTEs = true [13:18:04.421] final_rel = [13:18:04.421] l = 0x0 [13:18:04.421] #11 0x0000559f66a093f2 in SS_process_ctes (root=root@entry=0x559f685e5ce0) at ../src/backend/optimizer/plan/subselect.c:966 [13:18:04.421] subquery = [13:18:04.421] cte = 0x559f685aa890 [13:18:04.421] cmdType = [13:18:04.421] subroot = [13:18:04.421] final_rel = [13:18:04.421] best_path = [13:18:04.421] plan = [13:18:04.421] splan = [13:18:04.421] paramid = [13:18:04.421] lc__state = [13:18:04.421] lc = [13:18:04.421] __func__ = "SS_process_ctes" [13:18:04.421] #12 0x0000559f669f64fc in subquery_planner (glob=glob@entry=0x559f685bfae8, parse=parse@entry=0x559f685bfbf8, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:704 [13:18:04.421] root = 0x559f685e5ce0 [13:18:04.421] newWithCheckOptions = [13:18:04.421] newHaving = [13:18:04.421] hasOuterJoins = [13:18:04.421] hasResultRTEs = [13:18:04.421] final_rel = [13:18:04.421] l = [13:18:04.421] #13 0x0000559f669f86e9 in standard_planner (parse=0x559f685bfbf8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [13:18:04.421] result = [13:18:04.421] glob = 0x559f685bfae8 [13:18:04.421] tuple_fraction = 0 [13:18:04.421] root = [13:18:04.421] final_rel = [13:18:04.421] best_path = [13:18:04.421] top_plan = [13:18:04.421] lp = [13:18:04.421] lr = [13:18:04.421] #14 0x0000559f669f9753 in planner (parse=parse@entry=0x559f685bfbf8, query_string=query_string@entry=0x559f684cf5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [13:18:04.421] result = [13:18:04.421] #15 0x0000559f66c68d7d in pg_plan_query (querytree=querytree@entry=0x559f685bfbf8, query_string=query_string@entry=0x559f684cf5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [13:18:04.421] plan = [13:18:04.421] #16 0x0000559f66c6915e in pg_plan_queries (querytrees=0x559f685e5c90, query_string=query_string@entry=0x559f684cf5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:993 [13:18:04.421] query = 0x559f685bfbf8 [13:18:04.421] stmt = [13:18:04.421] query_list__state = [13:18:04.421] stmt_list = 0x0 [13:18:04.421] query_list = [13:18:04.421] #17 0x0000559f66c6970b in exec_simple_query (query_string=query_string@entry=0x559f684cf5a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "...) at ../src/backend/tcop/postgres.c:1190 [13:18:04.421] cmdtaglen = 6 [13:18:04.421] snapshot_set = true [13:18:04.421] per_parsetree_context = 0x0 [13:18:04.421] plantree_list = [13:18:04.421] parsetree = 0x559f685bfa68 [13:18:04.421] commandTag = CMDTAG_SELECT [13:18:04.421] qc = {commandTag = 1935, nprocessed = 94143138035104} [13:18:04.421] querytree_list = [13:18:04.421] portal = [13:18:04.421] receiver = [13:18:04.421] format = 0 [13:18:04.421] cmdtagname = [13:18:04.421] parsetree_item__state = [13:18:04.421] dest = DestRemote [13:18:04.421] oldcontext = 0x559f6855ef40 [13:18:04.421] parsetree_list = 0x559f685bfa98 [13:18:04.421] parsetree_item = 0x559f685bfab0 [13:18:04.421] save_log_statement_stats = false [13:18:04.421] was_logged = true [13:18:04.421] use_implicit_block = false [13:18:04.421] msec_str = "\004\000\000\000\000\000\000\000\240\220\362f\237U\000\000 \250j\265\374\177\000\000\217\a\000\000\000\000\000" [13:18:04.421] __func__ = "exec_simple_query" [13:18:04.421] #18 0x0000559f66c6c5a2 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [13:18:04.421] query_string = 0x559f684cf5a0 "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 "... [13:18:04.421] firstchar = [13:18:04.421] input_message = {data = 0x559f684cf5a0 "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} [13:18:04.421] local_sigjmp_buf = {{__jmpbuf = {94143128170552, -5216745284741630852, 140723352152476, 4, 2, 140723352152708, -2063281449216772996, -5216743779530181508}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94143137762768, 14336, 94143128164608, 94143138270288, 2, 94143115457679, 0, 9, 2, 94143128170560, 94143137762768, 94143128164608, 4, 2, 140723352152708}}}} [13:18:04.421] send_ready_for_query = false [13:18:04.421] idle_in_transaction_timeout_enabled = false [13:18:04.421] idle_session_timeout_enabled = false [13:18:04.421] __func__ = "PostgresMain" [13:18:04.421] #19 0x0000559f66c6260d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:18:04.421] bsdata = [13:18:04.421] #20 0x0000559f66b13d47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x7ffcb56aa99c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcb56aa9f0) at ../src/backend/postmaster/launch_backend.c:274 [13:18:04.421] pid = [13:18:04.421] #21 0x0000559f66b18d42 in BackendStartup (client_sock=client_sock@entry=0x7ffcb56aa9f0) at ../src/backend/postmaster/postmaster.c:3386 [13:18:04.421] bn = 0x559f684f65f8 [13:18:04.421] pid = [13:18:04.421] startup_data = {canAcceptConnections = CAC_OK} [13:18:04.421] cac = [13:18:04.421] __func__ = "BackendStartup" [13:18:04.421] #22 0x0000559f66b1ac1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [13:18:04.421] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\"\306\311e\237U\000\000\300\247\305e\237U\000\000@\253j\265\374\177\000\0008\253j\265\374\177\000\000\225[\362\001\000\000\000\000\240t\310Fp\177\000\000+", '\000' , "\374\177\000\000\000\004\000\000\000\000\000\000h\226mGp\177\000\0000v\310Fp\177\000\000\340\222mGp\177\000\000\316)fR\000\000\000", __ss_align = 3043666816}, salen = 2}} [13:18:04.421] i = 0 [13:18:04.421] now = [13:18:04.421] last_lockfile_recheck_time = 1735046051 [13:18:04.421] last_touch_time = 1735046051 [13:18:04.421] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1187542576, events = 32624, fd = 1198363360, user_data = 0x7c96e577}, {pos = -1251300416, events = 32764, fd = 1198193224, user_data = 0xf}, {pos = 1187542576, events = 32624, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1198363360, user_data = 0x7ffcb56aab38}, {pos = -1251300544, events = 32764, fd = 1198364264, user_data = 0x0}, {pos = 1749879328, events = 21919, fd = 1173060234, user_data = 0x559f684d0a20}, {pos = 1, events = 21919, fd = 32768, user_data = 0xffffffff}, {pos = 1172496416, events = 32624, fd = 1194524576, user_data = 0x559f684fa358}, {pos = 1750049336, events = 21919, fd = 1750046721, user_data = 0x7f70476b5ebe}, {pos = 1, events = 0, fd = 1198363360, user_data = 0x1aa}, {pos = 1732939088, events = 21919, fd = 0, user_data = 0xd8}, {pos = 1749879328, events = 21919, fd = 1198218942, user_data = 0x1}, {pos = 0, events = 0, fd = 1172496416, user_data = 0x7f7045ef2e40 }, {pos = 16, events = 0, fd = -1251299408, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f70476b81ba}, {pos = 0, events = 0, fd = 1173024164, user_data = 0x0}, {pos = 1739944928, events = 21919, fd = 2, user_data = 0x0}, {pos = 1749618288, events = 21919, fd = 1723839553, user_data = 0x559f68501b00}, {pos = 1723843542, events = 21919, fd = 1750080347, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = 1172530376, user_data = 0x7f7045e9c880 }, {pos = 1170034104, events = 32624, fd = -1251299216, user_data = 0x100007f00000002}, {pos = 1173057287, events = 32624, fd = 2, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = 1174346848, events = 32624, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 1415727466, events = 1983342968, fd = 168445769, user_data = 0x74616467702f6174}, {pos = 925960801, events = 875574579, fd = 1751342899, user_data = 0x305f742f61746164}, {pos = 1684826485, events = 1769300527, fd = 1949262956, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1750053536, events = 21919, fd = 1173060234, user_data = 0xa}, {pos = 1727292690, events = 21919, fd = 1750061760, user_data = 0x7f7045eb58be}, {pos = 1174329824, events = 32624, fd = 1172967790, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xbc9d1cd4d9d3500}, {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 = 0x559f684fa030}, {pos = 1, events = 0, fd = 1750049016, user_data = 0x3}, {pos = 0, events = 0, fd = 39497, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1749879328, user_data = 0x7f7045ef3053 }, {pos = 1750049016, events = 21919, fd = 1024, user_data = 0x7ffcb56ab078}, {pos = 1727376006, events = 21919, fd = 1740009456, user_data = 0x559f66f49543 }, {pos = 1750048816, events = 21919, fd = 1749871744, user_data = 0x559f684fa030}, {pos = 1173051243, events = 32624, fd = 0, user_data = 0x559f66f5b1ad }, {pos = 1750048816, events = 1, fd = 1727378166, user_data = 0x559f684cec80}, {pos = 1302148352, events = 197775821, fd = 0, user_data = 0x7f7045ea2ab1}, {pos = 1172968688, events = 32624, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1749618288, user_data = 0xbc9d1cd4d9d3500}, {pos = 0, events = 0, fd = 1302148352, user_data = 0xc}, {pos = 1302148352, events = 197775821, fd = 0, user_data = 0x7f7045e5b239 }, {pos = 217, events = 0, fd = 1722890820, user_data = 0x400000}, {pos = 0, events = 0, fd = 1749618288, user_data = 0x559f66f493d7 }, {pos = 1749705648, events = 21919, fd = 1749871744, user_data = 0x559f684a63b0}, {pos = 1, events = 0, fd = 0, user_data = 0x559f66f07b71 }, {pos = 12, events = 0, fd = 1750044264, user_data = 0x559f684f8e48}, {pos = 1739946336, events = 21919, fd = 296, user_data = 0x559f66b1625e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1722907291, events = 21919, fd = 1736357424, user_data = 0x559f684cf638}} [13:18:04.421] nevents = 1 [13:18:04.421] __func__ = "ServerLoop" [13:18:04.421] #23 0x0000559f66b1c49c in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x559f6848cce0) at ../src/backend/postmaster/postmaster.c:1371 [13:18:04.421] opt = [13:18:04.421] status = [13:18:04.421] userDoption = [13:18:04.421] listen_addr_saved = false [13:18:04.421] output_config_variable = [13:18:04.421] __func__ = "PostmasterMain" [13:18:04.421] #24 0x0000559f66948b3e in main (argc=4, argv=0x559f6848cce0) at ../src/backend/main/main.c:230 [13:18:04.421] do_check_root = [13:18:04.421] dispatch_option = [13:18:04.439] -e [13:18:04.439] [13:18:04.439] [13:18:04.501] dumping /tmp/cores/postgres-6-26048.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [13:18:04.736] [New LWP 26048] [13:18:04.736] [13:18:04.736] This GDB supports auto-downloading debuginfo from the following URLs: [13:18:04.736] [13:18:04.736] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:18:04.736] Debuginfod has been disabled. [13:18:04.736] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:18:04.838] [Thread debugging using libthread_db enabled] [13:18:04.838] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:18:04.838] Core was generated by `postgres: postgres regression [local] SELECT '. [13:18:04.838] Program terminated with signal SIGABRT, Aborted. [13:18:04.838] #0 0x00007f9b666a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:05.780] [13:18:05.780] Thread 1 (Thread 0x7f9b663ddf00 (LWP 26048)): [13:18:05.780] #0 0x00007f9b666a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:05.780] No symbol table info available. [13:18:05.780] #1 0x00007f9b6665afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:05.780] No symbol table info available. [13:18:05.780] #2 0x00007f9b66645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:05.780] No symbol table info available. [13:18:05.780] #3 0x00007f9b6681e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [13:18:05.780] No locals. [13:18:05.780] #4 0x00007f9b6682aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [13:18:05.780] No locals. [13:18:05.780] #5 0x00007f9b6680dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x559978980480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [13:18:05.780] bp = 140735132046464 [13:18:05.780] pc = [13:18:05.780] Opts = {FromUnrecoverableHandler = true, pc = 94117627637392, bp = 94117651836760} [13:18:05.780] #6 0x0000559977c32e90 in examine_self_contradictory_rels (root=root@entry=0x559979344df8, rel=rel@entry=0x559979345c68, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [13:18:05.780] lc__state = [13:18:05.780] rlist = [13:18:05.780] i = 3 [13:18:05.780] br = [13:18:05.780] expression = [13:18:05.780] or_rinfo = 0x559979347ce8 [13:18:05.780] ccxt = [13:18:05.780] delidx = 0x559979348469 [13:18:05.780] arglst = [13:18:05.780] lc = [13:18:05.780] arg = [13:18:05.780] n = [13:18:05.780] restrictinfo = [13:18:05.780] ccwapper = {clausecxt = 0x559979347a28} [13:18:05.780] sec = {sopcinfo = {n_members = 38, opcies = 0x559979347118}, attrsdc = {min_attr = -6, max_attr = 7, len_set = 2, atop_array = 0x5599793466f8, atop_set = 0x559979346c88}, ccfree = 0x559979346d88, vifree = 0x559979348058} [13:18:05.780] __func__ = "examine_self_contradictory_rels" [13:18:05.780] #7 0x0000559977c3309f in examine_self_contradictory_rels_phase1 (root=root@entry=0x559979344df8) at ../src/backend/optimizer/plan/contradictory.c:2608 [13:18:05.780] rel = 0x559979345c68 [13:18:05.780] rti = 1 [13:18:05.780] rinfo = [13:18:05.780] #8 0x0000559977bfe058 in query_planner (root=root@entry=0x559979344df8, qp_callback=qp_callback@entry=0x559977c03375 , qp_extra=qp_extra@entry=0x7fff738d9680) at ../src/backend/optimizer/plan/planmain.c:193 [13:18:05.780] parse = 0x5599793305d8 [13:18:05.780] joinlist = 0x559979346cf8 [13:18:05.780] final_rel = [13:18:05.780] __func__ = "query_planner" [13:18:05.780] #9 0x0000559977c10ad4 in grouping_planner (root=root@entry=0x559979344df8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [13:18:05.780] sort_input_targets = 0x559979345b58 [13:18:05.780] sort_input_target_parallel_safe = [13:18:05.780] grouping_target = [13:18:05.780] scanjoin_target = [13:18:05.780] activeWindows = 0x0 [13:18:05.780] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [13:18:05.780] sort_input_targets_contain_srfs = 0x2 [13:18:05.780] have_grouping = [13:18:05.780] wflists = 0x0 [13:18:05.780] gset_data = 0x0 [13:18:05.780] sort_input_target = [13:18:05.780] grouping_targets = 0x0 [13:18:05.780] grouping_target_parallel_safe = [13:18:05.780] scanjoin_targets = 0x559979344df8 [13:18:05.780] scanjoin_target_parallel_safe = [13:18:05.780] grouping_targets_contain_srfs = 0x559979345bf8 [13:18:05.780] scanjoin_targets_contain_srfs = 0x0 [13:18:05.780] scanjoin_target_same_exprs = [13:18:05.780] parse = 0x5599793305d8 [13:18:05.780] offset_est = 0 [13:18:05.780] count_est = 0 [13:18:05.780] limit_tuples = -1 [13:18:05.780] have_postponed_srfs = false [13:18:05.780] final_target = [13:18:05.780] final_targets = 0x559979376a78 [13:18:05.780] final_targets_contain_srfs = 0x559977c51d78 [13:18:05.780] final_target_parallel_safe = [13:18:05.780] current_rel = [13:18:05.780] final_rel = [13:18:05.780] extra = {limit_needed = 40, limit_tuples = 4.6500298435569117e-310, count_est = 94117651831800, offset_est = 94117651828216} [13:18:05.780] lc = [13:18:05.780] __func__ = "grouping_planner" [13:18:05.780] #10 0x0000559977c13a58 in subquery_planner (glob=glob@entry=0x559979377dc0, parse=parse@entry=0x5599793305d8, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [13:18:05.780] root = 0x559979344df8 [13:18:05.780] newWithCheckOptions = [13:18:05.780] newHaving = 0x0 [13:18:05.780] hasOuterJoins = [13:18:05.780] hasResultRTEs = false [13:18:05.780] final_rel = [13:18:05.780] l = 0x0 [13:18:05.780] #11 0x0000559977c146e9 in standard_planner (parse=0x5599793305d8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [13:18:05.780] result = [13:18:05.780] glob = 0x559979377dc0 [13:18:05.780] tuple_fraction = 0 [13:18:05.780] root = [13:18:05.780] final_rel = [13:18:05.780] best_path = [13:18:05.780] top_plan = [13:18:05.780] lp = [13:18:05.780] lr = [13:18:05.780] #12 0x0000559977c15753 in planner (parse=parse@entry=0x5599793305d8, query_string=query_string@entry=0x559979330290 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [13:18:05.780] result = [13:18:05.780] #13 0x0000559977e84d7d in pg_plan_query (querytree=querytree@entry=0x5599793305d8, query_string=query_string@entry=0x559979330290 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [13:18:05.780] plan = [13:18:05.780] #14 0x00005599779870a2 in standard_ExplainOneQuery (query=0x5599793305d8, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x559979377850, queryString=0x559979330290 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [13:18:05.780] plan = [13:18:05.780] planstart = [13:18:05.780] planduration = {ticks = 94117626811382} [13:18:05.780] bufusage_start = {shared_blks_hit = 77530, shared_blks_read = 8, shared_blks_dirtied = 231, shared_blks_written = 230, 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}} [13:18:05.780] bufusage = {shared_blks_hit = 0, shared_blks_read = 94117629834788, shared_blks_dirtied = 154223685681152, shared_blks_written = 72057594037927936, local_blks_hit = 140305218100208, local_blks_read = 94117651744064, local_blks_dirtied = 94117651744216, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94117632693279, shared_blk_read_time = {ticks = 140305218100208}, shared_blk_write_time = {ticks = 94117632693298}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94117633074450}, temp_blk_read_time = {ticks = 94117651743120}, temp_blk_write_time = {ticks = 64}} [13:18:05.780] mem_counters = {nblocks = 94117652036896, freechunks = 4294967297, totalspace = 140735132047600, freespace = 10} [13:18:05.780] planner_ctx = 0x0 [13:18:05.780] saved_ctx = 0x0 [13:18:05.780] #15 0x0000559977987388 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x559979377850, pstate=pstate@entry=0x559979377740, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [13:18:05.780] No locals. [13:18:05.780] #16 0x00005599779882df in ExplainQuery (pstate=pstate@entry=0x559979377740, stmt=stmt@entry=0x559979330480, params=params@entry=0x0, dest=dest@entry=0x5599793776b0) at ../src/backend/commands/explain.c:357 [13:18:05.780] l__state = [13:18:05.780] l = 0x559979377d88 [13:18:05.780] es = 0x559979377850 [13:18:05.780] tstate = [13:18:05.780] jstate = [13:18:05.780] query = [13:18:05.780] rewritten = 0x559979377d70 [13:18:05.780] lc = 0x0 [13:18:05.780] timing_set = false [13:18:05.780] buffers_set = false [13:18:05.780] summary_set = false [13:18:05.780] __func__ = "ExplainQuery" [13:18:05.780] #17 0x0000559977e8f79d in standard_ProcessUtility (pstmt=0x559979330370, queryString=0x559979330290 "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=0x5599793776b0, qc=0x7fff738d9b70) at ../src/backend/tcop/utility.c:866 [13:18:05.780] parsetree = 0x559979330480 [13:18:05.780] isTopLevel = false [13:18:05.780] isAtomicContext = true [13:18:05.780] pstate = 0x559979377740 [13:18:05.780] readonly_flags = [13:18:05.780] __func__ = "standard_ProcessUtility" [13:18:05.780] #18 0x0000559977e8fec6 in ProcessUtility (pstmt=pstmt@entry=0x559979330370, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_QUERY, params=, queryEnv=, dest=0x5599793776b0, qc=0x7fff738d9b70) at ../src/backend/tcop/utility.c:523 [13:18:05.780] No locals. [13:18:05.780] #19 0x0000559977e8b884 in PortalRunUtility (portal=portal@entry=0x55997925e210, pstmt=0x559979330370, isTopLevel=isTopLevel@entry=false, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5599793776b0, qc=qc@entry=0x7fff738d9b70) at ../src/backend/tcop/pquery.c:1152 [13:18:05.780] No locals. [13:18:05.780] #20 0x0000559977e8c0f7 in FillPortalStore (portal=portal@entry=0x55997925e210, isTopLevel=isTopLevel@entry=false) at ../src/backend/tcop/pquery.c:1025 [13:18:05.780] treceiver = 0x5599793776b0 [13:18:05.780] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:18:05.780] __func__ = "FillPortalStore" [13:18:05.780] #21 0x0000559977e8ca2b in PortalRunFetch (portal=portal@entry=0x55997925e210, fdirection=fdirection@entry=FETCH_FORWARD, count=count@entry=10, dest=dest@entry=0x5599786b0500 ) at ../src/backend/tcop/pquery.c:1433 [13:18:05.780] _save_exception_stack = 0x7fff738da120 [13:18:05.780] _save_context_stack = 0x7fff738d9f90 [13:18:05.780] _local_sigjmp_buf = {{__jmpbuf = {94117638636800, 6202506766121722562, 0, 10, 140735132049328, 94117650714808, 207075811277431490, 6202484252646466242}, __mask_was_saved = 0, __saved_mask = {__val = {2008205383, 94117651743376, 94117633084586, 140735132049296, 94117626561158, 144, 140305218866151, 94117651463584, 8192, 94117651529200, 94117651463584, 94117651463584, 94117651463840, 0, 94117633076693, 0}}}} [13:18:05.780] _do_rethrow = [13:18:05.780] result = [13:18:05.780] saveActivePortal = 0x55997925e100 [13:18:05.780] saveResourceOwner = 0x55997921d538 [13:18:05.780] savePortalContext = 0x55997932ed40 [13:18:05.780] oldContext = 0x559979231b70 [13:18:05.780] __func__ = "PortalRunFetch" [13:18:05.780] #22 0x0000559977b2c9c8 in _SPI_cursor_operation (portal=portal@entry=0x55997925e210, direction=direction@entry=FETCH_FORWARD, count=count@entry=10, dest=0x5599786b0500 ) at ../src/backend/executor/spi.c:3027 [13:18:05.780] nfetched = [13:18:05.780] __func__ = "_SPI_cursor_operation" [13:18:05.780] #23 0x0000559977b323f0 in SPI_cursor_fetch (portal=portal@entry=0x55997925e210, forward=forward@entry=true, count=10) at ../src/backend/executor/spi.c:1808 [13:18:05.780] No locals. [13:18:05.780] #24 0x00007f9b5aba0236 in exec_for_query (estate=estate@entry=0x7fff738d9fb0, stmt=stmt@entry=0x5599792350b8, portal=portal@entry=0x55997925e210, prefetch_ok=, prefetch_ok@entry=true) at ../src/pl/plpgsql/src/pl_exec.c:5887 [13:18:05.780] var = 0x559979235108 [13:18:05.780] tuptab = [13:18:05.780] found = false [13:18:05.780] rc = 0 [13:18:05.780] previous_id = 1 [13:18:05.780] tupdescs_match = true [13:18:05.780] n = [13:18:05.780] #25 0x00007f9b5aba0e40 in exec_stmt_dynfors (estate=estate@entry=0x7fff738d9fb0, stmt=stmt@entry=0x5599792350b8) at ../src/pl/plpgsql/src/pl_exec.c:4645 [13:18:05.780] portal = 0x55997925e210 [13:18:05.780] rc = [13:18:05.780] #26 0x00007f9b5ab9c738 in exec_stmts (estate=estate@entry=0x7fff738d9fb0, stmts=0x5599792357b8) at ../src/pl/plpgsql/src/pl_exec.c:2096 [13:18:05.780] stmt = 0x5599792350b8 [13:18:05.780] rc = [13:18:05.780] s__state = [13:18:05.780] save_estmt = 0x559979235808 [13:18:05.780] s = [13:18:05.780] __func__ = "exec_stmts" [13:18:05.780] #27 0x00007f9b5ab9d406 in exec_stmt_block (estate=estate@entry=0x7fff738d9fb0, block=block@entry=0x559979235808) at ../src/pl/plpgsql/src/pl_exec.c:1939 [13:18:05.780] rc = -1 [13:18:05.780] i = 3 [13:18:05.780] __func__ = "exec_stmt_block" [13:18:05.780] #28 0x00007f9b5ab9d54d in exec_toplevel_block (estate=estate@entry=0x7fff738d9fb0, block=0x559979235808) at ../src/pl/plpgsql/src/pl_exec.c:1630 [13:18:05.780] rc = [13:18:05.780] #29 0x00007f9b5ab9dc82 in plpgsql_exec_function (func=func@entry=0x55997921d128, fcinfo=fcinfo@entry=0x5599792fdf00, 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 [13:18:05.780] estate = {func = 0x55997921d128, 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 = 0x559979301e20, tuple_store_owner = 0x55997921d538, rsi = 0x7fff738da260, found_varno = 4, ndatums = 9, datums = 0x559979309f40, datum_context = 0x559979309df0, paramLI = 0x559979309ef0, simple_eval_estate = 0x55997930df10, simple_eval_resowner = 0x55997921b5a8, procedure_resowner = 0x0, cast_hash = 0x55997931bfa0, stmt_mcontext = 0x5599792ebda0, stmt_mcontext_parent = 0x559979309df0, eval_tuptable = 0x0, eval_processed = 0, eval_econtext = 0x55997930e120, err_stmt = 0x5599792350b8, err_var = 0x0, err_text = 0x0, plugin_info = 0x0} [13:18:05.780] plerrcontext = {previous = 0x0, callback = 0x7f9b5ab9a917 , arg = 0x7fff738d9fb0} [13:18:05.780] i = 1 [13:18:05.780] rc = [13:18:05.780] __func__ = "plpgsql_exec_function" [13:18:05.780] #30 0x00007f9b5aba6fe0 in plpgsql_call_handler (fcinfo=0x5599792fdf00) at ../src/pl/plpgsql/src/pl_handler.c:276 [13:18:05.780] _save_exception_stack = 0x7fff738da550 [13:18:05.780] _save_context_stack = 0x0 [13:18:05.780] _local_sigjmp_buf = {{__jmpbuf = {94117650616616, -206803562825096510, 0, 94117651555160, 1, 94117651557616, 207075809891214018, 150866419340305090}, __mask_was_saved = 0, __saved_mask = {__val = {94117651537704, 0, 0, 0, 94117625781966, 94117651537664, 94117651556792, 32, 94117625984588, 94117651557208, 94117651555160, 94117651537408, 94117651537664, 94117651537408, 94117626178155, 94117651537664}}}} [13:18:05.780] _do_rethrow = false [13:18:05.780] nonatomic = false [13:18:05.780] func = 0x55997921d128 [13:18:05.780] save_cur_estate = 0x0 [13:18:05.780] procedure_resowner = 0x0 [13:18:05.780] retval = 0 [13:18:05.780] rc = [13:18:05.780] __func__ = "plpgsql_call_handler" [13:18:05.780] #31 0x0000559977aa0d07 in ExecMakeTableFunctionResult (setexpr=0x559979302488, econtext=0x559979302358, argContext=, expectedDesc=0x559979302cf0, randomAccess=false) at ../src/backend/executor/execSRF.c:234 [13:18:05.780] result = 140305219188296 [13:18:05.780] tupstore = 0x0 [13:18:05.780] tupdesc = 0x0 [13:18:05.780] funcrettype = 2249 [13:18:05.780] returnsTuple = [13:18:05.780] returnsSet = true [13:18:05.780] fcinfo = 0x5599792fdf00 [13:18:05.780] fcusage = {fs = 0x0, save_f_total_time = {ticks = 94117632546680}, save_total = {ticks = 140305219188336}, start = {ticks = 140305219188336}} [13:18:05.780] rsinfo = {type = T_ReturnSetInfo, econtext = 0x559979302358, expectedDesc = 0x559979302cf0, allowedModes = 11, returnMode = SFRM_ValuePerCall, isDone = ExprSingleResult, setResult = 0x0, setDesc = 0x0} [13:18:05.780] tmptup = {t_len = 1522529928, t_self = {ip_blkid = {bi_hi = 32667, bi_lo = 0}, ip_posid = 2}, t_tableOid = 0, t_data = 0x1} [13:18:05.780] callerContext = 0x559979301e20 [13:18:05.780] first_time = true [13:18:05.780] __func__ = "ExecMakeTableFunctionResult" [13:18:05.780] #32 0x0000559977aced94 in FunctionNext (node=0x559979302148) at ../src/backend/executor/nodeFunctionscan.c:94 [13:18:05.780] tstore = 0x0 [13:18:05.780] estate = [13:18:05.780] direction = ForwardScanDirection [13:18:05.780] scanslot = 0x559979302f10 [13:18:05.780] alldone = [13:18:05.780] oldpos = [13:18:05.780] funcno = [13:18:05.780] att = [13:18:05.780] #33 0x0000559977aa2667 in ExecScanFetch (node=node@entry=0x559979302148, accessMtd=accessMtd@entry=0x559977aceb5f , recheckMtd=recheckMtd@entry=0x559977acea6b ) at ../src/backend/executor/execScan.c:131 [13:18:05.780] estate = [13:18:05.780] #34 0x0000559977aa2771 in ExecScan (node=0x559979302148, accessMtd=accessMtd@entry=0x559977aceb5f , recheckMtd=recheckMtd@entry=0x559977acea6b ) at ../src/backend/executor/execScan.c:180 [13:18:05.780] econtext = 0x559979302358 [13:18:05.780] qual = 0x0 [13:18:05.780] projInfo = 0x0 [13:18:05.780] #35 0x0000559977aceae3 in ExecFunctionScan (pstate=) at ../src/backend/executor/nodeFunctionscan.c:269 [13:18:05.780] node = [13:18:05.780] #36 0x0000559977a9b3ee in ExecProcNodeFirst (node=0x559979302148) at ../src/backend/executor/execProcnode.c:469 [13:18:05.780] No locals. [13:18:05.780] #37 0x0000559977a868d0 in ExecProcNode (node=node@entry=0x559979302148) at ../src/include/executor/executor.h:272 [13:18:05.780] No locals. [13:18:05.780] #38 0x0000559977a8778e in ExecutePlan (queryDesc=queryDesc@entry=0x55997932ee40, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x5599792e9b90) at ../src/backend/executor/execMain.c:1655 [13:18:05.780] estate = 0x559979301f20 [13:18:05.780] planstate = 0x559979302148 [13:18:05.780] use_parallel_mode = false [13:18:05.780] slot = [13:18:05.780] current_tuple_count = 0 [13:18:05.780] #39 0x0000559977a8899a in standard_ExecutorRun (queryDesc=0x55997932ee40, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:363 [13:18:05.780] estate = 0x559979301f20 [13:18:05.780] operation = CMD_SELECT [13:18:05.780] dest = 0x5599792e9b90 [13:18:05.780] sendTuples = [13:18:05.780] oldcontext = 0x55997932ed40 [13:18:05.780] #40 0x0000559977a889fa in ExecutorRun (queryDesc=queryDesc@entry=0x55997932ee40, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:300 [13:18:05.780] No locals. [13:18:05.780] #41 0x0000559977e89181 in PortalRunSelect (portal=portal@entry=0x55997925e100, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x5599792e9b90) at ../src/backend/tcop/pquery.c:920 [13:18:05.780] queryDesc = 0x55997932ee40 [13:18:05.780] direction = [13:18:05.780] nprocessed = [13:18:05.780] __func__ = "PortalRunSelect" [13:18:05.780] #42 0x0000559977e8c549 in PortalRun (portal=portal@entry=0x55997925e100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x5599792e9b90, altdest=altdest@entry=0x5599792e9b90, qc=qc@entry=0x7fff738da670) at ../src/backend/tcop/pquery.c:764 [13:18:05.780] _save_exception_stack = 0x7fff738da720 [13:18:05.780] _save_context_stack = 0x0 [13:18:05.780] _local_sigjmp_buf = {{__jmpbuf = {0, 6202506842575495874, 94117650882816, 94117650344760, 94117650344736, 94117650344688, 207075809759093442, 6202484252950815426}, __mask_was_saved = 0, __saved_mask = {__val = {94117633078867, 1938662911, 4, 94117650344688, 112, 179, 94117650882816, 94117650344760, 94117650344736, 94117650344688, 94117633166070, 1, 2, 179, 94117622421919, 0}}}} [13:18:05.780] _do_rethrow = [13:18:05.780] result = [13:18:05.780] nprocessed = [13:18:05.780] saveTopTransactionResourceOwner = 0x55997921adb8 [13:18:05.780] saveTopTransactionContext = 0x559979270530 [13:18:05.780] saveActivePortal = 0x0 [13:18:05.780] saveResourceOwner = 0x55997921adb8 [13:18:05.780] savePortalContext = 0x0 [13:18:05.780] saveMemoryContext = 0x559979270530 [13:18:05.780] __func__ = "PortalRun" [13:18:05.780] #43 0x0000559977e85849 in exec_simple_query (query_string=query_string@entry=0x5599791d9af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');") at ../src/backend/tcop/postgres.c:1271 [13:18:05.780] cmdtaglen = 6 [13:18:05.780] snapshot_set = [13:18:05.780] per_parsetree_context = 0x0 [13:18:05.780] plantree_list = 0x5599792e9b40 [13:18:05.780] parsetree = 0x5599791daaf0 [13:18:05.780] commandTag = [13:18:05.780] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:18:05.780] querytree_list = [13:18:05.780] portal = 0x55997925e100 [13:18:05.780] receiver = 0x5599792e9b90 [13:18:05.780] format = 0 [13:18:05.780] cmdtagname = [13:18:05.780] parsetree_item__state = [13:18:05.780] dest = DestRemote [13:18:05.780] oldcontext = 0x559979270530 [13:18:05.780] parsetree_list = 0x5599791dab20 [13:18:05.780] parsetree_item = 0x5599791dab38 [13:18:05.780] save_log_statement_stats = false [13:18:05.780] was_logged = false [13:18:05.780] use_implicit_block = false [13:18:05.780] msec_str = "\004\000\000\000\000\000\000\000\240P\024x\231U\000\000\000\247\215s\377\177\000\000x\000\000\000\000\000\000" [13:18:05.780] __func__ = "exec_simple_query" [13:18:05.780] #44 0x0000559977e885a2 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [13:18:05.780] query_string = 0x5599791d9af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');" [13:18:05.780] firstchar = [13:18:05.780] input_message = {data = 0x5599791d9af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');", len = 120, maxlen = 1024, cursor = 120} [13:18:05.780] local_sigjmp_buf = {{__jmpbuf = {94117645791288, 6202504458036077250, 140735132051580, 4, 9, 140735132051812, 207075809826202306, 6202484256214377154}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94117650071056, 15616, 94117645785344, 94117650603376, 9, 94117633078415, 0, 9, 2, 94117645791296, 94117650071056, 94117645785344, 4, 9, 140735132051812}}}} [13:18:05.780] send_ready_for_query = false [13:18:05.780] idle_in_transaction_timeout_enabled = false [13:18:05.780] idle_session_timeout_enabled = false [13:18:05.780] __func__ = "PostgresMain" [13:18:05.780] #45 0x0000559977e7e60d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:18:05.780] bsdata = [13:18:05.780] #46 0x0000559977d2fd47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=9, startup_data=startup_data@entry=0x7fff738da87c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff738da8d0) at ../src/backend/postmaster/launch_backend.c:274 [13:18:05.780] pid = [13:18:05.780] #47 0x0000559977d34d42 in BackendStartup (client_sock=client_sock@entry=0x7fff738da8d0) at ../src/backend/postmaster/postmaster.c:3386 [13:18:05.780] bn = 0x5599792021e8 [13:18:05.780] pid = [13:18:05.780] startup_data = {canAcceptConnections = CAC_OK} [13:18:05.780] cac = [13:18:05.780] __func__ = "BackendStartup" [13:18:05.780] #48 0x0000559977d36c1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [13:18:05.780] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "cf\233\177\000\000\240\217Sg\233\177\000\000x\251\215s\377\177\000\000t\251\215s\377\177", '\000' , "\"\206\353v\231U\000\000\300g\347v\231U\000\000@\252\215s\377\177\000\0008\252\215s\377\177\000\000\225[\362\001\000\000\000\000\240D\343f\233\177\000\000+", '\000' , "\231U\000\0000\205\353v\231U\000", __ss_align = 140305440183912}, salen = 2}} [13:18:05.780] i = 0 [13:18:05.780] now = [13:18:05.780] last_lockfile_recheck_time = 1735045975 [13:18:05.780] last_touch_time = 1735045975 [13:18:05.780] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x559976eb8622}, {pos = 1743525480, events = 32667, fd = 1726170672, user_data = 0x7f9b67ec12e0}, {pos = 2090263927, events = 0, fd = 1938664128, user_data = 0x7f9b67e97a48}, {pos = 15, events = 0, fd = 1726170672, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f9b67ec12e0}, {pos = 1938663992, events = 32767, fd = 1938664000, user_data = 0x7f9b67ec1668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 2031990752, events = 21913, fd = 1, user_data = 0x7fff738daf63}, {pos = -1, events = 0, fd = 1717755936, user_data = 0x7f9b67538fa0}, {pos = 2032161176, events = 21913, fd = 2032160888, user_data = 0x559979207461}, {pos = 1743380158, events = 32667, fd = 1, user_data = 0x7f9b67ec12e0}, {pos = 426, events = 0, fd = 2020363600, user_data = 0x0}, {pos = 236, events = 0, fd = 2031983536, user_data = 0x7f9b67e9debe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f9b6662e020}, {pos = 1718562368, events = 32667, fd = 16, user_data = 0x7fff738dae90}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1743389114, events = 32667, fd = 0, user_data = 0x7f9b666aeda4 }, {pos = 0, events = 0, fd = 2027369440, user_data = 0x2}, {pos = 0, events = 0, fd = 2031730352, user_data = 0x559977e1c00f }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 2031983536, user_data = 0x7f9b67e9debe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f9b666364c8}, {pos = 1718316807, events = 32667, fd = 2027425568, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1719606368, events = 32667, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = 0, events = 4294967040, fd = -1, user_data = 0xffffffff00000000}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x332020200a0a386f}, {pos = 822763892, events = 808792887, fd = 926496052, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2032176272, user_data = 0x7f9b666b576b}, {pos = 1719589344, events = 32667, fd = 1718227310, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x3da7a50057a97900}, {pos = 1719592416, events = 32667, fd = -328, user_data = 0x0}, {pos = 2032160568, events = 21913, 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 = 21526, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 2031983536, user_data = 0x7f9b666f3053 }, {pos = 2032160568, events = 21913, fd = 1024, user_data = 0x7fff738daf58}, {pos = 2014800518, events = 21913, fd = 2027433968, user_data = 0x559978165543 }, {pos = 2032160368, events = 21913, fd = 2031983088, user_data = 0x559979204e70}, {pos = 1718310763, events = 32667, fd = 0, user_data = 0x5599781771ad }, {pos = 2032160368, events = 1, fd = 2014802678, user_data = 0x5599791d99f0}, {pos = 1470724352, events = 1034396928, fd = 0, user_data = 0x7f9b666a2ab1}, {pos = 1718228208, events = 32667, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2031730352, user_data = 0x3da7a50057a97900}, {pos = 0, events = 0, fd = 1470724352, user_data = 0xc}, {pos = 1470724352, events = 1034396928, fd = 0, user_data = 0x7f9b6665b239 }, {pos = 237, events = 0, fd = 2010315332, user_data = 0x400000}, {pos = 0, events = 0, fd = 2031730352, user_data = 0x5599781653d7 }, {pos = 2031816992, events = 21913, fd = 2031983088, user_data = 0x5599791b1120}, {pos = 1, events = 0, fd = 0, user_data = 0x559978123b71 }, {pos = 12, events = 0, fd = 2032159944, user_data = 0x559979204ca8}, {pos = 2027370848, events = 21913, fd = 296, user_data = 0x559977d3225e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 2010331803, events = 21913, fd = 2023781936, user_data = 0x5599791da3c8}} [13:18:05.781] nevents = 1 [13:18:05.781] __func__ = "ServerLoop" [13:18:05.781] #49 0x0000559977d3849c in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x559979197d70) at ../src/backend/postmaster/postmaster.c:1371 [13:18:05.781] opt = [13:18:05.781] status = [13:18:05.781] userDoption = [13:18:05.781] listen_addr_saved = false [13:18:05.781] output_config_variable = [13:18:05.781] __func__ = "PostmasterMain" [13:18:05.781] #50 0x0000559977b64b3e in main (argc=8, argv=0x559979197d70) at ../src/backend/main/main.c:230 [13:18:05.781] do_check_root = [13:18:05.781] dispatch_option = [13:18:05.815] -e [13:18:05.815] [13:18:05.815] [13:18:05.878] dumping /tmp/cores/postgres-6-24019.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [13:18:06.120] [New LWP 24019] [13:18:06.120] [13:18:06.120] This GDB supports auto-downloading debuginfo from the following URLs: [13:18:06.120] [13:18:06.120] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:18:06.120] Debuginfod has been disabled. [13:18:06.120] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:18:06.223] [Thread debugging using libthread_db enabled] [13:18:06.223] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:18:06.223] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [13:18:06.223] Program terminated with signal SIGABRT, Aborted. [13:18:06.223] #0 0x00007f9b666a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:07.108] [13:18:07.108] Thread 1 (Thread 0x7f9b663ddf00 (LWP 24019)): [13:18:07.108] #0 0x00007f9b666a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:07.108] No symbol table info available. [13:18:07.108] #1 0x00007f9b6665afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:07.108] No symbol table info available. [13:18:07.108] #2 0x00007f9b66645472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:07.108] No symbol table info available. [13:18:07.108] #3 0x00007f9b6681e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [13:18:07.108] No locals. [13:18:07.108] #4 0x00007f9b6682aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [13:18:07.108] No locals. [13:18:07.108] #5 0x00007f9b6680dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x559978980480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [13:18:07.108] bp = 140735132048832 [13:18:07.108] pc = [13:18:07.108] Opts = {FromUnrecoverableHandler = true, pc = 94117627637392, bp = 94117652783440} [13:18:07.108] #6 0x0000559977c32e90 in examine_self_contradictory_rels (root=root@entry=0x55997942b6c8, rel=rel@entry=0x5599794184e8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [13:18:07.108] lc__state = [13:18:07.108] rlist = [13:18:07.108] i = 2 [13:18:07.108] br = [13:18:07.108] expression = [13:18:07.108] or_rinfo = 0x55997942f060 [13:18:07.108] ccxt = [13:18:07.108] delidx = 0x55997942ed59 [13:18:07.108] arglst = [13:18:07.108] lc = [13:18:07.108] arg = [13:18:07.108] n = [13:18:07.108] restrictinfo = [13:18:07.108] ccwapper = {clausecxt = 0x55997942e6d0} [13:18:07.108] sec = {sopcinfo = {n_members = 38, opcies = 0x55997942e1a0}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x55997942dd40, atop_set = 0x55997942e5b0}, ccfree = 0x55997942ecd8, vifree = 0x55997942e770} [13:18:07.108] __func__ = "examine_self_contradictory_rels" [13:18:07.108] #7 0x0000559977c3309f in examine_self_contradictory_rels_phase1 (root=root@entry=0x55997942b6c8) at ../src/backend/optimizer/plan/contradictory.c:2608 [13:18:07.108] rel = 0x5599794184e8 [13:18:07.108] rti = 1 [13:18:07.108] rinfo = [13:18:07.108] #8 0x0000559977bfe058 in query_planner (root=root@entry=0x55997942b6c8, qp_callback=qp_callback@entry=0x559977c03375 , qp_extra=qp_extra@entry=0x7fff738d9fc0) at ../src/backend/optimizer/plan/planmain.c:193 [13:18:07.108] parse = 0x5599791daf70 [13:18:07.108] joinlist = 0x55997942ddb0 [13:18:07.108] final_rel = [13:18:07.108] __func__ = "query_planner" [13:18:07.108] #9 0x0000559977c10ad4 in grouping_planner (root=root@entry=0x55997942b6c8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [13:18:07.108] sort_input_targets = 0x5 [13:18:07.108] sort_input_target_parallel_safe = [13:18:07.108] grouping_target = [13:18:07.108] scanjoin_target = [13:18:07.108] activeWindows = 0x0 [13:18:07.108] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [13:18:07.108] sort_input_targets_contain_srfs = 0x1 [13:18:07.108] have_grouping = [13:18:07.108] wflists = 0x0 [13:18:07.108] gset_data = 0x0 [13:18:07.108] sort_input_target = [13:18:07.108] grouping_targets = 0x1 [13:18:07.108] grouping_target_parallel_safe = [13:18:07.108] scanjoin_targets = 0x0 [13:18:07.108] scanjoin_target_parallel_safe = [13:18:07.108] grouping_targets_contain_srfs = 0x1 [13:18:07.108] scanjoin_targets_contain_srfs = 0x55997817895d [13:18:07.108] scanjoin_target_same_exprs = [13:18:07.108] parse = 0x5599791daf70 [13:18:07.108] offset_est = 0 [13:18:07.108] count_est = 0 [13:18:07.108] limit_tuples = -1 [13:18:07.108] have_postponed_srfs = false [13:18:07.108] final_target = [13:18:07.108] final_targets = 0x559979416298 [13:18:07.108] final_targets_contain_srfs = 0x559977b6ead2 [13:18:07.108] final_target_parallel_safe = [13:18:07.108] current_rel = [13:18:07.108] final_rel = [13:18:07.108] extra = {limit_needed = false, limit_tuples = 4.6500286074944375e-310, count_est = 94117652775880, offset_est = 94117652775880} [13:18:07.108] lc = [13:18:07.108] __func__ = "grouping_planner" [13:18:07.108] #10 0x0000559977c13a58 in subquery_planner (glob=glob@entry=0x559979416eb8, parse=parse@entry=0x5599791daf70, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [13:18:07.108] root = 0x55997942b6c8 [13:18:07.108] newWithCheckOptions = [13:18:07.108] newHaving = 0x0 [13:18:07.108] hasOuterJoins = [13:18:07.108] hasResultRTEs = false [13:18:07.108] final_rel = [13:18:07.108] l = 0x0 [13:18:07.108] #11 0x0000559977c146e9 in standard_planner (parse=0x5599791daf70, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [13:18:07.108] result = [13:18:07.108] glob = 0x559979416eb8 [13:18:07.108] tuple_fraction = 0 [13:18:07.108] root = [13:18:07.108] final_rel = [13:18:07.108] best_path = [13:18:07.108] top_plan = [13:18:07.108] lp = [13:18:07.108] lr = [13:18:07.108] #12 0x0000559977c15753 in planner (parse=parse@entry=0x5599791daf70, query_string=query_string@entry=0x5599791d9af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [13:18:07.108] result = [13:18:07.108] #13 0x0000559977e84d7d in pg_plan_query (querytree=querytree@entry=0x5599791daf70, query_string=query_string@entry=0x5599791d9af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [13:18:07.108] plan = [13:18:07.108] #14 0x00005599779870a2 in standard_ExplainOneQuery (query=0x5599791daf70, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x559979416c18, queryString=0x5599791d9af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [13:18:07.108] plan = [13:18:07.108] planstart = [13:18:07.108] planduration = {ticks = 94117626811382} [13:18:07.108] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94117633078867, shared_blks_dirtied = 1938662062, shared_blks_written = 3, local_blks_hit = 4294967392, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94117650345840, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94117633165661}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94117626808763}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94117650345840}} [13:18:07.108] bufusage = {shared_blks_hit = 0, shared_blks_read = 94117629834788, shared_blks_dirtied = 132826158612480, shared_blks_written = 72057594037927936, local_blks_hit = 140305216809592, local_blks_read = 94117650347016, local_blks_dirtied = 94117650345840, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94117632693279, shared_blk_read_time = {ticks = 140305216809592}, shared_blk_write_time = {ticks = 94117632693298}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94117633074450}, temp_blk_read_time = {ticks = 94117652411824}, temp_blk_write_time = {ticks = 64}} [13:18:07.108] mem_counters = {nblocks = 94117652694088, freechunks = 4294967297, totalspace = 140735132049968, freespace = 10} [13:18:07.108] planner_ctx = 0x0 [13:18:07.108] saved_ctx = 0x0 [13:18:07.108] #15 0x0000559977987388 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x559979416c18, pstate=pstate@entry=0x5599793d3868, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [13:18:07.108] No locals. [13:18:07.108] #16 0x00005599779882df in ExplainQuery (pstate=pstate@entry=0x5599793d3868, stmt=stmt@entry=0x5599791dadb0, params=params@entry=0x0, dest=dest@entry=0x5599793d37d8) at ../src/backend/commands/explain.c:357 [13:18:07.108] l__state = [13:18:07.108] l = 0x5599794184b0 [13:18:07.108] es = 0x559979416c18 [13:18:07.108] tstate = [13:18:07.108] jstate = [13:18:07.108] query = [13:18:07.108] rewritten = 0x559979418498 [13:18:07.108] lc = 0x0 [13:18:07.108] timing_set = false [13:18:07.108] buffers_set = false [13:18:07.108] summary_set = false [13:18:07.108] __func__ = "ExplainQuery" [13:18:07.108] #17 0x0000559977e8f79d in standard_ProcessUtility (pstmt=0x5599791dae60, queryString=0x5599791d9af0 "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=0x5599793d37d8, qc=0x7fff738da4b0) at ../src/backend/tcop/utility.c:866 [13:18:07.108] parsetree = 0x5599791dadb0 [13:18:07.108] isTopLevel = true [13:18:07.108] isAtomicContext = false [13:18:07.108] pstate = 0x5599793d3868 [13:18:07.108] readonly_flags = [13:18:07.108] __func__ = "standard_ProcessUtility" [13:18:07.108] #18 0x0000559977e8fec6 in ProcessUtility (pstmt=pstmt@entry=0x5599791dae60, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5599793d37d8, qc=0x7fff738da4b0) at ../src/backend/tcop/utility.c:523 [13:18:07.108] No locals. [13:18:07.108] #19 0x0000559977e8b884 in PortalRunUtility (portal=portal@entry=0x55997925e100, pstmt=0x5599791dae60, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5599793d37d8, qc=qc@entry=0x7fff738da4b0) at ../src/backend/tcop/pquery.c:1152 [13:18:07.108] No locals. [13:18:07.108] #20 0x0000559977e8c0f7 in FillPortalStore (portal=portal@entry=0x55997925e100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [13:18:07.108] treceiver = 0x5599793d37d8 [13:18:07.108] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:18:07.108] __func__ = "FillPortalStore" [13:18:07.108] #21 0x0000559977e8c612 in PortalRun (portal=portal@entry=0x55997925e100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x559979416578, altdest=altdest@entry=0x559979416578, qc=qc@entry=0x7fff738da670) at ../src/backend/tcop/pquery.c:759 [13:18:07.108] _save_exception_stack = 0x7fff738da720 [13:18:07.108] _save_context_stack = 0x0 [13:18:07.108] _local_sigjmp_buf = {{__jmpbuf = {0, 6202507560452645570, 94117650882816, 94117650345512, 94117650345488, 94117650345440, 207075809759093442, 6202484252950815426}, __mask_was_saved = 0, __saved_mask = {__val = {94117633078867, 1938662911, 4, 94117650345440, 112, 153, 94117650882816, 94117650345512, 94117650345488, 94117650345440, 94117633166070, 1, 2, 153, 94117622421919, 0}}}} [13:18:07.108] _do_rethrow = [13:18:07.108] result = [13:18:07.108] nprocessed = [13:18:07.108] saveTopTransactionResourceOwner = 0x559979219708 [13:18:07.108] saveTopTransactionContext = 0x559979270530 [13:18:07.108] saveActivePortal = 0x0 [13:18:07.108] saveResourceOwner = 0x559979219708 [13:18:07.108] savePortalContext = 0x0 [13:18:07.108] saveMemoryContext = 0x559979270530 [13:18:07.108] __func__ = "PortalRun" [13:18:07.108] #22 0x0000559977e85849 in exec_simple_query (query_string=query_string@entry=0x5599791d9af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');") at ../src/backend/tcop/postgres.c:1271 [13:18:07.108] cmdtaglen = 7 [13:18:07.108] snapshot_set = [13:18:07.108] per_parsetree_context = 0x0 [13:18:07.108] plantree_list = 0x559979416528 [13:18:07.108] parsetree = 0x5599791dade0 [13:18:07.108] commandTag = [13:18:07.108] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:18:07.108] querytree_list = [13:18:07.108] portal = 0x55997925e100 [13:18:07.108] receiver = 0x559979416578 [13:18:07.108] format = 0 [13:18:07.108] cmdtagname = [13:18:07.108] parsetree_item__state = [13:18:07.108] dest = DestRemote [13:18:07.108] oldcontext = 0x559979270530 [13:18:07.108] parsetree_list = 0x5599791dae10 [13:18:07.108] parsetree_item = 0x5599791dae28 [13:18:07.108] save_log_statement_stats = false [13:18:07.108] was_logged = false [13:18:07.108] use_implicit_block = false [13:18:07.108] msec_str = "\004\000\000\000\000\000\000\000\240P\024x\231U\000\000\000\247\215s\377\177\000\000S\000\000\000\000\000\000" [13:18:07.108] __func__ = "exec_simple_query" [13:18:07.108] #23 0x0000559977e885a2 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [13:18:07.108] query_string = 0x5599791d9af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');" [13:18:07.108] firstchar = [13:18:07.108] input_message = {data = 0x5599791d9af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", len = 83, maxlen = 1024, cursor = 83} [13:18:07.108] local_sigjmp_buf = {{__jmpbuf = {94117645791288, 6202504458036077250, 140735132051580, 4, 14, 140735132051812, 207075809826202306, 6202484256214377154}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94117650071056, 15616, 94117645785344, 94117650603376, 14, 94117633078415, 0, 9, 2, 94117645791296, 94117650071056, 94117645785344, 4, 14, 140735132051812}}}} [13:18:07.108] send_ready_for_query = false [13:18:07.108] idle_in_transaction_timeout_enabled = false [13:18:07.108] idle_session_timeout_enabled = false [13:18:07.108] __func__ = "PostgresMain" [13:18:07.108] #24 0x0000559977e7e60d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:18:07.108] bsdata = [13:18:07.108] #25 0x0000559977d2fd47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=14, startup_data=startup_data@entry=0x7fff738da87c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff738da8d0) at ../src/backend/postmaster/launch_backend.c:274 [13:18:07.108] pid = [13:18:07.108] #26 0x0000559977d34d42 in BackendStartup (client_sock=client_sock@entry=0x7fff738da8d0) at ../src/backend/postmaster/postmaster.c:3386 [13:18:07.108] bn = 0x5599792022d8 [13:18:07.108] pid = [13:18:07.108] startup_data = {canAcceptConnections = CAC_OK} [13:18:07.108] cac = [13:18:07.108] __func__ = "BackendStartup" [13:18:07.108] #27 0x0000559977d36c1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [13:18:07.108] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "cf\233\177\000\000\240\217Sg\233\177\000\000x\251\215s\377\177\000\000t\251\215s\377\177", '\000' , "\"\206\353v\231U\000\000\300g\347v\231U\000\000@\252\215s\377\177\000\0008\252\215s\377\177\000\000\225[\362\001\000\000\000\000\240D\343f\233\177\000\000+", '\000' , "\231U\000\0000\205\353v\231U\000", __ss_align = 140305440183912}, salen = 2}} [13:18:07.108] i = 0 [13:18:07.108] now = [13:18:07.108] last_lockfile_recheck_time = 1735045975 [13:18:07.108] last_touch_time = 1735045975 [13:18:07.108] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x559976eb8622}, {pos = 1743525480, events = 32667, fd = 1726170672, user_data = 0x7f9b67ec12e0}, {pos = 2090263927, events = 0, fd = 1938664128, user_data = 0x7f9b67e97a48}, {pos = 15, events = 0, fd = 1726170672, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f9b67ec12e0}, {pos = 1938663992, events = 32767, fd = 1938664000, user_data = 0x7f9b67ec1668}, {pos = 0, events = 0, fd = 32768, user_data = 0x8}, {pos = 2031990752, events = 21913, fd = 1, user_data = 0x7fff738daf63}, {pos = -1, events = 0, fd = 1717755936, user_data = 0x7f9b67538fa0}, {pos = 2032161176, events = 21913, fd = 2032160888, user_data = 0x559979207461}, {pos = 1743380158, events = 32667, fd = 1, user_data = 0x7f9b67ec12e0}, {pos = 426, events = 0, fd = 2020363600, user_data = 0x0}, {pos = 236, events = 0, fd = 2031983536, user_data = 0x7f9b67e9debe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f9b6662e020}, {pos = 1718562368, events = 32667, fd = 16, user_data = 0x7fff738dae90}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1743389114, events = 32667, fd = 0, user_data = 0x7f9b666aeda4 }, {pos = 0, events = 0, fd = 2027369440, user_data = 0x2}, {pos = 0, events = 0, fd = 2031730352, user_data = 0x559977e1c00f }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x8}, {pos = 8096, events = 196607, fd = 2031983536, user_data = 0x7f9b67e9debe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f9b666364c8}, {pos = 1718316807, events = 32667, fd = 2027425568, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1719606368, events = 32667, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffff000000000000}, {pos = 0, events = 4294967040, fd = -1, user_data = 0xffffffff00000000}, {pos = -1, events = 4294967295, fd = 762540901, user_data = 0x332020200a0a386f}, {pos = 822763892, events = 808792887, fd = 926496052, user_data = 0x726765722f6e7572}, {pos = 796095333, events = 1919378802, fd = 1836330762, user_data = 0x2d69632d73757272}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2032176272, user_data = 0x7f9b666b576b}, {pos = 1719589344, events = 32667, fd = 1718227310, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x3da7a50057a97900}, {pos = 1719592416, events = 32667, fd = -328, user_data = 0x0}, {pos = 2032160568, events = 21913, 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 = 21526, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 2031983536, user_data = 0x7f9b666f3053 }, {pos = 2032160568, events = 21913, fd = 1024, user_data = 0x7fff738daf58}, {pos = 2014800518, events = 21913, fd = 2027433968, user_data = 0x559978165543 }, {pos = 2032160368, events = 21913, fd = 2031983088, user_data = 0x559979204e70}, {pos = 1718310763, events = 32667, fd = 0, user_data = 0x5599781771ad }, {pos = 2032160368, events = 1, fd = 2014802678, user_data = 0x5599791d99f0}, {pos = 1470724352, events = 1034396928, fd = 0, user_data = 0x7f9b666a2ab1}, {pos = 1718228208, events = 32667, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 2031730352, user_data = 0x3da7a50057a97900}, {pos = 0, events = 0, fd = 1470724352, user_data = 0xc}, {pos = 1470724352, events = 1034396928, fd = 0, user_data = 0x7f9b6665b239 }, {pos = 237, events = 0, fd = 2010315332, user_data = 0x400000}, {pos = 0, events = 0, fd = 2031730352, user_data = 0x5599781653d7 }, {pos = 2031816992, events = 21913, fd = 2031983088, user_data = 0x5599791b1120}, {pos = 1, events = 0, fd = 0, user_data = 0x559978123b71 }, {pos = 12, events = 0, fd = 2032159944, user_data = 0x559979204ca8}, {pos = 2027370848, events = 21913, fd = 296, user_data = 0x559977d3225e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 2010331803, events = 21913, fd = 2023781936, user_data = 0x5599791da3c8}} [13:18:07.108] nevents = 1 [13:18:07.108] __func__ = "ServerLoop" [13:18:07.108] #28 0x0000559977d3849c in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x559979197d70) at ../src/backend/postmaster/postmaster.c:1371 [13:18:07.108] opt = [13:18:07.108] status = [13:18:07.108] userDoption = [13:18:07.108] listen_addr_saved = false [13:18:07.108] output_config_variable = [13:18:07.108] __func__ = "PostmasterMain" [13:18:07.108] #29 0x0000559977b64b3e in main (argc=8, argv=0x559979197d70) at ../src/backend/main/main.c:230 [13:18:07.108] do_check_root = [13:18:07.108] dispatch_option = [13:18:07.141] -e [13:18:07.141] [13:18:07.141] [13:18:07.251] dumping /tmp/cores/postgres-6-29705.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [13:18:07.491] [New LWP 29705] [13:18:07.491] [13:18:07.491] This GDB supports auto-downloading debuginfo from the following URLs: [13:18:07.491] [13:18:07.491] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [13:18:07.491] Debuginfod has been disabled. [13:18:07.491] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [13:18:07.724] [Thread debugging using libthread_db enabled] [13:18:07.724] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [13:18:07.724] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN '. [13:18:07.724] Program terminated with signal SIGABRT, Aborted. [13:18:07.724] #0 0x00007f592eaa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:08.617] [13:18:08.617] Thread 1 (Thread 0x7f592c61ef00 (LWP 29705)): [13:18:08.617] #0 0x00007f592eaa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:08.617] No symbol table info available. [13:18:08.617] #1 0x00007f592ea5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:08.617] No symbol table info available. [13:18:08.617] #2 0x00007f592ea45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [13:18:08.617] No symbol table info available. [13:18:08.617] #3 0x00007f592ec1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [13:18:08.617] No locals. [13:18:08.617] #4 0x00007f592ec2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [13:18:08.617] No locals. [13:18:08.617] #5 0x00007f592ec0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55f299455480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [13:18:08.617] bp = 140731177927408 [13:18:08.617] pc = [13:18:08.617] Opts = {FromUnrecoverableHandler = true, pc = 94500427955856, bp = 94500471848296} [13:18:08.617] #6 0x000055f298707e90 in examine_self_contradictory_rels (root=root@entry=0x55f29b0eba38, rel=rel@entry=0x55f29afcd958, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [13:18:08.617] lc__state = [13:18:08.617] rlist = [13:18:08.617] i = 2 [13:18:08.617] br = [13:18:08.617] expression = [13:18:08.617] or_rinfo = 0x55f29b0e4aa0 [13:18:08.617] ccxt = [13:18:08.617] delidx = 0x55f29b0e4939 [13:18:08.617] arglst = [13:18:08.617] lc = [13:18:08.617] arg = [13:18:08.617] n = [13:18:08.617] restrictinfo = [13:18:08.617] ccwapper = {clausecxt = 0x55f29b0e42e8} [13:18:08.617] sec = {sopcinfo = {n_members = 38, opcies = 0x55f29b0e3db8}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x55f29b0e3458, atop_set = 0x55f29b0e41c8}, ccfree = 0x55f29b0e4908, vifree = 0x55f29b0e4458} [13:18:08.617] __func__ = "examine_self_contradictory_rels" [13:18:08.617] #7 0x000055f29870809f in examine_self_contradictory_rels_phase1 (root=root@entry=0x55f29b0eba38) at ../src/backend/optimizer/plan/contradictory.c:2608 [13:18:08.617] rel = 0x55f29afcd958 [13:18:08.617] rti = 1 [13:18:08.617] rinfo = [13:18:08.617] #8 0x000055f2986d3058 in query_planner (root=root@entry=0x55f29b0eba38, qp_callback=qp_callback@entry=0x55f2986d8375 , qp_extra=qp_extra@entry=0x7ffe87de84f0) at ../src/backend/optimizer/plan/planmain.c:193 [13:18:08.617] parse = 0x55f29adbcd38 [13:18:08.617] joinlist = 0x55f29b0e34c8 [13:18:08.617] final_rel = [13:18:08.617] __func__ = "query_planner" [13:18:08.617] #9 0x000055f2986e5ad4 in grouping_planner (root=root@entry=0x55f29b0eba38, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [13:18:08.617] sort_input_targets = 0x5 [13:18:08.617] sort_input_target_parallel_safe = [13:18:08.617] grouping_target = [13:18:08.617] scanjoin_target = [13:18:08.617] activeWindows = 0x0 [13:18:08.617] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [13:18:08.617] sort_input_targets_contain_srfs = 0x1 [13:18:08.617] have_grouping = [13:18:08.617] wflists = 0x0 [13:18:08.617] gset_data = 0x0 [13:18:08.617] sort_input_target = [13:18:08.617] grouping_targets = 0x1 [13:18:08.617] grouping_target_parallel_safe = [13:18:08.617] scanjoin_targets = 0x0 [13:18:08.617] scanjoin_target_parallel_safe = [13:18:08.617] grouping_targets_contain_srfs = 0x1 [13:18:08.617] scanjoin_targets_contain_srfs = 0x55f298c4d95d [13:18:08.617] scanjoin_target_same_exprs = [13:18:08.617] parse = 0x55f29adbcd38 [13:18:08.617] offset_est = 0 [13:18:08.617] count_est = 0 [13:18:08.617] limit_tuples = -1 [13:18:08.617] have_postponed_srfs = false [13:18:08.617] final_target = [13:18:08.617] final_targets = 0x55f29b01d498 [13:18:08.617] final_targets_contain_srfs = 0x55f298643ad2 [13:18:08.617] final_target_parallel_safe = [13:18:08.617] current_rel = [13:18:08.617] final_rel = [13:18:08.617] extra = {limit_needed = false, limit_tuples = 4.6689414561514526e-310, count_est = 94500471844648, offset_est = 94500471844648} [13:18:08.617] lc = [13:18:08.617] __func__ = "grouping_planner" [13:18:08.617] #10 0x000055f2986e8a58 in subquery_planner (glob=glob@entry=0x55f29aeb7818, parse=parse@entry=0x55f29adbcd38, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [13:18:08.617] root = 0x55f29b0eba38 [13:18:08.617] newWithCheckOptions = [13:18:08.617] newHaving = 0x0 [13:18:08.617] hasOuterJoins = [13:18:08.617] hasResultRTEs = false [13:18:08.617] final_rel = [13:18:08.617] l = 0x0 [13:18:08.617] #11 0x000055f2986e96e9 in standard_planner (parse=parse@entry=0x55f29adbcd38, query_string=query_string@entry=0x55f29adbba90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:425 [13:18:08.617] result = [13:18:08.617] glob = 0x55f29aeb7818 [13:18:08.617] tuple_fraction = 0 [13:18:08.617] root = [13:18:08.617] final_rel = [13:18:08.617] best_path = [13:18:08.617] top_plan = [13:18:08.617] lp = [13:18:08.617] lr = [13:18:08.617] #12 0x00007f592c13d5a2 in pgss_planner (parse=0x55f29adbcd38, query_string=0x55f29adbba90 "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 [13:18:08.617] _save_exception_stack = 0x7ffe87de8e70 [13:18:08.617] _save_context_stack = 0x0 [13:18:08.617] _local_sigjmp_buf = {{__jmpbuf = {94500468542776, 2951262335795508376, 0, 2048, 94500468542776, 2048, 9001789104623760536, 9053238993146918040}, __mask_was_saved = 0, __saved_mask = {__val = {94500469037544, 94500469035136, 94500432881523, 94500468541672, 17039, 0, 0, 0, 406006434520, 17039, 0, 140020937911680, 140020937911616, 0, 0, 140021037341100}}}} [13:18:08.617] _do_rethrow = false [13:18:08.617] result = 0x7ffe87de87a8 [13:18:08.617] #13 0x000055f2986ea749 in planner (parse=parse@entry=0x55f29adbcd38, query_string=query_string@entry=0x55f29adbba90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:290 [13:18:08.617] result = [13:18:08.617] #14 0x000055f298959d7d in pg_plan_query (querytree=querytree@entry=0x55f29adbcd38, query_string=query_string@entry=0x55f29adbba90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [13:18:08.617] plan = [13:18:08.617] #15 0x000055f29845c0a2 in standard_ExplainOneQuery (query=0x55f29adbcd38, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55f29aeb7578, queryString=0x55f29adbba90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [13:18:08.617] plan = [13:18:08.617] planstart = [13:18:08.617] planduration = {ticks = 94500427129846} [13:18:08.617] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94500433397331, shared_blks_dirtied = 2279508766, shared_blks_written = 3, local_blks_hit = 6895229192, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94500468542776, shared_blk_read_time = {ticks = -2749134525672754248}, shared_blk_write_time = {ticks = 94500433484125}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94500427127227}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94500468542776}} [13:18:08.617] bufusage = {shared_blks_hit = 0, shared_blks_read = 94500430153252, shared_blks_dirtied = 73181947772928, shared_blks_written = 72057594037927936, local_blks_hit = 140020937901728, local_blks_read = 94500468543952, local_blks_dirtied = 94500468542776, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94500433011743, shared_blk_read_time = {ticks = 140020937901728}, shared_blk_write_time = {ticks = 94500433011762}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94500433392914}, temp_blk_read_time = {ticks = 94500468736880}, temp_blk_write_time = {ticks = 64}} [13:18:08.617] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140731177929376, freespace = 10} [13:18:08.617] planner_ctx = 0x0 [13:18:08.617] saved_ctx = 0x0 [13:18:08.617] #16 0x000055f29845c388 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55f29aeb7578, pstate=pstate@entry=0x55f29adec628, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [13:18:08.617] No locals. [13:18:08.617] #17 0x000055f29845d2df in ExplainQuery (pstate=pstate@entry=0x55f29adec628, stmt=stmt@entry=0x55f29adbcb78, params=params@entry=0x0, dest=dest@entry=0x55f29adec598) at ../src/backend/commands/explain.c:357 [13:18:08.617] l__state = [13:18:08.617] l = 0x55f29b0eba00 [13:18:08.617] es = 0x55f29aeb7578 [13:18:08.617] tstate = [13:18:08.617] jstate = [13:18:08.617] query = [13:18:08.617] rewritten = 0x55f29b0eb9e8 [13:18:08.617] lc = 0x0 [13:18:08.617] timing_set = false [13:18:08.617] buffers_set = false [13:18:08.617] summary_set = false [13:18:08.617] __func__ = "ExplainQuery" [13:18:08.617] #18 0x000055f29896479d in standard_ProcessUtility (pstmt=pstmt@entry=0x55f29adbcc28, queryString=queryString@entry=0x55f29adbba90 "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=0x55f29adec598, qc=0x7ffe87de90b0) at ../src/backend/tcop/utility.c:866 [13:18:08.617] parsetree = 0x55f29adbcb78 [13:18:08.617] isTopLevel = true [13:18:08.617] isAtomicContext = false [13:18:08.617] pstate = 0x55f29adec628 [13:18:08.617] readonly_flags = [13:18:08.617] __func__ = "standard_ProcessUtility" [13:18:08.617] #19 0x00007f592c13cd8f in pgss_ProcessUtility (pstmt=0x55f29adbcc28, queryString=0x55f29adbba90 "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=0x55f29adec598, qc=0x7ffe87de90b0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [13:18:08.617] _save_exception_stack = 0x7ffe87de9150 [13:18:08.617] _save_context_stack = 0x0 [13:18:08.617] _local_sigjmp_buf = {{__jmpbuf = {0, -9002193443359509352, 94500468542504, 94500468737432, 140731177930928, 1, 9001789104835572888, 9053238992669029528}, __mask_was_saved = 0, __saved_mask = {__val = {94500433392914, 94500468537744, 11, 1, 94500433397331, 2600590440, 1, 94500468537744, 10, 94500471037304, 94500471037304, 1, 94500471037304, 94500471037048, 140021011804269, 86}}}} [13:18:08.617] _do_rethrow = false [13:18:08.617] duration = [13:18:08.617] bufusage = {shared_blks_hit = 0, shared_blks_read = 94500433484534, shared_blks_dirtied = 0, shared_blks_written = 94500468544504, local_blks_hit = 94500471035160, local_blks_read = 94500471035160, local_blks_dirtied = 94500471035080, local_blks_written = 140731177930688, temp_blks_read = 140731177930688, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94500428403680}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94500468544648}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94500433392914}} [13:18:08.617] walusage_start = {wal_records = 71, wal_fpi = 1, wal_bytes = 14667} [13:18:08.617] start = [13:18:08.617] rows = [13:18:08.617] bufusage_start = {shared_blks_hit = 1495, shared_blks_read = 329, shared_blks_dirtied = 14, shared_blks_written = 76, 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}} [13:18:08.617] walusage = {wal_records = 140731177930448, wal_fpi = 94500432884955, wal_bytes = 140731177930448} [13:18:08.617] parsetree = [13:18:08.617] saved_queryId = 17056406110364834001 [13:18:08.617] saved_stmt_location = 0 [13:18:08.617] saved_stmt_len = 108 [13:18:08.617] enabled = true [13:18:08.617] #20 0x000055f298964e11 in ProcessUtility (pstmt=pstmt@entry=0x55f29adbcc28, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55f29adec598, qc=0x7ffe87de90b0) at ../src/backend/tcop/utility.c:519 [13:18:08.617] No locals. [13:18:08.617] #21 0x000055f298960884 in PortalRunUtility (portal=portal@entry=0x55f29ae3f000, pstmt=0x55f29adbcc28, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55f29adec598, qc=qc@entry=0x7ffe87de90b0) at ../src/backend/tcop/pquery.c:1152 [13:18:08.617] No locals. [13:18:08.617] #22 0x000055f2989610f7 in FillPortalStore (portal=portal@entry=0x55f29ae3f000, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [13:18:08.617] treceiver = 0x55f29adec598 [13:18:08.617] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:18:08.617] __func__ = "FillPortalStore" [13:18:08.617] #23 0x000055f298961612 in PortalRun (portal=portal@entry=0x55f29ae3f000, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55f29b01e5e8, altdest=altdest@entry=0x55f29b01e5e8, qc=qc@entry=0x7ffe87de9270) at ../src/backend/tcop/pquery.c:759 [13:18:08.617] _save_exception_stack = 0x7ffe87de9320 [13:18:08.617] _save_context_stack = 0x0 [13:18:08.617] _local_sigjmp_buf = {{__jmpbuf = {0, 2951263762912687256, 94500469075968, 94500468542448, 94500468542424, 94500468542376, 9001789105242420376, 2951258458254914712}, __mask_was_saved = 0, __saved_mask = {__val = {94500433397331, 2279510527, 4, 94500468542376, 112, 153, 94500469075968, 94500468542448, 94500468542424, 94500468542376, 94500433484534, 1, 2, 153, 94500422740383, 0}}}} [13:18:08.617] _do_rethrow = [13:18:08.617] result = [13:18:08.617] nprocessed = [13:18:08.617] saveTopTransactionResourceOwner = 0x55f29adfe4d8 [13:18:08.617] saveTopTransactionContext = 0x55f29ae51020 [13:18:08.617] saveActivePortal = 0x0 [13:18:08.617] saveResourceOwner = 0x55f29adfe4d8 [13:18:08.617] savePortalContext = 0x0 [13:18:08.617] saveMemoryContext = 0x55f29ae51020 [13:18:08.617] __func__ = "PortalRun" [13:18:08.617] #24 0x000055f29895a849 in exec_simple_query (query_string=query_string@entry=0x55f29adbba90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1271 [13:18:08.617] cmdtaglen = 7 [13:18:08.617] snapshot_set = [13:18:08.617] per_parsetree_context = 0x0 [13:18:08.617] plantree_list = 0x55f29b01e598 [13:18:08.617] parsetree = 0x55f29adbcba8 [13:18:08.617] commandTag = [13:18:08.617] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [13:18:08.617] querytree_list = [13:18:08.617] portal = 0x55f29ae3f000 [13:18:08.617] receiver = 0x55f29b01e5e8 [13:18:08.617] format = 0 [13:18:08.617] cmdtagname = [13:18:08.617] parsetree_item__state = [13:18:08.617] dest = DestRemote [13:18:08.617] oldcontext = 0x55f29ae51020 [13:18:08.617] parsetree_list = 0x55f29adbcbd8 [13:18:08.617] parsetree_item = 0x55f29adbcbf0 [13:18:08.617] save_log_statement_stats = false [13:18:08.617] was_logged = true [13:18:08.617] use_implicit_block = false [13:18:08.617] msec_str = "\004\000\000\000\000\000\000\000\240\240\301\230\362U\000\000\000\223އ\376\177\000\000n\000\000\000\000\000\000" [13:18:08.617] __func__ = "exec_simple_query" [13:18:08.617] #25 0x000055f29895d5a2 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [13:18:08.617] query_string = 0x55f29adbba90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [13:18:08.617] firstchar = [13:18:08.617] input_message = {data = 0x55f29adbba90 "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} [13:18:08.617] local_sigjmp_buf = {{__jmpbuf = {94500446109752, 2951260497778095256, 140731177931900, 4, 1, 140731177932132, 9001789105309529240, 2951258438483358872}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94500468795824, 0, 168, 94500433397433, 0, 10, 2, 94500446109760, 94500468268592, 94500446103808, 4, 1, 140731177932132}}}} [13:18:08.617] send_ready_for_query = false [13:18:08.617] idle_in_transaction_timeout_enabled = false [13:18:08.617] idle_session_timeout_enabled = false [13:18:08.617] __func__ = "PostgresMain" [13:18:08.617] #26 0x000055f29895360d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [13:18:08.617] bsdata = [13:18:08.617] #27 0x000055f298804d47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=1, startup_data=startup_data@entry=0x7ffe87de947c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffe87de94d0) at ../src/backend/postmaster/launch_backend.c:274 [13:18:08.617] pid = [13:18:08.617] #28 0x000055f298809d42 in BackendStartup (client_sock=client_sock@entry=0x7ffe87de94d0) at ../src/backend/postmaster/postmaster.c:3386 [13:18:08.617] bn = 0x55f29ade80f8 [13:18:08.617] pid = [13:18:08.617] startup_data = {canAcceptConnections = CAC_OK} [13:18:08.617] cac = [13:18:08.617] __func__ = "BackendStartup" [13:18:08.617] #29 0x000055f29880bc1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [13:18:08.617] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\243.Y\177\000\000\240\177\363/Y\177\000\000x\225އ\376\177\000\000t\225އ\376\177", '\000' , "\"֘\227\362U\000\000\300\267\224\227\362U\000\000@\226އ\376\177\000\0008\226އ\376\177\000\000\225[\362\001\000\000\000\000\260Zޚ\362U\000\000,", '\000' , "\362U\000\0000\325\230\227\362U\000", __ss_align = 140021037557352}, salen = 2}} [13:18:08.617] i = 0 [13:18:08.617] now = [13:18:08.617] last_lockfile_recheck_time = 1735046005 [13:18:08.617] last_touch_time = 1735046005 [13:18:08.617] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x55f29798d622}, {pos = 808740456, events = 32601, fd = 790869552, user_data = 0x7f59303462e0}, {pos = 2090263927, events = 0, fd = -2015455552, user_data = 0x7f593031ca48}, {pos = 15, events = 0, fd = 790869552, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f59303462e0}, {pos = -2015455688, events = 32766, fd = -2015455680, user_data = 0x7f5930346668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = -1696873040, events = 22002, fd = 1, user_data = 0x7ffe87de9b63}, {pos = -1, events = 0, fd = 782426144, user_data = 0x7f592ff37fa0}, {pos = -1696676200, events = 22002, fd = -1696676488, user_data = 0x55f29adf2141}, {pos = 808595134, events = 32601, fd = 1, user_data = 0x7f59303462e0}, {pos = 426, events = 0, fd = -1726374576, user_data = 0x0}, {pos = 86, events = 0, fd = -1696685816, user_data = 0x7f5930322ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f592ea2e020}, {pos = 783232576, events = 32601, fd = 16, user_data = 0x7ffe87de9a90}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 808604090, events = 32601, fd = 0, user_data = 0x7f592eaaeda4 }, {pos = 0, events = 0, fd = -1719368736, user_data = 0x2}, {pos = 0, events = 0, fd = -1697128752, user_data = 0x55f2988f100f }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = -1696685816, user_data = 0x7f5930322ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f592ea364c8}, {pos = 782987015, events = 32601, fd = -1719312608, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 784276576, events = 32601, 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 = 797467968, events = 32601, fd = 797469312, 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 = -1696646800, user_data = 0x7f592eab576b}, {pos = 784259552, events = 32601, fd = 782897518, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xb157c8a67fcca00}, {pos = 784262624, events = 32601, fd = -328, user_data = 0x0}, {pos = -1696676808, events = 22002, 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 = 28807, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1696685816, user_data = 0x7f592eaf3053 }, {pos = -1696676808, events = 22002, fd = 1024, user_data = 0x7ffe87de9b58}, {pos = -1731937658, events = 22002, fd = -1719304208, user_data = 0x55f298c3a543 }, {pos = -1696677008, events = 22002, fd = -1696876144, user_data = 0x55f29adec370}, {pos = 782980971, events = 32601, fd = 0, user_data = 0x55f298c4c1ad }, {pos = -1696677008, events = 1, fd = -1731935498, user_data = 0x55f29adbb990}, {pos = 1744620032, events = 185957514, fd = 0, user_data = 0x7f592eaa2ab1}, {pos = 782898416, events = 32601, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1697128752, user_data = 0xb157c8a67fcca00}, {pos = 0, events = 0, fd = 1744620032, user_data = 0xc}, {pos = 1744620032, events = 185957514, fd = 0, user_data = 0x7f592ea5b239 }, {pos = 87, events = 0, fd = -1736422844, user_data = 0x400000}, {pos = 0, events = 0, fd = -1697128752, user_data = 0x55f298c3a3d7 }, {pos = -1697042240, events = 22002, fd = -1696876144, user_data = 0x55f29ad930c0}, {pos = 1, events = 0, fd = 0, user_data = 0x55f298bf8b71 }, {pos = 12, events = 0, fd = -1696689864, user_data = 0x55f29ade9118}, {pos = -1719367328, events = 22002, fd = 296, user_data = 0x55f29880725e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1736406373, events = 22002, fd = -1722956240, user_data = 0x55f29adbc348}} [13:18:08.617] nevents = 1 [13:18:08.617] __func__ = "ServerLoop" [13:18:08.617] #30 0x000055f29880d49c in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55f29ad79d30) at ../src/backend/postmaster/postmaster.c:1371 [13:18:08.617] opt = [13:18:08.617] status = [13:18:08.617] userDoption = [13:18:08.617] listen_addr_saved = false [13:18:08.617] output_config_variable = [13:18:08.617] __func__ = "PostmasterMain" [13:18:08.617] #31 0x000055f298639b3e in main (argc=4, argv=0x55f29ad79d30) at ../src/backend/main/main.c:230 [13:18:08.617] do_check_root = [13:18:08.617] dispatch_option =