You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@wookie.apache.org by Gunith Devasurendra <gu...@gmail.com> on 2009/12/12 17:41:26 UTC
Errors installing in Ubuntu 9.04
Hi,
I was trying to install Wookie (in the standalone mode) I get this
With normal user privileges, ant run (also tried ant clean-build run) I get
this,
[java] 21:38:05,635 ERROR JDBCExceptionReporter:101 - The statement was
aborted because it would have caused a duplicate key value in a unique or
primary key constraint or unique index identified by 'SQL091212204704060'
defined on 'WIDGET'.
[java] Exception in thread "main"
org.hibernate.exception.ConstraintViolationException: could not execute
native bulk manipulation query
[java] at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
[java] at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
[java] at
org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:198)
[java] at
org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1190)
[java] at
org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:357)
[java] at
org.apache.wookie.server.Start.configureDatabase(Start.java:58)
[java] at org.apache.wookie.server.Start.main(Start.java:36)
[java] Caused by: java.sql.SQLIntegrityConstraintViolationException:
The statement was aborted because it would have caused a duplicate key value
in a unique or primary key constraint or unique index identified by
'SQL091212204704060' defined on 'WIDGET'.
[java] at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source)
[java] at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
[java] at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
[java] at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
[java] at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
[java] at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
[java] at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
[java] at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
[java] at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
[java] at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
[java] at
org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:189)
[java] ... 4 more
[java] Caused by: java.sql.SQLException: The statement was aborted
because it would have caused a duplicate key value in a unique or primary
key constraint or unique index identified by 'SQL091212204704060' defined on
'WIDGET'.
[java] at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
[java] at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
[java] ... 15 more
[java] Caused by: ERROR 23505: The statement was aborted because it
would have caused a duplicate key value in a unique or primary key
constraint or unique index identified by 'SQL091212204704060' defined on
'WIDGET'.
[java] at
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
[java] at
org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown
Source)
[java] at
org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source)
[java] at
org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)
[java] at
org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source)
[java] at
org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source)
[java] at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source)
[java] at
org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
[java] at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
[java] ... 9 more
BUILD FAILED
/data/projects/wookie/trunk/build.xml:39: The following error occurred while
executing this line:
/data/projects/wookie/trunk/ant/ivy-java-common.xml:106: Java returned: 1
I get this even with SU Priviledges. Any hint in how to resolve this would
be really helpful.
Thanks in advance*
*
--
Regards,
Gunith Devasurendra - ගුණිත් දේවසුරේන්ද්ර
linkedin.com/in/gunith - facebook.com/gunith - foss.lk
Re: Errors installing in Ubuntu 9.04
Posted by Gunith Devasurendra <gu...@gmail.com>.
Thanks Scott! It worked!!
On Sun, Dec 13, 2009 at 4:52 AM, Scott Wilson <
scott.bradley.wilson@gmail.com> wrote:
> Hi Gunith,
>
> This is caused if you shutdown and re-run Wookie in standalone (testing)
> mode without first clearing the database.
>
> If you type:
>
> ant clean-db run
>
> This should work OK.
>
> S
>
> On 12 Dec 2009, at 16:41, Gunith Devasurendra wrote:
>
> Hi,
>
> I was trying to install Wookie (in the standalone mode) I get this
>
> With normal user privileges, ant run (also tried ant clean-build run) I get
> this,
> [java] 21:38:05,635 ERROR JDBCExceptionReporter:101 - The statement
> was aborted because it would have caused a duplicate key value in a unique
> or primary key constraint or unique index identified by 'SQL091212204704060'
> defined on 'WIDGET'.
> [java] Exception in thread "main"
> org.hibernate.exception.ConstraintViolationException: could not execute
> native bulk manipulation query
> [java] at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
> [java] at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
> [java] at
> org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:198)
> [java] at
> org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1190)
> [java] at
> org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:357)
> [java] at
> org.apache.wookie.server.Start.configureDatabase(Start.java:58)
> [java] at org.apache.wookie.server.Start.main(Start.java:36)
> [java] Caused by: java.sql.SQLIntegrityConstraintViolationException:
> The statement was aborted because it would have caused a duplicate key value
> in a unique or primary key constraint or unique index identified by
> 'SQL091212204704060' defined on 'WIDGET'.
> [java] at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
> Source)
> [java] at
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> [java] at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> [java] at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
> [java] at
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> [java] at
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> [java] at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
> [java] at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
> Source)
> [java] at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
> Source)
> [java] at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
> [java] at
> org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:189)
> [java] ... 4 more
> [java] Caused by: java.sql.SQLException: The statement was aborted
> because it would have caused a duplicate key value in a unique or primary
> key constraint or unique index identified by 'SQL091212204704060' defined on
> 'WIDGET'.
> [java] at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> [java] at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> [java] ... 15 more
> [java] Caused by: ERROR 23505: The statement was aborted because it
> would have caused a duplicate key value in a unique or primary key
> constraint or unique index identified by 'SQL091212204704060' defined on
> 'WIDGET'.
> [java] at
> org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> [java] at
> org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown
> Source)
> [java] at
> org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source)
> [java] at
> org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)
> [java] at
> org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source)
> [java] at
> org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source)
> [java] at
> org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
> Source)
> [java] at
> org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
> [java] at
> org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
> [java] ... 9 more
>
> BUILD FAILED
> /data/projects/wookie/trunk/build.xml:39: The following error occurred
> while executing this line:
> /data/projects/wookie/trunk/ant/ivy-java-common.xml:106: Java returned: 1
>
>
> I get this even with SU Priviledges. Any hint in how to resolve this would
> be really helpful.
>
> Thanks in advance*
>
> *
> --
> Regards,
> Gunith Devasurendra - ගුණිත් දේවසුරේන්ද්ර
>
> linkedin.com/in/gunith - facebook.com/gunith - foss.lk
>
>
>
--
Regards,
Gunith Devasurendra - ගුණිත් දේවසුරේන්ද්ර
linkedin.com/in/gunith - facebook.com/gunith - foss.lk
Re: Errors installing in Ubuntu 9.04
Posted by Scott Wilson <sc...@gmail.com>.
Hi Gunith,
This is caused if you shutdown and re-run Wookie in standalone
(testing) mode without first clearing the database.
If you type:
ant clean-db run
This should work OK.
S
On 12 Dec 2009, at 16:41, Gunith Devasurendra wrote:
> Hi,
>
> I was trying to install Wookie (in the standalone mode) I get this
>
> With normal user privileges, ant run (also tried ant clean-build
> run) I get this,
> [java] 21:38:05,635 ERROR JDBCExceptionReporter:101 - The
> statement was aborted because it would have caused a duplicate key
> value in a unique or primary key constraint or unique index
> identified by 'SQL091212204704060' defined on 'WIDGET'.
> [java] Exception in thread "main"
> org.hibernate.exception.ConstraintViolationException: could not
> execute native bulk manipulation query
> [java] at
> org
> .hibernate
> .exception.SQLStateConverter.convert(SQLStateConverter.java:94)
> [java] at
> org
> .hibernate
> .exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
> [java] at
> org
> .hibernate
> .engine
> .query
> .NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:198)
> [java] at
> org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:
> 1190)
> [java] at
> org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:357)
> [java] at
> org.apache.wookie.server.Start.configureDatabase(Start.java:58)
> [java] at org.apache.wookie.server.Start.main(Start.java:36)
> [java] Caused by:
> java.sql.SQLIntegrityConstraintViolationException: The statement was
> aborted because it would have caused a duplicate key value in a
> unique or primary key constraint or unique index identified by
> 'SQL091212204704060' defined on 'WIDGET'.
> [java] at
> org
> .apache
> .derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
> [java] at
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> [java] at
> org
> .apache
> .derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> [java] at
> org
> .apache
> .derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
> [java] at
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
> Source)
> [java] at
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
> Source)
> [java] at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
> Source)
> [java] at
> org
> .apache
> .derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
> Source)
> [java] at
> org
> .apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
> Source)
> [java] at
> com
> .mchange
> .v2
> .c3p0
> .impl
> .NewProxyPreparedStatement
> .executeUpdate(NewProxyPreparedStatement.java:105)
> [java] at
> org
> .hibernate
> .engine
> .query
> .NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:189)
> [java] ... 4 more
> [java] Caused by: java.sql.SQLException: The statement was
> aborted because it would have caused a duplicate key value in a
> unique or primary key constraint or unique index identified by
> 'SQL091212204704060' defined on 'WIDGET'.
> [java] at
> org
> .apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> [java] at
> org
> .apache
> .derby
> .impl
> .jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
> Source)
> [java] ... 15 more
> [java] Caused by: ERROR 23505: The statement was aborted
> because it would have caused a duplicate key value in a unique or
> primary key constraint or unique index identified by
> 'SQL091212204704060' defined on 'WIDGET'.
> [java] at
> org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> [java] at
> org
> .apache
> .derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown
> Source)
> [java] at
> org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown
> Source)
> [java] at
> org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)
> [java] at
> org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown
> Source)
> [java] at
> org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown
> Source)
> [java] at
> org
> .apache
> .derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
> Source)
> [java] at
> org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
> [java] at
> org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
> Source)
> [java] ... 9 more
>
> BUILD FAILED
> /data/projects/wookie/trunk/build.xml:39: The following error
> occurred while executing this line:
> /data/projects/wookie/trunk/ant/ivy-java-common.xml:106: Java
> returned: 1
>
>
> I get this even with SU Priviledges. Any hint in how to resolve this
> would be really helpful.
>
> Thanks in advance
>
>
> --
> Regards,
> Gunith Devasurendra - ගුණිත්
> දේවසුරේන්ද්ර
>
> linkedin.com/in/gunith - facebook.com/gunith - foss.lk
>