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.com PostgreSQL Training, Services and Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers