polardb / polardbx-sql

PolarDB-X is a cloud native distributed SQL Database designed for high concurrency, massive storage, complex querying scenarios.
Apache License 2.0
1.53k stars 325 forks source link

创建表报错:Failed to execute the DDL task. Caused by: Failed to SYNC to the following nodes #119

Open swit1983 opened 1 year ago

swit1983 commented 1 year ago

刚部署好,建了一个数据库还是好的,可以顺利的创建表,过了几天建了一个新数据库创建表失败。 版本:5.6.29-PXC-5.4.15-20221129 数据库:

CREATE DATABASE `dbapi_log` /* MODE = 'auto' */

建表语句:

CREATE TABLE `access_log`
(
    `id`        varchar(50) NOT NULL,
    `url`       varchar(255)  DEFAULT NULL,
    `status`    int(11) DEFAULT NULL,
    `duration`  bigint(20) DEFAULT NULL,
    `timestamp` bigint(20) DEFAULT NULL,
    `ip`        varchar(50)   DEFAULT NULL,
    `app_id`    varchar(50)   DEFAULT NULL,
    `api_id`    varchar(50)   DEFAULT NULL,
    `error`     varchar(1024) DEFAULT NULL,
    PRIMARY KEY (`id`)
);
check table access_log;   显示都Ok

image

SHOW DDL RESULT;

Failed to execute the DDL task. Caused by: Failed to SYNC to the following nodes:
10.233.90.75:3406 - null;
10.233.118.96:3406 - null;
10.233.118.145:3406 - null;
10.233.118.83:3406 - null;
10.233.90.130:3406 - null;

但是报错 show ddl; image 表可以使用,但是无法删除。

运维也反馈不太稳定的感觉,部署好了,会出一些无法预测的问题,不知道问题在哪里

joeCarf commented 1 year ago

节点之间的通信是否正常呢,看报错可能是这些节点无法联通 10.233.90.75:3406 - null; 10.233.118.96:3406 - null; 10.233.118.145:3406 - null; 10.233.118.83:3406 - null; 10.233.90.130:3406 - null;