Author Topic: Started getting MySQL (database) errors. Tried updating via yum but errors  (Read 406 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
I started getting many database errors. When I log in Centos Web Panel, I got this message: "MySQL bad configuration detected, check from the console by using mysql command !!!"

I checked and their were updates (I have the Paid/Pro version of centos). I tried but it didn't work, so I manually went into SSL and did tied.

When I do yum update, I get these errors:
Code: [Select]
"Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
MariaDB-client-10.3.39-1.el7.c FAILED
http://yum.mariadb.org/10.3/centos7-amd64/rpms/MariaDB-client-10.3.39-1.el7.cent                                                                                                             os.x86_64.rpm: [Errno 14] HTTP Error 404 - Not Found
Trying other mirror.
MariaDB-common-10.3.39-1.el7.c FAILED
http://yum.mariadb.org/10.3/centos7-amd64/rpms/MariaDB-common-10.3.39-1.el7.cent                                                                                                             os.x86_64.rpm: [Errno 14] HTTP Error 404 - Not Found
Trying other mirror.
MariaDB-compat-10.3.39-1.el7.c FAILED
http://yum.mariadb.org/10.3/centos7-amd64/rpms/MariaDB-compat-10.3.39-1.el7.cent                                                                                                             os.x86_64.rpm: [Errno 14] HTTP Error 404 - Not Found
Trying other mirror.
MariaDB-devel-10.3.39-1.el7.ce FAILED
http://yum.mariadb.org/10.3/centos7-amd64/rpms/MariaDB-devel-10.3.39-1.el7.cento                                                                                                             s.x86_64.rpm: [Errno 14] HTTP Error 404 - Not Found
Trying other mirror.
MariaDB-server-10.3.39-1.el7.c FAILED
http://yum.mariadb.org/10.3/centos7-amd64/rpms/MariaDB-server-10.3.39-1.el7.cent                                                                                                             os.x86_64.rpm: [Errno 14] HTTP Error 404 - Not Found
Trying other mirror.
MariaDB-shared-10.3.39-1.el7.c FAILED
http://yum.mariadb.org/10.3/centos7-amd64/rpms/MariaDB-shared-10.3.39-1.el7.cent                                                                                                             os.x86_64.rpm: [Errno 14] HTTP Error 404 - Not Found
Trying other mirror.


Error downloading packages:
  MariaDB-devel-10.3.39-1.el7.centos.x86_64: [Errno 256] No more mirrors to try.
  MariaDB-server-10.3.39-1.el7.centos.x86_64: [Errno 256] No more mirrors to try                                                                                                             .
  MariaDB-common-10.3.39-1.el7.centos.x86_64: [Errno 256] No more mirrors to try                                                                                                             .
  MariaDB-client-10.3.39-1.el7.centos.x86_64: [Errno 256] No more mirrors to try                                                                                                             .
  MariaDB-shared-10.3.39-1.el7.centos.x86_64: [Errno 256] No more mirrors to try                                                                                                             .
  MariaDB-compat-10.3.39-1.el7.centos.x86_64: [Errno 256] No more mirrors to try "
.

What to do?? This is a main website of a client and I don't wanna mess anything up.

Offline
*
Ok, this is what I did. In mariadb.repo, I changed one point

This was my old one:

Code: [Select]
# MariaDB 10.2 CentOS repository list - created 2019-07-03 08:40 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
enabled=1

I changed the 10.3 to 10.4 and then I did a "yum update"

It is updating.. will let you know if it solved the issues

Offline
*
Ok, it did update and now when I log in Centos Web Panel, I am NOT getting the error "MySQL bad configuration detected, check from the console by using mysql command" so this is good, right?

Also, the CPU usage seems to be VERY high.. any suggestions?

edit: still getting frequent database errors on website :(
« Last Edit: March 23, 2024, 09:09:45 PM by hdaackda »

Offline
****
You should be at MariaDB 10.4 as a bare minimum. 10.6 would be better, 10.11 (LTS) would be ideal.
What is spiking your CPU? Are you watching processes with htop?