Thank you Maxim. I didn’t what you said and it worked perfectly. Just when you copy to other nodes the “persistance.xml” you have to restart the “tomcat3” service and that’s all. You can continue with the next steps of the clustering process.
Have a nice weekend. Greetings. Jibsan On Fri, Sep 11, 2020 at 8:02 AM Maxim Solodovnik <[email protected]> wrote: > Please NOTE current cluster implementation can increase user count on the > server NOT in the room > > On Thu, 10 Sep 2020 at 21:31, Jibsan Joel Rosa Toirac <[email protected]> > wrote: > >> It will be around 700 persons, maybe more >> >> >> El jue., 10 sept. 2020 a las 10:01, kaffeesurrogat (< >> [email protected]>) escribió: >> >>> @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 >>> >>> > > -- > Best regards, > Maxim >
