[Glass] My extent0.dbf also grows ...

[James Foster via Glass]

Hi Marten,

The best way of analyzing these problems is by looking at logs and statistics. Are you running statmonitor? If not, then you should! If so, then we can do some analysis. Absent statistics (and even with them), we can often figure out things based on a description of the symptoms.

The extent should not grow unless there is no space in the extent. So, even though now you see a lot of free space, at the time of the growth there was no space available. While this could be due to application data (including the ObjectLog), those would tend to remain and you would not have free space now. 

The most common cause of unexpected repository growth that is resolved when you restart the database is a “commit record backlog” that comes from having a logged-in session that does not commit while other sessions are committing.

While you are running in Jade, go to the ‘All Sessions’ tab on the Transcript, click Update, and then look for a session that has an old view age. Depending on your version, there might also be something in the ‘Backlog’ column that shows the commit record backlog. If that is more than a dozen or so, you should track down the oldest session and have it do an abort or commit.

James

P.S. Note also that as a paying customer (thank you!) you may file a help request with tech support (though I’m happy to offer comments here as well).


> On Aug 22, 2015, at 11:51 PM, itlists at schrievkrom.de via Glass <glass at lists.gemtalksystems.com> wrote:
> 
> Hey,
> 
> I've also problems with the size of my extent0.dbf. Within several hours
> (running our tests) the extents grows to more than 20 GB in size.
> 
> I'm not using Seaside, but just Zinc as REST server. The tests are doing
> no big real data creation, but more or less only movements of objects
> around (the database world).
> 
> The ObjectLog has only 3000 entries (created by me) - therefore not
> really much data. The database seems to be pretty empty:
> 
> SystemRepository fileSize      21.298.675.712
> SystemRepository freeSpace     20.171.669.504
> 
> We are producing lots of HTTP requests and lots of transactions with our
> test tools.
> 
> I've not investigated much in this area - and I start the stone via
> normal startStone script - nothing else.
> 
> Any idea ?
> 
> 
> Marten
> 
> -- 
> Marten Feldtmann
> _______________________________________________
> Glass mailing list
> Glass at lists.gemtalksystems.com
> http://lists.gemtalksystems.com/mailman/listinfo/glass