System error on trying to configure mysql with confluence 3.5.2

[Amey Nevrenkar]

Hi

I am trying to install confluence 3.5.2 . exe for the 1st time and trying to configure mysql with that, but when I do so I am getting a system error.

[Luis Mayora]

It seems that the hsqldb the one that is installed by default is corrupted for some reason. I will go ahead and install everything from scratch.

1. Create a MySQl DB with its user and permissions.

2. Edit the Confluence Configuration Files.

3. Start Confluence

Follow this instructions.

http://confluence.atlassian.com/display/DOC/Database+Setup+For+MySQL

[Amey Nevrenkar]

Hi Louis

Thanks for replying!

Yeah I did follow all the instructions but still got the error.

error is as follow:

Cause

org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.pages.Page#327759]; SQL []; integrity constraint violation: unique constraint or index violation; SYS_PK_10190 table: CONTENT; nested exception is java.sql.SQLException: integrity constraint violation: unique constraint or index violation; SYS_PK_10190 table: CONTENT
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:110)

caused by: java.sql.SQLException: integrity constraint violation: unique constraint or index violation; SYS_PK_10190 table: CONTENT
at org.hsqldb.jdbc.Util.sqlException(Util.java:215)

caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_10190 table: CONTENT
at org.hsqldb.error.Error.error(Error.java:131)

Stack Trace:[hide]

org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.pages.Page#327759]; SQL []; integrity constraint violation: unique constraint or index violation; SYS_PK_10190 table: CONTENT; nested exception is java.sql.SQLException: integrity constraint violation: unique constraint or index violation; SYS_PK_10190 table: CONTENT
Caused by: java.sql.SQLException: integrity constraint violation: unique constraint or index violation; SYS_PK_10190 table: CONTENT
	at org.hsqldb.jdbc.Util.sqlException(Util.java:215)
	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(JDBCPreparedStatement.java:4613)
	at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(JDBCPreparedStatement.java:308)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
	at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
	at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
	at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
	at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
	at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2447)
	at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2433)
	at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2390)
	at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2259)
	at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
	at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:510)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:662)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
	at com.atlassian.xwork.interceptors.TransactionalInvocation.commitOrRollbackTransaction(TransactionalInvocation.java:107)
	at com.atlassian.xwork.interceptors.TransactionalInvocation.access$000(TransactionalInvocation.java:18)
	at com.atlassian.xwork.interceptors.TransactionalInvocation$1.beforeResult(TransactionalInvocation.java:49)

[Luis Mayora]

Could you please send the error message or exception. Did you follow all installation instructions?.