Consistency problem on 5.5.34-23.7.6
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
Expired
|
Undecided
|
Unassigned |
Bug Description
I have written some simple code (java code attached) that breaks Consistency on my Percona XtraDB cluster.
If you run the code sometimes you don't get some rows (so the line "Did not get it for:" is printed out).
My configuration:
3 nodes
[root@cluster1 ~]# rpm -qa | grep -i percona
Percona-
Percona-
percona-
Percona-
Percona-
percona-
Percona-
table used:
CREATE TABLE test.`test` (
`id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[root@cluster1 ~]# uname -a
Linux cluster1 2.6.32-358.el6.i686 #1 SMP Thu Feb 21 21:50:49 UTC 2013 i686 i686 i386 GNU/Linux
program output:
Info: 1
Did not get it for:36
Did not get it for:37
Info: 101
Did not get it for:102
Did not get it for:109
Did not get it for:121
Info: 201
Did not get it for:231
Did not get it for:246
Did not get it for:293
Info: 301
Did not get it for:306
Did not get it for:308
Did not get it for:388
Did not get it for:395
Info: 401
Info: 501
Did not get it for:509
Did not get it for:574
Info: 601
Did not get it for:602
Did not get it for:659
Did not get it for:670
Did not get it for:674
Info: 701
Did not get it for:792
Did not get it for:800
Info: 801
Did not get it for:817
Did not get it for:821
Did not get it for:823
Did not get it for:844
Did not get it for:846
Did not get it for:848
Did not get it for:892
Did not get it for:895
Did not get it for:900
Info: 901
Did not get it for:936
Did not get it for:942
Did not get it for:969
Did not get it for:997
my.cnf:
[mysql]
# CLIENT #
port = 3306
socket = /data/mysql/
default-
[client]
socket = /data/mysql/
default-
[mysqld]
# GENERAL #
user = mysql
default_
socket = /data/mysql/
pid_file = /data/mysql/
# MyISAM #
key_buffer_size = 32M
myisam_recover = FORCE,BACKUP
# SAFETY #
max_allowed_packet = 16M
max_connect_errors = 1000000
skip_name_resolve
sql_mode = STRICT_
sysdate_is_now = 1
innodb = FORCE
innodb_strict_mode = 1
# DATA STORAGE #
datadir = /data/mysql/
# BINARY LOGGING #
log_bin = /data/mysql/
expire_logs_days = 14
sync_binlog = 1
# 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 = 100
# INNODB #
innodb_flush_method = O_DIRECT
innodb_
innodb_
innodb_
innodb_
innodb_
# LOGGING #
log_error = /data/mysql/
log_queries_
slow_query_log = 1
slow_query_log_file = /data/mysql/
# UTF8 #
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-
#### Cluster config ####
# Path to Galera library
wsrep_provider = /usr/lib/
# Cluster connection URL contains the IPs of all the nodes
wsrep_cluster_
# In order for Galera to work correctly binlog format should be ROW
binlog_format = ROW
# This is a recommended tuning variable for performance
innodb_
# This changes how InnoDB auto-increment locks are managed and is a requirement for Galera
innodb_
# IP address of this node
wsrep_node_address = 192.168.0.101
# SST method
wsrep_sst_method = xtrabackup-v2
# Cluster name
wsrep_cluster_name = data_cluster
# Authentication for SST method
wsrep_sst_auth = "sstuser:password"
Changed in percona-xtradb-cluster: | |
status: | New → Incomplete |
java code to reproduce