I test http session persistence to db with latest WildFly application server (Beta2-SNAPSHOT, h2 1.3.173). I have two nodes running in my test, where failover is tested and I use this connection url - "jdbc:h2:file;AUTO_SERVER=true". I need to use file storing, because of server shutdown failover. Occassionally I am facing following exception:
Unique index or primary key violation: "PRIMARY_KEY_A ON >> PUBLIC.""binarybased_default_host_session_db_cluster""(ID)"; SQL statement: > > INSERT INTO "binarybased_default_host_session_db_cluster" (datum, version, >> id) VALUES(?,?,?) [23505-159] > > at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) > > at org.h2.message.DbException.get(DbException.java:169) > > at org.h2.message.DbException.get(DbException.java:146) > > at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:81) > > at org.h2.index.PageBtree.find(PageBtree.java:121) > > at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:146) > > at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:100) > > at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:105) > > at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:96) > > at org.h2.table.RegularTable.addRow(RegularTable.java:130) > > at org.h2.command.dml.Insert.insertRows(Insert.java:124) > > at org.h2.command.dml.Insert.update(Insert.java:84) > > at org.h2.command.CommandContainer.update(CommandContainer.java:71) > > at org.h2.command.Command.executeUpdate(Command.java:212) > > at >> org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143) > > at >> org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:129) > > You can see full stack trace (slightly different) at https://issues.jboss.org/browse/WFLY-2409. I am not really sure, what could be the problem. I'll appreciate any suggestions. Thank's in advance. Tom -- 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.
