search

pingcap / tidb-tools

tidb-tools are some useful tool collections for TiDB.
Apache License 2.0
287 stars 192 forks source link

sync-diff fails with "Error 1105: context deadline exceeded error occured" #632

Open fubinzh opened 2 years ago

fubinzh commented 2 years ago

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do? Run sync-diff to compare upstream tidb and download stream tidb.

  2. What did you expect to see? sync-diff itself should finish the check

  3. What did you see instead?

    Error in comparison process:
Error 1105: context deadline exceeded error occured in `pp111db10`.`xx`

  4. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)? v6.1.0

  5. which tool are you using? sync-diff-inspector

  6. what versionof tool are you using (pump -V or tidb-lightning -V or syncer -V)? App Name: sync_diff_inspector v2.0 Release Version: v5.2.2-140-gdd591fd Git Commit Hash: dd591fdc742ce2608493c6cb9e3954837b122180 Git Branch: table_range_equal UTC Build Time: 2022-04-26 09:27:46

fubinzh commented 2 years ago

There compare database about 4TB with 4 tables. Sync-diff Logs: sync_diff.log