Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1513

LP #1249704: Consistency problem on 5.5.34-23.7.6

    Details

      Description

      **Reported in Launchpad by Francesco last update 02-02-2014 04:17:19

      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-XtraDB-Cluster-shared-5.5.34-23.7.6.565.rhel6.i686
      Percona-XtraDB-Cluster-galera-2.8-1.162.rhel6.i686
      percona-release-0.0-1.i386
      Percona-XtraDB-Cluster-client-5.5.34-23.7.6.565.rhel6.i686
      Percona-Server-shared-51-5.1.72-rel14.10.597.rhel6.i686
      percona-xtrabackup-2.1.5-680.rhel6.i686
      Percona-XtraDB-Cluster-server-5.5.34-23.7.6.565.rhel6.i686

      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]

      1. CLIENT #
        port = 3306
        socket = /data/mysql/mysql.sock
        default-character-set=utf8

      [client]
      socket = /data/mysql/mysql.sock
      default-character-set=utf8

      [mysqld]

      1. GENERAL #
        user = mysql
        default_storage_engine = InnoDB
        socket = /data/mysql/mysql.sock
        pid_file = /data/mysql/mysql.pid
      1. MyISAM #
        key_buffer_size = 32M
        myisam_recover = FORCE,BACKUP
      1. SAFETY #
        max_allowed_packet = 16M
        max_connect_errors = 1000000
        skip_name_resolve
        sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
        sysdate_is_now = 1
        innodb = FORCE
        innodb_strict_mode = 1
      1. DATA STORAGE #
        datadir = /data/mysql/
      1. BINARY LOGGING #
        log_bin = /data/mysql/mysql-bin
        expire_logs_days = 14
        sync_binlog = 1
      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_definition_cache = 1024
        table_open_cache = 100
      1. INNODB #
        innodb_flush_method = O_DIRECT
        innodb_log_files_in_group = 2
        innodb_log_file_size = 64M
        innodb_flush_log_at_trx_commit = 1
        innodb_file_per_table = 1
        innodb_buffer_pool_size = 512M
      1. LOGGING #
        log_error = /data/mysql/mysql-error.log
        log_queries_not_using_indexes = 1
        slow_query_log = 1
        slow_query_log_file = /data/mysql/mysql-slow.log
      1. UTF8 #
        collation-server = utf8_unicode_ci
        init-connect='SET NAMES utf8'
        character-set-server = utf8
            1. Cluster config ####
      1. Path to Galera library
        wsrep_provider = /usr/lib/libgalera_smm.so
      1. Cluster connection URL contains the IPs of all the nodes
        wsrep_cluster_address = gcomm://192.168.0.101,192.168.0.102,192.168.0.103
      1. In order for Galera to work correctly binlog format should be ROW
        binlog_format = ROW
      1. This is a recommended tuning variable for performance
        innodb_locks_unsafe_for_binlog = 1
      1. This changes how InnoDB auto-increment locks are managed and is a requirement for Galera
        innodb_autoinc_lock_mode = 2
      1. IP address of this node
        wsrep_node_address = 192.168.0.101
      1. SST method
        wsrep_sst_method = xtrabackup-v2
      1. Cluster name
        wsrep_cluster_name = data_cluster
      1. Authentication for SST method
        wsrep_sst_auth = "sstuser:password"

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: