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

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

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#

3

It seems you have installed PXC from tarball distribution? What were the exact steps you did?
This error:

[ERROR] Can't find messagefile '/opt/mysql/server-5.6/share/mysql/errmsg.sys'

suggests that there is some problem with paths used.