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:
-- 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?