[22:22:28.602] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [22:22:28.913] dumping /tmp/cores/postgres.26715.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:22:29.048] [New LWP 101939] [22:22:29.135] Core was generated by `postgres: cascade: startup recovering 000000020000000000000004'. [22:22:29.135] Program terminated with signal SIGQUIT, Quit. [22:22:29.135] Sent by thr_kill() from pid 26715 and user 1002. [22:22:29.135] #0 0x0000000829bd875a in _sigprocmask () from /lib/libc.so.7 [22:22:29.178] [22:22:29.178] Thread 1 (LWP 101939): [22:22:29.178] #0 0x0000000829bd875a in _sigprocmask () from /lib/libc.so.7 [22:22:29.178] No symbol table info available. [22:22:29.178] #1 0x0000000829c15a2f in _system () from /lib/libc.so.7 [22:22:29.178] No symbol table info available. [22:22:29.178] #2 0x000000082b0de8a3 in ?? () from /lib/libthr.so.3 [22:22:29.178] No symbol table info available. [22:22:29.178] #3 0x00000000006858f7 in RestoreArchivedFile (path=path@entry=0x82138d1e0 "pg_wal/00000002", '0' , "4", xlogfname=xlogfname@entry=0x82138d5e0 "00000003.history", recovername=, expectedSize=expectedSize@entry=0, cleanupEnabled=) at ../src/backend/access/transam/xlogarchive.c:177 [22:22:29.178] xlogpath = "pg_wal/RECOVERYHISTORY\000\273\320\312\310)\b\000\000\000\005\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\000\3228!\b\000\000\000\001\000\000\000\000\000\000\000\360\3158!\b\000\000\000\027.\265)\b", '\000' , "\300\034\301\000\000\000\000\000002", '\000' , "002\000\000\000\000\00000000000", '\000' , "\260\3158!\b\000\000\000͢\327\034=5\000\000\250\216\252)\b\000\000\000\234"... [22:22:29.178] lastRestartPointFname = '0' , '\000' , "\353\000\356\327\215\214\205\273\320\312\310)\b\000\000\000\030@\277\000\000\000\000\000\370he\250\256\035\000\000\001\377\000\207\377\377\377\377\027X\002\000\000\000\000\000\001\000\000\000\000\000\000\000\200\201\000\000\352\003\000\000\353\003\000\000\000\000\000\000\377\377\377\377\377\377\377\377\206N\364g\000\000\000\000\220#\3015\000\000\000\000\206N\364g\000\000\000\000\200\002\3005\000\000\000\000\206N\364g\000\000\000\000\340i\3015\000\000\000\000\206N\364g\000\000\000\000("... [22:22:29.178] stat_buf = {st_dev = 4, st_ino = 2, st_nlink = 34917110224, st_mode = 8435, st_padding0 = 178, st_uid = 0, st_gid = 557371856, st_padding1 = 8, st_rdev = 35059478039, st_atim = {tv_sec = 7834484, tv_nsec = 3}, st_mtim = {tv_sec = 0, tv_nsec = 0}, st_ctim = {tv_sec = 3420208, tv_nsec = 3472328296227680304}, st_birthtim = {tv_sec = 35060020816, tv_nsec = 32635986391048}, st_size = 2833192, st_blocks = 35082056889, st_blksize = 1, st_flags = 0, st_gen = 32635990646784, st_spare = {34917110160, 35060011806, 2, 35059881029, 700282448, 13512360797836017899, 34917110240, 12539984, 206158430240, 34917110240}} [22:22:29.178] restartRedoPtr = 34917109968 [22:22:29.178] restartTli = 8 [22:22:29.178] restartSegNo = [22:22:29.178] xlogRestoreCmd = 0x1daea8b70da8 "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\"" [22:22:29.178] rc = [22:22:29.178] #4 0x000000000066c768 in existsTimeLineHistory (probeTLI=probeTLI@entry=3) at ../src/backend/access/transam/timeline.c:235 [22:22:29.178] path = "pg_wal/00000002", '0' , "4\000\000\000\000\000\000\000\000\000\220Pe\250\256\035\000\000\001\000\000\000\000\000\000\000\260\3228!\b\000\000\000\020\3268!\b\000\000\000\020`\304)\b\000\000\000\353\000\356\327\215\214\205\273\200\t\200\250\256\035\000\000\000\000\000\000\000\000\000\000\220Pe\250\256\035\000\000\001\000\000\000\000\000\000\000\260\3228!\b\000\000\000\020\3268!\b\000\000\000\263e\304)\b\000\000\000\300\3228!\b", '\000' , "\n", '\000' , "\330X\200\250\256\035\000\000\000\020\000\000\000\000\000\000h\3268!\b\000\000\000\220"... [22:22:29.178] histfname = "00000003.history\000\3268!\b\000\000\000\215ޔ\000\000\000\000\000\377\377\377\377\377\377\377\377\000\000\000\000\000\000\000\000P\3268!\b\000\000\000\025\354\230\000\000\000\000" [22:22:29.178] fd = [22:22:29.178] #5 0x000000000066c828 in findNewestTimeLine (startTLI=startTLI@entry=2) at ../src/backend/access/transam/timeline.c:277 [22:22:29.178] newestTLI = 2 [22:22:29.178] probeTLI = 3 [22:22:29.178] #6 0x0000000000690d3b in rescanLatestTimeLine (replayTLI=replayTLI@entry=2, replayLSN=replayLSN@entry=67209536) at ../src/backend/access/transam/xlogrecovery.c:4135 [22:22:29.178] oldtarget = 2 [22:22:29.178] currentTle = 0x0 [22:22:29.178] newtarget = [22:22:29.178] newExpectedTLEs = [22:22:29.178] found = [22:22:29.178] cell = [22:22:29.178] #7 0x000000000068cf33 in WaitForWALToBecomeAvailable (RecPtr=67209560, tliRecPtr=67209536, replayTLI=2, replayLSN=67209536, randAccess=, fetching_ckpt=, nonblocking=) at ../src/backend/access/transam/xlogrecovery.c:3697 [22:22:29.178] startWalReceiver = false [22:22:29.178] streaming_reply_sent = true [22:22:29.178] now = [22:22:29.178] startWalReceiver = [22:22:29.178] oldSource = [22:22:29.178] wait_time = [22:22:29.178] __error = [22:22:29.178] __error = [22:22:29.178] __error = [22:22:29.178] havedata = [22:22:29.178] ptr = [22:22:29.178] tli = [22:22:29.178] __error = [22:22:29.178] latestChunkStart = [22:22:29.178] __error = [22:22:29.178] #8 XLogPageRead (xlogreader=0x1daea8a1d130, targetPagePtr=67207168, reqLen=2392, targetRecPtr=67209536, readBuf=0x1daea8b41ff8 "\030\321\005") at ../src/backend/access/transam/xlogrecovery.c:3363 [22:22:29.178] private = 0x1daea8a1d110 [22:22:29.178] emode = 15 [22:22:29.178] targetSegNo = 4 [22:22:29.178] targetPageOff = 98304 [22:22:29.178] io_start = [22:22:29.178] r = [22:22:29.178] #9 0x0000000000693c9a in ReadPageInternal (state=state@entry=0x1daea8a1d130, pageptr=67207168, reqLen=2392) at ../src/backend/access/transam/xlogreader.c:1061 [22:22:29.178] targetSegNo = 4 [22:22:29.178] targetPageOff = 98304 [22:22:29.178] readLen = [22:22:29.178] hdr = [22:22:29.178] err = [22:22:29.178] #10 0x0000000000692ac8 in XLogDecodeNextRecord (state=0x1daea8a1d130, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:598 [22:22:29.178] errormsg = 0x2f000000300 [22:22:29.178] randAccess = [22:22:29.178] decoded = 0x0 [22:22:29.178] RecPtr = 67209536 [22:22:29.178] assembled = false [22:22:29.178] targetPagePtr = 67207168 [22:22:29.178] readOff = [22:22:29.178] record = [22:22:29.178] gotheader = [22:22:29.178] targetRecOff = 2368 [22:22:29.178] pageHeaderSize = [22:22:29.178] len = [22:22:29.178] total_len = [22:22:29.178] buffer = [22:22:29.178] gotlen = [22:22:29.178] pageHeader = [22:22:29.178] contdata = [22:22:29.178] save_copy = [22:22:29.178] #11 XLogReadAhead (state=0x1daea8a1d130, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:974 [22:22:29.178] result = [22:22:29.178] #12 0x000000000068a1e8 in XLogPrefetcherNextBlock (pgsr_private=32635991900168, lsn=0x1daea8b70808) at ../src/backend/access/transam/xlogprefetcher.c:490 [22:22:29.178] nonblocking = false [22:22:29.178] record = 0x0 [22:22:29.178] prefetcher = 0x1daea8b44008 [22:22:29.178] reader = 0x1daea8a1d130 [22:22:29.178] replaying_lsn = 67209128 [22:22:29.178] #13 0x0000000000689e55 in lrq_prefetch (lrq=0x1daea8b70598) at ../src/backend/access/transam/xlogprefetcher.c:252 [22:22:29.178] No locals. [22:22:29.178] #14 lrq_complete_lsn (lrq=0x1daea8b70598, lsn=) at ../src/backend/access/transam/xlogprefetcher.c:290 [22:22:29.178] No locals. [22:22:29.178] #15 XLogPrefetcherReadRecord (prefetcher=prefetcher@entry=0x1daea8b44008, errmsg=errmsg@entry=0x821391d60) at ../src/backend/access/transam/xlogprefetcher.c:1035 [22:22:29.178] replayed_up_to = [22:22:29.178] record = [22:22:29.178] #16 0x000000000068d9ea in ReadRecord (xlogprefetcher=0x1daea8b44008, emode=emode@entry=15, fetching_ckpt=false, replayTLI=replayTLI@entry=2) at ../src/backend/access/transam/xlogrecovery.c:3162 [22:22:29.178] errormsg = 0x0 [22:22:29.178] xlogreader = 0x1daea8a1d130 [22:22:29.178] private = [22:22:29.178] record = [22:22:29.178] #17 0x000000000068e2d9 in PerformWalRecovery () at ../src/backend/access/transam/xlogrecovery.c:1840 [22:22:29.178] ru0 = {tv = {tv_sec = 1744064134, tv_usec = 928185}, ru = {ru_utime = {tv_sec = 0, tv_usec = 0}, ru_stime = {tv_sec = 0, tv_usec = 979}, 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 = 11, ru_nivcsw = 2}} [22:22:29.178] xtime = [22:22:29.178] reachedRecoveryTarget = false [22:22:29.178] replayTLI = 2 [22:22:29.178] record = [22:22:29.179] #18 0x000000000067e9e3 in StartupXLOG () at ../src/backend/access/transam/xlog.c:6033 [22:22:29.179] wasShutdown = false [22:22:29.179] haveTblspcMap = false [22:22:29.179] haveBackupLabel = true [22:22:29.179] promoted = false [22:22:29.179] didCrash = [22:22:29.179] checkPoint = {redo = 33554472, ThisTimeLineID = 1, PrevTimeLineID = , fullPageWrites = true, wal_level = , nextXid = {value = }, nextOid = , nextMulti = , nextMultiOffset = , oldestXid = , oldestXidDB = , oldestMulti = , oldestMultiDB = , time = , oldestCommitTsXid = 0, newestCommitTsXid = 0, oldestActiveXid = 752} [22:22:29.179] oldestActiveXID = [22:22:29.179] performedWalRecovery = [22:22:29.179] endOfRecoveryInfo = [22:22:29.179] EndOfLog = [22:22:29.179] EndOfLogTLI = [22:22:29.179] abortedRecPtr = [22:22:29.179] missingContrecPtr = [22:22:29.179] newTLI = [22:22:29.179] Insert = [22:22:29.179] #19 0x00000000008c12ab in StartupProcessMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/startup.c:258 [22:22:29.179] No locals. [22:22:29.179] #20 0x00000000008bad3b in postmaster_child_launch (child_type=child_type@entry=B_STARTUP, child_slot=89, 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 [22:22:29.179] pid = [22:22:29.179] #21 0x00000000008bdb17 in StartChildProcess (type=type@entry=B_STARTUP) at ../src/backend/postmaster/postmaster.c:3973 [22:22:29.179] pmchild = 0x0 [22:22:29.179] pid = [22:22:29.179] #22 0x00000000008bd512 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821397528) at ../src/backend/postmaster/postmaster.c:1393 [22:22:29.179] userDoption = [22:22:29.179] listen_addr_saved = false [22:22:29.179] output_config_variable = [22:22:29.179] opt = [22:22:29.179] status = [22:22:29.179] #23 0x00000000007f0c20 in main (argc=4, argv=0x821397528) at ../src/backend/main/main.c:227 [22:22:29.179] do_check_root = [22:22:29.179] dispatch_option = DISPATCH_POSTMASTER [22:22:29.187] [22:22:29.187] [22:22:29.187] [22:22:29.233] dumping /tmp/cores/sh.40360.core for /bin/sh [22:22:29.272] [New LWP 102104] [22:22:29.272] Core was generated by `sh -c cp "/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decodi'. [22:22:29.272] Program terminated with signal SIGQUIT, Quit. [22:22:29.272] Sent by kill() from pid 39304 and user 1002. [22:22:29.272] #0 0x00003d200bea7e90 in ?? () [22:22:29.272] [22:22:29.272] Thread 1 (LWP 102104): [22:22:29.272] #0 0x00003d200bea7e90 in ?? () [22:22:29.272] No symbol table info available. [22:22:29.272] #1 0x0000000000000003 in ?? () [22:22:29.272] No symbol table info available. [22:22:29.272] #2 0x00000729ded5a038 in ?? () [22:22:29.272] No symbol table info available. [22:22:29.272] #3 0x00000729ded5a03b in ?? () [22:22:29.272] No symbol table info available. [22:22:29.272] #4 0x00000729ded5a03e in ?? () [22:22:29.272] No symbol table info available. [22:22:29.272] #5 0x0000000000000000 in ?? () [22:22:29.272] No symbol table info available. [22:22:29.277] [22:22:29.277] [22:22:29.277] [22:22:29.332] dumping /tmp/cores/postgres.56730.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:22:29.458] [New LWP 100121] [22:22:29.527] Core was generated by `postgres: old_node: postgres regression [local] SET'. [22:22:29.527] Program terminated with signal SIGSEGV, Segmentation fault. [22:22:29.527] Address not mapped to object. [22:22:29.527] #0 pg_strcasecmp (s1=, s2=, s2@entry=0xd8e7f61d498 "checkpointer") at ../src/port/pgstrcasecmp.c:40 [22:22:29.527] 40 unsigned char ch1 = (unsigned char) *s1++; [22:22:29.556] [22:22:29.556] Thread 1 (LWP 100121): [22:22:29.556] #0 pg_strcasecmp (s1=, s2=, s2@entry=0xd8e7f61d498 "checkpointer") at ../src/port/pgstrcasecmp.c:40 [22:22:29.556] ch1 = [22:22:29.556] ch2 = [22:22:29.556] #1 0x000000000077216c in check_log_min_messages (newval=, extra=0x8210a1858, source=) at ../src/backend/commands/variable.c:1382 [22:22:29.556] i = 12 [22:22:29.556] found = true [22:22:29.556] btype = 0xd8e7f61d498 "checkpointer" [22:22:29.556] loglevel = [22:22:29.556] entry = 0xbc1990 [22:22:29.556] tok = [22:22:29.556] sep = [22:22:29.556] l__state = {l = 0xd8e7f61d448, i = 0} [22:22:29.556] elemlist = 0xd8e7f61d448 [22:22:29.556] newlevels = {320017171 , 13, 320017171, 320017171, 320017171, 320017171, 320017171, 320017171} [22:22:29.556] assigned = {false , true, false, false, false, false, false, false} [22:22:29.556] genericlevel = -1 [22:22:29.556] rawstring = 0xd8e7f6483b0 "checkpointer:debug2" [22:22:29.556] l = [22:22:29.556] #2 0x0000000000aefee4 in call_string_check_hook (conf=conf@entry=0xbeebe0 , newval=newval@entry=0x8210a1860, extra=extra@entry=0x8210a1858, source=source@entry=PGC_S_SESSION, elevel=elevel@entry=21) at ../src/backend/utils/misc/guc.c:6923 [22:22:29.556] _local_sigjmp_buf = {{_sjb = {11468436, 34914047776, 34914047768, 34914047952, 13, 34914048088, 12512224, 12648536, 895, 34914047992, 39, 0}}} [22:22:29.556] _save_exception_stack = 0x8210a1aa0 [22:22:29.556] _save_context_stack = 0x0 [22:22:29.556] _do_rethrow = false [22:22:29.556] result = true [22:22:29.556] #3 0x0000000000aef799 in parse_and_validate_value (record=record@entry=0xbeebe0 , value=, source=source@entry=PGC_S_SESSION, elevel=elevel@entry=21, newval=newval@entry=0x8210a1860, newextra=newextra@entry=0x8210a1858) at ../src/backend/utils/misc/guc.c:3257 [22:22:29.556] conf = 0xbeebe0 [22:22:29.556] #4 0x0000000000aee926 in set_config_with_handle (name=, handle=handle@entry=0x0, value=value@entry=0xd8e7f61d038 "checkpointer:debug2, autovacuum:debug1", context=context@entry=PGC_SUSET, source=source@entry=PGC_S_SESSION, srole=10, action=GUC_ACTION_SET, changeVal=, elevel=21, is_reload=) at ../src/backend/utils/misc/guc.c:4010 [22:22:29.556] conf = 0xbeebe0 [22:22:29.556] orig_context = PGC_SUSET [22:22:29.556] orig_source = PGC_S_SESSION [22:22:29.556] orig_srole = 10 [22:22:29.556] newval_union = {boolval = 136, intval = 2128781192, realval = 7.3643771523039751e-311, stringval = 0xd8e7ee29f88 "checkpointer:debug2, autovacuum:debug1", enumval = 2128781192} [22:22:29.556] newextra = 0x0 [22:22:29.556] prohibitValueChange = [22:22:29.556] record = 0xbeebe0 [22:22:29.556] makeDefault = false [22:22:29.556] #5 0x0000000000aeac42 in set_config_option (name=, value=0xd8e7f61d038 "checkpointer:debug2, autovacuum:debug1", context=PGC_SUSET, source=source@entry=PGC_S_SESSION, action=action@entry=GUC_ACTION_SET, changeVal=true, elevel=0, is_reload=) at ../src/backend/utils/misc/guc.c:3360 [22:22:29.556] srole = 34 [22:22:29.556] #6 0x0000000000af393e in ExecSetVariableStmt (stmt=stmt@entry=0xd8e7ee25d78, isTopLevel=) at ../src/backend/utils/misc/guc_funcs.c:62 [22:22:29.556] action = GUC_ACTION_SET [22:22:29.556] #7 0x000000000097678c in standard_ProcessUtility (pstmt=0xd8e7ee25468, queryString=0xd8e7ee24100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0xd8e7ee25f68, qc=0x8210a1bb0) at ../src/backend/tcop/utility.c:875 [22:22:29.556] isAtomicContext = false [22:22:29.556] parsetree = 0xd8e7ee25d78 [22:22:29.556] readonly_flags = [22:22:29.556] pstate = 0xd8e7f648100 [22:22:29.556] isTopLevel = [22:22:29.556] #8 0x0000000000976138 in ProcessUtility (pstmt=0x0, queryString=0x0, readOnlyTree=, context=2124769528, params=0x2, queryEnv=0x22, dest=0xd8e7ee25f68, qc=0x8210a1bb0) at ../src/backend/tcop/utility.c:523 [22:22:29.556] No locals. [22:22:29.556] #9 0x0000000000975bdc in PortalRunUtility (portal=0xd8e7ef0d100, pstmt=0xd8e7ee25468, isTopLevel=, setHoldSnapshot=false, dest=0xd8e7ee25f68, qc=0x8210a1bb0) at ../src/backend/tcop/pquery.c:1185 [22:22:29.556] No locals. [22:22:29.556] #10 0x0000000000975244 in PortalRunMulti (portal=portal@entry=0xd8e7ef0d100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0xd8e7ee25f68, altdest=altdest@entry=0xd8e7ee25f68, qc=qc@entry=0x8210a1bb0) at ../src/backend/tcop/pquery.c:1356 [22:22:29.556] pstmt = 0xd8e7ee25468 [22:22:29.556] stmtlist_item__state = {l = 0xd8e7ee25f18, i = 0} [22:22:29.556] active_snapshot_set = false [22:22:29.556] query_index = 0 [22:22:29.556] stmtlist_item = 0xd8e7ee25f30 [22:22:29.556] #11 0x0000000000974b01 in PortalRun (portal=portal@entry=0xd8e7ef0d100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0xd8e7ee25f68, altdest=altdest@entry=0xd8e7ee25f68, qc=qc@entry=0x8210a1bb0) at ../src/backend/tcop/pquery.c:820 [22:22:29.556] _local_sigjmp_buf = {{_sjb = {9915000, 14905666228480, 34914048664, 34914048912, 34914048672, 12648536, 34914048944, 12574408, 34914042751, 34914048879, 14905666625792, 14903536517120}}} [22:22:29.556] _save_exception_stack = 0x8210a1c80 [22:22:29.556] _save_context_stack = 0x0 [22:22:29.556] _do_rethrow = false [22:22:29.556] saveTopTransactionResourceOwner = 0xd8e7ef72788 [22:22:29.556] saveTopTransactionContext = 0xd8e7efad000 [22:22:29.556] saveActivePortal = 0x0 [22:22:29.556] saveResourceOwner = 0xd8e7ef72788 [22:22:29.556] savePortalContext = 0x0 [22:22:29.556] saveMemoryContext = 0xd8e7efad000 [22:22:29.556] result = [22:22:29.556] nprocessed = [22:22:29.556] #12 0x0000000000973891 in exec_simple_query (query_string=query_string@entry=0xd8e7ee24100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';") at ../src/backend/tcop/postgres.c:1274 [22:22:29.556] cmdtaglen = 3 [22:22:29.556] snapshot_set = [22:22:29.556] per_parsetree_context = 0x0 [22:22:29.556] plantree_list = [22:22:29.556] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:22:29.556] format = 0 [22:22:29.556] parsetree = 0xd8e7ee25298 [22:22:29.556] commandTag = [22:22:29.556] cmdtagname = [22:22:29.556] querytree_list = [22:22:29.556] portal = 0xd8e7ef0d100 [22:22:29.556] receiver = 0xd8e7ee25f68 [22:22:29.556] parsetree_item__state = {l = 0xd8e7ee25418, i = 0} [22:22:29.556] msec_str = "\000\000\000\000\b", '\000' , "\034\n!\b\000\000\000UZQ+\b\000\000" [22:22:29.556] dest = DestRemote [22:22:29.556] was_logged = [22:22:29.556] oldcontext = 0xd8e7efad000 [22:22:29.556] parsetree_list = 0xd8e7ee25418 [22:22:29.556] use_implicit_block = false [22:22:29.556] parsetree_item = 0xd8e7ee25430 [22:22:29.556] save_log_statement_stats = [22:22:29.556] #13 0x00000000009712b5 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4764 [22:22:29.556] query_string = 0xd8e7ee24100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';" [22:22:29.556] input_message = {data = 0xd8e7ee24100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';", len = 66, maxlen = 1024, cursor = 66} [22:22:29.556] firstchar = [22:22:29.556] local_sigjmp_buf = {{_sjb = {9897647, 34914049152, 34914049112, 34914049744, 12448820, 12448552, 12657336, 12651252, 895, 0, 0, 14903536517121}}} [22:22:29.556] send_ready_for_query = false [22:22:29.556] idle_in_transaction_timeout_enabled = false [22:22:29.556] idle_session_timeout_enabled = false [22:22:29.556] #14 0x000000000096b7b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [22:22:29.556] bsdata = [22:22:29.556] #15 0x00000000008bad3b in postmaster_child_launch (child_type=B_BACKEND, child_slot=7, startup_data=startup_data@entry=0x8210a2938, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x8210a2950) at ../src/backend/postmaster/launch_backend.c:290 [22:22:29.556] pid = [22:22:29.556] #16 0x00000000008bf6a8 in BackendStartup (client_sock=0x8210a2950) at ../src/backend/postmaster/postmaster.c:3580 [22:22:29.556] startup_data = {canAcceptConnections = CAC_OK, socket_created = 797379414701859, fork_started = } [22:22:29.556] bn = 0xd8e7ef41158 [22:22:29.556] cac = CAC_OK [22:22:29.556] pid = [22:22:29.556] __error = [22:22:29.556] save_errno = [22:22:29.556] __error = [22:22:29.556] __error = [22:22:29.556] #17 ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [22:22:29.556] 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' , "\260)\n!\b\000\000\000XV\\)\b\000\000\000\006\001\000\000\000\000\000\000\276\336\\)\b", '\000' , "\360)\n!\b\000\000\000\204\252\213\000\000\000\000\000\000*\n!\b", '\000' }, salen = 16}} [22:22:29.556] i = 0 [22:22:29.556] now = [22:22:29.556] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 726390156, user_data = 0x0}, {pos = 554313984, events = 8, fd = 2129159640, user_data = 0x8210a2790}, {pos = 0, events = 0, fd = 0, user_data = 0x6f0477560b5479d9}, {pos = 727502272, events = 8, fd = 554312704, user_data = 0x267000e9b2cd}, {pos = 725547960, events = 8, fd = 725622940, user_data = 0x8210a2418}, {pos = 554312848, events = 8, fd = 554312752, user_data = 0x267000e9b2cd}, {pos = 725544816, events = 8, fd = 725622940, user_data = 0x8210a2448}, {pos = 554312896, events = 8, fd = 725593540, user_data = 0x82b3fadc4}, {pos = 554312816, events = 8, fd = 15315661, user_data = 0x82b3f3410}, {pos = 725622940, events = 8, fd = 554312840, user_data = 0x8210a2500}, {pos = 725596468, events = 8, fd = 725596468, user_data = 0xd8e7ea0a408}, {pos = 3, events = 0, fd = 554312944, user_data = 0x267000e964fb}, {pos = 554312960, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 554313032, user_data = 0x8210a2708}, {pos = 554313008, events = 8, fd = 15314002, user_data = 0x295d8f}, {pos = 2124477096, events = 3470, fd = 725562384, user_data = 0xd8e7ea0a408}, {pos = 554313096, events = 8, fd = 554313544, user_data = 0x8210a2570}, {pos = 15314002, events = 9840, fd = 2734988, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 2124480592, user_data = 0x800000001}, {pos = 0, events = 0, fd = 0, user_data = 0x8210a2848}, {pos = 2128676288, events = 3, fd = 554313624, user_data = 0xd8e7ea0fae8}, {pos = 656, events = 0, fd = 554313544, user_data = 0x8210a2588}, {pos = 554313200, events = 8, fd = 15313611, user_data = 0x8210a2808}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 2124480592, events = 3470, fd = 1, user_data = 0xd8e7ea0a408}, {pos = 725562384, events = 8, fd = 554313800, user_data = 0x8210a2798}, {pos = 554313216, events = 8, fd = 0, user_data = 0xd8e7ea03008}, {pos = 32, events = 0, fd = 554313600, user_data = 0x267000e94c77}, {pos = 2124427272, events = 3470, fd = 2124428296, user_data = 0xd8e7ea03808}, {pos = 2124430344, events = 3470, fd = 2124443656, user_data = 0xd8e7ea07408}, {pos = 2124445704, events = 3470, fd = 2124446728, user_data = 0xd8e7ea08008}, {pos = 2124448776, events = 3470, fd = 2124449800, user_data = 0xd8e7ea08c08}, {pos = 2124451848, events = 3470, fd = 2124452872, user_data = 0xd8e7ea09808}, {pos = 2124454920, events = 3470, fd = 2124455944, user_data = 0xd8e7ea0a408}, {pos = 2124457992, events = 3470, fd = 2124459016, user_data = 0xd8e7ea0b008}, {pos = 2124461064, events = 3470, fd = 2124462088, user_data = 0xd8e7ea0bc08}, {pos = 2124464136, events = 3470, fd = 2124465160, user_data = 0xd8e7ea0c808}, {pos = 2124467208, events = 3470, fd = 2124472328, user_data = 0xd8e7ea0e408}, {pos = 2124474376, events = 3470, fd = 2124475400, user_data = 0xd8e7ea03008}, {pos = 2734988, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 2124480592, events = 3470, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554313800, user_data = 0x8210a2600}, {pos = 32, events = 32, fd = 2124427272, user_data = 0x37b}, {pos = 2113896, events = 0, fd = 297, user_data = 0xd8e7ea10050}, {pos = 554313776, events = 8, fd = 15288193, user_data = 0xd8e7ee31000}, {pos = 2734988, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 2124480592, events = 3470, fd = 1, user_data = 0xd8e7ea0a408}, {pos = 12536088, events = 0, fd = 726757136, user_data = 0xd8e7ea03008}, {pos = 2838832, events = 0, fd = 693949625, user_data = 0x1}, {pos = 2128683008, events = 3470, fd = 554313776, user_data = 0x8295cc642}, {pos = 726757136, events = 8, fd = 12536088, user_data = 0x82b516f10 }, {pos = 2124456968, events = 3470, fd = 554314000, user_data = 0x267000e94574}, {pos = 554313856, events = 8, fd = 1, user_data = 0x267000e943ee}, {pos = 2124427272, events = 3470, fd = 554313784, user_data = 0x8210a2910}, {pos = 6816, events = 0, fd = 12, user_data = 0x267000ea83a0}, {pos = 0, events = 0, fd = 2128741247, user_data = 0xc122b0 }, {pos = 554313920, events = 8, fd = 693908832, user_data = 0x82b5bb460 <__thr_jtable>}, {pos = 727439184, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 554313968, events = 8, fd = 693908832, user_data = 0x82b5bb460 <__thr_jtable>}, {pos = 727439184, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 554314016, events = 8, fd = 693951229, user_data = 0xd8e7ee12000}, {pos = 7433, events = 0, fd = 554314112, user_data = 0x8295c59ea}} [22:22:29.556] last_touch_time = 1744064092 [22:22:29.556] last_lockfile_recheck_time = 1744064212 [22:22:29.556] nevents = 1 [22:22:29.556] #18 0x00000000008bd54a in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8210a2f98) at ../src/backend/postmaster/postmaster.c:1400 [22:22:29.556] userDoption = [22:22:29.556] listen_addr_saved = false [22:22:29.556] output_config_variable = [22:22:29.556] opt = [22:22:29.556] status = [22:22:29.556] #19 0x00000000007f0c20 in main (argc=4, argv=0x8210a2f98) at ../src/backend/main/main.c:227 [22:22:29.556] do_check_root = [22:22:29.556] dispatch_option = DISPATCH_POSTMASTER [22:22:29.564] [22:22:29.564] [22:22:29.564] [22:22:29.654] dumping /tmp/cores/postgres.60168.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [22:22:29.778] [New LWP 100102] [22:22:29.850] Core was generated by `postgres: postgres regression [local] SET'. [22:22:29.850] Program terminated with signal SIGSEGV, Segmentation fault. [22:22:29.850] Address not mapped to object. [22:22:29.850] #0 pg_strcasecmp (s1=, s2=, s2@entry=0x1d5c17a18c98 "checkpointer") at ../src/port/pgstrcasecmp.c:40 [22:22:29.850] 40 unsigned char ch1 = (unsigned char) *s1++; [22:22:29.882] [22:22:29.882] Thread 1 (LWP 100102): [22:22:29.882] #0 pg_strcasecmp (s1=, s2=, s2@entry=0x1d5c17a18c98 "checkpointer") at ../src/port/pgstrcasecmp.c:40 [22:22:29.882] ch1 = [22:22:29.882] ch2 = [22:22:29.882] #1 0x000000000077216c in check_log_min_messages (newval=, extra=0x82100e938, source=) at ../src/backend/commands/variable.c:1382 [22:22:29.882] i = 12 [22:22:29.882] found = true [22:22:29.882] btype = 0x1d5c17a18c98 "checkpointer" [22:22:29.882] loglevel = [22:22:29.882] entry = 0xbc1990 [22:22:29.882] tok = [22:22:29.882] sep = [22:22:29.882] l__state = {l = 0x1d5c17a18c48, i = 0} [22:22:29.882] elemlist = 0x1d5c17a18c48 [22:22:29.882] newlevels = {320017171 , 13, 320017171, 320017171, 320017171, 320017171, 320017171, 320017171} [22:22:29.882] assigned = {false , true, false, false, false, false, false, false} [22:22:29.882] genericlevel = -1 [22:22:29.882] rawstring = 0x1d5c17a9b3b0 "checkpointer:debug2" [22:22:29.882] l = [22:22:29.882] #2 0x0000000000aefee4 in call_string_check_hook (conf=conf@entry=0xbeebe0 , newval=newval@entry=0x82100e940, extra=extra@entry=0x82100e938, source=source@entry=PGC_S_SESSION, elevel=elevel@entry=21) at ../src/backend/utils/misc/guc.c:6923 [22:22:29.882] _local_sigjmp_buf = {{_sjb = {11468436, 34913445888, 34913445880, 34913446064, 13, 34913446200, 12512224, 12648536, 895, 34913446104, 39, 0}}} [22:22:29.882] _save_exception_stack = 0x82100eb80 [22:22:29.882] _save_context_stack = 0x0 [22:22:29.882] _do_rethrow = false [22:22:29.882] result = true [22:22:29.882] #3 0x0000000000aef799 in parse_and_validate_value (record=record@entry=0xbeebe0 , value=, source=source@entry=PGC_S_SESSION, elevel=elevel@entry=21, newval=newval@entry=0x82100e940, newextra=newextra@entry=0x82100e938) at ../src/backend/utils/misc/guc.c:3257 [22:22:29.882] conf = 0xbeebe0 [22:22:29.882] #4 0x0000000000aee926 in set_config_with_handle (name=, handle=handle@entry=0x0, value=value@entry=0x1d5c17a18838 "checkpointer:debug2, autovacuum:debug1", context=context@entry=PGC_SUSET, source=source@entry=PGC_S_SESSION, srole=10, action=GUC_ACTION_SET, changeVal=, elevel=21, is_reload=) at ../src/backend/utils/misc/guc.c:4010 [22:22:29.882] conf = 0xbeebe0 [22:22:29.882] orig_context = PGC_SUSET [22:22:29.882] orig_source = PGC_S_SESSION [22:22:29.882] orig_srole = 10 [22:22:29.882] newval_union = {boolval = 232, intval = 396618216, realval = 1.5949116320330027e-310, stringval = 0x1d5c17a3e9e8 "checkpointer:debug2, autovacuum:debug1", enumval = 396618216} [22:22:29.882] newextra = 0x0 [22:22:29.882] prohibitValueChange = [22:22:29.882] record = 0xbeebe0 [22:22:29.882] makeDefault = false [22:22:29.882] #5 0x0000000000aeac42 in set_config_option (name=, value=0x1d5c17a18838 "checkpointer:debug2, autovacuum:debug1", context=PGC_SUSET, source=source@entry=PGC_S_SESSION, action=action@entry=GUC_ACTION_SET, changeVal=true, elevel=0, is_reload=) at ../src/backend/utils/misc/guc.c:3360 [22:22:29.882] srole = 34 [22:22:29.882] #6 0x0000000000af393e in ExecSetVariableStmt (stmt=stmt@entry=0x1d5c17225d78, isTopLevel=) at ../src/backend/utils/misc/guc_funcs.c:62 [22:22:29.882] action = GUC_ACTION_SET [22:22:29.882] #7 0x000000000097678c in standard_ProcessUtility (pstmt=0x1d5c17225468, queryString=0x1d5c17224100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x1d5c17225f68, qc=0x82100ec90) at ../src/backend/tcop/utility.c:875 [22:22:29.882] isAtomicContext = false [22:22:29.882] parsetree = 0x1d5c17225d78 [22:22:29.882] readonly_flags = [22:22:29.882] pstate = 0x1d5c17a9b100 [22:22:29.882] isTopLevel = [22:22:29.882] #8 0x0000000000976138 in ProcessUtility (pstmt=0x0, queryString=0x0, readOnlyTree=, context=384133368, params=0x2, queryEnv=0x22, dest=0x1d5c17225f68, qc=0x82100ec90) at ../src/backend/tcop/utility.c:523 [22:22:29.882] No locals. [22:22:29.882] #9 0x0000000000975bdc in PortalRunUtility (portal=0x1d5c17361100, pstmt=0x1d5c17225468, isTopLevel=, setHoldSnapshot=false, dest=0x1d5c17225f68, qc=0x82100ec90) at ../src/backend/tcop/pquery.c:1185 [22:22:29.882] No locals. [22:22:29.882] #10 0x0000000000975244 in PortalRunMulti (portal=portal@entry=0x1d5c17361100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x1d5c17225f68, altdest=altdest@entry=0x1d5c17225f68, qc=qc@entry=0x82100ec90) at ../src/backend/tcop/pquery.c:1356 [22:22:29.882] pstmt = 0x1d5c17225468 [22:22:29.882] stmtlist_item__state = {l = 0x1d5c17225f18, i = 0} [22:22:29.882] active_snapshot_set = false [22:22:29.882] query_index = 0 [22:22:29.882] stmtlist_item = 0x1d5c17225f30 [22:22:29.882] #11 0x0000000000974b01 in PortalRun (portal=portal@entry=0x1d5c17361100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x1d5c17225f68, altdest=altdest@entry=0x1d5c17225f68, qc=qc@entry=0x82100ec90) at ../src/backend/tcop/pquery.c:820 [22:22:29.882] _local_sigjmp_buf = {{_sjb = {9915000, 32281363616000, 34913446776, 34913447024, 34913446784, 12648536, 34913447056, 12574408, 34913387391, 34913446991, 32281363624192, 32280974196736}}} [22:22:29.882] _save_exception_stack = 0x82100ed60 [22:22:29.882] _save_context_stack = 0x0 [22:22:29.882] _do_rethrow = false [22:22:29.882] saveTopTransactionResourceOwner = 0x1d5c1736e2f8 [22:22:29.882] saveTopTransactionContext = 0x1d5c173c8000 [22:22:29.882] saveActivePortal = 0x0 [22:22:29.882] saveResourceOwner = 0x1d5c1736e2f8 [22:22:29.882] savePortalContext = 0x0 [22:22:29.882] saveMemoryContext = 0x1d5c173c8000 [22:22:29.882] result = [22:22:29.882] nprocessed = [22:22:29.882] #12 0x0000000000973891 in exec_simple_query (query_string=query_string@entry=0x1d5c17224100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';") at ../src/backend/tcop/postgres.c:1274 [22:22:29.882] cmdtaglen = 3 [22:22:29.882] snapshot_set = [22:22:29.882] per_parsetree_context = 0x0 [22:22:29.882] plantree_list = [22:22:29.882] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:22:29.882] format = 0 [22:22:29.882] parsetree = 0x1d5c17225298 [22:22:29.882] commandTag = [22:22:29.882] cmdtagname = [22:22:29.882] querytree_list = [22:22:29.882] portal = 0x1d5c17361100 [22:22:29.882] receiver = 0x1d5c17225f68 [22:22:29.882] parsetree_item__state = {l = 0x1d5c17225418, i = 0} [22:22:29.882] msec_str = "\000\000\000\000\b", '\000' , "\340\354\000!\b\000\000\000Uj\003+\b\000\000" [22:22:29.882] dest = DestRemote [22:22:29.882] was_logged = [22:22:29.882] oldcontext = 0x1d5c173c8000 [22:22:29.882] parsetree_list = 0x1d5c17225418 [22:22:29.882] use_implicit_block = false [22:22:29.882] parsetree_item = 0x1d5c17225430 [22:22:29.882] save_log_statement_stats = [22:22:29.882] #13 0x00000000009712b5 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4764 [22:22:29.882] query_string = 0x1d5c17224100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';" [22:22:29.882] input_message = {data = 0x1d5c17224100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';", len = 66, maxlen = 1024, cursor = 66} [22:22:29.882] firstchar = [22:22:29.882] local_sigjmp_buf = {{_sjb = {9897647, 34913447264, 34913447224, 34913447856, 12448820, 12448552, 12657336, 12651252, 895, 0, 0, 34359738369}}} [22:22:29.882] send_ready_for_query = false [22:22:29.882] idle_in_transaction_timeout_enabled = false [22:22:29.882] idle_session_timeout_enabled = false [22:22:29.882] #14 0x000000000096b7b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [22:22:29.882] bsdata = [22:22:29.882] #15 0x00000000008bad3b in postmaster_child_launch (child_type=B_BACKEND, child_slot=17, startup_data=startup_data@entry=0x82100fa18, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x82100fa30) at ../src/backend/postmaster/launch_backend.c:290 [22:22:29.882] pid = [22:22:29.882] #16 0x00000000008bf6a8 in BackendStartup (client_sock=0x82100fa30) at ../src/backend/postmaster/postmaster.c:3580 [22:22:29.882] startup_data = {canAcceptConnections = CAC_OK, socket_created = 797379428018395, fork_started = } [22:22:29.882] bn = 0x1d5c1732d338 [22:22:29.882] cac = CAC_OK [22:22:29.882] pid = [22:22:29.882] __error = [22:22:29.882] save_errno = [22:22:29.882] __error = [22:22:29.882] __error = [22:22:29.882] #17 ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [22:22:29.882] 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' , "\220\372\000!\b\000\000\000Xf\216+\b\000\000\000\032\001\000\000\000\000\000\000\276\356\216+\b", '\000' , "\320\372\000!\b\000\000\000\204\252\213\000\000\000\000\000\340\372\000!\b", '\000' }, salen = 16}} [22:22:29.882] i = 0 [22:22:29.882] now = [22:22:29.882] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 721282444, user_data = 0x0}, {pos = 553712096, events = 8, fd = 388486616, user_data = 0x82100f870}, {pos = 1788063406, events = 1125728589, fd = 389390336, user_data = 0x2000}, {pos = 4096, events = 0, fd = 553711056, user_data = 0x1}, {pos = 553710864, events = 8, fd = 722128128, user_data = 0x1}, {pos = 4096, events = 0, fd = 232, user_data = 0x0}, {pos = 720437104, events = 8, fd = 720515228, user_data = 0x82100f5d8}, {pos = 553711048, events = 8, fd = 32, user_data = 0x1d5c17000980}, {pos = 553710928, events = 8, fd = -1473404211, user_data = 0x82af14410}, {pos = 720515228, events = 8, fd = 553710952, user_data = 0x82100f5e0}, {pos = 720488756, events = 8, fd = 720488756, user_data = 0x1d5c16e0a408}, {pos = 3, events = 0, fd = 553711056, user_data = 0x2d2aa82d54fb}, {pos = 553711072, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 7516, fd = 384127168, user_data = 0x1000}, {pos = 8192, events = 0, fd = 4097, user_data = 0x82100f820}, {pos = 383840936, events = 7516, fd = 720454672, user_data = 0x1d5c16e0a408}, {pos = 553711208, events = 8, fd = 553711656, user_data = 0x82100f650}, {pos = -1473405870, events = 11562, fd = 2734988, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = 383844432, user_data = 0x800000001}, {pos = 0, events = 0, fd = 0, user_data = 0x82100f928}, {pos = 388040032, events = 3, fd = 553711736, user_data = 0x1d5c16e0fae8}, {pos = 656, events = 0, fd = 553711656, user_data = 0x82100f668}, {pos = 553711312, events = 8, fd = -1473406261, user_data = 0x82100f8e8}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 383844432, events = 7516, fd = 1, user_data = 0x1d5c16e0a408}, {pos = 720454672, events = 8, fd = 553711912, user_data = 0x82100f878}, {pos = 553711328, events = 8, fd = 0, user_data = 0x1d5c16e03008}, {pos = 32, events = 0, fd = 553711712, user_data = 0x2d2aa82d3c77}, {pos = 383791112, events = 7516, fd = 383792136, user_data = 0x1d5c16e03808}, {pos = 383794184, events = 7516, fd = 383807496, user_data = 0x1d5c16e07408}, {pos = 383809544, events = 7516, fd = 383810568, user_data = 0x1d5c16e08008}, {pos = 383812616, events = 7516, fd = 383813640, user_data = 0x1d5c16e08c08}, {pos = 383815688, events = 7516, fd = 383816712, user_data = 0x1d5c16e09808}, {pos = 383818760, events = 7516, fd = 383819784, user_data = 0x1d5c16e0a408}, {pos = 383821832, events = 7516, fd = 383822856, user_data = 0x1d5c16e0b008}, {pos = 383824904, events = 7516, fd = 383825928, user_data = 0x1d5c16e0bc08}, {pos = 383827976, events = 7516, fd = 383829000, user_data = 0x1d5c16e0c808}, {pos = 383831048, events = 7516, fd = 383836168, user_data = 0x1d5c16e0e408}, {pos = 383838216, events = 7516, fd = 383839240, user_data = 0x1d5c16e03008}, {pos = 2734988, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 383844432, events = 7516, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 553711912, user_data = 0x82100f6e0}, {pos = 32, events = 32, fd = 383791112, user_data = 0x37b}, {pos = 2113896, events = 0, fd = 297, user_data = 0x1d5c16e10050}, {pos = 553711888, events = 8, fd = -1473431679, user_data = 0x1d5c17231000}, {pos = 2734988, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 383844432, events = 7516, fd = 1, user_data = 0x1d5c16e0a408}, {pos = 12536088, events = 0, fd = 721649424, user_data = 0x1d5c16e03008}, {pos = 2838832, events = 0, fd = 730784953, user_data = 0x1}, {pos = 388046848, events = 7516, fd = 553711888, user_data = 0x82b8ed642}, {pos = 721649424, events = 8, fd = 12536088, user_data = 0x82b037f10 }, {pos = 383820808, events = 7516, fd = 553712112, user_data = 0x2d2aa82d3574}, {pos = 553711968, events = 8, fd = 1, user_data = 0x2d2aa82d33ee}, {pos = 383791112, events = 7516, fd = 553711896, user_data = 0x82100f9f0}, {pos = 6816, events = 0, fd = 12, user_data = 0x2d2aa82e73a0}, {pos = 0, events = 0, fd = 388105087, user_data = 0xc122b0 }, {pos = 553712032, events = 8, fd = 730744160, user_data = 0x82b0dc460 <__thr_jtable>}, {pos = 722331472, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 553712080, events = 8, fd = 730744160, user_data = 0x82b0dc460 <__thr_jtable>}, {pos = 722331472, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 553712128, events = 8, fd = 730786557, user_data = 0x1d5c17212000}, {pos = 7372, events = 0, fd = 553712224, user_data = 0x82b8e69ea}} [22:22:29.882] last_touch_time = 1744064091 [22:22:29.882] last_lockfile_recheck_time = 1744064211 [22:22:29.882] nevents = 1 [22:22:29.882] #18 0x00000000008bd54a in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821010070) at ../src/backend/postmaster/postmaster.c:1400 [22:22:29.882] userDoption = [22:22:29.882] listen_addr_saved = false [22:22:29.882] output_config_variable = [22:22:29.882] opt = [22:22:29.882] status = [22:22:29.882] #19 0x00000000007f0c20 in main (argc=8, argv=0x821010070) at ../src/backend/main/main.c:227 [22:22:29.882] do_check_root = [22:22:29.882] dispatch_option = DISPATCH_POSTMASTER [22:22:29.890] [22:22:29.890] [22:22:29.890] [22:22:29.947] dumping /tmp/cores/postgres.77324.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [22:22:30.075] [New LWP 102001] [22:22:30.149] Core was generated by `postgres: primary: postgres regression [local] SET'. [22:22:30.149] Program terminated with signal SIGSEGV, Segmentation fault. [22:22:30.149] Address not mapped to object. [22:22:30.149] #0 pg_strcasecmp (s1=, s2=, s2@entry=0xaf126ff4c98 "checkpointer") at ../src/port/pgstrcasecmp.c:40 [22:22:30.149] 40 unsigned char ch1 = (unsigned char) *s1++; [22:22:30.189] [22:22:30.189] Thread 1 (LWP 102001): [22:22:30.189] #0 pg_strcasecmp (s1=, s2=, s2@entry=0xaf126ff4c98 "checkpointer") at ../src/port/pgstrcasecmp.c:40 [22:22:30.189] ch1 = [22:22:30.189] ch2 = [22:22:30.189] #1 0x000000000077216c in check_log_min_messages (newval=, extra=0x82112c108, source=) at ../src/backend/commands/variable.c:1382 [22:22:30.189] i = 12 [22:22:30.189] found = true [22:22:30.189] btype = 0xaf126ff4c98 "checkpointer" [22:22:30.189] loglevel = [22:22:30.189] entry = 0xbc1990 [22:22:30.189] tok = [22:22:30.189] sep = [22:22:30.189] l__state = {l = 0xaf126ff4c48, i = 0} [22:22:30.189] elemlist = 0xaf126ff4c48 [22:22:30.189] newlevels = {320017171 , 13, 320017171, 320017171, 320017171, 320017171, 320017171, 320017171} [22:22:30.189] assigned = {false , true, false, false, false, false, false, false} [22:22:30.189] genericlevel = -1 [22:22:30.189] rawstring = 0xaf1277223b0 "checkpointer:debug2" [22:22:30.189] l = [22:22:30.189] #2 0x0000000000aefee4 in call_string_check_hook (conf=conf@entry=0xbeebe0 , newval=newval@entry=0x82112c110, extra=extra@entry=0x82112c108, source=source@entry=PGC_S_SESSION, elevel=elevel@entry=21) at ../src/backend/utils/misc/guc.c:6923 [22:22:30.189] _local_sigjmp_buf = {{_sjb = {11468436, 34914615248, 34914615240, 34914615424, 13, 34914615560, 12512224, 12648536, 895, 34914615464, 39, 0}}} [22:22:30.189] _save_exception_stack = 0x82112c340 [22:22:30.189] _save_context_stack = 0x0 [22:22:30.189] _do_rethrow = false [22:22:30.189] result = true [22:22:30.189] #3 0x0000000000aef799 in parse_and_validate_value (record=record@entry=0xbeebe0 , value=, source=source@entry=PGC_S_SESSION, elevel=elevel@entry=21, newval=newval@entry=0x82112c110, newextra=newextra@entry=0x82112c108) at ../src/backend/utils/misc/guc.c:3257 [22:22:30.189] conf = 0xbeebe0 [22:22:30.189] #4 0x0000000000aee926 in set_config_with_handle (name=, handle=handle@entry=0x0, value=value@entry=0xaf126ff4838 "checkpointer:debug2, autovacuum:debug1", context=context@entry=PGC_SUSET, source=source@entry=PGC_S_SESSION, srole=10, action=GUC_ACTION_SET, changeVal=, elevel=21, is_reload=) at ../src/backend/utils/misc/guc.c:4010 [22:22:30.189] conf = 0xbeebe0 [22:22:30.189] orig_context = PGC_SUSET [22:22:30.189] orig_source = PGC_S_SESSION [22:22:30.189] orig_srole = 10 [22:22:30.189] newval_union = {boolval = 160, intval = 660741536, realval = 5.9440366601874457e-311, stringval = 0xaf127621da0 "checkpointer:debug2, autovacuum:debug1", enumval = 660741536} [22:22:30.189] newextra = 0x0 [22:22:30.189] prohibitValueChange = [22:22:30.189] record = 0xbeebe0 [22:22:30.189] makeDefault = false [22:22:30.189] #5 0x0000000000aeac42 in set_config_option (name=, value=0xaf126ff4838 "checkpointer:debug2, autovacuum:debug1", context=PGC_SUSET, source=source@entry=PGC_S_SESSION, action=action@entry=GUC_ACTION_SET, changeVal=true, elevel=0, is_reload=) at ../src/backend/utils/misc/guc.c:3360 [22:22:30.189] srole = 34 [22:22:30.189] #6 0x0000000000af393e in ExecSetVariableStmt (stmt=stmt@entry=0xaf126e25fd8, isTopLevel=) at ../src/backend/utils/misc/guc_funcs.c:62 [22:22:30.189] action = GUC_ACTION_SET [22:22:30.189] #7 0x000000000097678c in standard_ProcessUtility (pstmt=pstmt@entry=0xaf126e25468, queryString=queryString@entry=0xaf126e24100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';", readOnlyTree=, context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=0xaf126fb3608, qc=0x82112c630) at ../src/backend/tcop/utility.c:875 [22:22:30.189] isAtomicContext = false [22:22:30.189] parsetree = 0xaf126e25fd8 [22:22:30.189] readonly_flags = [22:22:30.189] pstate = 0xaf127722100 [22:22:30.189] isTopLevel = [22:22:30.189] #8 0x00000008345af05c in pgss_ProcessUtility (pstmt=0xaf126e25468, queryString=0xaf126e24100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0xaf126fb3608, qc=0x82112c630) at ../contrib/pg_stat_statements/pg_stat_statements.c:1181 [22:22:30.189] _local_sigjmp_buf = {{_sjb = {35238113158, 34914616128, 34914615928, 34914616400, 12030855763048, 0, 12648536, 34914616608, 895, 12030857392421, 0, 549755813888}}} [22:22:30.189] _save_exception_stack = 0x82112c520 [22:22:30.189] _save_context_stack = 0x0 [22:22:30.189] _do_rethrow = false [22:22:30.189] bufusage = {shared_blks_hit = 35238113158, shared_blks_read = 34914616128, shared_blks_dirtied = 34914615928, shared_blks_written = 34914616400, local_blks_hit = 12030855763048, local_blks_read = 0, local_blks_dirtied = 12648536, local_blks_written = 34914616608, temp_blks_read = 895, temp_blks_written = 12030857392421, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 549755813888}, local_blk_read_time = {ticks = -5561251665015394359}, local_blk_write_time = {ticks = 12030855765976}, temp_blk_read_time = {ticks = 1}, temp_blk_write_time = {ticks = 123}} [22:22:30.189] walusage_start = {wal_records = 864, wal_fpi = 7, wal_bytes = 120083, wal_buffers_full = 0} [22:22:30.189] duration = [22:22:30.189] bufusage_start = {shared_blks_hit = 9636, shared_blks_read = 714, shared_blks_dirtied = 137, shared_blks_written = 100, 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}} [22:22:30.189] walusage = {wal_records = 0, wal_fpi = 1, wal_bytes = 12030857393272, wal_buffers_full = 34914616228} [22:22:30.189] start = {ticks = -314271224161} [22:22:30.189] rows = [22:22:30.189] saved_queryId = 4159730094505376283 [22:22:30.189] parsetree = [22:22:30.189] saved_stmt_location = 0 [22:22:30.189] saved_stmt_len = 64 [22:22:30.189] enabled = [22:22:30.189] #9 0x0000000000975bdc in PortalRunUtility (portal=0xaf126f0b100, pstmt=0xaf126e25468, isTopLevel=, setHoldSnapshot=false, dest=0xaf126fb3608, qc=0x82112c630) at ../src/backend/tcop/pquery.c:1185 [22:22:30.189] No locals. [22:22:30.189] #10 0x0000000000975244 in PortalRunMulti (portal=portal@entry=0xaf126f0b100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0xaf126fb3608, altdest=altdest@entry=0xaf126fb3608, qc=qc@entry=0x82112c630) at ../src/backend/tcop/pquery.c:1356 [22:22:30.189] pstmt = 0xaf126e25468 [22:22:30.189] stmtlist_item__state = {l = 0xaf126fb35b8, i = 0} [22:22:30.189] active_snapshot_set = false [22:22:30.189] query_index = 0 [22:22:30.189] stmtlist_item = 0xaf126fb35d0 [22:22:30.189] #11 0x0000000000974b01 in PortalRun (portal=portal@entry=0xaf126f0b100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0xaf126fb3608, altdest=altdest@entry=0xaf126fb3608, qc=qc@entry=0x82112c630) at ../src/backend/tcop/pquery.c:820 [22:22:30.189] _local_sigjmp_buf = {{_sjb = {9915000, 12030856704256, 34914616600, 34914616848, 34914616608, 12648536, 34914616880, 12574408, 34914567039, 34914616815, 12030856712448, 12030203396096}}} [22:22:30.189] _save_exception_stack = 0x82112c700 [22:22:30.189] _save_context_stack = 0x0 [22:22:30.189] _do_rethrow = false [22:22:30.189] saveTopTransactionResourceOwner = 0xaf126f55748 [22:22:30.189] saveTopTransactionContext = 0xaf126fab000 [22:22:30.189] saveActivePortal = 0x0 [22:22:30.189] saveResourceOwner = 0xaf126f55748 [22:22:30.189] savePortalContext = 0x0 [22:22:30.189] saveMemoryContext = 0xaf126fab000 [22:22:30.189] result = [22:22:30.189] nprocessed = [22:22:30.189] #12 0x0000000000973891 in exec_simple_query (query_string=query_string@entry=0xaf126e24100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';") at ../src/backend/tcop/postgres.c:1274 [22:22:30.189] cmdtaglen = 3 [22:22:30.189] snapshot_set = [22:22:30.189] per_parsetree_context = 0x0 [22:22:30.189] plantree_list = [22:22:30.189] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [22:22:30.189] format = 0 [22:22:30.189] parsetree = 0xaf126e25298 [22:22:30.189] commandTag = [22:22:30.189] cmdtagname = [22:22:30.189] querytree_list = [22:22:30.189] portal = 0xaf126f0b100 [22:22:30.189] receiver = 0xaf126fb3608 [22:22:30.189] parsetree_item__state = {l = 0xaf126e25418, i = 0} [22:22:30.189] msec_str = "\000\000\000\000\b", '\000' , "\200\306\022!\b\000\000\000U\n\225+\b\000\000" [22:22:30.189] dest = DestRemote [22:22:30.189] was_logged = [22:22:30.189] oldcontext = 0xaf126fab000 [22:22:30.189] parsetree_list = 0xaf126e25418 [22:22:30.189] use_implicit_block = false [22:22:30.189] parsetree_item = 0xaf126e25430 [22:22:30.189] save_log_statement_stats = [22:22:30.189] #13 0x00000000009712b5 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4764 [22:22:30.189] query_string = 0xaf126e24100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';" [22:22:30.189] input_message = {data = 0xaf126e24100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';", len = 66, maxlen = 1024, cursor = 66} [22:22:30.189] firstchar = [22:22:30.189] local_sigjmp_buf = {{_sjb = {9897647, 34914617088, 34914617048, 34914617680, 12448820, 12448552, 12657336, 12651252, 895, 0, 0, 34359738369}}} [22:22:30.189] send_ready_for_query = false [22:22:30.189] idle_in_transaction_timeout_enabled = false [22:22:30.189] idle_session_timeout_enabled = false [22:22:30.189] #14 0x000000000096b7b9 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [22:22:30.189] bsdata = [22:22:30.189] #15 0x00000000008bad3b in postmaster_child_launch (child_type=B_BACKEND, child_slot=16, startup_data=startup_data@entry=0x82112d3b8, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x82112d3d0) at ../src/backend/postmaster/launch_backend.c:290 [22:22:30.189] pid = [22:22:30.189] #16 0x00000000008bf6a8 in BackendStartup (client_sock=0x82112d3d0) at ../src/backend/postmaster/postmaster.c:3580 [22:22:30.189] startup_data = {canAcceptConnections = CAC_OK, socket_created = 797379487146396, fork_started = } [22:22:30.189] bn = 0xaf126f41648 [22:22:30.189] cac = CAC_OK [22:22:30.189] pid = [22:22:30.189] __error = [22:22:30.189] save_errno = [22:22:30.189] __error = [22:22:30.189] __error = [22:22:30.189] #17 ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [22:22:30.189] 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\324\022!\b\000\000\000X\326&*\b\000\000\000w\000\000\000\000\000\000\000\276^'*\b", '\000' , "p\324\022!\b\000\000\000\204\252\213\000\000\000\000\000\200\324\022!\b", '\000' }, salen = 16}} [22:22:30.189] i = 0 [22:22:30.189] now = [22:22:30.189] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 730826124, user_data = 0x0}, {pos = 554881920, events = 8, fd = 652735960, user_data = 0x82112d210}, {pos = 0, events = 0, fd = 0, user_data = 0x82112ce70}, {pos = 259515085, events = 2174, fd = 729983928, user_data = 0x82b83d09c}, {pos = 554880648, events = 8, fd = 554880768, user_data = 0x82112cea0}, {pos = 259515085, events = 2174, fd = 729980784, user_data = 0x82b83d09c}, {pos = 554880696, events = 8, fd = 554880816, user_data = 0x82b835dc4}, {pos = 730029508, events = 8, fd = 554880736, user_data = 0x87e0f77e2cd}, {pos = 729998352, events = 8, fd = 730058908, user_data = 0x82112cef8}, {pos = 554880880, events = 8, fd = 730032436, user_data = 0x82b836934}, {pos = 648061960, events = 2801, fd = 3, user_data = 0x82112cf60}, {pos = 259495163, events = 2174, fd = 554880880, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82112cfb8}, {pos = 554881416, events = 8, fd = 554880928, user_data = 0x87e0f77dc52}, {pos = 2710927, events = 0, fd = 648083432, user_data = 0x0}, {pos = 0, events = 0, fd = 554881016, user_data = 0x82112d1c8}, {pos = 554880992, events = 8, fd = 259513426, user_data = 0x29bb8c}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0xaf126a10050}, {pos = 1, events = 8, fd = 0, user_data = 0x0}, {pos = 554881736, events = 8, fd = 1, user_data = 0x82112d218}, {pos = 648083528, events = 2801, fd = 656, user_data = 0x82112d1c8}, {pos = 554881016, events = 8, fd = 554881120, user_data = 0x87e0f77dacb}, {pos = 554881672, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 648085584, user_data = 0x1}, {pos = 648061960, events = 2801, fd = 729998352, user_data = 0x82112d2c8}, {pos = 554881560, events = 8, fd = 554881136, user_data = 0x0}, {pos = 648032264, events = 2801, fd = 33, user_data = 0x82112d200}, {pos = 259488887, events = 2174, fd = 648032264, user_data = 0xaf126a03408}, {pos = 648034312, events = 2801, fd = 648035336, user_data = 0xaf126a07008}, {pos = 648049672, events = 2801, fd = 648050696, user_data = 0xaf126a07c08}, {pos = 648052744, events = 2801, fd = 648053768, user_data = 0xaf126a08808}, {pos = 648055816, events = 2801, fd = 648056840, user_data = 0xaf126a09408}, {pos = 648058888, events = 2801, fd = 648059912, user_data = 0xaf126a0a008}, {pos = 648061960, events = 2801, fd = 648062984, user_data = 0xaf126a0ac08}, {pos = 648065032, events = 2801, fd = 648066056, user_data = 0xaf126a0b808}, {pos = 648068104, events = 2801, fd = 648069128, user_data = 0xaf126a0c408}, {pos = 648071176, events = 2801, fd = 648072200, user_data = 0xaf126a0e008}, {pos = 648078344, events = 2801, fd = 648079368, user_data = 0xaf126a0ec08}, {pos = 648087560, events = 2801, fd = 328219000, user_data = 0xaf126a03008}, {pos = 2734988, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 648085584, events = 2801, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554881736, user_data = 0x82112d070}, {pos = 33, events = 33, fd = 648032264, user_data = 0x37b}, {pos = 2113896, events = 0, fd = 297, user_data = 0xaf126a10050}, {pos = 554881712, events = 8, fd = 259487617, user_data = 0xaf126e31000}, {pos = 2734988, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = 648085584, events = 2801, fd = 1, user_data = 0xaf126a0a408}, {pos = 12536088, events = 0, fd = 731193104, user_data = 0xaf126a03008}, {pos = 2838832, events = 0, fd = 707220665, user_data = 0x1}, {pos = 652288000, events = 2801, fd = 554881712, user_data = 0x82a274642}, {pos = 731193104, events = 8, fd = 12536088, user_data = 0x82b951f10 }, {pos = 648061960, events = 2801, fd = 554881936, user_data = 0x87e0f777574}, {pos = 554881792, events = 8, fd = 1, user_data = 0x87e0f7773ee}, {pos = 648032264, events = 2801, fd = 554881720, user_data = 0x82112d390}, {pos = 6816, events = 0, fd = 12, user_data = 0x87e0f78b3a0}, {pos = 0, events = 0, fd = 652346239, user_data = 0xc122b0 }, {pos = 554881856, events = 8, fd = 707179872, user_data = 0x82b9f6460 <__thr_jtable>}, {pos = 731875152, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 554881904, events = 8, fd = 707179872, user_data = 0x82b9f6460 <__thr_jtable>}, {pos = 731875152, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 554881952, events = 8, fd = 707222269, user_data = 0xaf126e12000}, {pos = 27114, events = 0, fd = 554882048, user_data = 0x82a26d9ea}} [22:22:30.189] last_touch_time = 1744064136 [22:22:30.189] last_lockfile_recheck_time = 1744064256 [22:22:30.189] nevents = 1 [22:22:30.189] #18 0x00000000008bd54a in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82112da18) at ../src/backend/postmaster/postmaster.c:1400 [22:22:30.189] userDoption = [22:22:30.189] listen_addr_saved = false [22:22:30.189] output_config_variable = [22:22:30.189] opt = [22:22:30.189] status = [22:22:30.189] #19 0x00000000007f0c20 in main (argc=4, argv=0x82112da18) at ../src/backend/main/main.c:227 [22:22:30.189] do_check_root = [22:22:30.189] dispatch_option = DISPATCH_POSTMASTER