Skip to content
New issue

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

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

Already on GitHub? Sign in 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;

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

No branches or pull requests

2 participants