I upgraded my test server to 5.7.1 in preparation for the upgrade of the live server and now when I try to create a new page in any space I get a spinning wheel "loading" and never loads (I even left it running all night still loading the next morning) and the following error in my log:
net.sf.hibernate.ObjectNotFoundException: No row with the given identifier exists: 61898755, of class: com.atlassian.confluence.spaces.Space
Anyone know what went wrong? I tried a re-index but it didn't help.
Hello Robert, it appears that the application is having troubles while retrieving data from a label. You can use the following queries to remove any orphanated references, note to have a DB snapshot ready before running any queries against the dataset.
First being to check scope, second to remove reference, third to find additional offenders that may persist harming Confluence. :-)
select * from content_label; delete from content_label where labelid=61898755; select * from content_label where labelid not in (select labelid from label)
K I know what happened now, I got a list of all the titles. What happened was I did a database export from the live server and a database import to the staged server. The live server had some a space that was deleted, and when the database got imported it must have had residue of that lost space. How do I remove that content? I tried delete FROM conf.CONTENT WHERE SPACEID = '61898755'; but that did not work as it failed foreign key constraint.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG