problem executing this data query
Moderators: Developers, Moderators
problem executing this data query
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 (193.1 KiB) Viewed 4121 times
host templete
it doesn't matter which templete I use they all have the error. I have cisco router templetes, windows, linux, and custom templetes.
- rony
- Developer/Forum Admin
- Posts: 6022
- Joined: Mon Nov 17, 2003 6:35 pm
- Location: Michigan, USA
- Contact:
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?
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]
[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]
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.
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.
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.
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.
Who is online
Users browsing this forum: No registered users and 0 guests