search

2ndQuadrant / pglogical

Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
http://2ndquadrant.com/en/resources/pglogical/
Other
1.04k stars 154 forks source link

ERROR: BEGIN on origin node failed: ERROR: SET TRANSACTION SNAPSHOT must be called before any query #407

Open Jinyouzhiu opened 1 year ago

Jinyouzhiu commented 1 year ago

LOG: statement: SELECT pglogical.create_subscription(subscription_name := 'subscription',provider_dsn := 'host=192.168.1.123 port=5432 dbname=testsync user=postgres password=jin12345'); LOG: starting apply for subscription subscription ERROR: BEGIN on origin node failed: ERROR: SET TRANSACTION SNAPSHOT must be called before any query

LOG: apply worker [25845] at slot 1 generation 16 exiting with error LOG: worker process: pglogical apply 16384:2875150205 (PID 25845) exited with exit code 1 LOG: statement: SELECT * FROM pglogical.show_subscription_status(); LOG: manager worker [25855] at slot 1 generation 17 detaching cleanly LOG: manager worker [25856] at slot 1 generation 18 detaching cleanly LOG: starting apply for subscription subscription ERROR: subscriber subscription initialization failed during nonrecoverable step (d), please try the setup again LOG: apply worker [25879] at slot 1 generation 19 exiting with error LOG: worker process: pglogical apply 16384:2875150205 (PID 25879) exited with exit code 1 LOG: starting apply for subscription subscription ERROR: subscriber subscription initialization failed during nonrecoverable step (d), please try the setup again LOG: apply worker [25912] at slot 1 generation 20 exiting with error LOG: worker process: pglogical apply 16384:2875150205 (PID 25912) exited with exit code 1

eulerto commented 1 year ago

You didn't provide enough information. What's your pglogical version? Postgres version? Can you provide a reproducible test case?