Please, can you send me directly the jar file also. I don't have the
build environment yet.
On 20 fév, 17:25, Noel Grandin <noelgran...@gmail.com> wrote:
> Make sure you can build and test the H2 source code locally, and I'll
> make you a patch tomorrow for displaying the transaction start time in
> the SESSIONS table.
>
> Then you can log the output of that table regularly to see who the culprit is.
>
>
>
>
>
>
>
> On Mon, Feb 20, 2012 at 18:16, IntensiveH2 <tlegr...@infovista.com> wrote:
> > For information
> > My connection string is:
> > jdbc:h2:file:D:\ProductDev\cockpitconsole\build\projects\mserver\dist
> > \h2\cockpit
> > \cockpit;MVCC=TRUE;AUTOCOMMIT=OFF;LOCK_MODE=3;LOG=2;CACHE_TYPE=SOFT_LRU
> > I change also some settings like:
> > statement.execute("set WRITE_DELAY 0");
> > statement.execute("SET MAX_MEMORY_ROWS 10000");
> > statement.execute("SET MAX_LOG_SIZE 32");
>
> > Also, When I shutdow defrag the DB size moves from 12GB to 800 MB but
> > after a Recover tool to extract SQL and a redo in a fresh DB the size
> > is 200MB.
> > After, I shutdown compact again and the DB size is 80 MB.
>
> > I don't really understand how I can progress on the subject.
> > It's very important for me because the DB grows on customer side
> > (200MB per day for nothing) and I don't know how to fix it.
>
> > On 18 fév, 08:27, Thomas Mueller <thomas.tom.muel...@gmail.com> wrote:
> >> Hi,
>
> >> > Can I add some debug settings on customer side?
>
> >> There are two options:
>
> >> - Use the trace options to analyze the JDBC method calls (append
> >> ;TRACE_LEVEL_FILE=3 to the database URL)
>
> >> - Use the Recover tool to find out if there are uncommitted
> >> transactions in the (large) database file (or a copy of the file; in
> >> this case you could even copy the database file while it's in use,
> >> because you don't need a 'save' copy of the database just to analyze
> >> the transaction log).
>
> >> > Perhaps we need to implement some kind of default timeout on how long a
> >> > transaction can stay open?
>
> >> Thats a very good idea. I wonder if other databases support something
> >> like this?
>
> >> At the very least there should be a warning in the .trace.db file. I
> >> will have a look at that.
>
> >> Regards,
> >> Thomas
>
> > --
> > 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
> > athttp://groups.google.com/group/h2-database?hl=en.
--
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.
