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 1seR8Y-0076lN-9x for pgsql-admin@arkaria.postgresql.org; Thu, 15 Aug 2024 03:26:54 +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 1seR8W-00E64o-Tx for pgsql-admin@arkaria.postgresql.org; Thu, 15 Aug 2024 03:26:52 +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 1seR8W-00E64f-Im for pgsql-admin@lists.postgresql.org; Thu, 15 Aug 2024 03:26:52 +0000 Received: from mail-oa1-x34.google.com ([2001:4860:4864:20::34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1seR8T-004nUN-OF for pgsql-admin@lists.postgresql.org; Thu, 15 Aug 2024 03:26:51 +0000 Received: by mail-oa1-x34.google.com with SMTP id 586e51a60fabf-260f863109cso357170fac.1 for ; Wed, 14 Aug 2024 20:26:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1723692409; x=1724297209; 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=QoXIAMPEsdaiiizwDXneguEf0nRhS/elWR3cf9Kraok=; b=izcM2n+COgDlkk2IjQu/P6UsozJ8q1xWpF9x44sCumvMpMQInpV/vz3PlHcnpEAAvU t+XaFkxFhnB5j1+N4+mu6k8po8ZrFQNpIAAYSJnPVVEAtbGtQF83zJw4t8+Pwp5c3saD t1xsfpUH6XHNeFihWW7R6Hb4DUOjzOo20kezvb1JheIm30RF5WCNrqqbWy3Bga8iCzFM gpiv3nAh0W8BPFqY3jB4rm00XFrSmO7ff0Mj254dKjZEQKYWRwx4xpxezy5XIvmlNbxY BOeBFkgeByfQxmElWK2j1BMQXvyS7vDBUXXW+KD/fhoqYAbrXg/2+VRa0qAqiDdhNR9P iQ3Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1723692409; x=1724297209; 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=QoXIAMPEsdaiiizwDXneguEf0nRhS/elWR3cf9Kraok=; b=aJZdJDyMZhwkeitGbl8/QQda5rvMklXphALtqqDr4qpoLatDOJy0F09hGo/DR7L8Cq uXPoL5wKrvK6n+VjHqKILp0ABiE+h2NfsB1jC0o6pk0s+sOtybJbXjY95kpLU8uCw/eD zhDPvVOdx3WjXZ2Zh921SLsQYMgT8ex/EjOCRrNKQGTVcpkStGXIiPygtjCo9x+BVLpU diwdGcyPn2kU9sf6z3y+yTP2slimwg1fSnYuBHCShjc/MXVQGvIEqcbe5hss3jSQN8Hl oIeZ1bWCHnf9DSNWAdk8rgnLlf9z3AKt3O7Rf0bg61UJw0pCk5cgCjoObHcMyg0Aq6Md d9Uw== X-Forwarded-Encrypted: i=1; AJvYcCWj1YbgrEyw6jzwTgfJIz9Z/yoefyL9X3TGpt2HmoGzqnj06LwbBuTNnPa+bcJuw6gQOq1FXfnZ8TIL4Na8hy+19OhnEsBYJuNu3AKZkjijtg== X-Gm-Message-State: AOJu0YzdmH464hSBwpU4JJznc0Ul37QwuapPYUgahfReoqlWkynL/NU9 V6PBM0lLsV542/vCHnlMmkhFEza56+m2lchTow3oipemPACxpRhIZppIE1lYGUnA78eNDjPw73g zenOOiyc+99Ob3aJQG4Nck/OlANA= X-Google-Smtp-Source: AGHT+IHCZUqHaZRIYvY/hFpNYTW1vhyzlbfk/qeuyrTTRR1NDRvqluZwwhE0IBjRUJNIqaS5KwMz0857r7SZHZiKKSY= X-Received: by 2002:a05:6870:45a4:b0:25e:1edb:5bcf with SMTP id 586e51a60fabf-26fe5a03ebemr6094873fac.6.1723692408994; Wed, 14 Aug 2024 20:26:48 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a8a:d02:0:b0:557:c384:fb61 with HTTP; Wed, 14 Aug 2024 20:26:48 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Wed, 14 Aug 2024 20:26:48 -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="000000000000bd85c5061fb069a7" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000bd85c5061fb069a7 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, August 14, 2024, Wasim Devale wrote: > Hi please help me with the below email. > > ---------- Forwarded message --------- > From: Wasim Devale > Date: Wed, 14 Aug, 2024, 11:09=E2=80=AFam > Subject: Dead lock after the migration from CentOS 7 to RHEL 9 > To: Pgsql-admin , pgsql-admin < > pgsql-admin@postgresql.org> > > > Hi All > > I am facing this issue while reindexing after migration. I analysed the > application holding the particular table. I stopped the application and > reindexed it. It went well then again I am facing this issue below. > > ERROR: deadlock detected > > DETAIL: Process 2197043 waits for AccessExclusiveLock on relation 1038435= 5 > of database 10163711; blocked by process 1889236. > > Process 1889236 waits for RowExclusiveLock on relation 10168609 of > database 10163711; blocked by process 2197043. > > HINT: See server log for query details. > How are we supposed to help; you have the indicated log files, and application code, not us. It=E2=80=99s a bug in your code. And you haven= =E2=80=99t asked any question that could be answered. David J. --000000000000bd85c5061fb069a7 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, August 14, 2024, Wasim Devale <wasimd60@gmail.com> wrote:
Hi please help me with the below=C2=A0email.
=
------= ---- Forwarded message ---------
From: Wasim Devale <wasimd60@gmail.com><= br>Date: Wed, 14 Aug, 2024, 11:09=E2=80=AFam
Subject: Dead lock after th= e migration from CentOS 7 to RHEL 9
To: Pgsql-admin <pgsql-admin@lists.pos= tgresql.org>, pgsql-admin <pgsql-admin@postgresql.org>
=

Hi All

I am facing this issue while reindex= ing after migration. I analysed the application holding the particular tabl= e. I stopped the application and reindexed it. It went well then again I am= facing this issue below.

ERROR: deadlock detected<= /p>

DETAIL: Process 2197043 waits for AccessExclusiveLock on relation 103= 84355 of database 10163711; blocked by process 1889236.

Process 18892= 36 waits for RowExclusiveLock on relation 10168609 of database 10163711; bl= ocked by process 2197043.

HINT: See server log for query details.
=


How are= we supposed to help; you have the indicated log files, and application cod= e, not us. It=E2=80=99s a bug in your code.=C2=A0 And you haven=E2=80=99t a= sked any question that could be answered.

David J.=

--000000000000bd85c5061fb069a7--