RIB query errors seen on the CAPC event Display

Document ID : KB000032052
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

Query errors appear in both the events dashboard and on the corresponding element/device page(s). 

Query failed. See the logs for details. (Query ID: 

678c8cc5-b0ac-4b94-b7fa-917f2017f327) 

 

Cause:

These errors are caused by the EM database being broken.


Resolution:

1) Stop all the capc processes (sso, eventmanager,devicemanager, console). As root run:

/etc/init.d/caperfcenter_console stop

/etc/init.d/caperfcenter_devicemanager stop

/etc/init.d/caperfcenter_eventmanager stop

/etc/init.d/caperfcenter_sso stop

 

2) Stop, then restart mysql (

/etc/init.d/mysql stop, 

/etc/init.d/mysql start

 

3) At the command prompt, run the mysql client:

mysql 

 

4) At the mysql> prompt, switch to the em database:

mysql>use em;

 

5) Check the table and let me know the results: ( check table events; ) 

mysql>check table events;

 

Should say something like: 

+-----------+-------+----------+---------------------------------------------- 

| Table | Op | Msg_type | Msg_text 

+-----------+-------+----------+---------------------------------------------- 

| em.events | check | Error | Incorrect key file for table'.\em\events#P#p20140626'; try to repair it | 

| em.events | check | Error | Incorrect key file for table 'events'; try to repair it | 

| em.events | check | error | Corrupt 

+-----------+-------+----------+---------------------------------------------- 

 

6) Try to repair the table:

mysql>repair table events;

 

This should repair the table. If so, we can restart the capc processes in the following order(sso, eventmanager,devicemanager, console). If not, call support. 

 

if no error on the restart using these commands:

 

/etc/init.d/caperfcenter_console start

/etc/init.d/caperfcenter_devicemanager start

/etc/init.d/caperfcenter_eventmanager start

/etc/init.d/caperfcenter_sso start