[07:15:04.738] src/tools/ci/cores_backtrace.sh linux /tmp/cores [07:15:04.966] dumping /tmp/cores/postgres-6-23604.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [07:15:05.233] [New LWP 23604] [07:15:05.233] [07:15:05.233] This GDB supports auto-downloading debuginfo from the following URLs: [07:15:05.233] [07:15:05.233] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [07:15:05.233] Debuginfod has been disabled. [07:15:05.233] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [07:15:05.361] [Thread debugging using libthread_db enabled] [07:15:05.361] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:15:05.361] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [07:15:05.361] Program terminated with signal SIGABRT, Aborted. [07:15:05.361] #0 0x00007f13c4aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:06.394] [07:15:06.394] Thread 1 (Thread 0x7f13c49d6f00 (LWP 23604)): [07:15:06.394] #0 0x00007f13c4aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:06.394] No symbol table info available. [07:15:06.394] #1 0x00007f13c4a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:06.394] No symbol table info available. [07:15:06.394] #2 0x00007f13c4a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:06.394] No symbol table info available. [07:15:06.394] #3 0x00007f13c4c1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [07:15:06.394] No locals. [07:15:06.394] #4 0x00007f13c4c2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [07:15:06.394] No locals. [07:15:06.394] #5 0x00007f13c4c0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5601208b3100, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [07:15:06.394] bp = 140726177142272 [07:15:06.394] pc = [07:15:06.394] Opts = {FromUnrecoverableHandler = true, pc = 94562827034108, bp = 94562857984272} [07:15:06.394] #6 0x000056011fb6ddfc in examine_self_contradictory_rels (root=root@entry=0x56012190a138, rel=rel@entry=0x5601218ce618, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [07:15:06.394] lc__state = [07:15:06.394] rlist = [07:15:06.394] i = 2 [07:15:06.394] br = [07:15:06.394] expression = [07:15:06.394] or_rinfo = 0x56012190f458 [07:15:06.394] ccxt = [07:15:06.394] delidx = 0x56012190f151 [07:15:06.394] arglst = [07:15:06.394] lc = [07:15:06.394] arg = [07:15:06.394] n = [07:15:06.394] restrictinfo = [07:15:06.394] ccwapper = {clausecxt = 0x56012190eac8} [07:15:06.394] sec = {sopcinfo = {n_members = 38, opcies = 0x56012190e598}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x5601218f1dc0, atop_set = 0x56012190e9a8}, ccfree = 0x56012190f0d0, vifree = 0x56012190eb68} [07:15:06.394] __func__ = "examine_self_contradictory_rels" [07:15:06.394] #7 0x000056011fb6e00b in examine_self_contradictory_rels_phase1 (root=root@entry=0x56012190a138) at ../src/backend/optimizer/plan/contradictory.c:2608 [07:15:06.394] rel = 0x5601218ce618 [07:15:06.394] rti = 1 [07:15:06.394] rinfo = [07:15:06.394] #8 0x000056011fb3864d in query_planner (root=root@entry=0x56012190a138, qp_callback=qp_callback@entry=0x56011fb3d96a , qp_extra=qp_extra@entry=0x7ffd5dcc9800) at ../src/backend/optimizer/plan/planmain.c:190 [07:15:06.394] parse = 0x560121738f70 [07:15:06.394] joinlist = 0x5601218f1e30 [07:15:06.394] final_rel = [07:15:06.394] __func__ = "query_planner" [07:15:06.394] #9 0x000056011fb4ba40 in grouping_planner (root=root@entry=0x56012190a138, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [07:15:06.394] sort_input_targets = 0x5 [07:15:06.394] sort_input_target_parallel_safe = [07:15:06.394] grouping_target = [07:15:06.394] scanjoin_target = [07:15:06.394] activeWindows = 0x0 [07:15:06.394] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [07:15:06.394] sort_input_targets_contain_srfs = 0x1 [07:15:06.394] have_grouping = [07:15:06.394] wflists = 0x0 [07:15:06.394] gset_data = 0x0 [07:15:06.394] sort_input_target = [07:15:06.394] grouping_targets = 0x1 [07:15:06.394] grouping_target_parallel_safe = [07:15:06.394] scanjoin_targets = 0x0 [07:15:06.394] scanjoin_target_parallel_safe = [07:15:06.394] grouping_targets_contain_srfs = 0x1 [07:15:06.394] scanjoin_targets_contain_srfs = 0x5601200b028d [07:15:06.394] scanjoin_target_same_exprs = [07:15:06.394] parse = 0x560121738f70 [07:15:06.394] offset_est = 0 [07:15:06.394] count_est = 0 [07:15:06.394] limit_tuples = -1 [07:15:06.394] have_postponed_srfs = false [07:15:06.394] final_target = [07:15:06.394] final_targets = 0x56012194f568 [07:15:06.394] final_targets_contain_srfs = 0x56011faaa098 [07:15:06.394] final_target_parallel_safe = [07:15:06.394] current_rel = [07:15:06.394] final_rel = [07:15:06.394] extra = {limit_needed = false, limit_tuples = 4.672024380321435e-310, count_est = 94562857981688, offset_est = 94562857981688} [07:15:06.394] lc = [07:15:06.394] __func__ = "grouping_planner" [07:15:06.394] #10 0x000056011fb4e9c4 in subquery_planner (glob=glob@entry=0x5601218ce508, parse=parse@entry=0x560121738f70, 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:1153 [07:15:06.394] root = 0x56012190a138 [07:15:06.394] newWithCheckOptions = [07:15:06.394] newHaving = 0x0 [07:15:06.394] hasOuterJoins = [07:15:06.394] hasResultRTEs = false [07:15:06.394] final_rel = [07:15:06.394] l = 0x0 [07:15:06.394] #11 0x000056011fb4f655 in standard_planner (parse=0x560121738f70, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [07:15:06.394] result = [07:15:06.394] glob = 0x5601218ce508 [07:15:06.394] tuple_fraction = 0 [07:15:06.394] root = [07:15:06.394] final_rel = [07:15:06.394] best_path = [07:15:06.394] top_plan = [07:15:06.394] lp = [07:15:06.394] lr = [07:15:06.394] #12 0x000056011fb506bf in planner (parse=parse@entry=0x560121738f70, query_string=query_string@entry=0x560121737af0 "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:294 [07:15:06.394] result = [07:15:06.394] #13 0x000056011fdbf86c in pg_plan_query (querytree=querytree@entry=0x560121738f70, query_string=query_string@entry=0x560121737af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [07:15:06.394] plan = [07:15:06.394] #14 0x000056011f8c53d0 in standard_ExplainOneQuery (query=0x560121738f70, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5601218fd2e8, queryString=0x560121737af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:496 [07:15:06.394] plan = [07:15:06.394] planstart = [07:15:06.394] planduration = {ticks = 94562826209724} [07:15:06.394] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94562832461699, shared_blks_dirtied = 1573690094, shared_blks_written = 3, local_blks_hit = 4856188512, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94562856177520, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94562832548493}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94562826207105}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94562856177520}} [07:15:06.394] bufusage = {shared_blks_hit = 0, shared_blks_read = 94562829230120, shared_blks_dirtied = 132817568677888, shared_blks_written = 72057594037927936, local_blks_hit = 139722683953272, local_blks_read = 94562856178696, local_blks_dirtied = 94562856177520, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94562832077023, shared_blk_read_time = {ticks = 139722683953272}, shared_blk_write_time = {ticks = 94562832077042}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94562832457282}, temp_blk_read_time = {ticks = 94562858028960}, temp_blk_write_time = {ticks = 64}} [07:15:06.394] mem_counters = {nblocks = 94562857837672, freechunks = 4294967297, totalspace = 140726177143408, freespace = 10} [07:15:06.394] planner_ctx = 0x0 [07:15:06.394] saved_ctx = 0x0 [07:15:06.394] #15 0x000056011f8c56b6 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5601218fd2e8, pstate=pstate@entry=0x5601218fd1d8, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [07:15:06.394] No locals. [07:15:06.394] #16 0x000056011f8c65b6 in ExplainQuery (pstate=pstate@entry=0x5601218fd1d8, stmt=stmt@entry=0x560121738db0, params=params@entry=0x0, dest=dest@entry=0x5601218fd148) at ../src/backend/commands/explain.c:350 [07:15:06.394] l__state = [07:15:06.394] l = 0x5601218ce4d0 [07:15:06.394] es = 0x5601218fd2e8 [07:15:06.394] tstate = [07:15:06.394] jstate = [07:15:06.394] query = [07:15:06.394] rewritten = 0x5601218ce4b8 [07:15:06.394] lc = 0x0 [07:15:06.394] timing_set = false [07:15:06.394] summary_set = false [07:15:06.394] __func__ = "ExplainQuery" [07:15:06.394] #17 0x000056011fdca453 in standard_ProcessUtility (pstmt=0x560121738e60, queryString=0x560121737af0 "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=0x5601218fd148, qc=0x7ffd5dcc9cf0) at ../src/backend/tcop/utility.c:866 [07:15:06.394] parsetree = 0x560121738db0 [07:15:06.394] isTopLevel = true [07:15:06.394] isAtomicContext = false [07:15:06.394] pstate = 0x5601218fd1d8 [07:15:06.394] readonly_flags = [07:15:06.394] __func__ = "standard_ProcessUtility" [07:15:06.394] #18 0x000056011fdcab7c in ProcessUtility (pstmt=pstmt@entry=0x560121738e60, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5601218fd148, qc=0x7ffd5dcc9cf0) at ../src/backend/tcop/utility.c:523 [07:15:06.394] No locals. [07:15:06.394] #19 0x000056011fdc63e8 in PortalRunUtility (portal=portal@entry=0x5601217bc100, pstmt=0x560121738e60, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5601218fd148, qc=qc@entry=0x7ffd5dcc9cf0) at ../src/backend/tcop/pquery.c:1158 [07:15:06.394] No locals. [07:15:06.394] #20 0x000056011fdc6c5b in FillPortalStore (portal=portal@entry=0x5601217bc100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [07:15:06.394] treceiver = 0x5601218fd148 [07:15:06.394] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:15:06.394] __func__ = "FillPortalStore" [07:15:06.394] #21 0x000056011fdc724f in PortalRun (portal=portal@entry=0x5601217bc100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x56012194f848, altdest=altdest@entry=0x56012194f848, qc=0x7ffd5dcc9ed0) at ../src/backend/tcop/pquery.c:763 [07:15:06.394] _save_exception_stack = 0x7ffd5dcc9f80 [07:15:06.394] _save_context_stack = 0x0 [07:15:06.394] _local_sigjmp_buf = {{__jmpbuf = {0, 8896529763442867483, 94562856714496, 94562856177192, 94562856714496, 94562856177120, 2922319524355357979, 8896489696138214683}, __mask_was_saved = 0, __saved_mask = {__val = {94562832457282, 94562856172016, 112, 4, 94562832461699, 1573690975, 4, 94562856177120, 112, 153, 94562856714496, 94562856177192, 94562856177168, 94562856177120, 94562832548902, 1}}}} [07:15:06.394] _do_rethrow = [07:15:06.394] result = [07:15:06.394] nprocessed = [07:15:06.394] saveTopTransactionResourceOwner = 0x560121777708 [07:15:06.394] saveTopTransactionContext = 0x5601217ce530 [07:15:06.394] saveActivePortal = 0x0 [07:15:06.394] saveResourceOwner = 0x560121777708 [07:15:06.394] savePortalContext = 0x0 [07:15:06.394] saveMemoryContext = 0x5601217ce530 [07:15:06.394] __func__ = "PortalRun" [07:15:06.394] #22 0x000056011fdc0342 in exec_simple_query (query_string=query_string@entry=0x560121737af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');") at ../src/backend/tcop/postgres.c:1283 [07:15:06.394] cmdtaglen = 7 [07:15:06.394] snapshot_set = [07:15:06.394] per_parsetree_context = 0x0 [07:15:06.394] plantree_list = 0x56012194f7f8 [07:15:06.394] parsetree = 0x560121738de0 [07:15:06.394] commandTag = [07:15:06.394] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:15:06.394] querytree_list = [07:15:06.394] portal = 0x5601217bc100 [07:15:06.394] receiver = 0x56012194f848 [07:15:06.394] format = 0 [07:15:06.394] cmdtagname = [07:15:06.394] parsetree_item__state = [07:15:06.394] dest = DestRemote [07:15:06.394] oldcontext = 0x5601217ce530 [07:15:06.394] parsetree_list = 0x560121738e10 [07:15:06.394] parsetree_item = 0x560121738e28 [07:15:06.394] save_log_statement_stats = false [07:15:06.394] was_logged = false [07:15:06.394] use_implicit_block = false [07:15:06.394] msec_str = "\004\000\000\000\000\000\000\000\021\314\a \001V\000\000`\237\314]\375\177\000\000S\000\000\000\000\000\000" [07:15:06.394] __func__ = "exec_simple_query" [07:15:06.394] #23 0x000056011fdc30c6 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4822 [07:15:06.394] query_string = 0x560121737af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');" [07:15:06.394] firstchar = [07:15:06.394] input_message = {data = 0x560121737af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", len = 83, maxlen = 1024, cursor = 83} [07:15:06.394] local_sigjmp_buf = {{__jmpbuf = {94562845136184, 8896526884303781147, 140726177145052, 4, 19, 140726177145284, 2922319524426661147, 8896489698353200411}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94562855902736, 15616, 94562845130272, 94562856435056, 19, 94562832461247, 0, 9, 2, 94562845136192, 94562855902736, 94562845130272, 4, 19, 140726177145284}}}} [07:15:06.394] send_ready_for_query = false [07:15:06.394] idle_in_transaction_timeout_enabled = false [07:15:06.394] idle_session_timeout_enabled = false [07:15:06.394] __func__ = "PostgresMain" [07:15:06.394] #24 0x000056011fdb8ebb in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:15:06.394] bsdata = [07:15:06.394] #25 0x000056011fc6a9ef in postmaster_child_launch (child_type=B_BACKEND, child_slot=19, startup_data=startup_data@entry=0x7ffd5dcca0dc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd5dcca130) at ../src/backend/postmaster/launch_backend.c:274 [07:15:06.394] pid = [07:15:06.394] #26 0x000056011fc6f9ea in BackendStartup (client_sock=client_sock@entry=0x7ffd5dcca130) at ../src/backend/postmaster/postmaster.c:3390 [07:15:06.394] bn = 0x5601217603c8 [07:15:06.394] pid = [07:15:06.394] startup_data = {canAcceptConnections = CAC_OK} [07:15:06.394] cac = [07:15:06.394] __func__ = "BackendStartup" [07:15:06.394] #27 0x000056011fc718c3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [07:15:06.394] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\322#\340\036\001V\000\000\200\a\334\036\001V\000\000\200\242\314]\375\177\000\000x\242\314]\375\177\000\000\225[\362\001\000\000\000\000\240\264\362\305\023\177\000\000+", '\000' , "\375\177\000\000\000\004\000\000\000\000\000\000h\246?\306\023\177\000\0000\266\362\305\023\177\000\000\340\242?\306\023\177\000\000\316)fR\000\000\000", __ss_align = 1573692096}, salen = 2}} [07:15:06.394] i = 0 [07:15:06.394] now = [07:15:06.394] last_lockfile_recheck_time = 1733641860 [07:15:06.394] last_touch_time = 1733641860 [07:15:06.394] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -973949392, events = 32531, fd = -968908064, user_data = 0x7c96e577}, {pos = 1573692160, events = 32765, fd = -969078200, user_data = 0xf}, {pos = -973949392, events = 32531, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -968908064, user_data = 0x7ffd5dcca278}, {pos = 1573692032, events = 32765, fd = -968907160, user_data = 0x0}, {pos = 561216432, events = 22017, fd = -995394934, user_data = 0x560121737bb0}, {pos = 1, events = 22017, fd = 32768, user_data = 0xffffffff}, {pos = -995958752, events = 32531, fd = -973828192, user_data = 0x560121763198}, {pos = 561393784, events = 22017, fd = 561402977, user_data = 0x7f13c63d6ebe}, {pos = 1, events = 0, fd = -968908064, user_data = 0x1ab}, {pos = 543145304, events = 22017, fd = 0, user_data = 0xec}, {pos = 561216432, events = 22017, fd = -969052482, user_data = 0x1}, {pos = 0, events = 0, fd = -995958752, user_data = 0x7f13c4af2e40 }, {pos = 16, events = 0, fd = 1573693168, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f13c63d91ba}, {pos = 0, events = 0, fd = -995431004, user_data = 0x0}, {pos = 550115584, events = 22017, fd = 2, user_data = 0x0}, {pos = 560963248, events = 22017, fd = 534060581, user_data = 0x56012176acc0}, {pos = 534064570, events = 22017, fd = 561425691, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -995924792, user_data = 0x7f13c4a9c880 }, {pos = -996315720, events = 32531, fd = 1573693360, user_data = 0x100007f00000002}, {pos = -995397881, events = 32531, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -994108320, events = 32531, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 1631155570, fd = 168447831, user_data = 0x36333337310a6174}, {pos = 909652276, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 22016, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 561396832, events = 22017, fd = -995394934, user_data = 0xa}, {pos = 537501250, events = 22017, fd = 561409168, user_data = 0x7f13c4ab576b}, {pos = -994125344, events = 32531, fd = -995487378, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x1acc6607fde61a00}, {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 = 0x560121762e70}, {pos = 1, events = 0, fd = 561393464, user_data = 0x3}, {pos = 0, events = 0, fd = 21016, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 561216432, user_data = 0x7f13c4af3053 }, {pos = 561393464, events = 22017, fd = 1024, user_data = 0x7ffd5dcca7b8}, {pos = 537584566, events = 22017, fd = 550180080, user_data = 0x56012009ce73 }, {pos = 561393264, events = 22017, fd = 561215984, user_data = 0x560121762e70}, {pos = -995403925, events = 32531, fd = 0, user_data = 0x5601200aeadd }, {pos = 561393264, events = 1, fd = 537586726, user_data = 0x5601217379f0}, {pos = -35251712, events = 449603079, fd = 0, user_data = 0x7f13c4aa2ab1}, {pos = -995486480, events = 32531, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 560963248, user_data = 0x1acc6607fde61a00}, {pos = 0, events = 0, fd = -35251712, user_data = 0xc}, {pos = -35251712, events = 449603079, fd = 0, user_data = 0x7f13c4a5b239 }, {pos = 237, events = 0, fd = 533112556, user_data = 0x400000}, {pos = 0, events = 0, fd = 560963248, user_data = 0x56012009cd07 }, {pos = 561049888, events = 22017, fd = 561215984, user_data = 0x56012170f120}, {pos = 1, events = 0, fd = 0, user_data = 0x56012005b704 }, {pos = 12, events = 0, fd = 561392840, user_data = 0x560121762ca8}, {pos = 550116992, events = 22017, fd = 296, user_data = 0x56011fc6cf06 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 533129027, events = 22017, fd = 546545136, user_data = 0x5601217383c8}} [07:15:06.394] nevents = 1 [07:15:06.394] __func__ = "ServerLoop" [07:15:06.394] #28 0x000056011fc73157 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5601216f5d70) at ../src/backend/postmaster/postmaster.c:1374 [07:15:06.394] opt = [07:15:06.394] status = [07:15:06.394] userDoption = [07:15:06.394] listen_addr_saved = false [07:15:06.394] output_config_variable = [07:15:06.394] __func__ = "PostmasterMain" [07:15:06.394] #29 0x000056011faa0104 in main (argc=8, argv=0x5601216f5d70) at ../src/backend/main/main.c:222 [07:15:06.394] do_check_root = [07:15:06.394] dispatch_option = [07:15:06.434] -e [07:15:06.434] [07:15:06.434] [07:15:06.502] dumping /tmp/cores/postgres-6-39621.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:15:06.752] [New LWP 39621] [07:15:06.752] [07:15:06.752] This GDB supports auto-downloading debuginfo from the following URLs: [07:15:06.752] [07:15:06.752] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [07:15:06.752] Debuginfod has been disabled. [07:15:06.752] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [07:15:06.863] [Thread debugging using libthread_db enabled] [07:15:06.863] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:15:06.863] Core was generated by `postgres: test: postgres db2 [local] SELECT '. [07:15:06.863] Program terminated with signal SIGABRT, Aborted. [07:15:06.863] #0 0x00007f32974a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:06.921] [07:15:06.921] Thread 1 (Thread 0x7f3297c34f00 (LWP 39621)): [07:15:06.921] #0 0x00007f32974a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:06.921] No symbol table info available. [07:15:06.921] #1 0x00007f329745afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:06.921] No symbol table info available. [07:15:06.921] #2 0x00007f3297445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:06.921] No symbol table info available. [07:15:06.921] #3 0x00007f329761e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [07:15:06.921] No locals. [07:15:06.921] #4 0x00007f329762aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [07:15:06.921] No locals. [07:15:06.921] #5 0x00007f329760dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x559fdbd1b100, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [07:15:06.921] bp = 140732095880208 [07:15:06.921] pc = [07:15:06.921] Opts = {FromUnrecoverableHandler = true, pc = 94145062198780, bp = 139855068331176} [07:15:06.921] #6 0x0000559fdafd5dfc in examine_self_contradictory_rels (root=root@entry=0x559fdd0aaf28, rel=rel@entry=0x559fdd0b4c18, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [07:15:06.921] lc__state = [07:15:06.921] rlist = [07:15:06.921] i = 7 [07:15:06.921] br = [07:15:06.921] expression = [07:15:06.921] or_rinfo = 0x7f328bab0d38 [07:15:06.921] ccxt = [07:15:06.921] delidx = 0x7f328bab3e91 [07:15:06.921] arglst = [07:15:06.921] lc = [07:15:06.921] arg = [07:15:06.921] n = [07:15:06.921] restrictinfo = [07:15:06.921] ccwapper = {clausecxt = 0x7f328bab1b28} [07:15:06.921] sec = {sopcinfo = {n_members = 38, opcies = 0x7f328bab12c8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7f328bab16d8, atop_set = 0x7f328baaf398}, ccfree = 0x7f328bab3e60, vifree = 0x7f328bab2d78} [07:15:06.921] __func__ = "examine_self_contradictory_rels" [07:15:06.921] #7 0x0000559fdafd600b in examine_self_contradictory_rels_phase1 (root=root@entry=0x559fdd0aaf28) at ../src/backend/optimizer/plan/contradictory.c:2608 [07:15:06.921] rel = 0x559fdd0b4c18 [07:15:06.921] rti = 1 [07:15:06.921] rinfo = [07:15:06.921] #8 0x0000559fdafa064d in query_planner (root=root@entry=0x559fdd0aaf28, qp_callback=qp_callback@entry=0x559fdafa596a , qp_extra=qp_extra@entry=0x7ffebe955e10) at ../src/backend/optimizer/plan/planmain.c:190 [07:15:06.921] parse = 0x559fdd0a1720 [07:15:06.921] joinlist = 0x7f328baaf528 [07:15:06.921] final_rel = [07:15:06.921] __func__ = "query_planner" [07:15:06.921] #9 0x0000559fdafb3a40 in grouping_planner (root=root@entry=0x559fdd0aaf28, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [07:15:06.921] sort_input_targets = 0x559fdd0aaf28 [07:15:06.921] sort_input_target_parallel_safe = [07:15:06.921] grouping_target = [07:15:06.921] scanjoin_target = [07:15:06.921] activeWindows = 0x0 [07:15:06.921] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [07:15:06.921] sort_input_targets_contain_srfs = 0x559fdd0a8720 [07:15:06.921] have_grouping = [07:15:06.921] wflists = 0x0 [07:15:06.921] gset_data = 0x0 [07:15:06.921] sort_input_target = [07:15:06.921] grouping_targets = 0x559fdd0a8768 [07:15:06.921] grouping_target_parallel_safe = [07:15:06.921] scanjoin_targets = 0x559fdd0a8750 [07:15:06.921] scanjoin_target_parallel_safe = [07:15:06.921] grouping_targets_contain_srfs = 0x559fdd0aaf28 [07:15:06.921] scanjoin_targets_contain_srfs = 0x0 [07:15:06.921] scanjoin_target_same_exprs = [07:15:06.921] parse = 0x559fdd0a1720 [07:15:06.921] offset_est = 0 [07:15:06.921] count_est = 0 [07:15:06.921] limit_tuples = -1 [07:15:06.921] have_postponed_srfs = false [07:15:06.921] final_target = [07:15:06.921] final_targets = 0x559fdd0aaf28 [07:15:06.921] final_targets_contain_srfs = 0x7 [07:15:06.921] final_target_parallel_safe = [07:15:06.921] current_rel = [07:15:06.921] final_rel = [07:15:06.921] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94145096587040} [07:15:06.921] lc = [07:15:06.921] __func__ = "grouping_planner" [07:15:06.921] #10 0x0000559fdafb69c4 in subquery_planner (glob=, parse=0x559fdd0a1720, parent_root=parent_root@entry=0x559fdd09e8e0, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1153 [07:15:06.921] root = 0x559fdd0aaf28 [07:15:06.921] newWithCheckOptions = [07:15:06.921] newHaving = 0x0 [07:15:06.921] hasOuterJoins = [07:15:06.921] hasResultRTEs = true [07:15:06.921] final_rel = [07:15:06.921] l = 0x0 [07:15:06.921] #11 0x0000559fdafc835e in SS_process_ctes (root=root@entry=0x559fdd09e8e0) at ../src/backend/optimizer/plan/subselect.c:966 [07:15:06.921] subquery = [07:15:06.921] cte = 0x559fdd064490 [07:15:06.921] cmdType = [07:15:06.921] subroot = [07:15:06.921] final_rel = [07:15:06.921] best_path = [07:15:06.921] plan = [07:15:06.921] splan = [07:15:06.921] paramid = [07:15:06.921] lc__state = [07:15:06.921] lc = [07:15:06.921] __func__ = "SS_process_ctes" [07:15:06.921] #12 0x0000559fdafb5468 in subquery_planner (glob=glob@entry=0x559fdd0796e8, parse=parse@entry=0x559fdd0797f8, 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:706 [07:15:06.921] root = 0x559fdd09e8e0 [07:15:06.921] newWithCheckOptions = [07:15:06.921] newHaving = [07:15:06.921] hasOuterJoins = [07:15:06.921] hasResultRTEs = [07:15:06.921] final_rel = [07:15:06.921] l = [07:15:06.921] #13 0x0000559fdafb7655 in standard_planner (parse=0x559fdd0797f8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [07:15:06.921] result = [07:15:06.921] glob = 0x559fdd0796e8 [07:15:06.921] tuple_fraction = 0 [07:15:06.921] root = [07:15:06.921] final_rel = [07:15:06.921] best_path = [07:15:06.921] top_plan = [07:15:06.921] lp = [07:15:06.921] lr = [07:15:06.921] #14 0x0000559fdafb86bf in planner (parse=parse@entry=0x559fdd0797f8, query_string=query_string@entry=0x559fdcf895a0 "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:294 [07:15:06.921] result = [07:15:06.921] #15 0x0000559fdb22786c in pg_plan_query (querytree=querytree@entry=0x559fdd0797f8, query_string=query_string@entry=0x559fdcf895a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [07:15:06.921] plan = [07:15:06.921] #16 0x0000559fdb227c4d in pg_plan_queries (querytrees=0x559fdd09e890, query_string=query_string@entry=0x559fdcf895a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:1005 [07:15:06.921] query = 0x559fdd0797f8 [07:15:06.921] stmt = [07:15:06.921] query_list__state = [07:15:06.921] stmt_list = 0x0 [07:15:06.921] query_list = [07:15:06.921] #17 0x0000559fdb2281fa in exec_simple_query (query_string=query_string@entry=0x559fdcf895a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "...) at ../src/backend/tcop/postgres.c:1202 [07:15:06.921] cmdtaglen = 6 [07:15:06.921] snapshot_set = true [07:15:06.921] per_parsetree_context = 0x0 [07:15:06.921] plantree_list = [07:15:06.921] parsetree = 0x559fdd079668 [07:15:06.921] commandTag = CMDTAG_SELECT [07:15:06.921] qc = {commandTag = 1935, nprocessed = 94145095439776} [07:15:06.921] querytree_list = [07:15:06.921] portal = [07:15:06.921] receiver = [07:15:06.921] format = 0 [07:15:06.921] cmdtagname = [07:15:06.921] parsetree_item__state = [07:15:06.921] dest = DestRemote [07:15:06.921] oldcontext = 0x559fdd018f40 [07:15:06.921] parsetree_list = 0x559fdd079698 [07:15:06.921] parsetree_item = 0x559fdd0796b0 [07:15:06.921] save_log_statement_stats = false [07:15:06.921] was_logged = true [07:15:06.921] use_implicit_block = false [07:15:06.921] msec_str = "\004\000\000\000\000\000\000\000\021LN۟U\000\000\340a\225\276\376\177\000\000\217\a\000\000\000\000\000" [07:15:06.921] __func__ = "exec_simple_query" [07:15:06.921] #18 0x0000559fdb22b0c6 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4822 [07:15:06.921] query_string = 0x559fdcf895a0 "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 "... [07:15:06.921] firstchar = [07:15:06.921] input_message = {data = 0x559fdcf895a0 "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} [07:15:06.921] local_sigjmp_buf = {{__jmpbuf = {94145080300856, -5128756067865559339, 140732095882076, 4, 1, 140732095882308, -1436583897520505131, -5128771073044742443}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94145095167440, 14336, 94145080294944, 94145095674960, 1, 94145067625919, 0, 9, 2, 94145080300864, 94145095167440, 94145080294944, 4, 1, 140732095882308}}}} [07:15:06.921] send_ready_for_query = false [07:15:06.921] idle_in_transaction_timeout_enabled = false [07:15:06.921] idle_session_timeout_enabled = false [07:15:06.921] __func__ = "PostgresMain" [07:15:06.921] #19 0x0000559fdb220ebb in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:15:06.921] bsdata = [07:15:06.921] #20 0x0000559fdb0d29ef in postmaster_child_launch (child_type=B_BACKEND, child_slot=1, startup_data=startup_data@entry=0x7ffebe95635c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffebe9563b0) at ../src/backend/postmaster/launch_backend.c:274 [07:15:06.921] pid = [07:15:06.921] #21 0x0000559fdb0d79ea in BackendStartup (client_sock=client_sock@entry=0x7ffebe9563b0) at ../src/backend/postmaster/postmaster.c:3390 [07:15:06.921] bn = 0x559fdcfb05c8 [07:15:06.921] pid = [07:15:06.921] startup_data = {canAcceptConnections = CAC_OK} [07:15:06.921] cac = [07:15:06.921] __func__ = "BackendStartup" [07:15:06.921] #22 0x0000559fdb0d98c3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [07:15:06.921] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "ң&ڟU\000\000\200\207\"ڟU\000\000\000e\225\276\376\177\000\000\370d\225\276\376\177\000\000\225[\362\001\000\000\000\000\2404ė2\177\000\000+", '\000' , "\376\177\000\000\000\004\000\000\000\000\000\000h6ߘ2\177\000\00006ė2\177\000\000\3402ߘ2\177\000\000\316)fR\000\000\000", __ss_align = 3197461824}, salen = 2}} [07:15:06.921] i = 0 [07:15:06.921] now = [07:15:06.921] last_lockfile_recheck_time = 1733641942 [07:15:06.921] last_touch_time = 1733641942 [07:15:06.921] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1748748752, events = 32562, fd = -1730202912, user_data = 0x7c96e577}, {pos = -1097505408, events = 32766, fd = -1730373048, user_data = 0xf}, {pos = -1748748752, events = 32562, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1730202912, user_data = 0x7ffebe9564f8}, {pos = -1097505536, events = 32766, fd = -1730202008, user_data = 0x0}, {pos = -587683296, events = 21919, fd = -1756661110, user_data = 0x559fdcf8aa20}, {pos = 1, events = 21919, fd = 32768, user_data = 0xffffffff}, {pos = -1757224928, events = 32562, fd = -1735123040, user_data = 0x559fdcfb4358}, {pos = -587513288, events = 21919, fd = -587515903, user_data = 0x7f3298dcfebe}, {pos = 1, events = 0, fd = -1730202912, user_data = 0x1ab}, {pos = -609862312, events = 21919, fd = 0, user_data = 0xd8}, {pos = -587683296, events = 21919, fd = -1730347330, user_data = 0x1}, {pos = 0, events = 0, fd = -1757224928, user_data = 0x7f32974f2e40 }, {pos = 16, events = 0, fd = -1097504400, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f3298dd21ba}, {pos = 0, events = 0, fd = -1756697180, user_data = 0x0}, {pos = -602892032, events = 21919, fd = 2, user_data = 0x0}, {pos = -587944336, events = 21919, fd = -618947035, user_data = 0x559fdcfbbb00}, {pos = -618943046, events = 21919, fd = -587482277, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -1757190968, user_data = 0x7f329749c880 }, {pos = -1748808264, events = 32562, fd = -1097504208, user_data = 0x100007f00000002}, {pos = -1756664057, events = 32562, fd = 2, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -1755374496, events = 32562, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 878082156, events = 1802860908, fd = 168441929, user_data = 0x74616467702f6174}, {pos = 925960801, events = 875967283, 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 = -587509088, events = 21919, fd = -1756661110, user_data = 0xa}, {pos = -615506366, events = 21919, fd = -587500864, user_data = 0x7f32974b58be}, {pos = -1755391520, events = 32562, fd = -1756753554, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xc942a6949f3c9800}, {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 = 0x559fdcfb4030}, {pos = 1, events = 0, fd = -587513608, user_data = 0x3}, {pos = 0, events = 0, fd = 39009, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -587683296, user_data = 0x7f32974f3053 }, {pos = -587513608, events = 21919, fd = 1024, user_data = 0x7ffebe956a38}, {pos = -615423050, events = 21919, fd = -602827536, user_data = 0x559fdb504e73 }, {pos = -587513808, events = 21919, fd = -587690880, user_data = 0x559fdcfb4030}, {pos = -1756670101, events = 32562, fd = 0, user_data = 0x559fdb516add }, {pos = -587513808, events = 1, fd = -615420890, user_data = 0x559fdcf88c80}, {pos = -1623418880, events = 3376588436, fd = 0, user_data = 0x7f32974a2ab1}, {pos = -1756752656, events = 32562, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -587944336, user_data = 0xc942a6949f3c9800}, {pos = 0, events = 0, fd = -1623418880, user_data = 0xc}, {pos = -1623418880, events = 3376588436, fd = 0, user_data = 0x7f329745b239 }, {pos = 217, events = 0, fd = -619895060, user_data = 0x400000}, {pos = 0, events = 0, fd = -587944336, user_data = 0x559fdb504d07 }, {pos = -587856976, events = 21919, fd = -587690880, user_data = 0x559fdcf603b0}, {pos = 1, events = 0, fd = 0, user_data = 0x559fdb4c3704 }, {pos = 12, events = 0, fd = -587518360, user_data = 0x559fdcfb2e48}, {pos = -602890624, events = 21919, fd = 296, user_data = 0x559fdb0d4f06 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -619878589, events = 21919, fd = -606462480, user_data = 0x559fdcf89638}} [07:15:06.921] nevents = 1 [07:15:06.921] __func__ = "ServerLoop" [07:15:06.921] #23 0x0000559fdb0db157 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x559fdcf46ce0) at ../src/backend/postmaster/postmaster.c:1374 [07:15:06.921] opt = [07:15:06.921] status = [07:15:06.921] userDoption = [07:15:06.921] listen_addr_saved = false [07:15:06.921] output_config_variable = [07:15:06.921] __func__ = "PostmasterMain" [07:15:06.921] #24 0x0000559fdaf08104 in main (argc=4, argv=0x559fdcf46ce0) at ../src/backend/main/main.c:222 [07:15:06.921] do_check_root = [07:15:06.921] dispatch_option = [07:15:06.941] -e [07:15:06.941] [07:15:06.941] [07:15:07.027] dumping /tmp/cores/postgres-6-29205.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:15:07.280] [New LWP 29205] [07:15:07.280] [07:15:07.280] This GDB supports auto-downloading debuginfo from the following URLs: [07:15:07.280] [07:15:07.280] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [07:15:07.280] Debuginfod has been disabled. [07:15:07.280] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [07:15:07.540] [Thread debugging using libthread_db enabled] [07:15:07.540] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:15:07.540] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN '. [07:15:07.540] Program terminated with signal SIGABRT, Aborted. [07:15:07.540] #0 0x00007fe70bca9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:08.547] [07:15:08.547] Thread 1 (Thread 0x7fe70c432f00 (LWP 29205)): [07:15:08.547] #0 0x00007fe70bca9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:08.547] No symbol table info available. [07:15:08.547] #1 0x00007fe70bc5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:08.547] No symbol table info available. [07:15:08.547] #2 0x00007fe70bc45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:08.547] No symbol table info available. [07:15:08.547] #3 0x00007fe70be1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [07:15:08.547] No locals. [07:15:08.547] #4 0x00007fe70be2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [07:15:08.547] No locals. [07:15:08.547] #5 0x00007fe70be0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x559687f94100, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [07:15:08.547] bp = 140731942544224 [07:15:08.547] pc = [07:15:08.547] Opts = {FromUnrecoverableHandler = true, pc = 94105000799740, bp = 94105045544760} [07:15:08.547] #6 0x000055968724edfc in examine_self_contradictory_rels (root=root@entry=0x559689c73c98, rel=rel@entry=0x559689cafe28, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [07:15:08.547] lc__state = [07:15:08.547] rlist = [07:15:08.547] i = 2 [07:15:08.547] br = [07:15:08.547] expression = [07:15:08.547] or_rinfo = 0x559689cfbc88 [07:15:08.547] ccxt = [07:15:08.547] delidx = 0x559689cfbb21 [07:15:08.547] arglst = [07:15:08.547] lc = [07:15:08.547] arg = [07:15:08.547] n = [07:15:08.547] restrictinfo = [07:15:08.547] ccwapper = {clausecxt = 0x559689cfb4b8} [07:15:08.547] sec = {sopcinfo = {n_members = 38, opcies = 0x559689cfaf88}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x559689cfa628, atop_set = 0x559689cfb398}, ccfree = 0x559689cfbaf0, vifree = 0x559689cfb628} [07:15:08.547] __func__ = "examine_self_contradictory_rels" [07:15:08.547] #7 0x000055968724f00b in examine_self_contradictory_rels_phase1 (root=root@entry=0x559689c73c98) at ../src/backend/optimizer/plan/contradictory.c:2608 [07:15:08.547] rel = 0x559689cafe28 [07:15:08.547] rti = 1 [07:15:08.547] rinfo = [07:15:08.547] #8 0x000055968721964d in query_planner (root=root@entry=0x559689c73c98, qp_callback=qp_callback@entry=0x55968721e96a , qp_extra=qp_extra@entry=0x7ffeb571a560) at ../src/backend/optimizer/plan/planmain.c:190 [07:15:08.547] parse = 0x5596899d7d38 [07:15:08.547] joinlist = 0x559689cfa698 [07:15:08.547] final_rel = [07:15:08.547] __func__ = "query_planner" [07:15:08.547] #9 0x000055968722ca40 in grouping_planner (root=root@entry=0x559689c73c98, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [07:15:08.547] sort_input_targets = 0x5 [07:15:08.547] sort_input_target_parallel_safe = [07:15:08.547] grouping_target = [07:15:08.547] scanjoin_target = [07:15:08.547] activeWindows = 0x0 [07:15:08.547] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [07:15:08.547] sort_input_targets_contain_srfs = 0x1 [07:15:08.547] have_grouping = [07:15:08.547] wflists = 0x0 [07:15:08.547] gset_data = 0x0 [07:15:08.547] sort_input_target = [07:15:08.547] grouping_targets = 0x1 [07:15:08.547] grouping_target_parallel_safe = [07:15:08.547] scanjoin_targets = 0x0 [07:15:08.547] scanjoin_target_parallel_safe = [07:15:08.547] grouping_targets_contain_srfs = 0x1 [07:15:08.547] scanjoin_targets_contain_srfs = 0x55968779128d [07:15:08.547] scanjoin_target_same_exprs = [07:15:08.547] parse = 0x5596899d7d38 [07:15:08.547] offset_est = 0 [07:15:08.547] count_est = 0 [07:15:08.547] limit_tuples = -1 [07:15:08.547] have_postponed_srfs = false [07:15:08.547] final_target = [07:15:08.547] final_targets = 0x559689c85258 [07:15:08.547] final_targets_contain_srfs = 0x55968718b098 [07:15:08.547] final_target_parallel_safe = [07:15:08.547] current_rel = [07:15:08.547] final_rel = [07:15:08.547] extra = {limit_needed = false, limit_tuples = 4.6494047589048258e-310, count_est = 94105044994824, offset_est = 94105044994824} [07:15:08.547] lc = [07:15:08.547] __func__ = "grouping_planner" [07:15:08.547] #10 0x000055968722f9c4 in subquery_planner (glob=glob@entry=0x559689cafd18, parse=parse@entry=0x5596899d7d38, 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:1153 [07:15:08.547] root = 0x559689c73c98 [07:15:08.547] newWithCheckOptions = [07:15:08.547] newHaving = 0x0 [07:15:08.547] hasOuterJoins = [07:15:08.547] hasResultRTEs = false [07:15:08.547] final_rel = [07:15:08.547] l = 0x0 [07:15:08.547] #11 0x0000559687230655 in standard_planner (parse=parse@entry=0x5596899d7d38, query_string=query_string@entry=0x5596899d6a90 "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:427 [07:15:08.547] result = [07:15:08.547] glob = 0x559689cafd18 [07:15:08.547] tuple_fraction = 0 [07:15:08.547] root = [07:15:08.547] final_rel = [07:15:08.547] best_path = [07:15:08.547] top_plan = [07:15:08.547] lp = [07:15:08.547] lr = [07:15:08.547] #12 0x00007fe7093655b0 in pgss_planner (parse=0x5596899d7d38, query_string=0x5596899d6a90 "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 [07:15:08.547] _save_exception_stack = 0x7ffeb571aee0 [07:15:08.547] _save_context_stack = 0x0 [07:15:08.547] _local_sigjmp_buf = {{__jmpbuf = {94105042255160, -3323159827384440657, 0, 2048, 94105042255160, 2048, -8849086837104908113, -8862306814522103633}, __mask_was_saved = 0, __saved_mask = {__val = {94105042749000, 94105042747520, 94105005712442, 0, 17016, 0, 0, 0, 157662948168, 17016, 0, 140630238320752, 140630238320688, 0, 0, 140731942803884}}}} [07:15:08.547] _do_rethrow = false [07:15:08.547] result = 0x559689c85e90 [07:15:08.547] #13 0x00005596872316b5 in planner (parse=parse@entry=0x5596899d7d38, query_string=query_string@entry=0x5596899d6a90 "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 [07:15:08.547] result = [07:15:08.547] #14 0x00005596874a086c in pg_plan_query (querytree=querytree@entry=0x5596899d7d38, query_string=query_string@entry=0x5596899d6a90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [07:15:08.547] plan = [07:15:08.547] #15 0x0000559686fa63d0 in standard_ExplainOneQuery (query=0x5596899d7d38, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x559689a076b8, queryString=0x5596899d6a90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:496 [07:15:08.547] plan = [07:15:08.547] planstart = [07:15:08.547] planduration = {ticks = 94104999975356} [07:15:08.547] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94105006227331, shared_blks_dirtied = 3044125582, shared_blks_written = 3, local_blks_hit = 6606270440, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94105042255160, shared_blk_read_time = {ticks = 8090544494394250696}, shared_blk_write_time = {ticks = 94105006314125}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94104999972737}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94105042255160}} [07:15:08.547] bufusage = {shared_blks_hit = 0, shared_blks_read = 94105002995752, shared_blks_dirtied = 73083163525120, shared_blks_written = 72057594037927936, local_blks_hit = 140630238310928, local_blks_read = 94105042256336, local_blks_dirtied = 94105042255160, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94105005842655, shared_blk_read_time = {ticks = 140630238310928}, shared_blk_write_time = {ticks = 94105005842674}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94105006222914}, temp_blk_read_time = {ticks = 94105042449264}, temp_blk_write_time = {ticks = 64}} [07:15:08.547] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140731942546192, freespace = 10} [07:15:08.547] planner_ctx = 0x0 [07:15:08.547] saved_ctx = 0x0 [07:15:08.547] #16 0x0000559686fa66b6 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x559689a076b8, pstate=pstate@entry=0x559689a075a8, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [07:15:08.547] No locals. [07:15:08.547] #17 0x0000559686fa75b6 in ExplainQuery (pstate=pstate@entry=0x559689a075a8, stmt=stmt@entry=0x5596899d7b78, params=params@entry=0x0, dest=dest@entry=0x559689a07518) at ../src/backend/commands/explain.c:350 [07:15:08.547] l__state = [07:15:08.547] l = 0x559689cafce0 [07:15:08.547] es = 0x559689a076b8 [07:15:08.547] tstate = [07:15:08.547] jstate = [07:15:08.547] query = [07:15:08.547] rewritten = 0x559689cafcc8 [07:15:08.547] lc = 0x0 [07:15:08.547] timing_set = false [07:15:08.547] summary_set = false [07:15:08.547] __func__ = "ExplainQuery" [07:15:08.547] #18 0x00005596874ab453 in standard_ProcessUtility (pstmt=pstmt@entry=0x5596899d7c28, queryString=queryString@entry=0x5596899d6a90 "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=0x559689a07518, qc=0x7ffeb571b120) at ../src/backend/tcop/utility.c:866 [07:15:08.547] parsetree = 0x5596899d7b78 [07:15:08.547] isTopLevel = true [07:15:08.547] isAtomicContext = false [07:15:08.547] pstate = 0x559689a075a8 [07:15:08.547] readonly_flags = [07:15:08.547] __func__ = "standard_ProcessUtility" [07:15:08.547] #19 0x00007fe709364d9d in pgss_ProcessUtility (pstmt=0x5596899d7c28, queryString=0x5596899d6a90 "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=0x559689a07518, qc=0x7ffeb571b120) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [07:15:08.547] _save_exception_stack = 0x7ffeb571b1c0 [07:15:08.547] _save_context_stack = 0x0 [07:15:08.547] _local_sigjmp_buf = {{__jmpbuf = {0, 8848676636347263151, 94105042254888, 94105042449688, 140731942547744, 1, -8849086837442549585, -8862306814422226769}, __mask_was_saved = 0, __saved_mask = {__val = {94105006227331, 2311607752, 0, 94105045064920, 94105006222914, 94105042250128, 11, 1, 94105006227331, 2311608872, 1, 94105042250128, 10, 94105045064504, 140630312054893, 1}}}} [07:15:08.547] _do_rethrow = false [07:15:08.547] duration = [07:15:08.547] bufusage = {shared_blks_hit = 94105042256888, shared_blks_read = 140731942547536, shared_blks_dirtied = 140731942547536, shared_blks_written = 0, local_blks_hit = 0, local_blks_read = 94105006314534, local_blks_dirtied = 0, local_blks_written = 94105042256888, temp_blks_read = 94105045062360, temp_blks_written = 94105045062360, shared_blk_read_time = {ticks = 94105045062280}, shared_blk_write_time = {ticks = 140731942547536}, local_blk_read_time = {ticks = 140731942547536}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94105001246864}} [07:15:08.547] walusage_start = {wal_records = 73, wal_fpi = 4, wal_bytes = 16206} [07:15:08.547] start = [07:15:08.547] rows = [07:15:08.547] bufusage_start = {shared_blks_hit = 1493, shared_blks_read = 335, shared_blks_dirtied = 18, shared_blks_written = 65, local_blks_hit = 0, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [07:15:08.547] walusage = {wal_records = 1, wal_fpi = 94105005705703, wal_bytes = 1} [07:15:08.547] parsetree = [07:15:08.547] saved_queryId = 2738982618451539959 [07:15:08.547] saved_stmt_location = 0 [07:15:08.547] saved_stmt_len = 108 [07:15:08.547] enabled = true [07:15:08.547] #20 0x00005596874abac7 in ProcessUtility (pstmt=pstmt@entry=0x5596899d7c28, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x559689a07518, qc=0x7ffeb571b120) at ../src/backend/tcop/utility.c:519 [07:15:08.547] No locals. [07:15:08.547] #21 0x00005596874a73e8 in PortalRunUtility (portal=portal@entry=0x559689a5a000, pstmt=0x5596899d7c28, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x559689a07518, qc=qc@entry=0x7ffeb571b120) at ../src/backend/tcop/pquery.c:1158 [07:15:08.547] No locals. [07:15:08.547] #22 0x00005596874a7c5b in FillPortalStore (portal=portal@entry=0x559689a5a000, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [07:15:08.547] treceiver = 0x559689a07518 [07:15:08.547] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:15:08.547] __func__ = "FillPortalStore" [07:15:08.547] #23 0x00005596874a824f in PortalRun (portal=portal@entry=0x559689a5a000, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x559689c863a8, altdest=altdest@entry=0x559689c863a8, qc=0x7ffeb571b300) at ../src/backend/tcop/pquery.c:763 [07:15:08.547] _save_exception_stack = 0x7ffeb571b3b0 [07:15:08.547] _save_context_stack = 0x0 [07:15:08.547] _local_sigjmp_buf = {{__jmpbuf = {0, -3323160557232133969, 94105042788352, 94105042254832, 94105042788352, 94105042254760, -8849086837580961617, -3323130888566806353}, __mask_was_saved = 0, __saved_mask = {__val = {94105006222914, 94105042250128, 112, 4, 94105006227331, 3044127375, 4, 94105042254760, 112, 153, 94105042788352, 94105042254832, 94105042254808, 94105042254760, 94105006314534, 1}}}} [07:15:08.547] _do_rethrow = [07:15:08.547] result = [07:15:08.547] nprocessed = [07:15:08.547] saveTopTransactionResourceOwner = 0x559689a194d8 [07:15:08.547] saveTopTransactionContext = 0x559689a6c020 [07:15:08.547] saveActivePortal = 0x0 [07:15:08.547] saveResourceOwner = 0x559689a194d8 [07:15:08.547] savePortalContext = 0x0 [07:15:08.547] saveMemoryContext = 0x559689a6c020 [07:15:08.547] __func__ = "PortalRun" [07:15:08.547] #24 0x00005596874a1342 in exec_simple_query (query_string=query_string@entry=0x5596899d6a90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1283 [07:15:08.547] cmdtaglen = 7 [07:15:08.547] snapshot_set = [07:15:08.547] per_parsetree_context = 0x0 [07:15:08.547] plantree_list = 0x559689c86358 [07:15:08.547] parsetree = 0x5596899d7ba8 [07:15:08.547] commandTag = [07:15:08.547] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:15:08.547] querytree_list = [07:15:08.547] portal = 0x559689a5a000 [07:15:08.547] receiver = 0x559689c863a8 [07:15:08.547] format = 0 [07:15:08.547] cmdtagname = [07:15:08.547] parsetree_item__state = [07:15:08.547] dest = DestRemote [07:15:08.547] oldcontext = 0x559689a6c020 [07:15:08.547] parsetree_list = 0x5596899d7bd8 [07:15:08.547] parsetree_item = 0x5596899d7bf0 [07:15:08.547] save_log_statement_stats = false [07:15:08.547] was_logged = true [07:15:08.547] use_implicit_block = false [07:15:08.547] msec_str = "\004\000\000\000\000\000\000\000\021\334u\207\226U\000\000\220\263q\265\376\177\000\000n\000\000\000\000\000\000" [07:15:08.547] __func__ = "exec_simple_query" [07:15:08.547] #25 0x00005596874a40c6 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4822 [07:15:08.547] query_string = 0x5596899d6a90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [07:15:08.547] firstchar = [07:15:08.547] input_message = {data = 0x5596899d6a90 "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} [07:15:08.547] local_sigjmp_buf = {{__jmpbuf = {94105018901816, -3323162883146717009, 140731942548748, 4, 15, 140731942548980, -8849086837518047057, -3323130886355490641}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94105042508208, 0, 168, 94105006227433, 0, 10, 2, 94105018901824, 94105041980976, 94105018895904, 4, 15, 140731942548980}}}} [07:15:08.547] send_ready_for_query = false [07:15:08.547] idle_in_transaction_timeout_enabled = false [07:15:08.547] idle_session_timeout_enabled = false [07:15:08.547] __func__ = "PostgresMain" [07:15:08.547] #26 0x0000559687499ebb in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:15:08.547] bsdata = [07:15:08.547] #27 0x000055968734b9ef in postmaster_child_launch (child_type=B_BACKEND, child_slot=15, startup_data=startup_data@entry=0x7ffeb571b50c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffeb571b560) at ../src/backend/postmaster/launch_backend.c:274 [07:15:08.547] pid = [07:15:08.547] #28 0x00005596873509ea in BackendStartup (client_sock=client_sock@entry=0x7ffeb571b560) at ../src/backend/postmaster/postmaster.c:3390 [07:15:08.547] bn = 0x559689a03398 [07:15:08.547] pid = [07:15:08.547] startup_data = {canAcceptConnections = CAC_OK} [07:15:08.547] cac = [07:15:08.547] __func__ = "BackendStartup" [07:15:08.547] #29 0x00005596873528c3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [07:15:08.547] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "q\265\376\177\000\000\364\265q\265\376\177", '\000' , "\3223N\206\226U\000\000\200\027J\206\226U\000\000\300\266q\265\376\177\000\000\270\266q\265\376\177\000\000\225[\362\001\000\000\000\000\260\n\240\211\226U\000\000,", '\000' , "\3402N\206\226U\000\000h\206X\r\347\177\000\0000\226C\f\347\177\000", __ss_align = 140630338077408}, salen = 2}} [07:15:08.547] i = 0 [07:15:08.547] now = [07:15:08.547] last_lockfile_recheck_time = 1733641892 [07:15:08.547] last_touch_time = 1733641892 [07:15:08.547] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -2041695278, events = 21910, fd = 223905384, user_data = 0x7fe70c439630}, {pos = 223904480, events = 32743, fd = 2090263927, user_data = 0x7ffeb571b740}, {pos = 223734344, events = 32743, fd = 15, user_data = 0x7fe70c439630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 223904480, events = 32743, fd = -1250838856, user_data = 0x7ffeb571b6c0}, {pos = 223905384, events = 32743, fd = 0, user_data = 0x559689a05108}, {pos = -2021877168, events = 21910, fd = 32768, user_data = 0x1}, {pos = -1986169424, events = 21910, fd = -1, user_data = 0x7fe70bc2e020}, {pos = 219676576, events = 32743, fd = -1985972584, user_data = 0x559689a07578}, {pos = -1985949375, events = 21910, fd = 223760062, user_data = 0x1}, {pos = 223904480, events = 32743, fd = 427, user_data = 0x559687cdcd58 }, {pos = 0, events = 0, fd = 86, user_data = 0x559689a05108}, {pos = 223760062, events = 32743, fd = 1, user_data = 0x0}, {pos = 197320736, events = 32743, fd = 198127168, user_data = 0x10}, {pos = -1250837728, events = 32766, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 223769018, user_data = 0x0}, {pos = 197848484, events = 32743, fd = 0, user_data = 0x559688382900 }, {pos = 2, events = 0, fd = 0, user_data = 0x559689998ed0}, {pos = -2025636422, events = 21910, fd = -1985955429, user_data = 0x5596874379f3 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x559689a05108}, {pos = 223760062, events = 32743, fd = 1, user_data = 0x0}, {pos = 197354696, events = 32743, fd = 197773440, user_data = 0x43a}, {pos = 197881607, events = 32743, fd = 2, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 199171168, events = 32743, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 205759808, user_data = 0x7fe70c43aa80}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = -2022199742, events = 21910, fd = -1985943184, user_data = 0x7fe70bcb576b}, {pos = 199154144, events = 32743, fd = 197792110, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x60ef042bf2d4cd00}, {pos = 199157216, events = 32743, fd = -328, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1985973192, user_data = 0x3}, {pos = 0, events = 0, fd = 28268, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1985982200, user_data = 0x7fe70bcf3053 }, {pos = -1985973192, events = 21910, fd = 1024, user_data = 0x7ffeb571bbe8}, {pos = -2022116426, events = 21910, fd = -2009520912, user_data = 0x55968777de73 }, {pos = -1985973392, events = 21910, fd = -1986172528, user_data = 0x559689a07370}, {pos = 197875563, events = 32743, fd = 0, user_data = 0x55968778fadd }, {pos = -1985973392, events = 1, fd = -2022114266, user_data = 0x5596899d6990}, {pos = -220934912, events = 1626276907, fd = 0, user_data = 0x7fe70bca2ab1}, {pos = 197793008, events = 32743, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1986425136, user_data = 0x60ef042bf2d4cd00}, {pos = 0, events = 0, fd = -220934912, user_data = 0xc}, {pos = -220934912, events = 1626276907, fd = 0, user_data = 0x7fe70bc5b239 }, {pos = 87, events = 0, fd = -2026588436, user_data = 0x400000}, {pos = 0, events = 0, fd = -1986425136, user_data = 0x55968777dd07 }, {pos = -1986338624, events = 21910, fd = -1986172528, user_data = 0x5596899ae0c0}, {pos = 1, events = 0, fd = 0, user_data = 0x55968773c704 }, {pos = 12, events = 0, fd = -1985986248, user_data = 0x559689a04118}, {pos = -2009584000, events = 21910, fd = 296, user_data = 0x55968734df06 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -2026571965, events = 21910, fd = -2013155856, user_data = 0x5596899d7348}} [07:15:08.548] nevents = 1 [07:15:08.548] __func__ = "ServerLoop" [07:15:08.548] #30 0x0000559687354157 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x559689994d30) at ../src/backend/postmaster/postmaster.c:1374 [07:15:08.548] opt = [07:15:08.548] status = [07:15:08.548] userDoption = [07:15:08.548] listen_addr_saved = false [07:15:08.548] output_config_variable = [07:15:08.548] __func__ = "PostmasterMain" [07:15:08.548] #31 0x0000559687181104 in main (argc=4, argv=0x559689994d30) at ../src/backend/main/main.c:222 [07:15:08.548] do_check_root = [07:15:08.548] dispatch_option = [07:15:08.589] -e [07:15:08.589] [07:15:08.589] [07:15:08.654] dumping /tmp/cores/postgres-6-39479.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:15:08.908] [New LWP 39479] [07:15:08.908] [07:15:08.908] This GDB supports auto-downloading debuginfo from the following URLs: [07:15:08.908] [07:15:08.908] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [07:15:08.908] Debuginfod has been disabled. [07:15:08.908] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [07:15:09.020] [Thread debugging using libthread_db enabled] [07:15:09.020] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:15:09.020] Core was generated by `postgres: test: postgres db1 [local] SELECT '. [07:15:09.020] Program terminated with signal SIGABRT, Aborted. [07:15:09.020] #0 0x00007f32974a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:09.079] [07:15:09.079] Thread 1 (Thread 0x7f3297c34f00 (LWP 39479)): [07:15:09.079] #0 0x00007f32974a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:09.079] No symbol table info available. [07:15:09.079] #1 0x00007f329745afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:09.079] No symbol table info available. [07:15:09.079] #2 0x00007f3297445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:09.079] No symbol table info available. [07:15:09.079] #3 0x00007f329761e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [07:15:09.079] No locals. [07:15:09.079] #4 0x00007f329762aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [07:15:09.079] No locals. [07:15:09.079] #5 0x00007f329760dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x559fdbd1b100, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [07:15:09.079] bp = 140732095880208 [07:15:09.079] pc = [07:15:09.079] Opts = {FromUnrecoverableHandler = true, pc = 94145062198780, bp = 139855068331176} [07:15:09.079] #6 0x0000559fdafd5dfc in examine_self_contradictory_rels (root=root@entry=0x559fdd0aaf28, rel=rel@entry=0x559fdd0b4c18, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [07:15:09.079] lc__state = [07:15:09.079] rlist = [07:15:09.079] i = 7 [07:15:09.079] br = [07:15:09.079] expression = [07:15:09.079] or_rinfo = 0x7f328bab0e48 [07:15:09.079] ccxt = [07:15:09.079] delidx = 0x7f328bab3ff1 [07:15:09.079] arglst = [07:15:09.079] lc = [07:15:09.079] arg = [07:15:09.079] n = [07:15:09.079] restrictinfo = [07:15:09.079] ccwapper = {clausecxt = 0x7f328bab1c88} [07:15:09.079] sec = {sopcinfo = {n_members = 38, opcies = 0x7f328bab1428}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7f328bab1838, atop_set = 0x7f328baaf398}, ccfree = 0x7f328bab3fc0, vifree = 0x7f328bab2ed8} [07:15:09.079] __func__ = "examine_self_contradictory_rels" [07:15:09.079] #7 0x0000559fdafd600b in examine_self_contradictory_rels_phase1 (root=root@entry=0x559fdd0aaf28) at ../src/backend/optimizer/plan/contradictory.c:2608 [07:15:09.079] rel = 0x559fdd0b4c18 [07:15:09.079] rti = 1 [07:15:09.079] rinfo = [07:15:09.079] #8 0x0000559fdafa064d in query_planner (root=root@entry=0x559fdd0aaf28, qp_callback=qp_callback@entry=0x559fdafa596a , qp_extra=qp_extra@entry=0x7ffebe955e10) at ../src/backend/optimizer/plan/planmain.c:190 [07:15:09.079] parse = 0x559fdd0a1720 [07:15:09.079] joinlist = 0x7f328baaf528 [07:15:09.079] final_rel = [07:15:09.079] __func__ = "query_planner" [07:15:09.079] #9 0x0000559fdafb3a40 in grouping_planner (root=root@entry=0x559fdd0aaf28, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [07:15:09.079] sort_input_targets = 0x559fdd0aaf28 [07:15:09.079] sort_input_target_parallel_safe = [07:15:09.079] grouping_target = [07:15:09.079] scanjoin_target = [07:15:09.079] activeWindows = 0x0 [07:15:09.079] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [07:15:09.079] sort_input_targets_contain_srfs = 0x559fdd0a8720 [07:15:09.079] have_grouping = [07:15:09.079] wflists = 0x0 [07:15:09.079] gset_data = 0x0 [07:15:09.079] sort_input_target = [07:15:09.079] grouping_targets = 0x559fdd0a8768 [07:15:09.079] grouping_target_parallel_safe = [07:15:09.079] scanjoin_targets = 0x559fdd0a8750 [07:15:09.079] scanjoin_target_parallel_safe = [07:15:09.079] grouping_targets_contain_srfs = 0x559fdd0aaf28 [07:15:09.079] scanjoin_targets_contain_srfs = 0x0 [07:15:09.079] scanjoin_target_same_exprs = [07:15:09.079] parse = 0x559fdd0a1720 [07:15:09.079] offset_est = 0 [07:15:09.079] count_est = 0 [07:15:09.079] limit_tuples = -1 [07:15:09.079] have_postponed_srfs = false [07:15:09.079] final_target = [07:15:09.079] final_targets = 0x559fdd0aaf28 [07:15:09.079] final_targets_contain_srfs = 0x7 [07:15:09.079] final_target_parallel_safe = [07:15:09.079] current_rel = [07:15:09.079] final_rel = [07:15:09.079] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94145096587040} [07:15:09.079] lc = [07:15:09.079] __func__ = "grouping_planner" [07:15:09.079] #10 0x0000559fdafb69c4 in subquery_planner (glob=, parse=0x559fdd0a1720, parent_root=parent_root@entry=0x559fdd09e8e0, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1153 [07:15:09.079] root = 0x559fdd0aaf28 [07:15:09.079] newWithCheckOptions = [07:15:09.079] newHaving = 0x0 [07:15:09.079] hasOuterJoins = [07:15:09.079] hasResultRTEs = true [07:15:09.079] final_rel = [07:15:09.079] l = 0x0 [07:15:09.079] #11 0x0000559fdafc835e in SS_process_ctes (root=root@entry=0x559fdd09e8e0) at ../src/backend/optimizer/plan/subselect.c:966 [07:15:09.079] subquery = [07:15:09.079] cte = 0x559fdd064490 [07:15:09.079] cmdType = [07:15:09.079] subroot = [07:15:09.079] final_rel = [07:15:09.079] best_path = [07:15:09.079] plan = [07:15:09.079] splan = [07:15:09.079] paramid = [07:15:09.079] lc__state = [07:15:09.079] lc = [07:15:09.079] __func__ = "SS_process_ctes" [07:15:09.079] #12 0x0000559fdafb5468 in subquery_planner (glob=glob@entry=0x559fdd0796e8, parse=parse@entry=0x559fdd0797f8, 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:706 [07:15:09.079] root = 0x559fdd09e8e0 [07:15:09.079] newWithCheckOptions = [07:15:09.079] newHaving = [07:15:09.079] hasOuterJoins = [07:15:09.079] hasResultRTEs = [07:15:09.079] final_rel = [07:15:09.079] l = [07:15:09.079] #13 0x0000559fdafb7655 in standard_planner (parse=0x559fdd0797f8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [07:15:09.079] result = [07:15:09.079] glob = 0x559fdd0796e8 [07:15:09.079] tuple_fraction = 0 [07:15:09.079] root = [07:15:09.079] final_rel = [07:15:09.079] best_path = [07:15:09.079] top_plan = [07:15:09.079] lp = [07:15:09.079] lr = [07:15:09.079] #14 0x0000559fdafb86bf in planner (parse=parse@entry=0x559fdd0797f8, query_string=query_string@entry=0x559fdcf895a0 "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:294 [07:15:09.079] result = [07:15:09.079] #15 0x0000559fdb22786c in pg_plan_query (querytree=querytree@entry=0x559fdd0797f8, query_string=query_string@entry=0x559fdcf895a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [07:15:09.079] plan = [07:15:09.079] #16 0x0000559fdb227c4d in pg_plan_queries (querytrees=0x559fdd09e890, query_string=query_string@entry=0x559fdcf895a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:1005 [07:15:09.079] query = 0x559fdd0797f8 [07:15:09.079] stmt = [07:15:09.079] query_list__state = [07:15:09.079] stmt_list = 0x0 [07:15:09.079] query_list = [07:15:09.079] #17 0x0000559fdb2281fa in exec_simple_query (query_string=query_string@entry=0x559fdcf895a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "...) at ../src/backend/tcop/postgres.c:1202 [07:15:09.079] cmdtaglen = 6 [07:15:09.079] snapshot_set = true [07:15:09.079] per_parsetree_context = 0x0 [07:15:09.079] plantree_list = [07:15:09.079] parsetree = 0x559fdd079668 [07:15:09.079] commandTag = CMDTAG_SELECT [07:15:09.079] qc = {commandTag = 1935, nprocessed = 94145095439776} [07:15:09.079] querytree_list = [07:15:09.079] portal = [07:15:09.079] receiver = [07:15:09.079] format = 0 [07:15:09.079] cmdtagname = [07:15:09.079] parsetree_item__state = [07:15:09.079] dest = DestRemote [07:15:09.079] oldcontext = 0x559fdd018f40 [07:15:09.079] parsetree_list = 0x559fdd079698 [07:15:09.079] parsetree_item = 0x559fdd0796b0 [07:15:09.079] save_log_statement_stats = false [07:15:09.079] was_logged = true [07:15:09.079] use_implicit_block = false [07:15:09.079] msec_str = "\004\000\000\000\000\000\000\000\021LN۟U\000\000\340a\225\276\376\177\000\000\217\a\000\000\000\000\000" [07:15:09.079] __func__ = "exec_simple_query" [07:15:09.079] #18 0x0000559fdb22b0c6 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4822 [07:15:09.079] query_string = 0x559fdcf895a0 "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 "... [07:15:09.079] firstchar = [07:15:09.079] input_message = {data = 0x559fdcf895a0 "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} [07:15:09.079] local_sigjmp_buf = {{__jmpbuf = {94145080300856, -5128756067865559339, 140732095882076, 4, 2, 140732095882308, -1436583897520505131, -5128771073044742443}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94145095167440, 14336, 94145080294944, 94145095674960, 2, 94145067625919, 0, 9, 2, 94145080300864, 94145095167440, 94145080294944, 4, 2, 140732095882308}}}} [07:15:09.079] send_ready_for_query = false [07:15:09.079] idle_in_transaction_timeout_enabled = false [07:15:09.079] idle_session_timeout_enabled = false [07:15:09.079] __func__ = "PostgresMain" [07:15:09.079] #19 0x0000559fdb220ebb in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:15:09.079] bsdata = [07:15:09.079] #20 0x0000559fdb0d29ef in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x7ffebe95635c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffebe9563b0) at ../src/backend/postmaster/launch_backend.c:274 [07:15:09.079] pid = [07:15:09.079] #21 0x0000559fdb0d79ea in BackendStartup (client_sock=client_sock@entry=0x7ffebe9563b0) at ../src/backend/postmaster/postmaster.c:3390 [07:15:09.079] bn = 0x559fdcfb05f8 [07:15:09.079] pid = [07:15:09.079] startup_data = {canAcceptConnections = CAC_OK} [07:15:09.079] cac = [07:15:09.079] __func__ = "BackendStartup" [07:15:09.079] #22 0x0000559fdb0d98c3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [07:15:09.079] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "ң&ڟU\000\000\200\207\"ڟU\000\000\000e\225\276\376\177\000\000\370d\225\276\376\177\000\000\225[\362\001\000\000\000\000\2404ė2\177\000\000+", '\000' , "\376\177\000\000\000\004\000\000\000\000\000\000h6ߘ2\177\000\00006ė2\177\000\000\3402ߘ2\177\000\000\316)fR\000\000\000", __ss_align = 3197461824}, salen = 2}} [07:15:09.079] i = 0 [07:15:09.079] now = [07:15:09.079] last_lockfile_recheck_time = 1733641942 [07:15:09.079] last_touch_time = 1733641942 [07:15:09.079] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1748748752, events = 32562, fd = -1730202912, user_data = 0x7c96e577}, {pos = -1097505408, events = 32766, fd = -1730373048, user_data = 0xf}, {pos = -1748748752, events = 32562, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1730202912, user_data = 0x7ffebe9564f8}, {pos = -1097505536, events = 32766, fd = -1730202008, user_data = 0x0}, {pos = -587683296, events = 21919, fd = -1756661110, user_data = 0x559fdcf8aa20}, {pos = 1, events = 21919, fd = 32768, user_data = 0xffffffff}, {pos = -1757224928, events = 32562, fd = -1735123040, user_data = 0x559fdcfb4358}, {pos = -587513288, events = 21919, fd = -587515903, user_data = 0x7f3298dcfebe}, {pos = 1, events = 0, fd = -1730202912, user_data = 0x1ab}, {pos = -609862312, events = 21919, fd = 0, user_data = 0xd8}, {pos = -587683296, events = 21919, fd = -1730347330, user_data = 0x1}, {pos = 0, events = 0, fd = -1757224928, user_data = 0x7f32974f2e40 }, {pos = 16, events = 0, fd = -1097504400, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f3298dd21ba}, {pos = 0, events = 0, fd = -1756697180, user_data = 0x0}, {pos = -602892032, events = 21919, fd = 2, user_data = 0x0}, {pos = -587944336, events = 21919, fd = -618947035, user_data = 0x559fdcfbbb00}, {pos = -618943046, events = 21919, fd = -587482277, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -1757190968, user_data = 0x7f329749c880 }, {pos = -1748808264, events = 32562, fd = -1097504208, user_data = 0x100007f00000002}, {pos = -1756664057, events = 32562, fd = 2, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -1755374496, events = 32562, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 878082156, events = 1802860908, fd = 168441929, user_data = 0x74616467702f6174}, {pos = 925960801, events = 875967283, 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 = -587509088, events = 21919, fd = -1756661110, user_data = 0xa}, {pos = -615506366, events = 21919, fd = -587500864, user_data = 0x7f32974b58be}, {pos = -1755391520, events = 32562, fd = -1756753554, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xc942a6949f3c9800}, {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 = 0x559fdcfb4030}, {pos = 1, events = 0, fd = -587513608, user_data = 0x3}, {pos = 0, events = 0, fd = 39009, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -587683296, user_data = 0x7f32974f3053 }, {pos = -587513608, events = 21919, fd = 1024, user_data = 0x7ffebe956a38}, {pos = -615423050, events = 21919, fd = -602827536, user_data = 0x559fdb504e73 }, {pos = -587513808, events = 21919, fd = -587690880, user_data = 0x559fdcfb4030}, {pos = -1756670101, events = 32562, fd = 0, user_data = 0x559fdb516add }, {pos = -587513808, events = 1, fd = -615420890, user_data = 0x559fdcf88c80}, {pos = -1623418880, events = 3376588436, fd = 0, user_data = 0x7f32974a2ab1}, {pos = -1756752656, events = 32562, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -587944336, user_data = 0xc942a6949f3c9800}, {pos = 0, events = 0, fd = -1623418880, user_data = 0xc}, {pos = -1623418880, events = 3376588436, fd = 0, user_data = 0x7f329745b239 }, {pos = 217, events = 0, fd = -619895060, user_data = 0x400000}, {pos = 0, events = 0, fd = -587944336, user_data = 0x559fdb504d07 }, {pos = -587856976, events = 21919, fd = -587690880, user_data = 0x559fdcf603b0}, {pos = 1, events = 0, fd = 0, user_data = 0x559fdb4c3704 }, {pos = 12, events = 0, fd = -587518360, user_data = 0x559fdcfb2e48}, {pos = -602890624, events = 21919, fd = 296, user_data = 0x559fdb0d4f06 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -619878589, events = 21919, fd = -606462480, user_data = 0x559fdcf89638}} [07:15:09.079] nevents = 1 [07:15:09.079] __func__ = "ServerLoop" [07:15:09.079] #23 0x0000559fdb0db157 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x559fdcf46ce0) at ../src/backend/postmaster/postmaster.c:1374 [07:15:09.079] opt = [07:15:09.079] status = [07:15:09.079] userDoption = [07:15:09.079] listen_addr_saved = false [07:15:09.079] output_config_variable = [07:15:09.079] __func__ = "PostmasterMain" [07:15:09.079] #24 0x0000559fdaf08104 in main (argc=4, argv=0x559fdcf46ce0) at ../src/backend/main/main.c:222 [07:15:09.079] do_check_root = [07:15:09.079] dispatch_option = [07:15:09.099] -e [07:15:09.099] [07:15:09.099] [07:15:09.169] dumping /tmp/cores/postgres-6-25589.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [07:15:09.429] [New LWP 25589] [07:15:09.429] [07:15:09.429] This GDB supports auto-downloading debuginfo from the following URLs: [07:15:09.429] [07:15:09.429] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [07:15:09.429] Debuginfod has been disabled. [07:15:09.429] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [07:15:09.543] [Thread debugging using libthread_db enabled] [07:15:09.543] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:15:09.543] Core was generated by `postgres: postgres regression [local] SELECT '. [07:15:09.543] Program terminated with signal SIGABRT, Aborted. [07:15:09.543] #0 0x00007f13c4aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:10.641] [07:15:10.641] Thread 1 (Thread 0x7f13c49d6f00 (LWP 25589)): [07:15:10.641] #0 0x00007f13c4aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:10.641] No symbol table info available. [07:15:10.641] #1 0x00007f13c4a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:10.641] No symbol table info available. [07:15:10.641] #2 0x00007f13c4a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:10.641] No symbol table info available. [07:15:10.641] #3 0x00007f13c4c1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [07:15:10.641] No locals. [07:15:10.641] #4 0x00007f13c4c2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [07:15:10.641] No locals. [07:15:10.641] #5 0x00007f13c4c0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5601208b3100, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [07:15:10.641] bp = 140726177139856 [07:15:10.641] pc = [07:15:10.641] Opts = {FromUnrecoverableHandler = true, pc = 94562827034108, bp = 94562857634632} [07:15:10.641] #6 0x000056011fb6ddfc in examine_self_contradictory_rels (root=root@entry=0x56012189aa08, rel=rel@entry=0x56012188db60, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [07:15:10.641] lc__state = [07:15:10.641] rlist = [07:15:10.641] i = 3 [07:15:10.641] br = [07:15:10.641] expression = [07:15:10.641] or_rinfo = 0x56012189d920 [07:15:10.641] ccxt = [07:15:10.641] delidx = 0x56012189e0a1 [07:15:10.641] arglst = [07:15:10.641] lc = [07:15:10.641] arg = [07:15:10.641] n = [07:15:10.641] restrictinfo = [07:15:10.641] ccwapper = {clausecxt = 0x56012189d660} [07:15:10.641] sec = {sopcinfo = {n_members = 38, opcies = 0x56012189cd08}, attrsdc = {min_attr = -6, max_attr = 7, len_set = 2, atop_array = 0x56012189c298, atop_set = 0x56012189c828}, ccfree = 0x56012189d630, vifree = 0x56012189dc90} [07:15:10.641] __func__ = "examine_self_contradictory_rels" [07:15:10.641] #7 0x000056011fb6e00b in examine_self_contradictory_rels_phase1 (root=root@entry=0x56012189aa08) at ../src/backend/optimizer/plan/contradictory.c:2608 [07:15:10.641] rel = 0x56012188db60 [07:15:10.641] rti = 1 [07:15:10.641] rinfo = [07:15:10.641] #8 0x000056011fb3864d in query_planner (root=root@entry=0x56012189aa08, qp_callback=qp_callback@entry=0x56011fb3d96a , qp_extra=qp_extra@entry=0x7ffd5dcc8e90) at ../src/backend/optimizer/plan/planmain.c:190 [07:15:10.641] parse = 0x56012188c998 [07:15:10.641] joinlist = 0x56012189c898 [07:15:10.641] final_rel = [07:15:10.641] __func__ = "query_planner" [07:15:10.641] #9 0x000056011fb4ba40 in grouping_planner (root=root@entry=0x56012189aa08, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [07:15:10.641] sort_input_targets = 0x56012189b7f8 [07:15:10.641] sort_input_target_parallel_safe = [07:15:10.641] grouping_target = [07:15:10.641] scanjoin_target = [07:15:10.641] activeWindows = 0x0 [07:15:10.641] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [07:15:10.641] sort_input_targets_contain_srfs = 0x2 [07:15:10.641] have_grouping = [07:15:10.641] wflists = 0x0 [07:15:10.641] gset_data = 0x0 [07:15:10.641] sort_input_target = [07:15:10.641] grouping_targets = 0x0 [07:15:10.641] grouping_target_parallel_safe = [07:15:10.641] scanjoin_targets = 0x56012189aa08 [07:15:10.641] scanjoin_target_parallel_safe = [07:15:10.641] grouping_targets_contain_srfs = 0x56012189b898 [07:15:10.641] scanjoin_targets_contain_srfs = 0x0 [07:15:10.641] scanjoin_target_same_exprs = [07:15:10.641] parse = 0x56012188c998 [07:15:10.641] offset_est = 0 [07:15:10.641] count_est = 0 [07:15:10.641] limit_tuples = -1 [07:15:10.641] have_postponed_srfs = false [07:15:10.641] final_target = [07:15:10.641] final_targets = 0x5601218b9c08 [07:15:10.641] final_targets_contain_srfs = 0x56011fb8cd59 [07:15:10.641] final_target_parallel_safe = [07:15:10.641] current_rel = [07:15:10.641] final_rel = [07:15:10.641] extra = {limit_needed = 200, limit_tuples = 4.6720259325642824e-310, count_est = 94562857629848, offset_est = 94562857626120} [07:15:10.641] lc = [07:15:10.641] __func__ = "grouping_planner" [07:15:10.641] #10 0x000056011fb4e9c4 in subquery_planner (glob=glob@entry=0x56012188da50, parse=parse@entry=0x56012188c998, 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:1153 [07:15:10.641] root = 0x56012189aa08 [07:15:10.641] newWithCheckOptions = [07:15:10.641] newHaving = 0x0 [07:15:10.641] hasOuterJoins = [07:15:10.641] hasResultRTEs = false [07:15:10.641] final_rel = [07:15:10.641] l = 0x0 [07:15:10.641] #11 0x000056011fb4f655 in standard_planner (parse=0x56012188c998, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [07:15:10.641] result = [07:15:10.641] glob = 0x56012188da50 [07:15:10.641] tuple_fraction = 0 [07:15:10.641] root = [07:15:10.641] final_rel = [07:15:10.641] best_path = [07:15:10.641] top_plan = [07:15:10.641] lp = [07:15:10.641] lr = [07:15:10.641] #12 0x000056011fb506bf in planner (parse=parse@entry=0x56012188c998, query_string=query_string@entry=0x5601218d43b0 "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:294 [07:15:10.641] result = [07:15:10.641] #13 0x000056011fdbf86c in pg_plan_query (querytree=querytree@entry=0x56012188c998, query_string=query_string@entry=0x5601218d43b0 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [07:15:10.641] plan = [07:15:10.641] #14 0x000056011f8c53d0 in standard_ExplainOneQuery (query=0x56012188c998, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x56012188d4e0, queryString=0x5601218d43b0 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:496 [07:15:10.641] plan = [07:15:10.641] planstart = [07:15:10.641] planduration = {ticks = 94562826209724} [07:15:10.641] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94562832461699, shared_blks_dirtied = 1573687678, shared_blks_written = 3, local_blks_hit = 4857873072, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94562857568664, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94562832548493}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94562826207105}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94562857568664}} [07:15:10.641] bufusage = {shared_blks_hit = 0, shared_blks_read = 94562829230120, shared_blks_dirtied = 154717606920192, shared_blks_written = 72057594037927936, local_blks_hit = 139722685380864, local_blks_read = 94562857862752, local_blks_dirtied = 94562857568664, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94562832077023, shared_blk_read_time = {ticks = 139722685380864}, shared_blk_write_time = {ticks = 94562832077042}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94562832457282}, temp_blk_read_time = {ticks = 94562857861808}, temp_blk_write_time = {ticks = 64}} [07:15:10.641] mem_counters = {nblocks = 94562857572784, freechunks = 4294967297, totalspace = 140726177140992, freespace = 10} [07:15:10.641] planner_ctx = 0x0 [07:15:10.641] saved_ctx = 0x0 [07:15:10.641] #15 0x000056011f8c56b6 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x56012188d4e0, pstate=pstate@entry=0x56012188d3d0, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [07:15:10.641] No locals. [07:15:10.641] #16 0x000056011f8c65b6 in ExplainQuery (pstate=pstate@entry=0x56012188d3d0, stmt=stmt@entry=0x5601218d45a0, params=params@entry=0x0, dest=dest@entry=0x56012188d340) at ../src/backend/commands/explain.c:350 [07:15:10.641] l__state = [07:15:10.641] l = 0x56012188da18 [07:15:10.641] es = 0x56012188d4e0 [07:15:10.641] tstate = [07:15:10.641] jstate = [07:15:10.641] query = [07:15:10.641] rewritten = 0x56012188da00 [07:15:10.641] lc = 0x0 [07:15:10.641] timing_set = false [07:15:10.641] summary_set = false [07:15:10.641] __func__ = "ExplainQuery" [07:15:10.641] #17 0x000056011fdca453 in standard_ProcessUtility (pstmt=0x5601218d4490, queryString=0x5601218d43b0 "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=0x56012188d340, qc=0x7ffd5dcc9380) at ../src/backend/tcop/utility.c:866 [07:15:10.641] parsetree = 0x5601218d45a0 [07:15:10.641] isTopLevel = false [07:15:10.641] isAtomicContext = true [07:15:10.641] pstate = 0x56012188d3d0 [07:15:10.641] readonly_flags = [07:15:10.641] __func__ = "standard_ProcessUtility" [07:15:10.641] #18 0x000056011fdcab7c in ProcessUtility (pstmt=pstmt@entry=0x5601218d4490, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_QUERY, params=, queryEnv=, dest=0x56012188d340, qc=0x7ffd5dcc9380) at ../src/backend/tcop/utility.c:523 [07:15:10.641] No locals. [07:15:10.641] #19 0x000056011fdc63e8 in PortalRunUtility (portal=portal@entry=0x5601217bc210, pstmt=0x5601218d4490, isTopLevel=isTopLevel@entry=false, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x56012188d340, qc=qc@entry=0x7ffd5dcc9380) at ../src/backend/tcop/pquery.c:1158 [07:15:10.641] No locals. [07:15:10.641] #20 0x000056011fdc6c5b in FillPortalStore (portal=portal@entry=0x5601217bc210, isTopLevel=isTopLevel@entry=false) at ../src/backend/tcop/pquery.c:1031 [07:15:10.641] treceiver = 0x56012188d340 [07:15:10.641] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:15:10.641] __func__ = "FillPortalStore" [07:15:10.641] #21 0x000056011fdc76de in PortalRunFetch (portal=portal@entry=0x5601217bc210, fdirection=fdirection@entry=FETCH_FORWARD, count=count@entry=10, dest=dest@entry=0x5601205e75e0 ) at ../src/backend/tcop/pquery.c:1442 [07:15:10.641] _save_exception_stack = 0x7ffd5dcc9930 [07:15:10.641] _save_context_stack = 0x7ffd5dcc97a0 [07:15:10.641] _local_sigjmp_buf = {{__jmpbuf = {94562856714768, 8896530598064274715, 0, 10, 140726177142720, 94562856550648, 2922319524269374747, 8896489695266323739}, __mask_was_saved = 0, __saved_mask = {__val = {531005400, 94562857862064, 94562832467418, 140726177142688, 94562825959959, 144, 139722686172103, 94562857478416, 8192, 94562857446896, 94562857478416, 94562857478416, 94562857478672, 0, 94562832459525, 0}}}} [07:15:10.641] _do_rethrow = [07:15:10.641] result = [07:15:10.641] saveActivePortal = 0x5601217bc100 [07:15:10.641] saveResourceOwner = 0x56012177b538 [07:15:10.641] savePortalContext = 0x5601218d2e60 [07:15:10.641] oldContext = 0x56012184a260 [07:15:10.641] __func__ = "PortalRunFetch" [07:15:10.641] #22 0x000056011fa68159 in _SPI_cursor_operation (portal=portal@entry=0x5601217bc210, direction=direction@entry=FETCH_FORWARD, count=count@entry=10, dest=0x5601205e75e0 ) at ../src/backend/executor/spi.c:3027 [07:15:10.641] nfetched = [07:15:10.641] __func__ = "_SPI_cursor_operation" [07:15:10.641] #23 0x000056011fa6da4e in SPI_cursor_fetch (portal=portal@entry=0x5601217bc210, forward=forward@entry=true, count=10) at ../src/backend/executor/spi.c:1808 [07:15:10.641] No locals. [07:15:10.641] #24 0x00007f13b9128ef1 in exec_for_query (estate=estate@entry=0x7ffd5dcc97c0, stmt=stmt@entry=0x5601217940f8, portal=portal@entry=0x5601217bc210, prefetch_ok=, prefetch_ok@entry=true) at ../src/pl/plpgsql/src/pl_exec.c:5887 [07:15:10.641] var = 0x560121794148 [07:15:10.641] tuptab = [07:15:10.641] found = false [07:15:10.641] rc = 0 [07:15:10.641] previous_id = 1 [07:15:10.641] tupdescs_match = true [07:15:10.641] n = [07:15:10.641] #25 0x00007f13b9129afb in exec_stmt_dynfors (estate=estate@entry=0x7ffd5dcc97c0, stmt=stmt@entry=0x5601217940f8) at ../src/pl/plpgsql/src/pl_exec.c:4645 [07:15:10.641] portal = 0x5601217bc210 [07:15:10.641] rc = [07:15:10.641] #26 0x00007f13b912543c in exec_stmts (estate=estate@entry=0x7ffd5dcc97c0, stmts=0x5601217947f8) at ../src/pl/plpgsql/src/pl_exec.c:2096 [07:15:10.641] stmt = 0x5601217940f8 [07:15:10.641] rc = [07:15:10.641] s__state = [07:15:10.641] save_estmt = 0x560121794848 [07:15:10.641] s = [07:15:10.641] __func__ = "exec_stmts" [07:15:10.641] #27 0x00007f13b912610a in exec_stmt_block (estate=estate@entry=0x7ffd5dcc97c0, block=block@entry=0x560121794848) at ../src/pl/plpgsql/src/pl_exec.c:1939 [07:15:10.641] rc = -1 [07:15:10.641] i = 3 [07:15:10.641] __func__ = "exec_stmt_block" [07:15:10.641] #28 0x00007f13b9126251 in exec_toplevel_block (estate=estate@entry=0x7ffd5dcc97c0, block=0x560121794848) at ../src/pl/plpgsql/src/pl_exec.c:1630 [07:15:10.641] rc = [07:15:10.641] #29 0x00007f13b9126986 in plpgsql_exec_function (func=func@entry=0x56012177b128, fcinfo=fcinfo@entry=0x560121794cd0, 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 [07:15:10.641] estate = {func = 0x56012177b128, 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 = 0x56012185dd80, tuple_store_owner = 0x56012177b538, rsi = 0x7ffd5dcc9a70, found_varno = 4, ndatums = 9, datums = 0x560121863ec0, datum_context = 0x560121863d70, paramLI = 0x560121863e70, simple_eval_estate = 0x560121867e90, simple_eval_resowner = 0x5601217795a8, procedure_resowner = 0x0, cast_hash = 0x560121878a20, stmt_mcontext = 0x560121876910, stmt_mcontext_parent = 0x560121863d70, eval_tuptable = 0x0, eval_processed = 0, eval_econtext = 0x5601218680a0, err_stmt = 0x5601217940f8, err_var = 0x0, err_text = 0x0, plugin_info = 0x0} [07:15:10.641] plerrcontext = {previous = 0x0, callback = 0x7f13b9123625 , arg = 0x7ffd5dcc97c0} [07:15:10.641] i = 1 [07:15:10.641] rc = [07:15:10.641] __func__ = "plpgsql_exec_function" [07:15:10.641] #30 0x00007f13b912fc9b in plpgsql_call_handler (fcinfo=0x560121794cd0) at ../src/pl/plpgsql/src/pl_handler.c:276 [07:15:10.641] _save_exception_stack = 0x7ffd5dcc9d90 [07:15:10.641] _save_context_stack = 0x0 [07:15:10.641] _local_sigjmp_buf = {{__jmpbuf = {94562856448296, -2921550249600107237, 0, 94562857378488, 1, 94562857380944, 2922319524514741531, 2977974068166901019}, __mask_was_saved = 0, __saved_mask = {__val = {94562856553720, 0, 0, 0, 94562825182834, 94562856553680, 94562857380120, 32, 94562825385216, 562424420, 94562857378488, 94562856553424, 94562856553680, 94562856553424, 94562825579223, 94562856553680}}}} [07:15:10.641] _do_rethrow = false [07:15:10.641] nonatomic = false [07:15:10.641] func = 0x56012177b128 [07:15:10.641] save_cur_estate = 0x0 [07:15:10.641] procedure_resowner = 0x0 [07:15:10.641] retval = 0 [07:15:10.641] rc = [07:15:10.641] __func__ = "plpgsql_call_handler" [07:15:10.641] #31 0x000056011f9dcbe7 in ExecMakeTableFunctionResult (setexpr=0x56012185e3e8, econtext=0x56012185e2b8, argContext=, expectedDesc=0x56012185ec50, randomAccess=false) at ../src/backend/executor/execSRF.c:234 [07:15:10.641] result = 94562831946810 [07:15:10.641] tupstore = 0x0 [07:15:10.641] tupdesc = 0x0 [07:15:10.641] funcrettype = 2249 [07:15:10.641] returnsTuple = [07:15:10.641] returnsSet = true [07:15:10.641] fcinfo = 0x560121794cd0 [07:15:10.641] fcusage = {fs = 0x0, save_f_total_time = {ticks = 94562831940071}, save_total = {ticks = 0}, start = {ticks = 94562831931930}} [07:15:10.641] rsinfo = {type = T_ReturnSetInfo, econtext = 0x56012185e2b8, expectedDesc = 0x56012185ec50, allowedModes = 11, returnMode = SFRM_ValuePerCall, isDone = ExprSingleResult, setResult = 0x0, setDesc = 0x0} [07:15:10.641] tmptup = {t_len = 0, t_self = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 23}, t_tableOid = 0, t_data = 0x0} [07:15:10.641] callerContext = 0x56012185dd80 [07:15:10.641] first_time = true [07:15:10.641] __func__ = "ExecMakeTableFunctionResult" [07:15:10.641] #32 0x000056011fa0ae00 in FunctionNext (node=0x56012185e0a8) at ../src/backend/executor/nodeFunctionscan.c:94 [07:15:10.641] tstore = 0x0 [07:15:10.641] estate = [07:15:10.641] direction = ForwardScanDirection [07:15:10.641] scanslot = 0x56012185ee70 [07:15:10.641] alldone = [07:15:10.641] oldpos = [07:15:10.641] funcno = [07:15:10.641] att = [07:15:10.641] #33 0x000056011f9de547 in ExecScanFetch (node=node@entry=0x56012185e0a8, accessMtd=accessMtd@entry=0x56011fa0abcb , recheckMtd=recheckMtd@entry=0x56011fa0aad7 ) at ../src/backend/executor/execScan.c:131 [07:15:10.641] estate = [07:15:10.641] #34 0x000056011f9de651 in ExecScan (node=0x56012185e0a8, accessMtd=accessMtd@entry=0x56011fa0abcb , recheckMtd=recheckMtd@entry=0x56011fa0aad7 ) at ../src/backend/executor/execScan.c:180 [07:15:10.641] econtext = 0x56012185e2b8 [07:15:10.641] qual = 0x0 [07:15:10.641] projInfo = 0x0 [07:15:10.641] #35 0x000056011fa0ab4f in ExecFunctionScan (pstate=) at ../src/backend/executor/nodeFunctionscan.c:269 [07:15:10.641] node = [07:15:10.641] #36 0x000056011f9d72f1 in ExecProcNodeFirst (node=0x56012185e0a8) at ../src/backend/executor/execProcnode.c:469 [07:15:10.641] No locals. [07:15:10.641] #37 0x000056011f9c2728 in ExecProcNode (node=node@entry=0x56012185e0a8) at ../src/include/executor/executor.h:278 [07:15:10.641] No locals. [07:15:10.641] #38 0x000056011f9c28dd in ExecutePlan (estate=estate@entry=0x56012185de80, planstate=0x56012185e0a8, use_parallel_mode=, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x56012182fd00, execute_once=true) at ../src/backend/executor/execMain.c:1655 [07:15:10.641] slot = [07:15:10.641] current_tuple_count = 0 [07:15:10.641] #39 0x000056011f9c4655 in standard_ExecutorRun (queryDesc=0x5601218d2f60, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:362 [07:15:10.641] estate = 0x56012185de80 [07:15:10.641] operation = CMD_SELECT [07:15:10.641] dest = 0x56012182fd00 [07:15:10.641] sendTuples = [07:15:10.641] oldcontext = 0x5601218d2e60 [07:15:10.641] __func__ = "standard_ExecutorRun" [07:15:10.641] #40 0x000056011f9c4888 in ExecutorRun (queryDesc=queryDesc@entry=0x5601218d2f60, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:303 [07:15:10.641] No locals. [07:15:10.641] #41 0x000056011fdc3caf in PortalRunSelect (portal=portal@entry=0x5601217bc100, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x56012182fd00) at ../src/backend/tcop/pquery.c:924 [07:15:10.641] queryDesc = 0x5601218d2f60 [07:15:10.641] direction = [07:15:10.641] nprocessed = [07:15:10.641] __func__ = "PortalRunSelect" [07:15:10.641] #42 0x000056011fdc7167 in PortalRun (portal=portal@entry=0x5601217bc100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x56012182fd00, altdest=altdest@entry=0x56012182fd00, qc=0x7ffd5dcc9ed0) at ../src/backend/tcop/pquery.c:768 [07:15:10.641] _save_exception_stack = 0x7ffd5dcc9f80 [07:15:10.641] _save_context_stack = 0x0 [07:15:10.641] _local_sigjmp_buf = {{__jmpbuf = {0, 8896529574287097115, 94562856714496, 94562856176440, 94562856714496, 94562856176368, 2922319524355357979, 8896489696138214683}, __mask_was_saved = 0, __saved_mask = {__val = {94562832457282, 94562856172016, 112, 4, 94562832461699, 1573690975, 4, 94562856176368, 112, 179, 94562856714496, 94562856176440, 94562856176416, 94562856176368, 94562832548902, 1}}}} [07:15:10.641] _do_rethrow = [07:15:10.641] result = [07:15:10.641] nprocessed = [07:15:10.641] saveTopTransactionResourceOwner = 0x560121778db8 [07:15:10.641] saveTopTransactionContext = 0x5601217ce530 [07:15:10.641] saveActivePortal = 0x0 [07:15:10.641] saveResourceOwner = 0x560121778db8 [07:15:10.641] savePortalContext = 0x0 [07:15:10.641] saveMemoryContext = 0x5601217ce530 [07:15:10.641] __func__ = "PortalRun" [07:15:10.641] #43 0x000056011fdc0342 in exec_simple_query (query_string=query_string@entry=0x560121737af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');") at ../src/backend/tcop/postgres.c:1283 [07:15:10.641] cmdtaglen = 6 [07:15:10.641] snapshot_set = [07:15:10.641] per_parsetree_context = 0x0 [07:15:10.641] plantree_list = 0x56012182fcb0 [07:15:10.641] parsetree = 0x560121738af0 [07:15:10.641] commandTag = [07:15:10.641] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:15:10.641] querytree_list = [07:15:10.641] portal = 0x5601217bc100 [07:15:10.641] receiver = 0x56012182fd00 [07:15:10.641] format = 0 [07:15:10.641] cmdtagname = [07:15:10.641] parsetree_item__state = [07:15:10.641] dest = DestRemote [07:15:10.641] oldcontext = 0x5601217ce530 [07:15:10.641] parsetree_list = 0x560121738b20 [07:15:10.641] parsetree_item = 0x560121738b38 [07:15:10.641] save_log_statement_stats = false [07:15:10.641] was_logged = false [07:15:10.641] use_implicit_block = false [07:15:10.641] msec_str = "\004\000\000\000\000\000\000\000\021\314\a \001V\000\000`\237\314]\375\177\000\000x\000\000\000\000\000\000" [07:15:10.641] __func__ = "exec_simple_query" [07:15:10.641] #44 0x000056011fdc30c6 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4822 [07:15:10.641] query_string = 0x560121737af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');" [07:15:10.641] firstchar = [07:15:10.641] input_message = {data = 0x560121737af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');", len = 120, maxlen = 1024, cursor = 120} [07:15:10.641] local_sigjmp_buf = {{__jmpbuf = {94562845136184, 8896526884303781147, 140726177145052, 4, 14, 140726177145284, 2922319524426661147, 8896489698353200411}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94562855902736, 15616, 94562845130272, 94562856435056, 14, 94562832461247, 0, 9, 2, 94562845136192, 94562855902736, 94562845130272, 4, 14, 140726177145284}}}} [07:15:10.641] send_ready_for_query = false [07:15:10.641] idle_in_transaction_timeout_enabled = false [07:15:10.641] idle_session_timeout_enabled = false [07:15:10.641] __func__ = "PostgresMain" [07:15:10.641] #45 0x000056011fdb8ebb in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:15:10.641] bsdata = [07:15:10.641] #46 0x000056011fc6a9ef in postmaster_child_launch (child_type=B_BACKEND, child_slot=14, startup_data=startup_data@entry=0x7ffd5dcca0dc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd5dcca130) at ../src/backend/postmaster/launch_backend.c:274 [07:15:10.641] pid = [07:15:10.641] #47 0x000056011fc6f9ea in BackendStartup (client_sock=client_sock@entry=0x7ffd5dcca130) at ../src/backend/postmaster/postmaster.c:3390 [07:15:10.641] bn = 0x5601217602d8 [07:15:10.641] pid = [07:15:10.641] startup_data = {canAcceptConnections = CAC_OK} [07:15:10.641] cac = [07:15:10.641] __func__ = "BackendStartup" [07:15:10.641] #48 0x000056011fc718c3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [07:15:10.641] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\322#\340\036\001V\000\000\200\a\334\036\001V\000\000\200\242\314]\375\177\000\000x\242\314]\375\177\000\000\225[\362\001\000\000\000\000\240\264\362\305\023\177\000\000+", '\000' , "\375\177\000\000\000\004\000\000\000\000\000\000h\246?\306\023\177\000\0000\266\362\305\023\177\000\000\340\242?\306\023\177\000\000\316)fR\000\000\000", __ss_align = 1573692096}, salen = 2}} [07:15:10.641] i = 0 [07:15:10.641] now = [07:15:10.641] last_lockfile_recheck_time = 1733641860 [07:15:10.641] last_touch_time = 1733641860 [07:15:10.641] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = -968908064, user_data = 0x0}, {pos = 1573692160, events = 32765, fd = -969078200, user_data = 0xf}, {pos = -973949392, events = 32531, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -968908064, user_data = 0x7ffd5dcca278}, {pos = 1573692032, events = 32765, fd = -968907160, user_data = 0x0}, {pos = 561216432, events = 22017, fd = -995394934, user_data = 0x560121737bb0}, {pos = 1, events = 22017, fd = 32768, user_data = 0xffffffff}, {pos = -995958752, events = 32531, fd = -973828192, user_data = 0x560121763198}, {pos = 561393784, events = 22017, fd = 561402977, user_data = 0x7f13c63d6ebe}, {pos = 1, events = 0, fd = -968908064, user_data = 0x1ab}, {pos = 543145304, events = 22017, fd = 0, user_data = 0xec}, {pos = 561216432, events = 22017, fd = -969052482, user_data = 0x1}, {pos = 0, events = 0, fd = -995958752, user_data = 0x7f13c4af2e40 }, {pos = 16, events = 0, fd = 1573693168, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f13c63d91ba}, {pos = 0, events = 0, fd = -995431004, user_data = 0x0}, {pos = 550115584, events = 22017, fd = 2, user_data = 0x0}, {pos = 560963248, events = 22017, fd = 534060581, user_data = 0x56012176acc0}, {pos = 534064570, events = 22017, fd = 561425691, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -995924792, user_data = 0x7f13c4a9c880 }, {pos = -996315720, events = 32531, fd = 1573693360, user_data = 0x100007f00000002}, {pos = -995397881, events = 32531, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -994108320, events = 32531, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 1631155570, fd = 168447831, user_data = 0x36333337310a6174}, {pos = 909652276, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 22016, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 561396832, events = 22017, fd = -995394934, user_data = 0xa}, {pos = 537501250, events = 22017, fd = 561409168, user_data = 0x7f13c4ab576b}, {pos = -994125344, events = 32531, fd = -995487378, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x1acc6607fde61a00}, {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 = 0x560121762e70}, {pos = 1, events = 0, fd = 561393464, user_data = 0x3}, {pos = 0, events = 0, fd = 21016, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 561216432, user_data = 0x7f13c4af3053 }, {pos = 561393464, events = 22017, fd = 1024, user_data = 0x7ffd5dcca7b8}, {pos = 537584566, events = 22017, fd = 550180080, user_data = 0x56012009ce73 }, {pos = 561393264, events = 22017, fd = 561215984, user_data = 0x560121762e70}, {pos = -995403925, events = 32531, fd = 0, user_data = 0x5601200aeadd }, {pos = 561393264, events = 1, fd = 537586726, user_data = 0x5601217379f0}, {pos = -35251712, events = 449603079, fd = 0, user_data = 0x7f13c4aa2ab1}, {pos = -995486480, events = 32531, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 560963248, user_data = 0x1acc6607fde61a00}, {pos = 0, events = 0, fd = -35251712, user_data = 0xc}, {pos = -35251712, events = 449603079, fd = 0, user_data = 0x7f13c4a5b239 }, {pos = 237, events = 0, fd = 533112556, user_data = 0x400000}, {pos = 0, events = 0, fd = 560963248, user_data = 0x56012009cd07 }, {pos = 561049888, events = 22017, fd = 561215984, user_data = 0x56012170f120}, {pos = 1, events = 0, fd = 0, user_data = 0x56012005b704 }, {pos = 12, events = 0, fd = 561392840, user_data = 0x560121762ca8}, {pos = 550116992, events = 22017, fd = 296, user_data = 0x56011fc6cf06 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 533129027, events = 22017, fd = 546545136, user_data = 0x5601217383c8}} [07:15:10.641] nevents = 1 [07:15:10.641] __func__ = "ServerLoop" [07:15:10.641] #49 0x000056011fc73157 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5601216f5d70) at ../src/backend/postmaster/postmaster.c:1374 [07:15:10.641] opt = [07:15:10.641] status = [07:15:10.641] userDoption = [07:15:10.641] listen_addr_saved = false [07:15:10.641] output_config_variable = [07:15:10.641] __func__ = "PostmasterMain" [07:15:10.641] #50 0x000056011faa0104 in main (argc=8, argv=0x5601216f5d70) at ../src/backend/main/main.c:222 [07:15:10.641] do_check_root = [07:15:10.641] dispatch_option = [07:15:10.682] -e [07:15:10.682] [07:15:10.682] [07:15:10.771] dumping /tmp/cores/postgres-6-22769.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:15:11.035] [New LWP 22769] [07:15:11.035] [07:15:11.035] This GDB supports auto-downloading debuginfo from the following URLs: [07:15:11.035] [07:15:11.035] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [07:15:11.035] Debuginfod has been disabled. [07:15:11.035] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [07:15:11.296] [Thread debugging using libthread_db enabled] [07:15:11.296] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:15:11.296] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN '. [07:15:11.296] Program terminated with signal SIGABRT, Aborted. [07:15:11.296] #0 0x00007f898baa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:12.293] [07:15:12.293] Thread 1 (Thread 0x7f898b9d2f00 (LWP 22769)): [07:15:12.293] #0 0x00007f898baa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:12.293] No symbol table info available. [07:15:12.293] #1 0x00007f898ba5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:12.293] No symbol table info available. [07:15:12.293] #2 0x00007f898ba45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:12.293] No symbol table info available. [07:15:12.293] #3 0x00007f898bc1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [07:15:12.293] No locals. [07:15:12.293] #4 0x00007f898bc2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [07:15:12.293] No locals. [07:15:12.293] #5 0x00007f898bc0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55dd0f700100, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [07:15:12.293] bp = 140725631878496 [07:15:12.293] pc = [07:15:12.293] Opts = {FromUnrecoverableHandler = true, pc = 94407921217020, bp = 94407964920664} [07:15:12.293] #6 0x000055dd0e9badfc in examine_self_contradictory_rels (root=root@entry=0x55dd1132e0f8, rel=rel@entry=0x55dd11416698, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [07:15:12.293] lc__state = [07:15:12.293] rlist = [07:15:12.293] i = 2 [07:15:12.293] br = [07:15:12.293] expression = [07:15:12.293] or_rinfo = 0x55dd113698a8 [07:15:12.293] ccxt = [07:15:12.293] delidx = 0x55dd11369741 [07:15:12.293] arglst = [07:15:12.293] lc = [07:15:12.293] arg = [07:15:12.293] n = [07:15:12.293] restrictinfo = [07:15:12.293] ccwapper = {clausecxt = 0x55dd113690d8} [07:15:12.293] sec = {sopcinfo = {n_members = 38, opcies = 0x55dd11368ba8}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x55dd113b4398, atop_set = 0x55dd11368fb8}, ccfree = 0x55dd11369710, vifree = 0x55dd11369248} [07:15:12.293] __func__ = "examine_self_contradictory_rels" [07:15:12.293] #7 0x000055dd0e9bb00b in examine_self_contradictory_rels_phase1 (root=root@entry=0x55dd1132e0f8) at ../src/backend/optimizer/plan/contradictory.c:2608 [07:15:12.293] rel = 0x55dd11416698 [07:15:12.293] rti = 1 [07:15:12.293] rinfo = [07:15:12.293] #8 0x000055dd0e98564d in query_planner (root=root@entry=0x55dd1132e0f8, qp_callback=qp_callback@entry=0x55dd0e98a96a , qp_extra=qp_extra@entry=0x7ffd3d4c8760) at ../src/backend/optimizer/plan/planmain.c:190 [07:15:12.293] parse = 0x55dd11112d18 [07:15:12.293] joinlist = 0x55dd113b4408 [07:15:12.293] final_rel = [07:15:12.293] __func__ = "query_planner" [07:15:12.293] #9 0x000055dd0e998a40 in grouping_planner (root=root@entry=0x55dd1132e0f8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [07:15:12.293] sort_input_targets = 0x5 [07:15:12.293] sort_input_target_parallel_safe = [07:15:12.293] grouping_target = [07:15:12.293] scanjoin_target = [07:15:12.293] activeWindows = 0x0 [07:15:12.293] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [07:15:12.293] sort_input_targets_contain_srfs = 0x1 [07:15:12.293] have_grouping = [07:15:12.293] wflists = 0x0 [07:15:12.293] gset_data = 0x0 [07:15:12.293] sort_input_target = [07:15:12.293] grouping_targets = 0x1 [07:15:12.293] grouping_target_parallel_safe = [07:15:12.293] scanjoin_targets = 0x0 [07:15:12.293] scanjoin_target_parallel_safe = [07:15:12.293] grouping_targets_contain_srfs = 0x1 [07:15:12.293] scanjoin_targets_contain_srfs = 0x55dd0eefd28d [07:15:12.293] scanjoin_target_same_exprs = [07:15:12.293] parse = 0x55dd11112d18 [07:15:12.293] offset_est = 0 [07:15:12.293] count_est = 0 [07:15:12.293] limit_tuples = -1 [07:15:12.293] have_postponed_srfs = false [07:15:12.293] final_target = [07:15:12.293] final_targets = 0x55dd11324958 [07:15:12.293] final_targets_contain_srfs = 0x55dd0e8f7098 [07:15:12.293] final_target_parallel_safe = [07:15:12.293] current_rel = [07:15:12.293] final_rel = [07:15:12.293] extra = {limit_needed = false, limit_tuples = 4.6643710160650201e-310, count_est = 94407965228648, offset_est = 94407965228648} [07:15:12.293] lc = [07:15:12.293] __func__ = "grouping_planner" [07:15:12.293] #10 0x000055dd0e99b9c4 in subquery_planner (glob=glob@entry=0x55dd11416588, parse=parse@entry=0x55dd11112d18, 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:1153 [07:15:12.293] root = 0x55dd1132e0f8 [07:15:12.293] newWithCheckOptions = [07:15:12.293] newHaving = 0x0 [07:15:12.293] hasOuterJoins = [07:15:12.293] hasResultRTEs = false [07:15:12.293] final_rel = [07:15:12.293] l = 0x0 [07:15:12.293] #11 0x000055dd0e99c655 in standard_planner (parse=0x55dd11112d18, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [07:15:12.293] result = [07:15:12.293] glob = 0x55dd11416588 [07:15:12.293] tuple_fraction = 0 [07:15:12.293] root = [07:15:12.293] final_rel = [07:15:12.293] best_path = [07:15:12.293] top_plan = [07:15:12.293] lp = [07:15:12.293] lr = [07:15:12.293] #12 0x000055dd0e99d6bf in planner (parse=parse@entry=0x55dd11112d18, query_string=query_string@entry=0x55dd11111a70 "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:294 [07:15:12.293] result = [07:15:12.293] #13 0x000055dd0ec0c86c in pg_plan_query (querytree=querytree@entry=0x55dd11112d18, query_string=query_string@entry=0x55dd11111a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [07:15:12.293] plan = [07:15:12.293] #14 0x000055dd0e7123d0 in standard_ExplainOneQuery (query=0x55dd11112d18, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55dd1113d068, queryString=0x55dd11111a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:496 [07:15:12.293] plan = [07:15:12.293] planstart = [07:15:12.293] planduration = {ticks = 94407920392636} [07:15:12.293] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94407926644611, shared_blks_dirtied = 1028426318, shared_blks_written = 3, local_blks_hit = 4294967296, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94407962471704, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94407926731405}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94407920390017}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94407962471704}} [07:15:12.293] bufusage = {shared_blks_hit = 0, shared_blks_read = 94407923413032, shared_blks_dirtied = 72971494375427, shared_blks_written = 72057594037927936, local_blks_hit = 140228539568656, local_blks_read = 94407962472880, local_blks_dirtied = 94407962471704, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94407926259935, shared_blk_read_time = {ticks = 140228539568656}, shared_blk_write_time = {ticks = 94407926259954}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94407926640194}, temp_blk_read_time = {ticks = 94407962643744}, temp_blk_write_time = {ticks = 64}} [07:15:12.293] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140725631879632, freespace = 10} [07:15:12.293] planner_ctx = 0x0 [07:15:12.293] saved_ctx = 0x0 [07:15:12.293] #15 0x000055dd0e7126b6 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55dd1113d068, pstate=pstate@entry=0x55dd1113cf58, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [07:15:12.293] No locals. [07:15:12.293] #16 0x000055dd0e7135b6 in ExplainQuery (pstate=pstate@entry=0x55dd1113cf58, stmt=stmt@entry=0x55dd11112b58, params=params@entry=0x0, dest=dest@entry=0x55dd1113cec8) at ../src/backend/commands/explain.c:350 [07:15:12.293] l__state = [07:15:12.293] l = 0x55dd11416550 [07:15:12.293] es = 0x55dd1113d068 [07:15:12.293] tstate = [07:15:12.293] jstate = [07:15:12.293] query = [07:15:12.293] rewritten = 0x55dd11416538 [07:15:12.293] lc = 0x0 [07:15:12.293] timing_set = false [07:15:12.293] summary_set = false [07:15:12.293] __func__ = "ExplainQuery" [07:15:12.293] #17 0x000055dd0ec17453 in standard_ProcessUtility (pstmt=0x55dd11112c08, queryString=0x55dd11111a70 "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=0x55dd1113cec8, qc=0x7ffd3d4c8c50) at ../src/backend/tcop/utility.c:866 [07:15:12.293] parsetree = 0x55dd11112b58 [07:15:12.293] isTopLevel = true [07:15:12.293] isAtomicContext = false [07:15:12.293] pstate = 0x55dd1113cf58 [07:15:12.293] readonly_flags = [07:15:12.293] __func__ = "standard_ProcessUtility" [07:15:12.293] #18 0x000055dd0ec17b7c in ProcessUtility (pstmt=pstmt@entry=0x55dd11112c08, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55dd1113cec8, qc=0x7ffd3d4c8c50) at ../src/backend/tcop/utility.c:523 [07:15:12.293] No locals. [07:15:12.293] #19 0x000055dd0ec133e8 in PortalRunUtility (portal=portal@entry=0x55dd111937e0, pstmt=0x55dd11112c08, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55dd1113cec8, qc=qc@entry=0x7ffd3d4c8c50) at ../src/backend/tcop/pquery.c:1158 [07:15:12.293] No locals. [07:15:12.293] #20 0x000055dd0ec13c5b in FillPortalStore (portal=portal@entry=0x55dd111937e0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [07:15:12.293] treceiver = 0x55dd1113cec8 [07:15:12.293] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:15:12.293] __func__ = "FillPortalStore" [07:15:12.293] #21 0x000055dd0ec1424f in PortalRun (portal=portal@entry=0x55dd111937e0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55dd11324d68, altdest=altdest@entry=0x55dd11324d68, qc=0x7ffd3d4c8e30) at ../src/backend/tcop/pquery.c:763 [07:15:12.293] _save_exception_stack = 0x7ffd3d4c8ee0 [07:15:12.293] _save_context_stack = 0x0 [07:15:12.293] _local_sigjmp_buf = {{__jmpbuf = {0, 8722467310060275061, 94407962998752, 94407962471376, 94407962998752, 94407962471304, 3264042325491942773, 8722436914001970549}, __mask_was_saved = 0, __saved_mask = {__val = {94407926640194, 94407962466672, 112, 4, 94407926644611, 1028427199, 4, 94407962471304, 112, 153, 94407962998752, 94407962471376, 94407962471352, 94407962471304, 94407926731814, 1}}}} [07:15:12.293] _do_rethrow = [07:15:12.293] result = [07:15:12.293] nprocessed = [07:15:12.293] saveTopTransactionResourceOwner = 0x55dd11150998 [07:15:12.293] saveTopTransactionContext = 0x55dd111a7c50 [07:15:12.293] saveActivePortal = 0x0 [07:15:12.293] saveResourceOwner = 0x55dd11150998 [07:15:12.293] savePortalContext = 0x0 [07:15:12.293] saveMemoryContext = 0x55dd111a7c50 [07:15:12.293] __func__ = "PortalRun" [07:15:12.293] #22 0x000055dd0ec0d342 in exec_simple_query (query_string=query_string@entry=0x55dd11111a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1283 [07:15:12.293] cmdtaglen = 7 [07:15:12.293] snapshot_set = [07:15:12.293] per_parsetree_context = 0x0 [07:15:12.293] plantree_list = 0x55dd11324d18 [07:15:12.293] parsetree = 0x55dd11112b88 [07:15:12.293] commandTag = [07:15:12.293] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:15:12.293] querytree_list = [07:15:12.293] portal = 0x55dd111937e0 [07:15:12.293] receiver = 0x55dd11324d68 [07:15:12.293] format = 0 [07:15:12.293] cmdtagname = [07:15:12.293] parsetree_item__state = [07:15:12.293] dest = DestRemote [07:15:12.293] oldcontext = 0x55dd111a7c50 [07:15:12.293] parsetree_list = 0x55dd11112bb8 [07:15:12.293] parsetree_item = 0x55dd11112bd0 [07:15:12.293] save_log_statement_stats = false [07:15:12.293] was_logged = true [07:15:12.293] use_implicit_block = false [07:15:12.293] msec_str = "\004\000\000\000\000\000\000\000\021\234\354\016\335U\000\000\300\216L=\375\177\000\000n\000\000\000\000\000\000" [07:15:12.293] __func__ = "exec_simple_query" [07:15:12.293] #23 0x000055dd0ec100c6 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4822 [07:15:12.293] query_string = 0x55dd11111a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [07:15:12.293] firstchar = [07:15:12.293] input_message = {data = 0x55dd11111a70 "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} [07:15:12.293] local_sigjmp_buf = {{__jmpbuf = {94407939319096, 8722435593072117109, 140725631881276, 4, 9, 140725631881508, 3264042325420639605, 8722436924669265269}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94407962197488, 14336, 94407939313184, 94407962720592, 9, 94407926644159, 0, 9, 2, 94407939319104, 94407962197488, 94407939313184, 4, 9, 140725631881508}}}} [07:15:12.293] send_ready_for_query = false [07:15:12.293] idle_in_transaction_timeout_enabled = false [07:15:12.293] idle_session_timeout_enabled = false [07:15:12.293] __func__ = "PostgresMain" [07:15:12.293] #24 0x000055dd0ec05ebb in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:15:12.293] bsdata = [07:15:12.293] #25 0x000055dd0eab79ef in postmaster_child_launch (child_type=B_BACKEND, child_slot=9, startup_data=startup_data@entry=0x7ffd3d4c903c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd3d4c9090) at ../src/backend/postmaster/launch_backend.c:274 [07:15:12.293] pid = [07:15:12.293] #26 0x000055dd0eabc9ea in BackendStartup (client_sock=client_sock@entry=0x7ffd3d4c9090) at ../src/backend/postmaster/postmaster.c:3390 [07:15:12.293] bn = 0x55dd11139438 [07:15:12.293] pid = [07:15:12.293] startup_data = {canAcceptConnections = CAC_OK} [07:15:12.293] cac = [07:15:12.293] __func__ = "BackendStartup" [07:15:12.293] #27 0x000055dd0eabe8c3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [07:15:12.293] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\243\213\211\177\000\000\240\257\375\214\211\177\000\0008\221L=\375\177\000\0004\221L=\375\177", '\000' , "\322\363\304\r\335U\000\000\200\327\300\r\335U\000\000\000\222L=\375\177\000\000\370\221L=\375\177\000\000\225[\362\001\000\000\000\000\240\344\362\214\211\177\000\000+", '\000' , "\335U\000\000\340\362\304\r\335U\000", __ss_align = 140228757603944}, salen = 2}} [07:15:12.293] i = 0 [07:15:12.293] now = [07:15:12.293] last_lockfile_recheck_time = 1733641863 [07:15:12.293] last_touch_time = 1733641863 [07:15:12.293] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x55dd0dc4f3d2}, {pos = -1924610456, events = 32649, fd = -1930238416, user_data = 0x7f898d48c2e0}, {pos = 2090263927, events = 0, fd = 1028428416, user_data = 0x7f898d462a48}, {pos = 15, events = 0, fd = -1930238416, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f898d48c2e0}, {pos = 1028428280, events = 32765, fd = 1028428288, user_data = 0x7f898d48c668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = 286340896, events = 21981, fd = 1, user_data = 0x7ffd3d4c9723}, {pos = -1, events = 0, fd = -1952260064, user_data = 0x7f898cfdafa0}, {pos = 286511176, events = 21981, fd = 286510888, user_data = 0x55dd1113c4f1}, {pos = -1924755778, events = 32649, fd = 1, user_data = 0x7f898d48c2e0}, {pos = 427, events = 0, fd = 256150872, user_data = 0x0}, {pos = 216, events = 0, fd = 286333576, user_data = 0x7f898d468ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f898ba2e020}, {pos = -1951453632, events = 32649, fd = 16, user_data = 0x7ffd3d4c9650}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1924746822, events = 32649, fd = 0, user_data = 0x7f898baaeda4 }, {pos = 0, events = 0, fd = 263121152, user_data = 0x2}, {pos = 0, events = 0, fd = 286080656, user_data = 0x55dd0eba39f3 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = 286333576, user_data = 0x7f898d468ebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f898ba364c8}, {pos = -1951699193, events = 32649, fd = 263177280, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -1950409632, events = 32649, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 4294967040, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x30305f742f617461}, {pos = 1735417650, events = 1735423327, fd = 1853190772, user_data = 0x2f65646172677075}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 286523312, user_data = 0x7f898bab58be}, {pos = -1950426656, events = 32649, fd = -1951788690, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x86e27117209c7300}, {pos = -1950423584, events = 32649, fd = -328, user_data = 0x0}, {pos = 286510568, events = 21981, 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 = 21631, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 286333576, user_data = 0x7f898baf3053 }, {pos = 286510568, events = 21981, fd = 1024, user_data = 0x7ffd3d4c9718}, {pos = 250590134, events = 21981, fd = 263185648, user_data = 0x55dd0eee9e73 }, {pos = 286510368, events = 21981, fd = 286333296, user_data = 0x55dd1113cd20}, {pos = -1951705237, events = 32649, fd = 0, user_data = 0x55dd0eefbadd }, {pos = 286510368, events = 1, fd = 250592294, user_data = 0x55dd11111970}, {pos = 547123968, events = 2262987031, fd = 0, user_data = 0x7f898baa2ab1}, {pos = -1951787792, events = 32649, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 286080656, user_data = 0x86e27117209c7300}, {pos = 0, events = 0, fd = 547123968, user_data = 0xc}, {pos = 547123968, events = 2262987031, fd = 0, user_data = 0x7f898ba5b239 }, {pos = 217, events = 0, fd = 246118124, user_data = 0x400000}, {pos = 0, events = 0, fd = 286080656, user_data = 0x55dd0eee9d07 }, {pos = 286167200, events = 21981, fd = 286333296, user_data = 0x55dd110e90a0}, {pos = 1, events = 0, fd = 0, user_data = 0x55dd0eea8704 }, {pos = 12, events = 0, fd = 286505816, user_data = 0x55dd1113bb38}, {pos = 263122560, events = 21981, fd = 296, user_data = 0x55dd0eab9f06 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 246134595, events = 21981, fd = 259550704, user_data = 0x55dd11112318}} [07:15:12.294] nevents = 1 [07:15:12.294] __func__ = "ServerLoop" [07:15:12.294] #28 0x000055dd0eac0157 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55dd110cfd00) at ../src/backend/postmaster/postmaster.c:1374 [07:15:12.294] opt = [07:15:12.294] status = [07:15:12.294] userDoption = [07:15:12.294] listen_addr_saved = false [07:15:12.294] output_config_variable = [07:15:12.294] __func__ = "PostmasterMain" [07:15:12.294] #29 0x000055dd0e8ed104 in main (argc=4, argv=0x55dd110cfd00) at ../src/backend/main/main.c:222 [07:15:12.294] do_check_root = [07:15:12.294] dispatch_option = [07:15:12.335] -e [07:15:12.335] [07:15:12.335] [07:15:12.418] dumping /tmp/cores/postgres-6-21866.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [07:15:12.679] [New LWP 21866] [07:15:12.679] [07:15:12.679] This GDB supports auto-downloading debuginfo from the following URLs: [07:15:12.679] [07:15:12.679] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [07:15:12.679] Debuginfod has been disabled. [07:15:12.679] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [07:15:12.935] [Thread debugging using libthread_db enabled] [07:15:12.935] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:15:12.935] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [07:15:12.935] Program terminated with signal SIGABRT, Aborted. [07:15:12.935] #0 0x00007f13c4aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:13.923] [07:15:13.923] Thread 1 (Thread 0x7f13c49d6f00 (LWP 21866)): [07:15:13.923] #0 0x00007f13c4aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:13.923] No symbol table info available. [07:15:13.923] #1 0x00007f13c4a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:13.923] No symbol table info available. [07:15:13.923] #2 0x00007f13c4a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:13.923] No symbol table info available. [07:15:13.923] #3 0x00007f13c4c1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [07:15:13.923] No locals. [07:15:13.923] #4 0x00007f13c4c2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [07:15:13.923] No locals. [07:15:13.923] #5 0x00007f13c4c0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5601208b3100, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [07:15:13.923] bp = 140726177142272 [07:15:13.923] pc = [07:15:13.923] Opts = {FromUnrecoverableHandler = true, pc = 94562827034108, bp = 94562859395672} [07:15:13.923] #6 0x000056011fb6ddfc in examine_self_contradictory_rels (root=root@entry=0x56012195dcc8, rel=rel@entry=0x5601219f2e78, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [07:15:13.923] lc__state = [07:15:13.923] rlist = [07:15:13.923] i = 2 [07:15:13.923] br = [07:15:13.923] expression = [07:15:13.923] or_rinfo = 0x560121a4b7a8 [07:15:13.923] ccxt = [07:15:13.923] delidx = 0x560121a4b641 [07:15:13.923] arglst = [07:15:13.923] lc = [07:15:13.923] arg = [07:15:13.923] n = [07:15:13.923] restrictinfo = [07:15:13.923] ccwapper = {clausecxt = 0x560121a4afd8} [07:15:13.923] sec = {sopcinfo = {n_members = 38, opcies = 0x560121a4aaa8}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x560121a4d5c8, atop_set = 0x560121a4aeb8}, ccfree = 0x560121a4b610, vifree = 0x560121a4b148} [07:15:13.923] __func__ = "examine_self_contradictory_rels" [07:15:13.923] #7 0x000056011fb6e00b in examine_self_contradictory_rels_phase1 (root=root@entry=0x56012195dcc8) at ../src/backend/optimizer/plan/contradictory.c:2608 [07:15:13.923] rel = 0x5601219f2e78 [07:15:13.923] rti = 1 [07:15:13.923] rinfo = [07:15:13.923] #8 0x000056011fb3864d in query_planner (root=root@entry=0x56012195dcc8, qp_callback=qp_callback@entry=0x56011fb3d96a , qp_extra=qp_extra@entry=0x7ffd5dcc9800) at ../src/backend/optimizer/plan/planmain.c:190 [07:15:13.923] parse = 0x560121738d98 [07:15:13.923] joinlist = 0x560121a4d638 [07:15:13.923] final_rel = [07:15:13.923] __func__ = "query_planner" [07:15:13.923] #9 0x000056011fb4ba40 in grouping_planner (root=root@entry=0x56012195dcc8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [07:15:13.923] sort_input_targets = 0x5 [07:15:13.923] sort_input_target_parallel_safe = [07:15:13.923] grouping_target = [07:15:13.923] scanjoin_target = [07:15:13.923] activeWindows = 0x0 [07:15:13.923] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [07:15:13.923] sort_input_targets_contain_srfs = 0x1 [07:15:13.923] have_grouping = [07:15:13.923] wflists = 0x0 [07:15:13.923] gset_data = 0x0 [07:15:13.923] sort_input_target = [07:15:13.923] grouping_targets = 0x1 [07:15:13.923] grouping_target_parallel_safe = [07:15:13.923] scanjoin_targets = 0x0 [07:15:13.923] scanjoin_target_parallel_safe = [07:15:13.923] grouping_targets_contain_srfs = 0x1 [07:15:13.923] scanjoin_targets_contain_srfs = 0x5601200b028d [07:15:13.923] scanjoin_target_same_exprs = [07:15:13.923] parse = 0x560121738d98 [07:15:13.923] offset_est = 0 [07:15:13.923] count_est = 0 [07:15:13.923] limit_tuples = -1 [07:15:13.923] have_postponed_srfs = false [07:15:13.923] final_target = [07:15:13.923] final_targets = 0x560121837cc8 [07:15:13.923] final_targets_contain_srfs = 0x56011faaa098 [07:15:13.923] final_target_parallel_safe = [07:15:13.923] current_rel = [07:15:13.923] final_rel = [07:15:13.923] extra = {limit_needed = false, limit_tuples = 4.672024380321435e-310, count_est = 94562859405464, offset_est = 94562859405464} [07:15:13.923] lc = [07:15:13.923] __func__ = "grouping_planner" [07:15:13.923] #10 0x000056011fb4e9c4 in subquery_planner (glob=glob@entry=0x5601219f2d68, parse=parse@entry=0x560121738d98, 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:1153 [07:15:13.923] root = 0x56012195dcc8 [07:15:13.923] newWithCheckOptions = [07:15:13.923] newHaving = 0x0 [07:15:13.923] hasOuterJoins = [07:15:13.923] hasResultRTEs = false [07:15:13.923] final_rel = [07:15:13.923] l = 0x0 [07:15:13.923] #11 0x000056011fb4f655 in standard_planner (parse=0x560121738d98, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [07:15:13.923] result = [07:15:13.923] glob = 0x5601219f2d68 [07:15:13.923] tuple_fraction = 0 [07:15:13.923] root = [07:15:13.923] final_rel = [07:15:13.923] best_path = [07:15:13.923] top_plan = [07:15:13.923] lp = [07:15:13.923] lr = [07:15:13.923] #12 0x000056011fb506bf in planner (parse=parse@entry=0x560121738d98, query_string=query_string@entry=0x560121737af0 "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:294 [07:15:13.923] result = [07:15:13.923] #13 0x000056011fdbf86c in pg_plan_query (querytree=querytree@entry=0x560121738d98, query_string=query_string@entry=0x560121737af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [07:15:13.923] plan = [07:15:13.923] #14 0x000056011f8c53d0 in standard_ExplainOneQuery (query=0x560121738d98, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5601217631b8, queryString=0x560121737af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:496 [07:15:13.923] plan = [07:15:13.923] planstart = [07:15:13.923] planduration = {ticks = 94562826209724} [07:15:13.923] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94562832461699, shared_blks_dirtied = 1573690094, shared_blks_written = 3, local_blks_hit = 4294967296, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94562856177048, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94562832548493}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94562826207105}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94562856177048}} [07:15:13.923] bufusage = {shared_blks_hit = 0, shared_blks_read = 94562829230120, shared_blks_dirtied = 72945724571648, shared_blks_written = 72057594037927936, local_blks_hit = 139722685977104, local_blks_read = 94562856178224, local_blks_dirtied = 94562856177048, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94562832077023, shared_blk_read_time = {ticks = 139722685977104}, shared_blk_write_time = {ticks = 94562832077042}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94562832457282}, temp_blk_read_time = {ticks = 94562856349296}, temp_blk_write_time = {ticks = 64}} [07:15:13.923] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140726177143408, freespace = 10} [07:15:13.923] planner_ctx = 0x0 [07:15:13.923] saved_ctx = 0x0 [07:15:13.923] #15 0x000056011f8c56b6 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5601217631b8, pstate=pstate@entry=0x5601217630a8, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [07:15:13.923] No locals. [07:15:13.923] #16 0x000056011f8c65b6 in ExplainQuery (pstate=pstate@entry=0x5601217630a8, stmt=stmt@entry=0x560121738bd8, params=params@entry=0x0, dest=dest@entry=0x560121763018) at ../src/backend/commands/explain.c:350 [07:15:13.923] l__state = [07:15:13.923] l = 0x5601219f2d30 [07:15:13.923] es = 0x5601217631b8 [07:15:13.923] tstate = [07:15:13.923] jstate = [07:15:13.923] query = [07:15:13.923] rewritten = 0x5601219f2d18 [07:15:13.923] lc = 0x0 [07:15:13.923] timing_set = false [07:15:13.923] summary_set = false [07:15:13.923] __func__ = "ExplainQuery" [07:15:13.923] #17 0x000056011fdca453 in standard_ProcessUtility (pstmt=0x560121738c88, queryString=0x560121737af0 "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=0x560121763018, qc=0x7ffd5dcc9cf0) at ../src/backend/tcop/utility.c:866 [07:15:13.923] parsetree = 0x560121738bd8 [07:15:13.923] isTopLevel = true [07:15:13.923] isAtomicContext = false [07:15:13.923] pstate = 0x5601217630a8 [07:15:13.923] readonly_flags = [07:15:13.923] __func__ = "standard_ProcessUtility" [07:15:13.923] #18 0x000056011fdcab7c in ProcessUtility (pstmt=pstmt@entry=0x560121738c88, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x560121763018, qc=0x7ffd5dcc9cf0) at ../src/backend/tcop/utility.c:523 [07:15:13.923] No locals. [07:15:13.923] #19 0x000056011fdc63e8 in PortalRunUtility (portal=portal@entry=0x5601217bc100, pstmt=0x560121738c88, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x560121763018, qc=qc@entry=0x7ffd5dcc9cf0) at ../src/backend/tcop/pquery.c:1158 [07:15:13.923] No locals. [07:15:13.923] #20 0x000056011fdc6c5b in FillPortalStore (portal=portal@entry=0x5601217bc100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [07:15:13.923] treceiver = 0x560121763018 [07:15:13.923] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:15:13.923] __func__ = "FillPortalStore" [07:15:13.923] #21 0x000056011fdc724f in PortalRun (portal=portal@entry=0x5601217bc100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5601218380d8, altdest=altdest@entry=0x5601218380d8, qc=0x7ffd5dcc9ed0) at ../src/backend/tcop/pquery.c:763 [07:15:13.923] _save_exception_stack = 0x7ffd5dcc9f80 [07:15:13.923] _save_context_stack = 0x0 [07:15:13.923] _local_sigjmp_buf = {{__jmpbuf = {0, 8896529569345158427, 94562856714496, 94562856176720, 94562856714496, 94562856176648, 2922319524355357979, 8896489696138214683}, __mask_was_saved = 0, __saved_mask = {__val = {94562832457282, 94562856172016, 112, 4, 94562832461699, 1573690975, 4, 94562856176648, 112, 153, 94562856714496, 94562856176720, 94562856176696, 94562856176648, 94562832548902, 1}}}} [07:15:13.923] _do_rethrow = [07:15:13.923] result = [07:15:13.923] nprocessed = [07:15:13.923] saveTopTransactionResourceOwner = 0x560121778db8 [07:15:13.923] saveTopTransactionContext = 0x5601217ce530 [07:15:13.923] saveActivePortal = 0x0 [07:15:13.923] saveResourceOwner = 0x560121778db8 [07:15:13.923] savePortalContext = 0x0 [07:15:13.923] saveMemoryContext = 0x5601217ce530 [07:15:13.923] __func__ = "PortalRun" [07:15:13.923] #22 0x000056011fdc0342 in exec_simple_query (query_string=query_string@entry=0x560121737af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1283 [07:15:13.923] cmdtaglen = 7 [07:15:13.923] snapshot_set = [07:15:13.923] per_parsetree_context = 0x0 [07:15:13.923] plantree_list = 0x560121838088 [07:15:13.923] parsetree = 0x560121738c08 [07:15:13.923] commandTag = [07:15:13.923] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:15:13.923] querytree_list = [07:15:13.923] portal = 0x5601217bc100 [07:15:13.923] receiver = 0x5601218380d8 [07:15:13.923] format = 0 [07:15:13.923] cmdtagname = [07:15:13.923] parsetree_item__state = [07:15:13.923] dest = DestRemote [07:15:13.923] oldcontext = 0x5601217ce530 [07:15:13.923] parsetree_list = 0x560121738c38 [07:15:13.923] parsetree_item = 0x560121738c50 [07:15:13.923] save_log_statement_stats = false [07:15:13.923] was_logged = false [07:15:13.923] use_implicit_block = false [07:15:13.923] msec_str = "\004\000\000\000\000\000\000\000\021\314\a \001V\000\000`\237\314]\375\177\000\000n\000\000\000\000\000\000" [07:15:13.923] __func__ = "exec_simple_query" [07:15:13.923] #23 0x000056011fdc30c6 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4822 [07:15:13.923] query_string = 0x560121737af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [07:15:13.923] firstchar = [07:15:13.923] input_message = {data = 0x560121737af0 "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} [07:15:13.923] local_sigjmp_buf = {{__jmpbuf = {94562845136184, 8896526884303781147, 140726177145052, 4, 3, 140726177145284, 2922319524426661147, 8896489698353200411}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94562855902736, 15616, 94562845130272, 94562856435056, 3, 94562832461247, 0, 9, 2, 94562845136192, 94562855902736, 94562845130272, 4, 3, 140726177145284}}}} [07:15:13.923] send_ready_for_query = false [07:15:13.923] idle_in_transaction_timeout_enabled = false [07:15:13.923] idle_session_timeout_enabled = false [07:15:13.923] __func__ = "PostgresMain" [07:15:13.923] #24 0x000056011fdb8ebb in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:15:13.923] bsdata = [07:15:13.923] #25 0x000056011fc6a9ef in postmaster_child_launch (child_type=B_BACKEND, child_slot=3, startup_data=startup_data@entry=0x7ffd5dcca0dc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd5dcca130) at ../src/backend/postmaster/launch_backend.c:274 [07:15:13.923] pid = [07:15:13.923] #26 0x000056011fc6f9ea in BackendStartup (client_sock=client_sock@entry=0x7ffd5dcca130) at ../src/backend/postmaster/postmaster.c:3390 [07:15:13.923] bn = 0x5601217600c8 [07:15:13.923] pid = [07:15:13.923] startup_data = {canAcceptConnections = CAC_OK} [07:15:13.923] cac = [07:15:13.923] __func__ = "BackendStartup" [07:15:13.923] #27 0x000056011fc718c3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [07:15:13.923] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\322#\340\036\001V\000\000\200\a\334\036\001V\000\000\200\242\314]\375\177\000\000x\242\314]\375\177\000\000\225[\362\001\000\000\000\000\240\264\362\305\023\177\000\000+", '\000' , "\375\177\000\000\000\004\000\000\000\000\000\000h\246?\306\023\177\000\0000\266\362\305\023\177\000\000\340\242?\306\023\177\000\000\316)fR\000\000\000", __ss_align = 1573692096}, salen = 2}} [07:15:13.923] i = 0 [07:15:13.923] now = [07:15:13.923] last_lockfile_recheck_time = 1733641860 [07:15:13.923] last_touch_time = 1733641860 [07:15:13.923] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -973949392, events = 32531, fd = -968908064, user_data = 0x7c96e577}, {pos = 1573692160, events = 32765, fd = -969078200, user_data = 0xf}, {pos = -973949392, events = 32531, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -968908064, user_data = 0x7ffd5dcca278}, {pos = 1573692032, events = 32765, fd = -968907160, user_data = 0x0}, {pos = 561216432, events = 22017, fd = -995394934, user_data = 0x560121737bb0}, {pos = 1, events = 22017, fd = 32768, user_data = 0xffffffff}, {pos = -995958752, events = 32531, fd = -973828192, user_data = 0x560121763198}, {pos = 561393784, events = 22017, fd = 561402977, user_data = 0x7f13c63d6ebe}, {pos = 1, events = 0, fd = -968908064, user_data = 0x1ab}, {pos = 543145304, events = 22017, fd = 0, user_data = 0xec}, {pos = 561216432, events = 22017, fd = -969052482, user_data = 0x1}, {pos = 0, events = 0, fd = -995958752, user_data = 0x7f13c4af2e40 }, {pos = 16, events = 0, fd = 1573693168, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f13c63d91ba}, {pos = 0, events = 0, fd = -995431004, user_data = 0x0}, {pos = 550115584, events = 22017, fd = 2, user_data = 0x0}, {pos = 560963248, events = 22017, fd = 534060581, user_data = 0x56012176acc0}, {pos = 534064570, events = 22017, fd = 561425691, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -995924792, user_data = 0x7f13c4a9c880 }, {pos = -996315720, events = 32531, fd = 1573693360, user_data = 0x100007f00000002}, {pos = -995397881, events = 32531, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -994108320, events = 32531, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 1631155570, fd = 168447831, user_data = 0x36333337310a6174}, {pos = 909652276, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 22016, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 561396832, events = 22017, fd = -995394934, user_data = 0xa}, {pos = 537501250, events = 22017, fd = 561409168, user_data = 0x7f13c4ab576b}, {pos = -994125344, events = 32531, fd = -995487378, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x1acc6607fde61a00}, {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 = 0x560121762e70}, {pos = 1, events = 0, fd = 561393464, user_data = 0x3}, {pos = 0, events = 0, fd = 21016, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 561216432, user_data = 0x7f13c4af3053 }, {pos = 561393464, events = 22017, fd = 1024, user_data = 0x7ffd5dcca7b8}, {pos = 537584566, events = 22017, fd = 550180080, user_data = 0x56012009ce73 }, {pos = 561393264, events = 22017, fd = 561215984, user_data = 0x560121762e70}, {pos = -995403925, events = 32531, fd = 0, user_data = 0x5601200aeadd }, {pos = 561393264, events = 1, fd = 537586726, user_data = 0x5601217379f0}, {pos = -35251712, events = 449603079, fd = 0, user_data = 0x7f13c4aa2ab1}, {pos = -995486480, events = 32531, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 560963248, user_data = 0x1acc6607fde61a00}, {pos = 0, events = 0, fd = -35251712, user_data = 0xc}, {pos = -35251712, events = 449603079, fd = 0, user_data = 0x7f13c4a5b239 }, {pos = 237, events = 0, fd = 533112556, user_data = 0x400000}, {pos = 0, events = 0, fd = 560963248, user_data = 0x56012009cd07 }, {pos = 561049888, events = 22017, fd = 561215984, user_data = 0x56012170f120}, {pos = 1, events = 0, fd = 0, user_data = 0x56012005b704 }, {pos = 12, events = 0, fd = 561392840, user_data = 0x560121762ca8}, {pos = 550116992, events = 22017, fd = 296, user_data = 0x56011fc6cf06 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 533129027, events = 22017, fd = 546545136, user_data = 0x5601217383c8}} [07:15:13.923] nevents = 1 [07:15:13.923] __func__ = "ServerLoop" [07:15:13.923] #28 0x000056011fc73157 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5601216f5d70) at ../src/backend/postmaster/postmaster.c:1374 [07:15:13.923] opt = [07:15:13.923] status = [07:15:13.923] userDoption = [07:15:13.923] listen_addr_saved = false [07:15:13.923] output_config_variable = [07:15:13.923] __func__ = "PostmasterMain" [07:15:13.923] #29 0x000056011faa0104 in main (argc=8, argv=0x5601216f5d70) at ../src/backend/main/main.c:222 [07:15:13.923] do_check_root = [07:15:13.923] dispatch_option = [07:15:13.961] -e [07:15:13.961] [07:15:13.961] [07:15:14.028] dumping /tmp/cores/postgres-6-39758.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [07:15:14.293] [New LWP 39758] [07:15:14.293] [07:15:14.293] This GDB supports auto-downloading debuginfo from the following URLs: [07:15:14.293] [07:15:14.293] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [07:15:14.293] Debuginfod has been disabled. [07:15:14.293] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [07:15:14.403] [Thread debugging using libthread_db enabled] [07:15:14.403] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:15:14.403] Core was generated by `postgres: test: postgres db1 [local] SELECT '. [07:15:14.403] Program terminated with signal SIGABRT, Aborted. [07:15:14.403] #0 0x00007f32974a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:14.461] [07:15:14.461] Thread 1 (Thread 0x7f3297c34f00 (LWP 39758)): [07:15:14.461] #0 0x00007f32974a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:14.461] No symbol table info available. [07:15:14.461] #1 0x00007f329745afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:14.461] No symbol table info available. [07:15:14.461] #2 0x00007f3297445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:14.461] No symbol table info available. [07:15:14.461] #3 0x00007f329761e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [07:15:14.461] No locals. [07:15:14.461] #4 0x00007f329762aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [07:15:14.461] No locals. [07:15:14.461] #5 0x00007f329760dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x559fdbd1b100, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [07:15:14.461] bp = 140732095880208 [07:15:14.461] pc = [07:15:14.461] Opts = {FromUnrecoverableHandler = true, pc = 94145062198780, bp = 139855068331176} [07:15:14.461] #6 0x0000559fdafd5dfc in examine_self_contradictory_rels (root=root@entry=0x559fdd0aaf28, rel=rel@entry=0x559fdd0b4c18, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [07:15:14.461] lc__state = [07:15:14.461] rlist = [07:15:14.461] i = 7 [07:15:14.461] br = [07:15:14.461] expression = [07:15:14.461] or_rinfo = 0x7f328bab0d38 [07:15:14.461] ccxt = [07:15:14.461] delidx = 0x7f328bab3e91 [07:15:14.461] arglst = [07:15:14.461] lc = [07:15:14.461] arg = [07:15:14.461] n = [07:15:14.461] restrictinfo = [07:15:14.461] ccwapper = {clausecxt = 0x7f328bab1b28} [07:15:14.461] sec = {sopcinfo = {n_members = 38, opcies = 0x7f328bab12c8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7f328bab16d8, atop_set = 0x7f328baaf398}, ccfree = 0x7f328bab3e60, vifree = 0x7f328bab2d78} [07:15:14.461] __func__ = "examine_self_contradictory_rels" [07:15:14.461] #7 0x0000559fdafd600b in examine_self_contradictory_rels_phase1 (root=root@entry=0x559fdd0aaf28) at ../src/backend/optimizer/plan/contradictory.c:2608 [07:15:14.461] rel = 0x559fdd0b4c18 [07:15:14.461] rti = 1 [07:15:14.461] rinfo = [07:15:14.461] #8 0x0000559fdafa064d in query_planner (root=root@entry=0x559fdd0aaf28, qp_callback=qp_callback@entry=0x559fdafa596a , qp_extra=qp_extra@entry=0x7ffebe955e10) at ../src/backend/optimizer/plan/planmain.c:190 [07:15:14.461] parse = 0x559fdd0a1720 [07:15:14.461] joinlist = 0x7f328baaf528 [07:15:14.461] final_rel = [07:15:14.461] __func__ = "query_planner" [07:15:14.461] #9 0x0000559fdafb3a40 in grouping_planner (root=root@entry=0x559fdd0aaf28, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [07:15:14.461] sort_input_targets = 0x559fdd0aaf28 [07:15:14.461] sort_input_target_parallel_safe = [07:15:14.461] grouping_target = [07:15:14.461] scanjoin_target = [07:15:14.461] activeWindows = 0x0 [07:15:14.461] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [07:15:14.461] sort_input_targets_contain_srfs = 0x559fdd0a8720 [07:15:14.461] have_grouping = [07:15:14.461] wflists = 0x0 [07:15:14.461] gset_data = 0x0 [07:15:14.461] sort_input_target = [07:15:14.461] grouping_targets = 0x559fdd0a8768 [07:15:14.461] grouping_target_parallel_safe = [07:15:14.461] scanjoin_targets = 0x559fdd0a8750 [07:15:14.461] scanjoin_target_parallel_safe = [07:15:14.461] grouping_targets_contain_srfs = 0x559fdd0aaf28 [07:15:14.461] scanjoin_targets_contain_srfs = 0x0 [07:15:14.461] scanjoin_target_same_exprs = [07:15:14.461] parse = 0x559fdd0a1720 [07:15:14.461] offset_est = 0 [07:15:14.461] count_est = 0 [07:15:14.461] limit_tuples = -1 [07:15:14.461] have_postponed_srfs = false [07:15:14.461] final_target = [07:15:14.461] final_targets = 0x559fdd0aaf28 [07:15:14.461] final_targets_contain_srfs = 0x7 [07:15:14.461] final_target_parallel_safe = [07:15:14.461] current_rel = [07:15:14.461] final_rel = [07:15:14.461] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94145096587040} [07:15:14.461] lc = [07:15:14.461] __func__ = "grouping_planner" [07:15:14.461] #10 0x0000559fdafb69c4 in subquery_planner (glob=, parse=0x559fdd0a1720, parent_root=parent_root@entry=0x559fdd09e8e0, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1153 [07:15:14.461] root = 0x559fdd0aaf28 [07:15:14.461] newWithCheckOptions = [07:15:14.461] newHaving = 0x0 [07:15:14.461] hasOuterJoins = [07:15:14.461] hasResultRTEs = true [07:15:14.461] final_rel = [07:15:14.461] l = 0x0 [07:15:14.461] #11 0x0000559fdafc835e in SS_process_ctes (root=root@entry=0x559fdd09e8e0) at ../src/backend/optimizer/plan/subselect.c:966 [07:15:14.461] subquery = [07:15:14.461] cte = 0x559fdd064490 [07:15:14.461] cmdType = [07:15:14.461] subroot = [07:15:14.461] final_rel = [07:15:14.461] best_path = [07:15:14.461] plan = [07:15:14.461] splan = [07:15:14.461] paramid = [07:15:14.461] lc__state = [07:15:14.461] lc = [07:15:14.461] __func__ = "SS_process_ctes" [07:15:14.461] #12 0x0000559fdafb5468 in subquery_planner (glob=glob@entry=0x559fdd0796e8, parse=parse@entry=0x559fdd0797f8, 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:706 [07:15:14.461] root = 0x559fdd09e8e0 [07:15:14.461] newWithCheckOptions = [07:15:14.461] newHaving = [07:15:14.461] hasOuterJoins = [07:15:14.461] hasResultRTEs = [07:15:14.461] final_rel = [07:15:14.461] l = [07:15:14.461] #13 0x0000559fdafb7655 in standard_planner (parse=0x559fdd0797f8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [07:15:14.461] result = [07:15:14.461] glob = 0x559fdd0796e8 [07:15:14.461] tuple_fraction = 0 [07:15:14.461] root = [07:15:14.461] final_rel = [07:15:14.461] best_path = [07:15:14.461] top_plan = [07:15:14.461] lp = [07:15:14.461] lr = [07:15:14.461] #14 0x0000559fdafb86bf in planner (parse=parse@entry=0x559fdd0797f8, query_string=query_string@entry=0x559fdcf895a0 "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:294 [07:15:14.461] result = [07:15:14.461] #15 0x0000559fdb22786c in pg_plan_query (querytree=querytree@entry=0x559fdd0797f8, query_string=query_string@entry=0x559fdcf895a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [07:15:14.461] plan = [07:15:14.461] #16 0x0000559fdb227c4d in pg_plan_queries (querytrees=0x559fdd09e890, query_string=query_string@entry=0x559fdcf895a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:1005 [07:15:14.461] query = 0x559fdd0797f8 [07:15:14.461] stmt = [07:15:14.461] query_list__state = [07:15:14.461] stmt_list = 0x0 [07:15:14.461] query_list = [07:15:14.461] #17 0x0000559fdb2281fa in exec_simple_query (query_string=query_string@entry=0x559fdcf895a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "...) at ../src/backend/tcop/postgres.c:1202 [07:15:14.461] cmdtaglen = 6 [07:15:14.461] snapshot_set = true [07:15:14.461] per_parsetree_context = 0x0 [07:15:14.461] plantree_list = [07:15:14.461] parsetree = 0x559fdd079668 [07:15:14.461] commandTag = CMDTAG_SELECT [07:15:14.461] qc = {commandTag = 1935, nprocessed = 94145095439776} [07:15:14.461] querytree_list = [07:15:14.461] portal = [07:15:14.461] receiver = [07:15:14.461] format = 0 [07:15:14.461] cmdtagname = [07:15:14.461] parsetree_item__state = [07:15:14.461] dest = DestRemote [07:15:14.461] oldcontext = 0x559fdd018f40 [07:15:14.461] parsetree_list = 0x559fdd079698 [07:15:14.461] parsetree_item = 0x559fdd0796b0 [07:15:14.461] save_log_statement_stats = false [07:15:14.461] was_logged = true [07:15:14.461] use_implicit_block = false [07:15:14.461] msec_str = "\004\000\000\000\000\000\000\000\021LN۟U\000\000\340a\225\276\376\177\000\000\217\a\000\000\000\000\000" [07:15:14.461] __func__ = "exec_simple_query" [07:15:14.461] #18 0x0000559fdb22b0c6 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4822 [07:15:14.461] query_string = 0x559fdcf895a0 "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 "... [07:15:14.461] firstchar = [07:15:14.461] input_message = {data = 0x559fdcf895a0 "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} [07:15:14.461] local_sigjmp_buf = {{__jmpbuf = {94145080300856, -5128756067865559339, 140732095882076, 4, 3, 140732095882308, -1436583897520505131, -5128771073044742443}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94145095167440, 14336, 94145080294944, 94145095674960, 3, 94145067625919, 0, 9, 2, 94145080300864, 94145095167440, 94145080294944, 4, 3, 140732095882308}}}} [07:15:14.461] send_ready_for_query = false [07:15:14.461] idle_in_transaction_timeout_enabled = false [07:15:14.461] idle_session_timeout_enabled = false [07:15:14.461] __func__ = "PostgresMain" [07:15:14.461] #19 0x0000559fdb220ebb in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:15:14.461] bsdata = [07:15:14.461] #20 0x0000559fdb0d29ef in postmaster_child_launch (child_type=B_BACKEND, child_slot=3, startup_data=startup_data@entry=0x7ffebe95635c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffebe9563b0) at ../src/backend/postmaster/launch_backend.c:274 [07:15:14.461] pid = [07:15:14.461] #21 0x0000559fdb0d79ea in BackendStartup (client_sock=client_sock@entry=0x7ffebe9563b0) at ../src/backend/postmaster/postmaster.c:3390 [07:15:14.461] bn = 0x559fdcfb0628 [07:15:14.461] pid = [07:15:14.461] startup_data = {canAcceptConnections = CAC_OK} [07:15:14.461] cac = [07:15:14.461] __func__ = "BackendStartup" [07:15:14.461] #22 0x0000559fdb0d98c3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [07:15:14.461] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "ң&ڟU\000\000\200\207\"ڟU\000\000\000e\225\276\376\177\000\000\370d\225\276\376\177\000\000\225[\362\001\000\000\000\000\2404ė2\177\000\000+", '\000' , "\376\177\000\000\000\004\000\000\000\000\000\000h6ߘ2\177\000\00006ė2\177\000\000\3402ߘ2\177\000\000\316)fR\000\000\000", __ss_align = 3197461824}, salen = 2}} [07:15:14.461] i = 0 [07:15:14.461] now = [07:15:14.461] last_lockfile_recheck_time = 1733641942 [07:15:14.461] last_touch_time = 1733641942 [07:15:14.461] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -1748748752, events = 32562, fd = -1730202912, user_data = 0x7c96e577}, {pos = -1097505408, events = 32766, fd = -1730373048, user_data = 0xf}, {pos = -1748748752, events = 32562, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1730202912, user_data = 0x7ffebe9564f8}, {pos = -1097505536, events = 32766, fd = -1730202008, user_data = 0x0}, {pos = -587683296, events = 21919, fd = -1756661110, user_data = 0x559fdcf8aa20}, {pos = 1, events = 21919, fd = 32768, user_data = 0xffffffff}, {pos = -1757224928, events = 32562, fd = -1735123040, user_data = 0x559fdcfb4358}, {pos = -587513288, events = 21919, fd = -587515903, user_data = 0x7f3298dcfebe}, {pos = 1, events = 0, fd = -1730202912, user_data = 0x1ab}, {pos = -609862312, events = 21919, fd = 0, user_data = 0xd8}, {pos = -587683296, events = 21919, fd = -1730347330, user_data = 0x1}, {pos = 0, events = 0, fd = -1757224928, user_data = 0x7f32974f2e40 }, {pos = 16, events = 0, fd = -1097504400, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f3298dd21ba}, {pos = 0, events = 0, fd = -1756697180, user_data = 0x0}, {pos = -602892032, events = 21919, fd = 2, user_data = 0x0}, {pos = -587944336, events = 21919, fd = -618947035, user_data = 0x559fdcfbbb00}, {pos = -618943046, events = 21919, fd = -587482277, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -1757190968, user_data = 0x7f329749c880 }, {pos = -1748808264, events = 32562, fd = -1097504208, user_data = 0x100007f00000002}, {pos = -1756664057, events = 32562, fd = 2, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -1755374496, events = 32562, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 878082156, events = 1802860908, fd = 168441929, user_data = 0x74616467702f6174}, {pos = 925960801, events = 875967283, 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 = -587509088, events = 21919, fd = -1756661110, user_data = 0xa}, {pos = -615506366, events = 21919, fd = -587500864, user_data = 0x7f32974b58be}, {pos = -1755391520, events = 32562, fd = -1756753554, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xc942a6949f3c9800}, {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 = 0x559fdcfb4030}, {pos = 1, events = 0, fd = -587513608, user_data = 0x3}, {pos = 0, events = 0, fd = 39009, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -587683296, user_data = 0x7f32974f3053 }, {pos = -587513608, events = 21919, fd = 1024, user_data = 0x7ffebe956a38}, {pos = -615423050, events = 21919, fd = -602827536, user_data = 0x559fdb504e73 }, {pos = -587513808, events = 21919, fd = -587690880, user_data = 0x559fdcfb4030}, {pos = -1756670101, events = 32562, fd = 0, user_data = 0x559fdb516add }, {pos = -587513808, events = 1, fd = -615420890, user_data = 0x559fdcf88c80}, {pos = -1623418880, events = 3376588436, fd = 0, user_data = 0x7f32974a2ab1}, {pos = -1756752656, events = 32562, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -587944336, user_data = 0xc942a6949f3c9800}, {pos = 0, events = 0, fd = -1623418880, user_data = 0xc}, {pos = -1623418880, events = 3376588436, fd = 0, user_data = 0x7f329745b239 }, {pos = 217, events = 0, fd = -619895060, user_data = 0x400000}, {pos = 0, events = 0, fd = -587944336, user_data = 0x559fdb504d07 }, {pos = -587856976, events = 21919, fd = -587690880, user_data = 0x559fdcf603b0}, {pos = 1, events = 0, fd = 0, user_data = 0x559fdb4c3704 }, {pos = 12, events = 0, fd = -587518360, user_data = 0x559fdcfb2e48}, {pos = -602890624, events = 21919, fd = 296, user_data = 0x559fdb0d4f06 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -619878589, events = 21919, fd = -606462480, user_data = 0x559fdcf89638}} [07:15:14.461] nevents = 1 [07:15:14.461] __func__ = "ServerLoop" [07:15:14.461] #23 0x0000559fdb0db157 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x559fdcf46ce0) at ../src/backend/postmaster/postmaster.c:1374 [07:15:14.461] opt = [07:15:14.461] status = [07:15:14.461] userDoption = [07:15:14.461] listen_addr_saved = false [07:15:14.461] output_config_variable = [07:15:14.461] __func__ = "PostmasterMain" [07:15:14.461] #24 0x0000559fdaf08104 in main (argc=4, argv=0x559fdcf46ce0) at ../src/backend/main/main.c:222 [07:15:14.461] do_check_root = [07:15:14.461] dispatch_option = [07:15:14.480] -e [07:15:14.480] [07:15:14.480] [07:15:14.544] dumping /tmp/cores/postgres-6-28263.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [07:15:14.805] [New LWP 28263] [07:15:14.805] [07:15:14.805] This GDB supports auto-downloading debuginfo from the following URLs: [07:15:14.805] [07:15:14.805] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [07:15:14.805] Debuginfod has been disabled. [07:15:14.805] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [07:15:14.917] [Thread debugging using libthread_db enabled] [07:15:14.917] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [07:15:14.917] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [07:15:14.917] Program terminated with signal SIGABRT, Aborted. [07:15:14.917] #0 0x00007f13c4aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:15.939] [07:15:15.939] Thread 1 (Thread 0x7f13c49d6f00 (LWP 28263)): [07:15:15.939] #0 0x00007f13c4aa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:15.939] No symbol table info available. [07:15:15.939] #1 0x00007f13c4a5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:15.939] No symbol table info available. [07:15:15.939] #2 0x00007f13c4a45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [07:15:15.939] No symbol table info available. [07:15:15.939] #3 0x00007f13c4c1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [07:15:15.939] No locals. [07:15:15.939] #4 0x00007f13c4c2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [07:15:15.939] No locals. [07:15:15.939] #5 0x00007f13c4c0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5601208b3100, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [07:15:15.939] bp = 140726177142272 [07:15:15.939] pc = [07:15:15.939] Opts = {FromUnrecoverableHandler = true, pc = 94562827034108, bp = 94562857196456} [07:15:15.939] #6 0x000056011fb6ddfc in examine_self_contradictory_rels (root=root@entry=0x560121796408, rel=rel@entry=0x5601217961b8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [07:15:15.939] lc__state = [07:15:15.939] rlist = [07:15:15.939] i = 2 [07:15:15.939] br = [07:15:15.939] expression = [07:15:15.939] or_rinfo = 0x560121832788 [07:15:15.939] ccxt = [07:15:15.939] delidx = 0x560121832721 [07:15:15.939] arglst = [07:15:15.939] lc = [07:15:15.939] arg = [07:15:15.939] n = [07:15:15.939] restrictinfo = [07:15:15.939] ccwapper = {clausecxt = 0x560121832088} [07:15:15.939] sec = {sopcinfo = {n_members = 38, opcies = 0x560121831bf8}, attrsdc = {min_attr = -6, max_attr = 5, len_set = 2, atop_array = 0x560121831318, atop_set = 0x560121831498}, ccfree = 0x5601218326f0, vifree = 0x560121832290} [07:15:15.939] __func__ = "examine_self_contradictory_rels" [07:15:15.939] #7 0x000056011fb6e00b in examine_self_contradictory_rels_phase1 (root=root@entry=0x560121796408) at ../src/backend/optimizer/plan/contradictory.c:2608 [07:15:15.939] rel = 0x5601217961b8 [07:15:15.939] rti = 1 [07:15:15.939] rinfo = [07:15:15.939] #8 0x000056011fb3864d in query_planner (root=root@entry=0x560121796408, qp_callback=qp_callback@entry=0x56011fb3d96a , qp_extra=qp_extra@entry=0x7ffd5dcc9800) at ../src/backend/optimizer/plan/planmain.c:190 [07:15:15.939] parse = 0x5601217390e0 [07:15:15.939] joinlist = 0x560121831508 [07:15:15.939] final_rel = [07:15:15.939] __func__ = "query_planner" [07:15:15.939] #9 0x000056011fb4ba40 in grouping_planner (root=root@entry=0x560121796408, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [07:15:15.939] sort_input_targets = 0x5 [07:15:15.939] sort_input_target_parallel_safe = [07:15:15.939] grouping_target = [07:15:15.939] scanjoin_target = [07:15:15.939] activeWindows = 0x0 [07:15:15.939] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [07:15:15.939] sort_input_targets_contain_srfs = 0x1 [07:15:15.939] have_grouping = [07:15:15.939] wflists = 0x0 [07:15:15.939] gset_data = 0x0 [07:15:15.939] sort_input_target = [07:15:15.939] grouping_targets = 0x1 [07:15:15.939] grouping_target_parallel_safe = [07:15:15.939] scanjoin_targets = 0x0 [07:15:15.939] scanjoin_target_parallel_safe = [07:15:15.939] grouping_targets_contain_srfs = 0x1 [07:15:15.939] scanjoin_targets_contain_srfs = 0x5601200b028d [07:15:15.939] scanjoin_target_same_exprs = [07:15:15.939] parse = 0x5601217390e0 [07:15:15.939] offset_est = 0 [07:15:15.939] count_est = 0 [07:15:15.939] limit_tuples = -1 [07:15:15.939] have_postponed_srfs = false [07:15:15.939] final_target = [07:15:15.939] final_targets = 0x56012176e618 [07:15:15.939] final_targets_contain_srfs = 0x56011faaa098 [07:15:15.939] final_target_parallel_safe = [07:15:15.939] current_rel = [07:15:15.939] final_rel = [07:15:15.939] extra = {limit_needed = false, limit_tuples = 4.672024380321435e-310, count_est = 94562856563464, offset_est = 94562856563464} [07:15:15.939] lc = [07:15:15.939] __func__ = "grouping_planner" [07:15:15.939] #10 0x000056011fb4e9c4 in subquery_planner (glob=glob@entry=0x5601217960a8, parse=parse@entry=0x5601217390e0, 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:1153 [07:15:15.939] root = 0x560121796408 [07:15:15.939] newWithCheckOptions = [07:15:15.939] newHaving = 0x0 [07:15:15.939] hasOuterJoins = [07:15:15.939] hasResultRTEs = false [07:15:15.939] final_rel = [07:15:15.939] l = 0x0 [07:15:15.939] #11 0x000056011fb4f655 in standard_planner (parse=0x5601217390e0, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [07:15:15.939] result = [07:15:15.939] glob = 0x5601217960a8 [07:15:15.939] tuple_fraction = 0 [07:15:15.939] root = [07:15:15.939] final_rel = [07:15:15.939] best_path = [07:15:15.939] top_plan = [07:15:15.939] lp = [07:15:15.939] lr = [07:15:15.939] #12 0x000056011fb506bf in planner (parse=parse@entry=0x5601217390e0, query_string=query_string@entry=0x560121737af0 "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:294 [07:15:15.939] result = [07:15:15.939] #13 0x000056011fdbf86c in pg_plan_query (querytree=querytree@entry=0x5601217390e0, query_string=query_string@entry=0x560121737af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [07:15:15.939] plan = [07:15:15.939] #14 0x000056011f8c53d0 in standard_ExplainOneQuery (query=0x5601217390e0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5601217724b8, queryString=0x560121737af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:496 [07:15:15.939] plan = [07:15:15.939] planstart = [07:15:15.939] planduration = {ticks = 94562826209724} [07:15:15.939] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94562832461699, shared_blks_dirtied = 1573690094, shared_blks_written = 3, local_blks_hit = 4856188880, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94562856177888, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94562832548493}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94562826207105}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94562856177888}} [07:15:15.939] bufusage = {shared_blks_hit = 0, shared_blks_read = 94562829230120, shared_blks_dirtied = 212592291233792, shared_blks_written = 72057594037927936, local_blks_hit = 139722686513384, local_blks_read = 94562856179280, local_blks_dirtied = 94562856177888, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94562832077023, shared_blk_read_time = {ticks = 139722686513384}, shared_blk_write_time = {ticks = 94562832077042}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94562832457282}, temp_blk_read_time = {ticks = 94562856411504}, temp_blk_write_time = {ticks = 64}} [07:15:15.939] mem_counters = {nblocks = 94562856558600, freechunks = 4294967297, totalspace = 140726177143408, freespace = 10} [07:15:15.939] planner_ctx = 0x0 [07:15:15.939] saved_ctx = 0x0 [07:15:15.939] #15 0x000056011f8c56b6 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5601217724b8, pstate=pstate@entry=0x5601217723a8, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [07:15:15.939] No locals. [07:15:15.939] #16 0x000056011f8c65b6 in ExplainQuery (pstate=pstate@entry=0x5601217723a8, stmt=stmt@entry=0x560121738f20, params=params@entry=0x0, dest=dest@entry=0x560121772318) at ../src/backend/commands/explain.c:350 [07:15:15.939] l__state = [07:15:15.939] l = 0x560121796070 [07:15:15.939] es = 0x5601217724b8 [07:15:15.939] tstate = [07:15:15.939] jstate = [07:15:15.939] query = [07:15:15.939] rewritten = 0x560121796058 [07:15:15.939] lc = 0x0 [07:15:15.939] timing_set = false [07:15:15.939] summary_set = false [07:15:15.939] __func__ = "ExplainQuery" [07:15:15.939] #17 0x000056011fdca453 in standard_ProcessUtility (pstmt=0x560121738fd0, queryString=0x560121737af0 "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=0x560121772318, qc=0x7ffd5dcc9cf0) at ../src/backend/tcop/utility.c:866 [07:15:15.939] parsetree = 0x560121738f20 [07:15:15.939] isTopLevel = true [07:15:15.939] isAtomicContext = false [07:15:15.939] pstate = 0x5601217723a8 [07:15:15.939] readonly_flags = [07:15:15.939] __func__ = "standard_ProcessUtility" [07:15:15.939] #18 0x000056011fdcab7c in ProcessUtility (pstmt=pstmt@entry=0x560121738fd0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x560121772318, qc=0x7ffd5dcc9cf0) at ../src/backend/tcop/utility.c:523 [07:15:15.939] No locals. [07:15:15.939] #19 0x000056011fdc63e8 in PortalRunUtility (portal=portal@entry=0x5601217bc100, pstmt=0x560121738fd0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x560121772318, qc=qc@entry=0x7ffd5dcc9cf0) at ../src/backend/tcop/pquery.c:1158 [07:15:15.939] No locals. [07:15:15.939] #20 0x000056011fdc6c5b in FillPortalStore (portal=portal@entry=0x5601217bc100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [07:15:15.939] treceiver = 0x560121772318 [07:15:15.939] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:15:15.939] __func__ = "FillPortalStore" [07:15:15.939] #21 0x000056011fdc724f in PortalRun (portal=portal@entry=0x5601217bc100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x56012176e8f8, altdest=altdest@entry=0x56012176e8f8, qc=0x7ffd5dcc9ed0) at ../src/backend/tcop/pquery.c:763 [07:15:15.939] _save_exception_stack = 0x7ffd5dcc9f80 [07:15:15.939] _save_context_stack = 0x0 [07:15:15.939] _local_sigjmp_buf = {{__jmpbuf = {0, 8896530571418909979, 94562856714496, 94562856177560, 94562856714496, 94562856177488, 2922319524355357979, 8896489696138214683}, __mask_was_saved = 0, __saved_mask = {__val = {94562832457282, 94562856172016, 112, 4, 94562832461699, 1573690975, 4, 94562856177488, 112, 153, 94562856714496, 94562856177560, 94562856177536, 94562856177488, 94562832548902, 1}}}} [07:15:15.939] _do_rethrow = [07:15:15.939] result = [07:15:15.939] nprocessed = [07:15:15.939] saveTopTransactionResourceOwner = 0x560121779658 [07:15:15.939] saveTopTransactionContext = 0x5601217ce530 [07:15:15.939] saveActivePortal = 0x0 [07:15:15.939] saveResourceOwner = 0x560121779658 [07:15:15.939] savePortalContext = 0x0 [07:15:15.939] saveMemoryContext = 0x5601217ce530 [07:15:15.939] __func__ = "PortalRun" [07:15:15.939] #22 0x000056011fdc0342 in exec_simple_query (query_string=query_string@entry=0x560121737af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;") at ../src/backend/tcop/postgres.c:1283 [07:15:15.939] cmdtaglen = 7 [07:15:15.939] snapshot_set = [07:15:15.939] per_parsetree_context = 0x0 [07:15:15.939] plantree_list = 0x56012176e8a8 [07:15:15.939] parsetree = 0x560121738f50 [07:15:15.939] commandTag = [07:15:15.939] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [07:15:15.939] querytree_list = [07:15:15.939] portal = 0x5601217bc100 [07:15:15.939] receiver = 0x56012176e8f8 [07:15:15.939] format = 0 [07:15:15.939] cmdtagname = [07:15:15.939] parsetree_item__state = [07:15:15.939] dest = DestRemote [07:15:15.939] oldcontext = 0x5601217ce530 [07:15:15.939] parsetree_list = 0x560121738f80 [07:15:15.939] parsetree_item = 0x560121738f98 [07:15:15.939] save_log_statement_stats = false [07:15:15.939] was_logged = false [07:15:15.939] use_implicit_block = false [07:15:15.939] msec_str = "\004\000\000\000\000\000\000\000\021\314\a \001V\000\000`\237\314]\375\177\000\000J\000\000\000\000\000\000" [07:15:15.939] __func__ = "exec_simple_query" [07:15:15.939] #23 0x000056011fdc30c6 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4822 [07:15:15.939] query_string = 0x560121737af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;" [07:15:15.939] firstchar = [07:15:15.939] input_message = {data = 0x560121737af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", len = 74, maxlen = 1024, cursor = 74} [07:15:15.939] local_sigjmp_buf = {{__jmpbuf = {94562845136184, 8896526884303781147, 140726177145052, 4, 1, 140726177145284, 2922319524426661147, 8896489698353200411}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94562855902736, 15616, 94562845130272, 94562856435056, 1, 94562832461247, 0, 9, 2, 94562845136192, 94562855902736, 94562845130272, 4, 1, 140726177145284}}}} [07:15:15.939] send_ready_for_query = false [07:15:15.939] idle_in_transaction_timeout_enabled = false [07:15:15.939] idle_session_timeout_enabled = false [07:15:15.939] __func__ = "PostgresMain" [07:15:15.939] #24 0x000056011fdb8ebb in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [07:15:15.939] bsdata = [07:15:15.939] #25 0x000056011fc6a9ef in postmaster_child_launch (child_type=B_BACKEND, child_slot=1, startup_data=startup_data@entry=0x7ffd5dcca0dc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd5dcca130) at ../src/backend/postmaster/launch_backend.c:274 [07:15:15.939] pid = [07:15:15.939] #26 0x000056011fc6f9ea in BackendStartup (client_sock=client_sock@entry=0x7ffd5dcca130) at ../src/backend/postmaster/postmaster.c:3390 [07:15:15.939] bn = 0x560121760068 [07:15:15.939] pid = [07:15:15.939] startup_data = {canAcceptConnections = CAC_OK} [07:15:15.939] cac = [07:15:15.939] __func__ = "BackendStartup" [07:15:15.939] #27 0x000056011fc718c3 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1676 [07:15:15.939] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\322#\340\036\001V\000\000\200\a\334\036\001V\000\000\200\242\314]\375\177\000\000x\242\314]\375\177\000\000\225[\362\001\000\000\000\000\240\264\362\305\023\177\000\000+", '\000' , "\375\177\000\000\000\004\000\000\000\000\000\000h\246?\306\023\177\000\0000\266\362\305\023\177\000\000\340\242?\306\023\177\000\000\316)fR\000\000\000", __ss_align = 1573692096}, salen = 2}} [07:15:15.939] i = 0 [07:15:15.939] now = [07:15:15.939] last_lockfile_recheck_time = 1733641860 [07:15:15.939] last_touch_time = 1733641860 [07:15:15.939] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = -968908064, user_data = 0x0}, {pos = 1573692160, events = 32765, fd = -969078200, user_data = 0xf}, {pos = -973949392, events = 32531, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -968908064, user_data = 0x7ffd5dcca278}, {pos = 1573692032, events = 32765, fd = -968907160, user_data = 0x0}, {pos = 561216432, events = 22017, fd = -995394934, user_data = 0x560121737bb0}, {pos = 1, events = 22017, fd = 32768, user_data = 0xffffffff}, {pos = -995958752, events = 32531, fd = -973828192, user_data = 0x560121763198}, {pos = 561393784, events = 22017, fd = 561402977, user_data = 0x7f13c63d6ebe}, {pos = 1, events = 0, fd = -968908064, user_data = 0x1ab}, {pos = 543145304, events = 22017, fd = 0, user_data = 0xec}, {pos = 561216432, events = 22017, fd = -969052482, user_data = 0x1}, {pos = 0, events = 0, fd = -995958752, user_data = 0x7f13c4af2e40 }, {pos = 16, events = 0, fd = 1573693168, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7f13c63d91ba}, {pos = 0, events = 0, fd = -995431004, user_data = 0x0}, {pos = 550115584, events = 22017, fd = 2, user_data = 0x0}, {pos = 560963248, events = 22017, fd = 534060581, user_data = 0x56012176acc0}, {pos = 534064570, events = 22017, fd = 561425691, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -995924792, user_data = 0x7f13c4a9c880 }, {pos = -996315720, events = 32531, fd = 1573693360, user_data = 0x100007f00000002}, {pos = -995397881, events = 32531, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -994108320, events = 32531, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = 762540901, events = 1631155570, fd = 168447831, user_data = 0x36333337310a6174}, {pos = 909652276, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 22016, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 561396832, events = 22017, fd = -995394934, user_data = 0xa}, {pos = 537501250, events = 22017, fd = 561409168, user_data = 0x7f13c4ab576b}, {pos = -994125344, events = 32531, fd = -995487378, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x1acc6607fde61a00}, {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 = 0x560121762e70}, {pos = 1, events = 0, fd = 561393464, user_data = 0x3}, {pos = 0, events = 0, fd = 21016, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 561216432, user_data = 0x7f13c4af3053 }, {pos = 561393464, events = 22017, fd = 1024, user_data = 0x7ffd5dcca7b8}, {pos = 537584566, events = 22017, fd = 550180080, user_data = 0x56012009ce73 }, {pos = 561393264, events = 22017, fd = 561215984, user_data = 0x560121762e70}, {pos = -995403925, events = 32531, fd = 0, user_data = 0x5601200aeadd }, {pos = 561393264, events = 1, fd = 537586726, user_data = 0x5601217379f0}, {pos = -35251712, events = 449603079, fd = 0, user_data = 0x7f13c4aa2ab1}, {pos = -995486480, events = 32531, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 560963248, user_data = 0x1acc6607fde61a00}, {pos = 0, events = 0, fd = -35251712, user_data = 0xc}, {pos = -35251712, events = 449603079, fd = 0, user_data = 0x7f13c4a5b239 }, {pos = 237, events = 0, fd = 533112556, user_data = 0x400000}, {pos = 0, events = 0, fd = 560963248, user_data = 0x56012009cd07 }, {pos = 561049888, events = 22017, fd = 561215984, user_data = 0x56012170f120}, {pos = 1, events = 0, fd = 0, user_data = 0x56012005b704 }, {pos = 12, events = 0, fd = 561392840, user_data = 0x560121762ca8}, {pos = 550116992, events = 22017, fd = 296, user_data = 0x56011fc6cf06 }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 533129027, events = 22017, fd = 546545136, user_data = 0x5601217383c8}} [07:15:15.939] nevents = 1 [07:15:15.939] __func__ = "ServerLoop" [07:15:15.939] #28 0x000056011fc73157 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x5601216f5d70) at ../src/backend/postmaster/postmaster.c:1374 [07:15:15.939] opt = [07:15:15.939] status = [07:15:15.939] userDoption = [07:15:15.939] listen_addr_saved = false [07:15:15.939] output_config_variable = [07:15:15.939] __func__ = "PostmasterMain" [07:15:15.939] #29 0x000056011faa0104 in main (argc=8, argv=0x5601216f5d70) at ../src/backend/main/main.c:222 [07:15:15.939] do_check_root = [07:15:15.939] dispatch_option =