Details
Major 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