Using databases created with 1.2.124 in a desktop app, I'm
occasionally getting error reports from users with this exception:
org.h2.jdbc.JdbcSQLException: General error:
"java.lang.ArrayIndexOutOfBoundsException: 0"; SQL statement:
select sum(takeinbigblinds) as takeinbigblinds from PlayerSummary f
where f.isHero=true and f.isplaymoney=? and f.istournament=? and
f.dayid>=? and f.dayid<? and f.tableSize=? and f.gametypeid=? and
buyin=? [50000-124]
at org.h2.message.Message.getSQLException(Message.java:111)
at org.h2.message.Message.convert(Message.java:288)
at org.h2.message.Message.convert(Message.java:249)
at org.h2.command.Command.executeQueryLocal(Command.java:144)
at org.h2.command.Command.executeQuery(Command.java:123)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery
(JdbcPreparedStatement.java:98)
at org.springframework.jdbc.core.JdbcTemplate
$1.doInPreparedStatement(JdbcTemplate.java:648)
at org.springframework.jdbc.core.JdbcTemplate.execute
(JdbcTemplate.java:591)
... 11 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 0
at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:310)
at org.h2.index.PageDataLeaf.getRow(PageDataLeaf.java:427)
at org.h2.index.PageDataNode.getRow(PageDataNode.java:284)
at org.h2.index.PageDataNode.getRow(PageDataNode.java:284)
at org.h2.index.PageDataIndex.getRow(PageDataIndex.java:377)
at org.h2.index.PageDataIndex.getRow(PageDataIndex.java:366)
at org.h2.table.TableData.getRow(TableData.java:116)
at org.h2.index.PageBtreeIndex.getRow(PageBtreeIndex.java:284)
at org.h2.index.PageBtreeCursor.get(PageBtreeCursor.java:46)
at org.h2.index.IndexCursor.get(IndexCursor.java:146)
at org.h2.table.TableFilter.getValue(TableFilter.java:650)
at org.h2.expression.ExpressionColumn.getValue
(ExpressionColumn.java:168)
at org.h2.expression.Comparison.getValue(Comparison.java:215)
at org.h2.expression.ConditionAndOr.getValue
(ConditionAndOr.java:86)
at org.h2.expression.Expression.getBooleanValue(Expression.java:
188)
at org.h2.command.dml.Select.queryGroup(Select.java:309)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:551)
at org.h2.command.dml.Query.query(Query.java:236)
at org.h2.command.CommandContainer.query(CommandContainer.java:
82)
at org.h2.command.Command.executeQueryLocal(Command.java:142)
... 15 more
I'm unable to reproduce, but in at least one case I know this was
preceded by a user's MacBook running out of power.
The database url is:
jdbc:h2:~/
database;DATABASE_EVENT_LISTENER='com.barbarysoftware.pokercopilot.database.DatabaseListener';MAX_LENGTH_INPLACE_LOB=65536;COMPRESS_LOB=DEFLATE;CACHE_SIZE=65536
Any suggestions?
Thanks
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.
