Can't launch CAPC URL

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

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