[Zope] Urgent - Database has consumed all possible space

[Michael Havard]

If it were only so easy. This is a shared box with many other applications 
and databases on it. Our database was only supposed to take up 200-300mb NOT 
1.8gb big difference. The DBA's have scrounged for extra space and given me 
all they could. Hard drive space for these machines is expensive and not 
something I can just ask for. Plus I still need to explain why 200-300mb 
worth of text files exploded in ZOPE to 1.8gb of information.


>From: Matthew Platte <plattem@inetnebr.com>
>To: Michael Havard <nhavar@hotmail.com>
>Subject: Re: [Zope] Urgent - Database has consumed all possible space
>Date: Tue, 01 Jul 2003 13:45:09 -0500
>MIME-Version: 1.0
>Received: from duck.inebraska.com ([199.184.119.13]) by 
>mc10-f41.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Tue, 1 Jul 
>2003 11:44:19 -0700
>Received: from lin-dsl-static-206-222-213-206.inetnebr.com 
>(lin-dsl-static-206-222-213-206.inetnebr.com [206.222.213.206])by 
>duck.inebraska.com (8.12.7/8.12.7) with ESMTP id h61IiHMv021926for 
><nhavar@hotmail.com>; Tue, 1 Jul 2003 13:44:17 -0500 (CDT)
>Received: from inetnebr.com (lin-dsl-static-206-222-213-205.inetnebr.com 
>[206.222.213.205])by lin-dsl-static-206-222-213-206.inetnebr.com (Postfix) 
>with ESMTP id C25BA105344for <nhavar@hotmail.com>; Tue,  1 Jul 2003 
>13:43:47 -0500 (CDT)
>X-Message-Info: JGTYoYF78jEHjJx36Oi8+Q1OJDRSDidP
>Message-ID: <3F01D6B5.3030602@inetnebr.com>
>User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.1) 
>Gecko/20020826
>X-Accept-Language: en-us, en
>References: <Law9-F477yeZNCKWnXp0001219d@hotmail.com>
>Return-Path: plattem@inetnebr.com
>X-OriginalArrivalTime: 01 Jul 2003 18:44:19.0491 (UTC) 
>FILETIME=[C7ED6F30:01C34000]
>
>Michael Havard wrote:
>>We've already tried packing. It keeps failing because of insufficient 
>>space in the DB. When it fails I get the distinct feeling that we're 
>>orphaning records and not really removing them from the DB which makes the 
>>pack an even larger process next time.
>
>>>>We are migrating data from an IIS server - approximately 200mb via FTP 
>>>>today I am told that the ZOPE tables now consume more than 1.8gb. How is 
>>>>it possible for 200mb of data to consume 1.8gb of database space and 
>>>>what can I do to correct it.
>
>
>Get a bigger drive. If 1.8GB is filling up the drive it was way too 
>small/full in the first place.
>
>Then, when panic/things have settled down a bit, investigate and fix the 
>bloat problem.
>
>--
>-------^.^--
>
>

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail