mySQL : exceeding 'max_questions' resource

The release 1.6 is going to be unsupported by Community. Because our effort moves ahead. However there are still valuable informations for you.

mySQL : exceeding 'max_questions' resource

Postby shitalk » Tue Jun 06, 2006 6:58 am

Hi,

I have about 4-5 people using Testlink concurrently. Every now and then, testlink stops responding. On turning on debug log, I get the foll error:

User \\\'testlink\\\' has exceeded the \\\'max_questions\\\' resource (current value: 1000)

Is there any solution to this? Right now, the only solution I have is to restart mySQL !! :-(
Last edited by shitalk on Wed Jun 07, 2006 1:13 pm, edited 1 time in total.
shitalk
TestLink user
 
Posts: 3
Joined: Thu Feb 16, 2006 11:38 am

Postby havlatm » Wed Jun 07, 2006 7:45 am

havlatm
Member of TestLink Community
 
Posts: 940
Joined: Mon Oct 31, 2005 1:24 am
Location: Czech

Resolved my problem

Postby shitalk » Wed Jun 07, 2006 1:11 pm

Hi,

I googled for max_questions and found that I could set/unset this value:

login as sql admin and:
use mysql;
update user set max_question = 0 where host = \'localhost\' and user = \'testlink\';

Then restart mySQL.

My user is testlink.

I could not find out what is the reasoning for the max-questions in the first place though!
shitalk
TestLink user
 
Posts: 3
Joined: Thu Feb 16, 2006 11:38 am


Return to TestLink 1.6 (closed)



Who is online

Users browsing this forum: No registered users and 2 guests

cron