Hello Thomas,
We noticed that if we delete the database index file to force H2 to
recreate it we sometimes get the following error when opening the
database without the index file. (MD_SEGMENTS is the table name and
the SEGMENT_ID is the primary key column).
Any idea what might be going on?
Alex
=================================================================================
...
Caused by: org.h2.jdbc.JdbcSQLException: General error:
java.lang.RuntimeException: rowcount remaining=-1 MD_SEGMENTS; SQL
statement:
CREATE PRIMARY KEY ON PUBLIC.MD_SEGMENTS(SEGMENT_ID) [50000-102]
at org/h2/message/Message.getSQLException (Unknown Source)
at org/h2/message/Message.convert (Unknown Source)
at org/h2/engine/MetaRecord.execute (Unknown Source)
at org/h2/engine/Database.open (Unknown Source)
at org/h2/engine/Database.<init> (Unknown Source)
at org/h2/engine/Engine.openSession (Unknown Source)
at org/h2/engine/Engine.openSession (Unknown Source)
at org/h2/engine/Engine.getSession (Unknown Source)
at org/h2/engine/Session.createSession (Unknown Source)
at org/h2/engine/SessionRemote.connectEmbeddedOrServer
(Unknown Source)
at org/h2/engine/SessionRemote.createSession (Unknown Source)
at org/h2/jdbc/JdbcConnection.<init> (Unknown Source)
at org/h2/jdbc/JdbcConnection.<init> (Unknown Source)
at org/h2/Driver.connect (Unknown Source)
at org/apache/commons/dbcp/
DriverConnectionFactory.createConnection (Unknown Source)
at org/apache/commons/dbcp/
PoolableConnectionFactory.makeObject (Unknown Source)
at org/apache/commons/dbcp/
BasicDataSource.validateConnectionFactory (Unknown Source)
... 12 more
Caused by: java.lang.RuntimeException: rowcount remaining=-1
MD_SEGMENTS
at org/h2/message/Message.getInternalError (Unknown Source)
at org/h2/table/TableData.addIndex (Unknown Source)
at org/h2/command/ddl/CreateIndex.update (Unknown Source)
... 27 more
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
