[Zope] Urgent - Database has consumed all possible space

[Michael Havard]

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.

>From: Jens Vagelpohl <jens@zope.com>
>To: "Michael Havard" <nhavar@hotmail.com>
>CC: zope@zope.org
>Subject: Re: [Zope] Urgent - Database has consumed all possible space
>Date: Tue, 1 Jul 2003 12:18:26 -0400
>MIME-Version: 1.0 (Apple Message framework v552)
>Received: from smtp.zope.com ([63.100.190.10]) by mc4-f30.law16.hotmail.com 
>with Microsoft SMTPSVC(5.0.2195.5600); Tue, 1 Jul 2003 09:18:36 -0700
>Received: from zope.com (piggy.zope.com [192.168.23.9])(authenticated 
>bits=0)by smtp.zope.com (8.12.5/8.12.5) with ESMTP id h61GL8v2023629;Tue, 1 
>Jul 2003 12:21:08 -0400
>X-Message-Info: JGTYoYF78jEHjJx36Oi8+Q1OJDRSDidP
>In-Reply-To: <Law9-F75Px33E1ioWwr0001965f@hotmail.com>
>Message-Id: <A4FD0B48-ABDF-11D7-9F63-000393D58818@zope.com>
>X-Mailer: Apple Mail (2.552)
>X-MailScanner: Found to be clean
>Return-Path: jens@zope.com
>X-OriginalArrivalTime: 01 Jul 2003 16:18:36.0999 (UTC) 
>FILETIME=[6CFF0570:01C33FEC]
>
>you need to pack your database. this is a normal maintenance step. log into 
>the ZMI and click on Control_Panel and then Database Management. you should 
>see a form that allows you to pack the database.
>
>jens
>
>
>On Tuesday, Jul 1, 2003, at 11:13 US/Eastern, Michael Havard wrote:
>
>>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.
>>
>>Can anyone help with this issue?
>>
>>We are running DCOracle2/OracleStorage on ZOPE 2.5.1 with CMF 1.3.
>>
>>_________________________________________________________________
>>Help STOP SPAM with the new MSN 8 and get 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 )
>

_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. 
http://join.msn.com/?page=features/junkmail