Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u6W9Q-00H39T-SM for pgsql-hackers@arkaria.postgresql.org; Sun, 20 Apr 2025 15:00:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u6W9O-00CcfF-Mn for pgsql-hackers@arkaria.postgresql.org; Sun, 20 Apr 2025 15:00:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u6W9O-00Ccf0-Av for pgsql-hackers@lists.postgresql.org; Sun, 20 Apr 2025 15:00:07 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u6W9L-0014z1-1L for pgsql-hackers@postgresql.org; Sun, 20 Apr 2025 15:00:06 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-43cf680d351so24603295e9.0 for ; Sun, 20 Apr 2025 08:00:04 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745161203; x=1745766003; darn=postgresql.org; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=OTvCg4lVI0PSDByjkK0Ca5qs1You/tcyWbzhMvZPrLM=; b=WL5SNm/DpmrGlDrMkm3JIoJookElBHYcE5fnhGRFurGLYeAdAMvngQngD/YN6kgOxN AtNmCXWKCxWylzIW/r+7Csc4Uc05JXsMuve46Zq1HAeWs1rJ1lq6hAFVTbcYSvfMUjRd COYl5TI+eUB37+JRDNmQDUM6z5Et46Dsyj1zsruhGRuEoclUtkSP62triitRuENwVoJB pHEYIPSx/qO8ZGBoBow5CJ11ozpVyp+j0tAkVjuh9DP70XdrYXCZQCLFH+5eAG7DPgjw Q8OqcRLskpQfXxVJHDrNAhPtdVs35lf9DR7EDnNdU8KNOdZRvvSih6stmwNUT8qBTT6I A98A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745161203; x=1745766003; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=OTvCg4lVI0PSDByjkK0Ca5qs1You/tcyWbzhMvZPrLM=; b=db4HoildjB+dWq90Y+aDhQ7MSUEZ5OirM44zECclrlgSsq/uNzQ1aS+nWsRRYV2kME vK+ODHh6967W4iklVEbjNJRgxlghGhvmZaI+c7mw69qDrDB6kkcJDr1r1NsUm8+DOT4U unGGCrFmH70UIVxYPWamiRXtrOEq7grqgc64eVEGKwUWeXG6DRtM+edHbbcMKy1F81PG +LZlkt4vd3OVREdU9erSDDE3TN6y6HxrUNldp8BEvjYsqqS+gu8rq1F8THagladf/oEa TOGQu4WMlixKXbA0IjncyRpXxCcRwwzFQm5vdhChcczmpmSCU1TZ8Er0mYm1Tkh7G0PI /8LA== X-Gm-Message-State: AOJu0YyGhGI4KethnhksvXELK9gxa5rbyYWJp3J9wA5fF2B9LkeQ+czm zGGGqK200ijeIwWfYO5B8fH5SFTs9/xgSTO7Rx82s+d+WVNVwPNM X-Gm-Gg: ASbGncslbX1Q53AfsjU3s/4R/pXSazhk5hgo76kT5f5dLR0x3D5mXLbXQ30Jy/km0ZP /Y1N05PZipaTCLeERauBdAgV8Oj+e9RBgakPYvCEE8yGQD59cmOCyFvbSdNQdaza+bB+DJWKorf t7xUY6ldVEDmy3PJ7vCPjVCXMd2zRLpNw04URvmXECU7oMyuH1XFRqGW9dwZjEjEat4SG7PP/99 SmVrBQ6A6ui+kwny0tO9moZ4WAqZRtN9ED7YYjalYPaG5H2C20SnuoLkunDHKPbouUn6rtpZnFR wCxfdahYY04BwtqAkOgLd7aDBRCrPQT+TU81pf+cTUM= X-Google-Smtp-Source: AGHT+IHgFTFRDKREDXKgORUayY6u+zdHH0Umf+zxTG39jXHhNQPeYg00xyLU0d64F91sH+F3UFw3AQ== X-Received: by 2002:adf:e04f:0:b0:39b:32fc:c025 with SMTP id ffacd0b85a97d-39ef89b5d9amr5755733f8f.2.1745161202688; Sun, 20 Apr 2025 08:00:02 -0700 (PDT) Received: from [192.168.0.50] ([89.149.68.176]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-44043529fdbsm120147675e9.1.2025.04.20.08.00.01 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 20 Apr 2025 08:00:02 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------CqHCnY0wy9eP5K3Ik0QEcZdC" Message-ID: <554d4da2-9392-4098-9c91-4c34f222abbb@gmail.com> Date: Sun, 20 Apr 2025 18:00:00 +0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: AIO v2.5 To: Andres Freund Cc: pgsql-hackers@postgresql.org, Thomas Munro , Heikki Linnakangas , Robert Haas , Jakub Wartak , Jelte Fennema-Nio , Antonin Houska , Noah Misch References: <5tyic6epvdlmd6eddgelv47syg2b5cpwffjam54axp25xyq2ga@ptwkinxqo3az> <20250328032223.34.nmisch@google.com> <20250329134143.ca.nmisch@google.com> <20250329212929.a6.nmisch@google.com> Content-Language: en-US From: Alexander Lakhin In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------CqHCnY0wy9eP5K3Ik0QEcZdC Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hello Andres, 31.03.2025 02:46, Andres Freund wrote: > I've pushed most of these after some very light further editing. Yay. Thanks > a lot for all the reviews! > > So far the buildfarm hasn't been complaining, but it's early days. I found one complaint against commit 12ce89fd0, expressed as: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=scorpion&dt=2025-04-08%2001%3A36%3A41 149/334 postgresql:recovery / recovery/032_relfilenode_reuse ERROR           206.41s   (exit status 255 or signal 127 SIGinvalid) [01:41:53.249](0.620s) ok 8 - standby: post move contents as expected [01:44:55.175](181.927s) Bail out!  aborting wait: program timed out stream contents: >><< pattern searched for: (?^m:warmed_buffers) 032_relfilenode_reuse_standby.log contains: 2025-04-08 01:41:54.674 UTC [4013024][startup][33/0:0] DEBUG: waiting for all backends to process ProcSignalBarrier generation 7 2025-04-08 01:41:54.674 UTC [4013024][startup][33/0:0] CONTEXT:  WAL redo at 0/43E5360 for Database/DROP: dir 1663/50001 2025-04-08 01:41:54.670 UTC [4013251][client backend][0/2:0] DEBUG: waiting for self with 0 pending 2025-04-08 01:41:54.674 UTC [4013251][client backend][0/2:0] ERROR: no free IOs despite no in-flight IOs 2025-04-08 01:41:54.674 UTC [4013251][client backend][0/2:0] STATEMENT:  SELECT SUM(pg_prewarm(oid)) warmed_buffers FROM pg_class WHERE pg_relation_filenode(oid) != 0; I could reproduce this error with the following TEMP_CONFIG: log_min_messages = DEBUG4 log_connections = on log_disconnections = on log_statement = 'all' log_line_prefix = '%m [%d][%p:%l][%b] %q[%a] ' fsync = on io_method=io_uring backtrace_functions = 'pgaio_io_wait_for_free' When running 032_relfilenode_reuse.pl in a loop, I got failures on iterations 10, 18, 6: 2025-04-20 15:56:01.310 CEST [][1517068:122][startup] DEBUG: updated min recovery point to 0/4296E90 on timeline 1 2025-04-20 15:56:01.310 CEST [][1517068:123][startup] CONTEXT:  WAL redo at 0/4296E48 for Transaction/COMMIT: 2025-04-20 15:56:01.09363+02; inval msgs: catcache 21; sync 2025-04-20 15:56:01.310 CEST [][1517068:124][startup] DEBUG: waiting for all backends to process ProcSignalBarrier generation 5 2025-04-20 15:56:01.310 CEST [][1517068:125][startup] CONTEXT:  WAL redo at 0/4296E90 for Database/DROP: dir 16409/50001 2025-04-20 15:56:01.312 CEST [postgres][1517075:144][client backend] [032_relfilenode_reuse.pl] DEBUG:  waiting for self with 0 pending 2025-04-20 15:56:01.312 CEST [postgres][1517075:145][client backend] [032_relfilenode_reuse.pl] BACKTRACE: pgaio_io_wait_for_free at aio.c:703:2  (inlined by) pgaio_io_acquire at aio.c:186:3 AsyncReadBuffers at bufmgr.c:1854:9 StartReadBuffersImpl at bufmgr.c:1425:18  (inlined by) StartReadBuffers at bufmgr.c:1497:9 read_stream_start_pending_read at read_stream.c:333:25 read_stream_look_ahead at read_stream.c:475:3 read_stream_next_buffer at read_stream.c:840:6 pg_prewarm at pg_prewarm.c:214:10 ExecInterpExpr at execExprInterp.c:927:7 ExecEvalExprNoReturn at executor.h:447:2 ... 2025-04-20 15:56:01.312 CEST [][1517068:126][startup] DEBUG: finished waiting for all backends to process ProcSignalBarrier generation 5 2025-04-20 15:56:01.312 CEST [][1517068:127][startup] CONTEXT:  WAL redo at 0/4296E90 for Database/DROP: dir 16409/50001 2025-04-20 15:56:01.314 CEST [postgres][1517075:146][client backend] [032_relfilenode_reuse.pl] ERROR:  no free IOs despite no in-flight IOs 2025-04-20 15:56:01.314 CEST [postgres][1517075:147][client backend] [032_relfilenode_reuse.pl] BACKTRACE: pgaio_io_wait_for_free at aio.c:735:3  (inlined by) pgaio_io_acquire at aio.c:186:3 AsyncReadBuffers at bufmgr.c:1854:9 StartReadBuffersImpl at bufmgr.c:1425:18  (inlined by) StartReadBuffers at bufmgr.c:1497:9 read_stream_start_pending_read at read_stream.c:333:25 read_stream_look_ahead at read_stream.c:475:3 read_stream_next_buffer at read_stream.c:840:6 pg_prewarm at pg_prewarm.c:214:10 ExecInterpExpr at execExprInterp.c:927:7 ExecEvalExprNoReturn at executor.h:447:2 ... I configured the build with: CPPFLAGS="-O1" ./configure --enable-injection-points --enable-cassert --enable-debug --enable-tap-tests --with-liburing I also encountered another failure when running this test: t/032_relfilenode_reuse.pl .. 1/? Bailout called.  Further testing stopped:  aborting wait: program died Core was generated by `postgres: standby: law postgres [local] SELECT                   '. Program terminated with signal SIGABRT, Aborted. #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=) at ./nptl/pthread_kill.c:44 (gdb) bt #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=) at ./nptl/pthread_kill.c:44 #1  __pthread_kill_internal (signo=6, threadid=) at ./nptl/pthread_kill.c:78 #2  __GI___pthread_kill (threadid=, signo=signo@entry=6) at ./nptl/pthread_kill.c:89 #3  0x0000700a5a24527e in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26 #4  0x0000700a5a2288ff in __GI_abort () at ./stdlib/abort.c:79 #5  0x0000630ff2c5dcea in errfinish (filename=filename@entry=0x630ff2cdd139 "aio.c", lineno=lineno@entry=559,     funcname=funcname@entry=0x630ff2e85da8 <__func__.9> "pgaio_io_wait") at elog.c:599 #6  0x0000630ff2aae79c in pgaio_io_wait (ioh=ioh@entry=0x700a57b59700, ref_generation=3972) at aio.c:559 #7  0x0000630ff2aaefab in pgaio_io_wait_for_free () at aio.c:771 #8  pgaio_io_acquire (resowner=0x63100114dee8, ret=ret@entry=0x6310011efec8) at aio.c:186 #9  0x0000630ff2ab9137 in AsyncReadBuffers (operation=operation@entry=0x6310011efe88, nblocks_progress=nblocks_progress@entry=0x7ffd8d262034) at bufmgr.c:1854 #10 0x0000630ff2abc6cc in StartReadBuffersImpl (allow_forwarding=true, flags=0, nblocks=0x7ffd8d262034, blockNum=0, buffers=0x6310011efe3c,     operation=0x6310011efe88) at bufmgr.c:1425 #11 StartReadBuffers (operation=0x6310011efe88, buffers=buffers@entry=0x6310011efe3c, blockNum=0, nblocks=nblocks@entry=0x7ffd8d262034, flags=flags@entry=0)     at bufmgr.c:1497 #12 0x0000630ff2ab2f3f in read_stream_start_pending_read (stream=stream@entry=0x6310011efde0) at read_stream.c:328 #13 0x0000630ff2ab3363 in read_stream_look_ahead (stream=stream@entry=0x6310011efde0) at read_stream.c:475 #14 0x0000630ff2ab37e5 in read_stream_next_buffer (stream=stream@entry=0x6310011efde0, per_buffer_data=per_buffer_data@entry=0x0) at read_stream.c:837 #15 0x0000700a5adae60c in pg_prewarm (fcinfo=) at pg_prewarm.c:214 #16 0x0000630ff29004cc in ExecInterpExpr (state=0x6310012239c8, econtext=0x6310011e1920, isnull=0x0) at execExprInterp.c:926 #17 0x0000630ff291bfb4 in ExecEvalExprNoReturn (econtext=, state=) at ../../../src/include/executor/executor.h:445 #18 ExecEvalExprNoReturnSwitchContext (econtext=, state=) at ../../../src/include/executor/executor.h:486 #19 advance_aggregates (aggstate=aggstate@entry=0x6310011e14f8) at nodeAgg.c:820 #20 0x0000630ff291db18 in agg_retrieve_direct (aggstate=0x6310011e14f8) at nodeAgg.c:2540 #21 ExecAgg (pstate=0x6310011e14f8) at nodeAgg.c:2265 #22 0x0000630ff290deef in ExecProcNodeFirst (node=0x6310011e14f8) at execProcnode.c:469 ... Best regards, Alexander Lakhin Neon (https://neon.tech) --------------CqHCnY0wy9eP5K3Ik0QEcZdC Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
Hello Andres,

31.03.2025 02:46, Andres Freund wrote:
I've pushed most of these after some very light further editing.  Yay.  Thanks
a lot for all the reviews!

So far the buildfarm hasn't been complaining, but it's early days.

I found one complaint against commit 12ce89fd0, expressed as:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=scorpion&dt=2025-04-08%2001%3A36%3A41

149/334 postgresql:recovery / recovery/032_relfilenode_reuse                            ERROR           206.41s   (exit status 255 or signal 127 SIGinvalid)

[01:41:53.249](0.620s) ok 8 - standby: post move contents as expected
[01:44:55.175](181.927s) Bail out!  aborting wait: program timed out
stream contents: >><<
pattern searched for: (?^m:warmed_buffers)

032_relfilenode_reuse_standby.log contains:
2025-04-08 01:41:54.674 UTC [4013024][startup][33/0:0] DEBUG:  waiting for all backends to process ProcSignalBarrier generation 7
2025-04-08 01:41:54.674 UTC [4013024][startup][33/0:0] CONTEXT:  WAL redo at 0/43E5360 for Database/DROP: dir 1663/50001
2025-04-08 01:41:54.670 UTC [4013251][client backend][0/2:0] DEBUG:  waiting for self with 0 pending
2025-04-08 01:41:54.674 UTC [4013251][client backend][0/2:0] ERROR:  no free IOs despite no in-flight IOs
2025-04-08 01:41:54.674 UTC [4013251][client backend][0/2:0] STATEMENT:  SELECT SUM(pg_prewarm(oid)) warmed_buffers FROM pg_class WHERE pg_relation_filenode(oid) != 0;

I could reproduce this error with the following TEMP_CONFIG:
log_min_messages = DEBUG4

log_connections = on
log_disconnections = on
log_statement = 'all'
log_line_prefix = '%m [%d][%p:%l][%b] %q[%a] '

fsync = on
io_method=io_uring
backtrace_functions = 'pgaio_io_wait_for_free'

When running 032_relfilenode_reuse.pl in a loop, I got failures on
iterations 10, 18, 6:
2025-04-20 15:56:01.310 CEST [][1517068:122][startup] DEBUG:  updated min recovery point to 0/4296E90 on timeline 1
2025-04-20 15:56:01.310 CEST [][1517068:123][startup] CONTEXT:  WAL redo at 0/4296E48 for Transaction/COMMIT: 2025-04-20 15:56:01.09363+02; inval msgs: catcache 21; sync
2025-04-20 15:56:01.310 CEST [][1517068:124][startup] DEBUG:  waiting for all backends to process ProcSignalBarrier generation 5
2025-04-20 15:56:01.310 CEST [][1517068:125][startup] CONTEXT:  WAL redo at 0/4296E90 for Database/DROP: dir 16409/50001
2025-04-20 15:56:01.312 CEST [postgres][1517075:144][client backend] [032_relfilenode_reuse.pl] DEBUG:  waiting for self with 0 pending
2025-04-20 15:56:01.312 CEST [postgres][1517075:145][client backend] [032_relfilenode_reuse.pl] BACKTRACE:
pgaio_io_wait_for_free at aio.c:703:2
 (inlined by) pgaio_io_acquire at aio.c:186:3
AsyncReadBuffers at bufmgr.c:1854:9
StartReadBuffersImpl at bufmgr.c:1425:18
 (inlined by) StartReadBuffers at bufmgr.c:1497:9
read_stream_start_pending_read at read_stream.c:333:25
read_stream_look_ahead at read_stream.c:475:3
read_stream_next_buffer at read_stream.c:840:6
pg_prewarm at pg_prewarm.c:214:10
ExecInterpExpr at execExprInterp.c:927:7
ExecEvalExprNoReturn at executor.h:447:2
...
2025-04-20 15:56:01.312 CEST [][1517068:126][startup] DEBUG:  finished waiting for all backends to process ProcSignalBarrier generation 5
2025-04-20 15:56:01.312 CEST [][1517068:127][startup] CONTEXT:  WAL redo at 0/4296E90 for Database/DROP: dir 16409/50001
2025-04-20 15:56:01.314 CEST [postgres][1517075:146][client backend] [032_relfilenode_reuse.pl] ERROR:  no free IOs despite no in-flight IOs
2025-04-20 15:56:01.314 CEST [postgres][1517075:147][client backend] [032_relfilenode_reuse.pl] BACKTRACE:
pgaio_io_wait_for_free at aio.c:735:3
 (inlined by) pgaio_io_acquire at aio.c:186:3
AsyncReadBuffers at bufmgr.c:1854:9
StartReadBuffersImpl at bufmgr.c:1425:18
 (inlined by) StartReadBuffers at bufmgr.c:1497:9
read_stream_start_pending_read at read_stream.c:333:25
read_stream_look_ahead at read_stream.c:475:3
read_stream_next_buffer at read_stream.c:840:6
pg_prewarm at pg_prewarm.c:214:10
ExecInterpExpr at execExprInterp.c:927:7
ExecEvalExprNoReturn at executor.h:447:2
...

I configured the build with:
CPPFLAGS="-O1" ./configure --enable-injection-points --enable-cassert --enable-debug --enable-tap-tests --with-liburing

I also encountered another failure when running this test:
t/032_relfilenode_reuse.pl .. 1/? Bailout called.  Further testing stopped:  aborting wait: program died

Core was generated by `postgres: standby: law postgres [local] SELECT                   '.
Program terminated with signal SIGABRT, Aborted.
#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:44

(gdb) bt
#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
#1  __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
#2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
#3  0x0000700a5a24527e in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
#4  0x0000700a5a2288ff in __GI_abort () at ./stdlib/abort.c:79
#5  0x0000630ff2c5dcea in errfinish (filename=filename@entry=0x630ff2cdd139 "aio.c", lineno=lineno@entry=559,
    funcname=funcname@entry=0x630ff2e85da8 <__func__.9> "pgaio_io_wait") at elog.c:599
#6  0x0000630ff2aae79c in pgaio_io_wait (ioh=ioh@entry=0x700a57b59700, ref_generation=3972) at aio.c:559
#7  0x0000630ff2aaefab in pgaio_io_wait_for_free () at aio.c:771
#8  pgaio_io_acquire (resowner=0x63100114dee8, ret=ret@entry=0x6310011efec8) at aio.c:186
#9  0x0000630ff2ab9137 in AsyncReadBuffers (operation=operation@entry=0x6310011efe88, nblocks_progress=nblocks_progress@entry=0x7ffd8d262034) at bufmgr.c:1854
#10 0x0000630ff2abc6cc in StartReadBuffersImpl (allow_forwarding=true, flags=0, nblocks=0x7ffd8d262034, blockNum=0, buffers=0x6310011efe3c,
    operation=0x6310011efe88) at bufmgr.c:1425
#11 StartReadBuffers (operation=0x6310011efe88, buffers=buffers@entry=0x6310011efe3c, blockNum=0, nblocks=nblocks@entry=0x7ffd8d262034, flags=flags@entry=0)
    at bufmgr.c:1497
#12 0x0000630ff2ab2f3f in read_stream_start_pending_read (stream=stream@entry=0x6310011efde0) at read_stream.c:328
#13 0x0000630ff2ab3363 in read_stream_look_ahead (stream=stream@entry=0x6310011efde0) at read_stream.c:475
#14 0x0000630ff2ab37e5 in read_stream_next_buffer (stream=stream@entry=0x6310011efde0, per_buffer_data=per_buffer_data@entry=0x0) at read_stream.c:837
#15 0x0000700a5adae60c in pg_prewarm (fcinfo=<optimized out>) at pg_prewarm.c:214
#16 0x0000630ff29004cc in ExecInterpExpr (state=0x6310012239c8, econtext=0x6310011e1920, isnull=0x0) at execExprInterp.c:926
#17 0x0000630ff291bfb4 in ExecEvalExprNoReturn (econtext=<optimized out>, state=<optimized out>) at ../../../src/include/executor/executor.h:445
#18 ExecEvalExprNoReturnSwitchContext (econtext=<optimized out>, state=<optimized out>) at ../../../src/include/executor/executor.h:486
#19 advance_aggregates (aggstate=aggstate@entry=0x6310011e14f8) at nodeAgg.c:820
#20 0x0000630ff291db18 in agg_retrieve_direct (aggstate=0x6310011e14f8) at nodeAgg.c:2540
#21 ExecAgg (pstate=0x6310011e14f8) at nodeAgg.c:2265
#22 0x0000630ff290deef in ExecProcNodeFirst (node=0x6310011e14f8) at execProcnode.c:469
...

Best regards,
Alexander Lakhin
Neon (https://neon.tech)
--------------CqHCnY0wy9eP5K3Ik0QEcZdC--