备案控制台
探索云世界
开发者社区 数据库 文章 正文

flink1.17提交cdc作业模式遇到的超时问题

2023-12-27 103
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
本文涉及的产品
实时计算 Flink 版，5000CU*H 3个月
推荐场景：
实时发现最热Github项目
云数据库 RDS MySQL Serverless，0.5-2RCU 50GB
推荐场景：
学生管理系统数据库设计 搭建个人博客
云数据库 RDS MySQL Serverless，价值2615元额度，1个月
简介： 各位大佬请教个问题，我在83服务器上部署了一个Flink1.17 ，然后我有两个mysql数据库，分别部署在63服务器和81服务上了，我在往83提交cdc作业时（链接的是81服务器上的数据库），前面几个任务能正常提交，后面再提交报超时（jdbc模式可以正常提交），为了验证cdc连接数，我把后面的任务链接的数据库服务器改为了63，可以正常提交，有人遇到过吗
  • 各位大佬请教个问题，我在83服务器上部署了一个Flink1.17 ，然后我有两个mysql数据库，分别部署在63服务器和81服务上了，我在往83提交cdc作业时（链接的是81服务器上的数据库），前面几个任务能正常提交，后面再提交报超时（jdbc模式可以正常提交），为了验证cdc连接数，我把后面的任务链接的数据库服务器改为了63，可以正常提交，有人遇到过吗
    2023-12-27 10:58:33,813 INFO org.apache.flink.runtime.executiongraph.ExecutionGraph [] - Job test (3f6489605981317c4125d5cc966aeecd) switched from state FAILING to FAILED.
    org.apache.flink.runtime.JobException: Recovery is suppressed by FixedDelayRestartBackoffTimeStrategy(maxNumberRestartAttempts=3, backoffTimeMS=5000)
    at org.apache.flink.runtime.executiongraph.failover.flip1.ExecutionFailureHandler.handleFailure(ExecutionFailureHandler.java:139) ~[flink-dist-1.17.0.jar:1.17.0]
    at org.apache.flink.runtime.executiongraph.failover.flip1.ExecutionFailureHandler.getGlobalFailureHandlingResult(ExecutionFailureHandler.java:102) ~[flink-dist-1.17.0.jar:1.17.0]
    at org.apache.flink.runtime.scheduler.DefaultScheduler.handleGlobalFailure(DefaultScheduler.java:301) ~[flink-dist-1.17.0.jar:1.17.0]
    at org.apache.flink.runtime.operators.coordination.OperatorCoordinatorHolder$LazyInitializedCoordinatorContext.lambda$failJob$0(OperatorCoordinatorHolder.java:618) ~[flink-dist-1.17.0.jar:1.17.0]
    at org.apache.flink.runtime.rpc.akka.AkkaRpcActor.lambda$handleRunAsync$4(AkkaRpcActor.java:453) ~[flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at org.apache.flink.runtime.concurrent.akka.ClassLoadingUtils.runWithContextClassLoader(ClassLoadingUtils.java:68) ~[flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at org.apache.flink.runtime.rpc.akka.AkkaRpcActor.handleRunAsync(AkkaRpcActor.java:453) ~[flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at org.apache.flink.runtime.rpc.akka.AkkaRpcActor.handleRpcMessage(AkkaRpcActor.java:218) ~[flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at org.apache.flink.runtime.rpc.akka.FencedAkkaRpcActor.handleRpcMessage(FencedAkkaRpcActor.java:84) ~[flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at org.apache.flink.runtime.rpc.akka.AkkaRpcActor.handleMessage(AkkaRpcActor.java:168) ~[flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at akka.japi.pf.UnitCaseStatement.apply(CaseStatements.scala:24) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at akka.japi.pf.UnitCaseStatement.apply(CaseStatements.scala:20) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at scala.PartialFunction.applyOrElse(PartialFunction.scala:127) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at scala.PartialFunction.applyOrElse$(PartialFunction.scala:126) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at akka.japi.pf.UnitCaseStatement.applyOrElse(CaseStatements.scala:20) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at scala.PartialFunction$OrElse.applyOrElse(PartialFunction.scala:175) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at scala.PartialFunction$OrElse.applyOrElse(PartialFunction.scala:176) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at scala.PartialFunction$OrElse.applyOrElse(PartialFunction.scala:176) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at akka.actor.Actor.aroundReceive(Actor.scala:537) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at akka.actor.Actor.aroundReceive$(Actor.scala:535) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at akka.actor.AbstractActor.aroundReceive(AbstractActor.scala:220) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at akka.actor.ActorCell.receiveMessage(ActorCell.scala:579) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at akka.actor.ActorCell.invoke(ActorCell.scala:547) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:270) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at akka.dispatch.Mailbox.run(Mailbox.scala:231) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at akka.dispatch.Mailbox.exec(Mailbox.scala:243) [flink-rpc-akka_dfc51966-50ff-45ae-8101-fd9d47ccf617.jar:1.17.0]
    at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289) [?:1.8.0_392]
    at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056) [?:1.8.0_392]
    at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692) [?:1.8.0_392]
    at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:175) [?:1.8.0_392]
    Caused by: org.apache.flink.util.FlinkException: Global failure triggered by OperatorCoordinator for 'Source: source_osi_inspection_task[8]' (operator 605b35e407e90cda15ad084365733fdd).
    at org.apache.flink.runtime.operators.coordination.OperatorCoordinatorHolder$LazyInitializedCoordinatorContext.failJob(OperatorCoordinatorHolder.java:600) ~[flink-dist-1.17.0.jar:1.17.0]
    at org.apache.flink.runtime.operators.coordination.RecreateOnResetOperatorCoordinator$QuiesceableContext.failJob(RecreateOnResetOperatorCoordinator.java:237) ~[flink-dist-1.17.0.jar:1.17.0]
    at org.apache.flink.runtime.source.coordinator.SourceCoordinatorContext.failJob(SourceCoordinatorContext.java:374) ~[flink-dist-1.17.0.jar:1.17.0]
    at org.apache.flink.runtime.source.coordinator.SourceCoordinator.lambda$runInEventLoop$10(SourceCoordinator.java:463) ~[flink-dist-1.17.0.jar:1.17.0]
    at org.apache.flink.util.ThrowableCatchingRunnable.run(ThrowableCatchingRunnable.java:40) ~[flink-dist-1.17.0.jar:1.17.0]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_392]
    at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_392]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) ~[?:1.8.0_392]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) ~[?:1.8.0_392]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_392]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_392]
    at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_392]
    Caused by: org.apache.flink.util.FlinkRuntimeException: org.apache.flink.util.FlinkRuntimeException: java.sql.SQLTransientConnectionException: connection-pool-10.70.10.81:3306 - Connection is not available, request timed out after 30000ms.
    at com.ververica.cdc.connectors.mysql.debezium.DebeziumUtils.openJdbcConnection(DebeziumUtils.java:71) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.source.assigners.MySqlChunkSplitter.open(MySqlChunkSplitter.java:112) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.source.assigners.MySqlSnapshotSplitAssigner.open(MySqlSnapshotSplitAssigner.java:168) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.source.assigners.MySqlHybridSplitAssigner.open(MySqlHybridSplitAssigner.java:93) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.source.enumerator.MySqlSourceEnumerator.start(MySqlSourceEnumerator.java:87) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at org.apache.flink.runtime.source.coordinator.SourceCoordinator.lambda$start$1(SourceCoordinator.java:225) ~[flink-dist-1.17.0.jar:1.17.0]
    at org.apache.flink.runtime.source.coordinator.SourceCoordinator.lambda$runInEventLoop$10(SourceCoordinator.java:449) ~[flink-dist-1.17.0.jar:1.17.0]
    at org.apache.flink.util.ThrowableCatchingRunnable.run(ThrowableCatchingRunnable.java:40) ~[flink-dist-1.17.0.jar:1.17.0]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_392]
    at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_392]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) ~[?:1.8.0_392]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) ~[?:1.8.0_392]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_392]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_392]
    at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_392]
    Caused by: org.apache.flink.util.FlinkRuntimeException: java.sql.SQLTransientConnectionException: connection-pool-10.70.10.81:3306 - Connection is not available, request timed out after 30000ms.
    at com.ververica.cdc.connectors.mysql.source.connection.JdbcConnectionFactory.connect(JdbcConnectionFactory.java:72) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:888) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:883) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at io.debezium.jdbc.JdbcConnection.connect(JdbcConnection.java:411) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.debezium.DebeziumUtils.openJdbcConnection(DebeziumUtils.java:68) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.source.assigners.MySqlChunkSplitter.open(MySqlChunkSplitter.java:112) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.source.assigners.MySqlSnapshotSplitAssigner.open(MySqlSnapshotSplitAssigner.java:168) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.source.assigners.MySqlHybridSplitAssigner.open(MySqlHybridSplitAssigner.java:93) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.source.enumerator.MySqlSourceEnumerator.start(MySqlSourceEnumerator.java:87) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at org.apache.flink.runtime.source.coordinator.SourceCoordinator.lambda$start$1(SourceCoordinator.java:225) ~[flink-dist-1.17.0.jar:1.17.0]
    at org.apache.flink.runtime.source.coordinator.SourceCoordinator.lambda$runInEventLoop$10(SourceCoordinator.java:449) ~[flink-dist-1.17.0.jar:1.17.0]
    at org.apache.flink.util.ThrowableCatchingRunnable.run(ThrowableCatchingRunnable.java:40) ~[flink-dist-1.17.0.jar:1.17.0]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_392]
    at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_392]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) ~[?:1.8.0_392]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) ~[?:1.8.0_392]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_392]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_392]
    at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_392]
    Caused by: java.sql.SQLTransientConnectionException: connection-pool-10.70.10.81:3306 - Connection is not available, request timed out after 30000ms.
    at com.ververica.cdc.connectors.shaded.com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.shaded.com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.shaded.com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.shaded.com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.source.connection.JdbcConnectionFactory.connect(JdbcConnectionFactory.java:59) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:888) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:883) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at io.debezium.jdbc.JdbcConnection.connect(JdbcConnection.java:411) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.debezium.DebeziumUtils.openJdbcConnection(DebeziumUtils.java:68) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.source.assigners.MySqlChunkSplitter.open(MySqlChunkSplitter.java:112) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.source.assigners.MySqlSnapshotSplitAssigner.open(MySqlSnapshotSplitAssigner.java:168) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.source.assigners.MySqlHybridSplitAssigner.open(MySqlHybridSplitAssigner.java:93) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at com.ververica.cdc.connectors.mysql.source.enumerator.MySqlSourceEnumerator.start(MySqlSourceEnumerator.java:87) ~[flink-sql-connector-mysql-cdc-2.4.0.jar:2.4.0]
    at org.apache.flink.runtime.source.coordinator.SourceCoordinator.lambda$start$1(SourceCoordinator.java:225) ~[flink-dist-1.17.0.jar:1.17.0]
    at org.apache.flink.runtime.source.coordinator.SourceCoordinator.lambda$runInEventLoop$10(SourceCoordinator.java:449) ~[flink-dist-1.17.0.jar:1.17.0]
    at org.apache.flink.util.ThrowableCatchingRunnable.run(ThrowableCatchingRunnable.java:40) ~[flink-dist-1.17.0.jar:1.17.0]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[?:1.8.0_392]
    at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_392]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) ~[?:1.8.0_392]
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) ~[?:1.8.0_392]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_392]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_392]
    at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_392]
    2023-12-27 10:58:33,815 INFO org.apache.flink.runtime.checkpoint.CheckpointCoordinator [] - Stopping checkpoint coordinator for job 3f6489605981317c4125d5cc966aeecd.
    2023-12-27 10:58:33,822 INFO org.apache.flink.runtime.dispatcher.StandaloneDispatcher [] - Job 3f6489605981317c4125d5cc966aeecd reached terminal state FAILED.
    org.apache.flink.util.FlinkException: Global failure triggered by OperatorCoordinator for 'Source: source_osi_inspection_project[3]' (operator feca28aff5a3958840bee985ee7de4d3).
    at org.apache.flink.runtime.operators.coordination.OperatorCoordinatorHolder$LazyInitializedCoordinatorContext.failJob(OperatorCoordinatorHolder.java:600)
    at org.apache.flink.runtime.operators.coordination.RecreateOnResetOperatorCoordinator$QuiesceableContext.failJob(RecreateOnResetOperatorCoordinator.java:237)
    at org.apache.flink.runtime.source.coordinator.SourceCoordinatorContext.failJob(SourceCoordinatorContext.java:374)
    at org.apache.flink.runtime.source.coordinator.SourceCoordinator.lambda$runInEventLoop$10(SourceCoordinator.java:463)
    at org.apache.flink.util.ThrowableCatchingRunnable.run(ThrowableCatchingRunnable.java:40)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
    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.apache.flink.util.FlinkRuntimeException: Failed to discovery tables to capture
    at com.ververica.cdc.connectors.mysql.source.assigners.MySqlSnapshotSplitAssigner.discoveryCaptureTables(MySqlSnapshotSplitAssigner.java:184)
    at com.ververica.cdc.connectors.mysql.source.assigners.MySqlSnapshotSplitAssigner.open(MySqlSnapshotSplitAssigner.java:169)
    at com.ververica.cdc.connectors.mysql.source.assigners.MySqlHybridSplitAssigner.open(MySqlHybridSplitAssigner.java:93)
    at com.ververica.cdc.connectors.mysql.source.enumerator.MySqlSourceEnumerator.start(MySqlSourceEnumerator.java:87)
    at org.apache.flink.runtime.source.coordinator.SourceCoordinator.lambda$start$1(SourceCoordinator.java:225)
    at org.apache.flink.runtime.source.coordinator.SourceCoordinator.lambda$runInEventLoop$10(SourceCoordinator.java:449)
    ... 8 more
    Caused by: org.apache.flink.util.FlinkRuntimeException: org.apache.flink.util.FlinkRuntimeException: java.sql.SQLTransientConnectionException: connection-pool-10.70.10.81:3306 - Connection is not available, request timed out after 30000ms.
    at com.ververica.cdc.connectors.mysql.debezium.DebeziumUtils.openJdbcConnection(DebeziumUtils.java:71)
    at com.ververica.cdc.connectors.mysql.source.assigners.MySqlSnapshotSplitAssigner.discoveryCaptureTables(MySqlSnapshotSplitAssigner.java:179)
    ... 13 more
    Caused by: org.apache.flink.util.FlinkRuntimeException: java.sql.SQLTransientConnectionException: connection-pool-10.70.10.81:3306 - Connection is not available, request timed out after 30000ms.
    at com.ververica.cdc.connectors.mysql.source.connection.JdbcConnectionFactory.connect(JdbcConnectionFactory.java:72)
    at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:888)
    at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:883)
    at io.debezium.jdbc.JdbcConnection.connect(JdbcConnection.java:411)
    at com.ververica.cdc.connectors.mysql.debezium.DebeziumUtils.openJdbcConnection(DebeziumUtils.java:68)
    ... 14 more
    Caused by: java.sql.SQLTransientConnectionException: connection-pool-10.70.10.81:3306 - Connection is not available, request timed out after 30000ms.
    at com.ververica.cdc.connectors.shaded.com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
    at com.ververica.cdc.connectors.shaded.com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
    at com.ververica.cdc.connectors.shaded.com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
    at com.ververica.cdc.connectors.shaded.com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
    at com.ververica.cdc.connectors.mysql.source.connection.JdbcConnectionFactory.connect(JdbcConnectionFactory.java:59)
    ... 18 more
