Re: [h2] Confused with the usage difference of org.h2.mvstore.type.XXXType and org.h2.value.DataType

thanks a lot !!! -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to

[h2] Re: Wait for getting connection infinitely

Hi Thomas. Thank you for reply. >What I would check is that you use the same version of H2 on the client and on the server. Both client and server use V1.3.176. When this issue occurred, the server OS was just shutting down. >I don't know what "stoped" means. Sorry, It's typo. THe correct spell

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

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.

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

Hi, It could be due to LOG data (BLOB, CLOB) that are not referenced, and not correctly garbage collected. To analyze that, we would need a reproducible test case. To find out, you could use the Recover tool on the large database. Regards, Thomas On Tuesday, November 22, 2016, Petr Holík

Re: [h2] Wait for getting connection infinitely

I'm sorry there is not enough data to reproduce or analyze this. What I would check is that you use the same version of H2 on the client and on the server. > UnfortunaIy my system was stoped 3 times recently. I don't know what "stoped" means. On Monday, November 21, 2016, yone

Re: [h2] H2 Database running really slow on mac OS sierra

Hi, Yes, I guess the problem is that somehow it's trying to resolve "localhost". I'm hoping there is a simple workaround for H2, but I'm not sure. Regards, Thomas On Saturday, November 19, 2016, wrote: > Update: I downloaded the tester from thoeni.io and ran the test

Re: [h2] Confused with the usage difference of org.h2.mvstore.type.XXXType and org.h2.value.DataType

Hi, The MVStore is a key-value storage engine that knows nothing about SQL, and can be used without the relational database engine. So the MVStore data type is used for that. The org.h2.value.DataType is the data type used for SQL (relational database) stuff. Regards, Thomas On Wednesday,

Re: [h2] Investigating large DBs

Hi, This last time there was also an index corruption, so we could not do a > dump and restore. > Hm, you should still be able to use "script to...". Did this not work? > > Do you have any suggestions on how to investigate the cause of this? E.g. > I have seen some threads mentioning the

Re: [h2] H2 Database running really slow on mac OS sierra

Hi, Yes, I guess the problem is that somehow it's trying to resolve "localhost". I'm hoping there is a simple workaround for H2, but I'm not sure. Regards, Thomas On Saturday, November 19, 2016, wrote: > Update: I downloaded the tester from thoeni.io and ran the test

Re: [h2] Confused with the usage difference of org.h2.mvstore.type.XXXType and org.h2.value.DataType

Hi, The MVStore is a key-value storage engine that knows nothing about SQL, and can be used without the relational database engine. So the MVStore data type is used for that. The org.h2.value.DataType is the data type used for SQL (relational database) stuff. Regards, Thomas On Wednesday,

Re: [h2] Wait for getting connection infinitely

I'm sorry there is not enough data to reproduce or analyze this. What I would check is that you use the same version of H2 on the client and on the server. > UnfortunaIy my system was stoped 3 times recently. I don't know what "stoped" means. On Monday, November 21, 2016, yone

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

Hi, It could be due to LOG data (BLOB, CLOB) that are not referenced, and not correctly garbage collected. To analyze that, we would need a reproducible test case. To find out, you could use the Recover tool on the large database. Regards, Thomas On Tuesday, November 22, 2016, Petr Holík

[h2] Sudden database corruption

Hi, Yesterday we got a very strange and serious problem. We run H2 on 5 servers and suddenly, in relatively same time, all the database gets corrupted. I tried to recover it, but no luck. We are using the latest 1.4.193 version. If anyone willing to see the database sample, you can check below

Re: [h2] Data stored in the INFORMATION_SCHEMA.LOBS and INFORMATION_SCHEMA.LOB_MAP tables seems to blow up our database

On 2016/11/24 12:02 PM, Reinhold Bihler wrote: Another approach would be to monitor the count of entries in the INFORMATION_SCHEMA.LOBS and INFORMATION_SCHEMA.LOB_MAP. What do you think? Does this sound more promising? yes, good idea, If it is a LOB problem, that will point it out fairly

Re: [h2] Data stored in the INFORMATION_SCHEMA.LOBS and INFORMATION_SCHEMA.LOB_MAP tables seems to blow up our database

I did write some code that monitors the database file size. But there seems to be no clear relationship between insert and delete queries and the size of the database file. Database file size changes seem to happen very rarely. Is this because we use hibernate or is it a general behavior of H2?