[ZODB-Dev] URGENT: ZODB down - Important Software Application at CERN

[Tres Seaver]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Pedro Ferreira wrote:

> Thanks a lot for your help. In fact, it was a matter of increasing the
> maximum recursion limit.
> There's still an unsolved issue, though. Each time we try to recover a
> backup using repozo, we get a CRC error. Is this normal? Has it happened
> to anyone?

I don't recall anything like that.  Can you provide a traceback?

> I guess we have a very large database, for what is normal in ZODB
> applications.

Not really:  I know of clients whose database routinely grow much larger
than yours (15 Gb, packing down to 6 Gb, right?)

> We were wondering if there's any way to optimize the size
> (and performance) of such a large database, through the removal of
> unused objects and useless data. We perform packs in a weekly basis, but
> we're not sure if this is enough, or if there are other ways of
> lightening up the DB. Any recommendations regarding this point?

Without knowing anything about the application:

- - Check that it is not holding onto "old" data inappropriately
  (e.g., maintaining lots of "archival" versions of content).

- - Check into the catalog / index usage:  you may be able to slow
  the growth by batching updates, especially to text indexes.


Tres.
- --
===================================================================
Tres Seaver          +1 540-429-0999          tseaver at palladion.com
Palladion Software   "Excellence by Design"    http://palladion.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFKGsvu+gerLs4ltQ4RApw+AKCOHgdPvKFsEXYnGRngrKLkwz5JrwCeNk+9
6RG4zZcUSw881nEWw5qKAEE=
=biZk
-----END PGP SIGNATURE-----