Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.1.14
-
Debian Jessie 64bit , Intel(R) Xeon(R) CPU E5-2658 0 @ 2.10GHz, 11GiB Mémoire système .
2 nodes + 1 arbitrator
Driver : mysql-connector-java.5.1.39
Description
Since several months , i have once of my node taht suddenfly crash , randomly , even the server is at low charge. We were on 10.1.10 (start of our cluster project) . I already try number of thinks ...( update Os (now debian 8.5 ) , upgrade mariadb 10.1.10 to 10.1.14 ) , change parameters in my.cnf ...) We were on a single mysql without these kinds of problems and it's a real problem to explain that now with a cluster , our websites are less available...
Here the full stack trace and the my.cnf, thanks for your help .
|
stacktrace |
160822 20:53:37 [ERROR] mysqld got signal 11 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
|
Server version: 10.1.14-MariaDB
|
key_buffer_size=10485760
|
read_buffer_size=131072
|
max_used_connections=83
|
max_threads=302
|
thread_count=37
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 673557 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x0x7ff644012008
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7ff8fe0e8258 thread_stack 0x48400
|
*** buffer overflow detected ***: /mysql/bin/mysqld terminated
|
======= Backtrace: =========
|
/lib/x86_64-linux-gnu/libc.so.6(+0x731af)[0x7ff8fb6331af]
|
/lib/x86_64-linux-gnu/libc.so.6(__fortify_fail+0x37)[0x7ff8fb6b8cf7]
|
/lib/x86_64-linux-gnu/libc.so.6(+0xf6f10)[0x7ff8fb6b6f10]
|
/lib/x86_64-linux-gnu/libc.so.6(+0xf8c67)[0x7ff8fb6b8c67]
|
/mysql/bin/mysqld(my_addr_resolve+0x45)[0x7ff8fda94bf5]
|
/mysql/bin/mysqld(my_print_stacktrace+0x1b2)[0x7ff8fda81772]
|
/mysql/bin/mysqld(handle_fatal_signal+0x355)[0x7ff8fd5ebb65]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0xf8d0)[0x7ff8fcc2c8d0]
|
/mysql/bin/mysqld(_ZN13MYSQL_BIN_LOG13mark_xid_doneEmb+0x7b)[0x7ff8fd696c2b]
|
/mysql/bin/mysqld(binlog_background_thread+0x28b)[0x7ff8fd69713b]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x80a4)[0x7ff8fcc250a4]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7ff8fb6a887d]
|
======= Memory map: ========
|
7ff621400000-7ff621c00000 rw-p 00000000 00:00 0
|
7ff621fff000-7ff622000000 ---p 00000000 00:00 0
|
7ff622000000-7ff63b800000 rw-p 00000000 00:00 0
|
7ff63bbf5000-7ff63bbf6000 ---p 00000000 00:00 0
|
7ff63bbf6000-7ff63c3f6000 rw-p 00000000 00:00 0 [stack:1842]
|
7ff63c3f6000-7ff63c3f7000 ---p 00000000 00:00 0
|
7ff63c3f7000-7ff63cbf7000 rw-p 00000000 00:00 0 [stack:1841]
|
7ff63cbf7000-7ff63cbf8000 ---p 00000000 00:00 0
|
7ff63cbf8000-7ff63d3f8000 rw-p 00000000 00:00 0 [stack:1840]
|
7ff63d3f8000-7ff63d3f9000 ---p 00000000 00:00 0
|
7ff63d3f9000-7ff63dbf9000 rw-p 00000000 00:00 0 [stack:1839]
|
7ff63dbf9000-7ff63dbfa000 ---p 00000000 00:00 0
|
7ff63dbfa000-7ff63e3fa000 rw-p 00000000 00:00 0 [stack:1838]
|
7ff63e3fa000-7ff63e3fb000 ---p 00000000 00:00 0
|
7ff63e3fb000-7ff63ebfb000 rw-p 00000000 00:00 0 [stack:1836]
|
7ff63ebfb000-7ff63ebfc000 ---p 00000000 00:00 0
|
7ff63ebfc000-7ff63f3fc000 rw-p 00000000 00:00 0 [stack:1835]
|
7ff63f3fc000-7ff63f3fd000 ---p 00000000 00:00 0
|
7ff63f3fd000-7ff63fbfd000 rw-p 00000000 00:00 0 [stack:1834]
|
7ff63fbfd000-7ff63fbfe000 ---p 00000000 00:00 0
|
7ff63fbfe000-7ff6403fe000 rw-p 00000000 00:00 0 [stack:1833]
|
7ff6403fe000-7ff6403ff000 ---p 00000000 00:00 0
|
7ff6403ff000-7ff640bff000 rw-p 00000000 00:00 0 [stack:1832]
|
7ff640bff000-7ff640c00000 ---p 00000000 00:00 0
|
7ff640c00000-7ff648800000 rw-p 00000000 00:00 0 [stack:1837]
|
7ff64895c000-7ff64895d000 ---p 00000000 00:00 0
|
7ff64895d000-7ff6489a6000 rw-p 00000000 00:00 0
|
7ff6489a6000-7ff6489a7000 ---p 00000000 00:00 0
|
7ff6489a7000-7ff6489f0000 rw-p 00000000 00:00 0
|
7ff6489f0000-7ff6489f1000 ---p 00000000 00:00 0
|
7ff6489f1000-7ff648a3a000 rw-p 00000000 00:00 0
|
7ff648a3a000-7ff648a3b000 ---p 00000000 00:00 0
|
7ff648a3b000-7ff648a84000 rw-p 00000000 00:00 0 [stack:8993]
|
7ff648a84000-7ff648a85000 ---p 00000000 00:00 0
|
7ff648a85000-7ff648ace000 rw-p 00000000 00:00 0
|
7ff648ace000-7ff648acf000 ---p 00000000 00:00 0
|
7ff648acf000-7ff648b18000 rw-p 00000000 00:00 0 [stack:7892]
|
7ff648b18000-7ff648b19000 ---p 00000000 00:00 0
|
7ff648b19000-7ff648b62000 rw-p 00000000 00:00 0
|
7ff648b62000-7ff648b63000 ---p 00000000 00:00 0
|
7ff648b63000-7ff648bac000 rw-p 00000000 00:00 0
|
7ff648bac000-7ff648bad000 ---p 00000000 00:00 0
|
7ff648bad000-7ff648bf6000 rw-p 00000000 00:00 0
|
7ff648bf6000-7ff648bf7000 ---p 00000000 00:00 0
|
7ff648bf7000-7ff6493f7000 rw-p 00000000 00:00 0 [stack:1827]
|
7ff6493f7000-7ff6493f8000 ---p 00000000 00:00 0
|
7ff6493f8000-7ff649bf8000 rw-p 00000000 00:00 0 [stack:1826]
|
7ff649bf8000-7ff649bf9000 ---p 00000000 00:00 0
|
7ff649bf9000-7ff64a3f9000 rw-p 00000000 00:00 0 [stack:1825]
|
7ff64a3f9000-7ff64a3fa000 ---p 00000000 00:00 0
|
7ff64a3fa000-7ff64abfa000 rw-p 00000000 00:00 0 [stack:1824]
|
7ff64abfa000-7ff64abfb000 ---p 00000000 00:00 0
|
7ff64abfb000-7ff64b3fb000 rw-p 00000000 00:00 0 [stack:1823]
|
7ff64b3fb000-7ff64b3fc000 ---p 00000000 00:00 0
|
7ff64b3fc000-7ff64bbfc000 rw-p 00000000 00:00 0 [stack:1822]
|
7ff64bbfc000-7ff64bbfd000 ---p 00000000 00:00 0
|
7ff64bbfd000-7ff64c3fd000 rw-p 00000000 00:00 0 [stack:1821]
|
7ff64c3fd000-7ff64c3fe000 ---p 00000000 00:00 0
|
7ff64c3fe000-7ff64cbfe000 rw-p 00000000 00:00 0 [stack:1820]
|
7ff64cbfe000-7ff64cbff000 ---p 00000000 00:00 0
|
7ff64cbff000-7ff64d3ff000 rw-p 00000000 00:00 0 [stack:1819]
|
7ff64d3ff000-7ff64d400000 ---p 00000000 00:00 0
|
7ff64d400000-7ff7b1000000 rw-p 00000000 00:00 0 [stack:1818]
|
7ff7b103d000-7ff7b103e000 ---p 00000000 00:00 0
|
7ff7b103e000-7ff7b1087000 rw-p 00000000 00:00 0
|
7ff7b1087000-7ff7b1088000 ---p 00000000 00:00 0
|
7ff7b1088000-7ff7b10d1000 rw-p 00000000 00:00 0 [stack:31921]
|
7ff7b10d1000-7ff7b10d2000 ---p 00000000 00:00 0
|
7ff7b10d2000-7ff7b111b000 rw-p 00000000 00:00 0
|
7ff7b111b000-7ff7b111c000 ---p 00000000 00:00 0
|
7ff7b111c000-7ff7b1165000 rw-p 00000000 00:00 0 [stack:31919]
|
7ff7b1166000-7ff7b11af000 rw-p 00000000 00:00 0
|
7ff7b11af000-7ff7b11b0000 ---p 00000000 00:00 0
|
7ff7b11b0000-7ff7b11f9000 rw-p 00000000 00:00 0 [stack:8898]
|
7ff7b11f9000-7ff7b11fa000 ---p 00000000 00:00 0
|
7ff7b11fa000-7ff7b1243000 rw-p 00000000 00:00 0
|
7ff7b1243000-7ff7b1244000 ---p 00000000 00:00 0
|
7ff7b1244000-7ff7b128d000 rw-p 00000000 00:00 0
|
7ff7b128d000-7ff7b128e000 ---p 00000000 00:00 0
|
7ff7b128e000-7ff7b12d7000 rw-p 00000000 00:00 0
|
7ff7b12d7000-7ff7b12d8000 ---p 00000000 00:00 0
|
7ff7b12d8000-7ff7b1321000 rw-p 00000000 00:00 0
|
7ff7b1321000-7ff7b1322000 ---p 00000000 00:00 0
|
7ff7b1322000-7ff7b136b000 rw-p 00000000 00:00 0 [stack:4785]
|
7ff7b136b000-7ff7b136c000 ---p 00000000 00:00 0
|
7ff7b136c000-7ff7b13b5000 rw-p 00000000 00:00 0 [stack:4860]
|
7ff7b13b5000-7ff7b13b6000 ---p 00000000 00:00 0
|
7ff7b13b6000-7ff7b13ff000 rw-p 00000000 00:00 0 [stack:9001]
|
7ff7b13ff000-7ff7b1400000 ---p 00000000 00:00 0
|
7ff7b1400000-7ff7b2000000 rw-p 00000000 00:00 0
|
7ff7b203d000-7ff7b203e000 ---p 00000000 00:00 0
|
7ff7b203e000-7ff7b2087000 rw-p 00000000 00:00 0
|
7ff7b2087000-7ff7b2088000 ---p 00000000 00:00 0
|
7ff7b2088000-7ff7b20d1000 rw-p 00000000 00:00 0
|
7ff7b20d1000-7ff7b20d2000 ---p 00000000 00:00 0
|
7ff7b20d2000-7ff7b211b000 rw-p 00000000 00:00 0
|
7ff7b211b000-7ff7b211c000 ---p 00000000 00:00 0
|
7ff7b211c000-7ff7b2165000 rw-p 00000000 00:00 0 [stack:4857]
|
7ff7b2165000-7ff7b2166000 ---p 00000000 00:00 0
|
7ff7b2166000-7ff7b21af000 rw-p 00000000 00:00 0
|
7ff7b21af000-7ff7b21b0000 ---p 00000000 00:00 0
|
7ff7b21b0000-7ff7b21f9000 rw-p 00000000 00:00 0
|
7ff7b21f9000-7ff7b21fa000 ---p 00000000 00:00 0
|
7ff7b21fa000-7ff7b2243000 rw-p 00000000 00:00 0
|
7ff7b2243000-7ff7b2244000 ---p 00000000 00:00 0
|
7ff7b2244000-7ff7b228d000 rw-p 00000000 00:00 0 [stack:31920]
|
7ff7b228d000-7ff7b228e000 ---p 00000000 00:00 0
|
7ff7b228e000-7ff7b22d7000 rw-p 00000000 00:00 0
|
7ff7b22d7000-7ff7b22d8000 ---p 00000000 00:00 0
|
7ff7b22d8000-7ff7b2321000 rw-p 00000000 00:00 0 [stack:9623]
|
7ff7b2321000-7ff7b2322000 ---p 00000000 00:00 0
|
7ff7b2322000-7ff7b236b000 rw-p 00000000 00:00 0
|
7ff7b236b000-7ff7b236c000 ---p 00000000 00:00 0
|
7ff7b236c000-7ff7b23b5000 rw-p 00000000 00:00 0
|
7ff7b23b5000-7ff7b23b6000 ---p 00000000 00:00 0
|
7ff7b23b6000-7ff7b23ff000 rw-p 00000000 00:00 0
|
7ff7b23ff000-7ff7b2400000 ---p 00000000 00:00 0
|
7ff7b2400000-7ff7b3c00000 rw-p 00000000 00:00 0 [stack:1817]
|
7ff7b3c3c000-7ff7b3c3d000 ---p 00000000 00:00 0
|
7ff7b3c3d000-7ff7b3c86000 rw-p 00000000 00:00 0 [stack:9484]
|
7ff7b3c86000-7ff7b3c87000 ---p 00000000 00:00 0
|
7ff7b3c87000-7ff7b3cd0000 rw-p 00000000 00:00 0
|
7ff7b3cd0000-7ff7b3cd1000 ---p 00000000 00:00 0
|
7ff7b3cd1000-7ff7b3d1a000 rw-p 00000000 00:00 0
|
7ff7b3d1a000-7ff7b3d1b000 ---p 00000000 00:00 0
|
7ff7b3d1b000-7ff7b3d64000 rw-p 00000000 00:00 0 [stack:31923]
|
7ff7b3d64000-7ff7b3d65000 ---p 00000000 00:00 0
|
7ff7b3d65000-7ff7b3dae000 rw-p 00000000 00:00 0
|
7ff7b3dae000-7ff7b3daf000 ---p 00000000 00:00 0
|
7ff7b3daf000-7ff7b3df8000 rw-p 00000000 00:00 0
|
7ff7b3df8000-7ff7b3df9000 ---p 00000000 00:00 0
|
7ff7b3df9000-7ff7b3e42000 rw-p 00000000 00:00 0
|
7ff7b3e42000-7ff7b3e43000 ---p 00000000 00:00 0
|
7ff7b3e43000-7ff7b3e8c000 rw-p 00000000 00:00 0 [stack:31922]
|
7ff7b3e8c000-7ff7b3e8d000 ---p 00000000 00:00 0
|
7ff7b3e8d000-7ff7b3ed6000 rw-p 00000000 00:00 0
|
7ff7b3ed6000-7ff7b3ed7000 ---p 00000000 00:00 0
|
7ff7b3ed7000-7ff7b3f20000 rw-p 00000000 00:00 0 [stack:11026]
|
7ff7b3f20000-7ff7b3f21000 ---p 00000000 00:00 0
|
7ff7b3f21000-7ff7b3f6a000 rw-p 00000000 00:00 0
|
7ff7b3f6a000-7ff7b3f6b000 ---p 00000000 00:00 0
|
7ff7b3f6b000-7ff7b3fb4000 rw-p 00000000 00:00 0 [stack:32163]
|
7ff7b3fb4000-7ff7b3fb5000 ---p 00000000 00:00 0
|
7ff7b3fb5000-7ff7b3ffe000 rw-p 00000000 00:00 0 [stack:9967]
|
7ff7b3ffe000-7ff7b3fff000 ---p 00000000 00:00 0
|
7ff7b3fff000-7ff7b47ff000 rw-p 00000000 00:00 0 [stack:1740]
|
7ff7b47ff000-7ff7b4800000 ---p 00000000 00:00 0
|
7ff7b4800000-7ff7b7800000 rw-p 00000000 00:00 0 [stack:1739]
|
7ff7b783d000-7ff7b783e000 ---p 00000000 00:00 0
|
7ff7b783e000-7ff7b7887000 rw-p 00000000 00:00 0
|
7ff7b7887000-7ff7b7888000 ---p 00000000 00:00 0
|
7ff7b7888000-7ff7b78d1000 rw-p 00000000 00:00 0
|
7ff7b78d1000-7ff7b78d2000 ---p 00000000 00:00 0
|
7ff7b78d2000-7ff7b791b000 rw-p 00000000 00:00 0 [stack:6438]
|
7ff7b791b000-7ff7b791c000 ---p 00000000 00:00 0
|
7ff7b791c000-7ff7b7965000 rw-p 00000000 00:00 0
|
7ff7b7965000-7ff7b7966000 ---p 00000000 00:00 0
|
7ff7b7966000-7ff7b79af000 rw-p 00000000 00:00 0
|
7ff7b79af000-7ff7b79b0000 ---p 00000000 00:00 0
|
7ff7b79b0000-7ff7b79f9000 rw-p 00000000 00:00 0 [stack:1315]
|
7ff7b79f9000-7ff7b79fa000 ---p 00000000 00:00 0
|
7ff7b79fa000-7ff7b7a43000 rw-p 00000000 00:00 0
|
7ff7b7a43000-7ff7b7a44000 ---p 00000000 00:00 0
|
7ff7b7a44000-7ff7b7a8d000 rw-p 00000000 00:00 0 [stack:3878]
|
7ff7b7a8d000-7ff7b7a8e000 ---p 00000000 00:00 0
|
7ff7b7a8e000-7ff7b7ad7000 rw-p 00000000 00:00 0 [stack:7893]
|
7ff7b7ad7000-7ff7b7ad8000 ---p 00000000 00:00 0
|
7ff7b7ad8000-7ff7b7b21000 rw-p 00000000 00:00 0 [stack:10457]
|
7ff7b7b21000-7ff7b7b22000 ---p 00000000 00:00 0
|
7ff7b7b22000-7ff7b7b6b000 rw-p 00000000 00:00 0
|
7ff7b7b6b000-7ff7b7b6c000 ---p 00000000 00:00 0
|
7ff7b7b6c000-7ff7b7bb5000 rw-p 00000000 00:00 0
|
7ff7b7bb5000-7ff7b7bb6000 ---p 00000000 00:00 0
|
7ff7b7bb6000-7ff7b7bff000 rw-p 00000000 00:00 0
|
7ff7b7bff000-7ff7b7c00000 ---p 00000000 00:00 0
|
7ff7b7c00000-7ff7b8800000 rw-p 00000000 00:00 0 [stack:1738]
|
7ff7b882f000-7ff7b8830000 ---p 00000000 00:00 0
|
7ff7b8830000-7ff7b8879000 rw-p 00000000 00:00 0
|
7ff7b8879000-7ff7b887a000 ---p 00000000 00:00 0
|
7ff7b887a000-7ff7b88c3000 rw-p 00000000 00:00 0
|
7ff7b88c3000-7ff7b88c4000 ---p 00000000 00:00 0
|
7ff7b88c4000-7ff7b890d000 rw-p 00000000 00:00 0
|
7ff7b890d000-7ff8f890e000 rw-s 00000000 fe:04 1310722 /var/mysql/galera.cache
|
7ff8f890e000-7ff8f8adb000 r-xp 00000000 fe:02 131794 /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
|
7ff8f8adb000-7ff8f8cda000 ---p 001cd000 fe:02 131794 /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
|
7ff8f8cda000-7ff8f8cf7000 r--p 001cc000 fe:02 131794 /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
|
7ff8f8cf7000-7ff8f8d07000 rw-p 001e9000 fe:02 131794 /usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
|
7ff8f8d07000-7ff8f8d0a000 rw-p 00000000 00:00 0
|
7ff8f8d0a000-7ff8f8d61000 r-xp 00000000 fe:02 131807 /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
|
7ff8f8d61000-7ff8f8f61000 ---p 00057000 fe:02 131807 /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
|
7ff8f8f61000-7ff8f8f64000 r--p 00057000 fe:02 131807 /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
|
7ff8f8f64000-7ff8f8f6a000 rw-p 0005a000 fe:02 131807 /usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
|
7ff8f8f6a000-7ff8f8f6b000 rw-p 00000000 00:00 0
|
7ff8f8f6b000-7ff8f91f3000 r-xp 00000000 fe:02 405868 /usr/lib/galera/libgalera_smm.so
|
7ff8f91f3000-7ff8f93f3000 ---p 00288000 fe:02 405868 /usr/lib/galera/libgalera_smm.so
|
7ff8f93f3000-7ff8f93fa000 r--p 00288000 fe:02 405868 /usr/lib/galera/libgalera_smm.so
|
7ff8f93fa000-7ff8f93fe000 rw-p 0028f000 fe:02 405868 /usr/lib/galera/libgalera_smm.so
|
7ff8f93fe000-7ff8f9800000 rw-p 00000000 00:00 0
|
7ff8f9804000-7ff8f9805000 ---p 00000000 00:00 0
|
7ff8f9805000-7ff8f984e000 rw-p 00000000 00:00 0 [stack:8509]
|
7ff8f984e000-7ff8f984f000 ---p 00000000 00:00 0
|
7ff8f984f000-7ff8f9898000 rw-p 00000000 00:00 0
|
7ff8f9898000-7ff8f9899000 ---p 00000000 00:00 0
|
7ff8f9899000-7ff8f98e2000 rw-p 00000000 00:00 0
|
7ff8f98e2000-7ff8f98e3000 ---p 00000000 00:00 0
|
7ff8f98e3000-7ff8f992c000 rw-p 00000000 00:00 0 [stack:3351]
|
7ff8f992c000-7ff8f992d000 ---p 00000000 00:00 0
|
7ff8f992d000-7ff8f9976000 rw-p 00000000 00:00 0 [stack:31918]
|
7ff8f9976000-7ff8f9977000 ---p 00000000 00:00 0
|
7ff8f9977000-7ff8f99c0000 rw-p 00000000 00:00 0 [stack:6918]
|
7ff8f99c0000-7ff8f99c7000 r-xp 00000000 fe:00 2702 /lib/x86_64-linux-gnu/librt-2.19.so
|
7ff8f99c7000-7ff8f9bc6000 ---p 00007000 fe:00 2702 /lib/x86_64-linux-gnu/librt-2.19.so
|
7ff8f9bc6000-7ff8f9bc7000 r--p 00006000 fe:00 2702 /lib/x86_64-linux-gnu/librt-2.19.so
|
7ff8f9bc7000-7ff8f9bc8000 rw-p 00007000 fe:00 2702 /lib/x86_64-linux-gnu/librt-2.19.so
|
7ff8f9bc8000-7ff8f9bc9000 ---p 00000000 00:00 0
|
7ff8f9bc9000-7ff8fa3c9000 rw-p 00000000 00:00 0 [stack:1737]
|
7ff8fa3c9000-7ff8fa3d4000 r-xp 00000000 fe:00 2695 /lib/x86_64-linux-gnu/libnss_files-2.19.so
|
7ff8fa3d4000-7ff8fa5d3000 ---p 0000b000 fe:00 2695 /lib/x86_64-linux-gnu/libnss_files-2.19.so
|
7ff8fa5d3000-7ff8fa5d4000 r--p 0000a000 fe:00 2695 /lib/x86_64-linux-gnu/libnss_files-2.19.so
|
7ff8fa5d4000-7ff8fa5d5000 rw-p 0000b000 fe:00 2695 /lib/x86_64-linux-gnu/libnss_files-2.19.so
|
7ff8fa5d5000-7ff8fa5df000 r-xp 00000000 fe:00 2697 /lib/x86_64-linux-gnu/libnss_nis-2.19.so
|
7ff8fa5df000-7ff8fa7de000 ---p 0000a000 fe:00 2697 /lib/x86_64-linux-gnu/libnss_nis-2.19.so
|
7ff8fa7de000-7ff8fa7df000 r--p 00009000 fe:00 2697 /lib/x86_64-linux-gnu/libnss_nis-2.19.so
|
7ff8fa7df000-7ff8fa7e0000 rw-p 0000a000 fe:00 2697 /lib/x86_64-linux-gnu/libnss_nis-2.19.so
|
7ff8fa7e0000-7ff8fa7f5000 r-xp 00000000 fe:00 1357 /lib/x86_64-linux-gnu/libnsl-2.19.so
|
7ff8fa7f5000-7ff8fa9f4000 ---p 00015000 fe:00 1357 /lib/x86_64-linux-gnu/libnsl-2.19.so
|
7ff8fa9f4000-7ff8fa9f5000 r--p 00014000 fe:00 1357 /lib/x86_64-linux-gnu/libnsl-2.19.so
|
7ff8fa9f5000-7ff8fa9f6000 rw-p 00015000 fe:00 1357 /lib/x86_64-linux-gnu/libnsl-2.19.so
|
7ff8fa9f6000-7ff8fa9f8000 rw-p 00000000 00:00 0
|
7ff8fa9f8000-7ff8fa9ff000 r-xp 00000000 fe:00 1401 /lib/x86_64-linux-gnu/libnss_compat-2.19.so
|
7ff8fa9ff000-7ff8fabfe000 ---p 00007000 fe:00 1401 /lib/x86_64-linux-gnu/libnss_compat-2.19.so
|
7ff8fabfe000-7ff8fabff000 r--p 00006000 fe:00 1401 /lib/x86_64-linux-gnu/libnss_compat-2.19.so
|
7ff8fabff000-7ff8fac00000 rw-p 00007000 fe:00 1401 /lib/x86_64-linux-gnu/libnss_compat-2.19.so
|
7ff8fac00000-7ff8fb400000 rw-p 00000000 00:00 0
|
7ff8fb404000-7ff8fb405000 ---p 00000000 00:00 0
|
7ff8fb405000-7ff8fb44e000 rw-p 00000000 00:00 0
|
7ff8fb44e000-7ff8fb44f000 ---p 00000000 00:00 0
|
7ff8fb44f000-7ff8fb498000 rw-p 00000000 00:00 0 [stack:9980]
|
7ff8fb498000-7ff8fb499000 ---p 00000000 00:00 0
|
7ff8fb499000-7ff8fb4e2000 rw-p 00000000 00:00 0 [stack:8999]
|
7ff8fb4e2000-7ff8fb4e3000 ---p 00000000 00:00 0
|
7ff8fb4e3000-7ff8fb52c000 rw-p 00000000 00:00 0 [stack:31917]
|
7ff8fb52c000-7ff8fb52d000 ---p 00000000 00:00 0
|
7ff8fb52d000-7ff8fb576000 rw-p 00000000 00:00 0
|
7ff8fb576000-7ff8fb577000 ---p 00000000 00:00 0
|
7ff8fb577000-7ff8fb5c0000 rw-p 00000000 00:00 0
|
7ff8fb5c0000-7ff8fb762000 r-xp 00000000 fe:00 1063 /lib/x86_64-linux-gnu/libc-2.19.so
|
7ff8fb762000-7ff8fb961000 ---p 001a2000 fe:00 1063 /lib/x86_64-linux-gnu/libc-2.19.so
|
7ff8fb961000-7ff8fb965000 r--p 001a1000 fe:00 1063 /lib/x86_64-linux-gnu/libc-2.19.so
|
7ff8fb965000-7ff8fb967000 rw-p 001a5000 fe:00 1063 /lib/x86_64-linux-gnu/libc-2.19.so
|
7ff8fb967000-7ff8fb96b000 rw-p 00000000 00:00 0
|
7ff8fb96b000-7ff8fb981000 r-xp 00000000 fe:00 24 /lib/x86_64-linux-gnu/libgcc_s.so.1
|
7ff8fb981000-7ff8fbb80000 ---p 00016000 fe:00 24 /lib/x86_64-linux-gnu/libgcc_s.so.1
|
7ff8fbb80000-7ff8fbb81000 rw-p 00015000 fe:00 24 /lib/x86_64-linux-gnu/libgcc_s.so.1
|
7ff8fbb81000-7ff8fbc81000 r-xp 00000000 fe:00 1074 /lib/x86_64-linux-gnu/libm-2.19.so
|
7ff8fbc81000-7ff8fbe80000 ---p 00100000 fe:00 1074 /lib/x86_64-linux-gnu/libm-2.19.so
|
7ff8fbe80000-7ff8fbe81000 r--p 000ff000 fe:00 1074 /lib/x86_64-linux-gnu/libm-2.19.so
|
7ff8fbe81000-7ff8fbe82000 rw-p 00100000 fe:00 1074 /lib/x86_64-linux-gnu/libm-2.19.so
|
7ff8fbe82000-7ff8fbf6e000 r-xp 00000000 fe:02 131610 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.20
|
7ff8fbf6e000-7ff8fc16e000 ---p 000ec000 fe:02 131610 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.20
|
7ff8fc16e000-7ff8fc176000 r--p 000ec000 fe:02 131610 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.20
|
7ff8fc176000-7ff8fc178000 rw-p 000f4000 fe:02 131610 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.20
|
7ff8fc178000-7ff8fc18d000 rw-p 00000000 00:00 0
|
7ff8fc18d000-7ff8fc190000 r-xp 00000000 fe:00 1068 /lib/x86_64-linux-gnu/libdl-2.19.so
|
7ff8fc190000-7ff8fc38f000 ---p 00003000 fe:00 1068 /lib/x86_64-linux-gnu/libdl-2.19.so
|
7ff8fc38f000-7ff8fc390000 r--p 00002000 fe:00 1068 /lib/x86_64-linux-gnu/libdl-2.19.so
|
7ff8fc390000-7ff8fc391000 rw-p 00003000 fe:00 1068 /lib/x86_64-linux-gnu/libdl-2.19.so
|
7ff8fc391000-7ff8fc399000 r-xp 00000000 fe:00 1066 /lib/x86_64-linux-gnu/libcrypt-2.19.so
|
7ff8fc399000-7ff8fc598000 ---p 00008000 fe:00 1066 /lib/x86_64-linux-gnu/libcrypt-2.19.so
|
7ff8fc598000-7ff8fc599000 r--p 00007000 fe:00 1066 /lib/x86_64-linux-gnu/libcrypt-2.19.so
|
7ff8fc599000-7ff8fc59a000 rw-p 00008000 fe:00 1066 /lib/x86_64-linux-gnu/libcrypt-2.19.so
|
7ff8fc59a000-7ff8fc5c8000 rw-p 00000000 00:00 0
|
7ff8fc5c8000-7ff8fc5fc000 r-xp 00000000 fe:02 135899 /usr/lib/x86_64-linux-gnu/libjemalloc.so.1
|
7ff8fc5fc000-7ff8fc7fc000 ---p 00034000 fe:02 135899 /usr/lib/x86_64-linux-gnu/libjemalloc.so.1
|
7ff8fc7fc000-7ff8fc7fe000 r--p 00034000 fe:02 135899 /usr/lib/x86_64-linux-gnu/libjemalloc.so.1
|
7ff8fc7fe000-7ff8fc7ff000 rw-p 00036000 fe:02 135899 /usr/lib/x86_64-linux-gnu/libjemalloc.so.1
|
7ff8fc7ff000-7ff8fc800000 rw-p 00000000 00:00 0
|
7ff8fc800000-7ff8fc81a000 r-xp 00000000 fe:00 329 /lib/x86_64-linux-gnu/libz.so.1.2.8
|
7ff8fc81a000-7ff8fca19000 ---p 0001a000 fe:00 329 /lib/x86_64-linux-gnu/libz.so.1.2.8
|
7ff8fca19000-7ff8fca1a000 r--p 00019000 fe:00 329 /lib/x86_64-linux-gnu/libz.so.1.2.8
|
7ff8fca1a000-7ff8fca1b000 rw-p 0001a000 fe:00 329 /lib/x86_64-linux-gnu/libz.so.1.2.8
|
7ff8fca1b000-7ff8fca1c000 r-xp 00000000 fe:00 2720 /lib/x86_64-linux-gnu/libaio.so.1.0.1
|
7ff8fca1c000-7ff8fcc1b000 ---p 00001000 fe:00 2720 /lib/x86_64-linux-gnu/libaio.so.1.0.1
|
7ff8fcc1b000-7ff8fcc1c000 r--p 00000000 fe:00 2720 /lib/x86_64-linux-gnu/libaio.so.1.0.1
|
7ff8fcc1c000-7ff8fcc1d000 rw-p 00001000 fe:00 2720 /lib/x86_64-linux-gnu/libaio.so.1.0.1
|
7ff8fcc1d000-7ff8fcc35000 r-xp 00000000 fe:00 1042 /lib/x86_64-linux-gnu/libpthread-2.19.so
|
7ff8fcc35000-7ff8fce34000 ---p 00018000 fe:00 1042 /lib/x86_64-linux-gnu/libpthread-2.19.so
|
7ff8fce34000-7ff8fce35000 r--p 00017000 fe:00 1042 /lib/x86_64-linux-gnu/libpthread-2.19.so
|
7ff8fce35000-7ff8fce36000 rw-p 00018000 fe:00 1042 /lib/x86_64-linux-gnu/libpthread-2.19.so
|
7ff8fce36000-7ff8fce3a000 rw-p 00000000 00:00 0
|
7ff8fce3a000-7ff8fce5a000 r-xp 00000000 fe:00 1050 /lib/x86_64-linux-gnu/ld-2.19.so
|
7ff8fce9e000-7ff8fce9f000 ---p 00000000 00:00 0
|
7ff8fce9f000-7ff8fcee8000 rw-p 00000000 00:00 0 [stack:2850]
|
7ff8fcee8000-7ff8fcee9000 ---p 00000000 00:00 0
|
7ff8fcee9000-7ff8fcf32000 rw-p 00000000 00:00 0 [stack:9974]
|
7ff8fcf32000-7ff8fcf33000 ---p 00000000 00:00 0
|
7ff8fcf33000-7ff8fcf7c000 rw-p 00000000 00:00 0 [stack:5340]
|
7ff8fcf7c000-7ff8fcf7d000 ---p 00000000 00:00 0
|
7ff8fcf7d000-7ff8fcfc6000 rw-p 00000000 00:00 0
|
7ff8fcfc6000-7ff8fcfc7000 ---p 00000000 00:00 0
|
7ff8fcfc7000-7ff8fd010000 rw-p 00000000 00:00 0 [stack:1851]
|
7ff8fd010000-7ff8fd011000 ---p 00000000 00:00 0
|
7ff8fd011000-7ff8fd05a000 rw-p 00000000 00:00 0 [stack:29028]
|
7ff8fd05a000-7ff8fd05b000 r--p 00020000 fe:00 1050 /lib/x86_64-linux-gnu/ld-2.19.so
|
7ff8fd05b000-7ff8fd05c000 rw-p 00021000 fe:00 1050 /lib/x86_64-linux-gnu/ld-2.19.so
|
7ff8fd05c000-7ff8fd05d000 rw-p 00000000 00:00 0
|
7ff8fd05d000-7ff8fdfc7000 r-xp 00000000 fe:02 405818 /usr/local/mariadb-10.1.14/bin/mysqld
|
7ff8fe00b000-7ff8fe00c000 rw-p 00000000 00:00 0
|
7ff8fe00c000-7ff8fe00d000 ---p 00000000 00:00 0
|
7ff8fe00d000-7ff8fe056000 rw-p 00000000 00:00 0 [stack:1846]
|
7ff8fe056000-7ff8fe057000 ---p 00000000 00:00 0
|
7ff8fe057000-7ff8fe0a0000 rw-p 00000000 00:00 0 [stack:1844]
|
7ff8fe0a0000-7ff8fe0a1000 ---p 00000000 00:00 0
|
7ff8fe0a1000-7ff8fe0ec000 rw-p 00000000 00:00 0 [stack:1843]
|
7ff8fe0ec000-7ff8fe0ef000 rw-s 00000000 00:0a 15390 /[aio] (deleted)
|
7ff8fe0ef000-7ff8fe0f4000 rw-s 00000000 00:0a 15389 /[aio] (deleted)
|
7ff8fe0f4000-7ff8fe0f9000 rw-s 00000000 00:0a 15388 /[aio] (deleted)
|
7ff8fe0f9000-7ff8fe0fe000 rw-s 00000000 00:0a 15387 /[aio] (deleted)
|
7ff8fe0fe000-7ff8fe103000 rw-s 00000000 00:0a 15386 /[aio] (deleted)
|
7ff8fe103000-7ff8fe108000 rw-s 00000000 00:0a 15385 /[aio] (deleted)
|
7ff8fe108000-7ff8fe10d000 rw-s 00000000 00:0a 15384 /[aio] (deleted)
|
7ff8fe10d000-7ff8fe112000 rw-s 00000000 00:0a 15383 /[aio] (deleted)
|
7ff8fe112000-7ff8fe117000 rw-s 00000000 00:0a 15382 /[aio] (deleted)
|
7ff8fe117000-7ff8fe11c000 rw-s 00000000 00:0a 15381 /[aio] (deleted)
|
7ff8fe11c000-7ff8fe121000 rw-s 00000000 00:0a 15380 /[aio] (deleted)
|
7ff8fe121000-7ff8fe122000 ---p 00000000 00:00 0
|
7ff8fe122000-7ff8fe16b000 rw-p 00000000 00:00 0 [stack:1742]
|
7ff8fe16b000-7ff8fe16c000 ---p 00000000 00:00 0
|
7ff8fe16c000-7ff8fe1bd000 rw-p 00000000 00:00 0 [stack:1741]
|
7ff8fe1bd000-7ff8fe1c0000 rw-s 00000000 00:0a 15379 /[aio] (deleted)
|
7ff8fe1c0000-7ff8fe1c7000 rw-p 00000000 00:00 0
|
7ff8fe1c7000-7ff8fe27f000 r--p 00f6a000 fe:02 405818 /usr/local/mariadb-10.1.14/bin/mysqld
|
7ff8fe27f000-7ff8fe325000 rw-p 01022000 fe:02 405818 /usr/local/mariadb-10.1.14/bin/mysqld
|
7ff8fe325000-7ff8feb9c000 rw-p 00000000 00:00 0
|
7ffc8330b000-7ffc8332c000 rw-p 00000000 00:00 0 [stack]
|
7ffc833ce000-7ffc833d0000 r-xp 00000000 00:00 0 [vdso]
|
7ffc833d0000-7ffc833d2000 r--p 00000000 00:00 0 [vvar]
|
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall]
|
Fatal signal 6 while backtracing
|
160822 20:53:39 mysqld_safe Number of processes running now: 0
|
160822 20:53:39 mysqld_safe WSREP: not restarting wsrep node automatically
|
160822 20:53:39 mysqld_safe mysqld from pid file /usr/local/mysql/data/svrmysql2.pid ended
|
|
my.cnf |
[mysqld]
|
bind-address=0.0.0.0
|
port = 3306
|
socket = /tmp/mysql.sock
|
skip-external-locking
|
|
|
key_buffer_size = 10M
|
#max_allowed_packet = 1M
|
table_open_cache = 7092
|
#sort_buffer_size = 2M
|
#read_buffer_size = 2M
|
#read_rnd_buffer_size = 8M
|
#myisam_sort_buffer_size = 2M
|
#thread_cache_size = 16
|
|
|
query_cache_size = 0
|
query_cache_limit = 2M
|
|
|
#tmp_table_size= 128M
|
#max_heap_table_size= 128M
|
|
|
# Try number of CPU's*2 for thread_concurrency
|
thread_concurrency = 8
|
|
|
open_files_limit = 102400
|
|
|
max_connections = 300
|
|
|
wait_timeout=300
|
|
|
log_error=/var/log/mysql/errors.log
|
expire_logs_days=7
|
skip-name-resolve
|
# Replication Master Server (default)
|
# binary logging is required for replication
|
log-bin=/var/mysql/mysql-bin
|
|
|
|
|
binlog_format=ROW
|
default-storage-engine=innodb
|
innodb_autoinc_lock_mode=2
|
wsrep_on=ON
|
wsrep_cluster_name='mariadb_cluster'
|
wsrep_node_name=node2
|
wsrep_node_address=10.253.253.xx
|
wsrep_provider = /usr/lib/galera/libgalera_smm.so
|
#wsrep_provider_options=""
|
wsrep_retry_autocommit = 0
|
wsrep_sst_method = rsync
|
wsrep_slave_threads=1
|
wsrep_certify_nonPK=1
|
wsrep_max_ws_rows=131072
|
wsrep_max_ws_size=1073741824
|
wsrep_debug=0
|
wsrep_log_conflicts = 1
|
wsrep_provider_options="gcache.size = 5G; gcache.name = /var/mysql/galera.cache"
|
wsrep_cluster_address=gcomm://our ip ...
|
#wsrep_cluster_address=gcomm://
|
performance_schema=off
|
|
|
# required unique id between 1 and 2^32 - 1
|
# defaults to 1 if master-host is not set
|
# but will not function as a master if omitted
|
server-id = 2
|
innodb_data_home_dir = /usr/local/mysql/data
|
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
|
innodb_log_group_home_dir = /usr/local/mysql/data
|
# You can set .._buffer_pool_size up to 50 - 80 %
|
# of RAM but beware of setting memory usage too high
|
innodb_buffer_pool_size = 9500M
|
#innodb_additional_mem_pool_size = 20M
|
# Set .._log_file_size to 25 % of buffer pool size
|
innodb_log_file_size = 100M
|
innodb_log_buffer_size = 8M
|
innodb_flush_log_at_trx_commit = 1
|
innodb_lock_wait_timeout = 50
|
|
|
|
|
|
|
slow-query-log-file = /var/log/mysql/mysql-slow.log
|
long_query_time = 1
|
|
|
|
|
[mysqldump]
|
quick
|
max_allowed_packet = 16M
|
|
|
[mysql]
|
no-auto-rehash
|
# Remove the next comment character if you are not familiar with SQL
|
#safe-updates
|
|
|
#[myisamchk]
|
#key_buffer_size = 64M
|
#sort_buffer_size = 2M
|
Attachments
Issue Links
- relates to
-
-
- Closed
-