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

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: Steve Singer <steve(at)ssinger(dot)info>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCH 11/14] Introduce wal decoding via catalog timetravel
Date: 2012-12-03 12:22:12
Message-ID: 20121203122212.GA5073@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2012-12-03 12:31:31 Re: WIP: index support for regexp search
Previous Message senthilnathan 2012-12-03 12:21:50 Re: Switching timeline over streaming replication