DM Synchronization Error

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

Original topic: dm同步报错

| username: 等一分钟

[TiDB Usage Environment] Production Environment
[TiDB Version] 6.5.1 DM Version 6.0

The synchronization task reports “Message”: “[parser:1115]Unknown character set: ‘utf8mb3’”,

I used binlog skip task_10 to skip the error, and then it reported
Message: such operation is only available for syncer, but now syncer is not running. current unit is Load"

How to solve this?

| username: 有猫万事足 | Original post link

Your synchronization task is still in the load phase, so the SQL file you dumped contains utf8mb3. The binlog command cannot skip this error.

This file is generally located in the directory starting with dumped_data under the DM installation path.

6272RKXUS``M$NQ}RX421

Alternatively, you can avoid this issue by creating the table in advance.

| username: 等一分钟 | Original post link

The load phase has ended, so I can directly modify the SQL file and then start it again, right?

| username: Fly-bird | Original post link

utf8mb3 ???

| username: dba远航 | Original post link

The default is UTF8.

| username: 等一分钟 | Original post link

Yes, MySQL 8.0’s.

| username: TiDBer_小阿飞 | Original post link

Can I change utf8mb3 to utf8?

Then re-import.

| username: 等一分钟 | Original post link

I used the sed command to batch modify, it seems to work.

| username: 等一分钟 | Original post link

Is this status considered normal?

| username: 等一分钟 | Original post link

The source database is: cc9342b1-5e4b-11ec-9e30-005056bb72fe:1-17

However, when I insert a piece of data into the source database, I can immediately see it in TiDB, but the GTID is inconsistent.

| username: 等一分钟 | Original post link

There is an error in the statement; TiDB has not yet synchronized to the latest data.

| username: 小龙虾爱大龙虾 | Original post link

Even with a large amount of data in the table, you can still perform a full backup yourself. Using Dumpling + Lightning is faster and more controllable, and then you can use DM for incremental backups.

| username: Billmay表妹 | Original post link

TiDB and DM should use the same version.

7.5 is highly compatible with MySQL 8.0 in the LTS version.
You can consider this version later.

| username: 有猫万事足 | Original post link

It’s still in the load phase, so you won’t see it immediately after insertion. When the unit is sync, it will be fine.

| username: dba远航 | Original post link

Did you find the cause of the problem?

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.