LogicJake/WebMonitor

部分任务到时时未运行

Opened this issue · 0 comments

StephanoGeorge commented

Describe the bug

部分任务到时时未运行

To Reproduce

Steps to reproduce the behavior:

  1. 添加数十条网页任务，间隔10分钟
  2. 等待运行

Expected behavior

到时时即运行

Desktop (please complete the following information):

  • OS: Ubuntu
  • Browser Chromium
  • Version Docker IMAGE ID bcc14cd47e9e

Additional context

task_3 的上次运行时间为 2022年7月25日 16:46。在 task_3 最近一次到期后，其上次运行时间还是未更新，虽然 django_apscheduler_djangojob 中的 next_run_time 已更新。

在我查看时也有部分任务在10分钟内运行过，但我没有查看其是否每次都会运行

sqlite> select * from django_apscheduler_djangojob;
id|name|job_state|next_run_time
1|ping|���|2022-07-25 18:05:17.817409
274|task_1|���|2022-07-25 20:05:46.385064
534|task_3|���|2022-07-25 18:06:26.036974
543|task_5|���|2022-07-25 18:11:10.558864
550|task_4|���|2022-07-25 18:11:33.638833
553|task_6|���|2022-07-25 18:06:43.647668
554|task_9|���|2022-07-25 18:08:47.317480
555|task_7|���|2022-07-25 18:09:15.496075
557|task_11|���|2022-07-25 18:09:27.665859
558|task_10|���|2022-07-25 18:11:39.212112
559|task_8|���|2022-07-25 18:13:24.355637
sqlite> select * from django_apscheduler_djangojob;
id|name|job_state|next_run_time
1|ping|���|2022-07-25 18:07:17.817409
274|task_1|���|2022-07-25 20:05:46.385064
534|task_3|���|2022-07-25 18:16:26.036974
543|task_5|���|2022-07-25 18:11:10.558864
550|task_4|���|2022-07-25 18:11:33.638833
553|task_6|���|2022-07-25 18:06:43.647668
554|task_9|���|2022-07-25 18:08:47.317480
555|task_7|���|2022-07-25 18:09:15.496075
557|task_11|���|2022-07-25 18:09:27.665859
558|task_10|���|2022-07-25 18:11:39.212112
559|task_8|���|2022-07-25 18:13:24.355637
sqlite> select count(*) from django_apscheduler_djangojobexecution;
count(*)
546

日志：

