调用 DescribeTaskDetail 接口查询任务详情。
同步请求。
参数 | 类型 | 是否必选 | 示例值 | 描述 |
|---|---|---|---|---|
TaskId | String | 是 | 6f415b1c8f394b0eaad4ea5f1439**** | 任务 ID。 |
ProjectName | String | 否 | default | 项目名称。 |
InstanceId | String | 否 | mysql-a63c49e8**** | 实例 ID。 |
参数 | 类型 | 示例值 | 描述 |
|---|---|---|---|
TaskInfo | Object | 请参见返回示例。 | 任务的详细信息。 |
CheckItems | Object[] | 请参见返回示例。 | 大版本升级的检查结果。 说明 仅在 UpgradeDBInstanceEngineMajorVersion 的任务详情中返回该字段。 |
CheckItemLog | String | 请参见返回示例。 | 实例大版本升级的检测项目日志。 说明 仅在 UpgradeDBInstanceEngineMajorVersion 的任务详情中返回该字段。 |
POST /?Action=DescribeTaskDetail&Version=2022-01-01 HTTP/1.1 Content-Type: application/json Host: rds-mysql.cn-beijing.volcengineapi.com X-Date: 20211202T101010Z Authorization: HMAC-SHA256 Credential=AKLTN2I0MmFiNzMxNWE5NDgzMzk4MmVjMTVkODlkZTZ****/20211202/cn-beijing/rds_mysql/request,SignedHeaders=x-date, Signature=71d31fc7bcf990142851c9833c5656391486cda0ae2e0b8ada733b7c6458**** { "TaskId": "20250410195816F9163BF4884FB4D2****-d4a831" }
{ "ResponseMetadata": { "RequestId": "2025041020230200DE5340D9C3CDD649F0-88e6d8", "Action": "DescribeTaskDetail", "Version": "2022-01-01", "Service": "rds_mysql", "Region": "cn-beijing" }, "Result": { "CheckItemLog": "{\"serverVersion\":\"5.7.32-log - MySQL Community Server (GPL)\",\"targetVersion\":\"8.0.32\",\"checksPerformed\":[{\"id\":\"circularDirectory\",\"status\":\"OK\",\"title\":\"Circular directory references in tablespace data file paths\"},{\"id\":\"engineMixup\",\"status\":\"OK\",\"title\":\"Tables recognized by InnoDB that belong to a different engine\"},{\"id\":\"changedFunctionsInGeneratedColumns\",\"status\":\"OK\",\"title\":\"Indexes on functions with changed semantics\"},{\"id\":\"columnsWhichCannotHaveDefaults\",\"status\":\"OK\",\"title\":\"Columns which cannot have default values\"},{\"id\":\"dollarSignName\",\"status\":\"OK\",\"title\":\"Check for deprecated usage of single dollar signs in object names\"},{\"id\":\"emptyDotTableSyntax\",\"status\":\"OK\",\"title\":\"Check for deprecated '.<table>' syntax used in routines.\"},{\"id\":\"authMethodUsage\",\"status\":\"OK\",\"title\":\"Check for deprecated or invalid user authentication methods.\"},{\"id\":\"deprecatedDefaultAuth\",\"status\":\"OK\",\"title\":\"Check for deprecated or invalid default authentication methods in system variables.\"},{\"id\":\"deprecatedRouterAuthMethod\",\"status\":\"OK\",\"title\":\"Check for deprecated or invalid authentication methods in use by MySQL Router internal accounts.\"},{\"id\":\"deprecatedTemporalDelimiter\",\"status\":\"OK\",\"title\":\"Check for deprecated temporal delimiters in table partitions.\"},{\"id\":\"indexTooLarge\",\"status\":\"OK\",\"title\":\"Check for indexes that are too large to work on higher versions of MySQL Server than 5.7\"},{\"id\":\"oldTemporal\",\"status\":\"OK\",\"title\":\"Usage of old temporal type\"},{\"id\":\"mysqlSchema\",\"status\":\"OK\",\"title\":\"Table names in the mysql schema conflicting with new tables in the latest MySQL.\"},{\"id\":\"nonNativePartitioning\",\"status\":\"OK\",\"title\":\"Partitioned tables using engines with non native partitioning\"},{\"id\":\"foreignKeyLength\",\"status\":\"OK\",\"title\":\"Foreign key constraint names longer than 64 characters\"},{\"id\":\"maxdbSqlModeFlags\",\"status\":\"OK\",\"title\":\"Usage of obsolete MAXDB sql_mode flag\"},{\"id\":\"obsoleteSqlModeFlags\",\"status\":\"OK\",\"title\":\"Usage of obsolete sql_mode flags\",\"detectedProblems\":[{\"dbObject\":\"@@global.sql_mode\",\"dbObjectType\":\"SystemVariable\",\"description\":\"defined using obsolete NO_AUTO_CREATE_USER option\",\"level\":\"Notice\"}]},{\"id\":\"enumSetElementLength\",\"status\":\"OK\",\"title\":\"ENUM/SET column definitions containing elements longer than 255 characters\"},{\"id\":\"groupbyAscSyntax\",\"status\":\"OK\",\"title\":\"Usage of removed GROUP BY ASC/DESC syntax\"},{\"id\":\"invalid57Names\",\"status\":\"OK\",\"title\":\"Check for invalid table names and schema names used in 5.7\",\"solutions\":[\"In order to fix them use the mysqlcheck utility as follows:\\n\\n $ mysqlcheck --check-upgrade --all-databases\\n $ mysqlcheck --fix-db-names --fix-table-names --all-databases\\n\\nOR via mysql client, for eg:\\n\\n ALTER DATABASE `#mysql50#lost+found` UPGRADE DATA DIRECTORY NAME;\"]},{\"id\":\"invalidEngineForeignKey\",\"status\":\"OK\",\"title\":\"Check for columns that have foreign keys pointing to tables from a different database engine.\"},{\"id\":\"routineSyntax\",\"status\":\"OK\",\"title\":\"MySQL syntax check for routine-like objects\"},{\"id\":\"reservedKeywords\",\"status\":\"OK\",\"title\":\"Usage of db objects with names conflicting with new reserved keywords\"},{\"id\":\"partitionedTablesInSharedTablespaces\",\"status\":\"OK\",\"title\":\"Usage of partitioned tables in shared tablespaces\"},{\"id\":\"removedFunctions\",\"status\":\"OK\",\"title\":\"Usage of removed functions\"},{\"id\":\"zeroDates\",\"status\":\"OK\",\"title\":\"Zero Date, Datetime, and Timestamp values\"},{\"id\":\"orphanedObjects\",\"status\":\"OK\",\"title\":\"Check for orphaned routines and events in 5.7\"},{\"id\":\"pluginUsage\",\"status\":\"OK\",\"title\":\"Check for deprecated or removed plugin usage.\"}]}", "CheckItems": [ { "CheckDetail": { "Impact": "SQL 执行后返回结果的排序可能与升级前有差异。", "Issue": "升级后默认字符序变更为 utf8mb4_0900_ai_ci。" }, "Description": "检查 init_connect 参数：检测是否配置了连接初始化 SQL 语句，评估其在 MySQL 8.0 中的执行安全性。", "ItemName": "initConnectCheck", "RiskLevel": "Warning" }, { "CheckDetail": { "Impact": "升级后 default_collation_for_utf8mb4 参数默认配置为 utf8mb4_general_ci。" }, "Description": "检查 utf8mb4 默认排序规则：确认 utf8mb4 字符集的默认排序规则是否为 utf8mb4_0900_ai_ci（MySQL 8.0 推荐值）。", "ItemName": "defaultCollationForUTF8MB4Check", "RiskLevel": "Warning" }, { "CheckDetail": { "Impact": "升级后SQL行为可能存在差异。", "Issue": "使用了已废弃的 sql_mode 选项（如 NO_FIELD_OPTIONS）。" }, "Description": "检查已废弃的 SQL_MODE 模式：识别使用了 MySQL 8.0 中已删除的 SQL 模式（如 NO_FIELD_OPTIONS），需更新配置以避免意外行为。", "ItemName": "obsoleteSqlModeFlags", "RiskLevel": "Warning" }, { "CheckDetail": { "Impact": "升级后相关参数将被忽略，涉及参数包含 [innodb_large_prefix,innodb_stats_sample_pages,metadata_locks_cache_size,query_cache_limit,query_cache_min_res_unit,query_cache_size,query_cache_type,query_cache_wlock_invalidate,secure_auth,sync_frm]。", "Issue": "使用了在 MySQL 8.0 中废弃的参数。" }, "Description": "检查系统参数变更：验证参数是否被废弃（如 query_cache_size）。", "ItemName": "removedSysVars", "RiskLevel": "Warning" } ], "TaskInfo": { "CostTimeMS": 601800, "CreateTime": "2025-04-10T08:29:06.577Z", "FinishTime": "2025-04-10T08:39:08.377Z", "ModifyTime": "2025-04-10T08:40:10.548Z", "OwnerHostIP": "10.56.55.154", "OwnerIP": "11.209.236.103", "OwnerName": "rdsmgr-6594668b96-btd54", "Progress": 0, "RelatedInstanceInfos": { "InstanceID": "mysql-0f7032f1****" }, "StartTime": "2025-04-10T08:29:06.577Z", "TaskAction": "UpgradeDBInstanceEngineMajorVersion", "TaskCategory": "VersionUpgrade", "TaskComplexity": "High", "TaskDesc": "", "TaskId": "20250410162906B3FB2CBF4C3BBEC5****-964567", "TaskParams": "{\"InstanceId\":\"mysql-0f7032f1****\",\"TargetMajorVersion\":\"MySQL 8.0.32\",\"MySQLSlaveDelayThreshold\":10}", "TaskProgressInfo": [ { "Name": "任务初始化", "StepProgress": 100, "StepStatus": "Success" }, { "Name": "资源处理", "StepProgress": 100, "StepStatus": "Success" }, { "Name": "数据处理", "StepExtraInfo": [ "节点1：当前已完成：4.11 GB，共需要处理：4.11 GB", "节点2：当前已完成：4.11 GB，共需要处理：4.11 GB", "节点3：当前已完成：4.11 GB，共需要处理：4.11 GB", "节点4：当前已完成：4.11 GB，共需要处理：4.11 GB" ], "StepProgress": 100, "StepStatus": "Success" }, { "Name": "数据追齐", "StepProgress": 100, "StepStatus": "Success" }, { "Name": "切换", "StepProgress": 100, "StepStatus": "Success" }, { "Name": "等待任务继续", "StepExtraInfo": [ "实例切换到目标版本后，任务将进入\"等待执行\"阶段，实例状态将保持为\"升级中\"。在此期间，您可选择“取消”以回退到升级前状态，或选择\"立即执行\"以完成升级。如果\"等待执行\"阶段持续时间超过观测时长，系统则会自动完成升级。" ], "StepProgress": 100, "StepStatus": "Success" }, { "Name": "后置维护", "StepProgress": 100, "StepStatus": "Success" }, { "Name": "任务结束", "StepProgress": 100, "StepStatus": "Success" } ], "TaskReason": "User operation", "TaskSource": "User", "TaskStatus": "Success" } } }
更多详情，请参见错误码。