[21:13:09.507] src/tools/ci/cores_backtrace.sh linux /tmp/cores [21:13:10.197] dumping /tmp/cores/postgres-3-26876.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:13:11.892] [New LWP 26876] [21:13:11.892] [New LWP 25818] [21:13:11.892] Downloading separate debug info for /lib/x86_64-linux-gnu/libm.so.6... [21:13:12.656] Downloading separate debug info for /lib/x86_64-linux-gnu/libdl.so.2... [21:13:13.421] Downloading separate debug info for /lib/x86_64-linux-gnu/librt.so.1... [21:13:14.652] Downloading separate debug info for /lib/x86_64-linux-gnu/libgssapi_krb5.so.2... [21:13:17.039] Downloading separate debug info for /lib/x86_64-linux-gnu/libicuuc.so.67... [21:13:17.039] Downloading separate debug info for /.cache/debuginfod_client/f871bbd529a02abd860f0d16b842b5b20234cb49/debuginfo... [21:13:18.931] Downloading separate debug info for /lib/x86_64-linux-gnu/libicui18n.so.67... [21:13:20.169] Downloading separate debug info for /lib/x86_64-linux-gnu/libldap_r-2.4.so.2... [21:13:21.793] Downloading separate debug info for /lib/x86_64-linux-gnu/libxml2.so.2... [21:13:22.866] Downloading separate debug info for /lib/x86_64-linux-gnu/liblz4.so.1... [21:13:23.631] Downloading separate debug info for /lib/x86_64-linux-gnu/libpam.so.0... [21:13:24.859] Downloading separate debug info for /lib/x86_64-linux-gnu/libssl.so.1.1... [21:13:26.480] Downloading separate debug info for /lib/x86_64-linux-gnu/libcrypto.so.1.1... [21:13:27.892] Downloading separate debug info for /lib/x86_64-linux-gnu/libsystemd.so.0... [21:13:28.805] Downloading separate debug info for /lib/x86_64-linux-gnu/libz.so.1... [21:13:30.347] Downloading separate debug info for /lib/x86_64-linux-gnu/libzstd.so.1... [21:13:31.740] Downloading separate debug info for /lib/x86_64-linux-gnu/libpthread.so.0... [21:13:32.212] [Thread debugging using libthread_db enabled] [21:13:32.212] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [21:13:33.280] Downloading separate debug info for /lib64/ld-linux-x86-64.so.2... [21:13:34.681] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5.so.3... [21:13:35.750] Downloading separate debug info for /lib/x86_64-linux-gnu/libk5crypto.so.3... [21:13:36.375] Downloading separate debug info for /lib/x86_64-linux-gnu/libcom_err.so.2... [21:13:37.153] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5support.so.0... [21:13:39.473] Downloading separate debug info for /lib/x86_64-linux-gnu/libstdc++.so.6... [21:13:40.408] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcc_s.so.1... [21:13:41.185] Downloading separate debug info for /lib/x86_64-linux-gnu/liblber-2.4.so.2... [21:13:42.096] Downloading separate debug info for /lib/x86_64-linux-gnu/libresolv.so.2... [21:13:43.014] Downloading separate debug info for /lib/x86_64-linux-gnu/libsasl2.so.2... [21:13:44.603] Downloading separate debug info for /lib/x86_64-linux-gnu/libgnutls.so.30... [21:13:45.669] Downloading separate debug info for /lib/x86_64-linux-gnu/liblzma.so.5... [21:13:46.436] Downloading separate debug info for /lib/x86_64-linux-gnu/libaudit.so.1... [21:13:47.823] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcrypt.so.20... [21:13:48.441] Downloading separate debug info for /lib/x86_64-linux-gnu/libkeyutils.so.1... [21:13:49.982] Downloading separate debug info for /lib/x86_64-linux-gnu/libp11-kit.so.0... [21:13:50.747] Downloading separate debug info for /lib/x86_64-linux-gnu/libidn2.so.0... [21:13:51.980] Downloading separate debug info for /lib/x86_64-linux-gnu/libunistring.so.2... [21:13:52.762] Downloading separate debug info for /lib/x86_64-linux-gnu/libtasn1.so.6... [21:13:53.854] Downloading separate debug info for /lib/x86_64-linux-gnu/libnettle.so.8... [21:13:54.791] Downloading separate debug info for /lib/x86_64-linux-gnu/libhogweed.so.6... [21:13:56.054] Downloading separate debug info for /lib/x86_64-linux-gnu/libgmp.so.10... [21:13:56.686] Downloading separate debug info for /lib/x86_64-linux-gnu/libcap-ng.so.0... [21:13:57.620] Downloading separate debug info for /lib/x86_64-linux-gnu/libgpg-error.so.0... [21:13:58.400] Downloading separate debug info for /lib/x86_64-linux-gnu/libffi.so.7... [21:13:58.898] Core was generated by `postgres: standby: startup waiting for 000000010000000000000005 '. [21:13:58.898] Program terminated with signal SIGQUIT, Quit. [21:13:58.898] #0 0x00007fc683143fc7 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [21:13:58.925] [Current thread is 1 (LWP 26876)] [21:13:59.047] [21:13:59.047] Thread 2 (Thread 0x7fc680adaa40 (LWP 25818)): [21:13:59.047] #0 0x00007fc683206a61 in clone () from /lib/x86_64-linux-gnu/libc.so.6 [21:13:59.047] No symbol table info available. [21:13:59.047] #1 0x00007fc6831f4e5e in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [21:13:59.047] No symbol table info available. [21:13:59.047] #2 0x00007fc6831f5497 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [21:13:59.047] No symbol table info available. [21:13:59.047] #3 0x00007fc6831f4cdb in posix_spawn () from /lib/x86_64-linux-gnu/libc.so.6 [21:13:59.047] No symbol table info available. [21:13:59.047] #4 0x00007fc683150a69 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [21:13:59.047] No symbol table info available. [21:13:59.047] #5 0x000055e1ef99a275 in RestoreArchivedFile (path=path@entry=0x7ffc039417c0 "`\033\224\003\374\177", xlogfname=xlogfname@entry=0x7ffc03941c10 "00000001", '0' , "5", recovername=recovername@entry=0x55e1f04a8adc "RECOVERYXLOG", expectedSize=16777216, cleanupEnabled=) at ../src/backend/access/transam/xlogarchive.c:177 [21:13:59.047] xlogpath = "pg_wal/RECOVERYXLOG", '\000' , "pg_wal/000000015", '0' , '\000' , "\b\000\000\000\000\000\000\000\314RJ\360\341U\000\000\350\026\224\003\374\177\000\000\300RJ\360\341U\000\000\270\336/\360\341U\000\000\020\034\224\003\374\177\000\000\227\212J\360\341U\000\000\350\026\224\003\374\177\000\000\225\212J\360\341U\000\000\030\251\255\200\306\177\000\000\024\351/\360\341U", '\000' , "\b", '\000' , "\060", '\000' , "\002", '\000' ... [21:13:59.047] xlogRestoreCmd = 0x55e1f2a90598 "cp \"/tmp/cirrus-ci-build/build/testrun/recovery/020_archive_status/data/t_020_archive_status_primary_data/archives/00000001", '0' , "5\" \"pg_wal/RECOVERYXLOG\"" [21:13:59.047] lastRestartPointFname = "00000001", '0' , "2\000\351/\360\341U", '\000' , "\001\000\000\226h\000\000\300\266-\203\306\177\000\000`\267-\203\306\177\000\000\226h\000\000\002", '\000' , "\020\r\025\203\306\177\000\000\260\017\224\003\374\177", '\000' , "W\001*\203\306\177\000\000O\001*\203\306\177\000\000\230\005\251\362\341U", '\000' , "@", '\000' ... [21:13:59.047] rc = [21:13:59.047] stat_buf = {st_dev = 94428885659804, st_ino = 335544320, st_nlink = 140490579393888, st_mode = 0, st_uid = 0, st_gid = 1003, __pad0 = 0, st_rdev = 13995741791360498432, st_size = 16777216, st_blksize = 94428927165848, st_blocks = 140720368521648, st_atim = {tv_sec = 140720368521232, tv_nsec = 140720368521360}, st_mtim = {tv_sec = 0, tv_nsec = 94428927165848}, st_ctim = {tv_sec = 140490580120727, tv_nsec = 0}, __glibc_reserved = {94428885671608, 140720368524320, 94428887405081}} [21:13:59.047] restartSegNo = [21:13:59.047] restartRedoPtr = 33563696 [21:13:59.047] restartTli = 1 [21:13:59.047] __func__ = "RestoreArchivedFile" [21:13:59.047] #6 0x000055e1ef9a8f05 in XLogFileRead (segno=140720368524224, segno@entry=5, emode=emode@entry=13, tli=tli@entry=1, source=source@entry=XLOG_FROM_ARCHIVE, notfoundOk=notfoundOk@entry=true) at ../src/backend/access/transam/xlogrecovery.c:4209 [21:13:59.047] xlogfname = "00000001", '0' , "5\000history\000\037\224\003\374\177\000\000\212f\251\204\306\177\000\000h\315\350\360\002\000\000\000\356\001\000\000\000\000\000" [21:13:59.047] activitymsg = "waiting for 00000001", '0' , "5\000\177\000\000\270\336/\360\341U\000\000\060\342U\360\341U\000\000-\342U\360\341U\000\000(\037\224\003\374\177\000\000+\342U\360\341U\000" [21:13:59.047] path = "`\033\224\003\374\177\000\000`\033\224\003\000\000\000\000\001\000\000\000\000\000\000\000t\335/\360\341U\000\000pg_wal/RECOVERYHISTORY\000\000\b", '\000' , "\214\343/\360\341U\000\062", '\000' , "\b\000\000\000\000\000\000\000\071\367I\360\341U\000\000H\033\224\003\374\177\000\000\065\367I\360\341U\000\000\270\336/\360\341U\000\000A\367I\360\341U\000\000\071\367I\360\341U\000\000H\033\224\003\374\177\000\000\065\367I\360\341U\000\000\030\251\255\200\306\177\000\000V\350/\360\341U", '\000' ... [21:13:59.047] fd = [21:13:59.047] __func__ = "XLogFileRead" [21:13:59.047] #7 0x000055e1ef9a90f5 in XLogFileReadAnyTLI (segno=5, emode=emode@entry=13, source=XLOG_FROM_ANY) at ../src/backend/access/transam/xlogrecovery.c:4337 [21:13:59.047] hent = [21:13:59.047] tli = 1 [21:13:59.047] cell__state = {l = , i = } [21:13:59.047] path = "\027zJ\360\341U\000\000\030\251\255\200\306\177\000\000P\037\224\003\374\177\000\000\370\360/\360\341U\000\000\000\000\000\000\000\000\000\000\202=\352\360\341U\000\000\000>\352\360\341U\000\000\024\036\224\003\374\177\000\000X\341U\360\341U\000\000\221=\352\360\341U\000\000\000>\352\360\341U\000\000\064\036\224\003\374\177\000\000g\341U\360\341U\000\000\000>\352\360\341U\000\000\002\000\000\000\000\000\000\000\265\370/\360\341U\000\000\066\036\224\003\374\177\000\000\064\036\224\003\374\177", '\000' , "\030\000\000\000\060\000\000\000\020\036\224\003\374\177\000\000\216\371/\360\341U\000\000LC_MESSA"... [21:13:59.047] cell = [21:13:59.047] fd = [21:13:59.047] tles = 0x55e1f2aa2d48 [21:13:59.047] __func__ = "XLogFileReadAnyTLI" [21:13:59.047] #8 0x000055e1ef9aa2f1 in WaitForWALToBecomeAvailable (RecPtr=RecPtr@entry=83886104, randAccess=false, fetching_ckpt=false, tliRecPtr=tliRecPtr@entry=83886080, replayTLI=1, replayLSN=83886080, nonblocking=false) at ../src/backend/access/transam/xlogrecovery.c:3770 [21:13:59.047] oldSource = [21:13:59.047] startWalReceiver = false [21:13:59.047] last_fail_time = 766444251085859 [21:13:59.047] now = [21:13:59.047] streaming_reply_sent = false [21:13:59.047] __func__ = "WaitForWALToBecomeAvailable" [21:13:59.047] #9 0x000055e1ef9aae26 in XLogPageRead (xlogreader=0x55e1f2a3df10, targetPagePtr=83886080, reqLen=24, targetRecPtr=83886080, readBuf=0x55e1f2a8cd68 "\025\321\002") at ../src/backend/access/transam/xlogrecovery.c:3351 [21:13:59.047] private = 0x55e1f2a3def0 [21:13:59.047] emode = 15 [21:13:59.047] targetPageOff = 0 [21:13:59.047] targetSegNo = 5 [21:13:59.047] r = [21:13:59.047] __func__ = "XLogPageRead" [21:13:59.047] #10 0x000055e1ef9b3281 in ReadPageInternal (state=state@entry=0x55e1f2a3df10, pageptr=pageptr@entry=83886080, reqLen=reqLen@entry=24) at ../src/backend/access/transam/xlogreader.c:1060 [21:13:59.047] readLen = [21:13:59.047] targetPageOff = 0 [21:13:59.047] targetSegNo = 5 [21:13:59.047] hdr = [21:13:59.047] #11 0x000055e1ef9b4edc in XLogDecodeNextRecord (state=state@entry=0x55e1f2a3df10, nonblocking=nonblocking@entry=false) at ../src/backend/access/transam/xlogreader.c:597 [21:13:59.047] RecPtr = 83886080 [21:13:59.047] record = [21:13:59.047] targetPagePtr = 83886080 [21:13:59.047] randAccess = false [21:13:59.047] len = [21:13:59.047] total_len = [21:13:59.047] targetRecOff = 0 [21:13:59.047] pageHeaderSize = [21:13:59.047] assembled = false [21:13:59.047] gotheader = [21:13:59.047] readOff = [21:13:59.047] decoded = 0x0 [21:13:59.047] errormsg = 0x55e1f2a3df10 "\301\253\232\357\341U" [21:13:59.047] #12 0x000055e1ef9b5a7e in XLogReadAhead (state=0x55e1f2a3df10, nonblocking=nonblocking@entry=false) at ../src/backend/access/transam/xlogreader.c:973 [21:13:59.047] result = [21:13:59.047] #13 0x000055e1ef9a03c0 in XLogPrefetcherNextBlock (pgsr_private=94428926831936, lsn=0x55e1f2aa2718) at ../src/backend/access/transam/xlogprefetcher.c:492 [21:13:59.047] nonblocking = [21:13:59.047] record = [21:13:59.047] prefetcher = 0x55e1f2a3ed40 [21:13:59.047] reader = 0x55e1f2a3df10 [21:13:59.047] replaying_lsn = 67109152 [21:13:59.047] __func__ = "XLogPrefetcherNextBlock" [21:13:59.047] #14 0x000055e1ef9a4789 in lrq_prefetch (lrq=) at ../src/backend/access/transam/xlogprefetcher.c:252 [21:13:59.047] No locals. [21:13:59.047] #15 lrq_complete_lsn (lsn=83886080, lrq=0x55e1f2aa2618) at ../src/backend/access/transam/xlogprefetcher.c:290 [21:13:59.047] No locals. [21:13:59.047] #16 XLogPrefetcherReadRecord (prefetcher=prefetcher@entry=0x55e1f2a3ed40, errmsg=errmsg@entry=0x7ffc039463a8) at ../src/backend/access/transam/xlogprefetcher.c:1037 [21:13:59.047] record = [21:13:59.047] replayed_up_to = 83886080 [21:13:59.047] #17 0x000055e1ef9ab653 in ReadRecord (xlogprefetcher=0x55e1f2a3ed40, emode=emode@entry=15, fetching_ckpt=fetching_ckpt@entry=false, replayTLI=1) at ../src/backend/access/transam/xlogrecovery.c:3151 [21:13:59.047] errormsg = 0x55e1efeab12f "AUATUSH\203\354\bH\205\377\017\204:\001" [21:13:59.067] record = [21:13:59.067] xlogreader = 0x55e1f2a3df10 [21:13:59.067] private = [21:13:59.067] __func__ = "ReadRecord" [21:13:59.067] #18 0x000055e1ef9ae7ea in PerformWalRecovery () at ../src/backend/access/transam/xlogrecovery.c:1832 [21:13:59.067] xtime = [21:13:59.067] ru0 = {tv = {tv_sec = 1713129048, tv_usec = 59000}, ru = {ru_utime = {tv_sec = 0, tv_usec = 1057}, ru_stime = {tv_sec = 0, tv_usec = 0}, {ru_maxrss = 16144, __ru_maxrss_word = 16144}, {ru_ixrss = 0, __ru_ixrss_word = 0}, {ru_idrss = 0, __ru_idrss_word = 0}, {ru_isrss = 0, __ru_isrss_word = 0}, {ru_minflt = 397, __ru_minflt_word = 397}, {ru_majflt = 5, __ru_majflt_word = 5}, {ru_nswap = 0, __ru_nswap_word = 0}, {ru_inblock = 0, __ru_inblock_word = 0}, {ru_oublock = 0, __ru_oublock_word = 0}, {ru_msgsnd = 0, __ru_msgsnd_word = 0}, {ru_msgrcv = 0, __ru_msgrcv_word = 0}, {ru_nsignals = 0, __ru_nsignals_word = 0}, {ru_nvcsw = 2, __ru_nvcsw_word = 2}, {ru_nivcsw = 1, __ru_nivcsw_word = 1}}} [21:13:59.067] record = 0x7fc6803941f0 [21:13:59.067] reachedRecoveryTarget = false [21:13:59.067] replayTLI = 1 [21:13:59.067] __func__ = "PerformWalRecovery" [21:13:59.067] #19 0x000055e1ef99820d in StartupXLOG () at ../src/backend/access/transam/xlog.c:5806 [21:13:59.067] Insert = [21:13:59.067] checkPoint = {redo = 33554472, ThisTimeLineID = 1, PrevTimeLineID = 1, fullPageWrites = true, nextXid = {value = 739}, nextOid = 24576, nextMulti = 1, nextMultiOffset = 0, oldestXid = 730, oldestXidDB = 1, oldestMulti = 1, oldestMultiDB = 1, time = 1713129047, oldestCommitTsXid = 0, newestCommitTsXid = 0, oldestActiveXid = 739} [21:13:59.067] wasShutdown = false [21:13:59.067] didCrash = [21:13:59.067] haveTblspcMap = false [21:13:59.067] haveBackupLabel = false [21:13:59.067] EndOfLog = [21:13:59.067] EndOfLogTLI = [21:13:59.067] newTLI = [21:13:59.067] performedWalRecovery = [21:13:59.067] endOfRecoveryInfo = [21:13:59.067] abortedRecPtr = [21:13:59.067] missingContrecPtr = [21:13:59.067] oldestActiveXID = [21:13:59.067] promoted = false [21:13:59.067] __func__ = "StartupXLOG" [21:13:59.067] #20 0x000055e1efe5d1d8 in StartupProcessMain (startup_data=, startup_data_len=) at ../src/backend/postmaster/startup.c:258 [21:13:59.067] No locals. [21:13:59.067] #21 0x000055e1efe547f4 in postmaster_child_launch (child_type=child_type@entry=B_STARTUP, startup_data=startup_data@entry=0x0, startup_data_len=startup_data_len@entry=0, client_sock=client_sock@entry=0x0) at ../src/backend/postmaster/launch_backend.c:265 [21:13:59.067] pid = [21:13:59.067] #22 0x000055e1efe5686d in StartChildProcess (type=type@entry=B_STARTUP) at ../src/backend/postmaster/postmaster.c:3928 [21:13:59.067] pid = [21:13:59.067] __func__ = "StartChildProcess" [21:13:59.067] #23 0x000055e1efe5c937 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55e1f2a3cde0) at ../src/backend/postmaster/postmaster.c:1364 [21:13:59.067] opt = [21:13:59.067] status = [21:13:59.067] userDoption = [21:13:59.067] listen_addr_saved = false [21:13:59.067] output_config_variable = [21:13:59.067] __func__ = "PostmasterMain" [21:13:59.067] #24 0x000055e1efc7d538 in main (argc=4, argv=0x55e1f2a3cde0) at ../src/backend/main/main.c:197 [21:13:59.067] do_check_root = [21:13:59.067] [21:13:59.067] Thread 1 (LWP 26876): [21:13:59.067] #0 0x00007fc683143fc7 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [21:13:59.067] No symbol table info available. [21:13:59.067] #1 0x00007fc6831f513a in ?? () from /lib/x86_64-linux-gnu/libc.so.6 [21:13:59.067] No symbol table info available. [21:13:59.067] #2 0x00007fc683206a6f in clone () from /lib/x86_64-linux-gnu/libc.so.6 [21:13:59.067] No symbol table info available. [21:13:59.084] -e [21:13:59.084] [21:13:59.084] [21:13:59.630] dumping /tmp/cores/postgres-6-21840.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [21:13:59.951] [New LWP 21840] [21:14:01.112] [Thread debugging using libthread_db enabled] [21:14:01.112] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [21:14:02.571] Core was generated by `postgres: postgres regression [local] MERGE '. [21:14:02.571] Program terminated with signal SIGABRT, Aborted. [21:14:02.571] #0 0x00007f79c5f56ce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [21:14:02.788] [21:14:02.788] Thread 1 (Thread 0x7f79c38eda40 (LWP 21840)): [21:14:02.788] #0 0x00007f79c5f56ce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [21:14:02.788] No symbol table info available. [21:14:02.788] #1 0x00007f79c5f40537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [21:14:02.788] No symbol table info available. [21:14:02.788] #2 0x000055f9176606c2 in ExceptionalCondition (conditionName=conditionName@entry=0x55f9178b54d8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x55f9178d9dd8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:14:02.788] No locals. [21:14:02.788] #3 0x000055f916fb25db in ExecFetchSlotHeapTuple (slot=slot@entry=0x7fff1a2efba0, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7fff1a2efa3f) at ../src/backend/executor/execTuples.c:1737 [21:14:02.788] No locals. [21:14:02.788] #4 0x000055f916f35fd4 in ExecIRDeleteTriggers (estate=estate@entry=0x55f9199d4180, relinfo=relinfo@entry=0x55f9199d4730, slot=slot@entry=0x7fff1a2efba0) at ../src/backend/commands/trigger.c:2841 [21:14:02.788] trigger = 0x55f9199d4990 [21:14:02.788] oldtuple = [21:14:02.788] trigdesc = 0x55f9199d4940 [21:14:02.788] newtuple = 0x0 [21:14:02.788] should_free = false [21:14:02.788] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7f79ba62ddd8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:14:02.788] i = 0 [21:14:02.788] #5 0x000055f9170154ef in ExecMergeMatched (context=0x7fff1a2efbc0, resultRelInfo=resultRelInfo@entry=0x55f9199d4730, tupleid=0x0, oldtuple=0x7fff1a2efba0, canSetTag=true, matched=matched@entry=0x7fff1a2efb4f) at ../src/backend/executor/nodeModifyTable.c:3027 [21:14:02.788] relaction = 0x55f919a06538 [21:14:02.788] commandType = CMD_DELETE [21:14:02.788] result = TM_Ok [21:14:02.788] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:14:02.788] l__state = {l = , i = } [21:14:02.788] mtstate = 0x55f9199d4520 [21:14:02.788] mergeActions = 0x55f9199d4840 [21:14:02.788] actionStates = 0x55f919a06af8 [21:14:02.788] newslot = 0x0 [21:14:02.788] rslot = 0x0 [21:14:02.788] estate = 0x55f9199d4180 [21:14:02.788] econtext = 0x55f919a05b48 [21:14:02.788] isNull = false [21:14:02.788] epqstate = 0x55f9199d4608 [21:14:02.788] l = [21:14:02.788] __func__ = "ExecMergeMatched" [21:14:02.788] lmerge_matched = [21:14:02.788] #6 0x000055f9170165d7 in ExecMerge (context=context@entry=0x7fff1a2efbc0, resultRelInfo=resultRelInfo@entry=0x55f9199d4730, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7fff1a2efba0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [21:14:02.788] rslot = 0x0 [21:14:02.788] matched = true [21:14:02.788] #7 0x000055f91701832e in ExecModifyTable (pstate=0x55f9199d4520) at ../src/backend/executor/nodeModifyTable.c:4112 [21:14:02.788] node = 0x55f9199d4520 [21:14:02.788] context = {mtstate = 0x55f9199d4520, epqstate = 0x55f9199d4608, estate = 0x55f9199d4180, planSlot = 0x55f919a04558, tmfd = {ctid = {ip_blkid = {bi_hi = 1, bi_lo = 0}, ip_posid = 0}, xmax = 385413554, cmax = 22009, traversed = 24}, cpUpdateReturningSlot = 0x55f919acf180} [21:14:02.788] estate = 0x55f9199d4180 [21:14:02.788] operation = CMD_MERGE [21:14:02.788] resultRelInfo = 0x55f9199d4730 [21:14:02.788] subplanstate = 0x55f9199d4e60 [21:14:02.788] slot = [21:14:02.788] oldSlot = [21:14:02.788] tuple_ctid = {ip_blkid = {bi_hi = 6572, bi_lo = 22009}, ip_posid = 0} [21:14:02.788] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x55f919a362c8} [21:14:02.788] oldtuple = 0x7fff1a2efba0 [21:14:02.788] tupleid = 0x0 [21:14:02.788] __func__ = "ExecModifyTable" [21:14:02.788] #8 0x000055f916fa47a6 in ExecProcNodeFirst (node=0x55f9199d4520) at ../src/backend/executor/execProcnode.c:464 [21:14:02.788] No locals. [21:14:02.788] #9 0x000055f916f90ea1 in ExecProcNode (node=0x55f9199d4520) at ../src/include/executor/executor.h:274 [21:14:02.788] No locals. [21:14:02.788] #10 ExecutePlan (estate=estate@entry=0x55f9199d4180, planstate=0x55f9199d4520, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x55f919a5a080, execute_once=true) at ../src/backend/executor/execMain.c:1646 [21:14:02.788] slot = [21:14:02.788] current_tuple_count = 0 [21:14:02.788] #11 0x000055f916f911eb in standard_ExecutorRun (queryDesc=0x55f919a628c8, direction=ForwardScanDirection, count=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [21:14:02.788] estate = 0x55f9199d4180 [21:14:02.788] operation = CMD_MERGE [21:14:02.788] dest = 0x55f919a5a080 [21:14:02.788] sendTuples = true [21:14:02.788] oldcontext = 0x55f919a59d70 [21:14:02.788] __func__ = "standard_ExecutorRun" [21:14:02.788] #12 0x000055f916f91356 in ExecutorRun (queryDesc=queryDesc@entry=0x55f919a628c8, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:304 [21:14:02.788] No locals. [21:14:02.788] #13 0x000055f9173b65a3 in ProcessQuery (plan=plan@entry=0x55f919ad2088, sourceText=0x55f9198d11e0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., params=0x0, queryEnv=0x0, dest=dest@entry=0x55f919a5a080, qc=qc@entry=0x7fff1a2efde0) at ../src/backend/tcop/pquery.c:160 [21:14:02.788] queryDesc = 0x55f919a628c8 [21:14:02.788] #14 0x000055f9173b82f2 in PortalRunMulti (portal=portal@entry=0x55f919951f10, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55f919a5a080, altdest=0x55f917b9d380 , qc=qc@entry=0x7fff1a2efde0) at ../src/backend/tcop/pquery.c:1277 [21:14:02.788] pstmt = 0x55f919ad2088 [21:14:02.788] stmtlist_item__state = {l = , i = } [21:14:02.788] active_snapshot_set = true [21:14:02.788] stmtlist_item = 0x55f919ad21b0 [21:14:02.788] #15 0x000055f9173b8998 in FillPortalStore (portal=portal@entry=0x55f919951f10, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [21:14:02.788] treceiver = 0x55f919a5a080 [21:14:02.788] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:14:02.788] __func__ = "FillPortalStore" [21:14:02.788] #16 0x000055f9173b8ff7 in PortalRun (portal=portal@entry=0x55f919951f10, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55f919ad21e8, altdest=altdest@entry=0x55f919ad21e8, qc=0x7fff1a2effc0) at ../src/backend/tcop/pquery.c:763 [21:14:02.788] _save_exception_stack = 0x7fff1a2f0070 [21:14:02.788] _save_context_stack = 0x0 [21:14:02.788] _local_sigjmp_buf = {{__jmpbuf = {1, 2670743194891291276, 94528365994472, 94528366258672, 94528364420880, 94528366258600, -2671102331471689076, -8150867996631266676}, __mask_was_saved = 0, __saved_mask = {__val = {94528364432440, 94528330960606, 94528364429088, 94528330960606, 1, 140733632675663, 94528366258648, 94528366258600, 94528327892489, 94528330546121, 94528364420880, 94528330960606, 1, 1, 94528328161290, 163}}}} [21:14:02.788] _do_rethrow = [21:14:02.788] result = [21:14:02.788] nprocessed = [21:14:02.788] saveTopTransactionResourceOwner = 0x55f919910bd8 [21:14:02.788] saveTopTransactionContext = 0x55f9198f9af0 [21:14:02.788] saveActivePortal = 0x0 [21:14:02.788] saveResourceOwner = 0x55f919910bd8 [21:14:02.788] savePortalContext = 0x0 [21:14:02.788] saveMemoryContext = 0x55f9198f9af0 [21:14:02.788] __func__ = "PortalRun" [21:14:02.788] #17 0x000055f9173b1f80 in exec_simple_query (query_string=query_string@entry=0x55f9198d11e0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1274 [21:14:02.788] cmdtaglen = 5 [21:14:02.788] snapshot_set = [21:14:02.788] per_parsetree_context = 0x0 [21:14:02.788] plantree_list = 0x55f919ad2198 [21:14:02.788] parsetree = 0x55f919b129a8 [21:14:02.788] commandTag = [21:14:02.788] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:14:02.788] querytree_list = [21:14:02.788] portal = 0x55f919951f10 [21:14:02.788] receiver = 0x55f919ad21e8 [21:14:02.788] format = 0 [21:14:02.788] cmdtagname = [21:14:02.788] parsetree_item__state = {l = , i = } [21:14:02.788] dest = DestRemote [21:14:02.788] oldcontext = 0x55f9198f9af0 [21:14:02.788] parsetree_list = 0x55f919b129d8 [21:14:02.788] parsetree_item = 0x55f919b129f0 [21:14:02.788] save_log_statement_stats = false [21:14:02.788] was_logged = false [21:14:02.788] use_implicit_block = false [21:14:02.788] msec_str = " \002/\032\377\177\000\000\242\232h\027\371U\000\000P\000/\032\377\177\000\000\026\001\000\000\000\000\000" [21:14:02.788] __func__ = "exec_simple_query" [21:14:02.788] #18 0x000055f9173b4d3e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [21:14:02.788] query_string = 0x55f9198d11e0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [21:14:02.788] firstchar = [21:14:02.788] input_message = {data = 0x55f9198d11e0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 278, maxlen = 1024, cursor = 278} [21:14:02.788] local_sigjmp_buf = {{__jmpbuf = {94528340627224, -8150861541197378932, 4, 140733632676384, 140733632676532, 1, -2671102322013533556, -8150867989852878196}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140160989281764, 94528363867792, 15616, 15680, 94528328064686, 94528340627232, 94528363867792, 94528340621304, 140733632676384, 140733632676532, 94528328068754, 140733632676160}}}} [21:14:02.788] send_ready_for_query = false [21:14:02.788] idle_in_transaction_timeout_enabled = false [21:14:02.788] idle_session_timeout_enabled = false [21:14:02.788] __func__ = "PostgresMain" [21:14:02.788] #19 0x000055f9173ab4e0 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [21:14:02.788] bsdata = [21:14:02.788] #20 0x000055f91724f7f4 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff1a2f01cc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff1a2f0220) at ../src/backend/postmaster/launch_backend.c:265 [21:14:02.788] pid = [21:14:02.788] #21 0x000055f917255b22 in BackendStartup (client_sock=client_sock@entry=0x7fff1a2f0220) at ../src/backend/postmaster/postmaster.c:3593 [21:14:02.788] bn = 0x55f9198fa118 [21:14:02.788] pid = [21:14:02.788] startup_data = {canAcceptConnections = CAC_OK} [21:14:02.788] __func__ = "BackendStartup" [21:14:02.788] #22 0x000055f9172560d0 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:14:02.788] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "\362\305y\177\000\000 \311\302\306y\177\000\000\310\002/\032\377\177\000\000\304\002/\032\377\177\000\000\000\000\000\000\377\177\000\000@n\222\303y\177\000\000\000\000\000\000\377\177\000\000\020\376\362\305y\177\000\000\340\037\362\305y\177\000\000\352_\017\306y\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000\304\002/\032\377\177\000\000@n\222\303y\177\000\000\220\003/\032\377\177\000", __ss_align = 140160990655264}, salen = 2}} [21:14:02.788] i = 0 [21:14:02.788] now = [21:14:02.788] last_lockfile_recheck_time = 1713129028 [21:14:02.788] last_touch_time = 1713129028 [21:14:02.788] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 18, user_data = 0x59e7c8ee}, {pos = -960313464, events = 32633, fd = -972070934, user_data = 0x7fff1a2f0428}, {pos = 439288704, events = 32767, fd = 439288720, user_data = 0x7f79c789dce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = -1014024680, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f79c6c2c420}, {pos = -1, events = 0, fd = -1014024680, user_data = 0x7f79c6c2c420}, {pos = -960313056, events = 1, fd = -960313464, user_data = 0x0}, {pos = 439288704, events = 32767, fd = 1024, user_data = 0xffffffff}, {pos = 439288992, events = 32767, fd = -973986792, user_data = 0x7f79c6c2c920}, {pos = 428862344, events = 22009, fd = 428852872, user_data = 0x55f9198f6970}, {pos = 428862376, events = 22009, fd = 428862177, user_data = 0x7f79c78a2623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = -971968264, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1}, {pos = 428683184, events = 22009, fd = -947247581, user_data = 0x1}, {pos = 0, events = 0, fd = 428829040, user_data = 0x7f79c5f22418}, {pos = 439289840, events = 32767, fd = -947218806, user_data = 0x0}, {pos = 0, events = 0, fd = 439289872, user_data = 0x55f918292cc0 }, {pos = 2, events = 0, fd = 405351616, user_data = 0x0}, {pos = -973460058, events = 32633, fd = 428886864, user_data = 0x7f79c60ecbe0}, {pos = 255, events = 0, fd = 8096, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x10f}, {pos = 4144, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x0}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1734701663, events = 1936942450, fd = 879573293, user_data = 0x42346d392d737365}, {pos = 168458312, events = 908075040, fd = 822763892, user_data = 0x30340a3832303932}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 538976266, user_data = 0x2020202020203635}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55f9198cef30}, {pos = 428666672, events = 22009, fd = -972126080, user_data = 0x7f79c5f9b51a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = -973468677, user_data = 0x400}, {pos = 428666672, events = 22009, fd = -972123008, user_data = 0x1198cef30}, {pos = 784, events = 0, fd = 395203148, user_data = 0x2}, {pos = 6, events = 2147483648, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x55f9176a92b0 }, {pos = 428852064, events = 22009, fd = 428852064, user_data = 0x55f9198fc360}, {pos = 1, events = 0, fd = 428852264, user_data = 0x400}, {pos = 0, events = 0, fd = 392935133, user_data = 0x55f9182a0ed0 }, {pos = 392861015, events = 22009, fd = 428852064, user_data = 0x55f9198d10e0}, {pos = 428852064, events = 22009, fd = 15, user_data = 0x4a}, {pos = 392936943, events = 22009, fd = 428852064, user_data = 0x55f9176bbf38 }, {pos = 428666672, events = 22009, fd = -973468677, user_data = 0x0}, {pos = 386298626, events = 22009, fd = 428840672, user_data = 0x7f79c5f9d1aa}, {pos = 439290024, events = 1, fd = 0, user_data = 0x7f79c5f9b8f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 19545, user_data = 0x7f79c5fe5b05 }, {pos = 0, events = 0, fd = -1317154304, user_data = 0x0}, {pos = 388298010, events = 22009, fd = 4194304, user_data = 0x55f9176a93eb }, {pos = 428840672, events = 22009, fd = 428675296, user_data = 0x55f9198f96e0}, {pos = 1, events = 0, fd = 0, user_data = 0x55f9176bbdef }, {pos = 428840672, events = 22009, fd = 392937272, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x55f917066ed5 }, {pos = 0, events = 0, fd = 386321579, user_data = 0xb}, {pos = 388319860, events = 22009, fd = 0, user_data = 0x0}} [21:14:02.789] nevents = 1 [21:14:02.789] __func__ = "ServerLoop" [21:14:02.789] #23 0x000055f917257af2 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x55f9198cadf0) at ../src/backend/postmaster/postmaster.c:1372 [21:14:02.789] opt = [21:14:02.789] status = [21:14:02.789] userDoption = [21:14:02.789] listen_addr_saved = false [21:14:02.789] output_config_variable = [21:14:02.789] __func__ = "PostmasterMain" [21:14:02.789] #24 0x000055f917078538 in main (argc=8, argv=0x55f9198cadf0) at ../src/backend/main/main.c:197 [21:14:02.789] do_check_root = [21:14:02.807] -e [21:14:02.807] [21:14:02.807] [21:14:03.362] dumping /tmp/cores/postgres-6-22824.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:14:03.675] [New LWP 22824] [21:14:04.826] [Thread debugging using libthread_db enabled] [21:14:04.826] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [21:14:06.264] Core was generated by `postgres: old_node: postgres regression [local] MERGE '. [21:14:06.264] Program terminated with signal SIGABRT, Aborted. [21:14:06.264] #0 0x00007fd78daadce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [21:14:06.477] [21:14:06.477] Thread 1 (Thread 0x7fd78b444a40 (LWP 22824)): [21:14:06.477] #0 0x00007fd78daadce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [21:14:06.477] No symbol table info available. [21:14:06.477] #1 0x00007fd78da97537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [21:14:06.477] No symbol table info available. [21:14:06.477] #2 0x0000559ab8ec36c2 in ExceptionalCondition (conditionName=conditionName@entry=0x559ab91184d8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x559ab913cdd8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:14:06.477] No locals. [21:14:06.477] #3 0x0000559ab88155db in ExecFetchSlotHeapTuple (slot=slot@entry=0x7ffce1dca880, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7ffce1dca71f) at ../src/backend/executor/execTuples.c:1737 [21:14:06.477] No locals. [21:14:06.477] #4 0x0000559ab8798fd4 in ExecIRDeleteTriggers (estate=estate@entry=0x559abaee28a0, relinfo=relinfo@entry=0x559abaee2e50, slot=slot@entry=0x7ffce1dca880) at ../src/backend/commands/trigger.c:2841 [21:14:06.477] trigger = 0x559abaee30b0 [21:14:06.477] oldtuple = [21:14:06.477] trigdesc = 0x559abaee3060 [21:14:06.477] newtuple = 0x0 [21:14:06.477] should_free = false [21:14:06.477] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7fd78249e6d8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:14:06.477] i = 0 [21:14:06.477] #5 0x0000559ab88784ef in ExecMergeMatched (context=0x7ffce1dca8a0, resultRelInfo=resultRelInfo@entry=0x559abaee2e50, tupleid=0x0, oldtuple=0x7ffce1dca880, canSetTag=true, matched=matched@entry=0x7ffce1dca82f) at ../src/backend/executor/nodeModifyTable.c:3027 [21:14:06.477] relaction = 0x559abaf7c798 [21:14:06.477] commandType = CMD_DELETE [21:14:06.477] result = TM_Ok [21:14:06.477] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:14:06.477] l__state = {l = , i = } [21:14:06.477] mtstate = 0x559abaee2c40 [21:14:06.477] mergeActions = 0x559abaee2f60 [21:14:06.477] actionStates = 0x559abaf7cd58 [21:14:06.477] newslot = 0x0 [21:14:06.477] rslot = 0x0 [21:14:06.477] estate = 0x559abaee28a0 [21:14:06.477] econtext = 0x559abaf7bda8 [21:14:06.477] isNull = false [21:14:06.477] epqstate = 0x559abaee2d28 [21:14:06.477] l = [21:14:06.477] __func__ = "ExecMergeMatched" [21:14:06.477] lmerge_matched = [21:14:06.477] #6 0x0000559ab88795d7 in ExecMerge (context=context@entry=0x7ffce1dca8a0, resultRelInfo=resultRelInfo@entry=0x559abaee2e50, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7ffce1dca880, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [21:14:06.477] rslot = 0x0 [21:14:06.477] matched = true [21:14:06.477] #7 0x0000559ab887b32e in ExecModifyTable (pstate=0x559abaee2c40) at ../src/backend/executor/nodeModifyTable.c:4112 [21:14:06.477] node = 0x559abaee2c40 [21:14:06.477] context = {mtstate = 0x559abaee2c40, epqstate = 0x559abaee2d28, estate = 0x559abaee28a0, planSlot = 0x559abaf7a7b8, tmfd = {ctid = {ip_blkid = {bi_hi = 1, bi_lo = 0}, ip_posid = 0}, xmax = 3095339442, cmax = 21914, traversed = 248}, cpUpdateReturningSlot = 0x559abafd0760} [21:14:06.477] estate = 0x559abaee28a0 [21:14:06.477] operation = CMD_MERGE [21:14:06.477] resultRelInfo = 0x559abaee2e50 [21:14:06.477] subplanstate = 0x559abaee3580 [21:14:06.477] slot = [21:14:06.477] oldSlot = [21:14:06.477] tuple_ctid = {ip_blkid = {bi_hi = 47869, bi_lo = 21914}, ip_posid = 0} [21:14:06.477] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x559abaf449e8} [21:14:06.477] oldtuple = 0x7ffce1dca880 [21:14:06.477] tupleid = 0x0 [21:14:06.477] __func__ = "ExecModifyTable" [21:14:06.477] #8 0x0000559ab88077a6 in ExecProcNodeFirst (node=0x559abaee2c40) at ../src/backend/executor/execProcnode.c:464 [21:14:06.477] No locals. [21:14:06.477] #9 0x0000559ab87f3ea1 in ExecProcNode (node=0x559abaee2c40) at ../src/include/executor/executor.h:274 [21:14:06.477] No locals. [21:14:06.477] #10 ExecutePlan (estate=estate@entry=0x559abaee28a0, planstate=0x559abaee2c40, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x559abaea9a70, execute_once=true) at ../src/backend/executor/execMain.c:1646 [21:14:06.477] slot = [21:14:06.477] current_tuple_count = 0 [21:14:06.477] #11 0x0000559ab87f41eb in standard_ExecutorRun (queryDesc=0x559abaf5ed88, direction=ForwardScanDirection, count=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [21:14:06.477] estate = 0x559abaee28a0 [21:14:06.477] operation = CMD_MERGE [21:14:06.477] dest = 0x559abaea9a70 [21:14:06.477] sendTuples = true [21:14:06.477] oldcontext = 0x559abaea9760 [21:14:06.477] __func__ = "standard_ExecutorRun" [21:14:06.477] #12 0x0000559ab87f4356 in ExecutorRun (queryDesc=queryDesc@entry=0x559abaf5ed88, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:304 [21:14:06.477] No locals. [21:14:06.477] #13 0x0000559ab8c195a3 in ProcessQuery (plan=plan@entry=0x559abafd3668, sourceText=0x559abaddf1d0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., params=0x0, queryEnv=0x0, dest=dest@entry=0x559abaea9a70, qc=qc@entry=0x7ffce1dcaac0) at ../src/backend/tcop/pquery.c:160 [21:14:06.477] queryDesc = 0x559abaf5ed88 [21:14:06.477] #14 0x0000559ab8c1b2f2 in PortalRunMulti (portal=portal@entry=0x559abae62ed0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x559abaea9a70, altdest=0x559ab9400380 , qc=qc@entry=0x7ffce1dcaac0) at ../src/backend/tcop/pquery.c:1277 [21:14:06.477] pstmt = 0x559abafd3668 [21:14:06.477] stmtlist_item__state = {l = , i = } [21:14:06.477] active_snapshot_set = true [21:14:06.477] stmtlist_item = 0x559abafd3790 [21:14:06.477] #15 0x0000559ab8c1b998 in FillPortalStore (portal=portal@entry=0x559abae62ed0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [21:14:06.477] treceiver = 0x559abaea9a70 [21:14:06.477] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:14:06.477] __func__ = "FillPortalStore" [21:14:06.477] #16 0x0000559ab8c1bff7 in PortalRun (portal=portal@entry=0x559abae62ed0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x559abafd37c8, altdest=altdest@entry=0x559abafd37c8, qc=0x7ffce1dcaca0) at ../src/backend/tcop/pquery.c:763 [21:14:06.477] _save_exception_stack = 0x7ffce1dcad50 [21:14:06.477] _save_context_stack = 0x0 [21:14:06.477] _local_sigjmp_buf = {{__jmpbuf = {1, -1860112271142430922, 94123050481608, 94123050688672, 94123048971984, 94123050688600, 1861761291993339702, 5556030432934221622}, __mask_was_saved = 0, __saved_mask = {__val = {94123048983544, 94123018993374, 94123048980192, 94123018993374, 1, 140724097821743, 94123050688648, 94123050688600, 94123015925257, 94123018578889, 94123048971984, 94123018993374, 1, 1, 94123016194058, 163}}}} [21:14:06.477] _do_rethrow = [21:14:06.477] result = [21:14:06.477] nprocessed = [21:14:06.477] saveTopTransactionResourceOwner = 0x559abae20088 [21:14:06.477] saveTopTransactionContext = 0x559abaeb92d0 [21:14:06.477] saveActivePortal = 0x0 [21:14:06.477] saveResourceOwner = 0x559abae20088 [21:14:06.477] savePortalContext = 0x0 [21:14:06.477] saveMemoryContext = 0x559abaeb92d0 [21:14:06.477] __func__ = "PortalRun" [21:14:06.477] #17 0x0000559ab8c14f80 in exec_simple_query (query_string=query_string@entry=0x559abaddf1d0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1274 [21:14:06.477] cmdtaglen = 5 [21:14:06.477] snapshot_set = [21:14:06.477] per_parsetree_context = 0x0 [21:14:06.477] plantree_list = 0x559abafd3778 [21:14:06.477] parsetree = 0x559abb006058 [21:14:06.477] commandTag = [21:14:06.477] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:14:06.477] querytree_list = [21:14:06.477] portal = 0x559abae62ed0 [21:14:06.477] receiver = 0x559abafd37c8 [21:14:06.477] format = 0 [21:14:06.477] cmdtagname = [21:14:06.477] parsetree_item__state = {l = , i = } [21:14:06.477] dest = DestRemote [21:14:06.477] oldcontext = 0x559abaeb92d0 [21:14:06.477] parsetree_list = 0x559abb006088 [21:14:06.477] parsetree_item = 0x559abb0060a0 [21:14:06.477] save_log_statement_stats = false [21:14:06.477] was_logged = true [21:14:06.477] use_implicit_block = false [21:14:06.477] msec_str = "\000\257\334\341\374\177\000\000\242\312U\000\000\060\255\334\341\374\177\000\000\026\001\000\000\000\000\000" [21:14:06.477] __func__ = "exec_simple_query" [21:14:06.477] #18 0x0000559ab8c17d3e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [21:14:06.477] query_string = 0x559abaddf1d0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [21:14:06.477] firstchar = [21:14:06.477] input_message = {data = 0x559abaddf1d0 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 278, maxlen = 1024, cursor = 278} [21:14:06.477] local_sigjmp_buf = {{__jmpbuf = {94123028659992, 5556033323416278838, 4, 140724097822464, 140724097822612, 1, 1861761292198860598, 5556030426156095286}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 14344, 0, 1, 140563771796964, 94123048406688, 14336, 14400, 94123016097454, 94123028660000, 94123048406688, 94123028654072, 140724097822464, 140724097822612, 94123016101522, 140724097822240}}}} [21:14:06.477] send_ready_for_query = false [21:14:06.477] idle_in_transaction_timeout_enabled = false [21:14:06.477] idle_session_timeout_enabled = false [21:14:06.477] __func__ = "PostgresMain" [21:14:06.477] #19 0x0000559ab8c0e4e0 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [21:14:06.477] bsdata = [21:14:06.477] #20 0x0000559ab8ab27f4 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffce1dcaeac "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffce1dcaf00) at ../src/backend/postmaster/launch_backend.c:265 [21:14:06.477] pid = [21:14:06.477] #21 0x0000559ab8ab8b22 in BackendStartup (client_sock=client_sock@entry=0x7ffce1dcaf00) at ../src/backend/postmaster/postmaster.c:3593 [21:14:06.477] bn = 0x559abae15188 [21:14:06.477] pid = [21:14:06.477] startup_data = {canAcceptConnections = CAC_OK} [21:14:06.477] __func__ = "BackendStartup" [21:14:06.477] #22 0x0000559ab8ab90d0 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:14:06.477] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "č\327\177\000\000\001\000\000\000\000\000\000\000\244C?\217\327\177\000\000-\000\000\000\000\000\000\000\020n\250\215\327\177\000\000 9x\216\327\177\000\000ȯ\334\341\374\177\000\000į\334\341\374\177\000\000\204\257\334\341\374\177\000\000@\336\000\000\001\000\000\000\000\000\000\000\232U\000\000\020n\250\215\327\177\000\000\340\217\247\215\327\177\000\000\352\317č\327\177\000\000\356\310\347Y\000\000\000", __ss_align = 23568163}, salen = 2}} [21:14:06.477] i = 0 [21:14:06.477] now = [21:14:06.477] last_lockfile_recheck_time = 1713129030 [21:14:06.477] last_touch_time = 1713129030 [21:14:06.477] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -505630592, events = 32764, fd = 45, user_data = 0x7ffce1dcb040}, {pos = -505630640, events = 0, fd = 0, user_data = 0x12}, {pos = 1508362478, events = 0, fd = -1904724088, user_data = 0x7fd78dc4cfea}, {pos = -505630424, events = 32764, fd = -505630592, user_data = 0x7ffce1dcb090}, {pos = -1891676959, events = 32727, fd = 18, user_data = 0x7fd78b44a618}, {pos = 1, events = 0, fd = 0, user_data = 0x1}, {pos = -1904724960, events = 32727, fd = -1, user_data = 0x7fd78b44a618}, {pos = -1904724960, events = 32727, fd = 1024, user_data = 0x7fd78e783788}, {pos = 0, events = 0, fd = 7, user_data = 0x7ffce1dcb090}, {pos = -1, events = 0, fd = -1917616966, user_data = 0x7fd78da79418}, {pos = -1904723680, events = 32727, fd = -1159691400, user_data = 0x559abae08208}, {pos = -1159684080, events = 21914, fd = -1159691368, user_data = 0x559abae092f1}, {pos = -1891658205, events = 32727, fd = 1, user_data = 0x7fd78dc660f8 <__libc_fork@got.plt>}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 1, events = 0, fd = -1159852176, user_data = 0x7fd78f3f9623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = 0, user_data = 0x559abae0a010}, {pos = -1918397416, events = 32727, fd = -505629488, user_data = 0x7fd78f40068a <_dl_runtime_resolve_xsavec+122>}, {pos = 0, events = 0, fd = 0, user_data = 0x7ffce1dcb4f0}, {pos = -1179689792, events = 21914, fd = 2, user_data = 0x559ab9af5cc0 }, {pos = 0, events = 0, fd = 7, user_data = 0x0}, {pos = 4096, events = 0, fd = 99, user_data = 0x2ffff00001fa0}, {pos = 4144, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = -1159691480, user_data = 0x3ff}, {pos = 4096, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffffffffffffff}, {pos = -1, events = 4294967295, fd = 794915937, user_data = 0x6770755f67705f32}, {pos = 1853190772, events = 1600614447, fd = 1919381621, user_data = 0x3137353736202020}, {pos = 538976304, events = 538976288, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 7, events = 0, fd = -1917878994, user_data = 0x400}, {pos = -1159868608, events = 21914, fd = -1916533632, user_data = 0x1baddcf40}, {pos = 784, events = 0, fd = -1189838260, user_data = 0x559abae07ee0}, {pos = -1933666304, events = 2549598632, fd = 4, user_data = 0x559abae082f0}, {pos = 2, events = 0, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x559abae07ee0}, {pos = 1, events = 0, fd = -1159692376, user_data = 0x400}, {pos = 0, events = 0, fd = -1192106275, user_data = 0x559ab9b03ed0 }, {pos = -1192180393, events = 21914, fd = -1159692576, user_data = 0x559abaddf0d0}, {pos = -1159692576, events = 21914, fd = 15, user_data = 0x4a}, {pos = -1192104465, events = 21914, fd = -1159692576, user_data = 0x559ab8f1ef38 }, {pos = -1159868608, events = 21914, fd = -1917878994, user_data = 0x0}, {pos = -1198742782, events = 21914, fd = -1159697728, user_data = 0x7fd78daf41aa}, {pos = -505629304, events = 1, fd = 0, user_data = 0x7fd78daf28f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 20115, user_data = 0x7fd78db3cb05 }, {pos = 0, events = 0, fd = -1933666304, user_data = 0x0}, {pos = -1196743398, events = 21914, fd = 4194304, user_data = 0x559ab8f0c3eb }, {pos = -1159697728, events = 21914, fd = -1159860016, user_data = 0x559abae06ac0}, {pos = 1, events = 0, fd = 0, user_data = 0x559ab8f1edef }, {pos = -1159697728, events = 21914, fd = -1192104136, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x559ab88c9ed5 }, {pos = 0, events = 0, fd = -1198719829, user_data = 0xb}, {pos = -1196721548, events = 21914, fd = 0, user_data = 0x0}} [21:14:06.478] nevents = 1 [21:14:06.478] __func__ = "ServerLoop" [21:14:06.478] #23 0x0000559ab8abaaf2 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x559abadd8db0) at ../src/backend/postmaster/postmaster.c:1372 [21:14:06.478] opt = [21:14:06.478] status = [21:14:06.478] userDoption = [21:14:06.478] listen_addr_saved = false [21:14:06.478] output_config_variable = [21:14:06.478] __func__ = "PostmasterMain" [21:14:06.478] #24 0x0000559ab88db538 in main (argc=4, argv=0x559abadd8db0) at ../src/backend/main/main.c:197 [21:14:06.478] do_check_root = [21:14:06.495] -e [21:14:06.495] [21:14:06.495] [21:14:07.034] dumping /tmp/cores/postgres-6-28748.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [21:14:07.355] [New LWP 28748] [21:14:08.508] [Thread debugging using libthread_db enabled] [21:14:08.508] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [21:14:09.954] Core was generated by `postgres: primary: postgres regression [local] MERGE '. [21:14:09.954] Program terminated with signal SIGABRT, Aborted. [21:14:09.954] #0 0x00007f719f374ce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [21:14:10.173] [21:14:10.173] Thread 1 (Thread 0x7f719cd0ba40 (LWP 28748)): [21:14:10.173] #0 0x00007f719f374ce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [21:14:10.173] No symbol table info available. [21:14:10.173] #1 0x00007f719f35e537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [21:14:10.173] No symbol table info available. [21:14:10.173] #2 0x0000563ef98d46c2 in ExceptionalCondition (conditionName=conditionName@entry=0x563ef9b294d8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x563ef9b4ddd8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [21:14:10.173] No locals. [21:14:10.173] #3 0x0000563ef92265db in ExecFetchSlotHeapTuple (slot=slot@entry=0x7fffcbd0eb80, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7fffcbd0ea1f) at ../src/backend/executor/execTuples.c:1737 [21:14:10.173] No locals. [21:14:10.173] #4 0x0000563ef91a9fd4 in ExecIRDeleteTriggers (estate=estate@entry=0x563efc3b7900, relinfo=relinfo@entry=0x563efc3b7eb0, slot=slot@entry=0x7fffcbd0eb80) at ../src/backend/commands/trigger.c:2841 [21:14:10.173] trigger = 0x563efc3b8110 [21:14:10.173] oldtuple = [21:14:10.173] trigdesc = 0x563efc3b80c0 [21:14:10.173] newtuple = 0x0 [21:14:10.173] should_free = false [21:14:10.173] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7f719aeae5c8, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [21:14:10.173] i = 0 [21:14:10.173] #5 0x0000563ef92894ef in ExecMergeMatched (context=0x7fffcbd0eba0, resultRelInfo=resultRelInfo@entry=0x563efc3b7eb0, tupleid=0x0, oldtuple=0x7fffcbd0eb80, canSetTag=true, matched=matched@entry=0x7fffcbd0eb2f) at ../src/backend/executor/nodeModifyTable.c:3027 [21:14:10.173] relaction = 0x563efc3e5708 [21:14:10.173] commandType = CMD_DELETE [21:14:10.173] result = TM_Ok [21:14:10.173] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [21:14:10.173] l__state = {l = , i = } [21:14:10.173] mtstate = 0x563efc3b7ca0 [21:14:10.173] mergeActions = 0x563efc3b7fc0 [21:14:10.173] actionStates = 0x563efc3e5cc8 [21:14:10.173] newslot = 0x0 [21:14:10.173] rslot = 0x0 [21:14:10.173] estate = 0x563efc3b7900 [21:14:10.173] econtext = 0x563efc3e4d18 [21:14:10.173] isNull = false [21:14:10.173] epqstate = 0x563efc3b7d88 [21:14:10.173] l = [21:14:10.173] __func__ = "ExecMergeMatched" [21:14:10.173] lmerge_matched = [21:14:10.173] #6 0x0000563ef928a5d7 in ExecMerge (context=context@entry=0x7fffcbd0eba0, resultRelInfo=resultRelInfo@entry=0x563efc3b7eb0, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7fffcbd0eb80, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [21:14:10.173] rslot = 0x0 [21:14:10.173] matched = true [21:14:10.173] #7 0x0000563ef928c32e in ExecModifyTable (pstate=0x563efc3b7ca0) at ../src/backend/executor/nodeModifyTable.c:4112 [21:14:10.173] node = 0x563efc3b7ca0 [21:14:10.173] context = {mtstate = 0x563efc3b7ca0, epqstate = 0x563efc3b7d88, estate = 0x563efc3b7900, planSlot = 0x563efc3e3728, tmfd = {ctid = {ip_blkid = {bi_hi = 21880, bi_lo = 64574}, ip_posid = 22078}, xmax = 4232416184, cmax = 22078, traversed = 160}, cpUpdateReturningSlot = 0x563ef920c465 } [21:14:10.173] estate = 0x563efc3b7900 [21:14:10.173] operation = CMD_MERGE [21:14:10.173] resultRelInfo = 0x563efc3b7eb0 [21:14:10.173] subplanstate = 0x563efc3b85e0 [21:14:10.173] slot = [21:14:10.173] oldSlot = [21:14:10.173] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 1}, ip_posid = 0} [21:14:10.173] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x563efc422c78} [21:14:10.173] oldtuple = 0x7fffcbd0eb80 [21:14:10.173] tupleid = 0x0 [21:14:10.173] __func__ = "ExecModifyTable" [21:14:10.173] #8 0x0000563ef92187a6 in ExecProcNodeFirst (node=0x563efc3b7ca0) at ../src/backend/executor/execProcnode.c:464 [21:14:10.173] No locals. [21:14:10.173] #9 0x0000563ef9204ea1 in ExecProcNode (node=0x563efc3b7ca0) at ../src/include/executor/executor.h:274 [21:14:10.173] No locals. [21:14:10.173] #10 ExecutePlan (estate=estate@entry=0x563efc3b7900, planstate=0x563efc3b7ca0, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x563efc4450c0, execute_once=true) at ../src/backend/executor/execMain.c:1646 [21:14:10.173] slot = [21:14:10.173] current_tuple_count = 0 [21:14:10.173] #11 0x0000563ef92051eb in standard_ExecutorRun (queryDesc=queryDesc@entry=0x563efc449278, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [21:14:10.173] estate = 0x563efc3b7900 [21:14:10.173] operation = CMD_MERGE [21:14:10.173] dest = 0x563efc4450c0 [21:14:10.173] sendTuples = true [21:14:10.173] oldcontext = 0x563efc444db0 [21:14:10.173] __func__ = "standard_ExecutorRun" [21:14:10.173] #12 0x00007f719cb307fc in pgss_ExecutorRun (queryDesc=0x563efc449278, direction=ForwardScanDirection, count=0, execute_once=) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [21:14:10.173] _save_exception_stack = 0x7fffcbd0ef70 [21:14:10.173] _save_context_stack = 0x0 [21:14:10.173] _local_sigjmp_buf = {{__jmpbuf = {94828520313464, -1100234602652111542, 94828518679056, 94828520296640, 0, 0, -1100234602624848566, -1033716084887261878}, __mask_was_saved = 0, __saved_mask = {__val = {94828519717120, 94828520313464, 0, 94828520295856, 94828475127818, 0, 1, 0, 94828467790356, 94828520313464, 94828487593760, 94828520295856, 140125937017890, 94828520313464, 0, 94828518679056}}}} [21:14:10.173] _do_rethrow = false [21:14:10.173] #13 0x0000563ef9205349 in ExecutorRun (queryDesc=queryDesc@entry=0x563efc449278, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:302 [21:14:10.173] No locals. [21:14:10.173] #14 0x0000563ef962a5a3 in ProcessQuery (plan=plan@entry=0x563efc45bdb0, sourceText=0x563efc2ba210 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., params=0x0, queryEnv=0x0, dest=dest@entry=0x563efc4450c0, qc=qc@entry=0x7fffcbd0eed0) at ../src/backend/tcop/pquery.c:160 [21:14:10.173] queryDesc = 0x563efc449278 [21:14:10.173] #15 0x0000563ef962c2f2 in PortalRunMulti (portal=portal@entry=0x563efc33bf20, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x563efc4450c0, altdest=0x563ef9e11380 , qc=qc@entry=0x7fffcbd0eed0) at ../src/backend/tcop/pquery.c:1277 [21:14:10.173] pstmt = 0x563efc45bdb0 [21:14:10.173] stmtlist_item__state = {l = , i = } [21:14:10.173] active_snapshot_set = true [21:14:10.173] stmtlist_item = 0x563efc45bed8 [21:14:10.173] #16 0x0000563ef962c998 in FillPortalStore (portal=portal@entry=0x563efc33bf20, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [21:14:10.173] treceiver = 0x563efc4450c0 [21:14:10.173] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:14:10.173] __func__ = "FillPortalStore" [21:14:10.173] #17 0x0000563ef962cff7 in PortalRun (portal=portal@entry=0x563efc33bf20, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x563efc45bf10, altdest=altdest@entry=0x563efc45bf10, qc=0x7fffcbd0f0b0) at ../src/backend/tcop/pquery.c:763 [21:14:10.173] _save_exception_stack = 0x7fffcbd0f160 [21:14:10.173] _save_context_stack = 0x0 [21:14:10.173] _local_sigjmp_buf = {{__jmpbuf = {1, 1100208531702017354, 94828520390416, 94828519926272, 94828519210784, 94828519926200, -1100234602691957430, -6685229635224212150}, __mask_was_saved = 0, __saved_mask = {__val = {94828519222344, 94828477927134, 94828519218992, 94828477927134, 1, 140736612855871, 94828519926248, 94828519926200, 94828474859017, 94828477512649, 94828519210784, 94828477927134, 1, 1, 94828475127818, 163}}}} [21:14:10.173] _do_rethrow = [21:14:10.173] result = [21:14:10.173] nprocessed = [21:14:10.173] saveTopTransactionResourceOwner = 0x563efc2fb3f0 [21:14:10.173] saveTopTransactionContext = 0x563efc2e6800 [21:14:10.173] saveActivePortal = 0x0 [21:14:10.173] saveResourceOwner = 0x563efc2fb3f0 [21:14:10.173] savePortalContext = 0x0 [21:14:10.173] saveMemoryContext = 0x563efc2e6800 [21:14:10.173] __func__ = "PortalRun" [21:14:10.173] #18 0x0000563ef9625f80 in exec_simple_query (query_string=query_string@entry=0x563efc2ba210 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"...) at ../src/backend/tcop/postgres.c:1274 [21:14:10.173] cmdtaglen = 5 [21:14:10.173] snapshot_set = [21:14:10.173] per_parsetree_context = 0x0 [21:14:10.173] plantree_list = 0x563efc45bec0 [21:14:10.173] parsetree = 0x563efc3ea9b8 [21:14:10.173] commandTag = [21:14:10.173] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [21:14:10.173] querytree_list = [21:14:10.173] portal = 0x563efc33bf20 [21:14:10.173] receiver = 0x563efc45bf10 [21:14:10.173] format = 0 [21:14:10.173] cmdtagname = [21:14:10.173] parsetree_item__state = {l = , i = } [21:14:10.173] dest = DestRemote [21:14:10.173] oldcontext = 0x563efc2e6800 [21:14:10.173] parsetree_list = 0x563efc3ea9e8 [21:14:10.173] parsetree_item = 0x563efc3eaa00 [21:14:10.173] save_log_statement_stats = false [21:14:10.173] was_logged = true [21:14:10.173] use_implicit_block = false [21:14:10.173] msec_str = "\020\363\320\313\377\177\000\000\242ڏ\371>V\000\000@\361\320\313\377\177\000\000\026\001\000\000\000\000\000" [21:14:10.173] __func__ = "exec_simple_query" [21:14:10.173] #19 0x0000563ef9628d3e in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [21:14:10.173] query_string = 0x563efc2ba210 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"... [21:14:10.173] firstchar = [21:14:10.173] input_message = {data = 0x563efc2ba210 "MERGE INTO rw_view2 t\n USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a\n WHEN MATCHED AND t.a <= 1 THEN DELETE\n WHEN MATCHED THEN UPDATE SET b = s.b\n WHEN NOT MATCHED AN"..., len = 278, maxlen = 1024, cursor = 278} [21:14:10.173] local_sigjmp_buf = {{__jmpbuf = {94828487593752, -6685227002507301558, 4, 140736612856592, 140736612856740, 1, -1100234601957954230, -6685229632875270838}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 94828518653664, 16384, 8248, 94828475032921, 0, 0, 0, 94828487593760, 94828518653664, 94828487587832, 140736612856592, 140736612856740, 1, 94828475035971, 140736612856368}}}} [21:14:10.173] send_ready_for_query = false [21:14:10.173] idle_in_transaction_timeout_enabled = false [21:14:10.173] idle_session_timeout_enabled = false [21:14:10.173] __func__ = "PostgresMain" [21:14:10.173] #20 0x0000563ef961f4e0 in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [21:14:10.173] bsdata = [21:14:10.173] #21 0x0000563ef94c37f4 in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fffcbd0f2bc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fffcbd0f310) at ../src/backend/postmaster/launch_backend.c:265 [21:14:10.173] pid = [21:14:10.173] #22 0x0000563ef94c9b22 in BackendStartup (client_sock=client_sock@entry=0x7fffcbd0f310) at ../src/backend/postmaster/postmaster.c:3593 [21:14:10.173] bn = 0x563efc2e6978 [21:14:10.173] pid = [21:14:10.173] startup_data = {canAcceptConnections = CAC_OK} [21:14:10.173] __func__ = "BackendStartup" [21:14:10.173] #23 0x0000563ef94ca0d0 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [21:14:10.173] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "ˠq\177\000\000-\000\000\000\000\000\000\000\020\336\064\237q\177\000\000 \251\004\240q\177\000\000\310\363\320\313\377\177\000\000\304\363\320\313\377\177\000\000\204\363\320\313\377\177\000\000`D.\374>V\000\000\000\000\000\000\377\177\000\000\020\336\064\237q\177\000\000\340\377\063\237q\177\000\000\352?Q\237q\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000\304\363\320\313\377\177\000", __ss_align = 94828518851680}, salen = 2}} [21:14:10.173] i = 0 [21:14:10.173] now = [21:14:10.173] last_lockfile_recheck_time = 1713129050 [21:14:10.173] last_touch_time = 1713129050 [21:14:10.173] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = -875498432, events = 32767, fd = -875498416, user_data = 0x0}, {pos = 18, events = 0, fd = 1508362478, user_data = 0x7f71a004a788}, {pos = -1622065174, events = 32625, fd = -875498200, user_data = 0x7fffcbd0f480}, {pos = -875498352, events = 32767, fd = -1597260575, user_data = 0x12}, {pos = -1664018920, events = 32625, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = -1610308576, user_data = 0xffffffff}, {pos = -1664018920, events = 32625, fd = -1610308576, user_data = 0x1a004a920}, {pos = -1610307704, events = 32625, fd = 0, user_data = 0x7fffcbd0f59e}, {pos = -875498096, events = 32767, fd = -1, user_data = 0x7fffcbd0f4a0}, {pos = -1623981032, events = 32625, fd = -1610307296, user_data = 0x563efc2ea4c8}, {pos = -64052392, events = 22078, fd = -64070944, user_data = 0x563efc2ea4e8}, {pos = -64053231, events = 22078, fd = -1597241821, user_data = 0x1}, {pos = -1621962504, events = 32625, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x563efc2bc070}, {pos = -1597241821, events = 32625, fd = 1, user_data = 0x0}, {pos = -64070944, events = 22078, fd = -1623981032, user_data = 0x7fffcbd0f8e0}, {pos = -1597213046, events = 32625, fd = 0, user_data = 0x0}, {pos = -875497216, events = 32767, fd = -95392576, user_data = 0x2}, {pos = -95392576, events = 22078, fd = 0, user_data = 0x7f719f50abe0}, {pos = 255, events = 0, fd = 7, user_data = 0x0}, {pos = 8096, events = 196607, fd = 99, user_data = 0x10f}, {pos = 4144, events = 0, fd = 64, user_data = 0x7000000101}, {pos = 111, events = 124, fd = 1, user_data = 0x7700000063}, {pos = 8, events = 0, fd = 0, user_data = 0x100007f00000002}, {pos = 255, events = 0, fd = 4096, user_data = 0xffffffffffffff08}, {pos = 0, events = 0, fd = -64030520, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1, events = 4294967295, fd = -1, user_data = 0x735f3732305f742f}, {pos = 1634038388, events = 1701994349, fd = 1868785010, user_data = 0x7274735f3732302f}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = -1622120320, user_data = 0x7f719f3b951a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = -1623462917, user_data = 0x400}, {pos = -64258176, events = 22078, fd = -1622117248, user_data = 0x1fc2b7f80}, {pos = 784, events = 0, fd = -105541044, user_data = 0x563efc2ea030}, {pos = -2022353920, events = 4105172618, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -64053200, events = 22078, fd = -64053200, user_data = 0x563efc2ea030}, {pos = 1, events = 0, fd = -64053000, user_data = 0x400}, {pos = 0, events = 0, fd = -107809059, user_data = 0x563efa514ed0 }, {pos = -107883177, events = 22078, fd = -64053200, user_data = 0x563efc2ba110}, {pos = -64053200, events = 22078, fd = 15, user_data = 0x4a}, {pos = -107807249, events = 22078, fd = -64053200, user_data = 0x563ef992ff38 }, {pos = -64258176, events = 22078, fd = -1623462610, user_data = 0x0}, {pos = -114445566, events = 22078, fd = -64079040, user_data = 0x7f719f3bb1aa}, {pos = -875497064, events = 1, fd = 0, user_data = 0x7f719f3b98f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 26692, user_data = 0x7f719f403b05 }, {pos = 0, events = 0, fd = -2022353920, user_data = 0x0}, {pos = -112446182, events = 22078, fd = 4194304, user_data = 0x563ef991d3eb }, {pos = -64079040, events = 22078, fd = -64249584, user_data = 0x563efc2e3b40}, {pos = 1, events = 0, fd = 0, user_data = 0x563ef992fdef }, {pos = -64079040, events = 22078, fd = -107806920, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x563ef92daed5 }, {pos = 0, events = 0, fd = -114422613, user_data = 0xb}, {pos = -112424332, events = 22078, fd = 0, user_data = 0x0}} [21:14:10.173] nevents = 1 [21:14:10.173] __func__ = "ServerLoop" [21:14:10.174] #24 0x0000563ef94cbaf2 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x563efc2b3de0) at ../src/backend/postmaster/postmaster.c:1372 [21:14:10.174] opt = [21:14:10.174] status = [21:14:10.174] userDoption = [21:14:10.174] listen_addr_saved = false [21:14:10.174] output_config_variable = [21:14:10.174] __func__ = "PostmasterMain" [21:14:10.174] #25 0x0000563ef92ec538 in main (argc=4, argv=0x563efc2b3de0) at ../src/backend/main/main.c:197 [21:14:10.174] do_check_root =