From: | "tamanna madaan" <tamanna(dot)madan(at)globallogic(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Cc: | "Tapin Agarwal" <tapin(dot)agarwal(at)globallogic(dot)com> |
Subject: | "attempted to lock invisible tuple" error while update |
Date: | 2010-07-09 04:56:43 |
Message-ID: | 68666423656E1444A011106C4E085F4DD48AAF@ex3-del1.synapse.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Arnaud Lesauvage | 2010-07-09 07:40:53 | Re: 'default nextval()' loses schema-qualification in dump ? |
Previous Message | Hiroshi Inoue | 2010-07-09 03:31:03 | Re: 'default nextval()' loses schema-qualification in dump ? |