Percona xtradb cluster v5.7.35-31.53.1 on ubuntu 20.04 configuration problems

i’m trying to install a xtradb cluster v5.7.35-31.53.1 on 20.04 but i have problems while it is configuring, so 2 packages are keeping not fully installed

root@XXXXXX:~# apt update
Hit:1 http://it.archive.ubuntu.com/ubuntu focal InRelease
Hit:2 http://it.archive.ubuntu.com/ubuntu focal-updates InRelease
Hit:3 http://it.archive.ubuntu.com/ubuntu focal-backports InRelease
Hit:4 http://it.archive.ubuntu.com/ubuntu focal-security InRelease
Hit:5 http://repo.percona.com/percona/apt focal InRelease
Hit:6 http://repo.percona.com/prel/apt focal InRelease
Reading package lists... Done
Building dependency tree
Reading state information... Done
All packages are up to date.
root@percona1-lnf:~# apt upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n] y
Setting up percona-xtradb-cluster-server-5.7 (5.7.35-31.53-1.focal) ...
dpkg: error processing package percona-xtradb-cluster-server-5.7 (--configure):
 installed percona-xtradb-cluster-server-5.7 package post-installation script subprocess returned error exit status 1
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          dpkg: dependency problems prevent configuration of percona-xtradb-cluster-57:
 percona-xtradb-cluster-57 depends on percona-xtradb-cluster-server-5.7 (>= 5.7.35-31.53-1.focal); however:
  Package percona-xtradb-cluster-server-5.7 is not configured yet.

