Error in DM synchronization to Alibaba DRDS: DM initialization error - DRDS does not support CREATE SCHEMA

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

Original topic: dm同步到阿里DRDS出错,dm初始化时错误 drds不支持create SCHEMA

| username: Hacker_Rs6Uz6Uy

[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version]
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact] [2024/07/01 18:26:13.430 +08:00] [INFO] [syncer.go:3524] [“use timezone”] [task=yh_stlb] [unit=“binlog replication”] [location=+08:00]
[2024/07/01 18:26:14.115 +08:00] [ERROR] [baseconn.go:184] [“execute statement failed”] [task=yh_stlb] [unit=“binlog replication”] [component=“shard group keeper”] [query=“CREATE SCHEMA IF NOT EXISTS yh_stlb”] [argument=“”] [error=“Error 4998: [1835e5f6824ae000-1][10.0.23.184:3306][yh_stlb]ERR-CODE: [TDDL-4998][ERR_NOT_SUPPORT] CREATE DATABASE not support yet! “]
[2024/07/01 18:26:14.117 +08:00] [ERROR] [db.go:221] [“execute statements failed after retry”] [task=yh_stlb] [unit=“binlog replication”] [component=“shard group keeper”] [queries=”[CREATE SCHEMA IF NOT EXISTS yh_stlb]”] [arguments=“”] [error="[code=10006:class=database:scope=not-set:level=high], Message: execute statement failed: CREATE SCHEMA IF NOT EXISTS yh_stlb, RawCause: Error 4998: [1835e5f6824ae000-1][10.0.23.184:3306][yh_stlb]ERR-CODE: [TDDL-4998][ERR_NOT_SUPPORT] CREATE DATABASE not support yet! "]
[2024/07/01 18:26:14.117 +08:00] [INFO] [sharding_group.go:673] [“execute sql”] [task=yh_stlb] [unit=“binlog replication”] [component=“shard group keeper”] [statement=“CREATE SCHEMA IF NOT EXISTS yh_stlb”]

[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachment: Screenshot/Log/Monitoring]