When trying to save a new page or edit an existing one,
Getting the following in UI
"This page is taking longer to load than usual. Give it a few moments, then try refreshing. Still having issues? Contact your Confluence admin."
2019-10-16 18:05:12,401 DEBUG [414:StdOutHandler [/opt/java/openjdk/bin/java]] {"synchrony":{"entity":"/Synchrony-21b6e24b-0b8c-3e34-aca1-0dbfaa652781/confluence-10651253","ns":"synchrony.sync.hub","throwable":"com.mysema.query.QueryException: Caught BatchUpdateException for insert into \"EVENTS\" (\"history\", \"rev\", \"partition\", \"sequence\", \"event\") values (?, ?, ?, ?, ?)\n\tat com.mysema.query.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:38)\n\tat com.mysema.query.sql.Configuration.translate(Configuration.java:514)\n\tat com.mysema.query.sql.dml.SQLInsertClause.execute(SQLInsertClause.java:380)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat clojure.lang.Reflector.invokeMatchingMethod(Reflector.java:93)\n\tat synchrony.querydsl.history_store.QueryDslHistoryStore$fn__55905.invoke(history_store.clj:112)\n\tat clojure.core.async$thread_call$fn__6519.invoke(async.clj:439)\n\tat synchrony.data.(take?)(data.clj:364)\n\tat synchrony.data$put_revisions_no_limit_BANG_$fn__39256.invoke(data.clj:361)\n\tat synchrony.data.(take?)(data.clj:413)\n\tat synchrony.data$put_revisions_BANG_$fn__39314.invoke(data.clj:384)\n\tat synchrony.data.(take?)(data.clj:782)\n\tat synchrony.data$put_revisions_ensure_snapshot_BANG_$fn__41126.invoke(data.clj:770)\n\tat synchrony.data.(take?)(data.clj:810)\n\tat synchrony.data$put_revisions_partitioning_BANG_$fn__41189.invoke(data.clj:801)\n\tat synchrony.sync.hub.(take?)(hub.clj:330)\n\tat synchrony.sync.hub$init_in_new_state$fn__42437.invoke(hub.clj:315)\n\tat synchrony.sync.hub.(take?)(hub.clj:576)\n\tat synchrony.sync.hub$process_merge_into_master$fn__43238.invoke(hub.clj:561)\n\tat synchrony.sync.hub.(take?)(hub.clj:599)\n\tat synchrony.sync.hub$fn__43275$fn__43309.invoke(hub.clj:591)\n\tat synchrony.sync.hub.(take?)(hub.clj:762)\n\tat synchrony.sync.hub$process_message$fn__44230.invoke(hub.clj:754)\n\tat clojure.lang.AFn.run(AFn.java:22)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: java.sql.BatchUpdateException: Batch entry 0 insert into \"EVENTS\" (\"history\", \"rev\", \"partition\", \"sequence\", \"event\") values ('/Synchrony-21b6e24b-0b8c-3e34-aca1-0dbfaa652781/confluence-10651253', 'confluence$content$10651253.5', 0, 0, ?) was aborted: ERROR: null value in column \"contentid\" violates not-null constraint\n Detail: Failing row contains (confluence$content$10651253.5, /Synchrony-21b6e24b-0b8c-3e34-aca1-0dbfaa652781/confluence-10651..., 0, 0, \\x01934493469301914a9147c44593429201961e9420bb636f6e666c75656e63..., null, null). Call getNextException to see other errors in the batch.\n\tat org.postgresql.jdbc.BatchResultHandler.handleCompletion(BatchResultHandler.java:166)\n\tat org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:483)\n\tat org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:791)\n\tat org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1547)\n\tat com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2544)\n\tat com.mysema.query.sql.dml.AbstractSQLClause.executeBatch(AbstractSQLClause.java:161)\n\tat com.mysema.query.sql.dml.AbstractSQLClause.executeBatch(AbstractSQLClause.java:171)\n\tat com.mysema.query.sql.dml.SQLInsertClause.execute(SQLInsertClause.java:374)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat java.lang.reflect.Method.invoke(Method.java:498)\n\tat clojure.lang.Reflector.invokeMatchingMethod(Reflector.java:93)\n\tat clojure.lang.Reflector.invokeNoArgInstanceMember(Reflector.java:313)\n\tat synchrony.querydsl.history_store.QueryDslHistoryStore$fn__55905.invoke(history_store.clj:112)\n\tat clojure.core.async$thread_call$fn__6519.invoke(async.clj:439)\n\t... 4 more\nCaused by: org.postgresql.util.PSQLException: ERROR: null value in column \"contentid\" violates not-null constraint\n Detail: Failing row contains (confluence$content$10651253.5, /Synchrony-21b6e24b-0b8c-3e34-aca1-0dbfaa652781/confluence-10651..., 0, 0, \\x01934493469301914a9147c44593429201961e9420bb636f6e666c75656e63..., null, null).\n\tat org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476)\n\tat org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2189)\n\tat org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:472)\n\t... 18 more\n","message":"synchrony.sync.hub [warn] Caught BatchUpdateException for insert into \"EVENTS\" (\"history\", \"rev\", \"partition\", \"sequence\", \"event\") values (?, ?, ?, ?, ?)","level":"warn"}}
2019-10-16 18:05:12,405 DEBUG [414:StdOutHandler [/opt/java/openjdk/bin/java]] {"synchrony":{"message":"synchrony.http.entity-api [warn] Error in put-entity","entity":"/Synchrony-21b6e24b-0b8c-3e34-aca1-0dbfaa652781/confluence-10651253","id":"W6Kc9TmE-jmDBf7YXv5sgg","ns":"synchrony.http.entity-api","throwable":"clojure.lang.ExceptionInfo: Caught BatchUpdateException for insert into \"EVENTS\" (\"history\", \"rev\", \"partition\", \"sequence\", \"event\") values (?, ?, ?, ?, ?) {:type :server-error, :source :server}\n\tat clojure.core$ex_info.invokeStatic(core.clj:4725)\n\tat synchrony.sync.messages$ex_info_from_error_message.invokeStatic(messages.cljc:29)\n\tat synchrony.sync.connection$request_BANG_$fn__31271.invoke(connection.cljc:92)\n\tat synchrony.http.entity-api.(take?)(entity_api.clj:493)\n\tat synchrony.http.entity_api$content_reconciliation$fn__48540.invoke(entity_api.clj:472)\n\tat synchrony.http.entity-api.(take?)(entity_api.clj:536)\n\tat synchrony.http.entity_api$put_revision_handler$fn__48739.invoke(entity_api.clj:518)\n\tat clojure.lang.AFn.run(AFn.java:22)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:748)\n","level":"warn"}}
2019-10-16 18:05:12,405 DEBUG [414:StdOutHandler [/opt/java/openjdk/bin/java]] {"synchrony":{"request":{"remote-addr":"172.19.0.1","uri":"/synchrony/v1/data/Synchrony-21b6e24b-0b8c-3e34-aca1-0dbfaa652781/confluence-10651253","request-method":"post","query-string":"optimistic=true&rewrite-request=true","x-forwarded-for":"51.15.81.8"},"response":{"status":400},"ns":"synchrony.middleware.logging","level":"info","message":"synchrony.middleware.logging [info] null"}}
2019-10-16 18:05:14,394 DEBUG [414:StdOutHandler [/opt/java/openjdk/bin/java]] {"synchrony":{"request":{"remote-addr":"127.0.0.1","uri":"/synchrony/heartbeat","request-method":"get","query-string":null},"response":{"status":200},"ns":"synchrony.middleware.logging","level":"info","message":"synchrony.middleware.logging [info] null"}}
2019-10-16 18:05:19,401 DEBUG [414:StdOutHandler [/opt/java/openjdk/bin/java]] {"synchrony":{"request":{"remote-addr":"127.0.0.1","uri":"/synchrony/heartbeat","request-method":"get","query-string":null},"response":{"status":200},"ns":"synchrony.middleware.logging","level":"info","message":"synchrony.middleware.logging [info] null"}}
Disabling Synchrony in Collaborative editing helps to resolve the issue temporarily
