增量表首日全量同步时,产生报错,如何解决?(标签-hadoop|关键词-connect)

问题遇到的现象和发生背景

配置Maxwell中,做增量表首日全量同步时,产生报错,我到网上找了很多方法,也解决不了

运行结果及报错内容

[navicat@hadoop101 bin]$ mysql_to_kafka_inc_init.sh all

[mysql-connector-java-8.0.17.jar:8.0.17]

33791 [WARN] BasicResourcePool: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@4135c3b is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests.
33810 [ERROR] MaxwellBootstrapUtility: failed to connect to mysql server @ jdbc:mysql://hadoop101:3306/maxwell?allowPublicKeyRetrieval=true&connectTimeout=5000&serverTimezone=Asia%2FShanghai&zeroDateTimeBehavior=convertToNull&useSSL=false
33810 [ERROR] MaxwellBootstrapUtility: Connections could not be acquired from the underlying database!
java.sql.SQLException: Connections could not be acquired from the underlying database!

我的解答思路和尝试过的方法

我的数据库是mysql5.7,maxwell的lib目录下的jar包是这个mysql-connector-java-8.0.17.jar
我替换maxwell的lib目录下的jar包,可结果连接不上MySQL数据库,而且我看了配置文件也没有问题。同时,对照其大数据项目之电商数仓(2业务数据采集平台)的文档来做,依然报错。

img

img