Hi,
Windows 7, NTFS, H2_1.3.163, I'm using:
java -cp h2.jar org.h2.tools.Recover
java -cp h2.jar org.h2.tools.RunScript -url jdbc:h2:db -user ?? -password
?? -script db.h2.sql
On Tuesday, July 10, 2012 10:42:34 AM UTC+4, Thomas Mueller wrote:
>
> Hi,
>
> It looks like you need to manually remove this insert statement.
>
> Could you tell me what operating system and file system you used? What is
> the database URL, and which version was the database created with (to find
> out, you can search for "CREATE_BUILD" in the .h2.sql file)?
>
> Regards,
> Thomas
>
>
>
> On Tuesday, July 10, 2012, naseh wrote:
>
>> i have a corrupted File (due to power cutoff), using the recovery tool
>> results in many exceptions:
>> Error: java.lang.NegativeArraySizeException
>> Error: java.lang.ArrayIndexOutOfBoundsException: 2048
>> Error: org.h2.message.DbException: IO Exception: "java.io.EOFException";
>> "C:/Program Files/app/lib/db.h2.db" [90031-163]
>> Error: java.lang.ArrayIndexOutOfBoundsException: 2048
>> Error: java.lang.NegativeArraySizeException
>> ......
>>
>>
>> i tried RunScript with the created file and it results with:
>>
>> Exception in thread "main" org.h2.jdbc.JdbcSQLException: Column count
>> does not match; SQL statement:
>>
>> -- ERROR: exception org.h2.message.DbException: File corrupted while
>> reading record: "type: 202". Possible solution: use the recovery tool
>> [90030-163] block: 0 storageId: 46 recordLength: 5 valueId: 4
>> -- dump: ....
>> INSERT INTO O_46
>> VALUES(STRINGDECODE('\u0654q8\u02ac-xM/\u07e0\u7900\u04d7'),
>> X'30d9441622ef', 2, NULL) [21002-163]
>> at
>> org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
>> at org.h2.message.DbException.get(DbException.java:169)
>> at org.h2.message.DbException.get(DbException.java:146)
>> at org.h2.message.DbException.get(DbException.java:135)
>> at org.h2.command.dml.Insert.prepare(Insert.java:226)
>> at org.h2.command.Parser.prepareCommand(Parser.java:218)
>> at org.h2.engine.Session.prepareLocal(Session.java:415)
>> at org.h2.engine.Session.prepareCommand(Session.java:364)
>> at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1121)
>> at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:164)
>> at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152)
>> at org.h2.tools.RunScript.process(RunScript.java:253)
>> at org.h2.tools.RunScript.process(RunScript.java:186)
>> at org.h2.tools.RunScript.process(RunScript.java:317)
>> at org.h2.tools.RunScript.runTool(RunScript.java:140)
>> at org.h2.tools.RunScript.main(RunScript.java:68)
>>
>>
>>
>>
>> Any hint is appreciated
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msg/h2-database/-/sOzYvlZ_9wcJ.
>> 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.
>>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/XZNHXcXsR98J.
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.
