Querries freeze forever in different statuses
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Galera |
New
|
Undecided
|
Unassigned |
Bug Description
I have cluster 2 physical nodes (2x Intel Xeon E5-2670 2.6Ghz , 192Gb, RAID1 SSD, ОС Debian 8, mariadb-
PROCESSLIST shows some queries (SELECT\
This occures only if I write to 1st node (and read from both). If I write to the 2nd node (and read from both) - everything is OK. Both nodes are identical (hardware and software), I've complitely reinstaled OS on both of them, changed LAN cables and connected it to another CISCO - no effect. Here is my config file:
[client]
port = 3306
socket = /var/run/
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
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-
performance_
# MyISAM #
key-buffer-size = 32M
myisam-recover = FORCE,BACKUP
# SAFETY #
max-allowed-packet = 16M
max-connect-errors = 1000000
skip-name-resolve
# DATA STORAGE #
datadir = /var/lib/mysql/
# BINARY LOGGING #
log-bin = /var/lib/
expire-logs-days = 14
#sync-binlog = 0
# CACHES AND LIMITS #
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
max-connections = 500
thread-cache-size = 50
open-files-limit = 65535
table-definitio
table-open-cache = 4096
# INNODB #
innodb-flush-method = O_DIRECT
innodb-
innodb-
innodb-
innodb-
innodb-
innodb_
# LOGGING #
log-error = /var/lib/
log-queries-
slow-query-log = 1
slow-query-log-file = /var/lib/
# GALERA part
binlog_format=ROW
default-
innodb_
bind-address=
# Galera Provider Configuration
wsrep_on=ON
wsrep_provider=
# Galera Cluster Configuration
wsrep_cluster_
wsrep_cluster_
# Galera Synchronization Configuration
wsrep_sst_
wsrep_sst_
# Galera Node Configuration
wsrep_node_
wsrep_node_
# Tuning
wsrep_retry_
wsrep_slave_threads = 64
wsrep_provider_
!includedir /etc/mysql/conf.d/