Re: [h2] How can I repair database with error "#Row {1} not found in primary index "PUBLIC.SYS_DATA: 1570" [90143-196]"?

2021-03-03 Thread Thomas Frick
Hi Andreas, it worked perfectly for me!! :-) I was able to rescue every data-byte out of the damaged database with your suggested solution. Thank you very, very much. That saved my day - oh no - week. :-) Lessons learned: NEVER use a different driver version to open an existing H2 DB!

Re: [h2] How can I repair database with error "#Row {1} not found in primary index "PUBLIC.SYS_DATA: 1570" [90143-196]"?

2021-02-23 Thread Andreas Reichel
On Tue, 2021-02-23 at 10:09 -0800, Thomas Frick wrote: > Can anyone here please give me a hint on how to repair the DB and > rescue all the data in it (if it's possible)? Good Morning Thomas. http://www.h2database.com/javadoc/org/h2/tools/Recover.html (Although this has never worked for me.)

[h2] How can I repair database with error "#Row {1} not found in primary index "PUBLIC.SYS_DATA: 1570" [90143-196]"?

2021-02-23 Thread Thomas Frick
Hi there, after trying to open an existing but unmounted/inactive database within Squirrel SQL Client, i got this error message: [...] class org.h2.jdbc.JdbcSQLException: #Row {1} not found in primary index "PUBLIC.SYS_DATA: 1570" [90143-196] [...] *urgs* Each further try to open the DB in