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 1seRCs-0077fs-Jd for pgsql-admin@arkaria.postgresql.org; Thu, 15 Aug 2024 03:31:22 +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 1seRCr-00ECki-3Z for pgsql-admin@arkaria.postgresql.org; Thu, 15 Aug 2024 03:31:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1seRCq-00ECkZ-OB for pgsql-admin@lists.postgresql.org; Thu, 15 Aug 2024 03:31:20 +0000 Received: from mail-oa1-x2b.google.com ([2001:4860:4864:20::2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1seRCo-004nfQ-4t for pgsql-admin@lists.postgresql.org; Thu, 15 Aug 2024 03:31:19 +0000 Received: by mail-oa1-x2b.google.com with SMTP id 586e51a60fabf-260f81f7fb5so379931fac.0 for ; Wed, 14 Aug 2024 20:31:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1723692677; x=1724297477; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Js9ORWUPk7UlRB/GaKB800GtwGkszpyoEBocKHUGHF8=; b=XDKkYrsCM/yYpK15YUSJDeQ6k+DdmJRB9sKf/U5RF6BnNYKktVR9eZlH2bGayed4R2 crQHR1zHot2I+HpQXoWIqyuxwfYFZR2H0VQ+BMdJ/wgiKLaOQEzu2Bc0rSeK9qsPykXb BkMZ9Hj9SNJ6IPYnJsjKkA9/hvjvuKza9xNB3Yo8h0HefTZOuDwqJP5Q2Nm8EbJ9iqlX UHdbbioR1sz002w+KetKegZ+DIP9YCr87t2BtMLspUYkS5FqhUTkAIsLy9nPMNzZvwiq e8JlSICk4MFH+PklkyZJo3X483pVS6i2XYoRfT0c0faz5APIdAhVtudjbsPx2FV5uTjo g4ig== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1723692677; x=1724297477; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Js9ORWUPk7UlRB/GaKB800GtwGkszpyoEBocKHUGHF8=; b=ivnAT8QocyBO19g6EK5Nhnqe4ZB5p6Y4hVh66ftaD7GOvbsHeHHcxy1ZRB61l+AoiZ O2Mk6r4I/teUAi3+qPWFWup5LF2Rsx9XyFLgqcDHt/prwSvqjuc+Qld3fI23bx8xpDEl 6qC2mrEIUxGCODjGDB3X8HPyP1We/svFHf6hU4jm3f4FUi+DW7Iz35E9dcf9SCYjVEn1 WYzY1kfr115FWpaaXIeZUQwp2U6o/1kuUUj8LBiaMJGDka4ZDP3xsnmbCqsap6HWw27R ZzLwKYYx5o4YXxU2O2AgJYg2cEBLskRtgq6PT9QgDjwSJ1Aje3OgK0dzHF6oZQcDeppa DabQ== X-Forwarded-Encrypted: i=1; AJvYcCXrQfQwCg8JMSMpIlSF+quLwe+ZaYW8j7CusIzMo8UGY+JeTq/yayT6KMhbDC/xRQpzKlU/okYVg+Ds6+XnNXbX3P5qhQ5PhDQhH0IMfYqzaA== X-Gm-Message-State: AOJu0YxIPDucSAo/McnTuS8TJb+wBmlu2rn2kAF8UcgATH6hNiG9AP5C lRHtZ9q+rH9r2At31y7DBH+AKrf4I9jNAUCVl2tqxc1FPSZC9Yuj3W96DZSt0XFtNxM99RmmCWs GJjgNFH75ZMgfCxtewCtQsNog1tw= X-Google-Smtp-Source: AGHT+IFPF+opi6PuBr2D++EleD3+z9Lqu5U+yHAqdCxiDIjLm8qLLyI2/ZIZjoR76P9aaDSAU/jQ8f0BxqcdEpZoVDc= X-Received: by 2002:a05:6870:3282:b0:261:a26:9319 with SMTP id 586e51a60fabf-26fe5a8e398mr5790909fac.24.1723692677490; Wed, 14 Aug 2024 20:31:17 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a8a:d02:0:b0:557:c384:fb61 with HTTP; Wed, 14 Aug 2024 20:31:16 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Wed, 14 Aug 2024 20:31:16 -0700 Message-ID: Subject: Re: Dead lock after the migration from CentOS 7 to RHEL 9 To: Wasim Devale Cc: Muhammad Waqas , Pgsql-admin , pgsql-admin Content-Type: multipart/alternative; boundary="000000000000be7078061fb07920" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000be7078061fb07920 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, August 14, 2024, Wasim Devale wrote: > So it's not a postgresql issue. It's from the application side correct? > That=E2=80=99s the assumption. The vast majority of locks happen because t= he =E2=80=9Capplication=E2=80=9D executed SQL commands. David J. --000000000000be7078061fb07920 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, August 14, 2024, Wasim Devale <wasimd60@gmail.com> wrote:

So it's not a postgresql issue. It's from the ap= plication side correct?


That=E2=80=99s = the assumption.=C2=A0 The vast majority of locks happen because the =E2=80= =9Capplication=E2=80=9D executed SQL commands.

Dav= id J.
--000000000000be7078061fb07920--