Search Postgresql Archives

"attempted to lock invisible tuple" error while update

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux