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

ykejflvf  于 2021-12-06  发布在  Java
关注(0)|答案(4)|浏览(691)

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>
  1. 查询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>
  1. 当执行下面SQL语句时候，xxl-job又可以正常调度了
kill 154582
  1. 出现问题到恢复正常的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配置信息


### 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
xxl-job

4条答案

按热度按时间
ki0zmccv

ki0zmccv1#

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

赞(0）分享  回复(0）举报  2021-12-06
lymnna71

lymnna712#

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

赞(0）分享  回复(0）举报  2021-12-06
qij5mzcb

qij5mzcb3#

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

赞(0）分享  回复(0）举报  2021-12-06
pvabu6sv

pvabu6sv4#

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

赞(0）分享  回复(0）举报  2021-12-06
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com