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.