flinkcdc 2.4.2 读取 pgsql， 能是什么原因？
flinkcdc 2.4.2 读取 pgsql， 使用
,'scan.startup.mode' = 'latest-offset'
,'scan.incremental.snapshot.enabled' = 'true'
, 'debezium.decimal.handling.mode' = 'string'
, 'debezium.table.include.list' = 'public.tmember\d*'
一直卡在
2024-05-09 12:03:35,891 INFO io.debezium.jdbc.JdbcConnection [] - Connection gracefully closed
2024-05-09 12:03:36,038 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Creating initial offset context
2024-05-09 12:03:36,051 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Read xlogStart at 'LSN{0/B80003B0}' from transaction '6969'
2024-05-09 12:04:29,792 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Creating initial offset context
2024-05-09 12:04:29,802 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Read xlogStart at 'LSN{0/B8000768}' from transaction '6971'
2024-05-09 12:05:21,405 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Creating initial offset context
2024-05-09 12:05:21,414 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Read xlogStart at 'LSN{0/B80007D0}' from transaction '6972'
2024-05-09 12:06:11,888 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Creating initial offset context
2024-05-09 12:06:11,897 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Read xlogStart at 'LSN{0/B9000000}' from transaction '6973'
2024-05-09 12:07:03,031 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Creating initial offset context
2024-05-09 12:07:03,041 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Read xlogStart at 'LSN{0/B9000090}' from transaction '6974'
2024-05-09 12:07:53,729 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Creating initial offset context
2024-05-09 12:07:53,738 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Read xlogStart at 'LSN{0/B90000F8}' from transaction '6975'
2024-05-09 12:08:44,847 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Creating initial offset context
2024-05-09 12:08:44,856 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Read xlogStart at 'LSN{0/B9000160}' from transaction '6976'
2024-05-09 12:09:35,399 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Creating initial offset context
2024-05-09 12:09:35,409 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Read xlogStart at 'LSN{0/B90001C8}' from transaction '6977'
2024-05-09 12:10:27,578 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Creating initial offset context
2024-05-09 12:10:27,587 INFO io.debezium.connector.postgresql.PostgresSnapshotChangeEventSource [] - Read xlogStart at 'LSN{0/B9000230}' from transaction '6978'可能是什么原因？
写回答
-
确保scan.startup.mode设置为latest-offset，并且debezium.table.include.list正确地包含了所有需要监控的表
可以通过scan.startup.mode参数来指定启动模式。如果设置为latest-offset，连接器应该会从上一次停止时的最新偏移量继续读取。但是，从您的日志来看，连接器似乎每次都是从xlogStart的位置开始，这可能意味着它没有找到上一次的偏移量，或者配置有误2024-05-15 08:38:18赞同 展开评论 打赏
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
实时计算Flink版是阿里云提供的全托管Serverless Flink云服务，基于 Apache Flink 构建的企业级、高性能实时大数据处理系统。提供全托管版 Flink 集群和引擎，提高作业开发运维效率。
