Skip to content

sync-diff hint is not clear: matches 2 table route rules which is more than one #571

@Tammyxia

Description

@Tammyxia

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.
  • For sync-diff 5.3.0 , it seems the config in route-rules(routes) and Task config (target-check-tables) may have conflict setting, but the document or sync diff log is not very clear message when user has this mistake.
  1. What did you expect to see?
  • Document has something like: Please make sure route-rules(routes) and Task config (target-check-tables) has not repeated setting.
  1. What did you see instead?
    [2021/12/20 15:40:20.421 +08:00] [FATAL] [main.go:95] ["failed to initialize diff process"] [error="from upstream: get route result for betting_0.unit1_5_game_bets_game_tag_0 failed, error betting_0.unit1_5_game_bets_game_tag_0 matches 2 table route rules which is more than one.\nThe first two rules are &{SchemaPattern:betting_0 TablePattern:unit1_* TargetSchema:betting_0 TargetTable:unit1_* TableExtractor: SchemaExtractor: SourceExtractor:}, &{SchemaPattern:betting_0 TablePattern:unit1_5_game_bets_game_tag_0 TargetSchema:betting_0 TargetTable:unit1_5_game_bets_game_tag_0 TableExtractor: SchemaExtractor: SourceExtractor:}.\nIt's not supported"]

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

  3. which tool are you using?

  4. what versionof tool are you using (pump -V or tidb-lightning -V or syncer -V)?

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