Introduction
| Excerpt |
|---|
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
| Code Block |
|---|
#####################################################
# 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 |
Jira 4.4 and further
| Panel |
|---|
#####################################################
# IDALKO DEV LOGGING JIRA 4.4 and higher
#####################################################
log4j.appender.igridlog=com.atlassian.jira.logging.MultiTenantJiraHomeAppender
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.appender.isqllog=com.atlassian.jira.logging.MultiTenantJiraHomeAppender
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.com.idalko = INFO, igridlog, console
log4j.additivity.com.idalko = false
log4j.logger.org.hibernate.SQL = INFO, isqllog
log4j.additivity.org.hibernate.SQL = false
log4j.logger.org.hibernate.tool.hbm2ddl = INFO, isqllog
log4j.additivity.org.hibernate.tool.hbm2ddl = false
log4j.logger.org.hibernate.util = INFO, isqllog
log4j.additivity.org.hibernate.util = false
log4j.logger.org.hibernate.tool.hbm2ddl.SchemaUpdate = INFO, isqllog
log4j.additivity.org.hibernate.tool.hbm2ddl.SchemaUpdate = false |
Jira 4.2
| Panel |
|---|
#####################################################
# IDALKO DEV LOGGING JIRA 4.2
#####################################################
log4j.appender.igridlog=org.apache.log4j.RollingFileAppender
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.appender.isqllog=org.apache.log4j.RollingFileAppender
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.com.idalko = INFO, igridlog, console
log4j.additivity.com.idalko = false
log4j.logger.org.hibernate.SQL = INFO, isqllog
log4j.additivity.org.hibernate.SQL = false
log4j.logger.org.hibernate.tool.hbm2ddl = INFO, isqllog
log4j.additivity.org.hibernate.tool.hbm2ddl = false
log4j.logger.org.hibernate.util = INFO, isqllog
log4j.additivity.org.hibernate.util = false
log4j.logger.org.hibernate.tool.hbm2ddl.SchemaUpdate = INFO, isqllog
log4j.additivity.org.hibernate.tool.hbm2ddl.SchemaUpdate = false |