Skip to content
This repository has been archived by the owner on Nov 24, 2023. It is now read-only.

can't calculate replication lag if "lower_case_table_names=1" #706

Closed
csuzhangxc opened this issue Jun 3, 2020 · 1 comment
Closed

can't calculate replication lag if "lower_case_table_names=1" #706

csuzhangxc opened this issue Jun 3, 2020 · 1 comment
Labels
severity/moderate type/bug This issue is a bug report
Milestone

Comments

@csuzhangxc
Copy link
Member

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do? If possible, provide a recipe for reproducing the error.

    set lower_case_table_names=1 for the upstream MySQL.

    set enable-heartbeat: true for task.yaml.

  2. What did you expect to see?

    valid application lag in Grafana dashboard.

  3. What did you see instead?

    invalid replication lag in Grafana dashboard.

  4. Versions of the cluster

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

      v1.0.5
      
@csuzhangxc csuzhangxc added the type/bug This issue is a bug report label Jun 3, 2020
@csuzhangxc csuzhangxc added this to the v1.0.6 milestone Jun 3, 2020
@csuzhangxc
Copy link
Member Author

csuzhangxc commented Jun 3, 2020

in pingcap/tidb-tools#322, we renamed dm_heartbeat/heartbeat to DM_HEARTBEAT/HEARTBEAT.

but MySQL has lower_case_table_names, which will convert upper case to lower case.

and in DM, we use == to compare a table name whether is heartbeat's table name before calculate replication lag.

@csuzhangxc csuzhangxc changed the title can't calculate replicaiton lag if "lower_case_table_names=1" can't calculate replication lag if "lower_case_table_names=1" Jun 3, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
severity/moderate type/bug This issue is a bug report
Projects
None yet
Development

No branches or pull requests

2 participants