Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-9902

Silence debug logs of PostgreSQL driver

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.6-M3, 6.6
    • Component/s: None
    • Labels:

      Description

      When debug is enabled, the PostgreSQL driver is very verbose. SonarQube SQL logs are lost in this noise.
      DEBUG and TRACE logs of org.postgresql.jdbc.PgConnection and org.postgresql.core.v3.QueryExecutorImpl should be disabled:

      2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection]   setAutoCommit = false
      2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection]   setAutoCommit = true
      2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection]   setAutoCommit = false
      2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection]   setAutoCommit = true
      2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection]   setAutoCommit = false
      2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection]   setAutoCommit = true
      2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection]   setAutoCommit = false
      2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection]   setAutoCommit = true
      2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection]   setAutoCommit = false
      2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection]   setAutoCommit = true
      2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection]   setAutoCommit = false
      2017.10.02 17:41:28 DEBUG web[][o.p.j.PgConnection]   setAutoCommit = true
      
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]  FE=> Bind(stmt=null,portal=null,$1=<'sonar.lf.aboutText'>)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]  FE=> Describe(portal=null)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]  FE=> Execute(portal=null,limit=0)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]  FE=> Sync
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]  <=BE BindComplete [unnamed]
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]  <=BE CommandStatus(BEGIN)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]  <=BE ParseComplete [null]
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]  <=BE BindComplete [unnamed]
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]  <=BE RowDescription(6)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]         Field(key,VARCHAR,65535,T)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]         Field(empty,BOOL,1,T)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]         Field(textvalue,VARCHAR,65535,T)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]         Field(clobvalue,TEXT,65535,T)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]         Field(resourceid,INT8,8,T)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]         Field(userid,INT8,8,T)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]  <=BE CommandStatus(SELECT 0)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][o.p.c.v.QueryExecutorImpl]  <=BE ReadyForQuery(T)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAM][sql] time=1ms | sql=select             p.prop_key as "key",     p.is_empty as empty,     p.text_value as textValue,     p.clob_value as clobValue,     p.resource_id as resourceId,     p.user_id as userId         from       properties p     where       p.prop_key in          (             ?          )        and p.resource_id is null       and p.user_id is null     order by p.id | params=sonar.lf.aboutText
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl]  <=BE ParseComplete [null]
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl]  <=BE BindComplete [unnamed]
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl]  <=BE CommandStatus(BEGIN)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl]  <=BE ParseComplete [null]
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl]  <=BE BindComplete [unnamed]
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl]  <=BE RowDescription(6)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl]         Field(key,VARCHAR,65535,T)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl]         Field(empty,BOOL,1,T)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl]         Field(textvalue,VARCHAR,65535,T)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl]         Field(clobvalue,TEXT,65535,T)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl]         Field(resourceid,INT8,8,T)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl]         Field(userid,INT8,8,T)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl]  <=BE CommandStatus(SELECT 0)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][o.p.c.v.QueryExecutorImpl]  <=BE ReadyForQuery(T)
      2017.10.03 10:48:26 TRACE web[AV7hbABsyY7eISsSAAAK][sql] time=2ms | sql=select             p.prop_key as "key",     p.is_empty as empty,     p.text_value as textValue,     p.clob_value as clobValue,     p.resource_id as resourceId,     p.user_id as userId         from       properties p     where       p.prop_key=?                 and p.resource_id is null                                 and p.user_id is null | params=sonar.forceAuthentication
      
      

        Attachments

          Activity

            People

            • Assignee:
              simon.brandhof Simon Brandhof
              Reporter:
              simon.brandhof Simon Brandhof
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved: