baijun opened a new issue #4051: URL: https://github.com/apache/incubator-dolphinscheduler/issues/4051
1. I set up a new timed task and confirmed that it could run normally, which was executed every minute as follows. 1、我建立了一个新的定时任务,并且确认他可以正常运行,如下每一分钟都在执行。  2. Then I tried to export the backup records in the database, such as exporting in SQL. 2、之后我尝试将数据库中记录备份导出,例如以sql的方式导出。 INSERT INTO "qrtz_triggers"("sched_name", "trigger_name", "trigger_group", "job_name", "job_group", "description", "next_fire_time", "prev_fire_time", "priority", "trigger_state", "trigger_type", "start_time", "end_time", "calendar_name", "misfire_instr", "job_data") VALUES ('DolphinScheduler', 'job_40', 'jobgroup_9', 'job_40', 'jobgroup_9', NULL, 1605079680000, 1605079620000, 5, 'ACQUIRED', 'CRON', 1605024000000, 4760697600000, NULL, 2, E'\\\\x'::bytea); 3. The reason why I do this is to simulate the process of database switch and then clear the data in the QRTZ_triggers table to simulate a new environment as follows: 3、我之所以这么做是在模拟切换数据库的过程,之后清空qrtz_triggers表中数据,模拟一个新的环境,如下:  4. Finally, I imported the exported record into Qrtz_TIRGGERS, as follows: 4、最后我将导出的记录导入到qrtz_tirggers,如下:  5. After that, the timer did not work, and an error occurred when editing the timer to go online, as follows: 5、之后定时不工作了,并且编辑定时器上线出错,如下:  ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
