cqpweb triggers error “DATABASE CACHE OVERLOAD!â€
Clash Royale CLAN TAG#URR8PPP up vote
1
down vote
favorite
cqpweb is a web interface to corpora programmed in php and using a mysql database. We run it successfully (and for quite a time unchanged) on our server, but during the last week or so, some database queries started fail consistently.
We run ubuntu 14.04 LTS and do regular upgrades with apt-get upgrade. Otherwise, we did not change the system configuration. I checked that disk space is not a problem.
Current versions of programs:
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
mysql --version
mysql Ver 14.14 Distrib 5.5.59, for debian-linux-gnu (x86_64) using readline 6.3
What can cause a database cache overload and how can I cure it? Rebboting the server does not help.
14.04 mysql php lamp
asked Apr 12 at 12:57
jknappen
116117
add a comment |Â
up vote
1
down vote
favorite
cqpweb is a web interface to corpora programmed in php and using a mysql database. We run it successfully (and for quite a time unchanged) on our server, but during the last week or so, some database queries started fail consistently.
We run ubuntu 14.04 LTS and do regular upgrades with apt-get upgrade. Otherwise, we did not change the system configuration. I checked that disk space is not a problem.
Current versions of programs:
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
mysql --version
mysql Ver 14.14 Distrib 5.5.59, for debian-linux-gnu (x86_64) using readline 6.3
What can cause a database cache overload and how can I cure it? Rebboting the server does not help.
14.04 mysql php lamp
asked Apr 12 at 12:57
jknappen
116117
add a comment |Â
up vote
1
down vote
favorite
up vote
1
down vote
favorite
cqpweb is a web interface to corpora programmed in php and using a mysql database. We run it successfully (and for quite a time unchanged) on our server, but during the last week or so, some database queries started fail consistently.
We run ubuntu 14.04 LTS and do regular upgrades with apt-get upgrade. Otherwise, we did not change the system configuration. I checked that disk space is not a problem.
Current versions of programs:
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
mysql --version
mysql Ver 14.14 Distrib 5.5.59, for debian-linux-gnu (x86_64) using readline 6.3
What can cause a database cache overload and how can I cure it? Rebboting the server does not help.
14.04 mysql php lamp
asked Apr 12 at 12:57
jknappen
116117
cqpweb is a web interface to corpora programmed in php and using a mysql database. We run it successfully (and for quite a time unchanged) on our server, but during the last week or so, some database queries started fail consistently.
We run ubuntu 14.04 LTS and do regular upgrades with apt-get upgrade. Otherwise, we did not change the system configuration. I checked that disk space is not a problem.
Current versions of programs:
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
mysql --version
mysql Ver 14.14 Distrib 5.5.59, for debian-linux-gnu (x86_64) using readline 6.3
What can cause a database cache overload and how can I cure it? Rebboting the server does not help.
14.04 mysql php lamp
14.04 mysql php lamp
asked Apr 12 at 12:57
jknappen
116117
asked Apr 12 at 12:57
jknappen
116117
edited Apr 12 at 13:17
asked Apr 12 at 12:57
jknappen
116117
asked Apr 12 at 12:57
jknappen
116117
asked Apr 12 at 12:57
jknappen
116117
116117
add a comment |Â
add a comment |Â
1 Answer
1
active
oldest
votes
up vote
0
down vote
accepted
Due to an inquiry on the CWB mailing list I have learned that the cache in question is maintained by the application (cqpweb) and that the Ubuntu upgrades on php and mysql aren't the problem.
In my case, the solution is to enlarge the application cache.
answered Apr 12 at 17:20
jknappen
116117
add a comment |Â
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
accepted
Due to an inquiry on the CWB mailing list I have learned that the cache in question is maintained by the application (cqpweb) and that the Ubuntu upgrades on php and mysql aren't the problem.
In my case, the solution is to enlarge the application cache.
answered Apr 12 at 17:20
jknappen
116117
add a comment |Â
up vote
0
down vote
accepted
Due to an inquiry on the CWB mailing list I have learned that the cache in question is maintained by the application (cqpweb) and that the Ubuntu upgrades on php and mysql aren't the problem.
In my case, the solution is to enlarge the application cache.
answered Apr 12 at 17:20
jknappen
116117
add a comment |Â
up vote
0
down vote
accepted
up vote
0
down vote
accepted
Due to an inquiry on the CWB mailing list I have learned that the cache in question is maintained by the application (cqpweb) and that the Ubuntu upgrades on php and mysql aren't the problem.
In my case, the solution is to enlarge the application cache.
answered Apr 12 at 17:20
jknappen
116117
Due to an inquiry on the CWB mailing list I have learned that the cache in question is maintained by the application (cqpweb) and that the Ubuntu upgrades on php and mysql aren't the problem.
In my case, the solution is to enlarge the application cache.
answered Apr 12 at 17:20
jknappen
116117
answered Apr 12 at 17:20
jknappen
116117
answered Apr 12 at 17:20
jknappen
116117
answered Apr 12 at 17:20
jknappen
116117
116117
add a comment |Â
add a comment |Â
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1024357%2fcqpweb-triggers-error-database-cache-overload%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password