dpkg: error processing package percona-xtradb-cluster-57 (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 percona-xtradb-cluster-server-5.7
 percona-xtradb-cluster-57
E: Sub-process /usr/bin/dpkg returned an error code (1)

In the log /var/log/mysqld.log i found:

2021-12-13T10:29:17.686855Z 0 [ERROR] unknown option '--oDB'
2021-12-13T10:29:17.686923Z 0 [ERROR] Aborting

how can i fix this situation ?

Another questions is there a way to automate the installation of percona packages via ansible ?

Because it seems there is no way to do it.

thanks in advance
Claudio

1 Like

Hi @soprano!
In your case PXC is not installed.
You need to try apt install --fix-broken command and resolve the issue.
I tried to reproduce it on my end but without success,
In my case all packages were installed correctly

1 Like

i tried it,

root@XXXXX~# apt install --fix-broken
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up percona-xtradb-cluster-server-5.7 (5.7.35-31.53-1.focal) ...


 * Percona XtraDB Cluster is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
 * Run the following commands to create these functions:

	mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
	mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
	mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"

 * See http://www.percona.com/doc/percona-server/5.7/management/udf_percona_toolkit.html for more details


Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
● mysql.service - LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon
     Loaded: loaded (/etc/init.d/mysql; generated)
     Active: failed (Result: exit-code) since Mon 2021-12-13 14:09:08 CET; 10ms ago
       Docs: man:systemd-sysv-generator(8)
    Process: 47285 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Dec 13 14:08:29 percona1-lnf systemd[1]: Starting LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon...
Dec 13 14:08:29 percona1-lnf mysql[47285]:  * Starting MySQL (Percona XtraDB Cluster) database server mysqld
Dec 13 14:08:29 percona1-lnf /etc/init.d/mysql[47340]: MySQL PID not found, pid_file detected/guessed: /var/run/mysqld/mysqld.pid
Dec 13 14:09:08 percona1-lnf mysql[47285]:  * The server quit without updating PID file (/var/run/mysqld/mysqld.pid).
Dec 13 14:09:08 percona1-lnf mysql[47285]:    ...fail!
Dec 13 14:09:08 percona1-lnf systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
Dec 13 14:09:08 percona1-lnf systemd[1]: mysql.service: Failed with result 'exit-code'.
Dec 13 14:09:08 percona1-lnf systemd[1]: Failed to start LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon.
dpkg: error processing package percona-xtradb-cluster-server-5.7 (--configure):
 installed percona-xtradb-cluster-server-5.7 package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of percona-xtradb-cluster-57:
 percona-xtradb-cluster-57 depends on percona-xtradb-cluster-server-5.7 (>= 5.7.35-31.53-1.focal); however:
  Package percona-xtradb-cluster-server-5.7 is not configured yet.

dpkg: error processing package percona-xtradb-cluster-57 (--configure):
 dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          Errors were encountered while processing:
 percona-xtradb-cluster-server-5.7
 percona-xtradb-cluster-57
E: Sub-process /usr/bin/dpkg returned an error code (1)

in the errorlogs i have

2021-12-13T13:09:03.723421Z 0 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view (pc.wait_prim_timeout): 110 (C
onnection timed out)
	 at gcomm/src/pc.cpp:connect():161
2021-12-13T13:09:03.723505Z 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -110 (Connection timed out)
2021-12-13T13:09:03.723611Z 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1527: Failed to open channel 'PerconaBC' at 'gcomm://10.52.1.111,10.52.1.112,1
0.52.1.113': -110 (Connection timed out)
2021-12-13T13:09:03.723641Z 0 [ERROR] WSREP: gcs connect failed: Connection timed out
2021-12-13T13:09:03.723655Z 0 [ERROR] WSREP: Provider/Node (gcomm://10.52.1.111,10.52.1.112,10.52.1.113) failed to establish connection with cluster (
reason: 7)
2021-12-13T13:09:03.723666Z 0 [ERROR] Aborting

Claudio

1 Like

I removed all the packages and also purge all the files.

Then reinstalled with

percona-release setup pxc57

then

root@XXXXX:~# apt install percona-xtradb-cluster-57
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
  percona-xtrabackup-24 percona-xtradb-cluster-client-5.7 percona-xtradb-cluster-common-5.7 percona-xtradb-cluster-server-5.7
Suggested packages:
  tinyca pv
The following NEW packages will be installed:
  percona-xtrabackup-24 percona-xtradb-cluster-57 percona-xtradb-cluster-client-5.7 percona-xtradb-cluster-common-5.7
  percona-xtradb-cluster-server-5.7
0 upgraded, 5 newly installed, 0 to remove and 1 not upgraded.
Need to get 0 B/22.1 MB of archives.
After this operation, 187 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Preconfiguring packages ...
Selecting previously unselected package percona-xtradb-cluster-common-5.7.
(Reading database ... 146162 files and directories currently installed.)
Preparing to unpack .../percona-xtradb-cluster-common-5.7_5.7.35-31.53-1.focal_amd64.deb ...
Unpacking percona-xtradb-cluster-common-5.7 (5.7.35-31.53-1.focal) ...
Selecting previously unselected package percona-xtradb-cluster-client-5.7.
Preparing to unpack .../percona-xtradb-cluster-client-5.7_5.7.35-31.53-1.focal_amd64.deb ...
Unpacking percona-xtradb-cluster-client-5.7 (5.7.35-31.53-1.focal) ...
Selecting previously unselected package percona-xtrabackup-24.
Preparing to unpack .../percona-xtrabackup-24_2.4.24-1.focal_amd64.deb ...
Unpacking percona-xtrabackup-24 (2.4.24-1.focal) ...
Selecting previously unselected package percona-xtradb-cluster-server-5.7.
Preparing to unpack .../percona-xtradb-cluster-server-5.7_5.7.35-31.53-1.focal_amd64.deb ...
Unpacking percona-xtradb-cluster-server-5.7 (5.7.35-31.53-1.focal) ...
Selecting previously unselected package percona-xtradb-cluster-57.
Preparing to unpack .../percona-xtradb-cluster-57_5.7.35-31.53-1.focal_amd64.deb ...
Unpacking percona-xtradb-cluster-57 (5.7.35-31.53-1.focal) ...
Setting up percona-xtrabackup-24 (2.4.24-1.focal) ...
Setting up percona-xtradb-cluster-common-5.7 (5.7.35-31.53-1.focal) ...
update-alternatives: using /etc/mysql/percona-xtradb-cluster.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Setting up percona-xtradb-cluster-client-5.7 (5.7.35-31.53-1.focal) ...
Setting up percona-xtradb-cluster-server-5.7 (5.7.35-31.53-1.focal) ...


 * Percona XtraDB Cluster is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
 * Run the following commands to create these functions:

	mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
	mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
	mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"

 * See http://www.percona.com/doc/percona-server/5.7/management/udf_percona_toolkit.html for more details


Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
● mysql.service - LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon
     Loaded: loaded (/etc/init.d/mysql; generated)
     Active: failed (Result: exit-code) since Tue 2021-12-14 17:14:16 CET; 15ms ago
       Docs: man:systemd-sysv-generator(8)
    Process: 55563 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Dec 14 17:14:04 percona3-lnf systemd[1]: Starting LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon...
Dec 14 17:14:04 percona3-lnf mysql[55563]:  * Starting MySQL (Percona XtraDB Cluster) database server mysqld
Dec 14 17:14:04 percona3-lnf /etc/init.d/mysql[55622]: MySQL PID not found, pid_file detected/guessed: /var/run/mysqld/mysqld.pid
Dec 14 17:14:16 percona3-lnf mysql[55563]:  * The server quit without updating PID file (/var/run/mysqld/mysqld.pid).
Dec 14 17:14:16 percona3-lnf mysql[55563]:    ...fail!
Dec 14 17:14:16 percona3-lnf systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
Dec 14 17:14:16 percona3-lnf systemd[1]: mysql.service: Failed with result 'exit-code'.
Dec 14 17:14:16 percona3-lnf systemd[1]: Failed to start LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon.
dpkg: error processing package percona-xtradb-cluster-server-5.7 (--configure):
 installed percona-xtradb-cluster-server-5.7 package post-installation script subprocess returned error exit status 1
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          dpkg: dependency problems prevent configuration of percona-xtradb-cluster-57:
 percona-xtradb-cluster-57 depends on percona-xtradb-cluster-server-5.7 (>= 5.7.35-31.53-1.focal); however:
  Package percona-xtradb-cluster-server-5.7 is not configured yet.

dpkg: error processing package percona-xtradb-cluster-57 (--configure):
 dependency problems - leaving unconfigured
Processing triggers for man-db (2.9.1-1) ...
Processing triggers for systemd (245.4-4ubuntu3.13) ...
Errors were encountered while processing:
 percona-xtradb-cluster-server-5.7
 percona-xtradb-cluster-57
E: Sub-process /usr/bin/dpkg returned an error code (1)

Is there a way to bootstrap the cluster from ubuntu ?

i tried with

root@XXXXX:~# systemctl start mysql@bootstrap
Failed to start mysql@bootstrap.service: Unit mysql@bootstrap.service not found.
root@XXXXX:~# systemctl start mysql.service@bootstrap
Failed to start mysql@bootstrap.service: Unit mysql@bootstrap.service not found.

only

root@XXXXX:~# /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]

fail

I think there is something not working with the installation process

Any hint/help is welcome
Claudio

1 Like

Hi @soprano
Seems you have enabled apparmor on your system.
In order to use PXC it is needed to disable it.
As for bootstraping node: /etc/init.d/mysql bootstrap-pxc
You can find more information in our documentation: Bootstrapping the First Node - Percona XtraDB Cluster

1 Like

Thanks for the suggestion, but

  • i removed apparmor with
root@XXXXX:~# apt remove apparmor
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following package was automatically installed and is no longer required:
  squashfs-tools
Use 'apt autoremove' to remove it.
The following packages will be REMOVED:
  apparmor snapd
0 upgraded, 0 newly installed, 2 to remove and 2 not upgraded.
2 not fully installed or removed.
After this operation, 136 MB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 146460 files and directories currently installed.)
Removing snapd (2.51.1+20.04ubuntu2) ...
Stopping snap.lxd.activate.service
Stopping unit snap.lxd.activate.service
Waiting until unit snap.lxd.activate.service is stopped [attempt 1]
snap.lxd.activate.service is stopped.
Stopping snap.lxd.daemon.service
Stopping unit snap.lxd.daemon.service
Waiting until unit snap.lxd.daemon.service is stopped [attempt 1]
snap.lxd.daemon.service is stopped.
Stopping snap.lxd.daemon.unix.socket
Stopping unit snap.lxd.daemon.unix.socket
Waiting until unit snap.lxd.daemon.unix.socket is stopped [attempt 1]
snap.lxd.daemon.unix.socket is stopped.
Removing apparmor (2.13.3-7ubuntu5.1) ...
  • i removed all the packages about percona with
