search

xuxueli / xxl-job

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

18:16:37.214 logback [xxl-job, admin JobRegistryMonitorHelper] ERROR c.x.j.a.c.t.JobRegistryMonitorHelper - >>>>>>>>>>> xxl-job, job registry monitor thread error:{} org.springframework.dao.CannotAcquireLockException: ### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction ### The error may exist in class path resource [mybatis-mapper/XxlJobGroupMapper.xml] ### The error may involve com.xxl.job.admin.dao.XxlJobGroupDao.update-Inline ### The error occurred while setting parameters ### SQL: UPDATE xxl_job_group SET `app_name` = ?, `title` = ?, `address_type` = ?, `address_list` = ? WHERE id = ? ### Cause: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction ; Lock wait timeout exceeded; try r #1778

Closed pig-stdv closed 4 years ago

pig-stdv commented 4 years ago

Please answer some questions before submitting your issue. Thanks!

Which version of XXL-JOB do you using?

Expected behavior

Actual behavior

Steps to reproduce the behavior

Other information

xuxueli commented 4 years ago

你好，问题无法复现，需要进一步提供版本、集群配置和复现步骤信息。

pig-stdv commented 4 years ago

最新版本，报死锁的错误

pig-stdv commented 4 years ago

请教一下，业务程序注册到xxl-job-admin 我现在写了 2个节点地址，是不是写ng的地址比较好。死锁是这个导致的么