nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

unknown

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

Accepted answers

Yoga Reddy {Appfire}

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

unknown

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';

Julian Rdnz

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.

All comments

Yoga Reddy {Appfire}

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

Thanks

Yoga

unknown

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

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';

Julian Rdnz

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

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

Michal Kusinski

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

Holly Marsh

This just worked for me on 6.13.0, thanks!

Hank42

Confirmed - works like a charm 6.13.0

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server