Message-ID: <58661f82-620c-8116-efe7-23266578289c@jakobs.com>
Date: Tue, 2 Apr 2024 18:45:21 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.12.0
Subject: Re: Deadlock
Content-Language: de-DE
To: pgsql-admin@lists.postgresql.org
References: 
 <CAJk5Atb6CnsgAJUQ--UPgvRH-eZUhhL__P9-pz=XZsq=r29ShA@mail.gmail.com>
From: Holger Jakobs <holger@jakobs.com>
In-Reply-To: 
 <CAJk5Atb6CnsgAJUQ--UPgvRH-eZUhhL__P9-pz=XZsq=r29ShA@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="------------0QHBAlr6ixTlWHnEQV9cVzFQ"
Archived-At: 
 <https://www.postgresql.org/message-id/58661f82-620c-8116-efe7-23266578289c%40jakobs.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------------0QHBAlr6ixTlWHnEQV9cVzFQ
Content-Type: multipart/mixed; boundary="------------ICoBYRXCh33yKbXS8E7UvAhH";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <58661f82-620c-8116-efe7-23266578289c@jakobs.com>
Subject: Re: Deadlock
References: <CAJk5Atb6CnsgAJUQ--UPgvRH-eZUhhL__P9-pz=XZsq=r29ShA@mail.gmail.com>
In-Reply-To: <CAJk5Atb6CnsgAJUQ--UPgvRH-eZUhhL__P9-pz=XZsq=r29ShA@mail.gmail.com>

--------------ICoBYRXCh33yKbXS8E7UvAhH
Content-Type: multipart/alternative;
 boundary="------------5XZPVYlKIcX7uN1ftaK5dJ4V"

--------------5XZPVYlKIcX7uN1ftaK5dJ4V
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: base64

QW0gMDIuMDQuMjQgdW0gMTg6NDAgc2NocmllYiBSYWplc2ggS3VtYXI6DQo+IEhpDQo+DQo+
IElmIEkgcmVjZWl2ZSBhbiBhbGVydCBmb3IgZGVhZGxvY2ssIHdoYXQgc2hvdWxkIEkgZG8/
IExpa2Ugd2hhdCANCj4gYW5hbHlzaXMgc2hvdWxkIEkgZG8/IE5vIHdheSB0byBmaW5kIGEg
cm9vdCBjYXVzZT8NCj4gVW5kZXIgcGdfbG9ja3MsIHdoYXQgSSBjYW4gYW5hbHlzZT8NCj4N
CklmIHlvdSByZWNlaXZlIGFuIGVycm9yIHdpdGggYSBkZWFkbG9jaywgdGhlIGN1cnJlbnQg
dHJhbnNhY3Rpb24gaXMgDQpkZWFkLiBZb3UgaGF2ZSB0byBkZWNpZGUgd2hldGhlciB0byB0
cnkgYWdhaW4uDQoNCldpdGhpbiB0aGUgZXJyb3IgbWVzc2FnZSB5b3UgZmluZCBhIGhpbnQg
d2hpY2ggb3RoZXIgKG5vdCBhYm9ydGVkKSANCnRyYW5zYWN0aW9uIHdhcyBpbnZvbHZlZCBp
biB0aGUgZGVhZGxvY2suIFNvIHlvdSBoYXZlIGFsbCB0aGUgDQppbmZvcm1hdGlvbiB5b3Ug
bmVlZCB0byBmaW5kIHRoZSBjdWxwcml0Lg0KDQpSZWdhcmRzLA0KDQpIb2xnZXINCg0KLS0g
DQoNCkhvbGdlciBKYWtvYnMsIEJlcmdpc2NoIEdsYWRiYWNoLCBUZWwuICs0OS0xNzgtOTc1
OTAxMg0KDQpjaGF0IHdpdGggbWUgb24gU2lnbmFsIG1lc3NlbmdlciANCjxodHRwczovL3Np
Z25hbC5tZS8jZXUvR3BJUDI1OWJCbmVfSmlCWUpGdmJaQ0xZSkVMaEItOTJuSmZuY0FDTDFM
VWVCT3BoZlhGRmdMWVlWWHZfQUdoZz4NCg0K
--------------5XZPVYlKIcX7uN1ftaK5dJ4V
Content-Type: multipart/related;
 boundary="------------X0QIPPXqL7tB9nVWbuFd5twK"

