[CWB] CRITICAL ERROR - CACHE OVERLOAD!

"Andrés Chandía" andres at chandia.net
Wed Jan 11 12:51:03 CET 2017



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]
 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
 
 NMT |
 

Dungupeyem | 
 Corlexim
 
 administrador de:
 Parles.upf |
 
 Amind terapia | 
 Mapuche koyaktu | 
 Nocando
|
 mail: 
 ONG Mapuche koyaktu | 
 Psicoaching |
 P 
 No imprima innecesariamente. ¡Cuide
el medio ambiente! 
 
 
 _______________________
            
andrés chandía
 
 NMT |
 

Dungupeyem | 
 Corlexim
 
 administrador de:
 Parles.upf | 
 Amind terapia | Mapuche koyaktu | 
 Nocando
|
 mail: ONG Mapuche koyaktu | 
 Psicoaching |
 P 
 No imprima innecesariamente. ¡Cuide el medio
ambiente!


 

 
   


_______________________

            andrés
chandía

NMT |
Dungupeyem | Corlexim

administrador de:
Parles.upf | Amind
terapia | Mapuche koyaktu | Nocando |
mail: ONG Mapuche koyaktu | Psicoaching |
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/8f768883/attachment.html>


More information about the CWB mailing list