github/gh-ost

1.1.7 can not use in mariadb 10.3

Open

#1488 opened on Jan 3, 2025

View on GitHub
 (3 comments) (0 reactions) (0 assignees)Go (8,101 stars) (819 forks)batch import
buggood first issue

Description

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 | +---------------+-----------------+

Contributor guide

Tech stack
gomysql
Domain
databasebackend
Issue type
bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
basic Go knowledgefamiliarity with MySQL/MariaDB variables
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
70
Research direction
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.