github/gh-ost

1.1.7 can not use in mariadb 10.3

Open

#1,488 创建于 2025年1月3日

在 GitHub 查看
 (3 评论) (0 反应) (0 负责人)Go (8,101 star) (819 fork)batch import
buggood first issue

描述

gh-ost --version 1.1.7 (git commit: d5ab048c1f046821f3c7384a386fc1c3ae399c92)

mysql --version mysql Ver 15.1 Distrib 10.3.31-MariaDB, for Linux (x86_64) using readline 5.1

2025-01-03 02:18:57 FATAL Error 1193 (HY000): Unknown system variable 'transaction_isolation'

in mariadb，not have variable 'transaction_isolation'，but have variable 'tx_isolation'

MariaDB [(none)]> show variables like '%isolation%'; +---------------+-----------------+ | Variable_name | Value | +---------------+-----------------+ | tx_isolation | REPEATABLE-READ | +---------------+-----------------+

贡献者指南

技术栈
gomysql
领域
databasebackend
议题类型
bug
难度面向新贡献者的预计实现难度，1 表示很小改动，5 表示专家级工作。
3
预计时间有经验贡献者完成调查、实现、测试并准备 pull request 的粗略时间范围。
1-3 hours
活动状态议题当前的可参与程度：新鲜、活跃、陈旧、阻塞或等待维护者输入。
fresh
清晰度议题是否清楚说明期望改动、验收标准和下一步。
clear
前置要求
basic Go knowledgefamiliarity with MySQL/MariaDB variables
新手友好度1-100 的估计分数，表示该议题对首次贡献者的友好程度。
70
研究方向
Search the gh ost codebase (likely in go/sql/ or similar) for references to 'transaction isolation'. The MySQL driver might set this variable. For MariaDB 10.3, the correct variable is 'tx isolation'. A fix could involve detecting the MariaDB version (e.g., via SELECT VERSION()) and conditionally setting 'tx isolation' instead. Check if there's a common SQL abstraction layer where this variable is used. Also review comments #1488 for any maintainer guidance.