How to enable debug logging permanently
Introduction
In the cases where you need to have a closer look at what the table grid editor is executing in the background, you can enable logging as described in this article.
Open the log4j.properties file using a text editor such as notepad++ (windows) or vi (unix) and paste following properties
to the end of the file. This file is located under <JIRA installation>/atlassian-jira/WEB-INF/classes/ (for JIRA standalone versions)
Steps to enable logging
Jira 6.0 and further
#####################################################
# IDALKO DEV LOGGING JIRA 6.0 and higher
#####################################################
log4j.appender.igridlog=com.atlassian.jira.logging.JiraHomeAppender
log4j.appender.igridlog.File=igrid-dev.log
log4j.appender.igridlog.MaxFileSize=20480KB
log4j.appender.igridlog.MaxBackupIndex=5
log4j.appender.igridlog.layout=org.apache.log4j.PatternLayout
log4j.appender.igridlog.layout.ConversionPattern=[%d] <%c{1}> %m%n
log4j.logger.com.idalko = DEBUG, igridlog, console
log4j.additivity.com.idalko = false
#
# Disable some verbose classes
#
log4j.logger.com.idalko.jira.plugins.igrid.providers.hibernate.tasks.HibernateTask = OFF
log4j.logger.com.idalko.jira.plugins.igrid.license.PluginLicenseManagerImpl = OFF
#
# Sql log logs all sql statements sent to the database server
#
log4j.appender.isqllog=com.atlassian.jira.logging.JiraHomeAppender
log4j.appender.isqllog.File=igrid-sql.log
log4j.appender.isqllog.MaxFileSize=20480KB
log4j.appender.isqllog.MaxBackupIndex=5
log4j.appender.isqllog.layout=org.apache.log4j.PatternLayout
log4j.appender.isqllog.layout.ConversionPattern=[%d] <%c{1}> %m%n
log4j.logger.org.hibernate.SQL = DEBUG, isqllog
log4j.additivity.org.hibernate.SQL = false
log4j.logger.org.hibernate.tool.hbm2ddl = DEBUG, isqllog
log4j.additivity.org.hibernate.tool.hbm2ddl = false
log4j.logger.org.hibernate.util = DEBUG, isqllog
log4j.additivity.org.hibernate.util = false
log4j.logger.org.hibernate.tool.hbm2ddl.SchemaUpdate = DEBUG, isqllog
log4j.additivity.org.hibernate.tool.hbm2ddl.SchemaUpdate = false
<