[CWB] Error # 1467: Failed to read auto-increment value from storage engine

[Jiayue Wang]

Hi,

With a very large corpus I created a concordance using CQP syntax, 
word="[a-zA-Z]+" word="[a-zA-Z]+", i.e. two consecutive word forms, did 
frequency breakdown, and then tried to download the list, I encountered 
Error# 1467. Here is the debugging trace:


array(6) {
   [1]=>
   array(4) {
     ["file"]=>
     string(48) "/home/arthur/www_root/CQPweb/lib/library.inc.php"
     ["line"]=>
     int(286)
     ["function"]=>
     string(20) "exiterror_mysqlquery"
     ["args"]=>
     array(3) {
       [0]=>
       int(1467)
       [1]=>
       string(55) "Failed to read auto-increment value from storage engine"
       [2]=>
       string(199) "LOAD DATA LOCAL INFILE 
'/home/arthur/CWB_folders/temp/tab_sort_ghw3c8zsj4' INTO TABLE 
`db_sort_ghw5k66zis` FIELDS ESCAPED BY ''
	/* from User: admin | Function: create_db() | 2020-Aug-19 07:46:29 */"
     }
   }
   [2]=>
   array(4) {
     ["file"]=>
     string(48) "/home/arthur/www_root/CQPweb/lib/library.inc.php"
     ["line"]=>
     int(410)
     ["function"]=>
     string(14) "do_mysql_query"
     ["args"]=>
     array(1) {
       [0]=>
       &string(199) "LOAD DATA LOCAL INFILE 
'/home/arthur/CWB_folders/temp/tab_sort_ghw3c8zsj4' INTO TABLE 
`db_sort_ghw5k66zis` FIELDS ESCAPED BY ''
	/* from User: admin | Function: create_db() | 2020-Aug-19 07:46:29 */"
     }
   }
   [3]=>
   array(4) {
     ["file"]=>
     string(43) "/home/arthur/www_root/CQPweb/lib/db.inc.php"
     ["line"]=>
     int(292)
     ["function"]=>
     string(21) "do_mysql_infile_query"
     ["args"]=>
     array(3) {
       [0]=>
       string(18) "db_sort_ghw5k66zis"
       [1]=>
       string(49) "/home/arthur/CWB_folders/temp/tab_sort_ghw3c8zsj4"
       [2]=>
       bool(true)
     }
   }
   [4]=>
   array(4) {
     ["file"]=>
     string(50) "/home/arthur/www_root/CQPweb/lib/breakdown.inc.php"
     ["line"]=>
     int(159)
     ["function"]=>
     string(9) "create_db"
     ["args"]=>
     array(5) {
       [0]=>
       object(DbType)#141 (4) {
         ["type"]=>
         int(3)
         ["str"]=>
         string(4) "sort"
         ["colloc_atts"]=>
         NULL
         ["colloc_range"]=>
         NULL
       }
       [1]=>
       string(10) "ghw3c8zsj4"
       [2]=>
       string(37) "[word="[a-zA-Z]+"] [word="[a-zA-Z]+"]"
       [3]=>
       string(19) "$^--text|country~us"
       [4]=>
       string(0) ""
     }
   }
   [5]=>
   array(4) {
     ["file"]=>
     string(49) "/home/arthur/www_root/CQPweb/lib/redirect.inc.php"
     ["line"]=>
     int(120)
     ["args"]=>
     array(1) {
       [0]=>
       string(50) "/home/arthur/www_root/CQPweb/lib/breakdown.inc.php"
     }
     ["function"]=>
     string(7) "require"
   }
   [6]=>
   array(4) {
     ["file"]=>
     string(45) "/home/arthur/www_root/CQPweb/exe/redirect.php"
     ["line"]=>
     int(1)
     ["args"]=>
     array(1) {
       [0]=>
       string(49) "/home/arthur/www_root/CQPweb/lib/redirect.inc.php"
     }
     ["function"]=>
     string(7) "require"
   }
}



It was a subcorpus of a larger corpus (of BNC's size); I tried the 
operation on the other subcorpora of the large corpus and had not 
problems. Is the error related to larger size? (The subcorpus is 
considerably larger than the other ones.)

Thanks

Arthur