-
Bug
-
Resolution: Fixed
-
High
-
5.6.1, 5.7, 5.8.5
-
None
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.
- 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-35096 Error moving object with pages "JIRA Issue / Filter"
-
- 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-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...
Many apologies Jan-Peter, I've told my robotic Minion to stop posting comments visible to customers, you should have a quieter inbox again.
The comments let our developers know when their work on issues has been included in releases that get built, tested and deployed automatically to Cloud environments. Visibility is now restricted to staff only; please let me know if you're still getting emails.
Regards,
Mike Howells
Cloud Release Manager