Hi, I have had this exception come up when trying to query a table This is the table definition CREATE TABLE `AL_PAC_TBL` ( `PAC_ID` BIGINT(20) UNSIGNED, `PAC_STR` VARCHAR(100) PRIMARY KEY, `EXPIRE_TIME` TIMESTAMP, `USED_FLAG` CHAR(1) );
CREATE UNIQUE INDEX `AL_PAC_TBL_IDX_1` ON `AL_PAC_TBL` (`PAC_ID`); CREATE INDEX `AL_PAC_TBL_IDX_2` ON `AL_PAC_TBL` (`EXPIRE_TIME`,`USED_FLAG`); this is the query SELECT * FROM AL_PAC_TBL WHERE PAC_STR='|1088712|4080362'; this is the exception Caused by: java.lang.NullPointerException: null at org.h2.store.PageStore.readPage(PageStore.java:1250) [na:na] at org.h2.store.PageStore.getPage(PageStore.java:687) [na:na] at org.h2.index.PageBtreeIndex.getPage(PageBtreeIndex.java: 141) [na:na] at org.h2.index.PageBtreeNode.find(PageBtreeNode.java:297) [na:na] at org.h2.index.PageBtreeNode.find(PageBtreeNode.java:298) [na:na] at org.h2.index.PageBtreeNode.find(PageBtreeNode.java:298) [na:na] at org.h2.index.PageBtreeIndex.find(PageBtreeIndex.java:172) [na:na] at org.h2.index.PageBtreeIndex.find(PageBtreeIndex.java:163) [na:na] at org.h2.index.MultiVersionIndex.find(MultiVersionIndex.java: 71) [na:na] at org.h2.index.IndexCursor.find(IndexCursor.java:138) [na:na] at org.h2.table.TableFilter.next(TableFilter.java:309) [na:na] at org.h2.command.dml.Select.queryFlat(Select.java:493) [na:na] at org.h2.command.dml.Select.queryWithoutCache(Select.java: 580) [na:na] at org.h2.command.dml.Query.query(Query.java:241) [na:na] at org.h2.command.CommandContainer.query(CommandContainer.java: 80) [na:na] at org.h2.command.Command.executeQuery(Command.java:132) [na:na] at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java: 96) [na:na] ... 11 common frames omitted --------------------------- I have also had issues before where the index would get corrupted and the database would not return a result that was previously inserted, however it would not let me insert a row with the same key claiming there is an index violation. After dropping the index the 'missing' rows did show up and there appeared to be duplicates in the database where unique index was used. Any comments? Thanks -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-datab...@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.