<!DOCTYPE html>
<html>
<head>
</head>
<body>
<dl style="line-height: 1.5; margin-left: 2em">
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Author</dt>
<dd style="margin-left: 8.5em">Kentaro Hayashi <hayas****@clear*****></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt>
<dd style="margin-left: 8.5em">2019-07-31 12:50:26 +0900 (Wed, 31 Jul 2019)</dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Revision</dt>
<dd style="margin-left: 8.5em"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861">13252f0e655d7ff1fa6ae72fc0f617573c65b861</a></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Message</dt>
<dd style="margin-left: 8.5em"><pre style="border: 1px solid #aaa; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; padding: 0.5em; width: auto">blog: add notification about fixed bug</pre></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Modified files</dt>
<dd style="margin-left: 8.5em">
<ul>
<li><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128">ja/_posts/2019-07-30-mroonga-9.05.md</a></li>
</ul>
</dd>
</dl>
<div class="diff-section" style="clear: both">
<table style="border-collapse: collapse; border: 1px solid #aaa">
<thead>
<tr class="diff-header" style="border: 1px solid #aaa">
<td colspan="3">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: ja/_posts/2019-07-30-mroonga-9.05.md (+7 -1)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
</td>
</tr>
</thead>
<tbody>
<tr>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L18">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L21">21</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L22">22</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L23">23</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L24">24</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L25">25</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L69">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L70">70</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L71">71</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L72">72</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L73">73</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L74">74</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128L75">75</a></span>
</pre>
</th>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R18">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R19">19</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R20">20</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R21">21</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R22">22</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R23">23</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R24">24</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R25">25</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R26">26</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R27">27</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R28">28</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R72">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R73">73</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R74">74</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R75">75</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R76">76</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R77">77</a></span>
<span class="diff-line-number-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R78">78</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R79">79</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R80">80</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/mroonga/mroonga.github.com/commit/13252f0e655d7ff1fa6ae72fc0f617573c65b861#diff-4f7b53a437ba1f8523d1039802679128R81">81</a></span>
</pre>
</th>
<td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -19,7 +19,10 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">published: false</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> * MySQL 5.6.45と5.7.27とMySQL 8.0.17への対応</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> * ユニークインデックスを更新する際の不具合を修正</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffecec; color: #000000; display: block; white-space: pre">-Mroongaの変更点ではないのですが、Groonga 9.0.5で大きな全文検索用のインデックスを更新したときにクラッシュする可能性のある不具合が修正されているので、クラッシュする問題を踏んでいる場合には、アップグレードすることで解決するかもしれません。</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+ユニークインデックスを更新する際の不具合を修正しているので、すでにユニークインデックスを作っている人はテーブルを作り直す必要があります。</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+既存のユニークインデックスにゴミが残っているかもしれないからです。詳細は後述します。</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+また、Mroongaの変更点ではないのですが、Groonga 9.0.5で大きな全文検索用のインデックスを更新したときにクラッシュする可能性のある不具合が修正されているので、クラッシュする問題を踏んでいる場合には、アップグレードすることで解決するかもしれません。</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ### MySQL 5.6.45と5.7.27とMySQL 8.0.17への対応</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -70,6 +73,9 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">ERROR 1062 (23000): Duplicate entry '10-100' for key 'source_id'</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 上記のようなケースで、古いインデックスのエントリが削除されず、キーの重複が発生してしまっていました。</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+冒頭でも述べましたが、すでにユニークインデックスを作っている人はテーブルを作り直す必要があります。</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+テーブルを作り直すには、ダンプ・リストアするか、`ALTER TABLE (ユニークインデックスを作ったテーブル} FORCE` を実行してください。</span>
<span class="diff-added" style="background-color: #eaffea; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ### おわりに</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 9.04からの詳細な変更点は[9.05リリース - 2019-07-30](/ja/docs/news.html#release-9-05)を確認してください。</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>