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 1mcXFD-0003U8-GL for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Oct 2021 18:20:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mcXFC-0006xU-77 for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Oct 2021 18:20:18 +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 1mcXFB-0006ta-Eq for pgsql-bugs@lists.postgresql.org; Mon, 18 Oct 2021 18:20:17 +0000 Received: from sonic310-24.consmr.mail.ne1.yahoo.com ([66.163.186.205]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mcXF7-0001Nn-S2 for pgsql-bugs@lists.postgresql.org; Mon, 18 Oct 2021 18:20:17 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1634581210; bh=cCrEQiczLhPR9+uIpsR13hjv23wYuZbEE9/gKRbFgkA=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=X2llsKHS+ObHYEj7feJTfOqzAhinqWcMdu2jTtwcGRNFfLRAg4Lg9pBu82N2oysNnbTuuva260JQRhpIi3R+fCZrF+SEFAMdYECgSoUAEH8Tb7smJK63ky3vVMpq6ekllT6ZltxLfvM9Xu+Py1v2j9kMPL8Vuexoa43cDxxsOL0KHi/Cq2g+UMWoFPrZs/EgIeVNYVx+zHhSia6RNPWVNSRh1tM51ycI2VKvv2hM0pvUBdCPRzQiL4C0BJJh5rknZRYfgpIBbxXrcXKrB5PT0eyxgqxCJYsHVdsdWi3Ii/FgHfS28dcWScr+0fOsDbXw+WJo+8FtLNbFcIE+FOp3Wg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1634581210; bh=BUnF9aGXY8vKyvTDmoGUtS0y27VX/SgkFZgbmwXYxrP=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=cg0XX2wO7RnWPOoMvts9S0jXLCcsZFtnQqInGVmks313vPl+IK/IpzNOeD2anqCcofS0Ictt/Kx3eljpqX/xXAItm9drh9mWIRPf5hC7VjhsjX1ezFlfXqb+1YGegS7qVgC+rzTZ4HTgkJm51pf3bo3r0xMvpJwZD+UCNreeUcd3bqvIl0MTHJEQQy2cRlLelBY3lmViuZoaCf5GoZ38TmVgoGZ3AZDvp0Zbqa5O7mkXeiyUtxhhzNaPd0QFayIocrcdF1GXvZ6PfsRB8VB+7OgnN4mF30HTK2cK+LWvjFgoRQt6Xa+PEHYv9zpgS+KTlIU7p8SZqMWWpQHl2anthg== X-YMail-OSG: .JqIHN0VM1miNYPHBhd5HzBiV9gCAnjlWdDboKTMKUyLwb8L.cd68B1JBz7m.NR ZnOhSunbQlJzSEKeZAluFX6X5K6VySpJje86QUl6kIS.YrhnGxr3JyQN0QCZoZR3rpqERlUSx6hF 6U.vWQfkiGRT23A3syMwDoPPFF62tCGxSzwFhtg61SVPE5oQtc3F2ngNKPfSTsc.VwPzbbCLdj1q k0NX_OY7f20Xm39rHSbxv5qdg3iyxyb2qbHhqtbFngmfWWhTE_mTQWMPFfQD0pKM9ttza_stcUxW eDYU464YPyy9rWX6mo.N1RKU8GcvtJcM5vTw04PpfWDnzlR6U.1p3_p5OJXwTl5HyS3.T4ekla1Q tiwPO3jBPSfYqIl3JF9pguT25m0wQGijsFGyuQXpJk1xvXuj8zvt7U1ws2yXTrmNlWoGHT.nHD7. wxIYMTvfVbdl.s3jfG5UGm0.zsB_o3UW__wDtOu0tylXVy3h1pnKn13RzJP6dXFSjQd5o6ydXivp vZKw1rYr1BggzAtyKYkcNm6QcHSdpqrkMEFX.qku1gSQsOstYEyD4GWWArGgl.Gy16GynV8rvQi0 FT8xjOFb.fYeGdL3VGAhfhUogQS3vrx_FK9Lw42RM6gTPCUQBeg9V_Md98xi5DKtTjDIxBpMgEpx vwSbt2YFfECCBTVdAuFQbrSue_L7TREkKC.dADYUEPjAH_zvWsPAQRoTdmOLFmojFkKRLYqD0.iy 0hqybIwhEy0CVnY.l9Z9jr.KB8DDRoPCXLFrtY5U97Oxvcmh2Qxv9IcCatfjIBMTo8JluEvtLlN6 RyTlRy9uWTAkzJDpV96ljAQLuyqwoIbIBYMWTcweSr1LyaW0W9w9tW77XzZptC0V5WIdeS1hip3g 9o_VfYs0.tQycctUtHOwXWvVtX3Rt3pQsZejNkkPHID8gGW26MK.5Oi8tYVIIMoac9t9sqTBMyr_ w0flF4HImmYwUBysKmWTwUzwcUmZf8KR5P6Y8dR71tTcvFBhjO6Wz8hsAWvW3XLTiGO1yGr3ukW9 a6LPjXVQaA6sa0NObpdRsjZgxBY.UDHSfP8uwW.c7yzCTusN17ptE3E_y61Hv5mfCiYvj7YFAxgP bp6oUQTMnlLB4bFDfyc8jYmW3tF3ehC7bg3HJckh2fvNJTTwbORx.0rEcIycmRI2ascxzsCfEVR8 quR._WKIbaGIrB1EN.nDSuIIzHRAj5khMvBO3eqpGsTc92l3YXhPiVrej.SQueCdh_uFUWiB3A3y eu4wZwAcK0mwx_H4Eq4WnkQ3aAe44e8SqwK__LdnSDJNOE.LsXrtZ9j3Huo2A5NXXS44jqgV.gpE GVAjT7mHhc2CtAILwy4GJnEQi2589sImi_69pqflyIFUceV15BnCSY8sDocD6QxN3cVyy7W7wNuT g0d_x5YyImUNVKJ1vfKEa2By61ThWCB4HI9QCxyRpeVQsvw0ERs06PiYJ2a.FVg4gVR15QlJNrVX 9Q14PYR1YPWsQdmDvdXZGdLgcmBjRJGkh50qWrcMXdm02tqCVTC4Vqvz9vhS4.pCFB3AVmYOI_Zg H6qEXyKWpEYapiBWN4QoQzUWqS5g.yxi2IAHfXsXCUtmSzn_EZy8ukECvfkhXblbUfaAZKmWDxgu Jn1_TpYilrlaQewapzhII69Z_EtC_mtDTP6SyzJIDygdHPuXaI_5p3F4PtBqpQA70DDS5qmVxXdP QfO1OAyVM1K.xNhnDt5OfGraa5s1HnJVJ2Ufj9Lfow56jWkYf03vlSphI418963h32pondMdrTWr yXvYJo8dQA2yf4X0UAoqBiJMeD3SJWY9GwL5pGwzL8LWiydDHYHOXYrWVex7dgUMz16Ny8Xq3eMO dhDuaXjtWO6VWorRwTL9UTCM6AlrAErBAYMmtChD8BRz4Qc3VvISWqKbYYsX85wThhnhRtLKixxc 9i.QflPPFFL7XY5tx_8zolst2S53NsygXyDVgiYYYY8.nO1QPP0O1LLNdUi2ziaePYgCWbHhftT3 1mY_s16UbVHaGuD_lP7Unh4mC9is1uT5sOjb7nxK7_LvHatvISGhPq6CC7IxYPzeVyywnDpgHFck znySI30YmiHfBpYz_fge.oMnPo6GkFr29mV.VanNO3UtzEAHfPUdvc2QoQCEnNH7Y9D7mTjacwp6 j5aClWih.EN0tT_k_JN1MUalOMDXv3TFEEFtK3owGwGaqXqEoYQ8OPA1EWSgttR9K1hpZuE2f282 rfGAbOKJRS61esi0KEqqaytj6rfdDPnj. X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.ne1.yahoo.com with HTTP; Mon, 18 Oct 2021 18:20:10 +0000 Date: Mon, 18 Oct 2021 18:20:07 +0000 (UTC) From: "Efrain J. Berdecia" To: Tom Lane Cc: "pgsql-bugs@lists.postgresql.org" Message-ID: <1462498010.4276407.1634581207093@mail.yahoo.com> In-Reply-To: <666112.1634154922@sss.pgh.pa.us> References: <17229-bc836b4d1d2633bf@postgresql.org> <666112.1634154922@sss.pgh.pa.us> Subject: Re: BUG #17229: Segmentation Fault after upgrading to version 13 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4276406_1774252209.1634581207088" X-Mailer: WebService/1.1.19116 YMailNorrin Content-Length: 26407 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_4276406_1774252209.1634581207088 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable This is what we see; postgres@dtord03pgm25p:/localpart0/db/postgres/13/campaign_service/data>gdb= -c /localpart0/db/postgres/13/campaign_service/data/core.28085.sig11.16343= 28354s /usr/pgsql-13/bin/postgresGNU gdb (GDB) Red Hat Enterprise Linux 7.6= .1-120.el7Copyright (C) 2013 Free Software Foundation, Inc.License GPLv3+: = GNU GPL version 3 or later This is free s= oftware: you are free to change and redistribute it.There is NO WARRANTY, t= o the extent permitted by law.=C2=A0 Type "show copying"and "show warranty"= for details.This GDB was configured as "x86_64-redhat-linux-gnu".For bug r= eporting instructions, please see:..= .Reading symbols from /usr/pgsql-13/bin/postgres...Reading symbols from /us= r/lib/debug/usr/pgsql-13/bin/postgres.debug...done.done.[New LWP 28085][Thr= ead debugging using libthread_db enabled]Using host libthread_db library "/= lib64/libthread_db.so.1". warning: the debug information found in "/usr/lib/debug//usr/pgsql-11/lib/l= ibpq.so.5.11.debug" does not match "/usr/pgsql-11/lib/libpq.so.5" (CRC mism= atch). warning: the debug information found in "/usr/lib/debug/usr/pgsql-11/lib/li= bpq.so.5.11.debug" does not match "/usr/pgsql-11/lib/libpq.so.5" (CRC misma= tch). Core was generated by `postgres: campaign_service: generic_toolkit_utility = bi_tools 10.110.149.55(4096'.Program terminated with signal 11, Segmentatio= n fault.#0=C2=A0 __memcpy_ssse3_back () at ../sysdeps/x86_64/multiarch/memc= py-ssse3-back.S:18521852=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 mov=C2=A0= =C2=A0 =C2=A0-12(%rsi), %rdxMissing separate debuginfos, use: debuginfo-in= stall llvm5.0-libs-5.0.1-7.el7.x86_64 pg_partman13-4.4.0-1.rhel7.x86_64 pos= tgresql11-libs-11.10-1PGDG.rhel7.x86_64 repmgr_13-5.2.1-1.rhel7.x86_64(gdb)= bt#0=C2=A0 __memcpy_ssse3_back () at ../sysdeps/x86_64/multiarch/memcpy-ss= se3-back.S:1852#1=C2=A0 0x00007f42aee2488b in memcpy (__len=3D12, __src=3D0= x7023c19c7, __dest=3D0x291967d) at /usr/include/bits/string3.h:51#2=C2=A0 g= trgm_alloc (isalltrue=3D, siglen=3Dsiglen@entry=3D12, sign= =3D0x7023c19c7
) at trgm_gist.c:82#3=C2= =A0 0x00007f42aee25d80 in gtrgm_picksplit (fcinfo=3D) at trg= m_gist.c:852#4=C2=A0 0x00000000008afcfa in FunctionCall2Coll (flinfo=3Dflin= fo@entry=3D0x2bf9400, collation=3D, arg1=3Darg1@entry=3D4309= 5272, arg2=3Darg2@entry=3D140737194144480) at fmgr.c:1164#5=C2=A0 0x0000000= 0004b2d03 in gistUserPicksplit (len=3D2, giststate=3D0x2bf75d8, itup=3D0x29= 193c8, v=3D0x7fffee76b2e0, attno=3D0, entryvec=3D0x29194e8, r=3D0x7f42aecd3= 668) at gistsplit.c:433#6=C2=A0 gistSplitByKey (r=3Dr@entry=3D0x7f42aecd366= 8, page=3Dpage@entry=3D0x2aaad2a7b500
, itup=3Ditup@entry=3D0x29193c8, len=3Dlen@entry=3D2, giststate=3Dgiststat= e@entry=3D0x2bf75d8,=C2=A0 =C2=A0 v=3Dv@entry=3D0x7fffee76b2e0, attno=3Datt= no@entry=3D0) at gistsplit.c:697#7=C2=A0 0x00000000004aa045 in gistSplit (r= =3Dr@entry=3D0x7f42aecd3668, page=3Dpage@entry=3D0x2aaad2a7b500
, itup=3Ditup@entry=3D0x29193c8, len=3D2,=C2=A0 = =C2=A0 giststate=3Dgiststate@entry=3D0x2bf75d8) at gist.c:1443#8=C2=A0 0x00= 000000004aa0fe in gistSplit (r=3Dr@entry=3D0x7f42aecd3668, page=3Dpage@entr= y=3D0x2aaad2a7b500
, itup=3Ditup@entr= y=3D0x29190b8, len=3D,=C2=A0 =C2=A0 giststate=3Dgiststate@en= try=3D0x2bf75d8) at gist.c:1473#9=C2=A0 0x00000000004aa0d6 in gistSplit (r= =3Dr@entry=3D0x7f42aecd3668, page=3Dpage@entry=3D0x2aaad2a7b500
, itup=3Ditup@entry=3D0x2918c08, len=3D,=C2=A0 =C2=A0 giststate=3Dgiststate@entry=3D0x2bf75d8) at gist.c:145= 8#10 0x00000000004aa0fe in gistSplit (r=3Dr@entry=3D0x7f42aecd3668, page=3D= page@entry=3D0x2aaad2a7b500
, itup=3D= , len=3D,=C2=A0 =C2=A0 giststate=3Dgiststate@= entry=3D0x2bf75d8) at gist.c:1473#11 0x00000000004aa3d9 in gistplacetopage = (rel=3D0x7f42aecd3668, freespace=3D0, giststate=3Dgiststate@entry=3D0x2bf75= d8, buffer=3D15844, itup=3Ditup@entry=3D0x7fffee76c018, ntup=3Dntup@entry= =3D1,=C2=A0 =C2=A0 oldoffnum=3Doldoffnum@entry=3D0, newblkno=3Dnewblkno@ent= ry=3D0x0, leftchildbuf=3Dleftchildbuf@entry=3D0, splitinfo=3Dsplitinfo@entr= y=3D0x7fffee76bf60, markfollowright=3Dmarkfollowright@entry=3Dtrue,=C2=A0 = =C2=A0 heapRel=3D0x7f42aecaffb0, is_build=3Dfalse) at gist.c:303#12 0x00000= 000004aaeda in gistinserttuples (state=3Dstate@entry=3D0x7fffee76c050, stac= k=3Dstack@entry=3D0x2918a98, giststate=3Dgiststate@entry=3D0x2bf75d8, tuple= s=3Dtuples@entry=3D0x7fffee76c018, ntup=3Dntup@entry=3D1,=C2=A0 =C2=A0 oldo= ffnum=3Doldoffnum@entry=3D0, leftchild=3Dleftchild@entry=3D0, rightchild=3D= rightchild@entry=3D0, unlockbuf=3Dunlockbuf@entry=3Dfalse, unlockleftchild= =3Dunlockleftchild@entry=3Dfalse) at gist.c:1271#13 0x00000000004ab5cf in g= istinserttuple (oldoffnum=3D0, tuple=3D0x2916628, giststate=3D0x2bf75d8, st= ack=3D, state=3D0x7fffee76c050) at gist.c:1224#14 gistdoinse= rt (r=3Dr@entry=3D0x7f42aecd3668, itup=3D0x2916628, freespace=3Dfreespace@e= ntry=3D0, giststate=3Dgiststate@entry=3D0x2bf75d8, heapRel=3DheapRel@entry= =3D0x7f42aecaffb0, is_build=3Dis_build@entry=3Dfalse)=C2=A0 =C2=A0 at gist.= c:880#15 0x00000000004abe57 in gistinsert (r=3D0x7f42aecd3668, values=3D, isnull=3D, ht_ctid=3D0x263db48, heapRel=3D0x7f= 42aecaffb0, checkUnique=3D, indexInfo=3D0x263d850)=C2=A0 =C2= =A0 at gist.c:180#16 0x000000000062be6a in ExecInsertIndexTuples (slot=3Dsl= ot@entry=3D0x263db18, estate=3Destate@entry=3D0x263d1c8, noDupErr=3DnoDupEr= r@entry=3Dfalse, specConflict=3DspecConflict@entry=3D0x0,=C2=A0 =C2=A0 arbi= terIndexes=3DarbiterIndexes@entry=3D0x0) at execIndexing.c:393#17 0x0000000= 00065561a in ExecInsert (mtstate=3Dmtstate@entry=3D0x263d598, slot=3D0x263d= b18, planSlot=3D0x263db18, estate=3Destate@entry=3D0x263d1c8, canSetTag=3D<= optimized out>) at nodeModifyTable.c:624#18 0x00000000006569d9 in ExecModif= yTable (pstate=3D0x263d598) at nodeModifyTable.c:2246#19 0x000000000062caa2= in ExecProcNode (node=3D0x263d598) at ../../../src/include/executor/execut= or.h:248#20 ExecutePlan (execute_once=3D, dest=3D0x9fb620 , direction=3D, numberTuples=3D0, sendTuples= =3Dfalse, operation=3DCMD_INSERT, use_parallel_mode=3D,=C2= =A0 =C2=A0 planstate=3D0x263d598, estate=3D0x263d1c8) at execMain.c:1646#21= standard_ExecutorRun (queryDesc=3D0x29ae260, direction=3D, = count=3D0, execute_once=3D) at execMain.c:364#22 0x00007f42a= f46439d in pgss_ExecutorRun (queryDesc=3D0x29ae260, direction=3DForwardScan= Direction, count=3D0, execute_once=3D) at pg_stat_statements= .c:1045#23 0x0000000000664e17 in _SPI_pquery (tcount=3D0, fire_triggers=3Dt= rue, queryDesc=3D) at spi.c:2511#24 _SPI_execute_plan (plan= =3Dplan@entry=3D0x7fffee76c720, paramLI=3DparamLI@entry=3D0x0, snapshot=3Ds= napshot@entry=3D0x0, crosscheck_snapshot=3Dcrosscheck_snapshot@entry=3D0x0,= read_only=3Dread_only@entry=3Dfalse,=C2=A0 =C2=A0 fire_triggers=3Dfire_tri= ggers@entry=3Dtrue, tcount=3Dtcount@entry=3D0) at spi.c:2288#25 0x000000000= 0665079 in SPI_execute (src=3Dsrc@entry=3D0x258c258 " \nDELETE FROM gp_meta= data_gpso.tables;\nINSERT INTO gp_metadata_gpso.tables\nSELECT * FROM table= s_tmp;\n", read_only=3D,=C2=A0 =C2=A0 tcount=3Dtcount@entry= =3D0) at spi.c:514#26 0x00007f42af04138e in exec_stmt_dynexecute (stmt=3D0x= 25bdaf8, estate=3D0x7fffee76cbe0) at pl_exec.c:4429#27 exec_stmt (estate=3D= estate@entry=3D0x7fffee76cbe0, stmt=3D0x25bdaf8) at pl_exec.c:2056#28 0x000= 07f42af0428e3 in exec_stmts (estate=3D0x7fffee76cbe0, stmts=3D0x25bdb48) at= pl_exec.c:1943#29 0x00007f42af042f22 in exec_stmt_block (estate=3Destate@e= ntry=3D0x7fffee76cbe0, block=3Dblock@entry=3D0x25bdb98) at pl_exec.c:1884#3= 0 0x00007f42af0408ee in exec_stmt (estate=3Destate@entry=3D0x7fffee76cbe0, = stmt=3D0x25bdb98) at pl_exec.c:1976#31 0x00007f42af042448 in plpgsql_exec_f= unction (func=3Dfunc@entry=3D0x29636f8, fcinfo=3Dfcinfo@entry=3D0x25567b0, = simple_eval_estate=3Dsimple_eval_estate@entry=3D0x0,=C2=A0 =C2=A0 simple_ev= al_resowner=3Dsimple_eval_resowner@entry=3D0x0, atomic=3Datomic@entry=3Dtru= e) at pl_exec.c:610#32 0x00007f42af04d286 in plpgsql_call_handler (fcinfo= =3D0x25567b0) at pl_handler.c:265#33 0x000000000062848f in ExecInterpExpr (= state=3D0x25566d8, econtext=3D0x2556400, isnull=3D) at execE= xprInterp.c:675#34 0x0000000000658a1f in ExecEvalExprSwitchContext (isNull= =3D0x7fffee76ceb7, econtext=3D0x2556400, state=3D0x25566d8) at ../../../src= /include/executor/executor.h:316#35 ExecProject (projInfo=3D0x25566d0) at .= ./../../src/include/executor/executor.h:350#36 ExecResult (pstate=3D) at nodeResult.c:136#37 0x000000000062caa2 in ExecProcNode (node= =3D0x25562f0) at ../../../src/include/executor/executor.h:248#38 ExecutePla= n (execute_once=3D, dest=3D0x2976218, direction=3D, numberTuples=3D0, sendTuples=3Dtrue, operation=3DCMD_SELECT, use_par= allel_mode=3D, planstate=3D0x25562f0,=C2=A0 =C2=A0 estate=3D= 0x25560c8) at execMain.c:1646#39 standard_ExecutorRun (queryDesc=3D0x269a44= 8, direction=3D, count=3D0, execute_once=3D) = at execMain.c:364#40 0x00007f42af46439d in pgss_ExecutorRun (queryDesc=3D0x= 269a448, direction=3DForwardScanDirection, count=3D0, execute_once=3D) at pg_stat_statements.c:1045---Type to continue, or q <= return> to quit---#41 0x000000000079071b in PortalRunSelect (portal=3Dporta= l@entry=3D0x2512588, forward=3Dforward@entry=3Dtrue, count=3D0, count@entry= =3D9223372036854775807, dest=3Ddest@entry=3D0x2976218) at pquery.c:912#42 0= x0000000000791a07 in PortalRun (portal=3D, count=3D922337203= 6854775807, isTopLevel=3D, run_once=3D, dest= =3D0x2976218, altdest=3D0x2976218, qc=3D0x7fffee76d240)=C2=A0 =C2=A0 at pqu= ery.c:756#43 0x000000000078d6c7 in exec_simple_query (query_string=3D) at postgres.c:1239#44 0x000000000078ea37 in PostgresMain (argc= =3D, argv=3D, dbname=3D, usern= ame=3D) at postgres.c:4315#45 0x00000000004879d4 in BackendR= un (port=3D, port=3D) at postmaster.c:4536#46= BackendStartup (port=3D0x248ff50) at postmaster.c:4220#47 ServerLoop () at= postmaster.c:1739#48 0x0000000000718598 in PostmasterMain (argc=3Dargc@ent= ry=3D3, argv=3Dargv@entry=3D0x2462420) at postmaster.c:1412#49 0x0000000000= 48890d in main (argc=3D3, argv=3D0x2462420) at main.c:210 Thanks,Efrain J. Berdecia=20 On Wednesday, October 13, 2021, 03:55:25 PM EDT, Tom Lane wrote: =20 =20 PG Bug reporting form writes: > Ever since we upgraded to PostgreSQL version 13 we are sporadically getti= ng > segmentation faults for the following process and all existing connection= s > get killed and our streaming replication process goes down. Hmm, can you get a stack trace from the crash?=C2=A0 See https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_b= ackend =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0 regards, tom lane =20 ------=_Part_4276406_1774252209.1634581207088 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
This is what we see;

