Re: [PATCH 11/14] Introduce wal decoding via catalog timetravel

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [PATCH 11/14] Introduce wal decoding via catalog timetravel
Дата
Msg-id 20121203122212.GA5073@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: [PATCH 11/14] Introduce wal decoding via catalog timetravel  (Steve Singer <steve@ssinger.info>)
Ответы Re: [PATCH 11/14] Introduce wal decoding via catalog timetravel
Список pgsql-hackers
Hi Steve,

On 2012-12-02 21:52:08 -0500, Steve Singer wrote:
> On 12-11-14 08:17 PM, Andres Freund wrote:
>
> I am getting errors like the following when I try to use either your
> test_decoding plugin or my own (which does even less than yours)
>
>
> LOG:  database system is ready to accept connections
> LOG:  autovacuum launcher started
> WARNING:  connecting to
> WARNING:  Initiating logical rep
> LOG:  computed new xmin: 773
> LOG:  start reading from 0/17F5D58, scrolled back to 0/17F4000
> LOG:  got new xmin 773 at 25124280
> LOG:  found initial snapshot (via running xacts). Done: 1
> WARNING:  reached consistent point, stopping!
> WARNING:  Starting logical replication
> LOG:  start reading from 0/17F5D58, scrolled back to 0/17F4000
> LOG:  found initial snapshot (via running xacts). Done: 1
> FATAL:  cannot read pg_class without having selected a database
> TRAP: FailedAssertion("!(SHMQueueEmpty(&(MyProc->myProcLocks[i])))", File:
> "proc.c", Line: 759)
>
> This seems to be happening under the calls at
> reorderbuffer.c:832    if (!SnapBuildHasCatalogChanges(NULL, xid,
> &change->relnode))

Two things:
1) Which exact options are you using for pg_receivellog? Not "-d
replication" by any chance?
2) Could you check that you really have a fully clean build? That has
hit me in the past as well.

Greetings,

Andres Freund

--Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Proposal for Allow postgresql.conf values to be changed via SQL
Следующее
От: Alexander Korotkov
Дата:
Сообщение: Re: WIP: index support for regexp search