Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

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

Open
swit1983 opened this issue Jan 5, 2023 · 1 comment

Comments

@swit1983
Copy link

swit1983 commented Jan 5, 2023

刚部署好,建了一个数据库还是好的,可以顺利的创建表,过了几天建了一个新数据库创建表失败。
版本: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
Copy link
Contributor

joeCarf commented Jan 9, 2023

节点之间的通信是否正常呢,看报错可能是这些节点无法联通
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;

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants