sagarswathi / h2database

Automatically exported from code.google.com/p/h2database
0 stars 1 forks source link

java.lang.RuntimeException: rowCount expected N got M Tx.Iy [50000-164] #612

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
Notation:

N > M 
Tx: Table
Iy: Index

Excerpt from Stacktrace:
...
java.lang.RuntimeException: rowCount expected 18231 got 18196 T1995.I823
at org.h2.message.DbException.throwInternalError(DbException.java:228)
at org.h2.table.RegularTable.checkRowCount(RegularTable.java:169)
at org.h2.table.RegularTable.addRow(RegularTable.java:122)

...

Original issue reported on code.google.com by hkatzlin...@gmail.com on 14 Jul 2015 at 7:44

GoogleCodeExporter commented 8 years ago

Original comment by hkatzlin...@gmail.com on 14 Jul 2015 at 7:52

GoogleCodeExporter commented 8 years ago

Original comment by hkatzlin...@gmail.com on 14 Jul 2015 at 8:08

Attachments:

GoogleCodeExporter commented 8 years ago
I'm sorry but I will close this issue, for multiple reasons:

Did you read the comment when you opened a new issue?

"
This project was migrated to Github.
Please report new issues here:
https://github.com/h2database/h2database/issues
"

Second, you are using an old version of H2 (1.3.164).

This looks like a corrupt database. To recover the data, 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?

There is a known problem with version 1.3.171 and older: when using local 
temporary tables and not dropping them manually before closing the session, and 
then killing the process could result in a database that couldn't be opened.

Original comment by thomas.t...@gmail.com on 16 Jul 2015 at 6:08

GoogleCodeExporter commented 8 years ago

Original comment by thomas.t...@gmail.com on 16 Jul 2015 at 6:08

GoogleCodeExporter commented 8 years ago
The recovery tool does not work well and takes a lot of time. (DB-Size: ~ 1GB)

There are no local temporary tables within the database

Original comment by hkatzlin...@gmail.com on 14 Aug 2015 at 7:42