Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Unknown server error when trying to create a space

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

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.

Perfect work! Thank you!

Hi Julian,

confirmed that your resolution works as a charm. 

Thank you for your great work ;)

Fadoua Community Leader Dec 15, 2018

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

Like John Johnston likes this
Like John Johnston likes this

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

Thanks Julian!

Super! 

It's work for me!

Julian,

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

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

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.

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

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.

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.

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

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

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

Elton, what DB are you use?

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

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

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 

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?

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

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 Dec 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 Zuul likes this
Fadoua Community Leader Dec 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!

0 votes
Artur J Atlassian Team Jun 07, 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.

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

0 votes

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

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

342 views 23 8
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you