Creating new page or space loads forever

Still need help?

The Atlassian Community is here for you.

Ask the community

This article only applies to Atlassian's server products. Learn more about the differences between cloud and server.

The problem reported by this KB is a bug: CONFSERVER-57943 - Getting issue details... STATUS It is already fixed on Confluence versions:  6.15.36.13.56.15.4 or later. Our recommendation is to upgrade to the fixed versions.


Problem

When click on Create Space or Create Page button, the pop up comes up and loads forever.

Cause

When trying to create a page or space, the following logs will come up on the database log:

< 2015-04-29 12:03:09.099 EDT >ERROR:  relation "AO_54C900_CONTENT_BLUEPRINT_AO_ID_seq" does not exist at character 16
< 2015-04-29 12:03:09.099 EDT >STATEMENT:  SELECT NEXTVAL('"AO_54C900_CONTENT_BLUEPRINT_AO_ID_seq"')
< 2015-04-29 12:03:09.105 EDT >ERROR:  current transaction is aborted, commands ignored until end of transaction block
< 2015-04-29 12:03:09.105 EDT >STATEMENT:  SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME,  CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema'  WHEN true THEN CASE  WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TABLE'   WHEN 'v' THEN 'SYSTEM VIEW'   WHEN 'i' THEN 'SYSTEM INDEX'   ELSE NULL   END  WHEN n.nspname = 'pg_toast' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TOAST TABLE'   WHEN 'i' THEN 'SYSTEM TOAST INDEX'   ELSE NULL   END  ELSE CASE c.relkind   WHEN 'r' THEN 'TEMPORARY TABLE'   WHEN 'i' THEN 'TEMPORARY INDEX'   WHEN 'S' THEN 'TEMPORARY SEQUENCE'   WHEN 'v' THEN 'TEMPORARY VIEW'   ELSE NULL   END  END  WHEN false THEN CASE c.relkind  WHEN 'r' THEN 'TABLE'  WHEN 'i' THEN 'INDEX'  WHEN 'S' THEN 'SEQUENCE'  WHEN 'v' THEN 'VIEW'  WHEN 'c' THEN 'TYPE'  WHEN 'f' THEN 'FOREIGN TABLE'  ELSE NULL  END  ELSE NULL  END  AS TABLE_TYPE, d.description AS REMARKS  FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c  LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0)  LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class')  LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog')  WHERE c.relnamespace = n.oid  AND c.relname LIKE 'PROBABLYNOT' AND (false  OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) )  ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME 

or

2018-10-24 10:26:12,392 WARN [https-jsse-nio-8443-exec-10] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #322332976)
– referer: https://<wiki-hostname>/spacedirectory/view.action | url: /rest/create-dialog/1.0/space-blueprint/dialog/web-items | traceId: 3504893171073da4 | userName: testuser

A network trace showed us that we get an HTTP status 500 accessing the resource at https://<wiki-hostname>/rest/create-dialog/1.0/space-blueprint/dialog/web-items. This means that Confluence cannot find a relation between the table and his Foreign Key. 

Solution

  • Make sure you have a backup from your database first.
  • The changes below will delete space and page templates and blueprints so make sure to take a backup of them first.

1 - Stop Confluence

2 - Drop the following tables:

DROP TABLE AO_54C900_SPACE_BLUEPRINT_AO;
DROP TABLE AO_54C900_C_TEMPLATE_REF;
DROP TABLE AO_54C900_CONTENT_BLUEPRINT_AO; 

(warning) If using PostgreSQL database, the table names need to be in between quotation marks

DROP TABLE "AO_54C900_SPACE_BLUEPRINT_AO";
DROP TABLE "AO_54C900_C_TEMPLATE_REF";
DROP TABLE "AO_54C900_CONTENT_BLUEPRINT_AO";

(warning) If using Oracle database, we also need to drop the sequences after dropping the tables:

drop sequence AO_54C900_SPACE_BLU760748750;
drop sequence AO_54C900_C_TEMPLAT776456439;
drop sequence AO_54C900_CONTENT_B2086059265;

3 - Remove the following directories to clear the plugin cache

<confluence-home>/bundled-plugins
<confluence-home>/plugins-cache
<confluence-home>/plugins-osgi-cache
<confluence-home>/plugins-temp
<confluence-home>/bundled-plugins_language

4 - Start Confluence


Last modified on Jul 30, 2019

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.