Re: Latest version of Hot Standby patch

On Wed, 2009-01-07 at 13:18 +0200, Heikki Linnakangas wrote:
> There's still something wrong with the way subtransactions are handled. 
> I got:
> 
> postgres=# SELECT * FROM foo;
> ERROR:  could not access status of transaction 118649
> DETAIL:  Could not open file "pg_subtrans/0001": No such file or directory.
> 
> in the standby after some testing.

Please tell me some more. Was 118649 active etc?

118649 should be in pg_subtrans/057 shouldn't it?? Hmmm.

> I created a lot of subtransactions in the master, each inserting a row 
> to table 'foo', and left the transaction open. In another session, I did 
> a lot of dummy activity (truncate bar; insert into bar ...) to generate 
> WAL, and also checkpoints and pg_xlog_switch() calls. I then restarted 
> the standby, and got the above error.

Can you confirm this works in normal running?

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support