Skip to main content

Mysql Failed during Upgrade

Sarfraz ahmad
Hi, I was trying to upgrade MySQL of my server. When i started upgradation it fails and disabled the MySQL and now showing following errors when i again try to upgrade it. Starting process with log file at /var/cpanel/logs/mysql_upgrade.20211005-174828/unattended_upgrade.log Beginning "MySQL 5.7" upgrade... Obtained version information from system. (XID 4z8f6h) The system failed to connect to the "MySQL" database "mysql" because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)) Ensuring the "Mysql57" repository is available and working. distro does not use package modules; ignoring request to disable mysql distro does not use package modules; ignoring request to disable mariadb checkyum version 22.3 Ensuring that the package "coreutils" is available. The package "coreutils" with version matching "" is already installed. Ensuring that the package "grep" is available. The package "grep" with version matching "" is already installed. Ensuring that the package "mysql-community-devel" with version matching "5.7" is available. Restarting mysql service. (XID y7frkz) The "mysql" service is disabled. The system was not able to ensure the availability of the "mysql-community-devel" package: (XID xcs697) "/usr/bin/yum" reported error code "1" when it ended:

Comments

4 comments

Date Votes
  • cPRex Jurassic Moderator
    Hey there! I would start by checking your server's repositories in /etc/resolv.conf. You can comment out any existing nameserver entries there, and replace them with Google's public repositories to see if that allows you to connect to the repos properly: nameserver 8.8.8.8 nameserver 8.8.4.4
    There may be other issues as well, but that is the first thing I would check for this particular issue.
    0
  • Sarfraz ahmad
    Hey there! I would start by checking your server's repositories in /etc/resolv.conf. You can comment out any existing nameserver entries there, and replace them with Google's public repositories to see if that allows you to connect to the repos properly: nameserver 8.8.8.8 nameserver 8.8.4.4
    There may be other issues as well, but that is the first thing I would check for this particular issue.

    nameserver 127.0.0.1 nameserver 213.51.48.74 search ovh These are the existing entries. I have replaced them with nameserver 8.8.8.8 nameserver 8.8.4.4 but there is same issue
    0
  • cPRex Jurassic Moderator
    Thanks for the additional details. With everything involved with MySQL and the potential for data loss, it would be best to open a ticket with our support team so we can check the system directly and see what is happening. If you are able to do that, please post the ticket number here so I can follow along and keep this thread updated with our findings.
    0
  • Sarfraz ahmad
    Thanks for the additional details. With everything involved with MySQL and the potential for data loss, it would be best to open a ticket with our support team so we can check the system directly and see what is happening. If you are able to do that, please post the ticket number here so I can follow along and keep this thread updated with our findings.

    here is the error when i again try to upgrade it. Starting process with log file at /var/cpanel/logs/mysql_upgrade.20211005-182915/unattended_upgrade.log Beginning "MySQL 5.7" upgrade... Obtained version information from system. (XID 7akssm) The system failed to connect to the "MySQL" database "mysql" because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)) Ensuring the "Mysql57" repository is available and working. distro does not use package modules; ignoring request to disable mysql distro does not use package modules; ignoring request to disable mariadb checkyum version 22.3 Ensuring that the package "coreutils" is available. The package "coreutils" with version matching "" is already installed. Ensuring that the package "grep" is available. The package "grep" with version matching "" is already installed. Ensuring that the package "mysql-community-devel" with version matching "5.7" is available. Restarting mysql service. (XID 2htc34) The "mysql" service is disabled. The system was not able to ensure the availability of the "mysql-community-devel" package: (XID 957jge) "/usr/bin/yum" reported error code "1" when it ended:
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post