Search Postgresql Archives

BDR error trying to replay a invalid statement

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux