こんばんは。かとうです。
環境:
MariaDB 10.6.5
Mroonga 11.09
Groonga 11.0.9
groonga-normalizer-mysql 1.1.4
テーブル:
CREATE TABLE `TEST_TABLE` (
`TEST_COLUMN1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`TEST_COLUMN2` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`TEST_COLUMN1`),
KEY `TEST_COLUMN2` (`TEST_COLUMN2`)
) ENGINE=Mroonga DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
データ（2行以上必要）:
insert into TEST_TABLE values (NULL,'ABCD');
insert into TEST_TABLE values (NULL,'ABCD');
上記の状況で下のクエリを投げると、groonga.logにトレースログが吐かれます。
投入したクエリ:
FLUSH TABLES;
SELECT SQL_CALC_FOUND_ROWS * FROM TEST_TABLE WHERE TEST_COLUMN2='ABCD' ORDER BY TEST_COLUMN1;
ログ内容:
2021-11-25 21:35:21.065016|e|1139|5e911640: [normalizer][mysql-unicode-ci] UTF-8 encoding is only supported: none
2021-11-25 21:35:21.066495|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(grn_ctx_log_back_trace+0x2b) [0x7f3e5d4317ab]
2021-11-25 21:35:21.066508|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(grn_plugin_set_error+0x175) [0x7f3e5d611745]
2021-11-25 21:35:21.066515|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(+0x5a07a2) [0x7f3e5d78d7a2]
2021-11-25 21:35:21.066523|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(grn_proc_call+0xf0) [0x7f3e5d46ea70]
2021-11-25 21:35:21.066531|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(grn_normalizer_normalize+0x2b) [0x7f3e5d5713bb]
2021-11-25 21:35:21.066538|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(grn_string_open_+0x254) [0x7f3e5d6417b4]
2021-11-25 21:35:21.066546|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(grn_table_get+0x234) [0x7f3e5d444774]
2021-11-25 21:35:21.066554|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(+0x45ad4f) [0x7f3e5d647d4f]
2021-11-25 21:35:21.066561|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(+0x45c3b6) [0x7f3e5d6493b6]
2021-11-25 21:35:21.066569|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(grn_table_selector_select+0x2c6) [0x7f3e5d64a186]
2021-11-25 21:35:21.066577|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(grn_table_select+0x48) [0x7f3e5d4734a8]
2021-11-25 21:35:21.066584|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(_ZN10ha_mroonga16storage_rnd_initEb+0x1b3) [0x7f3e5d405b53]
2021-11-25 21:35:21.066592|e|1139|5e911640: /usr/libexec/mariadbd(_ZN7handler22ha_rnd_init_with_errorEb+0x19) [0x562ddf074ec9]
2021-11-25 21:35:21.066600|e|1139|5e911640: /usr/libexec/mariadbd(_Z16init_read_recordP11READ_RECORDP3THDP5TABLEP10SQL_SELECTP9SORT_INFOibb+0x2a4) [0x562ddf1afdd4]
2021-11-25 21:35:21.066608|e|1139|5e911640: /usr/libexec/mariadbd(_Z21join_init_read_recordP13st_join_table+0xd8) [0x562ddeeb3248]
2021-11-25 21:35:21.066616|e|1139|5e911640: /usr/libexec/mariadbd(_Z10sub_selectP4JOINP13st_join_tableb+0x177) [0x562ddee9fb77]
2021-11-25 21:35:21.066627|e|1139|5e911640: [key][normalize] failed to normalize: <TEST_TABLE#TEST_COLUMN2>: <ABCD>
2021-11-25 21:35:21.068978|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(grn_ctx_log_back_trace+0x2b) [0x7f3e5d4317ab]
2021-11-25 21:35:21.068988|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(grn_table_get+0x3f3) [0x7f3e5d444933]
2021-11-25 21:35:21.068995|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(+0x45ad4f) [0x7f3e5d647d4f]
2021-11-25 21:35:21.069002|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(+0x45c3b6) [0x7f3e5d6493b6]
2021-11-25 21:35:21.069009|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(grn_table_selector_select+0x2c6) [0x7f3e5d64a186]
2021-11-25 21:35:21.069017|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(grn_table_select+0x48) [0x7f3e5d4734a8]
2021-11-25 21:35:21.069034|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(_ZN10ha_mroonga16storage_rnd_initEb+0x1b3) [0x7f3e5d405b53]
2021-11-25 21:35:21.069043|e|1139|5e911640: /usr/libexec/mariadbd(_ZN7handler22ha_rnd_init_with_errorEb+0x19) [0x562ddf074ec9]
2021-11-25 21:35:21.069051|e|1139|5e911640: /usr/libexec/mariadbd(_Z16init_read_recordP11READ_RECORDP3THDP5TABLEP10SQL_SELECTP9SORT_INFOibb+0x2a4) [0x562ddf1afdd4]
2021-11-25 21:35:21.069059|e|1139|5e911640: /usr/libexec/mariadbd(_Z21join_init_read_recordP13st_join_table+0xd8) [0x562ddeeb3248]
2021-11-25 21:35:21.069067|e|1139|5e911640: /usr/libexec/mariadbd(_Z10sub_selectP4JOINP13st_join_tableb+0x177) [0x562ddee9fb77]
2021-11-25 21:35:21.069074|e|1139|5e911640: /usr/libexec/mariadbd(_ZN4JOIN10exec_innerEv+0xf92) [0x562ddeec9972]
2021-11-25 21:35:21.069081|e|1139|5e911640: /usr/libexec/mariadbd(_ZN4JOIN4execEv+0x31) [0x562ddeec9d51]
2021-11-25 21:35:21.069089|e|1139|5e911640: /usr/libexec/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x111) [0x562ddeec7dd1]
2021-11-25 21:35:21.069098|e|1139|5e911640: /usr/libexec/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resultm+0x134) [0x562ddeec8594]
2021-11-25 21:35:21.069106|e|1139|5e911640: /usr/libexec/mariadbd(+0x78b45c) [0x562ddee5a45c]
2021-11-25 21:35:21.069146|e|1139|5e911640: [table][cursor][open] table must not be NULL
2021-11-25 21:35:21.072413|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(grn_ctx_log_back_trace+0x2b) [0x7f3e5d4317ab]
2021-11-25 21:35:21.072426|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(grn_table_cursor_open+0xaaa) [0x7f3e5d44a62a]
2021-11-25 21:35:21.072434|e|1139|5e911640: /usr/lib64/mysql/plugin/ha_mroonga.so(_ZN10ha_mroonga16storage_rnd_initEb+0x2eb) [0x7f3e5d405c8b]
2021-11-25 21:35:21.072442|e|1139|5e911640: /usr/libexec/mariadbd(_ZN7handler22ha_rnd_init_with_errorEb+0x19) [0x562ddf074ec9]
2021-11-25 21:35:21.072450|e|1139|5e911640: /usr/libexec/mariadbd(_Z16init_read_recordP11READ_RECORDP3THDP5TABLEP10SQL_SELECTP9SORT_INFOibb+0x2a4) [0x562ddf1afdd4]
2021-11-25 21:35:21.072458|e|1139|5e911640: /usr/libexec/mariadbd(_Z21join_init_read_recordP13st_join_table+0xd8) [0x562ddeeb3248]
2021-11-25 21:35:21.072466|e|1139|5e911640: /usr/libexec/mariadbd(_Z10sub_selectP4JOINP13st_join_tableb+0x177) [0x562ddee9fb77]
2021-11-25 21:35:21.072475|e|1139|5e911640: /usr/libexec/mariadbd(_ZN4JOIN10exec_innerEv+0xf92) [0x562ddeec9972]
2021-11-25 21:35:21.072483|e|1139|5e911640: /usr/libexec/mariadbd(_ZN4JOIN4execEv+0x31) [0x562ddeec9d51]
2021-11-25 21:35:21.072491|e|1139|5e911640: /usr/libexec/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x111) [0x562ddeec7dd1]
2021-11-25 21:35:21.072500|e|1139|5e911640: /usr/libexec/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resultm+0x134) [0x562ddeec8594]
2021-11-25 21:35:21.072509|e|1139|5e911640: /usr/libexec/mariadbd(+0x78b45c) [0x562ddee5a45c]
2021-11-25 21:35:21.072516|e|1139|5e911640: /usr/libexec/mariadbd(_Z21mysql_execute_commandP3THDb+0x419d) [0x562ddee66f8d]
2021-11-25 21:35:21.072525|e|1139|5e911640: /usr/libexec/mariadbd(_ZN18Prepared_statement7executeEP6Stringb+0x4ca) [0x562ddee7b10a]
2021-11-25 21:35:21.072533|e|1139|5e911640: /usr/libexec/mariadbd(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0x86) [0x562ddee7b286]
2021-11-25 21:35:21.072541|e|1139|5e911640: /usr/libexec/mariadbd(+0x7ad1ed) [0x562ddee7c1ed]
エンコーディングが GRN_ENC_NONE なのに groonga-normalizer-mysql の
正規化関数が呼ばれたことでエラーになった模様です。たぶん下記のいず
れかが必要なんだと思います。
- MATCH 〜 AGAINST じゃなくて '=' での比較だから正規化しなくてもいい？
→ 正規化関数を呼ばないようにするか、ログを抑制しましょう。
- '=' でも正規化すべき？
→ NONE ではないエンコーディングを渡しましょう。
--
__________________________________________________
_/_/ Tomohiro "Tomo-p" KATO <tomop****@teamg*****>
_/_/ Team Gedoh Network https://www.teamgedoh.net/
_/_/ Key fingerprint: 3347 89D9 5B87 29E6 33A2 30C1 B12F A313 30C4 13F0