problem executing this data query

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
ahardman
Posts: 41
Joined: Mon Apr 10, 2006 2:54 pm

problem executing this data query

Post by ahardman »

I am getting this error on all of my devices. I don't know when it started but I can't add any graphs now. When I click on the debug link it returns all of the informaition that it should. Has anyone seen this?
Attachments
cactisnmperror.JPG
cactisnmperror.JPG (193.1 KiB) Viewed 4118 times
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Which Host Template did you use?
Reinhard
ahardman
Posts: 41
Joined: Mon Apr 10, 2006 2:54 pm

host templete

Post by ahardman »

it doesn't matter which templete I use they all have the error. I have cisco router templetes, windows, linux, and custom templetes.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

From the edit screen of the failing device, what do you see in the upper left corner: SNMP Error? Please post your findings.
Are errors only seen with windows devices?
Please click the Debug link and post your findings.
Reinhard
ahardman
Posts: 41
Joined: Mon Apr 10, 2006 2:54 pm

Post by ahardman »

I clicked the debug link and the verbose query worked. My system is still polling devices and collecting data but I can't add anymore graphs due to this issue.
Attachments
cactisnmperror2.JPG
cactisnmperror2.JPG (220.51 KiB) Viewed 4034 times
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Ok, that DEBUG looks fine. Unfortunately, the image does not show the part of the "Associated Data Queries". Does the status now show any "items" and "rows"?
Reinhard
ahardman
Posts: 41
Joined: Mon Apr 10, 2006 2:54 pm

Post by ahardman »

No it does not. I had not noticed that before.
Attachments
cactisnmperror3.JPG
cactisnmperror3.JPG (23.18 KiB) Viewed 4026 times
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Please change to SNMP V1 (only for testing purpose). Then click the green circle to refresh and post your findings. You may as well run Verbose Query from there. This should have the same effect (AFAIK).
Reinhard
ahardman
Posts: 41
Joined: Mon Apr 10, 2006 2:54 pm

Post by ahardman »

Yes, switching to snmp V1 had the same result.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Post by gandalf »

Out of ideas, will call a dev
Reinhard
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:

Post by rony »

Ok. as I'm sitting in the LA waiting for a flight home. I'm looking at the thread and thinking WTF?

When did you notice the problem was occuring? Did you resently upgrade any software on the system? Did you resently import any templates? Are existing graphs that use the data queries working ok?

Am I able to login to the web interface to explorer your issue?
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
ad_vlad
Posts: 6
Joined: Thu Nov 24, 2005 8:41 am

Post by ad_vlad »

I seem to have exactly the same problem.
I don't remember touching the configs or makeing any package upgrades on the machine with the cacti.

All the devices I have defined are graphed nicely and the data is accurate. But if I go on a specific defice the line with the snmp interfaces is bugges:
1) SNMP - Interface Statistics (Verbose Query) Uptime Goes Backwards Success [0 Items, 0 Rows]
And the verbose query works and returns the interfaces just nicely.

Still trying to figure out if I changed anything on the cacti machine, since it happens on all my devices at the same time.
ad_vlad
Posts: 6
Joined: Thu Nov 24, 2005 8:41 am

Post by ad_vlad »

got the error. it's mysql related.
mysql> check table host_snmp_cache
-> ;
+-----------------------+-------+----------+----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------+-------+----------+----------------------------------------------------------+
| cacti.host_snmp_cache | check | warning | Table is marked as crashed |
| cacti.host_snmp_cache | check | warning | 3 clients are using or haven't closed the table properly |
| cacti.host_snmp_cache | check | error | Record at pos: 24824 is not remove-marked |
| cacti.host_snmp_cache | check | error | record delete-link-chain corrupted |
| cacti.host_snmp_cache | check | error | Corrupt |
+-----------------------+-------+----------+----------------------------------------------------------+
5 rows in set (0.08 sec)

mysql> repair table host_snmp_cache;

after this all runned fine.
ahardman
Posts: 41
Joined: Mon Apr 10, 2006 2:54 pm

Resolved

Post by ahardman »

After using this fix my problem went away. Thankyou so much.
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests