Guest User

Untitled

a guest
Dec 18th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.38 KB | None | 0 0
  1. 2017-12-05 9:27:13 140599126464256 [Note] WSREP: (8f3cb7d9, 'tcp://0.0.0.0:4567') turning message relay requesting off
  2. 171205 11:38:01 [ERROR] mysqld got signal 11 ;
  3. This could be because you hit a bug. It is also possible that this binary
  4. or one of the libraries it was linked against is corrupt, improperly built,
  5. or misconfigured. This error can also be caused by malfunctioning hardware.
  6.  
  7. To report this bug, see https://mariadb.com/kb/en/reporting-bugs
  8.  
  9. We will try our best to scrape up some info that will hopefully help
  10. diagnose the problem, but since we have already crashed,
  11. something is definitely wrong and this may fail.
  12.  
  13. Server version: 10.2.10-MariaDB-log
  14. key_buffer_size=16777216
  15. read_buffer_size=131072
  16. max_used_connections=15
  17. max_threads=102
  18. thread_count=23
  19. It is possible that mysqld could use up to
  20. key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 240475 K bytes of memory
  21. Hope that's ok; if not, decrease some variables in the equation.
  22.  
  23. Thread pointer: 0x7fddf40009a8
  24. Attempting backtrace. You can use the following information to find out
  25. where mysqld died. If you see no messages after this, something went
  26. terribly wrong...
  27.  
  28. # this is read by the standalone daemon and embedded servers
  29. [server]
  30.  
  31. # this is only for the mysqld standalone daemon
  32. [mysqld]
  33. bind-address = 0.0.0.0
  34. transaction-isolation = READ-COMMITTED
  35. max_allowed_packet = 16M
  36. myisam_recover_options = BACKUP
  37. max_connections = 100
  38. sql_mode =
  39.  
  40. # Logs
  41. log_error = /var/lib/mysql/logs/mysql_error.log
  42. slow_query_log = 1
  43. slow_query_log_file = /var/lib/mysql/logs/mysql_slow.log
  44. long_query_time = 2
  45.  
  46.  
  47. # Cache parameters
  48. query_cache_size = 64M
  49. query_cache_limit = 2M
  50. table_open_cache = 4096
  51. thread_cache_size = 200
  52. key_buffer_size = 16M
  53. thread_stack = 128K
  54. join_buffer_size = 2M
  55. sort_buffer_size = 2M
  56.  
  57. # Parameters for temporary tables
  58. tmpdir = /tmp
  59. max_heap_table_size = 512M
  60. tmp_table_size = 512M
  61. query_cache_type=1
  62.  
  63. # InnoDB parameters
  64. innodb_file_per_table
  65. innodb_buffer_pool_size = 4G
  66. innodb_flush_log_at_trx_commit = 2
  67. innodb_log_file_size = 128M
  68. innodb_flush_method = O_DIRECT
  69.  
  70. # Database charset parameters
  71. character-set-server = utf8
  72. collation-server = utf8_unicode_ci
  73. init-connect = "SET NAMES utf8 COLLATE utf8_unicode_ci"
  74. skip-character-set-client-handshake
  75. #skip-name-resolve
  76.  
  77. #
  78. # * Galera-related settings
  79. #
  80. [galera]
  81. # Mandatory settings
  82. wsrep_on = ON
  83. wsrep_provider = /usr/lib64/galera/libgalera_smm.so
  84. wsrep_cluster_address = "gcomm://192.168.59.78,172.16.140.29"
  85. wsrep_cluster_name = "site-appdb"
  86. wsrep_node_address = "192.168.59.78"
  87. wsrep_node_name = "site-appdb01"
  88. wsrep_sst_method = rsync
  89. wsrep_sst_auth=repl_user:+vQvI9Fe8Nr6
  90. binlog_format = row
  91. default_storage_engine = InnoDB
  92. innodb_autoinc_lock_mode = 2
  93. #innodb_locks_unsafe_for_binlog = 1
  94. #
  95. # Allow server to accept connections on all interfaces.
  96. #
  97. #bind-address=0.0.0.0
  98. #
  99. # Optional setting
  100. wsrep_slave_threads=1
  101. innodb_file_per_table
  102. innodb_buffer_pool_size = 4G
  103. innodb_flush_log_at_trx_commit = 2
  104. innodb_log_file_size = 128M
  105. innodb_flush_method = O_DIRECT
  106.  
  107. # this is only for embedded server
  108. [embedded]
  109.  
  110. # This group is only read by MariaDB servers, not by MySQL.
  111. # If you use the same .cnf file for MySQL and MariaDB,
  112. # you can put MariaDB-only options here
  113. [mariadb]
  114.  
  115. # This group is only read by MariaDB-10.1 servers.
  116. # If you use the same .cnf file for MariaDB of different versions,
  117. # use this group for options that older servers don't understand
  118. [mariadb-10.1]
Add Comment
Please, Sign In to add comment