Hi folks.
I've been getting a bevy of errors from PostgreSQL recently, most of which make no sense. Well, that is to say that while I understand what the errors are telling me, there seems to be no logicaly reason why they are occurring.
The error message is ALWAYS the one below, which is also very strange.
For example, the query below just threw the following error message a number of times, and then on another subsequent reload it worked fine. If I execute the queries from
Query:
select a_id, name, depth from cms_areas order by a_id
Error:
ERROR: current transaction is aborted, queries ignored until end of transaction block
I'm using this query as an example since there are no external variables being used in the query, it's executed as is every time.
One other thing which is worth noting is that while the above error indicates a transaction, there was no transaction in progress when this particular error occurred. In some cases, yes, this is thrown from within a transaction, but in this case I know for a fact it is not.
Can anyone tell me anything that they think might cause this problem?
Cheers and TIA,
Pablo
I've been getting a bevy of errors from PostgreSQL recently, most of which make no sense. Well, that is to say that while I understand what the errors are telling me, there seems to be no logicaly reason why they are occurring.
The error message is ALWAYS the one below, which is also very strange.
For example, the query below just threw the following error message a number of times, and then on another subsequent reload it worked fine. If I execute the queries from
Query:
select a_id, name, depth from cms_areas order by a_id
Error:
ERROR: current transaction is aborted, queries ignored until end of transaction block
I'm using this query as an example since there are no external variables being used in the query, it's executed as is every time.
One other thing which is worth noting is that while the above error indicates a transaction, there was no transaction in progress when this particular error occurred. In some cases, yes, this is thrown from within a transaction, but in this case I know for a fact it is not.
Can anyone tell me anything that they think might cause this problem?
Cheers and TIA,
Pablo