root@XXXXX:~# apt remove percona-xtrabackup-24 percona-xtradb-cluster-57 percona-xtradb-cluster-client-5.7 percona-xtradb-cluster-common-5.7 percona-xtradb-cluster-server-5.7
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
  debsums libcurl4-openssl-dev libdbd-mysql-perl libdbi-perl libdpkg-perl libev4 libfile-fcntllock-perl libfile-fnmatch-perl libmecab2 qpress socat
  squashfs-tools
Use 'apt autoremove' to remove them.
The following packages will be REMOVED:
  percona-xtrabackup-24 percona-xtradb-cluster-57 percona-xtradb-cluster-client-5.7 percona-xtradb-cluster-common-5.7
  percona-xtradb-cluster-server-5.7
0 upgraded, 0 newly installed, 5 to remove and 2 not upgraded.
2 not fully installed or removed.
After this operation, 187 MB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 146349 files and directories currently installed.)
Removing percona-xtradb-cluster-57 (5.7.35-31.53-1.focal) ...
Removing percona-xtradb-cluster-server-5.7 (5.7.35-31.53-1.focal) ...
Removing percona-xtrabackup-24 (2.4.24-1.focal) ...
Removing percona-xtradb-cluster-client-5.7 (5.7.35-31.53-1.focal) ...
Removing percona-xtradb-cluster-common-5.7 (5.7.35-31.53-1.focal) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Processing triggers for man-db (2.9.1-1) ...
  • i purged all the files with
root@XXXXX:~# apt purge percona-xtrabackup-24 percona-xtradb-cluster-57 percona-xtradb-cluster-client-5.7 percona-xtradb-cluster-common-5.7 percona-xtradb-cluster-server-5.7
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package 'percona-xtrabackup-24' is not installed, so not removed
Package 'percona-xtradb-cluster-57' is not installed, so not removed
Package 'percona-xtradb-cluster-client-5.7' is not installed, so not removed
Package 'percona-xtradb-cluster-common-5.7' is not installed, so not removed
Package 'percona-xtradb-cluster-server-5.7' is not installed, so not removed
The following packages were automatically installed and are no longer required:
  debsums libcurl4-openssl-dev libdbd-mysql-perl libdbi-perl libdpkg-perl libev4 libfile-fcntllock-perl libfile-fnmatch-perl libmecab2 qpress socat
  squashfs-tools
Use 'apt autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.
  • i reinstalled the percona packages with
root@XXXXX:~# apt install percona-xtradb-cluster-57
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following package was automatically installed and is no longer required:
  squashfs-tools
Use 'apt autoremove' to remove it.
The following additional packages will be installed:
  percona-xtrabackup-24 percona-xtradb-cluster-client-5.7 percona-xtradb-cluster-common-5.7 percona-xtradb-cluster-server-5.7
Suggested packages:
  tinyca pv
The following NEW packages will be installed:
  percona-xtrabackup-24 percona-xtradb-cluster-57 percona-xtradb-cluster-client-5.7 percona-xtradb-cluster-common-5.7
  percona-xtradb-cluster-server-5.7
