Uploaded image for project: 'Virtual Infrastructure Deployment'
  1. Virtual Infrastructure Deployment
  2. VID-332

schema_info table is missing

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Medium Medium
    • Casablanca Release
    • Casablanca Release
    • None
    • None
    • R3 Sprint 6

      When restarting VID docker all tables and data are gone, and the following error comes up:

       HTTP Status 500 - Servlet.init() for servlet dispatcher threw exception type Exception reportmessage Servlet.init() for servlet dispatcher threw exceptiondescription The server encountered an internal error that prevented it from fulfilling this request.exceptionjavax.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 causeorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourceMap' defined in class path resource [org/onap/portalsdk/core/conf/HibernateConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [java.util.Map]: Factory method 'dataSourceMap' threw exception; nested exception is java.sql.SQLSyntaxErrorException: (conn:71) Table 'vid_openecomp_epsdk.schema_info' doesn't existQuery 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.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:599)         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)root causeorg.springframework.beans.BeanInstantiationException: Failed to instantiate [java.util.Map]: Factory method 'dataSourceMap' threw exception; nested exception is java.sql.SQLSyntaxErrorException: (conn:71) Table 'vid_openecomp_epsdk.schema_info' doesn't existQuery 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.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:189)         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)root causejava.sql.SQLSyntaxErrorException: (conn:71) Table 'vid_openecomp_epsdk.schema_info' doesn't existQuery 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$$f8b57a6b.CGLIB$dataSourceMap$2(<generated>)         org.onap.portalsdk.core.conf.HibernateConfiguration$$EnhancerBySpringCGLIB$$f8b57a6b$$FastClassBySpringCGLIB$$32d5a79f.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$$f8b57a6b.dataSourceMap(<generated>)         sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)         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)root causeorg.mariadb.jdbc.internal.util.dao.QueryException: Table 'vid_openecomp_epsdk.schema_info' doesn't existQuery 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.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1115)         org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1047)         org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1002)         org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:142)         org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:243)         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$$f8b57a6b.CGLIB$dataSourceMap$2(<generated>)         org.onap.portalsdk.core.conf.HibernateConfiguration$$EnhancerBySpringCGLIB$$f8b57a6b$$FastClassBySpringCGLIB$$32d5a79f.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$$f8b57a6b.dataSourceMap(<generated>)         sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)         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)
      

            os0695 os0695
            os0695 os0695
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: