search

xuxueli / xxl-job

A distributed task scheduling framework.（分布式任务调度平台XXL-JOB）
http://www.xuxueli.com/xxl-job/
GNU General Public License v3.0
27.89k stars 10.98k forks source link

xxl-job运行一段时间后，出现全部任务都停止调度问题 #2302

Open Raofy opened 3 years ago

Raofy commented 3 years ago

Please answer some questions before submitting your issue. Thanks!

Which version of XXL-JOB do you using?

2.2.0 mysql 8.0

Expected behavior

正常运行调度

Actual behavior

全部的任务都没有执行，admin程序没有调度任务

Steps to reproduce the behavior

  1. 首先，下午14：20分的时候发现任务没有调度
  2. 执行下面的SQL语句 
    use xxl_job
# 查看当前运行的所有事务
select * from information_schema.innodb_trx;

    得到的信息导出xml文件

    <select_from_information_schema_innodb_trx>
<DATA_RECORD>
<trx_id>16,435,508</trx_id>
<trx_state>RUNNING</trx_state>
<trx_started>2021-03-08 11:30:02</trx_started>
<trx_requested_lock_id></trx_requested_lock_id>
<trx_wait_started></trx_wait_started>
<trx_weight>2</trx_weight>
<trx_mysql_thread_id>154,582</trx_mysql_thread_id>
<trx_query></trx_query>
<trx_operation_state></trx_operation_state>
<trx_tables_in_use>0</trx_tables_in_use>
<trx_tables_locked>1</trx_tables_locked>
<trx_lock_structs>2</trx_lock_structs>
<trx_lock_memory_bytes>1,136</trx_lock_memory_bytes>
<trx_rows_locked>1</trx_rows_locked>
<trx_rows_modified>0</trx_rows_modified>
<trx_concurrency_tickets>0</trx_concurrency_tickets>
<trx_isolation_level>REPEATABLE READ</trx_isolation_level>
<trx_unique_checks>1</trx_unique_checks>
<trx_foreign_key_checks>1</trx_foreign_key_checks>
<trx_last_foreign_key_error></trx_last_foreign_key_error>
<trx_adaptive_hash_latched>0</trx_adaptive_hash_latched>
<trx_adaptive_hash_timeout>0</trx_adaptive_hash_timeout>
<trx_is_read_only>0</trx_is_read_only>
<trx_autocommit_non_locking>0</trx_autocommit_non_locking>
<trx_schedule_weight></trx_schedule_weight>
</DATA_RECORD>
</select_from_information_schema_innodb_trx>
  3. 查询MySQL线程id为154,582的信息 
    SELECT * FROM information_schema.`PROCESSLIST` WHERE id=154582;

    得到结果如下

    <SELECT_FROM_information_schema_PROCESSLIST_WHERE_id_154582>
<DATA_RECORD>
<ID>154,582</ID>
<USER>root</USER>
<HOST>172.17.0.1:29934</HOST>
<DB>xxl_job</DB>
<COMMAND>Sleep</COMMAND>
<TIME>10,580</TIME>
<STATE></STATE>
<INFO></INFO>
</DATA_RECORD>
</SELECT_FROM_information_schema_PROCESSLIST_WHERE_id_154582>
  4. 当执行下面SQL语句时候，xxl-job又可以正常调度了 
    kill 154582
  5. 出现问题到恢复正常的xxl-job-admin.log文件信息 
    
