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

 

5 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
ajardim 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 @ajardim 

Suggest an answer

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

What project did you transition or start on Confluence with the shift to remote work?

It’s been great to hear from fellow users over the last few weeks about the best tips and fun moments you’ve had working on Confluence since the transition to working remote. I’d love to keep the c...

159 views 3 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