Closed
Description
Description
When job dead ,there has some error infomation, after restart this job,error info not clear.
Steps to reproduce the issue:
1.create a database
create database test1;
2.Src mysql create user : test1, Dest mysql not create user.
create user 'test1'@'%' identified by 'test1';
grant all privileges on *.* to test1@'%';
3.create job
job_error_type.json.txt
4. job dead
"ModifyIndex": 87,
"Name": "test4",
"Status": "dead",
"StatusDescription": "Error 1045: Access denied for user 'test2_mysql'@'node4.compose_net' (using password: YES)",
"Type": "synchronous"
- create user "test2-mysql" in Dest mysql
create user 'test2_mysql'@'%' identified by 'test2_mysql';
grant all privileges on *.* to test2_mysql@'%';
6.view job info:
"ModifyIndex": 119,
"Name": "test4",
"Status": "running",
"StatusDescription": "Error 1045: Access denied for user 'test2_mysql'@'node4.compose_net' (using password: YES)",
"Type": "synchronous"
Describe the results you received:
the error info still exist
Describe the results you expected:
when job running not have error info
Output of ./dtle version
:
Dtle 2.19.05.0 (git: 2.19.05.0 6597c279707070cf5217082a229e4b592788ea2d)
Additional information you deem important (e.g. issue happens only occasionally):
Additional details (log, config, job config etc):
2019/08/05 13:57:58.481558 [DEBUG] Worker.SaveState: after unlock: 0xc000d0e310
2019/08/05 13:57:58.481566 [DEBUG] updater
2019/08/05 13:57:58.481584 [DEBUG] setTaskState: dirtyCh<-
2019/08/05 13:57:58.481629 [ERR] [jobid:a7f848c0-aa3f-0945-d40f-29b461c2435c] mysql.extractor: unexpected error on publish, got nats: connection closed
2019/08/05 13:57:58.481710 [ERR] [jobid:a7f848c0-aa3f-0945-d40f-29b461c2435c] mysql.extractor. error: nats: connection closed
2019/08/05 13:57:58.481727 [INFO] [jobid:a7f848c0-aa3f-0945-d40f-29b461c2435c] mysql.extractor: Step 0: disabling autocommit and enabling repeatable read tr
ansactions
2019/08/05 13:57:58.481737 [INFO] [jobid:a7f848c0-aa3f-0945-d40f-29b461c2435c] mysql.extractor: Step 1: start transaction with consistent snapshot
2019/08/05 13:57:58.481754 [ERR] [jobid:a7f848c0-aa3f-0945-d40f-29b461c2435c] mysql.extractor: get gtid, round: 1, phase 1, err: sql: database is closed
2019/08/05 13:57:58.481775 [ERR] [jobid:a7f848c0-aa3f-0945-d40f-29b461c2435c] mysql.extractor. error: sql: database is closed
2019/08/05 13:57:58.481614 [DEBUG] syncStatus: Alloc
2019/08/05 13:57:58.481859 [INFO] [jobid:a7f848c0-aa3f-0945-d40f-29b461c2435c] mysql.extractor: Shutting down
Metadata
Metadata
Assignees
Labels
No labels