Hi Thomas,
I've been trying the new page store option, on an application that
performs around 15 million inserts and updates. Each time I've tried
(5 or 6 times) to run the app I get this exception (my app's part of
the stack trace is stripped):
Caused by: org.h2.jdbc.JdbcSQLException: General error:
java.lang.ArrayIndexOutOfBoundsException: 11; SQL statement:
update PlayerSummary set starttime=?, takeincents=?,
showdowntakeInCents=?, nonshowdowntakeInCents=?, takeinbigblinds=?,
timesseen=?, flopseen=?, vpip=?, preflopraised=?, postflopbet=?,
postflopraised=?, postflopcalled=?, postflopfolded=?,
postflopcallfoldbetorraise=?, postflopbetorraised=?,
blindstealattempt=?, blindstealattemptopportunity=?, checkraised=?,
wenttoshowdown=?, wonatshowdown=?, wonwithoutshowdown=?,
threebetpreflop=?, threebetpreflopopportunity=?,
blindStealDefenseOpportunityOnBigBlind=?, calledPreflopRaise=?,
calledPreflopRaiseOpportunity=?, continuationBetPreflop=?,
continuationBetPreflopOpportunity=?, foldedToBlindStealOnBigBlind=?,
foldedToContinuationBet=?, foldedToContinuationBetOpportunity=?,
foldedToPreflopThreeBet=?, foldedToPreflopThreeBetOpportunity=? where
playerid=? and dayid=? and tablesize=? and gametypeid=? and ishero=?
and istournament=? and isplaymoney=? [50000-116]
at org.h2.message.Message.getSQLException(Message.java:105)
at org.h2.message.Message.convert(Message.java:274)
at org.h2.table.TableData.removeRow(TableData.java:339)
at org.h2.table.Table.updateRows(Table.java:380)
at org.h2.command.dml.Update.update(Update.java:132)
at org.h2.command.CommandContainer.update(CommandContainer.java:72)
at org.h2.command.Command.executeUpdate(Command.java:208)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal
(JdbcPreparedStatement.java:140)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate
(JdbcPreparedStatement.java:129)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement
(JdbcTemplate.java:798)
at org.springframework.jdbc.core.JdbcTemplate.execute
(JdbcTemplate.java:591)
... 15 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 11
at org.h2.index.PageBtree.getRow(PageBtree.java:163)
at org.h2.index.PageBtreeLeaf.remove(PageBtreeLeaf.java:161)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:249)
at org.h2.index.PageBtreeIndex.remove(PageBtreeIndex.java:263)
at org.h2.table.TableData.removeRow(TableData.java:321)
... 23 more
This is on a Mac with OS X 10.5.7. I'm using h2 1.1.116. The problem
occurs with both Java 1.6.0_13 and 1.5.0_19. The SQL statement I am
trying to execute is an update, as part of a transaction.
My database URL is as follows:
"jdbc:h2:~/Library/Application Support/Poker Copilot/database/
pokercopilot;PAGE_STORE=TRUE"
I hope this is helpful.
Regards,
Steve McLeod
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
