[CWB] mysql cache errors occurring recently

[Hardie, Andrew]

3 things.

First, the function names/line numbers in the debug backtrace suggest this is rather an old version of the code. So, you might consider upgrading.

Second, you might find that if you look on the "cache control" / "database cache" page in the admin interface, it will tell you what is wrong. (This is assuming that your version of the code is not too old to have that tool!) One possibility is that you have a number of orphaned database table records which make the cache look fuller than it actually is. Deleting the orphan records would in that case solve the problem.

Third, when you get the " Too many database processes " error, you can look under "Manage MySQL processes" again in the admin UI, and delete records of zombie processes.

best

Andrew.


-----Original Message-----
From: cwb-bounces at sslmit.unibo.it [mailto:cwb-bounces at sslmit.unibo.it] On Behalf Of Jörg Knappen
Sent: 12 April 2018 13:48
To: cwb at sslmit.unibo.it
Subject: [CWB] mysql cache errors occurring recently

We run a cqpweb on Ubuntu 14.04 LTS using the following php version


PHP 5.5.9-1ubuntu4.24 (cli) (built: Mar 16 2018 12:41:43)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies
     with Zend OPcache v7.0.3, Copyright (c) 1999-2014, by Zend Technologies


and the mysql version

mysql  Ver 14.14 Distrib 5.5.59, for debian-linux-gnu (x86_64) using  
readline 6.3

We did not change cqpweb recently, nor did we anything but doing  
reqular system upgrades using
apt-get upgrade.

HOwever, when we try a frequency breakdown, the following error  
appears (frst encountered about a week or so ago):

CRITICAL ERROR - DATABASE CACHE OVERLOAD!





CQPweb tried to clear database cache space but failed!





Please report this error to the system administrator.


PHP debugging backtrace

array(5) {
   [1]=>
   array(4) {
     ["file"]=>
     string(35) "/var/www/html/cqpweb/lib/db.inc.php"
     ["line"]=>
     int(581)
     ["function"]=>
     string(20) "exiterror_dboverload"
     ["args"]=>
     array(0) {
     }
   }
   [2]=>
   array(4) {
     ["file"]=>
     string(35) "/var/www/html/cqpweb/lib/db.inc.php"
     ["line"]=>
     int(95)
     ["function"]=>
     string(16) "delete_saved_dbs"
     ["args"]=>
     array(0) {
     }
   }
   [3]=>
   array(4) {
     ["file"]=>
     string(42) "/var/www/html/cqpweb/lib/breakdown.inc.php"
     ["line"]=>
     int(160)
     ["function"]=>
     string(9) "create_db"
     ["args"]=>
     array(6) {
       [0]=>
       &string(4) "sort"
       [1]=>
       &string(10) "fqa49mvvxx"
       [2]=>
       &string(12) "[word="des"]"
       [3]=>
       &string(0) ""
       [4]=>
       &string(0) ""
       [5]=>
       &string(0) ""
     }
   }
   [4]=>
   array(4) {
     ["file"]=>
     string(41) "/var/www/html/cqpweb/lib/redirect.inc.php"
     ["line"]=>
     int(73)
     ["args"]=>
     array(1) {
       [0]=>
       string(42) "/var/www/html/cqpweb/lib/breakdown.inc.php"
     }
     ["function"]=>
     string(7) "require"
   }
   [5]=>
   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"
   }
}

and after a few more tries we finally reach the following error:

Too many database processes!

There are already 5 query sort databases being compiled.

Please use the Back-button of your browser and try again in a few moments.

Rebooting the server removes the latter error, but not the cache problem.

What can be the cause of the cache problem and how can I remove it?

Greetings from Saarbrücken,

Jörg Knappen


_______________________________________________
CWB mailing list
CWB at sslmit.unibo.it
http://liste.sslmit.unibo.it/mailman/listinfo/cwb