db size problem (4GB monster)

Jörn Paessler <[email protected]>
Newsgroups gmane.comp.cms.zms.devel
Message-ID <[email protected]>
Hi ZMS devs,

we have a big problem with an ZMS site and DB size.

Here are the facts:
- XML-export including binaries has a size of 100 MB
- the ZODB used to have a size of 400-500 MB
- suddenly, a few weeks ago, the size of the ZODB grew to twice the  
size (1 GB)
- that happened another two times, today the DB has a size of 4 GB
- packing ZODB has no effect
- trash is empty
- catalog is not active
- cache is not active
- the site does not contain large binary files or downloads, just  
several files < 1MB
- next strange behavior: exporting different nodes (level 1) produces  
4 GB .zexp files for all single nodes
- exporting as XML and importing it again into a naked site results in  
the error message "The currently logged-in user does not have the Copy  
or Move permission respective to the object zms."
- the only way to reduce the size of the DB is to delete one node by  
the other, pack and if lucky the "monster" gets found: a very time  
consuming procedure.

Did anybody make the same experience?
Does anybody have an idea what might gone wrong?

Thanks a lot for your help.

Best
Joern Paessler


Our setup:
ZMS: ZMS 2.10.5-06 (Build #129f)
ZOPE: (Zope 2.10.5-final, python 2.4.3, darwin)
PYTHON: 2.4.3 (#1, Oct 8 2006, 23:00:57) [GCC 4.0.1 (Apple Computer,  
Inc. build 5341)]
System Platform: darwin
SOFTWARE_HOME: /Applications/Zope/Zope-2.10.5/lib/python
ZOPE_HOME: /Applications/Zope/Zope-2.10.5
INSTANCE_HOME: /Users/jp/data/zope/instance-8004
CLIENT_HOME: /Users/jp/data/zope/instance-8004/var
System Time: 2008/09/30 17:00:37.711 GMT+2
Running For: 6 hours 26 sec
ZODB Location: /Users/jp/data/zope/instance-8004/var/Data.fs
Database Size: 4187.9M



-----------------------------------------------------------------------------------------------
beyond content GmbH
Dipl.-Ing. Jörn Paessler
Geschäftsführer
Burgschmietstr. 10
90419 Nürnberg, Germany
E-Mail: [email protected]
Web: www.beyond-content.de
Fon: +49 (0)911 977 98162
Fax:  +49-(0)911 787 2525
Geschäftsführer: Dipl.-Ing. Jörn Paessler
Sitz der Gesellschaft: Nürnberg
Handelsregister: Amtsgericht Nürnberg HRB 23740
USt-IdNr.: DE247571538
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.