[CONFSERVER-93213] When Synchrony is enabled and page has excessive nested span it is not possible to open editor

Type: Bug
Resolution: Incorrectly Filed
Priority: Medium
Fix Version/s: None
Affects Version/s: 8.5.2, 7.19.16, 8.5.3, 8.5.4, 7.19.17
Component/s: Editor - Page / Comment Editor
Labels:
None

Support reference count:
4
Symptom Severity:
Severity 2 - Major
UIS:
18
Bug Fix Policy:
View Atlassian Server bug fix policy

Problem

When Synchrony is enabled and the page has excessive nested  it is not possible to open the editor, to edit the page.

Environment

Steps to Reproduce

Create a page with excessive nested , like the example bellow:

Storage Format

<p><span style="color: rgb(0,0,0);"><strong><span><strong><span><strong><span><strong><span style="color: rgb(255,102,0);"><span style="color: rgb(0,51,102);" lang="ko"><span lang="ko"><strong><span style="color: rgb(255,102,0);"><span style="color: rgb(0,51,102);" lang="ko"><span style="color: rgb(255,102,0);"><span style="color: rgb(0,51,102);" lang="ko"><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span style="color: rgb(255,102,0);"><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span style="color: rgb(0,51,102);" lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><strong><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><strong><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><strong><span lang="ko"><strong><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko">ㅇ사전</span></span><span lang="ko"><span lang="ko">&nbsp;검토 : 미진행<span style="color: rgb(255,102,0);" lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><strong><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko"><span lang="ko">&nbsp;</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></strong></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></strong></span></span></span></strong></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></strong></span></strong></span></span></strong></span></span></strong></span></span></strong></span></span></span></span></strong></span></span></strong></span></span></strong></span></span></strong></span></span></span></strong></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></strong></span></strong></span></span></strong></span></span></strong></span></span></strong></span></span></span></span></strong></span></span></strong></span></span></strong></span></span></strong></span></span></span></strong></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></strong></span></strong></span></span></strong></span></span></strong></span></span></strong></span></span></span></span></strong></span></span></strong></span></span></strong></span></span></strong></span></span></span></strong></span></span></strong></span></span></strong></span></span></span></strong></span></span></strong></span></span></strong></span></span></span></strong></span></span></strong></span></span></strong></span></span></span></span></span></span></strong></span></span></span></strong></span></strong></span></strong></span></strong></span></p>

Click Edit to edit the page.

Expected Results

The editor opens and you are able to edit the page.

Actual Results

The editor opens without loading the page until eventually a popup shows stating "This page is taking longer to load than usual...".

The following errors were thrown in the atlassian-synchrony.log file:

atlassian-synchrony.log

