Articles in this section

MariaDB cannot start on Plesk server: redo log file exists

Yevgeniy Shimanskiy
Updated
Plesk for Linux kb: technical

Applicable to:

  • Plesk for Linux

Symptoms

  • MariaDB server cannot start.

  • The following error is found in /var/log/mariadb/mariadb.log:

    [ERROR] InnoDB: redo log file './ib_logfile1' exists. Creating system tablespace with existing redo log files is not recommended. Please delete all redo log files before creating new system tablespace.

Cause

Obsolete redo log file preventing MariaDB from operating correctly.

Resolution

  1. Connect to the server via SSH.

  2. Move the ib_logfile files from /var/lib/mysql:

    # mv /var/lib/mysql/ib_logfile* /root/

  3. Start MariaDB:

    # systemctl start mariadb

Was this article helpful?

Comments

1 comment
Date Votes
  • Avatar
    Daniel Black

    This should be clearer. This error will only occur if this is attempting a new database installation. A more complete advice would the to backup the entire /var/lib/mysql rather than just the redo logs.

    0

Please sign in to leave a comment.