Date: Tue, 26 Jan 2016 05:33:13 -0700 (MST)
From: leo <dazhoufei@gmail.com>
To: pgsql-hackers@postgresql.org
Message-ID: <1453811593597-5884242.post@n5.nabble.com>
In-Reply-To: <20160123031740.21436.54292.pgcf@coridan.postgresql.org>
References: <5685BB86.5010901@2ndquadrant.com> <569151D5.3060003@ssinger.info>
 <5692B798.2050002@ssinger.info> <56992762.1090409@2ndquadrant.com>
 <1453013216398-5882564.post@n5.nabble.com>
 <CAMsr+YEe3q3DG=oJpeN-v2EbVZKKUqqvdDRh0nJ-_=N9GPAWWw@mail.gmail.com>
 <20160123031740.21436.54292.pgcf@coridan.postgresql.org>
Subject: Re: pglogical - logical replication contrib module
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

Hi Steve Singer,

   I find the pglogical package has updated, I reinstall the new RPM package
and test again. But I find the same error in subscription node after I run
pglogical.create_subscription command:
   Error message:
     < 2016-01-26 12:23:59.642 UTC >LOG:  worker process: pglogical apply
19828:2377587811 (PID 12299) exited with exit code 1
< 2016-01-26 12:23:59.642 UTC >LOG:  unregistering background worker
"pglogical apply 19828:2377587811"
< 2016-01-26 12:23:59.642 UTC >LOG:  registering background worker
"pglogical apply 19828:2377587811"
< 2016-01-26 12:23:59.642 UTC >LOG:  starting background worker process
"pglogical apply 19828:2377587811"
< 2016-01-26 12:23:59.643 UTC >ERROR:  subscriber replicate_gis_data_from_11
initialization failed during nonrecoverable step (s), please try the setup
again
   I also find the provide node has error message:
     < 2016-01-26 04:16:51.173 UTC >LOG:  exported logical decoding
snapshot: "0003F483-1" with 0 transaction IDs
< 2016-01-26 04:16:51.282 UTC >LOG:  unexpected EOF on client connection
with an open transaction
< 2016-01-26 04:16:51.549 UTC >LOG:  logical decoding found consistent point
at 4F/8CD1A090
< 2016-01-26 04:16:51.549 UTC >DETAIL:  There are no running transactions.
< 2016-01-26 04:16:51.549 UTC >LOG:  exported logical decoding snapshot:
"0003F484-1" with 0 transaction IDs
< 2016-01-26 04:16:51.675 UTC >LOG:  unexpected EOF on client connection
with an open transaction
< 2016-01-26 04:16:51.968 UTC >LOG:  logical decoding found consistent point
at 4F/8CD1A0F8
< 2016-01-26 04:16:51.968 UTC >DETAIL:  There are no running transactions.
< 2016-01-26 04:16:51.968 UTC >LOG:  exported logical decoding snapshot:
"0003F485-1" with 0 transaction IDs
< 2016-01-26 04:16:52.399 UTC >ERROR:  schema "topology" already exists
< 2016-01-26 04:16:52.436 UTC >LOG:  unexpected EOF on client connection
with an open transaction

    I test pglogical according to README document.  Could you tell me what
is wrong?

Thanks,
Leo
  

--
View this message in context: http://postgresql.nabble.com/pglogical-logical-replication-contrib-module-tp5879755p5884242.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers