[Zope] Urgent - Database has consumed all possible space

sean.upton@uniontrib.com sean.upton@uniontrib.com
Tue, 01 Jul 2003 13:57:31 -0700


1 - Hard drive space is cheap, at least for servers you control, and as I
understand you do not control this server... I don't envy you if your DBAs
consider <2gb to be a lot of space - don't they let you account for temp
files, logs, etc???

2 - Explain that the spaces is taken up by transaction logging that isn't
properly rotated.  This is the truth (FileStorage is a logging storage), and
this is something that RDBMS admins, for example, would understand.  Explain
that after packing, the storage will take up less space.

3 - Pack regularly, and monitor your storage space; prune and delete
unnecessary/old content.


> -----Original Message-----
> From: Michael Havard [mailto:nhavar@hotmail.com]
> Sent: Tuesday, July 01, 2003 1:24 PM
> To: zope@zope.org
> Cc: plattem@inetnebr.com
> Subject: Re: [Zope] Urgent - Database has consumed all possible space
> 
> 
> 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
> 
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )
>