[resolved] Unable to deploy data container AGAIN!

One Star

[resolved] Unable to deploy data container AGAIN!

Hi there,
I'm trying to deploy a data container which I had previously successfully deployed and I get the following error:

The server log reads:
2014-08-06 12:31:50,640 WARN   No SQL storage defined for data model 'Media'. No SQL storage to update.
2014-08-06 12:31:50,640 WARN   No SQL staging storage defined for data model 'Media'. No SQL staging storage to update.
2014-08-06 12:31:50,646 INFO   DMUpdateEvent
2014-08-06 12:32:00,209 INFO   Container 'Media' does not exist in revision 'null', creating it.
2014-08-06 12:32:00,210 INFO   Reading from datasource file at 'D:\Program Files\TOS_MDM-Server-r111943-V5.4.1\jboss-4.2.2.GA\server\default\conf\datasources.xml'.
2014-08-06 12:32:00,233 INFO   Reading from datasource file at 'D:\Program Files\TOS_MDM-Server-r111943-V5.4.1\jboss-4.2.2.GA\server\default\conf\datasources.xml'.
2014-08-06 12:32:00,255 INFO   Reading from datasource file at 'D:\Program Files\TOS_MDM-Server-r111943-V5.4.1\jboss-4.2.2.GA\server\default\conf\datasources.xml'.
2014-08-06 12:32:00,301 INFO   Reading from datasource file at 'D:\Program Files\TOS_MDM-Server-r111943-V5.4.1\jboss-4.2.2.GA\server\default\conf\datasources.xml'.
2014-08-06 12:32:00,515 INFO   *NOT* cleaning existing database content.
2014-08-06 12:32:00,515 INFO   Preparing database before schema generation.
2014-08-06 12:32:08,079 ERROR ##### Error during storage preparation (force = true) #####
2014-08-06 12:32:08,079 ERROR TransactionRolledbackLocalException in method: public abstract boolean com.amalto.core.server.XmlServer.existCluster(java.lang.String,java.lang.String) throws com.amalto.core.util.XtentisException, causedBy:
java.lang.RuntimeException: Could not create storage 'Media' with data model 'Media'.
at com.amalto.core.server.StorageAdminImpl.create(StorageAdminImpl.java:117)
at com.amalto.core.server.StorageAdminImpl.exist(StorageAdminImpl.java:320)
at com.amalto.core.storage.StorageWrapper.existCluster(StorageWrapper.java:143)
at com.amalto.core.storage.DispatchWrapper.existCluster(DispatchWrapper.java:185)
at com.amalto.core.ejb.XmlServerSLWrapperBean.existCluster(XmlServerSLWrapperBean.java:268)
at sun.reflect.GeneratedMethodAccessor210.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
at org.jboss.ejb.Container.invoke(Container.java:960)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
at com.sun.proxy.$Proxy170.existCluster(Unknown Source)
at com.amalto.core.objects.datacluster.ejb.DataClusterCtrlBean.putDataCluster(DataClusterCtrlBean.java:118)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
at org.jboss.ejb.Container.invoke(Container.java:960)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
at com.sun.proxy.$Proxy191.putDataCluster(Unknown Source)
at com.amalto.core.delegator.IXtentisWSDelegator.putDataCluster(IXtentisWSDelegator.java:548)
at com.amalto.core.ejb.XtentisWSBean.putDataCluster(XtentisWSBean.java:328)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.wsf.container.jboss42.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:85)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
at org.jboss.ejb.Container.invoke(Container.java:960)
at sun.reflect.GeneratedMethodAccessor342.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.wsf.container.jboss42.InvocationHandlerEJB21.invoke(InvocationHandlerEJB21.java:147)
at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:220)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:408)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:272)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:189)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:122)
at org.jboss.wsf.stack.jbws.EndpointServlet.service(EndpointServlet.java:84)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:393)
at org.apache.catalina.authenticator.MDMSingleSignOn.invoke(MDMSingleSignOn.java:73)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.RuntimeException: Could not create storage for container 'Media' (MASTER) using data model 'Media'.
at com.amalto.core.server.StorageAdminImpl.internalCreateStorage(StorageAdminImpl.java:256)
at com.amalto.core.server.StorageAdminImpl.create(StorageAdminImpl.java:108)
... 101 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Exception occurred during initialization of H2 database
at com.amalto.core.storage.StorageLogger.handlePrepareError(StorageLogger.java:64)
at com.amalto.core.storage.StorageLogger.prepare(StorageLogger.java:71)
at com.amalto.core.server.StorageAdminImpl.internalCreateStorage(StorageAdminImpl.java:254)
... 102 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Exception occurred during initialization of H2 database
at com.amalto.core.storage.prepare.JDBCStorageInitializer.initialize(JDBCStorageInitializer.java:52)
at com.amalto.core.storage.hibernate.HibernateStorage.prepare(HibernateStorage.java:240)
at com.amalto.core.storage.SecuredStorage.prepare(SecuredStorage.java:72)
at com.amalto.core.storage.StorageLogger.prepare(StorageLogger.java:69)
... 103 more
Caused by: java.lang.RuntimeException: Exception occurred during initialization of H2 database
at com.amalto.core.storage.prepare.H2StorageInitializer.initialize(H2StorageInitializer.java:64)
at com.amalto.core.storage.prepare.FullTextIndexCleaner.initialize(FullTextIndexCleaner.java:74)
at com.amalto.core.storage.prepare.JDBCStorageInitializer.initialize(JDBCStorageInitializer.java:50)
... 106 more
Caused by: org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.store.FileLock.getExceptionAlreadyInUse(FileLock.java:439)
at org.h2.store.FileLock.lockFile(FileLock.java:336)
at org.h2.store.FileLock.lock(FileLock.java:128)
at org.h2.engine.Database.open(Database.java:542)
at org.h2.engine.Database.openDatabase(Database.java:222)
at org.h2.engine.Database.<init>(Database.java:217)
at org.h2.engine.Engine.openSession(Engine.java:56)
at org.h2.engine.Engine.openSession(Engine.java:159)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138)
at org.h2.engine.Engine.createSession(Engine.java:121)
at org.h2.engine.Engine.createSession(Engine.java:28)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:305)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
at org.h2.Driver.connect(Driver.java:72)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at com.amalto.core.storage.prepare.H2StorageInitializer.initialize(H2StorageInitializer.java:60)
... 108 more
2014-08-06 12:32:08,090 ERROR SOAP request exception
java.rmi.RemoteException: Unable to physically create the data cluster Media: javax.ejb.TransactionRolledbackLocalException: Could not create storage 'Media' with data model 'Media'.; 
: Could not create storage 'Media' with data model 'Media'.
: Could not create storage 'Media' with data model 'Media'.
: Could not create storage for container 'Media' (MASTER) using data model 'Media'.
: java.lang.RuntimeException: java.lang.RuntimeException: Exception occurred during initialization of H2 database
: java.lang.RuntimeException: Exception occurred during initialization of H2 database
: Exception occurred during initialization of H2 database
: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode ; nested exception is: 
com.amalto.core.util.XtentisException: Unable to physically create the data cluster Media: javax.ejb.TransactionRolledbackLocalException: Could not create storage 'Media' with data model 'Media'.
at com.amalto.core.util.RemoteExceptionFactory.aggregateCauses(RemoteExceptionFactory.java:35)
at com.amalto.core.delegator.IXtentisWSDelegator.putDataCluster(IXtentisWSDelegator.java:551)
at com.amalto.core.ejb.XtentisWSBean.putDataCluster(XtentisWSBean.java:328)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.wsf.container.jboss42.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:85)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
at org.jboss.ejb.Container.invoke(Container.java:960)
at sun.reflect.GeneratedMethodAccessor342.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.wsf.container.jboss42.InvocationHandlerEJB21.invoke(InvocationHandlerEJB21.java:147)
at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:220)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:408)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:272)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:189)
at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:122)
at org.jboss.wsf.stack.jbws.EndpointServlet.service(EndpointServlet.java:84)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:393)
at org.apache.catalina.authenticator.MDMSingleSignOn.invoke(MDMSingleSignOn.java:73)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:744)
Caused by: com.amalto.core.util.XtentisException: Unable to physically create the data cluster Media: javax.ejb.TransactionRolledbackLocalException: Could not create storage 'Media' with data model 'Media'.
at com.amalto.core.objects.datacluster.ejb.DataClusterCtrlBean.putDataCluster(DataClusterCtrlBean.java:130)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
at org.jboss.ejb.Container.invoke(Container.java:960)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
at com.sun.proxy.$Proxy191.putDataCluster(Unknown Source)
at com.amalto.core.delegator.IXtentisWSDelegator.putDataCluster(IXtentisWSDelegator.java:548)
... 56 more
Caused by: javax.ejb.TransactionRolledbackLocalException: Could not create storage 'Media' with data model 'Media'.
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:262)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
at org.jboss.ejb.Container.invoke(Container.java:960)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
at com.sun.proxy.$Proxy170.existCluster(Unknown Source)
at com.amalto.core.objects.datacluster.ejb.DataClusterCtrlBean.putDataCluster(DataClusterCtrlBean.java:118)
... 77 more
Caused by: java.lang.RuntimeException: Could not create storage 'Media' with data model 'Media'.
at com.amalto.core.server.StorageAdminImpl.create(StorageAdminImpl.java:117)
at com.amalto.core.server.StorageAdminImpl.exist(StorageAdminImpl.java:320)
at com.amalto.core.storage.StorageWrapper.existCluster(StorageWrapper.java:143)
at com.amalto.core.storage.DispatchWrapper.existCluster(DispatchWrapper.java:185)
at com.amalto.core.ejb.XmlServerSLWrapperBean.existCluster(XmlServerSLWrapperBean.java:268)
at sun.reflect.GeneratedMethodAccessor210.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
... 88 more
Caused by: java.lang.RuntimeException: Could not create storage for container 'Media' (MASTER) using data model 'Media'.
at com.amalto.core.server.StorageAdminImpl.internalCreateStorage(StorageAdminImpl.java:256)
at com.amalto.core.server.StorageAdminImpl.create(StorageAdminImpl.java:108)
... 101 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: Exception occurred during initialization of H2 database
at com.amalto.core.storage.StorageLogger.handlePrepareError(StorageLogger.java:64)
at com.amalto.core.storage.StorageLogger.prepare(StorageLogger.java:71)
at com.amalto.core.server.StorageAdminImpl.internalCreateStorage(StorageAdminImpl.java:254)
... 102 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Exception occurred during initialization of H2 database
at com.amalto.core.storage.prepare.JDBCStorageInitializer.initialize(JDBCStorageInitializer.java:52)
at com.amalto.core.storage.hibernate.HibernateStorage.prepare(HibernateStorage.java:240)
at com.amalto.core.storage.SecuredStorage.prepare(SecuredStorage.java:72)
at com.amalto.core.storage.StorageLogger.prepare(StorageLogger.java:69)
... 103 more
Caused by: java.lang.RuntimeException: Exception occurred during initialization of H2 database
at com.amalto.core.storage.prepare.H2StorageInitializer.initialize(H2StorageInitializer.java:64)
at com.amalto.core.storage.prepare.FullTextIndexCleaner.initialize(FullTextIndexCleaner.java:74)
at com.amalto.core.storage.prepare.JDBCStorageInitializer.initialize(JDBCStorageInitializer.java:50)
... 106 more
Caused by: org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.store.FileLock.getExceptionAlreadyInUse(FileLock.java:439)
at org.h2.store.FileLock.lockFile(FileLock.java:336)
at org.h2.store.FileLock.lock(FileLock.java:128)
at org.h2.engine.Database.open(Database.java:542)
at org.h2.engine.Database.openDatabase(Database.java:222)
at org.h2.engine.Database.<init>(Database.java:217)
at org.h2.engine.Engine.openSession(Engine.java:56)
at org.h2.engine.Engine.openSession(Engine.java:159)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:138)
at org.h2.engine.Engine.createSession(Engine.java:121)
at org.h2.engine.Engine.createSession(Engine.java:28)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:305)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
at org.h2.Driver.connect(Driver.java:72)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at com.amalto.core.storage.prepare.H2StorageInitializer.initialize(H2StorageInitializer.java:60)
... 108 more
Thanks,
Facoda

Accepted Solutions
Highlighted
Employee

Re: [resolved] Unable to deploy data container AGAIN!

Hi Facoda,
The following exception in your trace 

Caused by: org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode

would make me say that you may have many Talend MDM processes running at the same time, causing a database file-lock issue (H2 is relying on files with exclusive locks : first-come first-served). Can you double-check that there's only one process related to Talend MDM running ?
Regards,
Cyril.

All Replies
Highlighted
Employee

Re: [resolved] Unable to deploy data container AGAIN!

Hi Facoda,
The following exception in your trace 

Caused by: org.h2.jdbc.JdbcSQLException: Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode

would make me say that you may have many Talend MDM processes running at the same time, causing a database file-lock issue (H2 is relying on files with exclusive locks : first-come first-served). Can you double-check that there's only one process related to Talend MDM running ?
Regards,
Cyril.
One Star

Re: [resolved] Unable to deploy data container AGAIN!

Brilliant! Thanks Cyril. You were correct there was a lock on the H2 database because I had used H2 Console to view the contents of the Media DB. I killed the H2 process by ending the javaw.exe for Windows in task manager. 
One Star

Re: [resolved] Unable to deploy data container AGAIN!

Hi there,
I'm trying to deploy a data container which I am  deploying newly deployed and I got the above error mentioned.

