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.
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 |