- Notifications
You must be signed in to change notification settings - Fork38
Closed
Labels
Description
Consider the following scenario:
- Session 1 requests history.
- Session 1 is terminated while wating for collector.
- Session 2 requests profile.
- Collector sends history requested by session 1.
- Session 2 receives history instead of profile.
Stop the collector just beforeLockAcquire(&tag, ExclusiveLock, false, false); in collector_main (collector.c:442).
Session 1:
postgres=# select * from pg_wait_sampling_history limit 5;FATAL: terminating connection due to administrator commandserver closed the connection unexpectedlyThis probably means the server terminated abnormallybefore or while processing the request.The connection to the server was lost. Attempting reset: Succeeded.Terminate the backend while it is waiting for collector (with kill or pg_terminate_backend).
Session 2:
postgres=# select * from pg_wait_sampling_profile limit 5; pid | event_type | event | queryid | count -------+------------+---------------------+---------+----------------- 93315 | Activity | LogicalLauncherMain | 0 | 702740797103094 93309 | Activity | CheckpointerMain | 0 | 702740797103094 93310 | Activity | BgWriterHibernate | 0 | 702740797103094 93312 | Activity | WalWriterMain | 0 | 702740797103094 93635 | Client | ClientRead | 0 | 702740797224477(5 rows)After sending the query let the collector continue.