Postgresql Transaction ID Not Found

Question

Whenever I am executing a query in postgresql, this is the error message I receive

Transaction ID not found in the session.

Does anyone have any idea how to resolve this? I recently created a new user, but I was unable to find documentation that even shows this as a valid error.

Additional Details: I've managed to resolve the error by re-connecting with admin credentials.

I was using PG Admin V4 with Postgres V9.6, and that was the only message appearing in any query I executed, even if it was a basic query like 'SELECT NOW()'.

At the same time, this was the error message being received by the client device (an iOS device with a AWS Lambda / NodeJS backend) :

'message' : {
  'name' : 'error',
  'length' : 114,
  'severity' : 'fatal',
  'code' : '28000',
  'file' : 'miscinit.c',
  'line' : '587',
  'routine' : 'InitializeSessionUserId'
}

Solution 1

I assume you found a solution, but for anyone else that finds this post, I had the same issue and I just closed PG Admin 4 and restarted it and it cleared up.

Solution 2

To anyone who has this problem, all you have to do is:

1) Reconnect to the database

2) Open a new Query Tab. (Run your query here)

You're welcome.

Solution 3

For me helped changing 'localhost' in connection settings to '127.0.0.1', as mentioned here: https://stackoverflow.com/a/59747781/2590805

Solution 4

Create a new Query editor tab, that works for me

Solution 5

Disconnecting and reconnecting to the database solved this issue for me; it wasn't necessary to exit/open PGAdmin 4 completely.

View more solutions

Comments

[Brad Chou]

Have you resolved it?

[VKarthik]

@BradChou - I usually resolve it by just opening a new query window. It works. As to the cause of the error it still remains a mystery to me.

[Brad Chou]

@VKarthik, It works for me also. Thanks.

[Pugal]

@VKarthik.. Thx for solution.. _/\_

[MikeMurko]

"Have you tried turning it off and on again" sigh ... this worked for me

[Rex Charles]

Does anyone know specifically why this occurs and why restarting pg admin works?

[CompanyDroneFromSector7G]

It's from pgAdmin