H2 Database Engine: New version 1.4.186 available

[Thomas Mueller]

Hello,

A new version of H2 is available at http://www.h2database.com
(you may have to click 'Refresh').

For details, see the 'Change Log' at
http://www.h2database.com/html/changelog.html

For future plans, see the 'Roadmap' page at
http://www.h2database.com/html/roadmap.html

Please note the jar file may not yet be available in the
Maven central repository (synchronizing usually takes a few hours).

P.S. If you reply to this message please use a different subject.

Have fun,
Thomas

[Antonio Monforte]

Hi,

Error report:

URL :jdbc:h2:d:/biigeclipse/data/db;;AUTO_SERVER=TRUE

on SQuirrel SQL Client

Unexpected Error occurred attempting to open an SQL connection.

java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalArgumentException: timeNanos out of range 86400800000000" [50000-186]

at java.util.concurrent.FutureTask.report(Unknown Source)

at java.util.concurrent.FutureTask.get(Unknown Source)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: java.lang.RuntimeException: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalArgumentException: timeNanos out of range 86400800000000" [50000-186]

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)

... 5 more

Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalArgumentException: timeNanos out of range 86400800000000" [50000-186]

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.engine.Engine.createSession(Engine.java:26)

at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:347)

at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)

at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92)

at org.h2.Driver.connect(Driver.java:72)

at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)

at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)

... 7 more

Caused by: java.lang.IllegalArgumentException: timeNanos out of range 86400800000000

at org.h2.value.ValueTimestamp.<init>(ValueTimestamp.java:54)

at org.h2.value.ValueTimestamp.fromDateValueAndNanos(ValueTimestamp.java:68)

at org.h2.value.ValueTimestamp.fromMillisNanos(ValueTimestamp.java:95)

at org.h2.store.Data.readValue(Data.java:762)

at org.h2.index.PageDataLeaf.readRow(PageDataLeaf.java:625)

at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:335)

at org.h2.index.PageDataLeaf.getLastKey(PageDataLeaf.java:391)

at org.h2.index.PageDataNode.getLastKey(PageDataNode.java:214)

at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:87)

at org.h2.table.RegularTable.<init>(RegularTable.java:83)

at org.h2.store.PageStore.addMeta(PageStore.java:1696)

at org.h2.store.PageStore.readMetaData(PageStore.java:1627)

at org.h2.store.PageStore.recover(PageStore.java:1405)

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:2400)

at org.h2.engine.Database.open(Database.java:666)

at org.h2.engine.Database.openDatabase(Database.java:266)

... 19 more

Regards

Antómio Monforte

[Noel Grandin]

I'm sorry to say that you have a corrupt database. 

--
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.

[Thomas Mueller]

Hi,

Does it work if you open the database with an older version of H2?

Regards,

Thomas

[Antonio Monforte]

Hi,

SOLVED restoring a backup of database.

Regards

António Monforte

To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscribe@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.

--
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+unsubscribe@googlegroups.com.