2021-03-08 11:35:09,083 INFO [http-nio-8096-exec-1] o.a.coyote.http11.Http11Processor [DirectJDKLog.java : 175] Error parsing HTTP request header
Note: further occurrences of HTTP request parsing errors will be logged at DEBUG level.
java.lang.IllegalArgumentException: Invalid character found in method name. HTTP method names must be tokens
at org.apache.coyote.http11.Http11InputBuffer.parseRequestLine(Http11InputBuffer.java:418)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:260)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1594)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
2021-03-08 14:26:43,634 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.zaxxer.hikari.pool.ProxyConnection [ProxyConnection.java : 157] HikariCP - Connection com.mysql.cj.jdbc.ConnectionImpl@42970217 marked as broken because of SQLSTATE(08S01), ErrorCode(0)
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet successfully received from the server was 10,601,598 milliseconds ago. The last packet sent successfully to the server was 10,601,603 milliseconds ago. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) at com.mysql.cj.jdbc.ConnectionImpl.commit(ConnectionImpl.java:814) at com.zaxxer.hikari.pool.ProxyConnection.commit(ProxyConnection.java:366) at com.zaxxer.hikari.pool.HikariProxyConnection.commit(HikariProxyConnection.java) at com.xxl.job.admin.core.thread.JobScheduleHelper$1.run(JobScheduleHelper.java:153) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet successfully received from the server was 10,601,598 milliseconds ago. The last packet sent successfully to the server was 10,601,603 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:539) at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:703) at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:642) at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:941) at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:887) at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1073) at com.mysql.cj.jdbc.ConnectionImpl.commit(ConnectionImpl.java:802) ... 4 common frames omitted Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:533) ... 10 common frames omitted 2021-03-08 14:26:43,636 ERROR [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 156] Communications link failure