postgres@dtord03pgm25p:/localpart0/db/postgres/13/camp= aign_service/data>gdb -c /localpart0/db/postgres/13/campaign_service/dat= a/core.28085.sig11.1634328354s /usr/pgsql-13/bin/postgres
GNU gdb= (GDB) Red Hat Enterprise Linux 7.6.1-120.el7
Copyright (C) 2013 = Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 = or later <http://gnu.org/licenses/gpl.html>
This is free so= ftware: you are free to change and redistribute it.
There is NO W= ARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x8= 6_64-redhat-linux-gnu".
For bug reporting instructions, please se= e:
<http://www.gnu.org/software/gdb/bugs/>...
Rea= ding symbols from /usr/pgsql-13/bin/postgres...Reading symbols from /usr/li= b/debug/usr/pgsql-13/bin/postgres.debug...done.
done.
[= New LWP 28085]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".

warning: the debug information found in "/usr/lib/debug//us= r/pgsql-11/lib/libpq.so.5.11.debug" does not match "/usr/pgsql-11/lib/libpq= .so.5" (CRC mismatch).


warning: the= debug information found in "/usr/lib/debug/usr/pgsql-11/lib/libpq.so.5.11.= debug" does not match "/usr/pgsql-11/lib/libpq.so.5" (CRC mismatch).
<= div>
Core was generated by `postgres: campaign_service: gener= ic_toolkit_utility bi_tools 10.110.149.55(4096'.
Program terminat= ed with signal 11, Segmentation fault.
#0  __memcpy_ssse3_ba= ck () at ../sysdeps/x86_64/multiarch/memcpy-ssse3-back.S:1852
185= 2            mov     -12(%rsi)= , %rdx
Missing separate debuginfos, use: debuginfo-install llvm5.= 0-libs-5.0.1-7.el7.x86_64 pg_partman13-4.4.0-1.rhel7.x86_64 postgresql11-li= bs-11.10-1PGDG.rhel7.x86_64 repmgr_13-5.2.1-1.rhel7.x86_64
(gdb) = bt
#0  __memcpy_ssse3_back () at ../sysdeps/x86_64/multiarch= /memcpy-ssse3-back.S:1852
#1  0x00007f42aee2488b in memcpy (= __len=3D12, __src=3D0x7023c19c7, __dest=3D0x291967d) at /usr/include/bits/s= tring3.h:51
#2  gtrgm_alloc (isalltrue=3D<optimized out&g= t;, siglen=3Dsiglen@entry=3D12, sign=3D0x7023c19c7 <Address 0x7023c19c7 = out of bounds>) at trgm_gist.c:82
#3  0x00007f42aee25d80 = in gtrgm_picksplit (fcinfo=3D<optimized out>) at trgm_gist.c:852
#4  0x00000000008afcfa in FunctionCall2Coll (flinfo=3Dflinfo@ent= ry=3D0x2bf9400, collation=3D<optimized out>, arg1=3Darg1@entry=3D4309= 5272, arg2=3Darg2@entry=3D140737194144480) at fmgr.c:1164
#5 = ; 0x00000000004b2d03 in gistUserPicksplit (len=3D2, giststate=3D0x2bf75d8, = itup=3D0x29193c8, v=3D0x7fffee76b2e0, attno=3D0, entryvec=3D0x29194e8, r=3D= 0x7f42aecd3668) at gistsplit.c:433
#6  gistSplitByKey (r=3Dr= @entry=3D0x7f42aecd3668, page=3Dpage@entry=3D0x2aaad2a7b500 <Address 0x2= aaad2a7b500 out of bounds>, itup=3Ditup@entry=3D0x29193c8, len=3Dlen@ent= ry=3D2, giststate=3Dgiststate@entry=3D0x2bf75d8,
    v= =3Dv@entry=3D0x7fffee76b2e0, attno=3Dattno@entry=3D0) at gistsplit.c:697
#7  0x00000000004aa045 in gistSplit (r=3Dr@entry=3D0x7f42aecd3= 668, page=3Dpage@entry=3D0x2aaad2a7b500 <Address 0x2aaad2a7b500 out of b= ounds>, itup=3Ditup@entry=3D0x29193c8, len=3D2,
    = giststate=3Dgiststate@entry=3D0x2bf75d8) at gist.c:1443
#8  = 0x00000000004aa0fe in gistSplit (r=3Dr@entry=3D0x7f42aecd3668, page=3Dpage@= entry=3D0x2aaad2a7b500 <Address 0x2aaad2a7b500 out of bounds>, itup= =3Ditup@entry=3D0x29190b8, len=3D<optimized out>,
  &n= bsp; giststate=3Dgiststate@entry=3D0x2bf75d8) at gist.c:1473
#9&n= bsp; 0x00000000004aa0d6 in gistSplit (r=3Dr@entry=3D0x7f42aecd3668, page=3D= page@entry=3D0x2aaad2a7b500 <Address 0x2aaad2a7b500 out of bounds>, i= tup=3Ditup@entry=3D0x2918c08, len=3D<optimized out>,
 =   giststate=3Dgiststate@entry=3D0x2bf75d8) at gist.c:1458
#= 10 0x00000000004aa0fe in gistSplit (r=3Dr@entry=3D0x7f42aecd3668, page=3Dpa= ge@entry=3D0x2aaad2a7b500 <Address 0x2aaad2a7b500 out of bounds>, itu= p=3D<optimized out>, len=3D<optimized out>,
  &n= bsp; giststate=3Dgiststate@entry=3D0x2bf75d8) at gist.c:1473
#11 = 0x00000000004aa3d9 in gistplacetopage (rel=3D0x7f42aecd3668, freespace=3D0,= giststate=3Dgiststate@entry=3D0x2bf75d8, buffer=3D15844, itup=3Ditup@entry= =3D0x7fffee76c018, ntup=3Dntup@entry=3D1,
    oldoffnum= =3Doldoffnum@entry=3D0, newblkno=3Dnewblkno@entry=3D0x0, leftchildbuf=3Dlef= tchildbuf@entry=3D0, splitinfo=3Dsplitinfo@entry=3D0x7fffee76bf60, markfoll= owright=3Dmarkfollowright@entry=3Dtrue,
    heapRel=3D0= x7f42aecaffb0, is_build=3Dfalse) at gist.c:303
#12 0x00000000004a= aeda in gistinserttuples (state=3Dstate@entry=3D0x7fffee76c050, stack=3Dsta= ck@entry=3D0x2918a98, giststate=3Dgiststate@entry=3D0x2bf75d8, tuples=3Dtup= les@entry=3D0x7fffee76c018, ntup=3Dntup@entry=3D1,
    = oldoffnum=3Doldoffnum@entry=3D0, leftchild=3Dleftchild@entry=3D0, rightchil= d=3Drightchild@entry=3D0, unlockbuf=3Dunlockbuf@entry=3Dfalse, unlockleftch= ild=3Dunlockleftchild@entry=3Dfalse) at gist.c:1271
#13 0x0000000= 0004ab5cf in gistinserttuple (oldoffnum=3D0, tuple=3D0x2916628, giststate= =3D0x2bf75d8, stack=3D<optimized out>, state=3D0x7fffee76c050) at gis= t.c:1224
#14 gistdoinsert (r=3Dr@entry=3D0x7f42aecd3668, itup=3D0= x2916628, freespace=3Dfreespace@entry=3D0, giststate=3Dgiststate@entry=3D0x= 2bf75d8, heapRel=3DheapRel@entry=3D0x7f42aecaffb0, is_build=3Dis_build@entr= y=3Dfalse)
    at gist.c:880
#15 0x0000000000= 4abe57 in gistinsert (r=3D0x7f42aecd3668, values=3D<optimized out>, i= snull=3D<optimized out>, ht_ctid=3D0x263db48, heapRel=3D0x7f42aecaffb= 0, checkUnique=3D<optimized out>, indexInfo=3D0x263d850)
&n= bsp;   at gist.c:180
#16 0x000000000062be6a in ExecInsertInd= exTuples (slot=3Dslot@entry=3D0x263db18, estate=3Destate@entry=3D0x263d1c8,= noDupErr=3DnoDupErr@entry=3Dfalse, specConflict=3DspecConflict@entry=3D0x0= ,
    arbiterIndexes=3DarbiterIndexes@entry=3D0x0) at e= xecIndexing.c:393
#17 0x000000000065561a in ExecInsert (mtstate= =3Dmtstate@entry=3D0x263d598, slot=3D0x263db18, planSlot=3D0x263db18, estat= e=3Destate@entry=3D0x263d1c8, canSetTag=3D<optimized out>) at nodeMod= ifyTable.c:624
#18 0x00000000006569d9 in ExecModifyTable (pstate= =3D0x263d598) at nodeModifyTable.c:2246
#19 0x000000000062caa2 in= ExecProcNode (node=3D0x263d598) at ../../../src/include/executor/executor.= h:248
#20 ExecutePlan (execute_once=3D<optimized out>, dest= =3D0x9fb620 <spi_printtupDR>, direction=3D<optimized out>, numb= erTuples=3D0, sendTuples=3Dfalse, operation=3DCMD_INSERT, use_parallel_mode= =3D<optimized out>,
    planstate=3D0x263d598, es= tate=3D0x263d1c8) at execMain.c:1646
#21 standard_ExecutorRun (qu= eryDesc=3D0x29ae260, direction=3D<optimized out>, count=3D0, execute_= once=3D<optimized out>) at execMain.c:364
#22 0x00007f42af4= 6439d in pgss_ExecutorRun (queryDesc=3D0x29ae260, direction=3DForwardScanDi= rection, count=3D0, execute_once=3D<optimized out>) at pg_stat_statem= ents.c:1045
#23 0x0000000000664e17 in _SPI_pquery (tcount=3D0, fi= re_triggers=3Dtrue, queryDesc=3D<optimized out>) at spi.c:2511
<= div>#24 _SPI_execute_plan (plan=3Dplan@entry=3D0x7fffee76c720, paramLI=3Dpa= ramLI@entry=3D0x0, snapshot=3Dsnapshot@entry=3D0x0, crosscheck_snapshot=3Dc= rosscheck_snapshot@entry=3D0x0, read_only=3Dread_only@entry=3Dfalse,
<= div>    fire_triggers=3Dfire_triggers@entry=3Dtrue, tcount=3Dtcou= nt@entry=3D0) at spi.c:2288
#25 0x0000000000665079 in SPI_execute= (src=3Dsrc@entry=3D0x258c258 " \nDELETE FROM gp_metadata_gpso.tables;\nINS= ERT INTO gp_metadata_gpso.tables\nSELECT * FROM tables_tmp;\n", read_only= =3D<optimized out>,
    tcount=3Dtcount@entry=3D0= ) at spi.c:514
#26 0x00007f42af04138e in exec_stmt_dynexecute (st= mt=3D0x25bdaf8, estate=3D0x7fffee76cbe0) at pl_exec.c:4429
#27 ex= ec_stmt (estate=3Destate@entry=3D0x7fffee76cbe0, stmt=3D0x25bdaf8) at pl_ex= ec.c:2056
#28 0x00007f42af0428e3 in exec_stmts (estate=3D0x7fffee= 76cbe0, stmts=3D0x25bdb48) at pl_exec.c:1943
#29 0x00007f42af042f= 22 in exec_stmt_block (estate=3Destate@entry=3D0x7fffee76cbe0, block=3Dbloc= k@entry=3D0x25bdb98) at pl_exec.c:1884
#30 0x00007f42af0408ee in = exec_stmt (estate=3Destate@entry=3D0x7fffee76cbe0, stmt=3D0x25bdb98) at pl_= exec.c:1976
#31 0x00007f42af042448 in plpgsql_exec_function (func= =3Dfunc@entry=3D0x29636f8, fcinfo=3Dfcinfo@entry=3D0x25567b0, simple_eval_e= state=3Dsimple_eval_estate@entry=3D0x0,
    simple_eval= _resowner=3Dsimple_eval_resowner@entry=3D0x0, atomic=3Datomic@entry=3Dtrue)= at pl_exec.c:610
#32 0x00007f42af04d286 in plpgsql_call_handler = (fcinfo=3D0x25567b0) at pl_handler.c:265
#33 0x000000000062848f i= n ExecInterpExpr (state=3D0x25566d8, econtext=3D0x2556400, isnull=3D<opt= imized out>) at execExprInterp.c:675
#34 0x0000000000658a1f in= ExecEvalExprSwitchContext (isNull=3D0x7fffee76ceb7, econtext=3D0x2556400, = state=3D0x25566d8) at ../../../src/include/executor/executor.h:316
#35 ExecProject (projInfo=3D0x25566d0) at ../../../src/include/executor/e= xecutor.h:350
#36 ExecResult (pstate=3D<optimized out>) at = nodeResult.c:136
#37 0x000000000062caa2 in ExecProcNode (node=3D0= x25562f0) at ../../../src/include/executor/executor.h:248
#38 Exe= cutePlan (execute_once=3D<optimized out>, dest=3D0x2976218, direction= =3D<optimized out>, numberTuples=3D0, sendTuples=3Dtrue, operation=3D= CMD_SELECT, use_parallel_mode=3D<optimized out>, planstate=3D0x25562f= 0,
    estate=3D0x25560c8) at execMain.c:1646
#39 standard_ExecutorRun (queryDesc=3D0x269a448, direction=3D<optimized= out>, count=3D0, execute_once=3D<optimized out>) at execMain.c:36= 4
#40 0x00007f42af46439d in pgss_ExecutorRun (queryDesc=3D0x269a4= 48, direction=3DForwardScanDirection, count=3D0, execute_once=3D<optimiz= ed out>) at pg_stat_statements.c:1045
---Type <return> t= o continue, or q <return> to quit---
#41 0x000000000079071b= in PortalRunSelect (portal=3Dportal@entry=3D0x2512588, forward=3Dforward@e= ntry=3Dtrue, count=3D0, count@entry=3D9223372036854775807, dest=3Ddest@entr= y=3D0x2976218) at pquery.c:912
#42 0x0000000000791a07 in PortalRu= n (portal=3D<optimized out>, count=3D9223372036854775807, isTopLevel= =3D<optimized out>, run_once=3D<optimized out>, dest=3D0x297621= 8, altdest=3D0x2976218, qc=3D0x7fffee76d240)
    at pqu= ery.c:756
#43 0x000000000078d6c7 in exec_simple_query (query_stri= ng=3D<optimized out>) at postgres.c:1239
#44 0x000000000078= ea37 in PostgresMain (argc=3D<optimized out>, argv=3D<optimized ou= t>, dbname=3D<optimized out>, username=3D<optimized out>) at= postgres.c:4315
#45 0x00000000004879d4 in BackendRun (port=3D<= ;optimized out>, port=3D<optimized out>) at postmaster.c:4536
#46 BackendStartup (port=3D0x248ff50) at postmaster.c:4220
= #47 ServerLoop () at postmaster.c:1739
#48 0x0000000000718598 in = PostmasterMain (argc=3Dargc@entry=3D3, argv=3Dargv@entry=3D0x2462420) at po= stmaster.c:1412
#49 0x000000000048890d in main (argc=3D3, argv=3D= 0x2462420) at main.c:210


Thanks,
E= frain J. Berdecia


=20
=20
On Wednesday, October 13, 2021, 03:55:25 PM EDT, Tom La= ne <tgl@sss.pgh.pa.us> wrote:


PG Bug reporting form <noreply@postgresql.org> writes:

> Ever since we= upgraded to PostgreSQL version 13 we are sporadically getting
> segmentation faults for the following process and all existing c= onnections
> get killed and our streaming replication = process goes down.


Hmm, can you = get a stack trace from the crash?  See

= https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_b= ackend

     &n= bsp;      regards, tom lane

------=_Part_4276406_1774252209.1634581207088--