SQL tables dropping on reboot

SamWolf · ‎05-08-2014

Hi,

For about the forth time now my reboot of VCO 5.5 has brought about a dropping of all my SQL tables. This is becoming a massive issue as all the references in workflows also drop.

Could someone please advise me on how to prevent this from happening.

Thanks,

Sam

tschoergez · ‎05-08-2014

are you talking about the vCO database itself? Or a SQL database that is connected via the SQL Plugin?

Anyway, that obviously should not happen at all 🙂

Can you check the server log (perhaps set it to debug log level temporarily while reproducing the issue) if something stands out there?

Cheers,

Joerg

SamWolf · ‎05-08-2014

It is a connected database table via the SQL plugin. The plugin is still up and stable but all of the tables I have imported require a re-import via the "Add a database" workflow.

SamWolf · ‎05-09-2014

Hey Joerg.

I have been trying to reproduce the error as you suggested but it seems that the table drops come randomly as the last 3 server restarts have not produced the issue. This is a huge problem being that all workflow references to these table are dropped and need to be reapplied each time. Simply waiting for the next occurrence of this problem to crop up is not really a solution as it is impacting production servers and requires quiet a bit of remediation.

Please advise on how I can prevent this failure moving forward.

Thanks,

SamWolf · ‎05-09-2014

2014-05-09 15:24:25.991+0000 [http-bio-172.25.66.141-8281-exec-18] INFO {} [DatabaseManager] DatabaseManager created.

2014-05-09 15:24:26.046+0000 [http-bio-172.25.66.141-8281-exec-18] ERROR {} [AbstractResourceElementConfigPersister] Error loading content from resource with id: 9b2cefff-c39b-41fc-b16b-274d57744d6f name: Billing.xml

com.thoughtworks.xstream.mapper.CannotResolveClassException: endpoint

at com.thoughtworks.xstream.mapper.DefaultMapper.realClass(DefaultMapper.java:79)

at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:30)

at com.thoughtworks.xstream.mapper.DynamicProxyMapper.realClass(DynamicProxyMapper.java:55)

at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:30)

at com.thoughtworks.xstream.mapper.PackageAliasingMapper.realClass(PackageAliasingMapper.java:88)

at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:30)

at com.thoughtworks.xstream.mapper.ClassAliasingMapper.realClass(ClassAliasingMapper.java:79)

at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:30)

at com.thoughtworks.xstream.mapper.ArrayMapper.realClass(ArrayMapper.java:74)

at com.thoughtworks.xstream.mapper.MapperWrapper.realClass(MapperWrapper.java:30)

at com.thoughtworks.xstream.mapper.CachingMapper.realClass(CachingMapper.java:45)

at com.thoughtworks.xstream.core.util.HierarchicalStreams.readClassType(HierarchicalStreams.java:29)

at com.thoughtworks.xstream.core.TreeUnmarshaller.start(TreeUnmarshaller.java:133)

at com.thoughtworks.xstream.core.AbstractTreeMarshallingStrategy.unmarshal(AbstractTreeMarshallingStrategy.java:32)

at com.thoughtworks.xstream.XStream.unmarshal(XStream.java:1156)

at com.thoughtworks.xstream.XStream.unmarshal(XStream.java:1140)

at com.thoughtworks.xstream.XStream.fromXML(XStream.java:1011)

at com.vmware.o11n.plugin.database.configuration.old.DatabaseConfigPersisterOld.bytes2Config(DatabaseConfigPersisterOld.java:37)

at com.vmware.o11n.plugin.database.configuration.old.DatabaseConfigPersisterOld.bytes2Config(DatabaseConfigPersisterOld.java:19)

at ch.dunes.vso.sdk.impl.AbstractResourceElementConfigPersister.getAll(AbstractResourceElementConfigPersister.java:43)

at com.vmware.o11n.plugin.database.configuration.DataBaseConfigPersister.getAll(DataBaseConfigPersister.java:65)

at com.vmware.o11n.plugin.database.configuration.ConfigurationServiceImpl.reload(ConfigurationServiceImpl.java:67)

at com.vmware.o11n.plugin.database.configuration.ConfigurationServiceImpl.getAll(ConfigurationServiceImpl.java:124)

at com.vmware.o11n.plugin.database.model.DatabaseManager.getDatabases(DatabaseManager.java:415)

at com.vmware.o11n.plugin.database.DatabasePluginFactory.findRelation(DatabasePluginFactory.java:150)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at ch.dunes.vso.sdk.DirectInvoker.invoke(DirectInvoker.java:55)

at ch.dunes.vso.sdk.SDKDatasourceInvoker.fetchRelation(SDKDatasourceInvoker.java:67)

at ch.dunes.vso.sdk.SDKFinder.fetchRelation(SDKFinder.java:332)

at ch.dunes.vso.sdk.SDKFinder._findRelation(SDKFinder.java:306)

at ch.dunes.vso.sdk.SDKFinder.findRelation(SDKFinder.java:224)

at ch.dunes.vso.sdk.ModulesFactory.findRelation(ModulesFactory.java:521)

at com.vmware.o11n.sdk.EnhancedScriptingSDK.findRelation(EnhancedScriptingSDK.java:99)

at com.vmware.o11n.service.sdk.SdkModuleServiceImpl.findRelation(SdkModuleServiceImpl.java:57)

at com.vmware.o11n.service.factory.VcoFactoryFacade.findRelation(VcoFactoryFacade.java:1633)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.vmware.o11n.service.security.AccessRightsInterceptor.invoke(AccessRightsInterceptor.java:92)

at com.vmware.o11n.service.security.AccessRightsInterceptor.invoke(AccessRightsInterceptor.java:83)

at com.vmware.o11n.service.webremoting.VcoDelegatingWebFacade.invokeOperation(VcoDelegatingWebFacade.java:106)

at com.vmware.o11n.integration.initialization.VcoFactoryServiceFacadeProxy.invokeOperation(VcoFactoryServiceFacadeProxy.java:86)

at sun.reflect.GeneratedMethodAccessor143.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)

at com.sun.proxy.$Proxy67.invokeOperation(Unknown Source)

at sun.reflect.GeneratedMethodAccessor142.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:205)

at org.springframework.remoting.support.DefaultRemoteInvocationExecutor.invoke(DefaultRemoteInvocationExecutor.java:38)

at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:78)

at org.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExporter.java:114)

at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:73)

at org.springframework.web.context.support.HttpRequestHandlerServlet.service(HttpRequestHandlerServlet.java:67)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at net.sf.ehcache.constructs.web.filter.GzipFilter.doFilter(GzipFilter.java:95)

at net.sf.ehcache.constructs.web.filter.Filter.doFilter(Filter.java:86)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:611)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:680)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2014-05-09 15:24:26.070+0000 [http-bio-172.25.66.141-8281-exec-18] ERROR {} [AbstractResourceElementConfigPersister] Error loading content from resource with id: a9762f40-f1de-4435-ac24-2edd5c3eb88b name: Customers.xml