Re: Latest version of Hot Standby patch

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Latest version of Hot Standby patch
Дата
Msg-id 49648FA3.3070506@enterprisedb.com
обсуждение исходный текст
Ответ на Re: Latest version of Hot Standby patch  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Latest version of Hot Standby patch  (Simon Riggs <simon@2ndQuadrant.com>)
Re: Latest version of Hot Standby patch  (Simon Riggs <simon@2ndQuadrant.com>)
Re: Latest version of Hot Standby patch  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
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.

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.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: Re: Warning about the 8.4 release
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: new libpq SSL connection option