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