河野 隆志
takas****@gmo-m*****
2012年 3月 29日 (木) 20:15:37 JST
河野です
mroonga起動直後は普通に通るクエリが、起動後に負荷(レプリケーションと参照
クエリ)をかけてしばらくすると、クエリ実行時にエラーを出力して結果が返っ
てきません。(負荷は10〜15回/secくらいのSELECT＋レプリケーション)
mroongaを再起動すると元通りクエリは通るようになるのですが、またしばらく
するとエラーを出して使えなくなります。
なにかお心当たりありますでしょうか？
SQL実行時のエラー
localhost:test_db>
localhost:test_db>SELECT id FROM search_texts WHERE MATCH (text) AGAINST
('*D+ ほげほげ あげ' IN BOOLEAN MODE) ORDER BY created DESC LIMIT
180,180;
ERROR 1064 (42000): failed to parse fulltext search keyword: <*D+ ほげほ
げ あげ>: <table is null>
localhost:test_db>
localhost:test_db>
groonga.log
2012-03-29 19:51:11.337823| |41221940|40003a30|:1333018271337821000 filter(8139)
2012-03-29 19:51:11.361816| |466bf940|40003a30|:1333018271361815000 filter(26151)
2012-03-29 19:51:11.393343| |411c0940|40003a30|:1333018271393342000 filter(5399)
2012-03-29 19:51:11.773211| |4668e940|40003a30|:1333018271773210000 filter(22541)
2012-03-29 19:51:11.840492| |414cc940|40003a30|:1333018271840490000 filter(14178)
2012-03-29 19:51:11.871469|e|465fb940|Syntax error! (~y)
2012-03-29 19:51:11.873039|e|465fb940|/usr/local/groonga201/lib/libgroonga.so.0(grn_expr_parser+0x1721) [0x2aaab2f8aabc]
2012-03-29 19:51:11.873052|e|465fb940|/usr/local/groonga201/lib/libgroonga.so.0 [0x2aaab2f8ae06]
2012-03-29 19:51:11.873058|e|465fb940|/usr/local/groonga201/lib/libgroonga.so.0(grn_expr_parse+0x62f) [0x2aaab2f8bc94]
2012-03-29 19:51:11.873063|e|465fb940|/usr/local/mysql5522/lib/plugin/ha_mroonga.so(_ZN10ha_mroonga19generic_ft_init_extEjjP6String+0x535) [0x2aaab2d107cb]
2012-03-29 19:51:11.873069|e|465fb940|/usr/local/mysql5522/lib/plugin/ha_mroonga.so(_ZN10ha_mroonga19storage_ft_init_extEjjP6String+0x9) [0x2aaab2d10b95]
2012-03-29 19:51:11.873074|e|465fb940|/usr/local/mysql5522/bin/mysqld(_ZN15Item_func_match11init_searchEb+0x16b) [0x6b31ab]
2012-03-29 19:51:11.873079|e|465fb940|/usr/local/mysql5522/bin/mysqld(_Z12init_ftfuncsP3THDP13st_select_lexb+0x60) [0x5371d0]
2012-03-29 19:51:11.873084|e|465fb940|/usr/local/mysql5522/bin/mysqld(_ZN4JOIN8optimizeEv+0x1c13) [0x5ab3c3]
2012-03-29 19:51:11.873090|e|465fb940|/usr/local/mysql5522/bin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x171) [0x5ad971]
2012-03-29 19:51:11.873095|e|465fb940|/usr/local/mysql5522/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x179) [0x5b3729]
2012-03-29 19:51:11.873100|e|465fb940|/usr/local/mysql5522/bin/mysqld [0x571811]
2012-03-29 19:51:11.873105|e|465fb940|/usr/local/mysql5522/bin/mysqld(_Z21mysql_execute_commandP3THD+0x2216) [0x576de6]
2012-03-29 19:51:11.873110|e|465fb940|/usr/local/mysql5522/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x18a) [0x5793ba]
2012-03-29 19:51:11.873115|e|465fb940|/usr/local/mysql5522/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1321) [0x57af61]
2012-03-29 19:51:11.873121|e|465fb940|/usr/local/mysql5522/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x167) [0x60fbb7]
2012-03-29 19:51:11.873126|e|465fb940|/usr/local/mysql5522/bin/mysqld(handle_one_connection+0x54) [0x60fc24]
2012-03-29 19:51:11.873145|e|465fb940|failed to parse fulltext search keyword: <*D+ ~y>: <Syntax error! (~y)>
2012-03-29 19:51:11.873164|w|465fb940|result is not a array
2012-03-29 19:51:11.959019|e|40521940|failed to parse fulltext search keyword: <*D+ fl あばばば>: <result is not a array>
2012-03-29 19:51:11.959070|w|40521940|table is null
2012-03-29 19:51:12.061919|e|41221940|failed to parse fulltext search keyword: <*D+ ほげ もげ>: <table is null>
2012-03-29 19:51:12.061972|w|41221940|table is null
--
河野 隆志 <takas****@gmo-m*****>