文章标签：
实时计算 Flink版
云数据库 RDS MySQL 版
数据库
Java
关系型数据库
MySQL
数据库连接
关键词：
实时计算 Flink版作业
实时计算 Flink版模式
实时计算 Flink版超时
实时计算 Flink版cdc模式
实时计算 Flink版cdc作业超时
相关实践学习
基于Hologres轻松玩转一站式实时仓库
本场景介绍如何利用阿里云MaxCompute、实时计算Flink和交互式分析服务Hologres开发离线、实时数据融合分析的数据大屏应用。
Linux入门到精通
本套课程是从入门开始的Linux学习课程，适合初学者阅读。由浅入深案例丰富，通俗易懂。主要涉及基础的系统操作以及工作中常用的各种服务软件的应用、部署和优化。即使是零基础的学员，只要能够坚持把所有章节都学完，也一定会受益匪浅。
游客f3wsbz3d3mvme
目录
相关文章
vohelon
|
2月前
|
消息中间件 Java Kafka
Flink CDC 在外部查询某个 job 中的表数据
【2月更文挑战第27天】Flink CDC 在外部查询某个 job 中的表数据
vohelon
44 5
sunrr
|
2月前
|
API 数据库 流计算
有大佬知道在使用flink cdc实现数据同步，如何实现如果服务停止了对数据源表的某个数据进行删除操作，重启服务之后目标表能进行对源表删除的数据进行删除吗？
【2月更文挑战第27天】有大佬知道在使用flink cdc实现数据同步，如何实现如果服务停止了对数据源表的某个数据进行删除操作，重启服务之后目标表能进行对源表删除的数据进行删除吗？
sunrr
55 3
灵杰开发者
|
15天前
|
SQL 运维 DataWorks
Flink CDC在阿里云DataWorks数据集成应用实践
本文整理自阿里云 DataWorks 数据集成团队的高级技术专家 王明亚（云时）老师在 Flink Forward Asia 2023 中数据集成专场的分享。
灵杰开发者
473 2
Flink CDC在阿里云DataWorks数据集成应用实践
sunrr
|
2月前
|
消息中间件 Kafka 流计算
如果有多个版本的Flink CDC在同一环境中运行，可能会导致Debezium版本冲突
【2月更文挑战第30天】如果有多个版本的Flink CDC在同一环境中运行，可能会导致Debezium版本冲突
sunrr
20 2
灵杰开发者
|
2月前
|
消息中间件 API Apache
官宣｜阿里巴巴捐赠的 Flink CDC 项目正式加入 Apache 基金会
本文整理自阿里云开源大数据平台徐榜江 (雪尽)，关于阿里巴巴捐赠的 Flink CDC 项目正式加入 Apache 基金会。
灵杰开发者
1425 1
官宣｜阿里巴巴捐赠的 Flink CDC 项目正式加入 Apache 基金会
sunrr
|
2月前
|
Java 关系型数据库 MySQL
Flink CDC有见这个报错不？
【2月更文挑战第29天】Flink CDC有见这个报错不？
sunrr
25 2
sunrr
|
2月前
|
存储 数据库 流计算
Flink CDC 3.0 对于字符串类型的切片键（sharding key）确实存在一些问题
【2月更文挑战第29天】Flink CDC 3.0 对于字符串类型的切片键（sharding key）确实存在一些问题
sunrr
17 5
sunrr
|
3月前
|
消息中间件 Kafka Apache
Apache Flink 是一个开源的分布式流处理框架
Apache Flink 是一个开源的分布式流处理框架
sunrr
485 5
灵杰开发者
|
2月前
|
SQL Java API
官宣｜Apache Flink 1.19 发布公告
Apache Flink PMC（项目管理委员）很高兴地宣布发布 Apache Flink 1.19.0。
灵杰开发者
1368 1
官宣｜Apache Flink 1.19 发布公告
sunrr
|
2月前
|
SQL Apache 流计算
Apache Flink官方网站提供了关于如何使用Docker进行Flink CDC测试的文档
【2月更文挑战第25天】Apache Flink官方网站提供了关于如何使用Docker进行Flink CDC测试的文档
sunrr
147 3

