Noel Grandin wrote > This looks to me like you have code that is allocating connections > from a pool, making some changes, not committing those changes, and > not bothering to close the connection.
When using the connection pooling datasource, the connection is certainly reused and potentially not closed till the jvm shutdown. But I disabled it, and I continue to experiment the db size increase. Anyway I'd expect there's no need to close a connection in order to commit changes, otherwise connection pooling would become somewhat cumbersome. About not committing the changes: I've read many times that code, and it seems they are always committed. Shouldn't I see a SESSIONS row with UNDO_LOG_SIZE greater than 0 if there was an open connection with uncommitted changes at that stage? Moreover at connection close time there are those error messages I mentioned some days ago replying to Thomas... today during the second import I've just seen a buch of errors I've never seen before It seems it is reading a record out of its bounds. I ignored them and run a 3rd import, and I got the /NullPointerException/s and /ClassCastException/ trying to cast /PageStreamData/ to /PageDataNode/. Today I also sometimes experimented some imports (2nd or 3rd) with *no error messages at connection close time and no db increase*. So it seems that importing the same data from the same origin and under the same (known) conditions results in different behaviors. Hence, assumed the errors and the db size increase are related, I still don't know the cause. Worse and worse, I don't know how to systematically reproduce that behavior... some sort of entropy is really not welcome now :-) PS: I'll reply directly to Thomas for results of running the Recover tool with the /-transactionLog/ parameter (no results). Please tell me if I should take a different approach on replies. -- View this message in context: http://h2-database.66688.n3.nabble.com/h2-Continuous-Increase-in-H2-db-size-after-dropping-and-loading-same-data-repeatedly-tp4026836p4027192.html Sent from the H2 Database mailing list archive at Nabble.com. -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
