Hi there,
a customer of ours is experiencing regular database exception which I
don't know how to fix.
The exception is:
org.h2.jdbc.JdbcSQLException: General error:
"java.lang.ArrayIndexOutOfBoundsException: 127"; SQL statement:
UPDATE SF_INCIDENT SET sFPatientID = NULL, sFActorID = NULL, TYPE =
NULL WHERE (INCIDENT_ID = ? AND CALL_Mode is NULL AND CLOSED = ? AND
DISABLED = ? AND EXTERNAL_ID is NULL AND EXTERNAL_SESSION_ID is NULL
AND HASDOCUMENTS = ? AND HASGOALS = ? AND HASMVK = ? AND
HASPERSISTINGDIAGNOSIS = ? AND HASTHERAPEUTIC = ? AND PATIENT_COMMENT
is NULL AND sFActorID = ? AND sFPatientID = ? AND sFTaskID is NULL AND
TIME_CONTEXT = ? AND TYPE = ?) [50000-151]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
327)
at org.h2.message.DbException.get(DbException.java:156)
at org.h2.message.DbException.convert(DbException.java:279)
at org.h2.table.RegularTable.removeRow(RegularTable.java:379)
at org.h2.table.Table.updateRows(Table.java:417)
at org.h2.command.dml.Update.update(Update.java:125)
at org.h2.command.CommandContainer.update(CommandContainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java:211)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:
143)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:
129)
... some exceptions by the ORM (EOF in this case)...
java.lang.ArrayIndexOutOfBoundsException: 127
at org.h2.index.PageBtree.getRow(PageBtree.java:172)
at org.h2.index.PageBtreeLeaf.remove(PageBtreeLeaf.java:222)
at org.h2.index.PageBtreeNode.remove(PageBtreeNode.java:324)
at org.h2.index.PageBtreeIndex.remove(PageBtreeIndex.java:237)
at org.h2.table.RegularTable.removeRow(RegularTable.java:361)
As you can see, H2 1.3.151 is being used. The database was created
originally using 1.2.125 or 1.2.147 (I can't be sure, I wasn't
involved at the time). I did a full export and restore using 1.3.151,
but the problem persists.
I downloaded the data to my machine and so far I couldn't even
reproduce the problem.
Thanks for any help,
- Marius
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
