Re: Lock timeout in commit

2025-07-10 Thread Steve Baldwin
On Fri, 11 Jul 2025 at 01:28, Tom Lane wrote: > > I think all you could do is monitor the pg_locks view and hope to > catch the process in "waiting" state before it fails. > > It occurs to me to wonder though if we couldn't provide more > context in the error about what lock is being waited for.

Re: Lock timeout in commit

2025-07-10 Thread Tom Lane
Steve Baldwin writes: > 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 d