2023-11-08 15:08:27,044 DEBUG [482:StdOutHandler [/opt/atlassian/confluence/7.19.16/jre/bin/java]] 2023-11-08 15:08:27,044 WARN [async-dispatch-6] [synchrony.sync.hubs] closing in-close-promise due to xform error {:throwable #error {
2023-11-08 15:08:27,044 DEBUG [482:StdOutHandler [/opt/atlassian/confluence/7.19.16/jre/bin/java]]   :cause "Depth (1001) exceeds the maximum allowed nesting depth (1000)"
2023-11-08 15:08:27,044 DEBUG [482:StdOutHandler [/opt/atlassian/confluence/7.19.16/jre/bin/java]]   :via
2023-11-08 15:08:27,044 DEBUG [482:StdOutHandler [/opt/atlassian/confluence/7.19.16/jre/bin/java]]   [{:type com.fasterxml.jackson.core.exc.StreamConstraintsException
2023-11-08 15:08:27,044 DEBUG [482:StdOutHandler [/opt/atlassian/confluence/7.19.16/jre/bin/java]]     :message "Depth (1001) exceeds the maximum allowed nesting depth (1000)"
2023-11-08 15:08:27,044 DEBUG [482:StdOutHandler [/opt/atlassian/confluence/7.19.16/jre/bin/java]]     :at [com.fasterxml.jackson.core.StreamReadConstraints validateNestingDepth "StreamReadConstraints.java" 261]}]
2023-11-08 15:08:27,044 DEBUG [482:StdOutHandler [/opt/atlassian/confluence/7.19.16/jre/bin/java]]   :trace
2023-11-08 15:08:27,044 DEBUG [482:StdOutHandler [/opt/atlassian/confluence/7.19.16/jre/bin/java]]   [[com.fasterxml.jackson.core.StreamReadConstraints validateNestingDepth "StreamReadConstraints.java" 261]
2023-11-08 15:08:27,044 DEBUG [482:StdOutHandler [/opt/atlassian/confluence/7.19.16/jre/bin/java]]    [com.fasterxml.jackson.core.base.ParserBase createChildArrayContext "ParserBase.java" 1320]
2023-11-08 15:08:27,044 DEBUG [482:StdOutHandler [/opt/atlassian/confluence/7.19.16/jre/bin/java]]    [com.fasterxml.jackson.core.json.ReaderBasedJsonParser nextToken "ReaderBasedJsonParser.java" 755]
2023-11-08 15:08:27,044 DEBUG [482:StdOutHandler [/opt/atlassian/confluence/7.19.16/jre/bin/java]]    [cheshire.parse$parse_STAR_ invokeStatic "parse.clj" 64]
2023-11-08 15:08:27,044 DEBUG [482:StdOutHandler [/opt/atlassian/confluence/7.19.16/jre/bin/java]]    [cheshire.parse$parse_STAR_ invoke "parse.clj" 61]
(...)

Workaround

As it is not possible to open the editor to use it to remove the span tags, it is necessary to do it directly in the database.
Locate the Page ID, then retrive the page body content using the following query:

select body from bodycontent where contentid = <page ID>;

Remove the  tags.
Update the page with the cleaned content:

update bodycontent set body = '<content_without_span>' where  contentid = <page ID>;

Notes

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List

Screenshot 2023-11-10 at 17.57.44.png
10/Nov/2023 8:58 PM
16 kB
Marcio Ribeiro

causes: PS-155554 You do not have permission to view this issue

Marcelo da Costa made changes - 24/Jan/2024 9:41 PM

Affects Version/s

Original: 8.5.5 [ 106525 ]

Marcelo da Costa made changes - 24/Jan/2024 9:40 PM

Affects Version/s

New: 8.5.5 [ 106525 ]

Jai Shori made changes - 28/Dec/2023 5:27 PM

Affects Version/s		New: 8.5.4 [ 106320 ]
Affects Version/s		New: 7.19.17 [ 106326 ]

James Ponting made changes - 17/Nov/2023 10:41 PM

QA Demo Status	Original: Not Done [ 14330 ]	New: Not Needed [ 14332 ]
QA Kickoff Status	Original: Not Done [ 14234 ]	New: Not Needed [ 14236 ]
Resolution	Original: Duplicate [ 3 ]	New: Incorrectly Filed [ 10100 ]
Status	Original: Closed [ 6 ]	New: Closed [ 6 ]

James Ponting made changes - 17/Nov/2023 10:41 PM

Resolution		New: Duplicate [ 3 ]
Status	Original: Needs Triage [ 10030 ]	New: Closed [ 6 ]

SET Analytics Bot made changes - 17/Nov/2023 2:02 AM

UIS

Original: 17

New: 18

SET Analytics Bot made changes - 16/Nov/2023 4:03 AM

Support reference count

Original: 3

New: 4

SET Analytics Bot made changes - 15/Nov/2023 2:01 AM

UIS

Original: 15

New: 17

SET Analytics Bot made changes - 14/Nov/2023 4:02 AM

Support reference count

Original: 2

New: 3

SET Analytics Bot made changes - 14/Nov/2023 2:01 AM

UIS

Original: 3

New: 15

Assignee:: Unassigned

Reporter:: Marcio Ribeiro (Inactive)

Affected customers:: 0 This affects my team

Watchers:: 12 Start watching this issue

Created:: 10/Nov/2023 9:23 PM

Updated:: 05/Sep/2024 8:34 PM

Resolved:: 17/Nov/2023 10:41 PM

Details

Description

Problem

Environment

Steps to Reproduce

Expected Results

Actual Results

Workaround

Notes

Attachments

Attachments

Issue Links

Forms

Activity

People

Dates