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

语句在执行过程中被MySQL KILL以后,执行结果仍返回执行和备份成功 #34

Closed
hhyo opened this issue May 26, 2019 · 1 comment

Comments

@hhyo
Copy link
Contributor

hhyo commented May 26, 2019

描述
语句在执行过程中被MySQL KILL以后,执行结果仍返回执行和备份成功,并且回滚语句确实已经生成
但实际上没有执行成功,此时MySQL已经回滚

仅测试了DDL语句,DML语句未做验证

重现
执行语句

ALTER TABLE `archer_test`.`osc_test` DROP COLUMN `xx`;

在MySQL中KILL掉对应的进程,执行结果返回

{
	"id": 2,
	"stage": "EXECUTED",
	"errlevel": 2,
	"stagestatus": "Execute Successfully\nBackup Successfully",
	"errormessage": "Execute: invalid connection.",
	"sql": "ALTER TABLE `archer_test`.`osc_test` DROP COLUMN `xx`",
	"affected_rows": 0,
	"sequence": "1558865236_624_00000001",
	"backup_dbname": "mysql_3306_archer_test",
	"execute_time": "4.115",
	"sqlsha1": "",
	"backup_time": "0",
	"actual_affected_rows": ""
}

日志

time="2019/05/26 10:07:12.058" level=info msg="con:80 new connection 172.18.0.5:55452" file=server.go line=319
[mysql] 2019/05/26 10:07:16 packets.go:36: unexpected EOF
time="2019/05/26 10:07:16.174" level=error msg="invalid connection" file=conn.go line=97
time="2019/05/26 10:07:16.183" level=info msg="数据库断开重连" file=conn.go line=152
time="2019/05/26 10:07:16.193" level=error msg="invalid connection" file=session_inception.go line=1252
time="2019/05/26 10:07:16.313" level=info msg="con:80 close connection" file=server.go line=321
time="2019/05/26 10:10:30.456" level=info msg="con:81 new connection 172.18.0.5:55732" file=server.go line=319
time="2019/05/26 10:10:31.206" level=info msg="con:81 close connection" file=server.go line=321

环境

  • goInception: [v0.8.3] docker环境
[root@VM_0_15_centos ~]# docker images|grep goinception
hanchuanchuan/goinception   latest              12571ec1bcef        2 days ago          46.6MB
  • 数据库: [mysql]
  • 版本: [5.7.25-log]

参数

@hanchuanchuan
Copy link
Owner

感谢提出,问题已修复。
v0.8.2版本及docker已经更新。

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