Hi, On Tue, Aug 19, 2025 at 6:31 PM Matheus Alcantara <matheusssil...@gmail.com> wrote: > > On Tue Aug 19, 2025 at 12:57 AM -03, Daniil Davydov wrote: > > You have started a very long transaction, which holds its xid and prevents > > vacuum from freezing it. But what if the backend is stuck not inside a > > transaction? Maybe we can just hardcode a huge delay (not inside the > > transaction) or stop process execution via breakpoint in gdb. If we will > > use it > > instead of a long query, I think that this error may be reproducible. > > > But how could this happen in real scenarios? I mean, how the backend > could be stuck outside a transaction? >
For now, I cannot come up with a situation where it may be possible. Perhaps, such a lagging may occur during network communication, but I couldn't reproduce it. Maybe other people know how we can achieve this? I think that if such a situation may be possible, the suggestion to delete messages will no longer be relevant. Therefore, first of all, I would like to clarify this issue. -- Best regards, Daniil Davydov
