Ok, my problem was that I couldn't find them, but finally I found them at cqp/tmp/ directory,
the strange thing though is that those files are actually owned by the webserver user:<br
/><br />-rw-r--r-- 1 www-data www-data 27193353 oct 13 21:00
______tempfreq_ctilcglicom.tbl<br />-rw-r--r-- 1 www-data www-data 514114233 nov 20 2012
____temporary_freq_corpus_bnc_malt_parsed.tbl<br />-rw-r--r-- 1 www-data www-data 261833518
nov 20 2012 ____temporary_freq_corpus_bnc_malt_parsed.tbl.utf8.tmp<br />-rw-r--r-- 1
www-data www-data 24873076 nov 15 2012 ____temporary_freq_corpus_oldes.tbl<br
/>-rw-r--r-- 1 www-data www-data 63668668 oct 25 2012
____temporary_freq_corpus_wikica.tbl<br /><br />Thanks, already deleted.<br /><br /><br />El
Mie, 11 de Enero de 2017, 12:54, Hardie, Andrew escribió:<br /> <!-- begin sanitized
html --><br />
<div class="bodyclass"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">If
they don’t delete through the interface, the only explanation is that the
files are not “owned” by the web daemon’s
username…..</span>
<div class="WordSection1">
<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>
but how can I delete those files that are still mentioned at the Query cache leak monitor<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">….meaning
you have to delete them on the command line with<br /> <strong>rm</strong> or <strong>sudo
rm</strong>.</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> 11
January 2017 11:51<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" style="margin-bottom:12.0pt">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,<br /> 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ó:</p>
<div><br />
<p class="MsoNormal">El Mar, 10 de Enero de 2017, 13:23,
"Andrés Chandía"
escribió:<br /> </p>
<div><br />
<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" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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<br
/> the cache folder down to the set limit, but could not do so.</span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Reasons
this can happen:</span></p>
<p class="MsoListParagraph" style="text-indent:-18.0pt"><span
style="font-size:10.0pt;font-family:Symbol;color:#1F497D">·</span><span
style="font-size:7.0pt;color:#1F497D"><br /> <br /> </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"><span
style="font-size:10.0pt;font-family:Symbol;color:#1F497D">·</span><span
style="font-size:7.0pt;color:#1F497D"><br /> <br /> </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"><span
style="font-size:10.0pt;font-family:Symbol;color:#1F497D">·</span><span
style="font-size:7.0pt;color:#1F497D"><br /> <br /> </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â€</span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">ť</span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><br
/> tool in the admin control panel to investigate.</span></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;margin-bottom:12.0pt;margin-left:36.0pt"><br /> Corpus
``fblsumfziw'' is undefined<br /> <br /> Obviously I have no corpus named
"fblsumfziw"</p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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">â€</span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">ť</span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><br
/> is an “instance
nameâ€</span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">ť</span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
(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">â€</span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">ť</span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><br
/> in particular derives from a timestamp from<br /> about five hours ago. </span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Also:
When CQP says a
“corpusâ€</span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">ť</span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><br
/> is
“undefinedâ€</span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">ť</span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">
that also includes subcorpora (which are a type of corpus) and<br /> queries (which are a
type of subcorpus).</span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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<br /> exist, but CQPweb thinks it does, probably because there<br /> is an orphaned
record in query cache table.</span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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<br /> entries.</span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best</span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.</span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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"><br /> <a href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank" title="Este
enlace externo se abrirá en una nueva ventana">cwb-bounces@sslmit.unibo.it</a> [<a
href="mailto:cwb-bounces@sslmit.unibo.it" target="_blank" title="Este enlace externo se abrirá
en una nueva ventana">mailto:cwb-bounces@sslmit.unibo.it</a>]<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">On Behalf Of
</span></strong>"Andrés
Chandía"<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">Sent:</span></strong> 10 January
2017 16:59<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">To:</span></strong> Open source
development of the Corpus WorkBench<br /> <strong><span
style="font-family:"Tahoma","sans-serif"">Subject:</span></strong> Re:
[CWB] CRITICAL ERROR - CACHE OVERLOAD!</span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">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<br /> 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" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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 /> <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 /> <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 /> <br /> Nocando</a> |<br /> mail: <a
href="http://mail.corporacionkoyaktu.net" title="Este enlace externo se abrirá en una nueva
ventana" target="_blank"><br /> <br /> ONG Mapuche koyaktu</a> | <a
href="http://mail.psicoaching.net" title="Este enlace externo se abrirá en una nueva ventana"
target="_blank"><br /> <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 /> <br /> No imprima innecesariamente.
¡Cuide el medio ambiente!</span> <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_i1027" 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_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 /> <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 /> <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 /> <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 /> <br /> Psicoaching</a> |<br /> <span
style="font-size:18.0pt;font-family:Webdings;color:#4F6228">P</span> <span
style="font-size:10.0pt"><br /> <br /> No imprima innecesariamente.
¡Cuide el medio ambiente!</span></p>
</div>
<br />
<p class="MsoNormal"> </p>
</div>
<br />
<p class="MsoNormal"><br /> <br /> <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_i1029" 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_i1030" 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>