Hi,


During rollback of a transaction, I sometimes see this error:


org.h2.jdbc.JdbcSQLException: Eindeutiger Index oder Primärschlüssel 
verletzt: "PRIMARY KEY ON PUBLIC.USER_LOG"

Unique index or primary key violation: "PRIMARY KEY ON PUBLIC.USER_LOG"; 
SQL statement:

ROLLBACK [23505-173]

at org.h2.message.DbException.getJdbcSQLException(DbException.java:331) 
~[h2-1.3.173.jar:1.3.173]

at org.h2.message.DbException.get(DbException.java:171) 
~[h2-1.3.173.jar:1.3.173]

at org.h2.message.DbException.get(DbException.java:148) 
~[h2-1.3.173.jar:1.3.173]

at 
org.h2.index.PageDataIndex.getNewDuplicateKeyException(PageDataIndex.java:164) 
~[h2-1.3.173.jar:1.3.173]

at org.h2.index.PageDataIndex.add(PageDataIndex.java:142) 
~[h2-1.3.173.jar:1.3.173]

at org.h2.table.RegularTable.addRow(RegularTable.java:125) 
~[h2-1.3.173.jar:1.3.173]

at org.h2.engine.UndoLogRecord.undo(UndoLogRecord.java:112) 
~[h2-1.3.173.jar:1.3.173]

at org.h2.engine.Session.rollbackTo(Session.java:558) 
~[h2-1.3.173.jar:1.3.173]

at org.h2.engine.Session.rollback(Session.java:526) 
~[h2-1.3.173.jar:1.3.173]

at org.h2.command.dml.TransactionCommand.update(TransactionCommand.java:50) 
~[h2-1.3.173.jar:1.3.173]

at org.h2.command.CommandContainer.update(CommandContainer.java:79) 
~[h2-1.3.173.jar:1.3.173]

at org.h2.command.Command.executeUpdate(Command.java:235) 
~[h2-1.3.173.jar:1.3.173]

at org.h2.jdbc.JdbcConnection.rollbackInternal(JdbcConnection.java:1445) 
~[h2-1.3.173.jar:1.3.173]

at org.h2.jdbc.JdbcConnection.rollback(JdbcConnection.java:470) 
~[h2-1.3.173.jar:1.3.173]

at 
org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:283)
 
~[spring-jdbc-3.2.3.RELEASE.jar:3.2.3.RELEASE]

Is this a bug in h2 or my code?

h2 1.3.173

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to