I am running Postgres 9.1.2(and 9.0.5) and have a primary database set up with 5 hot standby's. I run a fairly large update once an hour. During this update, I get the following message on my standby databases. This does not happen every hour, nor does it happen at any specific times, just during random updates, at random times.
2012-04-02 13:36:13.269 PDT,"username","database",39523,"127.0.0.1:57893",4f79ffad.9a63,1,"",2012-04-02 12:36:13 PDT,3/32,0,FATAL,40001,"terminating connection due to conflict with recovery","User query might have needed to see row versions that must be removed.","In a moment you should be able to reconnect to the database and repeat your command.",,,,,,,""
The issue is that the user that is being disconnected is only executing a "SELECT 1;" while connected to the database. It does this every second indefinitely. When it does get disconnected, it is able to immediately reconnect, and resume selecting 1, but the disconnect is very strange for a user that isn't using any data/tables in the database.
Has anyone experienced this? Or know why this might be happening?