Skip to content

Subscription failed to created replication slot on provider after upgrade from Version 13 to 17. #501

@sinaganti1

Description

@sinaganti1

We have multimaster pglogical replication on 13 and i ahve upgraded secondary side to version 17.
I could enable subscription on 17 by creating replication origin.
Having issues creating subscription on 13.
I think this could be issue with pglocical version difference in Postgresql version 13 and 17.
What can be done here. We are struck at this and what are our options.

Error from subscriber after upgrade:
2025-07-08 18:27:50.447 CDT [1535444] [unknown]@bp_testLOG: starting apply for subscription dev3_dev1
2025-07-08 18:27:50.496 CDT [1535444] [unknown]@bp_testERROR: could not create replication slot on provider: ERROR: syntax error
2025-07-08 18:27:50.496 CDT [1535444] [unknown]@bp_testLOG: apply worker [1535444] at slot 1 generation 481 exiting with error
2025-07-08 18:27:50.498 CDT [890] LOG: background worker "pglogical apply 16393:3126332838" (PID 1535444) exited with exit code 1

Subscriber:
bp_test=# select version(), pglogical.pglogical_version();
version | pglogical_version
-----------------------------------------------------------------------------------------------------------+-------------------
PostgreSQL 13.21 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5), 64-bit | 2.4.3
(1 row)
bp_test=# select * from pglogical.show_subscription_status();
subscription_name | status | provider_node | provider_dsn | slot_name | replication_sets | forward_origins
-------------------+--------+-------------------+-----------------------------------------------------------------------------------------+---------------------------------------+---------------------------------------+-----------------
dev3_dev1 | down | vfd2-bppostgres-3 | host=XXX port=5432 user=replica dbname=bp_test password=XXXX | pgl_bp_test_dev3_dev1 | {default,default_insert_only,ddl_sql} |
(1 row)

Provider:
bp_test=# select version(), pglogical.pglogical_version();
version | pglogical_version
----------------------------------------------------------------------------------------------------------+-------------------
PostgreSQL 17.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5), 64-bit | 2.4.5
(1 row)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions