Results 1 to 2 of 2

Thread: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log...

  1. #1

    Question Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log...

    Big problem, installed Zabbix, working prefectly, saved VHDs, converted the Server to my Development Desktop, change my old Desktop to the server, installed XCP-ng, attached the VHD's and now i get this regarding mysql:

    Code:
    -- Unit mariadb.service has begun starting up. 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.5-MariaDB) starting as process 2331 ... 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32184) 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [Note] InnoDB: Using Linux native AIO 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [Note] InnoDB: Uses event mutexes 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [Note] InnoDB: Number of pools: 1 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [Note] InnoDB: Using SSE4.2 crc32 instructions 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts) 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [Note] InnoDB: Completed initialization of buffer pool 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setp> 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=238734461 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log. 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Page [page id: space=83, page number=1] log sequence number 238749447 is in the future! Current system log seque> 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing> 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=83, page number=3269] 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption. 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=83, page number=3269] 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption. 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=83, page number=3269] 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption. 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=84, page number=2164] 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption. 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=84, page number=2164] 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption. 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=84, page number=2164] 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption. 
    Sep 21 11:31:43 Zabbix mariadbd[2331]: 2020-09-21 11:31:43 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption 
    Sep 21 11:31:44 Zabbix mariadbd[2331]: 2020-09-21 11:31:44 0 [Note] InnoDB: Starting shutdown... 
    Sep 21 11:31:44 Zabbix mariadbd[2331]: 2020-09-21 11:31:44 0 [ERROR] Plugin 'InnoDB' init function returned error. 
    Sep 21 11:31:44 Zabbix mariadbd[2331]: 2020-09-21 11:31:44 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 
    Sep 21 11:31:44 Zabbix mariadbd[2331]: 2020-09-21 11:31:44 0 [Note] Plugin 'FEEDBACK' is disabled. 
    Sep 21 11:31:44 Zabbix mariadbd[2331]: 2020-09-21 11:31:44 0 [ERROR] Unknown/unsupported storage engine: InnoDB 
    Sep 21 11:31:44 Zabbix mariadbd[2331]: 2020-09-21 11:31:44 0 [ERROR] Aborting 
    Sep 21 11:31:44 Zabbix systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE 
    Sep 21 11:31:44 Zabbix systemd[1]: Failed to start MariaDB 10.5.5 database server. 
    -- Subject: Unit mariadb.service has failed 
    -- Defined-By: systemd 
    -- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel 
    --  
    -- Unit mariadb.service has failed. 
    --  
    -- The result is failed. 
    Sep 21 11:31:44 Zabbix systemd[1]: mariadb.service: Unit entered failed state.
    So, 1) could this be fixed, 2) if not, how can I remove and clean zabbix and mysql database, folders and reinstall with no remnants of these packages?

  2. #2

    Default Re: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log

    Well for the removing part I'll follow this: How to uninstall MySQL.

Posting Permissions

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