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