Skip to content

Dtle: When job dead ,restart job and job running ,the job still have error information #479

Closed
@yaqigithub

Description

@yaqigithub

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"

  1. 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

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions