[03:12:09.744] src/tools/ci/cores_backtrace.sh linux /tmp/cores [03:12:09.966] dumping /tmp/cores/postgres-6-25744.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:12:10.231] [New LWP 25744] [03:12:10.231] [03:12:10.231] This GDB supports auto-downloading debuginfo from the following URLs: [03:12:10.231] [03:12:10.231] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:12:10.231] Debuginfod has been disabled. [03:12:10.231] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:12:10.348] [Thread debugging using libthread_db enabled] [03:12:10.348] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:12:10.348] Core was generated by `postgres: postgres regression [local] ALTER TABLE '. [03:12:10.348] Program terminated with signal SIGABRT, Aborted. [03:12:10.348] #0 0x00007fe0fcaa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:11.439] [03:12:11.439] Thread 1 (Thread 0x7fe0faa5df00 (LWP 25744)): [03:12:11.439] #0 0x00007fe0fcaa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:11.439] No symbol table info available. [03:12:11.439] #1 0x00007fe0fca5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:11.439] No symbol table info available. [03:12:11.439] #2 0x00007fe0fca45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:11.439] No symbol table info available. [03:12:11.439] #3 0x00007fe0fcc1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [03:12:11.439] No locals. [03:12:11.439] #4 0x00007fe0fcc2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [03:12:11.439] No locals. [03:12:11.439] #5 0x00007fe0fcc0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55725d153b40, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [03:12:11.439] bp = 140734101450592 [03:12:11.439] pc = [03:12:11.439] Opts = {FromUnrecoverableHandler = true, pc = 93949662393587, bp = 93949713948136} [03:12:11.439] #6 0x000055725c40f4f3 in examine_self_contradictory_rels (root=root@entry=0x55725f3d8d18, rel=rel@entry=0x55725f5388d8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [03:12:11.439] lc__state = [03:12:11.439] rlist = [03:12:11.439] i = 4 [03:12:11.439] br = [03:12:11.439] expression = [03:12:11.439] or_rinfo = 0x55725f53bde0 [03:12:11.439] ccxt = [03:12:11.439] delidx = 0x55725f53bdc9 [03:12:11.439] arglst = [03:12:11.439] lc = [03:12:11.439] arg = [03:12:11.439] n = [03:12:11.439] restrictinfo = [03:12:11.439] ccwapper = {clausecxt = 0x55725f53b8e8} [03:12:11.439] sec = {sopcinfo = {n_members = 38, opcies = 0x55725f53afa8}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x55725f53ab48, atop_set = 0x55725f53b3b8}, ccfree = 0x55725f53bd98, vifree = 0x55725f53b458} [03:12:11.439] __func__ = "examine_self_contradictory_rels" [03:12:11.439] #7 0x000055725c40f702 in examine_self_contradictory_rels_phase1 (root=root@entry=0x55725f3d8d18) at ../src/backend/optimizer/plan/contradictory.c:2608 [03:12:11.439] rel = 0x55725f5388d8 [03:12:11.439] rti = 2 [03:12:11.439] rinfo = [03:12:11.439] #8 0x000055725c3d9d44 in query_planner (root=root@entry=0x55725f3d8d18, qp_callback=qp_callback@entry=0x55725c3df061 , qp_extra=qp_extra@entry=0x7fff361ff160) at ../src/backend/optimizer/plan/planmain.c:190 [03:12:11.439] parse = 0x55725f3d7470 [03:12:11.439] joinlist = 0x55725f539678 [03:12:11.439] final_rel = [03:12:11.439] __func__ = "query_planner" [03:12:11.439] #9 0x000055725c3ed137 in grouping_planner (root=root@entry=0x55725f3d8d18, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [03:12:11.439] sort_input_targets = 0x55725f513528 [03:12:11.439] sort_input_target_parallel_safe = [03:12:11.439] grouping_target = [03:12:11.439] scanjoin_target = [03:12:11.439] activeWindows = 0x0 [03:12:11.439] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [03:12:11.439] sort_input_targets_contain_srfs = 0x5 [03:12:11.439] have_grouping = [03:12:11.439] wflists = 0x0 [03:12:11.439] gset_data = 0x0 [03:12:11.439] sort_input_target = [03:12:11.439] grouping_targets = 0x0 [03:12:11.439] grouping_target_parallel_safe = [03:12:11.439] scanjoin_targets = 0x55725f3d8d18 [03:12:11.439] scanjoin_target_parallel_safe = [03:12:11.439] grouping_targets_contain_srfs = 0x55725f513738 [03:12:11.439] scanjoin_targets_contain_srfs = 0x0 [03:12:11.439] scanjoin_target_same_exprs = [03:12:11.439] parse = 0x55725f3d7470 [03:12:11.439] offset_est = 0 [03:12:11.439] count_est = 0 [03:12:11.439] limit_tuples = -1 [03:12:11.439] have_postponed_srfs = false [03:12:11.439] final_target = [03:12:11.439] final_targets = 0x55725f3d8000 [03:12:11.439] final_targets_contain_srfs = 0x55725c42e450 [03:12:11.439] final_target_parallel_safe = [03:12:11.439] current_rel = [03:12:11.439] final_rel = [03:12:11.439] extra = {limit_needed = 248, limit_tuples = 4.6417325383919827e-310, count_est = 93949713790776, offset_est = 93949712502040} [03:12:11.439] lc = [03:12:11.439] __func__ = "grouping_planner" [03:12:11.439] #10 0x000055725c3f00bb in subquery_planner (glob=glob@entry=0x55725f3d8c08, parse=parse@entry=0x55725f3d7470, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1153 [03:12:11.439] root = 0x55725f3d8d18 [03:12:11.439] newWithCheckOptions = [03:12:11.439] newHaving = 0x0 [03:12:11.439] hasOuterJoins = [03:12:11.439] hasResultRTEs = false [03:12:11.439] final_rel = [03:12:11.439] l = 0x0 [03:12:11.439] #11 0x000055725c3f0d4c in standard_planner (parse=0x55725f3d7470, query_string=, cursorOptions=0, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [03:12:11.439] result = [03:12:11.439] glob = 0x55725f3d8c08 [03:12:11.439] tuple_fraction = 0 [03:12:11.439] root = [03:12:11.439] final_rel = [03:12:11.439] best_path = [03:12:11.439] top_plan = [03:12:11.439] lp = [03:12:11.439] lr = [03:12:11.439] #12 0x000055725c3f1db6 in planner (parse=parse@entry=0x55725f3d7470, query_string=query_string@entry=0x55725f541908 "SELECT fk.\"a\" FROM ONLY \"fkpart4\".\"dropfk\" fk JOIN \"fkpart4\".\"droppk2_d\" pk ON ( pk.\"a\" OPERATOR(pg_catalog.=) fk.\"a\") WHERE ((pk.a IS NOT NULL) AND (pk.a >= 1000) AND (pk.a < 2000) AND (NOT ((pk.a IS"..., cursorOptions=cursorOptions@entry=0, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:294 [03:12:11.439] result = [03:12:11.439] #13 0x000055725c660dcc in pg_plan_query (querytree=querytree@entry=0x55725f3d7470, query_string=query_string@entry=0x55725f541908 "SELECT fk.\"a\" FROM ONLY \"fkpart4\".\"dropfk\" fk JOIN \"fkpart4\".\"droppk2_d\" pk ON ( pk.\"a\" OPERATOR(pg_catalog.=) fk.\"a\") WHERE ((pk.a IS NOT NULL) AND (pk.a >= 1000) AND (pk.a < 2000) AND (NOT ((pk.a IS"..., cursorOptions=cursorOptions@entry=0, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [03:12:11.439] plan = [03:12:11.439] #14 0x000055725c6611ad in pg_plan_queries (querytrees=querytrees@entry=0x55725f3d7420, query_string=0x55725f541908 "SELECT fk.\"a\" FROM ONLY \"fkpart4\".\"dropfk\" fk JOIN \"fkpart4\".\"droppk2_d\" pk ON ( pk.\"a\" OPERATOR(pg_catalog.=) fk.\"a\") WHERE ((pk.a IS NOT NULL) AND (pk.a >= 1000) AND (pk.a < 2000) AND (NOT ((pk.a IS"..., cursorOptions=0, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:1005 [03:12:11.439] query = 0x55725f3d7470 [03:12:11.439] stmt = [03:12:11.439] query_list__state = [03:12:11.439] stmt_list = 0x0 [03:12:11.439] query_list = [03:12:11.439] #15 0x000055725c8d2fef in BuildCachedPlan (plansource=plansource@entry=0x55725f542cf0, qlist=0x55725f3d7420, qlist@entry=0x0, boundParams=boundParams@entry=0x0, queryEnv=queryEnv@entry=0x0) at ../src/backend/utils/cache/plancache.c:962 [03:12:11.439] plan = [03:12:11.439] plist = [03:12:11.439] snapshot_set = false [03:12:11.439] is_transient = [03:12:11.439] plan_context = [03:12:11.439] oldcxt = 0x55725f3d7320 [03:12:11.439] lc = [03:12:11.439] #16 0x000055725c8d390e in GetCachedPlan (plansource=plansource@entry=0x55725f542cf0, boundParams=0x0, owner=owner@entry=0x0, queryEnv=0x0) at ../src/backend/utils/cache/plancache.c:1199 [03:12:11.439] plan = 0x0 [03:12:11.439] qlist = 0x0 [03:12:11.439] customplan = false [03:12:11.439] __func__ = "GetCachedPlan" [03:12:11.439] #17 0x000055725c30e9f4 in _SPI_execute_plan (plan=plan@entry=0x55725f528110, options=options@entry=0x7fff361ff530, snapshot=snapshot@entry=0x55725d551ea0 , crosscheck_snapshot=crosscheck_snapshot@entry=0x0, fire_triggers=fire_triggers@entry=false) at ../src/backend/executor/spi.c:2577 [03:12:11.439] plansource = 0x55725f542cf0 [03:12:11.439] stmt_list = [03:12:11.439] lc2 = [03:12:11.439] lc1__state = [03:12:11.439] my_res = 0 [03:12:11.439] my_processed = 0 [03:12:11.439] my_tuptable = 0x0 [03:12:11.439] res = [03:12:11.439] allow_nonatomic = false [03:12:11.439] pushed_active_snap = true [03:12:11.439] plan_owner = 0x0 [03:12:11.439] spicallbackarg = {query = 0x55725f541908 "SELECT fk.\"a\" FROM ONLY \"fkpart4\".\"dropfk\" fk JOIN \"fkpart4\".\"droppk2_d\" pk ON ( pk.\"a\" OPERATOR(pg_catalog.=) fk.\"a\") WHERE ((pk.a IS NOT NULL) AND (pk.a >= 1000) AND (pk.a < 2000) AND (NOT ((pk.a IS"..., mode = RAW_PARSE_DEFAULT} [03:12:11.439] spierrcontext = {previous = 0x0, callback = 0x55725c309255 <_SPI_error_callback>, arg = 0x7fff361ff4d0} [03:12:11.439] cplan = 0x0 [03:12:11.439] lc1 = [03:12:11.439] __func__ = "_SPI_execute_plan" [03:12:11.439] #18 0x000055725c30f0b4 in SPI_execute_snapshot (plan=plan@entry=0x55725f528110, Values=Values@entry=0x0, Nulls=Nulls@entry=0x0, snapshot=0x55725d551ea0 , crosscheck_snapshot=crosscheck_snapshot@entry=0x0, read_only=read_only@entry=true, fire_triggers=false, tcount=1) at ../src/backend/executor/spi.c:797 [03:12:11.439] options = {params = 0x0, read_only = true, allow_nonatomic = false, must_return_tuples = false, tcount = 1, dest = 0x0, owner = 0x0} [03:12:11.439] res = 0 [03:12:11.439] #19 0x000055725c80becb in RI_PartitionRemove_Check (trigger=trigger@entry=0x7fff361ffc70, fk_rel=fk_rel@entry=0x7fe0f0fc65a8, pk_rel=pk_rel@entry=0x7fe0f0fc8288) at ../src/backend/utils/adt/ri_triggers.c:1878 [03:12:11.439] riinfo = 0x55725f5319d8 [03:12:11.439] querybuf = {data = 0x55725f505f18 "SELECT fk.\"a\" FROM ONLY \"fkpart4\".\"dropfk\" fk JOIN \"fkpart4\".\"droppk2_d\" pk ON ( pk.\"a\" OPERATOR(pg_catalog.=) fk.\"a\") WHERE ((pk.a IS NOT NULL) AND (pk.a >= 1000) AND (pk.a < 2000) AND (NOT ((pk.a IS"..., len = 277, maxlen = 1024, cursor = 0} [03:12:11.439] constraintDef = [03:12:11.439] pkrelname = "\"fkpart4\".\"droppk2_d\"\000\000\000@W\347\371\340\177\000\000\000\255,\361\340\177\000\000Ȧ7_rU\000\000Ȧ7_rU\000\000\020\374\0376\377\177\000\000\005\000\000\000\000\000\000\000\357Pb\\rU\000\000Ȧ7_rU\000\000\003\240b\\rU\000\000\b\374\0376\377\177\000\000\000\000\000\000Ô\020\226`\216!_rU\000\000\340\004\221\\rU\000\000,\374\0376\377\177\000\000\340\021\267\374\340\177\000\000\006B\214\\", '\000' , "\364\251\000\000\000\000\000\000\b\312#_rU\000\000\000\000\000\000\000\000\000\000\260\260#_rU\000\000,\374\0376\377\177", '\000' ... [03:12:11.439] fkrelname = "\"fkpart4\".\"dropfk\"\000\360\340\177\000\000`R\003\\rU\000\000\370\220\374\360\340\177\000\000_\345\213\\rU\000\000\001\000\000\000\000\000\000\000f\005<\027\006\000\000\000\003\252", '\000' , "\001\000\003\000\000\000\000\000\000\000\000\000\303\340e\b\000\000\000\000\000b\031_rU\000\000\200z\265\371\340\177\000\000\003\000\000\000\000\000\000\000\020\000\000\000\000\000\000\000\203\b\221\\rU\000\000\020\373\0376\377\177\000\000\340\021\267\374\340\177\000\000@W\347\371\003\000\000\000\017\373\0376\377\177\000\000\260\363\350\371\340\177\000\000"... [03:12:11.439] pkattname = "pk.\"a\"\000\000\037\177\253\374\340\177\000\000\000@\000\000.\n\000\000\000\000\000\000\000\000\000\001\001\000\000\000\340\177\000\000<ȓ\\rU\000\000\000\222&_rU\000\000\001\000\000\000\000\000\000\000XTR_rU\000\000\000*$_rU", '\000' , "\212\030\361\340\177\000\000\001\000\000\000\000\000\000\0004\036b\\rU\000\000\000@\000\000.\n\000\000\000\000\000\000\000\000\000\001\001\000\000\000\000" [03:12:11.439] fkattname = "\"a\"\000a\"\000\000\002", '\000' , "Ȧ7_rU\000\000\320\371\0376\377\177\000\000c\n\221\\rU\000\000\000\000\000\000\000\000\000\000Ȧ7_rU\000\000\377\377\377\377", '\000' , "X\2219_rU\000\000\260Yb\\rU\000\000X\2219_rU\000\000\001\000\000\000\000\000\000\000X\2219_rU\000\000\247\262b\\rU\000\000(\375T_\001" [03:12:11.439] sep = 0x55725cb56fd2 " AND " [03:12:11.439] fk_only = [03:12:11.439] save_nestlevel = 2 [03:12:11.439] workmembuf = "65536\000\000\000\350\177#_rU\000\000}\v\000\000\000\000\000\000\220p#_rU\000" [03:12:11.439] spi_result = [03:12:11.439] qplan = 0x55725f528110 [03:12:11.439] i = [03:12:11.439] __func__ = "RI_PartitionRemove_Check" [03:12:11.439] #20 0x000055725c1be5e6 in ATDetachCheckNoForeignKeyRefs (partition=partition@entry=0x7fe0f0fc8288) at ../src/backend/commands/tablecmds.c:20729 [03:12:11.439] constrOid = [03:12:11.439] rel = 0x7fe0f0fc65a8 [03:12:11.439] trig = {tgoid = 0, tgname = 0x7fe0f0fc9184 "dropfk_a_fkey4", tgfoid = 0, tgtype = 0, tgenabled = 79 'O', tgisinternal = true, tgisclone = false, tgconstrrelid = 43502, tgconstrindid = 43505, tgconstraint = 43523, tgdeferrable = false, tginitdeferred = false, tgnargs = 0, tgnattr = 0, tgattr = 0x0, tgargs = 0x0, tgqual = 0x0, tgoldtable = 0x0, tgnewtable = 0x0} [03:12:11.439] tuple = 0x7fe0f0fc9138 [03:12:11.439] constrForm = [03:12:11.439] cell__state = [03:12:11.439] constraints = 0x55725f505ec8 [03:12:11.439] cell = [03:12:11.439] __func__ = "ATDetachCheckNoForeignKeyRefs" [03:12:11.439] #21 0x000055725c1f5a6e in ATExecDetachPartition (wqueue=wqueue@entry=0x7fff361ffe88, tab=tab@entry=0x55725f526628, rel=rel@entry=0x7fe0f0fbc3e8, name=, concurrent=) at ../src/backend/commands/tablecmds.c:19712 [03:12:11.439] partRel = 0x7fe0f0fc8288 [03:12:11.439] address = {classId = 0, objectId = 0, objectSubId = 8} [03:12:11.439] defaultPartOid = 43502 [03:12:11.439] __func__ = "ATExecDetachPartition" [03:12:11.439] #22 0x000055725c1f71d8 in ATExecCmd (wqueue=wqueue@entry=0x7fff361ffe88, tab=tab@entry=0x55725f526628, cmd=, lockmode=lockmode@entry=8, cur_pass=cur_pass@entry=AT_PASS_MISC, context=context@entry=0x7fff361fff70) at ../src/backend/commands/tablecmds.c:5580 [03:12:11.439] address = {classId = 0, objectId = 0, objectSubId = 0} [03:12:11.439] rel = 0x7fe0f0fbc3e8 [03:12:11.439] __func__ = "ATExecCmd" [03:12:11.439] #23 0x000055725c1f7453 in ATRewriteCatalogs (wqueue=wqueue@entry=0x7fff361ffe88, lockmode=lockmode@entry=8, context=context@entry=0x7fff361fff70) at ../src/backend/commands/tablecmds.c:5245 [03:12:11.439] lcmd__state = [03:12:11.439] tab = 0x55725f526628 [03:12:11.439] subcmds = 0x55725f523448 [03:12:11.439] lcmd = [03:12:11.439] ltab__state = [03:12:11.439] pass = AT_PASS_MISC [03:12:11.439] ltab = [03:12:11.439] #24 0x000055725c1f79ad in ATController (parsetree=parsetree@entry=0x55725f1d7630, rel=rel@entry=0x7fe0f0fbc3e8, cmds=, recurse=, lockmode=lockmode@entry=8, context=context@entry=0x7fff361fff70) at ../src/backend/commands/tablecmds.c:4802 [03:12:11.439] wqueue = 0x55725f5095a0 [03:12:11.439] lcmd = 0x0 [03:12:11.439] #25 0x000055725c1f7a64 in AlterTable (stmt=stmt@entry=0x55725f1d7630, lockmode=lockmode@entry=8, context=context@entry=0x7fff361fff70) at ../src/backend/commands/tablecmds.c:4457 [03:12:11.439] rel = 0x7fe0f0fbc3e8 [03:12:11.439] #26 0x000055725c66c92f in ProcessUtilitySlow (pstate=pstate@entry=0x55725f509490, pstmt=pstmt@entry=0x55725f1d7730, queryString=queryString@entry=0x55725f1d6af0 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x55725f1d7af0, qc=0x7fff36200490) at ../src/backend/tcop/utility.c:1321 [03:12:11.439] atcontext = {pstmt = 0x55725f1d7730, queryString = 0x55725f1d6af0 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;", relid = 43490, params = 0x0, queryEnv = 0x0} [03:12:11.439] atstmt = 0x55725f1d7630 [03:12:11.439] relid = 43490 [03:12:11.439] lockmode = 8 [03:12:11.439] cell = 0x0 [03:12:11.439] _save_exception_stack = 0x7fff36200350 [03:12:11.439] _save_context_stack = 0x0 [03:12:11.439] _local_sigjmp_buf = {{__jmpbuf = {0, 1767546265528360762, 93949710399024, 0, 93949710396144, 0, 5592705423959580474, 1767543014994665274}, __mask_was_saved = 0, __saved_mask = {__val = {0, 0, 93949668133338, 0, 0, 3659, 1549668433, 93949711587760, 93949660765862, 93949712413776, 0, 93949712413776, 93949668132107, 140604254576056, 3546362821509843749, 93949670656802}}}} [03:12:11.439] _do_rethrow = false [03:12:11.439] parsetree = 0x55725f1d7630 [03:12:11.439] isTopLevel = true [03:12:11.439] isCompleteQuery = true [03:12:11.439] needCleanup = false [03:12:11.439] commandCollected = false [03:12:11.439] address = {classId = 21874, objectId = 1595766320, objectSubId = 21874} [03:12:11.439] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [03:12:11.439] __func__ = "ProcessUtilitySlow" [03:12:11.439] #27 0x000055725c66bf81 in standard_ProcessUtility (pstmt=0x55725f1d7730, queryString=0x55725f1d6af0 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x55725f1d7af0, qc=0x7fff36200490) at ../src/backend/tcop/utility.c:1070 [03:12:11.439] parsetree = 0x55725f1d7630 [03:12:11.439] isTopLevel = true [03:12:11.439] isAtomicContext = false [03:12:11.439] pstate = 0x55725f509490 [03:12:11.439] readonly_flags = [03:12:11.439] __func__ = "standard_ProcessUtility" [03:12:11.439] #28 0x000055725c66c0dc in ProcessUtility (pstmt=pstmt@entry=0x55725f1d7730, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55725f1d7af0, qc=0x7fff36200490) at ../src/backend/tcop/utility.c:523 [03:12:11.439] No locals. [03:12:11.439] #29 0x000055725c667948 in PortalRunUtility (portal=portal@entry=0x55725f25b100, pstmt=pstmt@entry=0x55725f1d7730, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55725f1d7af0, qc=qc@entry=0x7fff36200490) at ../src/backend/tcop/pquery.c:1158 [03:12:11.439] No locals. [03:12:11.439] #30 0x000055725c667eed in PortalRunMulti (portal=portal@entry=0x55725f25b100, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@entry=0x55725f1d7af0, altdest=altdest@entry=0x55725f1d7af0, qc=qc@entry=0x7fff36200490) at ../src/backend/tcop/pquery.c:1315 [03:12:11.439] pstmt = 0x55725f1d7730 [03:12:11.439] stmtlist_item__state = [03:12:11.439] active_snapshot_set = false [03:12:11.439] stmtlist_item = 0x55725f1d7ab8 [03:12:11.439] #31 0x000055725c6684c0 in PortalRun (portal=portal@entry=0x55725f25b100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55725f1d7af0, altdest=altdest@entry=0x55725f1d7af0, qc=0x7fff36200490) at ../src/backend/tcop/pquery.c:791 [03:12:11.439] _save_exception_stack = 0x7fff36200540 [03:12:11.439] _save_context_stack = 0x0 [03:12:11.439] _local_sigjmp_buf = {{__jmpbuf = {0, 1767546265436086074, 93949710938368, 93949710399224, 93949710938368, 93949710399152, 5592704980416126778, 1767543012769718074}, __mask_was_saved = 0, __saved_mask = {__val = {93949667815807, 93949710395888, 112, 4, 93949667820224, 908067871, 4, 93949710399152, 112, 34, 93949710938368, 93949710399224, 93949710399200, 93949710399152, 93949667907427, 93949710399152}}}} [03:12:11.439] _do_rethrow = [03:12:11.439] result = [03:12:11.439] nprocessed = [03:12:11.439] saveTopTransactionResourceOwner = 0x55725f218658 [03:12:11.439] saveTopTransactionContext = 0x55725f269040 [03:12:11.439] saveActivePortal = 0x0 [03:12:11.439] saveResourceOwner = 0x55725f218658 [03:12:11.439] savePortalContext = 0x0 [03:12:11.439] saveMemoryContext = 0x55725f269040 [03:12:11.439] __func__ = "PortalRun" [03:12:11.439] #32 0x000055725c6618a2 in exec_simple_query (query_string=query_string@entry=0x55725f1d6af0 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;") at ../src/backend/tcop/postgres.c:1283 [03:12:11.439] cmdtaglen = 11 [03:12:11.439] snapshot_set = [03:12:11.439] per_parsetree_context = 0x0 [03:12:11.439] plantree_list = 0x55725f1d7aa0 [03:12:11.439] parsetree = 0x55725f1d76b0 [03:12:11.439] commandTag = [03:12:11.439] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:12:11.439] querytree_list = [03:12:11.439] portal = 0x55725f25b100 [03:12:11.439] receiver = 0x55725f1d7af0 [03:12:11.439] format = 0 [03:12:11.439] cmdtagname = [03:12:11.439] parsetree_item__state = [03:12:11.439] dest = DestRemote [03:12:11.439] oldcontext = 0x55725f269040 [03:12:11.439] parsetree_list = 0x55725f1d76e0 [03:12:11.439] parsetree_item = 0x55725f1d76f8 [03:12:11.439] save_log_statement_stats = false [03:12:11.439] was_logged = false [03:12:11.439] use_implicit_block = false [03:12:11.439] msec_str = "\004\000\000\000\000\000\000\000Nߑ\\rU\000\000 \005 6\377\177\000\0000\000\000\000\000\000\000" [03:12:11.439] __func__ = "exec_simple_query" [03:12:11.439] #33 0x000055725c664626 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4809 [03:12:11.439] query_string = 0x55725f1d6af0 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;" [03:12:11.439] firstchar = [03:12:11.439] input_message = {data = 0x55725f1d6af0 "ALTER TABLE droppk2 DETACH PARTITION droppk2_d;", len = 48, maxlen = 1024, cursor = 48} [03:12:11.439] local_sigjmp_buf = {{__jmpbuf = {93949680491832, 1767541247716810554, 140734101456540, 4, 6, 140734101456772, 5592704980302880570, 1767543007556591418}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93949710126608, 15616, 93949680485920, 93949710658928, 6, 93949667819772, 0, 9, 2, 93949680491840, 93949710126608, 93949680485920, 4, 6, 140734101456772}}}} [03:12:11.439] send_ready_for_query = false [03:12:11.439] idle_in_transaction_timeout_enabled = false [03:12:11.439] idle_session_timeout_enabled = false [03:12:11.439] __func__ = "PostgresMain" [03:12:11.439] #34 0x000055725c65a489 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:12:11.439] bsdata = [03:12:11.439] #35 0x000055725c50c0e6 in postmaster_child_launch (child_type=B_BACKEND, child_slot=6, startup_data=startup_data@entry=0x7fff3620069c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff362006f0) at ../src/backend/postmaster/launch_backend.c:274 [03:12:11.439] pid = [03:12:11.439] #36 0x000055725c5110e1 in BackendStartup (client_sock=client_sock@entry=0x7fff362006f0) at ../src/backend/postmaster/postmaster.c:3377 [03:12:11.439] bn = 0x55725f1ff158 [03:12:11.439] pid = [03:12:11.439] startup_data = {canAcceptConnections = CAC_OK} [03:12:11.439] cac = [03:12:11.439] __func__ = "BackendStartup" [03:12:11.439] #37 0x000055725c512fba in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [03:12:11.439] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\272Sj[rU\000\000\2007f[rU\000\000@\b 6\377\177\000\0008\b 6\377\177\000\000\225[\362\001\000\000\000\000\240\204\210\375\340\177\000\000+", '\000' , "\377\177\000\000\000\004\000\000\000\000\000\000h\226E\376\340\177\000\0000\206\210\375\340\177\000\000\340\222E\376\340\177\000\000\316)fR\000\000\000", __ss_align = 908068992}, salen = 2}} [03:12:11.439] i = 0 [03:12:11.439] now = [03:12:11.439] last_lockfile_recheck_time = 1733281686 [03:12:11.439] last_touch_time = 1733281686 [03:12:11.439] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = -28994848, user_data = 0x0}, {pos = 908069056, events = 32767, fd = -29164984, user_data = 0xf}, {pos = -41384400, events = 32736, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -28994848, user_data = 0x7fff36200838}, {pos = 908068928, events = 32767, fd = -28993944, user_data = 0x0}, {pos = 1595763632, events = 21874, fd = -55870838, user_data = 0x55725f1d6bb0}, {pos = 1, events = 21874, fd = 32768, user_data = 0xffffffff}, {pos = -56434656, events = 32736, fd = -33914976, user_data = 0x55725f202198}, {pos = 1595940984, events = 21874, fd = 1595950177, user_data = 0x7fe0fe435ebe}, {pos = 1, events = 0, fd = -28994848, user_data = 0x1ab}, {pos = 1558826328, events = 21874, fd = 0, user_data = 0xec}, {pos = 1595763632, events = 21874, fd = -29139266, user_data = 0x1}, {pos = 0, events = 0, fd = -56434656, user_data = 0x7fe0fcaf2e40 }, {pos = 16, events = 0, fd = 908070064, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fe0fe4381ba}, {pos = 0, events = 0, fd = -55906908, user_data = 0x0}, {pos = 1565794560, events = 21874, fd = 2, user_data = 0x0}, {pos = 1595510448, events = 21874, fd = 1549743091, user_data = 0x55725f209cc0}, {pos = 1549747080, events = 21874, fd = 1595972891, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -56400696, user_data = 0x7fe0fca9c880 }, {pos = -89793096, events = 32736, fd = 908070256, user_data = 0x100007f00000002}, {pos = -55873785, events = 32736, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -54584224, events = 32736, 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 = 1884846186, fd = 168455528, user_data = 0x32333337310a6174}, {pos = 943075640, events = 808716854, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1595944032, events = 21874, fd = -55870838, user_data = 0xa}, {pos = 1553183103, events = 21874, fd = 1595956368, user_data = 0x7fe0fcab576b}, {pos = -54601248, events = 32736, fd = -55963282, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xe312c15841774600}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55725f201e70}, {pos = 1, events = 0, fd = 1595940664, user_data = 0x3}, {pos = 0, events = 0, fd = 20851, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1595763632, user_data = 0x7fe0fcaf3053 }, {pos = 1595940664, events = 21874, fd = 1024, user_data = 0x7fff36200d78}, {pos = 1553266419, events = 21874, fd = 1565859056, user_data = 0x55725c93e1b0 }, {pos = 1595940464, events = 21874, fd = 1595763184, user_data = 0x55725f201e70}, {pos = -55879829, events = 32736, fd = 0, user_data = 0x55725c94fe1a }, {pos = 1595940464, events = 1, fd = 1553268579, user_data = 0x55725f1d69f0}, {pos = 1098335744, events = 3809657176, fd = 0, user_data = 0x7fe0fcaa2ab1}, {pos = -55962384, events = 32736, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1595510448, user_data = 0xe312c15841774600}, {pos = 0, events = 0, fd = 1098335744, user_data = 0xc}, {pos = 1098335744, events = 3809657176, fd = 0, user_data = 0x7fe0fca5b239 }, {pos = 237, events = 0, fd = 1548795363, user_data = 0x400000}, {pos = 0, events = 0, fd = 1595510448, user_data = 0x55725c93e044 }, {pos = 1595597088, events = 21874, fd = 1595763184, user_data = 0x55725f1ae120}, {pos = 1, events = 0, fd = 0, user_data = 0x55725c8fca41 }, {pos = 12, events = 0, fd = 1595940040, user_data = 0x55725f201ca8}, {pos = 1565795968, events = 21874, fd = 296, user_data = 0x55725c50e5fd }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1548811834, events = 21874, fd = 1562224688, user_data = 0x55725f1d73c8}} [03:12:11.440] nevents = 1 [03:12:11.440] __func__ = "ServerLoop" [03:12:11.440] #38 0x000055725c5147dd in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55725f194d70) at ../src/backend/postmaster/postmaster.c:1361 [03:12:11.440] opt = [03:12:11.440] status = [03:12:11.440] userDoption = [03:12:11.440] listen_addr_saved = false [03:12:11.440] output_config_variable = [03:12:11.440] __func__ = "PostmasterMain" [03:12:11.440] #39 0x000055725c341881 in main (argc=8, argv=0x55725f194d70) at ../src/backend/main/main.c:196 [03:12:11.440] do_check_root = [03:12:11.479] -e [03:12:11.479] [03:12:11.479] [03:12:11.548] dumping /tmp/cores/postgres-6-23324.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:12:11.823] [New LWP 23324] [03:12:11.823] [03:12:11.823] This GDB supports auto-downloading debuginfo from the following URLs: [03:12:11.823] [03:12:11.823] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:12:11.823] Debuginfod has been disabled. [03:12:11.823] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:12:11.940] [Thread debugging using libthread_db enabled] [03:12:11.940] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:12:11.940] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [03:12:11.940] Program terminated with signal SIGABRT, Aborted. [03:12:11.940] #0 0x00007fe0fcaa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:13.020] [03:12:13.020] Thread 1 (Thread 0x7fe0faa5df00 (LWP 23324)): [03:12:13.020] #0 0x00007fe0fcaa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:13.020] No symbol table info available. [03:12:13.020] #1 0x00007fe0fca5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:13.020] No symbol table info available. [03:12:13.020] #2 0x00007fe0fca45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:13.020] No symbol table info available. [03:12:13.020] #3 0x00007fe0fcc1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [03:12:13.020] No locals. [03:12:13.020] #4 0x00007fe0fcc2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [03:12:13.020] No locals. [03:12:13.020] #5 0x00007fe0fcc0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55725d153b40, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [03:12:13.020] bp = 140734101453760 [03:12:13.020] pc = [03:12:13.020] Opts = {FromUnrecoverableHandler = true, pc = 93949662393587, bp = 93949712458000} [03:12:13.020] #6 0x000055725c40f4f3 in examine_self_contradictory_rels (root=root@entry=0x55725f426e28, rel=rel@entry=0x55725f3aa328, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [03:12:13.020] lc__state = [03:12:13.020] rlist = [03:12:13.020] i = 2 [03:12:13.020] br = [03:12:13.020] expression = [03:12:13.020] or_rinfo = 0x55725f3cf2e8 [03:12:13.020] ccxt = [03:12:13.020] delidx = 0x55725f3cefe1 [03:12:13.020] arglst = [03:12:13.020] lc = [03:12:13.020] arg = [03:12:13.020] n = [03:12:13.020] restrictinfo = [03:12:13.020] ccwapper = {clausecxt = 0x55725f3ce958} [03:12:13.020] sec = {sopcinfo = {n_members = 38, opcies = 0x55725f3ce428}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x55725f3cddc0, atop_set = 0x55725f3ce838}, ccfree = 0x55725f3cef60, vifree = 0x55725f3ce9f8} [03:12:13.020] __func__ = "examine_self_contradictory_rels" [03:12:13.020] #7 0x000055725c40f702 in examine_self_contradictory_rels_phase1 (root=root@entry=0x55725f426e28) at ../src/backend/optimizer/plan/contradictory.c:2608 [03:12:13.020] rel = 0x55725f3aa328 [03:12:13.020] rti = 1 [03:12:13.020] rinfo = [03:12:13.020] #8 0x000055725c3d9d44 in query_planner (root=root@entry=0x55725f426e28, qp_callback=qp_callback@entry=0x55725c3df061 , qp_extra=qp_extra@entry=0x7fff361ffdc0) at ../src/backend/optimizer/plan/planmain.c:190 [03:12:13.020] parse = 0x55725f1d7f70 [03:12:13.020] joinlist = 0x55725f3cde30 [03:12:13.020] final_rel = [03:12:13.020] __func__ = "query_planner" [03:12:13.020] #9 0x000055725c3ed137 in grouping_planner (root=root@entry=0x55725f426e28, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [03:12:13.020] sort_input_targets = 0x5 [03:12:13.020] sort_input_target_parallel_safe = [03:12:13.020] grouping_target = [03:12:13.020] scanjoin_target = [03:12:13.020] activeWindows = 0x0 [03:12:13.020] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [03:12:13.020] sort_input_targets_contain_srfs = 0x1 [03:12:13.020] have_grouping = [03:12:13.020] wflists = 0x0 [03:12:13.020] gset_data = 0x0 [03:12:13.020] sort_input_target = [03:12:13.020] grouping_targets = 0x1 [03:12:13.020] grouping_target_parallel_safe = [03:12:13.020] scanjoin_targets = 0x0 [03:12:13.020] scanjoin_target_parallel_safe = [03:12:13.020] grouping_targets_contain_srfs = 0x1 [03:12:13.020] scanjoin_targets_contain_srfs = 0x55725c9515ca [03:12:13.020] scanjoin_target_same_exprs = [03:12:13.020] parse = 0x55725f1d7f70 [03:12:13.020] offset_est = 0 [03:12:13.020] count_est = 0 [03:12:13.020] limit_tuples = -1 [03:12:13.020] have_postponed_srfs = false [03:12:13.020] final_target = [03:12:13.020] final_targets = 0x55725f321a18 [03:12:13.020] final_targets_contain_srfs = 0x55725c34b78f [03:12:13.020] final_target_parallel_safe = [03:12:13.020] current_rel = [03:12:13.020] final_rel = [03:12:13.020] extra = {limit_needed = false, limit_tuples = 4.6417300219088326e-310, count_est = 93949712455416, offset_est = 93949712455416} [03:12:13.020] lc = [03:12:13.020] __func__ = "grouping_planner" [03:12:13.020] #10 0x000055725c3f00bb in subquery_planner (glob=glob@entry=0x55725f3aa218, parse=parse@entry=0x55725f1d7f70, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1153 [03:12:13.020] root = 0x55725f426e28 [03:12:13.020] newWithCheckOptions = [03:12:13.020] newHaving = 0x0 [03:12:13.020] hasOuterJoins = [03:12:13.020] hasResultRTEs = false [03:12:13.020] final_rel = [03:12:13.020] l = 0x0 [03:12:13.020] #11 0x000055725c3f0d4c in standard_planner (parse=0x55725f1d7f70, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [03:12:13.020] result = [03:12:13.020] glob = 0x55725f3aa218 [03:12:13.020] tuple_fraction = 0 [03:12:13.020] root = [03:12:13.020] final_rel = [03:12:13.020] best_path = [03:12:13.020] top_plan = [03:12:13.020] lp = [03:12:13.020] lr = [03:12:13.020] #12 0x000055725c3f1db6 in planner (parse=parse@entry=0x55725f1d7f70, query_string=query_string@entry=0x55725f1d6af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:294 [03:12:13.020] result = [03:12:13.020] #13 0x000055725c660dcc in pg_plan_query (querytree=querytree@entry=0x55725f1d7f70, query_string=query_string@entry=0x55725f1d6af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [03:12:13.020] plan = [03:12:13.020] #14 0x000055725c1672ff in standard_ExplainOneQuery (query=0x55725f1d7f70, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55725f3d4f68, queryString=0x55725f1d6af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:496 [03:12:13.020] plan = [03:12:13.020] planstart = [03:12:13.020] planduration = {ticks = 93949661569203} [03:12:13.020] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 93949667820224, shared_blks_dirtied = 908066990, shared_blks_written = 3, local_blks_hit = 5890735712, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 93949710401392, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 93949667907018}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93949661566584}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 93949710401392}} [03:12:13.020] bufusage = {shared_blks_hit = 0, shared_blks_read = 93949664589302, shared_blks_dirtied = 133311489916928, shared_blks_written = 72057594037927936, local_blks_hit = 140604092054888, local_blks_read = 93949710402568, local_blks_dirtied = 93949710401392, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 93949667436011, shared_blk_read_time = {ticks = 140604092054888}, shared_blk_write_time = {ticks = 93949667436030}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93949667815807}, temp_blk_read_time = {ticks = 93949712485408}, temp_blk_write_time = {ticks = 64}} [03:12:13.020] mem_counters = {nblocks = 93949712310648, freechunks = 4294967297, totalspace = 140734101454896, freespace = 10} [03:12:13.020] planner_ctx = 0x0 [03:12:13.020] saved_ctx = 0x0 [03:12:13.020] #15 0x000055725c1675e5 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55725f3d4f68, pstate=pstate@entry=0x55725f3d4e58, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [03:12:13.020] No locals. [03:12:13.020] #16 0x000055725c1684e5 in ExplainQuery (pstate=pstate@entry=0x55725f3d4e58, stmt=stmt@entry=0x55725f1d7db0, params=params@entry=0x0, dest=dest@entry=0x55725f3d4dc8) at ../src/backend/commands/explain.c:350 [03:12:13.020] l__state = [03:12:13.020] l = 0x55725f3aa1e0 [03:12:13.020] es = 0x55725f3d4f68 [03:12:13.020] tstate = [03:12:13.020] jstate = [03:12:13.020] query = [03:12:13.020] rewritten = 0x55725f3aa1c8 [03:12:13.020] lc = 0x0 [03:12:13.020] timing_set = false [03:12:13.020] summary_set = false [03:12:13.020] __func__ = "ExplainQuery" [03:12:13.020] #17 0x000055725c66b9b3 in standard_ProcessUtility (pstmt=0x55725f1d7e60, queryString=0x55725f1d6af0 "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=0x55725f3d4dc8, qc=0x7fff362002b0) at ../src/backend/tcop/utility.c:866 [03:12:13.020] parsetree = 0x55725f1d7db0 [03:12:13.020] isTopLevel = true [03:12:13.020] isAtomicContext = false [03:12:13.020] pstate = 0x55725f3d4e58 [03:12:13.020] readonly_flags = [03:12:13.020] __func__ = "standard_ProcessUtility" [03:12:13.020] #18 0x000055725c66c0dc in ProcessUtility (pstmt=pstmt@entry=0x55725f1d7e60, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55725f3d4dc8, qc=0x7fff362002b0) at ../src/backend/tcop/utility.c:523 [03:12:13.020] No locals. [03:12:13.020] #19 0x000055725c667948 in PortalRunUtility (portal=portal@entry=0x55725f25b100, pstmt=0x55725f1d7e60, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55725f3d4dc8, qc=qc@entry=0x7fff362002b0) at ../src/backend/tcop/pquery.c:1158 [03:12:13.020] No locals. [03:12:13.020] #20 0x000055725c6681bb in FillPortalStore (portal=portal@entry=0x55725f25b100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [03:12:13.020] treceiver = 0x55725f3d4dc8 [03:12:13.020] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:12:13.020] __func__ = "FillPortalStore" [03:12:13.020] #21 0x000055725c6687af in PortalRun (portal=portal@entry=0x55725f25b100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55725f321cf8, altdest=altdest@entry=0x55725f321cf8, qc=0x7fff36200490) at ../src/backend/tcop/pquery.c:763 [03:12:13.020] _save_exception_stack = 0x7fff36200540 [03:12:13.020] _save_context_stack = 0x0 [03:12:13.020] _local_sigjmp_buf = {{__jmpbuf = {0, 1767545929288834874, 93949710938368, 93949710401064, 93949710938368, 93949710400992, 5592704980416126778, 1767543012769718074}, __mask_was_saved = 0, __saved_mask = {__val = {93949667815807, 93949710395888, 112, 4, 93949667820224, 908067871, 4, 93949710400992, 112, 153, 93949710938368, 93949710401064, 93949710401040, 93949710400992, 93949667907427, 1}}}} [03:12:13.020] _do_rethrow = [03:12:13.020] result = [03:12:13.020] nprocessed = [03:12:13.020] saveTopTransactionResourceOwner = 0x55725f216708 [03:12:13.020] saveTopTransactionContext = 0x55725f26d530 [03:12:13.020] saveActivePortal = 0x0 [03:12:13.020] saveResourceOwner = 0x55725f216708 [03:12:13.020] savePortalContext = 0x0 [03:12:13.020] saveMemoryContext = 0x55725f26d530 [03:12:13.020] __func__ = "PortalRun" [03:12:13.020] #22 0x000055725c6618a2 in exec_simple_query (query_string=query_string@entry=0x55725f1d6af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');") at ../src/backend/tcop/postgres.c:1283 [03:12:13.020] cmdtaglen = 7 [03:12:13.020] snapshot_set = [03:12:13.020] per_parsetree_context = 0x0 [03:12:13.020] plantree_list = 0x55725f321ca8 [03:12:13.020] parsetree = 0x55725f1d7de0 [03:12:13.020] commandTag = [03:12:13.020] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:12:13.020] querytree_list = [03:12:13.020] portal = 0x55725f25b100 [03:12:13.020] receiver = 0x55725f321cf8 [03:12:13.020] format = 0 [03:12:13.020] cmdtagname = [03:12:13.020] parsetree_item__state = [03:12:13.020] dest = DestRemote [03:12:13.020] oldcontext = 0x55725f26d530 [03:12:13.020] parsetree_list = 0x55725f1d7e10 [03:12:13.020] parsetree_item = 0x55725f1d7e28 [03:12:13.020] save_log_statement_stats = false [03:12:13.020] was_logged = false [03:12:13.020] use_implicit_block = false [03:12:13.020] msec_str = "\004\000\000\000\000\000\000\000Nߑ\\rU\000\000 \005 6\377\177\000\000S\000\000\000\000\000\000" [03:12:13.020] __func__ = "exec_simple_query" [03:12:13.020] #23 0x000055725c664626 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4809 [03:12:13.020] query_string = 0x55725f1d6af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');" [03:12:13.020] firstchar = [03:12:13.020] input_message = {data = 0x55725f1d6af0 "explain (costs off) select * from list_parted where a = 'ab' or a in (null, 'cd');", len = 83, maxlen = 1024, cursor = 83} [03:12:13.020] local_sigjmp_buf = {{__jmpbuf = {93949680491832, 1767541247716810554, 140734101456540, 4, 17, 140734101456772, 5592704980302880570, 1767543007556591418}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93949710126608, 15616, 93949680485920, 93949710658928, 17, 93949667819772, 0, 9, 2, 93949680491840, 93949710126608, 93949680485920, 4, 17, 140734101456772}}}} [03:12:13.020] send_ready_for_query = false [03:12:13.020] idle_in_transaction_timeout_enabled = false [03:12:13.020] idle_session_timeout_enabled = false [03:12:13.020] __func__ = "PostgresMain" [03:12:13.020] #24 0x000055725c65a489 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:12:13.020] bsdata = [03:12:13.020] #25 0x000055725c50c0e6 in postmaster_child_launch (child_type=B_BACKEND, child_slot=17, startup_data=startup_data@entry=0x7fff3620069c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff362006f0) at ../src/backend/postmaster/launch_backend.c:274 [03:12:13.020] pid = [03:12:13.020] #26 0x000055725c5110e1 in BackendStartup (client_sock=client_sock@entry=0x7fff362006f0) at ../src/backend/postmaster/postmaster.c:3377 [03:12:13.020] bn = 0x55725f1ff368 [03:12:13.020] pid = [03:12:13.020] startup_data = {canAcceptConnections = CAC_OK} [03:12:13.020] cac = [03:12:13.020] __func__ = "BackendStartup" [03:12:13.020] #27 0x000055725c512fba in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [03:12:13.020] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\272Sj[rU\000\000\2007f[rU\000\000@\b 6\377\177\000\0008\b 6\377\177\000\000\225[\362\001\000\000\000\000\240\204\210\375\340\177\000\000+", '\000' , "\377\177\000\000\000\004\000\000\000\000\000\000h\226E\376\340\177\000\0000\206\210\375\340\177\000\000\340\222E\376\340\177\000\000\316)fR\000\000\000", __ss_align = 908068992}, salen = 2}} [03:12:13.020] i = 0 [03:12:13.020] now = [03:12:13.020] last_lockfile_recheck_time = 1733281686 [03:12:13.020] last_touch_time = 1733281686 [03:12:13.020] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -41384400, events = 32736, fd = -28994848, user_data = 0x7c96e577}, {pos = 908069056, events = 32767, fd = -29164984, user_data = 0xf}, {pos = -41384400, events = 32736, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -28994848, user_data = 0x7fff36200838}, {pos = 908068928, events = 32767, fd = -28993944, user_data = 0x0}, {pos = 1595763632, events = 21874, fd = -55870838, user_data = 0x55725f1d6bb0}, {pos = 1, events = 21874, fd = 32768, user_data = 0xffffffff}, {pos = -56434656, events = 32736, fd = -33914976, user_data = 0x55725f202198}, {pos = 1595940984, events = 21874, fd = 1595950177, user_data = 0x7fe0fe435ebe}, {pos = 1, events = 0, fd = -28994848, user_data = 0x1ab}, {pos = 1558826328, events = 21874, fd = 0, user_data = 0xec}, {pos = 1595763632, events = 21874, fd = -29139266, user_data = 0x1}, {pos = 0, events = 0, fd = -56434656, user_data = 0x7fe0fcaf2e40 }, {pos = 16, events = 0, fd = 908070064, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fe0fe4381ba}, {pos = 0, events = 0, fd = -55906908, user_data = 0x0}, {pos = 1565794560, events = 21874, fd = 2, user_data = 0x0}, {pos = 1595510448, events = 21874, fd = 1549743091, user_data = 0x55725f209cc0}, {pos = 1549747080, events = 21874, fd = 1595972891, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -56400696, user_data = 0x7fe0fca9c880 }, {pos = -89793096, events = 32736, fd = 908070256, user_data = 0x100007f00000002}, {pos = -55873785, events = 32736, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -54584224, events = 32736, 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 = 1884846186, fd = 168455528, user_data = 0x32333337310a6174}, {pos = 943075640, events = 808716854, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1595944032, events = 21874, fd = -55870838, user_data = 0xa}, {pos = 1553183103, events = 21874, fd = 1595956368, user_data = 0x7fe0fcab576b}, {pos = -54601248, events = 32736, fd = -55963282, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xe312c15841774600}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55725f201e70}, {pos = 1, events = 0, fd = 1595940664, user_data = 0x3}, {pos = 0, events = 0, fd = 20851, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1595763632, user_data = 0x7fe0fcaf3053 }, {pos = 1595940664, events = 21874, fd = 1024, user_data = 0x7fff36200d78}, {pos = 1553266419, events = 21874, fd = 1565859056, user_data = 0x55725c93e1b0 }, {pos = 1595940464, events = 21874, fd = 1595763184, user_data = 0x55725f201e70}, {pos = -55879829, events = 32736, fd = 0, user_data = 0x55725c94fe1a }, {pos = 1595940464, events = 1, fd = 1553268579, user_data = 0x55725f1d69f0}, {pos = 1098335744, events = 3809657176, fd = 0, user_data = 0x7fe0fcaa2ab1}, {pos = -55962384, events = 32736, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1595510448, user_data = 0xe312c15841774600}, {pos = 0, events = 0, fd = 1098335744, user_data = 0xc}, {pos = 1098335744, events = 3809657176, fd = 0, user_data = 0x7fe0fca5b239 }, {pos = 237, events = 0, fd = 1548795363, user_data = 0x400000}, {pos = 0, events = 0, fd = 1595510448, user_data = 0x55725c93e044 }, {pos = 1595597088, events = 21874, fd = 1595763184, user_data = 0x55725f1ae120}, {pos = 1, events = 0, fd = 0, user_data = 0x55725c8fca41 }, {pos = 12, events = 0, fd = 1595940040, user_data = 0x55725f201ca8}, {pos = 1565795968, events = 21874, fd = 296, user_data = 0x55725c50e5fd }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1548811834, events = 21874, fd = 1562224688, user_data = 0x55725f1d73c8}} [03:12:13.020] nevents = 1 [03:12:13.020] __func__ = "ServerLoop" [03:12:13.020] #28 0x000055725c5147dd in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55725f194d70) at ../src/backend/postmaster/postmaster.c:1361 [03:12:13.020] opt = [03:12:13.020] status = [03:12:13.020] userDoption = [03:12:13.020] listen_addr_saved = false [03:12:13.020] output_config_variable = [03:12:13.020] __func__ = "PostmasterMain" [03:12:13.020] #29 0x000055725c341881 in main (argc=8, argv=0x55725f194d70) at ../src/backend/main/main.c:196 [03:12:13.020] do_check_root = [03:12:13.059] -e [03:12:13.059] [03:12:13.059] [03:12:13.122] dumping /tmp/cores/postgres-3-28167.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:12:13.387] [New LWP 28167] [03:12:13.387] [03:12:13.387] This GDB supports auto-downloading debuginfo from the following URLs: [03:12:13.387] [03:12:13.387] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:12:13.387] Debuginfod has been disabled. [03:12:13.387] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:12:13.499] [New LWP 28048] [03:12:13.499] [Thread debugging using libthread_db enabled] [03:12:13.499] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:12:13.499] Core was generated by `postgres: cascade: startup recovering 000000020000000000000004 '. [03:12:13.499] Program terminated with signal SIGQUIT, Quit. [03:12:13.499] #0 0x00007fdb8b0aeda4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:13.505] [Current thread is 1 (LWP 28167)] [03:12:13.508] [03:12:13.508] Thread 2 (Thread 0x7fdb8be87f00 (LWP 28048)): [03:12:13.508] warning: Couldn't find general-purpose registers in core file. [03:12:13.508] #0 in ?? () [03:12:13.508] PC unavailable, cannot determine locals. [03:12:13.508] Backtrace stopped: not enough registers or memory available to unwind further [03:12:13.508] [03:12:13.508] Thread 1 (LWP 28167): [03:12:13.508] #0 0x00007fdb8b0aeda4 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:13.508] No symbol table info available. [03:12:13.508] #1 0x00007fdb8b05b239 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:13.508] No symbol table info available. [03:12:13.508] #2 0x00007fdb8b116204 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:13.508] No symbol table info available. [03:12:13.508] #3 0x00007fdb8b12885c in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:13.508] No symbol table info available. [03:12:13.527] -e [03:12:13.527] [03:12:13.527] [03:12:13.597] dumping /tmp/cores/postgres-6-39483.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:12:13.855] [New LWP 39483] [03:12:13.855] [03:12:13.855] This GDB supports auto-downloading debuginfo from the following URLs: [03:12:13.855] [03:12:13.855] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:12:13.855] Debuginfod has been disabled. [03:12:13.855] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:12:13.969] [Thread debugging using libthread_db enabled] [03:12:13.969] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:12:13.969] Core was generated by `postgres: test: postgres db2 [local] SELECT '. [03:12:13.969] Program terminated with signal SIGABRT, Aborted. [03:12:13.969] #0 0x00007f12ca0a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:14.030] [03:12:14.030] Thread 1 (Thread 0x7f12ca832f00 (LWP 39483)): [03:12:14.030] #0 0x00007f12ca0a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:14.030] No symbol table info available. [03:12:14.030] #1 0x00007f12ca05afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:14.030] No symbol table info available. [03:12:14.030] #2 0x00007f12ca045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:14.030] No symbol table info available. [03:12:14.030] #3 0x00007f12ca21e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [03:12:14.030] No locals. [03:12:14.030] #4 0x00007f12ca22aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [03:12:14.030] No locals. [03:12:14.030] #5 0x00007f12ca20dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x560a315c4b40, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [03:12:14.030] bp = 140725793005552 [03:12:14.030] pc = [03:12:14.030] Opts = {FromUnrecoverableHandler = true, pc = 94601763882227, bp = 139718480043176} [03:12:14.030] #6 0x0000560a308804f3 in examine_self_contradictory_rels (root=root@entry=0x560a335f7f28, rel=rel@entry=0x560a33601c18, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [03:12:14.030] lc__state = [03:12:14.030] rlist = [03:12:14.030] i = 7 [03:12:14.030] br = [03:12:14.030] expression = [03:12:14.030] or_rinfo = 0x7f12be5f2d38 [03:12:14.030] ccxt = [03:12:14.030] delidx = 0x7f12be5f5e91 [03:12:14.030] arglst = [03:12:14.030] lc = [03:12:14.030] arg = [03:12:14.030] n = [03:12:14.030] restrictinfo = [03:12:14.030] ccwapper = {clausecxt = 0x7f12be5f3b28} [03:12:14.030] sec = {sopcinfo = {n_members = 38, opcies = 0x7f12be5f32c8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7f12be5f36d8, atop_set = 0x7f12be5f1398}, ccfree = 0x7f12be5f5e60, vifree = 0x7f12be5f4d78} [03:12:14.030] __func__ = "examine_self_contradictory_rels" [03:12:14.030] #7 0x0000560a30880702 in examine_self_contradictory_rels_phase1 (root=root@entry=0x560a335f7f28) at ../src/backend/optimizer/plan/contradictory.c:2608 [03:12:14.030] rel = 0x560a33601c18 [03:12:14.030] rti = 1 [03:12:14.030] rinfo = [03:12:14.030] #8 0x0000560a3084ad44 in query_planner (root=root@entry=0x560a335f7f28, qp_callback=qp_callback@entry=0x560a30850061 , qp_extra=qp_extra@entry=0x7ffd46e721f0) at ../src/backend/optimizer/plan/planmain.c:190 [03:12:14.030] parse = 0x560a335ee720 [03:12:14.030] joinlist = 0x7f12be5f1528 [03:12:14.030] final_rel = [03:12:14.030] __func__ = "query_planner" [03:12:14.030] #9 0x0000560a3085e137 in grouping_planner (root=root@entry=0x560a335f7f28, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [03:12:14.030] sort_input_targets = 0x560a335f7f28 [03:12:14.030] sort_input_target_parallel_safe = [03:12:14.030] grouping_target = [03:12:14.030] scanjoin_target = [03:12:14.030] activeWindows = 0x0 [03:12:14.030] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [03:12:14.030] sort_input_targets_contain_srfs = 0x560a335f5720 [03:12:14.030] have_grouping = [03:12:14.030] wflists = 0x0 [03:12:14.030] gset_data = 0x0 [03:12:14.030] sort_input_target = [03:12:14.030] grouping_targets = 0x560a335f5768 [03:12:14.030] grouping_target_parallel_safe = [03:12:14.030] scanjoin_targets = 0x560a335f5750 [03:12:14.030] scanjoin_target_parallel_safe = [03:12:14.030] grouping_targets_contain_srfs = 0x560a335f7f28 [03:12:14.030] scanjoin_targets_contain_srfs = 0x0 [03:12:14.030] scanjoin_target_same_exprs = [03:12:14.030] parse = 0x560a335ee720 [03:12:14.030] offset_est = 0 [03:12:14.030] count_est = 0 [03:12:14.030] limit_tuples = -1 [03:12:14.030] have_postponed_srfs = false [03:12:14.030] final_target = [03:12:14.030] final_targets = 0x560a335f7f28 [03:12:14.030] final_targets_contain_srfs = 0x7 [03:12:14.030] final_target_parallel_safe = [03:12:14.030] current_rel = [03:12:14.030] final_rel = [03:12:14.030] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94601811519264} [03:12:14.030] lc = [03:12:14.030] __func__ = "grouping_planner" [03:12:14.030] #10 0x0000560a308610bb in subquery_planner (glob=, parse=0x560a335ee720, parent_root=parent_root@entry=0x560a335eb8e0, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1153 [03:12:14.030] root = 0x560a335f7f28 [03:12:14.030] newWithCheckOptions = [03:12:14.030] newHaving = 0x0 [03:12:14.030] hasOuterJoins = [03:12:14.030] hasResultRTEs = true [03:12:14.030] final_rel = [03:12:14.030] l = 0x0 [03:12:14.030] #11 0x0000560a30872a55 in SS_process_ctes (root=root@entry=0x560a335eb8e0) at ../src/backend/optimizer/plan/subselect.c:966 [03:12:14.030] subquery = [03:12:14.030] cte = 0x560a335b1490 [03:12:14.030] cmdType = [03:12:14.030] subroot = [03:12:14.030] final_rel = [03:12:14.030] best_path = [03:12:14.030] plan = [03:12:14.030] splan = [03:12:14.030] paramid = [03:12:14.030] lc__state = [03:12:14.030] lc = [03:12:14.030] __func__ = "SS_process_ctes" [03:12:14.030] #12 0x0000560a3085fb5f in subquery_planner (glob=glob@entry=0x560a335c66e8, parse=parse@entry=0x560a335c67f8, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:706 [03:12:14.030] root = 0x560a335eb8e0 [03:12:14.030] newWithCheckOptions = [03:12:14.030] newHaving = [03:12:14.030] hasOuterJoins = [03:12:14.030] hasResultRTEs = [03:12:14.030] final_rel = [03:12:14.030] l = [03:12:14.030] #13 0x0000560a30861d4c in standard_planner (parse=0x560a335c67f8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [03:12:14.030] result = [03:12:14.030] glob = 0x560a335c66e8 [03:12:14.030] tuple_fraction = 0 [03:12:14.030] root = [03:12:14.030] final_rel = [03:12:14.030] best_path = [03:12:14.030] top_plan = [03:12:14.030] lp = [03:12:14.030] lr = [03:12:14.030] #14 0x0000560a30862db6 in planner (parse=parse@entry=0x560a335c67f8, query_string=query_string@entry=0x560a334d65a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:294 [03:12:14.030] result = [03:12:14.030] #15 0x0000560a30ad1dcc in pg_plan_query (querytree=querytree@entry=0x560a335c67f8, query_string=query_string@entry=0x560a334d65a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [03:12:14.030] plan = [03:12:14.030] #16 0x0000560a30ad21ad in pg_plan_queries (querytrees=0x560a335eb890, query_string=query_string@entry=0x560a334d65a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:1005 [03:12:14.030] query = 0x560a335c67f8 [03:12:14.030] stmt = [03:12:14.030] query_list__state = [03:12:14.030] stmt_list = 0x0 [03:12:14.030] query_list = [03:12:14.030] #17 0x0000560a30ad275a in exec_simple_query (query_string=query_string@entry=0x560a334d65a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "...) at ../src/backend/tcop/postgres.c:1202 [03:12:14.030] cmdtaglen = 6 [03:12:14.030] snapshot_set = true [03:12:14.030] per_parsetree_context = 0x0 [03:12:14.030] plantree_list = [03:12:14.030] parsetree = 0x560a335c6668 [03:12:14.030] commandTag = CMDTAG_SELECT [03:12:14.030] qc = {commandTag = 1935, nprocessed = 94601810372000} [03:12:14.030] querytree_list = [03:12:14.030] portal = [03:12:14.030] receiver = [03:12:14.030] format = 0 [03:12:14.030] cmdtagname = [03:12:14.030] parsetree_item__state = [03:12:14.030] dest = DestRemote [03:12:14.030] oldcontext = 0x560a33565f40 [03:12:14.030] parsetree_list = 0x560a335c6698 [03:12:14.030] parsetree_item = 0x560a335c66b0 [03:12:14.030] save_log_statement_stats = false [03:12:14.030] was_logged = true [03:12:14.030] use_implicit_block = false [03:12:14.030] msec_str = "\004\000\000\000\000\000\000\000N\357\3300\nV\000\000\300%\347F\375\177\000\000\217\a\000\000\000\000\000" [03:12:14.030] __func__ = "exec_simple_query" [03:12:14.030] #18 0x0000560a30ad5626 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4809 [03:12:14.030] query_string = 0x560a334d65a0 "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 "... [03:12:14.030] firstchar = [03:12:14.030] input_message = {data = 0x560a334d65a0 "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} [03:12:14.030] local_sigjmp_buf = {{__jmpbuf = {94601781980472, 8478618289894305653, 140725793007420, 4, 1, 140725793007652, 2757597838455582581, 8478615686114422645}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94601810099664, 14336, 94601781974560, 94601810607184, 1, 94601769308412, 0, 9, 2, 94601781980480, 94601810099664, 94601781974560, 4, 1, 140725793007652}}}} [03:12:14.030] send_ready_for_query = false [03:12:14.030] idle_in_transaction_timeout_enabled = false [03:12:14.030] idle_session_timeout_enabled = false [03:12:14.030] __func__ = "PostgresMain" [03:12:14.030] #19 0x0000560a30acb489 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:12:14.030] bsdata = [03:12:14.030] #20 0x0000560a3097d0e6 in postmaster_child_launch (child_type=B_BACKEND, child_slot=1, startup_data=startup_data@entry=0x7ffd46e7273c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd46e72790) at ../src/backend/postmaster/launch_backend.c:274 [03:12:14.030] pid = [03:12:14.030] #21 0x0000560a309820e1 in BackendStartup (client_sock=client_sock@entry=0x7ffd46e72790) at ../src/backend/postmaster/postmaster.c:3377 [03:12:14.030] bn = 0x560a334fd5c8 [03:12:14.030] pid = [03:12:14.030] startup_data = {canAcceptConnections = CAC_OK} [03:12:14.030] cac = [03:12:14.030] __func__ = "BackendStartup" [03:12:14.030] #22 0x0000560a30983fba in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [03:12:14.030] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\003\312\022\177\000\000\240\177S\313\022\177\000\0008(\347F\375\177\000\0004(\347F\375\177", '\000' , "\272c\261/\nV\000\000\200G\255/\nV\000\000\000)\347F\375\177\000\000\370(\347F\375\177\000\000\225[\362\001\000\000\000\000\240\224\350\312\022\177\000\000+", '\000' , "\nV\000\000\310b\261/\nV\000", __ss_align = 139718701540968}, salen = 2}} [03:12:14.030] i = 0 [03:12:14.030] now = [03:12:14.030] last_lockfile_recheck_time = 1733281764 [03:12:14.030] last_touch_time = 1733281764 [03:12:14.030] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x560a2fb163ba}, {pos = -879565208, events = 32530, fd = -890726864, user_data = 0x7f12cb92e2e0}, {pos = 2090263927, events = 0, fd = 1189554560, user_data = 0x7f12cb904a48}, {pos = 15, events = 0, fd = -890726864, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f12cb92e2e0}, {pos = 1189554424, events = 32765, fd = 1189554432, user_data = 0x7f12cb92e668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = 860715616, events = 22026, fd = 1, user_data = 0x7ffd46e72e23}, {pos = -1, events = 0, fd = -905781216, user_data = 0x7f12cb537fa0}, {pos = 860885848, events = 22026, fd = 860885560, user_data = 0x560a33500801}, {pos = -879710530, events = 32530, fd = 1, user_data = 0x7f12cb92e2e0}, {pos = 427, events = 0, fd = 825285976, user_data = 0x0}, {pos = 216, events = 0, fd = 860715552, user_data = 0x7f12cb90aebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f12ca02e020}, {pos = -904974784, events = 32530, fd = 16, user_data = 0x7ffd46e72d50}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -879701574, events = 32530, fd = 0, user_data = 0x7f12ca0aeda4 }, {pos = 0, events = 0, fd = 832254208, user_data = 0x2}, {pos = 0, events = 0, fd = 860454512, user_data = 0x560a30a68fc1 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = 860715552, user_data = 0x7f12cb90aebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f12ca0364c8}, {pos = -905220345, events = 32530, fd = 832310336, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -903930784, events = 32530, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 1651664246, user_data = 0x342020200a0a5577}, {pos = 1882153332, events = 1952539751, fd = 925960801, user_data = 0x2f6b636568635f33}, {pos = 1635017060, events = 811562031, fd = 1684826485, user_data = 0x72747365742f646c}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 860897984, user_data = 0x7f12ca0b58be}, {pos = -903947808, events = 32530, fd = -905309842, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x499b3ed244f52a00}, {pos = -903944736, events = 32530, fd = -328, user_data = 0x0}, {pos = 860885240, events = 22026, 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 = 38889, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 860715552, user_data = 0x7f12ca0f3053 }, {pos = 860885240, events = 22026, fd = 1024, user_data = 0x7ffd46e72e18}, {pos = 819726067, events = 22026, fd = 832318704, user_data = 0x560a30daf1b0 }, {pos = 860885040, events = 22026, fd = 860707968, user_data = 0x560a33501030}, {pos = -905226389, events = 32530, fd = 0, user_data = 0x560a30dc0e1a }, {pos = 860885040, events = 1, fd = 819728227, user_data = 0x560a334d5c80}, {pos = 1156917760, events = 1234910930, fd = 0, user_data = 0x7f12ca0a2ab1}, {pos = -905308944, events = 32530, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 860454512, user_data = 0x499b3ed244f52a00}, {pos = 0, events = 0, fd = 1156917760, user_data = 0xc}, {pos = 1156917760, events = 1234910930, fd = 0, user_data = 0x7f12ca05b239 }, {pos = 217, events = 0, fd = 815255011, user_data = 0x400000}, {pos = 0, events = 0, fd = 860454512, user_data = 0x560a30daf044 }, {pos = 860541872, events = 22026, fd = 860707968, user_data = 0x560a334ad3b0}, {pos = 1, events = 0, fd = 0, user_data = 0x560a30d6da41 }, {pos = 12, events = 0, fd = 860880488, user_data = 0x560a334ffe48}, {pos = 832255616, events = 22026, fd = 296, user_data = 0x560a3097f5fd }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 815271482, events = 22026, fd = 828684336, user_data = 0x560a334d6638}} [03:12:14.030] nevents = 1 [03:12:14.030] __func__ = "ServerLoop" [03:12:14.030] #23 0x0000560a309857dd in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x560a33493ce0) at ../src/backend/postmaster/postmaster.c:1361 [03:12:14.030] opt = [03:12:14.030] status = [03:12:14.030] userDoption = [03:12:14.030] listen_addr_saved = false [03:12:14.030] output_config_variable = [03:12:14.030] __func__ = "PostmasterMain" [03:12:14.030] #24 0x0000560a307b2881 in main (argc=4, argv=0x560a33493ce0) at ../src/backend/main/main.c:196 [03:12:14.030] do_check_root = [03:12:14.050] -e [03:12:14.050] [03:12:14.050] [03:12:14.118] dumping /tmp/cores/postgres-6-39299.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:12:14.375] [New LWP 39299] [03:12:14.375] [03:12:14.375] This GDB supports auto-downloading debuginfo from the following URLs: [03:12:14.375] [03:12:14.375] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:12:14.375] Debuginfod has been disabled. [03:12:14.375] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:12:14.477] [Thread debugging using libthread_db enabled] [03:12:14.477] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:12:14.477] Core was generated by `postgres: test: postgres db1 [local] SELECT '. [03:12:14.477] Program terminated with signal SIGABRT, Aborted. [03:12:14.477] #0 0x00007f12ca0a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:14.538] [03:12:14.538] Thread 1 (Thread 0x7f12ca832f00 (LWP 39299)): [03:12:14.538] #0 0x00007f12ca0a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:14.538] No symbol table info available. [03:12:14.538] #1 0x00007f12ca05afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:14.538] No symbol table info available. [03:12:14.538] #2 0x00007f12ca045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:14.538] No symbol table info available. [03:12:14.538] #3 0x00007f12ca21e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [03:12:14.538] No locals. [03:12:14.538] #4 0x00007f12ca22aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [03:12:14.538] No locals. [03:12:14.538] #5 0x00007f12ca20dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x560a315c4b40, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [03:12:14.538] bp = 140725793005552 [03:12:14.538] pc = [03:12:14.538] Opts = {FromUnrecoverableHandler = true, pc = 94601763882227, bp = 139718480043176} [03:12:14.538] #6 0x0000560a308804f3 in examine_self_contradictory_rels (root=root@entry=0x560a335f7f28, rel=rel@entry=0x560a33601c18, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [03:12:14.538] lc__state = [03:12:14.538] rlist = [03:12:14.538] i = 7 [03:12:14.538] br = [03:12:14.538] expression = [03:12:14.538] or_rinfo = 0x7f12be5f2d38 [03:12:14.538] ccxt = [03:12:14.538] delidx = 0x7f12be5f5e91 [03:12:14.538] arglst = [03:12:14.538] lc = [03:12:14.538] arg = [03:12:14.538] n = [03:12:14.538] restrictinfo = [03:12:14.538] ccwapper = {clausecxt = 0x7f12be5f3b28} [03:12:14.538] sec = {sopcinfo = {n_members = 38, opcies = 0x7f12be5f32c8}, attrsdc = {min_attr = -6, max_attr = 33, len_set = 3, atop_array = 0x7f12be5f36d8, atop_set = 0x7f12be5f1398}, ccfree = 0x7f12be5f5e60, vifree = 0x7f12be5f4d78} [03:12:14.538] __func__ = "examine_self_contradictory_rels" [03:12:14.538] #7 0x0000560a30880702 in examine_self_contradictory_rels_phase1 (root=root@entry=0x560a335f7f28) at ../src/backend/optimizer/plan/contradictory.c:2608 [03:12:14.538] rel = 0x560a33601c18 [03:12:14.538] rti = 1 [03:12:14.538] rinfo = [03:12:14.538] #8 0x0000560a3084ad44 in query_planner (root=root@entry=0x560a335f7f28, qp_callback=qp_callback@entry=0x560a30850061 , qp_extra=qp_extra@entry=0x7ffd46e721f0) at ../src/backend/optimizer/plan/planmain.c:190 [03:12:14.538] parse = 0x560a335ee720 [03:12:14.538] joinlist = 0x7f12be5f1528 [03:12:14.538] final_rel = [03:12:14.538] __func__ = "query_planner" [03:12:14.538] #9 0x0000560a3085e137 in grouping_planner (root=root@entry=0x560a335f7f28, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [03:12:14.538] sort_input_targets = 0x560a335f7f28 [03:12:14.538] sort_input_target_parallel_safe = [03:12:14.538] grouping_target = [03:12:14.538] scanjoin_target = [03:12:14.538] activeWindows = 0x0 [03:12:14.538] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [03:12:14.538] sort_input_targets_contain_srfs = 0x560a335f5720 [03:12:14.538] have_grouping = [03:12:14.538] wflists = 0x0 [03:12:14.538] gset_data = 0x0 [03:12:14.538] sort_input_target = [03:12:14.538] grouping_targets = 0x560a335f5768 [03:12:14.538] grouping_target_parallel_safe = [03:12:14.538] scanjoin_targets = 0x560a335f5750 [03:12:14.538] scanjoin_target_parallel_safe = [03:12:14.538] grouping_targets_contain_srfs = 0x560a335f7f28 [03:12:14.538] scanjoin_targets_contain_srfs = 0x0 [03:12:14.538] scanjoin_target_same_exprs = [03:12:14.538] parse = 0x560a335ee720 [03:12:14.538] offset_est = 0 [03:12:14.538] count_est = 0 [03:12:14.538] limit_tuples = -1 [03:12:14.538] have_postponed_srfs = false [03:12:14.538] final_target = [03:12:14.538] final_targets = 0x560a335f7f28 [03:12:14.538] final_targets_contain_srfs = 0x7 [03:12:14.538] final_target_parallel_safe = [03:12:14.538] current_rel = [03:12:14.538] final_rel = [03:12:14.538] extra = {limit_needed = false, limit_tuples = 0, count_est = 0, offset_est = 94601811519264} [03:12:14.538] lc = [03:12:14.538] __func__ = "grouping_planner" [03:12:14.538] #10 0x0000560a308610bb in subquery_planner (glob=, parse=0x560a335ee720, parent_root=parent_root@entry=0x560a335eb8e0, hasRecursion=, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1153 [03:12:14.538] root = 0x560a335f7f28 [03:12:14.538] newWithCheckOptions = [03:12:14.538] newHaving = 0x0 [03:12:14.538] hasOuterJoins = [03:12:14.538] hasResultRTEs = true [03:12:14.538] final_rel = [03:12:14.538] l = 0x0 [03:12:14.538] #11 0x0000560a30872a55 in SS_process_ctes (root=root@entry=0x560a335eb8e0) at ../src/backend/optimizer/plan/subselect.c:966 [03:12:14.538] subquery = [03:12:14.538] cte = 0x560a335b1490 [03:12:14.538] cmdType = [03:12:14.538] subroot = [03:12:14.538] final_rel = [03:12:14.538] best_path = [03:12:14.538] plan = [03:12:14.538] splan = [03:12:14.538] paramid = [03:12:14.538] lc__state = [03:12:14.538] lc = [03:12:14.538] __func__ = "SS_process_ctes" [03:12:14.538] #12 0x0000560a3085fb5f in subquery_planner (glob=glob@entry=0x560a335c66e8, parse=parse@entry=0x560a335c67f8, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:706 [03:12:14.538] root = 0x560a335eb8e0 [03:12:14.538] newWithCheckOptions = [03:12:14.538] newHaving = [03:12:14.538] hasOuterJoins = [03:12:14.538] hasResultRTEs = [03:12:14.538] final_rel = [03:12:14.538] l = [03:12:14.538] #13 0x0000560a30861d4c in standard_planner (parse=0x560a335c67f8, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [03:12:14.538] result = [03:12:14.538] glob = 0x560a335c66e8 [03:12:14.538] tuple_fraction = 0 [03:12:14.538] root = [03:12:14.538] final_rel = [03:12:14.538] best_path = [03:12:14.538] top_plan = [03:12:14.538] lp = [03:12:14.538] lr = [03:12:14.538] #14 0x0000560a30862db6 in planner (parse=parse@entry=0x560a335c67f8, query_string=query_string@entry=0x560a334d65a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:294 [03:12:14.538] result = [03:12:14.538] #15 0x0000560a30ad1dcc in pg_plan_query (querytree=querytree@entry=0x560a335c67f8, query_string=query_string@entry=0x560a334d65a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [03:12:14.538] plan = [03:12:14.538] #16 0x0000560a30ad21ad in pg_plan_queries (querytrees=0x560a335eb890, query_string=query_string@entry=0x560a334d65a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:1005 [03:12:14.538] query = 0x560a335c67f8 [03:12:14.538] stmt = [03:12:14.538] query_list__state = [03:12:14.538] stmt_list = 0x0 [03:12:14.538] query_list = [03:12:14.538] #17 0x0000560a30ad275a in exec_simple_query (query_string=query_string@entry=0x560a334d65a0 "WITH include_raw (pattern_id, db_regex, nsp_regex, rel_regex, heap_only, btree_only) AS (\nVALUES\n(0::INTEGER, NULL::TEXT, '^(s1)$'::TEXT, '^(.*)$'::TEXT, true::BOOLEAN, false::BOOLEAN)\n),\ninclude_pat "...) at ../src/backend/tcop/postgres.c:1202 [03:12:14.538] cmdtaglen = 6 [03:12:14.538] snapshot_set = true [03:12:14.538] per_parsetree_context = 0x0 [03:12:14.538] plantree_list = [03:12:14.538] parsetree = 0x560a335c6668 [03:12:14.538] commandTag = CMDTAG_SELECT [03:12:14.538] qc = {commandTag = 1935, nprocessed = 94601810372000} [03:12:14.538] querytree_list = [03:12:14.538] portal = [03:12:14.538] receiver = [03:12:14.538] format = 0 [03:12:14.538] cmdtagname = [03:12:14.538] parsetree_item__state = [03:12:14.538] dest = DestRemote [03:12:14.538] oldcontext = 0x560a33565f40 [03:12:14.538] parsetree_list = 0x560a335c6698 [03:12:14.538] parsetree_item = 0x560a335c66b0 [03:12:14.538] save_log_statement_stats = false [03:12:14.538] was_logged = true [03:12:14.538] use_implicit_block = false [03:12:14.538] msec_str = "\004\000\000\000\000\000\000\000N\357\3300\nV\000\000\300%\347F\375\177\000\000\217\a\000\000\000\000\000" [03:12:14.538] __func__ = "exec_simple_query" [03:12:14.538] #18 0x0000560a30ad5626 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4809 [03:12:14.538] query_string = 0x560a334d65a0 "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 "... [03:12:14.538] firstchar = [03:12:14.538] input_message = {data = 0x560a334d65a0 "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} [03:12:14.538] local_sigjmp_buf = {{__jmpbuf = {94601781980472, 8478618289894305653, 140725793007420, 4, 2, 140725793007652, 2757597838455582581, 8478615686114422645}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94601810099664, 14336, 94601781974560, 94601810607184, 2, 94601769308412, 0, 9, 2, 94601781980480, 94601810099664, 94601781974560, 4, 2, 140725793007652}}}} [03:12:14.538] send_ready_for_query = false [03:12:14.538] idle_in_transaction_timeout_enabled = false [03:12:14.538] idle_session_timeout_enabled = false [03:12:14.538] __func__ = "PostgresMain" [03:12:14.538] #19 0x0000560a30acb489 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:12:14.538] bsdata = [03:12:14.538] #20 0x0000560a3097d0e6 in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x7ffd46e7273c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffd46e72790) at ../src/backend/postmaster/launch_backend.c:274 [03:12:14.538] pid = [03:12:14.538] #21 0x0000560a309820e1 in BackendStartup (client_sock=client_sock@entry=0x7ffd46e72790) at ../src/backend/postmaster/postmaster.c:3377 [03:12:14.538] bn = 0x560a334fd5f8 [03:12:14.538] pid = [03:12:14.538] startup_data = {canAcceptConnections = CAC_OK} [03:12:14.538] cac = [03:12:14.538] __func__ = "BackendStartup" [03:12:14.538] #22 0x0000560a30983fba in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [03:12:14.538] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\003\312\022\177\000\000\240\177S\313\022\177\000\0008(\347F\375\177\000\0004(\347F\375\177", '\000' , "\272c\261/\nV\000\000\200G\255/\nV\000\000\000)\347F\375\177\000\000\370(\347F\375\177\000\000\225[\362\001\000\000\000\000\240\224\350\312\022\177\000\000+", '\000' , "\nV\000\000\310b\261/\nV\000", __ss_align = 139718701540968}, salen = 2}} [03:12:14.538] i = 0 [03:12:14.538] now = [03:12:14.538] last_lockfile_recheck_time = 1733281764 [03:12:14.538] last_touch_time = 1733281764 [03:12:14.538] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 15, user_data = 0x560a2fb163ba}, {pos = -879565208, events = 32530, fd = -890726864, user_data = 0x7f12cb92e2e0}, {pos = 2090263927, events = 0, fd = 1189554560, user_data = 0x7f12cb904a48}, {pos = 15, events = 0, fd = -890726864, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f12cb92e2e0}, {pos = 1189554424, events = 32765, fd = 1189554432, user_data = 0x7f12cb92e668}, {pos = 0, events = 0, fd = 32768, user_data = 0x7}, {pos = 860715616, events = 22026, fd = 1, user_data = 0x7ffd46e72e23}, {pos = -1, events = 0, fd = -905781216, user_data = 0x7f12cb537fa0}, {pos = 860885848, events = 22026, fd = 860885560, user_data = 0x560a33500801}, {pos = -879710530, events = 32530, fd = 1, user_data = 0x7f12cb92e2e0}, {pos = 427, events = 0, fd = 825285976, user_data = 0x0}, {pos = 216, events = 0, fd = 860715552, user_data = 0x7f12cb90aebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f12ca02e020}, {pos = -904974784, events = 32530, fd = 16, user_data = 0x7ffd46e72d50}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -879701574, events = 32530, fd = 0, user_data = 0x7f12ca0aeda4 }, {pos = 0, events = 0, fd = 832254208, user_data = 0x2}, {pos = 0, events = 0, fd = 860454512, user_data = 0x560a30a68fc1 }, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x4}, {pos = 8096, events = 196607, fd = 860715552, user_data = 0x7f12cb90aebe}, {pos = 1, events = 0, fd = 0, user_data = 0x7f12ca0364c8}, {pos = -905220345, events = 32530, fd = 832310336, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x100007f00000002}, {pos = -903930784, events = 32530, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 1023, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 1651664246, user_data = 0x342020200a0a5577}, {pos = 1882153332, events = 1952539751, fd = 925960801, user_data = 0x2f6b636568635f33}, {pos = 1635017060, events = 811562031, fd = 1684826485, user_data = 0x72747365742f646c}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 860897984, user_data = 0x7f12ca0b58be}, {pos = -903947808, events = 32530, fd = -905309842, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x499b3ed244f52a00}, {pos = -903944736, events = 32530, fd = -328, user_data = 0x0}, {pos = 860885240, events = 22026, 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 = 38889, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 860715552, user_data = 0x7f12ca0f3053 }, {pos = 860885240, events = 22026, fd = 1024, user_data = 0x7ffd46e72e18}, {pos = 819726067, events = 22026, fd = 832318704, user_data = 0x560a30daf1b0 }, {pos = 860885040, events = 22026, fd = 860707968, user_data = 0x560a33501030}, {pos = -905226389, events = 32530, fd = 0, user_data = 0x560a30dc0e1a }, {pos = 860885040, events = 1, fd = 819728227, user_data = 0x560a334d5c80}, {pos = 1156917760, events = 1234910930, fd = 0, user_data = 0x7f12ca0a2ab1}, {pos = -905308944, events = 32530, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 860454512, user_data = 0x499b3ed244f52a00}, {pos = 0, events = 0, fd = 1156917760, user_data = 0xc}, {pos = 1156917760, events = 1234910930, fd = 0, user_data = 0x7f12ca05b239 }, {pos = 217, events = 0, fd = 815255011, user_data = 0x400000}, {pos = 0, events = 0, fd = 860454512, user_data = 0x560a30daf044 }, {pos = 860541872, events = 22026, fd = 860707968, user_data = 0x560a334ad3b0}, {pos = 1, events = 0, fd = 0, user_data = 0x560a30d6da41 }, {pos = 12, events = 0, fd = 860880488, user_data = 0x560a334ffe48}, {pos = 832255616, events = 22026, fd = 296, user_data = 0x560a3097f5fd }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 815271482, events = 22026, fd = 828684336, user_data = 0x560a334d6638}} [03:12:14.538] nevents = 1 [03:12:14.538] __func__ = "ServerLoop" [03:12:14.538] #23 0x0000560a309857dd in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x560a33493ce0) at ../src/backend/postmaster/postmaster.c:1361 [03:12:14.538] opt = [03:12:14.538] status = [03:12:14.538] userDoption = [03:12:14.539] listen_addr_saved = false [03:12:14.539] output_config_variable = [03:12:14.539] __func__ = "PostmasterMain" [03:12:14.539] #24 0x0000560a307b2881 in main (argc=4, argv=0x560a33493ce0) at ../src/backend/main/main.c:196 [03:12:14.539] do_check_root = [03:12:14.558] -e [03:12:14.558] [03:12:14.558] [03:12:14.623] dumping /tmp/cores/postgres-6-25295.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:12:14.879] [New LWP 25295] [03:12:14.879] [03:12:14.879] This GDB supports auto-downloading debuginfo from the following URLs: [03:12:14.879] [03:12:14.879] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:12:14.879] Debuginfod has been disabled. [03:12:14.879] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:12:14.991] [Thread debugging using libthread_db enabled] [03:12:14.991] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:12:14.991] Core was generated by `postgres: postgres regression [local] SELECT '. [03:12:14.991] Program terminated with signal SIGABRT, Aborted. [03:12:14.991] #0 0x00007fe0fcaa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:16.114] [03:12:16.114] Thread 1 (Thread 0x7fe0faa5df00 (LWP 25295)): [03:12:16.114] #0 0x00007fe0fcaa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:16.114] No symbol table info available. [03:12:16.114] #1 0x00007fe0fca5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:16.114] No symbol table info available. [03:12:16.114] #2 0x00007fe0fca45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:16.114] No symbol table info available. [03:12:16.114] #3 0x00007fe0fcc1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [03:12:16.114] No locals. [03:12:16.114] #4 0x00007fe0fcc2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [03:12:16.114] No locals. [03:12:16.114] #5 0x00007fe0fcc0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55725d153b40, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [03:12:16.114] bp = 140734101451344 [03:12:16.114] pc = [03:12:16.114] Opts = {FromUnrecoverableHandler = true, pc = 93949662393587, bp = 93949711856088} [03:12:16.114] #6 0x000055725c40f4f3 in examine_self_contradictory_rels (root=root@entry=0x55725f38d538, rel=rel@entry=0x55725f2355f0, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [03:12:16.114] lc__state = [03:12:16.114] rlist = [03:12:16.114] i = 3 [03:12:16.114] br = [03:12:16.114] expression = [03:12:16.114] or_rinfo = 0x55725f33bfb0 [03:12:16.114] ccxt = [03:12:16.114] delidx = 0x55725f33c731 [03:12:16.114] arglst = [03:12:16.114] lc = [03:12:16.114] arg = [03:12:16.114] n = [03:12:16.114] restrictinfo = [03:12:16.114] ccwapper = {clausecxt = 0x55725f33bcf0} [03:12:16.114] sec = {sopcinfo = {n_members = 38, opcies = 0x55725f33b398}, attrsdc = {min_attr = -6, max_attr = 7, len_set = 2, atop_array = 0x55725f38edc8, atop_set = 0x55725f38f358}, ccfree = 0x55725f33bcc0, vifree = 0x55725f33c320} [03:12:16.114] __func__ = "examine_self_contradictory_rels" [03:12:16.114] #7 0x000055725c40f702 in examine_self_contradictory_rels_phase1 (root=root@entry=0x55725f38d538) at ../src/backend/optimizer/plan/contradictory.c:2608 [03:12:16.114] rel = 0x55725f2355f0 [03:12:16.114] rti = 1 [03:12:16.114] rinfo = [03:12:16.114] #8 0x000055725c3d9d44 in query_planner (root=root@entry=0x55725f38d538, qp_callback=qp_callback@entry=0x55725c3df061 , qp_extra=qp_extra@entry=0x7fff361ff450) at ../src/backend/optimizer/plan/planmain.c:190 [03:12:16.114] parse = 0x55725f32bc18 [03:12:16.114] joinlist = 0x55725f38f3c8 [03:12:16.114] final_rel = [03:12:16.114] __func__ = "query_planner" [03:12:16.114] #9 0x000055725c3ed137 in grouping_planner (root=root@entry=0x55725f38d538, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [03:12:16.114] sort_input_targets = 0x55725f38e328 [03:12:16.114] sort_input_target_parallel_safe = [03:12:16.114] grouping_target = [03:12:16.114] scanjoin_target = [03:12:16.114] activeWindows = 0x0 [03:12:16.114] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [03:12:16.114] sort_input_targets_contain_srfs = 0x2 [03:12:16.114] have_grouping = [03:12:16.114] wflists = 0x0 [03:12:16.114] gset_data = 0x0 [03:12:16.114] sort_input_target = [03:12:16.114] grouping_targets = 0x0 [03:12:16.114] grouping_target_parallel_safe = [03:12:16.114] scanjoin_targets = 0x55725f38d538 [03:12:16.114] scanjoin_target_parallel_safe = [03:12:16.114] grouping_targets_contain_srfs = 0x55725f38e3c8 [03:12:16.114] scanjoin_targets_contain_srfs = 0x0 [03:12:16.114] scanjoin_target_same_exprs = [03:12:16.114] parse = 0x55725f32bc18 [03:12:16.114] offset_est = 0 [03:12:16.114] count_est = 0 [03:12:16.114] limit_tuples = -1 [03:12:16.114] have_postponed_srfs = false [03:12:16.114] final_target = [03:12:16.114] final_targets = 0x55725f2f5948 [03:12:16.114] final_targets_contain_srfs = 0x55725c42e450 [03:12:16.114] final_target_parallel_safe = [03:12:16.114] current_rel = [03:12:16.114] final_rel = [03:12:16.114] extra = {limit_needed = 248, limit_tuples = 4.6417325231146825e-310, count_est = 93949712196552, offset_est = 93949712192824} [03:12:16.114] lc = [03:12:16.114] __func__ = "grouping_planner" [03:12:16.114] #10 0x000055725c3f00bb in subquery_planner (glob=glob@entry=0x55725f2354e0, parse=parse@entry=0x55725f32bc18, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1153 [03:12:16.114] root = 0x55725f38d538 [03:12:16.114] newWithCheckOptions = [03:12:16.114] newHaving = 0x0 [03:12:16.114] hasOuterJoins = [03:12:16.114] hasResultRTEs = false [03:12:16.114] final_rel = [03:12:16.114] l = 0x0 [03:12:16.114] #11 0x000055725c3f0d4c in standard_planner (parse=0x55725f32bc18, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [03:12:16.114] result = [03:12:16.114] glob = 0x55725f2354e0 [03:12:16.114] tuple_fraction = 0 [03:12:16.114] root = [03:12:16.114] final_rel = [03:12:16.114] best_path = [03:12:16.114] top_plan = [03:12:16.114] lp = [03:12:16.114] lr = [03:12:16.114] #12 0x000055725c3f1db6 in planner (parse=parse@entry=0x55725f32bc18, query_string=query_string@entry=0x55725f36eda0 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:294 [03:12:16.114] result = [03:12:16.114] #13 0x000055725c660dcc in pg_plan_query (querytree=querytree@entry=0x55725f32bc18, query_string=query_string@entry=0x55725f36eda0 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [03:12:16.114] plan = [03:12:16.114] #14 0x000055725c1672ff in standard_ExplainOneQuery (query=0x55725f32bc18, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55725f234f70, queryString=0x55725f36eda0 "explain analyze SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > '1'", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:496 [03:12:16.114] plan = [03:12:16.114] planstart = [03:12:16.114] planduration = {ticks = 93949661569203} [03:12:16.114] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 93949667820224, shared_blks_dirtied = 908064574, shared_blks_written = 3, local_blks_hit = 5892402336, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 93949711793176, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 93949667907018}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93949661566584}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 93949711793176}} [03:12:16.114] bufusage = {shared_blks_hit = 0, shared_blks_read = 93949664589302, shared_blks_dirtied = 143477677506560, shared_blks_written = 72057594037927936, local_blks_hit = 140604093335072, local_blks_read = 93949712068688, local_blks_dirtied = 93949711793176, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 93949667436011, shared_blk_read_time = {ticks = 140604093335072}, shared_blk_write_time = {ticks = 93949667436030}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93949667815807}, temp_blk_read_time = {ticks = 93949712067744}, temp_blk_write_time = {ticks = 64}} [03:12:16.114] mem_counters = {nblocks = 93949710783552, freechunks = 4294967297, totalspace = 140734101452480, freespace = 10} [03:12:16.114] planner_ctx = 0x0 [03:12:16.114] saved_ctx = 0x0 [03:12:16.114] #15 0x000055725c1675e5 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55725f234f70, pstate=pstate@entry=0x55725f234e60, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [03:12:16.114] No locals. [03:12:16.114] #16 0x000055725c1684e5 in ExplainQuery (pstate=pstate@entry=0x55725f234e60, stmt=stmt@entry=0x55725f36ef90, params=params@entry=0x0, dest=dest@entry=0x55725f234dd0) at ../src/backend/commands/explain.c:350 [03:12:16.114] l__state = [03:12:16.114] l = 0x55725f2354a8 [03:12:16.114] es = 0x55725f234f70 [03:12:16.114] tstate = [03:12:16.114] jstate = [03:12:16.114] query = [03:12:16.114] rewritten = 0x55725f235490 [03:12:16.114] lc = 0x0 [03:12:16.114] timing_set = false [03:12:16.114] summary_set = false [03:12:16.114] __func__ = "ExplainQuery" [03:12:16.114] #17 0x000055725c66b9b3 in standard_ProcessUtility (pstmt=0x55725f36ee80, queryString=0x55725f36eda0 "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=0x55725f234dd0, qc=0x7fff361ff940) at ../src/backend/tcop/utility.c:866 [03:12:16.114] parsetree = 0x55725f36ef90 [03:12:16.114] isTopLevel = false [03:12:16.114] isAtomicContext = true [03:12:16.114] pstate = 0x55725f234e60 [03:12:16.114] readonly_flags = [03:12:16.114] __func__ = "standard_ProcessUtility" [03:12:16.114] #18 0x000055725c66c0dc in ProcessUtility (pstmt=pstmt@entry=0x55725f36ee80, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_QUERY, params=, queryEnv=, dest=0x55725f234dd0, qc=0x7fff361ff940) at ../src/backend/tcop/utility.c:523 [03:12:16.114] No locals. [03:12:16.114] #19 0x000055725c667948 in PortalRunUtility (portal=portal@entry=0x55725f25b210, pstmt=0x55725f36ee80, isTopLevel=isTopLevel@entry=false, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55725f234dd0, qc=qc@entry=0x7fff361ff940) at ../src/backend/tcop/pquery.c:1158 [03:12:16.114] No locals. [03:12:16.114] #20 0x000055725c6681bb in FillPortalStore (portal=portal@entry=0x55725f25b210, isTopLevel=isTopLevel@entry=false) at ../src/backend/tcop/pquery.c:1031 [03:12:16.114] treceiver = 0x55725f234dd0 [03:12:16.114] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:12:16.114] __func__ = "FillPortalStore" [03:12:16.114] #21 0x000055725c668c3e in PortalRunFetch (portal=portal@entry=0x55725f25b210, fdirection=fdirection@entry=FETCH_FORWARD, count=count@entry=10, dest=dest@entry=0x55725ce885e0 ) at ../src/backend/tcop/pquery.c:1442 [03:12:16.114] _save_exception_stack = 0x7fff361ffef0 [03:12:16.114] _save_context_stack = 0x7fff361ffd60 [03:12:16.114] _local_sigjmp_buf = {{__jmpbuf = {93949710938640, 1767545786803085114, 0, 10, 140734101454208, 93949711673368, 5592705424158809914, 1767543012522778426}, __mask_was_saved = 0, __saved_mask = {__val = {1546688534, 93949712068000, 93949667825943, 140734101454176, 93949661319765, 144, 140604094127047, 93949711717216, 8192, 93949711585968, 93949711717216, 93949711717216, 93949711717472, 0, 93949667818050, 0}}}} [03:12:16.114] _do_rethrow = [03:12:16.114] result = [03:12:16.114] saveActivePortal = 0x55725f25b100 [03:12:16.114] saveResourceOwner = 0x55725f21a538 [03:12:16.114] savePortalContext = 0x55725f36d850 [03:12:16.114] oldContext = 0x55725f2e9260 [03:12:16.114] __func__ = "PortalRunFetch" [03:12:16.114] #22 0x000055725c309997 in _SPI_cursor_operation (portal=portal@entry=0x55725f25b210, direction=direction@entry=FETCH_FORWARD, count=count@entry=10, dest=0x55725ce885e0 ) at ../src/backend/executor/spi.c:3027 [03:12:16.114] nfetched = [03:12:16.114] __func__ = "_SPI_cursor_operation" [03:12:16.114] #23 0x000055725c30f28c in SPI_cursor_fetch (portal=portal@entry=0x55725f25b210, forward=forward@entry=true, count=10) at ../src/backend/executor/spi.c:1808 [03:12:16.114] No locals. [03:12:16.114] #24 0x00007fe0f1149ef1 in exec_for_query (estate=estate@entry=0x7fff361ffd80, stmt=stmt@entry=0x55725f30e818, portal=portal@entry=0x55725f25b210, prefetch_ok=, prefetch_ok@entry=true) at ../src/pl/plpgsql/src/pl_exec.c:5887 [03:12:16.114] var = 0x55725f30e868 [03:12:16.114] tuptab = [03:12:16.114] found = false [03:12:16.114] rc = 0 [03:12:16.114] previous_id = 1 [03:12:16.114] tupdescs_match = true [03:12:16.114] n = [03:12:16.114] #25 0x00007fe0f114aafb in exec_stmt_dynfors (estate=estate@entry=0x7fff361ffd80, stmt=stmt@entry=0x55725f30e818) at ../src/pl/plpgsql/src/pl_exec.c:4645 [03:12:16.114] portal = 0x55725f25b210 [03:12:16.114] rc = [03:12:16.114] #26 0x00007fe0f114643c in exec_stmts (estate=estate@entry=0x7fff361ffd80, stmts=0x55725f30ef18) at ../src/pl/plpgsql/src/pl_exec.c:2096 [03:12:16.114] stmt = 0x55725f30e818 [03:12:16.114] rc = [03:12:16.114] s__state = [03:12:16.114] save_estmt = 0x55725f30ef68 [03:12:16.114] s = [03:12:16.114] __func__ = "exec_stmts" [03:12:16.114] #27 0x00007fe0f114710a in exec_stmt_block (estate=estate@entry=0x7fff361ffd80, block=block@entry=0x55725f30ef68) at ../src/pl/plpgsql/src/pl_exec.c:1939 [03:12:16.114] rc = -1 [03:12:16.114] i = 3 [03:12:16.114] __func__ = "exec_stmt_block" [03:12:16.114] #28 0x00007fe0f1147251 in exec_toplevel_block (estate=estate@entry=0x7fff361ffd80, block=0x55725f30ef68) at ../src/pl/plpgsql/src/pl_exec.c:1630 [03:12:16.114] rc = [03:12:16.114] #29 0x00007fe0f1147986 in plpgsql_exec_function (func=func@entry=0x55725f21a128, fcinfo=fcinfo@entry=0x55725f2fb3c0, 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 [03:12:16.114] estate = {func = 0x55725f21a128, 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 = 0x55725f2ff2e0, tuple_store_owner = 0x55725f21a538, rsi = 0x7fff36200030, found_varno = 4, ndatums = 9, datums = 0x55725f31b4c0, datum_context = 0x55725f31b370, paramLI = 0x55725f31b470, simple_eval_estate = 0x55725f3073b0, simple_eval_resowner = 0x55725f2185a8, procedure_resowner = 0x0, cast_hash = 0x55725f325490, stmt_mcontext = 0x55725f319360, stmt_mcontext_parent = 0x55725f31b370, eval_tuptable = 0x0, eval_processed = 0, eval_econtext = 0x55725f3075c0, err_stmt = 0x55725f30e818, err_var = 0x0, err_text = 0x0, plugin_info = 0x0} [03:12:16.114] plerrcontext = {previous = 0x0, callback = 0x7fe0f1144625 , arg = 0x7fff361ffd80} [03:12:16.114] i = 1 [03:12:16.114] rc = [03:12:16.114] __func__ = "plpgsql_exec_function" [03:12:16.114] #30 0x00007fe0f1150c9b in plpgsql_call_handler (fcinfo=0x55725f2fb3c0) at ../src/pl/plpgsql/src/pl_handler.c:276 [03:12:16.114] _save_exception_stack = 0x7fff36200350 [03:12:16.114] _save_context_stack = 0x0 [03:12:16.114] _local_sigjmp_buf = {{__jmpbuf = {93949710672168, -5592578155505197254, 0, 93949711611928, 1, 93949711614384, 5592705424014106426, 5594255678014807866}, __mask_was_saved = 0, __saved_mask = {__val = {93949711594472, 0, 0, 0, 93949660543011, 93949711594432, 93949711613560, 32, 93949660745022, 1596981188, 93949711611928, 93949711594176, 93949711594432, 93949711594176, 93949660939029, 93949711594432}}}} [03:12:16.114] _do_rethrow = false [03:12:16.114] nonatomic = false [03:12:16.114] func = 0x55725f21a128 [03:12:16.114] save_cur_estate = 0x0 [03:12:16.114] procedure_resowner = 0x0 [03:12:16.114] retval = 0 [03:12:16.114] rc = [03:12:16.114] __func__ = "plpgsql_call_handler" [03:12:16.114] #31 0x000055725c27e425 in ExecMakeTableFunctionResult (setexpr=0x55725f2ff948, econtext=0x55725f2ff818, argContext=, expectedDesc=0x55725f3001b0, randomAccess=false) at ../src/backend/executor/execSRF.c:234 [03:12:16.114] result = 93949667305798 [03:12:16.114] tupstore = 0x0 [03:12:16.114] tupdesc = 0x0 [03:12:16.114] funcrettype = 2249 [03:12:16.114] returnsTuple = [03:12:16.114] returnsSet = true [03:12:16.114] fcinfo = 0x55725f2fb3c0 [03:12:16.114] fcusage = {fs = 0x0, save_f_total_time = {ticks = 93949667299059}, save_total = {ticks = 0}, start = {ticks = 93949667290918}} [03:12:16.114] rsinfo = {type = T_ReturnSetInfo, econtext = 0x55725f2ff818, expectedDesc = 0x55725f3001b0, allowedModes = 11, returnMode = SFRM_ValuePerCall, isDone = ExprSingleResult, setResult = 0x0, setDesc = 0x0} [03:12:16.114] tmptup = {t_len = 0, t_self = {ip_blkid = {bi_hi = 3, bi_lo = 0}, ip_posid = 23}, t_tableOid = 0, t_data = 0x0} [03:12:16.114] callerContext = 0x55725f2ff2e0 [03:12:16.114] first_time = true [03:12:16.114] __func__ = "ExecMakeTableFunctionResult" [03:12:16.114] #32 0x000055725c2ac63e in FunctionNext (node=0x55725f2ff608) at ../src/backend/executor/nodeFunctionscan.c:94 [03:12:16.114] tstore = 0x0 [03:12:16.114] estate = [03:12:16.114] direction = ForwardScanDirection [03:12:16.114] scanslot = 0x55725f3003d0 [03:12:16.114] alldone = [03:12:16.114] oldpos = [03:12:16.114] funcno = [03:12:16.114] att = [03:12:16.114] #33 0x000055725c27fd85 in ExecScanFetch (node=node@entry=0x55725f2ff608, accessMtd=accessMtd@entry=0x55725c2ac409 , recheckMtd=recheckMtd@entry=0x55725c2ac315 ) at ../src/backend/executor/execScan.c:131 [03:12:16.114] estate = [03:12:16.114] #34 0x000055725c27fe8f in ExecScan (node=0x55725f2ff608, accessMtd=accessMtd@entry=0x55725c2ac409 , recheckMtd=recheckMtd@entry=0x55725c2ac315 ) at ../src/backend/executor/execScan.c:180 [03:12:16.114] econtext = 0x55725f2ff818 [03:12:16.114] qual = 0x0 [03:12:16.114] projInfo = 0x0 [03:12:16.114] #35 0x000055725c2ac38d in ExecFunctionScan (pstate=) at ../src/backend/executor/nodeFunctionscan.c:269 [03:12:16.114] node = [03:12:16.114] #36 0x000055725c278ca2 in ExecProcNodeFirst (node=0x55725f2ff608) at ../src/backend/executor/execProcnode.c:469 [03:12:16.114] No locals. [03:12:16.114] #37 0x000055725c2640d9 in ExecProcNode (node=node@entry=0x55725f2ff608) at ../src/include/executor/executor.h:278 [03:12:16.114] No locals. [03:12:16.114] #38 0x000055725c26428e in ExecutePlan (estate=estate@entry=0x55725f2ff3e0, planstate=0x55725f2ff608, use_parallel_mode=, operation=operation@entry=CMD_SELECT, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x55725f2326f0, execute_once=true) at ../src/backend/executor/execMain.c:1655 [03:12:16.114] slot = [03:12:16.114] current_tuple_count = 0 [03:12:16.114] #39 0x000055725c266006 in standard_ExecutorRun (queryDesc=0x55725f36d950, direction=ForwardScanDirection, count=0, execute_once=) at ../src/backend/executor/execMain.c:362 [03:12:16.114] estate = 0x55725f2ff3e0 [03:12:16.114] operation = CMD_SELECT [03:12:16.114] dest = 0x55725f2326f0 [03:12:16.114] sendTuples = [03:12:16.114] oldcontext = 0x55725f36d850 [03:12:16.114] __func__ = "standard_ExecutorRun" [03:12:16.114] #40 0x000055725c266239 in ExecutorRun (queryDesc=queryDesc@entry=0x55725f36d950, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=) at ../src/backend/executor/execMain.c:303 [03:12:16.114] No locals. [03:12:16.114] #41 0x000055725c66520f in PortalRunSelect (portal=portal@entry=0x55725f25b100, forward=forward@entry=true, count=0, count@entry=9223372036854775807, dest=dest@entry=0x55725f2326f0) at ../src/backend/tcop/pquery.c:924 [03:12:16.114] queryDesc = 0x55725f36d950 [03:12:16.114] direction = [03:12:16.114] nprocessed = [03:12:16.114] __func__ = "PortalRunSelect" [03:12:16.114] #42 0x000055725c6686c7 in PortalRun (portal=portal@entry=0x55725f25b100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55725f2326f0, altdest=altdest@entry=0x55725f2326f0, qc=0x7fff36200490) at ../src/backend/tcop/pquery.c:768 [03:12:16.114] _save_exception_stack = 0x7fff36200540 [03:12:16.114] _save_context_stack = 0x0 [03:12:16.114] _local_sigjmp_buf = {{__jmpbuf = {0, 1767545799029481274, 93949710938368, 93949710400312, 93949710938368, 93949710400240, 5592704980416126778, 1767543012769718074}, __mask_was_saved = 0, __saved_mask = {__val = {93949667815807, 93949710395888, 112, 4, 93949667820224, 908067871, 4, 93949710400240, 112, 179, 93949710938368, 93949710400312, 93949710400288, 93949710400240, 93949667907427, 1}}}} [03:12:16.114] _do_rethrow = [03:12:16.114] result = [03:12:16.114] nprocessed = [03:12:16.114] saveTopTransactionResourceOwner = 0x55725f217db8 [03:12:16.114] saveTopTransactionContext = 0x55725f26d530 [03:12:16.114] saveActivePortal = 0x0 [03:12:16.114] saveResourceOwner = 0x55725f217db8 [03:12:16.114] savePortalContext = 0x0 [03:12:16.114] saveMemoryContext = 0x55725f26d530 [03:12:16.114] __func__ = "PortalRun" [03:12:16.114] #43 0x000055725c6618a2 in exec_simple_query (query_string=query_string@entry=0x55725f1d6af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');") at ../src/backend/tcop/postgres.c:1283 [03:12:16.114] cmdtaglen = 6 [03:12:16.114] snapshot_set = [03:12:16.114] per_parsetree_context = 0x0 [03:12:16.114] plantree_list = 0x55725f2326a0 [03:12:16.114] parsetree = 0x55725f1d7af0 [03:12:16.114] commandTag = [03:12:16.114] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:12:16.114] querytree_list = [03:12:16.114] portal = 0x55725f25b100 [03:12:16.114] receiver = 0x55725f2326f0 [03:12:16.114] format = 0 [03:12:16.114] cmdtagname = [03:12:16.114] parsetree_item__state = [03:12:16.114] dest = DestRemote [03:12:16.114] oldcontext = 0x55725f26d530 [03:12:16.114] parsetree_list = 0x55725f1d7b20 [03:12:16.114] parsetree_item = 0x55725f1d7b38 [03:12:16.114] save_log_statement_stats = false [03:12:16.114] was_logged = false [03:12:16.114] use_implicit_block = false [03:12:16.114] msec_str = "\004\000\000\000\000\000\000\000Nߑ\\rU\000\000 \005 6\377\177\000\000x\000\000\000\000\000\000" [03:12:16.114] __func__ = "exec_simple_query" [03:12:16.114] #44 0x000055725c664626 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4809 [03:12:16.114] query_string = 0x55725f1d6af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');" [03:12:16.114] firstchar = [03:12:16.114] input_message = {data = 0x55725f1d6af0 "SELECT * FROM check_estimated_rows('SELECT * FROM functional_dependencies WHERE a < ANY (ARRAY[1, 51]) AND b > ''1''');", len = 120, maxlen = 1024, cursor = 120} [03:12:16.114] local_sigjmp_buf = {{__jmpbuf = {93949680491832, 1767541247716810554, 140734101456540, 4, 5, 140734101456772, 5592704980302880570, 1767543007556591418}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93949710126608, 15616, 93949680485920, 93949710658928, 5, 93949667819772, 0, 9, 2, 93949680491840, 93949710126608, 93949680485920, 4, 5, 140734101456772}}}} [03:12:16.114] send_ready_for_query = false [03:12:16.114] idle_in_transaction_timeout_enabled = false [03:12:16.114] idle_session_timeout_enabled = false [03:12:16.114] __func__ = "PostgresMain" [03:12:16.114] #45 0x000055725c65a489 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:12:16.114] bsdata = [03:12:16.114] #46 0x000055725c50c0e6 in postmaster_child_launch (child_type=B_BACKEND, child_slot=5, startup_data=startup_data@entry=0x7fff3620069c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff362006f0) at ../src/backend/postmaster/launch_backend.c:274 [03:12:16.114] pid = [03:12:16.114] #47 0x000055725c5110e1 in BackendStartup (client_sock=client_sock@entry=0x7fff362006f0) at ../src/backend/postmaster/postmaster.c:3377 [03:12:16.114] bn = 0x55725f1ff128 [03:12:16.114] pid = [03:12:16.114] startup_data = {canAcceptConnections = CAC_OK} [03:12:16.114] cac = [03:12:16.114] __func__ = "BackendStartup" [03:12:16.114] #48 0x000055725c512fba in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [03:12:16.114] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\272Sj[rU\000\000\2007f[rU\000\000@\b 6\377\177\000\0008\b 6\377\177\000\000\225[\362\001\000\000\000\000\240\204\210\375\340\177\000\000+", '\000' , "\377\177\000\000\000\004\000\000\000\000\000\000h\226E\376\340\177\000\0000\206\210\375\340\177\000\000\340\222E\376\340\177\000\000\316)fR\000\000\000", __ss_align = 908068992}, salen = 2}} [03:12:16.114] i = 0 [03:12:16.114] now = [03:12:16.114] last_lockfile_recheck_time = 1733281686 [03:12:16.114] last_touch_time = 1733281686 [03:12:16.114] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = -28994848, user_data = 0x0}, {pos = 908069056, events = 32767, fd = -29164984, user_data = 0xf}, {pos = -41384400, events = 32736, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -28994848, user_data = 0x7fff36200838}, {pos = 908068928, events = 32767, fd = -28993944, user_data = 0x0}, {pos = 1595763632, events = 21874, fd = -55870838, user_data = 0x55725f1d6bb0}, {pos = 1, events = 21874, fd = 32768, user_data = 0xffffffff}, {pos = -56434656, events = 32736, fd = -33914976, user_data = 0x55725f202198}, {pos = 1595940984, events = 21874, fd = 1595950177, user_data = 0x7fe0fe435ebe}, {pos = 1, events = 0, fd = -28994848, user_data = 0x1ab}, {pos = 1558826328, events = 21874, fd = 0, user_data = 0xec}, {pos = 1595763632, events = 21874, fd = -29139266, user_data = 0x1}, {pos = 0, events = 0, fd = -56434656, user_data = 0x7fe0fcaf2e40 }, {pos = 16, events = 0, fd = 908070064, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fe0fe4381ba}, {pos = 0, events = 0, fd = -55906908, user_data = 0x0}, {pos = 1565794560, events = 21874, fd = 2, user_data = 0x0}, {pos = 1595510448, events = 21874, fd = 1549743091, user_data = 0x55725f209cc0}, {pos = 1549747080, events = 21874, fd = 1595972891, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -56400696, user_data = 0x7fe0fca9c880 }, {pos = -89793096, events = 32736, fd = 908070256, user_data = 0x100007f00000002}, {pos = -55873785, events = 32736, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -54584224, events = 32736, 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 = 1884846186, fd = 168455528, user_data = 0x32333337310a6174}, {pos = 943075640, events = 808716854, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1595944032, events = 21874, fd = -55870838, user_data = 0xa}, {pos = 1553183103, events = 21874, fd = 1595956368, user_data = 0x7fe0fcab576b}, {pos = -54601248, events = 32736, fd = -55963282, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xe312c15841774600}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55725f201e70}, {pos = 1, events = 0, fd = 1595940664, user_data = 0x3}, {pos = 0, events = 0, fd = 20851, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1595763632, user_data = 0x7fe0fcaf3053 }, {pos = 1595940664, events = 21874, fd = 1024, user_data = 0x7fff36200d78}, {pos = 1553266419, events = 21874, fd = 1565859056, user_data = 0x55725c93e1b0 }, {pos = 1595940464, events = 21874, fd = 1595763184, user_data = 0x55725f201e70}, {pos = -55879829, events = 32736, fd = 0, user_data = 0x55725c94fe1a }, {pos = 1595940464, events = 1, fd = 1553268579, user_data = 0x55725f1d69f0}, {pos = 1098335744, events = 3809657176, fd = 0, user_data = 0x7fe0fcaa2ab1}, {pos = -55962384, events = 32736, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1595510448, user_data = 0xe312c15841774600}, {pos = 0, events = 0, fd = 1098335744, user_data = 0xc}, {pos = 1098335744, events = 3809657176, fd = 0, user_data = 0x7fe0fca5b239 }, {pos = 237, events = 0, fd = 1548795363, user_data = 0x400000}, {pos = 0, events = 0, fd = 1595510448, user_data = 0x55725c93e044 }, {pos = 1595597088, events = 21874, fd = 1595763184, user_data = 0x55725f1ae120}, {pos = 1, events = 0, fd = 0, user_data = 0x55725c8fca41 }, {pos = 12, events = 0, fd = 1595940040, user_data = 0x55725f201ca8}, {pos = 1565795968, events = 21874, fd = 296, user_data = 0x55725c50e5fd }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1548811834, events = 21874, fd = 1562224688, user_data = 0x55725f1d73c8}} [03:12:16.115] nevents = 1 [03:12:16.115] __func__ = "ServerLoop" [03:12:16.115] #49 0x000055725c5147dd in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55725f194d70) at ../src/backend/postmaster/postmaster.c:1361 [03:12:16.115] opt = [03:12:16.115] status = [03:12:16.115] userDoption = [03:12:16.115] listen_addr_saved = false [03:12:16.115] output_config_variable = [03:12:16.115] __func__ = "PostmasterMain" [03:12:16.115] #50 0x000055725c341881 in main (argc=8, argv=0x55725f194d70) at ../src/backend/main/main.c:196 [03:12:16.115] do_check_root = [03:12:16.159] -e [03:12:16.159] [03:12:16.159] [03:12:16.253] dumping /tmp/cores/postgres-6-21636.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:12:16.513] [New LWP 21636] [03:12:16.513] [03:12:16.513] This GDB supports auto-downloading debuginfo from the following URLs: [03:12:16.513] [03:12:16.513] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:12:16.513] Debuginfod has been disabled. [03:12:16.513] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:12:16.766] [Thread debugging using libthread_db enabled] [03:12:16.766] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:12:16.766] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [03:12:16.766] Program terminated with signal SIGABRT, Aborted. [03:12:16.766] #0 0x00007fe0fcaa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:17.791] [03:12:17.791] Thread 1 (Thread 0x7fe0faa5df00 (LWP 21636)): [03:12:17.791] #0 0x00007fe0fcaa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:17.791] No symbol table info available. [03:12:17.791] #1 0x00007fe0fca5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:17.791] No symbol table info available. [03:12:17.791] #2 0x00007fe0fca45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:17.791] No symbol table info available. [03:12:17.791] #3 0x00007fe0fcc1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [03:12:17.791] No locals. [03:12:17.791] #4 0x00007fe0fcc2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [03:12:17.791] No locals. [03:12:17.791] #5 0x00007fe0fcc0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55725d153b40, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [03:12:17.791] bp = 140734101453760 [03:12:17.791] pc = [03:12:17.791] Opts = {FromUnrecoverableHandler = true, pc = 93949662393587, bp = 93949713695880} [03:12:17.791] #6 0x000055725c40f4f3 in examine_self_contradictory_rels (root=root@entry=0x55725f53db78, rel=rel@entry=0x55725f4e49c8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [03:12:17.791] lc__state = [03:12:17.791] rlist = [03:12:17.791] i = 2 [03:12:17.791] br = [03:12:17.791] expression = [03:12:17.791] or_rinfo = 0x55725f4fd1d8 [03:12:17.791] ccxt = [03:12:17.791] delidx = 0x55725f4fd071 [03:12:17.791] arglst = [03:12:17.791] lc = [03:12:17.791] arg = [03:12:17.791] n = [03:12:17.791] restrictinfo = [03:12:17.791] ccwapper = {clausecxt = 0x55725f4fca08} [03:12:17.791] sec = {sopcinfo = {n_members = 38, opcies = 0x55725f4fc4d8}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x55725f3437b8, atop_set = 0x55725f4fc8e8}, ccfree = 0x55725f4fd040, vifree = 0x55725f4fcb78} [03:12:17.791] __func__ = "examine_self_contradictory_rels" [03:12:17.791] #7 0x000055725c40f702 in examine_self_contradictory_rels_phase1 (root=root@entry=0x55725f53db78) at ../src/backend/optimizer/plan/contradictory.c:2608 [03:12:17.791] rel = 0x55725f4e49c8 [03:12:17.791] rti = 1 [03:12:17.791] rinfo = [03:12:17.791] #8 0x000055725c3d9d44 in query_planner (root=root@entry=0x55725f53db78, qp_callback=qp_callback@entry=0x55725c3df061 , qp_extra=qp_extra@entry=0x7fff361ffdc0) at ../src/backend/optimizer/plan/planmain.c:190 [03:12:17.791] parse = 0x55725f1d7d98 [03:12:17.791] joinlist = 0x55725f343828 [03:12:17.791] final_rel = [03:12:17.791] __func__ = "query_planner" [03:12:17.791] #9 0x000055725c3ed137 in grouping_planner (root=root@entry=0x55725f53db78, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [03:12:17.791] sort_input_targets = 0x5 [03:12:17.791] sort_input_target_parallel_safe = [03:12:17.791] grouping_target = [03:12:17.791] scanjoin_target = [03:12:17.791] activeWindows = 0x0 [03:12:17.791] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [03:12:17.791] sort_input_targets_contain_srfs = 0x1 [03:12:17.791] have_grouping = [03:12:17.791] wflists = 0x0 [03:12:17.791] gset_data = 0x0 [03:12:17.791] sort_input_target = [03:12:17.791] grouping_targets = 0x1 [03:12:17.791] grouping_target_parallel_safe = [03:12:17.791] scanjoin_targets = 0x0 [03:12:17.791] scanjoin_target_parallel_safe = [03:12:17.791] grouping_targets_contain_srfs = 0x1 [03:12:17.791] scanjoin_targets_contain_srfs = 0x55725c9515ca [03:12:17.791] scanjoin_target_same_exprs = [03:12:17.791] parse = 0x55725f1d7d98 [03:12:17.791] offset_est = 0 [03:12:17.791] count_est = 0 [03:12:17.791] limit_tuples = -1 [03:12:17.791] have_postponed_srfs = false [03:12:17.791] final_target = [03:12:17.791] final_targets = 0x55725f2d77c8 [03:12:17.791] final_targets_contain_srfs = 0x55725c34b78f [03:12:17.791] final_target_parallel_safe = [03:12:17.791] current_rel = [03:12:17.791] final_rel = [03:12:17.791] extra = {limit_needed = false, limit_tuples = 4.6417300219088326e-310, count_est = 93949711889032, offset_est = 93949711889032} [03:12:17.791] lc = [03:12:17.791] __func__ = "grouping_planner" [03:12:17.791] #10 0x000055725c3f00bb in subquery_planner (glob=glob@entry=0x55725f4e48b8, parse=parse@entry=0x55725f1d7d98, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1153 [03:12:17.791] root = 0x55725f53db78 [03:12:17.791] newWithCheckOptions = [03:12:17.791] newHaving = 0x0 [03:12:17.791] hasOuterJoins = [03:12:17.791] hasResultRTEs = false [03:12:17.791] final_rel = [03:12:17.791] l = 0x0 [03:12:17.791] #11 0x000055725c3f0d4c in standard_planner (parse=0x55725f1d7d98, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [03:12:17.791] result = [03:12:17.791] glob = 0x55725f4e48b8 [03:12:17.791] tuple_fraction = 0 [03:12:17.791] root = [03:12:17.791] final_rel = [03:12:17.791] best_path = [03:12:17.791] top_plan = [03:12:17.791] lp = [03:12:17.791] lr = [03:12:17.791] #12 0x000055725c3f1db6 in planner (parse=parse@entry=0x55725f1d7d98, query_string=query_string@entry=0x55725f1d6af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:294 [03:12:17.791] result = [03:12:17.791] #13 0x000055725c660dcc in pg_plan_query (querytree=querytree@entry=0x55725f1d7d98, query_string=query_string@entry=0x55725f1d6af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [03:12:17.791] plan = [03:12:17.791] #14 0x000055725c1672ff in standard_ExplainOneQuery (query=0x55725f1d7d98, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55725f2021b8, queryString=0x55725f1d6af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:496 [03:12:17.791] plan = [03:12:17.791] planstart = [03:12:17.791] planduration = {ticks = 93949661569203} [03:12:17.791] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 93949667820224, shared_blks_dirtied = 908066990, shared_blks_written = 3, local_blks_hit = 4294967296, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 93949710400920, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 93949667907018}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93949661566584}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 93949710400920}} [03:12:17.791] bufusage = {shared_blks_hit = 0, shared_blks_read = 93949664589302, shared_blks_dirtied = 73014444048384, shared_blks_written = 72057594037927936, local_blks_hit = 140604093932048, local_blks_read = 93949710402096, local_blks_dirtied = 93949710400920, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 93949667436011, shared_blk_read_time = {ticks = 140604093932048}, shared_blk_write_time = {ticks = 93949667436030}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93949667815807}, temp_blk_read_time = {ticks = 93949710573168}, temp_blk_write_time = {ticks = 64}} [03:12:17.791] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140734101454896, freespace = 10} [03:12:17.791] planner_ctx = 0x0 [03:12:17.791] saved_ctx = 0x0 [03:12:17.791] #15 0x000055725c1675e5 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55725f2021b8, pstate=pstate@entry=0x55725f2020a8, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [03:12:17.791] No locals. [03:12:17.791] #16 0x000055725c1684e5 in ExplainQuery (pstate=pstate@entry=0x55725f2020a8, stmt=stmt@entry=0x55725f1d7bd8, params=params@entry=0x0, dest=dest@entry=0x55725f202018) at ../src/backend/commands/explain.c:350 [03:12:17.791] l__state = [03:12:17.791] l = 0x55725f4e4880 [03:12:17.791] es = 0x55725f2021b8 [03:12:17.791] tstate = [03:12:17.791] jstate = [03:12:17.791] query = [03:12:17.791] rewritten = 0x55725f4e4868 [03:12:17.791] lc = 0x0 [03:12:17.791] timing_set = false [03:12:17.791] summary_set = false [03:12:17.791] __func__ = "ExplainQuery" [03:12:17.791] #17 0x000055725c66b9b3 in standard_ProcessUtility (pstmt=0x55725f1d7c88, queryString=0x55725f1d6af0 "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=0x55725f202018, qc=0x7fff362002b0) at ../src/backend/tcop/utility.c:866 [03:12:17.791] parsetree = 0x55725f1d7bd8 [03:12:17.791] isTopLevel = true [03:12:17.791] isAtomicContext = false [03:12:17.791] pstate = 0x55725f2020a8 [03:12:17.791] readonly_flags = [03:12:17.791] __func__ = "standard_ProcessUtility" [03:12:17.791] #18 0x000055725c66c0dc in ProcessUtility (pstmt=pstmt@entry=0x55725f1d7c88, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55725f202018, qc=0x7fff362002b0) at ../src/backend/tcop/utility.c:523 [03:12:17.791] No locals. [03:12:17.791] #19 0x000055725c667948 in PortalRunUtility (portal=portal@entry=0x55725f25b100, pstmt=0x55725f1d7c88, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55725f202018, qc=qc@entry=0x7fff362002b0) at ../src/backend/tcop/pquery.c:1158 [03:12:17.791] No locals. [03:12:17.791] #20 0x000055725c6681bb in FillPortalStore (portal=portal@entry=0x55725f25b100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [03:12:17.791] treceiver = 0x55725f202018 [03:12:17.791] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:12:17.791] __func__ = "FillPortalStore" [03:12:17.791] #21 0x000055725c6687af in PortalRun (portal=portal@entry=0x55725f25b100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55725f2d7bd8, altdest=altdest@entry=0x55725f2d7bd8, qc=0x7fff36200490) at ../src/backend/tcop/pquery.c:763 [03:12:17.791] _save_exception_stack = 0x7fff36200540 [03:12:17.791] _save_context_stack = 0x0 [03:12:17.791] _local_sigjmp_buf = {{__jmpbuf = {0, 1767545853082525498, 93949710938368, 93949710400592, 93949710938368, 93949710400520, 5592704980416126778, 1767543012769718074}, __mask_was_saved = 0, __saved_mask = {__val = {93949667815807, 93949710395888, 112, 4, 93949667820224, 908067871, 4, 93949710400520, 112, 153, 93949710938368, 93949710400592, 93949710400568, 93949710400520, 93949667907427, 1}}}} [03:12:17.791] _do_rethrow = [03:12:17.791] result = [03:12:17.791] nprocessed = [03:12:17.791] saveTopTransactionResourceOwner = 0x55725f217db8 [03:12:17.791] saveTopTransactionContext = 0x55725f26d530 [03:12:17.791] saveActivePortal = 0x0 [03:12:17.791] saveResourceOwner = 0x55725f217db8 [03:12:17.791] savePortalContext = 0x0 [03:12:17.791] saveMemoryContext = 0x55725f26d530 [03:12:17.791] __func__ = "PortalRun" [03:12:17.791] #22 0x000055725c6618a2 in exec_simple_query (query_string=query_string@entry=0x55725f1d6af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1283 [03:12:17.791] cmdtaglen = 7 [03:12:17.791] snapshot_set = [03:12:17.791] per_parsetree_context = 0x0 [03:12:17.791] plantree_list = 0x55725f2d7b88 [03:12:17.791] parsetree = 0x55725f1d7c08 [03:12:17.791] commandTag = [03:12:17.791] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:12:17.791] querytree_list = [03:12:17.791] portal = 0x55725f25b100 [03:12:17.791] receiver = 0x55725f2d7bd8 [03:12:17.791] format = 0 [03:12:17.791] cmdtagname = [03:12:17.791] parsetree_item__state = [03:12:17.791] dest = DestRemote [03:12:17.791] oldcontext = 0x55725f26d530 [03:12:17.791] parsetree_list = 0x55725f1d7c38 [03:12:17.791] parsetree_item = 0x55725f1d7c50 [03:12:17.791] save_log_statement_stats = false [03:12:17.791] was_logged = false [03:12:17.791] use_implicit_block = false [03:12:17.791] msec_str = "\004\000\000\000\000\000\000\000Nߑ\\rU\000\000 \005 6\377\177\000\000n\000\000\000\000\000\000" [03:12:17.791] __func__ = "exec_simple_query" [03:12:17.791] #23 0x000055725c664626 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4809 [03:12:17.791] query_string = 0x55725f1d6af0 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [03:12:17.791] firstchar = [03:12:17.791] input_message = {data = 0x55725f1d6af0 "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} [03:12:17.791] local_sigjmp_buf = {{__jmpbuf = {93949680491832, 1767541247716810554, 140734101456540, 4, 8, 140734101456772, 5592704980302880570, 1767543007556591418}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93949710126608, 15616, 93949680485920, 93949710658928, 8, 93949667819772, 0, 9, 2, 93949680491840, 93949710126608, 93949680485920, 4, 8, 140734101456772}}}} [03:12:17.791] send_ready_for_query = false [03:12:17.791] idle_in_transaction_timeout_enabled = false [03:12:17.791] idle_session_timeout_enabled = false [03:12:17.791] __func__ = "PostgresMain" [03:12:17.791] #24 0x000055725c65a489 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:12:17.791] bsdata = [03:12:17.791] #25 0x000055725c50c0e6 in postmaster_child_launch (child_type=B_BACKEND, child_slot=8, startup_data=startup_data@entry=0x7fff3620069c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff362006f0) at ../src/backend/postmaster/launch_backend.c:274 [03:12:17.791] pid = [03:12:17.791] #26 0x000055725c5110e1 in BackendStartup (client_sock=client_sock@entry=0x7fff362006f0) at ../src/backend/postmaster/postmaster.c:3377 [03:12:17.791] bn = 0x55725f1ff1b8 [03:12:17.791] pid = [03:12:17.791] startup_data = {canAcceptConnections = CAC_OK} [03:12:17.791] cac = [03:12:17.791] __func__ = "BackendStartup" [03:12:17.791] #27 0x000055725c512fba in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [03:12:17.791] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\272Sj[rU\000\000\2007f[rU\000\000@\b 6\377\177\000\0008\b 6\377\177\000\000\225[\362\001\000\000\000\000\240\204\210\375\340\177\000\000+", '\000' , "\377\177\000\000\000\004\000\000\000\000\000\000h\226E\376\340\177\000\0000\206\210\375\340\177\000\000\340\222E\376\340\177\000\000\316)fR\000\000\000", __ss_align = 908068992}, salen = 2}} [03:12:17.791] i = 0 [03:12:17.791] now = [03:12:17.791] last_lockfile_recheck_time = 1733281686 [03:12:17.791] last_touch_time = 1733281686 [03:12:17.791] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = -41384400, events = 32736, fd = -28994848, user_data = 0x7c96e577}, {pos = 908069056, events = 32767, fd = -29164984, user_data = 0xf}, {pos = -41384400, events = 32736, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -28994848, user_data = 0x7fff36200838}, {pos = 908068928, events = 32767, fd = -28993944, user_data = 0x0}, {pos = 1595763632, events = 21874, fd = -55870838, user_data = 0x55725f1d6bb0}, {pos = 1, events = 21874, fd = 32768, user_data = 0xffffffff}, {pos = -56434656, events = 32736, fd = -33914976, user_data = 0x55725f202198}, {pos = 1595940984, events = 21874, fd = 1595950177, user_data = 0x7fe0fe435ebe}, {pos = 1, events = 0, fd = -28994848, user_data = 0x1ab}, {pos = 1558826328, events = 21874, fd = 0, user_data = 0xec}, {pos = 1595763632, events = 21874, fd = -29139266, user_data = 0x1}, {pos = 0, events = 0, fd = -56434656, user_data = 0x7fe0fcaf2e40 }, {pos = 16, events = 0, fd = 908070064, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fe0fe4381ba}, {pos = 0, events = 0, fd = -55906908, user_data = 0x0}, {pos = 1565794560, events = 21874, fd = 2, user_data = 0x0}, {pos = 1595510448, events = 21874, fd = 1549743091, user_data = 0x55725f209cc0}, {pos = 1549747080, events = 21874, fd = 1595972891, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -56400696, user_data = 0x7fe0fca9c880 }, {pos = -89793096, events = 32736, fd = 908070256, user_data = 0x100007f00000002}, {pos = -55873785, events = 32736, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -54584224, events = 32736, 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 = 1884846186, fd = 168455528, user_data = 0x32333337310a6174}, {pos = 943075640, events = 808716854, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1595944032, events = 21874, fd = -55870838, user_data = 0xa}, {pos = 1553183103, events = 21874, fd = 1595956368, user_data = 0x7fe0fcab576b}, {pos = -54601248, events = 32736, fd = -55963282, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xe312c15841774600}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55725f201e70}, {pos = 1, events = 0, fd = 1595940664, user_data = 0x3}, {pos = 0, events = 0, fd = 20851, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1595763632, user_data = 0x7fe0fcaf3053 }, {pos = 1595940664, events = 21874, fd = 1024, user_data = 0x7fff36200d78}, {pos = 1553266419, events = 21874, fd = 1565859056, user_data = 0x55725c93e1b0 }, {pos = 1595940464, events = 21874, fd = 1595763184, user_data = 0x55725f201e70}, {pos = -55879829, events = 32736, fd = 0, user_data = 0x55725c94fe1a }, {pos = 1595940464, events = 1, fd = 1553268579, user_data = 0x55725f1d69f0}, {pos = 1098335744, events = 3809657176, fd = 0, user_data = 0x7fe0fcaa2ab1}, {pos = -55962384, events = 32736, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1595510448, user_data = 0xe312c15841774600}, {pos = 0, events = 0, fd = 1098335744, user_data = 0xc}, {pos = 1098335744, events = 3809657176, fd = 0, user_data = 0x7fe0fca5b239 }, {pos = 237, events = 0, fd = 1548795363, user_data = 0x400000}, {pos = 0, events = 0, fd = 1595510448, user_data = 0x55725c93e044 }, {pos = 1595597088, events = 21874, fd = 1595763184, user_data = 0x55725f1ae120}, {pos = 1, events = 0, fd = 0, user_data = 0x55725c8fca41 }, {pos = 12, events = 0, fd = 1595940040, user_data = 0x55725f201ca8}, {pos = 1565795968, events = 21874, fd = 296, user_data = 0x55725c50e5fd }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1548811834, events = 21874, fd = 1562224688, user_data = 0x55725f1d73c8}} [03:12:17.792] nevents = 1 [03:12:17.792] __func__ = "ServerLoop" [03:12:17.792] #28 0x000055725c5147dd in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55725f194d70) at ../src/backend/postmaster/postmaster.c:1361 [03:12:17.792] opt = [03:12:17.792] status = [03:12:17.792] userDoption = [03:12:17.792] listen_addr_saved = false [03:12:17.792] output_config_variable = [03:12:17.792] __func__ = "PostmasterMain" [03:12:17.792] #29 0x000055725c341881 in main (argc=8, argv=0x55725f194d70) at ../src/backend/main/main.c:196 [03:12:17.792] do_check_root = [03:12:17.831] -e [03:12:17.831] [03:12:17.831] [03:12:17.898] dumping /tmp/cores/postgres-6-26951.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:12:18.163] [New LWP 26951] [03:12:18.163] [03:12:18.163] This GDB supports auto-downloading debuginfo from the following URLs: [03:12:18.163] [03:12:18.163] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:12:18.163] Debuginfod has been disabled. [03:12:18.163] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:12:18.268] [Thread debugging using libthread_db enabled] [03:12:18.268] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:12:18.268] Core was generated by `postgres: postgres regression [local] EXPLAIN '. [03:12:18.268] Program terminated with signal SIGABRT, Aborted. [03:12:18.268] #0 0x00007fe0fcaa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:19.307] [03:12:19.307] Thread 1 (Thread 0x7fe0faa5df00 (LWP 26951)): [03:12:19.307] #0 0x00007fe0fcaa9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:19.307] No symbol table info available. [03:12:19.307] #1 0x00007fe0fca5afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:19.307] No symbol table info available. [03:12:19.307] #2 0x00007fe0fca45472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:19.307] No symbol table info available. [03:12:19.307] #3 0x00007fe0fcc1e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [03:12:19.307] No locals. [03:12:19.307] #4 0x00007fe0fcc2aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [03:12:19.307] No locals. [03:12:19.307] #5 0x00007fe0fcc0dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55725d153b40, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [03:12:19.307] bp = 140734101453760 [03:12:19.307] pc = [03:12:19.307] Opts = {FromUnrecoverableHandler = true, pc = 93949662393587, bp = 93949711444920} [03:12:19.307] #6 0x000055725c40f4f3 in examine_self_contradictory_rels (root=root@entry=0x55725f233408, rel=rel@entry=0x55725f2331b8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [03:12:19.307] lc__state = [03:12:19.307] rlist = [03:12:19.307] i = 2 [03:12:19.307] br = [03:12:19.307] expression = [03:12:19.307] or_rinfo = 0x55725f2d7798 [03:12:19.307] ccxt = [03:12:19.307] delidx = 0x55725f2d7731 [03:12:19.307] arglst = [03:12:19.307] lc = [03:12:19.307] arg = [03:12:19.307] n = [03:12:19.307] restrictinfo = [03:12:19.307] ccwapper = {clausecxt = 0x55725f2d7098} [03:12:19.307] sec = {sopcinfo = {n_members = 38, opcies = 0x55725f2d6c08}, attrsdc = {min_attr = -6, max_attr = 5, len_set = 2, atop_array = 0x55725f2d6328, atop_set = 0x55725f2d64a8}, ccfree = 0x55725f2d7700, vifree = 0x55725f2d72a0} [03:12:19.307] __func__ = "examine_self_contradictory_rels" [03:12:19.307] #7 0x000055725c40f702 in examine_self_contradictory_rels_phase1 (root=root@entry=0x55725f233408) at ../src/backend/optimizer/plan/contradictory.c:2608 [03:12:19.307] rel = 0x55725f2331b8 [03:12:19.307] rti = 1 [03:12:19.307] rinfo = [03:12:19.307] #8 0x000055725c3d9d44 in query_planner (root=root@entry=0x55725f233408, qp_callback=qp_callback@entry=0x55725c3df061 , qp_extra=qp_extra@entry=0x7fff361ffdc0) at ../src/backend/optimizer/plan/planmain.c:190 [03:12:19.307] parse = 0x55725f1d80e0 [03:12:19.307] joinlist = 0x55725f2d6518 [03:12:19.307] final_rel = [03:12:19.307] __func__ = "query_planner" [03:12:19.307] #9 0x000055725c3ed137 in grouping_planner (root=root@entry=0x55725f233408, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [03:12:19.307] sort_input_targets = 0x5 [03:12:19.307] sort_input_target_parallel_safe = [03:12:19.307] grouping_target = [03:12:19.307] scanjoin_target = [03:12:19.307] activeWindows = 0x0 [03:12:19.307] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [03:12:19.307] sort_input_targets_contain_srfs = 0x1 [03:12:19.307] have_grouping = [03:12:19.307] wflists = 0x0 [03:12:19.307] gset_data = 0x0 [03:12:19.307] sort_input_target = [03:12:19.307] grouping_targets = 0x1 [03:12:19.307] grouping_target_parallel_safe = [03:12:19.307] scanjoin_targets = 0x0 [03:12:19.307] scanjoin_target_parallel_safe = [03:12:19.307] grouping_targets_contain_srfs = 0x1 [03:12:19.307] scanjoin_targets_contain_srfs = 0x55725c9515ca [03:12:19.307] scanjoin_target_same_exprs = [03:12:19.307] parse = 0x55725f1d80e0 [03:12:19.307] offset_est = 0 [03:12:19.307] count_est = 0 [03:12:19.307] limit_tuples = -1 [03:12:19.307] have_postponed_srfs = false [03:12:19.307] final_target = [03:12:19.307] final_targets = 0x55725f20d618 [03:12:19.307] final_targets_contain_srfs = 0x55725c34b78f [03:12:19.307] final_target_parallel_safe = [03:12:19.307] current_rel = [03:12:19.307] final_rel = [03:12:19.307] extra = {limit_needed = false, limit_tuples = 4.6417300219088326e-310, count_est = 93949710779144, offset_est = 93949710779144} [03:12:19.307] lc = [03:12:19.307] __func__ = "grouping_planner" [03:12:19.307] #10 0x000055725c3f00bb in subquery_planner (glob=glob@entry=0x55725f2330a8, parse=parse@entry=0x55725f1d80e0, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1153 [03:12:19.307] root = 0x55725f233408 [03:12:19.307] newWithCheckOptions = [03:12:19.307] newHaving = 0x0 [03:12:19.307] hasOuterJoins = [03:12:19.307] hasResultRTEs = false [03:12:19.307] final_rel = [03:12:19.307] l = 0x0 [03:12:19.307] #11 0x000055725c3f0d4c in standard_planner (parse=0x55725f1d80e0, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [03:12:19.307] result = [03:12:19.307] glob = 0x55725f2330a8 [03:12:19.307] tuple_fraction = 0 [03:12:19.307] root = [03:12:19.307] final_rel = [03:12:19.307] best_path = [03:12:19.307] top_plan = [03:12:19.307] lp = [03:12:19.307] lr = [03:12:19.307] #12 0x000055725c3f1db6 in planner (parse=parse@entry=0x55725f1d80e0, query_string=query_string@entry=0x55725f1d6af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:294 [03:12:19.307] result = [03:12:19.307] #13 0x000055725c660dcc in pg_plan_query (querytree=querytree@entry=0x55725f1d80e0, query_string=query_string@entry=0x55725f1d6af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [03:12:19.307] plan = [03:12:19.307] #14 0x000055725c1672ff in standard_ExplainOneQuery (query=0x55725f1d80e0, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55725f2114b8, queryString=0x55725f1d6af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:496 [03:12:19.307] plan = [03:12:19.307] planstart = [03:12:19.307] planduration = {ticks = 93949661569203} [03:12:19.307] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 93949667820224, shared_blks_dirtied = 908066990, shared_blks_written = 3, local_blks_hit = 5890736080, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 93949710401760, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 93949667907018}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93949661566584}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 93949710401760}} [03:12:19.307] bufusage = {shared_blks_hit = 0, shared_blks_read = 93949664589302, shared_blks_dirtied = 214636695666688, shared_blks_written = 72057594037927936, local_blks_hit = 140604094468328, local_blks_read = 93949710403152, local_blks_dirtied = 93949710401760, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 93949667436011, shared_blk_read_time = {ticks = 140604094468328}, shared_blk_write_time = {ticks = 93949667436030}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93949667815807}, temp_blk_read_time = {ticks = 93949710635376}, temp_blk_write_time = {ticks = 64}} [03:12:19.307] mem_counters = {nblocks = 93949710774280, freechunks = 4294967297, totalspace = 140734101454896, freespace = 10} [03:12:19.307] planner_ctx = 0x0 [03:12:19.307] saved_ctx = 0x0 [03:12:19.307] #15 0x000055725c1675e5 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55725f2114b8, pstate=pstate@entry=0x55725f2113a8, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [03:12:19.307] No locals. [03:12:19.307] #16 0x000055725c1684e5 in ExplainQuery (pstate=pstate@entry=0x55725f2113a8, stmt=stmt@entry=0x55725f1d7f20, params=params@entry=0x0, dest=dest@entry=0x55725f211318) at ../src/backend/commands/explain.c:350 [03:12:19.307] l__state = [03:12:19.307] l = 0x55725f233070 [03:12:19.307] es = 0x55725f2114b8 [03:12:19.307] tstate = [03:12:19.307] jstate = [03:12:19.307] query = [03:12:19.307] rewritten = 0x55725f233058 [03:12:19.307] lc = 0x0 [03:12:19.307] timing_set = false [03:12:19.307] summary_set = false [03:12:19.307] __func__ = "ExplainQuery" [03:12:19.307] #17 0x000055725c66b9b3 in standard_ProcessUtility (pstmt=0x55725f1d7fd0, queryString=0x55725f1d6af0 "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=0x55725f211318, qc=0x7fff362002b0) at ../src/backend/tcop/utility.c:866 [03:12:19.307] parsetree = 0x55725f1d7f20 [03:12:19.307] isTopLevel = true [03:12:19.307] isAtomicContext = false [03:12:19.307] pstate = 0x55725f2113a8 [03:12:19.307] readonly_flags = [03:12:19.307] __func__ = "standard_ProcessUtility" [03:12:19.307] #18 0x000055725c66c0dc in ProcessUtility (pstmt=pstmt@entry=0x55725f1d7fd0, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55725f211318, qc=0x7fff362002b0) at ../src/backend/tcop/utility.c:523 [03:12:19.307] No locals. [03:12:19.307] #19 0x000055725c667948 in PortalRunUtility (portal=portal@entry=0x55725f259100, pstmt=0x55725f1d7fd0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55725f211318, qc=qc@entry=0x7fff362002b0) at ../src/backend/tcop/pquery.c:1158 [03:12:19.307] No locals. [03:12:19.307] #20 0x000055725c6681bb in FillPortalStore (portal=portal@entry=0x55725f259100, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [03:12:19.307] treceiver = 0x55725f211318 [03:12:19.307] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:12:19.307] __func__ = "FillPortalStore" [03:12:19.307] #21 0x000055725c6687af in PortalRun (portal=portal@entry=0x55725f259100, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55725f20d8f8, altdest=altdest@entry=0x55725f20d8f8, qc=0x7fff36200490) at ../src/backend/tcop/pquery.c:763 [03:12:19.307] _save_exception_stack = 0x7fff36200540 [03:12:19.307] _save_context_stack = 0x0 [03:12:19.307] _local_sigjmp_buf = {{__jmpbuf = {0, 1767545815606419258, 93949710930176, 93949710401432, 93949710930176, 93949710401360, 5592704980416126778, 1767543012769718074}, __mask_was_saved = 0, __saved_mask = {__val = {93949667815807, 93949710395888, 112, 4, 93949667820224, 908067871, 4, 93949710401360, 112, 153, 93949710930176, 93949710401432, 93949710401408, 93949710401360, 93949667907427, 1}}}} [03:12:19.307] _do_rethrow = [03:12:19.307] result = [03:12:19.307] nprocessed = [03:12:19.307] saveTopTransactionResourceOwner = 0x55725f218898 [03:12:19.307] saveTopTransactionContext = 0x55725f26b530 [03:12:19.307] saveActivePortal = 0x0 [03:12:19.307] saveResourceOwner = 0x55725f218898 [03:12:19.307] savePortalContext = 0x0 [03:12:19.307] saveMemoryContext = 0x55725f26b530 [03:12:19.307] __func__ = "PortalRun" [03:12:19.307] #22 0x000055725c6618a2 in exec_simple_query (query_string=query_string@entry=0x55725f1d6af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;") at ../src/backend/tcop/postgres.c:1283 [03:12:19.307] cmdtaglen = 7 [03:12:19.307] snapshot_set = [03:12:19.307] per_parsetree_context = 0x0 [03:12:19.307] plantree_list = 0x55725f20d8a8 [03:12:19.307] parsetree = 0x55725f1d7f50 [03:12:19.307] commandTag = [03:12:19.307] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:12:19.307] querytree_list = [03:12:19.307] portal = 0x55725f259100 [03:12:19.307] receiver = 0x55725f20d8f8 [03:12:19.307] format = 0 [03:12:19.307] cmdtagname = [03:12:19.307] parsetree_item__state = [03:12:19.307] dest = DestRemote [03:12:19.307] oldcontext = 0x55725f26b530 [03:12:19.307] parsetree_list = 0x55725f1d7f80 [03:12:19.307] parsetree_item = 0x55725f1d7f98 [03:12:19.307] save_log_statement_stats = false [03:12:19.307] was_logged = false [03:12:19.307] use_implicit_block = false [03:12:19.307] msec_str = "\004\000\000\000\000\000\000\000Nߑ\\rU\000\000 \005 6\377\177\000\000J\000\000\000\000\000\000" [03:12:19.307] __func__ = "exec_simple_query" [03:12:19.307] #23 0x000055725c664626 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4809 [03:12:19.307] query_string = 0x55725f1d6af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;" [03:12:19.307] firstchar = [03:12:19.307] input_message = {data = 0x55725f1d6af0 "explain (costs off)\nSELECT * FROM self_a WHERE a < 9 AND a > 10 OR b < 8;", len = 74, maxlen = 1024, cursor = 74} [03:12:19.307] local_sigjmp_buf = {{__jmpbuf = {93949680491832, 1767541247716810554, 140734101456540, 4, 5, 140734101456772, 5592704980302880570, 1767543007556591418}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93949710126608, 15616, 93949680485920, 93949710650736, 5, 93949667819772, 0, 9, 2, 93949680491840, 93949710126608, 93949680485920, 4, 5, 140734101456772}}}} [03:12:19.307] send_ready_for_query = false [03:12:19.307] idle_in_transaction_timeout_enabled = false [03:12:19.307] idle_session_timeout_enabled = false [03:12:19.307] __func__ = "PostgresMain" [03:12:19.307] #24 0x000055725c65a489 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:12:19.307] bsdata = [03:12:19.307] #25 0x000055725c50c0e6 in postmaster_child_launch (child_type=B_BACKEND, child_slot=5, startup_data=startup_data@entry=0x7fff3620069c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff362006f0) at ../src/backend/postmaster/launch_backend.c:274 [03:12:19.307] pid = [03:12:19.307] #26 0x000055725c5110e1 in BackendStartup (client_sock=client_sock@entry=0x7fff362006f0) at ../src/backend/postmaster/postmaster.c:3377 [03:12:19.307] bn = 0x55725f1ff128 [03:12:19.307] pid = [03:12:19.307] startup_data = {canAcceptConnections = CAC_OK} [03:12:19.307] cac = [03:12:19.307] __func__ = "BackendStartup" [03:12:19.307] #27 0x000055725c512fba in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [03:12:19.307] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = '\000' , "\272Sj[rU\000\000\2007f[rU\000\000@\b 6\377\177\000\0008\b 6\377\177\000\000\225[\362\001\000\000\000\000\240\204\210\375\340\177\000\000+", '\000' , "\377\177\000\000\000\004\000\000\000\000\000\000h\226E\376\340\177\000\0000\206\210\375\340\177\000\000\340\222E\376\340\177\000\000\316)fR\000\000\000", __ss_align = 908068992}, salen = 2}} [03:12:19.307] i = 0 [03:12:19.307] now = [03:12:19.307] last_lockfile_recheck_time = 1733281686 [03:12:19.307] last_touch_time = 1733281686 [03:12:19.307] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = -28994848, user_data = 0x0}, {pos = 908069056, events = 32767, fd = -29164984, user_data = 0xf}, {pos = -41384400, events = 32736, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -28994848, user_data = 0x7fff36200838}, {pos = 908068928, events = 32767, fd = -28993944, user_data = 0x0}, {pos = 1595763632, events = 21874, fd = -55870838, user_data = 0x55725f1d6bb0}, {pos = 1, events = 21874, fd = 32768, user_data = 0xffffffff}, {pos = -56434656, events = 32736, fd = -33914976, user_data = 0x55725f202198}, {pos = 1595940984, events = 21874, fd = 1595950177, user_data = 0x7fe0fe435ebe}, {pos = 1, events = 0, fd = -28994848, user_data = 0x1ab}, {pos = 1558826328, events = 21874, fd = 0, user_data = 0xec}, {pos = 1595763632, events = 21874, fd = -29139266, user_data = 0x1}, {pos = 0, events = 0, fd = -56434656, user_data = 0x7fe0fcaf2e40 }, {pos = 16, events = 0, fd = 908070064, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x7fe0fe4381ba}, {pos = 0, events = 0, fd = -55906908, user_data = 0x0}, {pos = 1565794560, events = 21874, fd = 2, user_data = 0x0}, {pos = 1595510448, events = 21874, fd = 1549743091, user_data = 0x55725f209cc0}, {pos = 1549747080, events = 21874, fd = 1595972891, user_data = 0x2ffff00001fa0}, {pos = 1702060386, events = 1936158767, fd = 1952410737, user_data = 0x1}, {pos = 0, events = 0, fd = -56400696, user_data = 0x7fe0fca9c880 }, {pos = -89793096, events = 32736, fd = 908070256, user_data = 0x100007f00000002}, {pos = -55873785, events = 32736, fd = 2, user_data = 0x820}, {pos = 255, events = 0, fd = 99, user_data = 0x2}, {pos = -54584224, events = 32736, 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 = 1884846186, fd = 168455528, user_data = 0x32333337310a6174}, {pos = 943075640, events = 808716854, fd = 795768178, user_data = 0x726765722f737365}, {pos = 1836330762, events = 1768107888, fd = 1937076850, user_data = 0x0}, {pos = 0, events = 21760, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1595944032, events = 21874, fd = -55870838, user_data = 0xa}, {pos = 1553183103, events = 21874, fd = 1595956368, user_data = 0x7fe0fcab576b}, {pos = -54601248, events = 32736, fd = -55963282, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xe312c15841774600}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55725f201e70}, {pos = 1, events = 0, fd = 1595940664, user_data = 0x3}, {pos = 0, events = 0, fd = 20851, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 1595763632, user_data = 0x7fe0fcaf3053 }, {pos = 1595940664, events = 21874, fd = 1024, user_data = 0x7fff36200d78}, {pos = 1553266419, events = 21874, fd = 1565859056, user_data = 0x55725c93e1b0 }, {pos = 1595940464, events = 21874, fd = 1595763184, user_data = 0x55725f201e70}, {pos = -55879829, events = 32736, fd = 0, user_data = 0x55725c94fe1a }, {pos = 1595940464, events = 1, fd = 1553268579, user_data = 0x55725f1d69f0}, {pos = 1098335744, events = 3809657176, fd = 0, user_data = 0x7fe0fcaa2ab1}, {pos = -55962384, events = 32736, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1595510448, user_data = 0xe312c15841774600}, {pos = 0, events = 0, fd = 1098335744, user_data = 0xc}, {pos = 1098335744, events = 3809657176, fd = 0, user_data = 0x7fe0fca5b239 }, {pos = 237, events = 0, fd = 1548795363, user_data = 0x400000}, {pos = 0, events = 0, fd = 1595510448, user_data = 0x55725c93e044 }, {pos = 1595597088, events = 21874, fd = 1595763184, user_data = 0x55725f1ae120}, {pos = 1, events = 0, fd = 0, user_data = 0x55725c8fca41 }, {pos = 12, events = 0, fd = 1595940040, user_data = 0x55725f201ca8}, {pos = 1565795968, events = 21874, fd = 296, user_data = 0x55725c50e5fd }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 1548811834, events = 21874, fd = 1562224688, user_data = 0x55725f1d73c8}} [03:12:19.307] nevents = 1 [03:12:19.307] __func__ = "ServerLoop" [03:12:19.307] #28 0x000055725c5147dd in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55725f194d70) at ../src/backend/postmaster/postmaster.c:1361 [03:12:19.307] opt = [03:12:19.307] status = [03:12:19.307] userDoption = [03:12:19.307] listen_addr_saved = false [03:12:19.307] output_config_variable = [03:12:19.307] __func__ = "PostmasterMain" [03:12:19.307] #29 0x000055725c341881 in main (argc=8, argv=0x55725f194d70) at ../src/backend/main/main.c:196 [03:12:19.307] do_check_root = [03:12:19.345] -e [03:12:19.345] [03:12:19.345] [03:12:19.424] dumping /tmp/cores/postgres-6-22549.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:12:19.685] [New LWP 22549] [03:12:19.685] [03:12:19.685] This GDB supports auto-downloading debuginfo from the following URLs: [03:12:19.685] [03:12:19.685] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:12:19.685] Debuginfod has been disabled. [03:12:19.685] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:12:19.943] [Thread debugging using libthread_db enabled] [03:12:19.943] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:12:19.943] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN '. [03:12:19.943] Program terminated with signal SIGABRT, Aborted. [03:12:19.943] #0 0x00007f6d400a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:20.955] [03:12:20.955] Thread 1 (Thread 0x7f6d40835f00 (LWP 22549)): [03:12:20.955] #0 0x00007f6d400a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:20.955] No symbol table info available. [03:12:20.955] #1 0x00007f6d4005afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:20.955] No symbol table info available. [03:12:20.955] #2 0x00007f6d40045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:20.955] No symbol table info available. [03:12:20.955] #3 0x00007f6d4021e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [03:12:20.955] No locals. [03:12:20.955] #4 0x00007f6d4022aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [03:12:20.955] No locals. [03:12:20.955] #5 0x00007f6d4020dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x5572c88cfb40, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [03:12:20.955] bp = 140732979716912 [03:12:20.955] pc = [03:12:20.955] Opts = {FromUnrecoverableHandler = true, pc = 93951465403635, bp = 93951508928584} [03:12:20.955] #6 0x00005572c7b8b4f3 in examine_self_contradictory_rels (root=root@entry=0x5572ca4629e8, rel=rel@entry=0x5572ca4d4b08, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [03:12:20.955] lc__state = [03:12:20.955] rlist = [03:12:20.955] i = 2 [03:12:20.955] br = [03:12:20.955] expression = [03:12:20.955] or_rinfo = 0x5572ca50e598 [03:12:20.955] ccxt = [03:12:20.955] delidx = 0x5572ca50e431 [03:12:20.955] arglst = [03:12:20.955] lc = [03:12:20.955] arg = [03:12:20.955] n = [03:12:20.955] restrictinfo = [03:12:20.955] ccwapper = {clausecxt = 0x5572ca50ddc8} [03:12:20.955] sec = {sopcinfo = {n_members = 38, opcies = 0x5572ca50d898}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x5572ca36ed48, atop_set = 0x5572ca50dca8}, ccfree = 0x5572ca50e400, vifree = 0x5572ca50df38} [03:12:20.955] __func__ = "examine_self_contradictory_rels" [03:12:20.955] #7 0x00005572c7b8b702 in examine_self_contradictory_rels_phase1 (root=root@entry=0x5572ca4629e8) at ../src/backend/optimizer/plan/contradictory.c:2608 [03:12:20.955] rel = 0x5572ca4d4b08 [03:12:20.955] rti = 1 [03:12:20.955] rinfo = [03:12:20.955] #8 0x00005572c7b55d44 in query_planner (root=root@entry=0x5572ca4629e8, qp_callback=qp_callback@entry=0x5572c7b5b061 , qp_extra=qp_extra@entry=0x7ffef343a530) at ../src/backend/optimizer/plan/planmain.c:190 [03:12:20.955] parse = 0x5572ca203d18 [03:12:20.955] joinlist = 0x5572ca36edb8 [03:12:20.955] final_rel = [03:12:20.955] __func__ = "query_planner" [03:12:20.955] #9 0x00005572c7b69137 in grouping_planner (root=root@entry=0x5572ca4629e8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [03:12:20.955] sort_input_targets = 0x5 [03:12:20.955] sort_input_target_parallel_safe = [03:12:20.955] grouping_target = [03:12:20.955] scanjoin_target = [03:12:20.955] activeWindows = 0x0 [03:12:20.955] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [03:12:20.955] sort_input_targets_contain_srfs = 0x1 [03:12:20.955] have_grouping = [03:12:20.955] wflists = 0x0 [03:12:20.955] gset_data = 0x0 [03:12:20.955] sort_input_target = [03:12:20.955] grouping_targets = 0x1 [03:12:20.955] grouping_target_parallel_safe = [03:12:20.955] scanjoin_targets = 0x0 [03:12:20.955] scanjoin_target_parallel_safe = [03:12:20.955] grouping_targets_contain_srfs = 0x1 [03:12:20.955] scanjoin_targets_contain_srfs = 0x5572c80cd5ca [03:12:20.955] scanjoin_target_same_exprs = [03:12:20.955] parse = 0x5572ca203d18 [03:12:20.955] offset_est = 0 [03:12:20.955] count_est = 0 [03:12:20.955] limit_tuples = -1 [03:12:20.955] have_postponed_srfs = false [03:12:20.955] final_target = [03:12:20.955] final_targets = 0x5572ca304ac8 [03:12:20.955] final_targets_contain_srfs = 0x5572c7ac778f [03:12:20.955] final_target_parallel_safe = [03:12:20.955] current_rel = [03:12:20.955] final_rel = [03:12:20.955] extra = {limit_needed = false, limit_tuples = 4.6418191024412149e-310, count_est = 93951507228696, offset_est = 93951507228696} [03:12:20.955] lc = [03:12:20.955] __func__ = "grouping_planner" [03:12:20.955] #10 0x00005572c7b6c0bb in subquery_planner (glob=glob@entry=0x5572ca4d49f8, parse=parse@entry=0x5572ca203d18, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1153 [03:12:20.955] root = 0x5572ca4629e8 [03:12:20.955] newWithCheckOptions = [03:12:20.955] newHaving = 0x0 [03:12:20.955] hasOuterJoins = [03:12:20.955] hasResultRTEs = false [03:12:20.955] final_rel = [03:12:20.955] l = 0x0 [03:12:20.955] #11 0x00005572c7b6cd4c in standard_planner (parse=0x5572ca203d18, query_string=, cursorOptions=2048, boundParams=) at ../src/backend/optimizer/plan/planner.c:427 [03:12:20.955] result = [03:12:20.955] glob = 0x5572ca4d49f8 [03:12:20.955] tuple_fraction = 0 [03:12:20.955] root = [03:12:20.955] final_rel = [03:12:20.955] best_path = [03:12:20.955] top_plan = [03:12:20.955] lp = [03:12:20.955] lr = [03:12:20.955] #12 0x00005572c7b6ddb6 in planner (parse=parse@entry=0x5572ca203d18, query_string=query_string@entry=0x5572ca202a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:294 [03:12:20.955] result = [03:12:20.955] #13 0x00005572c7ddcdcc in pg_plan_query (querytree=querytree@entry=0x5572ca203d18, query_string=query_string@entry=0x5572ca202a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [03:12:20.955] plan = [03:12:20.955] #14 0x00005572c78e32ff in standard_ExplainOneQuery (query=0x5572ca203d18, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5572ca22e068, queryString=0x5572ca202a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:496 [03:12:20.955] plan = [03:12:20.955] planstart = [03:12:20.955] planduration = {ticks = 93951464579251} [03:12:20.955] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 93951470830272, shared_blks_dirtied = 4081297438, shared_blks_written = 3, local_blks_hit = 4294967296, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 93951505743128, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 93951470917066}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93951464576632}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 93951505743128}} [03:12:20.955] bufusage = {shared_blks_hit = 0, shared_blks_read = 93951467599350, shared_blks_dirtied = 73138998099971, shared_blks_written = 72057594037927936, local_blks_hit = 140107010822672, local_blks_read = 93951505744304, local_blks_dirtied = 93951505743128, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 93951470446059, shared_blk_read_time = {ticks = 140107010822672}, shared_blk_write_time = {ticks = 93951470446078}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 93951470825855}, temp_blk_read_time = {ticks = 93951505915168}, temp_blk_write_time = {ticks = 64}} [03:12:20.955] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140732979718048, freespace = 10} [03:12:20.955] planner_ctx = 0x0 [03:12:20.955] saved_ctx = 0x0 [03:12:20.955] #15 0x00005572c78e35e5 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x5572ca22e068, pstate=pstate@entry=0x5572ca22df58, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [03:12:20.955] No locals. [03:12:20.955] #16 0x00005572c78e44e5 in ExplainQuery (pstate=pstate@entry=0x5572ca22df58, stmt=stmt@entry=0x5572ca203b58, params=params@entry=0x0, dest=dest@entry=0x5572ca22dec8) at ../src/backend/commands/explain.c:350 [03:12:20.955] l__state = [03:12:20.955] l = 0x5572ca4d49c0 [03:12:20.955] es = 0x5572ca22e068 [03:12:20.955] tstate = [03:12:20.955] jstate = [03:12:20.955] query = [03:12:20.955] rewritten = 0x5572ca4d49a8 [03:12:20.955] lc = 0x0 [03:12:20.955] timing_set = false [03:12:20.955] summary_set = false [03:12:20.955] __func__ = "ExplainQuery" [03:12:20.955] #17 0x00005572c7de79b3 in standard_ProcessUtility (pstmt=0x5572ca203c08, queryString=0x5572ca202a70 "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=0x5572ca22dec8, qc=0x7ffef343aa20) at ../src/backend/tcop/utility.c:866 [03:12:20.955] parsetree = 0x5572ca203b58 [03:12:20.955] isTopLevel = true [03:12:20.955] isAtomicContext = false [03:12:20.955] pstate = 0x5572ca22df58 [03:12:20.955] readonly_flags = [03:12:20.955] __func__ = "standard_ProcessUtility" [03:12:20.955] #18 0x00005572c7de80dc in ProcessUtility (pstmt=pstmt@entry=0x5572ca203c08, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x5572ca22dec8, qc=0x7ffef343aa20) at ../src/backend/tcop/utility.c:523 [03:12:20.955] No locals. [03:12:20.955] #19 0x00005572c7de3948 in PortalRunUtility (portal=portal@entry=0x5572ca2847e0, pstmt=0x5572ca203c08, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x5572ca22dec8, qc=qc@entry=0x7ffef343aa20) at ../src/backend/tcop/pquery.c:1158 [03:12:20.955] No locals. [03:12:20.955] #20 0x00005572c7de41bb in FillPortalStore (portal=portal@entry=0x5572ca2847e0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [03:12:20.955] treceiver = 0x5572ca22dec8 [03:12:20.955] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:12:20.955] __func__ = "FillPortalStore" [03:12:20.955] #21 0x00005572c7de47af in PortalRun (portal=portal@entry=0x5572ca2847e0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x5572ca304ed8, altdest=altdest@entry=0x5572ca304ed8, qc=0x7ffef343ac00) at ../src/backend/tcop/pquery.c:763 [03:12:20.955] _save_exception_stack = 0x7ffef343acb0 [03:12:20.955] _save_context_stack = 0x0 [03:12:20.955] _local_sigjmp_buf = {{__jmpbuf = {0, -816239706884345124, 93951506270176, 93951505742800, 93951506270176, 93951505742728, -6794717253657496868, -816214125952044324}, __mask_was_saved = 0, __saved_mask = {__val = {93951470825855, 93951505738096, 112, 4, 93951470830272, 4081298319, 4, 93951505742728, 112, 153, 93951506270176, 93951505742800, 93951505742776, 93951505742728, 93951470917475, 1}}}} [03:12:20.955] _do_rethrow = [03:12:20.955] result = [03:12:20.955] nprocessed = [03:12:20.955] saveTopTransactionResourceOwner = 0x5572ca241998 [03:12:20.955] saveTopTransactionContext = 0x5572ca298c50 [03:12:20.955] saveActivePortal = 0x0 [03:12:20.955] saveResourceOwner = 0x5572ca241998 [03:12:20.955] savePortalContext = 0x0 [03:12:20.955] saveMemoryContext = 0x5572ca298c50 [03:12:20.955] __func__ = "PortalRun" [03:12:20.955] #22 0x00005572c7ddd8a2 in exec_simple_query (query_string=query_string@entry=0x5572ca202a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1283 [03:12:20.955] cmdtaglen = 7 [03:12:20.955] snapshot_set = [03:12:20.955] per_parsetree_context = 0x0 [03:12:20.955] plantree_list = 0x5572ca304e88 [03:12:20.955] parsetree = 0x5572ca203b88 [03:12:20.955] commandTag = [03:12:20.955] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:12:20.955] querytree_list = [03:12:20.955] portal = 0x5572ca2847e0 [03:12:20.955] receiver = 0x5572ca304ed8 [03:12:20.955] format = 0 [03:12:20.955] cmdtagname = [03:12:20.955] parsetree_item__state = [03:12:20.955] dest = DestRemote [03:12:20.955] oldcontext = 0x5572ca298c50 [03:12:20.955] parsetree_list = 0x5572ca203bb8 [03:12:20.955] parsetree_item = 0x5572ca203bd0 [03:12:20.955] save_log_statement_stats = false [03:12:20.955] was_logged = true [03:12:20.955] use_implicit_block = false [03:12:20.955] msec_str = "\004\000\000\000\000\000\000\000N\237\t\310rU\000\000\220\254C\363\376\177\000\000n\000\000\000\000\000\000" [03:12:20.955] __func__ = "exec_simple_query" [03:12:20.955] #23 0x00005572c7de0626 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4809 [03:12:20.955] query_string = 0x5572ca202a70 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [03:12:20.955] firstchar = [03:12:20.955] input_message = {data = 0x5572ca202a70 "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} [03:12:20.955] local_sigjmp_buf = {{__jmpbuf = {93951483501880, -816233767463619876, 140732979719692, 4, 17, 140732979719924, -6794717253451975972, -816214121253506340}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93951505468912, 14336, 93951483495968, 93951505992016, 17, 93951470829820, 0, 9, 2, 93951483501888, 93951505468912, 93951483495968, 4, 17, 140732979719924}}}} [03:12:20.955] send_ready_for_query = false [03:12:20.955] idle_in_transaction_timeout_enabled = false [03:12:20.955] idle_session_timeout_enabled = false [03:12:20.955] __func__ = "PostgresMain" [03:12:20.955] #24 0x00005572c7dd6489 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:12:20.955] bsdata = [03:12:20.955] #25 0x00005572c7c880e6 in postmaster_child_launch (child_type=B_BACKEND, child_slot=17, startup_data=startup_data@entry=0x7ffef343ae0c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffef343ae60) at ../src/backend/postmaster/launch_backend.c:274 [03:12:20.955] pid = [03:12:20.955] #26 0x00005572c7c8d0e1 in BackendStartup (client_sock=client_sock@entry=0x7ffef343ae60) at ../src/backend/postmaster/postmaster.c:3377 [03:12:20.955] bn = 0x5572ca22a5b8 [03:12:20.955] pid = [03:12:20.955] startup_data = {canAcceptConnections = CAC_OK} [03:12:20.955] cac = [03:12:20.955] __func__ = "BackendStartup" [03:12:20.955] #27 0x00005572c7c8efba in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [03:12:20.955] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "C\363\376\177\000\000\364\256C\363\376\177", '\000' , "\272\023\342\306rU\000\000\200\367\335\306rU\000\000\300\257C\363\376\177\000\000\270\257C\363\376\177\000\000\225[\362\001\000\000\000\000\240\304RAm\177\000\000+", '\000' , "\310\022\342\306rU\000\000h\346\234Am\177\000\0000\306RAm\177\000", __ss_align = 140107228963552}, salen = 2}} [03:12:20.955] i = 0 [03:12:20.955] now = [03:12:20.955] last_lockfile_recheck_time = 1733281689 [03:12:20.955] last_touch_time = 1733281689 [03:12:20.955] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -958262342, events = 21874, fd = 1100801640, user_data = 0x7f6d4152c630}, {pos = 1100800736, events = 32621, fd = 2090263927, user_data = 0x7ffef343b040}, {pos = 1100630600, events = 32621, fd = 15, user_data = 0x7f6d4152c630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1100800736, events = 32621, fd = -213667912, user_data = 0x7ffef343afc0}, {pos = 1100801640, events = 32621, fd = 0, user_data = 0x5572ca202a88}, {pos = -938451571, events = 21874, fd = 32768, user_data = 0x1}, {pos = -903854304, events = 21874, fd = -1, user_data = 0x7f6d4002e020}, {pos = 1096572832, events = 32621, fd = -903684024, user_data = 0x5572ca22df28}, {pos = -903686927, events = 21874, fd = 1100656318, user_data = 0x1}, {pos = 1100800736, events = 32621, fd = 427, user_data = 0x5572c8618d58 }, {pos = 0, events = 0, fd = 216, user_data = 0x5572ca202a88}, {pos = 1100656318, events = 32621, fd = 1, user_data = 0x0}, {pos = 1073930272, events = 32621, fd = 1074736704, user_data = 0x10}, {pos = -213666784, events = 32766, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1100665274, user_data = 0x0}, {pos = 1074458020, events = 32621, fd = 0, user_data = 0x5572c8cbe100 }, {pos = 2, events = 0, fd = 0, user_data = 0x5572ca1c4e90}, {pos = -942210168, events = 21874, fd = -903653301, user_data = 0x5572c7d73fc1 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x5572ca202a88}, {pos = 1100656318, events = 32621, fd = 1, user_data = 0x0}, {pos = 1073964232, events = 32621, fd = 1074382976, user_data = 0x42d}, {pos = 1074491143, events = 32621, fd = 2, user_data = 0x1030}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 1075780704, events = 32621, 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 = -938774145, events = 21874, fd = -903671888, user_data = 0x7f6d400b58be}, {pos = 1075763680, events = 32621, fd = 1074401646, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0xeafab3ffa364f000}, {pos = 1075766752, events = 32621, 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 = -903684632, user_data = 0x3}, {pos = 0, events = 0, fd = 21480, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = -903861624, user_data = 0x7f6d400f3053 }, {pos = -903684632, events = 21874, fd = 1024, user_data = 0x7ffef343b4e8}, {pos = -938690829, events = 21874, fd = -926098192, user_data = 0x5572c80ba1b0 }, {pos = -903684832, events = 21874, fd = -903861904, user_data = 0x5572ca22dd20}, {pos = 1074485099, events = 32621, fd = 0, user_data = 0x5572c80cbe1a }, {pos = -903684832, events = 1, fd = -938688669, user_data = 0x5572ca202970}, {pos = -1553666048, events = 3942298623, fd = 0, user_data = 0x7f6d400a2ab1}, {pos = 1074402544, events = 32621, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -904114544, user_data = 0xeafab3ffa364f000}, {pos = 0, events = 0, fd = -1553666048, user_data = 0xc}, {pos = -1553666048, events = 3942298623, fd = 0, user_data = 0x7f6d4005b239 }, {pos = 217, events = 0, fd = -943161885, user_data = 0x400000}, {pos = 0, events = 0, fd = -904114544, user_data = 0x5572c80ba044 }, {pos = -904028000, events = 21874, fd = -903861904, user_data = 0x5572ca1da0a0}, {pos = 1, events = 0, fd = 0, user_data = 0x5572c8078a41 }, {pos = 12, events = 0, fd = -903689384, user_data = 0x5572ca22cb38}, {pos = -926161280, events = 21874, fd = 296, user_data = 0x5572c7c8a5fd }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = -943145414, events = 21874, fd = -929732560, user_data = 0x5572ca203318}} [03:12:20.955] nevents = 1 [03:12:20.955] __func__ = "ServerLoop" [03:12:20.955] #28 0x00005572c7c907dd in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x5572ca1c0d00) at ../src/backend/postmaster/postmaster.c:1361 [03:12:20.955] opt = [03:12:20.955] status = [03:12:20.955] userDoption = [03:12:20.955] listen_addr_saved = false [03:12:20.955] output_config_variable = [03:12:20.955] __func__ = "PostmasterMain" [03:12:20.955] #29 0x00005572c7abd881 in main (argc=4, argv=0x5572ca1c0d00) at ../src/backend/main/main.c:196 [03:12:20.955] do_check_root = [03:12:20.994] -e [03:12:20.994] [03:12:20.994] [03:12:21.087] dumping /tmp/cores/postgres-6-29081.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:12:21.364] [New LWP 29081] [03:12:21.364] [03:12:21.364] This GDB supports auto-downloading debuginfo from the following URLs: [03:12:21.364] [03:12:21.364] Enable debuginfod for this session? (y or [n]) [answered N; input not from terminal] [03:12:21.364] Debuginfod has been disabled. [03:12:21.364] To make this setting permanent, add 'set debuginfod enabled off' to .gdbinit. [03:12:21.623] [Thread debugging using libthread_db enabled] [03:12:21.623] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [03:12:21.623] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN '. [03:12:21.623] Program terminated with signal SIGABRT, Aborted. [03:12:21.623] #0 0x00007f08620a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:22.702] [03:12:22.702] Thread 1 (Thread 0x7f085fc21f00 (LWP 29081)): [03:12:22.702] #0 0x00007f08620a9ebc in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:22.702] No symbol table info available. [03:12:22.702] #1 0x00007f086205afb2 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:22.702] No symbol table info available. [03:12:22.702] #2 0x00007f0862045472 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [03:12:22.702] No symbol table info available. [03:12:22.702] #3 0x00007f086221e84f in __sanitizer::Abort () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_posix_libcdep.cpp:143 [03:12:22.702] No locals. [03:12:22.702] #4 0x00007f086222aee1 in __sanitizer::Die () at ../../../../src/libsanitizer/sanitizer_common/sanitizer_termination.cpp:58 [03:12:22.702] No locals. [03:12:22.702] #5 0x00007f086220dd58 in __ubsan::__ubsan_handle_load_invalid_value_abort (Data=Data@entry=0x55d50dd47b40, Val=) at ../../../../src/libsanitizer/ubsan/ubsan_handlers.cpp:551 [03:12:22.702] bp = 140723520637024 [03:12:22.702] pc = [03:12:22.702] Opts = {FromUnrecoverableHandler = true, pc = 94373534512371, bp = 94373583012328} [03:12:22.702] #6 0x000055d50d0034f3 in examine_self_contradictory_rels (root=root@entry=0x55d50fcef0a8, rel=rel@entry=0x55d50fd864e8, deduct=deduct@entry=true) at ../src/backend/optimizer/plan/contradictory.c:2566 [03:12:22.702] lc__state = [03:12:22.702] rlist = [03:12:22.702] i = 2 [03:12:22.702] br = [03:12:22.702] expression = [03:12:22.702] or_rinfo = 0x55d50fe44f38 [03:12:22.702] ccxt = [03:12:22.702] delidx = 0x55d50fe44dd1 [03:12:22.702] arglst = [03:12:22.702] lc = [03:12:22.702] arg = [03:12:22.702] n = [03:12:22.702] restrictinfo = [03:12:22.702] ccwapper = {clausecxt = 0x55d50fe44768} [03:12:22.702] sec = {sopcinfo = {n_members = 38, opcies = 0x55d50fe44238}, attrsdc = {min_attr = -6, max_attr = 1, len_set = 1, atop_array = 0x55d50fe438d8, atop_set = 0x55d50fe44648}, ccfree = 0x55d50fe44da0, vifree = 0x55d50fe448d8} [03:12:22.702] __func__ = "examine_self_contradictory_rels" [03:12:22.702] #7 0x000055d50d003702 in examine_self_contradictory_rels_phase1 (root=root@entry=0x55d50fcef0a8) at ../src/backend/optimizer/plan/contradictory.c:2608 [03:12:22.702] rel = 0x55d50fd864e8 [03:12:22.702] rti = 1 [03:12:22.702] rinfo = [03:12:22.702] #8 0x000055d50cfcdd44 in query_planner (root=root@entry=0x55d50fcef0a8, qp_callback=qp_callback@entry=0x55d50cfd3061 , qp_extra=qp_extra@entry=0x7ffcbf758a60) at ../src/backend/optimizer/plan/planmain.c:190 [03:12:22.702] parse = 0x55d50faddd38 [03:12:22.702] joinlist = 0x55d50fe43948 [03:12:22.702] final_rel = [03:12:22.702] __func__ = "query_planner" [03:12:22.702] #9 0x000055d50cfe1137 in grouping_planner (root=root@entry=0x55d50fcef0a8, tuple_fraction=, tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1584 [03:12:22.702] sort_input_targets = 0x5 [03:12:22.702] sort_input_target_parallel_safe = [03:12:22.702] grouping_target = [03:12:22.702] scanjoin_target = [03:12:22.702] activeWindows = 0x0 [03:12:22.702] qp_extra = {activeWindows = 0x0, gset_data = 0x0, setop = 0x0} [03:12:22.702] sort_input_targets_contain_srfs = 0x1 [03:12:22.702] have_grouping = [03:12:22.702] wflists = 0x0 [03:12:22.702] gset_data = 0x0 [03:12:22.702] sort_input_target = [03:12:22.702] grouping_targets = 0x1 [03:12:22.702] grouping_target_parallel_safe = [03:12:22.702] scanjoin_targets = 0x0 [03:12:22.702] scanjoin_target_parallel_safe = [03:12:22.702] grouping_targets_contain_srfs = 0x1 [03:12:22.702] scanjoin_targets_contain_srfs = 0x55d50d5455ca [03:12:22.702] scanjoin_target_same_exprs = [03:12:22.702] parse = 0x55d50faddd38 [03:12:22.702] offset_est = 0 [03:12:22.702] count_est = 0 [03:12:22.702] limit_tuples = -1 [03:12:22.702] have_postponed_srfs = false [03:12:22.702] final_target = [03:12:22.702] final_targets = 0x55d50fdf62e8 [03:12:22.702] final_targets_contain_srfs = 0x55d50cf3f78f [03:12:22.702] final_target_parallel_safe = [03:12:22.702] current_rel = [03:12:22.702] final_rel = [03:12:22.702] extra = {limit_needed = false, limit_tuples = 4.662672087120944e-310, count_est = 94373581618968, offset_est = 94373581618968} [03:12:22.702] lc = [03:12:22.702] __func__ = "grouping_planner" [03:12:22.702] #10 0x000055d50cfe40bb in subquery_planner (glob=glob@entry=0x55d50fd863d8, parse=parse@entry=0x55d50faddd38, parent_root=parent_root@entry=0x0, hasRecursion=hasRecursion@entry=false, tuple_fraction=tuple_fraction@entry=0, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:1153 [03:12:22.702] root = 0x55d50fcef0a8 [03:12:22.702] newWithCheckOptions = [03:12:22.702] newHaving = 0x0 [03:12:22.702] hasOuterJoins = [03:12:22.702] hasResultRTEs = false [03:12:22.702] final_rel = [03:12:22.702] l = 0x0 [03:12:22.702] #11 0x000055d50cfe4d4c in standard_planner (parse=parse@entry=0x55d50faddd38, query_string=query_string@entry=0x55d50fadca90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:427 [03:12:22.702] result = [03:12:22.702] glob = 0x55d50fd863d8 [03:12:22.702] tuple_fraction = 0 [03:12:22.702] root = [03:12:22.702] final_rel = [03:12:22.702] best_path = [03:12:22.702] top_plan = [03:12:22.702] lp = [03:12:22.702] lr = [03:12:22.702] #12 0x00007f085f7da5b0 in pgss_planner (parse=0x55d50faddd38, query_string=0x55d50fadca90 "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 [03:12:22.702] _save_exception_stack = 0x7ffcbf7593e0 [03:12:22.702] _save_context_stack = 0x0 [03:12:22.702] _local_sigjmp_buf = {{__jmpbuf = {94373579447608, 9173988919746017052, 0, 2048, 94373579447608, 2048, 3099584720421566236, 3092336810031888156}, __mask_was_saved = 0, __saved_mask = {__val = {94373579941912, 94373579939968, 94373539424582, 0, 17005, 0, 0, 0, 282385027144, 17005, 0, 139673908115568, 139673908115504, 0, 0, 140723520731564}}}} [03:12:22.702] _do_rethrow = false [03:12:22.702] result = 0x55d50fdf6f20 [03:12:22.702] #13 0x000055d50cfe5dac in planner (parse=parse@entry=0x55d50faddd38, query_string=query_string@entry=0x55d50fadca90 "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 [03:12:22.702] result = [03:12:22.702] #14 0x000055d50d254dcc in pg_plan_query (querytree=querytree@entry=0x55d50faddd38, query_string=query_string@entry=0x55d50fadca90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:911 [03:12:22.702] plan = [03:12:22.702] #15 0x000055d50cd5b2ff in standard_ExplainOneQuery (query=0x55d50faddd38, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55d50fb0d6b8, queryString=0x55d50fadca90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';", params=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:496 [03:12:22.702] plan = [03:12:22.702] planstart = [03:12:22.702] planduration = {ticks = 94373533687987} [03:12:22.702] bufusage_start = {shared_blks_hit = 3, shared_blks_read = 94373539939008, shared_blks_dirtied = 3212152974, shared_blks_written = 3, local_blks_hit = 4560292136, local_blks_read = 1, local_blks_dirtied = 5, local_blks_written = 1, temp_blks_read = 0, temp_blks_written = 94373579447608, shared_blk_read_time = {ticks = 6128932974754435668}, shared_blk_write_time = {ticks = 94373540025802}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94373533685368}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94373579447608}} [03:12:22.702] bufusage = {shared_blks_hit = 0, shared_blks_read = 94373536708086, shared_blks_dirtied = 73035918884864, shared_blks_written = 72057594037927936, local_blks_hit = 139673908105744, local_blks_read = 94373579448784, local_blks_dirtied = 94373579447608, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 94373539554795, shared_blk_read_time = {ticks = 139673908105744}, shared_blk_write_time = {ticks = 94373539554814}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 94373539934591}, temp_blk_read_time = {ticks = 94373579641712}, temp_blk_write_time = {ticks = 64}} [03:12:22.702] mem_counters = {nblocks = 0, freechunks = 4294967297, totalspace = 140723520638992, freespace = 10} [03:12:22.702] planner_ctx = 0x0 [03:12:22.702] saved_ctx = 0x0 [03:12:22.702] #16 0x000055d50cd5b5e5 in ExplainOneQuery (query=, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x55d50fb0d6b8, pstate=pstate@entry=0x55d50fb0d5a8, params=params@entry=0x0) at ../src/backend/commands/explain.c:452 [03:12:22.702] No locals. [03:12:22.702] #17 0x000055d50cd5c4e5 in ExplainQuery (pstate=pstate@entry=0x55d50fb0d5a8, stmt=stmt@entry=0x55d50faddb78, params=params@entry=0x0, dest=dest@entry=0x55d50fb0d518) at ../src/backend/commands/explain.c:350 [03:12:22.702] l__state = [03:12:22.702] l = 0x55d50fd863a0 [03:12:22.702] es = 0x55d50fb0d6b8 [03:12:22.702] tstate = [03:12:22.702] jstate = [03:12:22.702] query = [03:12:22.702] rewritten = 0x55d50fd86388 [03:12:22.702] lc = 0x0 [03:12:22.702] timing_set = false [03:12:22.702] summary_set = false [03:12:22.702] __func__ = "ExplainQuery" [03:12:22.702] #18 0x000055d50d25f9b3 in standard_ProcessUtility (pstmt=pstmt@entry=0x55d50faddc28, queryString=queryString@entry=0x55d50fadca90 "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=0x55d50fb0d518, qc=0x7ffcbf759620) at ../src/backend/tcop/utility.c:866 [03:12:22.702] parsetree = 0x55d50faddb78 [03:12:22.702] isTopLevel = true [03:12:22.702] isAtomicContext = false [03:12:22.702] pstate = 0x55d50fb0d5a8 [03:12:22.702] readonly_flags = [03:12:22.702] __func__ = "standard_ProcessUtility" [03:12:22.702] #19 0x00007f085f7d9d9d in pgss_ProcessUtility (pstmt=0x55d50faddc28, queryString=0x55d50fadca90 "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=0x55d50fb0d518, qc=0x7ffcbf759620) at ../contrib/pg_stat_statements/pg_stat_statements.c:1171 [03:12:22.702] _save_exception_stack = 0x7ffcbf7596c0 [03:12:22.702] _save_context_stack = 0x0 [03:12:22.702] _local_sigjmp_buf = {{__jmpbuf = {0, -3100005918738958564, 94373579447336, 94373579642136, 140723520640544, 1, 3099584721421907740, 3092336808993011484}, __mask_was_saved = 0, __saved_mask = {__val = {94373539939008, 266298968, 0, 94373582695784, 94373539934591, 94373579442576, 11, 1, 94373539939008, 266300088, 1, 94373579442576, 10, 94373582695368, 139673981382765, 1}}}} [03:12:22.702] _do_rethrow = false [03:12:22.702] duration = [03:12:22.702] bufusage = {shared_blks_hit = 94373579449336, shared_blks_read = 140723520640336, shared_blks_dirtied = 140723520640336, shared_blks_written = 0, local_blks_hit = 0, local_blks_read = 94373540026211, local_blks_dirtied = 0, local_blks_written = 94373579449336, temp_blks_read = 94373582693224, temp_blks_written = 94373582693224, shared_blk_read_time = {ticks = 94373582693144}, shared_blk_write_time = {ticks = 140723520640336}, local_blk_read_time = {ticks = 140723520640336}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 94373534959495}} [03:12:22.702] walusage_start = {wal_records = 71, wal_fpi = 15, wal_bytes = 88474} [03:12:22.702] start = [03:12:22.702] rows = [03:12:22.702] bufusage_start = {shared_blks_hit = 1530, shared_blks_read = 289, shared_blks_dirtied = 22, shared_blks_written = 20, 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}} [03:12:22.702] walusage = {wal_records = 1, wal_fpi = 94373539417843, wal_bytes = 1} [03:12:22.702] parsetree = [03:12:22.702] saved_queryId = 13670714458196949111 [03:12:22.702] saved_stmt_location = 0 [03:12:22.702] saved_stmt_len = 108 [03:12:22.702] enabled = true [03:12:22.702] #20 0x000055d50d260027 in ProcessUtility (pstmt=pstmt@entry=0x55d50faddc28, queryString=, readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=, queryEnv=, dest=0x55d50fb0d518, qc=0x7ffcbf759620) at ../src/backend/tcop/utility.c:519 [03:12:22.702] No locals. [03:12:22.702] #21 0x000055d50d25b948 in PortalRunUtility (portal=portal@entry=0x55d50fb60000, pstmt=0x55d50faddc28, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55d50fb0d518, qc=qc@entry=0x7ffcbf759620) at ../src/backend/tcop/pquery.c:1158 [03:12:22.702] No locals. [03:12:22.702] #22 0x000055d50d25c1bb in FillPortalStore (portal=portal@entry=0x55d50fb60000, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1031 [03:12:22.702] treceiver = 0x55d50fb0d518 [03:12:22.702] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:12:22.702] __func__ = "FillPortalStore" [03:12:22.702] #23 0x000055d50d25c7af in PortalRun (portal=portal@entry=0x55d50fb60000, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55d50fdf7438, altdest=altdest@entry=0x55d50fdf7438, qc=0x7ffcbf759800) at ../src/backend/tcop/pquery.c:763 [03:12:22.702] _save_exception_stack = 0x7ffcbf7598b0 [03:12:22.702] _save_context_stack = 0x0 [03:12:22.702] _local_sigjmp_buf = {{__jmpbuf = {0, 9173989346637035292, 94373579980800, 94373579447280, 94373579980800, 94373579447208, 3099584721283495708, 9173985552715396892}, __mask_was_saved = 0, __saved_mask = {__val = {94373539934591, 94373579442576, 112, 4, 94373539939008, 3212154767, 4, 94373579447208, 112, 153, 94373579980800, 94373579447280, 94373579447256, 94373579447208, 94373540026211, 1}}}} [03:12:22.702] _do_rethrow = [03:12:22.702] result = [03:12:22.702] nprocessed = [03:12:22.702] saveTopTransactionResourceOwner = 0x55d50fb1f4d8 [03:12:22.702] saveTopTransactionContext = 0x55d50fb72020 [03:12:22.702] saveActivePortal = 0x0 [03:12:22.702] saveResourceOwner = 0x55d50fb1f4d8 [03:12:22.702] savePortalContext = 0x0 [03:12:22.702] saveMemoryContext = 0x55d50fb72020 [03:12:22.702] __func__ = "PortalRun" [03:12:22.702] #24 0x000055d50d2558a2 in exec_simple_query (query_string=query_string@entry=0x55d50fadca90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';") at ../src/backend/tcop/postgres.c:1283 [03:12:22.702] cmdtaglen = 7 [03:12:22.702] snapshot_set = [03:12:22.702] per_parsetree_context = 0x0 [03:12:22.702] plantree_list = 0x55d50fdf73e8 [03:12:22.702] parsetree = 0x55d50faddba8 [03:12:22.702] commandTag = [03:12:22.702] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:12:22.702] querytree_list = [03:12:22.702] portal = 0x55d50fb60000 [03:12:22.702] receiver = 0x55d50fdf7438 [03:12:22.702] format = 0 [03:12:22.702] cmdtagname = [03:12:22.702] parsetree_item__state = [03:12:22.702] dest = DestRemote [03:12:22.702] oldcontext = 0x55d50fb72020 [03:12:22.702] parsetree_list = 0x55d50faddbd8 [03:12:22.702] parsetree_item = 0x55d50faddbf0 [03:12:22.702] save_log_statement_stats = false [03:12:22.702] was_logged = true [03:12:22.702] use_implicit_block = false [03:12:22.702] msec_str = "\004\000\000\000\000\000\000\000N\037Q\r\325U\000\000\220\230u\277\374\177\000\000n\000\000\000\000\000\000" [03:12:22.702] __func__ = "exec_simple_query" [03:12:22.702] #25 0x000055d50d258626 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4809 [03:12:22.702] query_string = 0x55d50fadca90 "explain (costs off)\nselect count(*) from date_tbl\n where f1 between symmetric '1997-01-01' and '1998-01-01';" [03:12:22.702] firstchar = [03:12:22.702] input_message = {data = 0x55d50fadca90 "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} [03:12:22.702] local_sigjmp_buf = {{__jmpbuf = {94373552610616, 9173987618683402012, 140723520641548, 4, 3, 140723520641780, 3099584721077974812, 9173985549689861916}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 6016, 10, 94373579700656, 0, 168, 94373539939110, 0, 10, 2, 94373552610624, 94373579173424, 94373552604704, 4, 3, 140723520641780}}}} [03:12:22.702] send_ready_for_query = false [03:12:22.702] idle_in_transaction_timeout_enabled = false [03:12:22.702] idle_session_timeout_enabled = false [03:12:22.702] __func__ = "PostgresMain" [03:12:22.702] #26 0x000055d50d24e489 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [03:12:22.702] bsdata = [03:12:22.702] #27 0x000055d50d1000e6 in postmaster_child_launch (child_type=B_BACKEND, child_slot=3, startup_data=startup_data@entry=0x7ffcbf759a0c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffcbf759a60) at ../src/backend/postmaster/launch_backend.c:274 [03:12:22.702] pid = [03:12:22.702] #28 0x000055d50d1050e1 in BackendStartup (client_sock=client_sock@entry=0x7ffcbf759a60) at ../src/backend/postmaster/postmaster.c:3377 [03:12:22.702] bn = 0x55d50fb09158 [03:12:22.702] pid = [03:12:22.702] startup_data = {canAcceptConnections = CAC_OK} [03:12:22.702] cac = [03:12:22.702] __func__ = "BackendStartup" [03:12:22.702] #29 0x000055d50d106fba in ServerLoop () at ../src/backend/postmaster/postmaster.c:1663 [03:12:22.702] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "u\277\374\177\000\000\364\232u\277\374\177", '\000' , "\272\223)\f\325U\000\000\200w%\f\325U\000\000\300\233u\277\374\177\000\000\270\233u\277\374\177\000\000\225[\362\001\000\000\000\000\260j\260\017\325U\000\000,", '\000' , "Ȓ)\f\325U\000\000h\006\236c\b\177\000\0000\206\375a\b\177\000", __ss_align = 139674007765728}, salen = 2}} [03:12:22.702] i = 0 [03:12:22.702] now = [03:12:22.702] last_lockfile_recheck_time = 1733281715 [03:12:22.702] last_touch_time = 1733281715 [03:12:22.702] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 204051386, events = 21973, fd = 1671300712, user_data = 0x7f0861fd8630}, {pos = 1671299808, events = 32520, fd = 2090263927, user_data = 0x7ffcbf759c40}, {pos = 1671129672, events = 32520, fd = 15, user_data = 0x7f0861fd8630}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = 1671299808, events = 32520, fd = -1082811464, user_data = 0x7ffcbf759bc0}, {pos = 1671300712, events = 32520, fd = 0, user_data = 0x55d50fb0b108}, {pos = 223862157, events = 21973, fd = 32768, user_data = 0x1}, {pos = 263050672, events = 21973, fd = -1, user_data = 0x7f086202e020}, {pos = 1666379680, events = 32520, fd = 263247512, user_data = 0x55d50fb0d578}, {pos = 263270721, events = 21973, fd = 1671155390, user_data = 0x1}, {pos = 1671299808, events = 32520, fd = 427, user_data = 0x55d50da90d58 }, {pos = 0, events = 0, fd = 86, user_data = 0x55d50fb0b108}, {pos = 1671155390, events = 32520, fd = 1, user_data = 0x0}, {pos = 1644355616, events = 32520, fd = 1645162048, user_data = 0x10}, {pos = -1082810336, events = 32764, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1671164346, user_data = 0x0}, {pos = 1644883364, events = 32520, fd = 0, user_data = 0x55d50e136100 }, {pos = 2, events = 0, fd = 0, user_data = 0x55d50fa9eed0}, {pos = 220103560, events = 21973, fd = 263264667, user_data = 0x55d50d1ebfc1 }, {pos = 1702060386, events = 1936158767, fd = 8096, user_data = 0x55d50fb0b108}, {pos = 1671155390, events = 32520, fd = 1, user_data = 0x0}, {pos = 1644389576, events = 32520, fd = 1644808320, user_data = 0x42d}, {pos = 1644916487, events = 32520, fd = 2, user_data = 0x810}, {pos = 255, events = 0, fd = 99, user_data = 0x0}, {pos = 1646206048, events = 32520, fd = 255, user_data = 0xfffffffffffffef0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, fd = 1652761920, user_data = 0x7f0862832a80}, {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 = 223539583, events = 21973, fd = 263276912, user_data = 0x7f08620b576b}, {pos = 1646189024, events = 32520, fd = 1644826990, user_data = 0x100000400}, {pos = 7, events = 0, fd = 0, user_data = 0x6785864b89462500}, {pos = 1646192096, events = 32520, 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 = 263246904, user_data = 0x3}, {pos = 0, events = 0, fd = 28058, user_data = 0xfffffffffffffeb8}, {pos = 0, events = 0, fd = 263237896, user_data = 0x7f08620f3053 }, {pos = 263246904, events = 21973, fd = 1024, user_data = 0x7ffcbf75a0e8}, {pos = 223622899, events = 21973, fd = 236215536, user_data = 0x55d50d5321b0 }, {pos = 263246704, events = 21973, fd = 263047568, user_data = 0x55d50fb0d370}, {pos = 1644910443, events = 32520, fd = 0, user_data = 0x55d50d543e1a }, {pos = 263246704, events = 1, fd = 223625059, user_data = 0x55d50fadc990}, {pos = -1991891712, events = 1736803915, fd = 0, user_data = 0x7f08620a2ab1}, {pos = 1644827888, events = 32520, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 262794960, user_data = 0x6785864b89462500}, {pos = 0, events = 0, fd = -1991891712, user_data = 0xc}, {pos = -1991891712, events = 1736803915, fd = 0, user_data = 0x7f086205b239 }, {pos = 87, events = 0, fd = 219151843, user_data = 0x400000}, {pos = 0, events = 0, fd = 262794960, user_data = 0x55d50d532044 }, {pos = 262881472, events = 21973, fd = 263047568, user_data = 0x55d50fab40c0}, {pos = 1, events = 0, fd = 0, user_data = 0x55d50d4f0a41 }, {pos = 12, events = 0, fd = 263233848, user_data = 0x55d50fb0a118}, {pos = 236152448, events = 21973, fd = 296, user_data = 0x55d50d1025fd }, {pos = 12, events = 0, fd = 0, user_data = 0x0}, {pos = 219168314, events = 21973, fd = 232581168, user_data = 0x55d50fadd348}} [03:12:22.702] nevents = 1 [03:12:22.702] __func__ = "ServerLoop" [03:12:22.702] #30 0x000055d50d1087dd in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55d50fa9ad30) at ../src/backend/postmaster/postmaster.c:1361 [03:12:22.702] opt = [03:12:22.702] status = [03:12:22.702] userDoption = [03:12:22.702] listen_addr_saved = false [03:12:22.702] output_config_variable = [03:12:22.702] __func__ = "PostmasterMain" [03:12:22.702] #31 0x000055d50cf35881 in main (argc=4, argv=0x55d50fa9ad30) at ../src/backend/main/main.c:196 [03:12:22.702] do_check_root =