I have a system in which we carry out a large number of requests for insertions and updates (something also exacerbates)
I sometimes see a mistake in my magazines that claim.
PG::ObjectNotInPrerequisiteState: ERROR: attempted to delete invisible tuple INSERT INTO call_records(plain_crn,efd,acd,slt,slr,ror,raw_processing_data,parsed_json,timestamp,active,created_at,updated_at) VALUES (9873,2016030233,'R',0,0,'PKC01','\x02000086000181f9000101007 ... ')
What I do not understand, even when the request (delete) is not executed (the specified error appears in the insert clause), nevertheless, the error was thrown.
I searched for this problem, but no convincing evidence of why this is happening.
Postgres version.
database=# select version(); version -------------------------------------------------------------------------------------------------------------- PostgreSQL 9.5.2 on x86_64-apple-darwin14.5.0, compiled by Apple LLVM version 7.0.0 (clang-700.1.76), 64-bit (1 row)
Any clue?
source share