On 26.06.2025 19:24, Andrey Borodin wrote:
> If my hypothesis is correct nextMXact will precede tmpMXact.
It seems that the hypothesis has not been confirmed.
Attempt #1
2025-06-26 23:47:24.821 MSK [220458] WARNING: Timed out: nextMXact
24138381 tmpMXact 24138379
2025-06-26 23:47:24.822 MSK [220540] WARNING: Timed out: nextMXact
24138382 tmpMXact 24138379
2025-06-26 23:47:24.823 MSK [220548] WARNING: Timed out: nextMXact
24138382 tmpMXact 24138379
...
pgbench (17.5)
progress: 2.0 s, 0.0 tps, lat 0.000 ms stddev 0.000, 0 failed
progress: 3.0 s, 0.0 tps, lat 0.000 ms stddev 0.000, 0 failed
progress: 4.0 s, 482.2 tps, lat 820.293 ms stddev 1370.729, 0 failed
progress: 5.0 s, 886.0 tps, lat 112.463 ms stddev 8.506, 0 failed
progress: 6.0 s, 348.9 tps, lat 111.324 ms stddev 5.871, 0 failed
WARNING: Timed out: nextMXact 24138381 tmpMXact 24138379
WARNING: Timed out: nextMXact 24138382 tmpMXact 24138379
WARNING: Timed out: nextMXact 24138382 tmpMXact 24138379
...
progress: 7.0 s, 0.0 tps, lat 0.000 ms stddev 0.000, 0 failed
WARNING: Timed out: nextMXact 24138382 tmpMXact 24138379
Attempt #2
2025-06-27 09:18:01.312 MSK [236187] WARNING: Timed out: nextMXact
24497746 tmpMXact 24497744
2025-06-27 09:18:01.312 MSK [236225] WARNING: Timed out: nextMXact
24497746 tmpMXact 24497744
2025-06-27 09:18:01.312 MSK [236178] WARNING: Timed out: nextMXact
24497746 tmpMXact 24497744
...
pgbench (17.5)
progress: 1.0 s, 830.9 tps, lat 108.556 ms stddev 10.078, 0 failed
progress: 2.0 s, 839.0 tps, lat 118.358 ms stddev 19.708, 0 failed
progress: 3.0 s, 623.4 tps, lat 134.186 ms stddev 15.565, 0 failed
WARNING: Timed out: nextMXact 24497746 tmpMXact 24497744
WARNING: Timed out: nextMXact 24497746 tmpMXact 24497744
WARNING: Timed out: nextMXact 24497746 tmpMXact 24497744
WARNING: Timed out: nextMXact 24497746 tmpMXact 24497744
WARNING: Timed out: nextMXact 24497746 tmpMXact 24497744
WARNING: Timed out: nextMXact 24497747 tmpMXact 24497744
WARNING: Timed out: nextMXact 24497747 tmpMXact 24497744
...
progress: 4.0 s, 0.0 tps, lat 0.000 ms stddev 0.000, 0 failed
WARNING: Timed out: nextMXact 24497746 tmpMXact 24497744
Best regards,
Dmitry.
