Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1lhZG0-0005Tg-JN
	for pgsql-bugs@arkaria.postgresql.org; Fri, 14 May 2021 14:57:40 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1lhZFz-0006eq-HW
	for pgsql-bugs@arkaria.postgresql.org; Fri, 14 May 2021 14:57:39 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1lhZFz-0006eh-Av
	for pgsql-bugs@lists.postgresql.org; Fri, 14 May 2021 14:57:39 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1lhZFx-0004DY-6z
	for pgsql-bugs@lists.postgresql.org; Fri, 14 May 2021 14:57:38 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 14EEvUEs1884043;
	Fri, 14 May 2021 10:57:30 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alex F <phoedos16@gmail.com>
cc: Peter Geoghegan <pg@bowt.ie>, Andres Freund <andres@anarazel.de>,
        pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16833: postgresql 13.1 process crash every hour
In-reply-to: 
 <CAGbr_zXOUzvpXZm9fi6sysw4bavUNHHBgNTCsZC9XE1zVzke1g@mail.gmail.com>
References: <16833-12d1cd7c13c78bde@postgresql.org>
 <20210122175556.flvrb532anccsnca@alap3.anarazel.de>
 <CAGbr_zVCq-eW+PrE4K3wJGFmqC60w27EqHsNH6+hYC=YL0EnTg@mail.gmail.com>
 <CAGbr_zVNNrpDuDTi5eNYrUjg_8SQ_anggyfR6C0=Lx_3yv=jbg@mail.gmail.com>
 <1060558.1620827849@sss.pgh.pa.us>
 <CAGbr_zXOUzvpXZm9fi6sysw4bavUNHHBgNTCsZC9XE1zVzke1g@mail.gmail.com>
Comments: In-reply-to Alex F <phoedos16@gmail.com>
	message dated "Fri, 14 May 2021 11:29:13 +0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1884041.1621004250.1@sss.pgh.pa.us>
Date: Fri, 14 May 2021 10:57:30 -0400
Message-ID: <1884042.1621004250@sss.pgh.pa.us>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/1884042.1621004250%40sss.pgh.pa.us>
Precedence: bulk

Alex F <phoedos16@gmail.com> writes:
> Think I was able to get a gdb stack trace. Logs attached.

> Program terminated with signal SIGSEGV, Segmentation fault.
> #0  0x00007ffa43a2c94d in __memmove_avx_unaligned_erms () from
> /lib64/libc.so.6
> (gdb) bt
> #0  0x00007ffa43a2c94d in __memmove_avx_unaligned_erms () from
> /lib64/libc.so.6
> #1  0x00000000004d67f5 in _bt_swap_posting ()
> #2  0x00000000004d792e in _bt_insertonpg ()
> #3  0x00000000004d9113 in _bt_doinsert ()
> #4  0x00000000004dc1a1 in btinsert ()
> #5  0x000000000060fa7f in ExecInsertIndexTuples ()
> #6  0x0000000000637078 in ExecInsert ()
> #7  0x00000000006379c7 in ExecModifyTable ()
> #8  0x00000000006107dc in standard_ExecutorRun ()
> #9  0x0000000000645695 in _SPI_execute_plan ()
> #10 0x0000000000645a3c in SPI_execute ()
> #11 0x00000000005c39ff in ExecRefreshMatView ()
> #12 0x000000000075799d in ProcessUtilitySlow.isra.4 ()
> #13 0x00000000007567ce in standard_ProcessUtility ()
> #14 0x0000000000754382 in PortalRunUtility ()
> #15 0x0000000000754d4d in PortalRunMulti ()
> #16 0x0000000000755763 in PortalRun ()
> #17 0x000000000075330b in PostgresMain ()
> #18 0x00000000006e2d8a in ServerLoop ()
> #19 0x00000000006e3df7 in PostmasterMain ()
> #20 0x00000000004883c2 in main ()

Hmm, looks like it's time to rope Peter Geoghegan in on this discussion.

			regards, tom lane