Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10656

Got Signal 11 on one node randomly every week since 3 months

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.1.14
    • Fix Version/s: 10.1.30
    • Component/s: Galera
    • Labels:
    • Environment:
      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

            Activity

              People

              Assignee:
              sachin.setiya.007 Sachin Setiya
              Reporter:
              slevieux Levieux stéphane
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: