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

10 votes
Accepted answer

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

0 votes
Accepted answer

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
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

1,439 views 110 8
Join discussion

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