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 1luFYg-0000H3-Il for pgsql-admin@arkaria.postgresql.org; Fri, 18 Jun 2021 14:33:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1luFYf-0004qk-IS for pgsql-admin@arkaria.postgresql.org; Fri, 18 Jun 2021 14:33:21 +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 1luFYe-0004qb-Tu for pgsql-admin@lists.postgresql.org; Fri, 18 Jun 2021 14:33:21 +0000 Received: from sonic307-55.consmr.mail.gq1.yahoo.com ([98.137.64.31]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1luFYb-0007R3-Tc for pgsql-admin@lists.postgresql.org; Fri, 18 Jun 2021 14:33:20 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1624026794; bh=l5n7oEOH+O4L75sJIue0R8pJuqcyc39y2yidBdXTSf8=; h=From:Subject:Date:References:Cc:In-Reply-To:To:From:Subject:Reply-To; b=p7dY3EFKOvgIOxbugLbrxW028G2Lnd60wyKWFhz6U7VEjpmaZuxh7ShPCwoFKD4ihTl5yZybriJOBcAsN4d4nLJo1Q16R7Gm0KV7y3mAB53pVqY+h5VQAIFC0g7QHXHe2LjrHMtwOFUfs5cFTBCeTRwA1Wut8DTl3wQn0JM3iOkNHhBfnbMcldOVE5JEwY/k3roMgo0xMhnXo7oTczF93HiMkO32zONQms8FCj32y8ViE2en9rxiKPO57qUIwsJL7Xdyh5QVhURVewVnXhpJRx9o/XLcmKZ/vJmoBvjI7lTGrSEtccihiqheURhuYa3BYd5SNRwBCWppQL8E8NHXoA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1624026794; bh=cjXOcASRyKh/zHTeDDkv5IytSYUwH600h3S36mYAGwg=; h=X-Sonic-MF:From:Subject:Date:To:From:Subject; b=Vbft6OJua9hfmjudx7TtDxNzOm4axNd6BDtEzGwboCMj2Z6HN+1lwMp6no2dXuAfCl/junknGymQ6Ac+tthv1bMCTxLCvjVkSOBqelYbcOEKDEZJivzkaqtoyi21jnmxKzh6mpP+aOUoYCHLP6+AIXz0+ZbLtWhVgShdNcN5lGBmb7kOHUmyZGhKrhW2NsOcNDRKFu3uORbB1UNP9af1OOGKyi1SndisPfiKyAsnvTUHdWByCESHzkenOsoT9Mf50xbQMj9ObJg+LvszqgryV+GHh+Cu1T1XY/hi9FzKeB/gJ6dwHCjIqPvAapI0lib2k5pf6hRTX737vZFATeoJ7Q== X-YMail-OSG: sL7hiTsVM1lc.Y_aQ8JPP9U1QSO6G1xv5KJbpeSWDALFbNyVjpxXw69cd1hn7jX sEAAhbz7sO.9b513pVgjryNRx8TT.rtv5eucq0AnSdgH6sEmHC2awV2INICC5GObRsP3v7.Syqd9 Lhi4OEe4F0aZDCS5kquCoB87jCxASyfkEAVH2soxrcqX61IyLfhZiC.D0gWj2v95doCCRpbysIgl aVbmZlMxIH6ZoXyOd_UJmBLUxLiTaEJoPa5esgBltxq7EcYhv_M.kyThocdXwmVlm4Zv0535iCcp 9pvLHE6Cnx2S15Vek3vll1DuK7PjBwnDL2g8jzChDDj82HjUJ7H4qFn4iWdtdYnLMriImB7gpL9p UnTqeZXvS1cdL2dgLeIwoFZ7VHuT.MMwA6Wwxq9nDhOaISs3GI3mFHVGAMEH6tj4IEu0RWd6hT7h G45H2nK_ibsJZ.03K9YRzt1N0NjtViYX7wqEo7a8RNuqaTNJhcRBzifEC9bjaaKdHfgPfk_mGu25 jePjcxmmkpSBxLUn36RTU35OTDNHXFZG.5cOlAaIJXur2WcJT_6GM14rk4W4t_et4SWuyM7faSli tEOJc4pUSUcTVV7QNFv3Z9bGgnm3KmtFHqoTgWYosOpgQCh603l2PqWsgt5RUTHdPdau1g4LALGW eZNAxhWwV87XZp7yNW4EL4ewolnqt5Q9J0AFXWCmAez4q5eWQggrk3NTCEfHD_JQur_vctsbzhEq NKvvJIbeiUkuUuVmzaGAac0XieeOrNXMN1g3dF7h2gDDgy3c4eUd9Ro_CfOOpNIFdrDLAlZN.0Ri Uk6cpzZoZh.hfltZVMIZsxO6o4b3xQ8nAAh680C4D8haYZqXTIqDGerSMhuDkaBn.fB.7H.u.Dj2 FzKwwz7qAp3g_cewshdO.4T1Ycr7odCgu_5XJfDgd1q4dvnjBzinpX451fpl3__IuAUXVB.GPqqI oW3J5rcXLTWBYUDX2J8YAEuTplZrSSDEfDO66I7HY44n2wfvsS2tWpPfXR2TZsJwjWobCpg1ENEu giVqQqJ4uYCFmfq13jiIzIaVUniAL9Y6wC1jE0jsGZtkXbsDBS8fFKrrZhG2RVNrlU1JhIsS6HNv SRyIms3kyVDN2VH0R3yLdg.bobdKjYPXmaIFNKT6C13ehGLjp5enLfjd9YQvhm9.tYNOAAl2FLlr VrGL.3wFjoLVfVu60D2OgtH7oD_al7sIGBP9F_SlwH.sDI7PpH0wT18aZNZG.RGfljDcxIepyBSv LMgfHp45xq1AQbg33FFmjvifdqDlHBwWUT.oA0jFQMRmIRuE19TTHkf60fQEn13V0cDLPTrBhgTv rBsvFkavo7V1RtECSyncV4TV4ViBhVGtLm2t8OU_IzkqadR6WGqeZJV9dkMpRUVgSAEdFHJdoADL d.J7n1JrZkPCAsHY_nMUuPOI1ge5QkQ0GEiT5gN2PhrmoebnW.dY2zuGG4hHOdActShrXhCF.DPH mDjpR2wKs4S.cJe3d_82cs_zm4x9AR6hZcfHuA_Necu4x7ZvI_qC8bffeD2LVWj3J7CrzkTpt3zT C7fq6dPJ4To5hDVJXlx1c419wHBd6A.YAPDd0GSnzq3rUfKr2gJlhlV9s.M5awkR0IKiQ0AZkzLF PLGRZG40DjKAIgayPN_4IuKt3kLJchenYb8wnvwM5ljIzH.s9Xaq2pzQXMmbg7yQfcHgw2V6d4qo b__e4qd._VN1JiltkV2t.sKFAk1rIXlqYzjTMlM5Vd.8ZLXpl4VJEf.u01y2ILMrPwCFtW4IsqwN wMpORQ1Lcbxs1DID4Q0NtmpwrXbSY6.S8yRS5m9i0TQRUB2OJ_raTcGRLkjWdziyXpk7lXjD8g2g RCbNlWjHS9BFVKcn8jddS5xoK7zVi.gz0roNRY3qxeYRJ1JjWYuFAsJLKpj58uTX6Ij2Q2kWlko8 xDM8daMg8AfGMMM.PT6SYybXYBrpXdWlN9Yw6Ht7RZFyxBlsKhijBSo4dCaewIXn1zQJLAabpguW UYGZBVtBM_2Txs_AZreRPBNmWJzkOMHrR1A0ldeBEETlrZTZ4ueLcBzgjc1w8rvGNLyIr3aRZNgq QPyPX0gNljQqPenhqP5y5nVxc_cMkUhtmG2COMQMK51ezAw3D7L_B1B7kZNUIPhZW08hbcA.pGUR BXPTwnhBssvb8dGyFJYIw2UNSHmz3O05Wocidhzt_AEaDLhhBNrN1CeaBAvnXIKoNxh1z0_jPAm9 ETcTU73Aa2Ln2QsmFNOOJKmIBeG4.3e2AJWYNQydrw7XRm2gub149PNi.ar5m9LInO1KnEtXOcAX KDvpD7uDXqBjDmUuDgUUS3fITnvHUoW1TIJziH6Fk8oWktHGM04_JeqsRyMHMcPUJkWVRz6iqLv3 iIqNF4ILI7p_OuHQzv5W9SLiplyqT2hHj1l8I6QoMxRUGTjJewOfa4xsHX9sZJNVosGE0UAWgdG. jC6N9kjCKBf_IgkePdAIXWnkvhlKpfZ6O2yZq18x.PwKIMMwM30I.g9jh4nLhSag_etl.2B_Sumw TNLaDOxxCRYjl62t24q3dzAifL0HYjy1WGNSOBeXp278hX9bV3kD7qr0ZeKmV8kx_DNGmgEJ.f4K 8950- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic307.consmr.mail.gq1.yahoo.com with HTTP; Fri, 18 Jun 2021 14:33:14 +0000 Received: by kubenode501.mail-prod1.omega.sg3.yahoo.com (VZM Hermes SMTP Server) with ESMTPA ID cf7d9b59f2bcacf1ab64ac6537c5f12f; Fri, 18 Jun 2021 14:33:10 +0000 (UTC) Content-Type: multipart/alternative; boundary=Apple-Mail-8514349F-9754-40B5-A449-9017D117EBF9 Content-Transfer-Encoding: 7bit From: abbas alizadeh Mime-Version: 1.0 (1.0) Subject: Re: Kill postgresql process Date: Fri, 18 Jun 2021 22:33:08 +0800 Message-Id: <86429A65-AF41-40D4-8B7C-FDF6E45742A9@yahoo.com> References: <05a195d0d4fc09c4552551e806fd7692b9804e24.camel@cybertec.at> Cc: Julien Rouhaud , Pgsql-admin In-Reply-To: <05a195d0d4fc09c4552551e806fd7692b9804e24.camel@cybertec.at> To: Laurenz Albe X-Mailer: iPhone Mail (18F72) Content-Length: 4227 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-8514349F-9754-40B5-A449-9017D117EBF9 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Thanks Laurenz, Julien Stack trace helps alot to find a stuck point. That AbortCurrentTransaction wirked as well. Regards Abbas > On 15 Jun 2021, at 3:01 PM, Laurenz Albe wrote:= >=20 > =EF=BB=BFOn Tue, 2021-06-15 at 00:25 +0800, Julien Rouhaud wrote: >> Le mar. 15 juin 2021 =C3=A0 00:15, Laurenz Albe: >>> - Attach to the backend with gdb. >>> - Enter "print ProcessInterrupts()" >>>=20 >>> Of course that will not work if the backend is in uninterruptible >>> sleep (for example, stuck in an I/O operation). >>=20 >> that may be a terrible idea and leave a buffer pinned or something. >> and if it's not it won't tell us where we're missing a CALL_FOR_INTERRUPT= S >=20 > If there is an error, AbortCurrentTransaction() gets called, which release= s > all buffer pins. If you were stuck in an endless loop in a critical > section, you are going to crash anyway. >=20 > If you want to investigate where you are stuck, run a backtrace first. >=20 > Yours, > Laurenz Albe > --=20 > Cybertec | https://www.cybertec-postgresql.com >=20 >=20 >=20 --Apple-Mail-8514349F-9754-40B5-A449-9017D117EBF9 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Thanks Laurenz, Julien
Stack trace helps alot to find a stuck= point.
That AbortCurrentTransaction wirked as well.

Regards
Abbas


On 15 Jun 2021, at 3:01 PM, Laurenz Albe <laurenz.albe@cybertec= .at> wrote:

=EF=BB=BFOn Tue, 2021-06-15 at 00:25 +0800, Julien Rouhaud wrote= :
Le mar. 15 juin 2021 =C3=A0 00:1= 5, Laurenz Albe:
- Attach to the backend with gdb.
- E= nter "print ProcessInterrupts()"

<= /blockquote>
Of cou= rse that will not work if the backend is in uninterruptible
sleep (for example, stuck in an I/O operation).

that may be a terrible idea and leave a buffer pinned o= r something.
and if i= t's not it won't tell us where we're missing a CALL_FOR_INTERRUPTS

If there is an error, AbortCurrentTrans= action() gets called, which releases
all buffer pins.  = If you were stuck in an endless loop in a critical
section, y= ou are going to crash anyway.

If you want t= o investigate where you are stuck, run a backtrace first.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com



<= /html>= --Apple-Mail-8514349F-9754-40B5-A449-9017D117EBF9--