Unable to deploy data container to the cluster ....
Please help me in checking this issue.
Two Stars

Re: [resolved] Unable to deploy data container AGAIN!

Hi AnonymousUser.

 

I was in the same problem like you and the only problem was my grants on database. I got MySQL and when I did check it, my dbuser won't have the appropriate grants.

 

if you have the same database try this:

 

 

mysql> show grants for 'username';

+--------------------------------------------------------------------------------------------------------------------------------------+

| Grants for username@%                                                                                                              |

+--------------------------------------------------------------------------------------------------------------------------------------+

| GRANT ALL PRIVILEGES ON `MDM_STAGING`.* TO 'username'@'%'                                                                |

| GRANT ALL PRIVILEGES ON `MDM_MASTER`.* TO 'username'@'%'                                                                 |

| GRANT ALL PRIVILEGES ON `MDM_MASTER`.* TO 'username'@'%'                                                                  |

| GRANT ALL PRIVILEGES ON `TMDM_DB_SYSTEM`.* TO 'username'@'%'                                                                       |

+--------------------------------------------------------------------------------------------------------------------------------------+

4 rows in set (0.00 sec)

 

Like you notice I just have permission to modify my Database but I don't have permission to create another one.

 

mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

Restart the MDM Server and try it again.

 

 

So I hope it helps you.

Oscar

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads