开发者社区 > 大数据与机器学习 > 实时计算 Flink > 正文

flink cdc postgres运行起来报这个错是什么原因?

flink cdc postgres运行起来报这个错是什么原因?2024-04-10 10:31:16
io.debezium.DebeziumException: Creation of replication slot failed; when setting up multiple connectors for the same database host, please make sure to use a distinct replication slot name for each.
at io.debezium.connector.postgresql.PostgresConnectorTask.start(PostgresConnectorTask.java:144)
at io.debezium.connector.common.BaseSourceTask.start(BaseSourceTask.java:133)
at io.debezium.embedded.EmbeddedEngine.run(EmbeddedEngine.java:760)
at io.debezium.embedded.ConvertingEngineBuilder$2.run(ConvertingEngineBuilder.java:192)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
Caused by: org.postgresql.util.PSQLException: ERROR: replication slot "sink_test_cdc1" already exists
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:329)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:315)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:291)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:286)
at io.debezium.connector.postgresql.connection.PostgresReplicationConnection.createReplicationSlot(PostgresReplicationConnection.java:442)
at io.debezium.connector.postgresql.PostgresConnectorTask.start(PostgresConnectorTask.java:137)
... 6 moreb704ddc51755837e020eb4d5897b1d47.png这个不是重点,重点是Creation of replication slot failed;换了slotname后还有,postgreSql.conf要怎么配置,我按照网上说的配也不行,别的文章说pg_hba.conf也要改配置.postgres配置文件要改,但不知道改哪些,官网也没说.改了后报了这个错误是什么原因啊?2024-04-10 11:03:12
org.apache.kafka.connect.errors.ConnectException: Error configuring an instance of PostgresConnectorTask; check the logs for details
at io.debezium.connector.common.BaseSourceTask.start(BaseSourceTask.java:123)
at io.debezium.embedded.EmbeddedEngine.run(EmbeddedEngine.java:760)
at io.debezium.embedded.ConvertingEngineBuilder$2.run(ConvertingEngineBuilder.java:192)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)org.apache.kafka.connect.errors.ConnectException: Error configuring an instance of PostgresConnectorTask; check the logs for details
at io.debezium.connector.common.BaseSourceTask.start(BaseSourceTask.java:123)
at io.debezium.embedded.EmbeddedEngine.run(EmbeddedEngine.java:760)
at io.debezium.embedded.ConvertingEngineBuilder$2.run(ConvertingEngineBuilder.java:192)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)

展开
收起
小小鹿鹿鹿 2024-04-15 19:56:44 20 0
1 条回答
写回答
取消 提交回答
  • Caused by: org.postgresql.util.PSQLException: ERROR: replication slot "sink_test_cdc1" already exists。此回答来自钉群Flink CDC 社区。

    2024-04-15 22:08:05
    赞同 2 展开评论 打赏

实时计算Flink版是阿里云提供的全托管Serverless Flink云服务,基于 Apache Flink 构建的企业级、高性能实时大数据处理系统。提供全托管版 Flink 集群和引擎,提高作业开发运维效率。

相关电子书

更多
Flink CDC Meetup PPT - 龚中强 立即下载
Flink CDC Meetup PPT - 王赫 立即下载
Flink CDC Meetup PPT - 覃立辉 立即下载