Problem

While attempting to move a page or a page family to other locations, the operation halts with an error:

Move failed. There was a problem contacting the server.

An error on missing attachments directory appears in Confluence log, similar to this:

2010-03-29 20:52:08,066 ERROR [http-8310-1] [pages.persistence.dao.UpdateAttachmentsOnFilesystemOnPageMoveListener] moveAttachments Could not move the attachment data along with the page for move of page Solaris Tomcat install
 -- referer: http://localhost:8310/display/IT/Solaris+Tomcat+install | url: /pages/movepage.action | userName: confadm | action: movepage
java.io.FileNotFoundException: Source 'C:\confluence\confluence-home\attachments\ver003\27\117\1867777\67\243\5243067' does not exist
	at org.apache.commons.io.FileUtils.moveDirectory(FileUtils.java:1733)5243067
	at com.atlassian.confluence.pages.persistence.dao.UpdateAttachmentsOnFilesystemOnPageMoveListener.moveAttachments(UpdateAttachmentsOnFilesystemOnPageMoveListener.java:78)
	at com.atlassian.confluence.pages.persistence.dao.UpdateAttachmentsOnFilesystemOnPageMoveListener.handleEvent(UpdateAttachmentsOnFilesystemOnPageMoveListener.java:57)
	at com.atlassian.event.DefaultEventManager$2.run(DefaultEventManager.java:202

Before the move, the folder in question (i.e. C:\confluence\confluence-home\attachments\ver003\27\117\1867777\67\243\5243067) exists in the filesystem. However, it disappears after the failure.

 Causes and Resolutions

Cause #1

Ancestors table

The CONFANCESTORS table (which is used to speed up permission checks on parent-child page relationship) is broken. There are multiple records for a single page, which causes Confluence to fire multiple events. For each event, Confluence moves the attachment to the new folder, hence, subsequent events fail due to the "missing" folder.

Check if CONFANCESTORS table is corrupted by running this SQL query:

SELECT A.ANCESTORID, A.DESCENDENTID, COUNT(A.DESCENDENTID)
FROM CONFANCESTORS A, CONTENT B
WHERE B.CONTENTID = A.DESCENDENTID
GROUP BY A.ANCESTORID, A.DESCENDENTID HAVING COUNT(A.DESCENDENTID) != 1
ORDER BY 3 DESC;

All returned rows should have value '1' for the column 'count'. If there is a value other than '1' (e.g. '2', '3', etc.), the CONFANCESTORS table is broken.

To address this, restore Confluence (from backup) to the state before the page move. Then, rebuild CONFANCESTORS table before attempting the page move again.

Cause #2
Attachment Checkout plugin by Locus-Global is installed
We have a user reported that Attachment Checkout plugin by vendor Locus-Global is one of the root cause of this issue. For resolution, please disable or uninstall it.

Note: Please note that there are different Attachment Checkout plugins in the market and the one being referred here is from the vendor - Locus-Global.