GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

WSREP: wsrep::init() failed: 6, must shutdown

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • WSREP: wsrep::init() failed: 6, must shutdown

    cat my.4000.cnf
    [mysqld_safe]
    wsrep_urls= gcomm://192.168.2.21:4030,gcomm://192.168.2.21:5030,gcomm:// 192.168.2.21:6030,gcomm://

    [mysqld]
    port = 4000
    socket=/tmp/mysql.4000.sock
    datadir=/wali/mysql/data1
    basedir=/wali/percona/Percona-XtraDB-Cluster-5.5.27-23.6.356 .Linux.x86_64
    user=mysql
    log_error=error.log
    binlog_format=ROW
    wsrep_provider=/wali/percona/Percona-XtraDB-Cluster-5.5.27-2 3.6.356.Linux.x86_64/lib/libgalera_smm.so
    wsrep_sst_receive_address=192.168.2.21
    wsrep_node_incoming_address=192.168.2.21
    wsrep_slave_threads=2
    wsrep_cluster_name=trimethylxanthine
    wsrep_provider_options = "gmcast.listen_addr=tcp://192.168.2.21:4030;"
    wsrep_sst_method=rsync
    wsrep_node_name=node4000
    innodb_locks_unsafe_for_binlog=1
    innodb_autoinc_lock_mode=2

    mysqld_safe --defaults-file=/etc/my.4000.cnf


    vi /wali/mysql/data1/error.log

    120926 17:57:39 mysqld_safe Starting mysqld daemon with databases from /wali/mysql/data1
    120926 17:57:39 [Note] Flashcache bypass: disabled
    120926 17:57:39 [Note] Flashcache setup error is : ioctl failed

    120926 17:57:39 [Note] WSREP: Read nil XID from storage engines, skipping position init
    120926 17:57:39 [Note] WSREP: wsrep_load(): loading provider library '/wali/percona/Percona-XtraDB-Cluster-5.5.27-23.6.356.Linux. x86_64/lib/libgalera_smm.so'
    120926 17:57:39 [Note] WSREP: wsrep_load(): Galera 2.2(r115) by Codership Oy loaded succesfully.
    120926 17:57:39 [ERROR] WSREP: Failed to read output of: '/sbin/ifconfig | grep -m1 -1 -E '^[a-z]?eth[0-9]' | tail -n 1 | awk '{ print $2 }' | awk -F : '{ print $2 }''
    120926 17:57:39 [Warning] WSREP: Failed to autoguess base node address
    120926 17:57:39 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1
    120926 17:57:39 [Note] WSREP: Reusing existing '/wali/mysql/data1//galera.cache'.
    120926 17:57:39 [Note] WSREP: Passing config to GCS: gcache.dir = /wali/mysql/data1/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /wali/mysql/data1//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 0.5; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; gmcast.listen_addr = tcp://192.168.2.21:4030; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
    120926 17:57:39 [Note] WSREP: Flushing memory map to disk...
    120926 17:57:39 [ERROR] WSREP: non-standard exception
    120926 17:57:39 [ERROR] WSREP: wsrep::init() failed: 6, must shutdown

    120926 17:57:39 [ERROR] Aborting

  • #2
    rename em1 to eth0

    restart ok.

    Comment


    • #3
      sysbench --test=oltp --mysql-host=log1,log2,log3 --mysql-user=sbtest --mysql-password=sbtest --db-driver=mysql run
      sysbench 0.4.12: multi-threaded system evaluation benchmark

      Running the test with following options:
      Number of threads: 1

      Doing OLTP test.
      Running mixed OLTP test
      Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
      Using "BEGIN" for starting transactions
      Using auto_inc on the id column
      Maximum number of requests for OLTP test is limited to 10000
      Threads started!

      Done.

      OLTP test statistics:
      queries performed:
      read: 140000
      write: 50000
      other: 20000
      total: 210000
      transactions: 10000 (40.63 per sec.)
      deadlocks: 0 (0.00 per sec.)
      read/write requests: 190000 (771.95 per sec.)
      other operations: 20000 (81.26 per sec.)

      Test execution summary:
      total time: 246.1288s
      total number of events: 10000
      total time taken by event execution: 246.0193
      per-request statistics:
      min: 12.20ms
      avg: 24.60ms
      max: 189.63ms
      approx. 95 percentile: 31.85ms

      Threads fairness:
      events (avg/stddev): 10000.0000/0.00
      execution time (avg/stddev): 246.0193/0.00

      Comment


      • #4
        [root@localhost tmp]# sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=500000 --mysql-host=log1,log2,log3 --mysql-user=sbtest --mysql-password=sbtest --db-driver=mysql run
        sysbench 0.4.12: multi-threaded system evaluation benchmark

        Running the test with following options:
        Number of threads: 1

        Doing OLTP test.
        Running mixed OLTP test
        Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
        Using "BEGIN" for starting transactions
        Using auto_inc on the id column
        Maximum number of requests for OLTP test is limited to 10000
        Threads started!
        Done.

        OLTP test statistics:
        queries performed:
        read: 140000
        write: 50000
        other: 20000
        total: 210000
        transactions: 10000 (136.35 per sec.)
        deadlocks: 0 (0.00 per sec.)
        read/write requests: 190000 (2590.56 per sec.)
        other operations: 20000 (272.69 per sec.)

        Test execution summary:
        total time: 73.3432s
        total number of events: 10000
        total time taken by event execution: 73.2516
        per-request statistics:
        min: 6.13ms
        avg: 7.33ms
        max: 124.20ms
        approx. 95 percentile: 7.53ms

        Threads fairness:
        events (avg/stddev): 10000.0000/0.00
        execution time (avg/stddev): 73.2516/0.00

        [root@localhost tmp]# sysbench --num-threads=16 --max-requests=100000 --test=oltp --oltp-table-size=500000 --oltp-read-only --mysql-host=log1,log2,log3 --mysql-user=sbtest --mysql-password=sbtest --db-driver=mysql run
        sysbench 0.4.12: multi-threaded system evaluation benchmark

        Running the test with following options:
        Number of threads: 16

        Doing OLTP test.
        Running mixed OLTP test
        Doing read-only test
        Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
        Using "BEGIN" for starting transactions
        Using auto_inc on the id column
        Maximum number of requests for OLTP test is limited to 100000
        Threads started!
        Done.

        OLTP test statistics:
        queries performed:
        read: 1400084
        write: 0
        other: 200012
        total: 1600096
        transactions: 100006 (2306.22 per sec.)
        deadlocks: 0 (0.00 per sec.)
        read/write requests: 1400084 (32287.03 per sec.)
        other operations: 200012 (4612.43 per sec.)

        Test execution summary:
        total time: 43.3637s
        total number of events: 100006
        total time taken by event execution: 692.8043
        per-request statistics:
        min: 3.74ms
        avg: 6.93ms
        max: 16.96ms
        approx. 95 percentile: 8.69ms

        Threads fairness:
        events (avg/stddev): 6250.3750/362.45
        execution time (avg/stddev): 43.3003/0.00

        [root@localhost tmp]# sysbench --num-threads=16 --max-requests=100000 --test=oltp --oltp-table-size=500000 --oltp-test-mode=complex --mysql-host=log1,log2,log3 --mysql-user=sbtest --mysql-password=sbtest --db-driver=mysql run
        sysbench 0.4.12: multi-threaded system evaluation benchmark

        Running the test with following options:
        Number of threads: 16

        Doing OLTP test.
        Running mixed OLTP test
        Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
        Using "BEGIN" for starting transactions
        Using auto_inc on the id column
        Maximum number of requests for OLTP test is limited to 100000
        Threads started!
        Done.

        OLTP test statistics:
        queries performed:
        read: 1404536
        write: 501445
        other: 200499
        total: 2106480
        transactions: 100004 (1605.63 per sec.)
        deadlocks: 320 (5.14 per sec.)
        read/write requests: 1905981 (30601.83 per sec.)
        other operations: 200499 (3219.15 per sec.)

        Test execution summary:
        total time: 62.2832s
        total number of events: 100004
        total time taken by event execution: 995.3413
        per-request statistics:
        min: 6.59ms
        avg: 9.95ms
        max: 280.94ms
        approx. 95 percentile: 11.13ms

        Threads fairness:
        events (avg/stddev): 6250.2500/96.65
        execution time (avg/stddev): 62.2088/0.00

        Comment

        Working...
        X