nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

confluence create does not pull templates

Paul DeSousa1

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.

Accepted answers

Paul DeSousa1

select * FROM CONTENT WHERE SPACEID = '61898755';

with the mouse click select all, right delete rows.

And the problem went away. Thanks!

All comments

Guilherme Nedel

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 DeSousa1

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 DeSousa1

So the problem still exists

Paul DeSousa1

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

Paul DeSousa1

select * FROM CONTENT WHERE SPACEID = '61898755';

with the mouse click select all, right delete rows.

And the problem went away. Thanks!

Paul DeSousa1

Shoot! It started again, same error

Paul DeSousa1

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 :-)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

confluence-administration