From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Latest version of Hot Standby patch |
Date: | 2009-01-07 12:07:55 |
Message-ID: | 1231330075.15005.167.camel@ebony.2ndQuadrant |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2009-01-07 12:23:46 | Re: Latest version of Hot Standby patch |
Previous Message | Robert Haas | 2009-01-07 12:04:35 | Re: Do we still need constraint_exclusion? |