Thank you Maxim, I will try that and I'll let you know how it goes. Greetings,
Jibsan El mié., 9 sept. 2020 a las 12:04, Maxim Solodovnik (<[email protected]>) escribió: > Well > > it seems the docs are not clear enough ... > You DON'T NEED to install OM twice > > After the first (and the only one) installation DB is ready to use > you have to copy `persistense.xml` file to other nodes and that's it > > > On Wed, 9 Sep 2020 at 20:43, Jibsan Joel Rosa Toirac <[email protected]> > wrote: > >> Hello Maxim, I haven't reply earlier because I was testing several ways >> to setup the "Installation" process of the Cluster. >> >> To answer your questions: >> >> 1- I was setting the same OM initial Admin user on both, on the new >> Installation I created a different user for each node. But on the first >> time I did created the same user twice, I don't know how but it did. >> >> 2- I have only 1 DB for both nodes. >> >> Anyhow I will let you here the error that gave me at the final step on >> the second node, the first one was running without problem the installation >> process. >> >> P.D: >> I'm able now to enter on the Rooms, the Cluster is working perfectly but >> I still having the same error at the end of the second node, that's why it >> took so long to reply, I was testing different entries on all the fields of >> the Installation but the result is the same. >> >> Here is the error: >> >> Instalación fallida >> <openjpa-3.1.2-r66d2a72 fatal store error> >> org.apache.openjpa.persistence.EntityExistsException: The transaction has >> been rolled back. See the nested exceptions for details on the errors that >> occurred. >> FailedObject: >> org.apache.openmeetings.db.entity.basic.Configuration@3a53a03b >> at >> org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2470) >> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308) >> at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199) >> at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1962) >> at org.apache.openjpa.kernel.QueryImpl.isInMemory(QueryImpl.java:1028) >> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:902) >> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843) >> at >> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) >> at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) >> at >> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) >> at >> org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:129) >> at >> org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:136) >> at >> org.apache.openmeetings.db.dao.basic.ConfigurationDao.getString(ConfigurationDao.java:186) >> at >> org.apache.openmeetings.db.dao.basic.ConfigurationDao.reloadCrypt(ConfigurationDao.java:372) >> at >> org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:257) >> at >> org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:224) >> at >> org.apache.openmeetings.db.dao.basic.ConfigurationDao$$FastClassBySpringCGLIB$$2f9526f2.invoke(<generated>) >> at >> org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) >> at >> org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) >> at >> org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) >> at >> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367) >> at >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) >> at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) >> at >> org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) >> at >> org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) >> at >> org.apache.openmeetings.db.dao.basic.ConfigurationDao$$EnhancerBySpringCGLIB$$ecd6b025.update(<generated>) >> at >> org.apache.openmeetings.installation.ImportInitvalues.loadConfiguration(ImportInitvalues.java:391) >> at >> org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:581) >> at >> org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:591) >> at >> org.apache.openmeetings.installation.Wicket_Proxy_ImportInitvalues$$FastClassByCGLIB$$14cc0e15.invoke(<generated>) >> at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) >> at >> org.apache.wicket.proxy.LazyInitProxyFactory$AbstractCGLibInterceptor.intercept(LazyInitProxyFactory.java:364) >> at >> org.apache.openmeetings.installation.Wicket_Proxy_ImportInitvalues$$EnhancerByCGLIB$$5e6b109.loadAll(<generated>) >> at >> org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:833) >> at java.base/java.lang.Thread.run(Thread.java:834) >> Caused by: <openjpa-3.1.2-r66d2a72 fatal store error> >> org.apache.openjpa.persistence.EntityExistsException: Duplicate entry ' >> crypt.class.name' for key 'U_CNFGRTN_OM_KEY' {prepstmnt 313424765 INSERT >> INTO configuration (deleted, inserted, updated, comment, fromVersion, >> om_key, type, value, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)} >> [code=1062, state=23000] >> FailedObject: >> org.apache.openmeetings.db.entity.basic.Configuration@3a53a03b >> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5263) >> at >> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5238) >> at >> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) >> at >> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75) >> at >> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:146) >> at >> org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80) >> at >> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) >> at >> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90) >> at >> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:554) >> at >> org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:110) >> at >> org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61) >> at >> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:108) >> at >> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81) >> at >> org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:757) >> at >> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146) >> at >> org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:679) >> at >> org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146) >> ... 35 more >> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Duplicate >> entry 'crypt.class.name' for key 'U_CNFGRTN_OM_KEY' {prepstmnt 313424765 >> INSERT INTO configuration (deleted, inserted, updated, comment, >> fromVersion, om_key, type, value, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, >> ?)} [code=1062, state=23000] >> at >> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) >> at >> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195) >> at >> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:58) >> at >> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1188) >> at >> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) >> at >> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) >> at >> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:271) >> at >> org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121) >> ... 47 more >> >> Greetings and have a nice day, >> >> Jibsan >> > > > -- > Best regards, > Maxim >
