The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

old databases, after crash

Discussion in 'Data Protection' started by stefanbc, May 5, 2016.

  1. stefanbc

    stefanbc Well-Known Member

    Joined:
    Apr 13, 2015
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    toronto
    cPanel Access Level:
    Root Administrator
    Hi,

    Recently our server went out of space and services started to fail. The hosting company deleted some local backups in order to free up some space but when we started looking at the sites the databases were ~2 old.

    From my discussions INNODB was corrupted and unless there was an automatic restore to an older backup I am not sure what happened. Server admins said they did not do a restore.

    Also want to say that some cache files on server had the correct information but the databases had old data(we use some file based caching for some resources so we don't query the databases)

    Here is what I got from them.

    160503 3:16:32 [Note] /usr/libexec/mysqld: Shutdown complete’
    160503 03:16:32 mysqld_safe WSREP: Failed to recover position: ‘160503 3:16:30 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    160503 03:16:29 mysqld_safe WSREP: Running position recovery with —log_error=’/var/lib/mysql/wsrep_recovery.hcpSre’ —pid-file=‘/var/lib/mysql/server.xxxx.com-recover.pid’
    160503 03:16:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    160503 3:16:24 [Note] /usr/libexec/mysqld: Shutdown complete’
    160503 03:16:24 mysqld_safe WSREP: Failed to recover position: ‘160503 3:16:22 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    160503 03:16:21 mysqld_safe WSREP: Running position recovery with —log_error=’/var/lib/mysql/wsrep_recovery.lzqewX’ —pid-file=‘/var/lib/mysql/server.xxxx.com-recover.pid’
    160503 03:16:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    160503 3:16:16 [Note] /usr/libexec/mysqld: Shutdown complete’

    Can anyone help me figure out what happened?


    Thank you
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page