Re: IPC/MultixactCreation on the Standby server
| От | Dmitry |
|---|---|
| Тема | Re: IPC/MultixactCreation on the Standby server |
| Дата | |
| Msg-id | d5b14f74-5cfe-4246-b4da-9acd30f60c3c@yandex.ru обсуждение исходный текст |
| Ответ на | IPC/MultixactCreation on the Standby server (Dmitry <dsy.075@yandex.ru>) |
| Список | pgsql-hackers |
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.
В списке pgsql-hackers по дате отправления: