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

[Jiayue Wang]

Hi Andrew,

Thanks for pointing to the way!

best,
Arthur

On 8/19/20 7:11 PM, Hardie, Andrew wrote:
> 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
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
>