Announcement

Announcement Module
Collapse
No announcement yet.

percona node crashes bug report mysqld got signal 11 ;

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

  • percona node crashes bug report mysqld got signal 11 ;

    Hi, my node is no staying up for more then a few mins

    im loading my log file and cnf file to this message , however here is a snippet
    any help will be appreciated

    Code:
    WSREP: (4302ec23-e190-11e3-8be4-62b01228e2d3, 'tcp://0.0.0.0:4567') address 'tcp://10.10.0.6:4567' pointing to uuid 4302ec23-e190-11e3-8be4-62b01228e2d3 is blacklisted, skipping
    2014-05-22 11:07:08 27162 [Note] WSREP: (4302ec23-e190-11e3-8be4-62b01228e2d3, 'tcp://0.0.0.0:4567') cleaning up duplicate 0x7f36000022f0 after established 0x7f3600001a50
    09:07:08 UTC - mysqld got signal 11 ;
    This could be because you hit a bug. It is also possible that this binary
    or one of the libraries it was linked against is corrupt, improperly built,
    or misconfigured. This error can also be caused by malfunctioning hardware.
    We will try our best to scrape up some info that will hopefully help
    diagnose the problem, but since we have already crashed,
    something is definitely wrong and this may fail.
    Please help us make Percona XtraDB Cluster better by reporting any
    bugs at https://bugs.launchpad.net/percona-xtradb-cluster
    
    key_buffer_size=25165824
    read_buffer_size=131072
    max_used_connections=0
    max_threads=202
    thread_count=9
    connection_count=9
    It is possible that mysqld could use up to
    key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 105157 K bytes of memory
    Hope that's ok; if not, decrease some variables in the equation.
    
    Thread pointer: 0x0
    Attempting backtrace. You can use the following information to find out
    where mysqld died. If you see no messages after this, something went
    terribly wrong...
    stack_bottom = 0 thread_stack 0x40000
    /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x902645]
    /usr/sbin/mysqld(handle_fatal_signal+0x4c4)[0x6801e4]
    /lib64/libpthread.so.0[0x31f400f710]
    [0x7f36000001d8]
    You may download the Percona XtraDB Cluster operations manual by visiting
    http://www.percona.com/software/percona-xtradb-cluster/. You may find information
    in the manual which will help you identify the cause of the crash.
    140522 11:07:08 mysqld_safe Number of processes running now: 0
    140522 11:07:08 mysqld_safe WSREP: not restarting wsrep node automatically
    140522 11:07:08 mysqld_safe mysqld from pid file /var/lib/mysql/mysqld.pid ended
    and

    my.cnf
    Code:
    # All files in this package is subject to the GPL v2 license
    # More information is in the COPYING file in the top directory of this package.
    # Copyright (C) 2011 severalnines.com
    
    [MYSQLD]
    lower-case-table-names=1
    user=mysql
    basedir=/usr/
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    pid-file=mysqld.pid
    port=3306
    log-error=/var/log/mysqld.log
    log-warnings=2
    #log-output=FILE
    ### INNODB OPTIONS
    innodb-buffer-pool-size=5591M
    innodb-flush-log-at-trx-commit=2
    innodb-file-per-table=1
    innodb-data-file-path = ibdata1:100M:autoextend
    ## You may want to tune the below depending on number of cores and disk sub
    innodb-read-io-threads=4
    innodb-write-io-threads=4
    innodb-doublewrite=1
    innodb-log-file-size=512M
    innodb-log-buffer-size=64M
    innodb-buffer-pool-instances=4
    innodb-log-files-in-group=2
    innodb-thread-concurrency=0
    #innodb-file-format=barracuda
    innodb-flush-method = O_DIRECT
    #innodb-locks-unsafe-for-binlog=1
    innodb-autoinc-lock-mode=2
    ## avoid statistics update when doing e.g show tables
    innodb-stats-on-metadata=0
    default-storage-engine=innodb
    
    # CHARACTER SET
    #collation-server = utf8_unicode_ci
    #init-connect='SET NAMES utf8'
    #character-set-server = utf8
    
    # REPLICATION SPECIFIC - GENERAL
    #server-id must be unique across all mysql servers participating in replication.
    #server-id=SERVERID
    
    auto_increment_increment=5
    auto_increment_offset=3
    
    # REPLICATION SPECIFIC
    binlog_format=ROW
    #log-bin=binlog
    #relay-log=relay-bin
    #expire_logs_days=7
    #log-slave-updates=1
    #gtid_mode=ON
    #log-bin=binlog
    #enforce-gtid-consistency=1
    # OTHER THINGS, BUFFERS ETC
    key_buffer_size = 24M
    tmp_table_size = 64M
    max_heap_table_size = 64M
    max-allowed-packet = 512M
    #sort-buffer-size = 256K
    #read-buffer-size = 256K
    #read-rnd-buffer-size = 512K
    #myisam-sort-buffer_size = 8M
    skip-name-resolve
    memlock=0
    sysdate-is-now=1
    max-connections=200
    thread-cache-size=512
    query-cache-type = 0
    query-cache-size = 0
    table-open_cache=1024
    lower-case-table-names=0
    # 5.6 backwards compatibility
    explicit_defaults_for_timestamp=1
    ##
    ## WSREP options
    ##
    
    # Full path to wsrep provider library or 'none'
    wsrep_provider=/usr/lib64/libgalera_smm.so
    
    wsrep_node_address=10.10.0.6
    # Provider specific configuration options
    wsrep_provider_options="gcache.size=1024M; gmcast.segment=2; evs.keepalive_period=PT3S; evs.inactive_check_period=PT10S; evs.suspect_timeout=PT30S; evs.inactive_timeout=PT1M; evs.install_timeout=PT1M; evs.send_window=1024; evs.user_send_window=512;"
    
    # Logical cluster name. Should be the same for all nodes.
    wsrep_cluster_name="my_wsrep_cluster"
    
    # Group communication system handle
    wsrep_cluster_address=gcomm://10.10.0.1:4567,10.10.0.6:4567,10.10.0.10:4567
    
    # Human-readable node name (non-unique). Hostname by default.
    #wsrep_node_name=
    
    # Address for incoming client connections. Autodetect by default.
    #wsrep_node_incoming_address=
    
    # How many threads will process writesets from other nodes
    wsrep_slave_threads=8
    
    # DBUG options for wsrep provider
    #wsrep_dbug_option
    
    # Generate fake primary keys for non-PK tables (required for multi-master
    # and parallel applying operation)
    wsrep_certify_nonPK=1
    
    # Location of the directory with data files. Needed for non-mysqldump
    # state snapshot transfers. Defaults to mysql_real_data_home.
    #wsrep_data_home_dir=
    
    # Maximum number of rows in write set
    wsrep_max_ws_rows=131072
    
    # Maximum size of write set
    wsrep_max_ws_size=1073741824
    
    # to enable debug level logging, set this to 1
    wsrep_debug=0
    
    # convert locking sessions into transactions
    wsrep_convert_LOCK_to_trx=0
    
    # how many times to retry deadlocked autocommits
    wsrep_retry_autocommit=1
    
    # change auto_increment_increment and auto_increment_offset automatically
    wsrep_auto_increment_control=0
    
    # replicate myisam
    wsrep_replicate_myisam=1
    # retry autoinc insert, which failed for duplicate key error
    wsrep_drupal_282555_workaround=0
    
    # enable "strictly synchronous" semantics for read operations
    wsrep_causal_reads=0
    
    # Command to call when node status or cluster membership changes.
    # Will be passed all or some of the following options:
    # --status  - new status of this node
    # --uuid    - UUID of the cluster
    # --primary - whether the component is primary or not ("yes"/"no")
    # --members - comma-separated list of members
    # --index   - index of this node in the list
    #wsrep_notify_cmd=
    
    ##
    ## WSREP State Transfer options
    ##
    
    # State Snapshot Transfer method
    # ClusterControl currently DOES NOT support wsrep_sst_method=mysqldump
    wsrep_sst_method=xtrabackup-v2
    
    # Address on THIS node to receive SST at. DON'T SET IT TO DONOR ADDRESS!!!
    # (SST method dependent. Defaults to the first IP of the first interface)
    #wsrep_sst_receive_address=
    
    # SST authentication string. This will be used to send SST to joining nodes.
    # Depends on SST method. For mysqldump method it is root:<root password>
    wsrep_sst_auth=root:password
    
    # Desired SST donor name.
    #wsrep_sst_donor=
    
    # Protocol version to use
    # wsrep_protocol_version=
    [MYSQL]
    socket=/var/lib/mysql/mysql.sock
    #default-character-set=utf8
    [client]
    socket=/var/lib/mysql/mysql.sock
    #default-character-set=utf8
    [mysqldump]
    max-allowed-packet = 512M
    #default-character-set=utf8
    [MYSQLD_SAFE]
    pid-file=mysqld.pid
    log-error=/var/log/mysqld.log
    basedir=/usr/
    datadir=/var/lib/mysql
    Last edited by zmahomedy; 05-22-2014, 06:48 AM.
Working...
X