河野 隆志
takas****@gmo-m*****
2012年 5月 17日 (木) 13:27:28 JST
河野です。 久方ぶりの報告です。 レプリケーション構成にて検証したところ再発しました… 前回の報告で見逃してたエラーを見つけました。 気になるところと言えばcollisions辺りでしょうか… mroonga Slaveは5/8に動かし始め、今回参照系クエリは一切来ないように しています。 で、2012-05-12 19:33:26にmroognaが勝手に再起動しています。 この後は前回同様、データが壊れて参照はできますが更新が一切できない状態に なります。 ちょっとお手上げ状態なんですが、更新系クエリのSQLを正しく書き直して もう一度やってみたいと思います。 2012-05-12 14:52:02.043917|n|41429940|d0=1864 d1=6285 2012-05-12 14:52:02.049709|n|41429940|nterms=8149 chunk=33811 total=13621 2012-05-12 14:52:02.058330|n|41429940|d0=1864 d1=6285 2012-05-12 18:06:01.822291|n|41429940|nterms=259 chunk=348091 total=33747 2012-05-12 18:06:01.824042|n|41429940|d0=134 d1=125 2012-05-12 19:33:23.329713|C|41429940|deadlock detected!!! in GRN_IO_SEG_REF(0xe589520, 65536, 24610) 2012-05-12 19:33:26.265449|n|2dfb87a0|mroonga 2.02 started. 2012-05-12 19:33:26.265477|n|2dfb87a0|log level is 'NOTICE' 2012-05-14 11:37:14.846683|n|46fab940|io(schema_name.mrn.00001DB) collisions(1000/163): lock failed 1000 times 2012-05-14 12:11:34.404319|n|46fab940|io(schema_name.mrn.00001DB) collisions(1000000/163) 2012-05-14 12:45:50.037277|n|46fab940|io(schema_name.mrn.00001DB) collisions(2000000/163) 2012-05-14 13:20:11.380198|n|46fab940|io(schema_name.mrn.00001DB) collisions(3000000/163) 2012-05-14 13:54:33.130061|n|46fab940|io(schema_name.mrn.00001DB) collisions(4000000/163) 2012-05-14 14:28:51.877203|n|46fab940|io(schema_name.mrn.00001DB) collisions(5000000/163) 2012-05-14 15:03:14.397116|n|46fab940|io(schema_name.mrn.00001DB) collisions(6000000/163) 2012-05-14 15:37:37.542020|n|46fab940|io(schema_name.mrn.00001DB) collisions(7000000/163) 2012-05-14 16:12:03.949706|n|46fab940|io(schema_name.mrn.00001DB) collisions(8000000/163) 2012-05-14 16:46:15.785400|n|46fab940|io(schema_name.mrn.00001DB) collisions(9000000/163) 2012-05-14 17:20:27.957877|n|46fab940|io(schema_name.mrn.00001DB) collisions(10000000/163) 2012-05-14 17:20:27.960869|w|46fab940|[DB Locked] time out(10000000): io(schema_name.mrn.00001DB) collisions(10000000/163) 2012-05-14 17:20:27.960896|e|46fab940|grn_io_lock failed 2012-05-14 17:20:27.962277|e|46fab940|/usr/local/groonga202/lib/libgroonga.so.0(grn_io_lock+0x214) [0x2aaab301ca8d] 2012-05-14 17:20:27.962293|e|46fab940|/usr/local/groonga202/lib/libgroonga.so.0(grn_ii_column_update+0xbf) [0x2aaab30173b0] 2012-05-14 17:20:27.962299|e|46fab940|/usr/local/groonga202/lib/libgroonga.so.0(grn_column_index_update+0x32) [0x2aaab2f5aba1] 2012-05-14 17:20:27.962305|e|46fab940|/usr/local/mysql5523/lib/plugin/ha_mroonga.so(_ZN10ha_mroonga24storage_update_row_indexEPKhPh+0x4ed) [0x2aaab2d195d3] 2012-05-14 17:20:27.962311|e|46fab940|/usr/local/mysql5523/lib/plugin/ha_mroonga.so(_ZN10ha_mroonga18storage_update_rowEPKhPh+0x5eb) [0x2aaab2d1aefd] 2012-05-14 17:20:27.962317|e|46fab940|/usr/local/mysql5523/bin/mysqld(_ZN7handler13ha_update_rowEPKhPh+0x6f) [0x66f9df] 2012-05-14 17:20:27.962323|e|46fab940|/usr/local/mysql5523/bin/mysqld(_Z12write_recordP3THDP5TABLEP12st_copy_info+0x63c) [0x56090c] 2012-05-14 17:20:27.962329|e|46fab940|/usr/local/mysql5523/bin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0xad7) [0x567017] 2012-05-14 17:20:27.962335|e|46fab940|/usr/local/mysql5523/bin/mysqld(_Z21mysql_execute_commandP3THD+0x14c7) [0x576c97] 2012-05-14 17:20:27.962341|e|46fab940|/usr/local/mysql5523/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x18a) [0x579fba] 2012-05-14 17:20:27.962363|e|46fab940|/usr/local/mysql5523/bin/mysqld(_ZN15Query_log_event14do_apply_eventEPK14Relay_log_infoPKcj+0xd5c) [0x71723c] 2012-05-14 17:20:27.962370|e|46fab940|/usr/local/mysql5523/bin/mysqld(_Z26apply_event_and_update_posP9Log_eventP3THDP14Relay_log_info+0x125) [0x515ed5] 2012-05-14 17:20:27.962375|e|46fab940|/usr/local/mysql5523/bin/mysqld [0x51b95a] 2012-05-14 17:20:27.962380|e|46fab940|/usr/local/mysql5523/bin/mysqld(handle_slave_sql+0xa7b) [0x51e59b] 2012-05-14 17:20:27.962386|e|46fab940|/lib64/libpthread.so.0 [0x3a94a0677d] 2012-05-14 17:20:27.962391|e|46fab940|/lib64/libc.so.6(clone+0x6d) [0x3a93ed325d] 以上、宜しくお願い致します。 -- 河野 隆志 <takas****@gmo-m*****>
