@jibsan How many people should join your sessions ? Would be nice to know ;-)
On 09/09/2020 15:43, Jibsan Joel Rosa Toirac 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 <http://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 <http://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
