Results 1 to 3 of 3

Thread: Can't start MySQL after upgrade from 12.3 to 13.1

  1. #1

    Default Can't start MySQL after upgrade from 12.3 to 13.1

    Hi all,

    I upgraded from 12.3 to 13.1 from here:

    How To Upgrade From openSUSE 12.3 To openSUSE 13.1 | Unixmen

    And the problem I have now when I try to run mysql

    Code:
    rcmysql start
    I get this error:

    Code:
    redirecting to systemctl restart mysql
    Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.
    And executing "systemctl status mysql.service" it says this:

    Code:
    mysql.service - LSB: Start the MySQL database server   Loaded: loaded (/etc/init.d/mysql)
       Active: failed (Result: exit-code) since Mon 2013-12-09 19:50:14 CET; 11min ago
      Process: 4086 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
    
    
    Dec 09 19:50:14 linux-2guy.site systemd[1]: Starting LSB: Start the MySQL database server...
    Dec 09 19:50:14 linux-2guy.site mysql[4086]: You are upgrading from different stable version of MySQL!
    Dec 09 19:50:14 linux-2guy.site systemd[1]: mysql.service: control process exited, code=exited status=1
    Dec 09 19:50:14 linux-2guy.site systemd[1]: Failed to start LSB: Start the MySQL database server.
    Dec 09 19:50:14 linux-2guy.site systemd[1]: Unit mysql.service entered failed state.
    I don't know how to resolve this. Maybe I shouldn't have updated in this way, by it's done. Anyone knows is there is a solution?

    Thanks.

  2. #2

    Default Re: Can't start MySQL after upgrade from 12.3 to 13.1

    Quote Originally Posted by Evansly View Post
    I don't know how to resolve this. Maybe I shouldn't have updated in this way, by it's done. Anyone knows is there is a solution?
    Apparently there's an issue in MySQL's upgrade process.
    Remove the file /var/lib/mysql/.run-mysql_upgrade and it should start, this worked fine for me at least.

    Or uninstall "mysql-community-server", YaST/zypper should then automatically install "mariadb" instead (a drop-in replacement by MySQL's original developer, which is now default on openSUSE since 12.3 already). This should also just work.

  3. #3

    Default Re: Can't start MySQL after upgrade from 12.3 to 13.1

    Quote Originally Posted by wolfi323 View Post
    Apparently there's an issue in MySQL's upgrade process.
    Remove the file /var/lib/mysql/.run-mysql_upgrade and it should start, this worked fine for me at least.

    Or uninstall mysql-community-server, YaST/zypper should then automatically install MariaDB instead (a drop-in replacement by MySQL's original developer, which is now default on openSUSE). This should also just work.
    The first solution worked for me. Thank you very much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •