Hi Thomas,
One of my users sent this exception to me. It seems severe, based on
the error details for 90112, so I thought it was worth reporting here.
For the sake of completeness, here's some details:
final String databaseUrl =
"jdbc:h2:~/pokercopilot;" +
"MVCC=TRUE;" +
"CACHE_TYPE=SOFT_LRU;" +
"MAX_LENGTH_INPLACE_LOB=8192;" +
"DB_CLOSE_ON_EXIT=FALSE;" +
"COMPRESS_LOB=DEFLATE";
The user is running on Mac OS X 10.5.7, Java Version: 1.5.0_19, in
Colombia, using a Spanish-language locale.
Row not found when trying to delete from index
PUBLIC.PLAYERSUMMARY_SHORT_IDX; 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=? [90112-115]
at org.h2.message.Message.getSQLException(Message.java:105)
at org.h2.message.Message.getSQLException(Message.java:116)
at org.h2.message.Message.getSQLException(Message.java:75)
at org.h2.index.BtreeLeaf.remove(BtreeLeaf.java:132)
at org.h2.index.BtreeNode.remove(BtreeNode.java:147)
at org.h2.index.BtreeNode.remove(BtreeNode.java:147)
at org.h2.index.BtreeIndex.remove(BtreeIndex.java:261)
at org.h2.index.MultiVersionIndex.remove(MultiVersionIndex.java:
145)
at org.h2.table.TableData.removeRow(TableData.java:316)
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:139)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate
(JdbcPreparedStatement.java:128)
Regards,
Steve
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
