pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: marko@joh.to
Subject: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot
Date: Wed, 03 Jul 2019 08:03:24 +0000
Message-ID: <15888-52d02086ac2085e8@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      15888
Logged by:          Marko Tiikkaja
Email address:      marko@joh.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.

view thread (18+ messages)  latest in thread

Message-ID: <15888-52d02086ac2085e8@postgresql.org>
Permalink:  ../15888-52d02086ac2085e8@postgresql.org/
Also on:    postgresql.org/message-id/15888-52d02086ac2085e8@postgresql.org

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, marko@joh.to
  Subject: Re: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot
  In-Reply-To: <15888-52d02086ac2085e8@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox