Enable SQL query logging
Enabling SQL query logging
Create a file
<STASH_HOME>/logback.xmlwith the following text in it:<included> <logger name="org.hibernate.SQL" level="DEBUG"/> </included>- Restart your Stash server.
Look for
org.hibernate.SQLlogging lines in<STASH_HOME>/log/atlassian-stash.logsuch as:2014-12-04 19:39:39,749 DEBUG [clusterScheduler_Worker-8] org.hibernate.SQL delete sta_activity_0 from sta_activity sta_activity_0 inner join HT_sta_pr_rescope_activity HT_sta_pr_rescope_activity_0 on sta_activity_0.id=HT_sta_pr_rescope_activity_0.activity_id
Enabling parameter logging
This may log sensitive information (user names, group names, project names, etc).
SQL queries are parameterized with ?. If you need to see the parameter data, you can enable parameter logging by changing the logback.xml file as below.
<included>
<logger name="org.hibernate.SQL" level="DEBUG"/>
<logger name="org.hibernate.type" level="TRACE"/>
</included>
Last modified on Dec 5, 2014
Powered by Confluence and Scroll Viewport.