Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

If node gets rebooted it won't re-join the cluster once it gets back.

Description

If node gets rebooted it won't re-join the cluster once it gets back.

| wsrep_cluster_size | 3 | | wsrep_cluster_state_uuid | 7e1a32c8-4c08-11ea-b02f-82af451be4b7 | | wsrep_cluster_status | Primary | | wsrep_connected | ON | | wsrep_local_bf_aborts | 0 | | wsrep_local_index | 2 | | wsrep_provider_capabilities | :MULTI_MASTER:CERTIFICATION:PARALLEL_APPLYING:TRX_REPLAY:ISOLATION:PAUSE:CAUSAL_READS:INCREMENTAL_WRITESET:UNORDERED:PREORDERED:STREAMING:NBO: | | wsrep_provider_name | Galera | | wsrep_provider_vendor | Codership Oy <info@codership.com> | | wsrep_provider_version | 4.3(r752664d) | | wsrep_ready | ON | | wsrep_thread_count | 9 | +----------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------+ root@pxc3:~# reboot ... vagrant@pxc3:~$ sudo su - root@pxc3:~# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) root@pxc3:~# ps auxww| grep mysql root 1002 0.0 0.0 14428 1004 pts/0 S+ 13:41 0:00 grep --color=auto mysql

If this is an intended change it needs to be documented because it's not how it was working on previous (major) version.

Tested on:

root@pxc3:~# dpkg -l | grep percona ii percona-release 1.0-14.generic all Package to install Percona gpg key and APT repos ii percona-xtradb-cluster 1:8.0.18-26.4.3-1.bionic amd64 Percona XtraDB Cluster with Galera ii percona-xtradb-cluster-client 1:8.0.18-26.4.3-1.bionic amd64 Percona XtraDB Cluster database client binaries ii percona-xtradb-cluster-common 1:8.0.18-26.4.3-1.bionic amd64 Percona XtraDB Cluster database common files (e.g. /etc/mysql/my.cnf) ii percona-xtradb-cluster-server 1:8.0.18-26.4.3-1.bionic amd64 Percona XtraDB Cluster database server binaries

Environment

None

Smart Checklist

Activity

Show:

Evgeniy Patlan February 28, 2020 at 8:26 PM

new packages are in the repo. so the issue should be fixed

Evgeniy Patlan February 17, 2020 at 8:13 AM

enabling service will be added in scope of https://perconadev.atlassian.net/browse/PXC-2985#icft=PXC-2985.

Evgeniy Patlan February 10, 2020 at 3:08 PM

but service was not enabled. this is the reason

Hrvoje Matijakovic February 10, 2020 at 3:06 PM

In this case node is configured and it's part of the cluster.

David Bennett February 10, 2020 at 3:01 PM

    Seeing that PXC requires proper configuration before the service is started,  I believe that we should not automatically enable the service.   The service should be enabled after configuration is done.   It is my opinion,  this should be changed to a documentation issue.

Done

Details

Assignee

Reporter

Time tracking

25m logged

Components

Fix versions

Affects versions

Priority

Smart Checklist

Created February 10, 2020 at 1:44 PM
Updated March 6, 2024 at 9:48 PM
Resolved February 28, 2020 at 8:26 PM