exception opening database

68 views
Skip to first unread message

yambo

unread,
Sep 18, 2014, 3:08:30 AM9/18/14
to h2-da...@googlegroups.com
Hi,

I upgraded from 1.3.171 to 1.4.181 yesterday.
I have sereral databases in 1 instance. java exception
They all work fine, except for 1 where I get the following when I try to connect :

org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException: 2048" [50000-181]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:168)
    at org.h2.message.DbException.convert(DbException.java:295)
    at org.h2.engine.Database.openDatabase(Database.java:297)
    at org.h2.engine.Database.<init>(Database.java:260)
    at org.h2.engine.Engine.openSession(Engine.java:60)
    at org.h2.engine.Engine.openSession(Engine.java:167)
    at org.h2.engine.Engine.createSessionAndValidate(Engine.java:145)
    at org.h2.engine.Engine.createSession(Engine.java:128)
    at org.h2.server.TcpServerThread.run(TcpServerThread.java:149)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 2048
    at org.h2.store.Data.writeVarLong(Data.java:1254)
    at org.h2.store.Data.writeValue(Data.java:523)
    at org.h2.index.PageBtreeIndex.writeRow(PageBtreeIndex.java:393)
    at org.h2.index.PageBtreeNode.writeData(PageBtreeNode.java:453)
    at org.h2.index.PageBtreeNode.write(PageBtreeNode.java:426)
    at org.h2.store.PageStore.writeBack(PageStore.java:1046)
    at org.h2.store.PageStore.writeBack(PageStore.java:418)
    at org.h2.store.PageStore.recover(PageStore.java:1436)
    at org.h2.store.PageStore.openExisting(PageStore.java:367)
    at org.h2.store.PageStore.open(PageStore.java:288)
    at org.h2.engine.Database.getPageStore(Database.java:2386)
    at org.h2.engine.Database.open(Database.java:666)
    at org.h2.engine.Database.openDatabase(Database.java:266)
    ... 7 more

any ideas ?

kind regards

willy

Thomas Mueller

unread,
Sep 18, 2014, 2:31:49 PM9/18/14
to h2-da...@googlegroups.com
Hi,

That's weird. What database URL did you usually use? Would it be possible to send me the database file? 

Regards,
Thomas
--
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 h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

wolly.be

unread,
Sep 19, 2014, 10:07:03 AM9/19/14
to h2-da...@googlegroups.com
Hi,

The url I am using : jdbc:h2:tcp://localhost/zon;DB_CLOSE_DELAY=10
Unfortunally I connot send you the database file as I accidently deleted it.
I restored the database from a backup dump. And now it seems to work fine.
I noticed that now I am using another kind of database file.

kind regards

willy
You received this message because you are subscribed to a topic in the Google Groups "H2 Database" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/h2-database/dIgZXUKD9wc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to h2-database...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages