From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | marko(at)joh(dot)to |
Subject: | BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot |
Date: | 2019-07-03 08:03:24 |
Message-ID: | 15888-52d02086ac2085e8@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15888
Logged by: Marko Tiikkaja
Email address: marko(at)joh(dot)to
PostgreSQL version: 9.6.14
Operating system: OS X 10.12.6
Description:
Run:
pg_recvlogical -S foo -f /dev/null -d dbname --create-slot --start
and pg_stat_activity will show something like this until that session
disconnects:
-[ RECORD 1
]----+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
datid | 9672230
datname | dbname
pid | 81996
usesysid | 10
usename | marko
application_name | pg_recvlogical
client_addr |
client_hostname |
client_port | -1
backend_start | 2019-07-03 10:02:00.459737+02
xact_start |
query_start |
state_change | 2019-07-03 10:02:00.726645+02
wait_event_type |
wait_event |
state | idle in transaction
backend_xid |
backend_xmin |
query |
which is quite obviously bogus.
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2019-07-03 09:10:34 | BUG #15889: PostgreSQL failed to build due to error MSB8020 with MSVC on windows |
Previous Message | PG Bug reporting form | 2019-07-03 03:04:47 | BUG #15887: An extra "break" instruction causes a bug |