[CWB] Computing distribution fails with uninformative error message

Jörg Knappen j.knappen at mx.uni-saarland.de
Thu Apr 25 13:27:29 CEST 2019


I'm running CQPweb v3.2.31 © 2008-2018 on Ubuntu 18.04 LTS, and  
overnight "Distribution" queries started to fail with the following  
error message (I can confirm that "Distribution worked perfectly  
yesterday in the evening):

A MySQL query did not run successfully!

Original query: LOAD DATA LOCAL INFILE  
'/data2/cqpweb/cache/tab_dist_fycel9oplk' INTO TABLE  
`db_dist_g2f3ndxf40` FIELDS ESCAPED BY '' /* from User: knappen |  
Function: create_db() | 2019-Apr-25 11:23:01 */

Error # 0:


Because the error emerged overnight with nothing changed on the  
system, I suspect that some configured limit is hit, but I have no  
clue which.

Inspecting /var/log/mysql/error.log revealed nothing; and running the  
sql query directly from the mysql prompt succeeds.

What can it be?

Thanks in advance,

Jörg Knappen

P.S. PHP debugging backtrace

array(6) {
   [1]=>
   array(4) {
     ["file"]=>
     string(40) "/var/www/html/cqpweb/lib/library.inc.php"
     ["line"]=>
     int(299)
     ["function"]=>
     string(20) "exiterror_mysqlquery"
     ["args"]=>
     array(3) {
       [0]=>
       int(0)
       [1]=>
       string(0) ""
       [2]=>
       string(191) "LOAD DATA LOCAL INFILE  
'/data2/cqpweb/cache/tab_dist_fycel9oplk' INTO TABLE  
`db_dist_g2f3ndxf40` FIELDS ESCAPED BY ''
	/* from User: knappen | Function: create_db() | 2019-Apr-25 11:23:01 */"
     }
   }
   [2]=>
   array(4) {
     ["file"]=>
     string(40) "/var/www/html/cqpweb/lib/library.inc.php"
     ["line"]=>
     int(423)
     ["function"]=>
     string(14) "do_mysql_query"
     ["args"]=>
     array(1) {
       [0]=>
       &string(191) "LOAD DATA LOCAL INFILE  
'/data2/cqpweb/cache/tab_dist_fycel9oplk' INTO TABLE  
`db_dist_g2f3ndxf40` FIELDS ESCAPED BY ''
	/* from User: knappen | Function: create_db() | 2019-Apr-25 11:23:01 */"
     }
   }
   [3]=>
   array(4) {
     ["file"]=>
     string(35) "/var/www/html/cqpweb/lib/db.inc.php"
     ["line"]=>
     int(292)
     ["function"]=>
     string(21) "do_mysql_infile_query"
     ["args"]=>
     array(3) {
       [0]=>
       string(18) "db_dist_g2f3ndxf40"
       [1]=>
       string(39) "/data2/cqpweb/cache/tab_dist_fycel9oplk"
       [2]=>
       bool(true)
     }
   }
   [4]=>
   array(4) {
     ["file"]=>
     string(45) "/var/www/html/cqpweb/lib/distribution.inc.php"
     ["line"]=>
     int(81)
     ["function"]=>
     string(9) "create_db"
     ["args"]=>
     array(5) {
       [0]=>
       object(DbType)#428 (4) {
         ["type"]=>
         int(1)
         ["str"]=>
         string(4) "dist"
         ["colloc_atts"]=>
         NULL
         ["colloc_range"]=>
         NULL
       }
       [1]=>
       string(10) "fycel9oplk"
       [2]=>
       string(15) "[word="optics"]"
       [3]=>
       string(0) ""
       [4]=>
       string(0) ""
     }
   }
   [5]=>
   array(4) {
     ["file"]=>
     string(41) "/var/www/html/cqpweb/lib/redirect.inc.php"
     ["line"]=>
     int(124)
     ["args"]=>
     array(1) {
       [0]=>
       string(45) "/var/www/html/cqpweb/lib/distribution.inc.php"
     }
     ["function"]=>
     string(7) "require"
   }
   [6]=>
   array(4) {
     ["file"]=>
     string(37) "/var/www/html/cqpweb/exe/redirect.php"
     ["line"]=>
     int(1)
     ["args"]=>
     array(1) {
       [0]=>
       string(41) "/var/www/html/cqpweb/lib/redirect.inc.php"
     }
     ["function"]=>
     string(7) "require"
   }
}




More information about the CWB mailing list