[12:59:15.560] src/tools/ci/cores_backtrace.sh linux /tmp/cores [12:59:15.780] dumping /tmp/cores/postgres-6-29888.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [12:59:16.040] [New LWP 29888] [12:59:16.040] [12:59:16.040] This GDB supports auto-downloading debuginfo from the following URLs: [12:59:16.040] [12:59:16.040] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:59:16.040] Debuginfod has been disabled. [12:59:16.040] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:59:16.299] [Thread debugging using libthread_db enabled] [12:59:16.299] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:59:16.299] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN '. [12:59:16.299] Program terminated with signal SIGABRT, Aborted. [12:59:16.299] #0 0x00007f76cdea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:17.332] [12:59:17.332] Thread 1 (Thread 0x7f76ce633f00 (LWP 29888)): [12:59:17.332] #0 0x00007f76cdea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:17.332] No symbol table info available. [12:59:17.332] #1 0x00007f76cde5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:17.332] No symbol table info available. [12:59:17.332] #2 0x00007f76cde45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:17.332] No symbol table info available. [12:59:17.332] #3 0x00007f76ce01e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [12:59:17.332] No locals. [12:59:17.332] #4 0x00007f76ce02aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [12:59:17.332] No locals. [12:59:17.332] #5 0x00007f76ce00dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x562940830480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [12:59:17.332] bp = 140734608524464 [12:59:17.332] pc = [12:59:17.332] Opts = {FromUnrecoverableHandler = true, pc = 94735162007184, bp = 94735186598632} [12:59:17.332] #6 0x000056293fadde90 in examine_self_contradictory_rels (root=root@entry=0x56294117ca48, rel=rel@entry=0x562941278ea8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [12:59:17.332] lc__state = [12:59:17.332] rlist = [12:59:17.332] i = 2 [12:59:17.332] br = [12:59:17.332] expression = [12:59:17.332] or_rinfo = 0x562941252820 [12:59:17.332] ccxt = [12:59:17.332] delidx = 0x5629412526b9 [12:59:17.332] arglst = [12:59:17.332] lc = [12:59:17.332] arg = [12:59:17.332] n = [12:59:17.332] restrictinfo = [12:59:17.332] ccwapper = {clausecxt = 0x562941252068} [12:59:17.332] sec = {sopcinfo = {n_members = 38, opcies = 0x562941251b38}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x5629412511d8, atop_set = 0x562941251f48}, ccfree = 0x562941252688, vifree = 0x5629412521d8} [12:59:17.332] __func__ = "examine_self_contradictory_rels" [12:59:17.332] #7 0x000056293fade09f in examine_self_contradictory_rels_phase1 (root=root@entry=0x56294117ca48) at ../src/backend/optimizer/plan/contradictory.c:2608 [12:59:17.332] rel = 0x562941278ea8 [12:59:17.332] rti = 1 [12:59:17.332] rinfo = [12:59:17.332] #8 0x000056293faa9058 in query_planner (root=root@entry=0x56294117ca48, qp_callback=qp_callback@entry=0x56293faae375 , qp_extra=qp_extra@entry=0x7fff545946b0) at ../src/backend/optimizer/plan/planmain.c:193 [12:59:17.332] parse = 0x562940f42d38 [12:59:17.332] joinlist = 0x562941251248 [12:59:17.332] final_rel = [12:59:17.332] __func__ = "query_planner" [12:59:17.332] #9 0x000056293fabbad4 in grouping_planner (root=root@entry=0x56294117ca48, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [12:59:17.332] sort_input_targets = 0x5 [12:59:17.332] sort_input_target_parallel_safe = [12:59:17.332] grouping_target = [12:59:17.332] scanjoin_target = [12:59:17.332] activeWindows = 0x0 [12:59:17.332] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [12:59:17.332] sort_input_targets_contain_srfs = 0x1 [12:59:17.332] have_grouping = [12:59:17.332] wflists = 0x0 [12:59:17.332] gset_data = 0x0 [12:59:17.332] sort_input_target = [12:59:17.332] grouping_targets = 0x1 [12:59:17.332] grouping_target_parallel_safe = [12:59:17.332] scanjoin_targets = 0x0 [12:59:17.332] scanjoin_target_parallel_safe = [12:59:17.332] grouping_targets_contain_srfs = 0x1 [12:59:17.332] scanjoin_targets_contain_srfs = 0x562940023ab8 [12:59:17.332] scanjoin_target_same_exprs = [12:59:17.332] parse = 0x562940f42d38 [12:59:17.332] offset_est = 0 [12:59:17.332] count_est = 0 [12:59:17.332] limit_tuples = -1 [12:59:17.332] have_postponed_srfs = false [12:59:17.332] final_target = [12:59:17.332] final_targets = 0x5629411629a8 [12:59:17.332] final_targets_contain_srfs = 0x56293fa19ad2 [12:59:17.332] final_target_parallel_safe = [12:59:17.332] current_rel = [12:59:17.332] final_rel = [12:59:17.332] extra = {limit_needed = false, limit_tuples = 4.6805388592184827e-310, count_est = 94735186594984, offset_est = 94735186594984} [12:59:17.332] lc = [12:59:17.332] __func__ = "grouping_planner" [12:59:17.332] #10 0x000056293fabea58 in subquery_planner (glob=glob@entry=0x56294117da68, parse=parse@entry=0x562940f42d38, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [12:59:17.332] root = 0x56294117ca48 [12:59:17.332] newWithCheckOptions = [12:59:17.332] newHaving = 0x0 [12:59:17.332] hasOuterJoins = [12:59:17.332] hasResultRTEs = false [12:59:17.332] final_rel = [12:59:17.332] l = 0x0 [12:59:17.332] #11 0x000056293fabf6e9 in standard_planner (parse=parse@entry=0x562940f42d38, query_string=query_string@entry=0x562940f41a90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:425 [12:59:17.332] result = [12:59:17.332] glob = 0x56294117da68 [12:59:17.332] tuple_fraction = 0 [12:59:17.332] root = [12:59:17.332] final_rel = [12:59:17.332] best_path = [12:59:17.332] top_plan = [12:59:17.332] lp = [12:59:17.332] lr = [12:59:17.332] #12 0x00007f76cb5655a2 in pgss_planner (parse=0x562940f42d38, query_string=0x562940f41a90 "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 [12:59:17.332] _save_exception_stack = 0x7fff54595030 [12:59:17.332] _save_context_stack = 0x0 [12:59:17.332] _local_sigjmp_buf = {{__jmpbuf = {94735183392056, -2919886360680670996, 0, 2048, 94735183392056, 2048, -8874814165217257236, -8807512998022817556}, __mask_was_saved = 0, __saved_mask = {__val = {94735183885112, 94735183882752, 94735166933198, 94735183390952, 17019, 0, 0, 0, 392257162392, 17019, 0, 140148163915136, 140148163915072, 0, 0, 140734608673196}}}} [12:59:17.332] _do_rethrow = false [12:59:17.332] result = 0x7fff54594968 [12:59:17.332] #13 0x000056293fac0749 in planner (parse=parse@entry=0x562940f42d38, query_string=query_string@entry=0x562940f41a90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:290 [12:59:17.332] result = [12:59:17.332] #14 0x000056293fd2fd98 in pg_plan_query (querytree=querytree@entry=0x562940f42d38, query_string=query_string@entry=0x562940f41a90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [12:59:17.332] plan = [12:59:17.332] #15 0x000056293f8320a2 in standard_ExplainOneQuery (query=0x562940f42d38, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x56294117d7c8, queryString=0x562940f41a90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [12:59:17.332] plan = [12:59:17.332] planstart = [12:59:17.332] planduration = {ticks = 94735161181174} [12:59:17.332] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94735167449006, shared_blks_dirtied = 1415138526, shared_blks_written = 3, local_blks_hit = 5388078680, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94735183392056, shared_blk_read_time = {ticks = 396004053293604839}, shared_blk_write_time = {ticks = 94735167535800}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94735161178555}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94735183392056}} [12:59:17.332] bufusage = {shared_blks_hit = 0, shared_blks_read = 94735164204607, shared_blks_dirtied = 73096048427008, shared_blks_written = 72057594037927936, local_blks_hit = 140148163905184, local_blks_read = 94735183393232, local_blks_dirtied = 94735183392056, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94735167063418, shared_blk_read_time = {ticks = 140148163905184}, shared_blk_write_time = {ticks = 94735167063437}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94735167444589}, temp_blk_read_time = {ticks = 94735183607136}, temp_blk_write_time = {ticks = 64}} [12:59:17.332] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140734608526432, freespace = 10} [12:59:17.332] planner_ctx = 0x0 [12:59:17.332] saved_ctx = 0x0 [12:59:17.332] #16 0x000056293f832388 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x56294117d7c8, pstate=pstate@entry=0x562940f77818, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [12:59:17.332] No locals. [12:59:17.332] #17 0x000056293f8332df in ExplainQuery (pstate=pstate@entry=0x562940f77818, stmt=stmt@entry=0x562940f42b78, params=params@entry=0x0, dest=dest@entry=0x562940f77788) at ../src/backend/commands/explain.c:357 [12:59:17.332] l__state = [12:59:17.332] l = 0x56294117ca10 [12:59:17.332] es = 0x56294117d7c8 [12:59:17.332] tstate = [12:59:17.332] jstate = [12:59:17.332] query = [12:59:17.332] rewritten = 0x56294117c9f8 [12:59:17.332] lc = 0x0 [12:59:17.332] timing_set = false [12:59:17.332] buffers_set = false [12:59:17.332] summary_set = false [12:59:17.332] __func__ = "ExplainQuery" [12:59:17.332] #18 0x000056293fd3a7b8 in standard_ProcessUtility (pstmt=pstmt@entry=0x562940f42c28, queryString=queryString@entry=0x562940f41a90 "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=0x562940f77788, qc=0x7fff54595270) at ../src/backend/tcop/utility.c:866 [12:59:17.332] parsetree = 0x562940f42b78 [12:59:17.332] isTopLevel = true [12:59:17.332] isAtomicContext = false [12:59:17.332] pstate = 0x562940f77818 [12:59:17.332] readonly_flags = [12:59:17.332] __func__ = "standard_ProcessUtility" [12:59:17.332] #19 0x00007f76cb564d8f in pgss_ProcessUtility (pstmt=0x562940f42c28, queryString=0x562940f41a90 "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=0x562940f77788, qc=0x7fff54595270) at ../contrib/pg_stat_statements/pg_stat_statements.c:1170 [12:59:17.332] _save_exception_stack = 0x7fff54595310 [12:59:17.332] _save_context_stack = 0x0 [12:59:17.332] _local_sigjmp_buf = {{__jmpbuf = {0, 8874619296727095532, 94735183391784, 94735183607688, 140734608527984, 1, -8874814165273880340, -8807512998466103060}, __mask_was_saved = 0, __saved_mask = {__val = {94735167444589, 94735183387024, 11, 1, 94735167449006, 1091973496, 1, 94735183387024, 10, 94735185621640, 94735185621640, 1, 94735185621640, 94735185621384, 140148237627501, 86}}}} [12:59:17.332] _do_rethrow = false [12:59:17.332] duration = [12:59:17.332] bufusage = {shared_blks_hit = 0, shared_blks_read = 94735167536209, shared_blks_dirtied = 0, shared_blks_written = 94735183393784, local_blks_hit = 94735185619496, local_blks_read = 94735185619496, local_blks_dirtied = 94735185619416, local_blks_written = 140734608527744, temp_blks_read = 140734608527744, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94735162455008}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94735183393928}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94735167444589}} [12:59:17.332] walusage_start = {wal_records = 71, wal_fpi = 16, wal_bytes = 100621} [12:59:17.332] start = [12:59:17.332] rows = [12:59:17.332] bufusage_start = {shared_blks_hit = 1491, shared_blks_read = 320, shared_blks_dirtied = 23, shared_blks_written = 59, 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}} [12:59:17.332] walusage = {wal_records = 140734608527504, wal_fpi = 94735166936630, wal_bytes = 140734608527504} [12:59:17.332] parsetree = [12:59:17.332] saved_queryId = 115682106034732626 [12:59:17.332] saved_stmt_location = 0 [12:59:17.332] saved_stmt_len = 108 [12:59:17.332] enabled = true [12:59:17.332] #20 0x000056293fd3ae2c in ProcessUtility (pstmt=pstmt@entry=0x562940f42c28, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x562940f77788, qc=0x7fff54595270) at ../src/backend/tcop/utility.c:519 [12:59:17.332] No locals. [12:59:17.332] #21 0x000056293fd3689f in PortalRunUtility (portal=portal@entry=0x562940fc4980, pstmt=0x562940f42c28, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x562940f77788, qc=qc@entry=0x7fff54595270) at ../src/backend/tcop/pquery.c:1152 [12:59:17.332] No locals. [12:59:17.332] #22 0x000056293fd37112 in FillPortalStore (portal=portal@entry=0x562940fc4980, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [12:59:17.332] treceiver = 0x562940f77788 [12:59:17.332] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:59:17.332] __func__ = "FillPortalStore" [12:59:17.332] #23 0x000056293fd3762d in PortalRun (portal=portal@entry=0x562940fc4980, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x562941163af8, altdest=altdest@entry=0x562941163af8, qc=qc@entry=0x7fff54595430) at ../src/backend/tcop/pquery.c:759 [12:59:17.332] _save_exception_stack = 0x7fff545954e0 [12:59:17.332] _save_context_stack = 0x0 [12:59:17.332] _local_sigjmp_buf = {{__jmpbuf = {0, -2919888266560874260, 94735183923584, 94735183391728, 94735183391704, 94735183391656, -8874814164867032852, -2919875594525681428}, __mask_was_saved = 0, __saved_mask = {__val = {94735167449006, 1415140287, 4, 94735183391656, 112, 153, 94735183923584, 94735183391728, 94735183391704, 94735183391656, 94735167536209, 1, 2, 153, 94735156791711, 0}}}} [12:59:17.332] _do_rethrow = [12:59:17.332] result = [12:59:17.332] nprocessed = [12:59:17.332] saveTopTransactionResourceOwner = 0x562940f83e58 [12:59:17.332] saveTopTransactionContext = 0x562940fd71c0 [12:59:17.332] saveActivePortal = 0x0 [12:59:17.332] saveResourceOwner = 0x562940f83e58 [12:59:17.332] savePortalContext = 0x0 [12:59:17.332] saveMemoryContext = 0x562940fd71c0 [12:59:17.332] __func__ = "PortalRun" [12:59:17.332] #24 0x000056293fd30864 in exec_simple_query (query_string=query_string@entry=0x562940f41a90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1271 [12:59:17.332] cmdtaglen = 7 [12:59:17.332] snapshot_set = [12:59:17.332] per_parsetree_context = 0x0 [12:59:17.332] plantree_list = 0x562941163aa8 [12:59:17.332] parsetree = 0x562940f42ba8 [12:59:17.332] commandTag = [12:59:17.332] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:59:17.332] querytree_list = [12:59:17.332] portal = 0x562940fc4980 [12:59:17.332] receiver = 0x562941163af8 [12:59:17.332] format = 0 [12:59:17.332] cmdtagname = [12:59:17.332] parsetree_item__state = [12:59:17.332] dest = DestRemote [12:59:17.332] oldcontext = 0x562940fd71c0 [12:59:17.332] parsetree_list = 0x562940f42bd8 [12:59:17.332] parsetree_item = 0x562940f42bf0 [12:59:17.332] save_log_statement_stats = false [12:59:17.332] was_logged = true [12:59:17.332] use_implicit_block = false [12:59:17.332] msec_str = "\004\000\000\000\000\000\000\000\373\001\377?)V\000\000\300TYT\377\177\000\000n\000\000\000\000\000\000" [12:59:17.332] __func__ = "exec_simple_query" [12:59:17.332] #25 0x000056293fd335bd in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [12:59:17.332] query_string = 0x562940f41a90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [12:59:17.332] firstchar = [12:59:17.332] input_message = {data = 0x562940f41a90 "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} [12:59:17.332] local_sigjmp_buf = {{__jmpbuf = {94735180196216, -2919886452584163092, 140734608528956, 4, 21, 140734608529188, -8874814165068359444, -2919875597185263380}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94735183643440, 0, 168, 94735167449108, 0, 10, 2, 94735180196224, 94735183117872, 94735180190272, 4, 21, 140734608529188}}}} [12:59:17.332] send_ready_for_query = false [12:59:17.332] idle_in_transaction_timeout_enabled = false [12:59:17.332] idle_session_timeout_enabled = false [12:59:17.332] __func__ = "PostgresMain" [12:59:17.332] #26 0x000056293fd29628 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:59:17.332] bsdata = [12:59:17.332] #27 0x000056293fbdad47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=21, startup_data=startup_data@entry=0x7fff5459563c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff54595690) at ../src/backend/postmaster/launch_backend.c:274 [12:59:17.332] pid = [12:59:17.332] #28 0x000056293fbdfd42 in BackendStartup (client_sock=client_sock@entry=0x7fff54595690) at ../src/backend/postmaster/postmaster.c:3386 [12:59:17.332] bn = 0x562940f6d5a8 [12:59:17.332] pid = [12:59:17.332] startup_data = {canAcceptConnections = CAC_OK} [12:59:17.332] cac = [12:59:17.332] __func__ = "BackendStartup" [12:59:17.332] #29 0x000056293fbe1c1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [12:59:17.332] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\343\315v\177\000\000\240\1777\317v\177\000\0008WYT\377\177\000\0004WYT\377\177", '\000' , "\"\346\325>)V\000\000\300\307\321>)V\000\000\000XYT\377\177\000\000\370WYT\377\177\000\000\225[\362\001\000\000\000\000\360\306\366@)V\000\000,", '\000' , ")V\000\0000\345\325>)V\000", __ss_align = 140148263618152}, salen = 2}} [12:59:17.332] i = 0 [12:59:17.332] now = [12:59:17.332] last_lockfile_recheck_time = 1735304069 [12:59:17.332] last_touch_time = 1735304069 [12:59:17.332] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x56293ed5e622}, {pos = -814217624, events = 32630, fd = -825723344, user_data = 0x7f76cf7802e0}, {pos = 2090263927, events = 0, fd = 1415141504, user_data = 0x7f76cf756a48}, {pos = 15, events = 0, fd = -825723344, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f76cf7802e0}, {pos = 1415141368, events = 32767, fd = 1415141376, user_data = 0x7f76cf780668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = 1089742256, events = 22057, fd = 1, user_data = 0x7fff54595d23}, {pos = -1, events = 0, fd = -840769504, user_data = 0x7f76cf377fa0}, {pos = 1089960072, events = 22057, fd = 1089959784, user_data = 0x562940f71c51}, {pos = -814362946, events = 32630, fd = 1, user_data = 0x7f76cf7802e0}, {pos = 426, events = 0, fd = 1079463248, user_data = 0x0}, {pos = 86, events = 0, fd = 1089925624, user_data = 0x7f76cf75cebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f76cde2e020}, {pos = -839963072, events = 32630, fd = 16, user_data = 0x7fff54595c50}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -814353990, events = 32630, fd = 0, user_data = 0x7f76cdeaeda4 }, {pos = 0, events = 0, fd = 1086483744, user_data = 0x2}, {pos = 0, events = 0, fd = 1089486544, user_data = 0x56293fcc702a }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = 1089925624, user_data = 0x7f76cf75cebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f76cde364c8}, {pos = -840208633, events = 32630, fd = 1086539872, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -838919072, events = 32630, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x735f3732305f742f}, {pos = 1634038388, events = 1701994349, fd = 1868785010, user_data = 0x7274735f3732302f}, {pos = -825719488, events = 32630, fd = -825718144, 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 = 1089966464, user_data = 0x7f76cdeb576b}, {pos = -838936096, events = 32630, fd = -840298130, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x559c983087b39d00}, {pos = -838933024, events = 32630, fd = -328, user_data = 0x0}, {pos = 1089959464, events = 22057, 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 = 28886, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1089925624, user_data = 0x7f76cdef3053 }, {pos = 1089959464, events = 22057, fd = 1024, user_data = 0x7fff54595d18}, {pos = 1073880033, events = 22057, fd = 1086548272, user_data = 0x56294001069e }, {pos = 1089959264, events = 22057, fd = 1089739152, user_data = 0x562940f77560}, {pos = -840214677, events = 32630, fd = 0, user_data = 0x562940022308 }, {pos = 1089959264, events = 1, fd = 1073882193, user_data = 0x562940f41990}, {pos = -2018272000, events = 1436325936, fd = 0, user_data = 0x7f76cdea2ab1}, {pos = -840297232, events = 32630, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1089486544, user_data = 0x559c983087b39d00}, {pos = 0, events = 0, fd = -2018272000, user_data = 0xc}, {pos = -2018272000, events = 1436325936, fd = 0, user_data = 0x7f76cde5b239 }, {pos = 87, events = 0, fd = 1069394500, user_data = 0x400000}, {pos = 0, events = 0, fd = 1089486544, user_data = 0x562940010532 }, {pos = 1089573056, events = 22057, fd = 1089739152, user_data = 0x562940f190c0}, {pos = 1, events = 0, fd = 0, user_data = 0x56293ffceccc }, {pos = 12, events = 0, fd = 1089921576, user_data = 0x562940f6e208}, {pos = 1086485152, events = 22057, fd = 296, user_data = 0x56293fbdd25e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1069410971, events = 22057, fd = 1082881584, user_data = 0x562940f42348}} [12:59:17.332] nevents = 1 [12:59:17.332] __func__ = "ServerLoop" [12:59:17.332] #30 0x000056293fbe349c in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x562940effd30) at ../src/backend/postmaster/postmaster.c:1371 [12:59:17.332] opt = [12:59:17.332] status = [12:59:17.332] userDoption = [12:59:17.332] listen_addr_saved = false [12:59:17.332] output_config_variable = [12:59:17.332] __func__ = "PostmasterMain" [12:59:17.332] #31 0x000056293fa0fb3e in main (argc=4, argv=0x562940effd30) at ../src/backend/main/main.c:230 [12:59:17.332] do_check_root = [12:59:17.332] dispatch_option = [12:59:17.370] -e [12:59:17.370] [12:59:17.370] [12:59:17.457] dumping /tmp/cores/postgres-6-22429.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [12:59:17.718] [New LWP 22429] [12:59:17.718] [12:59:17.718] This GDB supports auto-downloading debuginfo from the following URLs: [12:59:17.718] [12:59:17.718] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:59:17.718] Debuginfod has been disabled. [12:59:17.718] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:59:17.966] [Thread debugging using libthread_db enabled] [12:59:17.966] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:59:17.966] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [12:59:17.966] Program terminated with signal SIGABRT, Aborted. [12:59:17.966] #0 0x00007ff7694a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:18.966] [12:59:18.966] Thread 1 (Thread 0x7ff769c33f00 (LWP 22429)): [12:59:18.966] #0 0x00007ff7694a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:18.966] No symbol table info available. [12:59:18.966] #1 0x00007ff76945afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:18.966] No symbol table info available. [12:59:18.966] #2 0x00007ff769445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:18.966] No symbol table info available. [12:59:18.966] #3 0x00007ff76961e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [12:59:18.966] No locals. [12:59:18.966] #4 0x00007ff76962aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [12:59:18.966] No locals. [12:59:18.966] #5 0x00007ff76960dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55eb9a41c480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [12:59:18.966] bp = 140735426548464 [12:59:18.966] pc = [12:59:18.966] Opts = {FromUnrecoverableHandler = true, pc = 94470379708048, bp = 94470431559976} [12:59:18.966] #6 0x000055eb996c9e90 in examine_self_contradictory_rels (root=root@entry=0x55eb9c786698, rel=rel@entry=0x55eb9c7cb298, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [12:59:18.966] lc__state = [12:59:18.966] rlist = [12:59:18.966] i = 2 [12:59:18.966] br = [12:59:18.966] expression = [12:59:18.966] or_rinfo = 0x55eb9c83de78 [12:59:18.966] ccxt = [12:59:18.966] delidx = 0x55eb9c83dd11 [12:59:18.966] arglst = [12:59:18.966] lc = [12:59:18.966] arg = [12:59:18.966] n = [12:59:18.966] restrictinfo = [12:59:18.966] ccwapper = {clausecxt = 0x55eb9c83d6a8} [12:59:18.966] sec = {sopcinfo = {n_members = 38, opcies = 0x55eb9c83d178}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x55eb9c83c928, atop_set = 0x55eb9c83d588}, ccfree = 0x55eb9c83dce0, vifree = 0x55eb9c83d818} [12:59:18.966] __func__ = "examine_self_contradictory_rels" [12:59:18.966] #7 0x000055eb996ca09f in examine_self_contradictory_rels_phase1 (root=root@entry=0x55eb9c786698) at ../src/backend/optimizer/plan/contradictory.c:2608 [12:59:18.966] rel = 0x55eb9c7cb298 [12:59:18.966] rti = 1 [12:59:18.966] rinfo = [12:59:18.966] #8 0x000055eb99695058 in query_planner (root=root@entry=0x55eb9c786698, qp_callback=qp_callback@entry=0x55eb9969a375 , qp_extra=qp_extra@entry=0x7fff851b54f0) at ../src/backend/optimizer/plan/planmain.c:193 [12:59:18.966] parse = 0x55eb9c526d98 [12:59:18.966] joinlist = 0x55eb9c83c998 [12:59:18.966] final_rel = [12:59:18.966] __func__ = "query_planner" [12:59:18.966] #9 0x000055eb996a7ad4 in grouping_planner (root=root@entry=0x55eb9c786698, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [12:59:18.966] sort_input_targets = 0x5 [12:59:18.966] sort_input_target_parallel_safe = [12:59:18.966] grouping_target = [12:59:18.966] scanjoin_target = [12:59:18.966] activeWindows = 0x0 [12:59:18.966] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [12:59:18.966] sort_input_targets_contain_srfs = 0x1 [12:59:18.966] have_grouping = [12:59:18.966] wflists = 0x0 [12:59:18.966] gset_data = 0x0 [12:59:18.966] sort_input_target = [12:59:18.966] grouping_targets = 0x1 [12:59:18.966] grouping_target_parallel_safe = [12:59:18.966] scanjoin_targets = 0x0 [12:59:18.966] scanjoin_target_parallel_safe = [12:59:18.966] grouping_targets_contain_srfs = 0x1 [12:59:18.966] scanjoin_targets_contain_srfs = 0x55eb99c0fab8 [12:59:18.966] scanjoin_target_same_exprs = [12:59:18.966] parse = 0x55eb9c526d98 [12:59:18.966] offset_est = 0 [12:59:18.966] count_est = 0 [12:59:18.966] limit_tuples = -1 [12:59:18.966] have_postponed_srfs = false [12:59:18.966] final_target = [12:59:18.966] final_targets = 0x55eb9c6271c8 [12:59:18.966] final_targets_contain_srfs = 0x55eb99605ad2 [12:59:18.966] final_target_parallel_safe = [12:59:18.966] current_rel = [12:59:18.966] final_rel = [12:59:18.966] extra = {limit_needed = false, limit_tuples = 4.6674568754554869e-310, count_est = 94470430815544, offset_est = 94470430815544} [12:59:18.966] lc = [12:59:18.966] __func__ = "grouping_planner" [12:59:18.966] #10 0x000055eb996aaa58 in subquery_planner (glob=glob@entry=0x55eb9c73e3a8, parse=parse@entry=0x55eb9c526d98, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [12:59:18.966] root = 0x55eb9c786698 [12:59:18.966] newWithCheckOptions = [12:59:18.966] newHaving = 0x0 [12:59:18.966] hasOuterJoins = [12:59:18.966] hasResultRTEs = false [12:59:18.966] final_rel = [12:59:18.966] l = 0x0 [12:59:18.966] #11 0x000055eb996ab6e9 in standard_planner (parse=0x55eb9c526d98, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [12:59:18.966] result = [12:59:18.966] glob = 0x55eb9c73e3a8 [12:59:18.966] tuple_fraction = 0 [12:59:18.966] root = [12:59:18.966] final_rel = [12:59:18.966] best_path = [12:59:18.966] top_plan = [12:59:18.966] lp = [12:59:18.966] lr = [12:59:18.966] #12 0x000055eb996ac753 in planner (parse=parse@entry=0x55eb9c526d98, query_string=query_string@entry=0x55eb9c525af0 "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 [12:59:18.966] result = [12:59:18.966] #13 0x000055eb9991bd98 in pg_plan_query (querytree=querytree@entry=0x55eb9c526d98, query_string=query_string@entry=0x55eb9c525af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [12:59:18.966] plan = [12:59:18.966] #14 0x000055eb9941e0a2 in standard_ExplainOneQuery (query=0x55eb9c526d98, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55eb9c73e108, queryString=0x55eb9c525af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [12:59:18.966] plan = [12:59:18.966] planstart = [12:59:18.966] planduration = {ticks = 94470378882038} [12:59:18.966] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94470385149870, shared_blks_dirtied = 2233161694, shared_blks_written = 3, local_blks_hit = 4294967392, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94470428323224, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94470385236664}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94470378879419}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94470428323224}} [12:59:18.966] bufusage = {shared_blks_hit = 0, shared_blks_read = 94470381905471, shared_blks_dirtied = 73053098754048, shared_blks_written = 72057594037927936, local_blks_hit = 140700403918496, local_blks_read = 94470428324400, local_blks_dirtied = 94470428323224, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94470384764282, shared_blk_read_time = {ticks = 140700403918496}, shared_blk_write_time = {ticks = 94470384764301}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94470385145453}, temp_blk_read_time = {ticks = 94470428503712}, temp_blk_write_time = {ticks = 64}} [12:59:18.966] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140735426549600, freespace = 10} [12:59:18.966] planner_ctx = 0x0 [12:59:18.966] saved_ctx = 0x0 [12:59:18.966] #15 0x000055eb9941e388 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55eb9c73e108, pstate=pstate@entry=0x55eb9c553158, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [12:59:18.966] No locals. [12:59:18.966] #16 0x000055eb9941f2df in ExplainQuery (pstate=pstate@entry=0x55eb9c553158, stmt=stmt@entry=0x55eb9c526bd8, params=params@entry=0x0, dest=dest@entry=0x55eb9c5530c8) at ../src/backend/commands/explain.c:357 [12:59:18.966] l__state = [12:59:18.966] l = 0x55eb9c7cb260 [12:59:18.966] es = 0x55eb9c73e108 [12:59:18.966] tstate = [12:59:18.966] jstate = [12:59:18.966] query = [12:59:18.966] rewritten = 0x55eb9c7cb248 [12:59:18.966] lc = 0x0 [12:59:18.966] timing_set = false [12:59:18.966] buffers_set = false [12:59:18.966] summary_set = false [12:59:18.966] __func__ = "ExplainQuery" [12:59:18.966] #17 0x000055eb999267b8 in standard_ProcessUtility (pstmt=0x55eb9c526c88, queryString=0x55eb9c525af0 "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=0x55eb9c5530c8, qc=0x7fff851b59e0) at ../src/backend/tcop/utility.c:866 [12:59:18.966] parsetree = 0x55eb9c526bd8 [12:59:18.966] isTopLevel = true [12:59:18.966] isAtomicContext = false [12:59:18.966] pstate = 0x55eb9c553158 [12:59:18.966] readonly_flags = [12:59:18.966] __func__ = "standard_ProcessUtility" [12:59:18.966] #18 0x000055eb99926ee1 in ProcessUtility (pstmt=pstmt@entry=0x55eb9c526c88, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55eb9c5530c8, qc=0x7fff851b59e0) at ../src/backend/tcop/utility.c:523 [12:59:18.966] No locals. [12:59:18.966] #19 0x000055eb9992289f in PortalRunUtility (portal=portal@entry=0x55eb9c5aa900, pstmt=0x55eb9c526c88, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55eb9c5530c8, qc=qc@entry=0x7fff851b59e0) at ../src/backend/tcop/pquery.c:1152 [12:59:18.966] No locals. [12:59:18.966] #20 0x000055eb99923112 in FillPortalStore (portal=portal@entry=0x55eb9c5aa900, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [12:59:18.966] treceiver = 0x55eb9c5530c8 [12:59:18.966] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:59:18.966] __func__ = "FillPortalStore" [12:59:18.966] #21 0x000055eb9992362d in PortalRun (portal=portal@entry=0x55eb9c5aa900, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55eb9c6275d8, altdest=altdest@entry=0x55eb9c6275d8, qc=qc@entry=0x7fff851b5ba0) at ../src/backend/tcop/pquery.c:759 [12:59:18.966] _save_exception_stack = 0x7fff851b5c50 [12:59:18.966] _save_context_stack = 0x0 [12:59:18.966] _local_sigjmp_buf = {{__jmpbuf = {0, 9010157995568772467, 94470428862720, 94470428322896, 94470428322872, 94470428322824, 2964125052491380083, 9010164727904318835}, __mask_was_saved = 0, __saved_mask = {__val = {94470385149870, 2233162543, 4, 94470428322824, 112, 153, 94470428862720, 94470428322896, 94470428322872, 94470428322824, 94470385237073, 1, 2, 153, 94470374492575, 0}}}} [12:59:18.966] _do_rethrow = [12:59:18.966] result = [12:59:18.966] nprocessed = [12:59:18.966] saveTopTransactionResourceOwner = 0x55eb9c5675b8 [12:59:18.966] saveTopTransactionContext = 0x55eb9c5bc920 [12:59:18.966] saveActivePortal = 0x0 [12:59:18.966] saveResourceOwner = 0x55eb9c5675b8 [12:59:18.966] savePortalContext = 0x0 [12:59:18.966] saveMemoryContext = 0x55eb9c5bc920 [12:59:18.966] __func__ = "PortalRun" [12:59:18.966] #22 0x000055eb9991c864 in exec_simple_query (query_string=query_string@entry=0x55eb9c525af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1271 [12:59:18.966] cmdtaglen = 7 [12:59:18.966] snapshot_set = [12:59:18.966] per_parsetree_context = 0x0 [12:59:18.966] plantree_list = 0x55eb9c627588 [12:59:18.966] parsetree = 0x55eb9c526c08 [12:59:18.966] commandTag = [12:59:18.966] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:59:18.966] querytree_list = [12:59:18.966] portal = 0x55eb9c5aa900 [12:59:18.966] receiver = 0x55eb9c6275d8 [12:59:18.966] format = 0 [12:59:18.966] cmdtagname = [12:59:18.966] parsetree_item__state = [12:59:18.966] dest = DestRemote [12:59:18.966] oldcontext = 0x55eb9c5bc920 [12:59:18.966] parsetree_list = 0x55eb9c526c38 [12:59:18.966] parsetree_item = 0x55eb9c526c50 [12:59:18.966] save_log_statement_stats = false [12:59:18.966] was_logged = false [12:59:18.966] use_implicit_block = false [12:59:18.966] msec_str = "\004\000\000\000\000\000\000\000\373\301\275\231\353U\000\0000\\\033\205\377\177\000\000n\000\000\000\000\000\000" [12:59:18.966] __func__ = "exec_simple_query" [12:59:18.966] #23 0x000055eb9991f5bd in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [12:59:18.966] query_string = 0x55eb9c525af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [12:59:18.966] firstchar = [12:59:18.966] input_message = {data = 0x55eb9c525af0 "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} [12:59:18.966] local_sigjmp_buf = {{__jmpbuf = {94470397897080, 9010171463121352051, 140735426551212, 4, 10, 140735426551444, 2964125052558488947, 9010164718014018931}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94470428048912, 15616, 94470397891136, 94470428583280, 10, 94470385149418, 0, 9, 2, 94470397897088, 94470428048912, 94470397891136, 4, 10, 140735426551444}}}} [12:59:18.966] send_ready_for_query = false [12:59:18.966] idle_in_transaction_timeout_enabled = false [12:59:18.966] idle_session_timeout_enabled = false [12:59:18.966] __func__ = "PostgresMain" [12:59:18.966] #24 0x000055eb99915628 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:59:18.966] bsdata = [12:59:18.966] #25 0x000055eb997c6d47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=10, startup_data=startup_data@entry=0x7fff851b5dac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff851b5e00) at ../src/backend/postmaster/launch_backend.c:274 [12:59:18.966] pid = [12:59:18.966] #26 0x000055eb997cbd42 in BackendStartup (client_sock=client_sock@entry=0x7fff851b5e00) at ../src/backend/postmaster/postmaster.c:3386 [12:59:18.966] bn = 0x55eb9c54e218 [12:59:18.966] pid = [12:59:18.966] startup_data = {canAcceptConnections = CAC_OK} [12:59:18.966] cac = [12:59:18.966] __func__ = "BackendStartup" [12:59:18.966] #27 0x000055eb997cdc1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [12:59:18.966] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\310j\367\177\000\000>\004\000\000\000\000\000\000\260\227Ci\367\177\000\000\240?\223j\367\177\000\000\270^\033\205\377\177\000\000\264^\033\205\377\177", '\000' , "\"\246\224\230\353U\000\000\300\207\220\230\353U\000\000\200_\033\205\377\177\000\000x_\033\205\377\177\000\000\225[\362\001\256\247\a\027\240\224(j\367\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [12:59:18.966] i = 0 [12:59:18.966] now = [12:59:18.966] last_lockfile_recheck_time = 1735304041 [12:59:18.966] last_touch_time = 1735304041 [12:59:18.966] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1382427086, events = 0, fd = -2061803584, user_data = 0x0}, {pos = 15, events = 0, fd = -1735088606, user_data = 0x7ff76acb7668}, {pos = 1781044784, events = 32759, fd = 1791718112, user_data = 0x7c96e577}, {pos = -2061803520, events = 32767, fd = 1791547976, user_data = 0xf}, {pos = 1781044784, events = 32759, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1791718112, user_data = 0x7fff851b5f78}, {pos = -2061803648, events = 32767, fd = 1791719016, user_data = 0x0}, {pos = -1672316960, events = 21995, fd = 1766780261, user_data = 0x7fff851b6493}, {pos = 1, events = 0, fd = -2061803648, user_data = 0xffffffff}, {pos = 1765990432, events = 32759, fd = 1788034976, user_data = 0x55eb9c5531c8}, {pos = -1672138584, events = 21995, fd = -1672139135, user_data = 0x7ff76ac93ebe}, {pos = 1, events = 0, fd = 1791718112, user_data = 0x1aa}, {pos = -1709830832, events = 21995, fd = 0, user_data = 0xec}, {pos = -1672324176, events = 21995, fd = 1791573694, user_data = 0x1}, {pos = 0, events = 0, fd = 1765990432, user_data = 0x7ff7694f2e40 }, {pos = 16, events = 0, fd = -2061802560, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7ff76ac961ba}, {pos = 0, events = 0, fd = 1766518180, user_data = 0x0}, {pos = -1702810336, events = 21995, fd = 2, user_data = 0x0}, {pos = -1672577360, events = 21995, fd = 1952410737, user_data = 0x160}, {pos = -1709831424, events = 21995, fd = 8, user_data = 0x2ffff00001fa0}, {pos = -1672324176, events = 21995, fd = 1791573694, user_data = 0x1}, {pos = 1766551661, events = 32759, fd = 1766024392, user_data = 0x55eb9c558510}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1767840864, events = 32759, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55eb9c4e7eb0}, {pos = 1766554250, events = 32759, 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 = 1836207721, fd = 168458347, user_data = 0x33353337310a6174}, {pos = 875574320, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1767823840, events = 32759, fd = 1766461806, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x1707a7ae89424e00}, {pos = 1767826912, events = 32759, fd = -328, user_data = 0x0}, {pos = -1672138904, events = 21995, fd = 1024, user_data = 0x55eb9c552f68}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 21654, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1672324176, user_data = 0x7ff7694f3053 }, {pos = -1672138904, events = 21995, fd = 1024, user_data = 0x7fff851b6488}, {pos = -1715414047, events = 21995, fd = -1702745808, user_data = 0x55eb99bfc69e }, {pos = -1672139104, events = 21995, fd = -1672324624, user_data = 0x55eb9c552ea0}, {pos = 1766545598, events = 32759, fd = 0, user_data = 0x55eb99c0e308 }, {pos = -1672139104, events = 1, fd = -1715411887, user_data = 0x55eb9c5259f0}, {pos = -1992143360, events = 386377646, fd = 0, user_data = 0x7ff7694a2ab1}, {pos = 1766462704, events = 32759, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1672577360, user_data = 0x1707a7ae89424e00}, {pos = 0, events = 0, fd = -1992143360, user_data = 0xc}, {pos = -1992143360, events = 386377646, fd = 0, user_data = 0x7ff76945b239 }, {pos = 237, events = 0, fd = -1719899580, user_data = 0x400000}, {pos = 0, events = 0, fd = -1672577360, user_data = 0x55eb99bfc532 }, {pos = -1672490720, events = 21995, fd = -1672324624, user_data = 0x55eb9c4fd120}, {pos = 1, events = 0, fd = 0, user_data = 0x55eb99bbaccc }, {pos = 12, events = 0, fd = -1672147768, user_data = 0x55eb9c550ca8}, {pos = -1702808928, events = 21995, fd = 296, user_data = 0x55eb997c925e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1719883109, events = 21995, fd = -1706412496, user_data = 0x55eb9c5263c8}} [12:59:18.966] nevents = 1 [12:59:18.966] __func__ = "ServerLoop" [12:59:18.966] #28 0x000055eb997cf49c in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55eb9c4e3d70) at ../src/backend/postmaster/postmaster.c:1371 [12:59:18.966] opt = [12:59:18.966] status = [12:59:18.966] userDoption = [12:59:18.966] listen_addr_saved = false [12:59:18.966] output_config_variable = [12:59:18.966] __func__ = "PostmasterMain" [12:59:18.966] #29 0x000055eb995fbb3e in main (argc=8, argv=0x55eb9c4e3d70) at ../src/backend/main/main.c:230 [12:59:18.966] do_check_root = [12:59:18.966] dispatch_option = [12:59:19.004] -e [12:59:19.004] [12:59:19.004] [12:59:19.068] dumping /tmp/cores/postgres-6-23928.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [12:59:19.324] [New LWP 23928] [12:59:19.324] [12:59:19.324] This GDB supports auto-downloading debuginfo from the following URLs: [12:59:19.324] [12:59:19.324] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:59:19.324] Debuginfod has been disabled. [12:59:19.324] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:59:19.435] [Thread debugging using libthread_db enabled] [12:59:19.435] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:59:19.435] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [12:59:19.435] Program terminated with signal SIGABRT, Aborted. [12:59:19.435] #0 0x00007ff7694a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:20.423] [12:59:20.423] Thread 1 (Thread 0x7ff769c33f00 (LWP 23928)): [12:59:20.423] #0 0x00007ff7694a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:20.423] No symbol table info available. [12:59:20.423] #1 0x00007ff76945afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:20.423] No symbol table info available. [12:59:20.423] #2 0x00007ff769445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:20.423] No symbol table info available. [12:59:20.423] #3 0x00007ff76961e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [12:59:20.423] No locals. [12:59:20.423] #4 0x00007ff76962aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [12:59:20.423] No locals. [12:59:20.423] #5 0x00007ff76960dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55eb9a41c480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [12:59:20.423] bp = 140735426548464 [12:59:20.423] pc = [12:59:20.423] Opts = {FromUnrecoverableHandler = true, pc = 94470379708048, bp = 94470430248688} [12:59:20.423] #6 0x000055eb996c9e90 in examine_self_contradictory_rels (root=root@entry=0x55eb9c6c34d8, rel=rel@entry=0x55eb9c71e678, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [12:59:20.423] lc__state = [12:59:20.423] rlist = [12:59:20.423] i = 2 [12:59:20.423] br = [12:59:20.423] expression = [12:59:20.423] or_rinfo = 0x55eb9c6fde00 [12:59:20.423] ccxt = [12:59:20.423] delidx = 0x55eb9c6fdaf9 [12:59:20.423] arglst = [12:59:20.423] lc = [12:59:20.423] arg = [12:59:20.423] n = [12:59:20.423] restrictinfo = [12:59:20.423] ccwapper = {clausecxt = 0x55eb9c6fd470} [12:59:20.423] sec = {sopcinfo = {n_members = 38, opcies = 0x55eb9c6fcf40}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x55eb9c6fcae0, atop_set = 0x55eb9c6fd350}, ccfree = 0x55eb9c6fda78, vifree = 0x55eb9c6fd510} [12:59:20.423] __func__ = "examine_self_contradictory_rels" [12:59:20.423] #7 0x000055eb996ca09f in examine_self_contradictory_rels_phase1 (root=root@entry=0x55eb9c6c34d8) at ../src/backend/optimizer/plan/contradictory.c:2608 [12:59:20.423] rel = 0x55eb9c71e678 [12:59:20.423] rti = 1 [12:59:20.423] rinfo = [12:59:20.423] #8 0x000055eb99695058 in query_planner (root=root@entry=0x55eb9c6c34d8, qp_callback=qp_callback@entry=0x55eb9969a375 , qp_extra=qp_extra@entry=0x7fff851b54f0) at ../src/backend/optimizer/plan/planmain.c:193 [12:59:20.423] parse = 0x55eb9c526f70 [12:59:20.423] joinlist = 0x55eb9c6fcb50 [12:59:20.423] final_rel = [12:59:20.423] __func__ = "query_planner" [12:59:20.423] #9 0x000055eb996a7ad4 in grouping_planner (root=root@entry=0x55eb9c6c34d8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [12:59:20.423] sort_input_targets = 0x5 [12:59:20.423] sort_input_target_parallel_safe = [12:59:20.423] grouping_target = [12:59:20.423] scanjoin_target = [12:59:20.423] activeWindows = 0x0 [12:59:20.423] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [12:59:20.423] sort_input_targets_contain_srfs = 0x1 [12:59:20.423] have_grouping = [12:59:20.423] wflists = 0x0 [12:59:20.423] gset_data = 0x0 [12:59:20.423] sort_input_target = [12:59:20.423] grouping_targets = 0x1 [12:59:20.423] grouping_target_parallel_safe = [12:59:20.423] scanjoin_targets = 0x0 [12:59:20.423] scanjoin_target_parallel_safe = [12:59:20.423] grouping_targets_contain_srfs = 0x1 [12:59:20.423] scanjoin_targets_contain_srfs = 0x55eb99c0fab8 [12:59:20.423] scanjoin_target_same_exprs = [12:59:20.423] parse = 0x55eb9c526f70 [12:59:20.423] offset_est = 0 [12:59:20.423] count_est = 0 [12:59:20.423] limit_tuples = -1 [12:59:20.423] have_postponed_srfs = false [12:59:20.423] final_target = [12:59:20.423] final_targets = 0x55eb9c71d848 [12:59:20.423] final_targets_contain_srfs = 0x55eb99605ad2 [12:59:20.423] final_target_parallel_safe = [12:59:20.423] current_rel = [12:59:20.423] final_rel = [12:59:20.423] extra = {limit_needed = false, limit_tuples = 4.6674568754554869e-310, count_est = 94470430015960, offset_est = 94470430015960} [12:59:20.423] lc = [12:59:20.423] __func__ = "grouping_planner" [12:59:20.423] #10 0x000055eb996aaa58 in subquery_planner (glob=glob@entry=0x55eb9c6c4788, parse=parse@entry=0x55eb9c526f70, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [12:59:20.423] root = 0x55eb9c6c34d8 [12:59:20.423] newWithCheckOptions = [12:59:20.423] newHaving = 0x0 [12:59:20.423] hasOuterJoins = [12:59:20.423] hasResultRTEs = false [12:59:20.423] final_rel = [12:59:20.423] l = 0x0 [12:59:20.423] #11 0x000055eb996ab6e9 in standard_planner (parse=0x55eb9c526f70, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [12:59:20.423] result = [12:59:20.423] glob = 0x55eb9c6c4788 [12:59:20.423] tuple_fraction = 0 [12:59:20.423] root = [12:59:20.423] final_rel = [12:59:20.423] best_path = [12:59:20.423] top_plan = [12:59:20.423] lp = [12:59:20.423] lr = [12:59:20.423] #12 0x000055eb996ac753 in planner (parse=parse@entry=0x55eb9c526f70, query_string=query_string@entry=0x55eb9c525af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [12:59:20.423] result = [12:59:20.423] #13 0x000055eb9991bd98 in pg_plan_query (querytree=querytree@entry=0x55eb9c526f70, query_string=query_string@entry=0x55eb9c525af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [12:59:20.423] plan = [12:59:20.423] #14 0x000055eb9941e0a2 in standard_ExplainOneQuery (query=0x55eb9c526f70, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55eb9c6c44e8, queryString=0x55eb9c525af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [12:59:20.423] plan = [12:59:20.423] planstart = [12:59:20.423] planduration = {ticks = 94470378882038} [12:59:20.423] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94470385149870, shared_blks_dirtied = 2233161694, shared_blks_written = 3, local_blks_hit = 4294967392, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94470428323696, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94470385236664}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94470378879419}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94470428323696}} [12:59:20.423] bufusage = {shared_blks_hit = 0, shared_blks_read = 94470381905471, shared_blks_dirtied = 128874788700160, shared_blks_written = 72057594037927936, local_blks_hit = 140700402036648, local_blks_read = 94470428324872, local_blks_dirtied = 94470428323696, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94470384764282, shared_blk_read_time = {ticks = 140700402036648}, shared_blk_write_time = {ticks = 94470384764301}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94470385145453}, temp_blk_read_time = {ticks = 94470430066000}, temp_blk_write_time = {ticks = 64}} [12:59:20.423] mem_counters = {nblocks = 94470430385624, freechunks = 4294967297, totalspace = 140735426549600, freespace = 10} [12:59:20.423] planner_ctx = 0x0 [12:59:20.423] saved_ctx = 0x0 [12:59:20.423] #15 0x000055eb9941e388 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55eb9c6c44e8, pstate=pstate@entry=0x55eb9c6d0808, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [12:59:20.423] No locals. [12:59:20.423] #16 0x000055eb9941f2df in ExplainQuery (pstate=pstate@entry=0x55eb9c6d0808, stmt=stmt@entry=0x55eb9c526db0, params=params@entry=0x0, dest=dest@entry=0x55eb9c6d0778) at ../src/backend/commands/explain.c:357 [12:59:20.423] l__state = [12:59:20.423] l = 0x55eb9c71e640 [12:59:20.423] es = 0x55eb9c6c44e8 [12:59:20.423] tstate = [12:59:20.423] jstate = [12:59:20.423] query = [12:59:20.423] rewritten = 0x55eb9c71e628 [12:59:20.423] lc = 0x0 [12:59:20.423] timing_set = false [12:59:20.423] buffers_set = false [12:59:20.423] summary_set = false [12:59:20.423] __func__ = "ExplainQuery" [12:59:20.423] #17 0x000055eb999267b8 in standard_ProcessUtility (pstmt=0x55eb9c526e60, queryString=0x55eb9c525af0 "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=0x55eb9c6d0778, qc=0x7fff851b59e0) at ../src/backend/tcop/utility.c:866 [12:59:20.423] parsetree = 0x55eb9c526db0 [12:59:20.423] isTopLevel = true [12:59:20.423] isAtomicContext = false [12:59:20.423] pstate = 0x55eb9c6d0808 [12:59:20.423] readonly_flags = [12:59:20.423] __func__ = "standard_ProcessUtility" [12:59:20.423] #18 0x000055eb99926ee1 in ProcessUtility (pstmt=pstmt@entry=0x55eb9c526e60, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55eb9c6d0778, qc=0x7fff851b59e0) at ../src/backend/tcop/utility.c:523 [12:59:20.423] No locals. [12:59:20.423] #19 0x000055eb9992289f in PortalRunUtility (portal=portal@entry=0x55eb9c5aa900, pstmt=0x55eb9c526e60, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55eb9c6d0778, qc=qc@entry=0x7fff851b59e0) at ../src/backend/tcop/pquery.c:1152 [12:59:20.423] No locals. [12:59:20.423] #20 0x000055eb99923112 in FillPortalStore (portal=portal@entry=0x55eb9c5aa900, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [12:59:20.423] treceiver = 0x55eb9c6d0778 [12:59:20.423] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:59:20.423] __func__ = "FillPortalStore" [12:59:20.423] #21 0x000055eb9992362d in PortalRun (portal=portal@entry=0x55eb9c5aa900, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55eb9c71db28, altdest=altdest@entry=0x55eb9c71db28, qc=qc@entry=0x7fff851b5ba0) at ../src/backend/tcop/pquery.c:759 [12:59:20.423] _save_exception_stack = 0x7fff851b5c50 [12:59:20.423] _save_context_stack = 0x0 [12:59:20.423] _local_sigjmp_buf = {{__jmpbuf = {0, 9010157846551442803, 94470428862720, 94470428323368, 94470428323344, 94470428323296, 2964125052491380083, 9010164727904318835}, __mask_was_saved = 0, __saved_mask = {__val = {94470385149870, 2233162543, 4, 94470428323296, 112, 153, 94470428862720, 94470428323368, 94470428323344, 94470428323296, 94470385237073, 1, 2, 153, 94470374492575, 0}}}} [12:59:20.423] _do_rethrow = [12:59:20.423] result = [12:59:20.423] nprocessed = [12:59:20.423] saveTopTransactionResourceOwner = 0x55eb9c565f08 [12:59:20.423] saveTopTransactionContext = 0x55eb9c5bc920 [12:59:20.423] saveActivePortal = 0x0 [12:59:20.423] saveResourceOwner = 0x55eb9c565f08 [12:59:20.423] savePortalContext = 0x0 [12:59:20.423] saveMemoryContext = 0x55eb9c5bc920 [12:59:20.423] __func__ = "PortalRun" [12:59:20.423] #22 0x000055eb9991c864 in exec_simple_query (query_string=query_string@entry=0x55eb9c525af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');") at ../src/backend/tcop/postgres.c:1271 [12:59:20.423] cmdtaglen = 7 [12:59:20.423] snapshot_set = [12:59:20.423] per_parsetree_context = 0x0 [12:59:20.423] plantree_list = 0x55eb9c71dad8 [12:59:20.423] parsetree = 0x55eb9c526de0 [12:59:20.423] commandTag = [12:59:20.423] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:59:20.423] querytree_list = [12:59:20.423] portal = 0x55eb9c5aa900 [12:59:20.423] receiver = 0x55eb9c71db28 [12:59:20.423] format = 0 [12:59:20.423] cmdtagname = [12:59:20.423] parsetree_item__state = [12:59:20.423] dest = DestRemote [12:59:20.423] oldcontext = 0x55eb9c5bc920 [12:59:20.423] parsetree_list = 0x55eb9c526e10 [12:59:20.423] parsetree_item = 0x55eb9c526e28 [12:59:20.423] save_log_statement_stats = false [12:59:20.423] was_logged = false [12:59:20.423] use_implicit_block = false [12:59:20.423] msec_str = "\004\000\000\000\000\000\000\000\373\301\275\231\353U\000\0000\\\033\205\377\177\000\000S\000\000\000\000\000\000" [12:59:20.423] __func__ = "exec_simple_query" [12:59:20.423] #23 0x000055eb9991f5bd in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [12:59:20.423] query_string = 0x55eb9c525af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');" [12:59:20.423] firstchar = [12:59:20.423] input_message = {data = 0x55eb9c525af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", len = 83, maxlen = 1024, cursor = 83} [12:59:20.423] local_sigjmp_buf = {{__jmpbuf = {94470397897080, 9010171463121352051, 140735426551212, 4, 12, 140735426551444, 2964125052558488947, 9010164718014018931}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94470428048912, 15616, 94470397891136, 94470428583280, 12, 94470385149418, 0, 9, 2, 94470397897088, 94470428048912, 94470397891136, 4, 12, 140735426551444}}}} [12:59:20.423] send_ready_for_query = false [12:59:20.423] idle_in_transaction_timeout_enabled = false [12:59:20.423] idle_session_timeout_enabled = false [12:59:20.423] __func__ = "PostgresMain" [12:59:20.423] #24 0x000055eb99915628 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:59:20.423] bsdata = [12:59:20.423] #25 0x000055eb997c6d47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=12, startup_data=startup_data@entry=0x7fff851b5dac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff851b5e00) at ../src/backend/postmaster/launch_backend.c:274 [12:59:20.423] pid = [12:59:20.423] #26 0x000055eb997cbd42 in BackendStartup (client_sock=client_sock@entry=0x7fff851b5e00) at ../src/backend/postmaster/postmaster.c:3386 [12:59:20.423] bn = 0x55eb9c54e278 [12:59:20.423] pid = [12:59:20.423] startup_data = {canAcceptConnections = CAC_OK} [12:59:20.423] cac = [12:59:20.423] __func__ = "BackendStartup" [12:59:20.423] #27 0x000055eb997cdc1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [12:59:20.423] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\310j\367\177\000\000>\004\000\000\000\000\000\000\260\227Ci\367\177\000\000\240?\223j\367\177\000\000\270^\033\205\377\177\000\000\264^\033\205\377\177", '\000' , "\"\246\224\230\353U\000\000\300\207\220\230\353U\000\000\200_\033\205\377\177\000\000x_\033\205\377\177\000\000\225[\362\001\256\247\a\027\240\224(j\367\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [12:59:20.423] i = 0 [12:59:20.423] now = [12:59:20.423] last_lockfile_recheck_time = 1735304041 [12:59:20.423] last_touch_time = 1735304041 [12:59:20.423] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 1382427086, events = 0, fd = -2061803584, user_data = 0x0}, {pos = 15, events = 0, fd = -1735088606, user_data = 0x7ff76acb7668}, {pos = 1781044784, events = 32759, fd = 1791718112, user_data = 0x7c96e577}, {pos = -2061803520, events = 32767, fd = 1791547976, user_data = 0xf}, {pos = 1781044784, events = 32759, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1791718112, user_data = 0x7fff851b5f78}, {pos = -2061803648, events = 32767, fd = 1791719016, user_data = 0x0}, {pos = -1672316960, events = 21995, fd = 1766780261, user_data = 0x7fff851b6493}, {pos = 1, events = 0, fd = -2061803648, user_data = 0xffffffff}, {pos = 1765990432, events = 32759, fd = 1788034976, user_data = 0x55eb9c5531c8}, {pos = -1672138584, events = 21995, fd = -1672139135, user_data = 0x7ff76ac93ebe}, {pos = 1, events = 0, fd = 1791718112, user_data = 0x1aa}, {pos = -1709830832, events = 21995, fd = 0, user_data = 0xec}, {pos = -1672324176, events = 21995, fd = 1791573694, user_data = 0x1}, {pos = 0, events = 0, fd = 1765990432, user_data = 0x7ff7694f2e40 }, {pos = 16, events = 0, fd = -2061802560, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7ff76ac961ba}, {pos = 0, events = 0, fd = 1766518180, user_data = 0x0}, {pos = -1702810336, events = 21995, fd = 2, user_data = 0x0}, {pos = -1672577360, events = 21995, fd = 1952410737, user_data = 0x160}, {pos = -1709831424, events = 21995, fd = 8, user_data = 0x2ffff00001fa0}, {pos = -1672324176, events = 21995, fd = 1791573694, user_data = 0x1}, {pos = 1766551661, events = 32759, fd = 1766024392, user_data = 0x55eb9c558510}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1767840864, events = 32759, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55eb9c4e7eb0}, {pos = 1766554250, events = 32759, 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 = 1836207721, fd = 168458347, user_data = 0x33353337310a6174}, {pos = 875574320, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1767823840, events = 32759, fd = 1766461806, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x1707a7ae89424e00}, {pos = 1767826912, events = 32759, fd = -328, user_data = 0x0}, {pos = -1672138904, events = 21995, fd = 1024, user_data = 0x55eb9c552f68}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 21654, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1672324176, user_data = 0x7ff7694f3053 }, {pos = -1672138904, events = 21995, fd = 1024, user_data = 0x7fff851b6488}, {pos = -1715414047, events = 21995, fd = -1702745808, user_data = 0x55eb99bfc69e }, {pos = -1672139104, events = 21995, fd = -1672324624, user_data = 0x55eb9c552ea0}, {pos = 1766545598, events = 32759, fd = 0, user_data = 0x55eb99c0e308 }, {pos = -1672139104, events = 1, fd = -1715411887, user_data = 0x55eb9c5259f0}, {pos = -1992143360, events = 386377646, fd = 0, user_data = 0x7ff7694a2ab1}, {pos = 1766462704, events = 32759, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1672577360, user_data = 0x1707a7ae89424e00}, {pos = 0, events = 0, fd = -1992143360, user_data = 0xc}, {pos = -1992143360, events = 386377646, fd = 0, user_data = 0x7ff76945b239 }, {pos = 237, events = 0, fd = -1719899580, user_data = 0x400000}, {pos = 0, events = 0, fd = -1672577360, user_data = 0x55eb99bfc532 }, {pos = -1672490720, events = 21995, fd = -1672324624, user_data = 0x55eb9c4fd120}, {pos = 1, events = 0, fd = 0, user_data = 0x55eb99bbaccc }, {pos = 12, events = 0, fd = -1672147768, user_data = 0x55eb9c550ca8}, {pos = -1702808928, events = 21995, fd = 296, user_data = 0x55eb997c925e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1719883109, events = 21995, fd = -1706412496, user_data = 0x55eb9c5263c8}} [12:59:20.423] nevents = 1 [12:59:20.423] __func__ = "ServerLoop" [12:59:20.423] #28 0x000055eb997cf49c in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55eb9c4e3d70) at ../src/backend/postmaster/postmaster.c:1371 [12:59:20.423] opt = [12:59:20.423] status = [12:59:20.423] userDoption = [12:59:20.423] listen_addr_saved = false [12:59:20.423] output_config_variable = [12:59:20.423] __func__ = "PostmasterMain" [12:59:20.423] #29 0x000055eb995fbb3e in main (argc=8, argv=0x55eb9c4e3d70) at ../src/backend/main/main.c:230 [12:59:20.423] do_check_root = [12:59:20.423] dispatch_option = [12:59:20.460] -e [12:59:20.460] [12:59:20.460] [12:59:20.548] dumping /tmp/cores/postgres-6-23357.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [12:59:20.794] [New LWP 23357] [12:59:20.794] [12:59:20.794] This GDB supports auto-downloading debuginfo from the following URLs: [12:59:20.794] [12:59:20.794] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:59:20.794] Debuginfod has been disabled. [12:59:20.794] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:59:21.036] [Thread debugging using libthread_db enabled] [12:59:21.036] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:59:21.036] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN '. [12:59:21.036] Program terminated with signal SIGABRT, Aborted. [12:59:21.036] #0 0x00007f7d4dca9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:22.041] [12:59:22.041] Thread 1 (Thread 0x7f7d4e435f00 (LWP 23357)): [12:59:22.041] #0 0x00007f7d4dca9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:22.041] No symbol table info available. [12:59:22.041] #1 0x00007f7d4dc5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:22.041] No symbol table info available. [12:59:22.041] #2 0x00007f7d4dc45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:22.041] No symbol table info available. [12:59:22.041] #3 0x00007f7d4de1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [12:59:22.041] No locals. [12:59:22.041] #4 0x00007f7d4de2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [12:59:22.041] No locals. [12:59:22.041] #5 0x00007f7d4de0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5610ff054480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [12:59:22.041] bp = 140726890181136 [12:59:22.041] pc = [12:59:22.041] Opts = {FromUnrecoverableHandler = true, pc = 94630984031888, bp = 94631027446808} [12:59:22.041] #6 0x00005610fe301e90 in examine_self_contradictory_rels (root=root@entry=0x561100c0a6c8, rel=rel@entry=0x561100c89558, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [12:59:22.041] lc__state = [12:59:22.041] rlist = [12:59:22.041] i = 2 [12:59:22.041] br = [12:59:22.041] expression = [12:59:22.041] or_rinfo = 0x561100c6a168 [12:59:22.041] ccxt = [12:59:22.041] delidx = 0x561100c6a001 [12:59:22.041] arglst = [12:59:22.041] lc = [12:59:22.041] arg = [12:59:22.041] n = [12:59:22.041] restrictinfo = [12:59:22.041] ccwapper = {clausecxt = 0x561100c69998} [12:59:22.041] sec = {sopcinfo = {n_members = 38, opcies = 0x561100c69468}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x561100c68c18, atop_set = 0x561100c69878}, ccfree = 0x561100c69fd0, vifree = 0x561100c69b08} [12:59:22.041] __func__ = "examine_self_contradictory_rels" [12:59:22.041] #7 0x00005610fe30209f in examine_self_contradictory_rels_phase1 (root=root@entry=0x561100c0a6c8) at ../src/backend/optimizer/plan/contradictory.c:2608 [12:59:22.041] rel = 0x561100c89558 [12:59:22.041] rti = 1 [12:59:22.041] rinfo = [12:59:22.041] #8 0x00005610fe2cd058 in query_planner (root=root@entry=0x561100c0a6c8, qp_callback=qp_callback@entry=0x5610fe2d2375 , qp_extra=qp_extra@entry=0x7ffd884cb410) at ../src/backend/optimizer/plan/planmain.c:193 [12:59:22.041] parse = 0x561100960d18 [12:59:22.041] joinlist = 0x561100c68c88 [12:59:22.041] final_rel = [12:59:22.041] __func__ = "query_planner" [12:59:22.041] #9 0x00005610fe2dfad4 in grouping_planner (root=root@entry=0x561100c0a6c8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [12:59:22.041] sort_input_targets = 0x5 [12:59:22.041] sort_input_target_parallel_safe = [12:59:22.041] grouping_target = [12:59:22.041] scanjoin_target = [12:59:22.041] activeWindows = 0x0 [12:59:22.041] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [12:59:22.041] sort_input_targets_contain_srfs = 0x1 [12:59:22.041] have_grouping = [12:59:22.041] wflists = 0x0 [12:59:22.041] gset_data = 0x0 [12:59:22.041] sort_input_target = [12:59:22.041] grouping_targets = 0x1 [12:59:22.041] grouping_target_parallel_safe = [12:59:22.041] scanjoin_targets = 0x0 [12:59:22.041] scanjoin_target_parallel_safe = [12:59:22.041] grouping_targets_contain_srfs = 0x1 [12:59:22.041] scanjoin_targets_contain_srfs = 0x5610fe847ab8 [12:59:22.041] scanjoin_target_same_exprs = [12:59:22.041] parse = 0x561100960d18 [12:59:22.041] offset_est = 0 [12:59:22.041] count_est = 0 [12:59:22.041] limit_tuples = -1 [12:59:22.041] have_postponed_srfs = false [12:59:22.041] final_target = [12:59:22.041] final_targets = 0x561100a609b8 [12:59:22.041] final_targets_contain_srfs = 0x5610fe23dad2 [12:59:22.041] final_target_parallel_safe = [12:59:22.041] current_rel = [12:59:22.041] final_rel = [12:59:22.041] extra = {limit_needed = false, limit_tuples = 4.6753917833537775e-310, count_est = 94631027062120, offset_est = 94631027062120} [12:59:22.041] lc = [12:59:22.041] __func__ = "grouping_planner" [12:59:22.041] #10 0x00005610fe2e2a58 in subquery_planner (glob=glob@entry=0x561100c081b8, parse=parse@entry=0x561100960d18, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [12:59:22.041] root = 0x561100c0a6c8 [12:59:22.041] newWithCheckOptions = [12:59:22.041] newHaving = 0x0 [12:59:22.041] hasOuterJoins = [12:59:22.041] hasResultRTEs = false [12:59:22.041] final_rel = [12:59:22.041] l = 0x0 [12:59:22.041] #11 0x00005610fe2e36e9 in standard_planner (parse=0x561100960d18, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [12:59:22.041] result = [12:59:22.041] glob = 0x561100c081b8 [12:59:22.041] tuple_fraction = 0 [12:59:22.041] root = [12:59:22.041] final_rel = [12:59:22.041] best_path = [12:59:22.041] top_plan = [12:59:22.041] lp = [12:59:22.041] lr = [12:59:22.041] #12 0x00005610fe2e4753 in planner (parse=parse@entry=0x561100960d18, query_string=query_string@entry=0x56110095fa70 "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 [12:59:22.041] result = [12:59:22.041] #13 0x00005610fe553d98 in pg_plan_query (querytree=querytree@entry=0x561100960d18, query_string=query_string@entry=0x56110095fa70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [12:59:22.041] plan = [12:59:22.041] #14 0x00005610fe0560a2 in standard_ExplainOneQuery (query=0x561100960d18, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x561100c07f18, queryString=0x56110095fa70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [12:59:22.041] plan = [12:59:22.041] planstart = [12:59:22.041] planduration = {ticks = 94630983205878} [12:59:22.041] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94630989473710, shared_blks_dirtied = 2286728958, shared_blks_written = 3, local_blks_hit = 4294967392, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94631024266520, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94630989560504}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94630983203259}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94631024266520}} [12:59:22.041] bufusage = {shared_blks_hit = 0, shared_blks_read = 94630986229311, shared_blks_dirtied = 73018739015683, shared_blks_written = 72057594037927936, local_blks_hit = 140175961007776, local_blks_read = 94631024267696, local_blks_dirtied = 94631024266520, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94630989088122, shared_blk_read_time = {ticks = 140175961007776}, shared_blk_write_time = {ticks = 94630989088141}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94630989469293}, temp_blk_read_time = {ticks = 94631024445920}, temp_blk_write_time = {ticks = 64}} [12:59:22.041] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140726890182272, freespace = 10} [12:59:22.041] planner_ctx = 0x0 [12:59:22.041] saved_ctx = 0x0 [12:59:22.041] #15 0x00005610fe056388 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x561100c07f18, pstate=pstate@entry=0x56110098cc98, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [12:59:22.041] No locals. [12:59:22.041] #16 0x00005610fe0572df in ExplainQuery (pstate=pstate@entry=0x56110098cc98, stmt=stmt@entry=0x561100960b58, params=params@entry=0x0, dest=dest@entry=0x56110098cc08) at ../src/backend/commands/explain.c:357 [12:59:22.041] l__state = [12:59:22.041] l = 0x561100c89520 [12:59:22.041] es = 0x561100c07f18 [12:59:22.041] tstate = [12:59:22.041] jstate = [12:59:22.041] query = [12:59:22.041] rewritten = 0x561100c89508 [12:59:22.041] lc = 0x0 [12:59:22.041] timing_set = false [12:59:22.041] buffers_set = false [12:59:22.041] summary_set = false [12:59:22.041] __func__ = "ExplainQuery" [12:59:22.041] #17 0x00005610fe55e7b8 in standard_ProcessUtility (pstmt=0x561100960c08, queryString=0x56110095fa70 "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=0x56110098cc08, qc=0x7ffd884cb900) at ../src/backend/tcop/utility.c:866 [12:59:22.041] parsetree = 0x561100960b58 [12:59:22.041] isTopLevel = true [12:59:22.041] isAtomicContext = false [12:59:22.041] pstate = 0x56110098cc98 [12:59:22.041] readonly_flags = [12:59:22.041] __func__ = "standard_ProcessUtility" [12:59:22.041] #18 0x00005610fe55eee1 in ProcessUtility (pstmt=pstmt@entry=0x561100960c08, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x56110098cc08, qc=0x7ffd884cb900) at ../src/backend/tcop/utility.c:523 [12:59:22.041] No locals. [12:59:22.041] #19 0x00005610fe55a89f in PortalRunUtility (portal=portal@entry=0x5611009e4300, pstmt=0x561100960c08, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x56110098cc08, qc=qc@entry=0x7ffd884cb900) at ../src/backend/tcop/pquery.c:1152 [12:59:22.041] No locals. [12:59:22.041] #20 0x00005610fe55b112 in FillPortalStore (portal=portal@entry=0x5611009e4300, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [12:59:22.041] treceiver = 0x56110098cc08 [12:59:22.041] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:59:22.041] __func__ = "FillPortalStore" [12:59:22.041] #21 0x00005610fe55b62d in PortalRun (portal=portal@entry=0x5611009e4300, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x561100a60dc8, altdest=altdest@entry=0x561100a60dc8, qc=qc@entry=0x7ffd884cbac0) at ../src/backend/tcop/pquery.c:759 [12:59:22.041] _save_exception_stack = 0x7ffd884cbb70 [12:59:22.041] _save_context_stack = 0x0 [12:59:22.041] _local_sigjmp_buf = {{__jmpbuf = {0, 788874999324779376, 94631024804608, 94631024266192, 94631024266168, 94631024266120, 6425427706686514032, 788508470200017776}, __mask_was_saved = 0, __saved_mask = {__val = {94630989473710, 2286729807, 4, 94631024266120, 112, 153, 94631024804608, 94631024266192, 94631024266168, 94631024266120, 94630989560913, 1, 2, 153, 94630978816415, 0}}}} [12:59:22.041] _do_rethrow = [12:59:22.041] result = [12:59:22.041] nprocessed = [12:59:22.041] saveTopTransactionResourceOwner = 0x5611009a14b8 [12:59:22.041] saveTopTransactionContext = 0x5611009f6320 [12:59:22.041] saveActivePortal = 0x0 [12:59:22.041] saveResourceOwner = 0x5611009a14b8 [12:59:22.041] savePortalContext = 0x0 [12:59:22.041] saveMemoryContext = 0x5611009f6320 [12:59:22.041] __func__ = "PortalRun" [12:59:22.041] #22 0x00005610fe554864 in exec_simple_query (query_string=query_string@entry=0x56110095fa70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1271 [12:59:22.041] cmdtaglen = 7 [12:59:22.041] snapshot_set = [12:59:22.041] per_parsetree_context = 0x0 [12:59:22.041] plantree_list = 0x561100a60d78 [12:59:22.041] parsetree = 0x561100960b88 [12:59:22.041] commandTag = [12:59:22.041] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:59:22.041] querytree_list = [12:59:22.041] portal = 0x5611009e4300 [12:59:22.041] receiver = 0x561100a60dc8 [12:59:22.041] format = 0 [12:59:22.041] cmdtagname = [12:59:22.041] parsetree_item__state = [12:59:22.041] dest = DestRemote [12:59:22.041] oldcontext = 0x5611009f6320 [12:59:22.041] parsetree_list = 0x561100960bb8 [12:59:22.041] parsetree_item = 0x561100960bd0 [12:59:22.041] save_log_statement_stats = false [12:59:22.041] was_logged = true [12:59:22.041] use_implicit_block = false [12:59:22.041] msec_str = "\004\000\000\000\000\000\000\000\373A\201\376\020V\000\000P\273L\210\375\177\000\000n\000\000\000\000\000\000" [12:59:22.041] __func__ = "exec_simple_query" [12:59:22.041] #23 0x00005610fe5575bd in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [12:59:22.041] query_string = 0x56110095fa70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [12:59:22.041] firstchar = [12:59:22.041] input_message = {data = 0x56110095fa70 "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} [12:59:22.041] local_sigjmp_buf = {{__jmpbuf = {94631002220920, 788510806355518320, 140726890183884, 4, 16, 140726890184116, 6425427706753622896, 788508472171733872}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94631023992304, 14336, 94631002214976, 94631024526448, 16, 94630989473258, 0, 9, 2, 94631002220928, 94631023992304, 94631002214976, 4, 16, 140726890184116}}}} [12:59:22.041] send_ready_for_query = false [12:59:22.041] idle_in_transaction_timeout_enabled = false [12:59:22.041] idle_session_timeout_enabled = false [12:59:22.041] __func__ = "PostgresMain" [12:59:22.041] #24 0x00005610fe54d628 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:59:22.041] bsdata = [12:59:22.041] #25 0x00005610fe3fed47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=16, startup_data=startup_data@entry=0x7ffd884cbccc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd884cbd20) at ../src/backend/postmaster/launch_backend.c:274 [12:59:22.041] pid = [12:59:22.041] #26 0x00005610fe403d42 in BackendStartup (client_sock=client_sock@entry=0x7ffd884cbd20) at ../src/backend/postmaster/postmaster.c:3386 [12:59:22.041] bn = 0x561100988238 [12:59:22.041] pid = [12:59:22.041] startup_data = {canAcceptConnections = CAC_OK} [12:59:22.041] cac = [12:59:22.041] __func__ = "BackendStartup" [12:59:22.041] #27 0x00005610fe405c1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [12:59:22.041] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "L\210\375\177\000\000\264\275L\210\375\177", '\000' , "\"&X\375\020V\000\000\300\aT\375\020V\000\000\200\276L\210\375\177\000\000x\276L\210\375\177\000\000\225[\362\001\000\000\000\000\240\004\251N}\177\000\000+", '\000' , "0%X\375\020V\000\000h&\\O}\177\000\0000\006\251N}\177\000", __ss_align = 140176179077856}, salen = 2}} [12:59:22.041] i = 0 [12:59:22.041] now = [12:59:22.041] last_lockfile_recheck_time = 1735304043 [12:59:22.041] last_touch_time = 1735304043 [12:59:22.041] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -44554718, events = 22032, fd = 1331439208, user_data = 0x7f7d4ea90630}, {pos = 1331438304, events = 32637, fd = 2090263927, user_data = 0x7ffd884cbf00}, {pos = 1331268168, events = 32637, fd = 15, user_data = 0x7f7d4ea90630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1331438304, events = 32637, fd = -2008236424, user_data = 0x7ffd884cbe80}, {pos = 1331439208, events = 32637, fd = 0, user_data = 0x56110095fa88}, {pos = -24641371, events = 22032, fd = 32768, user_data = 0x1}, {pos = 9836320, events = 22033, fd = -1, user_data = 0x7f7d4dc2e020}, {pos = 1327210400, events = 32637, fd = 10013960, user_data = 0x56110098cbe8}, {pos = 10013121, events = 22033, fd = 1331293886, user_data = 0x1}, {pos = 1331438304, events = 32637, fd = 426, user_data = 0x5610fed98d50 }, {pos = 0, events = 0, fd = 216, user_data = 0x56110095fa88}, {pos = 1331293886, events = 32637, fd = 1, user_data = 0x0}, {pos = 1304616992, events = 32637, fd = 1305423424, user_data = 0x10}, {pos = -2008235296, events = 32765, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1331302842, user_data = 0x0}, {pos = 1305144740, events = 32637, fd = 0, user_data = 0x5610ff44ad20 }, {pos = 2, events = 0, fd = 0, user_data = 0x561100921e90}, {pos = -28412943, events = 22032, fd = 10036331, user_data = 0x5610fe4eb02a }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x56110095fa88}, {pos = 1331293886, events = 32637, fd = 1, user_data = 0x0}, {pos = 1304650952, events = 32637, fd = 1305069696, user_data = 0x437}, {pos = 1305178221, events = 32637, fd = 2, user_data = 0x561100992410}, {pos = 255, events = 0, fd = 0, user_data = 0x0}, {pos = 1306467424, events = 32637, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 794915937, events = 808476532, fd = 1735417650, user_data = 0x5f67702f6e757274}, {pos = 1919381621, events = 795173985, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xa}, {pos = -24963475, events = 22032, fd = 10018832, user_data = 0x7f7d4dcb58be}, {pos = 1306450400, events = 32637, fd = 1305088366, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x4b3d110a83d7b400}, {pos = 1306453472, events = 32637, 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 = 10013352, user_data = 0x3}, {pos = 0, events = 0, fd = 22123, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 9829000, user_data = 0x7f7d4dcf3053 }, {pos = 10013352, events = 22033, fd = 1024, user_data = 0x7ffd884cc3a8}, {pos = -24880159, events = 22032, fd = -12211920, user_data = 0x5610fe83469e }, {pos = 10013152, events = 22033, fd = 9828720, user_data = 0x56110098c9e0}, {pos = 1305172158, events = 32637, fd = 0, user_data = 0x5610fe846308 }, {pos = 10013152, events = 1, fd = -24877999, user_data = 0x56110095f970}, {pos = -2083015680, events = 1262293258, fd = 0, user_data = 0x7f7d4dca2ab1}, {pos = 1305089264, events = 32637, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 9576080, user_data = 0x4b3d110a83d7b400}, {pos = 0, events = 0, fd = -2083015680, user_data = 0xc}, {pos = -2083015680, events = 1262293258, fd = 0, user_data = 0x7f7d4dc5b239 }, {pos = 217, events = 0, fd = -29365692, user_data = 0x400000}, {pos = 0, events = 0, fd = 9576080, user_data = 0x5610fe834532 }, {pos = 9662624, events = 22033, fd = 9828720, user_data = 0x5611009370a0}, {pos = 1, events = 0, fd = 0, user_data = 0x5610fe7f2ccc }, {pos = 12, events = 0, fd = 10004488, user_data = 0x56110098a7e8}, {pos = -12275040, events = 22032, fd = 296, user_data = 0x5610fe40125e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -29349221, events = 22032, fd = -15878608, user_data = 0x561100960318}} [12:59:22.041] nevents = 1 [12:59:22.041] __func__ = "ServerLoop" [12:59:22.041] #28 0x00005610fe40749c in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x56110091dd00) at ../src/backend/postmaster/postmaster.c:1371 [12:59:22.041] opt = [12:59:22.041] status = [12:59:22.041] userDoption = [12:59:22.041] listen_addr_saved = false [12:59:22.041] output_config_variable = [12:59:22.041] __func__ = "PostmasterMain" [12:59:22.041] #29 0x00005610fe233b3e in main (argc=4, argv=0x56110091dd00) at ../src/backend/main/main.c:230 [12:59:22.041] do_check_root = [12:59:22.041] dispatch_option = [12:59:22.077] -e [12:59:22.077] [12:59:22.077] [12:59:22.139] dumping /tmp/cores/postgres-6-28287.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [12:59:22.392] [New LWP 28287] [12:59:22.392] [12:59:22.392] This GDB supports auto-downloading debuginfo from the following URLs: [12:59:22.392] [12:59:22.392] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:59:22.392] Debuginfod has been disabled. [12:59:22.392] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:59:22.496] [Thread debugging using libthread_db enabled] [12:59:22.496] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:59:22.496] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [12:59:22.496] Program terminated with signal SIGABRT, Aborted. [12:59:22.496] #0 0x00007ff7694a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:23.489] [12:59:23.489] Thread 1 (Thread 0x7ff769c33f00 (LWP 28287)): [12:59:23.489] #0 0x00007ff7694a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:23.489] No symbol table info available. [12:59:23.489] #1 0x00007ff76945afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:23.489] No symbol table info available. [12:59:23.489] #2 0x00007ff769445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:23.489] No symbol table info available. [12:59:23.489] #3 0x00007ff76961e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [12:59:23.489] No locals. [12:59:23.489] #4 0x00007ff76962aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [12:59:23.489] No locals. [12:59:23.489] #5 0x00007ff76960dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55eb9a41c480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [12:59:23.489] bp = 140735426548464 [12:59:23.489] pc = [12:59:23.489] Opts = {FromUnrecoverableHandler = true, pc = 94470379708048, bp = 94470428709864} [12:59:23.489] #6 0x000055eb996c9e90 in examine_self_contradictory_rels (root=root@entry=0x55eb9c61f448, rel=rel@entry=0x55eb9c621d08, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [12:59:23.489] lc__state = [12:59:23.489] rlist = [12:59:23.489] i = 2 [12:59:23.489] br = [12:59:23.489] expression = [12:59:23.489] or_rinfo = 0x55eb9c585fc8 [12:59:23.489] ccxt = [12:59:23.489] delidx = 0x55eb9c585f61 [12:59:23.489] arglst = [12:59:23.489] lc = [12:59:23.489] arg = [12:59:23.489] n = [12:59:23.489] restrictinfo = [12:59:23.489] ccwapper = {clausecxt = 0x55eb9c5858c8} [12:59:23.489] sec = {sopcinfo = {n_members = 38, opcies = 0x55eb9c585438}, attrsdc = {min_attr = -6, max_attr = 5, len_set = 2, atop_array = 0x55eb9c584b28, atop_set = 0x55eb9c584ca8}, ccfree = 0x55eb9c585f30, vifree = 0x55eb9c585ad0} [12:59:23.489] __func__ = "examine_self_contradictory_rels" [12:59:23.489] #7 0x000055eb996ca09f in examine_self_contradictory_rels_phase1 (root=root@entry=0x55eb9c61f448) at ../src/backend/optimizer/plan/contradictory.c:2608 [12:59:23.489] rel = 0x55eb9c621d08 [12:59:23.489] rti = 1 [12:59:23.489] rinfo = [12:59:23.489] #8 0x000055eb99695058 in query_planner (root=root@entry=0x55eb9c61f448, qp_callback=qp_callback@entry=0x55eb9969a375 , qp_extra=qp_extra@entry=0x7fff851b54f0) at ../src/backend/optimizer/plan/planmain.c:193 [12:59:23.489] parse = 0x55eb9c5270e0 [12:59:23.489] joinlist = 0x55eb9c584d18 [12:59:23.489] final_rel = [12:59:23.489] __func__ = "query_planner" [12:59:23.489] #9 0x000055eb996a7ad4 in grouping_planner (root=root@entry=0x55eb9c61f448, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [12:59:23.489] sort_input_targets = 0x5 [12:59:23.489] sort_input_target_parallel_safe = [12:59:23.489] grouping_target = [12:59:23.489] scanjoin_target = [12:59:23.489] activeWindows = 0x0 [12:59:23.489] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [12:59:23.489] sort_input_targets_contain_srfs = 0x1 [12:59:23.489] have_grouping = [12:59:23.489] wflists = 0x0 [12:59:23.489] gset_data = 0x0 [12:59:23.489] sort_input_target = [12:59:23.489] grouping_targets = 0x1 [12:59:23.489] grouping_target_parallel_safe = [12:59:23.489] scanjoin_targets = 0x0 [12:59:23.489] scanjoin_target_parallel_safe = [12:59:23.489] grouping_targets_contain_srfs = 0x1 [12:59:23.489] scanjoin_targets_contain_srfs = 0x55eb99c0fab8 [12:59:23.489] scanjoin_target_same_exprs = [12:59:23.489] parse = 0x55eb9c5270e0 [12:59:23.489] offset_est = 0 [12:59:23.489] count_est = 0 [12:59:23.489] limit_tuples = -1 [12:59:23.489] have_postponed_srfs = false [12:59:23.489] final_target = [12:59:23.489] final_targets = 0x55eb9c6084f8 [12:59:23.489] final_targets_contain_srfs = 0x55eb99605ad2 [12:59:23.489] final_target_parallel_safe = [12:59:23.489] current_rel = [12:59:23.489] final_rel = [12:59:23.489] extra = {limit_needed = false, limit_tuples = 4.6674568754554869e-310, count_est = 94470429344488, offset_est = 94470429344488} [12:59:23.489] lc = [12:59:23.489] __func__ = "grouping_planner" [12:59:23.489] #10 0x000055eb996aaa58 in subquery_planner (glob=glob@entry=0x55eb9c6216e8, parse=parse@entry=0x55eb9c5270e0, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [12:59:23.489] root = 0x55eb9c61f448 [12:59:23.489] newWithCheckOptions = [12:59:23.489] newHaving = 0x0 [12:59:23.489] hasOuterJoins = [12:59:23.489] hasResultRTEs = false [12:59:23.489] final_rel = [12:59:23.489] l = 0x0 [12:59:23.489] #11 0x000055eb996ab6e9 in standard_planner (parse=0x55eb9c5270e0, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [12:59:23.489] result = [12:59:23.489] glob = 0x55eb9c6216e8 [12:59:23.489] tuple_fraction = 0 [12:59:23.489] root = [12:59:23.489] final_rel = [12:59:23.489] best_path = [12:59:23.489] top_plan = [12:59:23.489] lp = [12:59:23.489] lr = [12:59:23.489] #12 0x000055eb996ac753 in planner (parse=parse@entry=0x55eb9c5270e0, query_string=query_string@entry=0x55eb9c525af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [12:59:23.489] result = [12:59:23.489] #13 0x000055eb9991bd98 in pg_plan_query (querytree=querytree@entry=0x55eb9c5270e0, query_string=query_string@entry=0x55eb9c525af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [12:59:23.489] plan = [12:59:23.489] #14 0x000055eb9941e0a2 in standard_ExplainOneQuery (query=0x55eb9c5270e0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55eb9c621448, queryString=0x55eb9c525af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [12:59:23.489] plan = [12:59:23.489] planstart = [12:59:23.489] planduration = {ticks = 94470378882038} [12:59:23.489] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94470385149870, shared_blks_dirtied = 2233161694, shared_blks_written = 3, local_blks_hit = 4294967392, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94470428324064, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 94470385236664}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94470378879419}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94470428324064}} [12:59:23.489] bufusage = {shared_blks_hit = 0, shared_blks_read = 94470381905471, shared_blks_dirtied = 192972880625664, shared_blks_written = 72057594037927936, local_blks_hit = 140700404450920, local_blks_read = 94470428325456, local_blks_dirtied = 94470428324064, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94470384764282, shared_blk_read_time = {ticks = 140700404450920}, shared_blk_write_time = {ticks = 94470384764301}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94470385145453}, temp_blk_read_time = {ticks = 94470429178960}, temp_blk_write_time = {ticks = 64}} [12:59:23.489] mem_counters = {nblocks = 94470429351016, freechunks = 4294967297, totalspace = 140735426549600, freespace = 10} [12:59:23.489] planner_ctx = 0x0 [12:59:23.489] saved_ctx = 0x0 [12:59:23.489] #15 0x000055eb9941e388 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55eb9c621448, pstate=pstate@entry=0x55eb9c5f7f08, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [12:59:23.489] No locals. [12:59:23.489] #16 0x000055eb9941f2df in ExplainQuery (pstate=pstate@entry=0x55eb9c5f7f08, stmt=stmt@entry=0x55eb9c526f20, params=params@entry=0x0, dest=dest@entry=0x55eb9c5f7e78) at ../src/backend/commands/explain.c:357 [12:59:23.489] l__state = [12:59:23.489] l = 0x55eb9c621cd0 [12:59:23.489] es = 0x55eb9c621448 [12:59:23.489] tstate = [12:59:23.489] jstate = [12:59:23.489] query = [12:59:23.489] rewritten = 0x55eb9c621cb8 [12:59:23.489] lc = 0x0 [12:59:23.489] timing_set = false [12:59:23.489] buffers_set = false [12:59:23.489] summary_set = false [12:59:23.489] __func__ = "ExplainQuery" [12:59:23.489] #17 0x000055eb999267b8 in standard_ProcessUtility (pstmt=0x55eb9c526fd0, queryString=0x55eb9c525af0 "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=0x55eb9c5f7e78, qc=0x7fff851b59e0) at ../src/backend/tcop/utility.c:866 [12:59:23.489] parsetree = 0x55eb9c526f20 [12:59:23.489] isTopLevel = true [12:59:23.489] isAtomicContext = false [12:59:23.489] pstate = 0x55eb9c5f7f08 [12:59:23.489] readonly_flags = [12:59:23.489] __func__ = "standard_ProcessUtility" [12:59:23.489] #18 0x000055eb99926ee1 in ProcessUtility (pstmt=pstmt@entry=0x55eb9c526fd0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55eb9c5f7e78, qc=0x7fff851b59e0) at ../src/backend/tcop/utility.c:523 [12:59:23.489] No locals. [12:59:23.489] #19 0x000055eb9992289f in PortalRunUtility (portal=portal@entry=0x55eb9c5aa900, pstmt=0x55eb9c526fd0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55eb9c5f7e78, qc=qc@entry=0x7fff851b59e0) at ../src/backend/tcop/pquery.c:1152 [12:59:23.489] No locals. [12:59:23.489] #20 0x000055eb99923112 in FillPortalStore (portal=portal@entry=0x55eb9c5aa900, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1025 [12:59:23.489] treceiver = 0x55eb9c5f7e78 [12:59:23.489] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:59:23.489] __func__ = "FillPortalStore" [12:59:23.489] #21 0x000055eb9992362d in PortalRun (portal=portal@entry=0x55eb9c5aa900, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55eb9c6087d8, altdest=altdest@entry=0x55eb9c6087d8, qc=qc@entry=0x7fff851b5ba0) at ../src/backend/tcop/pquery.c:759 [12:59:23.489] _save_exception_stack = 0x7fff851b5c50 [12:59:23.489] _save_context_stack = 0x0 [12:59:23.489] _local_sigjmp_buf = {{__jmpbuf = {0, 9010157973624173939, 94470428862720, 94470428323736, 94470428323712, 94470428323664, 2964125052491380083, 9010164727904318835}, __mask_was_saved = 0, __saved_mask = {__val = {94470385149870, 2233162543, 4, 94470428323664, 112, 153, 94470428862720, 94470428323736, 94470428323712, 94470428323664, 94470385237073, 1, 2, 153, 94470374492575, 0}}}} [12:59:23.489] _do_rethrow = [12:59:23.489] result = [12:59:23.489] nprocessed = [12:59:23.489] saveTopTransactionResourceOwner = 0x55eb9c567e58 [12:59:23.489] saveTopTransactionContext = 0x55eb9c5bc920 [12:59:23.489] saveActivePortal = 0x0 [12:59:23.489] saveResourceOwner = 0x55eb9c567e58 [12:59:23.489] savePortalContext = 0x0 [12:59:23.489] saveMemoryContext = 0x55eb9c5bc920 [12:59:23.489] __func__ = "PortalRun" [12:59:23.489] #22 0x000055eb9991c864 in exec_simple_query (query_string=query_string@entry=0x55eb9c525af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;") at ../src/backend/tcop/postgres.c:1271 [12:59:23.489] cmdtaglen = 7 [12:59:23.489] snapshot_set = [12:59:23.489] per_parsetree_context = 0x0 [12:59:23.489] plantree_list = 0x55eb9c608788 [12:59:23.489] parsetree = 0x55eb9c526f50 [12:59:23.489] commandTag = [12:59:23.489] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:59:23.489] querytree_list = [12:59:23.489] portal = 0x55eb9c5aa900 [12:59:23.489] receiver = 0x55eb9c6087d8 [12:59:23.489] format = 0 [12:59:23.489] cmdtagname = [12:59:23.489] parsetree_item__state = [12:59:23.489] dest = DestRemote [12:59:23.489] oldcontext = 0x55eb9c5bc920 [12:59:23.489] parsetree_list = 0x55eb9c526f80 [12:59:23.489] parsetree_item = 0x55eb9c526f98 [12:59:23.489] save_log_statement_stats = false [12:59:23.489] was_logged = false [12:59:23.489] use_implicit_block = false [12:59:23.489] msec_str = "\004\000\000\000\000\000\000\000\373\301\275\231\353U\000\0000\\\033\205\377\177\000\000J\000\000\000\000\000\000" [12:59:23.489] __func__ = "exec_simple_query" [12:59:23.489] #23 0x000055eb9991f5bd in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [12:59:23.489] query_string = 0x55eb9c525af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;" [12:59:23.489] firstchar = [12:59:23.489] input_message = {data = 0x55eb9c525af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", len = 74, maxlen = 1024, cursor = 74} [12:59:23.489] local_sigjmp_buf = {{__jmpbuf = {94470397897080, 9010171463121352051, 140735426551212, 4, 8, 140735426551444, 2964125052558488947, 9010164718014018931}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94470428048912, 15616, 94470397891136, 94470428583280, 8, 94470385149418, 0, 9, 2, 94470397897088, 94470428048912, 94470397891136, 4, 8, 140735426551444}}}} [12:59:23.489] send_ready_for_query = false [12:59:23.489] idle_in_transaction_timeout_enabled = false [12:59:23.489] idle_session_timeout_enabled = false [12:59:23.489] __func__ = "PostgresMain" [12:59:23.489] #24 0x000055eb99915628 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:59:23.489] bsdata = [12:59:23.489] #25 0x000055eb997c6d47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=8, startup_data=startup_data@entry=0x7fff851b5dac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff851b5e00) at ../src/backend/postmaster/launch_backend.c:274 [12:59:23.489] pid = [12:59:23.489] #26 0x000055eb997cbd42 in BackendStartup (client_sock=client_sock@entry=0x7fff851b5e00) at ../src/backend/postmaster/postmaster.c:3386 [12:59:23.489] bn = 0x55eb9c54e1b8 [12:59:23.489] pid = [12:59:23.489] startup_data = {canAcceptConnections = CAC_OK} [12:59:23.489] cac = [12:59:23.489] __func__ = "BackendStartup" [12:59:23.489] #27 0x000055eb997cdc1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [12:59:23.489] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\310j\367\177\000\000>\004\000\000\000\000\000\000\260\227Ci\367\177\000\000\240?\223j\367\177\000\000\270^\033\205\377\177\000\000\264^\033\205\377\177", '\000' , "\"\246\224\230\353U\000\000\300\207\220\230\353U\000\000\200_\033\205\377\177\000\000x_\033\205\377\177\000\000\225[\362\001\256\247\a\027\240\224(j\367\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [12:59:23.489] i = 0 [12:59:23.489] now = [12:59:23.489] last_lockfile_recheck_time = 1735304041 [12:59:23.489] last_touch_time = 1735304041 [12:59:23.489] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = -2061803584, user_data = 0x0}, {pos = 15, events = 0, fd = -1735088606, user_data = 0x7ff76acb7668}, {pos = 1781044784, events = 32759, fd = 1791718112, user_data = 0x7c96e577}, {pos = -2061803520, events = 32767, fd = 1791547976, user_data = 0xf}, {pos = 1781044784, events = 32759, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1791718112, user_data = 0x7fff851b5f78}, {pos = -2061803648, events = 32767, fd = 1791719016, user_data = 0x0}, {pos = -1672316960, events = 21995, fd = 1766780261, user_data = 0x7fff851b6493}, {pos = 1, events = 0, fd = -2061803648, user_data = 0xffffffff}, {pos = 1765990432, events = 32759, fd = 1788034976, user_data = 0x55eb9c5531c8}, {pos = -1672138584, events = 21995, fd = -1672139135, user_data = 0x7ff76ac93ebe}, {pos = 1, events = 0, fd = 1791718112, user_data = 0x1aa}, {pos = -1709830832, events = 21995, fd = 0, user_data = 0xec}, {pos = -1672324176, events = 21995, fd = 1791573694, user_data = 0x1}, {pos = 0, events = 0, fd = 1765990432, user_data = 0x7ff7694f2e40 }, {pos = 16, events = 0, fd = -2061802560, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7ff76ac961ba}, {pos = 0, events = 0, fd = 1766518180, user_data = 0x0}, {pos = -1702810336, events = 21995, fd = 2, user_data = 0x0}, {pos = -1672577360, events = 21995, fd = 1952410737, user_data = 0x160}, {pos = -1709831424, events = 21995, fd = 8, user_data = 0x2ffff00001fa0}, {pos = -1672324176, events = 21995, fd = 1791573694, user_data = 0x1}, {pos = 1766551661, events = 32759, fd = 1766024392, user_data = 0x55eb9c558510}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1767840864, events = 32759, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55eb9c4e7eb0}, {pos = 1766554250, events = 32759, 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 = 1836207721, fd = 168458347, user_data = 0x33353337310a6174}, {pos = 875574320, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1767823840, events = 32759, fd = 1766461806, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x1707a7ae89424e00}, {pos = 1767826912, events = 32759, fd = -328, user_data = 0x0}, {pos = -1672138904, events = 21995, fd = 1024, user_data = 0x55eb9c552f68}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 21654, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1672324176, user_data = 0x7ff7694f3053 }, {pos = -1672138904, events = 21995, fd = 1024, user_data = 0x7fff851b6488}, {pos = -1715414047, events = 21995, fd = -1702745808, user_data = 0x55eb99bfc69e }, {pos = -1672139104, events = 21995, fd = -1672324624, user_data = 0x55eb9c552ea0}, {pos = 1766545598, events = 32759, fd = 0, user_data = 0x55eb99c0e308 }, {pos = -1672139104, events = 1, fd = -1715411887, user_data = 0x55eb9c5259f0}, {pos = -1992143360, events = 386377646, fd = 0, user_data = 0x7ff7694a2ab1}, {pos = 1766462704, events = 32759, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1672577360, user_data = 0x1707a7ae89424e00}, {pos = 0, events = 0, fd = -1992143360, user_data = 0xc}, {pos = -1992143360, events = 386377646, fd = 0, user_data = 0x7ff76945b239 }, {pos = 237, events = 0, fd = -1719899580, user_data = 0x400000}, {pos = 0, events = 0, fd = -1672577360, user_data = 0x55eb99bfc532 }, {pos = -1672490720, events = 21995, fd = -1672324624, user_data = 0x55eb9c4fd120}, {pos = 1, events = 0, fd = 0, user_data = 0x55eb99bbaccc }, {pos = 12, events = 0, fd = -1672147768, user_data = 0x55eb9c550ca8}, {pos = -1702808928, events = 21995, fd = 296, user_data = 0x55eb997c925e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1719883109, events = 21995, fd = -1706412496, user_data = 0x55eb9c5263c8}} [12:59:23.489] nevents = 1 [12:59:23.489] __func__ = "ServerLoop" [12:59:23.489] #28 0x000055eb997cf49c in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55eb9c4e3d70) at ../src/backend/postmaster/postmaster.c:1371 [12:59:23.489] opt = [12:59:23.489] status = [12:59:23.489] userDoption = [12:59:23.489] listen_addr_saved = false [12:59:23.489] output_config_variable = [12:59:23.489] __func__ = "PostmasterMain" [12:59:23.489] #29 0x000055eb995fbb3e in main (argc=8, argv=0x55eb9c4e3d70) at ../src/backend/main/main.c:230 [12:59:23.489] do_check_root = [12:59:23.489] dispatch_option = [12:59:23.525] -e [12:59:23.525] [12:59:23.525] [12:59:23.590] dumping /tmp/cores/postgres-6-26292.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [12:59:23.848] [New LWP 26292] [12:59:23.848] [12:59:23.848] This GDB supports auto-downloading debuginfo from the following URLs: [12:59:23.848] [12:59:23.848] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:59:23.848] Debuginfod has been disabled. [12:59:23.848] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:59:23.955] [Thread debugging using libthread_db enabled] [12:59:23.955] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:59:23.955] Core was generated by `postgres: postgres regression [local] SELECT '. [12:59:23.955] Program terminated with signal SIGABRT, Aborted. [12:59:23.955] #0 0x00007ff7694a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:25.031] [12:59:25.031] Thread 1 (Thread 0x7ff769c33f00 (LWP 26292)): [12:59:25.031] #0 0x00007ff7694a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:25.031] No symbol table info available. [12:59:25.031] #1 0x00007ff76945afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:25.031] No symbol table info available. [12:59:25.031] #2 0x00007ff769445472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:25.031] No symbol table info available. [12:59:25.031] #3 0x00007ff76961e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [12:59:25.031] No locals. [12:59:25.031] #4 0x00007ff76962aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [12:59:25.031] No locals. [12:59:25.031] #5 0x00007ff76960dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55eb9a41c480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [12:59:25.031] bp = 140735426546096 [12:59:25.031] pc = [12:59:25.031] Opts = {FromUnrecoverableHandler = true, pc = 94470379708048, bp = 94470429784312} [12:59:25.031] #6 0x000055eb996c9e90 in examine_self_contradictory_rels (root=root@entry=0x55eb9c682738, rel=rel@entry=0x55eb9c6835a8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [12:59:25.031] lc__state = [12:59:25.031] rlist = [12:59:25.031] i = 3 [12:59:25.031] br = [12:59:25.031] expression = [12:59:25.031] or_rinfo = 0x55eb9c68c688 [12:59:25.031] ccxt = [12:59:25.031] delidx = 0x55eb9c68ce09 [12:59:25.031] arglst = [12:59:25.031] lc = [12:59:25.031] arg = [12:59:25.031] n = [12:59:25.031] restrictinfo = [12:59:25.031] ccwapper = {clausecxt = 0x55eb9c68c3c8} [12:59:25.031] sec = {sopcinfo = {n_members = 38, opcies = 0x55eb9c68bab8}, attrsdc = {min_attr = -6, max_attr = 7, len_set = 2, atop_array = 0x55eb9c684038, atop_set = 0x55eb9c6845c8}, ccfree = 0x55eb9c6846c8, vifree = 0x55eb9c68c9f8} [12:59:25.031] __func__ = "examine_self_contradictory_rels" [12:59:25.031] #7 0x000055eb996ca09f in examine_self_contradictory_rels_phase1 (root=root@entry=0x55eb9c682738) at ../src/backend/optimizer/plan/contradictory.c:2608 [12:59:25.031] rel = 0x55eb9c6835a8 [12:59:25.031] rti = 1 [12:59:25.031] rinfo = [12:59:25.031] #8 0x000055eb99695058 in query_planner (root=root@entry=0x55eb9c682738, qp_callback=qp_callback@entry=0x55eb9969a375 , qp_extra=qp_extra@entry=0x7fff851b4bb0) at ../src/backend/optimizer/plan/planmain.c:193 [12:59:25.031] parse = 0x55eb9c67df08 [12:59:25.031] joinlist = 0x55eb9c684638 [12:59:25.031] final_rel = [12:59:25.031] __func__ = "query_planner" [12:59:25.031] #9 0x000055eb996a7ad4 in grouping_planner (root=root@entry=0x55eb9c682738, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [12:59:25.031] sort_input_targets = 0x55eb9c683498 [12:59:25.031] sort_input_target_parallel_safe = [12:59:25.031] grouping_target = [12:59:25.031] scanjoin_target = [12:59:25.031] activeWindows = 0x0 [12:59:25.031] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [12:59:25.031] sort_input_targets_contain_srfs = 0x2 [12:59:25.031] have_grouping = [12:59:25.031] wflists = 0x0 [12:59:25.031] gset_data = 0x0 [12:59:25.031] sort_input_target = [12:59:25.031] grouping_targets = 0x0 [12:59:25.031] grouping_target_parallel_safe = [12:59:25.031] scanjoin_targets = 0x55eb9c682738 [12:59:25.031] scanjoin_target_parallel_safe = [12:59:25.031] grouping_targets_contain_srfs = 0x55eb9c683538 [12:59:25.031] scanjoin_targets_contain_srfs = 0x0 [12:59:25.031] scanjoin_target_same_exprs = [12:59:25.031] parse = 0x55eb9c67df08 [12:59:25.031] offset_est = 0 [12:59:25.031] count_est = 0 [12:59:25.031] limit_tuples = -1 [12:59:25.031] have_postponed_srfs = false [12:59:25.031] final_target = [12:59:25.031] final_targets = 0x55eb9c6bd5a8 [12:59:25.031] final_targets_contain_srfs = 0x55eb996e8d78 [12:59:25.031] final_target_parallel_safe = [12:59:25.031] current_rel = [12:59:25.031] final_rel = [12:59:25.031] extra = {limit_needed = 104, limit_tuples = 4.6674593885851664e-310, count_est = 94470429750584, offset_est = 94470429747000} [12:59:25.031] lc = [12:59:25.031] __func__ = "grouping_planner" [12:59:25.031] #10 0x000055eb996aaa58 in subquery_planner (glob=glob@entry=0x55eb9c687470, parse=parse@entry=0x55eb9c67df08, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [12:59:25.031] root = 0x55eb9c682738 [12:59:25.031] newWithCheckOptions = [12:59:25.031] newHaving = 0x0 [12:59:25.031] hasOuterJoins = [12:59:25.031] hasResultRTEs = false [12:59:25.031] final_rel = [12:59:25.031] l = 0x0 [12:59:25.031] #11 0x000055eb996ab6e9 in standard_planner (parse=0x55eb9c67df08, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [12:59:25.031] result = [12:59:25.031] glob = 0x55eb9c687470 [12:59:25.031] tuple_fraction = 0 [12:59:25.031] root = [12:59:25.031] final_rel = [12:59:25.031] best_path = [12:59:25.031] top_plan = [12:59:25.031] lp = [12:59:25.031] lr = [12:59:25.031] #12 0x000055eb996ac753 in planner (parse=parse@entry=0x55eb9c67df08, query_string=query_string@entry=0x55eb9c6bb8b0 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [12:59:25.031] result = [12:59:25.031] #13 0x000055eb9991bd98 in pg_plan_query (querytree=querytree@entry=0x55eb9c67df08, query_string=query_string@entry=0x55eb9c6bb8b0 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [12:59:25.031] plan = [12:59:25.031] #14 0x000055eb9941e0a2 in standard_ExplainOneQuery (query=0x55eb9c67df08, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55eb9c686f00, queryString=0x55eb9c6bb8b0 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:503 [12:59:25.031] plan = [12:59:25.031] planstart = [12:59:25.031] planduration = {ticks = 94470378882038} [12:59:25.031] bufusage_start = {shared_blks_hit = 77542, shared_blks_read = 8, shared_blks_dirtied = 237, shared_blks_written = 245, 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}} [12:59:25.031] bufusage = {shared_blks_hit = 0, shared_blks_read = 94470381905471, shared_blks_dirtied = 155271657701376, shared_blks_written = 72057594037927936, local_blks_hit = 140700403327680, local_blks_read = 94470429981536, local_blks_dirtied = 94470429728520, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94470384764282, shared_blk_read_time = {ticks = 140700403327680}, shared_blk_write_time = {ticks = 94470384764301}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94470385145453}, temp_blk_read_time = {ticks = 94470429980592}, temp_blk_write_time = {ticks = 64}} [12:59:25.031] mem_counters = {nblocks = 94470429766608, freechunks = 4294967297, totalspace = 140735426547232, freespace = 10} [12:59:25.031] planner_ctx = 0x0 [12:59:25.031] saved_ctx = 0x0 [12:59:25.031] #15 0x000055eb9941e388 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55eb9c686f00, pstate=pstate@entry=0x55eb9c686df0, params=params@entry=0x0) at ../src/backend/commands/explain.c:459 [12:59:25.031] No locals. [12:59:25.031] #16 0x000055eb9941f2df in ExplainQuery (pstate=pstate@entry=0x55eb9c686df0, stmt=stmt@entry=0x55eb9c6bbaa0, params=params@entry=0x0, dest=dest@entry=0x55eb9c686d60) at ../src/backend/commands/explain.c:357 [12:59:25.031] l__state = [12:59:25.031] l = 0x55eb9c687438 [12:59:25.031] es = 0x55eb9c686f00 [12:59:25.031] tstate = [12:59:25.031] jstate = [12:59:25.031] query = [12:59:25.031] rewritten = 0x55eb9c687420 [12:59:25.031] lc = 0x0 [12:59:25.031] timing_set = false [12:59:25.031] buffers_set = false [12:59:25.031] summary_set = false [12:59:25.031] __func__ = "ExplainQuery" [12:59:25.031] #17 0x000055eb999267b8 in standard_ProcessUtility (pstmt=0x55eb9c6bb990, queryString=0x55eb9c6bb8b0 "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=0x55eb9c686d60, qc=0x7fff851b50a0) at ../src/backend/tcop/utility.c:866 [12:59:25.031] parsetree = 0x55eb9c6bbaa0 [12:59:25.031] isTopLevel = false [12:59:25.031] isAtomicContext = true [12:59:25.031] pstate = 0x55eb9c686df0 [12:59:25.031] readonly_flags = [12:59:25.031] __func__ = "standard_ProcessUtility" [12:59:25.031] #18 0x000055eb99926ee1 in ProcessUtility (pstmt=pstmt@entry=0x55eb9c6bb990, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_QUERY, params=, queryEnv=, dest=0x55eb9c686d60, qc=0x7fff851b50a0) at ../src/backend/tcop/utility.c:523 [12:59:25.031] No locals. [12:59:25.031] #19 0x000055eb9992289f in PortalRunUtility (portal=portal@entry=0x55eb9c5aaa10, pstmt=0x55eb9c6bb990, isTopLevel=isTopLevel@entry=false, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55eb9c686d60, qc=qc@entry=0x7fff851b50a0) at ../src/backend/tcop/pquery.c:1152 [12:59:25.031] No locals. [12:59:25.031] #20 0x000055eb99923112 in FillPortalStore (portal=portal@entry=0x55eb9c5aaa10, isTopLevel=isTopLevel@entry=false) at ../src/backend/tcop/pquery.c:1025 [12:59:25.031] treceiver = 0x55eb9c686d60 [12:59:25.031] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:59:25.031] __func__ = "FillPortalStore" [12:59:25.031] #21 0x000055eb99923a46 in PortalRunFetch (portal=portal@entry=0x55eb9c5aaa10, fdirection=fdirection@entry=FETCH_FORWARD, count=count@entry=10, dest=dest@entry=0x55eb9a14c500 ) at ../src/backend/tcop/pquery.c:1433 [12:59:25.031] _save_exception_stack = 0x7fff851b5650 [12:59:25.031] _save_context_stack = 0x7fff851b54c0 [12:59:25.031] _local_sigjmp_buf = {{__jmpbuf = {94470390727936, 9010157508887950707, 0, 10, 140735426548960, 94470429594424, 2964125052130669939, 9010164728115869043}, __mask_was_saved = 0, __saved_mask = {__val = {2572957767, 94470429980848, 94470385155589, 140735426548928, 94470378631814, 144, 140700404091879, 94470429630064, 8192, 94470429687472, 94470429630064, 94470429630064, 94470429630320, 0, 94470385147696, 0}}}} [12:59:25.031] _do_rethrow = [12:59:25.031] result = [12:59:25.031] saveActivePortal = 0x55eb9c5aa900 [12:59:25.031] saveResourceOwner = 0x55eb9c569d38 [12:59:25.031] savePortalContext = 0x55eb9c6ba360 [12:59:25.031] oldContext = 0x55eb9c637d80 [12:59:25.031] __func__ = "PortalRunFetch" [12:59:25.031] #22 0x000055eb995c39c8 in _SPI_cursor_operation (portal=portal@entry=0x55eb9c5aaa10, direction=direction@entry=FETCH_FORWARD, count=count@entry=10, dest=0x55eb9a14c500 ) at ../src/backend/executor/spi.c:3027 [12:59:25.031] nfetched = [12:59:25.031] __func__ = "_SPI_cursor_operation" [12:59:25.031] #23 0x000055eb995c93f0 in SPI_cursor_fetch (portal=portal@entry=0x55eb9c5aaa10, forward=forward@entry=true, count=10) at ../src/backend/executor/spi.c:1808 [12:59:25.031] No locals. [12:59:25.031] #24 0x00007ff75d9a0236 in exec_for_query (estate=estate@entry=0x7fff851b54e0, stmt=stmt@entry=0x55eb9c65d338, portal=portal@entry=0x55eb9c5aaa10, prefetch_ok=, prefetch_ok@entry=true) at ../src/pl/plpgsql/src/pl_exec.c:5887 [12:59:25.031] var = 0x55eb9c65d388 [12:59:25.031] tuptab = [12:59:25.031] found = false [12:59:25.031] rc = 0 [12:59:25.031] previous_id = 1 [12:59:25.031] tupdescs_match = true [12:59:25.031] n = [12:59:25.031] #25 0x00007ff75d9a0e40 in exec_stmt_dynfors (estate=estate@entry=0x7fff851b54e0, stmt=stmt@entry=0x55eb9c65d338) at ../src/pl/plpgsql/src/pl_exec.c:4645 [12:59:25.031] portal = 0x55eb9c5aaa10 [12:59:25.031] rc = [12:59:25.031] #26 0x00007ff75d99c738 in exec_stmts (estate=estate@entry=0x7fff851b54e0, stmts=0x55eb9c65da38) at ../src/pl/plpgsql/src/pl_exec.c:2096 [12:59:25.031] stmt = 0x55eb9c65d338 [12:59:25.031] rc = [12:59:25.031] s__state = [12:59:25.031] save_estmt = 0x55eb9c65da88 [12:59:25.031] s = [12:59:25.031] __func__ = "exec_stmts" [12:59:25.031] #27 0x00007ff75d99d406 in exec_stmt_block (estate=estate@entry=0x7fff851b54e0, block=block@entry=0x55eb9c65da88) at ../src/pl/plpgsql/src/pl_exec.c:1939 [12:59:25.031] rc = -1 [12:59:25.031] i = 3 [12:59:25.031] __func__ = "exec_stmt_block" [12:59:25.031] #28 0x00007ff75d99d54d in exec_toplevel_block (estate=estate@entry=0x7fff851b54e0, block=0x55eb9c65da88) at ../src/pl/plpgsql/src/pl_exec.c:1630 [12:59:25.031] rc = [12:59:25.031] #29 0x00007ff75d99dc82 in plpgsql_exec_function (func=func@entry=0x55eb9c569928, fcinfo=fcinfo@entry=0x55eb9c649ee0, 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 [12:59:25.031] estate = {func = 0x55eb9c569928, 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 = 0x55eb9c64bdf0, tuple_store_owner = 0x55eb9c569d38, rsi = 0x7fff851b5790, found_varno = 4, ndatums = 9, datums = 0x55eb9c655f20, datum_context = 0x55eb9c655dd0, paramLI = 0x55eb9c655ed0, simple_eval_estate = 0x55eb9c659ef0, simple_eval_resowner = 0x55eb9c567da8, procedure_resowner = 0x0, cast_hash = 0x55eb9c667f80, stmt_mcontext = 0x55eb9c665e70, stmt_mcontext_parent = 0x55eb9c655dd0, eval_tuptable = 0x0, eval_processed = 0, eval_econtext = 0x55eb9c65a100, err_stmt = 0x55eb9c65d338, err_var = 0x0, err_text = 0x0, plugin_info = 0x0} [12:59:25.031] plerrcontext = {previous = 0x0, callback = 0x7ff75d99a917 , arg = 0x7fff851b54e0} [12:59:25.031] i = 1 [12:59:25.031] rc = [12:59:25.031] __func__ = "plpgsql_exec_function" [12:59:25.031] #30 0x00007ff75d9a6fe0 in plpgsql_call_handler (fcinfo=0x55eb9c649ee0) at ../src/pl/plpgsql/src/pl_handler.c:276 [12:59:25.031] _save_exception_stack = 0x7fff851b5a80 [12:59:25.031] _save_context_stack = 0x0 [12:59:25.031] _local_sigjmp_buf = {{__jmpbuf = {94470428596520, -2964008258450770573, 0, 94470429524776, 1, 94470429527232, 2964125052359259507, 2968717703531050355}, __mask_was_saved = 0, __saved_mask = {__val = {94470429515528, 0, 0, 0, 94470377852622, 94470429515488, 94470429526408, 32, 94470378055244, 94470429526824, 94470429524776, 94470429515232, 94470429515488, 94470429515232, 94470378248811, 94470429515488}}}} [12:59:25.031] _do_rethrow = false [12:59:25.031] nonatomic = false [12:59:25.031] func = 0x55eb9c569928 [12:59:25.031] save_cur_estate = 0x0 [12:59:25.031] procedure_resowner = 0x0 [12:59:25.031] retval = 0 [12:59:25.031] rc = [12:59:25.031] __func__ = "plpgsql_call_handler" [12:59:25.031] #31 0x000055eb99537d07 in ExecMakeTableFunctionResult (setexpr=0x55eb9c64c458, econtext=0x55eb9c64c328, argContext=, expectedDesc=0x55eb9c64ccc0, randomAccess=false) at ../src/backend/executor/execSRF.c:234 [12:59:25.031] result = 140700404414024 [12:59:25.031] tupstore = 0x0 [12:59:25.031] tupdesc = 0x0 [12:59:25.031] funcrettype = 2249 [12:59:25.031] returnsTuple = [12:59:25.031] returnsSet = true [12:59:25.031] fcinfo = 0x55eb9c649ee0 [12:59:25.031] fcusage = {fs = 0x0, save_f_total_time = {ticks = 94470384617683}, save_total = {ticks = 140700404414064}, start = {ticks = 140700404414064}} [12:59:25.031] rsinfo = {type = T_ReturnSetInfo, econtext = 0x55eb9c64c328, expectedDesc = 0x55eb9c64ccc0, allowedModes = 11, returnMode = SFRM_ValuePerCall, isDone = ExprSingleResult, setResult = 0x0, setDesc = 0x0} [12:59:25.031] tmptup = {t_len = 1570764424, t_self = {ip_blkid = {bi_hi = 32759, bi_lo = 0}, ip_posid = 2}, t_tableOid = 0, t_data = 0x1} [12:59:25.031] callerContext = 0x55eb9c64bdf0 [12:59:25.031] first_time = true [12:59:25.031] __func__ = "ExecMakeTableFunctionResult" [12:59:25.031] #32 0x000055eb99565d94 in FunctionNext (node=0x55eb9c64c118) at ../src/backend/executor/nodeFunctionscan.c:94 [12:59:25.031] tstore = 0x0 [12:59:25.031] estate = [12:59:25.031] direction = ForwardScanDirection [12:59:25.031] scanslot = 0x55eb9c64cee0 [12:59:25.031] alldone = [12:59:25.031] oldpos = [12:59:25.031] funcno = [12:59:25.031] att = [12:59:25.031] #33 0x000055eb99539667 in ExecScanFetch (node=node@entry=0x55eb9c64c118, accessMtd=accessMtd@entry=0x55eb99565b5f , recheckMtd=recheckMtd@entry=0x55eb99565a6b ) at ../src/backend/executor/execScan.c:131 [12:59:25.031] estate = [12:59:25.031] #34 0x000055eb99539771 in ExecScan (node=0x55eb9c64c118, accessMtd=accessMtd@entry=0x55eb99565b5f , recheckMtd=recheckMtd@entry=0x55eb99565a6b ) at ../src/backend/executor/execScan.c:180 [12:59:25.031] econtext = 0x55eb9c64c328 [12:59:25.031] qual = 0x0 [12:59:25.031] projInfo = 0x0 [12:59:25.031] #35 0x000055eb99565ae3 in ExecFunctionScan (pstate=) at ../src/backend/executor/nodeFunctionscan.c:269 [12:59:25.031] node = [12:59:25.031] #36 0x000055eb995323ee in ExecProcNodeFirst (node=0x55eb9c64c118) at ../src/backend/executor/execProcnode.c:469 [12:59:25.031] No locals. [12:59:25.031] #37 0x000055eb9951d8d0 in ExecProcNode (node=node@entry=0x55eb9c64c118) at ../src/include/executor/executor.h:272 [12:59:25.031] No locals. [12:59:25.031] #38 0x000055eb9951e78e in ExecutePlan (queryDesc=queryDesc@entry=0x55eb9c6ba460, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=direction@entry=ForwardScanDirection, dest=dest@entry=0x55eb9c581ef0) at ../src/backend/executor/execMain.c:1655 [12:59:25.031] estate = 0x55eb9c64bef0 [12:59:25.031] planstate = 0x55eb9c64c118 [12:59:25.031] use_parallel_mode = false [12:59:25.031] slot = [12:59:25.031] current_tuple_count = 0 [12:59:25.031] #39 0x000055eb9951f99a in standard_ExecutorRun (queryDesc=0x55eb9c6ba460, direction=ForwardScanDirection, count=0) at ../src/backend/executor/execMain.c:363 [12:59:25.031] estate = 0x55eb9c64bef0 [12:59:25.031] operation = CMD_SELECT [12:59:25.031] dest = 0x55eb9c581ef0 [12:59:25.031] sendTuples = [12:59:25.031] oldcontext = 0x55eb9c6ba360 [12:59:25.031] #40 0x000055eb9951f9fa in ExecutorRun (queryDesc=queryDesc@entry=0x55eb9c6ba460, direction=direction@entry=ForwardScanDirection, count=count@entry=0) at ../src/backend/executor/execMain.c:300 [12:59:25.031] No locals. [12:59:25.031] #41 0x000055eb9992019c in PortalRunSelect (portal=portal@entry=0x55eb9c5aa900, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55eb9c581ef0) at ../src/backend/tcop/pquery.c:920 [12:59:25.031] queryDesc = 0x55eb9c6ba460 [12:59:25.031] direction = [12:59:25.031] nprocessed = [12:59:25.031] __func__ = "PortalRunSelect" [12:59:25.031] #42 0x000055eb99923564 in PortalRun (portal=portal@entry=0x55eb9c5aa900, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, dest=dest@entry=0x55eb9c581ef0, altdest=altdest@entry=0x55eb9c581ef0, qc=qc@entry=0x7fff851b5ba0) at ../src/backend/tcop/pquery.c:764 [12:59:25.031] _save_exception_stack = 0x7fff851b5c50 [12:59:25.031] _save_context_stack = 0x0 [12:59:25.031] _local_sigjmp_buf = {{__jmpbuf = {0, 9010157496653165939, 94470428862720, 94470428322616, 94470428322592, 94470428322544, 2964125052491380083, 9010164727904318835}, __mask_was_saved = 0, __saved_mask = {__val = {94470385149870, 2233162543, 4, 94470428322544, 112, 179, 94470428862720, 94470428322616, 94470428322592, 94470428322544, 94470385237073, 1, 2, 179, 94470374492575, 0}}}} [12:59:25.031] _do_rethrow = [12:59:25.031] result = [12:59:25.031] nprocessed = [12:59:25.031] saveTopTransactionResourceOwner = 0x55eb9c5675b8 [12:59:25.031] saveTopTransactionContext = 0x55eb9c5bc920 [12:59:25.031] saveActivePortal = 0x0 [12:59:25.031] saveResourceOwner = 0x55eb9c5675b8 [12:59:25.031] savePortalContext = 0x0 [12:59:25.031] saveMemoryContext = 0x55eb9c5bc920 [12:59:25.031] __func__ = "PortalRun" [12:59:25.031] #43 0x000055eb9991c864 in exec_simple_query (query_string=query_string@entry=0x55eb9c525af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');") at ../src/backend/tcop/postgres.c:1271 [12:59:25.031] cmdtaglen = 6 [12:59:25.031] snapshot_set = [12:59:25.031] per_parsetree_context = 0x0 [12:59:25.031] plantree_list = 0x55eb9c581ea0 [12:59:25.031] parsetree = 0x55eb9c526af0 [12:59:25.031] commandTag = [12:59:25.031] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [12:59:25.031] querytree_list = [12:59:25.031] portal = 0x55eb9c5aa900 [12:59:25.031] receiver = 0x55eb9c581ef0 [12:59:25.031] format = 0 [12:59:25.031] cmdtagname = [12:59:25.031] parsetree_item__state = [12:59:25.031] dest = DestRemote [12:59:25.031] oldcontext = 0x55eb9c5bc920 [12:59:25.031] parsetree_list = 0x55eb9c526b20 [12:59:25.031] parsetree_item = 0x55eb9c526b38 [12:59:25.031] save_log_statement_stats = false [12:59:25.031] was_logged = false [12:59:25.031] use_implicit_block = false [12:59:25.031] msec_str = "\004\000\000\000\000\000\000\000\373\301\275\231\353U\000\0000\\\033\205\377\177\000\000x\000\000\000\000\000\000" [12:59:25.031] __func__ = "exec_simple_query" [12:59:25.031] #44 0x000055eb9991f5bd in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [12:59:25.031] query_string = 0x55eb9c525af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');" [12:59:25.031] firstchar = [12:59:25.031] input_message = {data = 0x55eb9c525af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');", len = 120, maxlen = 1024, cursor = 120} [12:59:25.031] local_sigjmp_buf = {{__jmpbuf = {94470397897080, 9010171463121352051, 140735426551212, 4, 7, 140735426551444, 2964125052558488947, 9010164718014018931}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94470428048912, 15616, 94470397891136, 94470428583280, 7, 94470385149418, 0, 9, 2, 94470397897088, 94470428048912, 94470397891136, 4, 7, 140735426551444}}}} [12:59:25.031] send_ready_for_query = false [12:59:25.031] idle_in_transaction_timeout_enabled = false [12:59:25.031] idle_session_timeout_enabled = false [12:59:25.031] __func__ = "PostgresMain" [12:59:25.031] #45 0x000055eb99915628 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:59:25.031] bsdata = [12:59:25.031] #46 0x000055eb997c6d47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=7, startup_data=startup_data@entry=0x7fff851b5dac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff851b5e00) at ../src/backend/postmaster/launch_backend.c:274 [12:59:25.031] pid = [12:59:25.031] #47 0x000055eb997cbd42 in BackendStartup (client_sock=client_sock@entry=0x7fff851b5e00) at ../src/backend/postmaster/postmaster.c:3386 [12:59:25.031] bn = 0x55eb9c54e188 [12:59:25.031] pid = [12:59:25.031] startup_data = {canAcceptConnections = CAC_OK} [12:59:25.031] cac = [12:59:25.031] __func__ = "BackendStartup" [12:59:25.031] #48 0x000055eb997cdc1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [12:59:25.031] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\310j\367\177\000\000>\004\000\000\000\000\000\000\260\227Ci\367\177\000\000\240?\223j\367\177\000\000\270^\033\205\377\177\000\000\264^\033\205\377\177", '\000' , "\"\246\224\230\353U\000\000\300\207\220\230\353U\000\000\200_\033\205\377\177\000\000x_\033\205\377\177\000\000\225[\362\001\256\247\a\027\240\224(j\367\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [12:59:25.031] i = 0 [12:59:25.031] now = [12:59:25.031] last_lockfile_recheck_time = 1735304041 [12:59:25.031] last_touch_time = 1735304041 [12:59:25.031] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = -2061803584, user_data = 0x0}, {pos = 15, events = 0, fd = -1735088606, user_data = 0x7ff76acb7668}, {pos = 1781044784, events = 32759, fd = 1791718112, user_data = 0x7c96e577}, {pos = -2061803520, events = 32767, fd = 1791547976, user_data = 0xf}, {pos = 1781044784, events = 32759, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 1791718112, user_data = 0x7fff851b5f78}, {pos = -2061803648, events = 32767, fd = 1791719016, user_data = 0x0}, {pos = -1672316960, events = 21995, fd = 1766780261, user_data = 0x7fff851b6493}, {pos = 1, events = 0, fd = -2061803648, user_data = 0xffffffff}, {pos = 1765990432, events = 32759, fd = 1788034976, user_data = 0x55eb9c5531c8}, {pos = -1672138584, events = 21995, fd = -1672139135, user_data = 0x7ff76ac93ebe}, {pos = 1, events = 0, fd = 1791718112, user_data = 0x1aa}, {pos = -1709830832, events = 21995, fd = 0, user_data = 0xec}, {pos = -1672324176, events = 21995, fd = 1791573694, user_data = 0x1}, {pos = 0, events = 0, fd = 1765990432, user_data = 0x7ff7694f2e40 }, {pos = 16, events = 0, fd = -2061802560, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7ff76ac961ba}, {pos = 0, events = 0, fd = 1766518180, user_data = 0x0}, {pos = -1702810336, events = 21995, fd = 2, user_data = 0x0}, {pos = -1672577360, events = 21995, fd = 1952410737, user_data = 0x160}, {pos = -1709831424, events = 21995, fd = 8, user_data = 0x2ffff00001fa0}, {pos = -1672324176, events = 21995, fd = 1791573694, user_data = 0x1}, {pos = 1766551661, events = 32759, fd = 1766024392, user_data = 0x55eb9c558510}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = 1767840864, events = 32759, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x55eb9c4e7eb0}, {pos = 1766554250, events = 32759, 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 = 1836207721, fd = 168458347, user_data = 0x33353337310a6174}, {pos = 875574320, events = 808716848, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1767823840, events = 32759, fd = 1766461806, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x1707a7ae89424e00}, {pos = 1767826912, events = 32759, fd = -328, user_data = 0x0}, {pos = -1672138904, events = 21995, fd = 1024, user_data = 0x55eb9c552f68}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 21654, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -1672324176, user_data = 0x7ff7694f3053 }, {pos = -1672138904, events = 21995, fd = 1024, user_data = 0x7fff851b6488}, {pos = -1715414047, events = 21995, fd = -1702745808, user_data = 0x55eb99bfc69e }, {pos = -1672139104, events = 21995, fd = -1672324624, user_data = 0x55eb9c552ea0}, {pos = 1766545598, events = 32759, fd = 0, user_data = 0x55eb99c0e308 }, {pos = -1672139104, events = 1, fd = -1715411887, user_data = 0x55eb9c5259f0}, {pos = -1992143360, events = 386377646, fd = 0, user_data = 0x7ff7694a2ab1}, {pos = 1766462704, events = 32759, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1672577360, user_data = 0x1707a7ae89424e00}, {pos = 0, events = 0, fd = -1992143360, user_data = 0xc}, {pos = -1992143360, events = 386377646, fd = 0, user_data = 0x7ff76945b239 }, {pos = 237, events = 0, fd = -1719899580, user_data = 0x400000}, {pos = 0, events = 0, fd = -1672577360, user_data = 0x55eb99bfc532 }, {pos = -1672490720, events = 21995, fd = -1672324624, user_data = 0x55eb9c4fd120}, {pos = 1, events = 0, fd = 0, user_data = 0x55eb99bbaccc }, {pos = 12, events = 0, fd = -1672147768, user_data = 0x55eb9c550ca8}, {pos = -1702808928, events = 21995, fd = 296, user_data = 0x55eb997c925e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -1719883109, events = 21995, fd = -1706412496, user_data = 0x55eb9c5263c8}} [12:59:25.031] nevents = 1 [12:59:25.031] __func__ = "ServerLoop" [12:59:25.031] #49 0x000055eb997cf49c in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55eb9c4e3d70) at ../src/backend/postmaster/postmaster.c:1371 [12:59:25.031] opt = [12:59:25.031] status = [12:59:25.031] userDoption = [12:59:25.031] listen_addr_saved = false [12:59:25.031] output_config_variable = [12:59:25.031] __func__ = "PostmasterMain" [12:59:25.031] #50 0x000055eb995fbb3e in main (argc=8, argv=0x55eb9c4e3d70) at ../src/backend/main/main.c:230 [12:59:25.031] do_check_root = [12:59:25.031] dispatch_option = [12:59:25.069] -e [12:59:25.069] [12:59:25.069] [12:59:25.134] dumping /tmp/cores/postgres-6-40316.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [12:59:25.388] [New LWP 40316] [12:59:25.388] [12:59:25.388] This GDB supports auto-downloading debuginfo from the following URLs: [12:59:25.388] [12:59:25.388] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:59:25.388] Debuginfod has been disabled. [12:59:25.388] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:59:25.495] [Thread debugging using libthread_db enabled] [12:59:25.495] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:59:25.495] Core was generated by `postgres: test: postgres db2 [local] SELECT '. [12:59:25.495] Program terminated with signal SIGABRT, Aborted. [12:59:25.495] #0 0x00007fedabea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:25.552] [12:59:25.552] Thread 1 (Thread 0x7fedac635f00 (LWP 40316)): [12:59:25.552] #0 0x00007fedabea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:25.552] No symbol table info available. [12:59:25.552] #1 0x00007fedabe5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:25.552] No symbol table info available. [12:59:25.552] #2 0x00007fedabe45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:25.552] No symbol table info available. [12:59:25.552] #3 0x00007fedac01e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [12:59:25.552] No locals. [12:59:25.552] #4 0x00007fedac02aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [12:59:25.552] No locals. [12:59:25.552] #5 0x00007fedac00dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x564b66c1c480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [12:59:25.552] bp = 140734602836896 [12:59:25.552] pc = [12:59:25.552] Opts = {FromUnrecoverableHandler = true, pc = 94881832541840, bp = 140658573294760} [12:59:25.552] #6 0x0000564b65ec9e90 in examine_self_contradictory_rels (root=root@entry=0x564b677d71d8, rel=rel@entry=0x564b677e0ec8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [12:59:25.552] lc__state = [12:59:25.552] rlist = [12:59:25.552] i = 7 [12:59:25.552] br = [12:59:25.552] expression = [12:59:25.552] or_rinfo = 0x7feda04bcd38 [12:59:25.552] ccxt = [12:59:25.552] delidx = 0x7feda04bfe91 [12:59:25.552] arglst = [12:59:25.552] lc = [12:59:25.552] arg = [12:59:25.552] n = [12:59:25.552] restrictinfo = [12:59:25.552] ccwapper = {clausecxt = 0x7feda04bdb28} [12:59:25.552] sec = {sopcinfo = {n_members = 38, opcies = 0x7feda04bd2c8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7feda04bd6d8, atop_set = 0x7feda04bb398}, ccfree = 0x7feda04bfe60, vifree = 0x7feda04bed78} [12:59:25.552] __func__ = "examine_self_contradictory_rels" [12:59:25.552] #7 0x0000564b65eca09f in examine_self_contradictory_rels_phase1 (root=root@entry=0x564b677d71d8) at ../src/backend/optimizer/plan/contradictory.c:2608 [12:59:25.552] rel = 0x564b677e0ec8 [12:59:25.552] rti = 1 [12:59:25.552] rinfo = [12:59:25.552] #8 0x0000564b65e95058 in query_planner (root=root@entry=0x564b677d71d8, qp_callback=qp_callback@entry=0x564b65e9a375 , qp_extra=qp_extra@entry=0x7fff54027da0) at ../src/backend/optimizer/plan/planmain.c:193 [12:59:25.552] parse = 0x564b677cd9d0 [12:59:25.552] joinlist = 0x7feda04bb528 [12:59:25.552] final_rel = [12:59:25.552] __func__ = "query_planner" [12:59:25.552] #9 0x0000564b65ea7ad4 in grouping_planner (root=root@entry=0x564b677d71d8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [12:59:25.552] sort_input_targets = 0x564b677d71d8 [12:59:25.552] sort_input_target_parallel_safe = [12:59:25.552] grouping_target = [12:59:25.552] scanjoin_target = [12:59:25.552] activeWindows = 0x0 [12:59:25.552] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [12:59:25.552] sort_input_targets_contain_srfs = 0x564b677d49d0 [12:59:25.552] have_grouping = [12:59:25.552] wflists = 0x0 [12:59:25.552] gset_data = 0x0 [12:59:25.552] sort_input_target = [12:59:25.552] grouping_targets = 0x564b677d4a18 [12:59:25.552] grouping_target_parallel_safe = [12:59:25.552] scanjoin_targets = 0x564b677d4a00 [12:59:25.552] scanjoin_target_parallel_safe = [12:59:25.552] grouping_targets_contain_srfs = 0x564b677d71d8 [12:59:25.552] scanjoin_targets_contain_srfs = 0x0 [12:59:25.552] scanjoin_target_same_exprs = [12:59:25.552] parse = 0x564b677cd9d0 [12:59:25.552] offset_est = 0 [12:59:25.552] count_est = 0 [12:59:25.552] limit_tuples = -1 [12:59:25.552] have_postponed_srfs = false [12:59:25.552] final_target = [12:59:25.552] final_targets = 0x564b677d71d8 [12:59:25.552] final_targets_contain_srfs = 0x7 [12:59:25.552] final_target_parallel_safe = [12:59:25.552] current_rel = [12:59:25.552] final_rel = [12:59:25.552] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94881858771408} [12:59:25.552] lc = [12:59:25.552] __func__ = "grouping_planner" [12:59:25.552] #10 0x0000564b65eaaa58 in subquery_planner (glob=, parse=0x564b677cd9d0, parent_root=parent_root@entry=0x564b677cab90, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [12:59:25.552] root = 0x564b677d71d8 [12:59:25.552] newWithCheckOptions = [12:59:25.552] newHaving = 0x0 [12:59:25.552] hasOuterJoins = [12:59:25.552] hasResultRTEs = true [12:59:25.552] final_rel = [12:59:25.552] l = 0x0 [12:59:25.552] #11 0x0000564b65ebc3f2 in SS_process_ctes (root=root@entry=0x564b677cab90) at ../src/backend/optimizer/plan/subselect.c:966 [12:59:25.552] subquery = [12:59:25.552] cte = 0x564b6778ff60 [12:59:25.552] cmdType = [12:59:25.552] subroot = [12:59:25.552] final_rel = [12:59:25.552] best_path = [12:59:25.552] plan = [12:59:25.552] splan = [12:59:25.552] paramid = [12:59:25.552] lc__state = [12:59:25.552] lc = [12:59:25.552] __func__ = "SS_process_ctes" [12:59:25.552] #12 0x0000564b65ea94fc in subquery_planner (glob=glob@entry=0x564b677a4998, parse=parse@entry=0x564b677a4aa8, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:704 [12:59:25.552] root = 0x564b677cab90 [12:59:25.552] newWithCheckOptions = [12:59:25.552] newHaving = [12:59:25.552] hasOuterJoins = [12:59:25.552] hasResultRTEs = [12:59:25.552] final_rel = [12:59:25.552] l = [12:59:25.552] #13 0x0000564b65eab6e9 in standard_planner (parse=0x564b677a4aa8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [12:59:25.552] result = [12:59:25.552] glob = 0x564b677a4998 [12:59:25.552] tuple_fraction = 0 [12:59:25.552] root = [12:59:25.552] final_rel = [12:59:25.552] best_path = [12:59:25.552] top_plan = [12:59:25.552] lp = [12:59:25.552] lr = [12:59:25.552] #14 0x0000564b65eac753 in planner (parse=parse@entry=0x564b677a4aa8, query_string=query_string@entry=0x564b676b45a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [12:59:25.552] result = [12:59:25.552] #15 0x0000564b6611bd98 in pg_plan_query (querytree=querytree@entry=0x564b677a4aa8, query_string=query_string@entry=0x564b676b45a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [12:59:25.552] plan = [12:59:25.552] #16 0x0000564b6611c179 in pg_plan_queries (querytrees=0x564b677cab40, query_string=query_string@entry=0x564b676b45a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:993 [12:59:25.552] query = 0x564b677a4aa8 [12:59:25.552] stmt = [12:59:25.552] query_list__state = [12:59:25.552] stmt_list = 0x0 [12:59:25.552] query_list = [12:59:25.552] #17 0x0000564b6611c726 in exec_simple_query (query_string=query_string@entry=0x564b676b45a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "...) at ../src/backend/tcop/postgres.c:1190 [12:59:25.552] cmdtaglen = 6 [12:59:25.552] snapshot_set = true [12:59:25.552] per_parsetree_context = 0x0 [12:59:25.552] plantree_list = [12:59:25.552] parsetree = 0x564b677a4918 [12:59:25.552] commandTag = CMDTAG_SELECT [12:59:25.552] qc = {commandTag = 1935, nprocessed = 94881857619360} [12:59:25.552] querytree_list = [12:59:25.552] portal = [12:59:25.552] receiver = [12:59:25.552] format = 0 [12:59:25.552] cmdtagname = [12:59:25.552] parsetree_item__state = [12:59:25.552] dest = DestRemote [12:59:25.552] oldcontext = 0x564b67744610 [12:59:25.552] parsetree_list = 0x564b677a4948 [12:59:25.552] parsetree_item = 0x564b677a4960 [12:59:25.552] save_log_statement_stats = false [12:59:25.552] was_logged = true [12:59:25.552] use_implicit_block = false [12:59:25.552] msec_str = "\004\000\000\000\000\000\000\000\373\301=fKV\000\000p\201\002T\377\177\000\000\217\a\000\000\000\000\000" [12:59:25.552] __func__ = "exec_simple_query" [12:59:25.552] #18 0x0000564b6611f5bd in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [12:59:25.552] query_string = 0x564b676b45a0 "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 "... [12:59:25.552] firstchar = [12:59:25.552] input_message = {data = 0x564b676b45a0 "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} [12:59:25.552] local_sigjmp_buf = {{__jmpbuf = {94881850730872, 7812035794626218589, 140734602838764, 4, 1, 140734602838996, 4540062916685400669, 7812037871104887389}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94881857347024, 14336, 94881850724928, 94881857857376, 1, 94881837983210, 0, 9, 2, 94881850730880, 94881857347024, 94881850724928, 4, 1, 140734602838996}}}} [12:59:25.552] send_ready_for_query = false [12:59:25.552] idle_in_transaction_timeout_enabled = false [12:59:25.552] idle_session_timeout_enabled = false [12:59:25.552] __func__ = "PostgresMain" [12:59:25.552] #19 0x0000564b66115628 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:59:25.552] bsdata = [12:59:25.552] #20 0x0000564b65fc6d47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=1, startup_data=startup_data@entry=0x7fff540282ec "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff54028340) at ../src/backend/postmaster/launch_backend.c:274 [12:59:25.552] pid = [12:59:25.552] #21 0x0000564b65fcbd42 in BackendStartup (client_sock=client_sock@entry=0x7fff54028340) at ../src/backend/postmaster/postmaster.c:3386 [12:59:25.552] bn = 0x564b676dc278 [12:59:25.552] pid = [12:59:25.552] startup_data = {canAcceptConnections = CAC_OK} [12:59:25.552] cac = [12:59:25.552] __func__ = "BackendStartup" [12:59:25.552] #22 0x0000564b65fcdc1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [12:59:25.552] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "}\255\355\177\000\000>\004\000\000\000\000\000\000\260\227\343\253\355\177\000\000\240o5\255\355\177\000\000\370\203\002T\377\177\000\000\364\203\002T\377\177", '\000' , "\"\246\024eKV\000\000\300\207\020eKV\000\000\300\204\002T\377\177\000\000\270\204\002T\377\177\000\000\225[\362\0010\024E\037\240Dd\254\355\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [12:59:25.552] i = 0 [12:59:25.552] now = [12:59:25.552] last_lockfile_recheck_time = 1735304117 [12:59:25.552] last_touch_time = 1735304117 [12:59:25.552] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 1409451264, user_data = 0x0}, {pos = 15, events = 0, fd = 1695852066, user_data = 0x7fedad808668}, {pos = -1402714576, events = 32749, fd = -1384086816, user_data = 0x7c96e577}, {pos = 1409451328, events = 32767, fd = -1384256952, user_data = 0xf}, {pos = -1402714576, events = 32749, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1384086816, user_data = 0x7fff540284b8}, {pos = 1409451200, events = 32767, fd = -1384085912, user_data = 0x0}, {pos = 1735088736, events = 22091, fd = -1410405019, user_data = 0x7fff540289d3}, {pos = 1, events = 0, fd = 1409451200, user_data = 0xffffffff}, {pos = -1411194848, events = 32749, fd = -1389006944, user_data = 0x564b676e1018}, {pos = 1735266040, events = 22091, fd = 1735265489, user_data = 0x7fedad7e4ebe}, {pos = 1, events = 0, fd = -1384086816, user_data = 0x1aa}, {pos = 1721109840, events = 22091, fd = 0, user_data = 0xd8}, {pos = 1735088672, events = 22091, fd = -1384231234, user_data = 0x1}, {pos = 0, events = 0, fd = -1411194848, user_data = 0x7fedabef2e40 }, {pos = 16, events = 0, fd = 1409452288, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fedad7e71ba}, {pos = 0, events = 0, fd = -1410667100, user_data = 0x0}, {pos = 1728130336, events = 22091, fd = 2, user_data = 0x0}, {pos = 1734827632, events = 22091, fd = 1952410737, user_data = 0x160}, {pos = 1721109248, events = 22091, fd = 4, user_data = 0x2ffff00001fa0}, {pos = 1735088672, events = 22091, fd = -1384231234, user_data = 0x1}, {pos = -1410633619, events = 32749, fd = -1411160888, user_data = 0x564b676e6720}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -1409344416, events = 32749, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x564b67675e70}, {pos = -1410631030, events = 32749, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 808726282, events = 1767311924, fd = 1769223265, user_data = 0x0}, {pos = 0, events = 4278190080, fd = 1751342899, user_data = 0x305f742f61746164}, {pos = 1684826485, events = 1769300527, fd = 1949262956, user_data = 0x0}, {pos = 0, events = 32512, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1409361440, events = 32749, fd = -1410723474, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x1f451430df225300}, {pos = -1409358368, events = 32749, fd = -328, user_data = 0x0}, {pos = 1735265720, events = 22091, fd = 1024, user_data = 0x564b676e0db8}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 39686, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1735088672, user_data = 0x7fedabef3053 }, {pos = 1735265720, events = 22091, fd = 1024, user_data = 0x7fff540289c8}, {pos = 1715526625, events = 22091, fd = 1728194864, user_data = 0x564b663fc69e }, {pos = 1735265520, events = 22091, fd = 1735081088, user_data = 0x564b676e0cf0}, {pos = -1410639682, events = 32749, fd = 0, user_data = 0x564b6640e308 }, {pos = 1735265520, events = 1, fd = 1715528785, user_data = 0x564b676b3c80}, {pos = -551398656, events = 524620848, fd = 0, user_data = 0x7fedabea2ab1}, {pos = -1410722576, events = 32749, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1734827632, user_data = 0x1f451430df225300}, {pos = 0, events = 0, fd = -551398656, user_data = 0xc}, {pos = -551398656, events = 524620848, fd = 0, user_data = 0x7fedabe5b239 }, {pos = 217, events = 0, fd = 1711041092, user_data = 0x400000}, {pos = 0, events = 0, fd = 1734827632, user_data = 0x564b663fc532 }, {pos = 1734914992, events = 22091, fd = 1735081088, user_data = 0x564b6768b3b0}, {pos = 1, events = 0, fd = 0, user_data = 0x564b663baccc }, {pos = 12, events = 0, fd = 1735256856, user_data = 0x564b676deaf8}, {pos = 1728131744, events = 22091, fd = 296, user_data = 0x564b65fc925e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1711057563, events = 22091, fd = 1724528176, user_data = 0x564b676b4638}} [12:59:25.552] nevents = 1 [12:59:25.552] __func__ = "ServerLoop" [12:59:25.552] #23 0x0000564b65fcf49c in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x564b67671ce0) at ../src/backend/postmaster/postmaster.c:1371 [12:59:25.552] opt = [12:59:25.552] status = [12:59:25.552] userDoption = [12:59:25.552] listen_addr_saved = false [12:59:25.552] output_config_variable = [12:59:25.552] __func__ = "PostmasterMain" [12:59:25.552] #24 0x0000564b65dfbb3e in main (argc=4, argv=0x564b67671ce0) at ../src/backend/main/main.c:230 [12:59:25.552] do_check_root = [12:59:25.552] dispatch_option = [12:59:25.570] -e [12:59:25.570] [12:59:25.570] [12:59:25.635] dumping /tmp/cores/postgres-6-40138.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [12:59:25.892] [New LWP 40138] [12:59:25.892] [12:59:25.892] This GDB supports auto-downloading debuginfo from the following URLs: [12:59:25.892] [12:59:25.892] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:59:25.892] Debuginfod has been disabled. [12:59:25.892] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:59:25.996] [Thread debugging using libthread_db enabled] [12:59:25.996] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:59:25.996] Core was generated by `postgres: test: postgres db1 [local] SELECT '. [12:59:25.996] Program terminated with signal SIGABRT, Aborted. [12:59:25.996] #0 0x00007fedabea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:26.052] [12:59:26.052] Thread 1 (Thread 0x7fedac635f00 (LWP 40138)): [12:59:26.052] #0 0x00007fedabea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:26.052] No symbol table info available. [12:59:26.052] #1 0x00007fedabe5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:26.052] No symbol table info available. [12:59:26.052] #2 0x00007fedabe45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:26.052] No symbol table info available. [12:59:26.052] #3 0x00007fedac01e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [12:59:26.052] No locals. [12:59:26.052] #4 0x00007fedac02aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [12:59:26.052] No locals. [12:59:26.052] #5 0x00007fedac00dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x564b66c1c480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [12:59:26.052] bp = 140734602836896 [12:59:26.052] pc = [12:59:26.052] Opts = {FromUnrecoverableHandler = true, pc = 94881832541840, bp = 140658573294760} [12:59:26.052] #6 0x0000564b65ec9e90 in examine_self_contradictory_rels (root=root@entry=0x564b677d71d8, rel=rel@entry=0x564b677e0ec8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [12:59:26.052] lc__state = [12:59:26.052] rlist = [12:59:26.052] i = 7 [12:59:26.052] br = [12:59:26.052] expression = [12:59:26.052] or_rinfo = 0x7feda04bcd38 [12:59:26.052] ccxt = [12:59:26.052] delidx = 0x7feda04bfe91 [12:59:26.052] arglst = [12:59:26.052] lc = [12:59:26.052] arg = [12:59:26.052] n = [12:59:26.052] restrictinfo = [12:59:26.052] ccwapper = {clausecxt = 0x7feda04bdb28} [12:59:26.052] sec = {sopcinfo = {n_members = 38, opcies = 0x7feda04bd2c8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7feda04bd6d8, atop_set = 0x7feda04bb398}, ccfree = 0x7feda04bfe60, vifree = 0x7feda04bed78} [12:59:26.052] __func__ = "examine_self_contradictory_rels" [12:59:26.052] #7 0x0000564b65eca09f in examine_self_contradictory_rels_phase1 (root=root@entry=0x564b677d71d8) at ../src/backend/optimizer/plan/contradictory.c:2608 [12:59:26.052] rel = 0x564b677e0ec8 [12:59:26.052] rti = 1 [12:59:26.052] rinfo = [12:59:26.052] #8 0x0000564b65e95058 in query_planner (root=root@entry=0x564b677d71d8, qp_callback=qp_callback@entry=0x564b65e9a375 , qp_extra=qp_extra@entry=0x7fff54027da0) at ../src/backend/optimizer/plan/planmain.c:193 [12:59:26.052] parse = 0x564b677cd9d0 [12:59:26.052] joinlist = 0x7feda04bb528 [12:59:26.052] final_rel = [12:59:26.052] __func__ = "query_planner" [12:59:26.052] #9 0x0000564b65ea7ad4 in grouping_planner (root=root@entry=0x564b677d71d8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [12:59:26.052] sort_input_targets = 0x564b677d71d8 [12:59:26.052] sort_input_target_parallel_safe = [12:59:26.052] grouping_target = [12:59:26.052] scanjoin_target = [12:59:26.052] activeWindows = 0x0 [12:59:26.052] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [12:59:26.052] sort_input_targets_contain_srfs = 0x564b677d49d0 [12:59:26.052] have_grouping = [12:59:26.052] wflists = 0x0 [12:59:26.052] gset_data = 0x0 [12:59:26.052] sort_input_target = [12:59:26.052] grouping_targets = 0x564b677d4a18 [12:59:26.052] grouping_target_parallel_safe = [12:59:26.052] scanjoin_targets = 0x564b677d4a00 [12:59:26.052] scanjoin_target_parallel_safe = [12:59:26.052] grouping_targets_contain_srfs = 0x564b677d71d8 [12:59:26.052] scanjoin_targets_contain_srfs = 0x0 [12:59:26.052] scanjoin_target_same_exprs = [12:59:26.052] parse = 0x564b677cd9d0 [12:59:26.052] offset_est = 0 [12:59:26.052] count_est = 0 [12:59:26.052] limit_tuples = -1 [12:59:26.052] have_postponed_srfs = false [12:59:26.052] final_target = [12:59:26.052] final_targets = 0x564b677d71d8 [12:59:26.052] final_targets_contain_srfs = 0x7 [12:59:26.052] final_target_parallel_safe = [12:59:26.052] current_rel = [12:59:26.052] final_rel = [12:59:26.052] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94881858771408} [12:59:26.052] lc = [12:59:26.052] __func__ = "grouping_planner" [12:59:26.052] #10 0x0000564b65eaaa58 in subquery_planner (glob=, parse=0x564b677cd9d0, parent_root=parent_root@entry=0x564b677cab90, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [12:59:26.052] root = 0x564b677d71d8 [12:59:26.052] newWithCheckOptions = [12:59:26.052] newHaving = 0x0 [12:59:26.052] hasOuterJoins = [12:59:26.052] hasResultRTEs = true [12:59:26.052] final_rel = [12:59:26.052] l = 0x0 [12:59:26.052] #11 0x0000564b65ebc3f2 in SS_process_ctes (root=root@entry=0x564b677cab90) at ../src/backend/optimizer/plan/subselect.c:966 [12:59:26.052] subquery = [12:59:26.052] cte = 0x564b6778ff60 [12:59:26.052] cmdType = [12:59:26.052] subroot = [12:59:26.052] final_rel = [12:59:26.052] best_path = [12:59:26.052] plan = [12:59:26.052] splan = [12:59:26.052] paramid = [12:59:26.052] lc__state = [12:59:26.052] lc = [12:59:26.052] __func__ = "SS_process_ctes" [12:59:26.052] #12 0x0000564b65ea94fc in subquery_planner (glob=glob@entry=0x564b677a4998, parse=parse@entry=0x564b677a4aa8, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:704 [12:59:26.052] root = 0x564b677cab90 [12:59:26.052] newWithCheckOptions = [12:59:26.052] newHaving = [12:59:26.052] hasOuterJoins = [12:59:26.052] hasResultRTEs = [12:59:26.052] final_rel = [12:59:26.052] l = [12:59:26.052] #13 0x0000564b65eab6e9 in standard_planner (parse=0x564b677a4aa8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [12:59:26.052] result = [12:59:26.052] glob = 0x564b677a4998 [12:59:26.052] tuple_fraction = 0 [12:59:26.052] root = [12:59:26.052] final_rel = [12:59:26.052] best_path = [12:59:26.052] top_plan = [12:59:26.052] lp = [12:59:26.052] lr = [12:59:26.052] #14 0x0000564b65eac753 in planner (parse=parse@entry=0x564b677a4aa8, query_string=query_string@entry=0x564b676b45a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [12:59:26.052] result = [12:59:26.052] #15 0x0000564b6611bd98 in pg_plan_query (querytree=querytree@entry=0x564b677a4aa8, query_string=query_string@entry=0x564b676b45a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [12:59:26.052] plan = [12:59:26.052] #16 0x0000564b6611c179 in pg_plan_queries (querytrees=0x564b677cab40, query_string=query_string@entry=0x564b676b45a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:993 [12:59:26.052] query = 0x564b677a4aa8 [12:59:26.052] stmt = [12:59:26.052] query_list__state = [12:59:26.052] stmt_list = 0x0 [12:59:26.052] query_list = [12:59:26.052] #17 0x0000564b6611c726 in exec_simple_query (query_string=query_string@entry=0x564b676b45a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "...) at ../src/backend/tcop/postgres.c:1190 [12:59:26.052] cmdtaglen = 6 [12:59:26.052] snapshot_set = true [12:59:26.052] per_parsetree_context = 0x0 [12:59:26.052] plantree_list = [12:59:26.052] parsetree = 0x564b677a4918 [12:59:26.052] commandTag = CMDTAG_SELECT [12:59:26.052] qc = {commandTag = 1935, nprocessed = 94881857619360} [12:59:26.052] querytree_list = [12:59:26.052] portal = [12:59:26.052] receiver = [12:59:26.052] format = 0 [12:59:26.052] cmdtagname = [12:59:26.052] parsetree_item__state = [12:59:26.052] dest = DestRemote [12:59:26.052] oldcontext = 0x564b67744610 [12:59:26.052] parsetree_list = 0x564b677a4948 [12:59:26.052] parsetree_item = 0x564b677a4960 [12:59:26.052] save_log_statement_stats = false [12:59:26.052] was_logged = true [12:59:26.052] use_implicit_block = false [12:59:26.052] msec_str = "\004\000\000\000\000\000\000\000\373\301=fKV\000\000p\201\002T\377\177\000\000\217\a\000\000\000\000\000" [12:59:26.052] __func__ = "exec_simple_query" [12:59:26.052] #18 0x0000564b6611f5bd in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [12:59:26.052] query_string = 0x564b676b45a0 "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 "... [12:59:26.052] firstchar = [12:59:26.052] input_message = {data = 0x564b676b45a0 "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} [12:59:26.052] local_sigjmp_buf = {{__jmpbuf = {94881850730872, 7812035794626218589, 140734602838764, 4, 2, 140734602838996, 4540062916685400669, 7812037871104887389}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94881857347024, 14336, 94881850724928, 94881857857376, 2, 94881837983210, 0, 9, 2, 94881850730880, 94881857347024, 94881850724928, 4, 2, 140734602838996}}}} [12:59:26.052] send_ready_for_query = false [12:59:26.052] idle_in_transaction_timeout_enabled = false [12:59:26.052] idle_session_timeout_enabled = false [12:59:26.052] __func__ = "PostgresMain" [12:59:26.052] #19 0x0000564b66115628 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:59:26.052] bsdata = [12:59:26.052] #20 0x0000564b65fc6d47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x7fff540282ec "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff54028340) at ../src/backend/postmaster/launch_backend.c:274 [12:59:26.052] pid = [12:59:26.052] #21 0x0000564b65fcbd42 in BackendStartup (client_sock=client_sock@entry=0x7fff54028340) at ../src/backend/postmaster/postmaster.c:3386 [12:59:26.052] bn = 0x564b676dc2a8 [12:59:26.052] pid = [12:59:26.052] startup_data = {canAcceptConnections = CAC_OK} [12:59:26.052] cac = [12:59:26.052] __func__ = "BackendStartup" [12:59:26.052] #22 0x0000564b65fcdc1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [12:59:26.052] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "}\255\355\177\000\000>\004\000\000\000\000\000\000\260\227\343\253\355\177\000\000\240o5\255\355\177\000\000\370\203\002T\377\177\000\000\364\203\002T\377\177", '\000' , "\"\246\024eKV\000\000\300\207\020eKV\000\000\300\204\002T\377\177\000\000\270\204\002T\377\177\000\000\225[\362\0010\024E\037\240Dd\254\355\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [12:59:26.052] i = 0 [12:59:26.052] now = [12:59:26.052] last_lockfile_recheck_time = 1735304117 [12:59:26.052] last_touch_time = 1735304117 [12:59:26.052] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 1409451264, user_data = 0x0}, {pos = 15, events = 0, fd = 1695852066, user_data = 0x7fedad808668}, {pos = -1402714576, events = 32749, fd = -1384086816, user_data = 0x7c96e577}, {pos = 1409451328, events = 32767, fd = -1384256952, user_data = 0xf}, {pos = -1402714576, events = 32749, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1384086816, user_data = 0x7fff540284b8}, {pos = 1409451200, events = 32767, fd = -1384085912, user_data = 0x0}, {pos = 1735088736, events = 22091, fd = -1410405019, user_data = 0x7fff540289d3}, {pos = 1, events = 0, fd = 1409451200, user_data = 0xffffffff}, {pos = -1411194848, events = 32749, fd = -1389006944, user_data = 0x564b676e1018}, {pos = 1735266040, events = 22091, fd = 1735265489, user_data = 0x7fedad7e4ebe}, {pos = 1, events = 0, fd = -1384086816, user_data = 0x1aa}, {pos = 1721109840, events = 22091, fd = 0, user_data = 0xd8}, {pos = 1735088672, events = 22091, fd = -1384231234, user_data = 0x1}, {pos = 0, events = 0, fd = -1411194848, user_data = 0x7fedabef2e40 }, {pos = 16, events = 0, fd = 1409452288, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fedad7e71ba}, {pos = 0, events = 0, fd = -1410667100, user_data = 0x0}, {pos = 1728130336, events = 22091, fd = 2, user_data = 0x0}, {pos = 1734827632, events = 22091, fd = 1952410737, user_data = 0x160}, {pos = 1721109248, events = 22091, fd = 4, user_data = 0x2ffff00001fa0}, {pos = 1735088672, events = 22091, fd = -1384231234, user_data = 0x1}, {pos = -1410633619, events = 32749, fd = -1411160888, user_data = 0x564b676e6720}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -1409344416, events = 32749, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x564b67675e70}, {pos = -1410631030, events = 32749, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 808726282, events = 1767311924, fd = 1769223265, user_data = 0x0}, {pos = 0, events = 4278190080, fd = 1751342899, user_data = 0x305f742f61746164}, {pos = 1684826485, events = 1769300527, fd = 1949262956, user_data = 0x0}, {pos = 0, events = 32512, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1409361440, events = 32749, fd = -1410723474, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x1f451430df225300}, {pos = -1409358368, events = 32749, fd = -328, user_data = 0x0}, {pos = 1735265720, events = 22091, fd = 1024, user_data = 0x564b676e0db8}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 39686, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1735088672, user_data = 0x7fedabef3053 }, {pos = 1735265720, events = 22091, fd = 1024, user_data = 0x7fff540289c8}, {pos = 1715526625, events = 22091, fd = 1728194864, user_data = 0x564b663fc69e }, {pos = 1735265520, events = 22091, fd = 1735081088, user_data = 0x564b676e0cf0}, {pos = -1410639682, events = 32749, fd = 0, user_data = 0x564b6640e308 }, {pos = 1735265520, events = 1, fd = 1715528785, user_data = 0x564b676b3c80}, {pos = -551398656, events = 524620848, fd = 0, user_data = 0x7fedabea2ab1}, {pos = -1410722576, events = 32749, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1734827632, user_data = 0x1f451430df225300}, {pos = 0, events = 0, fd = -551398656, user_data = 0xc}, {pos = -551398656, events = 524620848, fd = 0, user_data = 0x7fedabe5b239 }, {pos = 217, events = 0, fd = 1711041092, user_data = 0x400000}, {pos = 0, events = 0, fd = 1734827632, user_data = 0x564b663fc532 }, {pos = 1734914992, events = 22091, fd = 1735081088, user_data = 0x564b6768b3b0}, {pos = 1, events = 0, fd = 0, user_data = 0x564b663baccc }, {pos = 12, events = 0, fd = 1735256856, user_data = 0x564b676deaf8}, {pos = 1728131744, events = 22091, fd = 296, user_data = 0x564b65fc925e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1711057563, events = 22091, fd = 1724528176, user_data = 0x564b676b4638}} [12:59:26.052] nevents = 1 [12:59:26.052] __func__ = "ServerLoop" [12:59:26.052] #23 0x0000564b65fcf49c in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x564b67671ce0) at ../src/backend/postmaster/postmaster.c:1371 [12:59:26.052] opt = [12:59:26.052] status = [12:59:26.052] userDoption = [12:59:26.052] listen_addr_saved = false [12:59:26.052] output_config_variable = [12:59:26.052] __func__ = "PostmasterMain" [12:59:26.052] #24 0x0000564b65dfbb3e in main (argc=4, argv=0x564b67671ce0) at ../src/backend/main/main.c:230 [12:59:26.052] do_check_root = [12:59:26.052] dispatch_option = [12:59:26.070] -e [12:59:26.070] [12:59:26.070] [12:59:26.133] dumping /tmp/cores/postgres-6-40450.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [12:59:26.388] [New LWP 40450] [12:59:26.388] [12:59:26.388] This GDB supports auto-downloading debuginfo from the following URLs: [12:59:26.388] [12:59:26.388] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [12:59:26.388] Debuginfod has been disabled. [12:59:26.388] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [12:59:26.492] [Thread debugging using libthread_db enabled] [12:59:26.492] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [12:59:26.492] Core was generated by `postgres: test: postgres db1 [local] SELECT '. [12:59:26.492] Program terminated with signal SIGABRT, Aborted. [12:59:26.492] #0 0x00007fedabea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:26.550] [12:59:26.550] Thread 1 (Thread 0x7fedac635f00 (LWP 40450)): [12:59:26.550] #0 0x00007fedabea9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:26.550] No symbol table info available. [12:59:26.550] #1 0x00007fedabe5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:26.550] No symbol table info available. [12:59:26.550] #2 0x00007fedabe45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [12:59:26.550] No symbol table info available. [12:59:26.550] #3 0x00007fedac01e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [12:59:26.550] No locals. [12:59:26.550] #4 0x00007fedac02aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [12:59:26.550] No locals. [12:59:26.550] #5 0x00007fedac00dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x564b66c1c480, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [12:59:26.550] bp = 140734602836896 [12:59:26.550] pc = [12:59:26.550] Opts = {FromUnrecoverableHandler = true, pc = 94881832541840, bp = 140658573294760} [12:59:26.550] #6 0x0000564b65ec9e90 in examine_self_contradictory_rels (root=root@entry=0x564b677d71d8, rel=rel@entry=0x564b677e0ec8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [12:59:26.550] lc__state = [12:59:26.550] rlist = [12:59:26.550] i = 7 [12:59:26.550] br = [12:59:26.550] expression = [12:59:26.550] or_rinfo = 0x7feda04bcd38 [12:59:26.550] ccxt = [12:59:26.550] delidx = 0x7feda04bfe91 [12:59:26.550] arglst = [12:59:26.550] lc = [12:59:26.550] arg = [12:59:26.550] n = [12:59:26.550] restrictinfo = [12:59:26.550] ccwapper = {clausecxt = 0x7feda04bdb28} [12:59:26.550] sec = {sopcinfo = {n_members = 38, opcies = 0x7feda04bd2c8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7feda04bd6d8, atop_set = 0x7feda04bb398}, ccfree = 0x7feda04bfe60, vifree = 0x7feda04bed78} [12:59:26.550] __func__ = "examine_self_contradictory_rels" [12:59:26.550] #7 0x0000564b65eca09f in examine_self_contradictory_rels_phase1 (root=root@entry=0x564b677d71d8) at ../src/backend/optimizer/plan/contradictory.c:2608 [12:59:26.550] rel = 0x564b677e0ec8 [12:59:26.550] rti = 1 [12:59:26.550] rinfo = [12:59:26.550] #8 0x0000564b65e95058 in query_planner (root=root@entry=0x564b677d71d8, qp_callback=qp_callback@entry=0x564b65e9a375 , qp_extra=qp_extra@entry=0x7fff54027da0) at ../src/backend/optimizer/plan/planmain.c:193 [12:59:26.550] parse = 0x564b677cd9d0 [12:59:26.550] joinlist = 0x7feda04bb528 [12:59:26.550] final_rel = [12:59:26.550] __func__ = "query_planner" [12:59:26.550] #9 0x0000564b65ea7ad4 in grouping_planner (root=root@entry=0x564b677d71d8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1580 [12:59:26.550] sort_input_targets = 0x564b677d71d8 [12:59:26.550] sort_input_target_parallel_safe = [12:59:26.550] grouping_target = [12:59:26.550] scanjoin_target = [12:59:26.550] activeWindows = 0x0 [12:59:26.550] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [12:59:26.550] sort_input_targets_contain_srfs = 0x564b677d49d0 [12:59:26.550] have_grouping = [12:59:26.550] wflists = 0x0 [12:59:26.550] gset_data = 0x0 [12:59:26.550] sort_input_target = [12:59:26.550] grouping_targets = 0x564b677d4a18 [12:59:26.550] grouping_target_parallel_safe = [12:59:26.550] scanjoin_targets = 0x564b677d4a00 [12:59:26.550] scanjoin_target_parallel_safe = [12:59:26.550] grouping_targets_contain_srfs = 0x564b677d71d8 [12:59:26.550] scanjoin_targets_contain_srfs = 0x0 [12:59:26.550] scanjoin_target_same_exprs = [12:59:26.550] parse = 0x564b677cd9d0 [12:59:26.550] offset_est = 0 [12:59:26.550] count_est = 0 [12:59:26.550] limit_tuples = -1 [12:59:26.550] have_postponed_srfs = false [12:59:26.550] final_target = [12:59:26.550] final_targets = 0x564b677d71d8 [12:59:26.550] final_targets_contain_srfs = 0x7 [12:59:26.550] final_target_parallel_safe = [12:59:26.550] current_rel = [12:59:26.550] final_rel = [12:59:26.550] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94881858771408} [12:59:26.550] lc = [12:59:26.550] __func__ = "grouping_planner" [12:59:26.550] #10 0x0000564b65eaaa58 in subquery_planner (glob=, parse=0x564b677cd9d0, parent_root=parent_root@entry=0x564b677cab90, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1151 [12:59:26.550] root = 0x564b677d71d8 [12:59:26.550] newWithCheckOptions = [12:59:26.550] newHaving = 0x0 [12:59:26.550] hasOuterJoins = [12:59:26.550] hasResultRTEs = true [12:59:26.550] final_rel = [12:59:26.550] l = 0x0 [12:59:26.550] #11 0x0000564b65ebc3f2 in SS_process_ctes (root=root@entry=0x564b677cab90) at ../src/backend/optimizer/plan/subselect.c:966 [12:59:26.550] subquery = [12:59:26.550] cte = 0x564b6778ff60 [12:59:26.550] cmdType = [12:59:26.550] subroot = [12:59:26.550] final_rel = [12:59:26.550] best_path = [12:59:26.550] plan = [12:59:26.550] splan = [12:59:26.550] paramid = [12:59:26.550] lc__state = [12:59:26.550] lc = [12:59:26.550] __func__ = "SS_process_ctes" [12:59:26.550] #12 0x0000564b65ea94fc in subquery_planner (glob=glob@entry=0x564b677a4998, parse=parse@entry=0x564b677a4aa8, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:704 [12:59:26.550] root = 0x564b677cab90 [12:59:26.550] newWithCheckOptions = [12:59:26.550] newHaving = [12:59:26.550] hasOuterJoins = [12:59:26.550] hasResultRTEs = [12:59:26.550] final_rel = [12:59:26.550] l = [12:59:26.550] #13 0x0000564b65eab6e9 in standard_planner (parse=0x564b677a4aa8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:425 [12:59:26.550] result = [12:59:26.550] glob = 0x564b677a4998 [12:59:26.550] tuple_fraction = 0 [12:59:26.550] root = [12:59:26.550] final_rel = [12:59:26.550] best_path = [12:59:26.550] top_plan = [12:59:26.550] lp = [12:59:26.550] lr = [12:59:26.550] #14 0x0000564b65eac753 in planner (parse=parse@entry=0x564b677a4aa8, query_string=query_string@entry=0x564b676b45a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:292 [12:59:26.550] result = [12:59:26.550] #15 0x0000564b6611bd98 in pg_plan_query (querytree=querytree@entry=0x564b677a4aa8, query_string=query_string@entry=0x564b676b45a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:899 [12:59:26.550] plan = [12:59:26.550] #16 0x0000564b6611c179 in pg_plan_queries (querytrees=0x564b677cab40, query_string=query_string@entry=0x564b676b45a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:993 [12:59:26.550] query = 0x564b677a4aa8 [12:59:26.550] stmt = [12:59:26.550] query_list__state = [12:59:26.550] stmt_list = 0x0 [12:59:26.550] query_list = [12:59:26.550] #17 0x0000564b6611c726 in exec_simple_query (query_string=query_string@entry=0x564b676b45a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "...) at ../src/backend/tcop/postgres.c:1190 [12:59:26.550] cmdtaglen = 6 [12:59:26.550] snapshot_set = true [12:59:26.550] per_parsetree_context = 0x0 [12:59:26.550] plantree_list = [12:59:26.550] parsetree = 0x564b677a4918 [12:59:26.550] commandTag = CMDTAG_SELECT [12:59:26.550] qc = {commandTag = 1935, nprocessed = 94881857619360} [12:59:26.550] querytree_list = [12:59:26.550] portal = [12:59:26.550] receiver = [12:59:26.550] format = 0 [12:59:26.550] cmdtagname = [12:59:26.550] parsetree_item__state = [12:59:26.550] dest = DestRemote [12:59:26.550] oldcontext = 0x564b67744610 [12:59:26.550] parsetree_list = 0x564b677a4948 [12:59:26.550] parsetree_item = 0x564b677a4960 [12:59:26.550] save_log_statement_stats = false [12:59:26.550] was_logged = true [12:59:26.550] use_implicit_block = false [12:59:26.550] msec_str = "\004\000\000\000\000\000\000\000\373\301=fKV\000\000p\201\002T\377\177\000\000\217\a\000\000\000\000\000" [12:59:26.550] __func__ = "exec_simple_query" [12:59:26.550] #18 0x0000564b6611f5bd in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4691 [12:59:26.550] query_string = 0x564b676b45a0 "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 "... [12:59:26.550] firstchar = [12:59:26.550] input_message = {data = 0x564b676b45a0 "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} [12:59:26.550] local_sigjmp_buf = {{__jmpbuf = {94881850730872, 7812035794626218589, 140734602838764, 4, 3, 140734602838996, 4540062916685400669, 7812037871104887389}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94881857347024, 14336, 94881850724928, 94881857857376, 3, 94881837983210, 0, 9, 2, 94881850730880, 94881857347024, 94881850724928, 4, 3, 140734602838996}}}} [12:59:26.550] send_ready_for_query = false [12:59:26.550] idle_in_transaction_timeout_enabled = false [12:59:26.550] idle_session_timeout_enabled = false [12:59:26.550] __func__ = "PostgresMain" [12:59:26.550] #19 0x0000564b66115628 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [12:59:26.550] bsdata = [12:59:26.550] #20 0x0000564b65fc6d47 in postmaster_child_launch (child_type=B_BACKEND, child_slot=3, startup_data=startup_data@entry=0x7fff540282ec "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff54028340) at ../src/backend/postmaster/launch_backend.c:274 [12:59:26.550] pid = [12:59:26.550] #21 0x0000564b65fcbd42 in BackendStartup (client_sock=client_sock@entry=0x7fff54028340) at ../src/backend/postmaster/postmaster.c:3386 [12:59:26.550] bn = 0x564b676dc2d8 [12:59:26.550] pid = [12:59:26.550] startup_data = {canAcceptConnections = CAC_OK} [12:59:26.550] cac = [12:59:26.550] __func__ = "BackendStartup" [12:59:26.550] #22 0x0000564b65fcdc1b in ServerLoop () at ../src/backend/postmaster/postmaster.c:1673 [12:59:26.550] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "}\255\355\177\000\000>\004\000\000\000\000\000\000\260\227\343\253\355\177\000\000\240o5\255\355\177\000\000\370\203\002T\377\177\000\000\364\203\002T\377\177", '\000' , "\"\246\024eKV\000\000\300\207\020eKV\000\000\300\204\002T\377\177\000\000\270\204\002T\377\177\000\000\225[\362\0010\024E\037\240Dd\254\355\177\000\000+\000\000\000\000\000\000", __ss_align = 0}, salen = 2}} [12:59:26.550] i = 0 [12:59:26.550] now = [12:59:26.550] last_lockfile_recheck_time = 1735304117 [12:59:26.550] last_touch_time = 1735304117 [12:59:26.550] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 1382427086, events = 0, fd = 1409451264, user_data = 0x0}, {pos = 15, events = 0, fd = 1695852066, user_data = 0x7fedad808668}, {pos = -1402714576, events = 32749, fd = -1384086816, user_data = 0x7c96e577}, {pos = 1409451328, events = 32767, fd = -1384256952, user_data = 0xf}, {pos = -1402714576, events = 32749, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1384086816, user_data = 0x7fff540284b8}, {pos = 1409451200, events = 32767, fd = -1384085912, user_data = 0x0}, {pos = 1735088736, events = 22091, fd = -1410405019, user_data = 0x7fff540289d3}, {pos = 1, events = 0, fd = 1409451200, user_data = 0xffffffff}, {pos = -1411194848, events = 32749, fd = -1389006944, user_data = 0x564b676e1018}, {pos = 1735266040, events = 22091, fd = 1735265489, user_data = 0x7fedad7e4ebe}, {pos = 1, events = 0, fd = -1384086816, user_data = 0x1aa}, {pos = 1721109840, events = 22091, fd = 0, user_data = 0xd8}, {pos = 1735088672, events = 22091, fd = -1384231234, user_data = 0x1}, {pos = 0, events = 0, fd = -1411194848, user_data = 0x7fedabef2e40 }, {pos = 16, events = 0, fd = 1409452288, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fedad7e71ba}, {pos = 0, events = 0, fd = -1410667100, user_data = 0x0}, {pos = 1728130336, events = 22091, fd = 2, user_data = 0x0}, {pos = 1734827632, events = 22091, fd = 1952410737, user_data = 0x160}, {pos = 1721109248, events = 22091, fd = 4, user_data = 0x2ffff00001fa0}, {pos = 1735088672, events = 22091, fd = -1384231234, user_data = 0x1}, {pos = -1410633619, events = 32749, fd = -1411160888, user_data = 0x564b676e6720}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -1409344416, events = 32749, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x564b67675e70}, {pos = -1410631030, events = 32749, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 808726282, events = 1767311924, fd = 1769223265, user_data = 0x0}, {pos = 0, events = 4278190080, fd = 1751342899, user_data = 0x305f742f61746164}, {pos = 1684826485, events = 1769300527, fd = 1949262956, user_data = 0x0}, {pos = 0, events = 32512, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1409361440, events = 32749, fd = -1410723474, user_data = 0x100000400}, {pos = 7, events = 0, fd = 2, user_data = 0x1f451430df225300}, {pos = -1409358368, events = 32749, fd = -328, user_data = 0x0}, {pos = 1735265720, events = 22091, fd = 1024, user_data = 0x564b676e0db8}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3}, {pos = 0, events = 0, fd = 39686, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1735088672, user_data = 0x7fedabef3053 }, {pos = 1735265720, events = 22091, fd = 1024, user_data = 0x7fff540289c8}, {pos = 1715526625, events = 22091, fd = 1728194864, user_data = 0x564b663fc69e }, {pos = 1735265520, events = 22091, fd = 1735081088, user_data = 0x564b676e0cf0}, {pos = -1410639682, events = 32749, fd = 0, user_data = 0x564b6640e308 }, {pos = 1735265520, events = 1, fd = 1715528785, user_data = 0x564b676b3c80}, {pos = -551398656, events = 524620848, fd = 0, user_data = 0x7fedabea2ab1}, {pos = -1410722576, events = 32749, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1734827632, user_data = 0x1f451430df225300}, {pos = 0, events = 0, fd = -551398656, user_data = 0xc}, {pos = -551398656, events = 524620848, fd = 0, user_data = 0x7fedabe5b239 }, {pos = 217, events = 0, fd = 1711041092, user_data = 0x400000}, {pos = 0, events = 0, fd = 1734827632, user_data = 0x564b663fc532 }, {pos = 1734914992, events = 22091, fd = 1735081088, user_data = 0x564b6768b3b0}, {pos = 1, events = 0, fd = 0, user_data = 0x564b663baccc }, {pos = 12, events = 0, fd = 1735256856, user_data = 0x564b676deaf8}, {pos = 1728131744, events = 22091, fd = 296, user_data = 0x564b65fc925e }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1711057563, events = 22091, fd = 1724528176, user_data = 0x564b676b4638}} [12:59:26.550] nevents = 1 [12:59:26.550] __func__ = "ServerLoop" [12:59:26.550] #23 0x0000564b65fcf49c in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x564b67671ce0) at ../src/backend/postmaster/postmaster.c:1371 [12:59:26.550] opt = [12:59:26.550] status = [12:59:26.550] userDoption = [12:59:26.550] listen_addr_saved = false [12:59:26.550] output_config_variable = [12:59:26.550] __func__ = "PostmasterMain" [12:59:26.550] #24 0x0000564b65dfbb3e in main (argc=4, argv=0x564b67671ce0) at ../src/backend/main/main.c:230 [12:59:26.550] do_check_root = [12:59:26.550] dispatch_option =