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 ) id 1mf0Ly-0001Ys-7t for pgsql-bugs@arkaria.postgresql.org; Mon, 25 Oct 2021 13:49:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mf0Lx-0005kE-5N for pgsql-bugs@arkaria.postgresql.org; Mon, 25 Oct 2021 13:49:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mf0Lw-0005k5-Gi for pgsql-bugs@lists.postgresql.org; Mon, 25 Oct 2021 13:49:28 +0000 Received: from sonic308-56.consmr.mail.ne1.yahoo.com ([66.163.187.31]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mf0Ls-0001ep-G9 for pgsql-bugs@lists.postgresql.org; Mon, 25 Oct 2021 13:49:28 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1635169761; bh=IkjGf9BPC7+ejaGUFxPLV4jO4c7ZzMS27CNij6dgMo4=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=rJw0EOiNvfxwAUgeHwygAVFHgqCNXK899TbQaMCBiSDZIQ5B1/y7KOle7u0d+dvOKLhWGXUAaNGm3F+XlxwcGJgOpqi8l+VLQI5D1aRs2O8QacrsXyKOt8dvPF0PrqjsGVEJNga1HeVuMy0ibApo6b4e2E1t2Ir01gDIssf/ebiE3ka1D4uZiClEFHNikznm0mxsXGw0nBKe8Q4C5DYOKdsqAo5ZNwkDb90JrH+i/8ca5vwQCMp7P+5OTX0X0Gj+cTvMdZfbdcqMn1XbKJKe/yu1RfvV/o98Yj615KgEY6rtBHd2xEWrBcP5E6EY0uvJzXcvpOtkB5B6bWxhL1ldRg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1635169761; bh=935SqI/4wZx4FxprsKsXuoDTj3jci0xpAOkV7qpCbbR=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=Cp3Z32NInXTN/JJV2ZL5dfkSZIC7QJ7rUwvezj7jv+jmZImqG3U6K3W9Kf/U2gaAxEk/6Rs77rmm+S8krqhkje3FaHrejdWA0qz2yydHI/Itspa7rxno6NjMD2m42CbuEiUjgU8rJGlWhVoEOaOehDxtaWfnCAzP+m+d4u/nfVKPJv/KzsNZtHh4Tp2AmlAeyGrJcepBANooS2KRB0Uja5o6f6i863Hqusz/g7xPKWApUf6S1nGDUJFInGgYb7ZG5yfmNBglMU+LEMD6Exz2wVWjpw8ePUqzW6THW/32/kPdRIy/SW28tTmCdSbsu4QDS360/AMFbIoP+UqEEyM9Dw== X-YMail-OSG: _vu9kmUVM1ldMxVUs6MP2l_X39ydUdoQwYpDb7WFCY3iSKpRgZ5svC0UHm_lgO8 nn_sm5ENlxyUxJx8LLgxp3TUGhUm3PCNYDcdf9nj98qou8N0jiGUM2dlZuKVXvuL0JD_vtGD0Tqm YdNUemwG9R_p1Y5mO2d31fuEbfIs4j231rdbOR39dROnqJp0H9LXPr87Ynj1mlpENnHHwWFv.te5 Wsz0jidrTZwJQyIp5vq1p7qoCrUfO._5p.LMYa1PH78joyv1SNePfmRVYu_S2sXlBbUOK5xiEzN0 evvjot1Sbzb8.jZp0E5xCvmteK3a.RgJKMCp_0IVUhnXZhroR0npRF8IKlUp1yFWPm0PvPN2LEKJ 8CaGSZPJ3JCZMSCFoQNS.lsGoWV7tVVzGrjkCXeq.PBtR3fvQWFfm2ZKHhjc.7BI1DtRPRT.pC8B ogA36v.24rv1W8Ac_po_bGddwPq3CLbL_BwFM6OJaYKt5NU_xlJC8qaZpOLKIWMCBKZg8Ov1tBai TjLkPZHqVzEn0um.XqUcPzYaCZHKqPc5Owv.R80GvXFHqCLioy.Stk3xsu1uTTy8sSG7GbxXM54v O7763Hb.x_RFyl33edi1XlCgPkQzJBx6TzWPpRsXx6ki.ncMuQ78PGDCwBpwwX.OA2cCD7d_QaYK flnX72ehjl7TRDeoLVD5imO3_Z.AnSPntbF7g_6Jh7qAq0birsfRXBDq2YU4rbfd7kh6_kwCJq95 WUvVA4PJ3TJlfNk8dB0LROc_jxsV4EZKmgwYSDnPtr7k_T0l9qKXc5y6V9UQineZ1EeAkI6JJGnr 4CY840.ctnQk.eDTpYuZEKkCMvvEEp9xPBAiN3OfMKskQfNMeGF78ULW2SlQ9wjs_VGk49IIfCGL NJeOccM6m9MgVDe2IULSO1kQoZzdhVlDLdYb4taHF4lqEaZ64z8kd_Rf0EnDs1Q4eEdCtzNZscP_ qdygtwUBON59SxkmabXpT7_Wl8D50hTlcgUJT16eJaKfHuvFsXHNvGs63IL4Q5lr5vjBADzpEXwy EDkx2qOu6psbP68ynKi.Oz7A6LCw8vpEaH9vHaYKVKBnQgX_4jZrlzLKR2CIJcitKxabglL6Sakf t0.W9b5ocN.BFYRkSHPWSpjfwCGsu.UzOahWMlYWAOYpGuEbAKiPv2CFrpw1CjmT7QnI6V6hTRKa NC_z82vD0mIpMt_m9YFylJb65t8EUBnRMoSlCltU9NM8E_y5_FL2BrldEPE0HYcRMx8NdoazObbR ARfWLd6DMnOI9REB4TUJ5ljgRXZ_2m1xOJxYGDC1_grZD9j8pct7dVGNXgG5OXr5m0DZOJn6FgTy yZ9YE0M1vQ432djB4T.4xKtPz41itf_4HnSf6nPeAbE73a7IO5JnFAZTp8ndmyEm6fQKtD3uYsCi WnR6s.KDqsSY0fzsBAWNjPQ.naNHLHs8STDG8BvtnIXaYNFUwdDuIyNT.MNAyZ.Rc8FYwH61UN.i cKXuluQszmQhznxXjZFPWVbH.oIivwngJ.RKFfLOcbDPNzkO1DmKu7GVe_ZiurClwapCtvIW_5sq Hq26PjVgNCXTfOT320casvWWauECRPXndP6a2WS2aGLKwmpdq59Hm0MjL6D4blpyJmDHmTpeuVI2 vqU9YEG4urmPnoEuahM_IFl0eJ65T1cI2MNEuy9c.RjlMkF1e9rOys_kgzHnUFKXTQbnNv4dbO7I .356uc_5.zm4phTr08uE9wVg5H76Y9an403mUevARRYLRUE61tNh0k3a4WxEbmmOCv6.5H7tbLR0 tro.gsieJ7KACw_9VJXN8zNTtz7asi9v5Aw7NtSa3BO.Km_UwVmBjmWMXAYQelX1siwaWcYssLyY 8E3BuL39hHuBbT9ITw_gBlKqyupBbGyKlknZXx0nrQkgxbt.oyLeRoFHqtFsomA9t5lMVIaKrxhO TYQEZfY6k1_.8xxZ4LKfMIjKC5bes5wQRX8ZJBMdF9ReVQ87flYHkJlsnkfAWJs4.ccZeOProdrN x7oeqLTiCcSw3mbQhA6CSuAkK_PiYFKM3_KtlAZLLOc0MlRlaJxJQQ_hTkGvMpi95ds.KcBhb9p8 kAjiBgk8lZiFpTFbSbCasYmcJrvMTOcoW.aMmID298q.dW.pD17wqDKJtTx7Kvst.sPRij2mtFYo c9FBhva8OOSTc6xJsuBBaqokppzWAgXlm2izEpIoZeaLisvaOatjt0P54elQqL2_JP0ksVnJjeoW O4ax4O3tC2DXlwi1iLgFScAav X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic308.consmr.mail.ne1.yahoo.com with HTTP; Mon, 25 Oct 2021 13:49:21 +0000 Date: Mon, 25 Oct 2021 13:49:18 +0000 (UTC) From: "Efrain J. Berdecia" To: Peter Geoghegan , Alexander Korotkov Cc: Tom Lane , "pgsql-bugs@lists.postgresql.org" Message-ID: <1097634451.1336766.1635169758802@mail.yahoo.com> In-Reply-To: References: <17229-bc836b4d1d2633bf@postgresql.org> <666112.1634154922@sss.pgh.pa.us> <1462498010.4276407.1634581207093@mail.yahoo.com> Subject: Re: BUG #17229: Segmentation Fault after upgrading to version 13 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1336765_295522163.1635169758800" X-Mailer: WebService/1.1.19198 YMailNorrin Content-Length: 6683 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1336765_295522163.1635169758800 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable We've been running 13.4 since last Thursday on our test cluster and haven't= seen the dump. I would say the latest patched addressed the issue. On a separate note, applying 13.4 on a running cluster caused some issues w= ith; "could not load library "/usr/pgsql-13/lib/plpgsql.so": /usr/pgsql-13/lib/p= lpgsql.so: undefined symbol: EnsurePortalSnapshotExists" ...just FYI.... I would considered this issue with the gist index resolved. Thanks,Efrain J. Berdecia=20 On Tuesday, October 19, 2021, 07:17:26 AM EDT, Alexander Korotkov wrote: =20 =20 On Mon, Oct 18, 2021 at 9:27 PM Peter Geoghegan wrote: > > On Mon, Oct 18, 2021 at 11:20 AM Efrain J. Berdecia > wrote: > > #0=C2=A0 __memcpy_ssse3_back () at ../sysdeps/x86_64/multiarch/memcpy-s= sse3-back.S:1852 > > #1=C2=A0 0x00007f42aee2488b in memcpy (__len=3D12, __src=3D0x7023c19c7,= __dest=3D0x291967d) at /usr/include/bits/string3.h:51 > > #2=C2=A0 gtrgm_alloc (isalltrue=3D, siglen=3Dsiglen@entr= y=3D12, sign=3D0x7023c19c7
) at trgm_gis= t.c:82 > > #3=C2=A0 0x00007f42aee25d80 in gtrgm_picksplit (fcinfo=3D) at trgm_gist.c:852 > > #4=C2=A0 0x00000000008afcfa in FunctionCall2Coll (flinfo=3Dflinfo@entry= =3D0x2bf9400, collation=3D, arg1=3Darg1@entry=3D43095272, ar= g2=3Darg2@entry=3D140737194144480) at fmgr.c:1164 > > #5=C2=A0 0x00000000004b2d03 in gistUserPicksplit (len=3D2, giststate=3D= 0x2bf75d8, itup=3D0x29193c8, v=3D0x7fffee76b2e0, attno=3D0, entryvec=3D0x29= 194e8, r=3D0x7f42aecd3668) at gistsplit.c:433 > > Commit 911e702077 ("Implement operator class parameters") seems like > the most likely culprit, based on a quick "git blame". Alexander? As I can see from the bug report, the affected version is 13.1.=C2=A0 I think this bug is already fixed by 48ab1fa304 in 13.2. ------ Regards, Alexander Korotkov =20 ------=_Part_1336765_295522163.1635169758800 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
We've been running 13.4 sinc= e last Thursday on our test cluster and haven't seen the dump.

