[CWB] Computing distribution fails with uninformative error message
Jörg Knappen
j.knappen at mx.uni-saarland.de
Thu Apr 25 19:15:20 CEST 2019
Ah ... something more worth mentioning:
I do daily mysql dumps of the cqpweb database (for backup), and there
was a remarkable growth of that dump yesterday:
-rw-rw-r-- 1 knappen knappen 5.5G Apr 25 01:07 cqpweb.dump
-rw-rw-r-- 1 knappen knappen 4.3G Apr 24 01:06 cqpweb.dump.bak
--Jörg Knappen
Quoting "Hardie, Andrew" <a.hardie at lancaster.ac.uk>:
> It's not CQPweb configuration. The error is deep in the MySQL layer.
> The fact that the query runs fine from the CL client, but causes an
> error when done via the CQPweb code, is suggestive.
>
> Suggestion: Have a look at your Mysql config and see if there is a
> difference in permissions between your account and that used by
> CQPweb.
>
> Also, if this si a shared server, maybe check whether anyone else
> did an Ubuntu update around the time the problem occurred??
>
> best
>
> Andrew.
>
> -----Original Message-----
> From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On
> Behalf Of Jörg Knappen
> Sent: 25 April 2019 13:11
> To: Open source development of the Corpus WorkBench <cwb at sslmit.unibo.it>
> Subject: Re: [CWB] Computing distribution fails with uninformative
> error message
>
> Hallo Andrew,
>
> raw disk space is currently not a problem: There is only one partition
> on the disk and it has 277G of free space.
>
> mysql itself eats up 16G of disk space:
>
> root at corpora:/var/lib/mysql# du -h ./
> 23M ./mysql
> 676K ./sys
> 16G ./cqpweb
> 1.1M ./performance_schema
> 16G ./
>
> which might be a magical number accessible to configuration.
>
> --Jörg Knappen
>
> Quoting "Hardie, Andrew" <a.hardie at lancaster.ac.uk>:
>
>> Is it a lack of disk space available to your MySQL daemon, possibly?
>>
>> best
>>
>> Andrew
>>
>> -----Original Message-----
>> From: cwb-bounces at sslmit.unibo.it <cwb-bounces at sslmit.unibo.it> On
>> Behalf Of Jörg Knappen
>> Sent: 25 April 2019 12:27
>> To: cwb at sslmit.unibo.it
>> Subject: [CWB] Computing distribution fails with uninformative error message
>>
>>
>> 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"
>> }
>> }
>>
>>
>> _______________________________________________
>> CWB mailing list
>> CWB at sslmit.unibo.it
>> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
>> _______________________________________________
>> CWB mailing list
>> CWB at sslmit.unibo.it
>> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
>
>
>
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
> _______________________________________________
> CWB mailing list
> CWB at sslmit.unibo.it
> http://liste.sslmit.unibo.it/mailman/listinfo/cwb
More information about the CWB
mailing list