Unable to Deploy JIRA Due to MySQL 'max_questions' Resource Limit
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
When trying to deploy JIRA, the following error appears in the JIRA logs:
1
2
3
4
5
6
7
SQL Exception while executing the following:
SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM propertyentry
WHERE ENTITY_NAME=? AND ENTITY_ID=?
(User 'jirauser' has exceeded the 'max_questions' resource (current value: 100))
at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.getKeys(OFBizPropertySet.java:100)
at com.opensymphony.module.propertyset.AbstractPropertySet.getKeys(AbstractPropertySet.java:292)
at com.opensymphony.module.propertyset.PropertySetCloner.cloneProperties(PropertySetCloner.java:114)
Cause
MySQL has been configured to limit the number of queries a user can make in an hour.
Resolution
Increase the max_questions property for the user. This will set it to unlimited:
1
2
3
4
use mysql;
update user set max_questions = 0 where user = 'jirauser';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 4 Changed: 0 Warnings: 0
ℹ️ The above example assumes that the user used by JIRA to access mysql is 'jirauser'. You'll want to replace this with the appropriate username for your system.
Was this helpful?