MySQL 8.4版本SQL上线有问题
Author: FindTheRealMeCreated Jul 28, 2026Updated Aug 25, 2026
重现步骤
最近所有的MySQL数据库都升级到了8.4.9 ,数据库应该是8.4之后就没有show master status这个命令了，由SHOW BINARY LOG STATUS; 来代替，所以sql上线到审批完成最后一步要执行的时候在执行信息一栏中就会出现这个报错：
Execute: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MASTER STATUS' at line 1 (sql: SHOW MASTER STATUS;). Execute: 无法获取master binlog信息.
预期外的结果
日志文本
goinception logs:
goinception | time="2026/07/28 18:01:46.377" level=error msg="con:3 Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MASTER STATUS' at line 1" file=conn.go func=raw line=68
goinception | time="2026/07/28 18:01:46.377" level=error msg="con:3 Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MASTER STATUS' at line 1" file=session_inception.go func=mysqlFetchMasterBinlogPosition line=1620版本
1.14.0
部署方式
Docker
是否还有其他可以辅助定位问题的信息？比如数据库版本等
MySQL: "8.4.9" goInception : v1.3.0-86-g02acf74-dirty
Source: hhyo/Archery