Appear error of `...see the documentation for 'show_compatibility_56'"` when using DM
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
### Before asking a question, make sure you have
- [X] Searched existing Stack Overflow questions
- [X] Googled your question
- [X] Searched open and closed [GitHub issues](https://github.com/pingcap/tiflow/issues?q=is%3Aissue)
- [X] Read the [documentation](https://docs.pingcap.com/tidb/stable)
### What is your question?
when people who used DM v6.1.0 migrate data from MySQL 5.7.40 to TiDB v6.1.0, the error `"RawCause": "sql: SELECT `VARIABLE_NAME`,`VARIABLE_VALUE` FROM `information_schema`.`GLOBAL_STATUS` LIMIT 1, args: []: Error 3167: The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for 'show_compatibility_56'"` appeared out of DM.
original problem address（including mini-reproduce） : https://asktug.com/t/topic/994794
Contributor guide
Research direction
Start with the reported DM migration from MySQL 5.7.40 to TiDB 6.1.0 and the GLOBAL_STATUS error shown in the issue. Review the linked AskTUG reproduction to determine whether the incompatibility belongs to DM or TiDB, then document or verify the expected compatibility behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 20/100