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

Error startup PXC with 1 node

HAGBARDHAGBARD EntrantCurrent User Role Beginner
Hi, I can't startup PXC with bootstrap in Centos 7 with 1 node.

This is the config file my.cnf:
[mysql]

# CLIENT #
port                           = 3306
socket                         = /var/lib/mysql/mysql.sock

[mysqld]

# GENERAL #
user                           = mysql
default-storage-engine         = InnoDB
socket                         = /var/lib/mysql/mysql.sock
pid-file                       = /var/lib/mysql/mysql.pid

# Cluster Config #
wsrep_cluster_address=gcomm://
binlog_format=ROW
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_cluster_name=AirePXC
wsrep_sst_method=mysqldump
#wsrep_sst_auth="sstuser:s3cr3t"
wsrep_node_name=PXC1
wsrep_node_address=127.0.0.1
innodb_locks_unsafe_for_binlog=1
innodb_autoinc_lock_mode=2

# MyISAM #
key-buffer-size                = 32M
myisam-recover                 = FORCE,BACKUP

# SAFETY #
max-allowed-packet             = 16M
max-connect-errors             = 1000000
sql-mode                       = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
innodb-strict-mode             = 1

# DATA STORAGE #
datadir                        = /var/lib/mysql/

# BINARY LOGGING #
log-bin                        = /var/lib/mysql/mysql-bin
expire-logs-days               = 14
sync-binlog                    = 1

# CACHES AND LIMITS #
tmp-table-size                 = 32M
max-heap-table-size            = 32M
query-cache-type               = 0
query-cache-size               = 0
max-connections                = 500
thread-cache-size              = 50
open-files-limit               = 65535
table-definition-cache         = 1024
table-open-cache               = 2048

# INNODB #
innodb-flush-method            = O_DIRECT
innodb-log-files-in-group      = 2

Startup PXC:
systemctl start mysql@bootstrap.service

And the output error:
Job for mysql@bootstrap.service failed. See 'systemctl status mysql@bootstrap.service' and 'journalctl -xn' for details.

Error Details:
ene 14 11:03:19 localhost.localdomain mysql-systemd[25304]: ERROR! mysql pid file /var/lib/mysql/mysql.pid empty or not readable
ene 14 11:03:19 localhost.localdomain mysql-systemd[25304]: WARNING: mysql may be already dead
ene 14 11:03:19 localhost.localdomain systemd[1]: Failed to start Percona XtraDB Cluster with config /etc/sysconfig/mysql.bootstrap.
-- Subject: Unit mysql@bootstrap.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- Unit mysql@bootstrap.service has failed.
-- 
-- The result is failed.
ene 14 11:03:19 localhost.localdomain systemd[1]: Unit mysql@bootstrap.service entered failed state.
ene 14 11:03:20 localhost.localdomain sshd[25272]: Failed password for root from 103.41.124.18 port 34714 ssh2
ene 14 11:03:20 localhost.localdomain sshd[25272]: Received disconnect from 103.41.124.18: 11:  [preauth]
ene 14 11:03:20 localhost.localdomain sshd[25272]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=103.41.124.18  user=root
ene 14 11:03:22 localhost.localdomain unix_chkpwd[25333]: password check failed for user (root)
ene 14 11:03:22 localhost.localdomain sshd[25331]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=103.41.124.18  user=root
ene 14 11:03:22 localhost.localdomain sshd[25331]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
[root@localhost data]#

Any ideas?

Comments

  • HAGBARDHAGBARD Entrant Current User Role Beginner
    I found the problem, I had not disabled the SELinux. :confused:
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.