No graphs and devices are not showing up as expected

[Ed_Howard]

This morning when I walked in and did my check of Cacti I noticed that none of the devices we have are listed. It shows that there are pages of devices available but they are not being shown. I have attached some screen shots to help illustrate my point.

In looking further I noticed that graphing has not been occuring for some time as well. I then looked at the cacti log and found the following:

12/15/2011 11:15:02 AM - SYSTEM THOLD STATS: Time:0.0083 Tholds:0 Hosts:0
12/15/2011 11:15:02 AM - SYSTEM STATS: Time:0.0039 Method:spine Processes:6 Threads:20 Hosts:0 HostsPerProcess:0 DataSources:1139 RRDsProcessed:0
12/15/2011 11:15:02 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1194', SQL:"SELECT id FROM host WHERE disabled='' ORDER BY id"
12/15/2011 11:13:34 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1194', SQL:"SELECT * FROM host ORDER BY description ASC LIMIT 0,30"
12/15/2011 11:10:01 AM - SYSTEM THOLD STATS: Time:0.0083 Tholds:0 Hosts:0
12/15/2011 11:10:01 AM - SYSTEM STATS: Time:0.0039 Method:spine Processes:6 Threads:20 Hosts:0 HostsPerProcess:0 DataSources:1139 RRDsProcessed:0
12/15/2011 11:10:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1194', SQL:"SELECT id FROM host WHERE disabled='' ORDER BY id"
12/15/2011 11:06:10 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1194', SQL:"SELECT * FROM host ORDER BY description ASC LIMIT 0,30"
12/15/2011 11:05:01 AM - SYSTEM THOLD STATS: Time:0.0083 Tholds:0 Hosts:0
12/15/2011 11:05:01 AM - SYSTEM STATS: Time:0.0038 Method:spine Processes:6 Threads:20 Hosts:0 HostsPerProcess:0 DataSources:1139 RRDsProcessed:0
12/15/2011 11:05:01 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1194', SQL:"SELECT id FROM host WHERE disabled='' ORDER BY id"
12/15/2011 11:01:06 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1194', SQL:"SELECT * FROM host where (host.hostname like '%%stacy%%' OR host.description like '%%stacy%%') ORDER BY description ASC LIMIT 0,30"

I am obviously not a database guy but I am hoping this is a quick and easy fix. Here are the particulars of my systems.

Running CentOS
Cacti Version 0.8.7g

Plugins are as follows:

Name Version Status

Autom8 0.35 Active
Reportit 0.7.3 Active
Aggregate 0.65 Active
Monitor 1.2 Active
Mactrack 2.9 Active
Settings 0.7 Active
Boost 4.3 Not Installed
Discovery 1.1 Active
Manage 0.6.2 Active
Weathermap 0.97a Active
Realtime 0.32 Disabled
Routerconfigs 0.3 Active
Nectar 0.30 Active
Ssl 0.1 Disabled
Thold 0.4.3 Active

Any other information you need please ask. I really appreciate all the help.

Just a quick update, I now cannot sign onto the the Cacti web gui. I am able to SSH the server and can see everything there. All seems fine on the server my guess is that it is a database corruption issue or some other issue.

[gandalf]

mysql docs say

Error: 1194 SQLSTATE: HY000 (ER_CRASHED_ON_USAGE)

Message: Table '%s' is marked as crashed and should be repaired

So please repair that table (call "repair table host;" from mysql command line or use phpMyAdmin to do so)
R.

[Ed_Howard]

mysql docs say

Error: 1194 SQLSTATE: HY000 (ER_CRASHED_ON_USAGE)

Message: Table '%s' is marked as crashed and should be repaired

So please repair that table (call "repair table host;" from mysql command line or use phpMyAdmin to do so)
R.

Reinhard always a pleasure having you helping me out I really appreciate it. That was a quick and simple fix. All of the devices have shown up again. I will wait and see if the graphing is working as expected. Once again I really appreciate all the help.