How to Enable Detailed SQL Logging

Still need help?

The Atlassian Community is here for you.

Ask the community

Bamboo uses the open source persistence framework Hibernate. This page tells you how to configure Bamboo's logging to report individual SQL requests that are sent to the database by Hibernate. It is useful for troubleshooting the following events:

  • Database Corruption
  • Exceptions caused by an illegal database operation
  • Any Database specific error(s)

It is advisable to enable detailed SQL logging before sending us log files so, after you have enabled enhanced logging, please replicate the action that was causing the error in the first place and then generate a Support Zip. This will assist us in determining what SQL queries were running during the reported problem.

 Enabling detailed SQL logging greatly increases the amount of log output produced, potentially resulting in increased disk usage. Ensure you have sufficient disk space available and disable detailed SQL logging once you no longer need it.

Enabling SQL logging using log4j.properties

  1. Stop Bamboo.
  2. Edit log4j.properties, located in <bamboo-install>/atlassian-bamboo/WEB-INF/classes.
  3. Add the following lines to log4j.properties:

    log4j.logger.org.hibernate.type.descriptor.sql.BasicBinder=TRACE
    log4j.logger.org.hibernate.resource.jdbc.internal.ResourceRegistryStandardImpl=TRACE
  4. Start Bamboo

Enabling SQL logging in the Bamboo UI

  1. Access Administration > Overview > Log settings
  2. Add the following log settings:

    ClasspathType
    org.hibernate.type.descriptor.sql.BasicBinder
    ALL
    org.hibernate.resource.jdbc.internal.ResourceRegistryStandardImpl
    ALL

Disable Batched Updates

  1. Stop Bamboo
  2. Edit <bamboo-home>/bamboo.cfg.xml and add the following hibernate.jdbc.batch_size property line:

    <application-configuration>
      ...
      <properties>
        ...
        <property name="hibernate.jdbc.batch_size">0</property>
        ...
      </properties>
    </application-configuration>
  3. Start Bamboo.


Last modified on Sep 19, 2019

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.