Confluence has been updated to version 6.15.9

Page tree
Skip to end of metadata
Go to start of metadata

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


Jira 4.4 and further

#####################################################
# 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

#####################################################
# 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