[09:52:05.168] src/tools/ci/cores_backtrace.sh freebsd /tmp/cores [09:52:05.448] dumping /tmp/cores/postgres.28751.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [09:52:05.578] [New LWP 101880] [09:52:05.659] Core was generated by `postgres: cascade: startup waiting for 000000020000000000000004'. [09:52:05.659] Program terminated with signal SIGQUIT, Quit. [09:52:05.659] Sent by thr_kill() from pid 28751 and user 1002. [09:52:05.659] #0 0x000000082935c5da in _sigprocmask () from /lib/libc.so.7 [09:52:05.696] [09:52:05.696] Thread 1 (LWP 101880): [09:52:05.696] #0 0x000000082935c5da in _sigprocmask () from /lib/libc.so.7 [09:52:05.696] No symbol table info available. [09:52:05.696] #1 0x0000000829399a3c in _system () from /lib/libc.so.7 [09:52:05.696] No symbol table info available. [09:52:05.696] #2 0x0000000828dc1953 in ?? () from /lib/libthr.so.3 [09:52:05.696] No symbol table info available. [09:52:05.696] #3 0x0000000000698289 in RestoreArchivedFile (path=path@entry=0x8211461b0 "\230c\024!\b", xlogfname=xlogfname@entry=0x821146600 "00000002", '0' , "4", recovername=, expectedSize=16777216, cleanupEnabled=) at ../src/backend/access/transam/xlogarchive.c:177 [09:52:05.696] xlogpath = "pg_wal/RECOVERYXLOG\000RY\000RP\371@)\b\000\000\000\005\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\320a\024!\b\000\000\000\001\000\000\000\000\000\000\000\300]\024!\b\000\000\000\207b-)\b", '\000' , "P\246\304\000\000\000\000\000002", '\000' , "002\000\000\000\000\00000000000", '\000' , "\220]\024!\b\000\000\000"... [09:52:05.696] lastRestartPointFname = "00000001", '0' , "2", '\000' , "\"\r\272\217\n\033\347RP\371@)\b", '\000' , "\365\026\264\000\000\000\000\000(`\024!\b\000\000\000\376\377\377\377\000\000\000\000\264Y\024!\b\000\000\000\377\377\377\377\000\000\000\000x`\024!\b", '\000' , "`Y\024!\b\000\000\0006\032\264", '\000' , "\365\026\264\000\000\000\000\000x`\024!\b\000\000\000"... [09:52:05.696] stat_buf = {st_dev = 34914723248, st_ino = 34914723328, st_nlink = 12674384, st_mode = 2, st_bsdflags = 0, st_uid = 0, st_gid = 554983840, st_padding1 = 8, st_rdev = 35050578567, st_atim = {tv_sec = 10886844556296, tv_nsec = 12887632}, st_mtim = {tv_sec = 875573296, tv_nsec = 0}, st_ctim = {tv_sec = 3420208, tv_nsec = 3472328296227680304}, st_birthtim = {tv_sec = 0, tv_nsec = 0}, st_size = 34914722064, st_blocks = 11855330, st_blksize = 16, st_flags = 48, st_gen = 34914723312, st_filerev = 34914722352, st_spare = {10886844576424, 35049898392, 10886844556296, 34914722264, 34914722712, 34914722240, 61183289218098, 206158430240, 34914722224}} [09:52:05.696] restartRedoPtr = 33554472 [09:52:05.696] restartTli = 1 [09:52:05.696] restartSegNo = [09:52:05.696] xlogRestoreCmd = 0x9e6cad8aea8 "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\"" [09:52:05.696] rc = [09:52:05.696] #4 0x00000000006a3c80 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:4276 [09:52:05.696] xlogfname = "00000002", '0' , "4\000\r\272\217\n\033\347R\000\000\000\000\000\000\000\000`f\024!\b\000\000\000Pf\024!\b\000\000\000\322w5)\b\000\000" [09:52:05.696] activitymsg = "waiting for 00000002", '0' , "4\000\t\000\000\200\027\000\000\000\000\000\000`f\024!\b\000\000\000\003\000\000\000\000\000\000\0000f\024!\b\000\000\000\220x5)\b\000\000" [09:52:05.696] path = "\230c\024!\b\000\000\000\330a\024!\b\000\000\000@b\024!\b\000\000\000\313R8X\2457", '\000' , "\b\000\000\000P\000\201\312\346\t\000\000\001\000\000\000\000\000\000\000\b\244\200\312\346\t\000\000\230\001#)\b\000\000\000\210d\024!\b\000\000\000\340c\024!\b\000\000\000 ", '\000' , "\b0\200\312\346\t\000\000Pb\024!\b\000\000\000\320c\024!\b\000\000\000\307\3607X\2457\000\000\b0\200\312\346\t\000\000\b4\200\312\346\t\000\000\b8\200\312\346\t\000\000\b<\200\312\346\t\000\000\bp\200\312\346\t\000\000"... [09:52:05.696] fd = [09:52:05.696] #5 0x000000000069f96b in XLogFileReadAnyTLI (segno=4, source=XLOG_FROM_ANY) at ../src/backend/access/transam/xlogrecovery.c:4404 [09:52:05.696] hent = [09:52:05.696] tli = 2 [09:52:05.696] cell__state = {l = 0x9e6cad5f298, i = 0} [09:52:05.696] path = "\000\000\000\004\000\000\000\0000000002", '0' , "3\000\000\000\n\000\000\000\000\000P\371@)\b\000\000\000\200R\205\312\346\t\000\000\000\000\000\000\000\000\000\000Pg\024!\b\000\000\000\345\2669)\b\000\000\000\002", '\000' , "\002", '\000' , "\001\000\000\000\001\377\377\377\230\000\000\000\000\000\000\000\000\000\000\002", '\000' , "\"\r\272\217\n\033\347RK|j\000\000\000\000\000@\000\b\000\000\000\000\000\000\000\b\000\000\000\000\000\260\247\024!\b\000\000\000K|j", '\000' ... [09:52:05.696] tles = 0x9e6cad5f298 [09:52:05.696] cell = [09:52:05.696] fd = [09:52:05.696] cell__state = [09:52:05.696] hent = [09:52:05.696] tli = [09:52:05.696] beginseg = [09:52:05.696] __error = [09:52:05.696] __error = [09:52:05.696] #6 WaitForWALToBecomeAvailable (RecPtr=67196800, randAccess=false, fetching_ckpt=false, tliRecPtr=67196776, replayTLI=2, replayLSN=67196776, nonblocking=false) at ../src/backend/access/transam/xlogrecovery.c:3838 [09:52:05.696] startWalReceiver = [09:52:05.696] streaming_reply_sent = true [09:52:05.696] now = [09:52:05.696] #7 XLogPageRead (xlogreader=0x9e6cac150a0, targetPagePtr=67190784, reqLen=6016, targetRecPtr=67196776, readBuf=0x9e6cad5b338 "\033\321\005") at ../src/backend/access/transam/xlogrecovery.c:3389 [09:52:05.696] private = 0x9e6cac15080 [09:52:05.696] emode = 15 [09:52:05.696] targetSegNo = 4 [09:52:05.696] targetPageOff = 81920 [09:52:05.696] io_start = [09:52:05.696] r = [09:52:05.696] #8 0x00000000006a72fc in ReadPageInternal (state=0x9e6cac150a0, pageptr=pageptr@entry=67190784, reqLen=6016) at ../src/backend/access/transam/xlogreader.c:1071 [09:52:05.696] targetSegNo = 4 [09:52:05.696] targetPageOff = 81920 [09:52:05.696] readLen = [09:52:05.696] hdr = [09:52:05.696] err = [09:52:05.696] #9 0x00000000006a60d5 in XLogDecodeNextRecord (state=0x9e6cac150a0, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:598 [09:52:05.696] errormsg = 0x0 [09:52:05.696] randAccess = [09:52:05.696] decoded = [09:52:05.696] RecPtr = 67196776 [09:52:05.696] assembled = false [09:52:05.696] targetPagePtr = 67190784 [09:52:05.696] readOff = [09:52:05.696] record = [09:52:05.696] gotheader = [09:52:05.696] targetRecOff = 5992 [09:52:05.696] pageHeaderSize = [09:52:05.696] len = [09:52:05.696] total_len = [09:52:05.696] buffer = [09:52:05.696] gotlen = [09:52:05.696] pageHeader = [09:52:05.696] contdata = [09:52:05.696] save_copy = [09:52:05.696] #10 XLogReadAhead (state=0x9e6cac150a0, nonblocking=false) at ../src/backend/access/transam/xlogreader.c:984 [09:52:05.696] result = [09:52:05.696] #11 0x000000000069cc38 in XLogPrefetcherNextBlock (pgsr_private=10886848798416, lsn=0x9e6cad8a908) at ../src/backend/access/transam/xlogprefetcher.c:490 [09:52:05.696] nonblocking = false [09:52:05.696] record = 0x0 [09:52:05.696] prefetcher = 0x9e6cac15ed0 [09:52:05.696] reader = 0x9e6cac150a0 [09:52:05.696] replaying_lsn = 67196368 [09:52:05.696] #12 0x000000000069c834 in lrq_prefetch (lrq=0x9e6cad8a698) at ../src/backend/access/transam/xlogprefetcher.c:252 [09:52:05.696] No locals. [09:52:05.696] #13 lrq_complete_lsn (lrq=0x9e6cad8a698, lsn=) at ../src/backend/access/transam/xlogprefetcher.c:290 [09:52:05.696] No locals. [09:52:05.696] #14 XLogPrefetcherReadRecord (prefetcher=prefetcher@entry=0x9e6cac15ed0, errmsg=errmsg@entry=0x82114ad60) at ../src/backend/access/transam/xlogprefetcher.c:1035 [09:52:05.696] replayed_up_to = [09:52:05.696] record = [09:52:05.696] #15 0x00000000006a05cc in ReadRecord (xlogprefetcher=0x9e6cac15ed0, emode=emode@entry=15, fetching_ckpt=false, replayTLI=replayTLI@entry=2) at ../src/backend/access/transam/xlogrecovery.c:3186 [09:52:05.696] errormsg = 0x0 [09:52:05.696] xlogreader = 0x9e6cac150a0 [09:52:05.696] private = [09:52:05.696] record = [09:52:05.696] #16 0x00000000006a0eb9 in PerformWalRecovery () at ../src/backend/access/transam/xlogrecovery.c:1862 [09:52:05.696] ru0 = {tv = {tv_sec = 1768988658, tv_usec = 144355}, ru = {ru_utime = {tv_sec = 0, tv_usec = 0}, ru_stime = {tv_sec = 0, tv_usec = 1058}, 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 = 12, ru_nivcsw = 1}} [09:52:05.696] xtime = [09:52:05.696] reachedRecoveryTarget = false [09:52:05.696] replayTLI = 2 [09:52:05.696] record = [09:52:05.696] #17 0x0000000000691520 in StartupXLOG () at ../src/backend/access/transam/xlog.c:5949 [09:52:05.696] wasShutdown = false [09:52:05.696] haveTblspcMap = false [09:52:05.696] haveBackupLabel = true [09:52:05.696] timebuf = "2026-01-21 09:44:17 UTC\000\003\000\000\000\000\000\000\000\"\r\272\217\n\033\347R\003\000\000\000\000\000\000\000p\270\024!\b\000\000\000\250\036\226\000\000\000\000\000\001\377\000\207\377\377\377\377$\204\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\361\237pi\000\000\000\000 \356\247:\000\000\000" [09:52:05.696] promoted = false [09:52:05.696] didCrash = [09:52:05.696] checkPoint = {redo = 33554472, ThisTimeLineID = 1, PrevTimeLineID = , fullPageWrites = true, wal_level = , logicalDecodingEnabled = , nextXid = {value = }, nextOid = , nextMulti = , nextMultiOffset = , oldestXid = , oldestXidDB = , oldestMulti = 1, oldestMultiDB = , time = , oldestCommitTsXid = 0, newestCommitTsXid = 0, oldestActiveXid = 768} [09:52:05.696] oldestActiveXID = [09:52:05.696] performedWalRecovery = [09:52:05.696] endOfRecoveryInfo = [09:52:05.696] EndOfLog = [09:52:05.696] EndOfLogTLI = [09:52:05.696] abortedRecPtr = [09:52:05.696] missingContrecPtr = [09:52:05.696] newTLI = [09:52:05.696] Insert = [09:52:05.696] #18 0x00000000008e452b in StartupProcessMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/startup.c:258 [09:52:05.696] No locals. [09:52:05.696] #19 0x00000000008ddebb 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:268 [09:52:05.696] pid = [09:52:05.696] #20 0x00000000008e0d57 in StartChildProcess (type=type@entry=B_STARTUP) at ../src/backend/postmaster/postmaster.c:3999 [09:52:05.696] pmchild = 0x0 [09:52:05.696] pid = [09:52:05.696] #21 0x00000000008e065f in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x82114ffb0) at ../src/backend/postmaster/postmaster.c:1396 [09:52:05.696] userDoption = [09:52:05.696] listen_addr_saved = false [09:52:05.696] output_config_variable = [09:52:05.696] opt = [09:52:05.696] status = [09:52:05.696] #22 0x000000000080c0cd in main (argc=4, argv=0x82114ffb0) at ../src/backend/main/main.c:231 [09:52:05.696] do_check_root = [09:52:05.696] dispatch_option = DISPATCH_POSTMASTER [09:52:05.703] [09:52:05.703] [09:52:05.703] [09:52:05.749] dumping /tmp/cores/sh.44777.core for /bin/sh [09:52:05.788] [New LWP 101770] [09:52:05.789] Core was generated by `sh -c cp "/tmp/cirrus-ci-build/build/testrun/recovery/035_standby_logical_decodi'. [09:52:05.789] Program terminated with signal SIGQUIT, Quit. [09:52:05.789] Sent by kill() from pid 43749 and user 1002. [09:52:05.789] #0 0x000036802fa52f30 in ?? () [09:52:05.789] [09:52:05.789] Thread 1 (LWP 101770): [09:52:05.789] #0 0x000036802fa52f30 in ?? () [09:52:05.789] No symbol table info available. [09:52:05.789] #1 0x0000000000000000 in ?? () [09:52:05.789] No symbol table info available. [09:52:05.794] [09:52:05.794] [09:52:05.794] [09:52:05.873] dumping /tmp/cores/postgres.65062.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:52:05.997] [New LWP 101827] [09:52:06.062] Core was generated by `postgres: postgres regression_pg_trgm [local] SELECT'. [09:52:06.062] Program terminated with signal SIGABRT, Aborted. [09:52:06.062] Sent by thr_kill() from pid 65062 and user 1002. [09:52:06.062] #0 0x000000082c15701a in thr_kill () from /lib/libc.so.7 [09:52:06.119] [09:52:06.119] Thread 1 (LWP 101827): [09:52:06.119] #0 0x000000082c15701a in thr_kill () from /lib/libc.so.7 [09:52:06.119] No symbol table info available. [09:52:06.119] #1 0x000000082c0cfa64 in raise () from /lib/libc.so.7 [09:52:06.119] No symbol table info available. [09:52:06.119] #2 0x000000082c183a59 in abort () from /lib/libc.so.7 [09:52:06.119] No symbol table info available. [09:52:06.119] #3 0x0000000000af038f in ExceptionalCondition (conditionName=, fileName=, lineNumber=lineNumber@entry=448) at ../src/backend/utils/error/assert.c:65 [09:52:06.119] No locals. [09:52:06.119] #4 0x0000000833c14224 in radix_sort_trigrams_signed (trg=0x3b05df8aa105, count=6) at ../contrib/pg_trgm/trgm_op.c:448 [09:52:06.119] starts = {0x3b05df8aa130 , 0x3b05df8aa142 } [09:52:06.119] freqs = {{0 , 6, 0 }, {0 , 3, 0 , 1, 1, 1, 0 }, {0 , 3, 0 , 1, 1, 1, 0 }} [09:52:06.119] buffer = 0x3b05df8aa130 [09:52:06.119] to = [09:52:06.119] from = [09:52:06.119] #5 0x0000000833c13cc9 in generate_trgm (str=, slen=) at ../contrib/pg_trgm/trgm_op.c:499 [09:52:06.119] trg = 0x3b05df8aa100 [09:52:06.119] len = 6 [09:52:06.119] #6 0x0000000833c14cdf in show_trgm (fcinfo=0x3b05df9173f0) at ../contrib/pg_trgm/trgm_op.c:1087 [09:52:06.119] in = 0x3b05df04e078 [09:52:06.119] trg = [09:52:06.119] ptr = [09:52:06.119] d = [09:52:06.119] i = [09:52:06.119] a = [09:52:06.119] #7 0x00000000007990fb in ExecInterpExpr (state=0x3b05df917310, econtext=0x3b05df917850, isnull=0x821061796) at ../src/backend/executor/execExprInterp.c:994 [09:52:06.119] dispatch_table = {0x79996c , 0x79997f , 0x798064 , 0x7989c0 , 0x798c08 , 0x798a30 , 0x798b6e , 0x7988e7 , 0x798c87 , 0x798909 , 0x798819 , 0x7987f7 , 0x798ae0 , 0x798b2c , 0x798aef , 0x7989b1 , 0x798bf0 , 0x798d23 , 0x7988a0 , 0x798dd5 , 0x798708 , 0x798a7c , 0x798ce5 , 0x798f81 , 0x79883b , 0x7987df , 0x79892b , 0x798750 , 0x798f51 , 0x7990cb , 0x7988de , 0x798e36 , 0x798da5 , 0x798dac , 0x798b3b , 0x79898d , 0x798994 , 0x798c54 , 0x798676 , 0x798d3a , 0x7994a0 , 0x7986aa , 0x79888a , 0x798a0c , 0x7985ad , 0x798693 , 0x7991d6 , 0x798746 , 0x798934 , 0x798afe , 0x7986eb , 0x7992b0 , 0x7987ae , 0x798cc0 , 0x798fce , 0x79853d , 0x79927b , 0x7983c2 , 0x798789 , 0x7984a0 , 0x79929f , 0x798d5e , 0x79930e , 0x798bba , 0x7992fd , 0x79999e , 0x79910b , 0x798375 , 0x798cd4 , 0x798ebd , 0x798ef3 , 0x798318 , 0x798958 , 0x798fbd , 0x798eac , 0x799367 , 0x7991fd , 0x7981a1 , 0x798fce , 0x798fce , 0x798fce , 0x79927b , 0x798aba , 0x79933a , 0x798414 , 0x798f71 , 0x799378 , 0x7992d4 , 0x79934b , 0x798354 , 0x7983d7 , 0x798879 , 0x799267 , 0x798f18 , 0x7991ec , 0x798acf , 0x79911c , 0x798f04 , 0x798343 , 0x7983eb , 0x798425 , 0x798170 , 0x79867f , 0x798f29 , 0x799138 , 0x79914b , 0x798576 , 0x7983a0 , 0x7986c0 , 0x7980b0 , 0x7984b4 , 0x7985c0 , 0x7993a1 , 0x7980e5 , 0x798fe4 , 0x798214 , 0x7991a6 , 0x799232 , 0x799463 , 0x7981bf , 0x799bb4 } [09:52:06.119] resultslot = 0x0 [09:52:06.119] op = 0x3b05df917440 [09:52:06.119] scanslot = 0x0 [09:52:06.119] innerslot = 0x0 [09:52:06.119] outerslot = 0x0 [09:52:06.119] oldslot = 0x0 [09:52:06.119] newslot = 0x0 [09:52:06.119] out_error = [09:52:06.119] CASE_EEOP_SBSREF_OLD = [09:52:06.119] CASE_EEOP_SBSREF_ASSIGN = [09:52:06.119] CASE_EEOP_SBSREF_FETCH = [09:52:06.119] CASE_EEOP_DOMAIN_TESTVAL = [09:52:06.119] #8 0x00000000008770bf in ExecEvalExprSwitchContext (state=0x3b05df917310, econtext=0x6, isNull=0x821061796) at ../src/include/executor/executor.h:444 [09:52:06.119] oldContext = 0x3b05df917000 [09:52:06.119] retDatum = [09:52:06.119] #9 evaluate_expr (expr=, result_type=result_type@entry=1009, result_typmod=result_typmod@entry=-1, result_collation=result_collation@entry=100) at ../src/backend/optimizer/util/clauses.c:5323 [09:52:06.119] const_is_null = false [09:52:06.119] resultTypLen = 0 [09:52:06.119] resultTypByVal = false [09:52:06.119] estate = 0x3b05df917100 [09:52:06.119] oldcontext = 0x3b05df01a000 [09:52:06.119] exprstate = 0x3b05df917310 [09:52:06.119] const_val = [09:52:06.119] #10 0x0000000000877e9d in evaluate_function (funcid=16388, result_type=1009, result_typmod=-1, result_collid=100, input_collid=100, args=0x3b05df04e4d0, funcvariadic=, func_tuple=0x3b05df848c98, context=) at ../src/backend/optimizer/util/clauses.c:4830 [09:52:06.119] funcform = [09:52:06.119] has_nonconst_input = [09:52:06.119] has_null_input = [09:52:06.119] arg = [09:52:06.119] newexpr = 0x0 [09:52:06.119] arg__state = [09:52:06.119] #11 simplify_function (funcid=funcid@entry=16388, result_type=result_type@entry=1009, result_typmod=-1, result_collid=100, input_collid=100, args_p=args_p@entry=0x821061918, funcvariadic=, process_args=, allow_non_const=true, context=0x8210619f8) at ../src/backend/optimizer/util/clauses.c:4179 [09:52:06.119] args = 0x3b05df04e4d0 [09:52:06.119] func_tuple = 0x3b05df848c98 [09:52:06.119] func_form = [09:52:06.119] newexpr = [09:52:06.119] #12 0x0000000000875a77 in eval_const_expressions_mutator (node=0x3b05df04dfd8, context=) at ../src/backend/optimizer/util/clauses.c:2608 [09:52:06.119] args = 0x3b05df04e4d0 [09:52:06.119] expr = 0x3b05df04dfd8 [09:52:06.119] simple = [09:52:06.119] newexpr = [09:52:06.119] #13 0x0000000000815b55 in expression_tree_mutator_impl (node=0x3b05df04df88, mutator=0x874f40 , context=0x8210619f8) at ../src/backend/nodes/nodeFuncs.c:3713 [09:52:06.119] No locals. [09:52:06.119] #14 0x00000000008159c7 in expression_tree_mutator_impl (node=0x3b05df04e108, mutator=0x874f40 , context=0x8210619f8) at ../src/backend/nodes/nodeFuncs.c:3571 [09:52:06.119] temp__state = {l = , i = 0} [09:52:06.119] resultlist = 0x0 [09:52:06.119] temp = 0x82c156ffa [09:52:06.119] #15 0x0000000000874ff9 in eval_const_expressions_mutator (node=0x18dc3, context=) at ../src/backend/optimizer/util/clauses.c:3798 [09:52:06.119] No locals. [09:52:06.119] #16 0x0000000000874f2b in eval_const_expressions (root=root@entry=0x3b05df01b238, node=0x0) at ../src/backend/optimizer/util/clauses.c:2282 [09:52:06.119] context = {boundParams = , root = 0x3b05df01b238, active_fns = 0x0, case_val = 0x0, estimate = false} [09:52:06.119] #17 0x0000000000854b7c in preprocess_expression (root=0x3b05df01b238, expr=0x0, kind=1) at ../src/backend/optimizer/plan/planner.c:1331 [09:52:06.119] No locals. [09:52:06.119] #18 subquery_planner (glob=glob@entry=0x3b05df01ba10, parse=parse@entry=0x3b05df04dd48, plan_name=plan_name@entry=0x0, parent_root=parent_root@entry=0x0, hasRecursion=false, tuple_fraction=, setops=setops@entry=0x0) at ../src/backend/optimizer/plan/planner.c:934 [09:52:06.119] root = 0x3b05df01b238 [09:52:06.119] hasOuterJoins = false [09:52:06.119] hasResultRTEs = true [09:52:06.119] l = [09:52:06.119] newWithCheckOptions = [09:52:06.119] newHaving = [09:52:06.119] final_rel = [09:52:06.119] #19 0x0000000000853d50 in standard_planner (parse=0x3b05df04dd48, query_string=0x3b05df01a100 "select show_trgm('a b c');", cursorOptions=2048, boundParams=0x0, es=0x0) at ../src/backend/optimizer/plan/planner.c:470 [09:52:06.119] tuple_fraction = 0 [09:52:06.119] glob = 0x3b05df01ba10 [09:52:06.119] root = [09:52:06.119] final_rel = [09:52:06.119] best_path = [09:52:06.119] top_plan = [09:52:06.119] lp = [09:52:06.119] lr = [09:52:06.119] result = [09:52:06.119] #20 0x0000000000853bae in planner (parse=0x18dc3, parse@entry=0x3b05df04dd48, query_string=0x6 , query_string@entry=0x3b05df01a100 "select show_trgm('a b c');", cursorOptions=0, cursorOptions@entry=2048, boundParams=0x82c156ffa , boundParams@entry=0x0, es=es@entry=0x0) at ../src/backend/optimizer/plan/planner.c:324 [09:52:06.119] result = [09:52:06.119] #21 0x000000000099c048 in pg_plan_query (querytree=querytree@entry=0x3b05df04dd48, query_string=query_string@entry=0x3b05df01a100 "select show_trgm('a b c');", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0, es=es@entry=0x0) at ../src/backend/tcop/postgres.c:905 [09:52:06.119] plan = [09:52:06.119] #22 0x000000000099c145 in pg_plan_queries (querytrees=0x3b05df04e158, query_string=query_string@entry=0x3b05df01a100 "select show_trgm('a b c');", cursorOptions=cursorOptions@entry=2048, boundParams=boundParams@entry=0x0) at ../src/backend/tcop/postgres.c:1000 [09:52:06.119] query = 0x3b05df04dd48 [09:52:06.119] stmt = [09:52:06.119] query_list__state = {l = 0x3b05df04e158, i = 0} [09:52:06.119] stmt_list = 0x0 [09:52:06.119] query_list = [09:52:06.119] #23 0x00000000009a084a in exec_simple_query (query_string=query_string@entry=0x3b05df01a100 "select show_trgm('a b c');") at ../src/backend/tcop/postgres.c:1198 [09:52:06.119] cmdtaglen = 6 [09:52:06.119] snapshot_set = [09:52:06.119] per_parsetree_context = 0x0 [09:52:06.119] plantree_list = [09:52:06.119] qc = {commandTag = 554048608, nprocessed = 12883036} [09:52:06.119] format = 8 [09:52:06.119] parsetree = 0x3b05df01b648 [09:52:06.119] commandTag = CMDTAG_SELECT [09:52:06.119] cmdtagname = [09:52:06.119] querytree_list = 0x0 [09:52:06.119] portal = [09:52:06.119] receiver = [09:52:06.119] parsetree_item__state = {l = , i = 0} [09:52:06.119] msec_str = "`\034\006!\b\000\000\000\\\224\304\000\000\000\000\0000\034\006!\b\000\000\000\2208\025,\b\000\000" [09:52:06.119] dest = DestRemote [09:52:06.119] save_log_statement_stats = false [09:52:06.119] was_logged = [09:52:06.119] oldcontext = 0x3b05df193000 [09:52:06.119] parsetree_list = 0x3b05df01b9c0 [09:52:06.119] use_implicit_block = [09:52:06.119] parsetree_item = 0x3b05df01b9d8 [09:52:06.119] #24 0x000000000099e29b in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4771 [09:52:06.119] query_string = 0x3b05df01a100 "select show_trgm('a b c');" [09:52:06.119] input_message = {data = 0x3b05df01a100 "select show_trgm('a b c');", len = 27, maxlen = 1024, cursor = 27} [09:52:06.119] firstchar = [09:52:06.119] local_sigjmp_buf = {{_sjb = {10082106, 34913787024, 34913787016, 34913787632, 12676188, 12675856, 12889160, 12883044, 895, 0, 0, 64892660875265}}} [09:52:06.119] send_ready_for_query = false [09:52:06.119] idle_in_transaction_timeout_enabled = false [09:52:06.119] idle_session_timeout_enabled = false [09:52:06.119] #25 0x0000000000998719 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [09:52:06.119] bsdata = [09:52:06.119] #26 0x00000000008ddebb in postmaster_child_launch (child_type=, child_slot=1, startup_data=startup_data@entry=0x821062958, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x821062970) at ../src/backend/postmaster/launch_backend.c:268 [09:52:06.119] pid = [09:52:06.119] #27 0x00000000008e2925 in BackendStartup (client_sock=0x821062970) at ../src/backend/postmaster/postmaster.c:3606 [09:52:06.119] startup_data = {canAcceptConnections = CAC_OK, socket_created = 822303942475292, fork_started = } [09:52:06.119] bn = 0x3b05df146038 [09:52:06.119] cac = CAC_OK [09:52:06.119] pid = [09:52:06.119] __error = [09:52:06.119] save_errno = [09:52:06.119] __error = [09:52:06.119] __error = [09:52:06.119] #28 ServerLoop () at ../src/backend/postmaster/postmaster.c:1713 [09:52:06.119] 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' , "\320)\006!\b\000\000\000\350\006\311)\b\000\000\000\032\001\000\000\000\000\000\000T\217\311)\b", '\000' , "\020*\006!\b\000\000\000\004܍\000\000\000\000\000 *\006!\b", '\000' }, salen = 16}} [09:52:06.119] i = 0 [09:52:06.119] now = [09:52:06.119] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -553040424, events = 15109, fd = 554050496, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 16777216, fd = 554050832, user_data = 0x43}, {pos = 554050608, events = 8, fd = 624429765, user_data = 0x821062410}, {pos = 739545893, events = 8, fd = 554050632, user_data = 0x8210624c0}, {pos = 554050656, events = 8, fd = 624429765, user_data = 0x3b05dec0a408}, {pos = 3, events = 0, fd = 554050680, user_data = 0x8210624f0}, {pos = 738425032, events = 8, fd = 738425032, user_data = 0x8210624a0}, {pos = 624429765, events = 4122, fd = 554050784, user_data = 0x101a2537bb2b}, {pos = 554050744, events = 8, fd = 554050864, user_data = 0x82c0368d4}, {pos = 738420948, events = 8, fd = -557800440, user_data = 0x3}, {pos = 554050848, events = 8, fd = 624409387, user_data = 0x821062530}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 554050936, events = 8, fd = 554051384, user_data = 0x821062560}, {pos = 624428082, events = 4122, fd = 2717798, user_data = 0x3b05dec0f2a8}, {pos = 738344584, events = 8, fd = -557800440, user_data = 0x8210625b8}, {pos = 554051448, events = 8, fd = 554050976, user_data = 0x101a25380432}, {pos = 2742638, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -557776816, events = 15109, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554051688, user_data = 0x3210625a0}, {pos = 554051520, events = 8, fd = -557778200, user_data = 0x290}, {pos = 554051448, events = 8, fd = 554051000, user_data = 0x821062620}, {pos = 624427723, events = 4122, fd = 554051624, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3b05dec10050}, {pos = 1, events = 8, fd = -557800440, user_data = 0x82c023e88}, {pos = 554051688, events = 8, fd = 554051520, user_data = 0x20}, {pos = 0, events = 0, fd = -557830136, user_data = 0x821062630}, {pos = 554051504, events = 8, fd = 624402631, user_data = 0x3b05dec03008}, {pos = -557829112, events = 15109, fd = -557828088, user_data = 0x3b05dec03c08}, {pos = -557813752, events = 15109, fd = -557812728, user_data = 0x3b05dec07808}, {pos = -557810680, events = 15109, fd = -557809656, user_data = 0x3b05dec08408}, {pos = -557807608, events = 15109, fd = -557806584, user_data = 0x3b05dec09008}, {pos = -557804536, events = 15109, fd = -557803512, user_data = 0x3b05dec09c08}, {pos = -557801464, events = 15109, fd = -557800440, user_data = 0x3b05dec0a808}, {pos = -557798392, events = 15109, fd = -557797368, user_data = 0x3b05dec0b408}, {pos = -557795320, events = 15109, fd = -557794296, user_data = 0x3b05dec0c008}, {pos = -557792248, events = 15109, fd = -557791224, user_data = 0x3b05dec0cc08}, {pos = -557785080, events = 15109, fd = -557784056, user_data = 0x3b05dec0e808}, {pos = -557782008, events = 15109, fd = -557830136, user_data = 0x29d96e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x3b05dec10050}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554051688, events = 8, fd = 554051120, user_data = 0x2000000020}, {pos = -557830136, events = 15109, fd = 1, user_data = 0x27cffc}, {pos = 302, events = 0, fd = -557776816, user_data = 0x821062850}, {pos = 624401340, events = 4122, fd = 2742638, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = -557776816, user_data = 0x1}, {pos = 12768688, events = 0, fd = 739593584, user_data = 0x3b05dec03008}, {pos = 2848256, events = 0, fd = 701072713, user_data = 0x1}, {pos = -557109240, events = 15109, fd = 554051664, user_data = 0x829c976e5}, {pos = 739593584, events = 8, fd = 12768688, user_data = 0x82c154d70 }, {pos = -557800440, events = 15109, fd = 554051888, user_data = 0x101a253799b4}, {pos = 554051744, events = 8, fd = 1, user_data = 0x101a2537982e}, {pos = -557830136, events = 15109, fd = 554051672, user_data = 0x821062930}, {pos = 6936, events = 0, fd = 12, user_data = 0x101a2538db40}, {pos = 0, events = 0, fd = -553581697, user_data = 0x821062960}, {pos = 554051808, events = 8, fd = 701031888, user_data = 0x82c1f8300 <__thr_jtable>}, {pos = 740271600, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 554051856, events = 8, fd = 701031888, user_data = 0x82c1f8300 <__thr_jtable>}, {pos = 740271600, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 554051904, events = 8, fd = 701074333, user_data = 0x3b05decb3008}, {pos = 65017, events = 0, fd = 554052000, user_data = 0x829c90a7d}} [09:52:06.119] last_touch_time = 1768988742 [09:52:06.119] last_lockfile_recheck_time = 1768988742 [09:52:06.119] nevents = 1 [09:52:06.119] #29 0x00000000008e0697 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821062fb0) at ../src/backend/postmaster/postmaster.c:1403 [09:52:06.119] userDoption = [09:52:06.119] listen_addr_saved = false [09:52:06.119] output_config_variable = [09:52:06.119] opt = [09:52:06.119] status = [09:52:06.119] #30 0x000000000080c0cd in main (argc=8, argv=0x821062fb0) at ../src/backend/main/main.c:231 [09:52:06.119] do_check_root = [09:52:06.119] dispatch_option = DISPATCH_POSTMASTER [09:52:06.127] [09:52:06.127] [09:52:06.127] [09:52:06.182] dumping /tmp/cores/postgres.65766.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [09:52:06.305] [New LWP 100718] [09:52:06.372] Core was generated by `postgres: postgres regression_pg_trgm [local] CREATE INDEX'. [09:52:06.372] Program terminated with signal SIGABRT, Aborted. [09:52:06.372] Sent by thr_kill() from pid 65766 and user 1002. [09:52:06.372] #0 0x000000082c15701a in thr_kill () from /lib/libc.so.7 [09:52:06.430] [09:52:06.430] Thread 1 (LWP 100718): [09:52:06.430] #0 0x000000082c15701a in thr_kill () from /lib/libc.so.7 [09:52:06.430] No symbol table info available. [09:52:06.430] #1 0x000000082c0cfa64 in raise () from /lib/libc.so.7 [09:52:06.430] No symbol table info available. [09:52:06.430] #2 0x000000082c183a59 in abort () from /lib/libc.so.7 [09:52:06.430] No symbol table info available. [09:52:06.430] #3 0x0000000000af038f in ExceptionalCondition (conditionName=, fileName=, lineNumber=lineNumber@entry=448) at ../src/backend/utils/error/assert.c:65 [09:52:06.430] No locals. [09:52:06.430] #4 0x000000083336f224 in radix_sort_trigrams_signed (trg=0x3b05df899105, count=7) at ../contrib/pg_trgm/trgm_op.c:448 [09:52:06.430] starts = {0x3b05df899150 , 0x3b05df899156 , 0x3b05df89915c, 0x3b05df89915f, 0x3b05df89915f, 0x3b05df89915f, 0x3b05df89915f, 0x3b05df89915f, 0x3b05df89915f, 0x3b05df89915f, 0x3b05df899162, 0x3b05df899162, 0x3b05df899165 } [09:52:06.430] freqs = {{0 , 2, 0 , 2, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0 }, {0 , 1, 0 , 2, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0 }, {0 , 1, 0 , 2, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0 }} [09:52:06.430] buffer = 0x3b05df899150 [09:52:06.430] to = [09:52:06.430] from = [09:52:06.430] #5 0x000000083336ecc9 in generate_trgm (str=, slen=) at ../contrib/pg_trgm/trgm_op.c:499 [09:52:06.430] trg = 0x3b05df899100 [09:52:06.430] len = 7 [09:52:06.430] #6 0x000000083336cd26 in gtrgm_compress (fcinfo=0x821060a78) at ../contrib/pg_trgm/trgm_gist.c:126 [09:52:06.430] val = 0x0 [09:52:06.430] res = [09:52:06.430] entry = 0x821060bc0 [09:52:06.430] siglen = [09:52:06.430] retval = 0x821060bc0 [09:52:06.430] #7 0x0000000000af9b32 in FunctionCall1Coll (flinfo=flinfo@entry=0x3b05df146c60, collation=6, arg1=0, arg1@entry=34913782720) at ../src/backend/utils/fmgr/fmgr.c:1140 [09:52:06.430] fcinfodata = {fcinfo = {flinfo = 0x3b05df146c60, context = 0x0, resultinfo = 0x0, fncollation = 950, isnull = false, nargs = 1, args = 0x821060a98}, fcinfo_data = "`l\024\337\005;", '\000' , "\266\003\000\000\000\000\001\000\300\v\006!\b\000\000\000\000\000\000\000\000\000\000"} [09:52:06.430] fcinfo = 0x821060a78 [09:52:06.430] result = [09:52:06.430] __error = [09:52:06.430] #8 0x0000000000608688 in gistCompressValues (r=0x3b05df84cee8, isleaf=true, compatt=0x821060ac0, giststate=, attdata=, isnull=) at ../src/backend/access/gist/gistutil.c:618 [09:52:06.430] centry = {key = 35255582712, rel = 0x3b05df84cee8, page = 0x0, offset = 0, leafkey = true} [09:52:06.430] cep = [09:52:06.430] i = 0 [09:52:06.430] centry = [09:52:06.430] cep = [09:52:06.430] #9 gistFormTuple (giststate=0x3b05df146038, r=r@entry=0x3b05df84cee8, attdata=0x821060f70, isnull=0x821061070, isleaf=true) at ../src/backend/access/gist/gistutil.c:581 [09:52:06.430] compatt = {64896402997920, 70368744179327, 24576, 1, 0, 64896404190152, 64896403075680, 64896410871128, 1, 112, 35246608576, 1, 64896403075232, 12884901888, 72057594037927937, 64896403075128, 1, 1, 0, 1, 34913782688, 9760241, 4294967296, 64896403075128, 3909228, 0, 35255582688, 0, 34913782736, 6174633, 72339064719671296, 18891145216} [09:52:06.430] res = [09:52:06.430] #10 0x00000000006000d2 in gistBuildCallback (index=0x3b05df84cee8, tid=0x3b05df095104, values=0x0, isnull=0x82c156ffa , tupleIsAlive=, state=0x0) at ../src/backend/access/gist/gistbuild.c:836 [09:52:06.430] buildstate = 0x821061190 [09:52:06.430] oldCtx = 0x3b05df1fe400 [09:52:06.430] itup = [09:52:06.430] #11 0x00000000006281e0 in heapam_index_build_range_scan (heapRelation=0x3b05df846558, indexRelation=0x3b05df84cee8, indexInfo=0x3b05df815308, allow_sync=, anyvisible=false, progress=true, start_blockno=0, numblocks=4294967295, callback=0x600090 , callback_state=0x821061190, scan=0x3b05df0950a0) at ../src/backend/access/heap/heapam_handler.c:1719 [09:52:06.430] tupleIsAlive = true [09:52:06.430] values = {35255582712, 35246609152, 1, 12791216, 4294967294, 0, 34913784000, 9769553, 64892660875264, 64896411185552, 64896411136136, 3, 1, 64896410898152, 34913783808, 10043710, 12883032, 2, 34913783840, 10056710, 4294967295, 7142530613248, 105574591119360, 0, 40, 0, 0, 12896576637, 1, 64896410898152, 8589934591, 34913784072} [09:52:06.430] isnull = {false, 206, 132, 223, true, false , 2, false, false, false, 8, false, false, false, 136, 112, 136, 223, 5, 59, false, false} [09:52:06.430] root_offsets = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 0 } [09:52:06.430] need_unregister_snapshot = [09:52:06.430] previous_blkno = 5 [09:52:06.430] root_blkno = 0 [09:52:06.430] checking_uniqueness = false [09:52:06.430] estate = 0x3b05df1f1100 [09:52:06.430] econtext = 0x3b05df1f1310 [09:52:06.430] slot = 0x3b05df1ff358 [09:52:06.430] predicate = 0x0 [09:52:06.430] OldestXmin = 773 [09:52:06.430] snapshot = 0xc2c9c8 [09:52:06.430] hscan = 0x3b05df0950a0 [09:52:06.430] reltuples = 1 [09:52:06.430] heapTuple = [09:52:06.430] is_system_catalog = [09:52:06.430] #12 0x00000000005ffd2f in table_index_build_scan (table_rel=0x3b05df846558, index_rel=0x3b05df84cee8, index_info=0x3b05df815308, allow_sync=true, progress=true, callback=0x0, callback_state=0x821061190, scan=0x0) at ../src/include/access/tableam.h:1763 [09:52:06.430] No locals. [09:52:06.430] #13 gistbuild (heap=0x3b05df846558, index=0x3b05df84cee8, indexInfo=0x3b05df815308) at ../src/backend/access/gist/gistbuild.c:313 [09:52:06.430] buffer = 985 [09:52:06.430] page = 0x83566a000 "" [09:52:06.430] buildstate = {indexrel = 0x3b05df84cee8, heaprel = 0x3b05df846558, giststate = 0x3b05df146038, freespace = 819, buildMode = GIST_BUFFERING_AUTO, indtuples = 0, indtuplesSize = 0, gfbb = 0x0, parentMap = 0x3b05df878d28, sortstate = 0x0, pages_allocated = 3750022888, bulkstate = 0x0} [09:52:06.430] oldcxt = 0x3b05df1fe400 [09:52:06.430] options = [09:52:06.430] fillfactor = [09:52:06.430] reltuples = [09:52:06.430] result = [09:52:06.430] SortSupportFnOids = [09:52:06.430] #14 0x00000000006c5ff3 in index_build (heapRelation=heapRelation@entry=0x3b05df846558, indexRelation=indexRelation@entry=0x3b05df84cee8, indexInfo=indexInfo@entry=0x3b05df815308, isreindex=false, parallel=) at ../src/backend/catalog/index.c:3076 [09:52:06.430] save_userid = 10 [09:52:06.430] save_sec_context = 2 [09:52:06.430] save_nestlevel = 3 [09:52:06.430] stats = [09:52:06.430] #15 0x00000000006c522c in index_create (heapRelation=heapRelation@entry=0x3b05df846558, indexRelationName=indexRelationName@entry=0x3b05df026c70 "trgm_idx2", indexRelationId=24581, indexRelationId@entry=0, parentIndexRelid=parentIndexRelid@entry=0, parentConstraintId=parentConstraintId@entry=0, relFileNumber=, indexInfo=0x3b05df815308, indexColNames=0x3b05df815780, accessMethodId=783, tableSpaceId=0, collationIds=0x3b05df0954c8, opclassIds=0x3b05df0954e0, opclassOptions=0x3b05df0954f8, coloptions=0x3b05df095510, stattargets=0x0, reloptions=0, flags=0, constr_flags=0, allow_system_table_mods=, is_internal=, constraintId=0x821061730) at ../src/backend/catalog/index.c:1276 [09:52:06.430] relfrozenxid = 0 [09:52:06.430] relminmxid = 0 [09:52:06.430] heapRelationId = 24576 [09:52:06.430] invalid = true [09:52:06.430] relkind = [09:52:06.430] pg_class = 0x3b05df1bfc58 [09:52:06.430] namespaceId = 2200 [09:52:06.430] shared_relation = false [09:52:06.430] mapped_relation = false [09:52:06.430] relpersistence = 112 'p' [09:52:06.430] i = [09:52:06.430] indexTupDesc = [09:52:06.430] indexRelation = 0x3b05df84cee8 [09:52:06.430] is_exclusion = [09:52:06.430] isprimary = [09:52:06.430] concurrent = [09:52:06.430] partitioned = [09:52:06.430] create_storage = [09:52:06.430] #16 0x000000000072baab in DefineIndex (pstate=pstate@entry=0x3b05df1fe500, tableId=tableId@entry=24576, stmt=stmt@entry=0x3b05df026be0, indexRelationId=indexRelationId@entry=0, parentIndexId=parentIndexId@entry=0, parentConstraintId=parentConstraintId@entry=0, total_parts=-1, is_alter_table=, check_rights=, check_not_in_use=, skip_build=, quiet=) at ../src/backend/commands/indexcmds.c:1252 [09:52:06.430] createdConstraintId = 0 [09:52:06.430] heaprelid = {relId = 554047200, dbId = 8} [09:52:06.430] root_save_userid = 10 [09:52:06.430] root_save_sec_context = 0 [09:52:06.430] root_save_nestlevel = 2 [09:52:06.430] concurrent = [09:52:06.430] numberOfKeyAttributes = [09:52:06.430] allIndexParams = [09:52:06.430] numberOfAttributes = [09:52:06.430] lockmode = 5 [09:52:06.430] rel = 0x3b05df846558 [09:52:06.430] namespaceId = [09:52:06.430] exclusion = false [09:52:06.430] tablespaceId = 0 [09:52:06.430] indexColNames = 0x3b05df815780 [09:52:06.430] indexRelationName = 0x3b05df026c70 "trgm_idx2" [09:52:06.430] accessMethodName = 0x3b05df026d00 "gist" [09:52:06.430] tuple = [09:52:06.430] accessMethodForm = [09:52:06.430] accessMethodId = 783 [09:52:06.430] amRoutine = [09:52:06.430] amcanorder = [09:52:06.430] amissummarizing = [09:52:06.430] amoptions = [09:52:06.430] reloptions = 0 [09:52:06.430] indexInfo = 0x3b05df815308 [09:52:06.430] typeIds = [09:52:06.430] collationIds = 0x3b05df0954c8 [09:52:06.430] opclassIds = 0x3b05df0954e0 [09:52:06.430] opclassOptions = 0x3b05df0954f8 [09:52:06.430] coloptions = 0x3b05df095510 [09:52:06.430] safe_index = true [09:52:06.430] constr_flags = 31232 [09:52:06.430] flags = [09:52:06.430] address = [09:52:06.430] heaplocktag = [09:52:06.430] snapshot = [09:52:06.430] limitXmin = [09:52:06.430] partitioned = [09:52:06.430] #17 0x00000000009a4f9f in ProcessUtilitySlow (pstate=pstate@entry=0x3b05df1fe500, pstmt=pstmt@entry=0x3b05df01b8f8, queryString=queryString@entry=0x3b05df01a100 "create index trgm_idx2 on test_trgm2 using gist (t gist_trgm_ops);", context=context@entry=PROCESS_UTILITY_TOPLEVEL, params=params@entry=0x0, queryEnv=queryEnv@entry=0x0, dest=, qc=0x821061be0) at ../src/backend/tcop/utility.c:1544 [09:52:06.430] stmt = 0x3b05df026be0 [09:52:06.430] nparts = -1 [09:52:06.430] lockmode = [09:52:06.430] is_alter_table = [09:52:06.430] relid = 24576 [09:52:06.430] _local_sigjmp_buf = {{_sjb = {10109673, 64896402307320, 34913785864, 34913786240, 34913785872, 12880328, 64896402353120, 0, 34913780607, 35099593127, 34913786032, 64892660875264}}} [09:52:06.430] _save_exception_stack = 0x821061ae0 [09:52:06.430] _save_context_stack = 0x0 [09:52:06.430] _do_rethrow = false [09:52:06.430] secondaryObject = {classId = 0, objectId = 0, objectSubId = 0} [09:52:06.430] parsetree = 0x3b05df026be0 [09:52:06.430] commandCollected = false [09:52:06.430] needCleanup = false [09:52:06.430] address = [09:52:06.430] isTopLevel = [09:52:06.430] isCompleteQuery = [09:52:06.430] #18 0x00000000009a373e in standard_ProcessUtility (pstmt=0x3b05df01b8f8, queryString=0x3b05df01a100 "create index trgm_idx2 on test_trgm2 using gist (t gist_trgm_ops);", readOnlyTree=, context=PROCESS_UTILITY_TOPLEVEL, params=0x0, queryEnv=0x0, dest=0x3b05df026f40, qc=0x821061be0) at ../src/backend/tcop/utility.c:1038 [09:52:06.430] isAtomicContext = false [09:52:06.430] parsetree = 0x3b05df026be0 [09:52:06.430] readonly_flags = [09:52:06.430] pstate = 0x3b05df1fe500 [09:52:06.430] isTopLevel = [09:52:06.430] #19 0x00000000009a3008 in ProcessUtility (pstmt=0x1896e, queryString=0x6 , readOnlyTree=, context=739602426, params=0x0, queryEnv=0x0, dest=0x3b05df026f40, qc=0x821061be0) at ../src/backend/tcop/utility.c:525 [09:52:06.430] No locals. [09:52:06.430] #20 0x00000000009a2b3c in PortalRunUtility (portal=0x3b05df178100, pstmt=0x3b05df01b8f8, isTopLevel=, setHoldSnapshot=false, dest=0x3b05df026f40, qc=0x821061be0) at ../src/backend/tcop/pquery.c:1148 [09:52:06.430] No locals. [09:52:06.430] #21 0x00000000009a21c4 in PortalRunMulti (portal=portal@entry=0x3b05df178100, isTopLevel=true, setHoldSnapshot=false, dest=dest@entry=0x3b05df026f40, altdest=altdest@entry=0x3b05df026f40, qc=qc@entry=0x821061be0) at ../src/backend/tcop/pquery.c:1313 [09:52:06.430] pstmt = 0x3b05df01b8f8 [09:52:06.430] stmtlist_item__state = {l = 0x3b05df026ef0, i = 0} [09:52:06.430] active_snapshot_set = false [09:52:06.430] stmtlist_item = 0x3b05df026f08 [09:52:06.430] #22 0x00000000009a1adb in PortalRun (portal=portal@entry=0x3b05df178100, count=count@entry=9223372036854775807, isTopLevel=true, dest=dest@entry=0x3b05df026f40, altdest=altdest@entry=0x3b05df026f40, qc=qc@entry=0x821061be0) at ../src/backend/tcop/pquery.c:783 [09:52:06.430] _local_sigjmp_buf = {{_sjb = {10099285, 64896403734784, 34913786584, 34913786832, 34913786592, 12880328, 34913786848, 12807272, 12780415, 0, 895, -6347183290859913216}}} [09:52:06.430] _save_exception_stack = 0x821061c90 [09:52:06.430] _save_context_stack = 0x0 [09:52:06.430] _do_rethrow = false [09:52:06.430] saveTopTransactionResourceOwner = 0x3b05df182718 [09:52:06.430] saveTopTransactionContext = 0x3b05df188000 [09:52:06.430] saveActivePortal = 0x0 [09:52:06.430] saveResourceOwner = 0x3b05df182718 [09:52:06.430] savePortalContext = 0x0 [09:52:06.430] saveMemoryContext = 0x3b05df188000 [09:52:06.430] result = [09:52:06.430] nprocessed = [09:52:06.430] #23 0x00000000009a0957 in exec_simple_query (query_string=query_string@entry=0x3b05df01a100 "create index trgm_idx2 on test_trgm2 using gist (t gist_trgm_ops);") at ../src/backend/tcop/postgres.c:1279 [09:52:06.430] cmdtaglen = 12 [09:52:06.430] snapshot_set = [09:52:06.430] per_parsetree_context = 0x0 [09:52:06.430] plantree_list = [09:52:06.430] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [09:52:06.430] format = 0 [09:52:06.430] parsetree = 0x3b05df01b5b8 [09:52:06.430] commandTag = [09:52:06.430] cmdtagname = [09:52:06.430] querytree_list = [09:52:06.430] portal = 0x3b05df178100 [09:52:06.430] receiver = 0x3b05df026f40 [09:52:06.430] parsetree_item__state = {l = , i = 0} [09:52:06.430] msec_str = "\000\000\000\000\b", '\000' , "0\034\006!\b\000\000\000\2208\025,\b\000\000" [09:52:06.430] dest = DestRemote [09:52:06.430] save_log_statement_stats = false [09:52:06.430] was_logged = [09:52:06.430] oldcontext = 0x3b05df188000 [09:52:06.430] parsetree_list = 0x3b05df01b8a8 [09:52:06.430] use_implicit_block = [09:52:06.430] parsetree_item = 0x3b05df01b8c0 [09:52:06.430] #24 0x000000000099e29b in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4771 [09:52:06.430] query_string = 0x3b05df01a100 "create index trgm_idx2 on test_trgm2 using gist (t gist_trgm_ops);" [09:52:06.430] input_message = {data = 0x3b05df01a100 "create index trgm_idx2 on test_trgm2 using gist (t gist_trgm_ops);", len = 67, maxlen = 1024, cursor = 67} [09:52:06.430] firstchar = [09:52:06.430] local_sigjmp_buf = {{_sjb = {10082106, 34913787024, 34913787016, 34913787632, 12676188, 12675856, 12889160, 12883044, 895, 0, 0, 64892660875265}}} [09:52:06.430] send_ready_for_query = false [09:52:06.430] idle_in_transaction_timeout_enabled = false [09:52:06.430] idle_session_timeout_enabled = false [09:52:06.430] #25 0x0000000000998719 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:124 [09:52:06.430] bsdata = [09:52:06.430] #26 0x00000000008ddebb in postmaster_child_launch (child_type=, child_slot=1, startup_data=startup_data@entry=0x821062958, startup_data_len=startup_data_len@entry=24, client_sock=client_sock@entry=0x821062970) at ../src/backend/postmaster/launch_backend.c:268 [09:52:06.430] pid = [09:52:06.430] #27 0x00000000008e2925 in BackendStartup (client_sock=0x821062970) at ../src/backend/postmaster/postmaster.c:3606 [09:52:06.430] startup_data = {canAcceptConnections = CAC_OK, socket_created = 822303944281709, fork_started = } [09:52:06.430] bn = 0x3b05df146038 [09:52:06.430] cac = CAC_OK [09:52:06.430] pid = [09:52:06.430] __error = [09:52:06.430] save_errno = [09:52:06.430] __error = [09:52:06.430] __error = [09:52:06.430] #28 ServerLoop () at ../src/backend/postmaster/postmaster.c:1713 [09:52:06.430] 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' , "\320)\006!\b\000\000\000\350\006\311)\b\000\000\000\032\001\000\000\000\000\000\000T\217\311)\b", '\000' , "\020*\006!\b\000\000\000\004܍\000\000\000\000\000 *\006!\b", '\000' }, salen = 16}} [09:52:06.430] i = 0 [09:52:06.430] now = [09:52:06.430] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -553040424, events = 15109, fd = 554050496, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 16777216, fd = 554050832, user_data = 0x43}, {pos = 554050608, events = 8, fd = 624429765, user_data = 0x821062410}, {pos = 739545893, events = 8, fd = 554050632, user_data = 0x8210624c0}, {pos = 554050656, events = 8, fd = 624429765, user_data = 0x3b05dec0a408}, {pos = 3, events = 0, fd = 554050680, user_data = 0x8210624f0}, {pos = 738425032, events = 8, fd = 738425032, user_data = 0x8210624a0}, {pos = 624429765, events = 4122, fd = 554050784, user_data = 0x101a2537bb2b}, {pos = 554050744, events = 8, fd = 554050864, user_data = 0x82c0368d4}, {pos = 738420948, events = 8, fd = -557800440, user_data = 0x3}, {pos = 554050848, events = 8, fd = 624409387, user_data = 0x821062530}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 554050936, events = 8, fd = 554051384, user_data = 0x821062560}, {pos = 624428082, events = 4122, fd = 2717798, user_data = 0x3b05dec0f2a8}, {pos = 738344584, events = 8, fd = -557800440, user_data = 0x8210625b8}, {pos = 554051448, events = 8, fd = 554050976, user_data = 0x101a25380432}, {pos = 2742638, events = 0, fd = 448139, user_data = 0x7c96e577}, {pos = -557776816, events = 15109, fd = 1, user_data = 0x0}, {pos = 0, events = 0, fd = 554051688, user_data = 0x3210625a0}, {pos = 554051520, events = 8, fd = -557778200, user_data = 0x290}, {pos = 554051448, events = 8, fd = 554051000, user_data = 0x821062620}, {pos = 624427723, events = 4122, fd = 554051624, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x3b05dec10050}, {pos = 1, events = 8, fd = -557800440, user_data = 0x82c023e88}, {pos = 554051688, events = 8, fd = 554051520, user_data = 0x20}, {pos = 0, events = 0, fd = -557830136, user_data = 0x821062630}, {pos = 554051504, events = 8, fd = 624402631, user_data = 0x3b05dec03008}, {pos = -557829112, events = 15109, fd = -557828088, user_data = 0x3b05dec03c08}, {pos = -557813752, events = 15109, fd = -557812728, user_data = 0x3b05dec07808}, {pos = -557810680, events = 15109, fd = -557809656, user_data = 0x3b05dec08408}, {pos = -557807608, events = 15109, fd = -557806584, user_data = 0x3b05dec09008}, {pos = -557804536, events = 15109, fd = -557803512, user_data = 0x3b05dec09c08}, {pos = -557801464, events = 15109, fd = -557800440, user_data = 0x3b05dec0a808}, {pos = -557798392, events = 15109, fd = -557797368, user_data = 0x3b05dec0b408}, {pos = -557795320, events = 15109, fd = -557794296, user_data = 0x3b05dec0c008}, {pos = -557792248, events = 15109, fd = -557791224, user_data = 0x3b05dec0cc08}, {pos = -557785080, events = 15109, fd = -557784056, user_data = 0x3b05dec0e808}, {pos = -557782008, events = 15109, fd = -557830136, user_data = 0x29d96e}, {pos = 448139, events = 0, fd = 2090263927, user_data = 0x3b05dec10050}, {pos = 1, events = 0, fd = 0, user_data = 0x0}, {pos = 554051688, events = 8, fd = 554051120, user_data = 0x2000000020}, {pos = -557830136, events = 15109, fd = 1, user_data = 0x27cffc}, {pos = 302, events = 0, fd = -557776816, user_data = 0x821062850}, {pos = 624401340, events = 4122, fd = 2742638, user_data = 0x6d68b}, {pos = 2090263927, events = 0, fd = -557776816, user_data = 0x1}, {pos = 12768688, events = 0, fd = 739593584, user_data = 0x3b05dec03008}, {pos = 2848256, events = 0, fd = 701072713, user_data = 0x1}, {pos = -557109240, events = 15109, fd = 554051664, user_data = 0x829c976e5}, {pos = 739593584, events = 8, fd = 12768688, user_data = 0x82c154d70 }, {pos = -557800440, events = 15109, fd = 554051888, user_data = 0x101a253799b4}, {pos = 554051744, events = 8, fd = 1, user_data = 0x101a2537982e}, {pos = -557830136, events = 15109, fd = 554051672, user_data = 0x821062930}, {pos = 6936, events = 0, fd = 12, user_data = 0x101a2538db40}, {pos = 0, events = 0, fd = -553581697, user_data = 0x821062960}, {pos = 554051808, events = 8, fd = 701031888, user_data = 0x82c1f8300 <__thr_jtable>}, {pos = 740271600, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 554051856, events = 8, fd = 701031888, user_data = 0x82c1f8300 <__thr_jtable>}, {pos = 740271600, events = 8, fd = 0, user_data = 0x1fc0}, {pos = 554051904, events = 8, fd = 701074333, user_data = 0x3b05decb3008}, {pos = 65017, events = 0, fd = 554052000, user_data = 0x829c90a7d}} [09:52:06.431] last_touch_time = 1768988742 [09:52:06.431] last_lockfile_recheck_time = 1768988742 [09:52:06.431] nevents = 1 [09:52:06.431] #29 0x00000000008e0697 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x821062fb0) at ../src/backend/postmaster/postmaster.c:1403 [09:52:06.431] userDoption = [09:52:06.431] listen_addr_saved = false [09:52:06.431] output_config_variable = [09:52:06.431] opt = [09:52:06.431] status = [09:52:06.431] #30 0x000000000080c0cd in main (argc=8, argv=0x821062fb0) at ../src/backend/main/main.c:231 [09:52:06.431] do_check_root = [09:52:06.431] dispatch_option = DISPATCH_POSTMASTER