gh-ost icon indicating copy to clipboard operation
gh-ost copied to clipboard

1.1.7 can not use in mariadb 10.3

Open RankRao opened this issue 1 year ago • 3 comments

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

RankRao avatar Jan 03 '25 02:01 RankRao

Thanks for the bug report, we don't currently have tests for MariaDB. transaction_isolation was added in https://github.com/github/gh-ost/pull/1156. The fix would have to add a flag to specify MariaDB and change the connection parameter name to tx_isolation

meiji163 avatar Jan 06 '25 02:01 meiji163

hi @meiji163 could you please have a look the linked pr thanks for your time!

Vasanth-96 avatar May 10 '25 15:05 Vasanth-96

mysql5.6 too, is there any way to add a flag to set uri or isolation variable key name or isolation variable whole key=value

welyss avatar Jun 04 '25 01:06 welyss