Hi, I tested the compact command. I have no issue regarding "corruption" but I need time to perform additional validations. But "compact command" closed all opened connection and if you have a "pool" of connection, it's a problem The error message is: org.h2.jdbc.JdbcSQLException: Database is already closed (to disable automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-164]
Thierry. On 15 fév, 13:13, Noel Grandin <noelgran...@gmail.com> wrote: > Hi > > I had a quick bash at implementing this by taking an exclusive lock on > the DB and re-using the existing compacting code. > So I added a > COMPACT > command. > > But the unit test I added indicates that I'm corrupting the database > somehow. > > Patch attached - Thomas, perhaps you have an idea? > > Regards, Noel. > > On 2012-02-15 11:51, IntensiveH2 wrote: > > > > > > > > > Thanks for the quick answer but currently it's not possible to reboot > > my application on a regular basis because my application must ensure > > scheduling, failover, HA .... > > and it's not possible to stop it. > > I really need to have a solution at runtime without restarting my > > application. > > Thanks. > > > On 15 f�v, 10:40, Noel Grandin<noelgran...@gmail.com> wrote: > >> Not sure what Thomas' plans are, > > >> but what I can suggest is that you set this setting to a nice large number > >> -Dh2.maxCompactTime=60000 > >> And reboot your application on a regular basis. > > >> See herehttp://www.h2database.com/html/grammar.html#shutdown > >> which sets the maximum time to compact the database on shutdown (in > >> milliseconds). > > >> On 2012-02-15 11:05, IntensiveH2 wrote: > > >>> Hi, > >>> I use H2 in a commercial product and I have an issue regarding the > >>> size of the DB (with a customer). > >>> Currently the DB size is 12 GB and after a shutdown compact/restart > >>> the new size is 800 MB > >>> When you start connection on DB (12 GB) it took around 70 minutes to > >>> start (on solaris) before to shutdow it with the compact option. > >>> This is not acceptable (from customer comment). > >>> NOTE: current version used of h2 are 1.3.159, 1.3.161 and 1.3.163 (the > >>> result is the same for all version) > >>> Do you have planned (urgently) to defragment/compact at runtime > >>> (similar to SHUTDOWN COMPACT) in a background thread? > >>> Do you have another solution to avoid this issue (long startup and > >>> compact at runtime)? > >>> Best regards. > >>> Thierry. > > > > online-compact.diff > 11KAfficherTélécharger -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
