Article ID: 119208, created on Dec 18, 2013, last review on May 9, 2014

  • Applies to:
  • Operations Automation

Symptoms

A user cannot log in to the POA Control Panel due to an error message like that provided below:

Error &#39;ERROR: could not access status of transaction 0;<br/>
Error while executing the query&#39; while &#39; DELETE FROM login_history WHERE login_time < ? AND user_id = ? AND logged_user_id = 0&#39;

The SQL query in the error message above may be different in different cases.

Cause

There is no free disk space on the POA Database Server, so the PostgreSQL database server cannot operate properly. Use the df utility to check the amount of free disk space on the POA Database server.

Resolution

Make sure that there is enough free disk space on the POA Database Server (at least a couple of GBs for system logs and database needs).

Search Words

Error &#39; ERROR: could not access status of transaction 0; <br/> Error while executing the query&#39; while &#39; DELETE FROM login_history WHERE login_time &lt; ? AND user_id = ? AND logged_user_id = 0&#39;

could not access status of transaction 0

DELETE FROM login_history WHERE login_time

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF