Error on connect

[Sady]

Do you have any idea about this error ?

I was just using the database, in this morning, my system cant get
connection to database. :-(

General error: java.lang.RuntimeException: rowcount remaining=-4 SYS
[50000-76] HY000/50000 (Help)
org.h2.jdbc.JdbcSQLException: General error:
java.lang.RuntimeException: rowcount remaining=-4 SYS [50000-76]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.convert(Message.java:257)
at org.h2.engine.Database.<init>(Database.java:226)
at org.h2.engine.Engine.openSession(Engine.java:56)
at org.h2.engine.Engine.openSession(Engine.java:125)
at org.h2.engine.Engine.getSession(Engine.java:108)
at org.h2.engine.Session.createSession(Session.java:242)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:87)
at org.h2.Driver.connect(Driver.java:57)
at org.h2.server.web.WebServer.getConnection(WebServer.java:625)
at org.h2.server.web.WebThread$1LoginTask.run(WebThread.java:1159)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: rowcount remaining=-4 SYS
at org.h2.message.Message.getInternalError(Message.java:179)
at org.h2.table.TableData.addIndex(TableData.java:202)
at org.h2.engine.Database.open(Database.java:564)
at org.h2.engine.Database.<init>(Database.java:207)

[Thomas Mueller]

Hi,

I am sorry to say that, but it looks like a corruption problem. I am
very interested in analyzing and solving this problem. Corruption
problems have top priority for me. I have a few question:

- Could you send the full stack trace of the exception including message text?
- What is your database URL?
- You can find out if the database is corrupted when running
SCRIPT TO 'test.sql'
- What version H2 are you using?
It looks like you are using version 1.0.76 (2008-07-27), just to make sure.
- Did you use multiple connections?
- The first workarounds is: append ;RECOVER=1 to the database URL.
Does it work when you do this?
- The second workarounds is: delete the index.db file
(it is re-created automatically) and try again. Does it work when you do this?
- The third workarounds is: use the tool org.h2.tools.Recover to create
the SQL script file, and then re-create the database using this script.
Does it work when you do this?
- With which version of H2 was this database created?
You can find it out using:
select * from information_schema.settings where name='CREATE_BUILD'
- Do you use any settings or special features (for example, the setting LOG=0,
or two phase commit, linked tables, cache settings)?
- Is the application multi-threaded?
- What operating system, file system, and virtual machine (java
-version) do you use?
- How big is the database (file sizes)?
- Is the database usually closed normally, or is process terminated forcefully
or the computer switched off?
- Is it possible to reproduce this problem using a fresh database
(sometimes, or always)?
- Are there any other exceptions (maybe in the .trace.db file)?
Could you send them please?
- Do you still have any .trace.db files, and if yes could you send them?
- Could you send the .data.db file where this exception occurs?

Regards,
Thomas