> Please provide cnf as well as error log (and general log if any).
Sorry general log is disabled, error log I already attached.
> a) Can you provide structure of the table before the crash?
No I can't provide it now, maybe tommorow. Our programmer is offline now.
Maybe i'll try upgrade server to newer build.
my.cnf: ############################### [client] port = 3306 socket = /var/run/mysqld/mysqld.sock
[mysqld_safe] wsrep_cluster_address=gcomm:// socket = /var/run/mysqld/mysqld.sock nice = 0
[mysqld] query_cache_size=0 binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1 innodb_doublewrite=1 wsrep_provider=/usr/lib/libgalera_smm.so wsrep_provider_options="gcache.size=4G; gcache.page_size=2G; socket.checksum =1" wsrep_cluster_address=gcomm://1.2.3.6,1.2.3.5 wsrep_cluster_name=""My_Cluster"" wsrep_node_address="1.2.3.4" wsrep_node_name="db1" wsrep_sst_method=xtrabackup wsrep_sst_auth="root:mypasswd" wsrep_node_incoming_address=1.2.3.4 wsrep_sst_receive_address=1.2.3.4 wsrep_slave_threads=2
user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc_messages_dir = /usr/share/mysql lc_messages = en_US skip-external-locking skip-name-resolve
character_set_server = utf8 collation_server = utf8_general_ci
bind-address = 0.0.0.0
max_connections = 100 connect_timeout = 65 wait_timeout = 65 max_allowed_packet = 16M thread_cache_size = 100 sort_buffer_size = 1M bulk_insert_buffer_size = 1M tmp_table_size = 256M max_heap_table_size = 256M #net_buffer_length = 8K
myisam_recover = BACKUP key_buffer_size = 16M myisam_sort_buffer_size = 1M concurrent_insert = 2
table_open_cache = 20000 table_definition_cache = 20000
read_buffer_size = 512K read_rnd_buffer_size = 512K
join_buffer_size = 4M
#general_log_file = /var/log/mysql/mysql.log #general_log = 1 #log_warnings = 2 log_error = /var/log/mysql/error.log
slow_query_log = 1 slow_query_log_file = /var/log/mysql/mariadb-slow.log long_query_time = 10 log_slow_rate_limit = 1000 #log_slow_verbosity = query_plan
log-queries-not-using-indexes log_slow_admin_statements
log_bin = /var/log/mysql/mysql-bin log_bin_index = /var/log/mysql/mysql-bin.index
sync_binlog = 1 expire_logs_days = 10 max_binlog_size = 32M
innodb_data_home_dir = /var/lib/mysql innodb_log_group_home_dir = /var/lib/mysql innodb_buffer_pool_size = 8096M innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 64M innodb_log_file_size = 256M innodb_file_per_table = 1 innodb_open_files = 20000 innodb_io_capacity = 200 innodb_flush_method = O_DIRECT innodb_thread_concurrency = 2 innodb_change_buffering = all innodb_force_recovery = 0
[mysqldump] quick quote-names max_allowed_packet = 200M
[isamchk] key_buffer = 8M ###############################
> Please provide cnf as well as error log (and general log if any).
Sorry general log is disabled, error log I already attached.
> a) Can you provide structure of the table before the crash?
No I can't provide it now, maybe tommorow. Our programmer is offline now.
Maybe i'll try upgrade server to newer build.
my.cnf: ####### ####### ####### ### mysqld/ mysqld. sock
#######
[client]
port = 3306
socket = /var/run/
[mysqld_safe] address= gcomm:/ / mysqld/ mysqld. sock
wsrep_cluster_
socket = /var/run/
nice = 0
[mysqld] storage_ engine= InnoDB autoinc_ lock_mode= 2 locks_unsafe_ for_binlog= 1 doublewrite= 1 /usr/lib/ libgalera_ smm.so options= "gcache. size=4G; gcache. page_size= 2G; socket.checksum =1" address= gcomm:/ /1.2.3. 6,1.2.3. 5 name="" My_Cluster" " address= "1.2.3. 4" name="db1" method= xtrabackup auth="root: mypasswd" incoming_ address= 1.2.3.4 receive_ address= 1.2.3.4 threads= 2
query_cache_size=0
binlog_format=ROW
default_
innodb_
innodb_
innodb_
wsrep_provider=
wsrep_provider_
wsrep_cluster_
wsrep_cluster_
wsrep_node_
wsrep_node_
wsrep_sst_
wsrep_sst_
wsrep_node_
wsrep_sst_
wsrep_slave_
user = mysql mysqld/ mysqld. pid mysqld/ mysqld. sock locking
pid-file = /var/run/
socket = /var/run/
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc_messages_dir = /usr/share/mysql
lc_messages = en_US
skip-external-
skip-name-resolve
character_ set_server = utf8
collation_server = utf8_general_ci
bind-address = 0.0.0.0
max_connections = 100 buffer_ size = 1M
connect_timeout = 65
wait_timeout = 65
max_allowed_packet = 16M
thread_cache_size = 100
sort_buffer_size = 1M
bulk_insert_
tmp_table_size = 256M
max_heap_table_size = 256M
#net_buffer_length = 8K
myisam_recover = BACKUP sort_buffer_ size = 1M
key_buffer_size = 16M
myisam_
concurrent_insert = 2
table_open_cache = 20000 n_cache = 20000
table_definitio
read_buffer_size = 512K buffer_ size = 512K
read_rnd_
join_buffer_size = 4M
#general_log_file = /var/log/ mysql/mysql. log mysql/error. log
#general_log = 1
#log_warnings = 2
log_error = /var/log/
slow_query_log = 1 mysql/mariadb- slow.log
slow_query_log_file = /var/log/
long_query_time = 10
log_slow_rate_limit = 1000
#log_slow_verbosity = query_plan
log-queries- not-using- indexes admin_statement s
log_slow_
log_bin = /var/log/ mysql/mysql- bin mysql/mysql- bin.index
log_bin_index = /var/log/
sync_binlog = 1
expire_logs_days = 10
max_binlog_size = 32M
innodb_ data_home_ dir = /var/lib/mysql log_group_ home_dir = /var/lib/mysql buffer_ pool_size = 8096M flush_log_ at_trx_ commit = 2 log_buffer_ size = 64M log_file_ size = 256M file_per_ table = 1 thread_ concurrency = 2 change_ buffering = all force_recovery = 0
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_open_files = 20000
innodb_io_capacity = 200
innodb_flush_method = O_DIRECT
innodb_
innodb_
innodb_
[mysqldump]
quick
quote-names
max_allowed_packet = 200M
[isamchk] ####### ####### ####### ###
key_buffer = 8M
#######