All,
We successfully deployed ONAP Beijing k8s 2.0.0 and it was running fine for
more than a month. We rebooted the server after applying some patches.
After that ONAP Portal is not able to load VID UI and started throwing HTTP
500 Error.
We looked at the VID logs, it seems like *vid_openecomp_epsdk* schema does
not have any tables in *dev-vid-mariadb-galera-0* DB POD.
We tried running *vid-config-galera* job again but it didn't help us.
Could some one point us, how to rerun the DB config jobs?
Is there is any workaround to resolve similar issues?
Below are the steps that we performed.
Thanks & Regards
Vivek
*# Running vid-config-galera job again failed with INIT error*
kubectl get job -n onap "vid-config-galera" -o json | jq
'del(.spec.selector)' | jq 'del(.spec.template.metadata.labels)' | kubectl
replace --force -f -
onap vid-config-galera-4fj8m 0/1
Init:Error 0 3h 10.42.137.29 beijing02
*# dev-vid-mariadb-galera-0 DB container database information*
MariaDB [(none)]> show databases;
+---------------------+
| Database |
+---------------------+
| information_schema |
| mysql |
| performance_schema |
| vid_openecomp_epsdk |
+---------------------+
MariaDB [(none)]> use vid_openecomp_epsdk
Database changed
MariaDB [vid_openecomp_epsdk]> show tables
-> ;
Empty set (0.00 sec)
*ONAP Portal UI Error log*
HTTP Status 500 - Servlet.init() for servlet dispatcher threw exception
*type* Exception report
*message* *Servlet.init() for servlet dispatcher threw exception*
*description* *The server encountered an internal error that prevented it
from fulfilling this request.*
*exception*
javax.servlet.ServletException: Servlet.init() for servlet dispatcher
threw exception
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1156)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:2464)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:748)
root cause
java.sql.SQLSyntaxErrorException: (conn:681) Table
'vid_openecomp_epsdk.schema_info' doesn't exist
Query is : SELECT
schema_id,datasource_type,connection_url,user_name,password,driver_class,min_pool_size,max_pool_size,idle_connection_test_period
FROM schema_info
org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:139)
org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)
org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77)
org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:224)
org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:253)
org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:366)
com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327)
org.onap.portalsdk.core.conf.HibernateConfiguration.dataSourceMap(HibernateConfiguration.java:108)
org.onap.portalsdk.core.conf.HibernateConfiguration$$EnhancerBySpringCGLIB$$4f673818.CGLIB$dataSourceMap$1(<generated>)
org.onap.portalsdk.core.conf.HibernateConfiguration$$EnhancerBySpringCGLIB$$4f673818$$FastClassBySpringCGLIB$$1f3e1143.invoke(<generated>)
org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:356)
org.onap.portalsdk.core.conf.HibernateConfiguration$$EnhancerBySpringCGLIB$$4f673818.dataSourceMap(<generated>)
sun.reflect.GeneratedMethodAccessor209.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:162)
org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:588)
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1128)
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1022)
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:512)
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:778)
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:843)
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:541)
org.springframework.web.servlet.FrameworkServlet.configureAndRefreshWebApplicationContext(FrameworkServlet.java:666)
org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:538)
org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:492)
org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:136)
javax.servlet.GenericServlet.init(GenericServlet.java:158)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1156)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:2464)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:748)
-=-=-=-=-=-=-=-=-=-=-=-
Links: You receive all messages sent to this group.
View/Reply Online (#13086): https://lists.onap.org/g/onap-discuss/message/13086
Mute This Topic: https://lists.onap.org/mt/27372034/21656
Group Owner: [email protected]
Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub
[[email protected]]
-=-=-=-=-=-=-=-=-=-=-=-
