[08:11:35.872] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [08:11:36.168] dumping /tmp/cores/postgres.41236.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:11:36.302] [New LWP 101866] [08:11:36.388] Core was generated by `postgres: cascading_standby: startup waiting for 000000020000000000000006'. [08:11:36.388] Program terminated with signal SIGQUIT, Quit. [08:11:36.388] Sent by thr_kill() from pid 41236 and user 1002. [08:11:36.388] #0 0x000000082c72875a in _sigprocmask () from /lib/libc.so.7 [08:11:36.432] [08:11:36.432] Thread 1 (LWP 101866): [08:11:36.432] #0 0x000000082c72875a in _sigprocmask () from /lib/libc.so.7 [08:11:36.432] No symbol table info available. [08:11:36.432] #1 0x000000082c765a7f in _system () from /lib/libc.so.7 [08:11:36.432] No symbol table info available. [08:11:36.432] #2 0x000000082cec28a3 in ?? () from /lib/libthr.so.3 [08:11:36.432] No symbol table info available. [08:11:36.432] #3 0x0000000000688d87 in RestoreArchivedFile (path=path@entry=0x8216cf1e0 "pg_wal/00000003.history", xlogfname=xlogfname@entry=0x8216cf630 "00000002", '0' , "6", recovername=, expectedSize=16777216, cleanupEnabled=) at ../src/backend/access/transam/xlogarchive.c:177 [08:11:36.432] xlogpath = "pg_wal/RECOVERYXLOG\000RY\000\000\0209p,\b\000\000\000\360\354l!\b\000\000\000`U\353,\b\000\000\000\260\224|,\b", '\000' , "`\355l!\b\000\000\000$:p,\b\000\000\000\260\224|,\b", '\000' , "\340\277p,\b", '\000' , "\b\000\000\000\260\361l!\b", '\000' , "\340\277p,\b", '\000' , "\231a\226\016\245Oc\230\020l.\ft,\000\000\001\000\000\000\000\000\000\000\200\355l!\b\000\000\000\032\002\224\000\000\000\000\000\260\343},\b\000\000\000"... [08:11:36.432] lastRestartPointFname = "00000001", '0' , "6\000\377\377\377\000\000\000\0008\360l!\b", '\000' , " \351l!\b\000\000\000槲", '\000' , "\245\244\262\000\000\000\000\0008\360l!\b\000\000\000\376\377\377\377\000\000\000\000\002", '\000' , "\245\244\262\000\000\000\000\000\240\357l!\b\000\000\000\373\377\377\377\000\000\000\000\005", '\000' , "\320\351l!\b\000\000\000\v\247\262", '\000' , "220\000\000\000\000\000\000\000\374`"... [08:11:36.432] stat_buf = {st_dev = 34920527328, st_ino = 34920527408, st_nlink = 12487584, st_mode = 2, st_padding0 = 0, st_uid = 0, st_gid = 560787920, st_padding1 = 8, st_rdev = 35104894487, st_atim = {tv_sec = 34920526184, tv_nsec = 12695328}, st_mtim = {tv_sec = 909127728, tv_nsec = 0}, st_ctim = {tv_sec = 3551280, tv_nsec = 3472328296227680304}, st_birthtim = {tv_sec = 11, tv_nsec = 2754025045574549505}, st_size = -7466036186917215847, st_blocks = 35106179856, st_blksize = 5, st_flags = 0, st_gen = 0, st_spare = {34920526224, 35105428254, 2, 35105297477, 0, 10980707886792335769, 34920526304, 12580592, 206158430240, 34920526304}} [08:11:36.432] restartRedoPtr = 100664848 [08:11:36.432] restartTli = 1 [08:11:36.432] restartSegNo = [08:11:36.432] xlogRestoreCmd = 0x2c740c38b1e8 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decoding/data/t_035_standby_logical_decoding_standby_data/archives/00000002", '0' , "6\" \"pg_wal/RECOVERYXLOG\"" [08:11:36.432] rc = [08:11:36.432] #4 0x0000000000694490 in XLogFileRead (segno=segno@entry=6, tli=tli@entry=2, source=source@entry=XLOG_FROM_ARCHIVE, notfoundOk=true) at ../src/backend/access/transam/xlogrecovery.c:4232 [08:11:36.432] xlogfname = "00000002", '0' , "6\000a\226\016\245Oc\230\000\000\000\000\000\000\000\000\220\366l!\b\000\000\000\200\366l!\b\000\000\000\2429r,\b\000\000" [08:11:36.432] activitymsg = "waiting for 00000002", '0' , "6\000,\000\000\230\017\000\000\000\000\000\000\220\366l!\b\000\000\000\003\000\000\000\000\000\000\000`\366l!\b\000\000\000U:r,\b\000\000" [08:11:36.432] path = "pg_wal/00000003.history\0000000006\000\000\000\000\000\000\000\000\000\220`\345\vt,\000\000\001\000\000\000\000\000\000\000\260\362l!\b\000\000\000\020\366l!\b\000\000\000``y,\b\000\000\000\231a\226\016\245Oc\230\200\t\000\ft,\000\000\000\000\000\000\000\000\000\000\220`\345\vt,\000\000\001\000\000\000\000\000\000\000\260\362l!\b\000\000\000\020\366l!\b\000\000\000\003fy,\b\000\000\000\300\362l!\b", '\000' , "\n", '\000' , "\330X\000\ft,\000\000\000\020\000\000\000\000\000\000h\366l!\b\000\000\000"... [08:11:36.432] fd = [08:11:36.432] #5 0x000000000069015c in XLogFileReadAnyTLI (segno=6, source=XLOG_FROM_ANY) at ../src/backend/access/transam/xlogrecovery.c:4360 [08:11:36.432] hent = [08:11:36.432] tli = 2 [08:11:36.432] cell__state = {l = 0x2c740c2b3580, i = 0} [08:11:36.432] path = "\030\250E\006\000\000\000\000\220`\345\vt,\000\000\000\000\n\000\000\000\000\000\020\313},\b\000\000\000\200b\345\vt,\000\000\000\000\000\000\000\000\000\000\200\367l!\b\000\000\000\032xv,\b\000\000\000h\006\000\006\000\000\000\000\270M1\ft,\000\000\006\000\000\000\000\000\000\000h\006\000\006", '\000' , "\006", '\000' , "\001\000\000\000\203|i\000\000\000\000\000\000\000\000\006\000\000\000\000\005\000\000\000\000\000\000\000<\006\240\ft,\000\000\203|i\000\000\000\000\000P\006\240\ft,\000\000\000\000\b\000\000\000\000\000<\006\240\ft,\000\000\0008m!\b\000\000\000P\006\240\ft,", '\000' ... [08:11:36.432] tles = 0x2c740c2b3580 [08:11:36.432] cell = [08:11:36.432] fd = [08:11:36.432] cell__state = [08:11:36.432] hent = [08:11:36.432] tli = [08:11:36.432] beginseg = [08:11:36.432] __error = [08:11:36.432] __error = [08:11:36.432] #6 WaitForWALToBecomeAvailable (RecPtr=105238424, tliRecPtr=105238400, replayTLI=2, replayLSN=105238400, randAccess=, fetching_ckpt=, nonblocking=) at ../src/backend/access/transam/xlogrecovery.c:3794 [08:11:36.432] startWalReceiver = [08:11:36.432] streaming_reply_sent = true [08:11:36.432] now = [08:11:36.432] startWalReceiver = [08:11:36.432] oldSource = [08:11:36.432] wait_time = [08:11:36.432] __error = [08:11:36.432] __error = [08:11:36.432] __error = [08:11:36.432] havedata = [08:11:36.432] ptr = [08:11:36.432] tli = [08:11:36.432] __error = [08:11:36.432] latestChunkStart = [08:11:36.432] __error = [08:11:36.432] #7 XLogPageRead (xlogreader=0x2c740c21d0a0, targetPagePtr=105234432, reqLen=3992, targetRecPtr=105238400, readBuf=0x2c740c314db8 "\030\321\005") at ../src/backend/access/transam/xlogrecovery.c:3364 [08:11:36.432] private = 0x2c740c21d080 [08:11:36.432] emode = 15 [08:11:36.432] targetSegNo = 6 [08:11:36.432] targetPageOff = 4571136 [08:11:36.432] io_start = [08:11:36.432] r = [08:11:36.432] #8 0x000000000069723a in ReadPageInternal (state=0x2c740c21d0a0, pageptr=pageptr@entry=105234432, reqLen=3992) at ../src/backend/access/transam/xlogreader.c:1071 [08:11:36.432] targetSegNo = 6 [08:11:36.432] targetPageOff = 4571136 [08:11:36.432] readLen = [08:11:36.432] hdr = [08:11:36.432] err = [08:11:36.432] #9 0x0000000000695feb in XLogDecodeNextRecord (state=0x2c740c21d0a0, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:598 [08:11:36.432] errormsg = 0xc1a558 "" [08:11:36.432] randAccess = [08:11:36.432] decoded = 0x0 [08:11:36.432] RecPtr = 105238400 [08:11:36.432] assembled = false [08:11:36.432] targetPagePtr = 105234432 [08:11:36.432] targetRecOff = 3968 [08:11:36.432] readOff = [08:11:36.432] pageHeaderSize = [08:11:36.432] record = [08:11:36.432] gotheader = [08:11:36.432] len = [08:11:36.432] total_len = [08:11:36.432] buffer = [08:11:36.432] gotlen = [08:11:36.432] pageHeader = [08:11:36.432] contdata = [08:11:36.432] save_copy = [08:11:36.432] #10 XLogReadAhead (state=0x2c740c21d0a0, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:984 [08:11:36.432] result = [08:11:36.432] #11 0x000000000068d6b8 in XLogPrefetcherNextBlock (pgsr_private=48876931374800, lsn=0x2c740c38aa58) at ../src/backend/access/transam/xlogprefetcher.c:490 [08:11:36.432] nonblocking = false [08:11:36.432] record = 0x0 [08:11:36.432] prefetcher = 0x2c740c21ded0 [08:11:36.432] reader = 0x2c740c21d0a0 [08:11:36.432] replaying_lsn = 105238352 [08:11:36.432] #12 0x000000000068d325 in lrq_prefetch (lrq=0x2c740c38a9d8) at ../src/backend/access/transam/xlogprefetcher.c:252 [08:11:36.432] No locals. [08:11:36.432] #13 lrq_complete_lsn (lrq=0x2c740c38a9d8, lsn=) at ../src/backend/access/transam/xlogprefetcher.c:290 [08:11:36.432] No locals. [08:11:36.432] #14 XLogPrefetcherReadRecord (prefetcher=prefetcher@entry=0x2c740c21ded0, errmsg=errmsg@entry=0x8216d3d60) at ../src/backend/access/transam/xlogprefetcher.c:1035 [08:11:36.432] replayed_up_to = [08:11:36.432] record = [08:11:36.432] #15 0x0000000000690eba in ReadRecord (xlogprefetcher=0x2c740c21ded0, emode=emode@entry=15, fetching_ckpt=false, replayTLI=replayTLI@entry=2) at ../src/backend/access/transam/xlogrecovery.c:3163 [08:11:36.432] errormsg = 0x0 [08:11:36.432] xlogreader = 0x2c740c21d0a0 [08:11:36.432] private = [08:11:36.432] record = [08:11:36.432] #16 0x00000000006917b9 in PerformWalRecovery () at ../src/backend/access/transam/xlogrecovery.c:1841 [08:11:36.432] ru0 = {tv = {tv_sec = 1756281861, tv_usec = 516044}, ru = {ru_utime = {tv_sec = 0, tv_usec = 0}, ru_stime = {tv_sec = 0, tv_usec = 1074}, ru_maxrss = 0, ru_ixrss = 0, ru_idrss = 0, ru_isrss = 0, ru_minflt = 158, ru_majflt = 0, ru_nswap = 0, ru_inblock = 0, ru_oublock = 0, ru_msgsnd = 0, ru_msgrcv = 0, ru_nsignals = 0, ru_nvcsw = 5, ru_nivcsw = 3}} [08:11:36.432] xtime = [08:11:36.432] reachedRecoveryTarget = false [08:11:36.432] replayTLI = 2 [08:11:36.432] record = [08:11:36.432] #17 0x0000000000681fe3 in StartupXLOG () at ../src/backend/access/transam/xlog.c:5874 [08:11:36.432] wasShutdown = false [08:11:36.432] haveTblspcMap = false [08:11:36.432] haveBackupLabel = true [08:11:36.432] timebuf = "2025-08-27 08:04:20 UTC\000YJHjeCAgk\n\n 256921 65551\n", '\000' [08:11:36.432] promoted = false [08:11:36.432] didCrash = [08:11:36.432] checkPoint = {redo = 100664848, ThisTimeLineID = 1, PrevTimeLineID = , fullPageWrites = true, wal_level = , nextXid = {value = }, nextOid = , nextMulti = , nextMultiOffset = , oldestXid = 746, oldestXidDB = , oldestMulti = , oldestMultiDB = , time = , oldestCommitTsXid = 0, newestCommitTsXid = 0, oldestActiveXid = 786} [08:11:36.432] oldestActiveXID = [08:11:36.432] performedWalRecovery = [08:11:36.432] endOfRecoveryInfo = [08:11:36.432] EndOfLog = [08:11:36.432] EndOfLogTLI = [08:11:36.432] abortedRecPtr = [08:11:36.432] missingContrecPtr = [08:11:36.432] newTLI = [08:11:36.432] Insert = [08:11:36.432] #18 0x00000000008c6c0b in StartupProcessMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/startup.c:258 [08:11:36.432] No locals. [08:11:36.432] #19 0x00000000008c063b in postmaster_child_launch (child_type=child_type@entry=B_STARTUP, child_slot=77, startup_data=startup_data@entry=0x0, startup_data_len=startup_data_len@entry=0, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:290 [08:11:36.432] pid = [08:11:36.432] #20 0x00000000008c3477 in StartChildProcess (type=type@entry=B_STARTUP) at ../src/backend/postmaster/postmaster.c:3983 [08:11:36.432] pmchild = 0x0 [08:11:36.432] pid = [08:11:36.432] #21 0x00000000008c2d87 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8216d8c38) at ../src/backend/postmaster/postmaster.c:1396 [08:11:36.432] userDoption = [08:11:36.432] listen_addr_saved = false [08:11:36.432] output_config_variable = [08:11:36.432] opt = [08:11:36.432] status = [08:11:36.432] #22 0x00000000007f5590 in main (argc=4, argv=0x8216d8c38) at ../src/backend/main/main.c:231 [08:11:36.432] do_check_root = [08:11:36.432] dispatch_option = DISPATCH_POSTMASTER [08:11:36.441] [08:11:36.441] [08:11:36.441] [08:11:36.500] dumping /tmp/cores/postgres.82082.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:11:36.628] [New LWP 101793] [08:11:36.695] Core was generated by `postgres: old_node: postgres regression [local] EXPLAIN'. [08:11:36.695] Program terminated with signal SIGABRT, Aborted. [08:11:36.695] Sent by thr_kill() from pid 82082 and user 1002. [08:11:36.695] #0 0x000000082de281ba in thr_kill () from /lib/libc.so.7 [08:11:36.767] [08:11:36.767] Thread 1 (LWP 101793): [08:11:36.767] #0 0x000000082de281ba in thr_kill () from /lib/libc.so.7 [08:11:36.767] No symbol table info available. [08:11:36.767] #1 0x000000082dda15d4 in raise () from /lib/libc.so.7 [08:11:36.767] No symbol table info available. [08:11:36.767] #2 0x000000082de54b59 in abort () from /lib/libc.so.7 [08:11:36.767] No symbol table info available. [08:11:36.767] #3 0x0000000000ad9bf5 in ExceptionalCondition (conditionName=0x3683e4 "n >= 0 && n < list->length", fileName=, lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [08:11:36.767] No locals. [08:11:36.767] #4 0x000000000085d696 in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [08:11:36.767] No locals. [08:11:36.767] #5 list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [08:11:36.767] No locals. [08:11:36.767] #6 0x000000000085d5eb in var_is_nonnullable (root=0x3be6fb89f478, var=var@entry=0x3be6fc0f1900, use_rel_info=false) at ../src/backend/optimizer/util/clauses.c:4235 [08:11:36.767] rte = [08:11:36.767] notnullattnums = 0x0 [08:11:36.767] #7 0x000000000085cf5d in eval_const_expressions_mutator (node=0x3be6fc0f1880, context=) at ../src/backend/optimizer/util/clauses.c:3556 [08:11:36.767] varg = 0x3be6fc0f1900 [08:11:36.767] result = [08:11:36.767] ntest = 0x3be6fc0f1880 [08:11:36.767] arg = 0x3be6fc0f1900 [08:11:36.767] newntest = [08:11:36.767] #8 0x000000000085f648 in simplify_and_arguments (args=, context=context@entry=0x8212e0328, haveNull=haveNull@entry=0x8212e02d0, forceFalse=forceFalse@entry=0x8212e02e4) at ../src/backend/optimizer/util/clauses.c:3964 [08:11:36.767] arg = 0x3be6fc0f1880 [08:11:36.767] newargs = 0x3be6fc0f1a90 [08:11:36.767] unprocessed_args = 0x0 [08:11:36.767] #9 0x000000000085ce63 in eval_const_expressions_mutator (node=0x3be6fc0f16c0, context=) at ../src/backend/optimizer/util/clauses.c:2877 [08:11:36.767] haveNull = false [08:11:36.767] forceFalse = false [08:11:36.767] newargs = [08:11:36.767] expr = 0x3be6fc0f16c0 [08:11:36.767] #10 0x000000000085be9b in eval_const_expressions (root=root@entry=0x3be6fb89f478, node=0x0, node@entry=0x3be6fc0f16c0) at ../src/backend/optimizer/util/clauses.c:2272 [08:11:36.767] context = {boundParams = , root = 0x3be6fb89f478, active_fns = 0x0, case_val = 0x0, estimate = false} [08:11:36.767] #11 0x000000000084c89f in convert_EXISTS_sublink_to_join (root=0x3be6fb89f478, sublink=, under_not=false, available_rels=available_rels@entry=0x3be6fb89fa58) at ../src/backend/optimizer/plan/subselect.c:1541 [08:11:36.767] je = [08:11:36.767] lc__state = {l = 0x3be6fc0f1670, i = 0} [08:11:36.767] subroot = {type = T_Invalid, parse = 0xae94e9 , glob = 0x2d9b0a, query_level = 0, parent_root = 0x3be6fb91c100, plan_params = 0x3be6fb91d8e8, outer_params = 0x200c1bd00, simple_rel_array = 0x0, simple_rel_array_size = -74333952, simple_rte_array = 0x3be6fb91c190, append_rel_array = 0x200000014, all_baserels = 0x0, outer_join_rels = 0x195f4b2b212e04b0, all_query_rels = 0x3be6fb91c190, join_rel_list = 0x14, join_rel_hash = 0x3be6fb91d8e8, join_rel_level = 0x8212e04d0, join_cur_level = 1064522760, init_plans = 0x1, cte_plan_ids = 0x1, multiexpr_params = 0x8212e0440, join_domains = 0xabd468 , eq_classes = 0xc1bd70 , ec_merging_done = false, canon_pathkeys = 0x3be6fb89f8d8, left_join_clauses = 0x0, right_join_clauses = 0x8212e0460, full_join_clauses = 0x53, join_info_list = 0x8212e04c0, last_rinfo_serial = 11419140, all_result_relids = 0x6183c0 , leaf_result_relids = 0xae977e , append_rel_list = 0x2, row_identity_vars = 0x0, rowMarks = 0x3be6fb830c00, placeholder_list = 0x3be6fb9d4ed0, placeholder_array = 0x3be6fb9d53e8, placeholder_array_size = 556664080, fkey_list = 0x3be6fb920100, query_pathkeys = 0x53, group_pathkeys = 0x1212e0500, num_groupby_pathkeys = 0, window_pathkeys = 0xd79fb7b3212e04e0, distinct_pathkeys = 0x0, sort_pathkeys = 0x4, setop_pathkeys = 0x3be6fb9d4e88, part_schemes = 0x3be6fb89f8d8, initial_rels = 0x0, upper_rels = {0xaa08, 0x0, 0x8212e0690, 0xacbb40 , 0x3000100000000, 0x3b600000000, 0xa3f2a0 , 0x10002000000b8}, upper_targets = {0x2, 0x0, 0x3be6fb830c00, 0x0, 0xaa08, 0x5000500000000, 0x3b600000000, 0x9f2610 }, processed_groupClause = 0x1000200000092, processed_distinctClause = 0x2, processed_tlist = 0x0, update_colnos = 0x3be6fb830c00, grouping_map = 0x0, minmax_aggs = 0x0, planner_cxt = 0x3000900000000, total_table_pages = 5.6527952693433506e-317, tuple_fraction = 5.3084784504283567e-317, limit_tuples = 1.3907136014837293e-309, qual_security_level = 556664322, hasJoinRTEs = 8, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 233, placeholdersFrozen = 148, hasRecursion = 174, group_rtindex = 0, agginfos = 0x3be6fb830c00, aggtransinfos = 0x0, numOrderedAggs = -74333952, hasNonPartialAggs = 230, hasNonSerialAggs = 59, wt_param_id = 556664548, non_recursive_path = 0x0, curOuterRels = 0x8212e0678, curOuterParams = 0x3be6fc025100, isAltSubplan = 0x3be6fb91c190, isUsedSubplan = 0x100000014, join_search_private = 0x0, partColsUpdated = 2, partPruneInfos = 0x3be6fc025190} [08:11:36.767] parse = 0x3be6fc0e4ec8 [08:11:36.767] subselect = 0x3be6fb8790c8 [08:11:36.767] newWhere = 0x0 [08:11:36.767] all_clauses = 0x3be6fc0f1670 [08:11:36.767] upper_reference_exists = false [08:11:36.767] whereClause = 0x3be6fc0f16c0 [08:11:36.767] lc = [08:11:36.767] rtoffset = [08:11:36.767] clause_varnos = [08:11:36.767] upper_varnos = [08:11:36.767] varno = [08:11:36.767] result = [08:11:36.767] #12 0x00000000008541a2 in pull_up_sublinks_qual_recurse (root=0x18da1, node=0x6, jtlink1=0x3be6fb874e20, available_rels1=0x3be6fb89fa58, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [08:11:36.767] child_rels = 0xb0211f [08:11:36.767] sublink = 0x6 [08:11:36.767] j = [08:11:36.767] #13 0x0000000000850f99 in pull_up_sublinks_jointree_recurse (root=root@entry=0x3be6fb89f478, jtnode=, relids=relids@entry=0x8212e0780) at ../src/backend/optimizer/prep/prepjointree.c:787 [08:11:36.767] leftrelids = 0x3be6fb89f928 [08:11:36.767] rightrelids = 0x3be6fb89fa58 [08:11:36.767] jtlink = 0x3be6fb874e08 [08:11:36.767] j = 0x3be6fb874e08 [08:11:36.767] #14 0x0000000000850e45 in pull_up_sublinks_jointree_recurse (root=root@entry=0x3be6fb89f478, jtnode=0x3be6fc0e5ed8, relids=relids@entry=0x8212e07c0) at ../src/backend/optimizer/prep/prepjointree.c:706 [08:11:36.767] childrelids = 0x3 [08:11:36.767] newchild = [08:11:36.767] l__state = {l = 0x3be6fc120440, i = 0} [08:11:36.767] jtlink = 0x3 [08:11:36.767] frelids = 0x0 [08:11:36.767] newf = [08:11:36.767] f = 0x3be6fc0e5ed8 [08:11:36.767] newfromlist = 0x0 [08:11:36.767] l = 0x82de2819a [08:11:36.767] #15 0x0000000000850d7a in pull_up_sublinks (root=0x18da1, root@entry=0x3be6fb89f478) at ../src/backend/optimizer/prep/prepjointree.c:653 [08:11:36.767] relids = 0x3be6fc0e5ed8 [08:11:36.767] jtnode = [08:11:36.767] #16 0x000000000083bf4a in subquery_planner (glob=glob@entry=0x3be6fb8792d8, parse=parse@entry=0x3be6fc0e4ec8, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:757 [08:11:36.767] root = 0x3be6fb89f478 [08:11:36.767] hasOuterJoins = [08:11:36.767] hasResultRTEs = [08:11:36.767] l = [08:11:36.767] newWithCheckOptions = [08:11:36.767] newHaving = [08:11:36.767] final_rel = [08:11:36.767] #17 0x000000000083b6c2 in standard_planner (parse=0x3be6fc0e4ec8, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:442 [08:11:36.767] glob = 0x3be6fb8792d8 [08:11:36.767] tuple_fraction = [08:11:36.767] root = [08:11:36.767] final_rel = [08:11:36.767] best_path = [08:11:36.767] top_plan = [08:11:36.767] lp = [08:11:36.767] lr = [08:11:36.767] result = [08:11:36.767] #18 0x000000000083b54e in planner (parse=0x18da1, parse@entry=0x3be6fc0e4ec8, query_string=0x6 , query_string@entry=0x3be6fb822100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=0, cursorOptions@entry=2048, boundParams=0x82de2819a , boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:301 [08:11:36.767] result = [08:11:36.767] #19 0x0000000000976f34 in pg_plan_query (querytree=querytree@entry=0x3be6fc0e4ec8, query_string=query_string@entry=0x3be6fb822100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:900 [08:11:36.767] plan = [08:11:36.767] #20 0x0000000000700bba in standard_ExplainOneQuery (query=0x3be6fc0e4ec8, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x3be6fb879038, queryString=0x3be6fb822100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:353 [08:11:36.767] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 65863249907336, shared_blks_dirtied = 65863249907336, shared_blks_written = 11542815, local_blks_hit = 240, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 65863249907336, temp_blks_read = 2, temp_blks_written = 65863257314240, shared_blk_read_time = {ticks = 34916403648}, shared_blk_write_time = {ticks = 6087130}, local_blk_read_time = {ticks = 70381629123080}, local_blk_write_time = {ticks = 65863257314160}, temp_blk_read_time = {ticks = 34916403824}, temp_blk_write_time = {ticks = 9529338}} [08:11:36.767] bufusage = {shared_blks_hit = 261, shared_blks_read = 453968808, shared_blks_dirtied = 4294967288, shared_blks_written = 65863257557505, local_blks_hit = 65863257557640, local_blks_read = 0, local_blks_dirtied = 34916403712, local_blks_written = 7324964, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = -1}, shared_blk_write_time = {ticks = 65863248186920}, local_blk_read_time = {ticks = 65863257312968}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 34916403792}, temp_blk_write_time = {ticks = 11581072}} [08:11:36.767] mem_counters = {nblocks = 34916403568, freechunks = 11542815, totalspace = 240, freespace = 65863249907336} [08:11:36.767] planduration = {ticks = 8355588} [08:11:36.767] planner_ctx = 0x0 [08:11:36.767] saved_ctx = [08:11:36.767] planstart = {ticks = -261453968808} [08:11:36.767] plan = [08:11:36.767] #21 0x0000000000700872 in ExplainOneQuery (query=0x18da1, cursorOptions=2048, into=0x0, es=0x3be6fb879038, pstate=0x3be6fb830eb8, params=0x0) at ../src/backend/commands/explain.c:309 [08:11:36.767] No locals. [08:11:36.767] #22 ExplainQuery (pstate=pstate@entry=0x3be6fb830eb8, stmt=stmt@entry=0x3be6fc0e4e98, params=params@entry=0x0, dest=0x3be6fb830e28) at ../src/backend/commands/explain.c:223 [08:11:36.767] l__state = {l = , i = 0} [08:11:36.767] l = 0x3be6fb874cb0 [08:11:36.767] es = 0x3be6fb879038 [08:11:36.767] jstate = [08:11:36.767] query = [08:11:36.767] rewritten = 0x3be6fb874c98 [08:11:36.767] tstate = [08:11:36.767] #23 0x000000000097e1a0 in standard_ProcessUtility (pstmt=0x3be6fc120b60, queryString=0x3be6fb822100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x3be6fb830e28, qc=0x8212e0c18) at ../src/backend/tcop/utility.c:866 [08:11:36.767] isAtomicContext = false [08:11:36.767] parsetree = 0x3be6fc0e4e98 [08:11:36.767] readonly_flags = [08:11:36.767] pstate = 0x3be6fb830eb8 [08:11:36.767] isTopLevel = [08:11:36.767] #24 0x000000000097de38 in ProcessUtility (pstmt=0x18da1, queryString=0x6 , readOnlyTree=, context=769819034, params=0x0, queryEnv=0x0, dest=0x3be6fb830e28, qc=0x8212e0c18) at ../src/backend/tcop/utility.c:523 [08:11:36.767] No locals. [08:11:36.767] #25 0x000000000097d96c in PortalRunUtility (portal=portal@entry=0x3be6fb924100, pstmt=0x3be6fc120b60, isTopLevel=, setHoldSnapshot=true, dest=dest@entry=0x3be6fb830e28, qc=qc@entry=0x8212e0c18) at ../src/backend/tcop/pquery.c:1153 [08:11:36.767] No locals. [08:11:36.767] #26 0x000000000097cbaa in FillPortalStore (portal=portal@entry=0x3be6fb924100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [08:11:36.767] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:11:36.767] treceiver = 0x3be6fb830e28 [08:11:36.767] #27 0x000000000097c8e4 in PortalRun (portal=portal@entry=0x3be6fb924100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x3be6fc120cc0, altdest=altdest@entry=0x3be6fc120cc0, qc=qc@entry=0x8212e0d50) at ../src/backend/tcop/pquery.c:760 [08:11:36.767] _local_sigjmp_buf = {{_sjb = {9947269, 65863249182976, 34916404296, 34916404544, 34916404304, 12688072, 34916404560, 12615016, 12583807, 0, 65863249167231, 65859028516864}}} [08:11:36.767] _save_exception_stack = 0x8212e0e00 [08:11:36.767] _save_context_stack = 0x0 [08:11:36.767] _do_rethrow = false [08:11:36.767] saveTopTransactionResourceOwner = 0x3be6fb98ce18 [08:11:36.767] saveTopTransactionContext = 0x3be6fb9e6000 [08:11:36.767] saveActivePortal = 0x0 [08:11:36.767] saveResourceOwner = 0x3be6fb98ce18 [08:11:36.767] savePortalContext = 0x0 [08:11:36.767] saveMemoryContext = 0x3be6fb9e6000 [08:11:36.767] result = [08:11:36.767] nprocessed = [08:11:36.767] #28 0x000000000097b749 in exec_simple_query (query_string=query_string@entry=0x3be6fb822100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"...) at ../src/backend/tcop/postgres.c:1274 [08:11:36.767] cmdtaglen = 7 [08:11:36.767] snapshot_set = [08:11:36.767] per_parsetree_context = 0x0 [08:11:36.767] plantree_list = [08:11:36.767] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:11:36.767] format = 0 [08:11:36.767] parsetree = 0x3be6fb97f188 [08:11:36.767] commandTag = [08:11:36.767] cmdtagname = [08:11:36.767] querytree_list = [08:11:36.767] portal = 0x3be6fb924100 [08:11:36.767] receiver = 0x3be6fc120cc0 [08:11:36.767] parsetree_item__state = {l = 0x3be6fb980140, i = 0} [08:11:36.767] msec_str = "\000\000\000\000\b", '\000' , "\240\r.!\b\000\000\000UJ\342-\b\000\000" [08:11:36.767] dest = DestRemote [08:11:36.767] was_logged = [08:11:36.767] oldcontext = 0x3be6fb9e6000 [08:11:36.767] parsetree_list = 0x3be6fb980140 [08:11:36.767] use_implicit_block = false [08:11:36.767] parsetree_item = 0x3be6fb980158 [08:11:36.767] save_log_statement_stats = [08:11:36.767] #29 0x0000000000979195 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4763 [08:11:36.767] query_string = 0x3be6fb822100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"... [08:11:36.767] input_message = {data = 0x3be6fb822100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., len = 206, maxlen = 1024, cursor = 206} [08:11:36.767] firstchar = [08:11:36.767] local_sigjmp_buf = {{_sjb = {9930123, 34916404736, 34916404728, 34916405328, 12489252, 12488984, 12696856, 12690788, 895, 0, 0, 65859028516865}}} [08:11:36.767] send_ready_for_query = false [08:11:36.767] idle_in_transaction_timeout_enabled = false [08:11:36.767] idle_session_timeout_enabled = false [08:11:36.767] #30 0x0000000000973639 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [08:11:36.767] bsdata = [08:11:36.767] #31 0x00000000008c063b in postmaster_child_launch (child_type=B_BACKEND, child_slot=17, startup_data=startup_data@entry=0x8212e1ab8, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x8212e1ad0) at ../src/backend/postmaster/launch_backend.c:290 [08:11:36.767] pid = [08:11:36.767] #32 0x00000000008c5008 in BackendStartup (client_sock=0x8212e1ad0) at ../src/backend/postmaster/postmaster.c:3590 [08:11:36.767] startup_data = {canAcceptConnections = CAC_OK, socket_created = 809597178195874, fork_started = } [08:11:36.767] bn = 0x3be6fb95b338 [08:11:36.767] cac = CAC_OK [08:11:36.767] pid = [08:11:36.767] __error = [08:11:36.767] save_errno = [08:11:36.767] __error = [08:11:36.767] __error = [08:11:36.767] #33 ServerLoop () at ../src/backend/postmaster/postmaster.c:1705 [08:11:36.767] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\r", '\000' , "0\033.!\b\000\000\000X\326\213,\b\000\000\000\006\001\000\000\000\000\000\000\276^\214,\b", '\000' , "p\033.!\b\000\000\000\204\003\214\000\000\000\000\000\200\033.!\b", '\000' }, salen = 16}} [08:11:36.767] i = 0 [08:11:36.767] now = [08:11:36.767] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 769443212, user_data = 0x0}, {pos = 556669568, events = 8, fd = -74844712, user_data = 0x8212e1910}, {pos = 0, events = 0, fd = 0, user_data = 0x55171df6cff4622e}, {pos = 770555392, events = 8, fd = 556668288, user_data = 0x3be12440d2cd}, {pos = 768601016, events = 8, fd = 768675996, user_data = 0x8212e1598}, {pos = 556668432, events = 8, fd = 556668336, user_data = 0x3be12440d2cd}, {pos = 768597872, events = 8, fd = 768675996, user_data = 0x8212e15c8}, {pos = 556668480, events = 8, fd = 768646596, user_data = 0x82dd09dc4}, {pos = 556668400, events = 8, fd = 608228045, user_data = 0x82dd02410}, {pos = 768675996, events = 8, fd = 556668424, user_data = 0x8212e1680}, {pos = 768649524, events = 8, fd = 768649524, user_data = 0x3be6fb40a408}, {pos = 3, events = 0, fd = 556668528, user_data = 0x3be1244084fb}, {pos = 556668544, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 556668616, user_data = 0x8212e1888}, {pos = 556668592, events = 8, fd = 608226386, user_data = 0x2960ca}, {pos = -79629688, events = 15334, fd = 768615440, user_data = 0x3be6fb40a408}, {pos = 556668680, events = 8, fd = 556669128, user_data = 0x8212e16f0}, {pos = 608226386, events = 15329, fd = 2735927, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = -79626160, user_data = 0x800000001}, {pos = 0, events = 0, fd = 0, user_data = 0x8212e19c8}, {pos = -75430464, events = 3, fd = 556669208, user_data = 0x3be6fb40fac8}, {pos = 656, events = 0, fd = 556669128, user_data = 0x8212e1708}, {pos = 556668784, events = 8, fd = 608225995, user_data = 0x8212e1988}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -79626160, events = 15334, fd = 1, user_data = 0x3be6fb40a408}, {pos = 768615440, events = 8, fd = 556669384, user_data = 0x8212e1918}, {pos = 556668800, events = 8, fd = 0, user_data = 0x3be6fb403008}, {pos = 32, events = 0, fd = 556669184, user_data = 0x3be124406c77}, {pos = -79679480, events = 15334, fd = -79678456, user_data = 0x3be6fb403808}, {pos = -79676408, events = 15334, fd = -79663096, user_data = 0x3be6fb407408}, {pos = -79661048, events = 15334, fd = -79660024, user_data = 0x3be6fb408008}, {pos = -79657976, events = 15334, fd = -79656952, user_data = 0x3be6fb408c08}, {pos = -79654904, events = 15334, fd = -79653880, user_data = 0x3be6fb409808}, {pos = -79651832, events = 15334, fd = -79650808, user_data = 0x3be6fb40a408}, {pos = -79648760, events = 15334, fd = -79647736, user_data = 0x3be6fb40b008}, {pos = -79645688, events = 15334, fd = -79644664, user_data = 0x3be6fb40bc08}, {pos = -79642616, events = 15334, fd = -79641592, user_data = 0x3be6fb40c808}, {pos = -79639544, events = 15334, fd = -79634424, user_data = 0x3be6fb40e408}, {pos = -79632376, events = 15334, fd = -79631352, user_data = 0x3be6fb403008}, {pos = 2735927, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -79626160, events = 15334, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 556669384, user_data = 0x8212e1780}, {pos = 32, events = 32, fd = -79679480, user_data = 0x378}, {pos = 2113896, events = 0, fd = 296, user_data = 0x3be6fb410050}, {pos = 556669360, events = 8, fd = 608200577, user_data = 0x3be6fb831000}, {pos = 2735927, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -79626160, events = 15334, fd = 1, user_data = 0x3be6fb40a408}, {pos = 12576672, events = 0, fd = 769810192, user_data = 0x3be6fb403008}, {pos = 2840040, events = 0, fd = 747394233, user_data = 0x1}, {pos = -75423744, events = 15334, fd = 556669360, user_data = 0x82c8c4642}, {pos = 769810192, events = 8, fd = 12576672, user_data = 0x82de25f10 }, {pos = -79649784, events = 15334, fd = 556669584, user_data = 0x3be124406574}, {pos = 556669440, events = 8, fd = 1, user_data = 0x3be1244063ee}, {pos = -79679480, events = 15334, fd = 556669368, user_data = 0x8212e1a90}, {pos = 6792, events = 0, fd = 12, user_data = 0x3be12441a3a0}, {pos = 0, events = 0, fd = -75365505, user_data = 0xc1bd10 }, {pos = 556669504, events = 8, fd = 747353440, user_data = 0x82deca4b0 <__thr_jtable>}, {pos = 770492320, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 556669552, events = 8, fd = 747353440, user_data = 0x82deca4b0 <__thr_jtable>}, {pos = 770492320, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 556669600, events = 8, fd = 747395837, user_data = 0x3be6fb812000}, {pos = 5761, events = 0, fd = 556669696, user_data = 0x82c8bd9ea}} [08:11:36.767] last_touch_time = 1756281781 [08:11:36.767] last_lockfile_recheck_time = 1756281961 [08:11:36.767] nevents = 1 [08:11:36.767] #34 0x00000000008c2dbf in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8212e2110) at ../src/backend/postmaster/postmaster.c:1403 [08:11:36.767] userDoption = [08:11:36.767] listen_addr_saved = false [08:11:36.767] output_config_variable = [08:11:36.767] opt = [08:11:36.767] status = [08:11:36.767] #35 0x00000000007f5590 in main (argc=4, argv=0x8212e2110) at ../src/backend/main/main.c:231 [08:11:36.767] do_check_root = [08:11:36.767] dispatch_option = DISPATCH_POSTMASTER [08:11:36.776] [08:11:36.776] [08:11:36.776] [08:11:36.827] dumping /tmp/cores/postgres.82729.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [08:11:36.956] [New LWP 101697] [08:11:37.021] Core was generated by `postgres: postgres regression [local] EXPLAIN'. [08:11:37.021] Program terminated with signal SIGABRT, Aborted. [08:11:37.021] Sent by thr_kill() from pid 82729 and user 1002. [08:11:37.021] #0 0x000000082bd061ba in thr_kill () from /lib/libc.so.7 [08:11:37.084] [08:11:37.084] Thread 1 (LWP 101697): [08:11:37.084] #0 0x000000082bd061ba in thr_kill () from /lib/libc.so.7 [08:11:37.084] No symbol table info available. [08:11:37.084] #1 0x000000082bc7f5d4 in raise () from /lib/libc.so.7 [08:11:37.084] No symbol table info available. [08:11:37.084] #2 0x000000082bd32b59 in abort () from /lib/libc.so.7 [08:11:37.084] No symbol table info available. [08:11:37.084] #3 0x0000000000ad9bf5 in ExceptionalCondition (conditionName=0x3683e4 "n >= 0 && n < list->length", fileName=, lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [08:11:37.084] No locals. [08:11:37.084] #4 0x000000000085d696 in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [08:11:37.084] No locals. [08:11:37.084] #5 list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [08:11:37.084] No locals. [08:11:37.084] #6 0x000000000085d5eb in var_is_nonnullable (root=0x53063296478, var=var@entry=0x53063ad9900, use_rel_info=false) at ../src/backend/optimizer/util/clauses.c:4235 [08:11:37.084] rte = [08:11:37.084] notnullattnums = 0x0 [08:11:37.084] #7 0x000000000085cf5d in eval_const_expressions_mutator (node=0x53063ad9880, context=) at ../src/backend/optimizer/util/clauses.c:3556 [08:11:37.084] varg = 0x53063ad9900 [08:11:37.084] result = [08:11:37.084] ntest = 0x53063ad9880 [08:11:37.084] arg = 0x53063ad9900 [08:11:37.084] newntest = [08:11:37.084] #8 0x000000000085f648 in simplify_and_arguments (args=, context=context@entry=0x82135c638, haveNull=haveNull@entry=0x82135c5e0, forceFalse=forceFalse@entry=0x82135c5f4) at ../src/backend/optimizer/util/clauses.c:3964 [08:11:37.084] arg = 0x53063ad9880 [08:11:37.084] newargs = 0x53063ad9a90 [08:11:37.084] unprocessed_args = 0x0 [08:11:37.084] #9 0x000000000085ce63 in eval_const_expressions_mutator (node=0x53063ad96c0, context=) at ../src/backend/optimizer/util/clauses.c:2877 [08:11:37.084] haveNull = false [08:11:37.084] forceFalse = false [08:11:37.084] newargs = [08:11:37.084] expr = 0x53063ad96c0 [08:11:37.084] #10 0x000000000085be9b in eval_const_expressions (root=root@entry=0x53063296478, node=0x0, node@entry=0x53063ad96c0) at ../src/backend/optimizer/util/clauses.c:2272 [08:11:37.084] context = {boundParams = , root = 0x53063296478, active_fns = 0x0, case_val = 0x0, estimate = false} [08:11:37.084] #11 0x000000000084c89f in convert_EXISTS_sublink_to_join (root=0x53063296478, sublink=, under_not=false, available_rels=available_rels@entry=0x53063296a58) at ../src/backend/optimizer/plan/subselect.c:1541 [08:11:37.084] je = [08:11:37.084] lc__state = {l = 0x53063ad9670, i = 0} [08:11:37.084] subroot = {type = T_Invalid, parse = 0xae94e9 , glob = 0x2d9b0a, query_level = 0, parent_root = 0x5306336f100, plan_params = 0x53063370af8, outer_params = 0x200c1bd00, simple_rel_array = 0x0, simple_rel_array_size = 1664545024, simple_rte_array = 0x5306336f190, append_rel_array = 0x200000014, all_baserels = 0x0, outer_join_rels = 0x637ad6552135c7c0, all_query_rels = 0x5306336f190, join_rel_list = 0x14, join_rel_hash = 0x53063370af8, join_rel_level = 0x82135c7e0, join_cur_level = 1001462376, init_plans = 0x1, cte_plan_ids = 0x1, multiexpr_params = 0x82135c750, join_domains = 0xabd468 , eq_classes = 0xc1bd70 , ec_merging_done = false, canon_pathkeys = 0x530632968d8, left_join_clauses = 0x0, right_join_clauses = 0x82135c770, full_join_clauses = 0x53, join_info_list = 0x82135c7d0, last_rinfo_serial = 11419140, all_result_relids = 0x6183c0 , leaf_result_relids = 0xae977e , append_rel_list = 0x2, row_identity_vars = 0x0, rowMarks = 0x53063230c00, placeholder_list = 0x530633ccfd0, placeholder_array = 0x530633cd4e8, placeholder_array_size = 557172768, fkey_list = 0x53063373100, query_pathkeys = 0x53, group_pathkeys = 0x12135c810, num_groupby_pathkeys = 0, window_pathkeys = 0x9289bbc92135c7f0, distinct_pathkeys = 0x0, sort_pathkeys = 0x4, setop_pathkeys = 0x530633ccf88, part_schemes = 0x530632968d8, initial_rels = 0x0, upper_rels = {0xaa05, 0x0, 0x82135c9a0, 0xacbb40 , 0x3000100000000, 0x3b600000000, 0xa3f2a0 , 0x10002000000b8}, upper_targets = {0x2, 0x0, 0x53063230c00, 0x0, 0xaa05, 0x5000500000000, 0x3b600000000, 0x9f2610 }, processed_groupClause = 0x1000200000092, processed_distinctClause = 0x2, processed_tlist = 0x0, update_colnos = 0x53063230c00, grouping_map = 0x0, minmax_aggs = 0x0, planner_cxt = 0x3000900000000, total_table_pages = 5.6527952693433506e-317, tuple_fraction = 5.3084784504283567e-317, limit_tuples = 1.3907136014837293e-309, qual_security_level = 557172994, hasJoinRTEs = 8, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 233, placeholdersFrozen = 148, hasRecursion = 174, group_rtindex = 0, agginfos = 0x53063230c00, aggtransinfos = 0x0, numOrderedAggs = 1664545024, hasNonPartialAggs = 48, hasNonSerialAggs = 5, wt_param_id = 557173236, non_recursive_path = 0x0, curOuterRels = 0x82135c988, curOuterParams = 0x53063aa0100, isAltSubplan = 0x5306336f190, isUsedSubplan = 0x100000014, join_search_private = 0x0, partColsUpdated = 2, partPruneInfos = 0x53063aa0190} [08:11:37.084] parse = 0x53063ac6b08 [08:11:37.084] subselect = 0x53063a390c8 [08:11:37.084] newWhere = 0x0 [08:11:37.084] all_clauses = 0x53063ad9670 [08:11:37.084] upper_reference_exists = false [08:11:37.084] whereClause = 0x53063ad96c0 [08:11:37.084] lc = [08:11:37.084] rtoffset = [08:11:37.084] clause_varnos = [08:11:37.084] upper_varnos = [08:11:37.084] varno = [08:11:37.084] result = [08:11:37.084] #12 0x00000000008541a2 in pull_up_sublinks_qual_recurse (root=0x18d41, node=0x6, jtlink1=0x5306326be20, available_rels1=0x53063296a58, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [08:11:37.084] child_rels = 0xb0211f [08:11:37.084] sublink = 0x6 [08:11:37.084] j = [08:11:37.084] #13 0x0000000000850f99 in pull_up_sublinks_jointree_recurse (root=root@entry=0x53063296478, jtnode=, relids=relids@entry=0x82135ca90) at ../src/backend/optimizer/prep/prepjointree.c:787 [08:11:37.084] leftrelids = 0x53063296928 [08:11:37.084] rightrelids = 0x53063296a58 [08:11:37.084] jtlink = 0x5306326be08 [08:11:37.084] j = 0x5306326be08 [08:11:37.084] #14 0x0000000000850e45 in pull_up_sublinks_jointree_recurse (root=root@entry=0x53063296478, jtnode=0x53063ac7b18, relids=relids@entry=0x82135cad0) at ../src/backend/optimizer/prep/prepjointree.c:706 [08:11:37.084] childrelids = 0x3 [08:11:37.084] newchild = [08:11:37.084] l__state = {l = 0x53063b04180, i = 0} [08:11:37.084] jtlink = 0x3 [08:11:37.084] frelids = 0x0 [08:11:37.084] newf = [08:11:37.084] f = 0x53063ac7b18 [08:11:37.084] newfromlist = 0x0 [08:11:37.084] l = 0x82bd0619a [08:11:37.084] #15 0x0000000000850d7a in pull_up_sublinks (root=0x18d41, root@entry=0x53063296478) at ../src/backend/optimizer/prep/prepjointree.c:653 [08:11:37.084] relids = 0x53063ac7b18 [08:11:37.084] jtnode = [08:11:37.084] #16 0x000000000083bf4a in subquery_planner (glob=glob@entry=0x53063a392d8, parse=parse@entry=0x53063ac6b08, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:757 [08:11:37.084] root = 0x53063296478 [08:11:37.084] hasOuterJoins = [08:11:37.084] hasResultRTEs = [08:11:37.084] l = [08:11:37.084] newWithCheckOptions = [08:11:37.084] newHaving = [08:11:37.084] final_rel = [08:11:37.084] #17 0x000000000083b6c2 in standard_planner (parse=0x53063ac6b08, query_string=, cursorOptions=2048, boundParams=0x0) at ../src/backend/optimizer/plan/planner.c:442 [08:11:37.084] glob = 0x53063a392d8 [08:11:37.084] tuple_fraction = [08:11:37.084] root = [08:11:37.084] final_rel = [08:11:37.084] best_path = [08:11:37.084] top_plan = [08:11:37.084] lp = [08:11:37.084] lr = [08:11:37.084] result = [08:11:37.084] #18 0x000000000083b54e in planner (parse=0x18d41, parse@entry=0x53063ac6b08, query_string=0x6 , query_string@entry=0x53063222100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=0, cursorOptions@entry=2048, boundParams=0x82bd0619a , boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:301 [08:11:37.084] result = [08:11:37.084] #19 0x0000000000976f34 in pg_plan_query (querytree=querytree@entry=0x53063ac6b08, query_string=query_string@entry=0x53063222100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:900 [08:11:37.084] plan = [08:11:37.084] #20 0x0000000000700bba in standard_ExplainOneQuery (query=0x53063ac6b08, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x53063a39038, queryString=0x53063222100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:353 [08:11:37.084] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 5705381498760, shared_blks_dirtied = 5705381498760, shared_blks_written = 11542815, local_blks_hit = 240, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 5705381498760, temp_blks_read = 2, temp_blks_written = 5705388814336, shared_blk_read_time = {ticks = 34916912336}, shared_blk_write_time = {ticks = 6087130}, local_blk_read_time = {ticks = 70368744221189}, local_blk_write_time = {ticks = 5705388814256}, temp_blk_read_time = {ticks = 34916912512}, temp_blk_write_time = {ticks = 9529338}} [08:11:37.084] bufusage = {shared_blks_hit = 264, shared_blks_read = 359288979, shared_blks_dirtied = 4294967288, shared_blks_written = 5705389065985, local_blks_hit = 5705389066184, local_blks_read = 0, local_blks_dirtied = 34916912384, local_blks_written = 7324964, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = -1}, shared_blk_write_time = {ticks = 5705379810856}, local_blk_read_time = {ticks = 5705388813064}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 34916912480}, temp_blk_write_time = {ticks = 11581072}} [08:11:37.084] mem_counters = {nblocks = 34916912256, freechunks = 11542815, totalspace = 240, freespace = 5705381498760} [08:11:37.084] planduration = {ticks = 8355588} [08:11:37.084] planner_ctx = 0x0 [08:11:37.084] saved_ctx = [08:11:37.084] planstart = {ticks = -264359288979} [08:11:37.084] plan = [08:11:37.084] #21 0x0000000000700872 in ExplainOneQuery (query=0x18d41, cursorOptions=2048, into=0x0, es=0x53063a39038, pstate=0x53063230eb8, params=0x0) at ../src/backend/commands/explain.c:309 [08:11:37.084] No locals. [08:11:37.084] #22 ExplainQuery (pstate=pstate@entry=0x53063230eb8, stmt=stmt@entry=0x53063ac6ad8, params=params@entry=0x0, dest=0x53063230e28) at ../src/backend/commands/explain.c:223 [08:11:37.084] l__state = {l = , i = 0} [08:11:37.084] l = 0x5306326bcb0 [08:11:37.084] es = 0x53063a39038 [08:11:37.084] jstate = [08:11:37.084] query = [08:11:37.084] rewritten = 0x5306326bc98 [08:11:37.084] tstate = [08:11:37.084] #23 0x000000000097e1a0 in standard_ProcessUtility (pstmt=0x53063b048a0, queryString=0x53063222100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x53063230e28, qc=0x82135cf28) at ../src/backend/tcop/utility.c:866 [08:11:37.084] isAtomicContext = false [08:11:37.084] parsetree = 0x53063ac6ad8 [08:11:37.084] readonly_flags = [08:11:37.084] pstate = 0x53063230eb8 [08:11:37.084] isTopLevel = [08:11:37.084] #24 0x000000000097de38 in ProcessUtility (pstmt=0x18d41, queryString=0x6 , readOnlyTree=, context=735076762, params=0x0, queryEnv=0x0, dest=0x53063230e28, qc=0x82135cf28) at ../src/backend/tcop/utility.c:523 [08:11:37.084] No locals. [08:11:37.084] #25 0x000000000097d96c in PortalRunUtility (portal=portal@entry=0x53063378100, pstmt=0x53063b048a0, isTopLevel=, setHoldSnapshot=true, dest=dest@entry=0x53063230e28, qc=qc@entry=0x82135cf28) at ../src/backend/tcop/pquery.c:1153 [08:11:37.084] No locals. [08:11:37.084] #26 0x000000000097cbaa in FillPortalStore (portal=portal@entry=0x53063378100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [08:11:37.084] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:11:37.084] treceiver = 0x53063230e28 [08:11:37.084] #27 0x000000000097c8e4 in PortalRun (portal=portal@entry=0x53063378100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x53063b04a00, altdest=altdest@entry=0x53063b04a00, qc=qc@entry=0x82135d060) at ../src/backend/tcop/pquery.c:760 [08:11:37.084] _local_sigjmp_buf = {{_sjb = {9947269, 5705381150976, 34916912984, 34916913232, 34916912992, 12688072, 34916913248, 12615016, 12583807, 0, 5705381118847, 5703716569088}}} [08:11:37.084] _save_exception_stack = 0x82135d110 [08:11:37.084] _save_context_stack = 0x0 [08:11:37.084] _do_rethrow = false [08:11:37.084] saveTopTransactionResourceOwner = 0x53063387b48 [08:11:37.084] saveTopTransactionContext = 0x530633e8000 [08:11:37.084] saveActivePortal = 0x0 [08:11:37.084] saveResourceOwner = 0x53063387b48 [08:11:37.084] savePortalContext = 0x0 [08:11:37.084] saveMemoryContext = 0x530633e8000 [08:11:37.084] result = [08:11:37.084] nprocessed = [08:11:37.084] #28 0x000000000097b749 in exec_simple_query (query_string=query_string@entry=0x53063222100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"...) at ../src/backend/tcop/postgres.c:1274 [08:11:37.084] cmdtaglen = 7 [08:11:37.084] snapshot_set = [08:11:37.084] per_parsetree_context = 0x0 [08:11:37.084] plantree_list = [08:11:37.084] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:11:37.084] format = 0 [08:11:37.084] parsetree = 0x5306337f408 [08:11:37.084] commandTag = [08:11:37.084] cmdtagname = [08:11:37.084] querytree_list = [08:11:37.084] portal = 0x53063378100 [08:11:37.084] receiver = 0x53063b04a00 [08:11:37.084] parsetree_item__state = {l = 0x530633803c0, i = 0} [08:11:37.084] msec_str = "\000\000\000\000\b", '\000' , "\260\3205!\b\000\000\000U*\320+\b\000\000" [08:11:37.084] dest = DestRemote [08:11:37.084] was_logged = [08:11:37.084] oldcontext = 0x530633e8000 [08:11:37.084] parsetree_list = 0x530633803c0 [08:11:37.084] use_implicit_block = false [08:11:37.084] parsetree_item = 0x530633803d8 [08:11:37.084] save_log_statement_stats = [08:11:37.084] #29 0x0000000000979195 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4763 [08:11:37.084] query_string = 0x53063222100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"... [08:11:37.084] input_message = {data = 0x53063222100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., len = 206, maxlen = 1024, cursor = 206} [08:11:37.084] firstchar = [08:11:37.084] local_sigjmp_buf = {{_sjb = {9930123, 34916913424, 34916913416, 34916914016, 12489252, 12488984, 12696856, 12690788, 895, 0, 0, 34359738369}}} [08:11:37.084] send_ready_for_query = false [08:11:37.084] idle_in_transaction_timeout_enabled = false [08:11:37.084] idle_session_timeout_enabled = false [08:11:37.084] #30 0x0000000000973639 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [08:11:37.084] bsdata = [08:11:37.084] #31 0x00000000008c063b in postmaster_child_launch (child_type=B_BACKEND, child_slot=7, startup_data=startup_data@entry=0x82135ddc8, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x82135dde0) at ../src/backend/postmaster/launch_backend.c:290 [08:11:37.084] pid = [08:11:37.084] #32 0x00000000008c5008 in BackendStartup (client_sock=0x82135dde0) at ../src/backend/postmaster/postmaster.c:3590 [08:11:37.084] startup_data = {canAcceptConnections = CAC_OK, socket_created = 809597181045247, fork_started = } [08:11:37.084] bn = 0x53063346158 [08:11:37.084] cac = CAC_OK [08:11:37.084] pid = [08:11:37.084] __error = [08:11:37.084] save_errno = [08:11:37.084] __error = [08:11:37.084] __error = [08:11:37.084] #33 ServerLoop () at ../src/backend/postmaster/postmaster.c:1705 [08:11:37.084] s = {sock = 8, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\r", '\000' , "@\3365!\b\000\000\000X\306\021*\b\000\000\000\032\001\000\000\000\000\000\000\276N\022*\b", '\000' , "\200\3365!\b\000\000\000\204\003\214\000\000\000\000\000\220\3365!\b", '\000' }, salen = 16}} [08:11:37.084] i = 0 [08:11:37.084] now = [08:11:37.084] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x0}, {pos = 557177952, events = 8, fd = 734700940, user_data = 0x0}, {pos = 557178256, events = 8, fd = 1663657432, user_data = 0x82135dc20}, {pos = 0, events = 0, fd = 0, user_data = 0x94e4f47ab3cb8875}, {pos = 735813120, events = 8, fd = 557176976, user_data = 0x3fb0432e52cd}, {pos = 733858744, events = 8, fd = 733933724, user_data = 0x82135d8a8}, {pos = 557177120, events = 8, fd = 557177024, user_data = 0x3fb0432e52cd}, {pos = 733855600, events = 8, fd = 733933724, user_data = 0x82135d8d8}, {pos = 557177168, events = 8, fd = 733904324, user_data = 0x82bbe7dc4}, {pos = 557177088, events = 8, fd = 1127109325, user_data = 0x82bbe0410}, {pos = 733933724, events = 8, fd = 557177112, user_data = 0x82135d990}, {pos = 733907252, events = 8, fd = 733907252, user_data = 0x53062e0a408}, {pos = 3, events = 0, fd = 557177216, user_data = 0x3fb0432e04fb}, {pos = 557177232, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 557177304, user_data = 0x82135db98}, {pos = 557177280, events = 8, fd = 1127107666, user_data = 0x2960ca}, {pos = 1658909320, events = 1328, fd = 733873168, user_data = 0x53062e0a408}, {pos = 557177368, events = 8, fd = 557177816, user_data = 0x82135da00}, {pos = 1127107666, events = 16304, fd = 2735927, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 1658912848, user_data = 0x800000001}, {pos = 0, events = 0, fd = 0, user_data = 0x82135dcd8}, {pos = 1663108448, events = 3, fd = 557177896, user_data = 0x53062e0fac8}, {pos = 656, events = 0, fd = 557177816, user_data = 0x82135da18}, {pos = 557177472, events = 8, fd = 1127107275, user_data = 0x82135dc98}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1658912848, events = 1328, fd = 1, user_data = 0x53062e0a408}, {pos = 733873168, events = 8, fd = 557178072, user_data = 0x82135dc28}, {pos = 557177488, events = 8, fd = 0, user_data = 0x53062e03008}, {pos = 32, events = 0, fd = 557177872, user_data = 0x3fb0432dec77}, {pos = 1658859528, events = 1328, fd = 1658860552, user_data = 0x53062e03808}, {pos = 1658862600, events = 1328, fd = 1658875912, user_data = 0x53062e07408}, {pos = 1658877960, events = 1328, fd = 1658878984, user_data = 0x53062e08008}, {pos = 1658881032, events = 1328, fd = 1658882056, user_data = 0x53062e08c08}, {pos = 1658884104, events = 1328, fd = 1658885128, user_data = 0x53062e09808}, {pos = 1658887176, events = 1328, fd = 1658888200, user_data = 0x53062e0a408}, {pos = 1658890248, events = 1328, fd = 1658891272, user_data = 0x53062e0b008}, {pos = 1658893320, events = 1328, fd = 1658894344, user_data = 0x53062e0bc08}, {pos = 1658896392, events = 1328, fd = 1658897416, user_data = 0x53062e0c808}, {pos = 1658899464, events = 1328, fd = 1658904584, user_data = 0x53062e0e408}, {pos = 1658906632, events = 1328, fd = 1658907656, user_data = 0x53062e03008}, {pos = 2735927, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 1658912848, events = 1328, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 557178072, user_data = 0x82135da90}, {pos = 32, events = 32, fd = 1658859528, user_data = 0x378}, {pos = 2113896, events = 0, fd = 296, user_data = 0x53062e10050}, {pos = 557178048, events = 8, fd = 1127081857, user_data = 0x53063231000}, {pos = 2735927, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 1658912848, events = 1328, fd = 1, user_data = 0x53062e0a408}, {pos = 12576672, events = 0, fd = 735067920, user_data = 0x53062e03008}, {pos = 2840040, events = 0, fd = 705840313, user_data = 0x1}, {pos = 1663115264, events = 1328, fd = 557178048, user_data = 0x82a123642}, {pos = 735067920, events = 8, fd = 12576672, user_data = 0x82bd03f10 }, {pos = 1658889224, events = 1328, fd = 557178272, user_data = 0x3fb0432de574}, {pos = 557178128, events = 8, fd = 1, user_data = 0x3fb0432de3ee}, {pos = 1658859528, events = 1328, fd = 557178056, user_data = 0x82135dda0}, {pos = 6792, events = 0, fd = 12, user_data = 0x3fb0432f23a0}, {pos = 0, events = 0, fd = 1663173503, user_data = 0xc1bd10 }, {pos = 557178192, events = 8, fd = 705799520, user_data = 0x82bda84b0 <__thr_jtable>}, {pos = 735750048, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 557178240, events = 8, fd = 705799520, user_data = 0x82bda84b0 <__thr_jtable>}, {pos = 735750048, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 557178288, events = 8, fd = 705841917, user_data = 0x53063212000}, {pos = 5648, events = 0, fd = 557178384, user_data = 0x82a11c9ea}} [08:11:37.084] last_touch_time = 1756281780 [08:11:37.084] last_lockfile_recheck_time = 1756281960 [08:11:37.084] nevents = 1 [08:11:37.084] #34 0x00000000008c2dbf in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82135e428) at ../src/backend/postmaster/postmaster.c:1403 [08:11:37.084] userDoption = [08:11:37.084] listen_addr_saved = false [08:11:37.084] output_config_variable = [08:11:37.084] opt = [08:11:37.084] status = [08:11:37.084] #35 0x00000000007f5590 in main (argc=8, argv=0x82135e428) at ../src/backend/main/main.c:231 [08:11:37.084] do_check_root = [08:11:37.084] dispatch_option = DISPATCH_POSTMASTER [08:11:37.093] [08:11:37.093] [08:11:37.093] [08:11:37.151] dumping /tmp/cores/postgres.5483.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [08:11:37.279] [New LWP 101799] [08:11:37.349] Core was generated by `postgres: primary: postgres regression [local] EXPLAIN'. [08:11:37.349] Program terminated with signal SIGABRT, Aborted. [08:11:37.349] Sent by thr_kill() from pid 5483 and user 1002. [08:11:37.349] #0 0x00000008283e71ba in thr_kill () from /lib/libc.so.7 [08:11:37.424] [08:11:37.424] Thread 1 (LWP 101799): [08:11:37.424] #0 0x00000008283e71ba in thr_kill () from /lib/libc.so.7 [08:11:37.424] No symbol table info available. [08:11:37.424] #1 0x00000008283605d4 in raise () from /lib/libc.so.7 [08:11:37.424] No symbol table info available. [08:11:37.424] #2 0x0000000828413b59 in abort () from /lib/libc.so.7 [08:11:37.424] No symbol table info available. [08:11:37.424] #3 0x0000000000ad9bf5 in ExceptionalCondition (conditionName=0x3683e4 "n >= 0 && n < list->length", fileName=, lineNumber=lineNumber@entry=280) at ../src/backend/utils/error/assert.c:66 [08:11:37.424] No locals. [08:11:37.424] #4 0x000000000085d696 in list_nth_cell (list=, n=) at ../src/include/nodes/pg_list.h:280 [08:11:37.424] No locals. [08:11:37.424] #5 list_nth (list=, n=) at ../src/include/nodes/pg_list.h:302 [08:11:37.424] No locals. [08:11:37.424] #6 0x000000000085d5eb in var_is_nonnullable (root=0x101fbb498ad8, var=var@entry=0x101fbbcc2f68, use_rel_info=false) at ../src/backend/optimizer/util/clauses.c:4235 [08:11:37.424] rte = [08:11:37.424] notnullattnums = 0x0 [08:11:37.424] #7 0x000000000085cf5d in eval_const_expressions_mutator (node=0x101fbbcc2ee8, context=) at ../src/backend/optimizer/util/clauses.c:3556 [08:11:37.424] varg = 0x101fbbcc2f68 [08:11:37.424] result = [08:11:37.424] ntest = 0x101fbbcc2ee8 [08:11:37.424] arg = 0x101fbbcc2f68 [08:11:37.424] newntest = [08:11:37.424] #8 0x000000000085f648 in simplify_and_arguments (args=, context=context@entry=0x821a1a9c8, haveNull=haveNull@entry=0x821a1a970, forceFalse=forceFalse@entry=0x821a1a984) at ../src/backend/optimizer/util/clauses.c:3964 [08:11:37.424] arg = 0x101fbbcc2ee8 [08:11:37.424] newargs = 0x101fbbcc30f8 [08:11:37.424] unprocessed_args = 0x0 [08:11:37.424] #9 0x000000000085ce63 in eval_const_expressions_mutator (node=0x101fbbcc2d28, context=) at ../src/backend/optimizer/util/clauses.c:2877 [08:11:37.424] haveNull = false [08:11:37.424] forceFalse = false [08:11:37.424] newargs = [08:11:37.424] expr = 0x101fbbcc2d28 [08:11:37.424] #10 0x000000000085be9b in eval_const_expressions (root=root@entry=0x101fbb498ad8, node=0x0, node@entry=0x101fbbcc2d28) at ../src/backend/optimizer/util/clauses.c:2272 [08:11:37.424] context = {boundParams = , root = 0x101fbb498ad8, active_fns = 0x0, case_val = 0x0, estimate = false} [08:11:37.424] #11 0x000000000084c89f in convert_EXISTS_sublink_to_join (root=0x101fbb498ad8, sublink=, under_not=false, available_rels=available_rels@entry=0x101fbbcc2148) at ../src/backend/optimizer/plan/subselect.c:1541 [08:11:37.424] je = [08:11:37.424] lc__state = {l = 0x101fbbcc2cd8, i = 0} [08:11:37.424] subroot = {type = T_Invalid, parse = 0xae94e9 , glob = 0x2d9b0a, query_level = 0, parent_root = 0x101fbb51a100, plan_params = 0x101fbb51ba48, outer_params = 0x200c1bd00, simple_rel_array = 0x0, simple_rel_array_size = -1152278272, simple_rte_array = 0x101fbb51a190, append_rel_array = 0x200000014, all_baserels = 0x0, outer_join_rels = 0x637ad65521a1ab50, all_query_rels = 0x101fbb51a190, join_rel_list = 0x14, join_rel_hash = 0x101fbb51ba48, join_rel_level = 0x821a1ab70, join_cur_level = 868602944, init_plans = 0x1, cte_plan_ids = 0x1, multiexpr_params = 0x821a1aae0, join_domains = 0xabd468 , eq_classes = 0xc1bd70 , ec_merging_done = false, canon_pathkeys = 0x101fbb498f38, left_join_clauses = 0x0, right_join_clauses = 0x821a1ab00, full_join_clauses = 0x53, join_info_list = 0x821a1ab60, last_rinfo_serial = 11419140, all_result_relids = 0x6183c0 , leaf_result_relids = 0xae977e , append_rel_list = 0x2, row_identity_vars = 0x0, rowMarks = 0x101fbb430c00, placeholder_list = 0x101fbb5b1e90, placeholder_array = 0x101fbb5b23a8, placeholder_array_size = 564243376, fkey_list = 0x101fbb51e100, query_pathkeys = 0x53, group_pathkeys = 0x121a1aba0, num_groupby_pathkeys = 0, window_pathkeys = 0xdb4a2aa321a1ab80, distinct_pathkeys = 0x0, sort_pathkeys = 0x4, setop_pathkeys = 0x101fbb5b1e48, part_schemes = 0x101fbb498f38, initial_rels = 0x0, upper_rels = {0xa9bb, 0x0, 0x821a1ad30, 0xacbb40 , 0x3000100000000, 0x3b600000000, 0xa3f2a0 , 0x10002000000b8}, upper_targets = {0x2, 0x0, 0x101fbb430c00, 0x0, 0xa9bb, 0x5000500000000, 0x3b600000000, 0x9f2610 }, processed_groupClause = 0x1000200000092, processed_distinctClause = 0x2, processed_tlist = 0x0, update_colnos = 0x101fbb430c00, grouping_map = 0x0, minmax_aggs = 0x0, planner_cxt = 0x3000900000000, total_table_pages = 5.6527952693433506e-317, tuple_fraction = 5.3084784504283567e-317, limit_tuples = 1.3907136014837293e-309, qual_security_level = 564243714, hasJoinRTEs = 8, hasLateralRTEs = false, hasHavingQual = false, hasPseudoConstantQuals = false, hasAlternativeSubPlans = 233, placeholdersFrozen = 148, hasRecursion = 174, group_rtindex = 0, agginfos = 0x101fbb430c00, aggtransinfos = 0x0, numOrderedAggs = -1152278272, hasNonPartialAggs = 31, hasNonSerialAggs = 16, wt_param_id = 564243844, non_recursive_path = 0x0, curOuterRels = 0x821a1ad18, curOuterParams = 0x101fbbc95100, isAltSubplan = 0x101fbb51a190, isUsedSubplan = 0x100000014, join_search_private = 0x0, partColsUpdated = 2, partPruneInfos = 0x101fbbc95190} [08:11:37.424] parse = 0x101fbbcbb1d8 [08:11:37.424] subselect = 0x101fbbc390c8 [08:11:37.424] newWhere = 0x0 [08:11:37.424] all_clauses = 0x101fbbcc2cd8 [08:11:37.424] upper_reference_exists = false [08:11:37.424] whereClause = 0x101fbbcc2d28 [08:11:37.424] lc = [08:11:37.424] rtoffset = [08:11:37.424] clause_varnos = [08:11:37.424] upper_varnos = [08:11:37.424] varno = [08:11:37.424] result = [08:11:37.424] #12 0x00000000008541a2 in pull_up_sublinks_qual_recurse (root=0x18da7, node=0x6, jtlink1=0x101fbb4985d0, available_rels1=0x101fbbcc2148, jtlink2=jtlink2@entry=0x0, available_rels2=available_rels2@entry=0x0) at ../src/backend/optimizer/prep/prepjointree.c:912 [08:11:37.424] child_rels = 0xb0211f [08:11:37.424] sublink = 0x6 [08:11:37.424] j = [08:11:37.424] #13 0x0000000000850f99 in pull_up_sublinks_jointree_recurse (root=root@entry=0x101fbb498ad8, jtnode=, relids=relids@entry=0x821a1ae20) at ../src/backend/optimizer/prep/prepjointree.c:787 [08:11:37.424] leftrelids = 0x101fbb498f88 [08:11:37.424] rightrelids = 0x101fbbcc2148 [08:11:37.424] jtlink = 0x101fbb4985b8 [08:11:37.424] j = 0x101fbb4985b8 [08:11:37.424] #14 0x0000000000850e45 in pull_up_sublinks_jointree_recurse (root=root@entry=0x101fbb498ad8, jtnode=0x101fbbcbbf18, relids=relids@entry=0x821a1ae60) at ../src/backend/optimizer/prep/prepjointree.c:706 [08:11:37.424] childrelids = 0x3 [08:11:37.424] newchild = [08:11:37.424] l__state = {l = 0x101fbbcd8698, i = 0} [08:11:37.424] jtlink = 0x3 [08:11:37.424] frelids = 0x0 [08:11:37.424] newf = [08:11:37.424] f = 0x101fbbcbbf18 [08:11:37.424] newfromlist = 0x0 [08:11:37.424] l = 0x8283e719a [08:11:37.424] #15 0x0000000000850d7a in pull_up_sublinks (root=0x18da7, root@entry=0x101fbb498ad8) at ../src/backend/optimizer/prep/prepjointree.c:653 [08:11:37.424] relids = 0x101fbbcbbf18 [08:11:37.424] jtnode = [08:11:37.424] #16 0x000000000083bf4a in subquery_planner (glob=glob@entry=0x101fbb46e6a8, parse=parse@entry=0x101fbbcbb1d8, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:757 [08:11:37.424] root = 0x101fbb498ad8 [08:11:37.424] hasOuterJoins = [08:11:37.424] hasResultRTEs = [08:11:37.424] l = [08:11:37.424] newWithCheckOptions = [08:11:37.424] newHaving = [08:11:37.424] final_rel = [08:11:37.424] #17 0x000000000083b6c2 in standard_planner (parse=parse@entry=0x101fbbcbb1d8, query_string=, cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:442 [08:11:37.424] glob = 0x101fbb46e6a8 [08:11:37.424] tuple_fraction = [08:11:37.424] root = [08:11:37.424] final_rel = [08:11:37.424] best_path = [08:11:37.424] top_plan = [08:11:37.424] lp = [08:11:37.424] lr = [08:11:37.424] result = [08:11:37.424] #18 0x0000000832924a07 in pgss_planner (parse=0x101fbbcbb1d8, query_string=0x101fbb422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=2048, boundParams=0x0) at ../contrib/pg_stat_statements/pg_stat_statements.c:983 [08:11:37.424] _local_sigjmp_buf = {{_sjb = {35208185975, 12688072, 34923982696, 34923983200, 0, 12694877, 12688064, 34923984144, 17728472679295, 83, 4859211856, 0}}} [08:11:37.424] _save_exception_stack = 0x821a1b510 [08:11:37.424] _save_context_stack = 0x0 [08:11:37.424] _do_rethrow = false [08:11:37.424] result = [08:11:37.424] #19 0x000000000083b547 in planner (parse=0x18da7, parse@entry=0x101fbbcbb1d8, query_string=0x6 , query_string@entry=0x101fbb422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=0, cursorOptions@entry=2048, boundParams=0x8283e719a , boundParams@entry=0x0) at ../src/backend/optimizer/plan/planner.c:299 [08:11:37.424] result = [08:11:37.424] #20 0x0000000000976f34 in pg_plan_query (querytree=querytree@entry=0x101fbbcbb1d8, query_string=query_string@entry=0x101fbb422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:900 [08:11:37.424] plan = [08:11:37.424] #21 0x0000000000700bba in standard_ExplainOneQuery (query=0x101fbbcbb1d8, cursorOptions=cursorOptions@entry=2048, into=into@entry=0x0, es=es@entry=0x101fbbc39038, queryString=0x101fbb422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., params=params@entry=0x0, queryEnv=0x0) at ../src/backend/commands/explain.c:353 [08:11:37.424] bufusage_start = {shared_blks_hit = 0, shared_blks_read = 17728473341512, shared_blks_dirtied = 17728473341512, shared_blks_written = 11542815, local_blks_hit = 240, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 17728473341512, temp_blks_read = 2, temp_blks_written = 17728480720592, shared_blk_read_time = {ticks = 34923983456}, shared_blk_write_time = {ticks = 6087130}, local_blk_read_time = {ticks = 70368744221115}, local_blk_write_time = {ticks = 17728480720512}, temp_blk_read_time = {ticks = 34923983632}, temp_blk_write_time = {ticks = 9529338}} [08:11:37.424] bufusage = {shared_blks_hit = 331, shared_blks_read = 378718169, shared_blks_dirtied = 34923983536, shared_blks_written = 17728472015944, local_blks_hit = 0, local_blks_read = 0, local_blks_dirtied = 17728480719104, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = -1}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 17728480719320}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 34923983600}, temp_blk_write_time = {ticks = 11581072}} [08:11:37.424] mem_counters = {nblocks = 34923983376, freechunks = 11542815, totalspace = 240, freespace = 17728473341512} [08:11:37.424] planduration = {ticks = 8355588} [08:11:37.424] planner_ctx = 0x0 [08:11:37.424] saved_ctx = [08:11:37.424] planstart = {ticks = -331378718169} [08:11:37.424] plan = [08:11:37.424] #22 0x0000000000700872 in ExplainOneQuery (query=0x18da7, cursorOptions=2048, into=0x0, es=0x101fbbc39038, pstate=0x101fbb430eb8, params=0x0) at ../src/backend/commands/explain.c:309 [08:11:37.424] No locals. [08:11:37.424] #23 ExplainQuery (pstate=pstate@entry=0x101fbb430eb8, stmt=stmt@entry=0x101fbbcbb1a8, params=params@entry=0x0, dest=0x101fbb430e28) at ../src/backend/commands/explain.c:223 [08:11:37.424] l__state = {l = , i = 0} [08:11:37.424] l = 0x101fbb498460 [08:11:37.424] es = 0x101fbbc39038 [08:11:37.424] jstate = [08:11:37.424] query = [08:11:37.424] rewritten = 0x101fbb498448 [08:11:37.424] tstate = [08:11:37.424] #24 0x000000000097e1a0 in standard_ProcessUtility (pstmt=pstmt@entry=0x101fbbcd8db8, queryString=queryString@entry=0x101fbb422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x101fbb430e28, qc=0x821a1b678) at ../src/backend/tcop/utility.c:866 [08:11:37.424] isAtomicContext = false [08:11:37.424] parsetree = 0x101fbbcbb1a8 [08:11:37.424] readonly_flags = [08:11:37.424] pstate = 0x101fbb430eb8 [08:11:37.424] isTopLevel = [08:11:37.424] #25 0x000000083292518f in pgss_ProcessUtility (pstmt=0x101fbbcd8db8, queryString=0x101fbb422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x101fbb430e28, qc=0x821a1b678) at ../contrib/pg_stat_statements/pg_stat_statements.c:1181 [08:11:37.424] _local_sigjmp_buf = {{_sjb = {35208188087, 34923984144, 34923983944, 34923984400, 0, 34923984560, 12688072, 331, 12583807, 12697040, 34923984384, 0}}} [08:11:37.424] _save_exception_stack = 0x821a1b6b0 [08:11:37.424] _save_context_stack = 0x0 [08:11:37.424] _do_rethrow = false [08:11:37.424] bufusage = {shared_blks_hit = 35208188087, shared_blks_read = 34923984144, shared_blks_dirtied = 34923983944, shared_blks_written = 34923984400, local_blks_hit = 0, local_blks_read = 34923984560, local_blks_dirtied = 12688072, local_blks_written = 331, temp_blks_read = 12583807, temp_blks_written = 12697040, shared_blk_read_time = {ticks = 34923984384}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 12697344}, local_blk_write_time = {ticks = 12573880}, temp_blk_read_time = {ticks = 17728480841144}, temp_blk_write_time = {ticks = 1}} [08:11:37.424] walusage_start = {wal_records = 60, wal_fpi = 0, wal_bytes = 6335, wal_buffers_full = 0} [08:11:37.424] duration = [08:11:37.424] bufusage_start = {shared_blks_hit = 6565, shared_blks_read = 130, shared_blks_dirtied = 14, shared_blks_written = 23, 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}} [08:11:37.424] walusage = {wal_records = 0, wal_fpi = 34923984180, wal_bytes = 34923984224, wal_buffers_full = 8399626} [08:11:37.424] start = {ticks = -331378301089} [08:11:37.424] rows = [08:11:37.424] saved_queryId = 3938666771540382425 [08:11:37.424] parsetree = [08:11:37.424] saved_stmt_location = 0 [08:11:37.424] saved_stmt_len = 204 [08:11:37.424] enabled = [08:11:37.424] #26 0x000000000097d96c in PortalRunUtility (portal=portal@entry=0x101fbb522100, pstmt=0x101fbbcd8db8, isTopLevel=, setHoldSnapshot=true, dest=dest@entry=0x101fbb430e28, qc=qc@entry=0x821a1b678) at ../src/backend/tcop/pquery.c:1153 [08:11:37.424] No locals. [08:11:37.424] #27 0x000000000097cbaa in FillPortalStore (portal=portal@entry=0x101fbb522100, isTopLevel=true) at ../src/backend/tcop/pquery.c:1026 [08:11:37.424] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:11:37.424] treceiver = 0x101fbb430e28 [08:11:37.424] #28 0x000000000097c8e4 in PortalRun (portal=portal@entry=0x101fbb522100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x101fbbcd8f18, altdest=altdest@entry=0x101fbbcd8f18, qc=qc@entry=0x821a1b7b0) at ../src/backend/tcop/pquery.c:760 [08:11:37.424] _local_sigjmp_buf = {{_sjb = {9947269, 17728472752384, 34923984552, 34923984800, 34923984560, 12688072, 34923984816, 12615016, 12583807, 0, 17728472744831, 17725330030592}}} [08:11:37.424] _save_exception_stack = 0x821a1b860 [08:11:37.424] _save_context_stack = 0x0 [08:11:37.424] _do_rethrow = false [08:11:37.424] saveTopTransactionResourceOwner = 0x101fbb56f8d8 [08:11:37.424] saveTopTransactionContext = 0x101fbb56b000 [08:11:37.424] saveActivePortal = 0x0 [08:11:37.424] saveResourceOwner = 0x101fbb56f8d8 [08:11:37.424] savePortalContext = 0x0 [08:11:37.424] saveMemoryContext = 0x101fbb56b000 [08:11:37.424] result = [08:11:37.424] nprocessed = [08:11:37.424] #29 0x000000000097b749 in exec_simple_query (query_string=query_string@entry=0x101fbb422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"...) at ../src/backend/tcop/postgres.c:1274 [08:11:37.424] cmdtaglen = 7 [08:11:37.424] snapshot_set = [08:11:37.424] per_parsetree_context = 0x0 [08:11:37.424] plantree_list = [08:11:37.424] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [08:11:37.424] format = 0 [08:11:37.424] parsetree = 0x101fbb55cdc8 [08:11:37.424] commandTag = [08:11:37.424] cmdtagname = [08:11:37.424] querytree_list = [08:11:37.424] portal = 0x101fbb522100 [08:11:37.424] receiver = 0x101fbbcd8f18 [08:11:37.424] parsetree_item__state = {l = 0x101fbb55dd80, i = 0} [08:11:37.424] msec_str = "\000\000\000\000\b", '\000' , "\270\241!\b\000\000\000U:>(\b\000\000" [08:11:37.424] dest = DestRemote [08:11:37.424] was_logged = [08:11:37.424] oldcontext = 0x101fbb56b000 [08:11:37.424] parsetree_list = 0x101fbb55dd80 [08:11:37.424] use_implicit_block = false [08:11:37.424] parsetree_item = 0x101fbb55dd98 [08:11:37.424] save_log_statement_stats = [08:11:37.424] #30 0x0000000000979195 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4763 [08:11:37.424] query_string = 0x101fbb422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"... [08:11:37.424] input_message = {data = 0x101fbb422100 "EXPLAIN (COSTS OFF)\nSELECT * FROM pred_tab t1\n LEFT JOIN pred_tab t2 ON EXISTS\n (SELECT 1 FROM pred_tab t3, pred_tab t4, pred_tab t5, pred_tab t6\n WHERE t1.a = t3.a AND t6.a IS NOT N"..., len = 206, maxlen = 1024, cursor = 206} [08:11:37.424] firstchar = [08:11:37.424] local_sigjmp_buf = {{_sjb = {9930123, 34923984992, 34923984984, 34923985584, 12489252, 12488984, 12696856, 12690788, 895, 0, 0, 34359738369}}} [08:11:37.424] send_ready_for_query = false [08:11:37.424] idle_in_transaction_timeout_enabled = false [08:11:37.424] idle_session_timeout_enabled = false [08:11:37.424] #31 0x0000000000973639 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [08:11:37.424] bsdata = [08:11:37.424] #32 0x00000000008c063b in postmaster_child_launch (child_type=B_BACKEND, child_slot=4, startup_data=startup_data@entry=0x821a1c518, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x821a1c530) at ../src/backend/postmaster/launch_backend.c:290 [08:11:37.424] pid = [08:11:37.424] #33 0x00000000008c5008 in BackendStartup (client_sock=0x821a1c530) at ../src/backend/postmaster/postmaster.c:3590 [08:11:37.424] startup_data = {canAcceptConnections = CAC_OK, socket_created = 809597248065048, fork_started = } [08:11:37.424] bn = 0x101fbb55be48 [08:11:37.424] cac = CAC_OK [08:11:37.424] pid = [08:11:37.424] __error = [08:11:37.424] save_errno = [08:11:37.424] __error = [08:11:37.424] __error = [08:11:37.424] #34 ServerLoop () at ../src/backend/postmaster/postmaster.c:1705 [08:11:37.424] s = {sock = 7, raddr = {addr = {ss_len = 16 '\020', ss_family = 1 '\001', __ss_pad1 = "\000\000\000\000\000", __ss_align = 0, __ss_pad2 = "\r", '\000' , "\220š!\b\000\000\000XF\024)\b\000\000\000w\000\000\000\000\000\000\000\276\316\024)\b", '\000' , "\320š!\b\000\000\000\204\003\214\000\000\000\000\000\340š!\b", '\000' }, salen = 16}} [08:11:37.424] i = 0 [08:11:37.424] now = [08:11:37.424] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 674805132, user_data = 0x0}, {pos = 564249824, events = 8, fd = -1152809512, user_data = 0x821a1c370}, {pos = 0, events = 0, fd = 0, user_data = 0x821a1bfd0}, {pos = 1696805581, events = 2014, fd = 673962936, user_data = 0x8282d009c}, {pos = 564248552, events = 8, fd = 564248672, user_data = 0x821a1c000}, {pos = 1696805581, events = 2014, fd = 673959792, user_data = 0x8282d009c}, {pos = 564248600, events = 8, fd = 564248720, user_data = 0x8282c8dc4}, {pos = 674008516, events = 8, fd = 564248640, user_data = 0x7de652332cd}, {pos = 673977360, events = 8, fd = 674037916, user_data = 0x821a1c058}, {pos = 564248784, events = 8, fd = 674011444, user_data = 0x8282c9934}, {pos = -1157585912, events = 4127, fd = 3, user_data = 0x821a1c0c0}, {pos = 1696785659, events = 2014, fd = 564248784, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x821a1c118}, {pos = 564249320, events = 8, fd = 564248832, user_data = 0x7de65232c52}, {pos = 2711754, events = 0, fd = -1157564472, user_data = 0x0}, {pos = 0, events = 0, fd = 564248920, user_data = 0x821a1c328}, {pos = 564248896, events = 8, fd = 1696803922, user_data = 0x29bf37}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x101fbb010050}, {pos = 1, events = 8, fd = 0, user_data = 0x0}, {pos = 564249640, events = 8, fd = 1, user_data = 0x821a1c378}, {pos = -1157564376, events = 4127, fd = 656, user_data = 0x821a1c328}, {pos = 564248920, events = 8, fd = 564249024, user_data = 0x7de65232acb}, {pos = 564249576, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1157562288, user_data = 0x1}, {pos = -1157585912, events = 4127, fd = 673977360, user_data = 0x821a1c428}, {pos = 564249464, events = 8, fd = 564249040, user_data = 0x0}, {pos = -1157615608, events = 4127, fd = 33, user_data = 0x821a1c360}, {pos = 1696779383, events = 2014, fd = -1157615608, user_data = 0x101fbb003408}, {pos = -1157613560, events = 4127, fd = -1157612536, user_data = 0x101fbb007008}, {pos = -1157598200, events = 4127, fd = -1157597176, user_data = 0x101fbb007c08}, {pos = -1157595128, events = 4127, fd = -1157594104, user_data = 0x101fbb008808}, {pos = -1157592056, events = 4127, fd = -1157591032, user_data = 0x101fbb009408}, {pos = -1157588984, events = 4127, fd = -1157587960, user_data = 0x101fbb00a008}, {pos = -1157585912, events = 4127, fd = -1157584888, user_data = 0x101fbb00ac08}, {pos = -1157582840, events = 4127, fd = -1157581816, user_data = 0x101fbb00b808}, {pos = -1157579768, events = 4127, fd = -1157578744, user_data = 0x101fbb00c408}, {pos = -1157576696, events = 4127, fd = -1157575672, user_data = 0x101fbb00e008}, {pos = -1157569528, events = 4127, fd = -1157568504, user_data = 0x101fbb00ec08}, {pos = -1157557240, events = 4127, fd = 228631000, user_data = 0x101fbb003008}, {pos = 2735927, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -1157562288, events = 4127, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 564249640, user_data = 0x821a1c1d0}, {pos = 33, events = 33, fd = -1157615608, user_data = 0x378}, {pos = 2113896, events = 0, fd = 296, user_data = 0x101fbb010050}, {pos = 564249616, events = 8, fd = 1696778113, user_data = 0x101fbb431000}, {pos = 2735927, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -1157562288, events = 4127, fd = 1, user_data = 0x101fbb00a408}, {pos = 12576672, events = 0, fd = 675172112, user_data = 0x101fbb003008}, {pos = 2840040, events = 0, fd = 689226937, user_data = 0x1}, {pos = -1153359872, events = 4127, fd = 564249616, user_data = 0x82914b642}, {pos = 675172112, events = 8, fd = 12576672, user_data = 0x8283e4f10 }, {pos = -1157585912, events = 4127, fd = 564249840, user_data = 0x7de6522c574}, {pos = 564249696, events = 8, fd = 1, user_data = 0x7de6522c3ee}, {pos = -1157615608, events = 4127, fd = 564249624, user_data = 0x821a1c4f0}, {pos = 6792, events = 0, fd = 12, user_data = 0x7de652403a0}, {pos = 0, events = 0, fd = -1153301633, user_data = 0xc1bd10 }, {pos = 564249760, events = 8, fd = 689186144, user_data = 0x8284894b0 <__thr_jtable>}, {pos = 675854240, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 564249808, events = 8, fd = 689186144, user_data = 0x8284894b0 <__thr_jtable>}, {pos = 675854240, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 564249856, events = 8, fd = 689228541, user_data = 0x101fbb412000}, {pos = 26481, events = 0, fd = 564249952, user_data = 0x8291449ea}} [08:11:37.424] last_touch_time = 1756281828 [08:11:37.424] last_lockfile_recheck_time = 1756282008 [08:11:37.424] nevents = 1 [08:11:37.424] #35 0x00000000008c2dbf in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821a1cb70) at ../src/backend/postmaster/postmaster.c:1403 [08:11:37.424] userDoption = [08:11:37.424] listen_addr_saved = false [08:11:37.424] output_config_variable = [08:11:37.424] opt = [08:11:37.424] status = [08:11:37.424] #36 0x00000000007f5590 in main (argc=4, argv=0x821a1cb70) at ../src/backend/main/main.c:231 [08:11:37.424] do_check_root = [08:11:37.424] dispatch_option = DISPATCH_POSTMASTER