Can't launch CAPC URL

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration

Issue/Introduction

Issue:

Unable to launch CAPC URL, getting http error 503 web service unavailable 

error code [145]; Table './netqosportal/items' is marked as crashed and should be repaired; nested exception is java.sql.SQLException: Table './netqosportal/items' is marked as crashed and should be repaired 

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328) 

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106) 

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325) 

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086) 

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517) 

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456) 

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291) 

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) 

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288) 

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190) 

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefini 

 

Environment:

2.x

 

Cause: 

Crashed table

 

Resolution:

We must repair the mysql database

First stop all relevant processes

1. /etc/init.d/caperfcenter_console stop 
2. /etc/init.d/caperfcenter_eventmanager stop 
3. /etc/init.d/caperfcenter_sso stop 
4. /etc/init.d/caperfcenter_devicemanager stop 
5. /etc/init.d/mysql stop

Next, lets repair the database by running the following command from /opt/CA/MySql/bin:

myisamchk --recover /opt/CA/MySql/data/netqosportal/*.MYI 

Finally start all processes back up in the appropriate order

1. /etc/init.d/mysql start 
2. /etc/init.d/caperfcenter_devicemanager start 
3. /etc/init.d/caperfcenter_sso start 
4. /etc/init.d/caperfcenter_eventmanager start 
5. /etc/init.d/caperfcenter_console start 

 

You should now be able to access CAPC successfully

Additional Information:

The myisamchk noted above is for the entire database.  We can certainly run it for individual table but the above command will address any other issues with the tables

Environment

Release: IMDAGG99000-2.8-Infrastructure Management-Data Aggregator
Component: