Any news regarding my issue? The last status was: - command compact works but closes all current connection - I tried "TRANSACTION_TIMEOUT" = 33554432 but I have issue. - I tried code with TRANSACTION_START but WHERE TRANSACTION_START IS NOT NULL returns nothing.
On 23 fév, 10:56, IntensiveH2 <tlegr...@infovista.com> wrote: > 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.