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

Console 3.8.0 关于alter sql 命令问题 #866

Open
roc0723 opened this issue Jan 15, 2025 · 2 comments
Open

Console 3.8.0 关于alter sql 命令问题 #866

roc0723 opened this issue Jan 15, 2025 · 2 comments

Comments

@roc0723
Copy link

roc0723 commented Jan 15, 2025

环境 : fisco 3.11.0
console 3.8.0
对于已经存有数据的表来说,若使用此altersql 增加一个字段,然后再用update语句更新 新增字段的数据,会造成节点关闭
【是因为不允许在原有的数据里更新此字段是的信息吗,而只能在新增的数据使用此字段】
【我增加的是status这个字段】
[group0]: /apps> update t_order_123 set extra_info = fff where order_status = 1;
1 row affected.

[group0]: /apps> update t_order_123 set status = 1 where order_status = 1;
{
"code":-4006,
"msg":"the session has been disconnected"
}

[group0]: /apps> update t_order_123 set extra_info = fff where order_status = 1;
{
"code":-4010,
"msg":"there has no connection available for the group,maybe all connections disconnected or the group does not exist,group: group0"
}

@kyonRay
Copy link
Member

kyonRay commented Jan 15, 2025

请提供你问题的复现全流程,包括alter语句的使用。

@roc0723
Copy link
Author

roc0723 commented Jan 15, 2025

创建表
image
insert一条数据,然后alter一个新的字段,然后使用update语句更新刚刚插入的数据
image
image
节点就掉了

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