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 On Tue, Oct 14, 2008 at 10:01 PM, Sady <[EMAIL PROTECTED]> wrote: > > 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) > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
