Comment 2 for bug 1282707

Revision history for this message
i.Tuzhilkin (ivan-tuzhilkin) wrote : Re: Percona XtraDB Cluster 5.6 crash on ALTER TABLE

> 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
###############################