You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2020/11/11 08:15:05 UTC
[GitHub] [incubator-dolphinscheduler] baijun opened a new issue #4051: [Bug][qrtz_tirggers module] qrtz_ data Import export exception
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] X-MerlinLee commented on issue #4051: [Bug][qrtz_tirggers module] qrtz_ data Import export exception
Posted by GitBox <gi...@apache.org>.
X-MerlinLee commented on issue #4051:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4051#issuecomment-732518011
I think it is not a bug. at least, it has nothing to do with this project. As @baijun mentioned, 'job_data' should be the binary result of Java object serialization, the results of dumping blob data is not as expected.
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] xingchun-chen commented on issue #4051: [Bug][qrtz_tirggers module] qrtz_ data Import export exception
Posted by GitBox <gi...@apache.org>.
xingchun-chen commented on issue #4051:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4051#issuecomment-731042200
Who can look the problem?
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] CalvinKirs closed issue #4051: [Bug][qrtz_tirggers module] qrtz_ data Import export exception
Posted by GitBox <gi...@apache.org>.
CalvinKirs closed issue #4051:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4051
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] baijun commented on issue #4051: [Bug][qrtz_tirggers module] qrtz_ data Import export exception
Posted by GitBox <gi...@apache.org>.
baijun commented on issue #4051:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4051#issuecomment-725353730
Triggers job_data in qrtz_triggers? Why is \x saved????
qrtz_triggers中的job_data为什么存的是个\x？？？？
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] X-MerlinLee commented on issue #4051: [Bug][qrtz_tirggers module] qrtz_ data Import export exception
Posted by GitBox <gi...@apache.org>.
X-MerlinLee commented on issue #4051:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4051#issuecomment-732524572
Maybe you should look for a better PostgreSQL synchronous replication tool. @baijun
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] CalvinKirs commented on issue #4051: [Bug][qrtz_tirggers module] qrtz_ data Import export exception
Posted by GitBox <gi...@apache.org>.
CalvinKirs commented on issue #4051:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4051#issuecomment-734733902
hi, as @X-MerlinLee said, this is not an error in this project, you should try other synchronization tools
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [incubator-dolphinscheduler] X-MerlinLee edited a comment on issue #4051: [Bug][qrtz_tirggers module] qrtz_ data Import export exception
Posted by GitBox <gi...@apache.org>.
X-MerlinLee edited a comment on issue #4051:
URL: https://github.com/apache/incubator-dolphinscheduler/issues/4051#issuecomment-732518011
I think it is not a bug. at least, it has nothing to do with this project. As @baijun mentioned, 'job_data' should be the binary result of Java object serialization, the blob data you exported is not as expected.
----------------------------------------------------------------
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:
users@infra.apache.org