<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.errormessage, li.errormessage, div.errormessage
{mso-style-name:errormessage;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-GB;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Verdana","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><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…..<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></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"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></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
<b>rm</b> or <b>sudo rm</b>.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">best<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andrew.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> cwb-bounces@sslmit.unibo.it [mailto:cwb-bounces@sslmit.unibo.it]
<b>On Behalf Of </b>"Andrés Chandía"<br>
<b>Sent:</b> 11 January 2017 11:51<br>
<b>To:</b> Open source development of the Corpus WorkBench<br>
<b>Subject:</b> Re: [CWB] CRITICAL ERROR - CACHE OVERLOAD!<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></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,
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ó:<o:p></o:p></p>
<div>
<p class="MsoNormal">El Mar, 10 de Enero de 2017, 13:23, "Andrés ChandÃa" escribió:
<o:p></o:p></p>
<div>
<p class="errormessage" style="margin-left:36.0pt">How can this be solved:<o:p></o:p></p>
<p class="errormessage" style="margin-left:36.0pt">CRITICAL ERROR - CACHE OVERLOAD!<o:p></o:p></p>
<p class="errormessage" style="margin-left:36.0pt">CQPweb tried to clear cache space but failed!<o:p></o:p></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
the cache folder down to the set limit, but could not do so.</span><o:p></o:p></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><o:p></o:p></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>
</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><o:p></o:p></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>
</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><o:p></o:p></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>
</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">
tool in the admin control panel to investigate.</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;margin-bottom:12.0pt;margin-left:36.0pt">
Corpus ``fblsumfziw'' is undefined<br>
<br>
Obviously I have no corpus named "fblsumfziw"<o:p></o:p></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">
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">
in particular derives from a timestamp from<br>
about five hours ago. </span><o:p></o:p></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">
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
queries (which are a type of subcorpus).</span><o:p></o:p></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
exist, but CQPweb thinks it does, probably because there<br>
is an orphaned record in query cache table.</span><o:p></o:p></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
entries.</span><o:p></o:p></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><o:p></o:p></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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><strong><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></strong><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">
<a href="mailto:cwb-bounces@sslmit.unibo.it">cwb-bounces@sslmit.unibo.it</a> [<a href="mailto:cwb-bounces@sslmit.unibo.it">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><o:p></o:p></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
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ó:<o:p></o:p></p>
<p class="errormessage">How can this be solved:<o:p></o:p></p>
<p class="errormessage">CRITICAL ERROR - CACHE OVERLOAD!<o:p></o:p></p>
<p class="errormessage">CQPweb tried to clear cache space but failed!<o:p></o:p></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" target="_blank" title="Este
enlace externo se abrirá en una nueva ventana"><span style="text-decoration:none"><img border="0" id="_x0000_i1025" src="../images/sec_remove_es_ES.png" alt="chandia.net"></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 border="0" width="20" height="20" id="_x0000_i1026" src="../images/sec_remove_es_ES.png"></span></a><br>
<a href="http://chandia.net/content/nmt" target="_blank" title="Este enlace externo se abrirá en una nueva
ventana">NMT</a> |<br>
<a href="http://chandia.net/content/dungupeyem" target="_blank" title="Este enlace externo se abrirá en una nueva ventana"><br>
Dungupeyem</a> | <a href="http://corlexim.cl" target="_blank" title="Este enlace externo se abrirá en una
nueva ventana">
<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> |<br>
<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">
<br>
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">
<br>
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;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 border="0" id="_x0000_i1027" src="../images/sec_remove_es_ES.png" alt="chandia.net"></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 border="0" width="20" height="20" id="_x0000_i1028" src="../images/sec_remove_es_ES.png"></span></a><br>
<a href="http://chandia.net/content/nmt" target="_blank" title="Este enlace externo se abrirá en una nueva
ventana">NMT</a> |<br>
<a href="http://chandia.net/content/dungupeyem" target="_blank" title="Este enlace externo se abrirá en una nueva ventana"><br>
Dungupeyem</a> | <a href="http://corlexim.cl" target="_blank" title="Este enlace externo se abrirá en una
nueva ventana">
<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><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><br>
<br>
<br>
<br>
<br>
_______________________<br>
andrés chandía<br>
<a href="http://www.chandia.net" target="_blank"><span style="text-decoration:none"><img border="0" id="_x0000_i1029" src="http://mail.chandia.net/images/chandia_net.png" alt="chandia.net"></span></a><a href="https://twitter.com/andreschandia" target="_blank"><span style="text-decoration:none"><img border="0" width="20" height="20" id="_x0000_i1030" src="http://mail.chandia.net/images/ico_tw.png"></span></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:18.0pt;font-family:Webdings;color:#4F6228">P</span> <span style="font-size:10.0pt">
No imprima innecesariamente. ¡Cuide el medio ambiente!</span><o:p></o:p></p>
</div>
</body>
</html>