Any database table that is missing from LogLogic LMI has potential to cause an LMI backup to fail. The table could be missing simply due to it accidentally being deleted during troubleshooting or something similar. In the event that your appliance is missing the statDisk15min table, or the 1 or 5 min variations of it, then the LMI backup can fail with the following error in /loglogic/backup_prep/status_files:

ERROR: Query failure: Table 'logapprtrpt.statDisk15min' doesn't exist

1. SSH to the appliance and log in as ”toor”.

 2. Run this command:

$ mysql logapprtrpt

3. Copy and paste one or more of the following three CREATE TABLE statements individually based on the table(s) referenced in the error message. If more than one is missing then press Enter after each one to execute them as separate statements. Only one missing table may be detected at a time so you can execute show tables; to confirm which ones exist. There should be a stDisk1min, statDisk5min and statDisk15min.

CREATE TABLE `statDisk15min` (

  `time` int(10) unsigned NOT NULL default '0',

  `total` int(10) unsigned NOT NULL default '0',

  `reads` int(10) unsigned NOT NULL default '0',

  `readBlks` int(10) unsigned NOT NULL default '0',

  `writes` int(10) unsigned NOT NULL default '0',

  `writeBlks` int(10) unsigned NOT NULL default '0',

  PRIMARY KEY  (`time`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `statDisk1min` (

  `time` int(10) unsigned NOT NULL default '0',

  `total` int(10) unsigned NOT NULL default '0',

  `reads` int(10) unsigned NOT NULL default '0',

  `readBlks` int(10) unsigned NOT NULL default '0',

  `writes` int(10) unsigned NOT NULL default '0',

  `writeBlks` int(10) unsigned NOT NULL default '0',

  PRIMARY KEY  (`time`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `statDisk5min` (

  `time` int(10) unsigned NOT NULL default '0',

  `total` int(10) unsigned NOT NULL default '0',

  `reads` int(10) unsigned NOT NULL default '0',

  `readBlks` int(10) unsigned NOT NULL default '0',

  `writes` int(10) unsigned NOT NULL default '0',

  `writeBlks` int(10) unsigned NOT NULL default '0',

  PRIMARY KEY  (`time`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 4. Log into the LogLog GUI and configure a backup to execute immediately.