--------------X0QIPPXqL7tB9nVWbuFd5twK
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <div class=3D"moz-cite-prefix">Am 02.04.24 um 18:40 schrieb Rajesh
      Kumar:<br>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CAJk5Atb6CnsgAJUQ--UPgvRH-eZUhhL__P9-pz=3DXZsq=3Dr29ShA@mail.=
gmail.com">
      <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DU=
TF-8">
      <div dir=3D"auto">Hi
        <div dir=3D"auto"><br>
        </div>
        <div dir=3D"auto">If I receive an alert for deadlock, what should=

          I do? Like what analysis should I do? No way to find a root
          cause?</div>
        <div dir=3D"auto">Under pg_locks, what I can analyse?=C2=A0</div>=

        <div dir=3D"auto"><br>
        </div>
      </div>
    </blockquote>
    <p>If you receive an error with a deadlock, the current transaction
      is dead. You have to decide whether to try again.</p>
    <p>Within the error message you find a hint which other (not
      aborted) transaction was involved in the deadlock. So you have all
      the information you need to find the culprit.</p>
    <p>Regards,</p>
    <p>Holger<br>
    </p>
    <div class=3D"moz-signature">-- <br>
      <p>Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012<br>
        <img src=3D"cid:part1.CLyhcq2Z.UZ3YijWJ@jakobs.com" alt=3D""
          title=3D"chat with me on Signal messenger"><br>
        <a
href=3D"https://signal.me/#eu/GpIP259bBne_JiBYJFvbZCLYJELhB-92nJfncACL1LU=
eBOphfXFFgLYYVXv_AGhg">chat
          with me on Signal messenger</a></p>
    </div>
  </body>
</html>
--------------X0QIPPXqL7tB9nVWbuFd5twK
Content-Type: image/png; name="TapMuhNyQVuzuVPA.png"
Content-Disposition: inline; filename="TapMuhNyQVuzuVPA.png"
Content-Id: <part1.CLyhcq2Z.UZ3YijWJ@jakobs.com>
Content-Transfer-Encoding: base64

iVBORw0KGgoAAAANSUhEUgAAAIcAAACHAQMAAAAGKdhJAAAABlBMVEUAAAD///+l2Z/dAAAA
AnRSTlP//8i138cAAAAJcEhZcwAACxIAAAsSAdLdfvwAAAG5SURBVEiJ3da7bcMwEAbgM1iw
kxYQwDXYcSVpAT0WkFdixzUIcAGqY0Hw8suJHSCNzkCKIIKg4isI3tMm/vnQP5FMtIQ4lbr4
SmSEcnCdHa/W7FQXFosfcEjvK76jfkNmp+6Bm35XqNOxs+8II8ahsxEXeEVxKcjPFIbP95Wx
S8FzFN5dJP1dnUvJmm5sVocviiIV5pStyna4FcRrhJItTQUpqrMeehaLVk3TaIlcHZ1Umq2o
wsQ0OvrMqkQOhEn1Fs5I+yCVRnEJidHSIZKVChdeiXer2nkTFko7a2cOTluJX1EIJGtzLwqz
s7q6BKngnNtjEJp+RiGQrNN61kLt1qDZhMIlzrb2xdwx5l/5uZaMWmOHWLOFODupsI/kUnao
hWpWKkdJ94L+xM2xTFgojQY0f3Np47gUIxT2iYvKp6RdS+Xw1PthdI9ZIKk0m45AHSHM550F
chSaPGqhDsYgSAVPxuwU9BjqboRy7jpO6OfshtFKBXt1tKh+ajiHxXImxzCrHeuuvCEzqc2r
VfP22JBCwa7DT+GIIj7PuRY+V1ZHmAU0AAvlzA9qwQYLeXpl9Up+61/B35IPLEvZkYbCln8A
AAAASUVORK5CYII=

--------------X0QIPPXqL7tB9nVWbuFd5twK--

--------------5XZPVYlKIcX7uN1ftaK5dJ4V--

--------------ICoBYRXCh33yKbXS8E7UvAhH--

--------------0QHBAlr6ixTlWHnEQV9cVzFQ
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZgw2IQUDAAAAAAAKCRCKV5yTsxlhumDG
AJ9Ne/W6xNlZBN3GgmckEmxg68pVdQCfe5/gLIV+i2Sip7uBpSqNzcm9GO8=
=vkmJ
-----END PGP SIGNATURE-----

--------------0QHBAlr6ixTlWHnEQV9cVzFQ--