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
