MIME-Version: 1.0
From: Steve Baldwin <steve.baldwin@gmail.com>
Date: Thu, 10 Jul 2025 22:01:07 +1000
Message-ID: <CAKE1AiY17RgcKCFba1N6Sz6SjHqSqvq+cfKWBfyKFEjT-L+qkg@mail.gmail.com>
Subject: Lock timeout in commit
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000897eec063991f357"
Archived-At: <https://www.postgresql.org/message-id/CAKE1AiY17RgcKCFba1N6Sz6SjHqSqvq%2BcfKWBfyKFEjT-L%2Bqkg%40mail.gmail.com>
Precedence: bulk

--000000000000897eec063991f357
Content-Type: text/plain; charset="UTF-8"

Hi all,

I'm occasionally seeing a lock timeout in a commit statement. For example:

2025-07-10 08:56:07.225 UTC,"b2bc_api","b2bcreditonline",23592,"
10.124.230.241:60648",686f8022.5c28,55,"COMMIT",2025-07-10 08:56:02
UTC,3984/10729,676737574,ERROR,55P03,"canceling statement due to lock
timeout",,,,,,"COMMIT",,,"098c62f7-bb76-4607-88da-120c6edee423","client
backend",,-2835399305386018931

Am I right in thinking this is likely due to a deferred foreign key
constraint? I couldn't see any obvious clue in the log. Is there somewhere
else I can look?

In case it matters, the server is running version 17.4.

Thanks,

Steve

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

<div dir=3D"ltr">Hi all,<div><br></div><div>I&#39;m occasionally seeing a l=
ock timeout in a commit statement. For example:</div><div><br></div><div>20=
25-07-10 08:56:07.225 UTC,&quot;b2bc_api&quot;,&quot;b2bcreditonline&quot;,=
23592,&quot;<a href=3D"http://10.124.230.241:60648">10.124.230.241:60648</a=
>&quot;,686f8022.5c28,55,&quot;COMMIT&quot;,2025-07-10 08:56:02 UTC,3984/10=
729,676737574,ERROR,55P03,&quot;canceling statement due to lock timeout&quo=
t;,,,,,,&quot;COMMIT&quot;,,,&quot;098c62f7-bb76-4607-88da-120c6edee423&quo=
t;,&quot;client backend&quot;,,-2835399305386018931<br></div><div><br></div=
><div>Am I right in thinking this is likely due to a deferred foreign key c=
onstraint? I couldn&#39;t see any obvious clue in the log. Is there somewhe=
re else I can look?</div><div><br></div><div>In case it matters, the server=
 is running version 17.4.</div><div><br></div><div>Thanks,</div><div><br></=
div><div>Steve</div></div>

--000000000000897eec063991f357--