# problem setting up xtradb-cluster 5.6.15-25.5-759 on ubuntu 12.04 **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [June 5, 2014, 3:22pm UTC](https://forums.percona.com/t/problem-setting-up-xtradb-cluster-5-6-15-25-5-759-on-ubuntu-12-04/3530 "2014-06-05T15:22:29Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![dl888888](https://avatars.discourse-cdn.com/v4/letter/d/c0e974/32.png) [@dl888888](https://forums.percona.com/u/dl888888)\ **Post date:** [June 5, 2014, 3:22pm UTC](https://forums.percona.com/t/problem-setting-up-xtradb-cluster-5-6-15-25-5-759-on-ubuntu-12-04/3530/1 "2014-06-05T15:22:29Z")
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](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 ---
**Author:** ![dl888888](https://avatars.discourse-cdn.com/v4/letter/d/c0e974/32.png) [@dl888888](https://forums.percona.com/u/dl888888)\ **Post date:** [June 5, 2014, 3:26pm UTC](https://forums.percona.com/t/problem-setting-up-xtradb-cluster-5-6-15-25-5-759-on-ubuntu-12-04/3530/2 "2014-06-05T15:26:13Z")
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# ---
**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\ **Post date:** [June 9, 2014, 4:20am UTC](https://forums.percona.com/t/problem-setting-up-xtradb-cluster-5-6-15-25-5-759-on-ubuntu-12-04/3530/3 "2014-06-09T04:20:05Z")
It seems you have installed PXC from tarball distribution? What were the exact steps you did? This error: ```auto [ERROR] Can't find messagefile '/opt/mysql/server-5.6/share/mysql/errmsg.sys' ``` suggests that there is some problem with paths used.