|
Hi All I am using a cluster setup with two nodes in it.
Replication between two nodes is being done through slony. Postgres version is 8.1.2 and slony version is 1.1.5 . I am running an operation that does thousands of update/inserts/delete
on some tables. While running update query on a particular table let say <abc> , it gives error “attempted
to lock invisible tuple” and fails. This update query is supposed to
update hundreds of record. Sometimes it gives the error while
running this update query and sometimes not. I have seen postgres logs of
two instances when it fails due to “attempted to
lock invisible tuple” error , in these two instances while it was doing
an update on <abc> table, another query was going on the same table which was
updating a particular record. Can this (two updates at the same time on the
same table) be the reason for this error in some way ( just a guess) . If not, then
what can be the reason of this error ?? Please help. Thanks.. Tamanna |
