Symptoms

When accessing Confluence Space or directory through a WebDAV client, the client timed out. This normally happens when the Space contains a huge number of pages. Accessing the Space directly through Confluence site works fine.

Cause

Confluence ancestor table is out of sync in the database.

Diagnosis

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
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.

Resolution

Rebuild your Confluence ancestor table