<div dir="ltr">
<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">各務様</span><div><span style="font-size:14px"><br></span></div><div><span style="font-size:14px">こんにちは、</span><span style="font-size:14px">ご連絡ありがとうございます。</span></div><div><span style="font-size:14px"><br></span></div><div><span style="font-size:14px">再現テストで1度だけ発生したのですが、その後も何度か</span><span style="font-size:14px">トライし<wbr>ているのですが、再発しない状況です。</span></div><div><span style="font-size:14px">しかも、再発した1回もmysqldumpですと時間がかかるので、「FLUSH TABLES；」でテストした際に</span></div><div><span style="font-size:14px">発生しただけです。</span></div><div><br></div><div><span style="font-size:14px">ログですが、発生当時のログは私の手元にないので共有できないのですが、</span></div><div><span style="font-size:14px">再現テストで再発した際の MySQLのログとmessagesは以下となります。</span></div><div><span style="font-size:14px">（groonga.logは取っておりませんでした。。。</span><br></div><div><span style="font-size:14px"> 後ほど取得できましたら、追加で共有させていただきます。）</span></div><div><span style="font-size:14px"><br></span></div><div><span style="font-size:14px">以上、よろしくお願いいたします。</span></div><div><span style="font-size:14px"><br></span></div><div><span style="font-size:14px">===MySQL log========</span></div><div><div><span style="font-size:14px">[Thu May 17 15:25:00.892 2018] 15:25:00 [user@test001 ~]$ tail -F /var/log/mysql/mysql.err</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] 06:50:52 UTC - mysqld got signal 11 ;</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] This could be because you hit a bug. It is also possible that this binary</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] or one of the libraries it was linked against is corrupt, improperly built,</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] or misconfigured. This error can also be caused by malfunctioning hardware.</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] We will try our best to scrape up some info that will hopefully help</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] diagnose the problem, but since we have already crashed, </span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] something is definitely wrong and this may fail.</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] </span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] key_buffer_size=8388608</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] read_buffer_size=524288</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] max_used_connections=12</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] max_threads=6000</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] thread_count=6</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] connection_count=6</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] It is possible that mysqld could use up to </span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 9305332 K bytes of memory</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] Hope that's ok; if not, decrease some variables in the equation.</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] </span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] Thread pointer: 0x1013db100</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] Attempting backtrace. You can use the following information to find out</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] where mysqld died. If you see no messages after this, something went</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.202 2018] terribly wrong...</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] stack_bottom = 7f8cfa2d5e18 thread_stack 0x40000</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8f85e5]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] /usr/sbin/mysqld(handle_fatal_signal+0x4a4)[0x68f2e4]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] /lib64/libpthread.so.0[0x3928e0f500]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] /usr/lib64/libgroonga.so.0(grn_expr_add_var+0x1ac)[0x32532607bc]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] /usr/lib64/libgroonga.so.0(grn_proc_create+0x578)[0x3253239468]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] /usr/lib64/libgroonga.so.0(grn_normalizer_register+0x6f)[0x32533720bf]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] /usr/lib64/groonga/plugins/normalizers/mysql.so(grn_plugin_impl_register+0x21)[0x7f8cc2de5481]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] /usr/lib64/libgroonga.so.0(grn_plugin_register_by_path+0x354)[0x325338a294]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] /usr/lib64/libgroonga.so.0(grn_plugin_register+0x4f)[0x325338a30f]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] /usr/lib64/mysql/plugin/ha_mroonga.so(_ZN10ha_mroonga20ensure_database_openEPKc+0x185)[0x7fb62cbcfcf5]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] /usr/lib64/mysql/plugin/ha_mroonga.so(_ZN10ha_mroonga12wrapper_openEPKcij+0x34)[0x7fb62cbd0744]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] /usr/lib64/mysql/plugin/ha_mroonga.so(_ZN10ha_mroonga4openEPKcij+0xaa)[0x7fb62cbd0b2a]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] /usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcii+0x3e)[0x5d5b4e]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.234 2018] /usr/sbin/mysqld(_Z21open_table_from_shareP3THDP11TABLE_SHAREPKcjjjP5TABLEb+0x624)[0x7919f4]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.237 2018] /usr/sbin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0x1eb)[0x6c52eb]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.237 2018] /usr/sbin/mysqld(_Z11open_tablesP3THDPP10TABLE_LISTPjjP19Prelocking_strategy+0xcaa)[0x6c7aba]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.237 2018] /usr/sbin/mysqld(_Z30open_normal_and_derived_tablesP3THDP10TABLE_LISTj+0x4f)[0x6c7bdf]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] /usr/sbin/mysqld[0x7069e1]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x117e)[0x7090be]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x32f)[0x70cc0f]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xe28)[0x70db28]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0xcf)[0x6db6cf]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] /usr/sbin/mysqld(handle_one_connection+0x47)[0x6db7f7]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] /usr/sbin/mysqld(pfs_spawn_thread+0x139)[0x97a0a9]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] /lib64/libpthread.so.0[0x3928e07851]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] /lib64/libc.so.6(clone+0x6d)[0x3928ae890d]</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] </span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] Trying to get some variables.</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] Some pointers may be invalid and cause the dump to abort.</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] Query (7f8c3c0e1790): is an invalid pointer</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] Connection ID (thread ID): 63749</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] Status: NOT_KILLED</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] </span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] The manual page at <a href="http://dev.mysql.com/doc/mysql/en/crashing.html">http://dev.mysql.com/doc/mysql/en/crashing.html</a> contains</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.283 2018] information that should help you find out what is causing the crash.</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.540 2018] 180517 15:50:52 mysqld_safe Number of processes running now: 0</span></div><div><span style="font-size:14px">[Thu May 17 15:50:52.540 2018] 180517 15:50:52 mysqld_safe mysqld restarted</span></div><div style="font-size:14px">=======================================================================</div></div><div style="font-size:14px"><br></div><div style="font-size:14px"><br></div><div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">
<div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial"><span style="font-size:14px">===messages========</span></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial"><div>[Thu May 17 15:50:02.149 2018] May 17 15:50:02 test001 xinetd[4620]: START: shell pid=10341 from=::ffff:10.181.192.1</div><div>[Thu May 17 15:50:02.394 2018] May 17 15:50:02 test001 cibadmin: [10428]: info: Invoked: cibadmin -Q </div><div>[Thu May 17 15:50:02.394 2018] May 17 15:50:02 test001 cibadmin: [10444]: info: Invoked: cibadmin --query --xpath //crm_config//nvpair[@name='cluster_name'] </div><div>[Thu May 17 15:50:02.394 2018] May 17 15:50:02 test001 cibadmin: [10449]: info: Invoked: cibadmin --query --xpath //primitive[@id='res_IPaddr2_cluster_ip'][@type='IPaddr2']/instance_attributes/nvpair[@name='ip'] </div><div>[Thu May 17 15:50:02.394 2018] May 17 15:50:02 test001 xinetd[4620]: EXIT: shell status=0 pid=10341 duration=0(sec)</div><div>[Thu May 17 15:50:02.646 2018] May 17 15:50:02 test001 xinetd[4620]: START: shell pid=10496 from=::ffff:10.181.192.1</div><div>[Thu May 17 15:50:02.896 2018] May 17 15:50:02 test001 cibadmin: [10559]: info: Invoked: cibadmin -Q </div><div>[Thu May 17 15:50:02.896 2018] May 17 15:50:02 test001 cibadmin: [10578]: info: Invoked: cibadmin --query --xpath //crm_config//nvpair[@name='cluster_name'] </div><div>[Thu May 17 15:50:02.896 2018] May 17 15:50:02 test001 cibadmin: [10581]: info: Invoked: cibadmin --query --xpath //primitive[@id='res_IPaddr2_cluster_ip'][@type='IPaddr2']/instance_attributes/nvpair[@name='ip'] </div><div>[Thu May 17 15:50:02.896 2018] May 17 15:50:02 test001 xinetd[4620]: EXIT: shell status=0 pid=10496 duration=0(sec)</div><div>[Thu May 17 15:50:04.606 2018] May 17 15:50:04 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:07.602 2018] May 17 15:50:07 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:10.639 2018] May 17 15:50:10 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:13.607 2018] May 17 15:50:13 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:16.630 2018] May 17 15:50:16 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:19.613 2018] May 17 15:50:19 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:20.602 2018] May 17 15:50:20 test001 cibadmin: [16931]: info: Invoked: cibadmin -Q </div><div>[Thu May 17 15:50:20.844 2018] May 17 15:50:20 test001 cibadmin: [16953]: info: Invoked: cibadmin --query --xpath //crm_config//nvpair[@name='cluster_name'] </div><div>[Thu May 17 15:50:20.844 2018] May 17 15:50:20 test001 cibadmin: [16957]: info: Invoked: cibadmin --query --xpath //primitive[@id='res_IPaddr2_cluster_ip'][@type='IPaddr2']/instance_attributes/nvpair[@name='ip'] </div><div>[Thu May 17 15:50:22.620 2018] May 17 15:50:22 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:25.619 2018] May 17 15:50:25 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:28.623 2018] May 17 15:50:28 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:31.625 2018] May 17 15:50:31 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:35.406 2018] May 17 15:50:34 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:37.628 2018] May 17 15:50:37 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:40.634 2018] May 17 15:50:40 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:43.645 2018] May 17 15:50:43 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:46.642 2018] May 17 15:50:46 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:49.672 2018] May 17 15:50:49 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:52.649 2018] May 17 15:50:52 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:55.648 2018] May 17 15:50:55 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:50:58.651 2018] May 17 15:50:58 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:01.656 2018] May 17 15:51:01 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:02.335 2018] May 17 15:51:02 test001 xinetd[4620]: START: shell pid=30903 from=::ffff:10.181.192.1</div><div>[Thu May 17 15:51:02.577 2018] May 17 15:51:02 test001 cibadmin: [30961]: info: Invoked: cibadmin -Q </div><div>[Thu May 17 15:51:02.577 2018] May 17 15:51:02 test001 cibadmin: [30988]: info: Invoked: cibadmin --query --xpath //crm_config//nvpair[@name='cluster_name'] </div><div>[Thu May 17 15:51:02.577 2018] May 17 15:51:02 test001 cibadmin: [30994]: info: Invoked: cibadmin --query --xpath //primitive[@id='res_IPaddr2_cluster_ip'][@type='IPaddr2']/instance_attributes/nvpair[@name='ip'] </div><div>[Thu May 17 15:51:02.577 2018] May 17 15:51:02 test001 xinetd[4620]: EXIT: shell status=0 pid=30903 duration=0(sec)</div><div>[Thu May 17 15:51:02.868 2018] May 17 15:51:02 test001 xinetd[4620]: START: shell pid=31026 from=::ffff:10.181.192.1</div><div>[Thu May 17 15:51:02.868 2018] May 17 15:51:02 test001 cibadmin: [31086]: info: Invoked: cibadmin -Q </div><div>[Thu May 17 15:51:02.868 2018] May 17 15:51:02 test001 cibadmin: [31093]: info: Invoked: cibadmin --query --xpath //crm_config//nvpair[@name='cluster_name'] </div><div>[Thu May 17 15:51:02.868 2018] May 17 15:51:02 test001 cibadmin: [31095]: info: Invoked: cibadmin --query --xpath //primitive[@id='res_IPaddr2_cluster_ip'][@type='IPaddr2']/instance_attributes/nvpair[@name='ip'] </div><div>[Thu May 17 15:51:02.868 2018] May 17 15:51:02 test001 xinetd[4620]: EXIT: shell status=0 pid=31026 duration=0(sec)</div><div>[Thu May 17 15:51:04.669 2018] May 17 15:51:04 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:07.661 2018] May 17 15:51:07 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:10.459 2018] May 17 15:51:10 test001 cibadmin: [1252]: info: Invoked: cibadmin -Q </div><div>[Thu May 17 15:51:10.709 2018] May 17 15:51:10 test001 cibadmin: [1273]: info: Invoked: cibadmin --query --xpath //crm_config//nvpair[@name='cluster_name'] </div><div>[Thu May 17 15:51:10.709 2018] May 17 15:51:10 test001 cibadmin: [1276]: info: Invoked: cibadmin --query --xpath //primitive[@id='res_IPaddr2_cluster_ip'][@type='IPaddr2']/instance_attributes/nvpair[@name='ip'] </div><div>[Thu May 17 15:51:10.709 2018] May 17 15:51:10 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:13.671 2018] May 17 15:51:13 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:16.678 2018] May 17 15:51:16 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:19.688 2018] May 17 15:51:19 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:22.675 2018] May 17 15:51:22 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:25.680 2018] May 17 15:51:25 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:28.683 2018] May 17 15:51:28 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:31.686 2018] May 17 15:51:31 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:34.693 2018] May 17 15:51:34 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:37.695 2018] May 17 15:51:37 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:40.695 2018] May 17 15:51:40 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:43.705 2018] May 17 15:51:43 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:46.701 2018] May 17 15:51:46 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>[Thu May 17 15:51:49.703 2018] May 17 15:51:49 test001 snmpd[4612]: refused smux peer: oid SNMPv2-SMI::enterprises.674.10892.1, descr Systems Management SNMP MIB Plug-in Manager</div><div>==================================================================</div>
</div><br></span></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:14px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">2018年5月17日 20:23 各務洋 <span dir="ltr"><<a href="mailto:kagam****@pyrol*****" target="_blank">kagam****@pyrol*****</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">大川様。<br>
各務と申します。<br>
<br>
mysqldump での クラッシュですと、毎回発生しないようですと、<wbr>再現は大変な気がします。<br>
<br>
クラッシュが発生した際のログ、<br>
<br>
/var/log/message<br>
/var/lib/mysql/groonga.log<br>
/var/log/mysqld.log<br>
<br>
あたりを記述いただければ、<wbr>何か知見が出てくるかもしれないです。<br>
<br>
個人的には CentOS 5の頃の設定、 vm.swappiness = 0 を CentOS 6 に適用していて<br>
よくクラッシュしていました。<br>
<br>
過渡的な状況でしたら、<wbr>クラッシュしにくくなる緩和策を求めるのも手かもしれないです。<br>
いかがでしょうか？<br>
<br>
2018年5月17日 17:32 大川敬臣 <<a href="mailto:yoshi****@kccs*****">yoshi****@kccs*****</a>>:<br>
<div><div class="h5">> お世話になっております。<br>
> 大川と申します。<br>
><br>
> 以下の環境でのMySQL Databaseサーバで質問させてください。<br>
><br>
> RHEL：6.4<br>
> MySQL：5.6.11<br>
> Mroonga：3.0.3<br>
><br>
> 上記の環境でmysqldumpを実行したタイミングでMySQ<wbr>Lが再起動する事象が発生しました。<br>
> 当方では、以下のバグに該当していると想定しております。<br>
> （Oracleサポートに問い合わせしたところ、<wbr>Mroongaストレージエンジンでクラッシュが発生したため、<wbr>MySQLが再起動したと回答を頂いております。）<br>
><br>
> 【Bug #2098】 ストレージエンジンMroonga時にmysqldumpすると<wbr>mysqldが落ちる<br>
> <a href="http://redmine.groonga.org/issues/2098" rel="noreferrer" target="_blank">http://redmine.groonga.org/<wbr>issues/2098</a><br>
><br>
> 実際に発生した環境は商用の環境なのですが、顧客説明のため、<wbr>テスト環境で再現試験を行っております。<br>
> しかし、<wbr>何度mysqldumpを実行しても再現させることができません<wbr>。<br>
> 実際にMySQLの再起動が発生したコマンドは以下となります。<br>
><br>
>>mysqldump --login-path=root --single-transaction --max-allowed-packet=1G<br>
>> --events --routines --flush-logs --master-data=2 --flush-privileges<br>
>> --all-databases > /data/db_mkt_delivery.sql &<br>
><br>
> 最終的には上記コマンドでは無く、<wbr>オプションを変えてMroonga ストレージエンジンを含まないDBのみdump出力するように<br>
> 変更する予定なのですが、その変更が効果があるかを確認したく、<wbr>ます、再現をさせている状況でございます。<br>
><br>
> 上記のmysqldumpで再現させるアイデアがあればご教示い<wbr>ただきたく質問させていただきました。<br>
><br>
> 事象が上記のバグではないんじゃないか？<wbr>と言った意見もございましたら、<wbr>ご教示くださいますようお願いいたします。<br>
><br>
> 皆様、どうぞよろしくお願いいたします。<br>
><br>
</div></div>> ______________________________<wbr>_________________<br>
> groonga-dev mailing list<br>
> <a href="mailto:groon****@lists*****">groon****@lists*****</a><br>
> <a href="https://lists.osdn.me/mailman/listinfo/groonga-dev" rel="noreferrer" target="_blank">https://lists.osdn.me/mailman/<wbr>listinfo/groonga-dev</a><br>
><br>
______________________________<wbr>_________________<br>
groonga-dev mailing list<br>
<a href="mailto:groon****@lists*****">groon****@lists*****</a><br>
<a href="https://lists.osdn.me/mailman/listinfo/groonga-dev" rel="noreferrer" target="_blank">https://lists.osdn.me/mailman/<wbr>listinfo/groonga-dev</a><br>
</blockquote></div><br></div>