multi machine Percona XtraDB Cluster can't start

Description

192.168.2.6

docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -e CLUSTER_NAME=PXC -e XTRABACKUP_PASSWORD=123456 -v /docker/pxc/mysql:/var/lib/mysql -v /docker/pxc/data:/data --privileged --name=db1 --net=host percona/percona-xtradb-cluster

it works

192.168.2.5

docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -e CLUSTER_NAME=PXC -e XTRABACKUP_PASSWORD=123456 -v /docker/pxc/mysql:/var/lib/mysql -v /docker/pxc/data:/data --privileged --name=db2 --net=host -e CLUSTER_JOIN=192.168.3.226 percona/percona-xtradb-cluster

it failed

 

docker logs -ft db2

mysqld: Table 'mysql.plugin' doesn't exist

[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it

Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.

 

I think what cause this is mysql version,please help me

 

Environment

None

Attachments

1

Smart Checklist

Activity

Show:

Jira Bot March 29, 2020 at 4:14 PM

Hello ,
It's been 268 days since this issue went into Incomplete and we haven't heard
from you on this.

At this point, our policy is to Close this issue, to keep things from getting
too cluttered. If you have more information about this issue and wish to
reopen it, please reply with a comment containing "jira-bot=reopen".

Jira Bot February 28, 2020 at 8:54 PM

Hello ,
It's jira-bot again. Your bug report is important to us, but we haven't heard
from you since the previous notification. If we don't hear from you on
this in 7 days, the issue will be automatically closed.

Jira Bot January 25, 2020 at 10:19 PM

Hello ,
I'm jira-bot, Percona's automated helper script. Your bug report is important
to us but we've been unable to reproduce it, and asked you for more
information. If we haven't heard from you on this in 3 more weeks, the issue
will be automatically closed.

Lalit Choudhary July 5, 2019 at 9:12 AM

Hi,

thank you for the report.

I see you are using --net=host  which will use localhost network. please follow the steps described in the following document to install PXC on docker.

https://www.percona.com/doc/percona-xtradb-cluster/LATEST/install/docker.html

Incomplete

Details

Assignee

Reporter

Components

Affects versions

Priority

Smart Checklist

Created July 5, 2019 at 2:09 AM
Updated March 6, 2024 at 10:08 PM
Resolved March 29, 2020 at 4:14 PM