github / github/gh-ost

Create _ghc table failed When Rocksdb enable rocksdb_strict_collation_check

Open
#1,748 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
13.6k
Forks
1.4k
Avg merge
2h 31m
Merged PRs (30d)
4

Description

```
show global variables like 'rocksdb_strict_collation_%';
+-------------------------------------+-------+
| Variable_name | Value |
+-------------------------------------+-------+
| rocksdb_strict_collation_check | ON |
| rocksdb_strict_collation_exceptions | |
+-------------------------------------+-------+

```

Error 12009 (HY000): Unsupported collation on string indexed column {db_name}._xxx_ghc.hint Use binary collation (binary, latin1_bin, utf8_bin).

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the failure with rocksdb_strict_collation_check enabled, using the shown SHOW GLOBAL VARIABLES query and the _ghc table creation path. Trace how gh-ost creates the table and identify why the string-indexed column uses an unsupported collation. Done means the _ghc table is created successfully with the setting enabled.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, mysql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.