[06:34:57.820] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [06:34:58.246] dumping /tmp/cores/postgres.14550.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:34:58.382] [New LWP 100097] [06:34:58.552] Core was generated by `postgres: cascade: startup recovering 000000020000000000000004'. [06:34:58.552] Program terminated with signal SIGQUIT, Quit. [06:34:58.552] Sent by thr_kill() from pid 14550 and user 1003. [06:34:58.552] #0 0x000000082b5fa8fa in _sigprocmask () from /lib/libc.so.7 [06:34:58.608] [06:34:58.608] Thread 1 (LWP 100097): [06:34:58.608] #0 0x000000082b5fa8fa in _sigprocmask () from /lib/libc.so.7 [06:34:58.608] No symbol table info available. [06:34:58.608] #1 0x000000082b633f91 in _system () from /lib/libc.so.7 [06:34:58.608] No symbol table info available. [06:34:58.608] #2 0x00000008292499d3 in ?? () from /lib/libthr.so.3 [06:34:58.608] No symbol table info available. [06:34:58.608] #3 0x000000000066c945 in RestoreArchivedFile (path=path@entry=0x82136e1d0 "pg_wal/00000002", '0' , "4", xlogfname=xlogfname@entry=0x82136e5d0 "00000003.history", recovername=, expectedSize=expectedSize@entry=0, cleanupEnabled=) at ../src/backend/access/transam/xlogarchive.c:177 [06:34:58.608] xlogpath = "pg_wal/RECOVERYHISTORY", '\000' , "\200\t\3405\b\000\000\000\210\3466!\b\000\000\0009\000\000\000\000\000\000\000\000\000\344\000\000\000\000\000\000\020\n\000\000\000\000\000\200\315\3405\b\000\000\00084\0337\b\000\000\000X3\0337\b\000\000\000P3\0337\b\000\000\000P.\0337\b\000\000\000\000\340\344\000\000\000\000\000\000 [6\b\000\000\000\000\020\n\000\000\000\000\000 \3356!\b\000\000\000 \3356!\b", '\000' , "\350\3366!\b\000\000\000h\3356!\b\000\000\000\b\000\000\0000\000\000\000"... [06:34:58.608] lastRestartPointFname = '0' , "\000\000\000\000\000\000\000\000\030\000\000\0000\000\000\000\260\3346!\b\000\000\000`\3326!\b", '\000' , "\240\306j+\b\000\000\000\210C\274\000\000\000\000\000\370\250\3733\b\000\000\000s\000\000\000\000\000\000\000T\266\032\000\000\000\000\000\001\000\000\000\000\000\000\000\200\201\000\000\353\003\000\000\354\003\000\000\000\000\000\000eq5\000\000\000\000\000\241\271\357f\000\000\000\000\330(\202\004\000\000\000\000\241\271\357f\000\000\000\000(o\202\004\000\000\000\000\241\271\357f\000\000\000\000"... [06:34:58.608] stat_buf = {st_dev = 90112, st_ino = 2, st_nlink = 34916983232, st_mode = 29443, st_padding0 = 174, st_uid = 0, st_gid = 557244864, st_padding1 = 8, st_rdev = 35086882279, st_atim = {tv_sec = 16394, tv_nsec = 3}, st_mtim = {tv_sec = 35328769924, tv_nsec = 28560}, st_ctim = {tv_sec = -72340172838076673, tv_nsec = -9187201950435737472}, st_birthtim = {tv_sec = 1709929087852544534, tv_nsec = 34916983216}, st_size = 6, st_blocks = 0, st_blksize = 78, st_flags = 0, st_gen = 35088156320, st_spare = {34916983152, 35087407791, 1726986658, 1314184075572706965, 1709929087852544534, 2, 0, 34916983216, 206158430240, 34916983248}} [06:34:58.608] restartRedoPtr = 34916982976 [06:34:58.608] restartTli = 8 [06:34:58.608] restartSegNo = [06:34:58.608] xlogRestoreCmd = 0x83657b438 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline/data/t_025_stuck_on_old_timeline_primary_data/archives/00000003.history\" \"pg_wal/RECOVERYHISTORY\"" [06:34:58.608] rc = [06:34:58.608] #4 0x00000000006539d8 in existsTimeLineHistory (probeTLI=probeTLI@entry=3) at ../src/backend/access/transam/timeline.c:235 [06:34:58.608] path = "pg_wal/00000002", '0' , "4\000\b\004\377!\b\000\000\000\310\004", '\000' , "HE\274\000\000\000\000\000\260\230_+\b\000\000\000x=N+\b\000\000\000\026\002\217 r\343\272\027\220\220\3733\b", '\000' , "\330X\3405\b\000\000\000\200\t\3405\b", '\000' , "0\3466!\b\000\000\000HMf+\b\000\000\000\000\020\000\000\000\000\000\000@", '\000' , "9\000\000\000\000\000\000\000\337\3466!\b\000\000\000\207\3466!\b", '\000' ... [06:34:58.608] histfname = "00000003.history\000\3466!\b\000\000\000\177\000\221\000\000\000\000\000\377\377\377\377\377\377\377\377\000\000\000\000\000\000\000\000\026\002\217 r\343\272\027\000\000\000\000\000\000\000" [06:34:58.608] fd = [06:34:58.608] #5 0x0000000000653a98 in findNewestTimeLine (startTLI=startTLI@entry=2) at ../src/backend/access/transam/timeline.c:277 [06:34:58.608] newestTLI = 2 [06:34:58.608] probeTLI = 3 [06:34:58.608] #6 0x0000000000677ecb in rescanLatestTimeLine (replayTLI=replayTLI@entry=2, replayLSN=replayLSN@entry=67205488) at ../src/backend/access/transam/xlogrecovery.c:4125 [06:34:58.608] oldtarget = 2 [06:34:58.608] currentTle = 0x0 [06:34:58.608] newtarget = [06:34:58.608] newExpectedTLEs = [06:34:58.608] found = [06:34:58.608] cell = [06:34:58.608] #7 0x00000000006740b3 in WaitForWALToBecomeAvailable (RecPtr=67205512, tliRecPtr=67205488, replayTLI=2, replayLSN=67205488, randAccess=, fetching_ckpt=, nonblocking=) at ../src/backend/access/transam/xlogrecovery.c:3687 [06:34:58.608] startWalReceiver = false [06:34:58.608] streaming_reply_sent = true [06:34:58.608] now = [06:34:58.608] startWalReceiver = [06:34:58.608] oldSource = [06:34:58.608] wait_time = [06:34:58.608] __error = [06:34:58.608] __error = [06:34:58.608] __error = [06:34:58.608] havedata = [06:34:58.608] ptr = [06:34:58.608] tli = [06:34:58.608] __error = [06:34:58.608] latestChunkStart = [06:34:58.608] __error = [06:34:58.608] #8 XLogPageRead (xlogreader=0x83648d130, targetPagePtr=67198976, reqLen=6536, targetRecPtr=67205488, readBuf=0x836577af8 "\027\321\006") at ../src/backend/access/transam/xlogrecovery.c:3364 [06:34:58.608] private = 0x83648d110 [06:34:58.608] emode = 15 [06:34:58.608] targetSegNo = 4 [06:34:58.608] targetPageOff = 90112 [06:34:58.608] r = [06:34:58.608] #9 0x000000000067ae12 in ReadPageInternal (state=state@entry=0x83648d130, pageptr=67198976, reqLen=6536) at ../src/backend/access/transam/xlogreader.c:1060 [06:34:58.608] targetSegNo = 4 [06:34:58.608] targetPageOff = 90112 [06:34:58.608] readLen = [06:34:58.608] hdr = [06:34:58.608] err = [06:34:58.608] #10 0x0000000000679c82 in XLogDecodeNextRecord (state=0x83648d130, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:597 [06:34:58.608] errormsg = 0x821372c98 "" [06:34:58.608] randAccess = [06:34:58.608] decoded = 0x0 [06:34:58.608] RecPtr = 67205488 [06:34:58.608] assembled = false [06:34:58.608] targetPagePtr = 34916980672 [06:34:58.608] readOff = [06:34:58.608] record = [06:34:58.608] gotheader = [06:34:58.608] targetRecOff = 6512 [06:34:58.608] pageHeaderSize = [06:34:58.608] len = [06:34:58.608] total_len = [06:34:58.608] buffer = [06:34:58.608] gotlen = [06:34:58.608] pageHeader = [06:34:58.608] contdata = [06:34:58.608] save_copy = [06:34:58.608] #11 XLogReadAhead (state=0x83648d130, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:973 [06:34:58.608] result = [06:34:58.608] #12 0x0000000000671368 in XLogPrefetcherNextBlock (pgsr_private=35271449352, lsn=0x8365a8298) at ../src/backend/access/transam/xlogprefetcher.c:490 [06:34:58.608] nonblocking = false [06:34:58.608] record = 0x0 [06:34:58.608] prefetcher = 0x836579b08 [06:34:58.608] reader = 0x83648d130 [06:34:58.608] replaying_lsn = 67205080 [06:34:58.608] #13 0x0000000000670fd2 in lrq_prefetch (lrq=0x8365a8028) at ../src/backend/access/transam/xlogprefetcher.c:252 [06:34:58.608] No locals. [06:34:58.608] #14 lrq_complete_lsn (lrq=0x8365a8028, lsn=) at ../src/backend/access/transam/xlogprefetcher.c:290 [06:34:58.608] No locals. [06:34:58.608] #15 XLogPrefetcherReadRecord (prefetcher=prefetcher@entry=0x836579b08, errmsg=errmsg@entry=0x821372d60) at ../src/backend/access/transam/xlogprefetcher.c:1035 [06:34:58.608] replayed_up_to = [06:34:58.608] record = [06:34:58.608] #16 0x0000000000674afa in ReadRecord (xlogprefetcher=0x836579b08, emode=emode@entry=15, fetching_ckpt=false, replayTLI=replayTLI@entry=2) at ../src/backend/access/transam/xlogrecovery.c:3164 [06:34:58.608] errormsg = 0x83648d940 "" [06:34:58.608] xlogreader = 0x83648d130 [06:34:58.608] private = [06:34:58.608] record = [06:34:58.608] #17 0x00000000006753d9 in PerformWalRecovery () at ../src/backend/access/transam/xlogrecovery.c:1843 [06:34:58.608] ru0 = {tv = {tv_sec = 1726986657, tv_usec = 250606}, ru = {ru_utime = {tv_sec = 0, tv_usec = 0}, ru_stime = {tv_sec = 0, tv_usec = 1229}, ru_maxrss = 0, ru_ixrss = 0, ru_idrss = 0, ru_isrss = 0, ru_minflt = 146, ru_majflt = 0, ru_nswap = 0, ru_inblock = 0, ru_oublock = 0, ru_msgsnd = 0, ru_msgrcv = 0, ru_nsignals = 0, ru_nvcsw = 12, ru_nivcsw = 2}} [06:34:58.608] xtime = [06:34:58.608] reachedRecoveryTarget = false [06:34:58.608] replayTLI = 2 [06:34:58.608] record = [06:34:58.608] #18 0x0000000000665c93 in StartupXLOG () at ../src/backend/access/transam/xlog.c:5841 [06:34:58.609] wasShutdown = false [06:34:58.609] haveTblspcMap = false [06:34:58.609] haveBackupLabel = true [06:34:58.609] promoted = false [06:34:58.609] didCrash = [06:34:58.609] checkPoint = {redo = 33554472, ThisTimeLineID = 1, PrevTimeLineID = , fullPageWrites = true, wal_level = , nextXid = {value = }, nextOid = , nextMulti = , nextMultiOffset = , oldestXid = , oldestXidDB = 1, oldestMulti = , oldestMultiDB = , time = , oldestCommitTsXid = 0, newestCommitTsXid = 0, oldestActiveXid = 741} [06:34:58.609] oldestActiveXID = [06:34:58.609] performedWalRecovery = [06:34:58.609] endOfRecoveryInfo = [06:34:58.609] EndOfLog = [06:34:58.609] EndOfLogTLI = [06:34:58.609] abortedRecPtr = [06:34:58.609] missingContrecPtr = [06:34:58.609] newTLI = [06:34:58.609] Insert = [06:34:58.609] #19 0x000000000089913b in StartupProcessMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/startup.c:258 [06:34:58.609] No locals. [06:34:58.609] #20 0x0000000000892e97 in postmaster_child_launch (child_type=child_type@entry=B_STARTUP, 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:274 [06:34:58.609] pid = [06:34:58.609] #21 0x0000000000895404 in StartChildProcess (type=B_AUTOVAC_WORKER, type@entry=B_STARTUP) at ../src/backend/postmaster/postmaster.c:3736 [06:34:58.609] pid = [06:34:58.609] __error = [06:34:58.609] #22 0x0000000000895045 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8213781c8) at ../src/backend/postmaster/postmaster.c:1343 [06:34:58.609] userDoption = [06:34:58.609] listen_addr_saved = [06:34:58.609] output_config_variable = [06:34:58.609] opt = [06:34:58.609] status = [06:34:58.609] #23 0x00000000007cec1c in main (argc=4, argv=0x8213781c8) at ../src/backend/main/main.c:197 [06:34:58.609] do_check_root = [06:34:58.620] [06:34:58.620] [06:34:58.620] [06:34:58.688] dumping /tmp/cores/postgres.22002.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [06:34:58.812] [New LWP 101858] [06:34:58.888] Core was generated by `postgres: primary: postgres regression [local] EXECUTE'. [06:34:58.888] Program terminated with signal SIGABRT, Aborted. [06:34:58.888] Sent by thr_kill() from pid 22002 and user 1003. [06:34:58.888] #0 0x000000082df2841a in thr_kill () from /lib/libc.so.7 [06:34:59.506] [06:34:59.506] Thread 1 (LWP 101858): [06:34:59.506] #0 0x000000082df2841a in thr_kill () from /lib/libc.so.7 [06:34:59.506] No symbol table info available. [06:34:59.506] #1 0x000000082dea1e64 in raise () from /lib/libc.so.7 [06:34:59.506] No symbol table info available. [06:34:59.506] #2 0x000000082df526f9 in abort () from /lib/libc.so.7 [06:34:59.506] No symbol table info available. [06:34:59.506] #3 0x0000000000a98945 in ExceptionalCondition (conditionName=0x343f42 "!IsQueryIdEnabled() || pgstat_get_my_query_id() != 0", fileName=, lineNumber=lineNumber@entry=369) at ../src/backend/utils/error/assert.c:66 [06:34:59.506] No locals. [06:34:59.506] #4 0x000000000076b3da in ExecutorRun (queryDesc=0x83ffd06e8, direction=ForwardScanDirection, count=2, execute_once=true) at ../src/backend/executor/execMain.c:369 [06:34:59.506] No locals. [06:34:59.506] #5 0x0000000000711669 in ExecuteLetStmt (pstate=pstate@entry=0x8376bf038, stmt=stmt@entry=0x83ff97660, params=params@entry=0x837557f08, queryEnv=queryEnv@entry=0x0, qc=0x820c11290) at ../src/backend/commands/session_variable.c:1400 [06:34:59.506] query = [06:34:59.506] varid = [06:34:59.506] aclresult = [06:34:59.506] dest = 0x83ff90fa8 [06:34:59.506] rewritten = [06:34:59.506] plan = 0x83ffd0268 [06:34:59.506] queryDesc = 0x83ffd06e8 [06:34:59.506] #6 0x0000000000943735 in standard_ProcessUtility (pstmt=0x83ff97550, queryString=queryString@entry=0x83ff97500 "PREPARE p1(numeric) AS LET var1 = $1;", readOnlyTree=, context=PROCESS_UTILITY_QUERY, params=0x837557f08, queryEnv=0x0, dest=0x83ffa62f8, qc=0x820c11290) at ../src/backend/tcop/utility.c:1070 [06:34:59.506] isAtomicContext = true [06:34:59.506] parsetree = 0x83ff97660 [06:34:59.506] readonly_flags = [06:34:59.506] pstate = 0x8376bf038 [06:34:59.506] isTopLevel = [06:34:59.506] #7 0x000000083b281dee in pgss_ProcessUtility (pstmt=0x83ff961a0, queryString=0x83ff97500 "PREPARE p1(numeric) AS LET var1 = $1;", readOnlyTree=, context=PROCESS_UTILITY_QUERY, params=0x837557f08, queryEnv=0x0, dest=0x83ffa62f8, qc=0x820c11290) at ../contrib/pg_stat_statements/pg_stat_statements.c:1160 [06:34:59.506] _local_sigjmp_buf = {{_sjb = {35352223015, 34909260576, 34909260440, 34909260896, 35433046432, 0, 12410920, 34909261104, 3620078463, -2, -16, 34359738368}}} [06:34:59.506] _save_exception_stack = 0x820c10d30 [06:34:59.506] _save_context_stack = 0x0 [06:34:59.506] _do_rethrow = false [06:34:59.506] bufusage = {shared_blks_hit = 35352223015, shared_blks_read = 34909260576, shared_blks_dirtied = 34909260440, shared_blks_written = 34909260896, local_blks_hit = 35433046432, local_blks_read = 0, local_blks_dirtied = 12410920, local_blks_written = 34909261104, temp_blks_read = 3620078463, temp_blks_written = -2, shared_blk_read_time = {ticks = -16}, shared_blk_write_time = {ticks = 34359738368}, local_blk_read_time = {ticks = 4264008352388602112}, local_blk_write_time = {ticks = 12419960}, temp_blk_read_time = {ticks = 35356715264}, temp_blk_write_time = {ticks = 12373504}} [06:34:59.506] walusage_start = {wal_records = 2716, wal_fpi = 6, wal_bytes = 260294} [06:34:59.506] duration = [06:34:59.506] bufusage_start = {shared_blks_hit = 36379, shared_blks_read = 3064, shared_blks_dirtied = 614, shared_blks_written = 717, 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}} [06:34:59.506] walusage = {wal_records = 20, wal_fpi = 1024, wal_bytes = 35248911472} [06:34:59.506] start = {ticks = -233928458747} [06:34:59.506] rows = [06:34:59.506] saved_queryId = 14011065068311194102 [06:34:59.506] parsetree = [06:34:59.506] saved_stmt_location = 0 [06:34:59.506] saved_stmt_len = 36 [06:34:59.506] enabled = [06:34:59.506] #8 0x00000000009430a3 in PortalRunUtility (portal=0x83759c210, pstmt=0x83ff961a0, isTopLevel=, setHoldSnapshot=, dest=0x83ffa62f8, qc=0x820c11290) at ../src/backend/tcop/pquery.c:1161 [06:34:59.506] No locals. [06:34:59.506] #9 0x0000000000942734 in PortalRunMulti (portal=portal@entry=0x83759c210, isTopLevel=false, setHoldSnapshot=false, dest=dest@entry=0x83ffa62f8, altdest=altdest@entry=0x83ffa62f8, qc=0x820c11290) at ../src/backend/tcop/pquery.c:1326 [06:34:59.506] pstmt = 0x83ff961a0 [06:34:59.506] stmtlist_item__state = {l = 0x83ff96150, i = 0} [06:34:59.506] active_snapshot_set = false [06:34:59.506] stmtlist_item = 0x83ff96168 [06:34:59.506] #10 0x0000000000942003 in PortalRun (portal=portal@entry=0x83759c210, count=count@entry=9223372036854775807, isTopLevel=false, run_once=true, dest=dest@entry=0x83ffa62f8, altdest=altdest@entry=0x83ffa62f8, qc=0x820c11290) at ../src/backend/tcop/pquery.c:794 [06:34:59.506] _local_sigjmp_buf = {{_sjb = {9707389, 35288367632, 34909261096, 34909261328, 34909261104, 35433023488, 12377560, 12410920, 34909258623, 11310896, 34909261248, 0}}} [06:34:59.506] _save_exception_stack = 0x820c10f00 [06:34:59.506] _save_context_stack = 0x0 [06:34:59.506] _do_rethrow = false [06:34:59.506] saveTopTransactionResourceOwner = 0x8375eaad8 [06:34:59.506] saveTopTransactionContext = 0x8375b3000 [06:34:59.506] saveActivePortal = 0x83759c100 [06:34:59.506] saveResourceOwner = 0x8376b6538 [06:34:59.506] savePortalContext = 0x83ff90800 [06:34:59.506] saveMemoryContext = 0x83ff90800 [06:34:59.506] result = [06:34:59.506] nprocessed = [06:34:59.506] #11 0x00000000007074ea in ExecuteQuery (pstate=pstate@entry=0x83ff90900, stmt=stmt@entry=0x83ffa5fc8, intoClause=intoClause@entry=0x0, params=params@entry=0x0, dest=0x83ffa62f8, qc=0x820c11290) at ../src/backend/commands/prepare.c:255 [06:34:59.506] paramLI = 0x837557f08 [06:34:59.506] estate = 0x83ff65100 [06:34:59.506] entry = 0x83ffa3ce0 [06:34:59.506] portal = 0x83759c210 [06:34:59.506] query_string = [06:34:59.506] cplan = [06:34:59.506] plan_list = [06:34:59.506] eflags = 0 [06:34:59.506] count = 9223372036854775807 [06:34:59.506] #12 0x0000000000943d42 in standard_ProcessUtility (pstmt=pstmt@entry=0x8374f77c0, queryString=queryString@entry=0x8374f6100 "EXECUTE p1(pi() + 100);", readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0x83ffa62f8, qc=0x820c11290) at ../src/backend/tcop/utility.c:754 [06:34:59.506] isAtomicContext = false [06:34:59.506] parsetree = 0x83ffa5fc8 [06:34:59.506] readonly_flags = [06:34:59.506] pstate = 0x83ff90900 [06:34:59.506] isTopLevel = [06:34:59.506] #13 0x000000083b281d8c in pgss_ProcessUtility (pstmt=0x8374f77c0, queryString=0x8374f6100 "EXECUTE p1(pi() + 100);", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x83ffa62f8, qc=0x820c11290) at ../contrib/pg_stat_statements/pg_stat_statements.c:1241 [06:34:59.506] _local_sigjmp_buf = {{_sjb = {35352222716, 0, 34909261560, 34909262016, 12410920, 34909262224, 12410912, 4294967295, 34909258623, 11856519, 16, 8589934592}}} [06:34:59.506] _save_exception_stack = 0x820c11190 [06:34:59.506] _save_context_stack = 0x0 [06:34:59.506] _do_rethrow = false [06:34:59.506] bump_level = [06:34:59.506] saved_queryId = [06:34:59.506] parsetree = [06:34:59.506] saved_stmt_location = [06:34:59.506] saved_stmt_len = [06:34:59.506] enabled = [06:34:59.506] #14 0x00000000009430a3 in PortalRunUtility (portal=0x83759c100, pstmt=0x8374f77c0, isTopLevel=, setHoldSnapshot=, dest=0x83ffa62f8, qc=0x820c11290) at ../src/backend/tcop/pquery.c:1161 [06:34:59.506] No locals. [06:34:59.506] #15 0x0000000000942734 in PortalRunMulti (portal=portal@entry=0x83759c100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x83ffa62f8, altdest=altdest@entry=0x83ffa62f8, qc=0x820c11290) at ../src/backend/tcop/pquery.c:1326 [06:34:59.506] pstmt = 0x8374f77c0 [06:34:59.506] stmtlist_item__state = {l = 0x83ffa62a8, i = 0} [06:34:59.506] active_snapshot_set = false [06:34:59.506] stmtlist_item = 0x83ffa62c0 [06:34:59.506] #16 0x0000000000942003 in PortalRun (portal=portal@entry=0x83759c100, count=count@entry=9223372036854775807, isTopLevel=true, run_once=true, dest=dest@entry=0x83ffa62f8, altdest=altdest@entry=0x83ffa62f8, qc=0x820c11290) at ../src/backend/tcop/pquery.c:794 [06:34:59.506] _local_sigjmp_buf = {{_sjb = {9707389, 35288367360, 34909262216, 34909262448, 34909262224, 35288461312, 12377560, 12410920, 35288318847, 35287694480, 4294967984, 0}}} [06:34:59.506] _save_exception_stack = 0x820c11360 [06:34:59.506] _save_context_stack = 0x0 [06:34:59.506] _do_rethrow = false [06:34:59.506] saveTopTransactionResourceOwner = 0x8375eaad8 [06:34:59.506] saveTopTransactionContext = 0x8375b3000 [06:34:59.506] saveActivePortal = 0x0 [06:34:59.506] saveResourceOwner = 0x8375eaad8 [06:34:59.506] savePortalContext = 0x0 [06:34:59.506] saveMemoryContext = 0x8375b3000 [06:34:59.506] result = [06:34:59.506] nprocessed = [06:34:59.506] #17 0x0000000000940e82 in exec_simple_query (query_string=query_string@entry=0x8374f6100 "EXECUTE p1(pi() + 100);") at ../src/backend/tcop/postgres.c:1284 [06:34:59.506] cmdtaglen = 7 [06:34:59.506] snapshot_set = [06:34:59.506] per_parsetree_context = 0x0 [06:34:59.506] plantree_list = [06:34:59.506] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [06:34:59.506] format = 0 [06:34:59.506] parsetree = 0x8374f74b0 [06:34:59.506] commandTag = [06:34:59.506] cmdtagname = [06:34:59.506] querytree_list = [06:34:59.506] portal = 0x83759c100 [06:34:59.506] receiver = 0x83ffa62f8 [06:34:59.506] parsetree_item__state = {l = 0x8374f7770, i = 0} [06:34:59.506] msec_str = "\000\000\000\000\b", '\000' , "۹\357f\000\000\000\000\375\242!jU\277\245", [06:34:59.506] dest = DestRemote [06:34:59.506] was_logged = [06:34:59.506] oldcontext = 0x8375b3000 [06:34:59.506] parsetree_list = 0x8374f7770 [06:34:59.506] use_implicit_block = false [06:34:59.506] parsetree_item = 0x8374f7788 [06:34:59.506] save_log_statement_stats = [06:34:59.506] #18 0x000000000093eaf3 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4789 [06:34:59.506] query_string = 0x8374f6100 "EXECUTE p1(pi() + 100);" [06:34:59.506] input_message = {data = 0x8374f6100 "EXECUTE p1(pi() + 100);", len = 24, maxlen = 1024, cursor = 24} [06:34:59.506] firstchar = [06:34:59.506] local_sigjmp_buf = {{_sjb = {9691046, 34909262688, 34909262648, 34909263232, 12419656, 1, 8192, 8388608, 895, 0, 0, 34359738369}}} [06:34:59.506] send_ready_for_query = false [06:34:59.506] idle_in_transaction_timeout_enabled = false [06:34:59.506] idle_session_timeout_enabled = false [06:34:59.506] #19 0x00000000009392c9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:107 [06:34:59.506] bsdata = [06:34:59.506] #20 0x0000000000892e97 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x820c120a4 "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x820c11fe0) at ../src/backend/postmaster/launch_backend.c:274 [06:34:59.506] pid = [06:34:59.506] #21 0x0000000000897268 in BackendStartup (client_sock=0x820c11fe0) at ../src/backend/postmaster/postmaster.c:3420 [06:34:59.506] startup_data = {canAcceptConnections = CAC_OK} [06:34:59.506] bn = 0x8375026c8 [06:34:59.506] pid = [06:34:59.506] __error = [06:34:59.506] save_errno = [06:34:59.506] __error = [06:34:59.506] __error = [06:34:59.506] #22 ServerLoop () at ../src/backend/postmaster/postmaster.c:1653 [06:34:59.506] 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 = " lO7\b", '\000' , "@ \301 \b\000\000\000h\265\367+\b\000\000\000\v\000\000\000\000\000\000\000^?\370+\b", '\000' , "\200 \301 \b\000\000\000D,\211\000\000\000\000\000\220 \301 \b", '\000' }, salen = 16}} [06:34:59.506] i = 0 [06:34:59.506] now = [06:34:59.506] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 770493570, events = 8, fd = 0, user_data = 0x820c11f90}, {pos = 928347608, events = 8, fd = 549527072, user_data = 0x0}, {pos = -1097411830, events = 5274, fd = 769660832, user_data = 0x82de12d78}, {pos = 549526168, events = 8, fd = 549526288, user_data = 0x820c11a98}, {pos = -1097411830, events = 5274, fd = 769639304, user_data = 0x82de12d78}, {pos = 549526216, events = 8, fd = 549526336, user_data = 0x820c11ac8}, {pos = 769700244, events = 8, fd = 563504136, user_data = 0x82de0b194}, {pos = 549526320, events = 8, fd = -1097432006, user_data = 0x820c11ad0}, {pos = 737645584, events = 8, fd = 771522608, user_data = 0x149abe96d30a}, {pos = 769607768, events = 8, fd = 769731960, user_data = 0x820c11b38}, {pos = 549526448, events = 8, fd = 549526328, user_data = 0x82de09d0c}, {pos = 563504136, events = 8, fd = 769694988, user_data = 0x820c11ba0}, {pos = -1097432006, events = 5274, fd = 549526472, user_data = 0x820c11d98}, {pos = 549526448, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1382427086, user_data = 0x82196c038}, {pos = 1, events = 3442752571, fd = 563504136, user_data = 0x82ddfc388}, {pos = 563525576, events = 8, fd = 0, user_data = 0x0}, {pos = 549526584, events = 8, fd = 549527048, user_data = 0x820c11c20}, {pos = -1097413470, events = 5274, fd = 2702778, user_data = 0x6d68b}, {pos = 2090263927, events = 3442752571, fd = 563527736, user_data = 0x1}, {pos = 0, events = 0, fd = 0, user_data = 0x820c11f08}, {pos = 563504136, events = 3, fd = 549527120, user_data = 0x82196b828}, {pos = 656, events = 0, fd = 549527048, user_data = 0x820c11c38}, {pos = 549526688, events = 8, fd = -1097413861, user_data = 0x820c11dd0}, {pos = 0, events = 0, fd = 0, user_data = 0x800000000}, {pos = 563527736, events = 8, fd = 1, user_data = 0x821966408}, {pos = 769607768, events = 8, fd = 549527304, user_data = 0x820c11e50}, {pos = 549526704, events = 8, fd = 0, user_data = 0x82195f008}, {pos = 33, events = 0, fd = 549527104, user_data = 0x149abe966ae7}, {pos = 563474440, events = 8, fd = 563475464, user_data = 0x82195f808}, {pos = 563477512, events = 8, fd = 563490824, user_data = 0x821963408}, {pos = 563492872, events = 8, fd = 563493896, user_data = 0x821964008}, {pos = 563495944, events = 8, fd = 563496968, user_data = 0x821964c08}, {pos = 563499016, events = 8, fd = 563500040, user_data = 0x821965808}, {pos = 563502088, events = 8, fd = 563503112, user_data = 0x821966408}, {pos = 563505160, events = 8, fd = 563506184, user_data = 0x821967008}, {pos = 563508232, events = 8, fd = 563509256, user_data = 0x821967c08}, {pos = 563511304, events = 8, fd = 563512328, user_data = 0x821968808}, {pos = 563514376, events = 8, fd = 563519496, user_data = 0x82196a408}, {pos = 563521544, events = 8, fd = 563522568, user_data = 0x82196d408}, {pos = 417231000, events = 0, fd = 563474440, user_data = 0x293dba}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x82196c038}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 549527304, events = 8, fd = 549526704, user_data = 0x2100000021}, {pos = 0, events = 0, fd = 563527736, user_data = 0x1}, {pos = 563474440, events = 8, fd = 313, user_data = 0x820c11ef0}, {pos = -1097439761, events = 5274, fd = 2702778, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = 563527736, user_data = 0x1}, {pos = 563504136, events = 8, fd = 927883264, user_data = 0x1}, {pos = 927883668, events = 8, fd = 0, user_data = 0x820c11ec0}, {pos = 737686892, events = 8, fd = 1, user_data = 0x8374e6000}, {pos = 549527280, events = 8, fd = 737683202, user_data = 0x82df26170 }, {pos = 12340496, events = 0, fd = 770859376, user_data = 0x821966408}, {pos = 549527504, events = 8, fd = -1097440290, user_data = 0x837504800}, {pos = 1, events = 8, fd = -1097440674, user_data = 0x82195f008}, {pos = 549527288, events = 8, fd = 549527504, user_data = 0x1c20}, {pos = 927951904, events = 8, fd = -1097361008, user_data = 0x0}, {pos = 549520255, events = 8, fd = 8134455, user_data = 0x820c11f80}, {pos = 737645584, events = 8, fd = 771522608, user_data = 0x82dfca310}, {pos = 0, events = 0, fd = 8128, user_data = 0x820c11fb0}, {pos = 737688477, events = 8, fd = 927883264, user_data = 0x38a1}, {pos = 549527568, events = 8, fd = 737655034, user_data = 0x0}, {pos = 0, events = 0, fd = 334029369, user_data = 0x0}} [06:34:59.506] last_touch_time = 1726986657 [06:34:59.506] last_lockfile_recheck_time = 1726986657 [06:34:59.506] nevents = 1 [06:34:59.506] #23 0x0000000000895085 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x820c125f0) at ../src/backend/postmaster/postmaster.c:1351 [06:34:59.506] userDoption = [06:34:59.506] listen_addr_saved = [06:34:59.506] output_config_variable = [06:34:59.506] opt = [06:34:59.506] status = [06:34:59.506] #24 0x00000000007cec1c in main (argc=4, argv=0x820c125f0) at ../src/backend/main/main.c:197 [06:34:59.506] do_check_root =