Ok, I've added this parameter to my config file:<br />$query_cache_size_limit = 9663676416;<br
/><br />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:<br /><br />______tempfreq_ctilcglicom.tbl 26,556 2016-Oct-13
19:00:14<br />____temporary_freq_corpus_bnc_malt_parsed.tbl 502,065 2012-Nov-20
12:08:06<br />____temporary_freq_corpus_bnc_malt_parsed.tbl.utf8.tmp 255,697 2012-Nov-20
12:09:09<br />____temporary_freq_corpus_oldes.tbl 24,290
2012-Nov-15 18:28:55<br />____temporary_freq_corpus_wikica.tbl 62,176
2012-Oct-25 14:04:33<br />___install_temp_ladino_old.txt 7,514 2013-May-23
08:48:37<br /><br />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.<br /><br />Thanks<br /><br /><br /><br />El Mar,
10 de Enero de 2017, 18:29, Hardie, Andrew escribió:<br /> <!-- begin sanitized html
--><br />
<div class="bodyclass">El Mar, 10 de Enero de 2017, 13:23, "Andrés
Chandía" escribió:
<div class="WordSection1">
<p class="errormessage" style="margin-left:36.0pt">How can this be solved:</p>
<p class="errormessage" style="margin-left:36.0pt">CRITICAL ERROR - CACHE OVERLOAD!</p>
<p class="errormessage" style="margin-left:36.0pt">CQPweb tried to clear cache space but
failed!</p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">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.</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Reasons
this can happen:</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><span
style="font-size:10.0pt;font-family:Symbol;color:#1F497D"><span
style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
<br /> </span></span></span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Your
cache size is configured too small ( see admin manual page 26 -<br />
</span>$query_cache_size_limit<span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">)</span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><span
style="font-size:10.0pt;font-family:Symbol;color:#1F497D"><span
style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
<br /> </span></span></span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">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).</span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><span
style="font-size:10.0pt;font-family:Symbol;color:#1F497D"><span
style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
<br /> </span></span></span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">You
have some kind of cache leak. Use the “Cache control > query
cache” tool in the admin control panel to investigate.</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal" style="margin-left:36.0pt">Corpus ``fblsumfziw'' is undefined<br /> <br
/> Obviously I have no corpus named "fblsumfziw"<br /> <br /> <span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"></span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">“</span>fblsumfziw<span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">”
is an “instance name” (based on microseconds since
1970-01-01<br /> encoded in base 36). It uniquely identifies the run of the script, and is
used when queries are saved to cache. “</span>fblsumfziw<span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">”
in particular derives from a timestamp from<br /> about five hours ago. </span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">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).<br /> </span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">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<br /> is an orphaned record in
query cache table.</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Again,
cache control should allow you to work out what the issues are and delete the orphaned cache
entries.</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.</span></p>
<p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
</span></p>
<p class="MsoNormal"><strong><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif""
lang="EN-US">From:</span></strong><span
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US">
cwb-bounces@sslmit.unibo.it [mailto:cwb-bounces@sslmit.unibo.it]<br /> <strong>On Behalf Of
</strong>"Andrés Chandía"<br /> <strong>Sent:</strong> 10
January 2017 16:59<br /> <strong>To:</strong> Open source development of the Corpus
WorkBench<br /> <strong>Subject:</strong> Re: [CWB] CRITICAL ERROR - CACHE
OVERLOAD!</span></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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:<br /> <br /> CQPweb encountered an error and could not
continue.<br /> CQP sent back these error messages:<br /> **** CQP ERROR ****<br /> CQP
Error:<br /> Corpus ``fblsumfziw'' is undefined<br /> <br /> Obviously I have no corpus named
"fblsumfziw"<br /> <br /> <br /> <br /> El Mar, 10 de Enero de 2017, 13:23,
"Andrés Chandía" escribió:</p>
<p class="errormessage">How can this be solved:</p>
<p class="errormessage">CRITICAL ERROR - CACHE OVERLOAD!</p>
<p class="errormessage">CQPweb tried to clear cache space but failed!</p>
<p class="MsoNormal"><br /> I've tried some of the configurations the manual recommends, but
there was no success on that, any other advice?<br /> <br /> <br /> _______________________<br
/> andrés chandía<br /> <a href="http://www.chandia.net" title="Este
enlace externo se abrirá en una nueva ventana" target="_blank"><span
style="text-decoration:none"><img id="_x0000_i1025" src="../images/sec_remove_es_ES.png"
alt="chandia.net" border="0" /></span></a><a href="https://twitter.com/andreschandia"
title="Este enlace externo se abrirá en una nueva ventana" target="_blank"><span
style="text-decoration:none"><img id="_x0000_i1026" src="../images/sec_remove_es_ES.png"
width="20" height="20" border="0" alt="" /></span></a><br /> <a
href="http://chandia.net/content/nmt" title="Este enlace externo se abrirá en una nueva
ventana" target="_blank">NMT</a> |<br /> <a href="http://chandia.net/content/dungupeyem"
title="Este enlace externo se abrirá en una nueva ventana" target="_blank"><br />
Dungupeyem</a> | <a href="http://corlexim.cl" title="Este enlace externo se abrirá en una
nueva ventana" target="_blank"><br /> Corlexim</a><br /> <br /> administrador de:<br /> <a
href="http://parles.upf.edu" title="Este enlace externo se abrirá en una nueva ventana"
target="_blank">Parles.upf</a> |<br /> <a href="http://amindterapia.com" title="Este enlace
externo se abrirá en una nueva ventana" target="_blank"><br /> Amind terapia</a> | <a
href="http://koyaktumapuche.net" title="Este enlace externo se abrirá en una nueva ventana"
target="_blank"><br /> Mapuche koyaktu</a> | <a href="http://parles.upf.edu/llocs/nocando"
title="Este enlace externo se abrirá en una nueva ventana" target="_blank"><br /> Nocando</a>
|<br /> mail: <a href="http://mail.corporacionkoyaktu.net" title="Este enlace externo se
abrirá en una nueva ventana" target="_blank"><br /> ONG Mapuche koyaktu</a> | <a
href="http://mail.psicoaching.net" title="Este enlace externo se abrirá en una nueva ventana"
target="_blank"><br /> Psicoaching</a> |<br /> <span
style="font-size:18.0pt;font-family:Webdings;color:#4F6228">P</span> <span
style="font-size:10.0pt;color:#4F6228"><br /> No imprima innecesariamente. ¡Cuide
el medio ambiente!</span> <br /> <br /> <br /> _______________________<br />
andrés chandía<br /> <a href="http://www.chandia.net" target="_blank"
title="Este enlace externo se abrirá en una nueva ventana"><span
style="text-decoration:none"><img id="_x0000_i1027" src="../images/sec_remove_es_ES.png"
alt="chandia.net" border="0" /></span></a><a href="https://twitter.com/andreschandia"
target="_blank" title="Este enlace externo se abrirá en una nueva ventana"><span
style="text-decoration:none"><img id="_x0000_i1028" src="../images/sec_remove_es_ES.png"
width="20" height="20" border="0" alt="" /></span></a><br /> <a
href="http://chandia.net/content/nmt" title="Este enlace externo se abrirá en una nueva
ventana" target="_blank">NMT</a> |<br /> <a href="http://chandia.net/content/dungupeyem"
title="Este enlace externo se abrirá en una nueva ventana" target="_blank"><br />
Dungupeyem</a> | <a href="http://corlexim.cl" title="Este enlace externo se abrirá en una
nueva ventana" target="_blank"><br /> Corlexim</a><br /> <br /> administrador de:<br /> <a
href="http://parles.upf.edu" target="_blank" title="Este enlace externo se abrirá en una nueva
ventana">Parles.upf</a> | <a href="http://amindterapia.com" target="_blank" title="Este enlace
externo se abrirá en una nueva ventana"><br /> Amind terapia</a> | <a
href="http://koyaktumapuche.net" target="_blank" title="Este enlace externo se abrirá en una
nueva ventana">Mapuche koyaktu</a> | <a href="http://parles.upf.edu/llocs/nocando"
target="_blank" title="Este enlace externo se abrirá en una nueva ventana"><br /> Nocando</a>
|<br /> mail: <a href="http://mail.corporacionkoyaktu.net" target="_blank" title="Este enlace
externo se abrirá en una nueva ventana">ONG Mapuche koyaktu</a> | <a
href="http://mail.psicoaching.net" target="_blank" title="Este enlace externo se abrirá en una
nueva ventana"><br /> Psicoaching</a> |<br /> <span
style="font-size:18.0pt;font-family:Webdings;color:#4F6228">P</span> <span
style="font-size:10.0pt"><br /> No imprima innecesariamente. ¡Cuide el medio
ambiente!</span></p>
</div>
<br /> </div>
<br /> <br /> <!-- end sanitized html --> <br /><br /><br />_______________________<br />
andrés
chandía<br /><a href="http://www.chandia.net" target="_blank"><img
src="http://mail.chandia.net/images/chandia_net.png" alt="chandia.net" border="0" /></a><a
href="https://twitter.com/andreschandia" target="_blank"><img
src="http://mail.chandia.net/images/ico_tw.png" width="20" height="20" alt="" /></a><br /><a
href="http://chandia.net/content/nmt" title="Unificador ortogrŕfico de mapudungun">NMT</a> |
<a href="http://chandia.net/content/dungupeyem" title="Analizador y generador mofológico de
mapudungun">Dungupeyem</a> | <a href="http://corlexim.cl" title="Corpus lexicográfico de
mapudungun">Corlexim</a><br /><br />administrador de:<br /><a
href="http://parles.upf.edu">Parles.upf</a> | <a href="http://amindterapia.com">Amind
terapia</a> | <a href="http://koyaktumapuche.net">Mapuche koyaktu</a> | <a
href="http://parles.upf.edu/llocs/nocando">Nocando</a> |<br />mail: <a
href="http://mail.corporacionkoyaktu.net">ONG Mapuche koyaktu</a> | <a
href="http://mail.psicoaching.net">Psicoaching</a> |<br /><span style="font-size: 18pt; color:
rgb(79, 98, 40); font-family: Webdings;">P</span> <span style="font-size: 10pt; color: rgb(79,
98, 40);">No imprima innecesariamente. ¡Cuide el medio ambiente!</span>