Postgresql Transaction ID Not Found

postgresql pgadmin pgadmin-4
Molezz picture Molezz · Apr 5, 2017 · Viewed 18.3k times · Source

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'
}

Answer

gignosko picture gignosko · Apr 13, 2017

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.

Related questions

PGAdmin: Not connected to the server or the connection to the server has been closed

i got this problem with postgreSQL, when i do a simple query of anything (CRUD), sometimes it works and almost always shows this message: Not connected to the server or the connection to the server has been closed. I don't …

Read More
PgAdmin fatal error. The appllication server could not be contacted

A couple of days before I have installed on my PC with Windows 7 Professional new version of PgAdmin (version 4). It worked fine, but today it loads slowly and then information window appears with text: "PgAdmin fatal error. The appllication server …

Read More
PgAdmin 4: Cannot edit rows from one table

Something strange is happening with my new created tables in Postgres, I can add data to them, but I cannot use PgAdmin to edit the any row. This is my table columns description: After executing the query to view all …

Read More