Corrupted databases - observation

46 views
Skip to first unread message

Silvio

unread,
Jun 18, 2019, 7:47:11 AM6/18/19
to H2 Database
I have been closely monitoring H2 databases being used on my servers that, as I described earlier, each maintain tens to a couple hundred concurrent connections to up to a couple thousand H2 databases. Some of these now run on h2-1.4.196.jar while most use h2-1.4.199.jar. I already reported many database corruptions on servers using 199 and hardly a one on those running 196.

BUT:

A couple of weeks ago we have gradually started upgrading servers from OpenJDK11 to OpenJDK12. Coincident or not; corruptions stopped occurring in the JDK12 servers while they continued on the JDK11/h2-199 servers. Eight days ago we upgraded the last server and since then we had only one corruption: the PageStore error I reported a couple of days ago. All the other corruptions where MVStore ones and they have not occurred on a JDK12 server yet.

This may be purely coincidental but I wonder if anyone more involved in the H2 internals can think of any reason why the problem might occur on JDK11/h2-199 but might not occur on JDK12 (and perhaps also not on older JDK versions used by others) or other H2 versions.

I am just guessing here and I could be too hasty with my conclusion that problems occur less/not on JDK12. But any reactions on this would be highly appreciated.

Reply all
Reply to author
Forward
0 new messages