[03:44:22.610] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [03:44:22.971] dumping /tmp/cores/postgres.26657.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:44:23.100] [New LWP 101938] [03:44:23.188] Core was generated by `postgres: cascade: startup waiting for 000000020000000000000004'. [03:44:23.188] Program terminated with signal SIGQUIT, Quit. [03:44:23.188] Sent by thr_kill() from pid 26657 and user 1002. [03:44:23.188] #0 0x000000082df4b75a in _sigprocmask () from /lib/libc.so.7 [03:44:23.232] [03:44:23.232] Thread 1 (LWP 101938): [03:44:23.232] #0 0x000000082df4b75a in _sigprocmask () from /lib/libc.so.7 [03:44:23.232] No symbol table info available. [03:44:23.232] #1 0x000000082df88a2f in _system () from /lib/libc.so.7 [03:44:23.232] No symbol table info available. [03:44:23.232] #2 0x000000082bc628a3 in ?? () from /lib/libthr.so.3 [03:44:23.232] No symbol table info available. [03:44:23.232] #3 0x0000000000688157 in RestoreArchivedFile (path=path@entry=0x8212ff1e0 "`\362/!\b", xlogfname=xlogfname@entry=0x8212ff630 "00000002", '0' , "4", recovername=, expectedSize=16777216, cleanupEnabled=) at ../src/backend/access/transam/xlogarchive.c:177 [03:44:23.232] xlogpath = "pg_wal/RECOVERYXLOG\000RY\000\277\320\372\377-\b\000\000\000\005\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\000\362/!\b\000\000\000\001\000\000\000\000\000\000\000\360\355/!\b\000\000\000\027^\354-\b", '\000' , "\320r\301\000\000\000\000\000002", '\000' , "002\000\000\000\000\00000000000", '\000' , "\260\355/!\b\000\000\000\315\362Y\002\310\016\000\000\250\276\341-\b\000\000\000"... [03:44:23.232] lastRestartPointFname = "00000001", '0' , "2", '\000' , "%e\262\000\000\000\000\0008\360/!\b\000\000\000\376\377\377\377\000\000\000\000\304\351/!\b\000\000\000\377\377\377\377\000\000\000\000\210\360/!\b", '\000' , "p\351/!\b\000\000\000fh\262", '\000' , "%e\262\000\000\000\000\000\210\360/!\b\000\000\000\376\377\377\377\000\000\000\000\002", '\000' ... [03:44:23.232] stat_buf = {st_dev = 34916529632, st_ino = 34916529712, st_nlink = 12469024, st_mode = 2, st_padding0 = 0, st_uid = 0, st_gid = 556790224, st_padding1 = 8, st_rdev = 35130203671, st_atim = {tv_sec = 34916528480, tv_nsec = 12677840}, st_mtim = {tv_sec = 875573296, tv_nsec = 0}, st_ctim = {tv_sec = 3420208, tv_nsec = 3472328296227680304}, st_birthtim = {tv_sec = 206158430224, tv_nsec = 34916529680}, st_size = 34916528704, st_blocks = 11751043, st_blksize = 1298088780, st_flags = 1095979845, st_gen = 67735702794920, st_spare = {35129503008, 67735702774792, 34916528632, 34916529080, 34916528608, 16252195695698, 2627577, 134090501, 206158430240, 34916528608}} [03:44:23.232] restartRedoPtr = 33554472 [03:44:23.232] restartTli = 1 [03:44:23.232] restartSegNo = [03:44:23.232] xlogRestoreCmd = 0x3d9af2d713e8 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/025_stuck_on_old_timeline/data/t_025_stuck_on_old_timeline_primary_data/archives/00000002", '0' , "4\" \"pg_wal/RECOVERYXLOG\"" [03:44:23.232] rc = [03:44:23.232] #4 0x00000000006937b0 in XLogFileRead (segno=segno@entry=4, tli=tli@entry=2, source=source@entry=XLOG_FROM_ARCHIVE, notfoundOk=true) at ../src/backend/access/transam/xlogrecovery.c:4231 [03:44:23.232] xlogfname = "00000002", '0' , "4\000\372\213o\214\234\373\277\000\000\000\000\000\000\000\000\220\366/!\b\000\000\000\200\366/!\b\000\000\000\242i\364-\b\000\000" [03:44:23.232] activitymsg = "waiting for 00000002", '0' , "4\000=\000\000p\a\000\000\000\000\000\000\220\366/!\b\000\000\000\003\000\000\000\000\000\000\000`\366/!\b\000\000\000Uj\364-\b\000\000" [03:44:23.232] path = "`\362/!\b\000\000\000\313\352Y\002\310\016\000\000\030\000\000\0000", '\000' , "P\000\201\362\232=\000\000\001\000\000\000\000\000\000\000\b\244\200\362\232=\000\000 \255\341-\b\000\000\000\270\364/!\b\000\000\000\b\364/!\b\000\000\000p\362/!\b", '\000' , "\b0\200\362\232=\000\000 \000\000\000\000\000\000\000\360\363/!\b\000\000\000w\214Y\002\310\016\000\000\b0\200\362\232=\000\000\b4\200\362\232=\000\000\b8\200\362\232=\000\000\b<\200\362\232=\000\000\bp\200\362\232=\000\000\bt\200\362\232=\000\000\bx\200\362\232=\000\000"... [03:44:23.232] fd = [03:44:23.232] #5 0x000000000068f4ec in XLogFileReadAnyTLI (segno=4, source=XLOG_FROM_ANY) at ../src/backend/access/transam/xlogrecovery.c:4359 [03:44:23.232] hent = [03:44:23.232] tli = 2 [03:44:23.232] cell__state = {l = 0x3d9af2d456d8, i = 0} [03:44:23.232] path = "\000\000\000\004\000\000\000\0000000002", '0' , "3\000\200R\205\362\232=\000\000\000\000\000\000\000\000\000\000\200\367/!\b\000\000\000ʧ\370-\b\000\000\000\200\000\000\002\000\000\000\000x\027\324\362\232=\000\000\002\000\000\000\000\000\000\000\200\000\000\002", '\000' , "\002", '\000' , "\001\000\000\000Coi\000\000\000\000\000\000\000\000\002", '\000' , "|\v@\363\232=\000\000Coi\000\000\000\000\000\220\v@\363\232=\000\000\000\000\b\000\000\000\000\000|\v@\363\232=\000\000\00080!\b\000\000\000\220\v@\363\232=", '\000' ... [03:44:23.232] tles = 0x3d9af2d456d8 [03:44:23.232] cell = [03:44:23.232] fd = [03:44:23.232] cell__state = [03:44:23.232] hent = [03:44:23.232] tli = [03:44:23.232] beginseg = [03:44:23.232] __error = [03:44:23.232] __error = [03:44:23.232] #6 WaitForWALToBecomeAvailable (RecPtr=67209072, tliRecPtr=67209048, replayTLI=2, replayLSN=67209048, randAccess=, fetching_ckpt=, nonblocking=) at ../src/backend/access/transam/xlogrecovery.c:3793 [03:44:23.232] startWalReceiver = [03:44:23.232] streaming_reply_sent = true [03:44:23.232] now = [03:44:23.232] startWalReceiver = [03:44:23.232] oldSource = [03:44:23.232] wait_time = [03:44:23.232] __error = [03:44:23.232] __error = [03:44:23.232] __error = [03:44:23.232] havedata = [03:44:23.232] ptr = [03:44:23.232] tli = [03:44:23.232] __error = [03:44:23.232] latestChunkStart = [03:44:23.232] __error = [03:44:23.232] #7 XLogPageRead (xlogreader=0x3d9af2c1d130, targetPagePtr=67207168, reqLen=1904, targetRecPtr=67209048, readBuf=0x3d9af2d41778 "\030\321\005") at ../src/backend/access/transam/xlogrecovery.c:3363 [03:44:23.232] private = 0x3d9af2c1d110 [03:44:23.232] emode = 15 [03:44:23.232] targetSegNo = 4 [03:44:23.232] targetPageOff = 98304 [03:44:23.232] io_start = [03:44:23.232] r = [03:44:23.232] #8 0x00000000006964fa in ReadPageInternal (state=state@entry=0x3d9af2c1d130, pageptr=67207168, reqLen=1904) at ../src/backend/access/transam/xlogreader.c:1061 [03:44:23.232] targetSegNo = 4 [03:44:23.232] targetPageOff = 98304 [03:44:23.232] readLen = [03:44:23.232] hdr = [03:44:23.232] err = [03:44:23.232] #9 0x0000000000695328 in XLogDecodeNextRecord (state=0x3d9af2c1d130, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:598 [03:44:23.232] errormsg = 0x2f000000300 [03:44:23.232] randAccess = [03:44:23.232] decoded = 0x0 [03:44:23.232] RecPtr = 67209048 [03:44:23.232] assembled = false [03:44:23.232] targetPagePtr = 67207168 [03:44:23.232] readOff = [03:44:23.232] record = [03:44:23.232] gotheader = [03:44:23.232] targetRecOff = 1880 [03:44:23.232] pageHeaderSize = [03:44:23.232] len = [03:44:23.232] total_len = [03:44:23.232] buffer = [03:44:23.232] gotlen = [03:44:23.232] pageHeader = [03:44:23.232] contdata = [03:44:23.232] save_copy = [03:44:23.232] #10 XLogReadAhead (state=0x3d9af2c1d130, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:974 [03:44:23.232] result = [03:44:23.232] #11 0x000000000068ca48 in XLogPrefetcherNextBlock (pgsr_private=67735708252040, lsn=0x3d9af2d70e48) at ../src/backend/access/transam/xlogprefetcher.c:490 [03:44:23.232] nonblocking = false [03:44:23.232] record = 0x0 [03:44:23.232] prefetcher = 0x3d9af2d43788 [03:44:23.232] reader = 0x3d9af2c1d130 [03:44:23.232] replaying_lsn = 67208640 [03:44:23.232] #12 0x000000000068c6b5 in lrq_prefetch (lrq=0x3d9af2d70bd8) at ../src/backend/access/transam/xlogprefetcher.c:252 [03:44:23.232] No locals. [03:44:23.232] #13 lrq_complete_lsn (lrq=0x3d9af2d70bd8, lsn=) at ../src/backend/access/transam/xlogprefetcher.c:290 [03:44:23.232] No locals. [03:44:23.232] #14 XLogPrefetcherReadRecord (prefetcher=prefetcher@entry=0x3d9af2d43788, errmsg=errmsg@entry=0x821303d60) at ../src/backend/access/transam/xlogprefetcher.c:1035 [03:44:23.232] replayed_up_to = [03:44:23.232] record = [03:44:23.232] #15 0x000000000069024a in ReadRecord (xlogprefetcher=0x3d9af2d43788, emode=emode@entry=15, fetching_ckpt=false, replayTLI=replayTLI@entry=2) at ../src/backend/access/transam/xlogrecovery.c:3162 [03:44:23.232] errormsg = 0x0 [03:44:23.232] xlogreader = 0x3d9af2c1d130 [03:44:23.232] private = [03:44:23.232] record = [03:44:23.232] #16 0x0000000000690b39 in PerformWalRecovery () at ../src/backend/access/transam/xlogrecovery.c:1840 [03:44:23.232] ru0 = {tv = {tv_sec = 1750995433, tv_usec = 71915}, ru = {ru_utime = {tv_sec = 0, tv_usec = 0}, ru_stime = {tv_sec = 0, tv_usec = 1245}, ru_maxrss = 0, ru_ixrss = 0, ru_idrss = 0, ru_isrss = 0, ru_minflt = 160, 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}} [03:44:23.232] xtime = [03:44:23.232] reachedRecoveryTarget = false [03:44:23.232] replayTLI = 2 [03:44:23.232] record = [03:44:23.232] #17 0x0000000000681223 in StartupXLOG () at ../src/backend/access/transam/xlog.c:6033 [03:44:23.232] wasShutdown = false [03:44:23.232] haveTblspcMap = false [03:44:23.232] haveBackupLabel = true [03:44:23.232] promoted = false [03:44:23.232] didCrash = [03:44:23.232] 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} [03:44:23.232] oldestActiveXID = [03:44:23.232] performedWalRecovery = [03:44:23.232] endOfRecoveryInfo = [03:44:23.232] EndOfLog = [03:44:23.232] EndOfLogTLI = [03:44:23.232] abortedRecPtr = [03:44:23.232] missingContrecPtr = [03:44:23.232] newTLI = [03:44:23.232] Insert = [03:44:23.232] #18 0x00000000008c44fb in StartupProcessMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/startup.c:258 [03:44:23.232] No locals. [03:44:23.232] #19 0x00000000008bdf8b 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 [03:44:23.232] pid = [03:44:23.232] #20 0x00000000008c0d67 in StartChildProcess (type=type@entry=B_STARTUP) at ../src/backend/postmaster/postmaster.c:3973 [03:44:23.232] pmchild = 0x0 [03:44:23.232] pid = [03:44:23.232] #21 0x00000000008c0762 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x821309130) at ../src/backend/postmaster/postmaster.c:1393 [03:44:23.232] userDoption = [03:44:23.232] listen_addr_saved = false [03:44:23.232] output_config_variable = [03:44:23.232] opt = [03:44:23.232] status = [03:44:23.232] #22 0x00000000007f36f0 in main (argc=4, argv=0x821309130) at ../src/backend/main/main.c:227 [03:44:23.232] do_check_root = [03:44:23.232] dispatch_option = DISPATCH_POSTMASTER [03:44:23.240] [03:44:23.240] [03:44:23.240] [03:44:23.292] dumping /tmp/cores/postgres.58838.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [03:44:23.415] [New LWP 100126] [03:44:23.488] Core was generated by `postgres: postgres regression [local] SET'. [03:44:23.488] Program terminated with signal SIGSEGV, Segmentation fault. [03:44:23.488] Address not mapped to object. [03:44:23.488] #0 pg_strcasecmp (s1=, s2=, s2@entry=0x3267ffe18c98 "checkpointer") at ../src/port/pgstrcasecmp.c:40 [03:44:23.488] 40 unsigned char ch1 = (unsigned char) *s1++; [03:44:23.520] [03:44:23.520] Thread 1 (LWP 100126): [03:44:23.520] #0 pg_strcasecmp (s1=, s2=, s2@entry=0x3267ffe18c98 "checkpointer") at ../src/port/pgstrcasecmp.c:40 [03:44:23.520] ch1 = [03:44:23.520] ch2 = [03:44:23.520] #1 0x0000000000774cbc in check_log_min_messages (newval=, extra=0x82199e8d8, source=) at ../src/backend/commands/variable.c:1380 [03:44:23.520] i = 12 [03:44:23.520] found = true [03:44:23.520] btype = 0x3267ffe18c98 "checkpointer" [03:44:23.520] loglevel = [03:44:23.520] entry = 0xbc6e70 [03:44:23.520] tok = [03:44:23.520] sep = [03:44:23.520] l__state = {l = 0x3267ffe18c48, i = 0} [03:44:23.520] elemlist = 0x3267ffe18c48 [03:44:23.520] newlevels = {320017171 , 13, 320017171, 320017171, 320017171, 320017171, 320017171, 320017171} [03:44:23.520] assigned = {false , true, false, false, false, false, false, false} [03:44:23.520] genericlevel = -1 [03:44:23.520] rawstring = 0x3267fff207b0 "checkpointer:debug2" [03:44:23.520] l = [03:44:23.520] #2 0x0000000000af3db4 in call_string_check_hook (conf=conf@entry=0xbf4120 , newval=newval@entry=0x82199e8e0, extra=extra@entry=0x82199e8d8, source=source@entry=PGC_S_SESSION, elevel=elevel@entry=21) at ../src/backend/utils/misc/guc.c:6923 [03:44:23.520] _local_sigjmp_buf = {{_sjb = {11484516, 34923472800, 34923472792, 34923472976, 13, 34923473112, 12534048, 12670568, 895, 34923473016, 39, 0}}} [03:44:23.520] _save_exception_stack = 0x82199eb20 [03:44:23.520] _save_context_stack = 0x0 [03:44:23.520] _do_rethrow = false [03:44:23.520] result = true [03:44:23.520] #3 0x0000000000af3669 in parse_and_validate_value (record=record@entry=0xbf4120 , value=, source=source@entry=PGC_S_SESSION, elevel=elevel@entry=21, newval=newval@entry=0x82199e8e0, newextra=newextra@entry=0x82199e8d8) at ../src/backend/utils/misc/guc.c:3257 [03:44:23.520] conf = 0xbf4120 [03:44:23.520] #4 0x0000000000af27f6 in set_config_with_handle (name=, handle=handle@entry=0x0, value=value@entry=0x3267ffe18838 "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 [03:44:23.520] conf = 0xbf4120 [03:44:23.520] orig_context = PGC_SUSET [03:44:23.520] orig_source = PGC_S_SESSION [03:44:23.520] orig_srole = 10 [03:44:23.520] newval_union = {boolval = 232, intval = -1841944, realval = 2.7382232776574622e-310, stringval = 0x3267ffe3e4e8 "checkpointer:debug2, autovacuum:debug1", enumval = -1841944} [03:44:23.520] newextra = 0x0 [03:44:23.520] prohibitValueChange = [03:44:23.520] record = 0xbf4120 [03:44:23.520] makeDefault = false [03:44:23.520] #5 0x0000000000aeeb12 in set_config_option (name=, value=0x3267ffe18838 "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 [03:44:23.520] srole = 34 [03:44:23.520] #6 0x0000000000af780e in ExecSetVariableStmt (stmt=stmt@entry=0x3267ff625d78, isTopLevel=) at ../src/backend/utils/misc/guc_funcs.c:62 [03:44:23.520] action = GUC_ACTION_SET [03:44:23.520] #7 0x000000000097a94c in standard_ProcessUtility (pstmt=0x3267ff625468, queryString=0x3267ff624100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x3267ff625f68, qc=0x82199ec20) at ../src/backend/tcop/utility.c:875 [03:44:23.520] isAtomicContext = false [03:44:23.520] parsetree = 0x3267ff625d78 [03:44:23.520] readonly_flags = [03:44:23.520] pstate = 0x3267fff20500 [03:44:23.520] isTopLevel = [03:44:23.520] #8 0x000000000097a2f8 in ProcessUtility (pstmt=0x0, queryString=0x0, readOnlyTree=, context=4280641784, params=0x2, queryEnv=0x22, dest=0x3267ff625f68, qc=0x82199ec20) at ../src/backend/tcop/utility.c:523 [03:44:23.520] No locals. [03:44:23.520] #9 0x0000000000979e2c in PortalRunUtility (portal=0x3267ff761100, pstmt=0x3267ff625468, isTopLevel=, setHoldSnapshot=false, dest=0x3267ff625f68, qc=0x82199ec20) at ../src/backend/tcop/pquery.c:1153 [03:44:23.520] No locals. [03:44:23.520] #10 0x00000000009794b4 in PortalRunMulti (portal=portal@entry=0x3267ff761100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x3267ff625f68, altdest=altdest@entry=0x3267ff625f68, qc=qc@entry=0x82199ec20) at ../src/backend/tcop/pquery.c:1317 [03:44:23.520] pstmt = 0x3267ff625468 [03:44:23.520] stmtlist_item__state = {l = 0x3267ff625f18, i = 0} [03:44:23.520] active_snapshot_set = false [03:44:23.520] stmtlist_item = 0x3267ff625f30 [03:44:23.520] #11 0x0000000000978dab in PortalRun (portal=portal@entry=0x3267ff761100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x3267ff625f68, altdest=altdest@entry=0x3267ff625f68, qc=qc@entry=0x82199ec20) at ../src/backend/tcop/pquery.c:788 [03:44:23.520] _local_sigjmp_buf = {{_sjb = {9932069, 55422248947968, 34923473688, 34923473936, 34923473696, 12670568, 34923473952, 12596440, 12583807, 0, 55422248944511, 55417963020288}}} [03:44:23.520] _save_exception_stack = 0x82199ecd0 [03:44:23.520] _save_context_stack = 0x0 [03:44:23.520] _do_rethrow = false [03:44:23.520] saveTopTransactionResourceOwner = 0x3267ff76deb8 [03:44:23.520] saveTopTransactionContext = 0x3267ff7c8000 [03:44:23.520] saveActivePortal = 0x0 [03:44:23.520] saveResourceOwner = 0x3267ff76deb8 [03:44:23.520] savePortalContext = 0x0 [03:44:23.520] saveMemoryContext = 0x3267ff7c8000 [03:44:23.520] result = [03:44:23.520] nprocessed = [03:44:23.520] #12 0x0000000000977be9 in exec_simple_query (query_string=query_string@entry=0x3267ff624100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';") at ../src/backend/tcop/postgres.c:1273 [03:44:23.520] cmdtaglen = 3 [03:44:23.520] snapshot_set = [03:44:23.520] per_parsetree_context = 0x0 [03:44:23.520] plantree_list = [03:44:23.520] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:44:23.520] format = 0 [03:44:23.520] parsetree = 0x3267ff625298 [03:44:23.520] commandTag = [03:44:23.520] cmdtagname = [03:44:23.520] querytree_list = [03:44:23.520] portal = 0x3267ff761100 [03:44:23.520] receiver = 0x3267ff625f68 [03:44:23.520] parsetree_item__state = {l = 0x3267ff625418, i = 0} [03:44:23.520] msec_str = "\000\000\000\000\b", '\000' , "p\354\231!\b\000\000\000U\372\377,\b\000\000" [03:44:23.520] dest = DestRemote [03:44:23.520] was_logged = [03:44:23.520] oldcontext = 0x3267ff7c8000 [03:44:23.520] parsetree_list = 0x3267ff625418 [03:44:23.520] use_implicit_block = false [03:44:23.520] parsetree_item = 0x3267ff625430 [03:44:23.520] save_log_statement_stats = [03:44:23.520] #13 0x0000000000975635 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [03:44:23.520] query_string = 0x3267ff624100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';" [03:44:23.520] input_message = {data = 0x3267ff624100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';", len = 66, maxlen = 1024, cursor = 66} [03:44:23.520] firstchar = [03:44:23.520] local_sigjmp_buf = {{_sjb = {9914923, 34923474128, 34923474120, 34923474720, 12470644, 12470376, 12679368, 12673284, 895, 0, 0, 34359738369}}} [03:44:23.520] send_ready_for_query = false [03:44:23.520] idle_in_transaction_timeout_enabled = false [03:44:23.520] idle_session_timeout_enabled = false [03:44:23.520] #14 0x000000000096fb39 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [03:44:23.520] bsdata = [03:44:23.520] #15 0x00000000008bdf8b in postmaster_child_launch (child_type=B_BACKEND, child_slot=16, startup_data=startup_data@entry=0x82199f988, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x82199f9a0) at ../src/backend/postmaster/launch_backend.c:290 [03:44:23.520] pid = [03:44:23.520] #16 0x00000000008c28f8 in BackendStartup (client_sock=0x82199f9a0) at ../src/backend/postmaster/postmaster.c:3580 [03:44:23.520] startup_data = {canAcceptConnections = CAC_OK, socket_created = 804310718289885, fork_started = } [03:44:23.520] bn = 0x3267ff72d308 [03:44:23.520] cac = CAC_OK [03:44:23.520] pid = [03:44:23.520] __error = [03:44:23.520] save_errno = [03:44:23.520] __error = [03:44:23.520] __error = [03:44:23.520] #17 ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [03:44:23.520] 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' , "\372\231!\b\000\000\000X\3263,\b\000\000\000\032\001\000\000\000\000\000\000\276^4,\b", '\000' , "@\372\231!\b\000\000\000\324܋\000\000\000\000\000P\372\231!\b", '\000' }, salen = 16}} [03:44:23.520] i = 0 [03:44:23.520] now = [03:44:23.520] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 754611596, user_data = 0x0}, {pos = 563738960, events = 8, fd = -9972264, user_data = 0x82199f7e0}, {pos = -1955341533, events = 2326092552, fd = -9068544, user_data = 0x2000}, {pos = 4096, events = 0, fd = 563737920, user_data = 0x1}, {pos = 563737728, events = 8, fd = 755457280, user_data = 0x1}, {pos = 4096, events = 0, fd = 232, user_data = 0x0}, {pos = 753766256, events = 8, fd = 753844380, user_data = 0x82199f548}, {pos = 563737912, events = 8, fd = 32, user_data = 0x3267ff400980}, {pos = 563737792, events = 8, fd = 563679949, user_data = 0x82cedd410}, {pos = 753844380, events = 8, fd = 563737816, user_data = 0x82199f550}, {pos = 753817908, events = 8, fd = 753817908, user_data = 0x3267ff20a408}, {pos = 3, events = 0, fd = 563737920, user_data = 0x3f102198c4fb}, {pos = -9977856, events = 12903, fd = 0, user_data = 0x0}, {pos = 0, events = 12903, fd = -14331712, user_data = 0x1000}, {pos = 8192, events = 0, fd = 4097, user_data = 0x82199f790}, {pos = -14617944, events = 12903, fd = 753783824, user_data = 0x3267ff20a408}, {pos = 563738072, events = 8, fd = 563738520, user_data = 0x82199f5c0}, {pos = 563678290, events = 16144, fd = 2735354, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = -14614448, user_data = 0x800000001}, {pos = 0, events = 0, fd = 0, user_data = 0x82199f898}, {pos = -10418848, events = 3, fd = 563738600, user_data = 0x3267ff20fae8}, {pos = 656, events = 0, fd = 563738520, user_data = 0x82199f5d8}, {pos = 563738176, events = 8, fd = 563677899, user_data = 0x82199f858}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -14614448, events = 12903, fd = 1, user_data = 0x3267ff20a408}, {pos = 753783824, events = 8, fd = 563738776, user_data = 0x82199f7e8}, {pos = 563738192, events = 8, fd = 0, user_data = 0x3267ff203008}, {pos = 32, events = 0, fd = 563738576, user_data = 0x3f102198ac77}, {pos = -14667768, events = 12903, fd = -14666744, user_data = 0x3267ff203808}, {pos = -14664696, events = 12903, fd = -14651384, user_data = 0x3267ff207408}, {pos = -14649336, events = 12903, fd = -14648312, user_data = 0x3267ff208008}, {pos = -14646264, events = 12903, fd = -14645240, user_data = 0x3267ff208c08}, {pos = -14643192, events = 12903, fd = -14642168, user_data = 0x3267ff209808}, {pos = -14640120, events = 12903, fd = -14639096, user_data = 0x3267ff20a408}, {pos = -14637048, events = 12903, fd = -14636024, user_data = 0x3267ff20b008}, {pos = -14633976, events = 12903, fd = -14632952, user_data = 0x3267ff20bc08}, {pos = -14630904, events = 12903, fd = -14629880, user_data = 0x3267ff20c808}, {pos = -14627832, events = 12903, fd = -14622712, user_data = 0x3267ff20e408}, {pos = -14620664, events = 12903, fd = -14619640, user_data = 0x3267ff203008}, {pos = 2735354, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -14614448, events = 12903, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 563738776, user_data = 0x82199f650}, {pos = 32, events = 32, fd = -14667768, user_data = 0x37b}, {pos = 2113896, events = 0, fd = 297, user_data = 0x3267ff210050}, {pos = 563738752, events = 8, fd = 563652481, user_data = 0x3267ff631000}, {pos = 2735354, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -14614448, events = 12903, fd = 1, user_data = 0x3267ff20a408}, {pos = 12558120, events = 0, fd = 754978576, user_data = 0x3267ff203008}, {pos = 2839440, events = 0, fd = 741627065, user_data = 0x1}, {pos = -10412032, events = 12903, fd = 563738752, user_data = 0x82c344642}, {pos = 754978576, events = 8, fd = 12558120, user_data = 0x82d000f10 }, {pos = -14638072, events = 12903, fd = 563738976, user_data = 0x3f102198a574}, {pos = 563738832, events = 8, fd = 1, user_data = 0x3f102198a3ee}, {pos = -14667768, events = 12903, fd = 563738760, user_data = 0x82199f960}, {pos = 6816, events = 0, fd = 12, user_data = 0x3f102199e3a0}, {pos = 0, events = 0, fd = -10353793, user_data = 0xc178c0 }, {pos = 563738896, events = 8, fd = 741586272, user_data = 0x82d0a5460 <__thr_jtable>}, {pos = 755660624, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 563738944, events = 8, fd = 741586272, user_data = 0x82d0a5460 <__thr_jtable>}, {pos = 755660624, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 563738992, events = 8, fd = 741628669, user_data = 0x3267ff612000}, {pos = 7337, events = 0, fd = 563739088, user_data = 0x82c33d9ea}} [03:44:23.520] last_touch_time = 1750995390 [03:44:23.520] last_lockfile_recheck_time = 1750995510 [03:44:23.520] nevents = 1 [03:44:23.520] #18 0x00000000008c079a in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x82199ffe0) at ../src/backend/postmaster/postmaster.c:1400 [03:44:23.520] userDoption = [03:44:23.520] listen_addr_saved = false [03:44:23.520] output_config_variable = [03:44:23.520] opt = [03:44:23.520] status = [03:44:23.520] #19 0x00000000007f36f0 in main (argc=8, argv=0x82199ffe0) at ../src/backend/main/main.c:227 [03:44:23.520] do_check_root = [03:44:23.520] dispatch_option = DISPATCH_POSTMASTER [03:44:23.528] [03:44:23.528] [03:44:23.528] [03:44:23.584] dumping /tmp/cores/postgres.59595.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:44:23.707] [New LWP 102114] [03:44:23.779] Core was generated by `postgres: old_node: postgres regression [local] SET'. [03:44:23.779] Program terminated with signal SIGSEGV, Segmentation fault. [03:44:23.779] Address not mapped to object. [03:44:23.779] #0 pg_strcasecmp (s1=, s2=, s2@entry=0x1137a001cc98 "checkpointer") at ../src/port/pgstrcasecmp.c:40 [03:44:23.779] 40 unsigned char ch1 = (unsigned char) *s1++; [03:44:23.810] [03:44:23.810] Thread 1 (LWP 102114): [03:44:23.810] #0 pg_strcasecmp (s1=, s2=, s2@entry=0x1137a001cc98 "checkpointer") at ../src/port/pgstrcasecmp.c:40 [03:44:23.810] ch1 = [03:44:23.810] ch2 = [03:44:23.810] #1 0x0000000000774cbc in check_log_min_messages (newval=, extra=0x8217882b8, source=) at ../src/backend/commands/variable.c:1380 [03:44:23.810] i = 12 [03:44:23.810] found = true [03:44:23.810] btype = 0x1137a001cc98 "checkpointer" [03:44:23.810] loglevel = [03:44:23.810] entry = 0xbc6e70 [03:44:23.810] tok = [03:44:23.810] sep = [03:44:23.810] l__state = {l = 0x1137a001cc48, i = 0} [03:44:23.810] elemlist = 0x1137a001cc48 [03:44:23.810] newlevels = {320017171 , 13, 320017171, 320017171, 320017171, 320017171, 320017171, 320017171} [03:44:23.810] assigned = {false , true, false, false, false, false, false, false} [03:44:23.810] genericlevel = -1 [03:44:23.810] rawstring = 0x11379f83dfb0 "checkpointer:debug2" [03:44:23.810] l = [03:44:23.810] #2 0x0000000000af3db4 in call_string_check_hook (conf=conf@entry=0xbf4120 , newval=newval@entry=0x8217882c0, extra=extra@entry=0x8217882b8, source=source@entry=PGC_S_SESSION, elevel=elevel@entry=21) at ../src/backend/utils/misc/guc.c:6923 [03:44:23.810] _local_sigjmp_buf = {{_sjb = {11484516, 34921283968, 34921283960, 34921284144, 13, 34921284280, 12534048, 12670568, 895, 34921284184, 39, 0}}} [03:44:23.810] _save_exception_stack = 0x821788500 [03:44:23.810] _save_context_stack = 0x0 [03:44:23.810] _do_rethrow = false [03:44:23.810] result = true [03:44:23.810] #3 0x0000000000af3669 in parse_and_validate_value (record=record@entry=0xbf4120 , value=, source=source@entry=PGC_S_SESSION, elevel=elevel@entry=21, newval=newval@entry=0x8217882c0, newextra=newextra@entry=0x8217882b8) at ../src/backend/utils/misc/guc.c:3257 [03:44:23.810] conf = 0xbf4120 [03:44:23.810] #4 0x0000000000af27f6 in set_config_with_handle (name=, handle=handle@entry=0x0, value=value@entry=0x1137a001c838 "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 [03:44:23.810] conf = 0xbf4120 [03:44:23.810] orig_context = PGC_SUSET [03:44:23.810] orig_source = PGC_S_SESSION [03:44:23.810] orig_srole = 10 [03:44:23.810] newval_union = {boolval = 136, intval = -1618829432, realval = 9.3529576385660925e-311, stringval = 0x11379f829f88 "checkpointer:debug2, autovacuum:debug1", enumval = -1618829432} [03:44:23.810] newextra = 0x0 [03:44:23.810] prohibitValueChange = [03:44:23.810] record = 0xbf4120 [03:44:23.810] makeDefault = false [03:44:23.810] #5 0x0000000000aeeb12 in set_config_option (name=, value=0x1137a001c838 "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 [03:44:23.810] srole = 34 [03:44:23.810] #6 0x0000000000af780e in ExecSetVariableStmt (stmt=stmt@entry=0x11379f825d78, isTopLevel=) at ../src/backend/utils/misc/guc_funcs.c:62 [03:44:23.810] action = GUC_ACTION_SET [03:44:23.810] #7 0x000000000097a94c in standard_ProcessUtility (pstmt=0x11379f825468, queryString=0x11379f824100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x11379f825f68, qc=0x821788600) at ../src/backend/tcop/utility.c:875 [03:44:23.810] isAtomicContext = false [03:44:23.810] parsetree = 0x11379f825d78 [03:44:23.810] readonly_flags = [03:44:23.810] pstate = 0x11379f83dd00 [03:44:23.810] isTopLevel = [03:44:23.810] #8 0x000000000097a2f8 in ProcessUtility (pstmt=0x0, queryString=0x0, readOnlyTree=, context=2672126200, params=0x2, queryEnv=0x22, dest=0x11379f825f68, qc=0x821788600) at ../src/backend/tcop/utility.c:523 [03:44:23.810] No locals. [03:44:23.810] #9 0x0000000000979e2c in PortalRunUtility (portal=0x11379f90d100, pstmt=0x11379f825468, isTopLevel=, setHoldSnapshot=false, dest=0x11379f825f68, qc=0x821788600) at ../src/backend/tcop/pquery.c:1153 [03:44:23.810] No locals. [03:44:23.810] #10 0x00000000009794b4 in PortalRunMulti (portal=portal@entry=0x11379f90d100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x11379f825f68, altdest=altdest@entry=0x11379f825f68, qc=qc@entry=0x821788600) at ../src/backend/tcop/pquery.c:1317 [03:44:23.810] pstmt = 0x11379f825468 [03:44:23.810] stmtlist_item__state = {l = 0x11379f825f18, i = 0} [03:44:23.810] active_snapshot_set = false [03:44:23.810] stmtlist_item = 0x11379f825f30 [03:44:23.810] #11 0x0000000000978dab in PortalRun (portal=portal@entry=0x11379f90d100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x11379f825f68, altdest=altdest@entry=0x11379f825f68, qc=qc@entry=0x821788600) at ../src/backend/tcop/pquery.c:788 [03:44:23.810] _local_sigjmp_buf = {{_sjb = {9932069, 18930597941504, 34921284856, 34921285104, 34921284864, 12670568, 34921285120, 12596440, 12583807, 0, 18930598282111, 18927920873472}}} [03:44:23.810] _save_exception_stack = 0x8217886b0 [03:44:23.810] _save_context_stack = 0x0 [03:44:23.810] _do_rethrow = false [03:44:23.810] saveTopTransactionResourceOwner = 0x11379f972748 [03:44:23.810] saveTopTransactionContext = 0x11379f9ad000 [03:44:23.810] saveActivePortal = 0x0 [03:44:23.810] saveResourceOwner = 0x11379f972748 [03:44:23.810] savePortalContext = 0x0 [03:44:23.810] saveMemoryContext = 0x11379f9ad000 [03:44:23.810] result = [03:44:23.810] nprocessed = [03:44:23.810] #12 0x0000000000977be9 in exec_simple_query (query_string=query_string@entry=0x11379f824100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';") at ../src/backend/tcop/postgres.c:1273 [03:44:23.810] cmdtaglen = 3 [03:44:23.810] snapshot_set = [03:44:23.810] per_parsetree_context = 0x0 [03:44:23.810] plantree_list = [03:44:23.810] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:44:23.810] format = 0 [03:44:23.810] parsetree = 0x11379f825298 [03:44:23.810] commandTag = [03:44:23.810] cmdtagname = [03:44:23.810] querytree_list = [03:44:23.810] portal = 0x11379f90d100 [03:44:23.810] receiver = 0x11379f825f68 [03:44:23.810] parsetree_item__state = {l = 0x11379f825418, i = 0} [03:44:23.810] msec_str = "\000\000\000\000\b", '\000' , "P\206x!\b\000\000\000UZ8-\b\000\000" [03:44:23.810] dest = DestRemote [03:44:23.810] was_logged = [03:44:23.810] oldcontext = 0x11379f9ad000 [03:44:23.810] parsetree_list = 0x11379f825418 [03:44:23.810] use_implicit_block = false [03:44:23.810] parsetree_item = 0x11379f825430 [03:44:23.810] save_log_statement_stats = [03:44:23.810] #13 0x0000000000975635 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [03:44:23.810] query_string = 0x11379f824100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';" [03:44:23.810] input_message = {data = 0x11379f824100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';", len = 66, maxlen = 1024, cursor = 66} [03:44:23.810] firstchar = [03:44:23.810] local_sigjmp_buf = {{_sjb = {9914923, 34921285296, 34921285288, 34921285888, 12470644, 12470376, 12679368, 12673284, 895, 0, 0, 18927920873473}}} [03:44:23.810] send_ready_for_query = false [03:44:23.810] idle_in_transaction_timeout_enabled = false [03:44:23.810] idle_session_timeout_enabled = false [03:44:23.810] #14 0x000000000096fb39 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [03:44:23.810] bsdata = [03:44:23.810] #15 0x00000000008bdf8b in postmaster_child_launch (child_type=B_BACKEND, child_slot=2, startup_data=startup_data@entry=0x821789368, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x821789380) at ../src/backend/postmaster/launch_backend.c:290 [03:44:23.810] pid = [03:44:23.810] #16 0x00000000008c28f8 in BackendStartup (client_sock=0x821789380) at ../src/backend/postmaster/postmaster.c:3580 [03:44:23.810] startup_data = {canAcceptConnections = CAC_OK, socket_created = 804310721115252, fork_started = } [03:44:23.810] bn = 0x11379f941068 [03:44:23.810] cac = CAC_OK [03:44:23.810] pid = [03:44:23.810] __error = [03:44:23.810] save_errno = [03:44:23.810] __error = [03:44:23.810] __error = [03:44:23.810] #17 ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [03:44:23.810] 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' , "\340\223x!\b\000\000\000X62,\b\000\000\000\006\001\000\000\000\000\000\000\276\2762,\b", '\000' , " \224x!\b\000\000\000\324܋\000\000\000\000\0000\224x!\b", '\000' }, salen = 16}} [03:44:23.810] i = 0 [03:44:23.810] now = [03:44:23.810] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 561549824, events = 8, fd = 758306188, user_data = 0x0}, {pos = 561550128, events = 8, fd = -1618450984, user_data = 0x8217891c0}, {pos = 0, events = 0, fd = 0, user_data = 0xebe8e42082b1155c}, {pos = 759418304, events = 8, fd = 561548848, user_data = 0xcdb334142cd}, {pos = 757463992, events = 8, fd = 757538972, user_data = 0x821788e48}, {pos = 561548992, events = 8, fd = 561548896, user_data = 0xcdb334142cd}, {pos = 757460848, events = 8, fd = 757538972, user_data = 0x821788e78}, {pos = 561549040, events = 8, fd = 757509572, user_data = 0x82d26adc4}, {pos = 561548960, events = 8, fd = 859914957, user_data = 0x82d263410}, {pos = 757538972, events = 8, fd = 561548984, user_data = 0x821788f30}, {pos = 757512500, events = 8, fd = 757512500, user_data = 0x11379f40a408}, {pos = 3, events = 0, fd = 561549088, user_data = 0xcdb3340f4fb}, {pos = 561549104, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 561549176, user_data = 0x821789138}, {pos = 561549152, events = 8, fd = 859913298, user_data = 0x295eec}, {pos = -1623133528, events = 4407, fd = 757478416, user_data = 0x11379f40a408}, {pos = 561549240, events = 8, fd = 561549688, user_data = 0x821788fa0}, {pos = 859913298, events = 3291, fd = 2735354, user_data = 0x6d68b}, {pos = 2090263927, events = 8, fd = -1623130032, user_data = 0x800000001}, {pos = 0, events = 0, fd = 0, user_data = 0x821789278}, {pos = -1618934336, events = 3, fd = 561549768, user_data = 0x11379f40fae8}, {pos = 656, events = 0, fd = 561549688, user_data = 0x821788fb8}, {pos = 561549344, events = 8, fd = 859912907, user_data = 0x821789238}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1623130032, events = 4407, fd = 1, user_data = 0x11379f40a408}, {pos = 757478416, events = 8, fd = 561549944, user_data = 0x8217891c8}, {pos = 561549360, events = 8, fd = 0, user_data = 0x11379f403008}, {pos = 32, events = 0, fd = 561549744, user_data = 0xcdb3340dc77}, {pos = -1623183352, events = 4407, fd = -1623182328, user_data = 0x11379f403808}, {pos = -1623180280, events = 4407, fd = -1623166968, user_data = 0x11379f407408}, {pos = -1623164920, events = 4407, fd = -1623163896, user_data = 0x11379f408008}, {pos = -1623161848, events = 4407, fd = -1623160824, user_data = 0x11379f408c08}, {pos = -1623158776, events = 4407, fd = -1623157752, user_data = 0x11379f409808}, {pos = -1623155704, events = 4407, fd = -1623154680, user_data = 0x11379f40a408}, {pos = -1623152632, events = 4407, fd = -1623151608, user_data = 0x11379f40b008}, {pos = -1623149560, events = 4407, fd = -1623148536, user_data = 0x11379f40bc08}, {pos = -1623146488, events = 4407, fd = -1623145464, user_data = 0x11379f40c808}, {pos = -1623143416, events = 4407, fd = -1623138296, user_data = 0x11379f40e408}, {pos = -1623136248, events = 4407, fd = -1623135224, user_data = 0x11379f403008}, {pos = 2735354, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -1623130032, events = 4407, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 561549944, user_data = 0x821789030}, {pos = 32, events = 32, fd = -1623183352, user_data = 0x37b}, {pos = 2113896, events = 0, fd = 297, user_data = 0x11379f410050}, {pos = 561549920, events = 8, fd = 859887489, user_data = 0x11379f831000}, {pos = 2735354, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -1623130032, events = 4407, fd = 1, user_data = 0x11379f40a408}, {pos = 12558120, events = 0, fd = 758673168, user_data = 0x11379f403008}, {pos = 2839440, events = 0, fd = 741520569, user_data = 0x1}, {pos = -1618927616, events = 4407, fd = 561549920, user_data = 0x82c32a642}, {pos = 758673168, events = 8, fd = 12558120, user_data = 0x82d386f10 }, {pos = -1623153656, events = 4407, fd = 561550144, user_data = 0xcdb3340d574}, {pos = 561550000, events = 8, fd = 1, user_data = 0xcdb3340d3ee}, {pos = -1623183352, events = 4407, fd = 561549928, user_data = 0x821789340}, {pos = 6816, events = 0, fd = 12, user_data = 0xcdb334213a0}, {pos = 0, events = 0, fd = -1618869377, user_data = 0xc178c0 }, {pos = 561550064, events = 8, fd = 741479776, user_data = 0x82d42b460 <__thr_jtable>}, {pos = 759355216, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 561550112, events = 8, fd = 741479776, user_data = 0x82d42b460 <__thr_jtable>}, {pos = 759355216, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 561550160, events = 8, fd = 741522173, user_data = 0x11379f812000}, {pos = 7359, events = 0, fd = 561550256, user_data = 0x82c3239ea}} [03:44:23.810] last_touch_time = 1750995390 [03:44:23.810] last_lockfile_recheck_time = 1750995510 [03:44:23.810] nevents = 1 [03:44:23.810] #18 0x00000000008c079a in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x8217899c8) at ../src/backend/postmaster/postmaster.c:1400 [03:44:23.810] userDoption = [03:44:23.810] listen_addr_saved = false [03:44:23.810] output_config_variable = [03:44:23.810] opt = [03:44:23.810] status = [03:44:23.810] #19 0x00000000007f36f0 in main (argc=4, argv=0x8217899c8) at ../src/backend/main/main.c:227 [03:44:23.810] do_check_root = [03:44:23.810] dispatch_option = DISPATCH_POSTMASTER [03:44:23.817] [03:44:23.817] [03:44:23.817] [03:44:23.873] dumping /tmp/cores/postgres.78531.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [03:44:23.995] [New LWP 101896] [03:44:24.068] Core was generated by `postgres: primary: postgres regression [local] SET'. [03:44:24.068] Program terminated with signal SIGSEGV, Segmentation fault. [03:44:24.068] Address not mapped to object. [03:44:24.068] #0 pg_strcasecmp (s1=, s2=, s2@entry=0x15dd9b072498 "checkpointer") at ../src/port/pgstrcasecmp.c:40 [03:44:24.068] 40 unsigned char ch1 = (unsigned char) *s1++; [03:44:24.106] [03:44:24.106] Thread 1 (LWP 101896): [03:44:24.106] #0 pg_strcasecmp (s1=, s2=, s2@entry=0x15dd9b072498 "checkpointer") at ../src/port/pgstrcasecmp.c:40 [03:44:24.106] ch1 = [03:44:24.106] ch2 = [03:44:24.106] #1 0x0000000000774cbc in check_log_min_messages (newval=, extra=0x82170c9d8, source=) at ../src/backend/commands/variable.c:1380 [03:44:24.106] i = 12 [03:44:24.106] found = true [03:44:24.106] btype = 0x15dd9b072498 "checkpointer" [03:44:24.106] loglevel = [03:44:24.106] entry = 0xbc6e70 [03:44:24.106] tok = [03:44:24.106] sep = [03:44:24.106] l__state = {l = 0x15dd9b072448, i = 0} [03:44:24.106] elemlist = 0x15dd9b072448 [03:44:24.106] newlevels = {320017171 , 13, 320017171, 320017171, 320017171, 320017171, 320017171, 320017171} [03:44:24.106] assigned = {false , true, false, false, false, false, false, false} [03:44:24.106] genericlevel = -1 [03:44:24.106] rawstring = 0x15dd9b8f6fb0 "checkpointer:debug2" [03:44:24.106] l = [03:44:24.106] #2 0x0000000000af3db4 in call_string_check_hook (conf=conf@entry=0xbf4120 , newval=newval@entry=0x82170c9e0, extra=extra@entry=0x82170c9d8, source=source@entry=PGC_S_SESSION, elevel=elevel@entry=21) at ../src/backend/utils/misc/guc.c:6923 [03:44:24.106] _local_sigjmp_buf = {{_sjb = {11484516, 34920777888, 34920777880, 34920778064, 13, 34920778200, 12534048, 12670568, 895, 34920778104, 39, 0}}} [03:44:24.106] _save_exception_stack = 0x82170cc10 [03:44:24.106] _save_context_stack = 0x0 [03:44:24.106] _do_rethrow = false [03:44:24.106] result = true [03:44:24.106] #3 0x0000000000af3669 in parse_and_validate_value (record=record@entry=0xbf4120 , value=, source=source@entry=PGC_S_SESSION, elevel=elevel@entry=21, newval=newval@entry=0x82170c9e0, newextra=newextra@entry=0x82170c9d8) at ../src/backend/utils/misc/guc.c:3257 [03:44:24.106] conf = 0xbf4120 [03:44:24.106] #4 0x0000000000af27f6 in set_config_with_handle (name=, handle=handle@entry=0x0, value=value@entry=0x15dd9b072038 "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 [03:44:24.106] conf = 0xbf4120 [03:44:24.106] orig_context = PGC_SUSET [03:44:24.106] orig_source = PGC_S_SESSION [03:44:24.106] orig_srole = 10 [03:44:24.106] newval_union = {boolval = 224, intval = -1685855008, realval = 1.1878099514780272e-310, stringval = 0x15dd9b83e4e0 "checkpointer:debug2, autovacuum:debug1", enumval = -1685855008} [03:44:24.106] newextra = 0x0 [03:44:24.106] prohibitValueChange = [03:44:24.106] record = 0xbf4120 [03:44:24.106] makeDefault = false [03:44:24.106] #5 0x0000000000aeeb12 in set_config_option (name=, value=0x15dd9b072038 "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 [03:44:24.106] srole = 34 [03:44:24.106] #6 0x0000000000af780e in ExecSetVariableStmt (stmt=stmt@entry=0x15dd9b025fd8, isTopLevel=) at ../src/backend/utils/misc/guc_funcs.c:62 [03:44:24.106] action = GUC_ACTION_SET [03:44:24.106] #7 0x000000000097a94c in standard_ProcessUtility (pstmt=pstmt@entry=0x15dd9b025468, queryString=queryString@entry=0x15dd9b024100 "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=0x15dd9b1b3608, qc=0x82170cef0) at ../src/backend/tcop/utility.c:875 [03:44:24.106] isAtomicContext = false [03:44:24.106] parsetree = 0x15dd9b025fd8 [03:44:24.106] readonly_flags = [03:44:24.106] pstate = 0x15dd9b8f6d00 [03:44:24.106] isTopLevel = [03:44:24.106] #8 0x000000083734800c in pgss_ProcessUtility (pstmt=0x15dd9b025468, queryString=0x15dd9b024100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x15dd9b1b3608, qc=0x82170cef0) at ../contrib/pg_stat_statements/pg_stat_statements.c:1173 [03:44:24.106] _local_sigjmp_buf = {{_sjb = {35285925686, 34920778768, 34920778568, 34920779040, 24041532576872, 0, 12670568, 34920779248, 895, 24041534206245, 0, 549755813888}}} [03:44:24.106] _save_exception_stack = 0x82170cdf0 [03:44:24.106] _save_context_stack = 0x0 [03:44:24.106] _do_rethrow = false [03:44:24.106] bufusage = {shared_blks_hit = 35285925686, shared_blks_read = 34920778768, shared_blks_dirtied = 34920778568, shared_blks_written = 34920779040, local_blks_hit = 24041532576872, local_blks_read = 0, local_blks_dirtied = 12670568, local_blks_written = 34920779248, temp_blks_read = 895, temp_blks_written = 24041534206245, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 549755813888}, local_blk_read_time = {ticks = 2576171236906806313}, local_blk_write_time = {ticks = 24041532579800}, temp_blk_read_time = {ticks = 1}, temp_blk_write_time = {ticks = 123}} [03:44:24.106] walusage_start = {wal_records = 865, wal_fpi = 2, wal_bytes = 100565, wal_buffers_full = 0} [03:44:24.106] duration = [03:44:24.106] bufusage_start = {shared_blks_hit = 9649, shared_blks_read = 674, shared_blks_dirtied = 122, shared_blks_written = 106, local_blks_hit = 0, local_blks_read = 0, local_blks_dirtied = 0, local_blks_written = 0, temp_blks_read = 0, temp_blks_written = 0, shared_blk_read_time = {ticks = 0}, shared_blk_write_time = {ticks = 0}, local_blk_read_time = {ticks = 0}, local_blk_write_time = {ticks = 0}, temp_blk_read_time = {ticks = 0}, temp_blk_write_time = {ticks = 0}} [03:44:24.106] walusage = {wal_records = 0, wal_fpi = 1, wal_bytes = 24041534207096, wal_buffers_full = 34920778868} [03:44:24.106] start = {ticks = -315523548889} [03:44:24.106] rows = [03:44:24.106] saved_queryId = 4159730094505376283 [03:44:24.106] parsetree = [03:44:24.106] saved_stmt_location = 0 [03:44:24.106] saved_stmt_len = 64 [03:44:24.106] enabled = [03:44:24.106] #9 0x0000000000979e2c in PortalRunUtility (portal=0x15dd9b10b100, pstmt=0x15dd9b025468, isTopLevel=, setHoldSnapshot=false, dest=0x15dd9b1b3608, qc=0x82170cef0) at ../src/backend/tcop/pquery.c:1153 [03:44:24.106] No locals. [03:44:24.106] #10 0x00000000009794b4 in PortalRunMulti (portal=portal@entry=0x15dd9b10b100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x15dd9b1b3608, altdest=altdest@entry=0x15dd9b1b3608, qc=qc@entry=0x82170cef0) at ../src/backend/tcop/pquery.c:1317 [03:44:24.106] pstmt = 0x15dd9b025468 [03:44:24.106] stmtlist_item__state = {l = 0x15dd9b1b35b8, i = 0} [03:44:24.106] active_snapshot_set = false [03:44:24.106] stmtlist_item = 0x15dd9b1b35d0 [03:44:24.106] #11 0x0000000000978dab in PortalRun (portal=portal@entry=0x15dd9b10b100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x15dd9b1b3608, altdest=altdest@entry=0x15dd9b1b3608, qc=qc@entry=0x82170cef0) at ../src/backend/tcop/pquery.c:788 [03:44:24.106] _local_sigjmp_buf = {{_sjb = {9932069, 24041533518080, 34920779240, 34920779488, 34920779248, 12670568, 34920779504, 12596440, 12583807, 0, 24041533473663, 24038931955712}}} [03:44:24.106] _save_exception_stack = 0x82170cfa0 [03:44:24.106] _save_context_stack = 0x0 [03:44:24.106] _do_rethrow = false [03:44:24.106] saveTopTransactionResourceOwner = 0x15dd9b155f08 [03:44:24.106] saveTopTransactionContext = 0x15dd9b1ab000 [03:44:24.106] saveActivePortal = 0x0 [03:44:24.106] saveResourceOwner = 0x15dd9b155f08 [03:44:24.106] savePortalContext = 0x0 [03:44:24.106] saveMemoryContext = 0x15dd9b1ab000 [03:44:24.106] result = [03:44:24.106] nprocessed = [03:44:24.106] #12 0x0000000000977be9 in exec_simple_query (query_string=query_string@entry=0x15dd9b024100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';") at ../src/backend/tcop/postgres.c:1273 [03:44:24.106] cmdtaglen = 3 [03:44:24.106] snapshot_set = [03:44:24.106] per_parsetree_context = 0x0 [03:44:24.106] plantree_list = [03:44:24.106] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [03:44:24.106] format = 0 [03:44:24.106] parsetree = 0x15dd9b025298 [03:44:24.106] commandTag = [03:44:24.106] cmdtagname = [03:44:24.106] querytree_list = [03:44:24.106] portal = 0x15dd9b10b100 [03:44:24.106] receiver = 0x15dd9b1b3608 [03:44:24.106] parsetree_item__state = {l = 0x15dd9b025418, i = 0} [03:44:24.106] msec_str = "\000\000\000\000\b", '\000' , "@\317p!\b\000\000\000U\232K,\b\000\000" [03:44:24.106] dest = DestRemote [03:44:24.106] was_logged = [03:44:24.106] oldcontext = 0x15dd9b1ab000 [03:44:24.106] parsetree_list = 0x15dd9b025418 [03:44:24.106] use_implicit_block = false [03:44:24.106] parsetree_item = 0x15dd9b025430 [03:44:24.106] save_log_statement_stats = [03:44:24.106] #13 0x0000000000975635 in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4762 [03:44:24.106] query_string = 0x15dd9b024100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';" [03:44:24.106] input_message = {data = 0x15dd9b024100 "SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1';", len = 66, maxlen = 1024, cursor = 66} [03:44:24.106] firstchar = [03:44:24.106] local_sigjmp_buf = {{_sjb = {9914923, 34920779680, 34920779672, 34920780272, 12470644, 12470376, 12679368, 12673284, 895, 0, 0, 34359738369}}} [03:44:24.106] send_ready_for_query = false [03:44:24.106] idle_in_transaction_timeout_enabled = false [03:44:24.106] idle_session_timeout_enabled = false [03:44:24.106] #14 0x000000000096fb39 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [03:44:24.106] bsdata = [03:44:24.106] #15 0x00000000008bdf8b in postmaster_child_launch (child_type=B_BACKEND, child_slot=16, startup_data=startup_data@entry=0x82170dc58, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x82170dc70) at ../src/backend/postmaster/launch_backend.c:290 [03:44:24.106] pid = [03:44:24.106] #16 0x00000000008c28f8 in BackendStartup (client_sock=0x82170dc70) at ../src/backend/postmaster/postmaster.c:3580 [03:44:24.106] startup_data = {canAcceptConnections = CAC_OK, socket_created = 804310789430281, fork_started = } [03:44:24.106] bn = 0x15dd9b141988 [03:44:24.106] cac = CAC_OK [03:44:24.106] pid = [03:44:24.106] __error = [03:44:24.106] save_errno = [03:44:24.106] __error = [03:44:24.106] __error = [03:44:24.106] #17 ServerLoop () at ../src/backend/postmaster/postmaster.c:1702 [03:44:24.106] 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' , "\320\334p!\b\000\000\000Xv\353+\b\000\000\000w\000\000\000\000\000\000\000\276\376\353+\b", '\000' , "\020\335p!\b\000\000\000\324܋\000\000\000\000\000 \335p!\b", '\000' }, salen = 16}} [03:44:24.106] i = 0 [03:44:24.106] now = [03:44:24.106] events = {{pos = 1, events = 2, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 5, user_data = 0x0}, {pos = 0, events = 0, fd = 742790540, user_data = 0x0}, {pos = 561044512, events = 8, fd = -1693977128, user_data = 0x82170dab0}, {pos = 0, events = 0, fd = 0, user_data = 0x82170d710}, {pos = 1694438093, events = 12742, fd = 741948344, user_data = 0x82c3a609c}, {pos = 561043240, events = 8, fd = 561043360, user_data = 0x82170d740}, {pos = 1694438093, events = 12742, fd = 741945200, user_data = 0x82c3a609c}, {pos = 561043288, events = 8, fd = 561043408, user_data = 0x82c39edc4}, {pos = 741993924, events = 8, fd = 561043328, user_data = 0x31c664ff12cd}, {pos = 741962768, events = 8, fd = 742023324, user_data = 0x82170d798}, {pos = 561043472, events = 8, fd = 741996852, user_data = 0x82c39f934}, {pos = -1698651128, events = 5597, fd = 3, user_data = 0x82170d800}, {pos = 1694418171, events = 12742, fd = 561043472, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x82170d858}, {pos = 561044008, events = 8, fd = 561043520, user_data = 0x31c664ff0c52}, {pos = 2711276, events = 0, fd = -1698629656, user_data = 0x0}, {pos = 0, events = 0, fd = 561043608, user_data = 0x82170da68}, {pos = 561043584, events = 8, fd = 1694436434, user_data = 0x29bcfa}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x15dd9ac10050}, {pos = 1, events = 8, fd = 0, user_data = 0x0}, {pos = 561044328, events = 8, fd = 1, user_data = 0x82170dab8}, {pos = -1698629560, events = 5597, fd = 656, user_data = 0x82170da68}, {pos = 561043608, events = 8, fd = 561043712, user_data = 0x31c664ff0acb}, {pos = 561044264, events = 8, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1698627504, user_data = 0x1}, {pos = -1698651128, events = 5597, fd = 741962768, user_data = 0x82170db68}, {pos = 561044152, events = 8, fd = 561043728, user_data = 0x0}, {pos = -1698680824, events = 5597, fd = 33, user_data = 0x82170daa0}, {pos = 1694411895, events = 12742, fd = -1698680824, user_data = 0x15dd9ac03408}, {pos = -1698678776, events = 5597, fd = -1698677752, user_data = 0x15dd9ac07008}, {pos = -1698663416, events = 5597, fd = -1698662392, user_data = 0x15dd9ac07c08}, {pos = -1698660344, events = 5597, fd = -1698659320, user_data = 0x15dd9ac08808}, {pos = -1698657272, events = 5597, fd = -1698656248, user_data = 0x15dd9ac09408}, {pos = -1698654200, events = 5597, fd = -1698653176, user_data = 0x15dd9ac0a008}, {pos = -1698651128, events = 5597, fd = -1698650104, user_data = 0x15dd9ac0ac08}, {pos = -1698648056, events = 5597, fd = -1698647032, user_data = 0x15dd9ac0b808}, {pos = -1698644984, events = 5597, fd = -1698643960, user_data = 0x15dd9ac0c408}, {pos = -1698641912, events = 5597, fd = -1698640888, user_data = 0x15dd9ac0e008}, {pos = -1698634744, events = 5597, fd = -1698633720, user_data = 0x15dd9ac0ec08}, {pos = -1698625528, events = 5597, fd = 839327000, user_data = 0x15dd9ac03008}, {pos = 2735354, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -1698627504, events = 5597, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 561044328, user_data = 0x82170d910}, {pos = 33, events = 33, fd = -1698680824, user_data = 0x37b}, {pos = 2113896, events = 0, fd = 297, user_data = 0x15dd9ac10050}, {pos = 561044304, events = 8, fd = 1694410625, user_data = 0x15dd9b031000}, {pos = 2735354, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -1698627504, events = 5597, fd = 1, user_data = 0x15dd9ac0a408}, {pos = 12558120, events = 0, fd = 743157520, user_data = 0x15dd9ac03008}, {pos = 2839440, events = 0, fd = 736883897, user_data = 0x1}, {pos = -1694425088, events = 5597, fd = 561044304, user_data = 0x82bebe642}, {pos = 743157520, events = 8, fd = 12558120, user_data = 0x82c4baf10 }, {pos = -1698651128, events = 5597, fd = 561044528, user_data = 0x31c664fea574}, {pos = 561044384, events = 8, fd = 1, user_data = 0x31c664fea3ee}, {pos = -1698680824, events = 5597, fd = 561044312, user_data = 0x82170dc30}, {pos = 6816, events = 0, fd = 12, user_data = 0x31c664ffe3a0}, {pos = 0, events = 0, fd = -1694366849, user_data = 0xc178c0 }, {pos = 561044448, events = 8, fd = 736843104, user_data = 0x82c55f460 <__thr_jtable>}, {pos = 743839568, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 561044496, events = 8, fd = 736843104, user_data = 0x82c55f460 <__thr_jtable>}, {pos = 743839568, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 561044544, events = 8, fd = 736885501, user_data = 0x15dd9b012000}, {pos = 27191, events = 0, fd = 561044640, user_data = 0x82beb79ea}} [03:44:24.107] last_touch_time = 1750995435 [03:44:24.107] last_lockfile_recheck_time = 1750995555 [03:44:24.107] nevents = 1 [03:44:24.107] #18 0x00000000008c079a in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82170e2b0) at ../src/backend/postmaster/postmaster.c:1400 [03:44:24.107] userDoption = [03:44:24.107] listen_addr_saved = false [03:44:24.107] output_config_variable = [03:44:24.107] opt = [03:44:24.107] status = [03:44:24.107] #19 0x00000000007f36f0 in main (argc=4, argv=0x82170e2b0) at ../src/backend/main/main.c:227 [03:44:24.107] do_check_root = [03:44:24.107] dispatch_option = DISPATCH_POSTMASTER