[05:21:03.711] src/tools/ci/cores_backtrace.sh linux /tmp/cores [05:21:04.417] dumping /tmp/cores/sh-3-26664.core for /bin/sh [05:21:05.420] Downloading separate debug info for /bin/sh... [05:21:05.899] [New LWP 26664] [05:21:05.899] [New LWP 26661] [05:21:07.128] Downloading separate debug info for /lib64/ld-linux-x86-64.so.2... [05:21:07.600] Core was generated by `sh -c cp "/tmp/cirrus-ci-build/build/testrun/recovery/020_archive_status/data/t'. [05:21:07.600] Program terminated with signal SIGQUIT, Quit. [05:21:07.600] #0 0x00007f1b7037dfc7 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [05:21:07.616] [Current thread is 1 (LWP 26664)] [05:21:07.616] [05:21:07.616] Thread 2 (LWP 26661): [05:21:07.616] #0 0x00007f1b7040cbc8 in vfork () from /lib/x86_64-linux-gnu/libc.so.6 [05:21:07.616] No symbol table info available. [05:21:07.616] #1 0x0000563a6b8e826b in vforkexec (n=n@entry=0x563a6b8fc9a8 , argv=argv@entry=0x563a6c0fc950, path=path@entry=0x7ffea7ffc0b8 "/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/src/test/recovery:/tmp/cirrus-ci-build/build/src/test/recovery/test:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr"..., idx=6) at jobs.c:973 [05:21:07.616] jp = 0x563a6c0fcad0 [05:21:07.616] pid = [05:21:07.616] #2 0x0000563a6b8e232c in evalcommand (cmd=0x563a6b8fc9a8 , flags=0) at eval.c:905 [05:21:07.616] i = [05:21:07.616] localvar_stop = 0x0 [05:21:07.616] file_stop = 0x563a6c0fc7e0 [05:21:07.616] redir_stop = 0x0 [05:21:07.616] argp = [05:21:07.616] arglist = {list = 0x563a6b8fc9d0 , lastp = 0x563a6c0fc938} [05:21:07.616] varlist = {list = 0x0, lastp = 0x7ffea7ffa720} [05:21:07.616] argv = 0x563a6c0fc950 [05:21:07.616] argc = 3 [05:21:07.616] osp = [05:21:07.616] sp = [05:21:07.616] cmdentry = {cmdtype = 0, u = {index = 6, cmd = 0xa1a1a1a100000006, func = 0xa1a1a1a100000006}} [05:21:07.616] jp = 0x0 [05:21:07.616] lastarg = 0x0 [05:21:07.616] path = 0x7ffea7ffc0b8 "/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/src/test/recovery:/tmp/cirrus-ci-build/build/src/test/recovery/test:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr"... [05:21:07.616] spclbltin = -1 [05:21:07.616] cmd_flag = 0 [05:21:07.616] execcmd = 0 [05:21:07.616] status = [05:21:07.616] nargv = [05:21:07.616] vflags = 0 [05:21:07.616] vlocal = [05:21:07.616] #3 0x0000563a6b8e127e in evaltree (n=n@entry=0x563a6b8fc9a8 , flags=0) at eval.c:303 [05:21:07.616] checkexit = 0 [05:21:07.616] evalfn = [05:21:07.616] smark = {stackp = 0x563a6b8fc7e0 , stacknxt = 0x563a6b8fc9c8 "cp", stacknleft = 24} [05:21:07.616] isor = [05:21:07.616] status = [05:21:07.616] evaln = [05:21:07.616] #4 0x0000563a6b8e1c6a in evalstring (s=0x563a6b8fc7e8 "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\"", flags=flags@entry=0) at eval.c:185 [05:21:07.616] i = [05:21:07.616] n = 0x563a6b8fc9a8 [05:21:07.616] smark = {stackp = 0x563a6b8fc7e0 , stacknxt = 0x563a6b8fc890 "cp", stacknleft = 336} [05:21:07.616] status = 0 [05:21:07.616] #5 0x0000563a6b8df67f in main (argc=3, argv=0x7ffea7ffa998) at main.c:177 [05:21:07.616] shinit = [05:21:07.616] state = 4 [05:21:07.616] smark = {stackp = 0x563a6b8fc7e0 , stacknxt = 0x563a6b8fc7e8 "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\"", stacknleft = 504} [05:21:07.616] login = [05:21:07.616] [05:21:07.616] Thread 1 (LWP 26664): [05:21:07.616] #0 0x00007f1b7037dfc7 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6 [05:21:07.616] No symbol table info available. [05:21:07.616] #1 0x00007f1b7037e2c7 in sigsetmask () from /lib/x86_64-linux-gnu/libc.so.6 [05:21:07.616] No symbol table info available. [05:21:07.616] #2 0x0000563a6b8e82b7 in sigclearmask () at system.h:46 [05:21:07.616] No locals. [05:21:07.616] #3 vforkexec (n=n@entry=0x563a6b8fc9a8 , argv=argv@entry=0x563a6c0fc950, path=path@entry=0x7ffea7ffc0b8 "/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/src/test/recovery:/tmp/cirrus-ci-build/build/src/test/recovery/test:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr"..., idx=6) at jobs.c:977 [05:21:07.616] jp = 0x563a6c0fcad0 [05:21:07.616] pid = [05:21:07.616] #4 0x0000563a6b8e232c in evalcommand (cmd=0x563a6b8fc9a8 , flags=0) at eval.c:905 [05:21:07.616] i = [05:21:07.616] localvar_stop = 0x0 [05:21:07.616] file_stop = 0x563a6c0fc7e0 [05:21:07.616] redir_stop = 0x0 [05:21:07.616] argp = [05:21:07.616] arglist = {list = 0x563a6b8fc9d0 , lastp = 0x563a6c0fc938} [05:21:07.616] varlist = {list = 0x0, lastp = 0x7ffea7ffa720} [05:21:07.616] argv = 0x563a6c0fc950 [05:21:07.616] argc = 3 [05:21:07.616] osp = [05:21:07.616] sp = [05:21:07.616] cmdentry = {cmdtype = 0, u = {index = 6, cmd = 0xa1a1a1a100000006, func = 0xa1a1a1a100000006}} [05:21:07.616] jp = 0x0 [05:21:07.616] lastarg = 0x0 [05:21:07.616] path = 0x7ffea7ffc0b8 "/tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin:/tmp/cirrus-ci-build/build/src/test/recovery:/tmp/cirrus-ci-build/build/src/test/recovery/test:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr"... [05:21:07.616] spclbltin = -1 [05:21:07.616] cmd_flag = 0 [05:21:07.616] execcmd = 0 [05:21:07.616] status = [05:21:07.616] nargv = [05:21:07.616] vflags = 0 [05:21:07.616] vlocal = [05:21:07.616] #5 0x0000563a6b8e127e in evaltree (n=n@entry=0x563a6b8fc9a8 , flags=0) at eval.c:303 [05:21:07.616] checkexit = 0 [05:21:07.616] evalfn = [05:21:07.616] smark = {stackp = 0x563a6b8fc7e0 , stacknxt = 0x563a6b8fc9c8 "cp", stacknleft = 24} [05:21:07.616] isor = [05:21:07.616] status = [05:21:07.616] evaln = [05:21:07.616] #6 0x0000563a6b8e1c6a in evalstring (s=0x563a6b8fc7e8 "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\"", flags=flags@entry=0) at eval.c:185 [05:21:07.616] i = [05:21:07.616] n = 0x563a6b8fc9a8 [05:21:07.616] smark = {stackp = 0x563a6b8fc7e0 , stacknxt = 0x563a6b8fc890 "cp", stacknleft = 336} [05:21:07.616] status = 0 [05:21:07.616] #7 0x0000563a6b8df67f in main (argc=3, argv=0x7ffea7ffa998) at main.c:177 [05:21:07.616] shinit = [05:21:07.616] state = 4 [05:21:07.616] smark = {stackp = 0x563a6b8fc7e0 , stacknxt = 0x563a6b8fc7e8 "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\"", stacknleft = 504} [05:21:07.616] login = [05:21:07.622] -e [05:21:07.622] [05:21:07.622] [05:21:08.159] dumping /tmp/cores/postgres-6-28860.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [05:21:09.826] [New LWP 28860] [05:21:09.826] Downloading separate debug info for /lib/x86_64-linux-gnu/libm.so.6... [05:21:10.589] Downloading separate debug info for /lib/x86_64-linux-gnu/libdl.so.2... [05:21:11.357] Downloading separate debug info for /lib/x86_64-linux-gnu/librt.so.1... [05:21:12.592] Downloading separate debug info for /lib/x86_64-linux-gnu/libgssapi_krb5.so.2... [05:21:14.992] Downloading separate debug info for /lib/x86_64-linux-gnu/libicuuc.so.67... [05:21:14.992] Downloading separate debug info for /.cache/debuginfod_client/f871bbd529a02abd860f0d16b842b5b20234cb49/debuginfo... [05:21:16.878] Downloading separate debug info for /lib/x86_64-linux-gnu/libicui18n.so.67... [05:21:18.105] Downloading separate debug info for /lib/x86_64-linux-gnu/libldap_r-2.4.so.2... [05:21:19.705] Downloading separate debug info for /lib/x86_64-linux-gnu/libxml2.so.2... [05:21:20.801] Downloading separate debug info for /lib/x86_64-linux-gnu/liblz4.so.1... [05:21:21.588] Downloading separate debug info for /lib/x86_64-linux-gnu/libpam.so.0... [05:21:22.841] Downloading separate debug info for /lib/x86_64-linux-gnu/libssl.so.1.1... [05:21:24.481] Downloading separate debug info for /lib/x86_64-linux-gnu/libcrypto.so.1.1... [05:21:25.909] Downloading separate debug info for /lib/x86_64-linux-gnu/libsystemd.so.0... [05:21:26.831] Downloading separate debug info for /lib/x86_64-linux-gnu/libz.so.1... [05:21:28.391] Downloading separate debug info for /lib/x86_64-linux-gnu/libzstd.so.1... [05:21:29.806] Downloading separate debug info for /lib/x86_64-linux-gnu/libpthread.so.0... [05:21:30.276] [Thread debugging using libthread_db enabled] [05:21:30.276] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [05:21:31.682] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5.so.3... [05:21:32.754] Downloading separate debug info for /lib/x86_64-linux-gnu/libk5crypto.so.3... [05:21:33.372] Downloading separate debug info for /lib/x86_64-linux-gnu/libcom_err.so.2... [05:21:34.272] Downloading separate debug info for /lib/x86_64-linux-gnu/libkrb5support.so.0... [05:21:36.559] Downloading separate debug info for /lib/x86_64-linux-gnu/libstdc++.so.6... [05:21:37.473] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcc_s.so.1... [05:21:38.244] Downloading separate debug info for /lib/x86_64-linux-gnu/liblber-2.4.so.2... [05:21:39.175] Downloading separate debug info for /lib/x86_64-linux-gnu/libresolv.so.2... [05:21:40.110] Downloading separate debug info for /lib/x86_64-linux-gnu/libsasl2.so.2... [05:21:41.723] Downloading separate debug info for /lib/x86_64-linux-gnu/libgnutls.so.30... [05:21:42.810] Downloading separate debug info for /lib/x86_64-linux-gnu/liblzma.so.5... [05:21:43.579] Downloading separate debug info for /lib/x86_64-linux-gnu/libaudit.so.1... [05:21:44.976] Downloading separate debug info for /lib/x86_64-linux-gnu/libgcrypt.so.20... [05:21:45.601] Downloading separate debug info for /lib/x86_64-linux-gnu/libkeyutils.so.1... [05:21:47.171] Downloading separate debug info for /lib/x86_64-linux-gnu/libp11-kit.so.0... [05:21:47.948] Downloading separate debug info for /lib/x86_64-linux-gnu/libidn2.so.0... [05:21:49.177] Downloading separate debug info for /lib/x86_64-linux-gnu/libunistring.so.2... [05:21:49.949] Downloading separate debug info for /lib/x86_64-linux-gnu/libtasn1.so.6... [05:21:51.024] Downloading separate debug info for /lib/x86_64-linux-gnu/libnettle.so.8... [05:21:51.956] Downloading separate debug info for /lib/x86_64-linux-gnu/libhogweed.so.6... [05:21:53.193] Downloading separate debug info for /lib/x86_64-linux-gnu/libgmp.so.10... [05:21:53.810] Downloading separate debug info for /lib/x86_64-linux-gnu/libcap-ng.so.0... [05:21:54.730] Downloading separate debug info for /lib/x86_64-linux-gnu/libgpg-error.so.0... [05:21:55.495] Downloading separate debug info for /lib/x86_64-linux-gnu/libffi.so.7... [05:21:55.990] Core was generated by `postgres: primary: postgres regression [local] MERGE '. [05:21:55.990] Program terminated with signal SIGABRT, Aborted. [05:21:55.990] #0 0x00007f8cec91ace1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [05:21:56.235] [05:21:56.235] Thread 1 (Thread 0x7f8cea2b1a40 (LWP 28860)): [05:21:56.235] #0 0x00007f8cec91ace1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [05:21:56.235] No symbol table info available. [05:21:56.235] #1 0x00007f8cec904537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [05:21:56.235] No symbol table info available. [05:21:56.235] #2 0x0000556eee37032f in ExceptionalCondition (conditionName=conditionName@entry=0x556eee5c44d8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x556eee5e8dd8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [05:21:56.235] No locals. [05:21:56.235] #3 0x0000556eedcc24e2 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7ffdd8b8fd90, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7ffdd8b8fc2f) at ../src/backend/executor/execTuples.c:1737 [05:21:56.235] No locals. [05:21:56.235] #4 0x0000556eedc45edb in ExecIRDeleteTriggers (estate=estate@entry=0x556ef0445900, relinfo=relinfo@entry=0x556ef0445eb0, slot=slot@entry=0x7ffdd8b8fd90) at ../src/backend/commands/trigger.c:2841 [05:21:56.235] trigger = 0x556ef0446110 [05:21:56.235] oldtuple = [05:21:56.235] trigdesc = 0x556ef04460c0 [05:21:56.235] newtuple = 0x0 [05:21:56.235] should_free = false [05:21:56.235] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7f8ce8455b68, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [05:21:56.235] i = 0 [05:21:56.235] #5 0x0000556eedd253f6 in ExecMergeMatched (context=0x7ffdd8b8fdb0, resultRelInfo=resultRelInfo@entry=0x556ef0445eb0, tupleid=0x0, oldtuple=0x7ffdd8b8fd90, canSetTag=true, matched=matched@entry=0x7ffdd8b8fd3f) at ../src/backend/executor/nodeModifyTable.c:3027 [05:21:56.235] relaction = 0x556ef048b318 [05:21:56.235] commandType = CMD_DELETE [05:21:56.235] result = TM_Ok [05:21:56.235] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [05:21:56.235] l__state = {l = , i = } [05:21:56.235] mtstate = 0x556ef0445ca0 [05:21:56.235] mergeActions = 0x556ef0445fc0 [05:21:56.235] actionStates = 0x556ef048b8d8 [05:21:56.235] newslot = 0x0 [05:21:56.235] rslot = 0x0 [05:21:56.235] estate = 0x556ef0445900 [05:21:56.235] econtext = 0x556ef048a928 [05:21:56.235] isNull = false [05:21:56.235] epqstate = 0x556ef0445d88 [05:21:56.235] l = [05:21:56.235] __func__ = "ExecMergeMatched" [05:21:56.235] lmerge_matched = [05:21:56.235] #6 0x0000556eedd264de in ExecMerge (context=context@entry=0x7ffdd8b8fdb0, resultRelInfo=resultRelInfo@entry=0x556ef0445eb0, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7ffdd8b8fd90, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [05:21:56.235] rslot = 0x0 [05:21:56.235] matched = true [05:21:56.235] #7 0x0000556eedd28235 in ExecModifyTable (pstate=0x556ef0445ca0) at ../src/backend/executor/nodeModifyTable.c:4112 [05:21:56.235] node = 0x556ef0445ca0 [05:21:56.235] context = {mtstate = 0x556ef0445ca0, epqstate = 0x556ef0445d88, estate = 0x556ef0445900, planSlot = 0x556ef0489338, tmfd = {ctid = {ip_blkid = {bi_hi = 45448, bi_lo = 61512}, ip_posid = 21870}, xmax = 4031629992, cmax = 21870, traversed = 160}, cpUpdateReturningSlot = 0x556eedca836c } [05:21:56.235] estate = 0x556ef0445900 [05:21:56.235] operation = CMD_MERGE [05:21:56.235] resultRelInfo = 0x556ef0445eb0 [05:21:56.235] subplanstate = 0x556ef04465e0 [05:21:56.235] slot = [05:21:56.235] oldSlot = [05:21:56.235] tuple_ctid = {ip_blkid = {bi_hi = 0, bi_lo = 1}, ip_posid = 0} [05:21:56.235] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x556ef04aa558} [05:21:56.235] oldtuple = 0x7ffdd8b8fd90 [05:21:56.235] tupleid = 0x0 [05:21:56.235] __func__ = "ExecModifyTable" [05:21:56.235] #8 0x0000556eedcb46ad in ExecProcNodeFirst (node=0x556ef0445ca0) at ../src/backend/executor/execProcnode.c:464 [05:21:56.235] No locals. [05:21:56.235] #9 0x0000556eedca0da8 in ExecProcNode (node=0x556ef0445ca0) at ../src/include/executor/executor.h:274 [05:21:56.235] No locals. [05:21:56.235] #10 ExecutePlan (estate=estate@entry=0x556ef0445900, planstate=0x556ef0445ca0, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x556ef04cc2b0, execute_once=true) at ../src/backend/executor/execMain.c:1646 [05:21:56.235] slot = [05:21:56.235] current_tuple_count = 0 [05:21:56.235] #11 0x0000556eedca10f2 in standard_ExecutorRun (queryDesc=queryDesc@entry=0x556ef044d3f8, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [05:21:56.235] estate = 0x556ef0445900 [05:21:56.235] operation = CMD_MERGE [05:21:56.235] dest = 0x556ef04cc2b0 [05:21:56.235] sendTuples = true [05:21:56.235] oldcontext = 0x556ef04cbfa0 [05:21:56.235] __func__ = "standard_ExecutorRun" [05:21:56.235] #12 0x00007f8cea0d67fc in pgss_ExecutorRun (queryDesc=0x556ef044d3f8, direction=ForwardScanDirection, count=0, execute_once=) at ../contrib/pg_stat_statements/pg_stat_statements.c:1032 [05:21:56.235] _save_exception_stack = 0x7ffdd8b90180 [05:21:56.235] _save_context_stack = 0x0 [05:21:56.235] _local_sigjmp_buf = {{__jmpbuf = {93934965806072, -6656173487438209171, 93934964736528, 93934966325936, 0, 0, -6656173493001953427, -6682532527350784147}, __mask_was_saved = 0, __saved_mask = {__val = {93934965774592, 93934965806072, 0, 93934966325152, 93934931727479, 0, 1, 0, 93934924390683, 93934965806072, 93934944189856, 93934966325152, 140243198903330, 93934965806072, 0, 93934964736528}}}} [05:21:56.235] _do_rethrow = false [05:21:56.235] #13 0x0000556eedca1250 in ExecutorRun (queryDesc=queryDesc@entry=0x556ef044d3f8, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:302 [05:21:56.235] No locals. [05:21:56.235] #14 0x0000556eee0c6210 in ProcessQuery (plan=plan@entry=0x556ef04dfca0, sourceText=0x556ef0348210 "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=0x556ef04cc2b0, qc=qc@entry=0x7ffdd8b900e0) at ../src/backend/tcop/pquery.c:160 [05:21:56.235] queryDesc = 0x556ef044d3f8 [05:21:56.235] #15 0x0000556eee0c7f5f in PortalRunMulti (portal=portal@entry=0x556ef03c9f20, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x556ef04cc2b0, altdest=0x556eee8ac380 , qc=qc@entry=0x7ffdd8b900e0) at ../src/backend/tcop/pquery.c:1277 [05:21:56.235] pstmt = 0x556ef04dfca0 [05:21:56.235] stmtlist_item__state = {l = , i = } [05:21:56.235] active_snapshot_set = true [05:21:56.235] stmtlist_item = 0x556ef04dfdc8 [05:21:56.235] #16 0x0000556eee0c8605 in FillPortalStore (portal=portal@entry=0x556ef03c9f20, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [05:21:56.235] treceiver = 0x556ef04cc2b0 [05:21:56.235] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:21:56.235] __func__ = "FillPortalStore" [05:21:56.235] #17 0x0000556eee0c8c64 in PortalRun (portal=portal@entry=0x556ef03c9f20, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x556ef04dfe00, altdest=altdest@entry=0x556ef04dfe00, qc=0x7ffdd8b902c0) at ../src/backend/tcop/pquery.c:763 [05:21:56.235] _save_exception_stack = 0x7ffdd8b90370 [05:21:56.235] _save_context_stack = 0x0 [05:21:56.235] _local_sigjmp_buf = {{__jmpbuf = {1, 6654970086087941997, 93934966406656, 93934966820208, 93934965268256, 93934966820136, -6656173487431917715, -682603130746216595}, __mask_was_saved = 0, __saved_mask = {__val = {93934965279816, 93934934523614, 93934965276464, 93934934523614, 1, 140728239456847, 93934966820184, 93934966820136, 93934931458678, 93934934109129, 93934965268256, 93934934523614, 1, 1, 93934931727479, 163}}}} [05:21:56.235] _do_rethrow = [05:21:56.235] result = [05:21:56.235] nprocessed = [05:21:56.235] saveTopTransactionResourceOwner = 0x556ef03893f0 [05:21:56.235] saveTopTransactionContext = 0x556ef0374800 [05:21:56.235] saveActivePortal = 0x0 [05:21:56.235] saveResourceOwner = 0x556ef03893f0 [05:21:56.235] savePortalContext = 0x0 [05:21:56.235] saveMemoryContext = 0x556ef0374800 [05:21:56.235] __func__ = "PortalRun" [05:21:56.235] #18 0x0000556eee0c1bed in exec_simple_query (query_string=query_string@entry=0x556ef0348210 "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 [05:21:56.235] cmdtaglen = 5 [05:21:56.235] snapshot_set = [05:21:56.235] per_parsetree_context = 0x0 [05:21:56.235] plantree_list = 0x556ef04dfdb0 [05:21:56.235] parsetree = 0x556ef0544d28 [05:21:56.235] commandTag = [05:21:56.235] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:21:56.235] querytree_list = [05:21:56.235] portal = 0x556ef03c9f20 [05:21:56.235] receiver = 0x556ef04dfe00 [05:21:56.235] format = 0 [05:21:56.235] cmdtagname = [05:21:56.235] parsetree_item__state = {l = , i = } [05:21:56.235] dest = DestRemote [05:21:56.235] oldcontext = 0x556ef0374800 [05:21:56.235] parsetree_list = 0x556ef0544d58 [05:21:56.235] parsetree_item = 0x556ef0544d70 [05:21:56.235] save_log_statement_stats = false [05:21:56.235] was_logged = true [05:21:56.235] use_implicit_block = false [05:21:56.235] msec_str = " \005\271\330\375\177\000\000\017\227\071\356nU\000\000P\003\271\330\375\177\000\000\026\001\000\000\000\000\000" [05:21:56.235] __func__ = "exec_simple_query" [05:21:56.235] #19 0x0000556eee0c49ab in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [05:21:56.235] query_string = 0x556ef0348210 "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"... [05:21:56.235] firstchar = [05:21:56.235] input_message = {data = 0x556ef0348210 "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} [05:21:56.235] local_sigjmp_buf = {{__jmpbuf = {93934944189848, -682601019063967891, 4, 140728239457568, 140728239457716, 1, -6656173487494832275, -682603137524605075}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 93934964711136, 16384, 8248, 93934931632582, 0, 0, 0, 93934944189856, 93934964711136, 93934944183928, 140728239457568, 140728239457716, 1, 93934931635632, 140728239457344}}}} [05:21:56.235] send_ready_for_query = false [05:21:56.235] idle_in_transaction_timeout_enabled = false [05:21:56.235] idle_session_timeout_enabled = false [05:21:56.235] __func__ = "PostgresMain" [05:21:56.235] #20 0x0000556eee0bb14d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [05:21:56.235] bsdata = [05:21:56.235] #21 0x0000556eedf5f6fb in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffdd8b904cc "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffdd8b90520) at ../src/backend/postmaster/launch_backend.c:265 [05:21:56.235] pid = [05:21:56.235] #22 0x0000556eedf65a29 in BackendStartup (client_sock=client_sock@entry=0x7ffdd8b90520) at ../src/backend/postmaster/postmaster.c:3593 [05:21:56.235] bn = 0x556ef0374ba8 [05:21:56.235] pid = [05:21:56.235] startup_data = {canAcceptConnections = CAC_OK} [05:21:56.235] __func__ = "BackendStartup" [05:21:56.235] #23 0x0000556eedf65fd7 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [05:21:56.235] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "\217\354\214\177\000\000 \t_\355\214\177\000\000\310\005\271\330\375\177\000\000\304\005\271\330\375\177\000\000\000\000\000\000\375\177\000\000`$7\360nU\000\000\000\000\000\000\375\177\000\000\020>\217\354\214\177\000\000\340_\216\354\214\177\000\000\352\237\253\354\214\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000\304\005\271\330\375\177\000\000`$7\360nU\000\000\220\006\271\330\375\177\000", __ss_align = 140243242808096}, salen = 2}} [05:21:56.235] i = 0 [05:21:56.235] now = [05:21:56.235] last_lockfile_recheck_time = 1712985520 [05:21:56.235] last_touch_time = 1712985520 [05:21:56.235] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 0, events = 0, fd = 18, user_data = 0x59e7c8ee}, {pos = -312539256, events = 32652, fd = -324296726, user_data = 0x7ffdd8b90728}, {pos = -658962816, events = 32765, fd = -658962800, user_data = 0x7f8cee261ce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = -366250472, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7f8ced5f0420}, {pos = -1, events = 0, fd = -366250472, user_data = 0x7f8ced5f0420}, {pos = -312538848, events = 1, fd = -312539256, user_data = 0x0}, {pos = -658962816, events = 32765, fd = 1024, user_data = 0xffffffff}, {pos = -658962528, events = 32765, fd = -326212584, user_data = 0x7f8ced5f0920}, {pos = -264796984, events = 21870, fd = -264797352, user_data = 0x556ef0373ae0}, {pos = -264796952, events = 21870, fd = -264798191, user_data = 0x7f8cee266623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = -324194056, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1}, {pos = -264986512, events = 21870, fd = -299473373, user_data = 0x1}, {pos = 0, events = 0, fd = -264815904, user_data = 0x7f8cec8e6418}, {pos = -658961680, events = 32765, fd = -299444598, user_data = 0x0}, {pos = 0, events = 0, fd = -658961648, user_data = 0x556eeefa1b40 }, {pos = 2, events = 0, fd = -285598912, user_data = 0x0}, {pos = -325685684, events = 32652, fd = -264775536, user_data = 0x7f8cecab0be0}, {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 = 0, events = 0, fd = 0, user_data = 0xa49}, {pos = 0, events = 0, fd = -65536, user_data = 0xffffffffffffffff}, {pos = 811562031, events = 1935619890, fd = 1634038388, user_data = 0x797265766f636572}, {pos = 926036015, events = 1920234335, 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 = 0, user_data = 0x556ef0345f80}, {pos = -265003136, events = 21870, fd = -324351872, user_data = 0x7f8cec95f51a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = -325694469, user_data = 0x400}, {pos = -265003136, events = 21870, fd = -324348800, user_data = 0x1f0345f80}, {pos = 784, events = 0, fd = -295746996, 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 = 0x556eee3b8f1d }, {pos = -264798160, events = 21870, fd = -264798160, user_data = 0x556ef0378030}, {pos = 1, events = 0, fd = -264797960, user_data = 0x400}, {pos = 0, events = 0, fd = -298011830, user_data = 0x556eeefafd50 }, {pos = -298085948, events = 21870, fd = -264798160, user_data = 0x556ef0348110}, {pos = -264798160, events = 21870, fd = 15, user_data = 0x4a}, {pos = -298010020, events = 21870, fd = -264798160, user_data = 0x556eee3cbba5 }, {pos = -265003136, events = 21870, fd = -325694162, user_data = 0x0}, {pos = -304647671, events = 21870, fd = -264824000, user_data = 0x7f8cec9611aa}, {pos = -658961496, events = 1, fd = 0, user_data = 0x7f8cec95f8f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 26824, user_data = 0x7f8cec9a9b05 }, {pos = 0, events = 0, fd = -748088576, user_data = 0x0}, {pos = -302648287, events = 21870, fd = 4194304, user_data = 0x556eee3b9058 }, {pos = -264824000, events = 21870, fd = -264994544, user_data = 0x556ef0371b40}, {pos = 1, events = 0, fd = 0, user_data = 0x556eee3cba5c }, {pos = -264824000, events = 21870, fd = -298009691, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x556eedd76ddc }, {pos = 0, events = 0, fd = -304624718, user_data = 0xb}, {pos = -302626437, events = 21870, fd = 0, user_data = 0x0}} [05:21:56.236] nevents = 1 [05:21:56.236] __func__ = "ServerLoop" [05:21:56.236] #24 0x0000556eedf679f9 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x556ef0341de0) at ../src/backend/postmaster/postmaster.c:1372 [05:21:56.236] opt = [05:21:56.236] status = [05:21:56.236] userDoption = [05:21:56.236] listen_addr_saved = false [05:21:56.236] output_config_variable = [05:21:56.236] __func__ = "PostmasterMain" [05:21:56.236] #25 0x0000556eedd8843f in main (argc=4, argv=0x556ef0341de0) at ../src/backend/main/main.c:197 [05:21:56.236] do_check_root = [05:21:56.256] -e [05:21:56.256] [05:21:56.256] [05:21:56.798] dumping /tmp/cores/postgres-6-21896.core for /tmp/cirrus-ci-build/build/tmp_install//usr/local/pgsql/bin/postgres [05:21:57.111] [New LWP 21896] [05:21:58.255] [Thread debugging using libthread_db enabled] [05:21:58.255] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [05:21:59.692] Core was generated by `postgres: postgres regression [local] MERGE '. [05:21:59.692] Program terminated with signal SIGABRT, Aborted. [05:21:59.692] #0 0x00007fed9846ece1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [05:21:59.891] [05:21:59.891] Thread 1 (Thread 0x7fed95e05a40 (LWP 21896)): [05:21:59.891] #0 0x00007fed9846ece1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [05:21:59.891] No symbol table info available. [05:21:59.891] #1 0x00007fed98458537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [05:21:59.891] No symbol table info available. [05:21:59.891] #2 0x000056161b0ab32f in ExceptionalCondition (conditionName=conditionName@entry=0x56161b2ff4d8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x56161b323dd8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [05:21:59.891] No locals. [05:21:59.891] #3 0x000056161a9fd4e2 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7ffc6e5cffe0, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7ffc6e5cfe7f) at ../src/backend/executor/execTuples.c:1737 [05:21:59.891] No locals. [05:21:59.891] #4 0x000056161a980edb in ExecIRDeleteTriggers (estate=estate@entry=0x56161dd46180, relinfo=relinfo@entry=0x56161dd46730, slot=slot@entry=0x7ffc6e5cffe0) at ../src/backend/commands/trigger.c:2841 [05:21:59.891] trigger = 0x56161dd46990 [05:21:59.891] oldtuple = [05:21:59.891] trigdesc = 0x56161dd46940 [05:21:59.891] newtuple = 0x0 [05:21:59.891] should_free = false [05:21:59.891] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7fed8cb25608, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [05:21:59.891] i = 0 [05:21:59.891] #5 0x000056161aa603f6 in ExecMergeMatched (context=0x7ffc6e5d0000, resultRelInfo=resultRelInfo@entry=0x56161dd46730, tupleid=0x0, oldtuple=0x7ffc6e5cffe0, canSetTag=true, matched=matched@entry=0x7ffc6e5cff8f) at ../src/backend/executor/nodeModifyTable.c:3027 [05:21:59.891] relaction = 0x56161de37968 [05:21:59.891] commandType = CMD_DELETE [05:21:59.891] result = TM_Ok [05:21:59.891] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [05:21:59.891] l__state = {l = , i = } [05:21:59.891] mtstate = 0x56161dd46520 [05:21:59.891] mergeActions = 0x56161dd46840 [05:21:59.891] actionStates = 0x56161de37f28 [05:21:59.891] newslot = 0x0 [05:21:59.891] rslot = 0x0 [05:21:59.891] estate = 0x56161dd46180 [05:21:59.891] econtext = 0x56161de36f78 [05:21:59.891] isNull = false [05:21:59.891] epqstate = 0x56161dd46608 [05:21:59.891] l = [05:21:59.891] __func__ = "ExecMergeMatched" [05:21:59.891] lmerge_matched = [05:21:59.891] #6 0x000056161aa614de in ExecMerge (context=context@entry=0x7ffc6e5d0000, resultRelInfo=resultRelInfo@entry=0x56161dd46730, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7ffc6e5cffe0, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [05:21:59.891] rslot = 0x0 [05:21:59.891] matched = true [05:21:59.891] #7 0x000056161aa63235 in ExecModifyTable (pstate=0x56161dd46520) at ../src/backend/executor/nodeModifyTable.c:4112 [05:21:59.891] node = 0x56161dd46520 [05:21:59.891] context = {mtstate = 0x56161dd46520, epqstate = 0x56161dd46608, estate = 0x56161dd46180, planSlot = 0x56161de35988, tmfd = {ctid = {ip_blkid = {bi_hi = 1, bi_lo = 0}, ip_posid = 0}, xmax = 446537913, cmax = 22038, traversed = 168}, cpUpdateReturningSlot = 0x56161de41510} [05:21:59.891] estate = 0x56161dd46180 [05:21:59.891] operation = CMD_MERGE [05:21:59.891] resultRelInfo = 0x56161dd46730 [05:21:59.891] subplanstate = 0x56161dd46e60 [05:21:59.891] slot = [05:21:59.891] oldSlot = [05:21:59.891] tuple_ctid = {ip_blkid = {bi_hi = 7652, bi_lo = 22038}, ip_posid = 0} [05:21:59.891] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x56161ddaede8} [05:21:59.891] oldtuple = 0x7ffc6e5cffe0 [05:21:59.891] tupleid = 0x0 [05:21:59.891] __func__ = "ExecModifyTable" [05:21:59.891] #8 0x000056161a9ef6ad in ExecProcNodeFirst (node=0x56161dd46520) at ../src/backend/executor/execProcnode.c:464 [05:21:59.891] No locals. [05:21:59.891] #9 0x000056161a9dbda8 in ExecProcNode (node=0x56161dd46520) at ../src/include/executor/executor.h:274 [05:21:59.891] No locals. [05:21:59.891] #10 ExecutePlan (estate=estate@entry=0x56161dd46180, planstate=0x56161dd46520, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x56161ddd1a50, execute_once=true) at ../src/backend/executor/execMain.c:1646 [05:21:59.891] slot = [05:21:59.891] current_tuple_count = 0 [05:21:59.891] #11 0x000056161a9dc0f2 in standard_ExecutorRun (queryDesc=0x56161de61b48, direction=ForwardScanDirection, count=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [05:21:59.891] estate = 0x56161dd46180 [05:21:59.891] operation = CMD_MERGE [05:21:59.891] dest = 0x56161ddd1a50 [05:21:59.891] sendTuples = true [05:21:59.891] oldcontext = 0x56161ddd1740 [05:21:59.891] __func__ = "standard_ExecutorRun" [05:21:59.891] #12 0x000056161a9dc25d in ExecutorRun (queryDesc=queryDesc@entry=0x56161de61b48, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:304 [05:21:59.891] No locals. [05:21:59.891] #13 0x000056161ae01210 in ProcessQuery (plan=plan@entry=0x56161de44418, sourceText=0x56161dc431e0 "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=0x56161ddd1a50, qc=qc@entry=0x7ffc6e5d0220) at ../src/backend/tcop/pquery.c:160 [05:21:59.891] queryDesc = 0x56161de61b48 [05:21:59.891] #14 0x000056161ae02f5f in PortalRunMulti (portal=portal@entry=0x56161dcc3f10, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x56161ddd1a50, altdest=0x56161b5e7380 , qc=qc@entry=0x7ffc6e5d0220) at ../src/backend/tcop/pquery.c:1277 [05:21:59.891] pstmt = 0x56161de44418 [05:21:59.891] stmtlist_item__state = {l = , i = } [05:21:59.891] active_snapshot_set = true [05:21:59.891] stmtlist_item = 0x56161de44540 [05:21:59.891] #15 0x000056161ae03605 in FillPortalStore (portal=portal@entry=0x56161dcc3f10, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [05:21:59.891] treceiver = 0x56161ddd1a50 [05:21:59.891] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:21:59.891] __func__ = "FillPortalStore" [05:21:59.891] #16 0x000056161ae03c64 in PortalRun (portal=portal@entry=0x56161dcc3f10, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x56161de44578, altdest=altdest@entry=0x56161de44578, qc=0x7ffc6e5d0400) at ../src/backend/tcop/pquery.c:763 [05:21:59.891] _save_exception_stack = 0x7ffc6e5d04b0 [05:21:59.891] _save_context_stack = 0x0 [05:21:59.891] _local_sigjmp_buf = {{__jmpbuf = {1, -697700077074891810, 94652990768504, 94652989913088, 94652989194000, 94652989913016, 696256684473990110, 6520491777712077790}, __mask_was_saved = 0, __saved_mask = {__val = {94652989205560, 94652946132702, 94652989202208, 94652946132702, 1, 140722160075663, 94652989913064, 94652989913016, 94652943067766, 94652945718217, 94652989194000, 94652946132702, 1, 1, 94652943336567, 163}}}} [05:21:59.891] _do_rethrow = [05:21:59.891] result = [05:21:59.891] nprocessed = [05:21:59.891] saveTopTransactionResourceOwner = 0x56161dc82bd8 [05:21:59.891] saveTopTransactionContext = 0x56161dc6baf0 [05:21:59.891] saveActivePortal = 0x0 [05:21:59.891] saveResourceOwner = 0x56161dc82bd8 [05:21:59.891] savePortalContext = 0x0 [05:21:59.891] saveMemoryContext = 0x56161dc6baf0 [05:21:59.891] __func__ = "PortalRun" [05:21:59.891] #17 0x000056161adfcbed in exec_simple_query (query_string=query_string@entry=0x56161dc431e0 "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 [05:21:59.891] cmdtaglen = 5 [05:21:59.891] snapshot_set = [05:21:59.891] per_parsetree_context = 0x0 [05:21:59.891] plantree_list = 0x56161de44528 [05:21:59.891] parsetree = 0x56161dd737b8 [05:21:59.891] commandTag = [05:21:59.891] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:21:59.891] querytree_list = [05:21:59.891] portal = 0x56161dcc3f10 [05:21:59.891] receiver = 0x56161de44578 [05:21:59.891] format = 0 [05:21:59.891] cmdtagname = [05:21:59.891] parsetree_item__state = {l = , i = } [05:21:59.891] dest = DestRemote [05:21:59.891] oldcontext = 0x56161dc6baf0 [05:21:59.891] parsetree_list = 0x56161dd737e8 [05:21:59.891] parsetree_item = 0x56161dd73800 [05:21:59.891] save_log_statement_stats = false [05:21:59.891] was_logged = false [05:21:59.891] use_implicit_block = false [05:21:59.891] msec_str = "`\006]n\374\177\000\000\017G\r\033\026V\000\000\220\004]n\374\177\000\000\026\001\000\000\000\000\000" [05:21:59.891] __func__ = "exec_simple_query" [05:21:59.891] #18 0x000056161adff9ab in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [05:21:59.891] query_string = 0x56161dc431e0 "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"... [05:21:59.891] firstchar = [05:21:59.891] input_message = {data = 0x56161dc431e0 "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} [05:21:59.891] local_sigjmp_buf = {{__jmpbuf = {94652955798936, 6520494161788943326, 4, 140722160076384, 140722160076532, 1, 696256684276857822, 6520491831735106526}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 15624, 0, 1, 140658439077348, 94652988640912, 15616, 15680, 94652943239963, 94652955798944, 94652988640912, 94652955793016, 140722160076384, 140722160076532, 94652943244031, 140722160076160}}}} [05:21:59.891] send_ready_for_query = false [05:21:59.891] idle_in_transaction_timeout_enabled = false [05:21:59.891] idle_session_timeout_enabled = false [05:21:59.891] __func__ = "PostgresMain" [05:21:59.891] #19 0x000056161adf614d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [05:21:59.891] bsdata = [05:21:59.891] #20 0x000056161ac9a6fb in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7ffc6e5d060c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7ffc6e5d0660) at ../src/backend/postmaster/launch_backend.c:265 [05:21:59.891] pid = [05:21:59.891] #21 0x000056161aca0a29 in BackendStartup (client_sock=client_sock@entry=0x7ffc6e5d0660) at ../src/backend/postmaster/postmaster.c:3593 [05:21:59.891] bn = 0x56161dc6bf38 [05:21:59.891] pid = [05:21:59.891] startup_data = {canAcceptConnections = CAC_OK} [05:21:59.891] __func__ = "BackendStartup" [05:21:59.891] #22 0x000056161aca0fd7 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [05:21:59.891] s = {sock = 9, raddr = {addr = {ss_family = 1, __ss_padding = "D\230\355\177\000\000 I\024\231\355\177\000\000\b\a]n\374\177\000\000\004\a]n\374\177\000\000\000\000\000\000\374\177\000\000@\356\343\225\355\177\000\000\000\000\000\000\374\177\000\000\020~D\230\355\177\000\000\340\237C\230\355\177\000\000\352\337`\230\355\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000\004\a]n\374\177\000\000@\356\343\225\355\177\000\000\320\a]n\374\177\000", __ss_align = 140658440450848}, salen = 2}} [05:21:59.891] i = 0 [05:21:59.891] now = [05:21:59.891] last_lockfile_recheck_time = 1712985497 [05:21:59.891] last_touch_time = 1712985497 [05:21:59.891] events = {{pos = 1, events = 2, fd = 7, user_data = 0x0}, {pos = 0, events = 0, fd = 18, user_data = 0x59e7c8ee}, {pos = -1726724216, events = 32749, fd = -1738481686, user_data = 0x7ffc6e5d0868}, {pos = 1851590592, events = 32764, fd = 1851590608, user_data = 0x7fed99db5ce1 <_dl_lookup_symbol_x+289>}, {pos = 18, events = 0, fd = -1780435432, user_data = 0x1}, {pos = 0, events = 0, fd = 1, user_data = 0x7fed99144420}, {pos = -1, events = 0, fd = -1780435432, user_data = 0x7fed99144420}, {pos = -1726723808, events = 1, fd = -1726724216, user_data = 0x0}, {pos = 1851590592, events = 32764, fd = 1024, user_data = 0xffffffff}, {pos = 1851590880, events = 32764, fd = -1740397544, user_data = 0x7fed99144920}, {pos = 499583880, events = 22038, fd = 499574408, user_data = 0x56161dc68970}, {pos = 499583912, events = 22038, fd = 499583713, user_data = 0x7fed99dba623 <_dl_fixup+211>}, {pos = 1, events = 0, fd = -1738379016, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x1}, {pos = 499404720, events = 22038, fd = -1713658333, user_data = 0x1}, {pos = 0, events = 0, fd = 499550576, user_data = 0x7fed9843a418}, {pos = 1851591728, events = 32764, fd = -1713629558, user_data = 0x0}, {pos = 0, events = 0, fd = 1851591760, user_data = 0x56161bcdcb40 }, {pos = 2, events = 0, fd = 466471744, user_data = 0x0}, {pos = -1739870810, events = 32749, fd = 499608400, user_data = 0x7fed98604be0}, {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 = 1365459757, user_data = 0x765163432d737365}, {pos = 168452932, events = 908075040, fd = 822763892, user_data = 0x30340a3739343538}, {pos = 795768178, events = 1919378802, fd = 796095333, user_data = 0x69632f706d742f0a}, {pos = 1937076850, events = 761881389, fd = 538976266, user_data = 0x2020202020203236}, {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 = 0x56161dc40f30}, {pos = 499388208, events = 22038, fd = -1738536832, user_data = 0x7fed984b351a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = -1739879429, user_data = 0x400}, {pos = 499388208, events = 22038, fd = -1738533760, user_data = 0x11dc40f30}, {pos = 784, events = 0, fd = 456323660, 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 = 0x56161b0f3f1d }, {pos = 499573600, events = 22038, fd = 499573600, user_data = 0x56161dc6e360}, {pos = 1, events = 0, fd = 499573800, user_data = 0x400}, {pos = 0, events = 0, fd = 454058826, user_data = 0x56161bcead50 }, {pos = 453984708, events = 22038, fd = 499573600, user_data = 0x56161dc430e0}, {pos = 499573600, events = 22038, fd = 15, user_data = 0x4a}, {pos = 454060636, events = 22038, fd = 499573600, user_data = 0x56161b106ba5 }, {pos = 499388208, events = 22038, fd = -1739879429, user_data = 0x0}, {pos = 447422985, events = 22038, fd = 499562208, user_data = 0x7fed984b51aa}, {pos = 1851591912, events = 1, fd = 0, user_data = 0x7fed984b38f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 19573, user_data = 0x7fed984fdb05 }, {pos = 0, events = 0, fd = 215222272, user_data = 0x0}, {pos = 449422369, events = 22038, fd = 4194304, user_data = 0x56161b0f4058 }, {pos = 499562208, events = 22038, fd = 499396832, user_data = 0x56161dc6b6e0}, {pos = 1, events = 0, fd = 0, user_data = 0x56161b106a5c }, {pos = 499562208, events = 22038, fd = 454060965, user_data = 0x0}, {pos = 8, events = 0, fd = 0, user_data = 0x56161aab1ddc }, {pos = 0, events = 0, fd = 447445938, user_data = 0xb}, {pos = 449444219, events = 22038, fd = 0, user_data = 0x0}} [05:21:59.892] nevents = 1 [05:21:59.892] __func__ = "ServerLoop" [05:21:59.892] #23 0x000056161aca29f9 in PostmasterMain (argc=argc@entry=8, argv=argv@entry=0x56161dc3cdf0) at ../src/backend/postmaster/postmaster.c:1372 [05:21:59.892] opt = [05:21:59.892] status = [05:21:59.892] userDoption = [05:21:59.892] listen_addr_saved = false [05:21:59.892] output_config_variable = [05:21:59.892] __func__ = "PostmasterMain" [05:21:59.892] #24 0x000056161aac343f in main (argc=8, argv=0x56161dc3cdf0) at ../src/backend/main/main.c:197 [05:21:59.892] do_check_root = [05:21:59.911] -e [05:21:59.911] [05:21:59.911] [05:22:00.459] dumping /tmp/cores/postgres-6-23105.core for /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin/postgres [05:22:00.775] [New LWP 23105] [05:22:01.922] [Thread debugging using libthread_db enabled] [05:22:01.922] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [05:22:03.343] Core was generated by `postgres: old_node: postgres regression [local] MERGE '. [05:22:03.343] Program terminated with signal SIGABRT, Aborted. [05:22:03.343] #0 0x00007fae2d90cce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [05:22:03.546] [05:22:03.546] Thread 1 (Thread 0x7fae2b2a3a40 (LWP 23105)): [05:22:03.546] #0 0x00007fae2d90cce1 in raise () from /lib/x86_64-linux-gnu/libc.so.6 [05:22:03.546] No symbol table info available. [05:22:03.546] #1 0x00007fae2d8f6537 in abort () from /lib/x86_64-linux-gnu/libc.so.6 [05:22:03.546] No symbol table info available. [05:22:03.546] #2 0x000055c9beb1c32f in ExceptionalCondition (conditionName=conditionName@entry=0x55c9bed704d8 "!TTS_EMPTY(slot)", fileName=fileName@entry=0x55c9bed94dd8 "../src/backend/executor/execTuples.c", lineNumber=lineNumber@entry=1737) at ../src/backend/utils/error/assert.c:66 [05:22:03.546] No locals. [05:22:03.546] #3 0x000055c9be46e4e2 in ExecFetchSlotHeapTuple (slot=slot@entry=0x7fff06d4c350, materialize=materialize@entry=true, shouldFree=shouldFree@entry=0x7fff06d4c1ef) at ../src/backend/executor/execTuples.c:1737 [05:22:03.546] No locals. [05:22:03.546] #4 0x000055c9be3f1edb in ExecIRDeleteTriggers (estate=estate@entry=0x55c9c02988a0, relinfo=relinfo@entry=0x55c9c0298e50, slot=slot@entry=0x7fff06d4c350) at ../src/backend/commands/trigger.c:2841 [05:22:03.546] trigger = 0x55c9c02990b0 [05:22:03.546] oldtuple = [05:22:03.546] trigdesc = 0x55c9c0299060 [05:22:03.546] newtuple = 0x0 [05:22:03.546] should_free = false [05:22:03.546] LocTriggerData = {type = T_TriggerData, tg_event = 21, tg_relation = 0x7fae222d8140, tg_trigtuple = 0x0, tg_newtuple = 0x0, tg_trigger = 0x0, tg_trigslot = 0x0, tg_newslot = 0x0, tg_oldtable = 0x0, tg_newtable = 0x0, tg_updatedcols = 0x0} [05:22:03.546] i = 0 [05:22:03.546] #5 0x000055c9be4d13f6 in ExecMergeMatched (context=0x7fff06d4c370, resultRelInfo=resultRelInfo@entry=0x55c9c0298e50, tupleid=0x0, oldtuple=0x7fff06d4c350, canSetTag=true, matched=matched@entry=0x7fff06d4c2ff) at ../src/backend/executor/nodeModifyTable.c:3027 [05:22:03.546] relaction = 0x55c9c0332798 [05:22:03.546] commandType = CMD_DELETE [05:22:03.546] result = TM_Ok [05:22:03.546] updateCxt = {crossPartUpdate = false, updateIndexes = TU_None, lockmode = LockTupleKeyShare} [05:22:03.546] l__state = {l = , i = } [05:22:03.546] mtstate = 0x55c9c0298c40 [05:22:03.546] mergeActions = 0x55c9c0298f60 [05:22:03.546] actionStates = 0x55c9c0332d58 [05:22:03.546] newslot = 0x0 [05:22:03.546] rslot = 0x0 [05:22:03.546] estate = 0x55c9c02988a0 [05:22:03.546] econtext = 0x55c9c0331da8 [05:22:03.546] isNull = false [05:22:03.546] epqstate = 0x55c9c0298d28 [05:22:03.546] l = [05:22:03.546] __func__ = "ExecMergeMatched" [05:22:03.546] lmerge_matched = [05:22:03.546] #6 0x000055c9be4d24de in ExecMerge (context=context@entry=0x7fff06d4c370, resultRelInfo=resultRelInfo@entry=0x55c9c0298e50, tupleid=tupleid@entry=0x0, oldtuple=oldtuple@entry=0x7fff06d4c350, canSetTag=) at ../src/backend/executor/nodeModifyTable.c:2791 [05:22:03.546] rslot = 0x0 [05:22:03.546] matched = true [05:22:03.546] #7 0x000055c9be4d4235 in ExecModifyTable (pstate=0x55c9c0298c40) at ../src/backend/executor/nodeModifyTable.c:4112 [05:22:03.546] node = 0x55c9c0298c40 [05:22:03.546] context = {mtstate = 0x55c9c0298c40, epqstate = 0x55c9c0298d28, estate = 0x55c9c02988a0, planSlot = 0x55c9c03307b8, tmfd = {ctid = {ip_blkid = {bi_hi = 1, bi_lo = 0}, ip_posid = 0}, xmax = 3192172729, cmax = 21961, traversed = 200}, cpUpdateReturningSlot = 0x55c9c0354730} [05:22:03.546] estate = 0x55c9c02988a0 [05:22:03.546] operation = CMD_MERGE [05:22:03.546] resultRelInfo = 0x55c9c0298e50 [05:22:03.546] subplanstate = 0x55c9c0299580 [05:22:03.546] slot = [05:22:03.546] oldSlot = [05:22:03.546] tuple_ctid = {ip_blkid = {bi_hi = 49205, bi_lo = 21961}, ip_posid = 0} [05:22:03.546] oldtupdata = {t_len = 34, t_self = {ip_blkid = {bi_hi = 65535, bi_lo = 65535}, ip_posid = 0}, t_tableOid = 0, t_data = 0x55c9c02fa9e8} [05:22:03.546] oldtuple = 0x7fff06d4c350 [05:22:03.546] tupleid = 0x0 [05:22:03.546] __func__ = "ExecModifyTable" [05:22:03.546] #8 0x000055c9be4606ad in ExecProcNodeFirst (node=0x55c9c0298c40) at ../src/backend/executor/execProcnode.c:464 [05:22:03.546] No locals. [05:22:03.546] #9 0x000055c9be44cda8 in ExecProcNode (node=0x55c9c0298c40) at ../src/include/executor/executor.h:274 [05:22:03.546] No locals. [05:22:03.546] #10 ExecutePlan (estate=estate@entry=0x55c9c02988a0, planstate=0x55c9c0298c40, use_parallel_mode=, operation=operation@entry=CMD_MERGE, sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0, direction=ForwardScanDirection, dest=0x55c9c031c740, execute_once=true) at ../src/backend/executor/execMain.c:1646 [05:22:03.546] slot = [05:22:03.546] current_tuple_count = 0 [05:22:03.546] #11 0x000055c9be44d0f2 in standard_ExecutorRun (queryDesc=0x55c9c034c938, direction=ForwardScanDirection, count=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:363 [05:22:03.546] estate = 0x55c9c02988a0 [05:22:03.546] operation = CMD_MERGE [05:22:03.546] dest = 0x55c9c031c740 [05:22:03.546] sendTuples = true [05:22:03.546] oldcontext = 0x55c9c031c430 [05:22:03.546] __func__ = "standard_ExecutorRun" [05:22:03.546] #12 0x000055c9be44d25d in ExecutorRun (queryDesc=queryDesc@entry=0x55c9c034c938, direction=direction@entry=ForwardScanDirection, count=count@entry=0, execute_once=execute_once@entry=true) at ../src/backend/executor/execMain.c:304 [05:22:03.546] No locals. [05:22:03.546] #13 0x000055c9be872210 in ProcessQuery (plan=plan@entry=0x55c9c0357638, sourceText=0x55c9c01951d0 "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=0x55c9c031c740, qc=qc@entry=0x7fff06d4c590) at ../src/backend/tcop/pquery.c:160 [05:22:03.546] queryDesc = 0x55c9c034c938 [05:22:03.546] #14 0x000055c9be873f5f in PortalRunMulti (portal=portal@entry=0x55c9c0218ed0, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=true, dest=dest@entry=0x55c9c031c740, altdest=0x55c9bf058380 , qc=qc@entry=0x7fff06d4c590) at ../src/backend/tcop/pquery.c:1277 [05:22:03.546] pstmt = 0x55c9c0357638 [05:22:03.546] stmtlist_item__state = {l = , i = } [05:22:03.546] active_snapshot_set = true [05:22:03.546] stmtlist_item = 0x55c9c0357760 [05:22:03.546] #15 0x000055c9be874605 in FillPortalStore (portal=portal@entry=0x55c9c0218ed0, isTopLevel=isTopLevel@entry=true) at ../src/backend/tcop/pquery.c:1026 [05:22:03.546] treceiver = 0x55c9c031c740 [05:22:03.546] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:22:03.546] __func__ = "FillPortalStore" [05:22:03.546] #16 0x000055c9be874c64 in PortalRun (portal=portal@entry=0x55c9c0218ed0, count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true, run_once=run_once@entry=true, dest=dest@entry=0x55c9c0357798, altdest=altdest@entry=0x55c9c0357798, qc=0x7fff06d4c770) at ../src/backend/tcop/pquery.c:763 [05:22:03.546] _save_exception_stack = 0x7fff06d4c820 [05:22:03.546] _save_context_stack = 0x0 [05:22:03.546] _local_sigjmp_buf = {{__jmpbuf = {1, -9193632931813942671, 94325001516952, 94325001378496, 94325000212176, 94325001378424, 9194004250867636849, 3169085532822542961}, __mask_was_saved = 0, __saved_mask = {__val = {94325000223736, 94324979285726, 94325000220384, 94324979285726, 1, 140733307995903, 94325001378472, 94325001378424, 94324976220790, 94324978871241, 94325000212176, 94324979285726, 1, 1, 94324976489591, 163}}}} [05:22:03.546] _do_rethrow = [05:22:03.546] result = [05:22:03.546] nprocessed = [05:22:03.546] saveTopTransactionResourceOwner = 0x55c9c01d6088 [05:22:03.546] saveTopTransactionContext = 0x55c9c026f2d0 [05:22:03.546] saveActivePortal = 0x0 [05:22:03.546] saveResourceOwner = 0x55c9c01d6088 [05:22:03.546] savePortalContext = 0x0 [05:22:03.546] saveMemoryContext = 0x55c9c026f2d0 [05:22:03.546] __func__ = "PortalRun" [05:22:03.546] #17 0x000055c9be86dbed in exec_simple_query (query_string=query_string@entry=0x55c9c01951d0 "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 [05:22:03.546] cmdtaglen = 5 [05:22:03.546] snapshot_set = [05:22:03.546] per_parsetree_context = 0x0 [05:22:03.546] plantree_list = 0x55c9c0357748 [05:22:03.546] parsetree = 0x55c9c0335a78 [05:22:03.546] commandTag = [05:22:03.546] qc = {commandTag = CMDTAG_UNKNOWN, nprocessed = 0} [05:22:03.546] querytree_list = [05:22:03.546] portal = 0x55c9c0218ed0 [05:22:03.546] receiver = 0x55c9c0357798 [05:22:03.546] format = 0 [05:22:03.546] cmdtagname = [05:22:03.546] parsetree_item__state = {l = , i = } [05:22:03.546] dest = DestRemote [05:22:03.546] oldcontext = 0x55c9c026f2d0 [05:22:03.546] parsetree_list = 0x55c9c0335aa8 [05:22:03.546] parsetree_item = 0x55c9c0335ac0 [05:22:03.546] save_log_statement_stats = false [05:22:03.546] was_logged = true [05:22:03.546] use_implicit_block = false [05:22:03.546] msec_str = "\320\311\324\006\377\177\000\000\017W\264\276\311U\000\000\000\310\324\006\377\177\000\000\026\001\000\000\000\000\000" [05:22:03.546] __func__ = "exec_simple_query" [05:22:03.546] #18 0x000055c9be8709ab in PostgresMain (dbname=, username=) at ../src/backend/tcop/postgres.c:4680 [05:22:03.546] query_string = 0x55c9c01951d0 "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"... [05:22:03.546] firstchar = [05:22:03.546] input_message = {data = 0x55c9c01951d0 "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} [05:22:03.546] local_sigjmp_buf = {{__jmpbuf = {94324988951960, 3169084317983152753, 4, 140733307996624, 140733307996772, 1, 9194004250796333681, 3169085535171746417}, __mask_was_saved = 1, __saved_mask = {__val = {4194304, 14344, 0, 1, 140386065817060, 94324999646880, 14336, 14400, 94324976392987, 94324988951968, 94324999646880, 94324988946040, 140733307996624, 140733307996772, 94324976397055, 140733307996400}}}} [05:22:03.546] send_ready_for_query = false [05:22:03.546] idle_in_transaction_timeout_enabled = false [05:22:03.546] idle_session_timeout_enabled = false [05:22:03.546] __func__ = "PostgresMain" [05:22:03.546] #19 0x000055c9be86714d in BackendMain (startup_data=, startup_data_len=) at ../src/backend/tcop/backend_startup.c:105 [05:22:03.546] bsdata = [05:22:03.546] #20 0x000055c9be70b6fb in postmaster_child_launch (child_type=child_type@entry=B_BACKEND, startup_data=startup_data@entry=0x7fff06d4c97c "", startup_data_len=startup_data_len@entry=4, client_sock=client_sock@entry=0x7fff06d4c9d0) at ../src/backend/postmaster/launch_backend.c:265 [05:22:03.546] pid = [05:22:03.546] #21 0x000055c9be711a29 in BackendStartup (client_sock=client_sock@entry=0x7fff06d4c9d0) at ../src/backend/postmaster/postmaster.c:3593 [05:22:03.546] bn = 0x55c9c01cb278 [05:22:03.546] pid = [05:22:03.546] startup_data = {canAcceptConnections = CAC_OK} [05:22:03.546] __func__ = "BackendStartup" [05:22:03.546] #22 0x000055c9be711fd7 in ServerLoop () at ../src/backend/postmaster/postmaster.c:1674 [05:22:03.546] s = {sock = 8, raddr = {addr = {ss_family = 1, __ss_padding = "%/\256\177\000\000-\000\000\000\000\000\000\000\020^\216-\256\177\000\000 )^.\256\177\000\000\210\312\324\006\377\177\000\000\204\312\324\006\377\177\000\000D\312\324\006\377\177\000\000@\316-+\256\177\000\000\000\000\000\000\377\177\000\000\020^\216-\256\177\000\000\340\177\215-\256\177\000\000꿪-\256\177\000\000\356\310\347Y\000\000\000\000#\237g\001\000\000\000\000\204\312\324\006\377\177\000", __ss_align = 140386025459264}, salen = 2}} [05:22:03.546] i = 0 [05:22:03.546] now = [05:22:03.546] last_lockfile_recheck_time = 1712985498 [05:22:03.546] last_touch_time = 1712985498 [05:22:03.546] events = {{pos = 1, events = 2, fd = 6, user_data = 0x0}, {pos = 114608896, events = 32767, fd = 114608912, user_data = 0x0}, {pos = 18, events = 0, fd = 1508362478, user_data = 0x7fae2e5e2788}, {pos = 766164970, events = 32686, fd = 114609128, user_data = 0x7fff06d4cb40}, {pos = 114608976, events = 32767, fd = 790969569, user_data = 0x12}, {pos = 724211224, events = 32686, fd = 1, user_data = 0x0}, {pos = 1, events = 0, fd = 777921568, user_data = 0xffffffff}, {pos = 724211224, events = 32686, fd = 777921568, user_data = 0x12e5e2920}, {pos = 777922440, events = 32686, fd = 0, user_data = 0x7fff06d4cc5e}, {pos = 114609232, events = 32767, fd = -1, user_data = 0x7fff06d4cb60}, {pos = 764249112, events = 32686, fd = 777922848, user_data = 0x55c9c01be378}, {pos = -1071914488, events = 21961, fd = -1071906800, user_data = 0x55c9c01be398}, {pos = -1071910159, events = 21961, fd = 790988323, user_data = 0x1}, {pos = 766267640, events = 32686, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 1, user_data = 0x55c9c0196f70}, {pos = 790988323, events = 32686, fd = 1, user_data = 0x0}, {pos = -1071906800, events = 21961, fd = 764249112, user_data = 0x7fff06d4cfa0}, {pos = 791017098, events = 32686, fd = 0, user_data = 0x0}, {pos = 114610112, events = 32767, fd = -1082860736, user_data = 0x2}, {pos = -1082860736, events = 21961, fd = 0, user_data = 0x7fae2daa2be0}, {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 = -1071914200, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0xffffff0000000000}, {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 = 0x30305f742f617461}, {pos = 1735417650, events = 1735423327, fd = 1853190772, user_data = 0x2f65646172677075}, {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 = 766109824, user_data = 0x7fae2d95151a <_IO_file_underflow+378>}, {pos = 7, events = 0, fd = 764767534, user_data = 0x400}, {pos = -1072091328, events = 21961, fd = 766112896, user_data = 0x1c0192f40}, {pos = 784, events = 0, fd = -1093008820, user_data = 0x55c9c01bdee0}, {pos = -1782576128, events = 2126189216, fd = 2, user_data = 0x8000000000000006}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = -1071915296, events = 21961, fd = -1071915296, user_data = 0x55c9c01bdee0}, {pos = 1, events = 0, fd = -1071915096, user_data = 0x400}, {pos = 0, events = 0, fd = -1095273654, user_data = 0x55c9bf75bd50 }, {pos = -1095347772, events = 21961, fd = -1071915296, user_data = 0x55c9c01950d0}, {pos = -1071915296, events = 21961, fd = 15, user_data = 0x4a}, {pos = -1095271844, events = 21961, fd = -1071915296, user_data = 0x55c9beb77ba5 }, {pos = -1072091328, events = 21961, fd = 764767534, user_data = 0x0}, {pos = -1101909495, events = 21961, fd = -1071920448, user_data = 0x7fae2d9531aa}, {pos = 114610264, events = 1, fd = 0, user_data = 0x7fae2d9518f0}, {pos = 0, events = 0, fd = 0, user_data = 0x0}, {pos = 0, events = 0, fd = 11, user_data = 0x0}, {pos = 0, events = 0, fd = 20271, user_data = 0x7fae2d99bb05 }, {pos = 0, events = 0, fd = -1782576128, user_data = 0x0}, {pos = -1099910111, events = 21961, fd = 4194304, user_data = 0x55c9beb65058 }, {pos = -1071920448, events = 21961, fd = -1072082736, user_data = 0x55c9c01bcac0}, {pos = 1, events = 0, fd = 0, user_data = 0x55c9beb77a5c }, {pos = -1071920448, events = 21961, fd = -1095271515, user_data = 0x0}, {pos = 4, events = 0, fd = 0, user_data = 0x55c9be522ddc }, {pos = 0, events = 0, fd = -1101886542, user_data = 0xb}, {pos = -1099888261, events = 21961, fd = 0, user_data = 0x0}} [05:22:03.547] nevents = 1 [05:22:03.547] __func__ = "ServerLoop" [05:22:03.547] #23 0x000055c9be7139f9 in PostmasterMain (argc=argc@entry=4, argv=argv@entry=0x55c9c018edb0) at ../src/backend/postmaster/postmaster.c:1372 [05:22:03.547] opt = [05:22:03.547] status = [05:22:03.547] userDoption = [05:22:03.547] listen_addr_saved = false [05:22:03.547] output_config_variable = [05:22:03.547] __func__ = "PostmasterMain" [05:22:03.547] #24 0x000055c9be53443f in main (argc=4, argv=0x55c9c018edb0) at ../src/backend/main/main.c:197 [05:22:03.547] do_check_root =