[CWB] CRITICAL ERROR - CACHE OVERLOAD!

Hardie, Andrew a.hardie at lancaster.ac.uk
Wed Jan 11 12:54:32 CET 2017


If they don’t delete through the interface, the only explanation is that the files are not “owned” by the web daemon’s username…..

>> but how can I delete those files that are still mentioned at the Query cache leak monitor

….meaning you have to delete them on the command line with rm or sudo rm.

best

Andrew.

From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of "Andrés Chandía"
Sent: 11 January 2017 11:51
To: Open source development of the Corpus WorkBench
Subject: Re: [CWB] CRITICAL ERROR - CACHE OVERLOAD!

Ok, I've added this parameter to my config file:
$query_cache_size_limit = 9663676416;

and deleted all the cache leaked files except for some that do not delete when clicking the button and I can not find them, they are not in the database nor in the cqp directory:

______tempfreq_ctilcglicom.tbl  26,556  2016-Oct-13 19:00:14
____temporary_freq_corpus_bnc_malt_parsed.tbl   502,065 2012-Nov-20 12:08:06
____temporary_freq_corpus_bnc_malt_parsed.tbl.utf8.tmp  255,697 2012-Nov-20 12:09:09
____temporary_freq_corpus_oldes.tbl     24,290  2012-Nov-15 18:28:55
____temporary_freq_corpus_wikica.tbl    62,176  2012-Oct-25 14:04:33
___install_temp_ladino_old.txt  7,514   2013-May-23 08:48:37

the CRITICAL ERROR - CACHE OVERLOAD! is gone and I can download the files, but how can I delete those files that are still mentioned at the Query cache leak monitor, I've deleted also all the tables appearing at the temporary database control, just in case, but those files remain at the leak monitor.

Thanks



El Mar, 10 de Enero de 2017, 18:29, Hardie, Andrew escribió:
El Mar, 10 de Enero de 2017, 13:23, "Andrés Chandía" escribió:

How can this be solved:

CRITICAL ERROR - CACHE OVERLOAD!

CQPweb tried to clear cache space but failed!
This indicates that the system has tried to delete cached queries from disk to bring the size of the cache folder down to the set limit, but could not do so.
Reasons this can happen:

••
Your cache size is configured too small ( see admin manual page 26 -
$query_cache_size_limit)

••
You have a lot fo very big saved queries (which are never deleted and so can take over your cache if there are too many).

••
You have some kind of cache leak. Use the “Cache control > query cache” tool in the admin control panel to investigate.
Corpus ``fblsumfziw'' is undefined

Obviously I have no corpus named "fblsumfziw"
“fblsumfziw” is an “instance name” (based on microseconds since 1970-01-01
encoded in base 36). It uniquely identifies the run of the script, and is used when queries are saved to cache. “fblsumfziw” in particular derives from a timestamp from
about five hours ago.
Also: When CQP says a “corpus” is “undefined” that also includes subcorpora (which are a type of corpus) and queries (which are a type of subcorpus).
So again this sounds like a cache leak of some description: the file with the cached query does not exist, but CQPweb thinks it does, probably because there
is an orphaned record in query cache table.
Again, cache control should allow you to work out what the issues are and delete the orphaned cache entries.
best
Andrew.
From: cwb-bounces at sslmit.unibo.it<mailto:cwb-bounces at sslmit.unibo.it> [mailto:cwb-bounces at sslmit.unibo.it]
On Behalf Of "Andrés Chandía"
Sent: 10 January 2017 16:59
To: Open source development of the Corpus WorkBench
Subject: Re: [CWB] CRITICAL ERROR - CACHE OVERLOAD!
Another issue, probably related with the one sent before, is when I try to download a concordance, either the typical for Word, Excel or the typical for FileMaker, at both download txt files I get:

CQPweb encountered an error and could not continue.
CQP sent back these error messages:
**** CQP ERROR ****
CQP Error:
Corpus ``fblsumfziw'' is undefined

Obviously I have no corpus named "fblsumfziw"



El Mar, 10 de Enero de 2017, 13:23, "Andrés Chandía" escribió:

How can this be solved:

CRITICAL ERROR - CACHE OVERLOAD!

CQPweb tried to clear cache space but failed!

I've tried some of the configurations the manual recommends, but there was no success on that, any other advice?


_______________________
andrés chandía
[chandia.net]<http://www.chandia.net>[X]<https://twitter.com/andreschandia>
NMT<http://chandia.net/content/nmt> |

Dungupeyem<http://chandia.net/content/dungupeyem> |
Corlexim<http://corlexim.cl>

administrador de:
Parles.upf<http://parles.upf.edu> |

Amind terapia<http://amindterapia.com> |
Mapuche koyaktu<http://koyaktumapuche.net> |
Nocando<http://parles.upf.edu/llocs/nocando> |
mail:
ONG Mapuche koyaktu<http://mail.corporacionkoyaktu.net> |
Psicoaching<http://mail.psicoaching.net> |
P
No imprima innecesariamente. ¡Cuide el medio ambiente!


_______________________
andrés chandía
[chandia.net]<http://www.chandia.net>[X]<https://twitter.com/andreschandia>
NMT<http://chandia.net/content/nmt> |

Dungupeyem<http://chandia.net/content/dungupeyem> |
Corlexim<http://corlexim.cl>

administrador de:
Parles.upf<http://parles.upf.edu> |
Amind terapia<http://amindterapia.com> | Mapuche koyaktu<http://koyaktumapuche.net> |
Nocando<http://parles.upf.edu/llocs/nocando> |
mail: ONG Mapuche koyaktu<http://mail.corporacionkoyaktu.net> |
Psicoaching<http://mail.psicoaching.net> |
P
No imprima innecesariamente. ¡Cuide el medio ambiente!






_______________________
            andrés chandía
[chandia.net]<http://www.chandia.net>[http://mail.chandia.net/images/ico_tw.png]<https://twitter.com/andreschandia>
NMT<http://chandia.net/content/nmt> | Dungupeyem<http://chandia.net/content/dungupeyem> | Corlexim<http://corlexim.cl>

administrador de:
Parles.upf<http://parles.upf.edu> | Amind terapia<http://amindterapia.com> | Mapuche koyaktu<http://koyaktumapuche.net> | Nocando<http://parles.upf.edu/llocs/nocando> |
mail: ONG Mapuche koyaktu<http://mail.corporacionkoyaktu.net> | Psicoaching<http://mail.psicoaching.net> |
P No imprima innecesariamente. ¡Cuide el medio ambiente!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20170111/ef1d5944/attachment-0001.html>


More information about the CWB mailing list