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

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

Unable to finish installer on ubuntu 20.04 (7.4.5/7.51/7.8.1 + PostgreSQL 10/12/13)

I am trying to install confluence on my ubuntu 20.04 server, the very same way I already did a couple of months ago on my ubuntu 18.04 server.

This time, however, I can't seem to get past the database setup in the wizard. Every time it crashes with a HTTP-500 and a screen full of stack traces. The top of the error messages look like this:

 

HTTP Status 500 – Internal Server Error


Type Exception Report

Message Error creating bean with name 'tenantedTransactionManager' defined in class path resource [databaseSubsystemContext.xml]: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantedLocalSessionFactoryBean5' defined in class path resource [productionDatabaseContext.xml]: Bean instantiation via constructor failed; nested exception is java.lang.NoClassDefFoundError: Could not initialize class com.atlassian.confluence.impl.hibernate.ConfluenceLocalSessionFactoryBean

Beschreibung The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantedTransactionManager' defined in class path resource [databaseSubsystemContext.xml]: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantedLocalSessionFactoryBean5' defined in class path resource [productionDatabaseContext.xml]: Bean instantiation via constructor failed; nested exception is java.lang.NoClassDefFoundError: Could not initialize class com.atlassian.confluence.impl.hibernate.ConfluenceLocalSessionFactoryBean
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1771)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
	org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
	org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
	org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
	org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)

Which does not help me at all tracking down the issue.

In the postgres log I can also see:

2020-10-25 16:31:42.719 CET [206067] LOG: database system is ready to accept connections
2020-10-25 16:34:44.663 CET [206368] confluence@confluence ERROR: relation "attachments" does not exist at character 22
2020-10-25 16:34:44.663 CET [206368] confluence@confluence STATEMENT: select count(*) from ATTACHMENTS
2020-10-25 16:34:44.675 CET [206368] confluence@confluence ERROR: relation "bodycontent" does not exist at character 22
2020-10-25 16:34:44.675 CET [206368] confluence@confluence STATEMENT: select count(*) from BODYCONTENT
2020-10-25 16:34:44.675 CET [206368] confluence@confluence ERROR: relation "content" does not exist at character 22
2020-10-25 16:34:44.675 CET [206368] confluence@confluence STATEMENT: select count(*) from CONTENT
2020-10-25 16:34:44.676 CET [206368] confluence@confluence ERROR: relation "cwd_application" does not exist at character 22
2020-10-25 16:34:44.676 CET [206368] confluence@confluence STATEMENT: select count(*) from cwd_application
2020-10-25 16:34:44.678 CET [206368] confluence@confluence ERROR: relation "cwd_directory" does not exist at character 22
2020-10-25 16:34:44.678 CET [206368] confluence@confluence STATEMENT: select count(*) from cwd_directory
2020-10-25 16:34:44.679 CET [206368] confluence@confluence ERROR: relation "cwd_group" does not exist at character 22
2020-10-25 16:34:44.679 CET [206368] confluence@confluence STATEMENT: select count(*) from cwd_group
2020-10-25 16:34:44.679 CET [206368] confluence@confluence ERROR: relation "cwd_user" does not exist at character 22
2020-10-25 16:34:44.679 CET [206368] confluence@confluence STATEMENT: select count(*) from cwd_user
2020-10-25 16:34:44.680 CET [206368] confluence@confluence ERROR: relation "links" does not exist at character 22
2020-10-25 16:34:44.680 CET [206368] confluence@confluence STATEMENT: select count(*) from LINKS
2020-10-25 16:34:44.681 CET [206368] confluence@confluence ERROR: relation "notifications" does not exist at character 22
2020-10-25 16:34:44.681 CET [206368] confluence@confluence STATEMENT: select count(*) from NOTIFICATIONS
2020-10-25 16:34:44.682 CET [206368] confluence@confluence ERROR: relation "os_propertyentry" does not exist at character 22
2020-10-25 16:34:44.682 CET [206368] confluence@confluence STATEMENT: select count(*) from OS_PROPERTYENTRY
2020-10-25 16:34:44.683 CET [206368] confluence@confluence ERROR: relation "pagetemplates" does not exist at character 22
2020-10-25 16:34:44.683 CET [206368] confluence@confluence STATEMENT: select count(*) from PAGETEMPLATES
2020-10-25 16:34:44.684 CET [206368] confluence@confluence ERROR: relation "spacepermissions" does not exist at character 22
2020-10-25 16:34:44.684 CET [206368] confluence@confluence STATEMENT: select count(*) from SPACEPERMISSIONS
2020-10-25 16:34:44.685 CET [206368] confluence@confluence ERROR: relation "spaces" does not exist at character 22
2020-10-25 16:34:44.685 CET [206368] confluence@confluence STATEMENT: select count(*) from SPACES

 

Now, I have tried several combinations of:

  1. confluence 7.4.5, confluence 7.5.1 and confluence 7.8.1 (with 7.5.1 beeing the version which is running fine on my other server
  2. postgres 10, postgres 12, postgres 13
  3. use "simple" database setup & connection string

With each iteration:

  • wiping /var/atlassian (confluence home)
  • wiping /opt/atliassian (confluence installation directory)

 

Yet the result is always the same. The installer accepts the licence, I enter the database credentials, and after a while, I get the error above.

So this leaves me unable to complete the setup. I would be happy if someone could help me resolve this.

2 answers

you will have to logon to the db 

 

psql -d wikidb 

create the tables 

then create table table1();

0 votes
Diego Atlassian Team Oct 26, 2020

Hello @Patrick Fial !
As I understand, setting up Confluence is not working as intended.

With the details you gave us, I can start to make some recommendations. Here we go:

  1. Confluence 7.8 supports only two versions of PostgreSQL – 9.6 and 10. Try to install Confluence only when paired with one of those versions.
  2. You need to make sure to drop the database created for the previous attempt at starting Confluence before trying again (if you intend to use the same name for the database as before).
  3. You need to check if the user used to connect Confluence to the database has enough permissions on the database.

Here we have some documentation:

Let us hear from you!

Hi, thanks for the feedback. Regarding your tips:

 

1) As stated in the initial post, I have tried with a postgresql 10 database

2) I have dropped the database with each new attempt

3) The user/db was created like this:

postgres@myhost:~$ createuser --interactive
Enter name of role to add: confluence
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) n
postgres@myhost:~$ createdb -O confluence confluence
postgres@myhost:~$

Afterwards I have set the password for user `confluence`.

Is there any additional postgresql settings necessary?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.8.1
TAGS
Community showcase
Published in Confluence

Confluence Mythbusters: Does Atlassian even use Confluence?

Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...

1,437 views 7 29
Read article

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