[#MDEV-26058] Instalação MariaDB-Server 10.4

[MDEV-26058] Instalação MariaDB-Server 10.4–10.6 Created: 2021-06-30 Updated: 2021-07-17 Resolved: 2021-07-17
Status:	Closed
Project:	MariaDB Server
Component/s:	Server
Affects Version/s:	10.6.2, 10.4.20, 10.5.11
Fix Version/s:	N/A

Type:

Bug

Priority:

Major

Reporter:

Rodrigo Camargo dos Santos

Assignee:

Daniel Black

Resolution:

Duplicate

Votes:

Labels:

crash, server

Environment:

$ uname -a
Linux srv-001378 3.10.0-1160.31.1.el7.ppc64 #1 SMP Wed Jun 9 16:39:35 UTC 2021 ppc64 ppc64 ppc64 GNU/Linux

$ lscpu
Architecture: ppc64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Big Endian
CPU(s): 56
On-line CPU(s) list: 0-55
Thread(s) per core: 4
Core(s) per socket: 1
Socket(s): 14
NUMA node(s): 4
Model: 2.1 (pvr 004a 0201)
Model name: POWER7 (architected), altivec supported
Hypervisor vendor: pHyp
Virtualization type: para
L1d cache: 32K
L1i cache: 32K
NUMA node0 CPU(s): 24-27,40-43
NUMA node1 CPU(s): 28-31,44-47
NUMA node2 CPU(s): 32-35,48-51
NUMA node3 CPU(s): 0-23,36-39,52-55

$ lsblk -a
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sda 8:0 0 350G 0 disk
├─sda1 8:1 0 4M 0 part
├─sda2 8:2 0 1G 0 part /boot
└─sda3 8:3 0 349G 0 part
├─centos-root 253:0 0 300G 0 lvm /
└─centos-swap 253:1 0 4G 0 lvm [SWAP]
sr0 11:0 1 1024M 0 rom
sr1 11:1 1 1024M 0 rom

$ free -lht
total used free shared buff/cache available
Mem: 107G 1,2G 105G 38M 1,3G 104G
Low: 107G 2,5G 105G
High: 0B 0B 0B
Swap: 4,0G 0B 4,0G
Total: 111G 1,2G 109G

$ sudo cat /proc/cpuinfo
processor : 0
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 1
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 2
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 3
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 4
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 5
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 6
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 7
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 8
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 9
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 10
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 11
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 12
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 13
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 14
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 15
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 16
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 17
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 18
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 19
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 20
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 21
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 22
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 23
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 24
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 25
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 26
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 27
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 28
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 29
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 30
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 31
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 32
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 33
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 34
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 35
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 36
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 37
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 38
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 39
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 40
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 41
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 42
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 43
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 44
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 45
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 46
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 47
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 48
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 49
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 50
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 51
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 52
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 53
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 54
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

processor : 55
cpu : POWER7 (architected), altivec supported
clock : 3612.000000MHz
revision : 2.1 (pvr 004a 0201)

timebase : 512000000
platform : pSeries
model : IBM,7895-43X
machine : CHRP IBM,7895-43X

Attachments:

mariadb10.4.20.err

Issue Links:

Duplicate
duplicates	~~MDEV-26060~~	Instalação MariaDB-Server 10.5	Closed
duplicates	~~MDEV-26072~~	Instalação MariaDB-Server 10.6	Closed
is duplicated by	MDEV-26056	crc32vpm detection on Power7 incorrec...	Open

Description

No momento do comando `sudo systemctl start mariadb`, ele retornou o seguinte erro, o conteúdo está em `mariadb10.4.20.err`.

Observação: selinux está desabilitado.

Procedimentos:

cat <<EOF | sudo tee /etc/yum.repos.d/MariaDB.repo

# MariaDB 10.4 CentOS repository list - created 2021-06-30 20:12 UTC

# https://mariadb.org/download/

[mariadb]

name = MariaDB

baseurl = http://nyc2.mirrors.digitalocean.com/mariadb/yum/10.4/centos7-ppc64

gpgkey=http://nyc2.mirrors.digitalocean.com/mariadb/yum/RPM-GPG-KEY-MariaDB

gpgcheck=1

EOF

sudo rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

sudo yum install MariaDB-server MariaDB-client galera-4 rsync

sudo systemctl start mariadb

Comments

Comment by Sergei Golubchik [ 2021-07-17 ]

As danblack explained in a comment for ~~MDEV-26072~~, InnoDB fails to start because it expects a VSX capability in all POWER builds.Will be fixed in the scope of MDEV-26056.

Generated at Thu Feb 08 09:42:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.

[MDEV-26058] Instalação MariaDB-Server 10.4–10.6 Created: 2021-06-30 Updated: 2021-07-17 Resolved: 2021-07-17