BDR error trying to replay a invalid statement
| От | cchee-ob |
|---|---|
| Тема | BDR error trying to replay a invalid statement |
| Дата | |
| Msg-id | 1454360874599-5885230.post@n5.nabble.com обсуждение исходный текст |
| Ответы |
Re: BDR error trying to replay a invalid statement
|
| Список | 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.
В списке pgsql-general по дате отправления: