PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15888
PG Version9.6.14
OSOS X 10.12.6
Opened2019-07-03 08:03:24+00
Reported byMarko Tiikkaja
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15888
Logged by:          Marko Tiikkaja
Email address:      (redacted)
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.

Messages

DateAuthorSubject
2019-07-03 08:03:24+00PG Bug reporting formBUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot
2019-07-04 04:35:12+00Michael PaquierRe: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot
2019-07-09 20:15:57+00Andres FreundRe: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot
2019-07-09 21:46:30+00Alvaro HerreraRe: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot
2019-07-10 04:51:47+00Michael PaquierRe: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot
2019-07-10 07:55:01+00Andres FreundRe: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot
2019-07-10 15:24:44+00Magnus HaganderRe: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot
2019-07-10 23:58:30+00Michael PaquierRe: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot
2019-07-11 11:21:39+00Magnus HaganderRe: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot
2019-07-11 13:09:46+00Michael PaquierRe: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot
2019-07-11 13:44:07+00Tom LaneRe: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot
2019-07-12 01:25:03+00Michael PaquierRe: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot