confluence create does not pull templates

[Paul DeSousa]

Hi all,

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.

[Paul DeSousa · Accepted solution]

select * FROM CONTENT WHERE SPACEID = '61898755';

with the mouse click select all, right delete rows.

And the problem went away.   Thanks!

[Paul DeSousa]

Shoot! It started again, same error

[Paul DeSousa]

The entries in the database came back. I re-synchronize (rsync) the home dir from the live server to the test server and re upgraded and this resolved it. That is why it is a test server :-)

[Guilherme Nedel [Atlassian]]

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)

[Paul DeSousa]

Interestingly, there were no labels with labelid of '61898755' when I did a select * from CONTENT_LABEL; When I did the delete from I got 0 rows affected.

[Paul DeSousa]

So the problem still exists

[Paul DeSousa]

I did a search of all tables in the database and 61898755 is a space id. Maybe a deleted or rogue space?

[Paul DeSousa]

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.