开发者社区 > PolarDB开源 > PolarDB 分布式版 > 正文

PolarDB-X中当ddl异常且无法cancel或者continue的时候该如何处理?有两条

PolarDB-X中当ddl异常且无法cancel或者continue的时候该如何处理?有两条
1:{"@type":"com.alibaba.polardbx.executor.ddl.newengine.sync.DdlResponse$Response","ddlType":"CREATE_TABLE","jobId":1599938172245024768,"objectName":"iyv6p_icm_group_config","responseContent":"Failed to execute the DDL task. Caused by: ERR-CODE: [PXC-4636][ERR_DDL_JOB_ERROR] Rollback subjob 1599938172685426688 failed with state ROLLBACK_PAUSED. ","responseType":"ERROR","schemaName":"xio_mes"}

  1. {"@type":"com.alibaba.polardbx.executor.ddl.newengine.sync.DdlResponse$Response","ddlType":"CREATE_TABLE","jobId":1600176109377327104,"objectName":"iyv6p_icm_ky_value","responseContent":"Failed to execute the DDL task. Caused by: Failed to SYNC to the following nodes:\n10.244.92.52:3406 - wait millis 3008, active 0, maxActive 30, creating 3, createElapseMillis 76857, createErrorCount 24;\n10.244.139.163:3406 - wait millis 3008, active 0, maxActive 30, creating 3, createElapseMillis 76857, createErrorCount 24;\n10.244.139.172:3406 - wait millis 3007, active 0, maxActive 30, creating 3, createElapseMillis 76858, createErrorCount 24;\n10.244.92.46:3406 - wait millis 3008, active 0, maxActive 30, creating 3, createElapseMillis 76857, createErrorCount 24;\n10.244.92.42:3406 - wait millis 3007, active 0, maxActive 30, creating 3, createElapseMillis 76856, createErrorCount 24;\n10.244.139.169:3406 - wait millis 3008, active 0, maxActive 30, creating 3, createElapseMillis 76858, createErrorCount 24;\n","responseType":"ERROR","schemaName":"xio_mes"}k8s部署,2个cn节点image.png
    是指直接删除pod还是内部杀进程

展开
收起
真的很搞笑 2023-06-06 14:11:37 226 0
1 条回答
写回答
取消 提交回答
  • show full ddl 看一下,用k8s 部署的吗,有几个CN节点,执行一下select * from metadb.server_info;老版本operator的问题,有一些cn节点的信息残留了,可以把这个表清理一下,只留下现有的两个cn节点,ip过滤,然后还需要重启一下现有的两个cn节点。
    正式库不会出现这种case,当然也有办法可以解决,只是稍微麻烦一点,测试库的话直接删库是最方便的,是的,需要升级一下operator,此回答整理自钉群“阿里云 PolarDB-X 开源交流群”

    2023-07-19 15:54:12
    赞同 展开评论 打赏

PolarDB 分布式版 (PolarDB for Xscale,简称“PolarDB-X”) 采用 Shared-nothing 与存储计算分离架构,支持水平扩展、分布式事务、混合负载等能力,100%兼容MySQL。 2021年开源,开源历程及更多信息访问:OpenPolarDB.com/about

相关产品

  • 云原生分布式数据库 PolarDB-X
  • 相关电子书

    更多
    PolarDB-X分布式数据库解决方案 立即下载
    PolarDB-X 2.0 全局 Binlog 与备份恢复能 立即下载
    分布式数据库DRDS全新升级 立即下载