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

Confluence add Space fails - An unknown server error has occurred. Edited

Hi, 

i recently installed confluence 6.11.0 on ubuntu and It is running on an ip on Port 8090. 

The Base Url of the system is set to that ip including the Port Number.

When i want to create a space ( i am in confluence-admin group ), i get the popup with the message  "An unknown server error has occurred.".

So i had a look into atlassian-confluence.log and there is no hint, what could have went wrong. Since creating a space is one key function, i really would like to know what to do or where to look for answers.

Confluence is running on mysql database and the driver 5.1.47 is installed.

Where can i get informations, on what error occured and how to fix that problem?

( importing spaces from another confluence instance is working )

 Thanks for any hint, where i can find a solution.

 

Patrick 

4 answers

3 accepted

11 votes
Answer 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:

Backup database or even better the whole system ( VM snapshot / XM backup ). You better try this on your staging / dev system!


Shutdown Confluence


Delete tables:


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

Clean plugin cache: https://confluence.atlassian.com/confkb/how-to-clear-confluence-plugins-cache-297664846.html 

 

Restart Confluence.


Now creating spaces should work again.

Nano Oil I'm New Here Nov 14, 2018

Thanks, Julian, ever so much! That really worked!

Like 1 person likes this

This just worked for me on 6.13.0, thanks!

Confirmed  - works like a charm 6.13.0

This worked for me after upgrading to Confluence 6.13 and was getting the error in the create space dialogue, with no information in the logs except a hibernate error. This was running on a postgress Database 9.6.10

Work! Thanks a lot

Thank you.

Worked for me too!

Saved my day ;-)

0 votes
Answer accepted

Confluence v6.11.0 will supports only the following database server and java.

MySQL 5.6

MySQL 5.7

Java 1.8


You can clarify the supported database platform for running Confluence 6.11.0 from the following page and update it if necessary.

https://confluence.atlassian.com/doc/supported-platforms-207488198.html

 

Location of the log file : <home directory>/logs/atlassian-confluence-log
Logs : open the logs by tail -f atlassian-confluence-log and try to create the space, there you will get the exact error logs related to this space issue. 


Thanks

Yoga

I was wrong with the database . it was running on postgresql and i finally found the issue on that.

So basically there was no installation date set in the database. According to this article here: https://confluence.atlassian.com/confkb/create-page-space-loads-forever-due-to-wst-timezone-set-in-server-installation-date-759989578.html

any invalid date-value will lead to that error there.

I did have <null/> in the corresponding value field

 

select * from bandana where bandanakey like 'confluence.server.installation.date';

so i created a query to update that field to some valid date in the past ( i chose random date )

 

update bandana set bandanavalue = '<date>2018-06-14 12:00:00.123 AWST</date>' where bandanakey = 'confluence.server.installation.date';

 

Hi,
I am facing the same issue, however I cannot access database. 
I did cleaned plugin cache. Is there any other workaround. 
Thank you in advance

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published Thursday in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

185 views 0 11
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you