IBM Support

IBM Platform RTM MySQL Error:'1146'

Troubleshooting


Problem

There are error messages in cacti.log like below, " ... 09/03/2013 08:35:21 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT clusterid, SUM(CASE WHEN stat='STARTED' THEN slots_in_state ELSE 0 END) AS hourly_started_jobs, SUM(CASE WHEN stat='ENDED' THEN slots_in_state ELSE 0 END) AS hourly_done_jobs, SUM(CASE WHEN stat='EXITED' THEN slots_in_state ELSE 0 END) AS hourly_exit_jobs FROM grid_job_interval_stats WHERE interval_start>='2013-09-03 07:35:21' AND clusterid IN (SELECT clusterid FROM grid_clusters) GROUP BY clusterid" ... "

Symptom

IBM Platform RTM graphs do not update.

Cause


MySQL ERROR 1146 : Table doesn't exist, in this case table grid_job_interval_stats is missing.

Resolving The Problem


Run the following statements in MySQL to create table "grid_job_interval_stats" manually,

DROP TABLE IF EXISTS `grid_job_interval_stats`;
CREATE TABLE `grid_job_interval_stats` (
`clusterid` int(10) unsigned NOT NULL default '0',
`user` varchar(45) NOT NULL default '',
`stat` varchar(45) NOT NULL default '',
`queue` varchar(45) NOT NULL default '',
`from_host` varchar(64) NOT NULL default '',
`exec_host` varchar(64) NOT NULL default '',
`projectName` varchar(60) NOT NULL default '',
`jobs_reaching_state` int(10) unsigned NOT NULL default '0',
`jobs_wall_time` int(10) unsigned NOT NULL default '0',
`jobs_stime` double NOT NULL,
`jobs_utime` double NOT NULL,
`slots_in_state` int(10) unsigned NOT NULL default '0',
`avg_memory` double NOT NULL default '0',
`max_memory` double NOT NULL default '0',
`interval_start` timestamp NOT NULL default '0000-00-00 00:00:00',
`interval_end` timestamp NOT NULL default '0000-00-00 00:00:00',
`date_recorded` timestamp NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`clusterid`,`user`,`stat`,`projectName`,`exec_host`,`from_host`,`queue`,`date_recorded`),
KEY `interval_start` (`interval_start`),
KEY `interval_end` (`interval_end`),
KEY `clusterid` (`clusterid`),
KEY `stat` (`stat`),
KEY `queue` (`queue`),
KEY `date_recorded` (`date_recorded`),
KEY `clusterid_queue_stat` (`clusterid`,`queue`,`stat`),
KEY `clusterid_date_recorded` (`clusterid`,`date_recorded`),
KEY `clusterid_stat_interval_end` (`clusterid`,`stat`,`interval_end`,`user`),
KEY `projectName` (`projectName`),
KEY `user` (`user`)
) ENGINE=MyISAM;

[{"Product":{"code":"SSVMSD","label":"Platform RTM"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1.0","Edition":"Advanced","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSZT2D","label":"IBM Spectrum LSF RTM"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSZT2D","label":"IBM Spectrum LSF RTM"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

More support for:
Platform RTM

Software version:
9.1.0

Document number:
677857

Modified date:
17 June 2018

UID

isg3T1019877

Manage My Notification Subscriptions