db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Very bad disk space leak in Derby
Date Fri, 30 Apr 2010 22:12:46 GMT
On 04/30/10 23:38, David Van Couvering wrote:
> Hi, all. 
> 
> I have a thread that runs the following query every 10 seconds:
> 
> SELECT d.ITEMSET_ID, f.FILTER_INDEX, FROM FILTERS f, PENDING_DELIVERIES
> d WHERE f.ITEMSET_ID = d.ITEMSET_ID AND f.FILTER_INDEX = d.FILTER_INDEX
> AND d.SENT = 0 AND d.SERVER_ID = 1
> 
> The FILTERS table has about 200 rows in it, and the PENDING_DELIVERIES
> table has no rows.  So this query returns zero rows each time it is run.
> 
> My database directory is growing by about *1 MB *! every 30 seconds.
> 
> This is the *only* query running.  The number of rows in my tables never
> changes. 

Hi David,

You may already have done so, but to verify that there is no other
thread adding data, you could set the derby.language.logStatementText
property and check derby.log to see which statements are executed.

-- 
Knut Anders

Mime
View raw message