Re: [h2] TimeNanos out of range when using different version of jar - No check when DB upgraded

2016-11-28 Thread Petr Holík | EgoPanda
Hello Noel, thanks for clarification. > I suggest you revert to an earlier version, do a dump, and restore into the new version, after fixing up the data. That's exactly what I did - I am unwanted H2 recovery expert :( I have recently recovered about 20-30 corrupted customer's databases :(

Re: [h2] SHUTDOWN COMPACT does not recover space SHUTDOWN DEFRAG take insanely long Opening DB takes 500Mb of space

2016-11-24 Thread Petr Holík | EgoPanda
Hello Thomas, it makes a sense we are using CLOBs in our database extensively. And it often ends with Missing LOB entry(which i've reported on github) or database with wasted space (after deleting data mostly from table which contains CLOBs). Propably is something broken in H2 in handling (C)LOB.