Hi
Thanks for the test case.
This is my analysis so far. I won't have time to implement a fix right now, but
maybe someone else will.
Basically, we are leaking temporary tables. Uli, you can probably work around
this by increasing the
MAX_MEMORY_ROWS_DISTINCT
parameter.
LocalResult
is allocating a temp table (which is normally released by
LocalResult#close() )
--> Select owns the LocalResult, stored in the "lastResult" field
--> SelectUnion owns the Select, stored in the "right" field
--> Insert owns the SelectUnion, stored in the "query" field
--> CommandContainer owns the Insert in the "prepared" field.
--> CommandContainer extends Command
--> Session owns Command in the "queryCache" SmallLRUMap field.
The correct answer here is that, when we remove a Command entry from the queryCache, we need to call a new close()
method on it, Command needs to call a new close() method on Insert, which needs to call a new close() method on
SelectUnion, which needs to call a new close() method on Select, which can call close() on the LocalResult field, which
will release the temporary table.
Regards, Noel.
On 2014-03-14 10:58, Uli wrote:
The test case is attached to my post 9:07 AM.
Thanks!
On Friday, March 14, 2014 9:55:17 AM UTC+1, Noel Grandin wrote:
Sorry, then I don't know what is going on.
If you can generate a standalone test-case I could take a look at it.
On 2014-03-14 10:45, Uli wrote:
> I am using 1.3.175
>
--
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
h2-database+unsubscr...@googlegroups.com
<mailto:h2-database+unsubscr...@googlegroups.com>.
To post to this group, send email to h2-database@googlegroups.com
<mailto:h2-database@googlegroups.com>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