I would say the latest patched addressed the issue.

On a separate note, applying 13.4 on a running cluster caused some issues = with;

"could not load library "/usr/pg= sql-13/lib/plpgsql.so": /usr/pgsql-13/lib/plpgsql.so: undefined symbol: Ens= urePortalSnapshotExists"

...just FYI....

I would considered this i= ssue with the gist index resolved.

Thanks,
Efrain J. Berdecia


=20
=20
On Tuesday, October 19, 2021, 07:17:26 AM EDT, Alexande= r Korotkov <aekorotkov@gmail.com> wrote:


On Mon, Oct 18, 2021 at 9:27 PM Peter= Geoghegan <pg@bowt.ie> wrote:

>
> On Mon, Oct 18, 2021 at 11:20 AM Efrain J. Berdecia
> <ejberdecia@yahoo.com> wrote:
> > #0  __memcpy_ssse3_back () at ../sysdeps/x86_64/m= ultiarch/memcpy-ssse3-back.S:1852
> > #1  0x00= 007f42aee2488b in memcpy (__len=3D12, __src=3D0x7023c19c7, __dest=3D0x29196= 7d) at /usr/include/bits/string3.h:51
> > #2  = gtrgm_alloc (isalltrue=3D<optimized out>, siglen=3Dsiglen@entr= y=3D12, sign=3D0x7023c19c7 <Address 0x7023c19c7 out of bounds>) a= t trgm_gist.c:82
> > #3  0x00007f42aee25d80 in= gtrgm_picksplit (fcinfo=3D<optimized out>) at trgm_gist.c:852
> > #4  0x00000000008afcfa in FunctionCall2Coll (fli= nfo=3Dflinfo@entry=3D0x2bf9400, collation=3D<optimized out>= ;, arg1=3Darg1@entry=3D43095272, arg2=3Darg2@entry=3D1407= 37194144480) at fmgr.c:1164
> > #5  0x00000000= 004b2d03 in gistUserPicksplit (len=3D2, giststate=3D0x2bf75d8, itup=3D0x291= 93c8, v=3D0x7fffee76b2e0, attno=3D0, entryvec=3D0x29194e8, r=3D0x7f42aecd36= 68) at gistsplit.c:433
>
> Commit= 911e702077 ("Implement operator class parameters") seems like
> the most likely culprit, based on a quick "git blame". Alexander= ?



As I can se= e from the bug report, the affected version is 13.1.  I
think this bug is already fixed by 48ab1fa304 in 13.2.

------
Regards,
Al= exander Korotkov

------=_Part_1336765_295522163.1635169758800--