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

Write conflict happened while upgrade dm V2.0.1 to nightly #1890

Closed
XuJianxu opened this issue Jul 20, 2021 · 2 comments
Closed

Write conflict happened while upgrade dm V2.0.1 to nightly #1890

XuJianxu opened this issue Jul 20, 2021 · 2 comments
Labels
severity/major type/bug This issue is a bug report

Comments

@XuJianxu
Copy link

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.
    200 upstream mysql, 200* dm worker, 3*dm master, 200K QPS+TPS in upstream.
    Upgrade dm cluster from 2.0.1 to nightly。

  2. What did you expect to see?
    no write conflict

  3. What did you see instead?
    write conflict happened
    image

  4. Versions of the cluster

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

      v2.0.1
      
    • Upstream MySQL/MariaDB server version:

      mysql5.6/5.7
      
    • Downstream TiDB cluster version (execute SELECT tidb_version(); in a MySQL client):

      4.0.10
      
    • How did you deploy DM: DM-Ansible or manually?

      DM-Ansible
      
    • Other interesting information (system version, hardware config, etc):

  5. current status of DM cluster (execute query-status in dmctl)

  6. Operation logs

    • Please upload dm-worker.log for every DM-worker instance if possible
    • Please upload dm-master.log if possible
    • Other interesting logs
    • Output of dmctl's commands with problems
  7. Configuration of the cluster and the task

    • dm-worker.toml for every DM-worker instance if possible
    • dm-master.toml for DM-master if possible
    • task config, like task.yaml if possible
    • inventory.ini if deployed by DM-Ansible
  8. Screenshot/exported-PDF of Grafana dashboard or metrics' graph in Prometheus for DM if possible

@lance6716 lance6716 added type/bug This issue is a bug report and removed type/bug-fix Bug fix labels Jul 20, 2021
@lance6716
Copy link
Collaborator

write conflict may caused by #1895 (comment). since the write conflict still occurs at this moment, I'll try to adjust the table structure by operate-schema and see if the conflict is still here

@lance6716
Copy link
Collaborator

after setting correct table schema for every shard tables, this problem doesn't happen again.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
severity/major type/bug This issue is a bug report
Projects
None yet
Development

No branches or pull requests

2 participants