0 upgraded, 5 newly installed, 0 to remove and 2 not upgraded.
Need to get 0 B/22.1 MB of archives.
After this operation, 187 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Preconfiguring packages ...
Selecting previously unselected package percona-xtradb-cluster-common-5.7.
(Reading database ... 146051 files and directories currently installed.)
Preparing to unpack .../percona-xtradb-cluster-common-5.7_5.7.35-31.53-1.focal_amd64.deb ...
Unpacking percona-xtradb-cluster-common-5.7 (5.7.35-31.53-1.focal) ...
Selecting previously unselected package percona-xtradb-cluster-client-5.7.
Preparing to unpack .../percona-xtradb-cluster-client-5.7_5.7.35-31.53-1.focal_amd64.deb ...
Unpacking percona-xtradb-cluster-client-5.7 (5.7.35-31.53-1.focal) ...
Selecting previously unselected package percona-xtrabackup-24.
Preparing to unpack .../percona-xtrabackup-24_2.4.24-1.focal_amd64.deb ...
Unpacking percona-xtrabackup-24 (2.4.24-1.focal) ...
Selecting previously unselected package percona-xtradb-cluster-server-5.7.
Preparing to unpack .../percona-xtradb-cluster-server-5.7_5.7.35-31.53-1.focal_amd64.deb ...
Unpacking percona-xtradb-cluster-server-5.7 (5.7.35-31.53-1.focal) ...
Selecting previously unselected package percona-xtradb-cluster-57.
Preparing to unpack .../percona-xtradb-cluster-57_5.7.35-31.53-1.focal_amd64.deb ...
Unpacking percona-xtradb-cluster-57 (5.7.35-31.53-1.focal) ...
Setting up percona-xtrabackup-24 (2.4.24-1.focal) ...
Setting up percona-xtradb-cluster-common-5.7 (5.7.35-31.53-1.focal) ...
update-alternatives: using /etc/mysql/percona-xtradb-cluster.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Setting up percona-xtradb-cluster-client-5.7 (5.7.35-31.53-1.focal) ...
Setting up percona-xtradb-cluster-server-5.7 (5.7.35-31.53-1.focal) ...


 * Percona XtraDB Cluster is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
 * Run the following commands to create these functions:

	mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
	mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
	mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"

 * See http://www.percona.com/doc/percona-server/5.7/management/udf_percona_toolkit.html for more details


Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
invoke-rc.d: initscript mysql, action "start" failed.
● mysql.service - LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon
     Loaded: loaded (/etc/init.d/mysql; generated)
     Active: failed (Result: exit-code) since Wed 2021-12-15 15:31:02 CET; 7ms ago
       Docs: man:systemd-sysv-generator(8)
    Process: 60359 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Dec 15 15:30:51 XXXXX systemd[1]: Starting LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon...
Dec 15 15:30:51 XXXXX mysql[60359]:  * Starting MySQL (Percona XtraDB Cluster) database server mysqld
Dec 15 15:31:02 XXXXX mysql[60359]:  * The server quit without updating PID file (/var/run/mysqld/mysqld.pid).
Dec 15 15:31:02 XXXXX mysql[60359]:    ...fail!
Dec 15 15:31:02 XXXXX systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
Dec 15 15:31:02 XXXXX systemd[1]: mysql.service: Failed with result 'exit-code'.
Dec 15 15:31:02 XXXXX systemd[1]: Failed to start LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon.
dpkg: error processing package percona-xtradb-cluster-server-5.7 (--configure):
 installed percona-xtradb-cluster-server-5.7 package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of percona-xtradb-cluster-57:
 percona-xtradb-cluster-57 depends on percona-xtradb-cluster-server-5.7 (>= 5.7.35-31.53-1.focal); however:
  Package percona-xtradb-cluster-server-5.7 is not configured yet.

dpkg: error processing package percona-xtradb-cluster-57 (--configure):
 dependency problems - leaving unconfigured
Processing triggers for man-db (2.9.1-1) ...
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          Processing triggers for systemd (245.4-4ubuntu3.13) ...
Errors were encountered while processing:
 percona-xtradb-cluster-server-5.7
 percona-xtradb-cluster-57
E: Sub-process /usr/bin/dpkg returned an error code (1)

And we are at the begin of this tread

Here the mysqld.log

2021-12-15T14:30:52.252717Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server optio
n (see documentation for more details).
2021-12-15T14:30:52.254597Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.35-38-57-log) starting as process 60786 ...
2021-12-15T14:30:52.258806Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this My
SQL server acts as a master and has his hostname changed!! Please use '--log-bin=XXXXX -bin' to avoid this problem.
2021-12-15T14:30:52.259101Z 0 [Note] WSREP: Setting wsrep_ready to false
2021-12-15T14:30:52.259114Z 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization.
2021-12-15T14:30:52.259120Z 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera3/libgalera_smm.so'
2021-12-15T14:30:52.259799Z 0 [Note] WSREP: wsrep_load(): Galera 3.53(re33d74b) by Codership Oy <info@codership.com> loaded successfully.
2021-12-15T14:30:52.260011Z 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2021-12-15T14:30:52.260313Z 0 [Note] WSREP: Found saved state: db8faa27-5cf8-11ec-8b52-fe24c2e2fe75:0, safe_to_bootstrap: 1
2021-12-15T14:30:52.264032Z 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.52.1.113; base_port = 4567; cert.log_con
flicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_pe
riod = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 10; evs.stats_report_peri
od = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 4; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.freeze_purge_at
_seqno = -1; gcache.keep_pages_count = 0; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_siz
e = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 100; gcs.fc_master_slave
= no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor
= no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.npvo
 = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; pc.weight = 1; protonet.backend = asio; protonet.vers
