[CWB] [ cwb-Bugs-3587078 ] CQPweb: database not tracking cache files correctly

[SourceForge.net]

Bugs item #3587078, was opened at 2012-11-14 02:16
Message generated for change (Tracker Item Submitted) made by andrewhardie
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=722303&aid=3587078&group_id=131809

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: CQPweb
Group: None
Status: Open
Resolution: None
Priority: 7
Private: No
Submitted By: Andrew Hardie (andrewhardie)
Assigned to: Andrew Hardie (andrewhardie)
Summary: CQPweb: database not tracking cache files correctly

Initial Comment:
The CQPOweb database that is supposed ot keep track of the cache contents is losing track of some files. 

In my cache directory:

du -b
8577149457

But:
select sum(file_size) from saved_queries
317843000

Default cache limit: (which is NOT overridden): 3221225472.

I suspect that crashed processes result in files on disk without matching entries in the database. The files are, thus, lost track of.

Solution: admin interface for managing "orphaned" files - if possible, also add an option for superusers to be emailed with a warning if the orphaned files overspill.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=722303&aid=3587078&group_id=131809