Confluence Synchrony logging level

Dave Theodore [Coyote Creek Consulting]

I'm setting up a Confluence Data Center environment and have dedicated Synchrony nodes.  Collaborative editing isn't working and I think the issue is that Synchrony can't access the database due to special characters in the password. There is no logging on the database activity.  Is there a switch I can enable to crank up the SQL log verbosity? Nothing obvious in the docs.

Startup logs:

{"timestamp":"2018-09-11T23:26:28,342Z","level":"INFO","thread":"main","logger":"synchrony.querydsl.jdbc","message":{"synchrony":{"message":"synchrony.querydsl.jdbc [info] connection pool test-connection-on-checkin: true idle-connection-test-period: 1800 max-idle-time-excess-connections: 1800 max-idle-time: 10800","ns":"synchrony.querydsl.jdbc","level":"info"}},"location":{"class":"synchrony.logging$eval69$fn__73","method":"invoke","line":"0"}}

{"timestamp":"2018-09-11T23:26:28,365Z","level":"INFO","thread":"MLog-Init-Reporter","logger":"com.mchange.v2.log.MLog","message":"MLog clients using slf4j logging.","location":{"class":"com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$InfoLogger","method":"log","line":"203"}}

{"timestamp":"2018-09-11T23:26:28,395Z","level":"INFO","thread":"main","logger":"com.mchange.v2.c3p0.C3P0Registry","message":"Initializing c3p0-0.9.5.1 [built 16-June-2015 00:06:36 -0700; debug? true; trace: 10]","location":{"class":"com.mchange.v2.log.slf4j.Slf4jMLog$Slf4jMLogger$InfoLogger","method":"log","line":"203"}}

{"timestamp":"2018-09-11T23:26:28,472Z","level":"INFO","thread":"main","logger":"com.hazelcast.instance.DefaultAddressPicker","message":"[LOCAL] [Confluence-Synchrony] [3.7.4] Interfaces is enabled, trying to pick one address matching to one of: [10.13.0.8]","location":{"class":"com.hazelcast.logging.Log4jFactory$Log4jLogger","method":"log","line":"50"}}

{"timestamp":"2018-09-11T23:26:28,473Z","level":"INFO","thread":"main","logger":"com.hazelcast.instance.DefaultAddressPicker","message":"[LOCAL] [Confluence-Synchrony] [3.7.4] Prefer IPv4 stack is true.","location":{"class":"com.hazelcast.logging.Log4jFactory$Log4jLogger","method":"log","line":"50"}}

{"timestamp":"2018-09-11T23:26:28,478Z","level":"INFO","thread":"main","logger":"com.hazelcast.instance.DefaultAddressPicker","message":"[LOCAL] [Confluence-Synchrony] [3.7.4] Picked [10.13.0.8]:5701, using socket ServerSocket[addr=/0:0:0:0:0:0:0:0,localport=5701], bind any local is true","location":{"class":"com.hazelcast.logging.Log4jFactory$Log4jLogger","method":"log","line":"50"}}

{"timestamp":"2018-09-11T23:26:28,484Z","level":"INFO","thread":"main","logger":"com.hazelcast.system","message":"[10.13.0.8]:5701 [Confluence-Synchrony] [3.7.4] Hazelcast 3.7.4 (20161209 - 3df1bb5) starting at [10.13.0.8]:5701","location":{"class":"com.hazelcast.logging.Log4jFactory$Log4jLogger","method":"log","line":"50"}}

sarath sasi

Hi,

 

1.Do you have seperate nodes for synchrony or running in same server?

2.What error you are seeing in developer panel while editing?

3.Do you have error in UI when you turn on collaborative editing in admin section?