热门文章

最新文章

  • 1
    Flink常见面试问题(附答案)
  • 2
    【Flink】Flink中的窗口分析
  • 3
    【Flink】Flink的三种时间语义
  • 4
    【Flink】Flink集群有哪些角色？各自有什么作用？
  • 5
    【Flink】Flink跟Spark Streaming的区别？
  • 6
    【Flink】Flink的CEP机制
  • 7
    Flink实时流处理框架原理与应用：面试经验与必备知识点解析
  • 8
    【Flink】怎么提交的实时任务，有多少Job Manager？
  • 9
    flink最新master代码编译出现Java Runtime Environment 问题
  • 10
    面经：Storm实时计算框架原理与应用场景
  • 1
    在Kubernetes上运行Flink应用程序时
    38
  • 2
    Flink CDC产品常见问题之大文件整库同步怎么解决
    74
  • 3
    Flink CDC产品常见问题之mysql整库同步到starrock时任务挂掉如何解决
    41
  • 4
    Flink CDC产品常见问题之look up hint 没有生效如何解决
    808
  • 5
    Flink CDC产品常见问题之写hudi的时候报错如何解决
    406
  • 6
    Flink CDC产品常见问题之tidb cdc 数据量大了就疯狂报空指针如何解决
    438
  • 7
    Flink CDC产品常见问题之pg cdc程序已经停了但是执行删不掉如何解决
    234
  • 8
    Flink CDC产品常见问题之没有报错但是一直监听不到数据如何解决
    47
  • 9
    Flink CDC产品常见问题之flink集群jps命令报错如何解决
    31
  • 10
    Flink CDC产品常见问题之mysql整库同步到starrock时任务挂掉如何解决
    66

    • 相关课程

    更多
  • 实时计算 Flink 版产品入门与实操
  • 开源 Flink 极速上手教程
  • 大数据实时计算框架Spark快速入门
  • Apache Flink 入门

    • 相关电子书

    更多
  • Flink CDC Meetup PPT - 龚中强
  • Flink CDC Meetup PPT - 王赫
  • Flink CDC Meetup PPT - 覃立辉

    • 相关实验场景

    更多
  • XXL-JOB零改造迁移
  • 使用PolarDB-X与Flink搭建实时数据大屏
  • 使用Flink实时发现最热Github项目
  • 5分钟上手Flink MySQL连接器
  • 基于Flink+Tair搭建实时监控大屏
    • 下一篇
    2024年阿里云免费云服务器及学生云服务器申请教程参考