Loading...

XML

Word

Printable

Details

Type: Bug
Resolution: Fixed
Priority: High
Fix Version/s: 5.9.2, 5.8.18
Affects Version/s: 5.6.1, 5.7, 5.8.5
Component/s: None
Labels:

Bug Fix Policy:
View Atlassian Server bug fix policy

Description

NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

Related
https://jira.atlassian.com/browse/CONF-24883 (similar issue)
https://jira.atlassian.com/browse/CONF-34870 (slow page move increases window of deadlock)

Suggested fix(es)

Have single (cluster wide) queue for page move operation
Hold (cluster) composite lock (parentID:childId), or do two locks in natural ordering (parentId -< childId).

Side effect of this bug

Page Tree cycling eternally and causes OOM in under few minutes.
breadcrumbs hits stackoverflow
other plugins (indexing?) are not guaranteed to handle cyclic graphs in confluence.

Symptoms:
nginx:

172.24.12.144 - - [23/Sep/2014:01:40:43 +0000] "GET /pages/movepage.action?pageId=2302876189&position=append&targetId=2298943959&atl_token=1a8fab263d4644b9373a3453c9bceea99fdd9166&_=1411436432399 HTTP/1.0" 200 271 "https://extranet.atlassian.com/pages/reorderpages.action?key=ST" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:32.0) Gecko/20100101 Firefox/32.0"
172.24.12.144 - - [23/Sep/2014:01:40:44 +0000] "GET /pages/movepage.action?pageId=2302876189&position=above&targetId=2298943959&atl_token=1a8fab263d4644b9373a3453c9bceea99fdd9166&_=1411436436617 HTTP/1.0" 200 271 "https://extranet.atlassian.com/pages/reorderpages.action?key=ST" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:32.0) Gecko/20100101 Firefox/32.0"
172.24.12.144 - - [23/Sep/2014:01:40:45 +0000] "GET /pages/movepage.action?pageId=2298943959&position=append&targetId=2302876189&atl_token=1a8fab263d4644b9373a3453c9bceea99fdd9166&_=1411436439759 HTTP/1.0" 200 265 "https://extranet.atlassian.com/pages/reorderpages.action?key=ST" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:32.0) Gecko/20100101 Firefox/32.0"
172.24.12.144 - - [23/Sep/2014:01:41:04 +0000] "GET /pages/movepage.action?pageId=2301533426&position=below&targetId=2302876189&atl_token=1a8fab263d4644b9373a3453c9bceea99fdd9166&_=1411436461303 HTTP/1.0" 200 297 "https://extranet.atlassian.com/pages/reorderpages.action?key=ST" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:32.0) Gecko/20100101 Firefox/32.0"
172.24.12.144 - - [23/Sep/2014:01:41:06 +0000] "GET /pages/movepage.action?pageId=2301533426&position=above&targetId=2298943959&atl_token=1a8fab263d4644b9373a3453c9bceea99fdd9166&_=1411436465795 HTTP/1.0" 200 297 "https://extranet.atlassian.com/pages/reorderpages.action?key=ST" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:32.0) Gecko/20100101 Firefox/32.0"

App log(full version attached):

2014-09-22 20:40:44,397 ERROR [catalina-exec-10] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ERROR: deadlock detected
  Detail: Process 29730 waits for ShareLock on transaction 2482659; blocked by process 14749.
Process 14749 waits for ShareLock on transaction 2482650; blocked by process 29730.
  Hint: See server log for query details.

Attachments

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

atlassian-confluence.log.1.gz
1.47 MB
24/Sep/2014 2:53 AM
pagemove.log
211 kB
24/Sep/2014 2:53 AM
Page Not Found.png
13 kB
13/Jul/2015 11:41 AM
Screen Shot 2015-09-29 at 12.22.49.png
31 kB
29/Sep/2015 11:24 AM

Issue Links

is related to

CONFSERVER-24883 Moving a page can time out and leave Confluence in an inconsistent state

Closed

CONFSERVER-34870 The page move UI should provide feedback when the move is slow and multiple concurrent moves of the same page should be prevented

Closed

CONFSERVER-35396 Page move action is too slow when moving a large number of pages

Closed

relates to

CONFCLOUD-35040 Page move action causes database deadlock and data corruption

Closed

CONFSERVER-34226 Detect loops when going through page tree structure

Closed

CONFSERVER-19476 Ancestor table gets out of sync when moving pages to another space

Closed

CONFSERVER-38220 User is able to move a page tree although another user is moving it at the same time

Closed

CONFSERVER-38222 Page move fails with deep page hierarchy

Closed

CONFSERVER-40315 Cannot move pages

Closed

CONFSERVER-35096 Error moving object with pages "JIRA Issue / Filter"

Gathering Impact

CONFSERVER-25188 Identify the health state of Confluence ancestor CONFANCESTORS table

Closed

included in

CPU-64 Confluence 5.9.1-OD-2015.47.1-0002

CPU-103 Confluence 6.0.0-OD-2015.48.1-0004

CPU-106 Confluence 6.0.0-OD-2015.48.1-0006

mentioned in: Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...

PIR - Priority Action: PIR-28 Loading...

(6 relates to, 3 included in, 18 mentioned in, 1 PIR - Priority Action)

Activity

People

Assignee:: Petro Semeniuk (Inactive)

Reporter:: Petro Semeniuk (Inactive)

Votes:: 51 Vote for this issue

Watchers:: 68 Start watching this issue

Dates

Created:: 24/Sep/2014 12:01 AM

Updated:: 07/Dec/2022 12:40 PM

Resolved:: 12/Nov/2015 7:03 AM