Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

engine(dm): query-status cannot see secondsBehindMaster #7189

Closed
GMHDBJD opened this issue Sep 22, 2022 · 0 comments · Fixed by #7193
Closed

engine(dm): query-status cannot see secondsBehindMaster #7189

GMHDBJD opened this issue Sep 22, 2022 · 0 comments · Fixed by #7193
Labels
area/dm Issues or PRs related to DM. area/engine Issues or PRs related to Dataflow Engine. severity/minor type/bug The issue is confirmed as a bug.

Comments

@GMHDBJD
Copy link
Contributor

GMHDBJD commented Sep 22, 2022

What did you do?

 gmhdbjd@gmhdbjd  ~/test/engine-chaos  curl "http://127.0.0.1:10240/api/v1/jobs/6858cb86-2ef3-4f1e-92f2-6fafc7face16/status"
{
    "job_id": "6858cb86-2ef3-4f1e-92f2-6fafc7face16",
    "task_status": {
        "replica-01": {
            "expected_stage": "Running",
            "worker_id": "9d86d0fd-f577-4e11-916c-810dccb05977",
            "config_outdated": false,
            "status": {
                "error_message": "",
                "unit": "DMSyncTask",
                "stage": "Running",
                "result": null,
                "status": {
                    "binlogType": "remote",
                    "masterBinlog": "(mysql-bin.000003, 89073519)",
                    "masterBinlogGtid": "744a7ba7-3a4e-11ed-be2f-e2805d6d0361:1-5105",
                    "syncerBinlog": "(mysql-bin.000003, 87977216)",
                    "syncerBinlogGtid": "744a7ba7-3a4e-11ed-be2f-e2805d6d0361:1-5042",
                    "totalEvents": 513559
                }
            }
        },
        "replica-02": {
            "expected_stage": "Running",
            "worker_id": "d1cca49d-ca6d-43b9-910f-424433377696",
            "config_outdated": false,
            "status": {
                "error_message": "",
                "unit": "DMSyncTask",
                "stage": "Running",
                "result": null,
                "status": {
                    "binlogType": "remote",
                    "masterBinlog": "(mysql-bin.000003, 92601305)",
                    "masterBinlogGtid": "75a0a836-3a4e-11ed-9388-0ea55a079c53:1-5122",
                    "recentTps": 1200,
                    "syncerBinlog": "(mysql-bin.000003, 89532085)",
                    "syncerBinlogGtid": "75a0a836-3a4e-11ed-9388-0ea55a079c53:1-4952",
                    "totalEvents": 515267,
                    "totalTps": 559
                }
            }
        },
        "replica-03": {
            "expected_stage": "Running",
            "worker_id": "bbd694d4-2a17-4761-88c7-d75689c3b00b",
            "config_outdated": false,
            "status": {
                "error_message": "",
                "unit": "DMSyncTask",
                "stage": "Running",
                "result": null,
                "status": {
                    "binlogType": "remote",
                    "masterBinlog": "(mysql-bin.000002, 158373115)",
                    "masterBinlogGtid": "0-1-5128",
                    "syncerBinlog": "(mysql-bin.000002, 156790016)",
                    "syncerBinlogGtid": "0-1-5076",
                    "totalEvents": 516366
                }
            }
        }
    }
}%      

What did you expect to see?

No response

What did you see instead?

No response

Versions of the cluster

DM version (run dmctl -V or dm-worker -V or dm-master -V):

(paste DM version here, and you must ensure versions of dmctl, DM-worker and DM-master are same)

Upstream MySQL/MariaDB server version:

(paste upstream MySQL/MariaDB server version here)

Downstream TiDB cluster version (execute SELECT tidb_version(); in a MySQL client):

(paste TiDB cluster version here)

How did you deploy DM: tiup or manually?

(leave TiUP or manually here)

Other interesting information (system version, hardware config, etc):

>
>

current status of DM cluster (execute query-status <task-name> in dmctl)

(paste current status of DM cluster here)
@GMHDBJD GMHDBJD added type/bug The issue is confirmed as a bug. area/dm Issues or PRs related to DM. area/engine Issues or PRs related to Dataflow Engine. labels Sep 22, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/dm Issues or PRs related to DM. area/engine Issues or PRs related to Dataflow Engine. severity/minor type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant