sorry CREATE_BUILD 158;
im using H2_1.3.163 for the recover
On Tuesday, July 10, 2012 11:20:52 AM UTC+4, naseh wrote:
>
> 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/-/U1fJ9TulZQIJ.
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.
