Unknown server error when trying to create a space

steven qent September 29, 2018

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?

Screen Shot 2018-09-29 at 11.09.33 PM.png

 

6 answers

1 accepted

11 votes
Answer accepted
Julian Rdnz November 12, 2018

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 November 13, 2018

Perfect work! Thank you!

Petr Musil
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 20, 2018

Hi Julian,

confirmed that your resolution works as a charm. 

Thank you for your great work ;)

Fadoua
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 15, 2018

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

roman
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 22, 2019

@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.

Like John Johnston likes this
Julian Rdnz January 22, 2019

Done!

Like John Johnston likes this
Irvin Yip (Gmail)
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 26, 2019

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

Thanks Julian!

Lucas Rodrigues de Oliveira
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 27, 2019

Super! 

It's work for me!

John Johnston
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 23, 2019

Julian,

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

1 vote
Edgar Dicimulacion
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 5, 2020

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 April 26, 2023

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.

1 vote
Michael Mendez
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 31, 2018

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.

0 votes
Artur J
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 7, 2019

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.

Fadoua
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 8, 2019

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

0 votes
Fadoua
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 17, 2018
0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 30, 2018

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 September 30, 2018

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-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 30, 2018

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 September 30, 2018

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-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 30, 2018

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 October 3, 2018

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

Like Sheng Zhang likes this
steven qent October 3, 2018

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

Evgeny Gryaznov October 4, 2018

Elton, what DB are you use?

steven qent October 4, 2018

Postgres 

Adis October 12, 2018

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 October 12, 2018

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

Christian Muschiol
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 25, 2018

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 26, 2018

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 October 26, 2018

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 November 6, 2018

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

Fadoua
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 15, 2018

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.

Like Adis likes this
Fadoua
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 17, 2018

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!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events