I recently switched from Derby to H2. Amazing speed increase! However, I
have some concerns about the stability of this database.
This works fine:
SELECT * FROM TRE_XIGNITE where localsymbol in ('TQQQ') and
LOCALDATE2>'2010-12-24'
And this works fine:
SELECT * FROM TRE_XIGNITE where localsymbol in (''SSO') and
LOCALDATE2>'2010-12-24'
But the following gives the exception below. Any thoughts? It will be a
nightmare if lots of users of my application have corrupted databases like
this. Thanks!
SELECT * FROM TRE_XIGNITE where localsymbol in ('TQQQ','SSO') and
LOCALDATE2>'2010-12-24'
File corrupted while reading record: "page[44172] data leaf table:14
TRE_XIGNITE entries:12 parent:44161 keys:[440345, 440346, 440347, 440348,
440349, 440350, 440351, 440352, 440353, 440354, 440355, 440356]
offsets:[1939, 1836, 1739, 1630, 1522, 1421, 1318, 1213, 1105, 998, 890,
781]". Possible solution: use the recovery tool; SQL statement:
SELECT * FROM TRE_XIGNITE where localsymbol in ('TQQQ','SSO') and
LOCALDATE2>'2010-12-24'
[90030-171]<http://192.168.1.9:8082/query.do?jsessionid=02dc34894bba4fa5218509497147dffb#>
90030/90030
(Help)<http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c90030>
org.h2.jdbc.JdbcSQLException: File corrupted while reading record:
"page[44172] data leaf table:14 TRE_XIGNITE entries:12 parent:44161
keys:[440345, 440346, 440347, 440348, 440349, 440350, 440351, 440352,
440353, 440354, 440355, 440356] offsets:[1939, 1836, 1739, 1630, 1522,
1421, 1318, 1213, 1105, 998, 890, 781]". Possible solution: use the
recovery tool; SQL statement:
SELECT * FROM TRE_XIGNITE where localsymbol in ('TQQQ','SSO') and
LOCALDATE2>'2010-12-24' [90030-171]
at
org.h2.message.DbException.getJdbcSQLException(DbException.java:329<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=329&build=171>
)
at
org.h2.message.DbException.get(DbException.java:169<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=169&build=171>
)
at
org.h2.message.DbException.get(DbException.java:146<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=146&build=171>
)
at
org.h2.index.PageBtreeIndex.getPage(PageBtreeIndex.java:161<http://h2database.com/html/source.html?file=org/h2/index/PageBtreeIndex.java&line=161&build=171>
)
at
org.h2.index.PageBtreeNode.nextPage(PageBtreeNode.java:495<http://h2database.com/html/source.html?file=org/h2/index/PageBtreeNode.java&line=495&build=171>
)
at
org.h2.index.PageBtreeLeaf.nextPage(PageBtreeLeaf.java:323<http://h2database.com/html/source.html?file=org/h2/index/PageBtreeLeaf.java&line=323&build=171>
)
at
org.h2.index.PageBtreeCursor.next(PageBtreeCursor.java:59<http://h2database.com/html/source.html?file=org/h2/index/PageBtreeCursor.java&line=59&build=171>
)
at
org.h2.index.IndexCursor.next(IndexCursor.java:238<http://h2database.com/html/source.html?file=org/h2/index/IndexCursor.java&line=238&build=171>
)
at
org.h2.table.TableFilter.next(TableFilter.java:353<http://h2database.com/html/source.html?file=org/h2/table/TableFilter.java&line=353&build=171>
)
at
org.h2.command.dml.Select.queryFlat(Select.java:517<http://h2database.com/html/source.html?file=org/h2/command/dml/Select.java&line=517&build=171>
)
at
org.h2.command.dml.Select.queryWithoutCache(Select.java:622<http://h2database.com/html/source.html?file=org/h2/command/dml/Select.java&line=622&build=171>
)
at
org.h2.command.dml.Query.query(Query.java:311<http://h2database.com/html/source.html?file=org/h2/command/dml/Query.java&line=311&build=171>
)
at
org.h2.command.dml.Query.query(Query.java:281<http://h2database.com/html/source.html?file=org/h2/command/dml/Query.java&line=281&build=171>
)
at
org.h2.command.dml.Query.query(Query.java:36<http://h2database.com/html/source.html?file=org/h2/command/dml/Query.java&line=36&build=171>
)
at
org.h2.command.CommandContainer.query(CommandContainer.java:86<http://h2database.com/html/source.html?file=org/h2/command/CommandContainer.java&line=86&build=171>
)
at
org.h2.command.Command.executeQuery(Command.java:191<http://h2database.com/html/source.html?file=org/h2/command/Command.java&line=191&build=171>
)
at
org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:173<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=173&build=171>
)
at
org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=152&build=171>
)
at
org.h2.server.web.WebApp.getResult(WebApp.java:1312<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1312&build=171>
)
at
org.h2.server.web.WebApp.query(WebApp.java:1002<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1002&build=171>
)
at
org.h2.server.web.WebApp$1.next(WebApp.java:965<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=965&build=171>
)
at
org.h2.server.web.WebApp$1.next(WebApp.java:954<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=954&build=171>
)
at
org.h2.server.web.WebThread.process(WebThread.java:166<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=166&build=171>
)
at
org.h2.server.web.WebThread.run(WebThread.java:93<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=93&build=171>
)
at java.lang.Thread.run(Thread.java:722)
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
