GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

problem setting up xtradb-cluster 5.6.15-25.5-759 on ubuntu 12.04

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

  • problem setting up xtradb-cluster 5.6.15-25.5-759 on ubuntu 12.04

    When I tried to set it up,

    root@mysql-firefallapi-08:/data/mysql# /etc/init.d/mysql bootstrap-pxc
    * Bootstrapping Percona XtraDB Cluster database server mysqld * The server quit without updating PID file (/var/run/mysqld/mysqld.pid).
    [fail]
    root@mysql-firefallapi-08:/data/mysql#


    looking in the error file, I get:

    140605 20:39:15 mysqld_safe Starting mysqld daemon with databases from /data/mysql
    140605 20:39:15 mysqld_safe Skipping wsrep-recover for empty datadir: /data/mysql
    140605 20:39:15 mysqld_safe Assigning 00000000-0000-0000-0000-000000000000:-1 to wsrep_start_position
    2014-06-05 20:39:15 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
    2014-06-05 20:39:15 0 [Note] WSREP: wsrep_start_position var submitted: '00000000-0000-0000-0000-000000000000:-1'
    2014-06-05 20:39:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2014-06-05 20:39:15 25230 [ERROR] Can't find messagefile '/opt/mysql/server-5.6/share/mysql/errmsg.sys'
    2014-06-05 20:39:15 25230 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
    2014-06-05 20:39:15 25230 [Note] Plugin 'FEDERATED' is disabled.
    2014-06-05 20:39:15 25230 [Note] InnoDB: The InnoDB memory heap is disabled
    2014-06-05 20:39:15 25230 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2014-06-05 20:39:15 25230 [Note] InnoDB: Compressed tables use zlib 1.2.3.4
    2014-06-05 20:39:15 25230 [Note] InnoDB: Using Linux native AIO
    2014-06-05 20:39:15 25230 [Note] InnoDB: Using CPU crc32 instructions
    2014-06-05 20:39:15 25230 [Note] InnoDB: Initializing buffer pool, size = 17.8G
    2014-06-05 20:39:16 25230 [Note] InnoDB: Completed initialization of buffer pool
    2014-06-05 20:39:16 25230 [Note] InnoDB: Highest supported file format is Barracuda.
    2014-06-05 20:39:17 25230 [Note] InnoDB: 128 rollback segment(s) are active.
    2014-06-05 20:39:17 25230 [Note] InnoDB: Waiting for purge to start
    2014-06-05 20:39:17 25230 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.15-rel63.0 started; log sequence number 1349166538
    2014-06-05 20:39:17 25230 [ERROR] Aborting

    2014-06-05 20:39:17 25230 [Note] Binlog end
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'partition'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_METRICS'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_CMP'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_LOCKS'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'INNODB_TRX'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'XTRADB_RSEG'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
    2014-06-05 20:39:17 25230 [Note] Shutting down plugin 'InnoDB'
    2014-06-05 20:39:17 25230 [Note] InnoDB: FTS optimize thread exiting.
    2014-06-05 20:39:17 25230 [Note] InnoDB: Starting shutdown...
    2014-06-05 20:39:20 25230 [Note] InnoDB: Shutdown completed; log sequence number 1349166548
    2014-06-05 20:39:20 25230 [Note] Shutting down plugin 'ARCHIVE'
    2014-06-05 20:39:20 25230 [Note] Shutting down plugin 'BLACKHOLE'
    2014-06-05 20:39:20 25230 [Note] Shutting down plugin 'MRG_MYISAM'
    2014-06-05 20:39:20 25230 [Note] Shutting down plugin 'CSV'
    2014-06-05 20:39:20 25230 [Note] Shutting down plugin 'MEMORY'
    2014-06-05 20:39:20 25230 [Note] Shutting down plugin 'MyISAM'
    2014-06-05 20:39:20 25230 [Note] Shutting down plugin 'sha256_password'
    2014-06-05 20:39:20 25230 [Note] Shutting down plugin 'mysql_old_password'
    2014-06-05 20:39:20 25230 [Note] Shutting down plugin 'mysql_native_password'
    2014-06-05 20:39:20 25230 [Note] Shutting down plugin 'wsrep'
    2014-06-05 20:39:20 25230 [Note] Shutting down plugin 'binlog'
    2014-06-05 20:39:20 25230 [Note]
    140605 20:39:20 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
    root@mysql-firefallapi-08:/data/mysql#


    What is the problem? Do I need to set wsrep_start_position? None of the example in the manual seem to set this.


    Thanks,

    Derek

  • #2
    Also, this is what my my.cnf looks like:

    root@mysql-firefallapi-08:/data/mysql# cat /etc/mysql/my.cnf
    #
    # Generated by Chef for mysql-firefallapi-08
    #

    [client]
    port = 3306
    socket = /var/run/mysqld/mysqld.sock

    [mysqld_safe]
    socket = /var/run/mysqld/mysqld.sock
    nice = 0

    [mysqld]
    server_id = 10210113
    auto_increment_increment = 100
    auto_increment_offset = 48

    user = mysql
    default_storage_engine = InnoDB
    pid-file = /var/run/mysqld/mysqld.pid
    socket = /var/run/mysqld/mysqld.sock
    port = 3306
    basedir = /opt/mysql/server-5.6
    datadir = /data/mysql
    tmpdir = /ssd/tmp
    skip-external-locking
    bind-address = 10.210.1.13
    skip_name_resolve
    sysdate_is_now = 1
    myisam-recover = FORCE,BACKUP
    performance_schema = OFF

    # REPLICATION #
    read_only = ON
    master-info-repository = TABLE
    relay-log-info-repository = TABLE
    gtid_mode = ON
    enforce-gtid-consistency
    binlog-format = row

    log_slave_updates = 1
    log_bin = mysqld-bin
    slave_net_timeout = 60
    sync_master_info = 0
    sync_relay_log = 0
    sync_relay_log_info = 0
    sync_binlog = 0
    expire_logs_days = 14
    max_binlog_size = 1000M
    binlog_rows_query_log_events = 1
    slave_parallel_workers = 0

    # CACHES AND LIMITS #
    key_buffer = 16M
    max_heap_table_size = 32M
    max_allowed_packet = 128M
    max_connect_errors = 1000000
    max_connections = 800
    net_read_timeout = 30
    net_write_timeout = 30
    query_cache_type = 0
    query_cache_limit = 3M
    query_cache_size = 512M
    thread_cache_size = 50
    thread_stack = 256K
    #thread_concurrency =
    open_files_limit = 65535
    table_definition_cache = 1024
    table_open_cache = 2048
    tmp_table_size = 32M
    wait_timeout = 180
    back_log = 128
    max_join_size = 134200000000
    join_buffer_size = 1049000000

    # INNODB #
    innodb = FORCE
    #innodb_strict_mode =
    #innodb_stats_persistent =
    innodb_flush_method = O_DIRECT
    innodb_log_files_in_group = 2
    innodb_log_file_size = 512M
    innodb_flush_log_at_trx_commit = 2
    innodb_file_per_table = true
    innodb_buffer_pool_size = 18255M
    innodb_log_buffer_size = 8M
    innodb_lock_wait_timeout = 60
    innodb_read_io_threads = 8
    innodb_write_io_threads = 2
    innodb_max_dirty_pages_pct = 15
    innodb_thread_concurrency = 16

    # LOGGING #
    log_queries_not_using_indexes = 1
    slow_query_log = 1
    long_query_time = 1
    log-output = TABLE
    slow_launch_time = 1

    skip-federated

    [mysqldump]
    quick
    quote-names
    max_allowed_packet = 16M

    [mysql]
    #no-auto-rehash # faster start of mysql but no tab completition

    [isamchk]
    key_buffer = 16M

    !includedir /etc/mysql/conf.d/

    # Path to Galera library
    wsrep_provider=/usr/lib/libgalera_smm.so
    # Cluster connection URL
    wsrep_cluster_address=gcomm://10.210.1.13
    # In order for Galera to work correctly binlog format should be ROW
    binlog_format=ROW
    # MyISAM storage engine has only experimental support
    default_storage_engine=InnoDB
    # This changes how |InnoDB| autoincrement locks are managed and is a requirement for Galera
    innodb_autoinc_lock_mode=2
    wsrep_cluster_name=xdb
    wsrep_slave_threads=4
    wsrep_sst_method=xtrabackup
    root@mysql-firefallapi-08:/data/mysql#

    Comment


    • #3
      It seems you have installed PXC from tarball distribution? What were the exact steps you did?
      This error:
      Code:
      [ERROR] Can't find messagefile '/opt/mysql/server-5.6/share/mysql/errmsg.sys'
      suggests that there is some problem with paths used.

      Comment

      Working...
      X