I always got this BinaryLog Client was unable to connect

asked 2018-10-04 21:31:11 -0600

Hi there,

I am connecting to Mysql 8 and I always receive the following error, any clue how to fix it? MYSQL_003 - Error connecting to MySql: java.util.concurrent.TimeoutException: BinaryLogClient was unable to connect in 5000ms

from the /var/log/ 0a7a0bba431-testmysql] ERROR ProductionPipelineRunnable - An exception occurred while running the pipeline, com.streamsets.pipeline.api.StageException: MYSQL_003 - Error connecting to MySql: java.util.concurrent.TimeoutException: BinaryLogClient was unable to connect in 5000ms com.streamsets.pipeline.api.StageException: MYSQL_003 - Error connecting to MySql: java.util.concurrent.TimeoutException: BinaryLogClient was unable to connect in 5000ms at com.streamsets.pipeline.stage.origin.mysql.MysqlSource.connectClient(MysqlSource.java:322) at com.streamsets.pipeline.stage.origin.mysql.MysqlSource.produce(MysqlSource.java:203) at com.streamsets.datacollector.runner.StageRuntime.lambda$execute$2(StageRuntime.java:283) at com.streamsets.pipeline.api.impl.CreateByRef.call(CreateByRef.java:40) at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:235) at com.streamsets.datacollector.runner.StageRuntime.execute(StageRuntime.java:298) at com.streamsets.datacollector.runner.StagePipe.process(StagePipe.java:244) at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunner.processPipe(ProductionPipelineRunner.java:804) at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunner.runPollSource(ProductionPipelineRunner.java:549) at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunner.run(ProductionPipelineRunner.java:384) at com.streamsets.datacollector.runner.Pipeline.run(Pipeline.java:528) at com.streamsets.datacollector.execution.runner.common.ProductionPipeline.run(ProductionPipeline.java:109) at com.streamsets.datacollector.execution.runner.common.ProductionPipelineRunnable.run(ProductionPipelineRunnable.java:74) at com.streamsets.datacollector.execution.runner.standalone.StandaloneRunner.start(StandaloneRunner.java:726) at com.streamsets.datacollector.execution.AbstractRunner.lambda$scheduleForRetries$0(AbstractRunner.java:357) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.lambda$call$0(SafeScheduledExecutorService.java:226) at com.streamsets.datacollector.security.GroupsInScope.execute(GroupsInScope.java:33) at com.streamsets.pipeline.lib.executor.SafeScheduledExecutorService$SafeCallable.call(SafeScheduledExecutorService.java:222) 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)

However, I can telnet the machine to the port number.

edit retag flag offensive close merge delete