Not able to edit pages

[Noe Masis]

Since yesterday we're not able to save an edited page- the popup says: 'no connection to server - saving actually not possible'

Whenever I sa

019-08-27 09:10:56,711 WARN [http-nio-8090-exec-4] [plugins.tasklist.transformer.DefaultInlineTaskRenderedFieldsExtractor] buildDescription Unable to extract links from the Inline Task title. The Inline Task will be created without a description.
-- referer: https://docs.orsiniit.com/pages/editpage.action | url: /rest/api/content/5014030 | traceId: de90dc16225d22f8 | userName: noe
2019-08-27 09:10:56,727 WARN [http-nio-8090-exec-4] [plugins.tasklist.transformer.DefaultInlineTaskRenderedFieldsExtractor] buildDescription Unable to extract links from the Inline Task title. The Inline Task will be created without a description.
-- referer: https://docs.orsiniit.com/pages/editpage.action | url: /rest/api/content/5014030 | traceId: de90dc16225d22f8 | userName: noe
2019-08-27 09:10:56,727 WARN [http-nio-8090-exec-4] [plugins.tasklist.transformer.DefaultInlineTaskRenderedFieldsExtractor] buildDescription Unable to extract links from the Inline Task title. The Inline Task will be created without a description.
-- referer: https://docs.orsiniit.com/pages/editpage.action | url: /rest/api/content/5014030 | traceId: de90dc16225d22f8 | userName: noe
2019-08-27 09:10:56,727 WARN [http-nio-8090-exec-4] [plugins.tasklist.transformer.DefaultInlineTaskRenderedFieldsExtractor] buildDescription Unable to extract links from the Inline Task title. The Inline Task will be created without a description.
-- referer: https://docs.orsiniit.com/pages/editpage.action | url: /rest/api/content/5014030 | traceId: de90dc16225d22f8 | userName: noe
2019-08-27 09:10:56,742 WARN [http-nio-8090-exec-4] [plugins.tasklist.transformer.DefaultInlineTaskRenderedFieldsExtractor] buildDescription Unable to extract links from the Inline Task title. The Inline Task will be created without a description.
-- referer: https://docs.orsiniit.com/pages/editpage.action | url: /rest/api/content/5014030 | traceId: de90dc16225d22f8 | userName: noe
2019-08-27 09:10:56,742 WARN [http-nio-8090-exec-4] [plugins.tasklist.transformer.DefaultInlineTaskRenderedFieldsExtractor] buildDescription Unable to extract links from the Inline Task title. The Inline Task will be created without a description.
-- referer: https://docs.orsiniit.com/pages/editpage.action | url: /rest/api/content/5014030 | traceId: de90dc16225d22f8 | userName: noe
2019-08-27 09:10:56,742 WARN [http-nio-8090-exec-4] [plugins.tasklist.transformer.DefaultInlineTaskRenderedFieldsExtractor] buildDescription Unable to extract links from the Inline Task title. The Inline Task will be created without a description.
-- referer: https://docs.orsiniit.com/pages/editpage.action | url: /rest/api/content/5014030 | traceId: de90dc16225d22f8 | userName: noe
2019-08-27 09:10:58,883 ERROR [http-nio-8090-exec-4] [engine.jdbc.spi.SqlExceptionHelper] logExceptions Timeout trying to lock table ; SQL statement:
delete from USERCONTENT_RELATION where RELATIONID=? [50200-196]
-- referer: https://docs.orsiniit.com/pages/editpage.action | url: /rest/api/content/5014030 | traceId: de90dc16225d22f8 | userName: noe
2019-08-27 09:10:58,883 WARN [http-nio-8090-exec-4] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[com.atlassian.confluence.api.impl.service.content.draft.ContentDraftServiceImpl.publishEditDraft]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1762058980)
-- referer: https://docs.orsiniit.com/pages/editpage.action | url: /rest/api/content/5014030 | traceId: de90dc16225d22f8 | userName: noe
2019-08-27 09:10:58,883 ERROR [http-nio-8090-exec-4] [rest.api.model.ExceptionConverter] convertServiceException No status code found for exception, converting to internal server error :
-- referer: https://docs.orsiniit.com/pages/editpage.action | url: /rest/api/content/5014030 | traceId: de90dc16225d22f8 | userName: noe
org.springframework.dao.PessimisticLockingFailureException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.PessimisticLockException: could not execute statement

Tried to follow this but it was already disabled

https://community.atlassian.com/t5/Confluence-questions/Getting-error-quot-Unable-to-communicate-with-server-Saving-is/qaq-p/27058

Tried multiple browsers as well. 

[Mike Rathwell]

Hi @Noe Masis 

It sounds like your Synchrony service has taken a header for some reason in your instance. Go to the Administration -> General Configuration -> Collaborative editing section. If it's happy (which I suspect it's not) you'll see a happy green "Running" lozenge there. 

Things to check; make sure there aren't any changes to any proxy server in front of Confluence. Also check to see if a happy sec admin decided that "Confluence is on 8090 so that's all that can be open" as Synchrony runs on 8091 (defaults). 

Sometimes you can get it back by clicking the "Restart Synchrony" button in that admin screen assuming nothing changed in your environment.

[Noe Masis]

I restarted the service both saying running and all happy. 

I continue to receive the same error. 

[Mike Rathwell]

Hi @Noe Masis 

It starts to feel like there was a change in a proxy/firewall/something. A shot in the dark, try to edit a page from an incognito browser window and see what you get.

[Noe Masis]

Issue started yesterday but nothing changed on the on prem server network. I tried from incognito mode but same thing. 

Is there any logs that can tell me exactly what it is?

[Mike Rathwell]

Did you have a look in $CONF_HOME/logs/atlassian-synchrony.log? That might have some clues...

A "hail mary" approach also might be to stop Confluence, clear the plugin cache, and restart... I know it's rather a "Windoze" way of doing things but when all else failed and I ran out of patience trying to fix in place, that was a repairation...