On 7/3/23 14:58, hubert depesz lubaczewski wrote:
> ...
>
> and then it went back to hash_seq_search :(
>
So is it an infinite loop in ReorderBufferExecuteInvalidations, or is it
just the case that there are many invalidations? I can't really deduce
that from the backtraces.
How many invalidations does the transaction have? Should be enough to
print txn->ninvalidations
Also, is there anything interesting about the transaction? You know the
XID (2741814901) so maybe use pg_waldump to see what it did.
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company