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;
Was this topic helpful?
Document Information
More support for:
Platform RTM
Software version:
9.1.0
Document number:
677857
Modified date:
17 June 2018
UID
isg3T1019877