[CWB] Error # 3: Error writing file '/tmp/MYGAVRRH' (Errcode: 28)

[Meier-Vieracker, Simon]

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"
  }
}