User Tools

Site Tools


maintenance:general:tools:table_renew.pl

Error 1168 SQL MERGE non-MyISAM type

When importing a database from another server with a different MariaDB version, it could happen the MERGE engine fails and therefore the task_log, action_log, node_log and job_log aren't shown from the GUI.

Looking at the different tables manually, (ending in 'quarter' or 'all') the following error is shown:

10:30:58	Error loading schema content	Error Code: 1168 Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist	
NOTE: mysql_repair.sh isn't able to fix this issue.

The process to restore this has been automated into 4 steps. Depending on the size of the database, this might take a while.

  1. table_renew.pl LOGS; will dump all tables to disk, drops the tables and restores them for the LOGS database.
  2. table_renew.pl NCCM; will dump all tables to disk, drops the tables and restores them for the NCCM database.
  3. logs_daily.pl; will create the merge for the LOGS database.
  4. nccm_daily.pl; will create the merge for the NCCM database.

Once these steps have been executed all logs are visible again. Since no data could be written to the database in the meantime, only the data from the backup is presented. From this point on, data can be stored in the databases once again.

LDAP: couldn't connect to LDAP server
maintenance/general/tools/table_renew.pl.txt · Last modified: 2019/12/30 10:46 by bdorlandt