I want to do clustering on OpenMeeting-3.0.7. I have two machines(10.1.2.2
and 10.1.2.3). 10.1.2.2 have database Postgres installed on it.
I did the following
1. Extracted apache-openmeetings-3.0.7.tar.gz on 10.1.2.2.
2. Changed following properties in persistence.xml and
openmeetings-applicationContext.xml
respectively.
<property name="serverId" value="10.1.2.2" />
<property name="openjpa.RemoteCommitProvider"
value="tcp(Addresses=10.1.1.2;10.1.1.3)" />
3.
Ran ./red5.sh and installed OpenMeetings successfully.
4.
Extracted apache-openmeetings-3.0.7.tar.gz on 10.1.2.3.
5.
Changed following properties in persistence.xml and
openmeetings-applicationContext.xml respectively.
<property name="serverId" value="10.1.2.3" />
<property name="openjpa.RemoteCommitProvider"
value="tcp(Addresses=10.1.1.2;10.1.1.3)" />
6. Now when I ran ./red5.sh, i got following error.
Installation is failed
org.springframework.dao.DataIntegrityViolationException: The transaction
has been rolled back. See the nested exceptions for details on the errors
that occurred.; nested exception is <openjpa-2.4.0-r422266:1674604 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@3d65f054
at
org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:407)
at
org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122)
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:757)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:726)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:521)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:291)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)
at
org.apache.openmeetings.db.dao.basic.ConfigurationDao$$EnhancerBySpringCGLIB$$2b956ef0.add(<generated>)
at
org.apache.openmeetings.installation.ImportInitvalues.loadConfiguration(ImportInitvalues.java:283)
at
org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:714)
at
org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:726)
at
org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:616)
at java.lang.Thread.run(Thread.java:745)
Caused by: <openjpa-2.4.0-r422266:1674604 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@3d65f054
at
org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2368)
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2205)
at
org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2103)
at
org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2021)
at
org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1526)
at
org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:932)
at
org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:569)
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:517)
... 13 more
Caused by: <openjpa-2.4.0-r422266:1674604 fatal store error>
org.apache.openjpa.persistence.EntityExistsException: ERROR: duplicate key
value violates unique constraint "u_cnfgrtn_conf_key"
Detail: Key (conf_key)=(crypt_ClassName) already exists. {prepstmnt
55686682 INSERT INTO configuration (comment_field, conf_key, conf_value,
deleted, starttime, updatetime, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)}
[code=0, state=23505]
FailedObject:
org.apache.openmeetings.db.entity.basic.Configuration@3d65f054
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4986)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4961)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:133)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:144)
at
org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
at
org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:104)
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:77)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:731)
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
at
org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:668)
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
... 21 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR:
duplicate key value violates unique constraint "u_cnfgrtn_conf_key"
Detail: Key (conf_key)=(crypt_ClassName) already exists. {prepstmnt
55686682 INSERT INTO configuration (comment_field, conf_key, conf_value,
deleted, starttime, updatetime, user_id) VALUES (?, ?, ?, ?, ?, ?, ?)}
[code=0, state=23505]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:218)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:194)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:58)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1133)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:275)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:275)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:275)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:268)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:119)
... 33 more
