Not the answer you need?
Register and ask your own question!

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

ppop123ppop123 EntrantCurrent User Role Beginner
cat my.4000.cnf
[mysqld_safe]
wsrep_urls=[URL="gcomm://192.168.2.21:4030,gcomm://192.168.2.21:5030,gcomm://192.168.2.21:6030,gcomm://"] gcomm://192.168.2.21:4030,gcomm://192.168.2.21:5030,gcomm:// 192.168.2.21:6030,gcomm://[/URL]

[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=[URL]tcp://192.168.2.21:4030[/URL];"
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 <[EMAIL="info&#64;codership.com"][email protected][/EMAIL]> 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 = [URL]tcp://192.168.2.21:4030[/URL]; 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

Comments

  • ppop123ppop123 Entrant Current User Role Beginner
    rename em1 to eth0

    restart ok.
  • ppop123ppop123 Entrant Current User Role Beginner
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.