[CWB] Error # 3: Error writing file '/tmp/MYGAVRRH' (Errcode: 28)
Hardie, Andrew
a.hardie at lancaster.ac.uk
Mon Apr 9 12:27:25 CEST 2018
Sure, that's the other way, if you can identify data to remove. (*)
If you mean data files internal to CQPweb, the way to do that is with the "Cache control" tools in the admin panel. These are designed to identify files and db tables that have been lost-track of (and therefore will not be deleted by the normal internal cache mechanisms).
best
Andrew.
(*) Note that if you are using a single tablespace for your MySQL engine, then that file never gets any smaller even if you delete tables. See the MySQL manual.
-----Original Message-----
From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Meier-Vieracker, Simon
Sent: 09 April 2018 11:20
To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
Subject: Re: [CWB] Error # 3: Error writing file '/tmp/MYGAVRRH' (Errcode: 28)
Thanks for this quick answer.
Just to be sure: There is no chance to delete some old files that are no longer used? I ask this because until yesterday I never has these problems.
Best
Simon
> Am 09.04.2018 um 12:02 schrieb Hardie, Andrew <a.hardie at lancaster.ac.uk>:
>
> This error means the disk is full. MySQL writes temporary files when doing big calculations, by default to /tmp. If it runs out of space, you get this file-write error.
>
> Solution: either increase the size of the disk /tmp is on, or reconfig MySQL to use temporary space on another available disk.
>
> best
>
> Andrew.
>
> -----Original Message-----
> From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Meier-Vieracker, Simon
> Sent: 09 April 2018 09:12
> To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
> Subject: [CWB] Error # 3: Error writing file '/tmp/MYGAVRRH' (Errcode: 28)
>
> Hi,
>
> when trying to calculate collocations in CQPweb, an error occurs: Error # 3: Error writing file '/tmp/MYGAVRRH' (Errcode: 28)
> See the full report below.
>
> I guess this has something to do with the size of the collocation database, because it works fine with a smaller number of hits. Moreover, the same error occurs in other corpora when the number of hits is too big. Any suggestions?
>
> Thanks in advance
> Simon
>
>
> ----------
>
> array(3) {
> [1]=>
> array(4) {
> ["file"]=>
> string(36) "/home/cqp/CQPweb/lib/library.inc.php"
> ["line"]=>
> int(286)
> ["function"]=>
> string(20) "exiterror_mysqlquery"
> ["args"]=>
> array(3) {
> [0]=>
> &int(3)
> [1]=>
> &string(48) "Error writing file '/tmp/MYGAVRRH' (Errcode: 28)"
> [2]=>
> &string(1904) "select db_colloc_fq6ehkxff6.`word`, count(db_colloc_fq6ehkxff6.`word`) as observed, (753220 * (freq_corpus_guardian_word.freq) / 14592941) as expected,
> sign(1e0 * COUNT(db_colloc_fq6ehkxff6.`word`) - (753220 * (freq_corpus_guardian_word.freq) / 14592941)) * 2 * (
> IF(1e0 * COUNT(db_colloc_fq6ehkxff6.`word`) > 0, 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`) * log(1e0 * COUNT(db_colloc_fq6ehkxff6.`word`) / (753220 * (freq_corpus_guardian_word.freq) / 14592941)), 0) +
> IF((753220 - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`)) > 0, (753220 - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`)) * log((753220 - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`)) / (753220 * (14592941 - (freq_corpus_guardian_word.freq)) / 14592941)), 0) +
> IF(((freq_corpus_guardian_word.freq) - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`)) > 0, ((freq_corpus_guardian_word.freq) - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`)) * log(((freq_corpus_guardian_word.freq) - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`)) / (13839721 * (freq_corpus_guardian_word.freq) / 14592941)), 0) +
> IF((13839721 - ((freq_corpus_guardian_word.freq) - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`))) > 0, (13839721 - ((freq_corpus_guardian_word.freq) - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`))) * log((13839721 - ((freq_corpus_guardian_word.freq) - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`))) / (13839721 * (14592941 - (freq_corpus_guardian_word.freq)) / 14592941)), 0)
> ) as significance,
> freq_corpus_guardian_word.freq, count(distinct(text_id)) as text_id_count
> from db_colloc_fq6ehkxff6, freq_corpus_guardian_word
> where db_colloc_fq6ehkxff6.`word` = freq_corpus_guardian_word.item
> and dist between -5 and 5
>
> and freq_corpus_guardian_word.freq >= 5
> group by db_colloc_fq6ehkxff6.`word`
> having observed >= 5
> order by significance desc
> LIMIT 0, 50
>
> /* from User: fussballlinguist | Function: require() | 2018-Apr-09 07:53:38 */"
> }
> }
> [2]=>
> array(4) {
> ["file"]=>
> string(40) "/home/cqp/CQPweb/lib/collocation.inc.php"
> ["line"]=>
> int(505)
> ["function"]=>
> string(14) "do_mysql_query"
> ["args"]=>
> array(1) {
> [0]=>
> &string(1823) "select db_colloc_fq6ehkxff6.`word`, count(db_colloc_fq6ehkxff6.`word`) as observed, (753220 * (freq_corpus_guardian_word.freq) / 14592941) as expected,
> sign(1e0 * COUNT(db_colloc_fq6ehkxff6.`word`) - (753220 * (freq_corpus_guardian_word.freq) / 14592941)) * 2 * (
> IF(1e0 * COUNT(db_colloc_fq6ehkxff6.`word`) > 0, 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`) * log(1e0 * COUNT(db_colloc_fq6ehkxff6.`word`) / (753220 * (freq_corpus_guardian_word.freq) / 14592941)), 0) +
> IF((753220 - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`)) > 0, (753220 - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`)) * log((753220 - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`)) / (753220 * (14592941 - (freq_corpus_guardian_word.freq)) / 14592941)), 0) +
> IF(((freq_corpus_guardian_word.freq) - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`)) > 0, ((freq_corpus_guardian_word.freq) - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`)) * log(((freq_corpus_guardian_word.freq) - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`)) / (13839721 * (freq_corpus_guardian_word.freq) / 14592941)), 0) +
> IF((13839721 - ((freq_corpus_guardian_word.freq) - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`))) > 0, (13839721 - ((freq_corpus_guardian_word.freq) - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`))) * log((13839721 - ((freq_corpus_guardian_word.freq) - 1e0 * COUNT(db_colloc_fq6ehkxff6.`word`))) / (13839721 * (14592941 - (freq_corpus_guardian_word.freq)) / 14592941)), 0)
> ) as significance,
> freq_corpus_guardian_word.freq, count(distinct(text_id)) as text_id_count
> from db_colloc_fq6ehkxff6, freq_corpus_guardian_word
> where db_colloc_fq6ehkxff6.`word` = freq_corpus_guardian_word.item
> and dist between -5 and 5
>
> and freq_corpus_guardian_word.freq >= 5
> group by db_colloc_fq6ehkxff6.`word`
> having observed >= 5
> order by significance desc
> LIMIT 0, 50
> "
> }
> }
> [3]=>
> array(4) {
> ["file"]=>
> string(36) "/home/cqp/CQPweb/exe/collocation.php"
> ["line"]=>
> int(1)
> ["args"]=>
> array(1) {
> [0]=>
> string(40) "/home/cqp/CQPweb/lib/collocation.inc.php"
> }
> ["function"]=>
> string(7) "require"
> }
> }
>
>
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
-------
Dr. Simon Meier
Technische Universität Berlin
Institut für Sprache und Kommunikation
Fachgebiet Allgemeine Linguistik
Sekretariat H42
Straße des 17. Juni 135, 10623 Berlin
+49 (0) 30 314 22323
simon.meier at tu-berlin.de
http://www.linguistik.tu-berlin.de/menue/mitarbeiterinnen/wiss_mitarbeiterinnen/simon_meier/
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
http://liste.sslmit.unibo.it/mailman/listinfo/cwb
More information about the CWB
mailing list