Enable SQL query logging

'How Do I...' and 'How to...' Guide to Stash

このページの内容

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

Enabling SQL query logging

  1. Create a file <STASH_HOME>/logback.xml with the following text in it:

    <included>
    <logger name="org.hibernate.SQL" level="DEBUG"/>
    </included>
  2. Restart your Stash server.
  3. Look for org.hibernate.SQL logging lines in <STASH_HOME>/log/atlassian-stash.log such 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>
最終更新日: 2014 年 12 月 5 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.