Some pages go "Page not found" even though they exist, restoring and re-restoring them fixes problem

[Malte Schmidt]

Hello,

I recently noticed on an Confluence instance running Postgres 9.6 and Confluence 7.8.x that some links turn into a "Page not found".

Looking up the contentid in the database and manually opening the "Page information" page, they exist and look fine. Restoring the page to an older version and then re-restoring it to the current one fixes the problem, the pretty link (e. g. https://confluence/TEST/Test+site and also the normal link work fine again).

SELECT c.title, 
u.username AS Creator, 
c.contentid,
c.creationdate, 
c.lastmoddate, 
um.username AS LastModifier
FROM content c 
JOIN user_mapping u ON c.creator = u.user_key 
JOIN user_mapping um ON c.lastmodifier = um.user_key 
WHERE c.prevver IS NULL 
AND c.contenttype = 'PAGE' 
AND c.content_status = 'current'
AND c.title LIKE '%testtitle%'
ORDER BY title; 

Has anyone experienced this problem? How to proceed here?

I verified with the Release Notes of all following versions that this problem is not known/fixed.

EDIT:

I verified that this only affects the "pretty links". The pages that show "Page not found" with the pretty link are perfectly accessible using the normal link containing the ID.

Broken: https://confluence/TEST/Test+site
Working: https://confluence/pages/viewpage.action?pageId=1234