openmeetings-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maxim Solodovnik <solomax...@gmail.com>
Subject Re: The error at the en of Clustering
Date Wed, 09 Sep 2020 16:04:26 GMT
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 <jibsan94@gmail.com>
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

Mime
View raw message