Unable to Synchronize Properly When Migrating from MariaDB to TiDB Using DM Tool

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 使用DM工具从mariadb迁移到TIDB,无法正常同步

| username: TiDBer_1KScaFHo

[TiDB Usage Environment] /Test/
[TiDB Version] 5.7.25-TiDB-v5.0.1
[Encountered Issue: Phenomenon and Impact]
image


image

Could any expert help me figure out the reason? According to the error message, it seems like my MariaDB version is relatively low, but based on the warning, the MariaDB version is already greater than 10.1.2.
image

| username: CuteRay | Original post link

Isn’t this not reporting an error?
This is reminding you that DM migrating data from MariaDB is still an experimental feature. If you insist on migrating data from MariaDB, please ensure that the MariaDB version is greater than or equal to 10.1.2.
The warning is very clear. If you can’t understand English, you can copy and translate this sentence.
The usage restrictions in the documentation are also clearly stated.
TiDB Data Migration Overview | PingCAP Documentation Center

| username: CuteRay | Original post link

Read the documentation carefully before using it.

| username: dba-kit | Original post link

This is a warning, the task has been successfully created. However, you should check the task status with query-status. The GTID implementation of MariaDB is different from MySQL, so you need to specifically check if there are any synchronization errors.

| username: Jjjjayson_zeng | Original post link

The task name testdm is already duplicated, the version warning can be ignored.

| username: Jjjjayson_zeng | Original post link

Hope you can give my reply a like :joy:

| username: okenJiang | Original post link

Please learn to read the error messages yourself.

| username: TiDBer_1KScaFHo | Original post link

Yes, the warning states that the MariaDB version should be greater than 10.1.2, and my MariaDB version is 10.3.38, which is greater than 10.1.2. Moreover, there were no other errors during the migration, but the test01 test database I created just can’t be migrated to TiDB…

| username: TiDBer_1KScaFHo | Original post link

My MariaDB version is greater than 10.1.2, my version is 10.3.38~

| username: TiDBer_1KScaFHo | Original post link

I first stopped the testdm task and then restarted it. Do you mean that if this task has been used before, it cannot be used again? Do I need to create a new task?

| username: Jjjjayson_zeng | Original post link

Task names must not be duplicated.

| username: Jjjjayson_zeng | Original post link

The name of the task you create cannot be the same as before.

| username: Jjjjayson_zeng | Original post link

Or you can directly delete the tables related to the task in the dm_meta database.

| username: TiDBer_1KScaFHo | Original post link

Hello, I just deleted the previously configured tasks and files, and then encountered an error when creating mysql-01.yaml. What could be the reason?

| username: 考试没答案 | Original post link

Is the master down?

| username: 考试没答案 | Original post link

Please display the status of the master.

| username: Jjjjayson_zeng | Original post link

The master address seems incorrect. Please double-check if your master address is local.

| username: TiDBer_1KScaFHo | Original post link

How do you display the status of the master? Haha, I just started with TIDB DM, I’m a newbie~

| username: TiDBer_1KScaFHo | Original post link

The master address is configured as the local physical port.

| username: 考试没答案 | Original post link

tiup dm display dm_name?