2022-07-25 17:45:17,844 [ThreadPoolExecutor-0_1:140643686913792] [views:ping:9] [INFO]- pong!!
2022-07-25 17:46:17,860 [ThreadPoolExecutor-0_9:140642722244352] [views:ping:9] [INFO]- pong!!
2022-07-25 17:46:38,562 [ThreadPoolExecutor-0_5:140643108112128] [scheduler:monitor:145] [INFO]- rule: , content: 已答复 1, last_content: 已答复 1, status_code: 0
2022-07-25 17:46:38,587 [ThreadPoolExecutor-0_5:140643108112128] [scheduler:add_job:223] [INFO]- 添加定时任务task_6
2022-07-25 17:47:17,825 [ThreadPoolExecutor-0_3:140643124897536] [views:ping:9] [INFO]- pong!!
2022-07-25 17:48:17,861 [ThreadPoolExecutor-0_6:140643099719424] [views:ping:9] [INFO]- pong!!
2022-07-25 17:48:42,939 [ThreadPoolExecutor-0_2:140643133290240] [scheduler:monitor:145] [INFO]- rule: , content: 待处理 0, last_content: 待处理 0, status_code: 0
2022-07-25 17:48:42,965 [ThreadPoolExecutor-0_2:140643133290240] [scheduler:add_job:223] [INFO]- 添加定时任务task_9
2022-07-25 17:49:09,287 [ThreadPoolExecutor-0_7:140643091326720] [scheduler:monitor:145] [INFO]- rule: , content: 待处理 1, last_content: 待处理 1, status_code: 0
2022-07-25 17:49:09,312 [ThreadPoolExecutor-0_7:140643091326720] [scheduler:add_job:223] [INFO]- 添加定时任务task_7
2022-07-25 17:49:17,822 [ThreadPoolExecutor-0_4:140643116504832] [views:ping:9] [INFO]- pong!!
2022-07-25 17:50:17,864 [ThreadPoolExecutor-0_8:140643082934016] [views:ping:9] [INFO]- pong!!
2022-07-25 17:51:17,851 [ThreadPoolExecutor-0_5:140643108112128] [views:ping:9] [INFO]- pong!!
2022-07-25 17:51:33,323 [ThreadPoolExecutor-0_3:140643124897536] [scheduler:monitor:145] [INFO]- rule: , content: 待处理 0, last_content: , status_code: 3
2022-07-25 17:51:33,616 [ThreadPoolExecutor-0_1:140643686913792] [scheduler:monitor:145] [INFO]- rule: , content: 已答复 2, last_content: 已答复 2, status_code: 0
2022-07-25 17:51:33,646 [ThreadPoolExecutor-0_1:140643686913792] [scheduler:add_job:223] [INFO]- 添加定时任务task_4
2022-07-25 17:51:33,762 [ThreadPoolExecutor-0_3:140643124897536] [scheduler:add_job:223] [INFO]- 添加定时任务task_10
2022-07-25 17:52:17,861 [ThreadPoolExecutor-0_2:140643133290240] [views:ping:9] [INFO]- pong!!
2022-07-25 17:52:51,846 [ThreadPoolExecutor-0_6:140643099719424] [scheduler:monitor:145] [INFO]- rule: , content: 待处理 0, last_content: 待处理 0, status_code: 0
2022-07-25 17:52:51,871 [ThreadPoolExecutor-0_6:140643099719424] [scheduler:add_job:223] [INFO]- 添加定时任务task_8
2022-07-25 17:53:17,823 [ThreadPoolExecutor-0_7:140643091326720] [views:ping:9] [INFO]- pong!!
2022-07-25 17:54:17,865 [ThreadPoolExecutor-0_4:140643116504832] [views:ping:9] [INFO]- pong!!
2022-07-25 17:55:17,870 [ThreadPoolExecutor-0_8:140643082934016] [views:ping:9] [INFO]- pong!!
2022-07-25 17:56:17,867 [ThreadPoolExecutor-0_5:140643108112128] [views:ping:9] [INFO]- pong!!
2022-07-25 17:56:43,627 [ThreadPoolExecutor-0_1:140643686913792] [scheduler:monitor:145] [INFO]- rule: , content: 已答复 1, last_content: 已答复 1, status_code: 0
2022-07-25 17:56:43,656 [ThreadPoolExecutor-0_1:140643686913792] [scheduler:add_job:223] [INFO]- 添加定时任务task_6
2022-07-25 17:57:17,823 [ThreadPoolExecutor-0_3:140643124897536] [views:ping:9] [INFO]- pong!!
2022-07-25 17:58:17,863 [ThreadPoolExecutor-0_2:140643133290240] [views:ping:9] [INFO]- pong!!
2022-07-25 17:58:47,296 [ThreadPoolExecutor-0_6:140643099719424] [scheduler:monitor:145] [INFO]- rule: , content: 待处理 0, last_content: 待处理 0, status_code: 0
2022-07-25 17:58:47,325 [ThreadPoolExecutor-0_6:140643099719424] [scheduler:add_job:223] [INFO]- 添加定时任务task_9
2022-07-25 17:59:15,475 [ThreadPoolExecutor-0_7:140643091326720] [scheduler:monitor:145] [INFO]- rule: , content: 待处理 1, last_content: 待处理 1, status_code: 0
2022-07-25 17:59:15,504 [ThreadPoolExecutor-0_7:140643091326720] [scheduler:add_job:223] [INFO]- 添加定时任务task_7
2022-07-25 17:59:17,825 [ThreadPoolExecutor-0_4:140643116504832] [views:ping:9] [INFO]- pong!!
2022-07-25 17:59:27,659 [Thread-12:140643818395392] [scheduler:add_job:223] [INFO]- 添加定时任务task_11
2022-07-25 17:59:27,667 [Thread-12:140643818395392] [scheduler:add_job:223] [INFO]- 添加定时任务task_11
2022-07-25 18:00:17,822 [ThreadPoolExecutor-0_8:140643082934016] [views:ping:9] [INFO]- pong!!
2022-07-25 18:01:17,840 [ThreadPoolExecutor-0_5:140643108112128] [views:ping:9] [INFO]- pong!!
2022-07-25 18:01:38,701 [ThreadPoolExecutor-0_3:140643124897536] [scheduler:monitor:145] [INFO]- rule: , content: 已答复 1, last_content: 待处理 0, status_code: 3
2022-07-25 18:01:39,220 [ThreadPoolExecutor-0_3:140643124897536] [scheduler:add_job:223] [INFO]- 添加定时任务task_10
2022-07-25 18:02:17,822 [ThreadPoolExecutor-0_2:140643133290240] [views:ping:9] [INFO]- pong!!
2022-07-25 18:03:17,846 [ThreadPoolExecutor-0_7:140643091326720] [views:ping:9] [INFO]- pong!!
2022-07-25 18:03:24,336 [ThreadPoolExecutor-0_6:140643099719424] [scheduler:monitor:145] [INFO]- rule: , content: 待处理 0, last_content: 待处理 0, status_code: 0
2022-07-25 18:03:24,362 [ThreadPoolExecutor-0_6:140643099719424] [scheduler:add_job:223] [INFO]- 添加定时任务task_8
2022-07-25 18:04:17,822 [ThreadPoolExecutor-0_4:140643116504832] [views:ping:9] [INFO]- pong!!
2022-07-25 18:05:17,863 [ThreadPoolExecutor-0_8:140643082934016] [views:ping:9] [INFO]- pong!!
2022-07-25 18:06:17,841 [ThreadPoolExecutor-0_5:140643108112128] [views:ping:9] [INFO]- pong!!
2022-07-25 18:06:54,107 [ThreadPoolExecutor-0_3:140643124897536] [scheduler:monitor:145] [INFO]- rule: , content: 已答复 1, last_content: 已答复 1, status_code: 0
2022-07-25 18:06:54,134 [ThreadPoolExecutor-0_3:140643124897536] [scheduler:add_job:223] [INFO]- 添加定时任务task_6
2022-07-25 18:07:17,824 [ThreadPoolExecutor-0_2:140643133290240] [views:ping:9] [INFO]- pong!!
2022-07-25 18:08:17,861 [ThreadPoolExecutor-0_7:140643091326720] [views:ping:9] [INFO]- pong!!

根据另一个issue，这可能与数据库过大有关，在我删除大部分 django_apscheduler_djangojobexecution 记录后，长时间不运行的任务减少了，但要每5天清理一下数据库是不合适的