ion = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 9; socket.c
hecksum = 2; socket.recv_buf_size = auto; socket.send_buf_size = auto;
2021-12-15T14:30:52.278325Z 0 [Note] WSREP: Assign initial position for certification: 0, protocol version: -1
2021-12-15T14:30:52.278346Z 0 [Note] WSREP: Preparing to initiate SST/IST
2021-12-15T14:30:52.278351Z 0 [Note] WSREP: Starting replication
2021-12-15T14:30:52.278359Z 0 [Note] WSREP: Setting initial position to db8faa27-5cf8-11ec-8b52-fe24c2e2fe75:0
2021-12-15T14:30:52.278492Z 0 [Note] WSREP: Using CRC-32C for message checksums.
2021-12-15T14:30:52.278578Z 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2021-12-15T14:30:52.278648Z 0 [Warning] WSREP: Fail to access the file (/var/lib/mysql//gvwstate.dat) error (No such file or directory). It is possibl
e if node is booting for first time or re-booting after a graceful shutdown
2021-12-15T14:30:52.278655Z 0 [Note] WSREP: Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a
graceful shutdown
2021-12-15T14:30:52.278821Z 0 [Note] WSREP: GMCast version 0
2021-12-15T14:30:52.278896Z 0 [Note] WSREP: (9b023b9b, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2021-12-15T14:30:52.278903Z 0 [Note] WSREP: (9b023b9b, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2021-12-15T14:30:52.279172Z 0 [Note] WSREP: EVS version 0
2021-12-15T14:30:52.279237Z 0 [Note] WSREP: gcomm: connecting to group 'pxc-cluster', peer ''
2021-12-15T14:30:52.279260Z 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2021-12-15T14:30:52.279470Z 0 [Note] WSREP: Node 9b023b9b state primary
2021-12-15T14:30:52.279490Z 0 [Note] WSREP: Current view of cluster as seen by this node
view (view_id(PRIM,9b023b9b,1)
memb {
	9b023b9b,0
	}
joined {
	}
left {
	}
partitioned {
	}
)
2021-12-15T14:30:52.279496Z 0 [Note] WSREP: Save the discovered primary-component to disk
2021-12-15T14:30:52.291702Z 0 [Note] WSREP: gcomm: connected
2021-12-15T14:30:52.291822Z 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2021-12-15T14:30:52.291878Z 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2021-12-15T14:30:52.291922Z 0 [Note] WSREP: Waiting for SST/IST to complete.
2021-12-15T14:30:52.291967Z 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 9b0441b8-5db3-11ec-b6e6-13b4cd49e8d0
2021-12-15T14:30:52.291975Z 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 9b0441b8-5db3-11ec-b6e6-13b4cd49e8d0
2021-12-15T14:30:52.291979Z 0 [Note] WSREP: STATE EXCHANGE: got state msg: 9b0441b8-5db3-11ec-b6e6-13b4cd49e8d0 from 0 (pxc-cluster-node-1)
2021-12-15T14:30:52.291984Z 0 [Note] WSREP: Quorum results:
	version    = 6,
	component  = PRIMARY,
	conf_id    = 0,
	members    = 1/1 (primary/total),
	act_id     = 0,
	last_appl. = -1,
	protocols  = 0/9/3 (gcs/repl/appl),
	group UUID = db8faa27-5cf8-11ec-8b52-fe24c2e2fe75
2021-12-15T14:30:52.291987Z 0 [Note] WSREP: Flow-control interval: [100, 100]
2021-12-15T14:30:52.291990Z 0 [Note] WSREP: Restored state OPEN -> JOINED (0)
2021-12-15T14:30:52.291999Z 0 [Note] WSREP: Member 0.0 (pxc-cluster-node-1) synced with group.
2021-12-15T14:30:52.292002Z 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
2021-12-15T14:30:52.292058Z 1 [Note] WSREP: REPL Protocols: 9 (4, 2)
2021-12-15T14:30:52.292072Z 1 [Note] WSREP: REPL Protocols: 9 (4, 2)
2021-12-15T14:30:52.292083Z 1 [Note] WSREP: New cluster view: global state: db8faa27-5cf8-11ec-8b52-fe24c2e2fe75:0, view# 1: Primary, number of nodes:
 1, my index: 0, protocol version 3
2021-12-15T14:30:52.292087Z 1 [Note] WSREP: Setting wsrep_ready to true
2021-12-15T14:30:52.292102Z 0 [Note] WSREP: SST complete, seqno: 0
2021-12-15T14:30:52.293684Z 0 [Note] InnoDB: PUNCH HOLE support available
2021-12-15T14:30:52.293698Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-12-15T14:30:52.293703Z 0 [Note] InnoDB: Uses event mutexes
2021-12-15T14:30:52.293707Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2021-12-15T14:30:52.293711Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-15T14:30:52.293715Z 0 [Note] InnoDB: Using Linux native AIO
2021-12-15T14:30:52.293944Z 0 [Note] InnoDB: Number of pools: 1
2021-12-15T14:30:52.294049Z 0 [Note] InnoDB: Using CPU crc32 instructions
2021-12-15T14:30:52.295715Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-12-15T14:30:52.301237Z 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-15T14:30:52.303415Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page
 of setpriority().
2021-12-15T14:30:52.314786Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2021-12-15T14:30:52.315328Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2021-12-15T14:30:52.362698Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes
2021-12-15T14:30:52.366404Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-12-15T14:30:52.366464Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-12-15T14:30:52.459383Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-12-15T14:30:52.460078Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2021-12-15T14:30:52.460090Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2021-12-15T14:30:52.460431Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.35-38 started; log sequence number 1216575
2021-12-15T14:30:52.460695Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-12-15T14:30:52.460738Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2021-12-15T14:30:52.460845Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2021-12-15T14:30:52.461219Z 0 [Note] InnoDB: Buffer pool(s) load completed at 211215 15:30:52
2021-12-15T14:30:52.489584Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-12-15T14:30:52.500386Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2021-12-15T14:30:52.500401Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2021-12-15T14:30:52.500406Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2021-12-15T14:30:52.500410Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2021-12-15T14:30:52.500951Z 0 [Warning] CA certificate ca.pem is self signed.
2021-12-15T14:30:52.500982Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2021-12-15T14:30:52.501046Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-12-15T14:30:52.501137Z 0 [Note] IPv6 is available.
2021-12-15T14:30:52.501144Z 0 [Note]   - '::' resolves to '::';
2021-12-15T14:30:52.501166Z 0 [Note] Server socket created on IP: '::'.
2021-12-15T14:30:52.501882Z 0 [Warning] Failed to open optimizer cost constant tables

2021-12-15T14:30:52.501989Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2021-12-15T14:30:52.502004Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2021-12-15T14:30:52.502038Z 0 [ERROR] Aborting

2021-12-15T14:30:52.502043Z 0 [Note] Giving 2 client threads a chance to die gracefully
2021-12-15T14:30:54.502296Z 0 [Note] WSREP: Closing send monitor...
2021-12-15T14:30:54.502443Z 0 [Note] WSREP: Closed send monitor.
2021-12-15T14:30:54.502378Z 2 [Note] WSREP: rollbacker thread exiting
2021-12-15T14:30:54.502508Z 0 [Note] WSREP: gcomm: terminating thread
2021-12-15T14:30:54.502641Z 0 [Note] WSREP: gcomm: joining thread
2021-12-15T14:30:54.502803Z 0 [Note] WSREP: gcomm: closing backend
2021-12-15T14:30:54.502829Z 0 [Note] WSREP: Current view of cluster as seen by this node
view ((empty))
2021-12-15T14:30:54.502922Z 0 [Note] WSREP: gcomm: closed
2021-12-15T14:30:54.502944Z 0 [Note] WSREP: Received self-leave message.
2021-12-15T14:30:54.502962Z 0 [Note] WSREP: Flow-control interval: [0, 0]
2021-12-15T14:30:54.502967Z 0 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2021-12-15T14:30:54.502971Z 0 [Note] WSREP: Shifting SYNCED -> CLOSED (TO: 0)
2021-12-15T14:30:54.502978Z 0 [Note] WSREP: RECV thread exiting 0: Success
2021-12-15T14:30:54.503007Z 0 [Note] WSREP: recv_thread() joined.
2021-12-15T14:30:54.503011Z 0 [Note] WSREP: Closing replication queue.
2021-12-15T14:30:54.503014Z 0 [Note] WSREP: Closing slave action queue.
2021-12-15T14:30:54.503017Z 0 [Note] WSREP: Waiting for active wsrep applier to exit
2021-12-15T14:30:54.513510Z 1 [Note] WSREP: Initialized wsrep sidno 2
2021-12-15T14:30:54.513525Z 1 [Note] WSREP: Auto Increment Offset/Increment re-align with cluster membership change (Offset: 1 -> 1) (Increment: 1 ->
1)
2021-12-15T14:30:54.513560Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-12-15T14:30:54.513594Z 1 [Note] WSREP: Assign initial position for certification: 0, protocol version: 4
2021-12-15T14:30:54.513612Z 0 [Note] WSREP: Service thread queue flushed.
2021-12-15T14:30:54.522182Z 1 [Note] WSREP: Synchronized with group, ready for connections
2021-12-15T14:30:54.522201Z 1 [Note] WSREP: Setting wsrep_ready to true
2021-12-15T14:30:54.522207Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-12-15T14:30:54.522224Z 1 [Note] WSREP: New cluster view: global state: db8faa27-5cf8-11ec-8b52-fe24c2e2fe75:0, view# -1: non-Primary, number of n
odes: 0, my index: -1, protocol version 3
2021-12-15T14:30:54.522229Z 1 [Note] WSREP: Setting wsrep_ready to false
2021-12-15T14:30:54.522233Z 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2021-12-15T14:30:54.530387Z 1 [Note] WSREP: applier thread exiting (code:0)
2021-12-15T14:30:54.530506Z 0 [Note] WSREP: Service disconnected.
2021-12-15T14:30:54.530511Z 0 [Note] WSREP: Waiting to close threads......
2021-12-15T14:30:59.530655Z 0 [Note] WSREP: Some threads may fail to exit.
2021-12-15T14:30:59.535665Z 0 [Note] WSREP: Service thread queue flushed.
2021-12-15T14:30:59.535750Z 0 [Note] WSREP: MemPool(SlaveTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0
2021-12-15T14:30:59.539159Z 0 [Note] Binlog end
2021-12-15T14:30:59.547704Z 0 [Note] Shutting down plugin 'ngram'
2021-12-15T14:30:59.547718Z 0 [Note] Shutting down plugin 'partition'
2021-12-15T14:30:59.547721Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-12-15T14:30:59.547724Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-12-15T14:30:59.547726Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-12-15T14:30:59.547729Z 0 [Note] Shutting down plugin 'MyISAM'
2021-12-15T14:30:59.547737Z 0 [Note] Shutting down plugin 'INNODB_TABLESPACES_SCRUBBING'
2021-12-15T14:30:59.547739Z 0 [Note] Shutting down plugin 'INNODB_TABLESPACES_ENCRYPTION'
2021-12-15T14:30:59.547741Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2021-12-15T14:30:59.547743Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
2021-12-15T14:30:59.547745Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-12-15T14:30:59.547754Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-12-15T14:30:59.547756Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-12-15T14:30:59.547758Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-12-15T14:30:59.547760Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-12-15T14:30:59.547762Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-12-15T14:30:59.547763Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-12-15T14:30:59.547765Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-12-15T14:30:59.547767Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-12-15T14:30:59.547769Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-12-15T14:30:59.547771Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-12-15T14:30:59.547773Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-12-15T14:30:59.547775Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-12-15T14:30:59.547777Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-12-15T14:30:59.547778Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-12-15T14:30:59.547780Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-12-15T14:30:59.547782Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-12-15T14:30:59.547784Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-12-15T14:30:59.547786Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-12-15T14:30:59.547788Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-12-15T14:30:59.547790Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-12-15T14:30:59.547792Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-12-15T14:30:59.547793Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-12-15T14:30:59.547795Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-12-15T14:30:59.547797Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-12-15T14:30:59.547800Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2021-12-15T14:30:59.547802Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2021-12-15T14:30:59.547803Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2021-12-15T14:30:59.547805Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2021-12-15T14:30:59.547807Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS'
2021-12-15T14:30:59.547809Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT'
2021-12-15T14:30:59.547811Z 0 [Note] Shutting down plugin 'XTRADB_RSEG'
2021-12-15T14:30:59.547813Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
2021-12-15T14:30:59.547815Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
2021-12-15T14:30:59.547817Z 0 [Note] Shutting down plugin 'InnoDB'
2021-12-15T14:30:59.547867Z 0 [Note] InnoDB: FTS optimize thread exiting.
2021-12-15T14:30:59.547961Z 0 [Note] InnoDB: Starting shutdown...
2021-12-15T14:30:59.648361Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2021-12-15T14:30:59.648552Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 211215 15:30:59
2021-12-15T14:31:00.649944Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2021-12-15T14:31:01.977743Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1216766
2021-12-15T14:31:01.979471Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-12-15T14:31:01.979497Z 0 [Note] Shutting down plugin 'MEMORY'
2021-12-15T14:31:01.979504Z 0 [Note] Shutting down plugin 'CSV'
2021-12-15T14:31:01.979508Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-12-15T14:31:01.979574Z 0 [Note] Shutting down plugin 'sha256_password'
2021-12-15T14:31:01.979579Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-12-15T14:31:01.979582Z 0 [Note] Shutting down plugin 'wsrep'
2021-12-15T14:31:01.979766Z 0 [Note] Shutting down plugin 'binlog'
2021-12-15T14:31:01.979942Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

Maybe i have to remove all the files info in /var/lib/mysql before reinstall mysql ?

EDIT: i uninstalled, purged, removed all the files in /var/lib/mysql, then reinstalled percona, same error

I was expecting that the instalation finish with no error and mysql start as single node/mysql server but this is not the case

Claudio

1 Like

the problem seems this

2021-12-16T14:13:33.858029Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2021-12-16T14:13:33.858036Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2021-12-16T14:13:33.858057Z 0 [ERROR] Aborting

infact in /var/lib/mysql there is not a mysql directory with the user table files

so during installation it would be create, right ?

this is the list of the /var/lib/mysql directory

root@XXXXX:/var/lib/mysql# ll
total 241736
drwx------ 4 mysql mysql 4096 Dec 16 15:13 ./
drwxr-xr-x 47 root root 4096 Dec 16 15:12 …/
-rw-r----- 1 mysql mysql 56 Dec 16 15:13 auto.cnf
drwxr-xr-x 2 mysql mysql 6 Dec 16 14:20 binarylogs/
-rw------- 1 mysql mysql 1680 Dec 16 15:13 ca-key.pem
-rw-r–r-- 1 mysql mysql 1120 Dec 16 15:13 ca.pem
-rw-r–r-- 1 mysql mysql 1120 Dec 16 15:13 client-cert.pem
-rw------- 1 mysql mysql 1676 Dec 16 15:13 client-key.pem
drwxr-xr-x 2 mysql mysql 6 Dec 15 15:48 db/
-rw-r----- 1 mysql mysql 134219048 Dec 16 15:13 galera.cache
-rw-r----- 1 mysql mysql 113 Dec 16 15:13 grastate.dat
-rw-r----- 1 mysql mysql 221 Dec 16 15:13 ib_buffer_pool
-rw-r----- 1 mysql mysql 12582912 Dec 16 15:13 ibdata1
-rw-r----- 1 mysql mysql 50331648 Dec 16 15:13 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 Dec 16 15:13 ib_logfile1
-rw-rw---- 1 root root 6 Dec 16 15:13 mysqld_safe.pid
-rw-r----- 1 mysql mysql 177 Dec 16 15:13 percona3-lnf-bin.000001
-rw-r----- 1 mysql mysql 26 Dec 16 15:13 percona3-lnf-bin.index
-rw------- 1 mysql mysql 1676 Dec 16 15:13 private_key.pem
-rw-r–r-- 1 mysql mysql 452 Dec 16 15:13 public_key.pem
-rw-r–r-- 1 mysql mysql 1120 Dec 16 15:13 server-cert.pem
-rw------- 1 mysql mysql 1676 Dec 16 15:13 server-key.pem

the db and binarylogs directories will be used in when i will configure the cluster, the first will keep the db files, the second the binarylogs, but for now they are not used

Claudio

1 Like

I didn’t write this, i used the percona-release_latest.generic_all.deb package how in the guide, maybe is this the problem ?

Someone has any hint ?

Claudio

Does someone know a way to check what the installation script does ?

Where do i find the installation script for percona-xtradb-cluster-57 ?

I suspect something is wrong in the installation script or in my ubuntu installation.

Thanks in advance
Claudio

No one can give some hints ?

I’m stuck with the installation of this Percona XtraDB Cluster on 3 Ubuntu LTS 20.04 nodes

Claudio

1 Like

Hi @soprano
I tried to reproduce your issue but without any success,
I am able to install PXC-5.7 on Ubuntu without any issues.
Here is the detailed installation instruction Installing Percona XtraDB Cluster on Debian or Ubuntu - Percona XtraDB Cluster
And it should work.
I followed it and was able to install PXC correctly

1 Like

I found why it gives errors.

I have the /var/lib/mysql

but inside it i have two directories:

db
binarylogs

both are on another disk, different volume group, different logical volumes, both are owned by mysql:mysql

/etc/fstab
/dev/mysql/db   /var/lib/mysql/db       xfs     defaults        0       1
/dev/mysql/binarylogs   /var/lib/mysql/binarylogs       xfs     defaults        0       2
ll /var/lib/mysql
total 241736
drwxr-x---  4 mysql mysql      4096 Jan  3 12:06 ./
drwxr-xr-x 48 root  root       4096 Jan  3 12:06 ../
-rw-r-----  1 mysql mysql        56 Jan  3 12:06 auto.cnf
drwxr-xr-x  2 mysql mysql         6 Jan  3 11:47 binarylogs/
-rw-------  1 mysql mysql      1680 Jan  3 12:06 ca-key.pem
-rw-r--r--  1 mysql mysql      1120 Jan  3 12:06 ca.pem
-rw-r--r--  1 mysql mysql      1120 Jan  3 12:06 client-cert.pem
-rw-------  1 mysql mysql      1680 Jan  3 12:06 client-key.pem
drwxr-xr-x  2 mysql mysql         6 Jan  3 11:47 db/
-rw-r-----  1 mysql mysql 134219048 Jan  3 12:06 galera.cache
-rw-r-----  1 mysql mysql       113 Jan  3 12:06 grastate.dat
-rw-r-----  1 mysql mysql       221 Jan  3 12:06 ib_buffer_pool
-rw-r-----  1 mysql mysql  12582912 Jan  3 12:06 ibdata1
-rw-r-----  1 mysql mysql  50331648 Jan  3 12:06 ib_logfile0
-rw-r-----  1 mysql mysql  50331648 Jan  3 12:06 ib_logfile1
-rw-rw----  1 root  root          6 Jan  3 12:06 mysqld_safe.pid
-rw-r-----  1 mysql mysql       177 Jan  3 12:06 percona1-lnf-bin.000001
-rw-r-----  1 mysql mysql        26 Jan  3 12:06 percona1-lnf-bin.index
-rw-------  1 mysql mysql      1676 Jan  3 12:06 private_key.pem
-rw-r--r--  1 mysql mysql       452 Jan  3 12:06 public_key.pem
-rw-r--r--  1 mysql mysql      1120 Jan  3 12:06 server-cert.pem
-rw-------  1 mysql mysql      1680 Jan  3 12:06 server-key.pem

if i umount both these directories and install percona all is ok.

while if i mount these directories the installation fails

You can reproduce this error, i suppose something in the installation try to removes all the files in the /var/lib/mysql but fails (it is not possible to remove directories mounted on other disks).

I use these directories, because i set

  • the DB dir to /var/lib/mysql/db
  • the binarylogs to /var/lib/mysql/binarylogs
  • the relaylogs to /var/lib/mysql/relaylogs (if i have slaves)
    i have to do so, because if db are in /var/lib/mysql directory and binarylogs/relaylogs inside it then SST will not work if the node goes down, because the binarylogs directory will be deleted before SST begins.

How can i solve this ?

Let me know if you need other infos.

1 Like

I’m new to proxysql. I’ve installed proxysql on one server and configured 2 nodes in it in mysql_servers.
proxysql is up and running but when I’m connecting to 6033 port with sbuser which I created under the mysql_users table, it is throwing access denied error.

[root@server19 proxysql]# mysql -u sbuser -psbpass -h 127.0.0.1 -P6033
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)

Where should I debug?

1 Like

Ok i solved modifyng the file

/etc/mysql/percona-xtradb-cluster.conf.d/mysqld.cnf
..
datadir=/var/lib/mysql/db
..

in this way the percona installation will finish good using apt install --fix-broken

So the problem is with mountpoints and FS mounted under /var/lib/mysql/

I suppose because during the first start of mysql, the /var/lib/mysql directory is erased to prevent bogus files and in my case it is not possible (for the mountpoints linked to different volume FS)

Claudio

1 Like

You need to post this problem to a new topic else it will not be visible for that it is.

Claudio

1 Like

ok. But I’ve installed proxysql manually using rpm of proxysql.

1 Like

Repeat,

it’s better to open a new topic and not to write on this one, this is about Percona xtradb cluster 57 installation and configuration problems and not proxysql.

If you open a new topic you will get better support.

If you are trying to connect proxysql to a Percona Xtradb Cluster 57, you can write in this forum section else you will have to choose the right forum section, anyway a new topic is always a better solution for different problems on different products.

1 Like

yeah got that. I just wrote to inform you.
Already opened a new topic on this.

Thank you so much.

1 Like

Perfect.

You will get support as soon as someone knows how to help you

1 Like