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
