<div dir="ltr"><div>※先日、当MLに投稿いたしましたが、過去ログを確認しましたところ、</div><div>　4/19時点で投稿内容が残ってりませんでした為、念のため再投稿させていただきます。</div><div><br></div><div>mroongaを使い始めた者なのですが、下記事象が発生いたしました。</div><div>使い方に問題があるものなのかどうか等、ご教示頂けますと助かります。</div><div><br></div><div>お手数をおかけいたしますが、よろしくお願いいたします。</div><div><br></div><div>[事象]</div><div>複数レコードをINSERT</div><div>↓</div><div>INSERTしたレコードを全てDELETE</div><div>↓</div><div>再度同じレコードをINSERT</div><div><br></div><div>を行うと、そのうち1件で下記エラーが発生いたします。</div><div><br></div><div>ERROR 1062 (23000): Duplicate entry 'カラムの値' for key 'uid'</div><div><br></div><div>※再現手順を下記に記載いたしました。</div><div><br></div><div>[使用環境]</div><div># uname -a</div><div>Linux localhost1.local 3.10.0-229.el7.x86_64 #1 SMP Fri Mar 6 11:36:42 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux</div><div><br></div><div># mysql --version</div><div>mysql Ver 14.14 Distrib 5.6.23, for Linux (x86_64) using EditLine wrapper</div><div><br></div><div>mysql> show variables like '%mroonga%';</div><div>+----------------------------------------+---------------+</div><div>| Variable_name | Value |</div><div>+----------------------------------------+---------------+</div><div>| mroonga_action_on_fulltext_query_error | ERROR_AND_LOG |</div><div>| mroonga_boolean_mode_syntax_flags | DEFAULT |</div><div>| mroonga_database_path_prefix | |</div><div>| mroonga_default_parser | TokenBigram |</div><div>| mroonga_default_wrapper_engine | |</div><div>| mroonga_dry_write | OFF |</div><div>| mroonga_enable_optimization | ON |</div><div>| mroonga_libgroonga_support_lz4 | OFF |</div><div>| mroonga_libgroonga_support_zlib | ON |</div><div>| mroonga_libgroonga_version | 5.0.2 |</div><div>| mroonga_lock_timeout | 10000000 |</div><div>| mroonga_log_file | groonga.log |</div><div>| mroonga_log_level | NOTICE |</div><div>| mroonga_match_escalation_threshold | 0 |</div><div>| mroonga_vector_column_delimiter | |</div><div>| mroonga_version | 5.01 |</div><div>+----------------------------------------+---------------+</div><div><br></div><div>[再現手順]</div><div>(1)テーブルの作成</div><div><br></div><div>CREATE TABLE `uk_test` (</div><div> id int(10) unsigned not null,</div><div> uid varchar(150) not null,</div><div> data text not null,</div><div> primary key (id),</div><div> unique key uid (uid)</div><div>) ENGINE=mroonga DEFAULT CHARSET=utf8;</div><div><br></div><div>(2)データをINSERT</div><div>INSERT INTO uk_test (id,uid, data) VALUES (1,'uid2','');</div><div>INSERT INTO uk_test (id,uid, data) VALUES (2,'uid1','');</div><div>INSERT INTO uk_test (id,uid, data) VALUES (3,'uid3','');</div><div>INSERT INTO uk_test (id,uid, data) VALUES (4,'uid4','');</div><div><br></div><div>(3)データをDELETE</div><div>DELETE FROM uk_test WHERE `id`='1';</div><div>DELETE FROM uk_test WHERE `id`='2';</div><div>DELETE FROM uk_test WHERE `id`='3';</div><div>DELETE FROM uk_test WHERE `id`='4';</div><div><br></div><div>(4)上記(2)と同じデータをINSERT</div><div>INSERT INTO uk_test (id,uid, data) VALUES (1,'uid2','');</div><div>INSERT INTO uk_test (id,uid, data) VALUES (2,'uid1','');</div><div>INSERT INTO uk_test (id,uid, data) VALUES (3,'uid3','');</div><div>INSERT INTO uk_test (id,uid, data) VALUES (4,'uid4','');</div><div><br></div><div>[補足-1]</div><div>上記(2)、(4)で実行するINSER文を下記にしますと、事象が再現しなくなります。</div><div>INSERT INTO uk_test (id,uid, data) VALUES (1,'uid1','');</div><div>INSERT INTO uk_test (id,uid, data) VALUES (2,'uid2','');</div><div>INSERT INTO uk_test (id,uid, data) VALUES (3,'uid3','');</div><div>INSERT INTO uk_test (id,uid, data) VALUES (4,'uid4','');</div><div><br></div><div>[補足-2]</div><div>上記(2)、(4)で実行するINSER文は下記3件でも、事象が再現いたします。</div><div>INSERT INTO uk_test (id,uid, data) VALUES (1,'uid2','');</div><div>INSERT INTO uk_test (id,uid, data) VALUES (2,'uid1','');</div><div>INSERT INTO uk_test (id,uid, data) VALUES (3,'uid3','');</div><div><br></div><div>以上よろしくお願いいたします。</div><div><br></div><div>-------------------------------------------------</div><div>酒匂祐也</div><div><a href="mailto:ysgon****@gmail*****">ysgon****@gmail*****</a><br></div></div>