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

[Hardie, Andrew]

Hi Arthur,

A quick search online suggests that this error is probably due to your freq BD table having more rows than the database engine can accommodate. " Failed to read auto-increment value from storage engine " usually means that the row ID has exceeded the maximum possible value.

I suggest you try using cwb-scan-corpus from the command line. It won't overflow.

best

Andrew.

-----Original Message-----
From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On Behalf Of Jiayue Wang
Sent: 19 August 2020 09:54
To: cwb at sslmit.unibo.it
Subject: [CWB] Error # 1467: Failed to read auto-increment value from storage engine


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
_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fliste.sslmit.unibo.it%2Fmailman%2Flistinfo%2Fcwb&amp;data=02%7C01%7Ca.hardie%40lancaster.ac.uk%7C4927c4a01f774d54d18308d8441e77b5%7C9c9bcd11977a4e9ca9a0bc734090164a%7C0%7C1%7C637334244943745054&amp;sdata=Er5%2FAhZ3VqblVuboRsxMkQknUY8oWwQ4A2woJ5Q2iss%3D&amp;reserved=0