Unknown server error when trying to create a space

[steven qent]

After updating to 6.11.2, I get the below error when i try to create a space. 

I dont see any stack trace in the logs even after setting the logging type to 'diagnostic'. 

Any ideas?

[Julian Rdnz · Accepted solution]

Hi,

the same problem occurred on my Confluence instance after updating to 6.12.1. It seems to be caused by corrupted data in some template tables.

Solution:

1. Backup database or even better the whole system ( VM snapshot / XM backup ). You better try this on your staging / dev system!
2. Shutdown Confluence
3. Delete tables:

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

1. Clean plugin cache.
2. Restart Confluence.

Now creating spaces should work again.

[Evgeny Gryaznov]

Perfect work! Thank you!

[Petr Musil]

Hi Julian,

confirmed that your resolution works as a charm. 

Thank you for your great work ;)

[Tinker Fadoua]

@Julian Rdnz it worked. Thank you so much for sharing!

[roman]

@Julian Rdnz , could you please fix the broken link in step 4? It should lead to https://confluence.atlassian.com/confkb/how-to-clear-confluence-plugins-cache-297664846.html.

Roman.

[Julian Rdnz]

Done!

[Adis]

They created a seperate KB article:
https://confluence.atlassian.com/confkb/creating-new-page-or-space-loads-forever-744329880.html

[Irvin Yip (Gmail)]

Mine got this error after upgrade from 6.6 to 6.15.1. This fix works!!

Thanks Julian!

[Lucas Rodrigues de Oliveira]

Super! 

It's work for me!

[John Johnston]

Julian,

Thank, you, thank you, thank you!  Awesome.  Worked perfectly.

[Edgar Dicimulacion]

Hi, i would like to share this resolution to anyone who might need this.

I've upgraded Confluence version 6 to the latest which is 7.5.1 but after the update I can't create new spaces. I followed the suggestions above about dropping tables but it was no avail...

I spend 2 days trying to figure this out and what helped me is this resolution:
https://confluence.atlassian.com/confkb/create-page-space-loads-forever-due-to-wst-timezone-set-in-server-installation-date-759989578.html?_ga=2.72181782.448273411.1593857204-1040913564.1593857204

Thank God, this worked like a charm! After many trials I've never known that the problem only is with the installation date. :D

[JWCho]

Thank you! This saved my day.

Little different situation but our Confluence database got migrated from MySQL to Postgres.

After migration, I'm not able to create a new space.

But I found out that our system installation date showed null.

[Michael Mendez]

Same issue here. Confluence 6.12.0, Postgres 9.6, disabled collaborative editing to get page create/edit working again, but still cannot create a space using UI features. The direct link Evgeny describes works for us.

[Artur J]

To anyone reading this thread, it's actually a bug: https://jira.atlassian.com/browse/CONFSERVER-57943 Fortunately, it's already fixed on versions 6.15.3, 6.13.5, 6.15.4 so we recommend upgrading to such versions or later.

[Tinker Fadoua]

We are facing this issue after upgrading to 6.15.2. Just did the upgrade last week in Production @Artur J 

[Tinker Fadoua]

Atlassian Engineer shared the following: https://confluence.atlassian.com/confkb/creating-new-page-or-space-loads-forever-744329880.html

Thank you @Andy Heinzer!

[Nic Brough -Adaptavist-]

The logs will have caught some form of error at this point, you will need to read them to find out what the problem is.

[steven qent]

Thanks for replying nic.

I attempted to create a space  3 times and i have 3 distinct logs for each attempt. No crash logs like i mentioned before.

2018-09-30 10:20:08,813 WARN [http-nio2-8081-exec-54] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:

  ->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #227939952)

 -- referer: https://CONFLUENCE_URL/confluence/spacedirectory/view.action | url: /confluence/rest/create-dialog/1.0/space-blueprint/dialog/web-items | traceId: 6a7051aef2c5be75 | userName: CONFLUENCE_USER

2018-09-30 10:20:11,512 WARN [http-nio2-8081-exec-52] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:

  ->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1631217962)

 -- referer: https://CONFLUENCE_URL/confluence/spacedirectory/view.action | url: /confluence/rest/create-dialog/1.0/space-blueprint/dialog/web-items | traceId: 34a229cecbb36645 | userName: CONFLUENCE_USER

2018-09-30 10:20:13,932 WARN [http-nio2-8081-exec-49] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:

  ->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #1599606007)

 -- referer: https://CONFLUENCE_URL/confluence/spacedirectory/view.action | url: /confluence/rest/create-dialog/1.0/space-blueprint/dialog/web-items | traceId: 174ff0fc175b2f0d | userName: CONFLUENCE_USER

[Nic Brough -Adaptavist-]

That looks to me like you have your database set up incorrectly.

The application logs should have full related errors (stop looking for "crashes", you need to see the warnings and errors) that can confirm that.

[steven qent]

I have no trouble with the other functionality (that i would imagine is DB related). I dont see anything *in the logs* related to this action.

[Nic Brough -Adaptavist-]

The messages you have given us suggest that the database is set up incorrectly.  I can't tell you much more than that without the other errors.

You might want to make all the checks described in https://confluence.atlassian.com/confkb/unable-to-edit-any-pages-in-confluence-6-x-due-to-collaborative-editing-867362716.html and https://confluence.atlassian.com/confkb/unable-to-create-pages-the-create-page-popup-loads-forever-after-confluence-upgrade-to-5-x-330793034.html

[Evgeny Gryaznov]

I have the exactly same issue! I'm using MS SQL and direct link like "/confluence/spaces/createspace-start.action?src=spacemenu" works.

[steven qent]

The direct link did the trick. Thank you so much!

[Evgeny Gryaznov]

Elton, what DB are you use?

[steven qent]

Postgres 

[Adis]

Hi,
we have the same situation here with mysql 5.6.33, after upgrading to 6.11.2. The link you provided is usefull, but how can we track down the problem? The application-logs have not much output regarding this issue...

[Evgeny Gryaznov]

hi! Unfortunately, our company policy didn't allow sending logs to Atlassian. So, a can't rise a bug so easy.

[Christian Muschiol]

Same here after Update to 6.12.1.

2018-10-25 15:52:55,682 WARN [http-nio-8090-exec-6] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
  ->[PluginReadWriteTx]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT (Session #818850729)
 -- referer: http://10.0.1.5:8090/spacedirectory/view.action | url: /rest/create-dialog/1.0/space-blueprint/dialog/web-items | traceId: 320c267c9e876167 | userName: myusername

Creation of spaces not possible. Every other action is fine.

Using mysql 5.7.24-0ubuntu0.16.04.1 

[Petr Musil]

Same problem in our company Confluence, No errors in log. Followed steps on atlass doc with synchrony settings or Apache / Nginx / Tomacat settings, users rights on server etc. Didn't find any problem. 

Confluence 6.11.2

PostgreSQL 9.3.5

Apache Tomcat 9.0.11

Thank you for the direct link. It works fine.

Have anyone created atlass bug?

[Evgeny Gryaznov]

Hi!

Link works, but problem is deeper... Seems like some REST API problems. our developers uses it very extensively and receive many strange errors after upgrade,

Our company policy didn't allow sending logs to Atlassian. So, a can't rise a bug so easy....

[Kai Huegle]

we´ve got the same problem, but could´t find helpful entries in the log file.
We use confluence 6.12.1 and postgres 9.5

[Tinker Fadoua]

It is definitely a bug guys, let me share it with Atlassian Team, will update you if there is a bug ticket opened for it.

[Tinker Fadoua]

Atlassian is aware of it. The engineer helping me is going to look and see if there is an open ticket with Atlassian about the issue so that we can vote and comment. Have a great day!