There is a bug in JackRabbit 1.3 that prevents blobs stored in the DB from being removed when the container document is deleted.
See : https://issues.apache.org/jira/browse/JCR-832
As a consequence, JCR Repositories that are configured to store blobs in the DB always grow and never release the allocated disk space.
As we recommend it, most people do not store Blob in the SQL DB and do not have the problem.
- JCR repository based on JackRabbit 1.3 (Nuxeo < 5.2.RC) is safe as long as blobs are on FileSystem.
- JCR repository based on JackRabbit 1.4 (starting with Nuxeo 5.2.RC) is safe.
- Nuxeo SQL repository is safe
If you use JackRabbit 1.3 with Blob in DB, you have 3 options:
- upgrade to 5.2 to use JackRabbit 1.4 or Nuxeo SQL repository
- change your storage configuration to have blobs stored on FileSystem (see here)
- use a SQL script to clean up the unused blobs
You can find here a sample PGSQL script.
Tested with PostgreSQL 8.3 (psql support needed).
Labels:
None