8000 不支持MySQL 8.4.x版本，求支持 · Issue #2929 · hhyo/Archery · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

不支持MySQL 8.4.x版本，求支持 #2929

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.

Sign up for GitHub

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

Jump to bottom
Open
SoHuDrgon opened this issue Mar 20, 2025 · 1 comment
Open

不支持MySQL 8.4.x版本，求支持 #2929

SoHuDrgon opened this issue Mar 20, 2025 · 1 comment

Comments

@SoHuDrgon
Copy link

重现步骤

MySQL 8.4的版本变化很大，SHOW SLAVE STATUS 已被弃用，改为使用 SHOW REPLICA STATUS 来查询复制状态。SHOW MASTER STATUS;已被弃用，改为使用SHOW BINARY LOG STATUS;

预期外的结果

期望项目支持MySQL 8.4的版本，他也是长期支持版本。

日志文本

# tail -f logs/archery.log
  File "/opt/archery/sql/engines/mysql.py", line 526, in query
    effect_row = cursor.execute(sql, parameters)
  File "/opt/archery/venv4archery/lib64/python3.9/site-packages/MySQLdb/cursors.py", line 179, in execute
    res = self._query(mogrified_query)
  File "/opt/archery/venv4archery/lib64/python3.9/site-packages/MySQLdb/cursors.py", line 330, in _query
    db.query(q)
  File "/opt/archery/venv4archery/lib64/python3.9/site-packages/MySQLdb/connections.py", line 280, in query
    _mysql.connection.query(self, query)
MySQLdb.ProgrammingError: (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 'slave status' at line 1")

版本

1.11.3

部署方式

Docker

是否还有其他可以辅助定位问题的信息？比如数据库版本等

MySQL 8.4.4
@forwardwayl
Copy link

我遇到了类似的问题。

版本：1.11.1
部署方式：源码部署

执行sql上线“UPDATE db1.table1 SET col1 = 0 WHERE id = 25”时报错：

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: Can't found master binlog position.

是否有解决方案

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@SoHuDrgon @forwardwayl
0