The last packet successfully received from the server was 10,601,598 milliseconds ago. The last packet sent successfully to the server was 10,601,603 milliseconds ago. com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet successfully received from the server was 10,601,598 milliseconds ago. The last packet sent successfully to the server was 10,601,603 milliseconds ago. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) at com.mysql.cj.jdbc.ConnectionImpl.commit(ConnectionImpl.java:814) at com.zaxxer.hikari.pool.ProxyConnection.commit(ProxyConnection.java:366) at com.zaxxer.hikari.pool.HikariProxyConnection.commit(HikariProxyConnection.java) at com.xxl.job.admin.core.thread.JobScheduleHelper$1.run(JobScheduleHelper.java:153) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet successfully received from the server was 10,601,598 milliseconds ago. The last packet sent successfully to the server was 10,601,603 milliseconds ago. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:539) at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:703) at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:642) at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:941) at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:887) at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1073) at com.mysql.cj.jdbc.ConnectionImpl.commit(ConnectionImpl.java:802) ... 4 common frames omitted Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:533) ... 10 common frames omitted 2021-03-08 14:26:43,637 ERROR [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 163] Connection is closed java.sql.SQLException: Connection is closed at com.zaxxer.hikari.pool.ProxyConnection$ClosedConnection.lambda$getClosedConnection$0(ProxyConnection.java:494) at com.sun.proxy.$Proxy100.setAutoCommit(Unknown Source) at com.zaxxer.hikari.pool.ProxyConnection.setAutoCommit(ProxyConnection.java:393) at com.zaxxer.hikari.pool.HikariProxyConnection.setAutoCommit(HikariProxyConnection.java) at com.xxl.job.admin.core.thread.JobScheduleHelper$1.run(JobScheduleHelper.java:160) at java.lang.Thread.run(Thread.java:748) 2021-03-08 14:26:43,662 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 11 2021-03-08 14:26:43,663 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 27 2021-03-08 14:26:43,663 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 33 2021-03-08 14:26:43,663 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 34 2021-03-08 14:26:43,663 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 37 2021-03-08 14:26:43,663 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 38 2021-03-08 14:26:43,663 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 47 2021-03-08 14:26:43,664 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 52 2021-03-08 14:26:43,664 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 61 2021-03-08 14:26:43,664 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 66 2021-03-08 14:26:43,664 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 67 2021-03-08 14:26:43,664 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 74 2021-03-08 14:26:43,664 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 82 2021-03-08 14:26:43,665 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 89 2021-03-08 14:26:43,665 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 98 2021-03-08 14:26:43,665 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 101 2021-03-08 14:26:43,665 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 102 2021-03-08 14:26:43,665 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 110 2021-03-08 14:26:43,665 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 112 2021-03-08 14:26:43,666 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 117 2021-03-08 14:26:43,666 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 118 2021-03-08 14:26:43,666 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 123 2021-03-08 14:26:43,666 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 125 2021-03-08 14:26:43,666 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 126 2021-03-08 14:26:43,666 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 162 2021-03-08 14:26:43,666 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 174 2021-03-08 14:26:43,667 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 175 2021-03-08 14:26:43,667 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 180 2021-03-08 14:26:43,667 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 189 2021-03-08 14:26:43,667 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 191 2021-03-08 14:26:43,667 WARN [xxl-job, admin JobScheduleHelper#scheduleThread] c.x.j.a.c.thread.JobScheduleHelper [JobScheduleHelper.java : 87] >>>>>>>>>>> xxl-job, schedule misfire, jobId = 209

**这个情况xxl-job运行一段时间后，又会出现这个问题，kill掉相关的进程号之后又可以正常调度**
**这是什么原因导致的？？**
### Other information
xxl-job配置信息

```properties
### web
server.port=7300

server.servlet.context-path=/xxl-job-admin

### actuator
management.server.servlet.context-path=/actuator
management.health.mail.enabled=false

### resources
spring.mvc.servlet.load-on-startup=0
spring.mvc.static-path-pattern=/static/**
spring.resources.static-locations=classpath:/static/

### freemarker
spring.freemarker.templateLoaderPath=classpath:/templates/
spring.freemarker.suffix=.ftl
spring.freemarker.charset=UTF-8
spring.freemarker.request-context-attribute=request
spring.freemarker.settings.number_format=0.##########

### mybatis
mybatis.mapper-locations=classpath:/mybatis-mapper/*Mapper.xml

### xxl-job, datasource
spring.datasource.url=jdbc:mysql://localhost:3306/xxl_job?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&serverTimezone=Asia/Shanghai
#spring.datasource.username=root
#spring.datasource.password=123456@XXX.com

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

### datasource-pool
spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.hikari.minimum-idle=10
spring.datasource.hikari.maximum-pool-size=30
spring.datasource.hikari.auto-commit=true
spring.datasource.hikari.idle-timeout=30000
spring.datasource.hikari.pool-name=HikariCP
spring.datasource.hikari.max-lifetime=900000
spring.datasource.hikari.connection-timeout=10000
spring.datasource.hikari.connection-test-query=SELECT 1

### xxl-job, email
spring.mail.host=smtp.qq.com
spring.mail.port=25
spring.mail.username=xxx@qq.com
spring.mail.password=xxx
spring.mail.properties.mail.smtp.auth=true
spring.mail.properties.mail.smtp.starttls.enable=true
spring.mail.properties.mail.smtp.starttls.required=true
spring.mail.properties.mail.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory

### xxl-job, access token
xxl.job.accessToken=jin10

### xxl-job, i18n (default is zh_CN, and you can choose "zh_CN", "zh_TC" and "en")
xxl.job.i18n=zh_CN

## xxl-job, triggerpool max size
xxl.job.triggerpool.fast.max=200
xxl.job.triggerpool.slow.max=100

### xxl-job, log retention days
xxl.job.logretentiondays=5
Mihawk-lf commented 3 years ago

这是数据库连接的问题那。 你可以选择调整下连接参数，或者调整下mysql的配置信息那。

Raofy commented 3 years ago

@Mihawk-lf 也就是数据库连接池是没有问题的

wangshouyi323 commented 3 years ago

JobScheduleHelper 这个类，网上下载最新的版本，替换老版本，重新启动试试。 Connection conn = null; 是这个地方出了问题，数据库链接释放，但是Connection还在，应该每次都重新连接

Horus-K commented 3 years ago

我现在版本是2.1.0 也有这个问题，开发查原因是因为应用注册地址有通过vpn链接的本地ip，断开之后xxljob会一直尝试调度任务而造成连接池问题，大佬们有什么解决方法么