[CWB] Error # 3: Error writing file '/tmp/MYGAVRRH' (Errcode: 28)
Meier-Vieracker, Simon
simon.meier at tu-berlin.de
Mon Apr 9 12:20:02 CEST 2018
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/
More information about the CWB
mailing list