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
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
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