BDR error trying to replay a invalid statement

From: cchee-ob <carter(dot)chee(at)objectbrains(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: BDR error trying to replay a invalid statement
Date: 2016-02-01 21:07:54
Message-ID: 1454360874599-5885230.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I noticed that the BDR replication continually trying to replay a ddl
statement that has a syntax error. Is there anything that can be done to
skip this statement or do I need to rebuild the replicated node? Here's
what I see in the logs:

t=2016-02-01 13:02:27 PST d= h= p=21795 a=LOCATION:
bdr_establish_connection_and_slot, bdr.c:572
t=2016-02-01 13:02:27 PST d= h= p=21795 a=INFO: 00000: starting up
replication from 1 at 125/360AF118
t=2016-02-01 13:02:27 PST d= h= p=21795 a=LOCATION: bdr_apply_main,
bdr_apply.c:2550
t=2016-02-01 13:02:27 PST d= h= p=21795 a=DEBUG: 00000: bdr_apply: BEGIN
origin(source, orig_lsn, timestamp): 125/360AF1B8, 2016-01-28
19:34:50.180915-08
t=2016-02-01 13:02:27 PST d= h= p=21795 a=LOCATION: process_remote_begin,
bdr_apply.c:198
t=2016-02-01 13:02:27 PST d= h= p=21795 a=ERROR: 42601: syntax error at or
near "ON" at character 8
t=2016-02-01 13:02:27 PST d= h= p=21795 a=CONTEXT: during DDL replay of ddl
statement: GRANT ON TABLE table1 TO user2 WITH GRANT OPTION

Thanks in advance!

--
View this message in context: http://postgresql.nabble.com/BDR-error-trying-to-replay-a-invalid-statement-tp5885230.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-02-01 21:11:10 Re: Check constraints and function volatility categories
Previous Message Yu Nie 2016-02-01 21:03:31 Re: strange sql behavior