|
|
| Subject: | No new events - possible database table corrupted |
| Author: | [Not Specified] |
| Posted: | 2016-10-12 13:47 |
Hello,
I'm using Zenoss Core v5.0.7. We recently stopped receiving new events. I connected into the docker container for mariadb. I ran mysqlcheck.
It gives the following error:
an ERROR for zenoss_zep.event_time
Failed to read from .par file
Incorrect information in file './zenoss_zep/event_time.frm'
corrupt
We have an old backup, months ago, made via the Control Center. We dont care if we lose our event data, but we want to make sure we dont lose our devices. We've added new devices since that last backup.
I'm not too sure the best way to fix something like this
I was thinking drop that database table and re-create it. I'm not sure how to properly re-create that table so that it has the correct structure etc.
Thank you in advance for any help you are able to provide
| Subject: | Fixed! |
| Author: | [Not Specified] |
| Posted: | 2016-10-21 12:06 |
I ended up fixing my issue.
I deletedthe "event_time" table located in the zenoss_zep database. And then re-created the databasetable.
The challenge for me was figuring out how to properly re-create the "event_time"table using the correct table definition. To figure out the database table definition:
- installed zenoss onto a virtual machine
- connected into the docker container for mariadb
- logged into mysql and looked ran 'show create table' to get table definition
Then I ran the CREATE TABLE statement in the original mariadb docker container.
As soon as I recreated the database table, I restarted services and events immediately began showing again.
There was probably an easier way to do this, but this was the only thing i could think of.
| < |
Previous Zenoss Core 5 API or Zendmd script - How Do I create a new SNMPv3 Command using ... |
Next server exception zenoss core 4.2.5 |
> |